- 论坛徽章:
- 0
|
回复 #4 yangward 的帖子
Table: trade
Create Table: CREATE TABLE `trade` (
`id` int(11) NOT NULL auto_increment,
`poster` varchar(50) collate utf8_unicode_ci default NULL,
`editor` varchar(20) collate utf8_unicode_ci default NULL,
`post_date` timestamp NULL default CURRENT_TIMESTAMP,
`pubDate` date default NULL,
`webSite` varchar(60) collate utf8_unicode_ci default NULL,
`type` varchar(10) collate utf8_unicode_ci NOT NULL default '',
`title` varchar(150) collate utf8_unicode_ci default NULL,
`product` varchar(100) collate utf8_unicode_ci default NULL,
`link` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(20) collate utf8_unicode_ci default NULL,
`subcategory` varchar(20) collate utf8_unicode_ci default NULL,
`region` varchar(20) collate utf8_unicode_ci default NULL,
`expiryDate` int(11) default '30',
`company` varchar(100) collate utf8_unicode_ci default NULL,
`intro` text collate utf8_unicode_ci,
`contact` varchar(50) collate utf8_unicode_ci default NULL,
`tel` varchar(50) collate utf8_unicode_ci default NULL,
`fax` varchar(50) collate utf8_unicode_ci default NULL,
`zip` varchar(20) collate utf8_unicode_ci default NULL,
`mobile` varchar(30) collate utf8_unicode_ci default NULL,
`email` varchar(50) collate utf8_unicode_ci default NULL,
`address` varchar(100) collate utf8_unicode_ci default NULL,
`company_http` varchar(100) collate utf8_unicode_ci default NULL,
`keywords` varchar(100) collate utf8_unicode_ci default NULL,
`pic_name` varchar(20) collate utf8_unicode_ci default NULL,
`pic_name1` varchar(100) collate utf8_unicode_ci default NULL,
`image` varchar(200) collate utf8_unicode_ci default NULL,
`data_flag` tinyint(4) default '0',
`ip_address` varchar(20) collate utf8_unicode_ci default NULL,
`additional` text collate utf8_unicode_ci,
`in_Q` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `category` (`category`),
KEY `subcategory` (`subcategory`),
KEY `pubDate` (`pubDate`),
KEY `poster` (`poster`),
KEY `product` (`product`),
KEY `data_flag` (`data_flag`),
KEY `post_date` (`post_date`),
KEY `type` (`type`,`category`)
) ENGINE=MyISAM AUTO_INCREMENT=135201077 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci MAX_ROWS=1000000000 AVG_ROW_LENGTH=15000 |
|