?-- MySQL Administrator dump 1.4---- -------------------------------------------------------- Server version	5.0.24a-community-nt/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;---- Definition of table `ejf_admin_log`--DROP TABLE IF EXISTS `ejf_admin_log`;CREATE TABLE `ejf_admin_log` (  `logID` int(11) NOT NULL auto_increment,  `userID` varchar(15) NOT NULL,  `groupName` varchar(15) NOT NULL,  `remoteIP` varchar(25) default NULL,  `action` varchar(10) NOT NULL,  `remark` varchar(40) default NULL,  `createTime` datetime default NULL,  PRIMARY KEY  (`logID`)) ENGINE=InnoDB DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_admin_log`--/*!40000 ALTER TABLE `ejf_admin_log` DISABLE KEYS */;/*!40000 ALTER TABLE `ejf_admin_log` ENABLE KEYS */;---- Definition of table `ejf_archive_reply`--DROP TABLE IF EXISTS `ejf_archive_reply`;CREATE TABLE `ejf_archive_reply` (  `replyID` int(11) NOT NULL default '0',  `topicID` int(11) NOT NULL,  `userID` varchar(15) NOT NULL,  `remoteIP` varchar(25) default NULL,  `title` varchar(100) default NULL,  `content` mediumtext NOT NULL,  `attaches` tinyint(4) default '0',  `isHidePost` char(1) default 'F',  `isBest` char(1) default 'F',  `state` char(1) default 'N',  `createTime` datetime default NULL,  `updateTime` timestamp NOT NULL default '0000-00-00 00:00:00') ENGINE=MyISAM DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_archive_reply`--/*!40000 ALTER TABLE `ejf_archive_reply` DISABLE KEYS */;/*!40000 ALTER TABLE `ejf_archive_reply` ENABLE KEYS */;---- Definition of table `ejf_archive_topic`--DROP TABLE IF EXISTS `ejf_archive_topic`;CREATE TABLE `ejf_archive_topic` (  `topicID` int(11) NOT NULL default '0',  `boardID` int(11) NOT NULL,  `sectionID` int(11) default '0',  `userID` varchar(15) NOT NULL,  `nickname` varchar(15) default NULL,  `remoteIP` varchar(25) default NULL,  `title` varchar(100) NOT NULL,  `content` mediumtext,  `reward` smallint(6) default '0',  `visits` int(11) default '0',  `replies` int(11) default '0',  `attaches` tinyint(4) default '0',  `attachIcon` varchar(5) default NULL,  `lastPostUser` varchar(15) NOT NULL,  `lastNickname` varchar(15) default NULL,  `lastPostTime` datetime default NULL,  `isDigest` char(1) default 'F',  `isReplyNotice` char(1) default 'F',  `isHidePost` char(1) default 'F',  `isSolved` char(1) default 'F',  `topScope` char(1) default 'N',  `topExpireDate` datetime default NULL,  `highColor` varchar(6) default NULL,  `highExpireDate` datetime default NULL,  `state` char(1) default 'N',  `createTime` datetime default NULL,  `updateTime` timestamp NOT NULL default '0000-00-00 00:00:00',  `updateUser` varchar(15) default NULL) ENGINE=MyISAM DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_archive_topic`--/*!40000 ALTER TABLE `ejf_archive_topic` DISABLE KEYS */;/*!40000 ALTER TABLE `ejf_archive_topic` ENABLE KEYS */;---- Definition of table `ejf_attach`--DROP TABLE IF EXISTS `ejf_attach`;CREATE TABLE `ejf_attach` (  `attachID` int(11) NOT NULL auto_increment,  `topicID` int(11) NOT NULL,  `replyID` int(11) default '0',  `userID` varchar(15) NOT NULL,  `localname` varchar(50) NOT NULL,  `localID` smallint(6) default '0',  `filename` varchar(50) NOT NULL,  `filesize` int(11) default '0',  `credits` int(11) default '0',  `title` varchar(50) default NULL,  `downloads` int(11) default '0',  `state` char(1) default 'N',  `createTime` datetime default NULL,  `updateTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  PRIMARY KEY  (`attachID`),  KEY `topicID` (`topicID`),  CONSTRAINT `ejf_attach_ibfk_1` FOREIGN KEY (`topicID`) REFERENCES `ejf_topic` (`topicID`) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_attach`--/*!40000 ALTER TABLE `ejf_attach` DISABLE KEYS */;/*!40000 ALTER TABLE `ejf_attach` ENABLE KEYS */;---- Definition of table `ejf_backup_task`--DROP TABLE IF EXISTS `ejf_backup_task`;CREATE TABLE `ejf_backup_task` (  `taskID` int(11) NOT NULL auto_increment,  `inputFile` varchar(255) NOT NULL,  `outputFile` varchar(255) NOT NULL,  `runAt` char(1) default 'N',  `sendmail` char(1) default 'T',  `runMode` char(1) default 'A',  `isOnlyFile` char(1) default 'T',  `runStamp` varchar(20) default NULL,  `remark` varchar(50) default NULL,  `createTime` datetime default NULL,  PRIMARY KEY  (`taskID`)) ENGINE=InnoDB DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_backup_task`--/*!40000 ALTER TABLE `ejf_backup_task` DISABLE KEYS */;/*!40000 ALTER TABLE `ejf_backup_task` ENABLE KEYS */;---- Definition of table `ejf_board`--DROP TABLE IF EXISTS `ejf_board`;CREATE TABLE `ejf_board` (  `boardID` int(11) NOT NULL auto_increment,  `sectionID` int(11) NOT NULL,  `boardName` varchar(20) NOT NULL,  `highColor` varchar(6) default NULL,  `seqno` int(11) default '1',  `brief` varchar(100) default NULL,  `keywords` varchar(100) default NULL,  `moderator` varchar(60) default NULL,  `viewStyle` varchar(20) default NULL,  `sortField` varchar(20) default NULL,  `isImageOK` char(1) default 'T',  `isMediaOK` char(1) default 'F',  `isGuestPostOK` char(1) default 'F',  `allowGroups` varchar(20) default NULL,  `acl` varchar(100) default NULL,  `ruleCode` text,  `headAdCode` text,  `footAdCode` text,  `state` char(1) default 'N',  `createTime` datetime default NULL,  `updateTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  PRIMARY KEY  (`boardID`),  KEY `sectionID` (`sectionID`),  CONSTRAINT `ejf_board_ibfk_1` FOREIGN KEY (`sectionID`) REFERENCES `ejf_section` (`sectionID`)) ENGINE=InnoDB DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_board`--/*!40000 ALTER TABLE `ejf_board` DISABLE KEYS */;INSERT INTO `ejf_board` (`boardID`,`sectionID`,`boardName`,`highColor`,`seqno`,`brief`,`keywords`,`moderator`,`viewStyle`,`sortField`,`isImageOK`,`isMediaOK`,`isGuestPostOK`,`allowGroups`,`acl`,`ruleCode`,`headAdCode`,`footAdCode`,`state`,`createTime`,`updateTime`) VALUES  (1,1,'默認(rèn)版塊',NULL,1,'',NULL,NULL,NULL,NULL,'T','F','F','AMSG1234567','',NULL,NULL,NULL,'N','2008-08-19 17:12:54','2008-08-19 17:12:54'), (2,2,'論壇公告',NULL,1,'論壇公告發(fā)布，版主任免，管理與獎(jiǎng)懲決定公布等',NULL,NULL,NULL,NULL,'T','F','F','AMSG1234567','F_AMS',NULL,NULL,NULL,'N','2008-08-19 17:12:54','2008-08-19 17:12:54'), (3,2,'站務(wù)管理',NULL,2,'意見、建議發(fā)表，系統(tǒng)BUG報(bào)告等',NULL,NULL,NULL,NULL,'T','F','F','AMSG1234567','',NULL,NULL,NULL,'N','2008-08-19 17:12:54','2008-08-19 17:12:54');/*!40000 ALTER TABLE `ejf_board` ENABLE KEYS */;---- Definition of table `ejf_bookmark`--DROP TABLE IF EXISTS `ejf_bookmark`;CREATE TABLE `ejf_bookmark` (  `markID` int(11) NOT NULL auto_increment,  `userID` varchar(15) NOT NULL,  `url` varchar(100) NOT NULL,  `title` varchar(100) NOT NULL,  `boardName` varchar(20) default NULL,  `createTime` datetime default NULL,  PRIMARY KEY  (`markID`),  KEY `userID` (`userID`),  CONSTRAINT `ejf_bookmark_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `ejf_user` (`userID`) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_bookmark`--/*!40000 ALTER TABLE `ejf_bookmark` DISABLE KEYS */;/*!40000 ALTER TABLE `ejf_bookmark` ENABLE KEYS */;---- Definition of table `ejf_censor_log`--DROP TABLE IF EXISTS `ejf_censor_log`;CREATE TABLE `ejf_censor_log` (  `logID` int(11) NOT NULL auto_increment,  `userID` varchar(15) default NULL,  `boardID` int(11) NOT NULL,  `boardName` varchar(20) NOT NULL,  `topicID` int(11) NOT NULL,  `topicTitle` varchar(100) NOT NULL,  `replyID` int(11) default '0',  `reason` varchar(40) NOT NULL,  `createTime` datetime default NULL,  PRIMARY KEY  (`logID`)) ENGINE=InnoDB DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_censor_log`--/*!40000 ALTER TABLE `ejf_censor_log` DISABLE KEYS */;/*!40000 ALTER TABLE `ejf_censor_log` ENABLE KEYS */;---- Definition of table `ejf_credits_log`--DROP TABLE IF EXISTS `ejf_credits_log`;CREATE TABLE `ejf_credits_log` (  `logID` int(11) NOT NULL auto_increment,  `userID` varchar(15) NOT NULL,  `fromUser` varchar(15) default NULL,  `credits` smallint(6) default '0',  `action` varchar(10) NOT NULL,  `createTime` datetime default NULL,  PRIMARY KEY  (`logID`)) ENGINE=InnoDB DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_credits_log`--/*!40000 ALTER TABLE `ejf_credits_log` DISABLE KEYS */;/*!40000 ALTER TABLE `ejf_credits_log` ENABLE KEYS */;---- Definition of table `ejf_error_log`--DROP TABLE IF EXISTS `ejf_error_log`;CREATE TABLE `ejf_error_log` (  `logID` int(11) NOT NULL auto_increment,  `userID` varchar(15) NOT NULL,  `remoteIP` varchar(25) default NULL,  `action` varchar(10) NOT NULL,  `errorInfo` varchar(100) default NULL,  `createTime` datetime default NULL,  PRIMARY KEY  (`logID`)) ENGINE=InnoDB DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_error_log`--/*!40000 ALTER TABLE `ejf_error_log` DISABLE KEYS */;/*!40000 ALTER TABLE `ejf_error_log` ENABLE KEYS */;---- Definition of table `ejf_friend`--DROP TABLE IF EXISTS `ejf_friend`;CREATE TABLE `ejf_friend` (  `userID` varchar(15) NOT NULL,  `friendID` varchar(15) NOT NULL,  `remark` varchar(50) default NULL,  `createTime` datetime default NULL,  PRIMARY KEY  (`userID`,`friendID`),  KEY `userID` (`userID`),  CONSTRAINT `ejf_friend_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `ejf_user` (`userID`) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=gbk;---- Dumping data for table `ejf_friend`--