jeecms-db-0.7.0-beta.sql

JSP(Java Server Pages)是由Sun Microsystems公司倡导、许多公司参与一起建立的一种动态网页技术标准。 JSP技术是用JAVA语言作为脚本语言的

/* Table: CMS_VISIT_LOG                                         */
/*==============================================================*/
create table CMS_VISIT_LOG
(
   CVISITL_ID           bigint not null auto_increment,
   WEBSITE_ID           bigint not null,
   URL                  varchar(250) comment '访问地址',
   IP                   varchar(50) comment '浏览者IP',
   PORT                 int comment '浏览者端口号',
   VISITE_TIME          datetime comment '浏览时间',
   VISITE_DATE          date comment '访问日期。方便查询，如分组查询',
   OS                   varchar(255) comment '浏览者操作系统',
   BROWSER              varchar(255) comment '浏览者浏览器',
   USER_AGENT           longtext comment '用户代理。包含浏览器和操作系统',
   primary key (CVISITL_ID)
)
comment = "站点的访问日志";

/*==============================================================*/
/* Table: CMS_WEBSITE                                           */
/*==============================================================*/
create table CMS_WEBSITE
(
   WEBSITE_ID           bigint not null auto_increment,
   PARENT_ID            bigint comment '父站点',
   UNITED_ID            bigint comment '用户联合站',
   DOMAIN               varchar(50) not null comment '域名',
   RES_PATH             varchar(20) not null comment '资源路径',
   RES_DOMAIN           varchar(50) not null comment '资源地址',
   BASE_DOMAIN          varchar(50) comment '根域名',
   DOMAIN_ALIAS         varchar(250) comment '可储存多个别名，用;分割',
   PORT                 int comment '服务的端口号',
   CONTEXT_PATH         varchar(20) comment '应用部署的上下文路径',
   NAME                 varchar(100) comment '站点名称',
   SHORT_NAME           varchar(20) comment '简称',
   SUFFIX               varchar(20) comment '访问后缀，可以是jsp、htm、asp、php等',
   DEFAULT_SYSTEM       char(4) comment '默认系统',
   OWNER_NAME           varchar(100) comment '网站拥有者姓名',
   OWNER_IDENTITY       varchar(100) comment '网站拥有者身份证号',
   COMPANY              varchar(200) comment '公司名称',
   EMAIL                varchar(100) comment '网站拥有者电子邮箱',
   PHONE_CODE           varchar(200) comment '电话号码',
   MOBILE_CODE          varchar(200) comment '手机号码',
   CREATE_TIME          datetime comment '站点创建时间',
   START_TIME           date comment '站点开始租用时间',
   LIMIT_TIME           date comment '站点租用到期时间',
   EMAIL_CHARSET        varchar(20) comment '邮件发送编码',
   EMAIL_HOSTNAME       varchar(50) comment '邮件发送服务器',
   EMAIL_ACCOUNT        varchar(100) comment '网站邮箱账号',
   EMAIL_USER_NAME      varchar(50) comment '网站邮箱名称',
   EMAIL_USER_ID        varchar(100) comment '网站邮箱登录名',
   EMAIL_USER_PWD       varchar(50) comment '网站邮箱密码',
   EMAIL_SUBJECT        varchar(255) comment '邮件主题（标题）',
   EMAIL_CONTENT        longtext comment '邮件内容',
   IS_CHECK             bool not null comment '是否通过审核',
   IS_DISABLED          bool not null comment '是否禁用',
   primary key (WEBSITE_ID),
   key AK_DOMAIN (DOMAIN),
   key AK_RES_PATH (RES_PATH)
);

alter table ARTI_ARTICLE add constraint FK_ARITCLE_INPUT_ADMIN foreign key (INPUT_ADMIN_ID)
      references CMS_USER_ADMIN (ADMIN_ID) on delete restrict on update restrict;

alter table ARTI_ARTICLE add constraint FK_ARTICLE_AGGOUP foreign key (AGGROUP_ID)
      references ARTI_GUEST_GROUP (AGGROUP_ID) on delete restrict on update restrict;

alter table ARTI_ARTICLE add constraint FK_ARTICLE_AGUEST foreign key (AGUEST_ID)
      references ARTI_GUEST (AGUEST_ID) on delete restrict on update restrict;

alter table ARTI_ARTICLE add constraint FK_ARTICLE_CHECK_ADMIN foreign key (CHECK_ADMIN_ID)
      references CMS_USER_ADMIN (ADMIN_ID) on delete restrict on update restrict;

alter table ARTI_ARTICLE add constraint FK_ARTICLE_DISABLE_ADMIN foreign key (DISABLE_ADMIN_ID)
      references CMS_USER_ADMIN (ADMIN_ID) on delete restrict on update restrict;

alter table ARTI_ARTICLE add constraint FK_ARTI_CHAN foreign key (CHAN_ID)
      references CMS_CHANNEL (CHAN_ID) on delete restrict on update restrict;

alter table ARTI_ARTICLE add constraint FK_ARTI_TEMPLATE_CONTENT foreign key (TEMPLATE_ID)
      references CMS_TEMPLATE (TEMPLATE_ID) on delete restrict on update restrict;

alter table ARTI_ARTICLE add constraint FK_ARTI_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table ARTI_CHECK_LOG add constraint FK_ACLOG_ARTICLE foreign key (ARTI_ID)
      references ARTI_ARTICLE (ARTI_ID) on delete restrict on update restrict;

alter table ARTI_CHECK_LOG add constraint FK_ACLOG_CUADMIN foreign key (ADMIN_ID)
      references CMS_USER_ADMIN (ADMIN_ID) on delete restrict on update restrict;

alter table ARTI_COMMENT add constraint FK_COMMENT_ADMIN foreign key (ADMIN_ID)
      references CMS_USER_ADMIN (ADMIN_ID) on delete restrict on update restrict;

alter table ARTI_COMMENT add constraint FK_COMMENT_ARTICLE foreign key (ARTI_ID)
      references ARTI_ARTICLE (ARTI_ID) on delete restrict on update restrict;

alter table ARTI_COMMENT add constraint FK_COMMENT_GUEST foreign key (GUEST_ID)
      references CMS_USER_GUEST (GUEST_ID) on delete restrict on update restrict;

alter table ARTI_GUEST add constraint FK_AGUEST_AGGROUP foreign key (AGGROUP_ID)
      references ARTI_GUEST_GROUP (AGGROUP_ID) on delete restrict on update restrict;

alter table ARTI_GUEST add constraint FK_AGUEST_CUGUEST foreign key (AGUEST_ID)
      references CMS_USER_GUEST (GUEST_ID) on delete restrict on update restrict;

alter table ARTI_GUEST add constraint FK_AGUEST_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table ARTI_GUEST_GROUP add constraint FK_AGGROUP_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table ARTI_TOPIC_ARTICLE add constraint FK_ARTICLE_TOPIC foreign key (CHAN_ID)
      references CMS_CHANNEL (CHAN_ID) on delete restrict on update restrict;

alter table ARTI_TOPIC_ARTICLE add constraint FK_TOPIC_ARTICLE foreign key (ARTI_ID)
      references ARTI_ARTICLE (ARTI_ID) on delete restrict on update restrict;

alter table CMS_CHANNEL add constraint FK_CHANNEL_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_CHANNEL add constraint FK_CHAN_PARENT foreign key (PARENT_ID)
      references CMS_CHANNEL (CHAN_ID) on delete restrict on update restrict;

alter table CMS_CHANNEL add constraint FK_CHAN_TEMPLATE_CONTENT foreign key (TPL_CONTENT_ID)
      references CMS_TEMPLATE (TEMPLATE_ID) on delete restrict on update restrict;

alter table CMS_CHANNEL add constraint FK_CHAN_TEMPLATE_INDEX foreign key (TPL_INDEX_ID)
      references CMS_TEMPLATE (TEMPLATE_ID) on delete restrict on update restrict;

alter table CMS_EXCLUDE_FUNCTION add constraint FK_CMS_EXCLUDE_FUNCTION foreign key (FUNC_ID)
      references CMS_FUNCTION (FUNC_ID) on delete restrict on update restrict;

alter table CMS_EXCLUDE_FUNCTION add constraint FK_CMS_EXCLUDE_FUNCTION2 foreign key (ADMIN_ID)
      references CMS_USER_ADMIN (ADMIN_ID) on delete restrict on update restrict;

alter table CMS_FRIEND_SITE add constraint FK_FRIENDSITE_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_FRIEND_SITE add constraint FK_FRIEND_CTG foreign key (FRIENDCTG_ID)
      references CMS_FRIEND_SITE_CTG (FRIENDCTG_ID) on delete restrict on update restrict;

alter table CMS_FRIEND_SITE_CTG add constraint FK_FRIENDCTG_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_FUNCTION add constraint FK_PARENT foreign key (PARENT_ID)
      references CMS_FUNCTION (FUNC_ID) on delete restrict on update restrict;

alter table CMS_INCLUDE_FUNCTION add constraint FK_CMS_INCLUDE_FUNCTION foreign key (FUNC_ID)
      references CMS_FUNCTION (FUNC_ID) on delete restrict on update restrict;

alter table CMS_INCLUDE_FUNCTION add constraint FK_CMS_INCLUDE_FUNCTION2 foreign key (ADMIN_ID)
      references CMS_USER_ADMIN (ADMIN_ID) on delete restrict on update restrict;

alter table CMS_KEY_VALUE add constraint FK_KEYVALUE_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_MESSAGE_BOARD add constraint FK_MSG_ADMIN foreign key (ADMIN_ID)
      references CMS_USER_ADMIN (ADMIN_ID) on delete restrict on update restrict;

alter table CMS_MESSAGE_BOARD add constraint FK_MSG_CTG foreign key (MSGCTG_ID)
      references CMS_MESSAGE_BOARD_CTG (MSGCTG_ID) on delete restrict on update restrict;

alter table CMS_MESSAGE_BOARD add constraint FK_MSG_GUEST foreign key (GUEST_ID)
      references CMS_USER_GUEST (GUEST_ID) on delete restrict on update restrict;

alter table CMS_MESSAGE_BOARD add constraint FK_MSG_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_MESSAGE_BOARD_CTG add constraint FK_MSGCTG_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_RECOMMEND_GROUP add constraint FK_RGROUP_CHANNEL foreign key (CHAN_ID)
      references CMS_CHANNEL (CHAN_ID) on delete restrict on update restrict;

alter table CMS_RECOMMEND_GROUP add constraint FK_RGROUP_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_RECOMMEND_ITEM add constraint FK_RITEM_RGOUP foreign key (RGROUP_ID)
      references CMS_RECOMMEND_GROUP (RGROUP_ID) on delete restrict on update restrict;

alter table CMS_RECOMMEND_ITEM add constraint FK_RITEM_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_ROLE_FUNCTION add constraint FK_CMS_ROLE_FUNCTION foreign key (ROLE_ID)
      references CMS_ROLE (ROLE_ID) on delete restrict on update restrict;

alter table CMS_ROLE_FUNCTION add constraint FK_CMS_ROLE_FUNCTION2 foreign key (FUNC_ID)
      references CMS_FUNCTION (FUNC_ID) on delete restrict on update restrict;

alter table CMS_TEMPLATE add constraint FK_TEMPLATE_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_USER_ADMIN add constraint FK_ADMIN_UNITEDUSER foreign key (UNITED_USER_ID)
      references CMS_USER_UNITED (UNITED_USER_ID) on delete restrict on update restrict;

alter table CMS_USER_ADMIN add constraint FK_ADMIN_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_USER_GUEST add constraint FK_GUEST_UNITEDUSER foreign key (UNITED_USER_ID)
      references CMS_USER_UNITED (UNITED_USER_ID) on delete restrict on update restrict;

alter table CMS_USER_GUEST add constraint FK_GUEST_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_USER_ROLE add constraint FK_CMS_USER_ROLE foreign key (ROLE_ID)
      references CMS_ROLE (ROLE_ID) on delete restrict on update restrict;

alter table CMS_USER_ROLE add constraint FK_CMS_USER_ROLE2 foreign key (ADMIN_ID)
      references CMS_USER_ADMIN (ADMIN_ID) on delete restrict on update restrict;

alter table CMS_VISIT_LOG add constraint FK_CVISITL_WEBSITE foreign key (WEBSITE_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_WEBSITE add constraint FK_PARENT_WEBSITE foreign key (PARENT_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;

alter table CMS_WEBSITE add constraint FK_UNITED_USER_WEBISTE foreign key (UNITED_ID)
      references CMS_WEBSITE (WEBSITE_ID) on delete restrict on update restrict;