 COMMENT ON COLUMN BO_INTERFACE_DESC.CATALOG_ID IS '接口目录';
 COMMENT ON COLUMN BO_INTERFACE_DESC.SEQUENCE IS '排序';
 COMMENT ON COLUMN BO_INTERFACE_DESC.TYPE IS '类型';
+
+
+DROP TABLE CMS_ARTICLE CASCADE CONSTRAINTS;
+CREATE TABLE CMS_ARTICLE (
+ID CHAR(32) not null ,
+CREATE_DATE DATE,
+CREATE_USER VARCHAR2(50),
+UPDATE_DATE DATE,
+UPDATE_USER VARCHAR2(50),
+REMARKS VARCHAR2(255),
+DEL_FLAG CHAR(1),
+SITE_ID CHAR(32),
+CATEGORY_ID VARCHAR2(100),
+TITLE VARCHAR2(100) not null ,
+SUB_TITLE VARCHAR2(100),
+KEYWORDS VARCHAR2(100),
+DESCRIPTION VARCHAR2(500),
+SEQ NUMBER(10),
+HITS NUMBER(10),
+CONTENT CLOB,
+COPYFROM VARCHAR2(500),
+CUSTOM_CONTENT_VIEW VARCHAR2(500),
+VIEW_CONFIG CLOB,
+POSTER VARCHAR2(500),
+TAG_ID VARCHAR2(4000)
+);
+ALTER TABLE CMS_ARTICLE ADD CONSTRAINT CMS_ARTICLE_ID PRIMARY KEY (ID);
+COMMENT ON TABLE CMS_ARTICLE IS '内容发布文章';
+COMMENT ON COLUMN CMS_ARTICLE.ID IS '主键';
+COMMENT ON COLUMN CMS_ARTICLE.CREATE_DATE IS '创建日期';
+COMMENT ON COLUMN CMS_ARTICLE.CREATE_USER IS '创建用户';
+COMMENT ON COLUMN CMS_ARTICLE.UPDATE_DATE IS '修改日期';
+COMMENT ON COLUMN CMS_ARTICLE.UPDATE_USER IS '修改用户';
+COMMENT ON COLUMN CMS_ARTICLE.REMARKS IS '备注信息';
+COMMENT ON COLUMN CMS_ARTICLE.DEL_FLAG IS '删除标记';
+COMMENT ON COLUMN CMS_ARTICLE.SITE_ID IS '所属站点';
+COMMENT ON COLUMN CMS_ARTICLE.CATEGORY_ID IS '所属栏目';
+COMMENT ON COLUMN CMS_ARTICLE.TITLE IS '标题';
+COMMENT ON COLUMN CMS_ARTICLE.SUB_TITLE IS '副标题';
+COMMENT ON COLUMN CMS_ARTICLE.KEYWORDS IS '关键字';
+COMMENT ON COLUMN CMS_ARTICLE.DESCRIPTION IS '描述';
+COMMENT ON COLUMN CMS_ARTICLE.SEQ IS '权重';
+COMMENT ON COLUMN CMS_ARTICLE.HITS IS '点击数';
+COMMENT ON COLUMN CMS_ARTICLE.CONTENT IS '文章内容';
+COMMENT ON COLUMN CMS_ARTICLE.COPYFROM IS '文章来源';
+COMMENT ON COLUMN CMS_ARTICLE.CUSTOM_CONTENT_VIEW IS '自定义内容视图';
+COMMENT ON COLUMN CMS_ARTICLE.VIEW_CONFIG IS '视图配置';
+COMMENT ON COLUMN CMS_ARTICLE.POSTER IS '海报';
+COMMENT ON COLUMN CMS_ARTICLE.TAG_ID IS '标签';
+
+
+DROP TABLE CMS_CATEGORY CASCADE CONSTRAINTS;
+CREATE TABLE CMS_CATEGORY (
+ID CHAR(32) not null ,
+CREATE_DATE DATE,
+CREATE_USER VARCHAR2(50),
+UPDATE_DATE DATE,
+UPDATE_USER VARCHAR2(50),
+REMARKS VARCHAR2(255),
+DEL_FLAG CHAR(1),
+SITE_ID CHAR(32) not null ,
+MODULE VARCHAR2(100),
+NAME VARCHAR2(100) not null ,
+PARENT_ID CHAR(32) not null ,
+HREF VARCHAR2(500),
+TARGET VARCHAR2(100),
+DESCRIPTION VARCHAR2(500),
+KEYWORDS VARCHAR2(500),
+SEQ NUMBER(10) not null ,
+IN_MENU CHAR(1),
+IN_LIST CHAR(1),
+IS_COMMENT CHAR(1),
+IS_AUDIT CHAR(1),
+CUSTOM_LIST_VIEW VARCHAR2(500),
+CUSTOM_CONTENT_VIEW VARCHAR2(500),
+VIEW_CONFIG CLOB,
+EXTENDS_INFO VARCHAR2(100)
+);
+ALTER TABLE CMS_CATEGORY ADD CONSTRAINT CMS_CATEGORY_ID PRIMARY KEY (ID);
+COMMENT ON TABLE CMS_CATEGORY IS '内容发布栏目';
+COMMENT ON COLUMN CMS_CATEGORY.ID IS '主键';
+COMMENT ON COLUMN CMS_CATEGORY.CREATE_DATE IS '创建日期';
+COMMENT ON COLUMN CMS_CATEGORY.CREATE_USER IS '创建用户';
+COMMENT ON COLUMN CMS_CATEGORY.UPDATE_DATE IS '修改日期';
+COMMENT ON COLUMN CMS_CATEGORY.UPDATE_USER IS '修改用户';
+COMMENT ON COLUMN CMS_CATEGORY.REMARKS IS '备注信息';
+COMMENT ON COLUMN CMS_CATEGORY.DEL_FLAG IS '删除标记';
+COMMENT ON COLUMN CMS_CATEGORY.SITE_ID IS '站点';
+COMMENT ON COLUMN CMS_CATEGORY.MODULE IS '栏目模块';
+COMMENT ON COLUMN CMS_CATEGORY.NAME IS '栏目名称';
+COMMENT ON COLUMN CMS_CATEGORY.PARENT_ID IS '父级栏目';
+COMMENT ON COLUMN CMS_CATEGORY.HREF IS '链接';
+COMMENT ON COLUMN CMS_CATEGORY.TARGET IS '目标';
+COMMENT ON COLUMN CMS_CATEGORY.DESCRIPTION IS '描述';
+COMMENT ON COLUMN CMS_CATEGORY.KEYWORDS IS '关键字';
+COMMENT ON COLUMN CMS_CATEGORY.SEQ IS '权重';
+COMMENT ON COLUMN CMS_CATEGORY.IN_MENU IS '是否导航显示';
+COMMENT ON COLUMN CMS_CATEGORY.IN_LIST IS '是否分类列表';
+COMMENT ON COLUMN CMS_CATEGORY.IS_COMMENT IS '是否允许评论';
+COMMENT ON COLUMN CMS_CATEGORY.IS_AUDIT IS '是否需要审核';
+COMMENT ON COLUMN CMS_CATEGORY.CUSTOM_LIST_VIEW IS '列表视图';
+COMMENT ON COLUMN CMS_CATEGORY.CUSTOM_CONTENT_VIEW IS '内容视图';
+COMMENT ON COLUMN CMS_CATEGORY.VIEW_CONFIG IS '视图配置';
+COMMENT ON COLUMN CMS_CATEGORY.EXTENDS_INFO IS '扩展内容';
+
+
+DROP TABLE CMS_COLLECTIONS CASCADE CONSTRAINTS;
+CREATE TABLE CMS_COLLECTIONS (
+ID CHAR(32) not null ,
+CREATE_DATE DATE,
+CREATE_USER VARCHAR2(50),
+UPDATE_DATE DATE,
+UPDATE_USER VARCHAR2(50),
+REMARKS VARCHAR2(255),
+DEL_FLAG CHAR(1),
+SITE_ID CHAR(32),
+CATEGORY_ID CHAR(32),
+BASIC_ID CHAR(32) not null ,
+TYPE CHAR(1),
+CATEGORY VARCHAR2(100)
+);
+ALTER TABLE CMS_COLLECTIONS ADD CONSTRAINT CMS_COLLECTION_ID PRIMARY KEY (ID);
+COMMENT ON TABLE CMS_COLLECTIONS IS '内容发布收藏';
+COMMENT ON COLUMN CMS_COLLECTIONS.ID IS '主键';
+COMMENT ON COLUMN CMS_COLLECTIONS.CREATE_DATE IS '创建日期';
+COMMENT ON COLUMN CMS_COLLECTIONS.CREATE_USER IS '创建用户';
+COMMENT ON COLUMN CMS_COLLECTIONS.UPDATE_DATE IS '修改日期';
+COMMENT ON COLUMN CMS_COLLECTIONS.UPDATE_USER IS '修改用户';
+COMMENT ON COLUMN CMS_COLLECTIONS.REMARKS IS '备注信息';
+COMMENT ON COLUMN CMS_COLLECTIONS.DEL_FLAG IS '删除标记';
+COMMENT ON COLUMN CMS_COLLECTIONS.SITE_ID IS '所属站点';
+COMMENT ON COLUMN CMS_COLLECTIONS.CATEGORY_ID IS '所属栏目';
+COMMENT ON COLUMN CMS_COLLECTIONS.BASIC_ID IS '评论主体';
+COMMENT ON COLUMN CMS_COLLECTIONS.TYPE IS '类型';
+COMMENT ON COLUMN CMS_COLLECTIONS.CATEGORY IS '分类';
+
+
+DROP TABLE CMS_COMMENT CASCADE CONSTRAINTS;
+CREATE TABLE CMS_COMMENT (
+ID CHAR(32) not null ,
+CREATE_DATE DATE,
+CREATE_USER VARCHAR2(50),
+UPDATE_DATE DATE,
+UPDATE_USER VARCHAR2(50),
+REMARKS VARCHAR2(255),
+DEL_FLAG CHAR(1),
+SITE_ID CHAR(32) not null ,
+CATEGORY_ID CHAR(32),
+BASIC_ID CHAR(32) not null ,
+SCORE NUMBER(10),
+CONTENT VARCHAR2(500),
+USER_ID CHAR(32),
+USER_NAME VARCHAR2(100),
+IP VARCHAR2(100),
+AUDIT_USER_ID CHAR(32),
+AUDIT_USER_NAME VARCHAR2(100),
+AUDIT_DATE DATE,
+AUDIT_STATE VARCHAR2(100)
+);
+ALTER TABLE CMS_COMMENT ADD CONSTRAINT CMS_COMMENT_ID PRIMARY KEY (ID);
+COMMENT ON TABLE CMS_COMMENT IS '内容发布评价';
+COMMENT ON COLUMN CMS_COMMENT.ID IS '主键';
+COMMENT ON COLUMN CMS_COMMENT.CREATE_DATE IS '创建日期';
+COMMENT ON COLUMN CMS_COMMENT.CREATE_USER IS '创建用户';
+COMMENT ON COLUMN CMS_COMMENT.UPDATE_DATE IS '修改日期';
+COMMENT ON COLUMN CMS_COMMENT.UPDATE_USER IS '修改用户';
+COMMENT ON COLUMN CMS_COMMENT.REMARKS IS '备注信息';
+COMMENT ON COLUMN CMS_COMMENT.DEL_FLAG IS '删除标记';
+COMMENT ON COLUMN CMS_COMMENT.SITE_ID IS '所属站点';
+COMMENT ON COLUMN CMS_COMMENT.CATEGORY_ID IS '所属栏目';
+COMMENT ON COLUMN CMS_COMMENT.BASIC_ID IS '所属主体';
+COMMENT ON COLUMN CMS_COMMENT.SCORE IS '等级';
+COMMENT ON COLUMN CMS_COMMENT.CONTENT IS '评价内容';
+COMMENT ON COLUMN CMS_COMMENT.USER_ID IS '用户ID';
+COMMENT ON COLUMN CMS_COMMENT.USER_NAME IS '评价人';
+COMMENT ON COLUMN CMS_COMMENT.IP IS 'IP';
+COMMENT ON COLUMN CMS_COMMENT.AUDIT_USER_ID IS '审核用户ID';
+COMMENT ON COLUMN CMS_COMMENT.AUDIT_USER_NAME IS '审核人';
+COMMENT ON COLUMN CMS_COMMENT.AUDIT_DATE IS '审核时间';
+COMMENT ON COLUMN CMS_COMMENT.AUDIT_STATE IS '是否屏蔽';
+
+
+DROP TABLE CMS_GUESTBOOK CASCADE CONSTRAINTS;
+CREATE TABLE CMS_GUESTBOOK (
+ID CHAR(32) not null ,
+CREATE_DATE DATE,
+CREATE_USER VARCHAR2(50),
+UPDATE_DATE DATE,
+UPDATE_USER VARCHAR2(50),
+REMARKS VARCHAR2(255),
+DEL_FLAG CHAR(1),
+TYPE VARCHAR2(100),
+CONTENT VARCHAR2(4000),
+NAME VARCHAR2(100),
+EMAIL VARCHAR2(100),
+PHONE VARCHAR2(100),
+WORKUNIT VARCHAR2(100),
+IP VARCHAR2(100),
+REUSERID CHAR(32),
+REDATE DATE,
+RECONTENT VARCHAR2(4000),
+SITE_ID CHAR(32)
+);
+ALTER TABLE CMS_GUESTBOOK ADD CONSTRAINT CMS_GUESTBOOK_ID PRIMARY KEY (ID);
+COMMENT ON TABLE CMS_GUESTBOOK IS '内容发布留言板';
+COMMENT ON COLUMN CMS_GUESTBOOK.ID IS '主键';
+COMMENT ON COLUMN CMS_GUESTBOOK.CREATE_DATE IS '创建日期';
+COMMENT ON COLUMN CMS_GUESTBOOK.CREATE_USER IS '创建用户';
+COMMENT ON COLUMN CMS_GUESTBOOK.UPDATE_DATE IS '修改日期';
+COMMENT ON COLUMN CMS_GUESTBOOK.UPDATE_USER IS '修改用户';
+COMMENT ON COLUMN CMS_GUESTBOOK.REMARKS IS '备注信息';
+COMMENT ON COLUMN CMS_GUESTBOOK.DEL_FLAG IS '删除标记';
+COMMENT ON COLUMN CMS_GUESTBOOK.TYPE IS '留言分类';
+COMMENT ON COLUMN CMS_GUESTBOOK.CONTENT IS '留言内容';
+COMMENT ON COLUMN CMS_GUESTBOOK.NAME IS '姓名';
+COMMENT ON COLUMN CMS_GUESTBOOK.EMAIL IS '邮箱';
+COMMENT ON COLUMN CMS_GUESTBOOK.PHONE IS '电话';
+COMMENT ON COLUMN CMS_GUESTBOOK.WORKUNIT IS '单位';
+COMMENT ON COLUMN CMS_GUESTBOOK.IP IS 'IP';
+COMMENT ON COLUMN CMS_GUESTBOOK.REUSERID IS '回复人';
+COMMENT ON COLUMN CMS_GUESTBOOK.REDATE IS '回复时间';
+COMMENT ON COLUMN CMS_GUESTBOOK.RECONTENT IS '回复内容';
+COMMENT ON COLUMN CMS_GUESTBOOK.SITE_ID IS '站点';
+
+
+DROP TABLE CMS_SITE CASCADE CONSTRAINTS;
+CREATE TABLE CMS_SITE (
+ID CHAR(32) not null ,
+CREATE_DATE DATE,
+CREATE_USER VARCHAR2(50),
+UPDATE_DATE DATE,
+UPDATE_USER VARCHAR2(50),
+REMARKS VARCHAR2(255),
+DEL_FLAG CHAR(1),
+NAME VARCHAR2(100) not null ,
+TITLE VARCHAR2(100) not null ,
+LOGO VARCHAR2(500),
+DOMAIN VARCHAR2(100) not null ,
+DESCRIPTION VARCHAR2(1000),
+KEYWORDS VARCHAR2(500),
+THEME VARCHAR2(100),
+COPYRIGHT VARCHAR2(1000),
+CUSTOM_VIEW VARCHAR2(500)
+);
+ALTER TABLE CMS_SITE ADD CONSTRAINT CMS_SITE_ID PRIMARY KEY (ID);
+COMMENT ON TABLE CMS_SITE IS '内容发布站点';
+COMMENT ON COLUMN CMS_SITE.ID IS '主键';
+COMMENT ON COLUMN CMS_SITE.CREATE_DATE IS '创建日期';
+COMMENT ON COLUMN CMS_SITE.CREATE_USER IS '创建用户';
+COMMENT ON COLUMN CMS_SITE.UPDATE_DATE IS '修改日期';
+COMMENT ON COLUMN CMS_SITE.UPDATE_USER IS '修改用户';
+COMMENT ON COLUMN CMS_SITE.REMARKS IS '备注信息';
+COMMENT ON COLUMN CMS_SITE.DEL_FLAG IS '删除标记';
+COMMENT ON COLUMN CMS_SITE.NAME IS '站点名称';
+COMMENT ON COLUMN CMS_SITE.TITLE IS '站点标题';
+COMMENT ON COLUMN CMS_SITE.LOGO IS '站点LOGO';
+COMMENT ON COLUMN CMS_SITE.DOMAIN IS '站点域名';
+COMMENT ON COLUMN CMS_SITE.DESCRIPTION IS '描述';
+COMMENT ON COLUMN CMS_SITE.KEYWORDS IS '关键字';
+COMMENT ON COLUMN CMS_SITE.THEME IS '主题';
+COMMENT ON COLUMN CMS_SITE.COPYRIGHT IS '版权信息';
+COMMENT ON COLUMN CMS_SITE.CUSTOM_VIEW IS '自定义首页视图';
+
+
+DROP TABLE CMS_TAGCLOUD CASCADE CONSTRAINTS;
+CREATE TABLE CMS_TAGCLOUD (
+ID CHAR(32) not null ,
+CREATE_DATE DATE,
+CREATE_USER VARCHAR2(50),
+UPDATE_DATE DATE,
+UPDATE_USER VARCHAR2(50),
+REMARKS VARCHAR2(255),
+DEL_FLAG CHAR(1),
+SITE_ID CHAR(32) not null ,
+NAME VARCHAR2(100)
+);
+ALTER TABLE CMS_TAGCLOUD ADD CONSTRAINT CMS_TAGCLOUD_ID PRIMARY KEY (ID);
+COMMENT ON TABLE CMS_TAGCLOUD IS '内容发布标签云';
+COMMENT ON COLUMN CMS_TAGCLOUD.ID IS '主键';
+COMMENT ON COLUMN CMS_TAGCLOUD.CREATE_DATE IS '创建日期';
+COMMENT ON COLUMN CMS_TAGCLOUD.CREATE_USER IS '创建用户';
+COMMENT ON COLUMN CMS_TAGCLOUD.UPDATE_DATE IS '修改日期';
+COMMENT ON COLUMN CMS_TAGCLOUD.UPDATE_USER IS '修改用户';
+COMMENT ON COLUMN CMS_TAGCLOUD.REMARKS IS '备注信息';
+COMMENT ON COLUMN CMS_TAGCLOUD.DEL_FLAG IS '删除标记';
+COMMENT ON COLUMN CMS_TAGCLOUD.SITE_ID IS '站点';
+COMMENT ON COLUMN CMS_TAGCLOUD.NAME IS '标签';
 
 
 DROP TABLE JOB_QUARTZ_CONF CASCADE CONSTRAINTS;

INSERT INTO SYS_MENU (ID,PARENT_ID,NAME,URL,SEQUENCE,ICON,TARGET) 
VALUES ('8fb68d4012d34b6393c3d999dde478ad','c617ec2d6eee475ea05fbe779ab3b7c8','定时任务计划','/quartz/quartzConf/list',888,'fa fa-hospital-o','_blank');

INSERT INTO SYS_MODULE (ID,NAME,SHIRO) 
VALUES ('d94881a8dc854298bfac029147b38e26','系统皮肤','skins');


VALUES ('d3f34652eb03447b9cc8bb7375df675d','系统管理员','sys');

INSERT INTO SYS_ROLE_MENU (ROLE_ID,MENU_ID) 
VALUES ('233e1814d0484ae6ad600a84ae8b2a1b','09d5b978a1c64a45b69097219d28fdcf');

INSERT INTO SYS_ROLE_MENU (ROLE_ID,MENU_ID) 
VALUES ('233e1814d0484ae6ad600a84ae8b2a1b','afa54364390c4675b4c97a28663a28b7');

INSERT INTO SYS_ROLE_MENU (ROLE_ID,MENU_ID) 
VALUES ('233e1814d0484ae6ad600a84ae8b2a1b','d63fb68c3af44a5a9bc93afc3edba378');
