This repository was archived by the owner on Mar 4, 2018. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathelevators.sql
62 lines (56 loc) · 3.61 KB
/
elevators.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
/*
Navicat MySQL Data Transfer
Source Server : DarkStar
Source Server Version : 50515
Source Host : localhost:3306
Source Database : dspdb
Target Server Type : MYSQL
Target Server Version : 50515
File Encoding : 65001
Date: 2011-11-21 19:42:21
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `elevators`
-- ----------------------------
DROP TABLE IF EXISTS `elevators`;
CREATE TABLE `elevators` (
`id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(35) NOT NULL,
`elevator` int(10) unsigned NOT NULL DEFAULT '0',
`upperDoor` int(10) unsigned NOT NULL DEFAULT '0',
`lowerDoor` int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
`regime` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=38;
-- ----------------------------
-- Records of elevators
-- ----------------------------
INSERT INTO `elevators` VALUES ('1', 'Pso\'Xja_Elvtr_1', '16814442', '16814443', '16814444', '1', '1');
INSERT INTO `elevators` VALUES ('2', 'Pso\'Xja_Elvtr_2', '16814461', '16814462', '16814463', '1', '1');
INSERT INTO `elevators` VALUES ('3', 'Pso\'Xja_Elvtr_3', '16814464', '16814465', '16814466', '1', '1');
-- INSERT INTO `elevators` VALUES ('4', 'Pso\'Xja_Mvng_Flr_4', '16814466', '16814467', '16814468', '1', '1');
-- INSERT INTO `elevators` VALUES ('5', 'Pso\'Xja_Mvng_Flr_3', '16814470', '16814471', '16814472', '1', '1');
-- INSERT INTO `elevators` VALUES ('6', 'Pso\'Xja_Mvng_Flr_1', '16814473', '16814474', '16814475', '1', '1');
-- INSERT INTO `elevators` VALUES ('7', 'Pso\'Xja_Mvng_Flr_2', '16814476', '16814477', '16814478', '1', '1');
INSERT INTO `elevators` VALUES ('8', 'Pso\'Xja_1', '16814480', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('9', 'Pso\'Xja_2', '16814481', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('10', 'Pso\'Xja_3', '16814482', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('11', 'Pso\'Xja_4', '16814483', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('12', 'Pso\'Xja_5', '16814484', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('13', 'Pso\'Xja_6', '16814485', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('14', 'Pso\'Xja_Elvtr_4', '16814486', '16814487', '16814488', '1', '1');
INSERT INTO `elevators` VALUES ('15', 'Pso\'Xja_Elvtr_5', '16814505', '16814506', '16814507', '1', '1');
INSERT INTO `elevators` VALUES ('16', 'Pso\'Xja_Elvtr_6', '16814508', '16814509', '16814510', '1', '1');
INSERT INTO `elevators` VALUES ('17', 'Pso\'Xja_Elvtr_7', '16814511', '16814512', '16814513', '1', '1');
INSERT INTO `elevators` VALUES ('18', 'Pso\'Xja_Dspprng_Tls_4', '16814516', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('19', 'Pso\'Xja_Dspprng_Tls_1', '16814517', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('20', 'Pso\'Xja_Dspprng_Tls_2', '16814518', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('21', 'Fort_Ghelsba_Elvtr', '17354989', '17354991', '17354990', '0', '0');
INSERT INTO `elevators` VALUES ('22', 'Palborough_Mines_Elvtr', '17363343', '17363337', '17363336', '0', '0');
INSERT INTO `elevators` VALUES ('23', 'Davoi_Elvtr', '17387995', '17387998', '17387996', '0', '0');
INSERT INTO `elevators` VALUES ('24', 'Kuftal_Tunnel_Dspprng_Rck', '17490280', '0', '0', '1', '1');
INSERT INTO `elevators` VALUES ('25', 'Port_Bastok_Drwbrdg', '17743962', '17743963', '17743964', '1', '1');
INSERT INTO `elevators` VALUES ('26', 'Metalworks_Elvtr_1', '17748035', '17748036', '17748037', '1', '1');
INSERT INTO `elevators` VALUES ('27', 'Metalworks_Elvtr_2', '17748038', '17748039', '17748040', '1', '1');