1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| CREATE TABLE forum_attachments (
att_id decimal identity,
post_id int(11) NOT NULL default '0',
topic_id int(11) NOT NULL default '0',
forum_id int(11) NOT NULL default '0',
unixdate int(11) NOT NULL default '0',
att_name varchar(255) NOT NULL default '',
att_type varchar(64) NOT NULL default '',
att_size int(11) NOT NULL default '0',
att_path varchar(255) NOT NULL default '',
inline char(1) NOT NULL default '',
apli varchar(10) NOT NULL default '',
compteur int(11) NOT NULL default '0',
visible tinyint(1) NOT NULL default '0',
PRIMARY KEY (att_id),
KEY (post_id),
KEY (topic_id),
KEY (apli),
KEY (visible),
KEY (forum_id)
) |
Partager