CREATE TABLE pre9_forum_attachment_2 ( aid mediumint(8) unsigned NOT NULL, tid mediumint(8) unsigned NOT NULL DEFAULT '0', pid int(10) unsigned NOT NULL DEFAULT '0', uid mediumint(8) unsigned NOT NULL DEFAULT '0', dateline int(10) unsigned NOT NULL DEFAULT '0', filename varchar(255) NOT NULL DEFAULT '', filesize int(10) unsigned NOT NULL DEFAULT '0', attachment varchar(255) NOT NULL DEFAULT '', remote tinyint(1) unsigned NOT NULL DEFAULT '0', description varchar(255) NOT NULL, readperm tinyint(3) unsigned NOT NULL DEFAULT '0', price smallint(6) unsigned NOT NULL DEFAULT '0', isimage tinyint(1) NOT NULL DEFAULT '0', width smallint(6) unsigned NOT NULL DEFAULT '0', thumb tinyint(1) unsigned NOT NULL DEFAULT '0', picid mediumint(8) NOT NULL DEFAULT '0', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid) ) ENGINE=MYISAM DEFAULT CHARSET=gbk |