install.sql

我的比赛作品 第22届全国青少年科技创新大赛3等奨 备注: 同时使用VC及Delphi开发

INSERT INTO `bus_route` VALUES (1007, 21, 0, 30, 0, 0);
INSERT INTO `bus_route` VALUES (1008, 21, 0, 31, 0, 0);
INSERT INTO `bus_route` VALUES (1009, 21, 0, 32, 0, 0);
INSERT INTO `bus_route` VALUES (1010, 21, 0, 33, 0, 0);
INSERT INTO `bus_route` VALUES (1011, 22, 0, 1, 0, 0);
INSERT INTO `bus_route` VALUES (1012, 22, 0, 2, 0, 0);
INSERT INTO `bus_route` VALUES (1013, 22, 0, 3, 0, 0);
INSERT INTO `bus_route` VALUES (1014, 22, 0, 4, 0, 0);
INSERT INTO `bus_route` VALUES (1015, 22, 0, 5, 0, 0);
INSERT INTO `bus_route` VALUES (1016, 22, 0, 6, 0, 0);
INSERT INTO `bus_route` VALUES (1017, 22, 0, 7, 0, 0);
INSERT INTO `bus_route` VALUES (1018, 22, 0, 8, 0, 0);
INSERT INTO `bus_route` VALUES (1019, 22, 0, 9, 0, 0);
INSERT INTO `bus_route` VALUES (1020, 22, 0, 10, 0, 0);
INSERT INTO `bus_route` VALUES (1021, 22, 0, 79, 0, 0);
INSERT INTO `bus_route` VALUES (1022, 22, 0, 96, 0, 0);
INSERT INTO `bus_route` VALUES (1023, 22, 0, 97, 0, 0);
INSERT INTO `bus_route` VALUES (1024, 22, 0, 127, 0, 0);
INSERT INTO `bus_route` VALUES (1050, 22, 0, 78, 0, 0);
INSERT INTO `bus_route` VALUES (1051, 22, 0, 24, 0, 0);
INSERT INTO `bus_route` VALUES (1052, 22, 0, 25, 0, 0);
INSERT INTO `bus_route` VALUES (1053, 22, 0, 26, 0, 0);
INSERT INTO `bus_route` VALUES (1054, 22, 0, 27, 0, 0);
INSERT INTO `bus_route` VALUES (1055, 22, 0, 28, 0, 0);
INSERT INTO `bus_route` VALUES (1056, 22, 0, 29, 0, 0);
INSERT INTO `bus_route` VALUES (1057, 22, 0, 30, 0, 0);
INSERT INTO `bus_route` VALUES (1058, 22, 0, 31, 0, 0);
INSERT INTO `bus_route` VALUES (1059, 22, 0, 32, 0, 0);
INSERT INTO `bus_route` VALUES (1060, 22, 0, 33, 0, 0);
INSERT INTO `bus_route` VALUES (1061, 23, 0, 17, 0, 0);
INSERT INTO `bus_route` VALUES (1062, 23, 0, 18, 0, 0);
INSERT INTO `bus_route` VALUES (1063, 23, 0, 19, 0, 0);
INSERT INTO `bus_route` VALUES (1064, 23, 0, 20, 0, 0);
INSERT INTO `bus_route` VALUES (1065, 23, 0, 21, 0, 0);
INSERT INTO `bus_route` VALUES (1066, 23, 0, 22, 0, 0);
INSERT INTO `bus_route` VALUES (1067, 23, 0, 23, 0, 0);
INSERT INTO `bus_route` VALUES (1068, 23, 0, 24, 0, 0);
INSERT INTO `bus_route` VALUES (1069, 23, 0, 25, 0, 0);
INSERT INTO `bus_route` VALUES (1070, 23, 0, 26, 0, 0);
INSERT INTO `bus_route` VALUES (1071, 23, 0, 27, 0, 0);
INSERT INTO `bus_route` VALUES (1072, 23, 0, 28, 0, 0);
INSERT INTO `bus_route` VALUES (1073, 23, 0, 47, 0, 0);
INSERT INTO `bus_route` VALUES (1074, 23, 0, 48, 0, 0);
INSERT INTO `bus_route` VALUES (1075, 23, 0, 3, 0, 0);
INSERT INTO `bus_route` VALUES (1076, 23, 0, 105, 0, 0);
INSERT INTO `bus_route` VALUES (1077, 23, 0, 106, 0, 0);
INSERT INTO `bus_route` VALUES (1078, 23, 0, 127, 0, 0);
INSERT INTO `bus_route` VALUES (1079, 23, 0, 107, 0, 0);
INSERT INTO `bus_route` VALUES (1080, 23, 0, 89, 0, 0);
INSERT INTO `bus_route` VALUES (1081, 23, 0, 67, 0, 0);
INSERT INTO `bus_route` VALUES (1082, 23, 0, 68, 0, 0);
INSERT INTO `bus_route` VALUES (1083, 23, 0, 69, 0, 0);
INSERT INTO `bus_route` VALUES (1084, 23, 0, 70, 0, 0);
INSERT INTO `bus_route` VALUES (1085, 23, 0, 51, 0, 0);
INSERT INTO `bus_route` VALUES (1100, 23, 1, 127, 0, 0);
INSERT INTO `bus_route` VALUES (1115, 23, 1, 110, 0, 0);
INSERT INTO `bus_route` VALUES (1116, 23, 1, 111, 0, 0);
INSERT INTO `bus_route` VALUES (1117, 23, 1, 43, 0, 0);
INSERT INTO `bus_route` VALUES (1118, 23, 1, 44, 0, 0);
INSERT INTO `bus_route` VALUES (1119, 23, 1, 45, 0, 0);
INSERT INTO `bus_route` VALUES (1120, 23, 1, 88, 0, 0);
INSERT INTO `bus_route` VALUES (1121, 23, 1, 119, 0, 0);
INSERT INTO `bus_route` VALUES (1122, 23, 1, 93, 0, 0);
INSERT INTO `bus_route` VALUES (1124, 23, 1, 94, 0, 0);
INSERT INTO `bus_route` VALUES (1125, 23, 1, 95, 0, 0);
INSERT INTO `bus_route` VALUES (1126, 23, 1, 4, 0, 0);
INSERT INTO `bus_route` VALUES (1127, 23, 1, 5, 0, 0);
INSERT INTO `bus_route` VALUES (1128, 23, 1, 6, 0, 0);
INSERT INTO `bus_route` VALUES (1129, 23, 1, 7, 0, 0);
INSERT INTO `bus_route` VALUES (1130, 23, 1, 8, 0, 0);
INSERT INTO `bus_route` VALUES (1131, 23, 1, 9, 0, 0);
INSERT INTO `bus_route` VALUES (1132, 23, 1, 10, 0, 0);
INSERT INTO `bus_route` VALUES (1133, 23, 1, 11, 0, 0);
INSERT INTO `bus_route` VALUES (1134, 23, 1, 12, 0, 0);
INSERT INTO `bus_route` VALUES (1135, 23, 1, 13, 0, 0);
INSERT INTO `bus_route` VALUES (1136, 23, 1, 20, 0, 0);
INSERT INTO `bus_route` VALUES (1137, 23, 1, 15, 0, 0);
INSERT INTO `bus_route` VALUES (1138, 23, 1, 16, 0, 0);
INSERT INTO `bus_route` VALUES (1139, 23, 1, 17, 0, 0);
INSERT INTO `bus_route` VALUES (1140, 24, 0, 127, 0, 0);
INSERT INTO `bus_route` VALUES (1160, 25, 0, 92, 0, 0);
INSERT INTO `bus_route` VALUES (1161, 25, 0, 107, 0, 0);
INSERT INTO `bus_route` VALUES (1162, 25, 0, 89, 0, 0);
INSERT INTO `bus_route` VALUES (1163, 25, 0, 67, 0, 0);
INSERT INTO `bus_route` VALUES (1164, 25, 0, 68, 0, 0);
INSERT INTO `bus_route` VALUES (1165, 25, 0, 69, 0, 0);
INSERT INTO `bus_route` VALUES (1166, 25, 0, 70, 0, 0);
INSERT INTO `bus_route` VALUES (1167, 25, 0, 51, 0, 0);
INSERT INTO `bus_route` VALUES (1168, 25, 0, 52, 0, 0);
INSERT INTO `bus_route` VALUES (1169, 25, 0, 53, 0, 0);
INSERT INTO `bus_route` VALUES (1170, 25, 0, 54, 0, 0);
INSERT INTO `bus_route` VALUES (1171, 25, 0, 127, 0, 0);
INSERT INTO `bus_route` VALUES (1175, 25, 0, 102, 0, 0);
INSERT INTO `bus_route` VALUES (1176, 25, 0, 103, 0, 0);
INSERT INTO `bus_route` VALUES (1194, 25, 1, 127, 0, 0);
INSERT INTO `bus_route` VALUES (1210, 25, 1, 98, 0, 0);
INSERT INTO `bus_route` VALUES (1211, 25, 1, 99, 0, 0);
INSERT INTO `bus_route` VALUES (1212, 25, 1, 100, 0, 0);
INSERT INTO `bus_route` VALUES (1213, 25, 1, 61, 0, 0);
INSERT INTO `bus_route` VALUES (1217, 25, 1, 54, 0, 0);
INSERT INTO `bus_route` VALUES (1218, 25, 1, 55, 0, 0);
INSERT INTO `bus_route` VALUES (1220, 25, 1, 40, 0, 0);
INSERT INTO `bus_route` VALUES (1221, 25, 1, 41, 0, 0);
INSERT INTO `bus_route` VALUES (1222, 25, 1, 42, 0, 0);
INSERT INTO `bus_route` VALUES (1223, 25, 1, 43, 0, 0);
INSERT INTO `bus_route` VALUES (1225, 25, 1, 45, 0, 0);
INSERT INTO `bus_route` VALUES (1226, 25, 1, 46, 0, 0);
INSERT INTO `bus_route` VALUES (1227, 25, 1, 105, 0, 0);
INSERT INTO `bus_route` VALUES (1228, 25, 1, 106, 0, 0);
INSERT INTO `bus_route` VALUES (1229, 25, 1, 92, 0, 0);

-- --------------------------------------------------------

-- 
-- 表的结构 `bus_station`
-- 

CREATE TABLE `bus_station` (
  `station` tinyint(4) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `area` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`station`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=128 ;

-- 
-- 导出表中的数据 `bus_station`
-- 

INSERT INTO `bus_station` VALUES (1, '筷子基总站', '筷子基区');
INSERT INTO `bus_station` VALUES (2, '青洲/逸丽花园', '青洲区');
INSERT INTO `bus_station` VALUES (3, '台山街市', '台山区');
INSERT INTO `bus_station` VALUES (4, '市政狗房', '望厦区');
INSERT INTO `bus_station` VALUES (5, '红街市', '高士德区');
INSERT INTO `bus_station` VALUES (6, '中星花园', '沙梨头区');
INSERT INTO `bus_station` VALUES (7, '土地庙前地', '沙梨头区');
INSERT INTO `bus_station` VALUES (8, '水上街市/中银', '沙梨头区');
INSERT INTO `bus_station` VALUES (9, '海边新街', '沙梨头区');
INSERT INTO `bus_station` VALUES (10, '柏港停车场', '沙梨头区');
INSERT INTO `bus_station` VALUES (11, '粤通码头', '中区');
INSERT INTO `bus_station` VALUES (12, '司打口', '下环区');
INSERT INTO `bus_station` VALUES (13, '河边新街/街市', '下环区');
INSERT INTO `bus_station` VALUES (14, '下环/沙井天巷', '下环区');
INSERT INTO `bus_station` VALUES (15, '河边新街/下环', '下环区');
INSERT INTO `bus_station` VALUES (16, '妈阁庙', '下环区');
INSERT INTO `bus_station` VALUES (17, '妈阁总站', '下环区');
INSERT INTO `bus_station` VALUES (18, '妈阁庙前地', '下环区');
INSERT INTO `bus_station` VALUES (19, '河边新街/妈阁', '下环区');
INSERT INTO `bus_station` VALUES (20, '河边新街/小贩巷', '下环区');
INSERT INTO `bus_station` VALUES (21, '下环/李加禄街', '下环区');
INSERT INTO `bus_station` VALUES (22, '司打口/李道巷', '下环区');
INSERT INTO `bus_station` VALUES (23, '火船头街', '中区');
INSERT INTO `bus_station` VALUES (24, '内港/停车场', '沙梨头区');
INSERT INTO `bus_station` VALUES (25, '沙梨头', '沙梨头区');
INSERT INTO `bus_station` VALUES (26, '水上街市', '沙梨头区');
INSERT INTO `bus_station` VALUES (27, '沙梨头海边街', '沙梨头区');
INSERT INTO `bus_station` VALUES (28, '提督/红街市', '高士德区');
INSERT INTO `bus_station` VALUES (29, '莲峰游泳池', '望厦区');
INSERT INTO `bus_station` VALUES (30, '莲峰庙', '望厦区');
INSERT INTO `bus_station` VALUES (31, '第二警司处', '台山区');
INSERT INTO `bus_station` VALUES (32, '白朗古/跑狗场', '筷子基区');
INSERT INTO `bus_station` VALUES (33, '筷子基北街', '筷子基区');
INSERT INTO `bus_station` VALUES (34, '新口岸/科英布拉街总站', '新口岸区');
INSERT INTO `bus_station` VALUES (35, '新口岸/皇朝广场', '新口岸区');
INSERT INTO `bus_station` VALUES (36, '高美士/百汇广场', '新口岸区');
INSERT INTO `bus_station` VALUES (37, '澳门理工学院', '新口岸区');
INSERT INTO `bus_station` VALUES (38, '综艺馆', '新口岸区');
INSERT INTO `bus_station` VALUES (39, '出入境事务局', '新口岸区');
INSERT INTO `bus_station` VALUES (40, '水塘北角', '新口岸区');
INSERT INTO `bus_station` VALUES (41, '渔翁街', '黑沙环新区');
INSERT INTO `bus_station` VALUES (42, '慕拉士/发电厂', '望厦区');
INSERT INTO `bus_station` VALUES (43, '八达新村', '望厦区');
INSERT INTO `bus_station` VALUES (44, '慕拉士马路/望厦', '望厦区');
INSERT INTO `bus_station` VALUES (45, '黑沙环马路', '望厦区');
INSERT INTO `bus_station` VALUES (46, '拱形马路/莲峰庙', '望厦区');
INSERT INTO `bus_station` VALUES (47, '提督马路/白朗古', '高士德区');
INSERT INTO `bus_station` VALUES (48, '白朗古/中银', '筷子基区');
INSERT INTO `bus_station` VALUES (49, '拱形马路', '望厦区');
INSERT INTO `bus_station` VALUES (50, '慕拉士大马路', '黑沙环新区');
INSERT INTO `bus_station` VALUES (51, '慕拉士巷', '黑沙环新区');
INSERT INTO `bus_station` VALUES (52, '慕拉士/飞通大厦', '黑沙环新区');
INSERT INTO `bus_station` VALUES (53, '渔翁街/水塘', '黑沙环新区');
INSERT INTO `bus_station` VALUES (54, '外港码头', '新口岸区');
INSERT INTO `bus_station` VALUES (55, '友谊马路/行车天桥', '新口岸区');
INSERT INTO `bus_station` VALUES (56, '新八佰伴', '新口岸区');
INSERT INTO `bus_station` VALUES (57, '马六甲街', '新口岸区');
INSERT INTO `bus_station` VALUES (58, '旅游活动中心', '新口岸区');
INSERT INTO `bus_station` VALUES (59, '金域酒店', '新口岸区');
INSERT INTO `bus_station` VALUES (60, '高美士/南园大厦', '新口岸区');
INSERT INTO `bus_station` VALUES (61, '宋玉生博士广场', '新口岸区');
INSERT INTO `bus_station` VALUES (62, '新口岸/罗马街', '新口岸区');
INSERT INTO `bus_station` VALUES (63, '新口岸/伦敦街', '新口岸区');
INSERT INTO `bus_station` VALUES (64, '新口岸/柏嘉街', '新口岸区');
INSERT INTO `bus_station` VALUES (65, '顺景广场总站', '佑汉区');
INSERT INTO `bus_station` VALUES (66, '翡翠广场', '佑汉区');
INSERT INTO `bus_station` VALUES (67, '佑汉街市', '佑汉区');
INSERT INTO `bus_station` VALUES (68, '佑汉公园', '佑汉区');
INSERT INTO `bus_station` VALUES (69, '永康街/丽华', '佑汉区');
INSERT INTO `bus_station` VALUES (70, '黑沙环第五街', '黑沙环区');
INSERT INTO `bus_station` VALUES (71, '新雅马路', '望厦区');
INSERT INTO `bus_station` VALUES (72, '二龙喉公园', '荷兰园区');
INSERT INTO `bus_station` VALUES (73, '得胜花园', '荷兰园区');
INSERT INTO `bus_station` VALUES (74, '爱都酒店', '荷兰园区');
INSERT INTO `bus_station` VALUES (75, '公共行政大楼', '中区');
INSERT INTO `bus_station` VALUES (76, '约翰四世大马路', '中区');
INSERT INTO `bus_station` VALUES (77, '中区/殷皇子马路', '中区');
INSERT INTO `bus_station` VALUES (78, '新马路', '中区');
INSERT INTO `bus_station` VALUES (79, '新马路/营地大街', '中区');
INSERT INTO `bus_station` VALUES (80, '南湾大马路/时代', '中区');
INSERT INTO `bus_station` VALUES (81, '水坑尾街', '中区');
INSERT INTO `bus_station` VALUES (82, '塔石/卫生中心', '荷兰园区');
INSERT INTO `bus_station` VALUES (83, '卢廉若公园', '荷兰园区');
INSERT INTO `bus_station` VALUES (84, '荷兰花园', '荷兰园区');
INSERT INTO `bus_station` VALUES (85, '荷兰园/柏蕙', '荷兰园区');
INSERT INTO `bus_station` VALUES (86, '鲍斯高球场', '望厦区');
INSERT INTO `bus_station` VALUES (87, '电力公司', '望厦区');
INSERT INTO `bus_station` VALUES (88, '佑汉第二街', '佑汉区');
INSERT INTO `bus_station` VALUES (89, '看台街/中银', '佑汉区');
INSERT INTO `bus_station` VALUES (90, '永宁广场', '黑沙环区');
INSERT INTO `bus_station` VALUES (91, '马场东大马路', '黑沙环区');
INSERT INTO `bus_station` VALUES (92, '关闸总站', '台山区');
INSERT INTO `bus_station` VALUES (93, '柏丽停车场', '黑沙环区');
INSERT INTO `bus_station` VALUES (94, '关闸马路', '黑沙环区');
INSERT INTO `bus_station` VALUES (95, '三角花园', '黑沙环区');
INSERT INTO `bus_station` VALUES (96, '殷皇子马路', '中区');
INSERT INTO `bus_station` VALUES (97, '殷皇子马路/葡京', '中区');
INSERT INTO `bus_station` VALUES (98, '葡京酒店', '中区');
INSERT INTO `bus_station` VALUES (99, '十月一日前地', '新口岸区');
INSERT INTO `bus_station` VALUES (100, '北京街/假日酒店', '新口岸区');
INSERT INTO `bus_station` VALUES (101, '外港码头总站', '新口岸区');
INSERT INTO `bus_station` VALUES (102, '何贤公园', '新口岸区');
INSERT INTO `bus_station` VALUES (103, '治安警察局', '新口岸区');
INSERT INTO `bus_station` VALUES (104, '教育暨青年局', '中区');
INSERT INTO `bus_station` VALUES (105, '台山', '台山区');
INSERT INTO `bus_station` VALUES (106, '新城市花园', '台山区');
INSERT INTO `bus_station` VALUES (107, '看台街', '佑汉区');
INSERT INTO `bus_station` VALUES (108, '福泰工业大厦', '黑沙环新区');
INSERT INTO `bus_station` VALUES (109, '劳动节大马路', '黑沙环新区');
INSERT INTO `bus_station` VALUES (110, '东北大马路/大丰', '黑沙环新区');
INSERT INTO `bus_station` VALUES (111, '东北大马路/东华', '黑沙环新区');
INSERT INTO `bus_station` VALUES (112, '警察总部', '新口岸区');
INSERT INTO `bus_station` VALUES (113, '司打口总站', '下环区');
INSERT INTO `bus_station` VALUES (114, '总统酒店', '新口岸区');
INSERT INTO `bus_station` VALUES (115, '东方酒店', '新口岸区');
INSERT INTO `bus_station` VALUES (116, '黑沙环新街/广华', '黑沙环新区');
INSERT INTO `bus_station` VALUES (117, '黑沙环新街/海滨', '黑沙环新区');
INSERT INTO `bus_station` VALUES (118, '黑沙环新街/建华', '黑沙环新区');
INSERT INTO `bus_station` VALUES (119, '长寿马路', '佑汉区');
INSERT INTO `bus_station` VALUES (120, '高士德/连胜', '高士德区');
INSERT INTO `bus_station` VALUES (121, '高士德/大西洋银行', '高士德区');
INSERT INTO `bus_station` VALUES (122, '高士德/贾伯乐', '高士德区');
INSERT INTO `bus_station` VALUES (123, '罗理基/东方拱门', '新口岸区');
INSERT INTO `bus_station` VALUES (124, '高士德/培正', '高士德区');
INSERT INTO `bus_station` VALUES (125, '高士德/中银', '高士德区');
INSERT INTO `bus_station` VALUES (126, '高士德/姑娘街', '高士德区');
INSERT INTO `bus_station` VALUES (127, '高士德/红街市', '高士德区');

-- --------------------------------------------------------

-- 
-- 表的结构 `bus_type`
-- 

CREATE TABLE `bus_type` (
  `tid` tinyint(4) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `midpeop` tinyint(3) NOT NULL default '0',
  `fulpeop` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;

-- 
-- 导出表中的数据 `bus_type`
-- 

INSERT INTO `bus_type` VALUES (1, '大巴', 20, 40);