installsql.php

小蜜蜂商务网站门户系统(BBWPS)平台系统 v1.0 Build 061113

<?PHP
$sql= "
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."article`;
CREATE TABLE `".$prefix.$modulePrefix."article` (
  `articleid` int(11) NOT NULL auto_increment,
  `catid` smallint(6) NOT NULL default '0',
  `specialid` smallint(6) NOT NULL default '0',
  `cid` smallint(6) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `keywords` varchar(255) NOT NULL default '',
  `author` varchar(50) NOT NULL default '',
  `copyfromname` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `hits` smallint(6) NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL default '',
  `addtime` int(10) NOT NULL default '0',
  `status` smallint(1) NOT NULL default '0',
  `isquik` smallint(1) NOT NULL default '1',
  `img_url` varchar(255) NOT NULL default '',
  `hasimg` smallint(1) NOT NULL default '0',
  `isview` smallint(1) NOT NULL default '1',
  `inter` int(10) NOT NULL default '0',
  `recommend` smallint(1) NOT NULL default '0',
  `catid_f` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`articleid`),
  KEY `catid` (`catid`),
  KEY `catid_f` (`catid_f`),
  KEY `hasimg` (`hasimg`)
) TYPE=MyISAM COMMENT='文章基本表' AUTO_INCREMENT=1;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."category`;
CREATE TABLE `".$prefix.$modulePrefix."category` (
  `cid` smallint(8) unsigned NOT NULL auto_increment,
  `cname` varchar(200) NOT NULL default '',
  `csort` int(2) NOT NULL default '1',
  `cparent` smallint(8) default '0',
  `mid` smallint(1) NOT NULL default '1',
  PRIMARY KEY  (`cid`)
) TYPE=MyISAM COMMENT='保存站点信息' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."changedruler`;
CREATE TABLE `".$prefix.$modulePrefix."changedruler` (
  `cid` smallint(6) NOT NULL default '0',
  `intime` int(10) NOT NULL default '0'
) TYPE=MyISAM COMMENT='保存失效的规则';
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."frontcat`;
CREATE TABLE `".$prefix.$modulePrefix."frontcat` (
  `catid` smallint(6) NOT NULL auto_increment,
  `fname` varchar(20) NOT NULL default '',
  `fsort` smallint(1) NOT NULL default '1',
  `fparent` smallint(6) NOT NULL default '0',
  `isurl` smallint(1) NOT NULL default '0',
  `url` varchar(255) default NULL,
  `template` varchar(255) default NULL,
  `isadd` smallint(1) NOT NULL default '0',
  `isview` smallint(2) NOT NULL default '1',
  `keyword` TEXT NOT NULL,
  PRIMARY KEY  (`catid`)
) TYPE=MyISAM COMMENT='文章前台分类频道' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."loadurl`;
CREATE TABLE `".$prefix.$modulePrefix."loadurl` (
  `uid` smallint(8) unsigned NOT NULL auto_increment,
  `cid` smallint(8) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '0',
  `url` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM COMMENT='保存已经采集的连接' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."message`;
CREATE TABLE `".$prefix.$modulePrefix."message` (
  `mid` smallint(8) unsigned NOT NULL auto_increment,
  `cid` smallint(8) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `imglink` varchar(200) NOT NULL default '',
  `flashlink` varchar(200) NOT NULL default '',
  `content` text NOT NULL,
  `author` varchar(50) NOT NULL default '',
  `addtime` int(10) NOT NULL default '0',
  `sourse` varchar(100) NOT NULL default '',
  `haveimg` smallint(1) NOT NULL default '0',
  `haveflash` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`mid`)
) TYPE=MyISAM COMMENT='保存采集内容' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."ruler`;
CREATE TABLE `".$prefix.$modulePrefix."ruler` (
  `rid` smallint(6) NOT NULL auto_increment,
  `cid` smallint(8) NOT NULL default '0',
  `title` text NOT NULL,
  `content` text NOT NULL,
  `inner_page` text,
  `outer_url` text NOT NULL,
  `filtrate_str` text,
  `img_dir` varchar(50) default NULL,
  `iscreatedir` smallint(1) NOT NULL default '0',
  `flash_dir` varchar(50) default NULL,
  `author` text,
  `sourse` text,
  `outurlrang` varchar(10) default NULL,
  `step` smallint(1) default '1',
  `link` text NOT NULL,
  `channelid` smallint(4) default '1',
  `catid` smallint(4) default '1',
  `specialid` smallint(4) default '0',
  `status` smallint(1) default '1',
  `setupdate` text,
  `cookie` text,
  `referer` varchar(100) default NULL,
  `replace_sr` text,
  `replace_tg` text,
  `isutf8` smallint(1) NOT NULL default '0',
  `floor` smallint(2) NOT NULL default '0',
  `metatime` smallint(2) NOT NULL default '0',
  `linkReplaceS` varchar(50) default NULL,
  `linkReplaceT` varchar(50) default NULL,
  `innerReplaceS` varchar(50) default NULL,
  `innerReplaceT` varchar(50) default NULL,
  `tags` text,
  `addPosition` smallint(1) default '0',
  `addString` text,
  `keyword` varchar(255) default NULL,
  `iscontent` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`rid`),
  KEY `cid` (`cid`)
) TYPE=MyISAM COMMENT='保存栏目规则' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."special`;
CREATE TABLE `".$prefix.$modulePrefix."special` (
  `sid` smallint(6) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `pictrue` varchar(200) NOT NULL default '',
  `introduce` text NOT NULL,
  `addtime` int(10) NOT NULL default '0',
  `start` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`sid`)
) TYPE=MyISAM COMMENT='文章前台专题' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."update`;
CREATE TABLE `".$prefix.$modulePrefix."update` (
  `upid` smallint(8) unsigned NOT NULL auto_increment,
  `cid` smallint(8) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `keyword` varchar(100) default NULL,
  `ifget` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`upid`),
  UNIQUE KEY `url` (`url`)
) TYPE=MyISAM COMMENT='需要更新的记录' AUTO_INCREMENT=1;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."editor`;
CREATE TABLE `".$prefix.$modulePrefix."editor` (
  `editorid` smallint(4) NOT NULL auto_increment,
  `editorname` varchar(100) NOT NULL default '',
  `eparent` smallint(4) NOT NULL default '0',
  `epermit` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`editorid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."member`;
CREATE TABLE `".$prefix.$modulePrefix."member` (
  `uid` varchar(40) NOT NULL default '',
  `roleid` smallint(2) default '0',
  `editorid` smallint(2) default '0',
  `template` varchar(20) default 'template',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM COMMENT='文章用户的登记信息';
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."role`;
CREATE TABLE `".$prefix.$modulePrefix."role` (
  `roleid` smallint(4) NOT NULL auto_increment,
  `rolename` varchar(20) NOT NULL default '',
  `rpermit` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`roleid`)
) TYPE=MyISAM COMMENT='角色定义表' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."rss`;
CREATE TABLE `".$prefix.$modulePrefix."rss` (
  `rssid` int(11) NOT NULL auto_increment,
  `catid` smallint(6) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `linkurl` varchar(255) NOT NULL default '',
  `addtime` int(10) NOT NULL default '0',
  `status` smallint(1) NOT NULL default '1',
  `uptime` int(10) default NULL,
  `author` varchar(60) NOT NULL default 'admin',
  PRIMARY KEY  (`rssid`)
) TYPE=MyISAM COMMENT='文章基本表' AUTO_INCREMENT=1;
DROP TABLE IF EXISTS `".$prefix.$modulePrefix."rssarticle`;
CREATE TABLE `".$prefix.$modulePrefix."rssarticle` (
  `rssarticleid` int(11) NOT NULL auto_increment,
  `catid` smallint(6) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `hits` smallint(6) NOT NULL default '0',
  `linkurl` varchar(255) NOT NULL default '',
  `addtime` int(10) NOT NULL default '0',
  `status` smallint(1) NOT NULL default '0',
  `img_url` varchar(255) NOT NULL default '',
  `hasimg` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`rssarticleid`)
) TYPE=MyISAM COMMENT='文章基本表' AUTO_INCREMENT=1 ;
"
?>