All pastes #604646 Raw Edit

Untitled

public text v1 · immutable
·published 2007-07-05 18:17 UTC
rendered paste body
create table _website_user_shipping
(
	id int not null primary key auto_increment ,
	name varchar(150) not null ,
	idUser int not null ,
	fname varchar(150) null ,
	lname varchar(150) null ,
	idCountry int not null ,
	address varchar(150) not null ,
	address2 varchar(50) null ,
	idCity varchar(150) null ,
	idState int null ,
	zip varchar(50) null ,
	instructions varchar(2000) null ,
	constraint fk_website_user_shipping_idUser foreign key (idUser) references _website_user(id) ,
	constraint fk_website_user_shipping_idCountry foreign key (idCountry) references _country(id) ,
	constraint fk_website_user_shipping_idState foreign key (idState) references _state(id) ,
	constraint fk_website_user_shipping_idCity foreign key (idCity) references _city(id)
);