mysql41_cms4j_create_table.sql

CMS4J 是 JAVA / JSP 版网站管理系统 （Content Manage System For Java）的简称

#
# Table Objects for table actions2
#

CREATE TABLE `actions2` (
  `ID` int(11) NOT NULL auto_increment,
  `ACT_NAME` varchar(40) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table actions2
#


#
# Table Objects for table announce
#

CREATE TABLE `announce` (
  `ID` int(11) NOT NULL auto_increment,
  `IS_SELECTED` int(11) default NULL,
  `TITLE` text NOT NULL,
  `CONTENT` longtext NOT NULL,
  `AUTHOR` varchar(30) NOT NULL default '',
  `ADD_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `CLASS_ID` int(11) NOT NULL default '0',
  `BEGIN_DATE` datetime default NULL,
  `END_DATE` datetime default NULL,
  `ANNOUNCE_TYPE` varchar(20) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table announce
#


#
# Table Objects for table announce_class
#

CREATE TABLE `announce_class` (
  `ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(100) NOT NULL default '',
  `REMARK` text,
  `ADD_AUTHOR` varchar(30) NOT NULL default '',
  `ADD_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table announce_class
#


#
# Table Objects for table article
#

CREATE TABLE `article` (
  `ID` int(11) NOT NULL auto_increment,
  `TITLE` varchar(200) NOT NULL default '',
  `CONTENT` longtext NOT NULL,
  `CLICKS` int(11) NOT NULL default '0',
  `AUTHOR` varchar(60) default NULL,
  `ADD_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `SOURCE` varchar(60) default NULL,
  `RELEASE_STATE` varchar(20) NOT NULL default '',
  `IS_COMMENT` varchar(10) default '0',
  `IS_DEL` varchar(10) default '0',
  `ACTION_ID` int(11) NOT NULL default '1',
  `RESTRICT_ID` int(11) NOT NULL default '1',
  `ARTICLE_CLASS_ID` varchar(60) NOT NULL default '',
  `SPECIAL_ID` varchar(60) NOT NULL default '',
  `PAGINATION_ID` int(11) NOT NULL default '0',
  `FRAME_TEMPLET_ID` int(11) NOT NULL default '0',
  `COLOR_TEMPLET_ID` int(11) NOT NULL default '0',
  `KEY_WORD` varchar(60) NOT NULL default '',
  `LINK_TO_EXTERIOR` varchar(200) default NULL,
  `HOMEPAGE_IMAGE` varchar(200) default NULL,
  `SAVE_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `IS_HOT` varchar(10) default NULL,
  `IS_ONTOP` varchar(10) default NULL,
  `IS_ELITE` varchar(10) default NULL,
  `IS_COMMEND` varchar(10) default NULL,
  `ADD_USER` varchar(20) NOT NULL default '',
  `SUMMARY` text,
  `CURR_AUDIT_LEVEL` int(11) NOT NULL default '1',
  `HTML_SAVE_PATH` text,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table article
#

#
# Table Objects for table article_class
#

CREATE TABLE `article_class` (
  `ARTICLE_CLASS_ID` varchar(60) NOT NULL default '',
  `CLASS_NAME` varchar(60) NOT NULL default '',
  `CLASS_REMARK` varchar(200) default NULL,
  `CLASS_TYPE` varchar(20) NOT NULL default '',
  `CLASS_STATE` int(11) NOT NULL default '0',
  `PARENT_ID` varchar(60) default NULL,
  `DEPTH` int(11) NOT NULL default '0',
  `RESTRICT_ID` int(11) NOT NULL default '0',
  `ACTION_ID` int(11) NOT NULL default '0',
  `REVIEW_RESTRICT_ID` int(11) NOT NULL default '0',
  `OUTSIDE_URL` varchar(100) default NULL,
  `ORDER_NUM` int(11) NOT NULL default '0',
  `ROOT_ID` varchar(60) NOT NULL default '',
  `PREV_ID` varchar(60) default NULL,
  `NEXT_ID` varchar(60) default NULL,
  `PATH` varchar(250) NOT NULL default '',
  `CLASS_NAME2` varchar(40) default NULL,
  `CUSTOM_LINK` varchar(200) default NULL,
  `IS_SHOW` int(11) default NULL,
  PRIMARY KEY  (`ARTICLE_CLASS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table article_class
#

#
# Table Objects for table article_color_templet
#

CREATE TABLE `article_color_templet` (
  `COLOR_TEMPLET_ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(30) default NULL,
  PRIMARY KEY  (`COLOR_TEMPLET_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table article_color_templet
#


#
# Table Objects for table article_pagination
#

CREATE TABLE `article_pagination` (
  `PAGINATION_ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(30) default NULL,
  `SIZE` int(11) default NULL,
  `PAGE_SYMBOL` varchar(60) default NULL,
  PRIMARY KEY  (`PAGINATION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table article_pagination
#


#
# Table Objects for table article_special
#

CREATE TABLE `article_special` (
  `SPECIAL_ID` varchar(60) NOT NULL default '',
  `NAME` varchar(60) NOT NULL default '',
  `STATE` int(11) NOT NULL default '0',
  `REMARK` varchar(200) default NULL,
  `ADD_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `ORDER_NUM` int(11) NOT NULL default '0',
  PRIMARY KEY  (`SPECIAL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table article_special
#


#
# Table Objects for table config_file_upload
#

CREATE TABLE `config_file_upload` (
  `ID` int(11) NOT NULL auto_increment,
  `CAN_UPLOAD_TYPE` text NOT NULL,
  `FILE_UPLOAD_DIR` varchar(50) NOT NULL default '',
  `FILE_UPLOAD_MAX_SIZE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table config_file_upload
#


#
# Table Objects for table config_site
#

CREATE TABLE `config_site` (
  `ID` int(11) NOT NULL auto_increment,
  `SITE_NAME` varchar(100) NOT NULL default '',
  `SITE_TITLE` varchar(200) NOT NULL default '',
  `SITE_URL` varchar(200) default NULL,
  `LOGO_URL` varchar(200) default NULL,
  `BANNER_URL` varchar(200) default NULL,
  `SITE_ADMIN` varchar(50) NOT NULL default '',
  `SITE_ADMIN_EMAIL` varchar(50) NOT NULL default '',
  `COPYRIGHT` text,
  `SessionLife` int(11) NOT NULL default '0',
  `CAN_CREATE_NU` varchar(20) default NULL,
  `NU_NEED_CHECK_EMAIL` varchar(20) default NULL,
  `NU_NEED_ADMIN_CHECK` varchar(20) default NULL,
  `TABOO_REGIST_UN` text,
  `SMTP_HOSTURL` varchar(200) default NULL,
  `SMTP_USER_NAME` varchar(50) default NULL,
  `SMTP_PASSWORLD` varchar(50) default NULL,
  `STMP_DOMAIN_NAME` varchar(200) default NULL,
  `STAT_BEGIN_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `SITE_COUNTER_SAVE_STEP` int(11) NOT NULL default '0',
  `ARTICLE_ISHOT_CLICKS` int(11) NOT NULL default '0',
  `CONTEXT_PATH` varchar(30) NOT NULL default '',
  `SITE_TEMPLET_PATH` varchar(200) default NULL,
  `ARTICLE_VIEW_TEMPLET_PATH` varchar(200) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table config_site
#


#
# Table Objects for table jcms_comment
#

CREATE TABLE `jcms_comment` (
  `COMMENT_ID` int(11) NOT NULL default '0',
  `CHANNEL_ID` int(11) NOT NULL default '0',
  `INFO_ID` int(11) NOT NULL default '0',
  `USER_TYPE` int(11) NOT NULL default '0',
  `USER_NAME` varchar(40) NOT NULL default '',
  `SEX` varchar(10) default NULL,
  `OICQ` varchar(20) default NULL,
  `MSN` varchar(40) default NULL,
  `ICQ` varchar(20) default NULL,
  `MAIL` varchar(50) default NULL,
  `HOMEPAGE` varchar(100) default NULL,
  `IP` varchar(30) NOT NULL default '',
  `ADD_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `SCORE` int(11) NOT NULL default '0',
  `CONTENT` longtext NOT NULL,
  `REPLY_NAME` varchar(50) default NULL,
  `REPLY_CONTENT` longtext,
  `REPLY_TIME` timestamp NOT NULL default '0000-00-00 00:00:00',
  `PASSED` int(11) NOT NULL default '0',
  PRIMARY KEY  (`COMMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table jcms_comment
#


#
# Table Objects for table login_info
#

CREATE TABLE `login_info` (
  `UID` varchar(20) default NULL,
  `LOGIN_IP` varchar(40) default NULL,
  `LOGIN_HOST` varchar(40) default NULL,
  `LOGIN_DATE` datetime default NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table login_info
#

#
# Table Objects for table map_class_user
#

CREATE TABLE `map_class_user` (
  `ID` int(11) NOT NULL auto_increment,
  `UID` varchar(20) default NULL,
  `ARTICLE_CLASS_ID` varchar(60) default NULL,
  `PURVIEW_TYPE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table map_class_user
#


#
# Table Objects for table map_group_module
#

CREATE TABLE `map_group_module` (
  `ID` int(11) NOT NULL auto_increment,
  `GROUP_ID` int(11) default NULL,
  `MODULE_ID` int(11) default NULL,
  `MAP_TYPE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table map_group_module
#


#
# Table Objects for table map_user_module
#

CREATE TABLE `map_user_module` (
  `ID` int(11) NOT NULL auto_increment,
  `UID` varchar(20) default NULL,
  `MODULE_ID` int(11) default NULL,
  `MODULE_TYPE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table map_user_module
#


#
# Table Objects for table restricts2
#

CREATE TABLE `restricts2` (
  `ID` int(11) NOT NULL auto_increment,
  `REST_NAME` varchar(40) default NULL,
  PRIMARY KEY  (`ID`)