installsql.php

在传统CMS文章内容管理功能基础上

<?php
$sql= "
DROP TABLE IF EXISTS `{$prefix}user`;
CREATE TABLE `{$prefix}user` (
  `id` smallint(11) NOT NULL auto_increment,
  `user` varchar(50) NOT NULL default '',
  `pwd` varchar(50) NOT NULL default '',
  `popedom` text NOT NULL,
  `admingroupid` text NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
DROP TABLE IF EXISTS `{$prefix}members`;
CREATE TABLE `{$prefix}members` (
  `uid` mediumint(8) unsigned NOT NULL auto_increment,
  `username` varchar(15) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `regip` varchar(15) NOT NULL default '',
  `regdate` int(10) unsigned NOT NULL default '0',
  `lastip` varchar(15) NOT NULL default '',
  `lastvisit` int(10) unsigned NOT NULL default '0',
  `oltime` smallint(6) unsigned NOT NULL default '0',
  `online` smallint(1) NOT NULL default '0',
  `onlinetime` int(10) unsigned NOT NULL default '0',
  `credits` double(9,1) NOT NULL default '0.0',
  `available` smallint(1) NOT NULL default '0',
  `reason` text NOT NULL,
  `regctrl` smallint(1) NOT NULL default '0',
  `email` varchar(30) NOT NULL default '',
  `validate` tinyint(1) NOT NULL default '0',
  `messprotect` tinyint(1) NOT NULL default '0',
  `newmess` tinyint(1) NOT NULL default '0',
  `newvalidate` tinyint(1) NOT NULL default '0',
  `delmess` char(1) NOT NULL default '',
  `cashpwd` varchar(64) NOT NULL default '',
  `vipnum` smallint(10) NOT NULL default '-1',
  `vipwait` smallint(1) NOT NULL default '0',
  `paycheck` varchar(255) NOT NULL default '',
  `module` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=1;
DROP TABLE IF EXISTS `{$prefix}advertisements`;
CREATE TABLE `{$prefix}advertisements` (
  `adid` mediumint(8) unsigned NOT NULL auto_increment,
  `available` tinyint(1) NOT NULL default '0',
  `type` varchar(50) NOT NULL default '0',
  `adaddress` varchar(20) NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `targets` text NOT NULL,
  `adtag` text NOT NULL,
  `code` text NOT NULL,
  `starttime` int(10) unsigned NOT NULL default '0',
  `endtime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`adid`)
) TYPE=MyISAM AUTO_INCREMENT=1;
DROP TABLE IF EXISTS `{$prefix}forbidip`;
CREATE TABLE `{$prefix}forbidip` (
  `fiid` int(10) NOT NULL auto_increment,
  `forbidip` varchar(15) NOT NULL default '0',
  `forbidtime` int(10) NOT NULL default '0',
  `forbid` smallint(1) NOT NULL default '0',
  `overtime` int(10) NOT NULL default '0',
  PRIMARY KEY  (`fiid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}pm`;
CREATE TABLE `{$prefix}pm` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `from` varchar(20) NOT NULL default '',
  `to` varchar(20) NOT NULL default '0',
  `posttime` int(10) unsigned NOT NULL default '0',
  `title` varchar(75) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `frombox` tinyint(4) default NULL,
  `new` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`pid`),
  KEY `from` (`from`),
  KEY `to` (`to`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}friend`;
CREATE TABLE `{$prefix}friend` (
  `friendid` smallint(8) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `friendname` varchar(20) NOT NULL default '',
  `addtime` int(10) NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `validatetype` tinyint(1) NOT NULL default '0',
  `annexmess` text NOT NULL,
  PRIMARY KEY  (`friendid`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}pmbox`;
CREATE TABLE `{$prefix}pmbox` (
  `pbid` int(10) unsigned NOT NULL auto_increment,
  `from` varchar(20) NOT NULL default '',
  `to` varchar(20) NOT NULL default '0',
  `posttime` int(10) unsigned NOT NULL default '0',
  `title` varchar(75) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `new` tinyint(1) NOT NULL default '1',
  `system` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`pbid`),
  KEY `from` (`from`),
  KEY `to` (`to`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}bank`;
CREATE TABLE `{$prefix}bank` (
  `bid` smallint(2) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `person` varchar(10) NOT NULL default '',
  `count` varchar(20) NOT NULL default '',
  `bank` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`bid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `{$prefix}track` (
  `tid` int(10) NOT NULL auto_increment,
  `pcardid` varchar(30) NOT NULL default '',
  `trade_no` varchar(30) NOT NULL default '',
  `mony` double(4,2) NOT NULL default '0.00',
  `state` smallint(1) NOT NULL default '0',
  `start_time` int(10) NOT NULL default '0',
  `bid` smallint(2) NOT NULL default '0',
  `count` varchar(30) NOT NULL default '',
  `bank` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`tid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}bankcard`;
CREATE TABLE `{$prefix}bankcard` (
  `bankid` int(8) NOT NULL auto_increment,
  `uid` smallint(8) default '0',
  `count` varchar(30) NOT NULL default '',
  `password` varchar(32) default NULL,
  `mony` double(6,2) default NULL,
  `date` smallint(4) default NULL,
  `time` int(10) default '0',
  `type` smallint(1) NOT NULL default '1',
  `status` smallint(1) NOT NULL default '1',
  `reason` varchar(200) default NULL,
  PRIMARY KEY  (`bankid`),
  KEY `uid` (`uid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}paycard`;
CREATE TABLE `{$prefix}paycard` (
  `pcardid` int(8) NOT NULL auto_increment,
  `uid` int(8) NOT NULL default '0',
  `bid` int(8) NOT NULL default '0',
  `count` varchar(30) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `mony` double(4,2) NOT NULL default '0.00',
  `date` smallint(4) NOT NULL default '0',
  `time` int(10) NOT NULL default '0',
  `payid` smallint(2) NOT NULL default '0',
  `type` smallint(1) NOT NULL default '1',
  `status` smallint(1) NOT NULL default '0',
  `state` smallint(1) NOT NULL default '0',
  `settime` int(10) default '0',
  PRIMARY KEY  (`pcardid`),
  KEY `uid` (`uid`,`bid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}alipay`;
CREATE TABLE `{$prefix}alipay` (
  `alipayid` int(11) NOT NULL auto_increment,
  `pcardid` int(8) NOT NULL default '0',
  `value` varchar(64) NOT NULL default '',
  `out_trade_no` varchar(64) NOT NULL default '',
  `trade_status` varchar(64) NOT NULL default '',
  `tradestarttime` int(10) NOT NULL default '0',
  `tradendtime` int(10) NOT NULL default '0',
  PRIMARY KEY  (`alipayid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}bill`;
CREATE TABLE `{$prefix}bill` (
  `billid` int(8) NOT NULL auto_increment,
  `bankid` int(8) NOT NULL default '0',
  `uid` int(8) NOT NULL default '0',
  `mony` double(4,2) NOT NULL default '0.00',
  `realmony` double(4,2) NOT NULL default '0.00',
  `time` int(10) NOT NULL default '0',
  `state` smallint(1) NOT NULL default '0',
  `save` smallint(1) NOT NULL default '0',
  `person` varchar(20) default NULL,
  `count` varchar(30) default NULL,
  `bank` varchar(200) default NULL,
  PRIMARY KEY  (`billid`),
  KEY `uid` (`uid`),
  KEY `bankid` (`bankid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}outcome`;
CREATE TABLE `{$prefix}outcome` (
  `outid` mediumint(8) NOT NULL auto_increment,
  `uid` int(8) NOT NULL default '0',
  `type` smallint(1) NOT NULL default '1',
  `mony` double(4,2) NOT NULL default '0.00',
  `time` int(10) NOT NULL default '0',
  `url` varchar(200) NOT NULL default '0',
  PRIMARY KEY  (`outid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}paytype`;
CREATE TABLE `{$prefix}paytype` (
  `payid` smallint(2) NOT NULL auto_increment,
  `name` varchar(20) default NULL,
  `type` smallint(1) NOT NULL default '1',
  `num` int(8) NOT NULL default '0',
  `has` int(8) NOT NULL default '0',
  `mony` double(4,2) NOT NULL default '0.00',
  `date` smallint(4) NOT NULL default '0',
  `one` smallint(4) NOT NULL default '0',
  PRIMARY KEY  (`payid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `{$prefix}cbase`;
CREATE TABLE `{$prefix}cbase` (
  `cbaseid` smallint(4) NOT NULL auto_increment,
  `cbasename` varchar(20) NOT NULL default '',
  `pcbaseid` smallint(4) NOT NULL default '0',
  `nodeurl` varchar(50) NOT NULL default '',
  `nodetemplate` varchar(50) NOT NULL default '',
  `nodeuser` smallint(3) NOT NULL default '-1',
  `ordernum` smallint(4) NOT NULL default '0',
  PRIMARY KEY  (`cbaseid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `{$prefix}company`;
CREATE TABLE `{$prefix}company` (
  `username` varchar(15) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `linkman` varchar(30) NOT NULL default '',
  `phone` varchar(20) NOT NULL default '',
  `address` varchar(100) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `face` varchar(255) default NULL,
  PRIMARY KEY  (`username`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `{$prefix}groupfield`;
CREATE TABLE `{$prefix}groupfield` (
  `gfid` smallint(4) NOT NULL auto_increment,
  `fid` smallint(4) NOT NULL default '0',
  `pgid` smallint(4) NOT NULL default '0',
  `ispass` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`gfid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `{$prefix}memberfields`;
CREATE TABLE `{$prefix}memberfields` (
  `username` varchar(15) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `face` varchar(255) default NULL,
  PRIMARY KEY  (`username`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `{$prefix}module`;
CREATE TABLE `{$prefix}module` (
  `id` smallint(4) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL default '',
  `time` varchar(20) NOT NULL default '',
  `sort` smallint(2) NOT NULL default '99',
  `isstart` smallint(1) NOT NULL default '1',
  `isshow` smallint(1) NOT NULL default '1',
  `dns` varchar(200) NOT NULL default '',
  `regctrl` smallint(1) NOT NULL default '2',
  `idns` varchar(200) NOT NULL default '',
  `cbaseid` smallint(4) NOT NULL default '0',
  `modulepor` float(4,2) NOT NULL default '1.00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `dns` (`dns`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `{$prefix}permitgroup`;
CREATE TABLE `{$prefix}permitgroup` (
  `pgid` mediumint(3) NOT NULL auto_increment,
  `pgname` varchar(20) default NULL,
  `permit` text,
  `module` text NOT NULL,
  `descript` varchar(255) default NULL,
  `popen` mediumint(1) default NULL,
  `pgtype` varchar(20) NOT NULL default '',
  `ispass` smallint(1) NOT NULL default '1',
  `isreg` smallint(1) NOT NULL default '1',
  PRIMARY KEY  (`pgid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `{$prefix}setfield`;
CREATE TABLE `{$prefix}setfield` (
  `fid` smallint(2) NOT NULL auto_increment,
  `field` varchar(20) NOT NULL default '',
  `length` smallint(3) NOT NULL default '0',
  `isnull` smallint(1) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  `tablename` varchar(20) NOT NULL default '',
  `descript` varchar(20) NOT NULL default '',
  `input` varchar(20) NOT NULL default '',
  `value` text,
  `text` text,
  `isdefault` smallint(4) default '0',
  PRIMARY KEY  (`fid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
"
?>