回复 shadow0301 的帖子
CREATE TABLE uchome_pic (
picid mediumint(8) NOT NULL auto_increment,
albumid mediumint(8) unsigned NOT NULL default '0',
topicid mediumint(8) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
username varchar(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
postip varchar(20) NOT NULL default '',
filename varchar(100) NOT NULL default '',
title varchar(255) NOT NULL default '',
`type` varchar(20) NOT NULL default '',
size int(10) unsigned NOT NULL default '0',
filepath varchar(60) NOT NULL default '',
thumb tinyint(1) NOT NULL default '0',
remote tinyint(1) NOT NULL default '0',
hot mediumint(8) unsigned NOT NULL default '0',
click_6 smallint(6) unsigned NOT NULL default '0',
click_7 smallint(6) unsigned NOT NULL default '0',
click_8 smallint(6) unsigned NOT NULL default '0',
click_9 smallint(6) unsigned NOT NULL default '0',
click_10 smallint(6) unsigned NOT NULL default '0',
magicframe tinyint(6) NOT NULL default '0',
PRIMARY KEY (picid),
KEY albumid (albumid,dateline),
KEY topicid (topicid,dateline)
) ENGINE=MyISAM;
这段吗 |