CREATE TABLE `brand_albumitems` ( `itemid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `shopid` mediumint(8) unsigned NOT NULL DEFAULT '0', `catid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '鍒嗙被id', `frombbs` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '鏄?惁涓轰粠璁哄潧瀵煎叆鐨勭浉鍐?, `tid` mediumint(8) unsigned NOT NULL DEFAULT '0', `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `displayorder` smallint(6) NOT NULL DEFAULT '100', `displayorder_s` smallint(6) NOT NULL DEFAULT '100', `username` char(15) NOT NULL, `subject` char(80) NOT NULL DEFAULT '', `subjectimage` char(160) NOT NULL DEFAULT '', `description` char(255) NOT NULL COMMENT '鐩稿唽鎻忚堪', `picnum` smallint(6) NOT NULL DEFAULT '0' COMMENT '鐩稿唽鍥剧墖鏁?, `dateline` int(10) unsigned NOT NULL DEFAULT '0', `lastpost` int(10) unsigned NOT NULL DEFAULT '0', `viewnum` mediumint(8) unsigned NOT NULL DEFAULT '0', `replynum` mediumint(8) unsigned NOT NULL DEFAULT '0', `reportnum` mediumint(8) unsigned NOT NULL DEFAULT '0', `allowreply` tinyint(1) unsigned NOT NULL DEFAULT '1', `grade_s` tinyint(1) unsigned NOT NULL DEFAULT '3', `grade` tinyint(1) unsigned NOT NULL DEFAULT '3', `updateverify` tinyint(1) unsigned NULL DEFAULT '0', `bbstid` int(10) unsigned NOT NULL DEFAULT '0', `gosync` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemid`), KEY `shopid` (`shopid`, `grade_s`, `grade`), KEY `catid` (`catid`, `grade_s`, `grade`, `displayorder`), KEY `catid_s` (`catid`, `grade_s`, `grade`, `displayorder_s`), KEY `frombbs` (`frombbs`, `grade`), KEY `tid` (`tid`), KEY `grade_s` (`grade_s`, `grade`, `displayorder`), KEY `grade` (`grade`, `displayorder`), KEY `updateverify` (`updateverify`)) ENGINE=MYISAM DEFAULT CHARSET=gbk
Error writing file '.\brand\brand_albumitems.frm' (Errcode: 28)
run_sql_error- MySQL Query Error
CREATE TABLE `brand_attachments` ( `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `isavailable` tinyint(1) NOT NULL DEFAULT '0', `type` char(30) NOT NULL DEFAULT '', `itemid` mediumint(8) unsigned NOT NULL DEFAULT '0', `catid` smallint(6) unsigned NOT NULL DEFAULT '0', `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `filename` char(150) NOT NULL DEFAULT '', `subject` char(80) NOT NULL DEFAULT '', `attachtype` char(10) NOT NULL DEFAULT '', `isimage` tinyint(1) NOT NULL DEFAULT '0', `size` int(10) unsigned NOT NULL DEFAULT '0', `filepath` char(200) NOT NULL DEFAULT '', `thumbpath` char(200) NOT NULL DEFAULT '', `downloads` mediumint(8) unsigned NOT NULL DEFAULT '0', `hash` char(16) NOT NULL DEFAULT '', PRIMARY KEY (`aid`), KEY `hash` (`hash`), KEY `itemid` (`itemid`), KEY `uid` (`uid`,`type`,`dateline`), KEY `type` (`type`)) ENGINE=MYISAM DEFAULT CHARSET=gbk
Error writing file '.\brand\brand_attachments.frm' (Errcode: 28)
run_sql_error- MySQL Query Error
CREATE TABLE `brand_attribute` ( `attr_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '灞炴
|