📄 oracle.sql

📁 一个cms内容管理平台
💻 SQL
字号:
CREATE TABLE CMS_MODULE_ONLINE_MASTER (
	MASTER_ID VARCHAR2(36) NOT NULL,
	SUB_ID NUMBER NOT NULL,
	USER_ID VARCHAR2(36) NOT NULL,
	GROUP_ID VARCHAR2(36) NOT NULL,
	PROJECT_ID NUMBER NOT NULL,
	ACCESS_FLAGS NUMBER NOT NULL,
	STATE NUMBER NOT NULL,
	LOCKED_BY VARCHAR2(36) NOT NULL,
	LASTMODIFIED_BY VARCHAR2(36) NOT NULL,
	DATE_CREATED DATE NOT NULL,
	DATE_LASTMODIFIED DATE NOT NULL,
	PUBLICATION_DATE DATE,
	PURGE_DATE DATE,
	FLAGS NUMBER,
	FEED_ID NUMBER,
	FEED_REFERENCE NUMBER,
	FEED_FILENAME VARCHAR2(255),
	TITLE VARCHAR2(255),
	DATA_BIG_0 VARCHAR2(4000),
	DATA_BIG_1 VARCHAR2(4000),
	DATA_BIG_2 VARCHAR2(4000),
	DATA_BIG_3 VARCHAR2(4000),
	DATA_BIG_4 VARCHAR2(4000),
	DATA_BIG_5 VARCHAR2(4000),
	DATA_BIG_6 VARCHAR2(4000),
	DATA_BIG_7 VARCHAR2(4000),
	DATA_BIG_8 VARCHAR2(4000),
	DATA_BIG_9 VARCHAR2(4000),
	DATA_MEDIUM_0 VARCHAR2(2000),
	DATA_MEDIUM_1 VARCHAR2(2000),
	DATA_MEDIUM_2 VARCHAR2(2000),
	DATA_MEDIUM_3 VARCHAR2(2000),
	DATA_MEDIUM_4 VARCHAR2(2000),
	DATA_MEDIUM_5 VARCHAR2(2000),
	DATA_MEDIUM_6 VARCHAR2(2000),
	DATA_MEDIUM_7 VARCHAR2(2000),
	DATA_MEDIUM_8 VARCHAR2(2000),
	DATA_MEDIUM_9 VARCHAR2(2000),
	DATA_SMALL_0 VARCHAR2(500),
	DATA_SMALL_1 VARCHAR2(500),
	DATA_SMALL_2 VARCHAR2(500),
	DATA_SMALL_3 VARCHAR2(500),
	DATA_SMALL_4 VARCHAR2(500),
	DATA_SMALL_5 VARCHAR2(500),
	DATA_SMALL_6 VARCHAR2(500),
	DATA_SMALL_7 VARCHAR2(500),
	DATA_SMALL_8 VARCHAR2(500),
	DATA_SMALL_9 VARCHAR2(500),
	DATA_SMALL_10 VARCHAR2(500),
	DATA_SMALL_11 VARCHAR2(500),
	DATA_SMALL_12 VARCHAR2(500),
	DATA_SMALL_13 VARCHAR2(500),
	DATA_SMALL_14 VARCHAR2(500),
	DATA_SMALL_15 VARCHAR2(500),
	DATA_SMALL_16 VARCHAR2(500),
	DATA_SMALL_17 VARCHAR2(500),
	DATA_SMALL_18 VARCHAR2(500),
	DATA_SMALL_19 VARCHAR2(500),
	DATA_SMALL_20 VARCHAR2(500),
	DATA_SMALL_21 VARCHAR2(500),
	DATA_SMALL_22 VARCHAR2(500),
	DATA_SMALL_23 VARCHAR2(500),
	DATA_SMALL_24 VARCHAR2(500),
	DATA_SMALL_25 VARCHAR2(500),
	DATA_SMALL_26 VARCHAR2(500),
	DATA_SMALL_27 VARCHAR2(500),
	DATA_SMALL_28 VARCHAR2(500),
	DATA_SMALL_29 VARCHAR2(500),
	DATA_SMALL_30 VARCHAR2(500),
	DATA_SMALL_31 VARCHAR2(500),
	DATA_SMALL_32 VARCHAR2(500),
	DATA_SMALL_33 VARCHAR2(500),
	DATA_SMALL_34 VARCHAR2(500),
	DATA_SMALL_35 VARCHAR2(500),
	DATA_SMALL_36 VARCHAR2(500),
	DATA_SMALL_37 VARCHAR2(500),
	DATA_SMALL_38 VARCHAR2(500),
	DATA_SMALL_39 VARCHAR2(500),
	DATA_INT_0 NUMBER,
	DATA_INT_1 NUMBER,
	DATA_INT_2 NUMBER,
	DATA_INT_3 NUMBER,
	DATA_INT_4 NUMBER,
	DATA_INT_5 NUMBER,
	DATA_INT_6 NUMBER,
	DATA_INT_7 NUMBER,
	DATA_INT_8 NUMBER,
	DATA_INT_9 NUMBER,
	DATA_REFERENCE_0 NUMBER,
	DATA_REFERENCE_1 NUMBER,
	DATA_REFERENCE_2 NUMBER,
	DATA_REFERENCE_3 NUMBER,
	DATA_REFERENCE_4 NUMBER,
	DATA_REFERENCE_5 NUMBER,
	DATA_REFERENCE_6 NUMBER,
	DATA_REFERENCE_7 NUMBER,
	DATA_REFERENCE_8 NUMBER,
	DATA_REFERENCE_9 NUMBER,
	DATA_DATE_0 DATE,
	DATA_DATE_1 DATE,
	DATA_DATE_2 DATE,
	DATA_DATE_3 DATE,
	DATA_DATE_4 DATE,
	CONSTRAINT PK_MODULE_ONLINE_MASTER PRIMARY KEY(MASTER_ID) USING INDEX TABLESPACE ${indexTablespace}
);
                                         
CREATE TABLE CMS_MODULE_ONLINE_CHANNEL_REL (
	MASTER_ID VARCHAR2(36) NOT NULL,
	CHANNEL_ID VARCHAR2(36) NOT NULL,
    CHANNEL_NAME VARCHAR2(1024) NOT NULL,
	CONSTRAINT PK_MODULE_ONLINE_CHANNEL_REL PRIMARY KEY(CHANNEL_ID, MASTER_ID) USING INDEX TABLESPACE ${indexTablespace}
);

CREATE TABLE CMS_MODULE_ONLINE_MEDIA (
	MEDIA_ID NUMBER NOT NULL,
	MASTER_ID VARCHAR2(36) NOT NULL,
	MEDIA_POSITION NUMBER NOT NULL,
	MEDIA_WIDTH NUMBER NOT NULL,
	MEDIA_HEIGHT NUMBER NOT NULL,
	MEDIA_SIZE NUMBER NOT NULL,
	MEDIA_MIMETYPE VARCHAR2(255),
	MEDIA_TYPE NUMBER NOT NULL,
	MEDIA_TITLE VARCHAR2(255),
	MEDIA_NAME VARCHAR2(255),
	MEDIA_DESCRIPTION VARCHAR2(500) NOT NULL,
	MEDIA LONG RAW NOT NULL,
	CONSTRAINT PK_MODULE_ONLINE_MEDIA PRIMARY KEY(MEDIA_ID) USING INDEX TABLESPACE ${indexTablespace}
);
                                         
CREATE TABLE CMS_MODULE_MASTER (
	MASTER_ID VARCHAR2(36) NOT NULL,
	SUB_ID NUMBER NOT NULL,
	USER_ID VARCHAR2(36) NOT NULL,
	GROUP_ID VARCHAR2(36) NOT NULL,
	PROJECT_ID NUMBER NOT NULL,
	ACCESS_FLAGS NUMBER NOT NULL,
	STATE NUMBER NOT NULL,
	LOCKED_BY VARCHAR2(36) NOT NULL,
	LASTMODIFIED_BY VARCHAR2(36) NOT NULL,
	DATE_CREATED DATE NOT NULL,
	DATE_LASTMODIFIED DATE NOT NULL,
	PUBLICATION_DATE DATE,
	PURGE_DATE DATE,
	FLAGS NUMBER,
	FEED_ID NUMBER,
	FEED_REFERENCE NUMBER,
	FEED_FILENAME VARCHAR2(255),
	TITLE VARCHAR2(255),
	DATA_BIG_0 VARCHAR2(4000),
	DATA_BIG_1 VARCHAR2(4000),
	DATA_BIG_2 VARCHAR2(4000),
	DATA_BIG_3 VARCHAR2(4000),
	DATA_BIG_4 VARCHAR2(4000),
	DATA_BIG_5 VARCHAR2(4000),
	DATA_BIG_6 VARCHAR2(4000),
	DATA_BIG_7 VARCHAR2(4000),
	DATA_BIG_8 VARCHAR2(4000),
	DATA_BIG_9 VARCHAR2(4000),
	DATA_MEDIUM_0 VARCHAR2(2000),
	DATA_MEDIUM_1 VARCHAR2(2000),
	DATA_MEDIUM_2 VARCHAR2(2000),
	DATA_MEDIUM_3 VARCHAR2(2000),
	DATA_MEDIUM_4 VARCHAR2(2000),
	DATA_MEDIUM_5 VARCHAR2(2000),
	DATA_MEDIUM_6 VARCHAR2(2000),
	DATA_MEDIUM_7 VARCHAR2(2000),
	DATA_MEDIUM_8 VARCHAR2(2000),
	DATA_MEDIUM_9 VARCHAR2(2000),
	DATA_SMALL_0 VARCHAR2(500),
	DATA_SMALL_1 VARCHAR2(500),
	DATA_SMALL_2 VARCHAR2(500),
	DATA_SMALL_3 VARCHAR2(500),
	DATA_SMALL_4 VARCHAR2(500),
	DATA_SMALL_5 VARCHAR2(500),
	DATA_SMALL_6 VARCHAR2(500),
	DATA_SMALL_7 VARCHAR2(500),
	DATA_SMALL_8 VARCHAR2(500),
	DATA_SMALL_9 VARCHAR2(500),
	DATA_SMALL_10 VARCHAR2(500),
	DATA_SMALL_11 VARCHAR2(500),
	DATA_SMALL_12 VARCHAR2(500),
	DATA_SMALL_13 VARCHAR2(500),
	DATA_SMALL_14 VARCHAR2(500),
	DATA_SMALL_15 VARCHAR2(500),
	DATA_SMALL_16 VARCHAR2(500),
	DATA_SMALL_17 VARCHAR2(500),
	DATA_SMALL_18 VARCHAR2(500),
	DATA_SMALL_19 VARCHAR2(500),
	DATA_SMALL_20 VARCHAR2(500),
	DATA_SMALL_21 VARCHAR2(500),
	DATA_SMALL_22 VARCHAR2(500),
	DATA_SMALL_23 VARCHAR2(500),
	DATA_SMALL_24 VARCHAR2(500),
	DATA_SMALL_25 VARCHAR2(500),
	DATA_SMALL_26 VARCHAR2(500),
	DATA_SMALL_27 VARCHAR2(500),
	DATA_SMALL_28 VARCHAR2(500),
	DATA_SMALL_29 VARCHAR2(500),
	DATA_SMALL_30 VARCHAR2(500),
	DATA_SMALL_31 VARCHAR2(500),
	DATA_SMALL_32 VARCHAR2(500),
	DATA_SMALL_33 VARCHAR2(500),
	DATA_SMALL_34 VARCHAR2(500),
	DATA_SMALL_35 VARCHAR2(500),
	DATA_SMALL_36 VARCHAR2(500),
	DATA_SMALL_37 VARCHAR2(500),
	DATA_SMALL_38 VARCHAR2(500),
	DATA_SMALL_39 VARCHAR2(500),
	DATA_INT_0 NUMBER,
	DATA_INT_1 NUMBER,
	DATA_INT_2 NUMBER,
	DATA_INT_3 NUMBER,
	DATA_INT_4 NUMBER,
	DATA_INT_5 NUMBER,
	DATA_INT_6 NUMBER,
	DATA_INT_7 NUMBER,
	DATA_INT_8 NUMBER,
	DATA_INT_9 NUMBER,
	DATA_REFERENCE_0 NUMBER,
	DATA_REFERENCE_1 NUMBER,
	DATA_REFERENCE_2 NUMBER,
	DATA_REFERENCE_3 NUMBER,
	DATA_REFERENCE_4 NUMBER,
	DATA_REFERENCE_5 NUMBER,
	DATA_REFERENCE_6 NUMBER,
	DATA_REFERENCE_7 NUMBER,
	DATA_REFERENCE_8 NUMBER,
	DATA_REFERENCE_9 NUMBER,
	DATA_DATE_0 DATE,
	DATA_DATE_1 DATE,
	DATA_DATE_2 DATE,
	DATA_DATE_3 DATE,
	DATA_DATE_4 DATE,
	CONSTRAINT PK_MODULE_MASTER PRIMARY KEY(MASTER_ID) USING INDEX TABLESPACE ${indexTablespace}
);

CREATE TABLE CMS_MODULE_CHANNEL_REL (
	MASTER_ID VARCHAR2(36) NOT NULL,
	CHANNEL_ID VARCHAR2(36) NOT NULL,
	CHANNEL_NAME VARCHAR2(1024) NOT NULL,
	CONSTRAINT PK_MODULE_CHANNEL_REL PRIMARY KEY(CHANNEL_ID, MASTER_ID) USING INDEX TABLESPACE ${indexTablespace}
);


CREATE TABLE CMS_MODULE_MEDIA (
	MEDIA_ID NUMBER NOT NULL,
	MASTER_ID VARCHAR2(36) NOT NULL,
	MEDIA_POSITION NUMBER NOT NULL,
	MEDIA_WIDTH NUMBER NOT NULL,
	MEDIA_HEIGHT NUMBER NOT NULL,
	MEDIA_SIZE NUMBER NOT NULL,
	MEDIA_MIMETYPE VARCHAR2(255),
	MEDIA_TYPE NUMBER NOT NULL,
	MEDIA_TITLE VARCHAR2(255),
	MEDIA_NAME VARCHAR2(255),
	MEDIA_DESCRIPTION VARCHAR2(500) NOT NULL,
	MEDIA LONG RAW NOT NULL,
	CONSTRAINT PK_MODULE_MEDIA PRIMARY KEY(MEDIA_ID) USING INDEX TABLESPACE ${indexTablespace}
);

CREATE TABLE CMS_MODULE_BACKUP_MASTER (
	MASTER_ID VARCHAR2(36) NOT NULL,
	SUB_ID NUMBER NOT NULL,
	USER_ID VARCHAR2(36) NOT NULL,
	GROUP_ID VARCHAR2(36) NOT NULL,
	PROJECT_ID NUMBER NOT NULL,
	ACCESS_FLAGS NUMBER NOT NULL,
	STATE NUMBER NOT NULL,
	LOCKED_BY VARCHAR2(36) NOT NULL,
	LASTMODIFIED_BY VARCHAR2(36) NOT NULL,
	DATE_CREATED DATE NOT NULL,
	DATE_LASTMODIFIED DATE NOT NULL,
	PUBLICATION_DATE DATE,
	PURGE_DATE DATE,
	FLAGS NUMBER,
	FEED_ID NUMBER,
	FEED_REFERENCE NUMBER,
	FEED_FILENAME VARCHAR2(255),
	TITLE VARCHAR2(255),
	DATA_BIG_0 VARCHAR2(4000),
	DATA_BIG_1 VARCHAR2(4000),
	DATA_BIG_2 VARCHAR2(4000),
	DATA_BIG_3 VARCHAR2(4000),
	DATA_BIG_4 VARCHAR2(4000),
	DATA_BIG_5 VARCHAR2(4000),
	DATA_BIG_6 VARCHAR2(4000),
	DATA_BIG_7 VARCHAR2(4000),
	DATA_BIG_8 VARCHAR2(4000),
	DATA_BIG_9 VARCHAR2(4000),
	DATA_MEDIUM_0 VARCHAR2(2000),
	DATA_MEDIUM_1 VARCHAR2(2000),
	DATA_MEDIUM_2 VARCHAR2(2000),
	DATA_MEDIUM_3 VARCHAR2(2000),
	DATA_MEDIUM_4 VARCHAR2(2000),
	DATA_MEDIUM_5 VARCHAR2(2000),
	DATA_MEDIUM_6 VARCHAR2(2000),
	DATA_MEDIUM_7 VARCHAR2(2000),
	DATA_MEDIUM_8 VARCHAR2(2000),
	DATA_MEDIUM_9 VARCHAR2(2000),
	DATA_SMALL_0 VARCHAR2(500),
	DATA_SMALL_1 VARCHAR2(500),
	DATA_SMALL_2 VARCHAR2(500),
	DATA_SMALL_3 VARCHAR2(500),
	DATA_SMALL_4 VARCHAR2(500),
	DATA_SMALL_5 VARCHAR2(500),
	DATA_SMALL_6 VARCHAR2(500),
	DATA_SMALL_7 VARCHAR2(500),
	DATA_SMALL_8 VARCHAR2(500),
	DATA_SMALL_9 VARCHAR2(500),
	DATA_SMALL_10 VARCHAR2(500),
	DATA_SMALL_11 VARCHAR2(500),
	DATA_SMALL_12 VARCHAR2(500),
	DATA_SMALL_13 VARCHAR2(500),
	DATA_SMALL_14 VARCHAR2(500),
	DATA_SMALL_15 VARCHAR2(500),
	DATA_SMALL_16 VARCHAR2(500),
	DATA_SMALL_17 VARCHAR2(500),
	DATA_SMALL_18 VARCHAR2(500),
	DATA_SMALL_19 VARCHAR2(500),
	DATA_SMALL_20 VARCHAR2(500),
	DATA_SMALL_21 VARCHAR2(500),
	DATA_SMALL_22 VARCHAR2(500),
	DATA_SMALL_23 VARCHAR2(500),
	DATA_SMALL_24 VARCHAR2(500),
	DATA_SMALL_25 VARCHAR2(500),
	DATA_SMALL_26 VARCHAR2(500),
	DATA_SMALL_27 VARCHAR2(500),
	DATA_SMALL_28 VARCHAR2(500),
	DATA_SMALL_29 VARCHAR2(500),
	DATA_SMALL_30 VARCHAR2(500),
	DATA_SMALL_31 VARCHAR2(500),
	DATA_SMALL_32 VARCHAR2(500),
	DATA_SMALL_33 VARCHAR2(500),
	DATA_SMALL_34 VARCHAR2(500),
	DATA_SMALL_35 VARCHAR2(500),
	DATA_SMALL_36 VARCHAR2(500),
	DATA_SMALL_37 VARCHAR2(500),
	DATA_SMALL_38 VARCHAR2(500),
	DATA_SMALL_39 VARCHAR2(500),
	DATA_INT_0 NUMBER,
	DATA_INT_1 NUMBER,
	DATA_INT_2 NUMBER,
	DATA_INT_3 NUMBER,
	DATA_INT_4 NUMBER,
	DATA_INT_5 NUMBER,
	DATA_INT_6 NUMBER,
	DATA_INT_7 NUMBER,
	DATA_INT_8 NUMBER,
	DATA_INT_9 NUMBER,
	DATA_REFERENCE_0 NUMBER,
	DATA_REFERENCE_1 NUMBER,
	DATA_REFERENCE_2 NUMBER,
	DATA_REFERENCE_3 NUMBER,
	DATA_REFERENCE_4 NUMBER,
	DATA_REFERENCE_5 NUMBER,
	DATA_REFERENCE_6 NUMBER,
	DATA_REFERENCE_7 NUMBER,
	DATA_REFERENCE_8 NUMBER,
	DATA_REFERENCE_9 NUMBER,
	DATA_DATE_0 DATE,
	DATA_DATE_1 DATE,
	DATA_DATE_2 DATE,
	DATA_DATE_3 DATE,
	DATA_DATE_4 DATE,
	TAG_ID NUMBER NOT NULL,
	USER_NAME VARCHAR(167),
	GROUP_NAME VARCHAR(64),
	LASTMODIFIED_BY_NAME VARCHAR(167),
	CONSTRAINT PK_MODULE_BACKUP_MASTER PRIMARY KEY(MASTER_ID, TAG_ID) USING INDEX TABLESPACE ${indexTablespace}
);

CREATE TABLE CMS_MODULE_BACKUP_MEDIA (
	MEDIA_ID NUMBER NOT NULL,
	MASTER_ID VARCHAR2(36) NOT NULL,
	MEDIA_POSITION NUMBER NOT NULL,
	MEDIA_WIDTH NUMBER NOT NULL,
	MEDIA_HEIGHT NUMBER NOT NULL,
	MEDIA_SIZE NUMBER NOT NULL,
	MEDIA_MIMETYPE VARCHAR2(255),
	MEDIA_TYPE NUMBER NOT NULL,
	MEDIA_TITLE VARCHAR2(255),
	MEDIA_NAME VARCHAR2(255),
	MEDIA_DESCRIPTION VARCHAR2(500) NOT NULL,
	MEDIA LONG RAW NOT NULL,
	TAG_ID NUMBER NOT NULL,
	CONSTRAINT PK_MODULE_BACKUP_MEDIA PRIMARY KEY(MEDIA_ID, TAG_ID) USING INDEX TABLESPACE ${indexTablespace}
);

CREATE INDEX MASTER_SUBID 
	ON CMS_MODULE_MASTER(SUB_ID)
	TABLESPACE ${indexTablespace};
  
CREATE INDEX ONLINEMASTER_SUBID 
	ON CMS_MODULE_ONLINE_MASTER(SUB_ID)
	TABLESPACE ${indexTablespace};
  
CREATE INDEX ONLINEMEDIA_MASTERID 
	ON CMS_MODULE_ONLINE_MEDIA(MASTER_ID)
	TABLESPACE ${indexTablespace};
  
CREATE INDEX MEDIA_MASTERID 
	ON CMS_MODULE_MEDIA(MASTER_ID)
	TABLESPACE ${indexTablespace};
💿 文件大小 24785 K
👤 上传用户 liujun
📂 所属分类 Java编程
🏷️ 相关标签

#cms #管理平台
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -