/* 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;