database struct.txt

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

bus_route
rid	int
roid	mediumint
direction	tinyint(1)
station	tinyint
sort	tinyint

//direction  0 => Go  1 => Back


bus_road
roid	mediumint		primary index
road	varchar(10)
price	float


bus_busrun
bid	int
bustype	tinyint
direction	tinyint(1)
roid	mediumint
number	varchar(50)
starttime	int(10)
station	TINYINT UNSIGNED
people	tinyint(3)
enable	tinyint(1)

bus_type
tid	tinyint
name	varchar(50)
midpeop	tinyint(3)
fulpeop	tinyint(3)

bus_log
logid	int
bid	int
direction	tinyint(1)
roid	mediumint
station	tinyint
passtime	int(10)


bus_station
station	mediumint
name	varchar(50)



UPDATE `bus_busrun` SET starttime = unix_timestamp( now( ) ) -(rand() * 1000) WHERE starttime =0
update `bus_log` set passtime = unix_timestamp(now()) where passtime=0