/* table definition ddl				*/
/* Thu Feb 10 17:05:26 PST 2000		*/
/* SQL script for reconstituting omnibus	*/
/* sybdump run by de on yakuza.ucolick.org	*/
use omnibus
go



/*	Drop and recreate table Data_kibrick938819006_D1	*/
setuser "guest"
go
drop table Data_kibrick938819006_D1
go
create table Data_kibrick938819006_D1 (
	collflx1 int null,
	collflx2 int null,
	collflx3 int null,
	collfoc real null,
	collfocr int null,
	collmode tinyint null,
	colloff1 int null,
	colloff2 int null,
	colloff3 int null,
	collstat tinyint null,
	collusr1 int null,
	collusr2 int null,
	collusr3 int null,
	logstamp datetime NOT NULL,
	t__yoe int null,
	t__moy int null,
	t__woy int null,
	t__doy int null,
	t__dom int null,
	t__dow int null,
	t__hod int null,
	t__moh int null,
	t__som int null,
	t__tick float null
)
go

/*	Drop and recreate table Data_kibrick938819419_D1	*/
go
drop table Data_kibrick938819419_D1
go
create table Data_kibrick938819419_D1 (
	collflx1 int null,
	collflx2 int null,
	collflx3 int null,
	collfoc real null,
	collfocr int null,
	collmode tinyint null,
	colloff1 int null,
	colloff2 int null,
	colloff3 int null,
	collstat tinyint null,
	collusr1 int null,
	collusr2 int null,
	collusr3 int null,
	logstamp datetime NOT NULL,
	t__yoe int null,
	t__moy int null,
	t__woy int null,
	t__doy int null,
	t__dom int null,
	t__dow int null,
	t__hod int null,
	t__moh int null,
	t__som int null,
	t__tick float null
)
go

/*	Drop and recreate table Data_kibrick938819913_D1	*/
go
drop table Data_kibrick938819913_D1
go
create table Data_kibrick938819913_D1 (
	collflx1 int null,
	collflx2 int null,
	collflx3 int null,
	collfoc real null,
	collfocr int null,
	collmode tinyint null,
	colloff1 int null,
	colloff2 int null,
	colloff3 int null,
	collstat tinyint null,
	collusr1 int null,
	collusr2 int null,
	collusr3 int null,
	logstamp datetime NOT NULL,
	t__yoe int null,
	t__moy int null,
	t__woy int null,
	t__doy int null,
	t__dom int null,
	t__dow int null,
	t__hod int null,
	t__moh int null,
	t__som int null,
	t__tick float null
)
go

/*	Drop and recreate table Data_kibrick938820077_D1	*/
go
drop table Data_kibrick938820077_D1
go
create table Data_kibrick938820077_D1 (
	collflx1 int null,
	collflx2 int null,
	collflx3 int null,
	collfoc real null,
	collfocr int null,
	collmode tinyint null,
	colloff1 int null,
	colloff2 int null,
	colloff3 int null,
	collstat tinyint null,
	collusr1 int null,
	collusr2 int null,
	collusr3 int null,
	logstamp datetime NOT NULL,
	t__yoe int null,
	t__moy int null,
	t__woy int null,
	t__doy int null,
	t__dom int null,
	t__dow int null,
	t__hod int null,
	t__moh int null,
	t__som int null,
	t__tick float null
)
go

/*	Drop and recreate table georoad	*/
setuser "dbo"
go
drop table georoad
go
create table georoad (
	sid int NOT NULL,
	pt int NOT NULL,
	long real NOT NULL,
	lat real NOT NULL
)
go

/*	Drop and recreate table raw_roads	*/
go
drop table raw_roads
go
create table raw_roads (
	FNODE int null,
	TNODE int null,
	LPOLY int null,
	RPOLY int null,
	LENGTH real null,
	ROADS911 int null,
	ROADS911_I int null,
	STREET_ID int null,
	ID int NOT NULL,
	NAME char(22) null,
	L_LADD int null,
	L_HADD int null,
	R_LADD int null,
	R_HADD int null,
	CHANGE char(5) null,
	TIGER_CLAS char(4) null,
	ADDRESS_ER char(8) null,
	ADDR_ERR_O char(8) null,
	LABEL_ANGL real null,
	RESPONSE char(6) null,
	MESSAGE int null,
	L_CITY_ID char(15) null,
	R_CITY_ID char(15) null,
	L_POLICE_I char(4) null,
	R_POLICE_I char(4) null,
	L_FIRE_ID char(4) null,
	R_FIRE_ID char(4) null,
	L_EMS_ID char(4) null,
	R_EMS_ID char(4) null,
	L_COUNTY_I char(10) null,
	R_COUNTY_I char(10) null,
	L_MAP_PAGE char(7) null,
	R_MAP_PAGE char(7) null,
	L_REPORT_D char(4) null,
	R_REPORT_D char(4) null,
	LAST_EDIT smalldatetime null,
	EDITOR char(10) null,
	F_ID int null,
	T_ID int null,
	CHAIN char(7) null,
	LOW_CROSS char(22) null,
	HIGH_CROSS char(22) null,
	SV_ANNO int null,
	NBHD_ANNO int null,
	BLOCK100 int null,
	CLASS char(4) null,
	NBHD_ADDR char(2) null,
	POLICE_BEA char(2) null,
	FIRE_BEAT char(2) null,
	EMS_BEAT_A char(2) null,
	PREFIX_DIR char(2) null,
	ST_NAME char(20) null,
	SUFFIX_TYP char(4) null,
	POLICE_DIS char(2) null,
	FIRE_DIST char(2) null,
	EMS_DIST_A char(2) null,
	L_ANIMAL_I char(4) null,
	R_P_WORKS char(4) null,
	R_ANIMAL_I char(4) null,
	L_P_WORKS char(4) null,
	L_RESPONSE char(4) null,
	R_RESPONSE char(4) null,
	LABEL_X real null,
	LABEL_Y real null,
	F_X real null,
	F_Y real null,
	T_X real null,
	T_Y real null,
	MIN_X real null,
	MIN_Y real null,
	MAX_X real null,
	MAX_Y real null
)
go

/*	Drop and recreate table roadblock	*/
go
drop table roadblock
go
create table roadblock (
	street_id int null,
	id int null,
	name varchar(22) null,
	l_ladd int null,
	l_hadd int null,
	r_ladd int null,
	r_hadd int null,
	label_angl float null,
	l_city_id varchar(15) null,
	r_city_id varchar(15) null,
	l_county_i varchar(10) null,
	r_county_i varchar(10) null,
	f_id int null,
	t_id int null,
	low_cross_ varchar(22) null,
	high_cross varchar(22) null,
	block100 int null,
	st_name varchar(20) null,
	suffix_typ varchar(4) null,
	min_add int null,
	max_add int NOT NULL
)
go

/*	Drop and recreate table roads	*/
go
drop table roads
go
create table roads (
	id int NOT NULL,
	street_id int null,
	name char(22) null,
	prefix_dir char(2) null,
	st_name char(20) null,
	suffix_typ char(4) null,
	real real null,
	low_cross char(22) null,
	high_cross char(22) null,
	l_ladd int null,
	l_hadd int null,
	r_ladd int null,
	r_hadd int null,
	label_angl real null,
	l_map_page char(7) null,
	r_map_page char(7) null,
	l_city_id char(15) null,
	r_city_id char(15) null,
	l_county_i char(10) null,
	r_county_i char(10) null,
	f_id int null,
	t_id int null,
	min_add int null,
	maz_add int null,
	max_add int null
)
go

/*	Drop and recreate table stops	*/
go
drop table stops
go
create table stops (
	STOPID int NOT NULL,
	STOP_INSTE varchar(43) null,
	AV_STATUS char(1) null,
	MANUALLY_F char(1) null,
	AV_ADD char(43) null,
	AV_SCORE int null,
	X_COORD real null,
	Y_COORD real null
)
go
use master
go
dump tran omnibus with no_log
go

