ngg-samp/SQL Files/lockers.sql

/*
 Navicat Premium Data Transfer

 Source Server         : NGG
 Source Server Type    : MySQL
 Source Server Version : 50625
 Source Host           : samp.ng-gaming.net
 Source Database       : samp_beta

 Target Server Type    : MySQL
 Target Server Version : 50625
 File Encoding         : utf-8

 Date: 08/11/2015 11:03:57 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `lockers`
-- ----------------------------
DROP TABLE IF EXISTS `lockers`;
CREATE TABLE `lockers` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Group_ID` int(11) NOT NULL DEFAULT '-1',
  `Locker_ID` int(11) NOT NULL,
  `LockerX` float NOT NULL DEFAULT '0',
  `LockerY` float NOT NULL DEFAULT '0',
  `LockerZ` float NOT NULL DEFAULT '0',
  `LockerVW` int(11) NOT NULL DEFAULT '0',
  `LockerShare` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `lockers`
-- ----------------------------
BEGIN;
INSERT INTO `lockers` VALUES ('1', '1', '1', '1533.81', '-1680.92', '13.38', '0', '0'), ('2', '1', '2', '-1585.04', '692.96', '13.85', '0', '0'), ('3', '1', '3', '267.94', '199.38', '1090.93', '43265', '0'), ('4', '1', '4', '255.38', '77.19', '1003.64', '7899', '0'), ('5', '1', '5', '266.91', '109.93', '1004.59', '28244', '0'), ('6', '2', '1', '1041.64', '-832.57', '1088.79', '0', '0'), ('7', '2', '2', '2290.8', '1300.38', '10.81', '129', '0'), ('8', '2', '3', '310.48', '-1537.89', '-45.13', '231', '0'), ('9', '2', '4', '-2031.81', '-112.5', '1035.17', '1776', '0'), ('10', '2', '5', '308.63', '-1538.27', '-45.13', '1324123', '0'), ('11', '3', '1', '580.34', '1461.13', '6007.47', '0', '0'), ('12', '3', '2', '594.21', '1483.25', '6000.41', '0', '0'), ('13', '3', '3', '0', '0', '0', '0', '0'), ('14', '3', '4', '0', '0', '0', '123002', '0'), ('15', '3', '5', '0', '0', '0', '6582', '0'), ('16', '4', '1', '0', '0', '0', '0', '0'), ('17', '4', '2', '0', '0', '0', '0', '0'), ('18', '4', '3', '0', '0', '0', '11', '0'), ('19', '4', '4', '0', '0', '0', '2112', '0'), ('20', '4', '5', '0', '0', '0', '0', '0'), ('21', '5', '1', '-2031.31', '-114.83', '1035.17', '101489', '0'), ('22', '5', '2', '0', '0', '0', '0', '0'), ('23', '5', '3', '0', '0', '0', '0', '0'), ('24', '5', '4', '0', '0', '0', '0', '0'), ('25', '5', '5', '0', '0', '0', '0', '0'), ('26', '6', '1', '354.35', '173.77', '1008.38', '20041', '0'), ('27', '6', '2', '1112.75', '-2055.37', '1410.3', '2345', '0'), ('28', '6', '3', '354.89', '173.85', '1008.38', '20167', '0'), ('29', '6', '4', '1059.63', '-2120.62', '1534.26', '2345', '0'), ('30', '6', '5', '836.28', '-2009.93', '1472.88', '2345', '0'), ('31', '7', '1', '0', '0', '0', '0', '0'), ('32', '7', '2', '2290.37', '1300.39', '10.81', '1969', '0'), ('33', '7', '3', '665.26', '-1588.05', '3223.12', '123925', '0'), ('34', '7', '4', '1492.68', '1308.18', '1093.29', '420', '0'), ('35', '7', '5', '2736.87', '-1782.18', '12011.9', '6203', '0'), ('36', '8', '1', '0', '0', '0', '0', '0'), ('37', '8', '2', '0', '0', '0', '0', '0'), ('38', '8', '3', '0', '0', '0', '0', '0'), ('39', '8', '4', '0', '0', '0', '0', '0'), ('40', '8', '5', '0', '0', '0', '0', '0'), ('41', '9', '1', '0', '0', '0', '1234', '0'), ('42', '9', '2', '0', '0', '0', '16969', '0'), ('43', '9', '3', '0', '0', '0', '0', '0'), ('44', '9', '4', '0', '0', '0', '0', '0'), ('45', '9', '5', '0', '0', '0', '976943684', '0'), ('46', '10', '1', '0', '0', '0', '14', '0'), ('47', '10', '2', '0', '0', '0', '6036', '0'), ('48', '10', '3', '0', '0', '0', '11119999', '0'), ('49', '10', '4', '0', '0', '0', '565436', '0'), ('50', '10', '5', '0', '0', '0', '4', '0'), ('51', '11', '1', '0', '0', '0', '99', '0'), ('52', '11', '2', '0', '0', '0', '861', '0'), ('53', '11', '3', '0', '0', '0', '573', '0'), ('54', '11', '4', '0', '0', '0', '8097', '0'), ('55', '11', '5', '0', '0', '0', '1334', '0'), ('56', '12', '1', '332.64', '2344.29', '8905.41', '0', '0'), ('57', '12', '2', '-1686.26', '-2373.62', '10294.7', '123983', '0'), ('58', '12', '3', '413.13', '2537.81', '19.12', '0', '0'), ('59', '12', '4', '354.35', '173.91', '1008.38', '420', '0'), ('60', '12', '5', '-1339.56', '488.95', '11.18', '0', '0'), ('61', '13', '1', '620.45', '-8.38', '1102.76', '4225', '0'), ('62', '13', '2', '255.38', '77.04', '1003.64', '956', '0'), ('63', '13', '3', '629.4', '10.31', '1107.93', '0', '0'), ('64', '13', '4', '-2160.12', '646.44', '1057.56', '473843', '0'), ('65', '13', '5', '0', '0', '0', '0', '0'), ('66', '14', '1', '0', '0', '0', '30034', '0'), ('67', '14', '2', '0', '0', '0', '233600', '0'), ('68', '14', '3', '0', '0', '0', '8303', '0'), ('69', '14', '4', '0', '0', '0', '0', '0'), ('70', '14', '5', '0', '0', '0', '0', '0'), ('71', '15', '1', '1361.17', '-1828.68', '7522.33', '2230', '0'), ('72', '15', '2', '2223.37', '-1042.93', '1200.43', '0', '0'), ('73', '15', '3', '1374.78', '-1786.06', '7326', '92', '0'), ('74', '15', '4', '1374.43', '-1786.17', '7326', '93', '0'), ('75', '15', '5', '1411.18', '-1773.79', '7308.95', '10665', '0'), ('76', '16', '1', '0', '0', '0', '81699', '0'), ('77', '16', '2', '0', '0', '0', '2112', '0'), ('78', '16', '3', '0', '0', '0', '0', '0'), ('79', '16', '4', '0', '0', '0', '3165', '0'), ('80', '16', '5', '0', '0', '0', '0', '0'), ('81', '17', '1', '2382.75', '2652.12', '8001.14', '0', '0'), ('82', '17', '2', '1302.8', '-2586.83', '13.97', '0', '0'), ('83', '17', '3', '1188.89', '-1351.41', '2423.26', '11119999', '0'), ('84', '17', '4', '295.39', '-1379.29', '14.02', '0', '0'), ('85', '17', '5', '1856.06', '-1795.18', '17.45', '0', '0'), ('86', '18', '1', '331.75', '2342.76', '8905.41', '10935', '0'), ('87', '18', '2', '0', '0', '0', '0', '0'), ('88', '18', '3', '0', '0', '0', '0', '0'), ('89', '18', '4', '-219.83', '1406.16', '27.77', '374', '0'), ('90', '18', '5', '-2031.31', '-114.69', '1035.17', '0', '0'), ('91', '19', '1', '272.63', '199.66', '1099.18', '81699', '0'), ('92', '19', '2', '275.17', '161.71', '1099.18', '81699', '0'), ('93', '19', '3', '2613.12', '-2167.8', '-0.2', '0', '0'), ('94', '19', '4', '362.7', '58.75', '647.65', '123102', '0'), ('95', '19', '5', '1781.18', '-1296.38', '98.5', '0', '0'), ('96', '20', '1', '0', '0', '0', '0', '0'), ('97', '20', '2', '0', '0', '0', '0', '0'), ('98', '20', '3', '0', '0', '0', '0', '0'), ('99', '20', '4', '0', '0', '0', '0', '0'), ('100', '20', '5', '0', '0', '0', '0', '0'), ('101', '21', '1', '0', '0', '0', '0', '0'), ('102', '21', '2', '0', '0', '0', '0', '0'), ('103', '21', '3', '0', '0', '0', '0', '0'), ('104', '21', '4', '0', '0', '0', '0', '0'), ('105', '21', '5', '0', '0', '0', '0', '0'), ('106', '22', '1', '1530.64', '-1666.84', '13.38', '0', '0'), ('107', '22', '2', '1230.77', '-807.15', '1084', '200142', '0'), ('108', '22', '3', '754.08', '-40.81', '1000.59', '2870', '0'), ('109', '22', '4', '0', '0', '0', '404', '0'), ('110', '22', '5', '0', '0', '0', '0', '0'), ('111', '23', '1', '28.67', '-48.97', '4090.34', '123064', '0'), ('112', '23', '2', '1528.93', '-1665.68', '13.38', '0', '0'), ('113', '23', '3', '0', '0', '0', '0', '0'), ('114', '23', '4', '0', '0', '0', '0', '0'), ('115', '23', '5', '0', '0', '0', '0', '0'), ('116', '24', '1', '0', '0', '0', '0', '0'), ('117', '24', '2', '0', '0', '0', '0', '0'), ('118', '24', '3', '0', '0', '0', '0', '0'), ('119', '24', '4', '0', '0', '0', '0', '0'), ('120', '24', '5', '0', '0', '0', '0', '0'), ('121', '25', '1', '1844.45', '-1309.76', '-29.55', '123944', '0'), ('122', '25', '2', '0', '0', '0', '123911', '0'), ('123', '25', '3', '0', '0', '0', '2907', '0'), ('124', '25', '4', '0', '0', '0', '0', '0'), ('125', '25', '5', '0', '0', '0', '0', '0'), ('126', '26', '1', '0', '0', '0', '0', '0'), ('127', '26', '2', '0', '0', '0', '0', '0'), ('128', '26', '3', '0', '0', '0', '0', '0'), ('129', '26', '4', '0', '0', '0', '0', '0'), ('130', '26', '5', '0', '0', '0', '0', '0'), ('131', '27', '1', '174.13', '1350.81', '971.2', '638', '0'), ('132', '27', '2', '0', '0', '0', '0', '0'), ('133', '27', '3', '0', '0', '0', '0', '0'), ('134', '27', '4', '0', '0', '0', '0', '0'), ('135', '27', '5', '0', '0', '0', '0', '0'), ('136', '28', '1', '-567.63', '457.97', '1407.06', '123034', '0'), ('137', '28', '2', '0', '0', '0', '0', '0'), ('138', '28', '3', '0', '0', '0', '0', '0'), ('139', '28', '4', '0', '0', '0', '0', '0'), ('140', '28', '5', '0', '0', '0', '0', '0'), ('141', '29', '1', '1867.18', '-1155.81', '1400.68', '8702', '0'), ('142', '29', '2', '0', '0', '0', '0', '0'), ('143', '29', '3', '0', '0', '0', '0', '0'), ('144', '29', '4', '0', '0', '0', '0', '0'), ('145', '29', '5', '0', '0', '0', '0', '0'), ('146', '30', '1', '0', '0', '0', '0', '0'), ('147', '30', '2', '0', '0', '0', '0', '0'), ('148', '30', '3', '0', '0', '0', '0', '0'), ('149', '30', '4', '0', '0', '0', '0', '0'), ('150', '30', '5', '0', '0', '0', '0', '0'), ('151', '31', '1', '695.15', '-386.04', '775.09', '1', '0'), ('152', '31', '2', '-710.09', '-2057.37', '17.79', '0', '0'), ('153', '31', '3', '0', '0', '0', '0', '0'), ('154', '31', '4', '-761.94', '2575.36', '10016.7', '1', '0'), ('155', '31', '5', '0', '0', '0', '0', '0'), ('156', '32', '1', '324.01', '1202.9', '5018.39', '123674', '0'), ('157', '32', '2', '309.95', '-131.27', '1004.03', '2993', '0'), ('158', '32', '3', '0', '0', '0', '0', '0'), ('159', '32', '4', '0', '0', '0', '0', '0'), ('160', '32', '5', '0', '0', '0', '0', '0'), ('161', '33', '1', '0', '0', '0', '0', '0'), ('162', '33', '2', '0', '0', '0', '0', '0'), ('163', '33', '3', '0', '0', '0', '0', '0'), ('164', '33', '4', '550.01', '-597.51', '-14.97', '2889', '0'), ('165', '33', '5', '0', '0', '0', '0', '0'), ('166', '34', '1', '0', '0', '0', '0', '0'), ('167', '34', '2', '0', '0', '0', '0', '0'), ('168', '34', '3', '0', '0', '0', '0', '0'), ('169', '34', '4', '0', '0', '0', '0', '0'), ('170', '34', '5', '0', '0', '0', '0', '0'), ('171', '35', '1', '0', '0', '0', '2738', '0'), ('172', '35', '2', '0', '0', '0', '402', '0'), ('173', '35', '3', '0', '0', '0', '0', '0'), ('174', '35', '4', '0', '0', '0', '3485943', '0'), ('175', '35', '5', '0', '0', '0', '0', '0'), ('176', '36', '1', '0', '0', '0', '0', '0'), ('177', '36', '2', '0', '0', '0', '0', '0'), ('178', '36', '3', '0', '0', '0', '0', '0'), ('179', '36', '4', '0', '0', '0', '0', '0'), ('180', '36', '5', '0', '0', '0', '0', '0'), ('181', '37', '1', '0', '0', '0', '0', '0'), ('182', '37', '2', '0', '0', '0', '0', '0'), ('183', '37', '3', '0', '0', '0', '0', '0'), ('184', '37', '4', '0', '0', '0', '0', '0'), ('185', '37', '5', '0', '0', '0', '0', '0'), ('186', '38', '1', '0', '0', '0', '0', '0'), ('187', '38', '2', '0', '0', '0', '0', '0'), ('188', '38', '3', '0', '0', '0', '0', '0'), ('189', '38', '4', '0', '0', '0', '0', '0'), ('190', '38', '5', '0', '0', '0', '0', '0'), ('191', '39', '1', '0', '0', '0', '0', '0'), ('192', '39', '2', '0', '0', '0', '0', '0'), ('193', '39', '3', '0', '0', '0', '0', '0'), ('194', '39', '4', '0', '0', '0', '0', '0'), ('195', '39', '5', '0', '0', '0', '0', '0'), ('196', '40', '1', '0', '0', '0', '0', '0'), ('197', '40', '2', '0', '0', '0', '0', '0'), ('198', '40', '3', '0', '0', '0', '0', '0'), ('199', '40', '4', '0', '0', '0', '0', '0'), ('200', '40', '5', '0', '0', '0', '0', '0'), ('201', '2', '6', '2492.3', '-1710.43', '1018.34', '1777', '0'), ('202', '2', '7', '1158.31', '1965.43', '14906.7', '123016', '0'), ('203', '2', '8', '0', '0', '0', '0', '0'), ('204', '2', '9', '0', '0', '0', '0', '0'), ('205', '2', '10', '0', '0', '0', '0', '0'), ('206', '12', '6', '2230.37', '1906.81', '1346.65', '100', '0'), ('207', '12', '7', '0', '0', '0', '0', '0'), ('208', '12', '8', '0', '0', '0', '0', '0'), ('209', '12', '9', '0', '0', '0', '0', '0'), ('210', '12', '10', '0', '0', '0', '84321', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;