mysql.sql

采用模块化开发

  `thumb` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL default '0.00',
  `quantifier` varchar(20) NOT NULL,
  `introduce` mediumtext NOT NULL,
  `unit` varchar(255) NOT NULL,
  `linkman` varchar(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `address` varchar(255) NOT NULL,
  `addtime` int(10) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL,
  `edittime` int(10) unsigned NOT NULL default '0',
  `editor` varchar(20) NOT NULL,
  `checker` varchar(20) NOT NULL,
  `checktime` int(10) unsigned NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL,
  `hits` int(10) unsigned NOT NULL default '0',
  `listorder` int(5) unsigned NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`productid`),
  KEY `listorder` (`listorder`,`productid`,`status`),
  KEY `catid` (`catid`,`listorder`,`status`),
  KEY `hits` (`hits`,`productid`,`status`),
  KEY `username` (`username`(10)),
  KEY `companyid` (`companyid`,`productid`,`listorder`,`status`),
  FULLTEXT KEY `keywords` (`keywords`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_sales`;
CREATE TABLE IF NOT EXISTS `phpcms_yp_sales` (
  `productid` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) NOT NULL,
  `catid` int(5) unsigned NOT NULL default '0',
  `companyid` int(10) unsigned NOT NULL default '0',
  `keywords` varchar(255) NOT NULL,
  `style` varchar(80) NOT NULL,
  `thumb` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL default '0.00',
  `quantifier` varchar(20) NOT NULL,
  `formerprice` decimal(10,2) NOT NULL default '0.00',
  `period` int(10) unsigned NOT NULL default '0',
  `introduce` mediumtext NOT NULL,
  `state` tinytext NOT NULL,
  `unit` varchar(255) NOT NULL,
  `linkman` varchar(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `address` varchar(255) NOT NULL,
  `addtime` int(10) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL,
  `edittime` int(10) unsigned NOT NULL default '0',
  `editor` varchar(20) NOT NULL,
  `checker` varchar(20) NOT NULL,
  `checktime` int(10) unsigned NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL,
  `hits` int(10) unsigned NOT NULL default '0',
  `listorder` int(5) unsigned NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`productid`),
  KEY `catid` (`catid`,`listorder`,`status`),
  KEY `username` (`username`(10)),
  KEY `companyid` (`companyid`,`status`,`listorder`,`productid`),
  KEY `hits` (`hits`,`status`,`productid`),
  FULLTEXT KEY `keywords` (`keywords`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_buy`;
CREATE TABLE IF NOT EXISTS `phpcms_yp_buy` (
  `productid` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(80) NOT NULL,
  `catid` int(5) unsigned NOT NULL default '0',
  `companyid` int(10) unsigned NOT NULL default '0',
  `keywords` varchar(255) NOT NULL,
  `style` varchar(80) NOT NULL,
  `period` int(10) unsigned NOT NULL default '0',
  `introduce` mediumtext NOT NULL,
  `unit` varchar(255) NOT NULL,
  `linkman` varchar(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `address` varchar(255) NOT NULL,
  `addtime` int(10) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL,
  `edittime` int(10) unsigned NOT NULL default '0',
  `editor` varchar(20) NOT NULL,
  `checker` varchar(20) NOT NULL,
  `checktime` int(10) unsigned NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL,
  `hits` int(10) unsigned NOT NULL default '0',
  `listorder` int(5) unsigned NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  `my_selecttype` varchar(50) NOT NULL default '',
  `my_buyprice` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`productid`),
  KEY `hits` (`hits`,`productid`,`status`),
  KEY `username` (`username`(10)),
  KEY `catid` (`catid`,`status`,`listorder`,`productid`),
  KEY `companyid` (`companyid`,`status`,`listorder`,`productid`),
  FULLTEXT KEY `keywords` (`keywords`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_trade`;
CREATE TABLE IF NOT EXISTS `phpcms_yp_trade` (
  `tradeid` smallint(6) unsigned NOT NULL auto_increment,
  `script` varchar(20) NOT NULL,
  `tradename` varchar(50) NOT NULL default '',
  `domain` varchar(50) NOT NULL default '',
  `style` varchar(50) NOT NULL default '',
  `parentid` smallint(6) unsigned NOT NULL default '0',
  `arrparentid` varchar(255) NOT NULL default '',
  `child` tinyint(1) NOT NULL default '0',
  `arrchildid` mediumtext NOT NULL,
  `listorder` smallint(6) unsigned NOT NULL default '0',
  `urlruleid` tinyint(1) unsigned NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL default '',
  `setting` mediumtext NOT NULL,
  `hits` int(11) unsigned NOT NULL default '0',
  `disabled` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`tradeid`),
  KEY `listorder` (`listorder`),
 KEY `script` (`script`,`disabled`,`listorder`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_stock`;
CREATE TABLE IF NOT EXISTS `phpcms_yp_stock` (
  `stockid` int(10) unsigned NOT NULL auto_increment,
  `jobid` int(10) unsigned NOT NULL,
  `label` tinyint(1) NOT NULL,
  `status` tinyint(1) unsigned NOT NULL,
  `username` varchar(20) NOT NULL,
  `addtime` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`stockid`),
  KEY `jobid` (`jobid`,`status`,`label`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `phpcms_area` (
  `areaid` smallint(6) unsigned NOT NULL auto_increment,
  `keyid` varchar(20) NOT NULL,
  `areaname` varchar(50) NOT NULL default '',
  `domain` varchar(50) NOT NULL default '',
  `style` varchar(50) NOT NULL default '',
  `parentid` smallint(6) unsigned NOT NULL default '0',
  `arrparentid` varchar(255) NOT NULL default '',
  `child` tinyint(1) NOT NULL default '0',
  `arrchildid` mediumtext NOT NULL,
  `listorder` smallint(6) unsigned NOT NULL default '0',
  `urlruleid` tinyint(1) unsigned NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL default '',
  `setting` mediumtext NOT NULL,
  `hits` int(11) unsigned NOT NULL default '0',
  `disabled` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`areaid`),
  KEY `listorder` (`listorder`),
  KEY `keyid` (`keyid`,`disabled`,`listorder`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_order`;
CREATE TABLE IF NOT EXISTS `phpcms_yp_order` (
  `orderid` int(11) unsigned NOT NULL auto_increment,
  `companyid` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL,
  `number` int(10) unsigned NOT NULL default '0',
  `order_no` varchar(30) NOT NULL,
  `content` text NOT NULL,
  `linkman` varchar(20) NOT NULL,
  `username` varchar(20) NOT NULL,
  `telephone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `qq` int(10) unsigned NOT NULL default '0',
  `msn` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL,
  `unit` varchar(255) NOT NULL,
  `status` tinyint(1) unsigned NOT NULL default '0',
  `itemid` int(11) unsigned NOT NULL default '0',
  `label` varchar(20) NOT NULL,
  `addtime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`orderid`),
  UNIQUE KEY `order_no` (`order_no`),
  KEY `orderid` (`orderid`,`status`,`itemid`,`label`)
)TYPE=MyISAM;
INSERT INTO `phpcms_field` (`tablename`, `name`, `size`, `title`, `note`, `type`, `defaultvalue`, `options`, `formtype`, `inputtool`, `inputlimit`, `listorder`, `enablehtml`, `enablelist`, `enablesearch`) VALUES('phpcms_yp_buy', 'my_selecttype', 250, '求购-出售-转让-其他', '', 'varchar', '', '求购|<b>求购</b>\r\n出售|出售\r\n转让|转让\r\n其他|其他', 'select', '', 'notnull', 0, 1, 1, 0);
INSERT INTO `phpcms_field` (`tablename`, `name`, `size`, `title`, `note`, `type`, `defaultvalue`, `options`, `formtype`, `inputtool`, `inputlimit`, `listorder`, `enablehtml`, `enablelist`, `enablesearch`) VALUES('phpcms_yp_buy', 'my_buyprice', 250, '价格', '', 'varchar', '', '选项一|选项值一\r\n选项二|选项值二\r\n选项三|选项值三', 'text', '', 'notnull', 0, 1, 1, 0);
INSERT INTO `phpcms_field` (`tablename`, `name`, `size`, `title`, `note`, `type`, `defaultvalue`, `options`, `formtype`, `inputtool`, `inputlimit`, `listorder`, `enablehtml`, `enablelist`, `enablesearch`) VALUES('phpcms_member_company', 'my_yplink', 250, '友情链接图片：', '黄页企业友情链接', 'varchar', '', '选项一|选项值一\r\n选项二|选项值二\r\n选项三|选项值三', 'text', 'imageupload', '', 0, 1, 1, 0);