mysql41_cms4j_create_table.sql

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

) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table restricts2
#


#
# Table Objects for table sa_group
#

CREATE TABLE `sa_group` (
  `GROUP_ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(80) NOT NULL default '',
  `GROUP_DESC` varchar(200) default NULL,
  `STATE` int(11) NOT NULL default '0',
  `GROUP_TYPE` int(11) NOT NULL default '0',
  `ADD_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `MODIFY_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `OTHER_PURVIEW` text,
  `IS_SYS` int(11) default NULL,
  PRIMARY KEY  (`GROUP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sa_group
#


#
# Table Objects for table sa_user
#

CREATE TABLE `sa_user` (
  `UID` varchar(20) NOT NULL default '',
  `NAME` varchar(30) NOT NULL default '',
  `PWD` varchar(50) NOT NULL default '',
  `SEX` varchar(10) default NULL,
  `AGE` int(11) default NULL,
  `JOIN_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `LOGINS` int(11) NOT NULL default '1',
  `BIRTH` date default NULL,
  `OICQ` varchar(20) default NULL,
  `ICQ` varchar(20) default NULL,
  `MAIL` varchar(100) default NULL,
  `MSN` varchar(40) default NULL,
  `HOMEPAGE` varchar(100) default NULL,
  `POINT` int(11) default NULL,
  `LAST_LOGIN_DATE` datetime default '0000-00-00 00:00:00',
  `LAST_LOGIN_IP` varchar(20) default NULL,
  `QUESTION` varchar(100) NOT NULL default '',
  `ANSWER` varchar(100) NOT NULL default '',
  `TEL` varchar(50) default NULL,
  `FRONT_GROUP_ID` int(11) NOT NULL default '0',
  `BACK_GROUP_ID` int(11) default NULL,
  `STATE` int(11) NOT NULL default '0',
  `ENABLE_MULTI_LOGIN` int(11) NOT NULL default '0',
  `ADMIN_LEVEL_ARTICLE` int(11) default NULL,
  `REMARK` varchar(200) default NULL,
  `AUDIT_LEVEL` int(11) default '1',
  PRIMARY KEY  (`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sa_user
#


#
# Table Objects for table site_form
#

CREATE TABLE `site_form` (
  `ID` int(11) NOT NULL auto_increment,
  `POST_TYPE` varchar(100) default NULL,
  `RESV_USER` varchar(100) default NULL,
  `UNAME` varchar(100) default NULL,
  `UMAIL` varchar(200) default NULL,
  `UTEL` varchar(100) default NULL,
  `UZIPCODE` varchar(20) default NULL,
  `UADDR` varchar(200) default NULL,
  `TITLE` varchar(200) default NULL,
  `CONTENT` text,
  `SEND_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `FORM_TYPE` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`ID`,`FORM_TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table site_form
#


#
# Table Objects for table stat_site_counter
#

CREATE TABLE `stat_site_counter` (
  `ID` int(11) NOT NULL auto_increment,
  `STAT_COUNT` int(11) NOT NULL default '0',
  `STAT_TYPE` varchar(20) NOT NULL default '',
  `STAT_YEAR` int(11) NOT NULL default '0',
  `STAT_MONTH` int(11) NOT NULL default '0',
  `STAT_DAY` int(11) NOT NULL default '0',
  `STAT_HOUR` int(11) NOT NULL default '0',
  `STAT_MINUTE` int(11) NOT NULL default '0',
  `SAVE_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table stat_site_counter
#


#
# Table Objects for table sys_action_mapping
#

CREATE TABLE `sys_action_mapping` (
  `ACTION_NAME` varchar(50) NOT NULL default '',
  `VALUE` varchar(200) NOT NULL default '',
  `ACTION_DESC` varchar(200) default NULL,
  `AUTH` varchar(40) NOT NULL default '',
  `AUTH_CONTACT` varchar(50) default NULL,
  `ADD_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `MODIFY_TIME` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ACTION_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_action_mapping
#


#
# Table Objects for table sys_actions
#

CREATE TABLE `sys_actions` (
  `ACTION_ID` int(11) NOT NULL auto_increment,
  `ACT_NAME` varchar(40) NOT NULL default '',
  `STATE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ACTION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_actions
#

#
# Table Objects for table sys_actions2
#

CREATE TABLE `sys_actions2` (
  `ACTION_ID` int(11) NOT NULL auto_increment,
  `ACT_NAME` varchar(40) NOT NULL default '',
  `STATE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ACTION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_actions2
#


#
# Table Objects for table sys_config
#

CREATE TABLE `sys_config` (
  `ID` int(11) NOT NULL default '0',
  `CFG_NAME` varchar(40) NOT NULL default '',
  `CFG_VALUE` varchar(100) default NULL,
  `CFG_TYPE` int(11) NOT NULL default '0',
  `CFG_DESC` varchar(100) default NULL,
  `MODIFY_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_config
#


#
# Table Objects for table sys_module
#

CREATE TABLE `sys_module` (
  `MODULE_ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(40) NOT NULL default '',
  `MODULE_DESC` varchar(200) default NULL,
  `MODULE_DOMAIN` int(11) NOT NULL default '0',
  `ADD_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `STATE` int(11) NOT NULL default '0',
  `MODULE_TYPE_ID` int(11) default NULL,
  `ORDER_NUM` int(11) NOT NULL default '0',
  `PURVIEW_TYPE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`MODULE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_module
#


#
# Table Objects for table sys_module_type
#

CREATE TABLE `sys_module_type` (
  `MODULE_TYPE_ID` int(11) NOT NULL auto_increment,
  `MODULE_TYPE_NAME` varchar(100) NOT NULL default '',
  `MODULE_TYPE_DESC` text,
  `STATE` int(11) NOT NULL default '0',
  `ORDER_NUM` int(11) NOT NULL default '0',
  `ADD_DATE` datetime default NULL,
  PRIMARY KEY  (`MODULE_TYPE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_module_type
#


#
# Table Objects for table sys_resource
#

CREATE TABLE `sys_resource` (
  `RES_ID` int(11) NOT NULL auto_increment,
  `MODULE_ID` int(11) default NULL,
  `NAME` varchar(40) NOT NULL default '',
  `RES_DESC` varchar(200) default NULL,
  `RES_ACTION` varchar(200) default NULL,
  `COMMAND` text,
  `URL` text,
  `RES_TYPE` int(11) NOT NULL default '0',
  `AUTH` varchar(30) default NULL,
  `AUTH_CONTACT` varchar(100) default NULL,
  `STATE` int(11) NOT NULL default '0',
  `ADD_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `ORDER_NUM` int(11) NOT NULL default '0',
  `RES_SOURCE_TYPE` int(11) NOT NULL default '0',
  `OUT_URL` text,
  `RES_OPER_TYPE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`RES_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_resource
#

#
# Table Objects for table sys_restricts
#

CREATE TABLE `sys_restricts` (
  `RESTRICT_ID` int(11) NOT NULL auto_increment,
  `REST_NAME` varchar(40) NOT NULL default '',
  `STATE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`RESTRICT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_restricts
#


#
# Table Objects for table sys_sequence
#

CREATE TABLE `sys_sequence` (
  `seq_TYPE` varchar(20) NOT NULL default '',
  `SEQ_NUM` int(11) NOT NULL default '0',
  PRIMARY KEY  (`seq_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_sequence
#

#
# Table Objects for table sys_templet
#

CREATE TABLE `sys_templet` (
  `TEMPLET_ID` int(11) NOT NULL auto_increment,
  `TEMPLET_NAME` varchar(30) NOT NULL default '',
  `TEMPLET_URL` varchar(200) NOT NULL default '',
  `TEMPLET_LEGEND_URL` varchar(200) default NULL,
  `TEMPLET_AUTHOR` varchar(50) default NULL,
  `TEMPLET_DESC` text,
  `TEMPLET_TYPE` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`TEMPLET_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table sys_templet
#


#
# Table Objects for table vote
#

CREATE TABLE `vote` (
  `ID` int(11) NOT NULL auto_increment,
  `VOTE_ID` int(11) NOT NULL default '0',
  `TITLE` varchar(200) NOT NULL default '',
  `SELECT1` varchar(200) default NULL,
  `ANSWER1` int(11) default NULL,
  `SELECT2` varchar(200) default NULL,
  `ANSWER2` int(11) default NULL,
  `SELECT3` varchar(200) default NULL,
  `ANSWER3` int(11) default NULL,
  `SELECT4` varchar(200) default NULL,
  `ANSWER4` int(11) default NULL,
  `SELECT5` varchar(200) default NULL,
  `ANSWER5` int(11) default NULL,
  `SELECT6` varchar(200) default NULL,
  `ANSWER6` int(11) default NULL,
  `SELECT7` varchar(200) default NULL,
  `ANSWER7` int(11) default NULL,
  `SELECT8` varchar(200) default NULL,
  `ANSWER8` int(11) default NULL,
  `VOTE_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
  `VOTE_TYPE` int(11) NOT NULL default '0',
  `IS_SELECTED` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table vote
#