全国列车时刻数据库脚本

# phpMyAdmin MySQL-Dump # version 2.5.0-rc2 # http://www.phpmyadmin.net/ (download page) # # 主机: localhost # 生成日期: 2006 年 06 月 07 日 01:12 # 服务器版本: 4.0.18 # PHP 版本: 4.3.4 # 数据库 : `post` # -------------------------------------------------------- # # 表的结构 `tx_train_province` # # 创建时间: 2006 年 06 月 03 日 02:10 # 最后更新时间: 2006 年 06 月 03 日 02:10 # CREATE TABLE `tx_train_province` ( `provinceID` tinyint(2) unsigned NOT NULL auto_increment, `provinceName` varchar(6) NOT NULL default '', `enName` varchar(15) NOT NULL default '', PRIMARY KEY (`provinceID`), UNIQUE KEY `provinceName` (`provinceName`), KEY `enName` (`enName`) ) TYPE=MyISAM AUTO_INCREMENT=100 ; # # 导出表中的数据 `tx_train_province` # INSERT INTO `tx_train_province` VALUES (1, '北京', 'beijing'); INSERT INTO `tx_train_province` VALUES (2, '上海', 'shanghai'); INSERT INTO `tx_train_province` VALUES (3, '天津', 'tianjin'); INSERT INTO `tx_train_province` VALUES (4, '重庆', 'chongqing'); INSERT INTO `tx_train_province` VALUES (5, '广东', 'guangdong'); INSERT INTO `tx_train_province` VALUES (6, '四川', 'sichuan'); INSERT INTO `tx_train_province` VALUES (7, '湖南', 'hunan'); INSERT INTO `tx_train_province` VALUES (8, '湖北', 'hubei'); INSERT INTO `tx_train_province` VALUES (9, '浙江', 'zhejiang'); INSERT INTO `tx_train_province` VALUES (10, '福建', 'fujian'); INSERT INTO `tx_train_province` VALUES (11, '河南', 'henan'); INSERT INTO `tx_train_province` VALUES (12, '河北', 'hebei'); INSERT INTO `tx_train_province` VALUES (13, '安徽', 'anhui'); INSERT INTO `tx_train_province` VALUES (14, '山东', 'shandong'); INSERT INTO `tx_train_province` VALUES (15, '山西', 'shanxi'); INSERT INTO `tx_train_province` VALUES (16, '黑龙江', 'heilongjiang'); INSERT INTO `tx_train_province` VALUES (17, '吉林', 'jilin'); INSERT INTO `tx_train_province` VALUES (18, '辽宁', 'liaoning'); INSERT INTO `tx_train_province` VALUES (19, '江西', 'jiangxi'); INSERT INTO `tx_train_province` VALUES (20, '陕西', 'shanxi'); INSERT INTO `tx_train_province` VALUES (21, '云南', 'yunnan'); INSERT INTO `tx_train_province` VALUES (22, '甘肃', 'gansu'); INSERT INTO `tx_train_province` VALUES (23, '广西', 'guangxi'); INSERT INTO `tx_train_province` VALUES (24, '贵州', 'guizhou'); INSERT INTO `tx_train_province` VALUES (25, '江苏', 'jiangxi'); INSERT INTO `tx_train_province` VALUES (26, '内蒙古', 'neimenggu'); INSERT INTO `tx_train_province` VALUES (27, '宁夏', 'ningxia'); INSERT INTO `tx_train_province` VALUES (28, '青海', 'qinghai'); INSERT INTO `tx_train_province` VALUES (29, '新疆', 'xinjiang'); # -------------------------------------------------------- # # 表的结构 `tx_train_station` # # 创建时间: 2006 年 06 月 05 日 20:39 # 最后更新时间: 2006 年 06 月 06 日 14:00 # 最后检查时间: 2006 年 06 月 05 日 20:39 # CREATE TABLE `tx_train_station` ( `stationID` smallint(4) unsigned NOT NULL auto_increment, `provinceID` tinyint(2) unsigned NOT NULL default '0', `stationName` varchar(40) NOT NULL default '', `trainnum` smallint(3) unsigned NOT NULL default '0', PRIMARY KEY (`stationID`), KEY `provinceID` (`provinceID`) ) TYPE=MyISAM AUTO_INCREMENT=3804 ; # # 导出表中的数据 `tx_train_station` # INSERT INTO `tx_train_station` VALUES (143, 1, '通县', 0); INSERT INTO `tx_train_station` VALUES (76, 1, '八达岭', 2); INSERT INTO `tx_train_station` VALUES (77, 1, '北京', 352); INSERT INTO `tx_train_station` VALUES (78, 1, '北京北', 14); INSERT INTO `tx_train_station` VALUES (79, 1, '北京东', 3); INSERT INTO `tx_train_station` VALUES (80, 1, '北京南', 0); INSERT INTO `tx_train_station` VALUES (81, 1, '北京市', 352); INSERT INTO `tx_train_station` VALUES (82, 1, '北京西', 172); INSERT INTO `tx_train_station` VALUES (83, 1, '北宅', 2); INSERT INTO `tx_train_station` VALUES (84, 1, '兵马营', 2); INSERT INTO `tx_train_station` VALUES (85, 1, '昌平', 8); INSERT INTO `tx_train_station` VALUES (86, 1, '昌平北', 2); INSERT INTO `tx_train_station` VALUES (87, 1, '大城子', 0); INSERT INTO `tx_train_station` VALUES (88, 1, '大灰厂', 4); INSERT INTO `tx_train_station` VALUES (89, 1, '大兴', 5); INSERT INTO `tx_train_station` VALUES (90, 1, '东园', 2); INSERT INTO `tx_train_station` VALUES (91, 1, '范各庄', 2); INSERT INTO `tx_train_station` VALUES (92, 1, '丰台', 34); INSERT INTO `tx_train_station` VALUES (93, 1, '丰台西', 4); INSERT INTO `tx_train_station` VALUES (94, 1, '高各庄', 4); INSERT INTO `tx_train_station` VALUES (95, 1, '官高', 2); INSERT INTO `tx_train_station` VALUES (96, 1, '孤山口', 4); INSERT INTO `tx_train_station` VALUES (97, 1, '黑山寺', 2); INSERT INTO `tx_train_station` VALUES (98, 1, '怀柔', 17); INSERT INTO `tx_train_station` VALUES (99, 1, '怀柔北', 10); INSERT INTO `tx_train_station` VALUES (100, 1, '怀柔市', 17); INSERT INTO `tx_train_station` VALUES (101, 1, '黄村', 9); INSERT INTO `tx_train_station` VALUES (102, 1, '巨各庄', 0); INSERT INTO `tx_train_station` VALUES (103, 1, '康庄', 6); INSERT INTO `tx_train_station` VALUES (104, 1, '良各庄', 4); INSERT INTO `tx_train_station` VALUES (105, 1, '落坡岭', 2); INSERT INTO `tx_train_station` VALUES (106, 1, '庙城', 4); INSERT INTO `tx_train_station` VALUES (107, 1, '密云', 6); INSERT INTO `tx_train_station` VALUES (108, 1, '南观村', 4); INSERT INTO `tx_train_station` VALUES (109, 1, '南口', 8); INSERT INTO `tx_train_station` VALUES (110, 1, '牛栏山', 0); INSERT INTO `tx_train_station` VALUES (111, 1, '平义分', 2); INSERT INTO `tx_train_station` VALUES (112, 1, '平峪', 4); INSERT INTO `tx_train_station` VALUES (113, 1, '墙子路', 0); INSERT INTO `tx_train_station` VALUES (114, 1, '清河', 6); INSERT INTO `tx_train_station` VALUES (115, 1, '清华园', 8); INSERT INTO `tx_train_station` VALUES (116, 1, '青龙桥', 5); INSERT INTO `tx_train_station` VALUES (117, 1, '三堡', 2); INSERT INTO `tx_train_station` VALUES (118, 1, '三合庄', 3); INSERT INTO `tx_train_station` VALUES (119, 1, '三家店', 9); INSERT INTO `tx_train_station` VALUES (120, 1, '沙河', 6); INSERT INTO `tx_train_station` VALUES (121, 1, '上万', 4); INSERT INTO `tx_train_station` VALUES (122, 1, '十渡', 4); INSERT INTO `tx_train_station` VALUES (123, 1, '石景山南', 4); INSERT INTO `tx_train_station` VALUES (124, 1, '石塘路', 6); INSERT INTO `tx_train_station` VALUES (125, 1, '双桥', 2); INSERT INTO `tx_train_station` VALUES (126, 1, '顺义', 7); INSERT INTO `tx_train_station` VALUES (127, 1, '统军庄', 4); INSERT INTO `tx_train_station` VALUES (128, 1, '通县', 0); INSERT INTO `tx_train_station` VALUES (129, 1, '通县西', 0); INSERT INTO `tx_train_station` VALUES (130, 1, '下河', 2); INSERT INTO `tx_train_station` VALUES (131, 1, '小水峪', 2); INSERT INTO `tx_train_station` VALUES (132, 1, '小唐庄', 0); INSERT INTO `tx_train_station` VALUES (133, 1, '西拨子', 2); INSERT INTO `tx_train_station` VALUES (134, 1, '斜河涧', 2); INSERT INTO `tx_train_station` VALUES (135, 1, '兴寿', 2); INSERT INTO `tx_train_station` VALUES (136, 1, '雁翅', 4); INSERT INTO `tx_train_station` VALUES (137, 1, '沿河城', 2); INSERT INTO `tx_train_station` VALUES (138, 1, '燕落', 2); INSERT INTO `tx_train_station` VALUES (139, 1, '燕山', 4); INSERT INTO `tx_train_station` VALUES (140, 1, '云居寺', 4); INSERT INTO `tx_train_station` VALUES (141, 1, '张辛', 4); INSERT INTO `tx_train_station` VALUES (142, 1, '珠窝', 3); INSERT INTO `tx_train_station` VALUES (3145, 2, '安亭', 2); INSERT INTO `tx_train_station` VALUES (3146, 2, '枫泾', 3); INSERT INTO `tx_train_station` VALUES (3147, 2, '梅陇', 10); INSERT INTO `tx_train_station` VALUES (3148, 2, '上海', 226); INSERT INTO `tx_train_station` VALUES (3149, 2, '上海市', 226); INSERT INTO `tx_train_station` VALUES (3150, 2, '上海西', 22); INSERT INTO `tx_train_station` VALUES (3151, 2, '松江', 48); INSERT INTO `tx_train_station` VALUES (3371, 3, '宝坻', 2); INSERT INTO `tx_train_station` VALUES (3372, 3, '北仓', 2