1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
CREATE TABLE site (
st_id int(12) NOT NULL auto_increment,
st_user_ref int(12) DEFAULT '0' NOT NULL,
st_cat_ref int(12) DEFAULT '0' NOT NULL,
st_name varchar(100) NOT NULL,
st_url varchar(100) NOT NULL,
st_desc text NOT NULL,
st_show_me int(32) DEFAULT '0' NOT NULL,
st_click_me int(32) DEFAULT '0' NOT NULL,
st_status int(2) DEFAULT '0' NOT NULL,
st_banner blob NOT NULL,
st_show_my int(32) DEFAULT '0' NOT NULL,
st_click_my int(32) DEFAULT '0' NOT NULL,
PRIMARY KEY (st_id),
KEY st_user_ref (st_user_ref)
); |
Partager