mysql.sql

phpcms2007很好的cms内容管理系统,操作方便

INSERT INTO `phpcms_module` (`name`, `module`, `moduledir`, `moduledomain`, `iscore`, `iscopy`, `isshare`, `version`, `author`, `site`, `email`, `introduce`, `license`, `faq`, `setting`, `disabled`, `publishdate`, `installdate`, `updatedate`) VALUES ('采集', 'spider', 'spider', '', 0, 0, 0, '1.0.0', 'phpcms', 'http://www.phpcms.cn', '[e-mail]', '<p>采集</p>', '', '', '', 0, '0000-00-00', '0000-00-00', '0000-00-00');
DROP TABLE IF EXISTS `phpcms_spider_job`;
CREATE TABLE `phpcms_spider_job` (
  `JobId` int(11) unsigned NOT NULL auto_increment,
  `SiteId` int(8) NOT NULL default '0',
  `JobName` varchar(100) NOT NULL default '',
  `JobDescription` text NOT NULL,
  `StartUrl` text NOT NULL,
  `SpiderStep` tinyint(1) NOT NULL default '0',
  `UseSpecialLink` tinyint(1) NOT NULL default '0',
  `ScriptLink` varchar(250) NOT NULL default '',
  `TrueLink` varchar(250) NOT NULL default '',
  `ListPageMust` varchar(100) NOT NULL default '',
  `ListPageForbid` varchar(100) NOT NULL default '',
  `ContentPageMust` varchar(100) NOT NULL default '',
  `ContentPageForbid` varchar(100) NOT NULL default '',
  `ListUrlStart` text NOT NULL,
  `ListUrlEnd` text NOT NULL,
  `Cookie` text NOT NULL,
  `DividePageStyle` tinyint(1) NOT NULL default '0',
  `DividePageStart` text NOT NULL,
  `DividePageEnd` text NOT NULL,
  `SourceEncode` tinyint(1) NOT NULL default '0',
  `LabelCycle` tinyint(1) NOT NULL default '0',
  `TestPageUrl` varchar(250) NOT NULL default '',
  `DownImg` tinyint(1) NOT NULL default '0',
  `DownSwf` tinyint(1) NOT NULL default '0',
  `DownOther` tinyint(1) NOT NULL default '0',
  `OtherFileType` varchar(200) NOT NULL default '',
  `ThreadNum` int(5) NOT NULL default '0',
  `ThreadRequest` int(5) NOT NULL default '0',
  `ThreadSleep` int(8) NOT NULL default '0',
  `TimeOut` int(5) NOT NULL default '0',
  `CreateOn` int(11) NOT NULL default '0',
  `UpdateOn` int(11) NOT NULL default '0',
  PRIMARY KEY  (`JobId`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `phpcms_spider_out`;
CREATE TABLE `phpcms_spider_out` (
  `Id` int(11) unsigned NOT NULL auto_increment,
  `CMS` varchar(50) NOT NULL default '',
  `Field` varchar(100) NOT NULL default '',
  `Description` varchar(250) NOT NULL default '',
  `UserValue` text NOT NULL,
  `DefaultValue` varchar(250) NOT NULL default '',
  `Label` text NOT NULL,
  `Hidden` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`Id`)
) TYPE=MyISAM ;

INSERT INTO `phpcms_spider_out` ( `CMS`, `Field`, `Description`, `UserValue`, `DefaultValue`, `Label`, `Hidden`) VALUES ( 'article', 'articleid', '文章ID(自动生成)', '自动生成', '自动生成', '<input style="width:220px;height:20px;" id="textUinarticleid" name="art[articleid]"  readonly >\r\n<span style="position:absolute;margin:1px 1px 1px -6px">\r\n<select style="margin-left:-202px;width:220px;" id="uinSelectorarticleid" onchange="document.getElementById(''textUinarticleid'').value=value;"  disabled ></select></span>', 1);
INSERT INTO `phpcms_spider_out` ( `CMS`, `Field`, `Description`, `UserValue`, `DefaultValue`, `Label`, `Hidden`) VALUES ( 'article', 'title', '文章标题', '[标签:标题]', '[标签:标题]', '<input style="width:220px;height:20px;"   id="textUintitle" name="art[title]" >\r\n<span style="position:absolute;margin:1px 1px 1px -6px">\r\n<select style="margin-left:-202px;width:220px;" id="uinSelectortitle" onchange="document.getElementById(''textUintitle'').value=value;">\r\n<option selected>---手动填写或选择下拉列表---</option>\r\n[采集生成标签]</select></span>', 0);