⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 install.sql

📁 我的比赛作品 第22届全国青少年科技创新大赛3等奨 备注: 同时使用VC及Delphi开发
💻 SQL
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost
-- 生成日期: 2007 年 07 月 28 日 03:32
-- 服务器版本: 5.0.24
-- PHP 版本: 5.1.6
-- 
-- 数据库: `bus`
-- 

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

-- 
-- 表的结构 `bus_busrun`
-- 

CREATE TABLE `bus_busrun` (
  `bid` int(11) NOT NULL auto_increment,
  `bustype` tinyint(4) NOT NULL default '1',
  `direction` tinyint(1) unsigned NOT NULL default '0',
  `roid` mediumint(9) NOT NULL default '0',
  `number` varchar(25) NOT NULL default '',
  `starttime` int(10) NOT NULL default '0',
  `station` tinyint(3) unsigned NOT NULL default '0',
  `people` tinyint(3) unsigned NOT NULL default '0',
  `enable` tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`bid`),
  KEY `road` (`roid`,`number`),
  KEY `enable` (`enable`),
  KEY `station` (`station`),
  KEY `bustype` (`bustype`),
  KEY `direction` (`direction`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=5 ;

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

INSERT INTO `bus_busrun` VALUES (1, 1, 0, 7, 'MF-1234', 1171336357, 0, 55, 1);
INSERT INTO `bus_busrun` VALUES (2, 1, 0, 7, 'MC-9876', 1171417469, 14, 12, 1);
INSERT INTO `bus_busrun` VALUES (3, 1, 0, 7, 'TT-1111', 1171337269, 57, 0, 0);
INSERT INTO `bus_busrun` VALUES (4, 1, 0, 7, 'TT-1112', 1171336965, 123, 0, 0);

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

-- 
-- 表的结构 `bus_log`
-- 

CREATE TABLE `bus_log` (
  `logid` int(10) unsigned NOT NULL auto_increment,
  `bid` int(11) NOT NULL default '0',
  `direction` tinyint(1) unsigned NOT NULL default '0',
  `roid` mediumint(9) NOT NULL default '0',
  `station` tinyint(4) NOT NULL default '0',
  `passtime` int(10) NOT NULL default '0',
  PRIMARY KEY  (`logid`),
  KEY `bid` (`bid`,`station`),
  KEY `roid` (`roid`),
  KEY `direction` (`direction`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=23 ;

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

INSERT INTO `bus_log` VALUES (1, 2, 0, 7, 15, 1173534926);
INSERT INTO `bus_log` VALUES (2, 2, 0, 7, 14, 1173535131);
INSERT INTO `bus_log` VALUES (3, 1, 0, 7, 15, 1173535166);

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

-- 
-- 表的结构 `bus_road`
-- 

CREATE TABLE `bus_road` (
  `roid` mediumint(9) NOT NULL auto_increment,
  `road` varchar(5) NOT NULL default '',
  `price` float NOT NULL default '2.5',
  PRIMARY KEY  (`roid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=26 ;

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

INSERT INTO `bus_road` VALUES (1, '1', 2.5);
INSERT INTO `bus_road` VALUES (2, '1A', 2.5);
INSERT INTO `bus_road` VALUES (3, '2', 2.5);
INSERT INTO `bus_road` VALUES (4, '3', 2.5);
INSERT INTO `bus_road` VALUES (5, '3A', 2.5);
INSERT INTO `bus_road` VALUES (6, '4', 2.5);
INSERT INTO `bus_road` VALUES (7, '5', 2.5);
INSERT INTO `bus_road` VALUES (8, '6', 2.5);
INSERT INTO `bus_road` VALUES (9, '7', 2.5);
INSERT INTO `bus_road` VALUES (10, '8', 2.5);
INSERT INTO `bus_road` VALUES (11, '8A', 2.5);
INSERT INTO `bus_road` VALUES (12, '9', 2.5);
INSERT INTO `bus_road` VALUES (13, '9A', 2.5);
INSERT INTO `bus_road` VALUES (14, '16', 2.5);
INSERT INTO `bus_road` VALUES (15, '26', 2.5);
INSERT INTO `bus_road` VALUES (16, '26A', 2.5);
INSERT INTO `bus_road` VALUES (17, '28A', 2.5);
INSERT INTO `bus_road` VALUES (18, '28B', 2.5);
INSERT INTO `bus_road` VALUES (19, '28BX', 2.5);
INSERT INTO `bus_road` VALUES (20, '28C', 2.5);
INSERT INTO `bus_road` VALUES (21, '32', 2.5);
INSERT INTO `bus_road` VALUES (22, '33', 3.3);
INSERT INTO `bus_road` VALUES (23, '34', 3.3);
INSERT INTO `bus_road` VALUES (24, '35', 3.3);
INSERT INTO `bus_road` VALUES (25, 'AP1', 3.3);

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

-- 
-- 表的结构 `bus_route`
-- 

CREATE TABLE `bus_route` (
  `rid` int(10) unsigned NOT NULL auto_increment,
  `roid` mediumint(9) NOT NULL default '0',
  `direction` tinyint(1) NOT NULL default '0',
  `station` tinyint(1) NOT NULL default '0',
  `sort` tinyint(4) NOT NULL default '0',
  `cost` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`rid`),
  KEY `road` (`roid`,`direction`,`station`),
  KEY `sort` (`sort`),
  KEY `cost` (`cost`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=1230 ;

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

INSERT INTO `bus_route` VALUES (1, 1, 0, 1, 0, 0);
INSERT INTO `bus_route` VALUES (2, 1, 0, 2, 0, 0);
INSERT INTO `bus_route` VALUES (3, 1, 0, 3, 0, 0);
INSERT INTO `bus_route` VALUES (4, 1, 0, 4, 0, 0);
INSERT INTO `bus_route` VALUES (5, 1, 0, 5, 0, 0);
INSERT INTO `bus_route` VALUES (6, 1, 0, 6, 0, 0);
INSERT INTO `bus_route` VALUES (7, 1, 0, 7, 0, 0);
INSERT INTO `bus_route` VALUES (8, 1, 0, 8, 0, 0);
INSERT INTO `bus_route` VALUES (9, 1, 0, 9, 0, 0);
INSERT INTO `bus_route` VALUES (10, 1, 0, 10, 0, 0);
INSERT INTO `bus_route` VALUES (11, 1, 0, 11, 0, 0);
INSERT INTO `bus_route` VALUES (12, 1, 0, 12, 0, 0);
INSERT INTO `bus_route` VALUES (13, 1, 0, 13, 0, 0);
INSERT INTO `bus_route` VALUES (14, 1, 0, 14, 0, 0);
INSERT INTO `bus_route` VALUES (15, 1, 0, 15, 0, 0);
INSERT INTO `bus_route` VALUES (16, 1, 0, 16, 0, 0);
INSERT INTO `bus_route` VALUES (17, 1, 0, 17, 0, 0);
INSERT INTO `bus_route` VALUES (18, 1, 1, 17, 0, 0);
INSERT INTO `bus_route` VALUES (19, 1, 1, 18, 0, 0);
INSERT INTO `bus_route` VALUES (20, 1, 1, 19, 0, 0);
INSERT INTO `bus_route` VALUES (21, 1, 1, 20, 0, 0);
INSERT INTO `bus_route` VALUES (22, 1, 1, 21, 0, 0);
INSERT INTO `bus_route` VALUES (23, 1, 1, 22, 0, 0);
INSERT INTO `bus_route` VALUES (24, 1, 1, 23, 0, 0);
INSERT INTO `bus_route` VALUES (25, 1, 1, 24, 0, 0);
INSERT INTO `bus_route` VALUES (26, 1, 1, 25, 0, 0);
INSERT INTO `bus_route` VALUES (27, 1, 1, 26, 0, 0);
INSERT INTO `bus_route` VALUES (28, 1, 1, 27, 0, 0);
INSERT INTO `bus_route` VALUES (29, 1, 1, 28, 0, 0);
INSERT INTO `bus_route` VALUES (30, 1, 1, 29, 0, 0);
INSERT INTO `bus_route` VALUES (31, 1, 1, 30, 0, 0);
INSERT INTO `bus_route` VALUES (32, 1, 1, 31, 0, 0);
INSERT INTO `bus_route` VALUES (33, 1, 1, 32, 0, 0);
INSERT INTO `bus_route` VALUES (34, 1, 1, 33, 0, 0);
INSERT INTO `bus_route` VALUES (35, 1, 1, 1, 0, 0);
INSERT INTO `bus_route` VALUES (36, 2, 0, 34, 0, 0);
INSERT INTO `bus_route` VALUES (37, 2, 0, 35, 0, 0);
INSERT INTO `bus_route` VALUES (38, 2, 0, 36, 0, 0);
INSERT INTO `bus_route` VALUES (39, 2, 0, 37, 0, 0);
INSERT INTO `bus_route` VALUES (40, 2, 0, 38, 0, 0);
INSERT INTO `bus_route` VALUES (41, 2, 0, 39, 0, 0);
INSERT INTO `bus_route` VALUES (42, 2, 0, 40, 0, 0);
INSERT INTO `bus_route` VALUES (43, 2, 0, 41, 0, 0);
INSERT INTO `bus_route` VALUES (44, 2, 0, 42, 0, 0);
INSERT INTO `bus_route` VALUES (45, 2, 0, 43, 0, 0);
INSERT INTO `bus_route` VALUES (46, 2, 0, 44, 0, 0);
INSERT INTO `bus_route` VALUES (47, 2, 0, 45, 0, 0);
INSERT INTO `bus_route` VALUES (48, 2, 0, 46, 0, 0);
INSERT INTO `bus_route` VALUES (49, 2, 0, 4, 0, 0);
INSERT INTO `bus_route` VALUES (50, 2, 0, 5, 0, 0);
INSERT INTO `bus_route` VALUES (51, 2, 0, 6, 0, 0);
INSERT INTO `bus_route` VALUES (52, 2, 0, 7, 0, 0);
INSERT INTO `bus_route` VALUES (53, 2, 0, 8, 0, 0);
INSERT INTO `bus_route` VALUES (54, 2, 0, 9, 0, 0);
INSERT INTO `bus_route` VALUES (55, 2, 0, 10, 0, 0);
INSERT INTO `bus_route` VALUES (56, 2, 0, 11, 0, 0);
INSERT INTO `bus_route` VALUES (57, 2, 0, 12, 0, 0);
INSERT INTO `bus_route` VALUES (58, 2, 0, 13, 0, 0);
INSERT INTO `bus_route` VALUES (59, 2, 0, 14, 0, 0);
INSERT INTO `bus_route` VALUES (60, 2, 0, 15, 0, 0);
INSERT INTO `bus_route` VALUES (61, 2, 0, 16, 0, 0);
INSERT INTO `bus_route` VALUES (62, 2, 0, 17, 0, 0);
INSERT INTO `bus_route` VALUES (63, 2, 1, 17, 0, 0);
INSERT INTO `bus_route` VALUES (64, 2, 1, 18, 0, 0);
INSERT INTO `bus_route` VALUES (65, 2, 1, 19, 0, 0);
INSERT INTO `bus_route` VALUES (66, 2, 1, 20, 0, 0);
INSERT INTO `bus_route` VALUES (67, 2, 1, 21, 0, 0);
INSERT INTO `bus_route` VALUES (68, 2, 1, 22, 0, 0);
INSERT INTO `bus_route` VALUES (69, 2, 1, 23, 0, 0);
INSERT INTO `bus_route` VALUES (70, 2, 1, 24, 0, 0);
INSERT INTO `bus_route` VALUES (71, 2, 1, 25, 0, 0);
INSERT INTO `bus_route` VALUES (72, 2, 1, 26, 0, 0);
INSERT INTO `bus_route` VALUES (73, 2, 1, 27, 0, 0);
INSERT INTO `bus_route` VALUES (74, 2, 1, 28, 0, 0);
INSERT INTO `bus_route` VALUES (75, 2, 1, 47, 0, 0);
INSERT INTO `bus_route` VALUES (76, 2, 1, 48, 0, 0);
INSERT INTO `bus_route` VALUES (77, 2, 1, 3, 0, 0);
INSERT INTO `bus_route` VALUES (78, 2, 1, 49, 0, 0);
INSERT INTO `bus_route` VALUES (79, 2, 1, 50, 0, 0);
INSERT INTO `bus_route` VALUES (80, 2, 1, 51, 0, 0);
INSERT INTO `bus_route` VALUES (81, 2, 1, 52, 0, 0);
INSERT INTO `bus_route` VALUES (82, 2, 1, 53, 0, 0);
INSERT INTO `bus_route` VALUES (83, 2, 1, 54, 0, 0);
INSERT INTO `bus_route` VALUES (84, 2, 1, 55, 0, 0);
INSERT INTO `bus_route` VALUES (85, 2, 1, 56, 0, 0);
INSERT INTO `bus_route` VALUES (86, 2, 1, 57, 0, 0);
INSERT INTO `bus_route` VALUES (87, 2, 1, 58, 0, 0);
INSERT INTO `bus_route` VALUES (88, 2, 1, 59, 0, 0);
INSERT INTO `bus_route` VALUES (89, 2, 1, 60, 0, 0);
INSERT INTO `bus_route` VALUES (90, 2, 1, 61, 0, 0);
INSERT INTO `bus_route` VALUES (91, 2, 1, 62, 0, 0);
INSERT INTO `bus_route` VALUES (92, 2, 1, 63, 0, 0);
INSERT INTO `bus_route` VALUES (93, 2, 1, 64, 0, 0);
INSERT INTO `bus_route` VALUES (94, 2, 1, 34, 0, 0);
INSERT INTO `bus_route` VALUES (95, 3, 0, 65, 0, 0);
INSERT INTO `bus_route` VALUES (96, 3, 0, 66, 0, 0);
INSERT INTO `bus_route` VALUES (97, 3, 0, 67, 0, 0);
INSERT INTO `bus_route` VALUES (98, 3, 0, 68, 0, 0);
INSERT INTO `bus_route` VALUES (99, 3, 0, 69, 0, 0);
INSERT INTO `bus_route` VALUES (100, 3, 0, 70, 0, 0);
INSERT INTO `bus_route` VALUES (101, 3, 0, 51, 0, 0);
INSERT INTO `bus_route` VALUES (102, 3, 0, 52, 0, 0);
INSERT INTO `bus_route` VALUES (103, 3, 0, 71, 0, 0);
INSERT INTO `bus_route` VALUES (104, 3, 0, 72, 0, 0);
INSERT INTO `bus_route` VALUES (105, 3, 0, 73, 0, 0);
INSERT INTO `bus_route` VALUES (106, 3, 0, 74, 0, 0);
INSERT INTO `bus_route` VALUES (107, 3, 0, 75, 0, 0);
INSERT INTO `bus_route` VALUES (108, 3, 0, 76, 0, 0);
INSERT INTO `bus_route` VALUES (109, 3, 0, 77, 0, 0);
INSERT INTO `bus_route` VALUES (110, 3, 0, 78, 0, 0);
INSERT INTO `bus_route` VALUES (111, 3, 0, 11, 0, 0);
INSERT INTO `bus_route` VALUES (112, 3, 0, 12, 0, 0);
INSERT INTO `bus_route` VALUES (113, 3, 0, 13, 0, 0);
INSERT INTO `bus_route` VALUES (114, 3, 0, 14, 0, 0);
INSERT INTO `bus_route` VALUES (115, 3, 0, 15, 0, 0);
INSERT INTO `bus_route` VALUES (116, 3, 0, 16, 0, 0);
INSERT INTO `bus_route` VALUES (117, 3, 0, 17, 0, 0);
INSERT INTO `bus_route` VALUES (118, 3, 1, 17, 0, 0);
INSERT INTO `bus_route` VALUES (119, 3, 1, 18, 0, 0);
INSERT INTO `bus_route` VALUES (120, 3, 1, 19, 0, 0);
INSERT INTO `bus_route` VALUES (121, 3, 1, 20, 0, 0);
INSERT INTO `bus_route` VALUES (122, 3, 1, 21, 0, 0);
INSERT INTO `bus_route` VALUES (123, 3, 1, 22, 0, 0);
INSERT INTO `bus_route` VALUES (124, 3, 1, 23, 0, 0);
INSERT INTO `bus_route` VALUES (125, 3, 1, 79, 0, 0);
INSERT INTO `bus_route` VALUES (126, 3, 1, 80, 0, 0);
INSERT INTO `bus_route` VALUES (127, 3, 1, 81, 0, 0);
INSERT INTO `bus_route` VALUES (128, 3, 1, 82, 0, 0);
INSERT INTO `bus_route` VALUES (129, 3, 1, 83, 0, 0);
INSERT INTO `bus_route` VALUES (130, 3, 1, 84, 0, 0);
INSERT INTO `bus_route` VALUES (131, 3, 1, 85, 0, 0);
INSERT INTO `bus_route` VALUES (132, 3, 1, 86, 0, 0);
INSERT INTO `bus_route` VALUES (133, 3, 1, 87, 0, 0);
INSERT INTO `bus_route` VALUES (134, 3, 1, 42, 0, 0);
INSERT INTO `bus_route` VALUES (135, 3, 1, 43, 0, 0);
INSERT INTO `bus_route` VALUES (136, 3, 1, 44, 0, 0);
INSERT INTO `bus_route` VALUES (137, 3, 1, 45, 0, 0);
INSERT INTO `bus_route` VALUES (138, 3, 1, 88, 0, 0);
INSERT INTO `bus_route` VALUES (139, 3, 1, 89, 0, 0);
INSERT INTO `bus_route` VALUES (140, 3, 1, 90, 0, 0);
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -