mysql.sql

采用模块化开发

INSERT INTO `phpcms_module` (`name`, `module`, `moduledir`, `moduledomain`, `iscore`, `iscopy`, `isshare`, `version`, `author`, `site`, `email`, `introduce`, `license`, `faq`, `setting`, `disabled`, `publishdate`, `installdate`, `updatedate`) VALUES
('企业黄页', 'yp', 'yp', '', 0, 0, 0, '1.0.0', 'phpcms', 'http://www.phpcms.cn', '[e-mail]', '企业黄页', '', '', '', 0, '0000-00-00', '0000-00-00', '0000-00-00');

INSERT INTO `phpcms_menu` ( `position`, `name`, `title`, `url`, `target`, `style`, `listorder`, `arrgroupid`, `arrgrade`, `username`) VALUES 
('member_menu', '我的简历', '', 'yp/myitem.php', '_self', '', 100, '', '', '');

INSERT INTO `phpcms_channel` (`module`, `channelname`, `style`, `channelpic`, `introduce`, `seo_title`, `seo_keywords`, `seo_description`, `listorder`, `islink`, `channeldir`, `channeldomain`, `disabled`, `templateid`, `skinid`, `items`, `comments`, `categorys`, `specials`, `hits`, `enablepurview`, `arrgroupid_browse`, `purview_message`, `point_message`, `enablecontribute`, `enablecheck`, `emailofreject`, `emailofpassed`, `enableupload`, `uploaddir`, `maxfilesize`, `uploadfiletype`, `linkurl`, `setting`, `ishtml`, `cat_html_urlruleid`, `item_html_urlruleid`, `special_html_urlruleid`, `cat_php_urlruleid`, `item_php_urlruleid`, `special_php_urlruleid`) VALUES 
('yp', '企业黄页', '', '', '', '', '', '', 7, 1, '', '', 0, '0', '0', 0, 0, 0, 0, 0, 0, '', '<div align=''center'' style=''color:red''>对不起，您没有阅读权限！</div>', '<p align=''center''><span style=''background:#E3E3E3''><a href=''{$readurl}'' class=''read''>阅读本文需要消耗<font color=''red''>{$readpoint}</font>点，您确认查看吗？</a></span></p><br/>', 1, 1, '', '', 1, 'uploadfile', 1024000, 'gif|jpg', 'yp/', '', 1, 0, 0, 0, 0, 0, 0);


DROP TABLE IF EXISTS `phpcms_member_company`;
CREATE TABLE IF NOT EXISTS `phpcms_member_company` (
  `companyid` int(10) unsigned NOT NULL auto_increment,
  `companyname` varchar(100) NOT NULL,
  `username` varchar(20) NOT NULL,
  `listorder` int(10) unsigned NOT NULL default '0',
  `pattern` varchar(255) NOT NULL,
  `tradeid` int(6) unsigned NOT NULL default '0',
  `typeid` varchar(255) NOT NULL,
  `product` mediumtext NOT NULL,
  `regtime` int(10) unsigned NOT NULL default '0',
  `areaid` int(10) unsigned NOT NULL default '0',
  `employnum` varchar(50) NOT NULL,
  `turnover` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL default '0',
  `sitedomain` varchar(255) default NULL,
  `logo` varchar(255) NOT NULL,
  `banner` varchar(255) NOT NULL,
  `background` varchar(255) NOT NULL,
  `linkman` varchar(50) NOT NULL,
  `telephone` varchar(50) NOT NULL,
  `fax` varchar(50) NOT NULL,
  `postid` varchar(6) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `homepage` varchar(255) NOT NULL,
  `introduce` mediumtext NOT NULL,
  `elite` tinyint(1) unsigned NOT NULL default '0',
  `templateid` varchar(100) NOT NULL,
  `menu` text NOT NULL,
  `addtime` int(10) unsigned NOT NULL default '0',
  `checker` varchar(20) NOT NULL,
  `checktime` int(10) unsigned NOT NULL default '0',
  `editor` varchar(20) NOT NULL,
  `edittime` int(10) unsigned NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL,
  `hits` int(10) unsigned NOT NULL default '0',
  `map` varchar(255) NOT NULL,
  `vip` int(10) unsigned NOT NULL default '0',
  `my_yplink` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`companyid`),
  UNIQUE KEY `username` (`username`),
  KEY `sitedomain` (`sitedomain`),
  KEY `hits` (`hits`,`status`,`companyid`),
  KEY `typeid` (`typeid`,`status`,`listorder`,`companyid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_apply`;
CREATE TABLE IF NOT EXISTS `phpcms_yp_apply` (
  `applyid` int(11) unsigned NOT NULL auto_increment,
  `station` varchar(200) NOT NULL,
  `experience` varchar(20) NOT NULL,
  `worktype` varchar(10) NOT NULL,
  `pay` int(8) unsigned NOT NULL,
  `linkman` varchar(20) NOT NULL,
  `introduce` mediumtext NOT NULL,
  `story` mediumtext NOT NULL,
  `status` tinyint(1) NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL,
  `username` varchar(20) NOT NULL,
  `hits` int(10) unsigned NOT NULL default '0',
  `listorder` int(10) unsigned NOT NULL,
  `addtime` int(10) unsigned NOT NULL default '0',
  `editor` varchar(20) NOT NULL,
  `edittime` int(10) unsigned NOT NULL default '0',
  `graduatetime` varchar(50) NOT NULL,
  `school` varchar(255) NOT NULL,
  `specialty` varchar(255) NOT NULL,
  `area` varchar(255) NOT NULL,
  `period` smallint(3) unsigned NOT NULL,
  PRIMARY KEY  (`applyid`),
  UNIQUE KEY `username` (`username`),
  KEY `station` (`station`,`status`,`listorder`,`applyid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_article`;
CREATE TABLE IF NOT EXISTS `phpcms_yp_article` (
  `articleid` int(10) unsigned NOT NULL auto_increment,
  `catid` smallint(5) unsigned NOT NULL default '0',
  `companyid` int(10) unsigned NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `style` varchar(50) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `keywords` varchar(100) NOT NULL default '',
  `hits` int(10) unsigned NOT NULL default '0',
  `comments` int(10) unsigned NOT NULL default '0',
  `thumb` varchar(255) NOT NULL default '',
  `username` varchar(20) NOT NULL default '',
  `addtime` int(10) unsigned NOT NULL default '0',
  `editor` varchar(25) NOT NULL default '',
  `edittime` int(10) unsigned NOT NULL default '0',
  `checker` varchar(25) NOT NULL default '',
  `checktime` int(10) unsigned NOT NULL default '0',
  `arrposid` varchar(50) NOT NULL default '',
  `status` tinyint(1) NOT NULL default '0',
  `listorder` smallint(4) unsigned NOT NULL default '0',
  `islink` tinyint(1) unsigned NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`articleid`),
  KEY `catid` (`catid`,`status`,`listorder`,`articleid`),
  KEY `username` (`username`(10)),
  KEY `hits` (`status`,`hits`,`articleid`),
  KEY `companyid` (`companyid`,`articleid`,`status`,`listorder`),
  FULLTEXT KEY `keywords` (`keywords`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_guestbook`;
CREATE TABLE `phpcms_yp_guestbook` (
  `gid` int(11) unsigned NOT NULL auto_increment,
  `companyid` int(10) unsigned NOT NULL default '0',
  `itemid` int(11) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL,
  `fax` varchar(100) NOT NULL,
  `telephone` varchar(100) NOT NULL,
  `qq` int(10) unsigned NOT NULL default '0',
  `unit` varchar(255) NOT NULL,
  `msn` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `content` mediumtext NOT NULL,
  `status` tinyint(1) unsigned NOT NULL default '0',
  `label` varchar(255) NOT NULL,
  `addtime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gid`),
  KEY `companyid` (`companyid`,`status`,`gid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_job`;
CREATE TABLE IF NOT EXISTS `phpcms_yp_job` (
  `jobid` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `style` varchar(100) NOT NULL,
  `station` varchar(200) NOT NULL,
  `employ` int(6) unsigned NOT NULL,
  `experience` varchar(20) NOT NULL,
  `worktype` varchar(10) NOT NULL,
  `sex` tinyint(1) unsigned NOT NULL,
  `degree` varchar(10) NOT NULL,
  `pay` int(8) unsigned NOT NULL,
  `areaid` int(10) unsigned NOT NULL default '0',
  `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,
  `introduce` mediumtext NOT NULL,
  `period` int(4) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL,
  `companyid` int(11) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL,
  `hits` int(10) unsigned NOT NULL default '0',
  `listorder` int(10) unsigned NOT NULL,
  `addtime` int(10) unsigned NOT NULL default '0',
  `checker` varchar(20) NOT NULL,
  `checktime` int(10) unsigned NOT NULL default '0',
  `editor` varchar(20) NOT NULL,
  `edittime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`jobid`),
  KEY `label` (`status`,`jobid`),
  KEY `listorder` (`listorder`,`status`,`jobid`),
  KEY `hits` (`hits`,`status`,`jobid`),
  KEY `username` (`username`(10)),
  KEY `companyid` (`companyid`,`status`,`listorder`,`jobid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_yp_product`;
CREATE TABLE IF NOT EXISTS `phpcms_yp_product` (
  `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,
  `model` varchar(255) NOT NULL,