CREATE TABLE VIADMIN.APPLICATION_SETTINGS ( APPLICATION_SETTINGS_ID INTEGER NOT NULL, REPOSITORY_VERSION INTEGER NOT NULL, APPLICATION_PARAMETERS BLOB ) LOB (APPLICATION_PARAMETERS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_APPLICATION_SETTINGS ON VIADMIN.APPLICATION_SETTINGS (APPLICATION_SETTINGS_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.APPLICATION_SETTINGS ADD ( CONSTRAINT PK_APPLICATION_SETTINGS PRIMARY KEY (APPLICATION_SETTINGS_ID) USING INDEX VIADMIN.PK_APPLICATION_SETTINGS ENABLE VALIDATE); CREATE TABLE VIADMIN.EVENT_MONITORS ( EVENT_MONITOR_ID INTEGER NOT NULL, EVENT_MONITOR_DESCRIPTION VARCHAR2(255 BYTE) NOT NULL, EVENT_MONITOR_TYPE INTEGER NOT NULL, ENABLE_EXECUTION NUMBER(1) DEFAULT 0 NOT NULL, CONNECTION_ID INTEGER, COMPUTER_TO_MONITOR VARCHAR2(64 BYTE) NOT NULL, EVENT_MONITOR_COMMENTS BLOB, EVENT_MONITOR_PARAMETERS BLOB, OBJECT_ID INTEGER, COMPUTER_TO_EXECUTE_ON VARCHAR2(64 BYTE) NOT NULL, APPLICATION_PLATFORM VARCHAR2(30 BYTE), NUMBER_OF_EXECUTIONS INTEGER DEFAULT 0, TERMINATE_ON_TIMEOUT NUMBER(1) DEFAULT 0 NOT NULL, EXPECTED_EXECUTION_TIME DATE, CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) LOB (EVENT_MONITOR_COMMENTS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) LOB (EVENT_MONITOR_PARAMETERS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_EVENT_MONITORS ON VIADMIN.EVENT_MONITORS (EVENT_MONITOR_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.EVENT_MONITORS ADD ( CONSTRAINT PK_EVENT_MONITORS PRIMARY KEY (EVENT_MONITOR_ID) USING INDEX VIADMIN.PK_EVENT_MONITORS ENABLE VALIDATE); --DROP TABLE VIADMIN.GROUPS CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.GROUPS ( GROUP_ID INTEGER NOT NULL, GROUP_NAME VARCHAR2(80 BYTE), CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_GROUPS ON VIADMIN.GROUPS (GROUP_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.GROUPS ADD ( CONSTRAINT PK_GROUPS PRIMARY KEY (GROUP_ID) USING INDEX VIADMIN.PK_GROUPS ENABLE VALIDATE); --DROP TABLE VIADMIN.ID_GENERATOR CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.ID_GENERATOR ( ID_TYPE INTEGER NOT NULL, GENERATOR_NAME VARCHAR2(80 BYTE), ID INTEGER NOT NULL ) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_ID_GENERATOR ON VIADMIN.ID_GENERATOR (ID_TYPE) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.ID_GENERATOR ADD ( CONSTRAINT PK_ID_GENERATOR PRIMARY KEY (ID_TYPE) USING INDEX VIADMIN.PK_ID_GENERATOR ENABLE VALIDATE); --DROP TABLE VIADMIN.MENUS CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.MENUS ( MENU_ID INTEGER NOT NULL, ID INTEGER NOT NULL, PARENT_ID INTEGER NOT NULL, ITEM_POSITION_NUMBER INTEGER DEFAULT 0, OBJECT_NAME VARCHAR2(100 BYTE), OBJECT_TYPE INTEGER, OBJECT_ID INTEGER, CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_MENUS ON VIADMIN.MENUS (MENU_ID, ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.MENUS ADD ( CONSTRAINT PK_MENUS PRIMARY KEY (MENU_ID, ID) USING INDEX VIADMIN.PK_MENUS ENABLE VALIDATE); --DROP TABLE VIADMIN.NODES CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.NODES ( NODE_NAME VARCHAR2(64 BYTE) NOT NULL, NODE_DESCRIPTION VARCHAR2(255 BYTE), OPERATING_SYSTEM VARCHAR2(255 BYTE), REGISTERED_COMPANY VARCHAR2(255 BYTE), REGISTERED_OWNER VARCHAR2(255 BYTE), NETWORK_DOMAIN VARCHAR2(255 BYTE), IP_ADDRESS VARCHAR2(30 BYTE), CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_NODES ON VIADMIN.NODES (NODE_NAME) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.NODES ADD ( CONSTRAINT PK_NODES PRIMARY KEY (NODE_NAME) USING INDEX VIADMIN.PK_NODES ENABLE VALIDATE); --DROP TABLE VIADMIN.NODE_STATUS CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.NODE_STATUS ( NODE_NAME VARCHAR2(64 BYTE) NOT NULL, APPLICATION_NAME VARCHAR2(64 BYTE), APPLICATION_PLATFORM VARCHAR2(30 BYTE), APPLICATION_DESCRIPTION VARCHAR2(255 BYTE), APPLICATION_VERSION VARCHAR2(30 BYTE), APPLICATION_PARAMETERS BLOB, ENABLE_EXECUTION NUMBER(1) DEFAULT 0 NOT NULL, LICENSED_FROM DATE, LICENSE_OWNER VARCHAR2(255 BYTE), LICENSE_TYPE VARCHAR2(30 BYTE), USER_NAME VARCHAR2(64 BYTE), STARTED DATE, LAST_HART_BEAT DATE, SHUT_DOWN DATE, CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) LOB (APPLICATION_PARAMETERS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_NODE_STATUS ON VIADMIN.NODE_STATUS (NODE_NAME, APPLICATION_NAME, APPLICATION_PLATFORM) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.NODE_STATUS ADD ( CONSTRAINT PK_NODE_STATUS PRIMARY KEY (NODE_NAME, APPLICATION_NAME, APPLICATION_PLATFORM) USING INDEX VIADMIN.PK_NODE_STATUS ENABLE VALIDATE); --DROP TABLE VIADMIN.OBJECTS CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.OBJECTS ( OBJECT_ID INTEGER NOT NULL, OBJECT_TYPE INTEGER, CONNECTION_ID INTEGER, PARENT_ID INTEGER, OBJECT_NAME VARCHAR2(80 BYTE), OBJECT_DATA1 BLOB, OBJECT_DATA2 BLOB, OBJECT_DATA3 BLOB, OBJECT_PARAMETERS BLOB, OBJECT_COMMENTS BLOB, MD5 VARCHAR2(255 BYTE), F1 VARCHAR2(255 BYTE), CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) LOB (OBJECT_COMMENTS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_DATA1) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_DATA2) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_DATA3) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_PARAMETERS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_OBJECTS ON VIADMIN.OBJECTS (OBJECT_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.OBJECTS ADD ( CONSTRAINT PK_OBJECTS PRIMARY KEY (OBJECT_ID) USING INDEX VIADMIN.PK_OBJECTS ENABLE VALIDATE); --DROP TABLE VIADMIN.OBJECTS_HISTORY CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.OBJECTS_HISTORY ( OBJECT_ID INTEGER NOT NULL, VERSION_NO INTEGER NOT NULL, VERSION_COMMENTS VARCHAR2(254 BYTE), CONNECTION_ID INTEGER, OBJECT_NAME VARCHAR2(80 BYTE), OBJECT_DATA1 BLOB, OBJECT_DATA2 BLOB, OBJECT_DATA3 BLOB, OBJECT_PARAMETERS BLOB, OBJECT_COMMENTS BLOB, MD5 VARCHAR2(255 BYTE), F1 VARCHAR2(255 BYTE), COMPUTER_NAME VARCHAR2(32 BYTE), CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE) ) LOB (OBJECT_COMMENTS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_DATA1) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_DATA2) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_DATA3) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_PARAMETERS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_OBJECTS_HISTORY ON VIADMIN.OBJECTS_HISTORY (OBJECT_ID, VERSION_NO) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.OBJECTS_HISTORY ADD ( CONSTRAINT PK_OBJECTS_HISTORY PRIMARY KEY (OBJECT_ID, VERSION_NO) USING INDEX VIADMIN.PK_OBJECTS_HISTORY ENABLE VALIDATE); --DROP TABLE VIADMIN.OBJECTS_TREE CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.OBJECTS_TREE ( OBJECT_ID INTEGER NOT NULL, PARENT_ID INTEGER NOT NULL, NAME VARCHAR2(80 BYTE), OBJECT_TYPE INTEGER NOT NULL, READ_ONLY INTEGER, OBJECT_TYPE_GROUP INTEGER, USER_FIELD_01 VARCHAR2(255 BYTE), USER_FIELD_02 VARCHAR2(255 BYTE), USER_FIELD_03 VARCHAR2(255 BYTE), USER_FIELD_04 VARCHAR2(255 BYTE), USER_FIELD_05 VARCHAR2(255 BYTE), USER_FIELD_06 VARCHAR2(255 BYTE), USER_FIELD_07 VARCHAR2(255 BYTE), USER_FIELD_08 VARCHAR2(255 BYTE), USER_FIELD_09 VARCHAR2(255 BYTE), USER_FIELD_10 VARCHAR2(255 BYTE), OBJECT_DISABLED INTEGER ) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_OBJECTS_TREE ON VIADMIN.OBJECTS_TREE (OBJECT_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.OBJECTS_TREE ADD ( CONSTRAINT PK_OBJECTS_TREE PRIMARY KEY (OBJECT_ID) USING INDEX VIADMIN.PK_OBJECTS_TREE ENABLE VALIDATE); --DROP TABLE VIADMIN.OBJECT_TYPES CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.OBJECT_TYPES ( OBJECT_TYPE INTEGER NOT NULL, OBJECT_TYPE_NAME VARCHAR2(80 BYTE), OBJECT_TYPE_GROUP INTEGER ) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_OBJECT_TYPES ON VIADMIN.OBJECT_TYPES (OBJECT_TYPE) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.OBJECT_TYPES ADD ( CONSTRAINT PK_OBJECT_TYPES PRIMARY KEY (OBJECT_TYPE) USING INDEX VIADMIN.PK_OBJECT_TYPES ENABLE VALIDATE); --DROP TABLE VIADMIN.QUEUE CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.QUEUE ( QUEUE_ID INTEGER NOT NULL, OBJECT_ID INTEGER, OBJECT_TYPE INTEGER, OBJECT_NAME VARCHAR2(80 BYTE), OBJECT_DATA BLOB, OBJECT_PARAMETERS BLOB, LOG_FILE VARCHAR2(255 BYTE), LOG_DATA BLOB, SUBMITED DATE, STARTED DATE, FINISHED DATE, STATUS VARCHAR2(1 BYTE), ABORT_EXECUTION NUMBER(1) DEFAULT 0 NOT NULL, USE_AGENT NUMBER(1) DEFAULT 0 NOT NULL, COMPUTER_NAME VARCHAR2(64 BYTE), OSUSER VARCHAR2(30 BYTE), TERMINATE_ON_TIMEOUT NUMBER(1) DEFAULT 0 NOT NULL, EXPECTED_EXECUTION_TIME DATE, APPLICATION_SUBMITTED VARCHAR2(64 BYTE), APPLICATION_EXECUTED VARCHAR2(64 BYTE), APPLICATION_EXECUTED_PLATFORM VARCHAR2(30 BYTE) ) LOB (LOG_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (OBJECT_PARAMETERS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_QUEUE ON VIADMIN.QUEUE (QUEUE_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.QUEUE ADD ( CONSTRAINT PK_QUEUE PRIMARY KEY (QUEUE_ID) USING INDEX VIADMIN.PK_QUEUE ENABLE VALIDATE); --DROP TABLE VIADMIN.QUEUE_ACTIONS CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.QUEUE_ACTIONS ( QUEUE_ACTIONS_ID INTEGER NOT NULL, QUEUE_ID INTEGER NOT NULL, PARENT_ID INTEGER NOT NULL, ACTION_NAME VARCHAR2(80 BYTE), ACTION_TYPE INTEGER NOT NULL, LINE_NO INTEGER, STARTED DATE, FINISHED DATE, STATUS VARCHAR2(1 BYTE) NOT NULL, ERRORS INTEGER, OBJECT_ID INTEGER, OBJECT_DATA BLOB, LOG_FILE VARCHAR2(255 BYTE), LOG_DATA BLOB, BAD_RECORDS_FILE VARCHAR2(255 BYTE), BAD_RECORDS_DATA BLOB ) LOB (BAD_RECORDS_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) LOB (LOG_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) LOB (OBJECT_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_QUEUE_ACTIONS ON VIADMIN.QUEUE_ACTIONS (QUEUE_ACTIONS_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.QUEUE_ACTIONS ADD ( CONSTRAINT PK_QUEUE_ACTIONS PRIMARY KEY (QUEUE_ACTIONS_ID) USING INDEX VIADMIN.PK_QUEUE_ACTIONS ENABLE VALIDATE); --DROP TABLE VIADMIN.QUEUE_HISTORY CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.QUEUE_HISTORY ( QUEUE_ID INTEGER NOT NULL, OBJECT_ID INTEGER, OBJECT_TYPE INTEGER, OBJECT_NAME VARCHAR2(80 BYTE), OBJECT_DATA BLOB, OBJECT_PARAMETERS BLOB, LOG_FILE VARCHAR2(255 BYTE), LOG_DATA BLOB, SUBMITED DATE, STARTED DATE, FINISHED DATE, STATUS VARCHAR2(1 BYTE), ABORT_EXECUTION NUMBER(1) DEFAULT 0 NOT NULL, USE_AGENT NUMBER(1) DEFAULT 0 NOT NULL, COMPUTER_NAME VARCHAR2(64 BYTE), OSUSER VARCHAR2(30 BYTE), TERMINATE_ON_TIMEOUT NUMBER(1) DEFAULT 0 NOT NULL, EXPECTED_EXECUTION_TIME DATE, APPLICATION_SUBMITTED VARCHAR2(64 BYTE), APPLICATION_EXECUTED VARCHAR2(64 BYTE), APPLICATION_EXECUTED_PLATFORM VARCHAR2(30 BYTE) ) LOB (LOG_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) LOB (OBJECT_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) LOB (OBJECT_PARAMETERS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_QUEUE_HISTORY ON VIADMIN.QUEUE_HISTORY (QUEUE_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.QUEUE_HISTORY ADD ( CONSTRAINT PK_QUEUE_HISTORY PRIMARY KEY (QUEUE_ID) USING INDEX VIADMIN.PK_QUEUE_HISTORY ENABLE VALIDATE); --DROP TABLE VIADMIN.SCHEDULE CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.SCHEDULE ( SCHEDULE_ID INTEGER NOT NULL, OBJECT_ID INTEGER NOT NULL, SCHEDULE_COMMENTS BLOB, START_AT DATE, HOW_OFTEN VARCHAR2(10 BYTE) NOT NULL, START_DATE DATE, END_DATE DATE, USE_END_DATE NUMBER(1) NOT NULL, EVERY INTEGER NOT NULL, REPEAT_TASK NUMBER(1) NOT NULL, REPEAT_EVERY INTEGER NOT NULL, REPEAT_TYPE NUMBER(1) NOT NULL, REPEAT_START DATE, REPEAT_UNTIL DATE, MON NUMBER(1) NOT NULL, TUE NUMBER(1) NOT NULL, WED NUMBER(1) NOT NULL, THU NUMBER(1) NOT NULL, FRI NUMBER(1) NOT NULL, SAT NUMBER(1) NOT NULL, SUN NUMBER(1) NOT NULL, JAN NUMBER(1) NOT NULL, FEB NUMBER(1) NOT NULL, MAR NUMBER(1) NOT NULL, APR NUMBER(1) NOT NULL, MAY NUMBER(1) NOT NULL, JUN NUMBER(1) NOT NULL, JUL NUMBER(1) NOT NULL, AUG NUMBER(1) NOT NULL, SEP NUMBER(1) NOT NULL, OCT NUMBER(1) NOT NULL, NOV NUMBER(1) NOT NULL, DEC NUMBER(1) NOT NULL, MONTHLY_TYPE NUMBER(1) NOT NULL, WEEK_DAY NUMBER(1) NOT NULL, DAY_NO NUMBER(1) NOT NULL, ENABLE_EXECUTION NUMBER(1) DEFAULT 0 NOT NULL, USE_AGENT NUMBER(1) DEFAULT 0 NOT NULL, COMPUTER_TO_EXECUTE_ON VARCHAR2(64 BYTE), APPLICATION_PLATFORM VARCHAR2(30 BYTE), NUMBER_OF_EXECUTIONS INTEGER DEFAULT 0, TERMINATE_ON_TIMEOUT NUMBER(1) DEFAULT 0 NOT NULL, EXPECTED_EXECUTION_TIME DATE, CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) LOB (SCHEDULE_COMMENTS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_SCHEDULE ON VIADMIN.SCHEDULE (SCHEDULE_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.SCHEDULE ADD ( CONSTRAINT PK_SCHEDULE PRIMARY KEY (SCHEDULE_ID) USING INDEX VIADMIN.PK_SCHEDULE ENABLE VALIDATE); --DROP TABLE VIADMIN.SQL_EXECUTION_HISTORY CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.SQL_EXECUTION_HISTORY ( SQL_EXECUTION_HISTORY_ID INTEGER NOT NULL, EXECUTED_SQL BLOB, CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) LOB (EXECUTED_SQL) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_SQL_EXECUTION_HISTORY ON VIADMIN.SQL_EXECUTION_HISTORY (SQL_EXECUTION_HISTORY_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.SQL_EXECUTION_HISTORY ADD ( CONSTRAINT PK_SQL_EXECUTION_HISTORY PRIMARY KEY (SQL_EXECUTION_HISTORY_ID) USING INDEX VIADMIN.PK_SQL_EXECUTION_HISTORY ENABLE VALIDATE); --DROP TABLE VIADMIN.TEMPLATES CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.TEMPLATES ( TEMPLATE_ID INTEGER NOT NULL, TEMPLATE_TYPE INTEGER NOT NULL, TEMPLATE_DATA BLOB, TEMPLATE_COMMENTS BLOB, CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) LOB (TEMPLATE_COMMENTS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) LOB (TEMPLATE_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_TEMPLATES ON VIADMIN.TEMPLATES (TEMPLATE_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.TEMPLATES ADD ( CONSTRAINT PK_TEMPLATES PRIMARY KEY (TEMPLATE_ID) USING INDEX VIADMIN.PK_TEMPLATES ENABLE VALIDATE); --DROP TABLE VIADMIN.USERS CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.USERS ( USER_ID INTEGER NOT NULL, MENU_ID INTEGER, USER_TITLE VARCHAR2(15 BYTE), USER_NAME VARCHAR2(100 BYTE), USER_PASSWORD VARCHAR2(32 BYTE), USER_FIRST_NAME VARCHAR2(100 BYTE), USER_LAST_NAME VARCHAR2(100 BYTE), USER_EMAIL VARCHAR2(100 BYTE), USER_COMPANY VARCHAR2(100 BYTE), USER_WORK_PHONE VARCHAR2(40 BYTE), USER_MOBILE_PHONE VARCHAR2(40 BYTE), USER_DISABLED NUMBER(1) DEFAULT 0, LAST_LOGGED_IN VARCHAR2(19 BYTE), CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_USERS ON VIADMIN.USERS (USER_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE UNIQUE INDEX VIADMIN.USERS_INDEX1 ON VIADMIN.USERS (USER_NAME) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.USERS ADD ( CONSTRAINT PK_USERS PRIMARY KEY (USER_ID) USING INDEX VIADMIN.PK_USERS ENABLE VALIDATE); CREATE INDEX VIADMIN.MENUS_IDX1 ON VIADMIN.MENUS (OBJECT_TYPE) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.MENUS_IDX2 ON VIADMIN.MENUS (PARENT_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.MENUS_IDX3 ON VIADMIN.MENUS (MENU_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.OBJECTS_INDEX1 ON VIADMIN.OBJECTS (OBJECT_TYPE) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.OBJECTS_TREE_INDEX1 ON VIADMIN.OBJECTS_TREE (PARENT_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.QUEUE_ACTIONS_INDEX2 ON VIADMIN.QUEUE_ACTIONS (QUEUE_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.QUEUE_H_INDEX1 ON VIADMIN.QUEUE_HISTORY (STATUS, APPLICATION_EXECUTED_PLATFORM) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.QUEUE_INDEX1 ON VIADMIN.QUEUE (STATUS) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.USERS_IDX1 ON VIADMIN.USERS (USER_DISABLED) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.USERS_IDX2 ON VIADMIN.USERS (MENU_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); --DROP TABLE VIADMIN.ACCESS_RIGHTS CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.ACCESS_RIGHTS ( GROUP_ID INTEGER NOT NULL, OBJECT_ID INTEGER NOT NULL, NO_ACCESS NUMBER(1) DEFAULT 0, CAN_SELECT NUMBER(1) DEFAULT 0, CAN_UPDATE NUMBER(1) DEFAULT 0, CAN_INSERT NUMBER(1) DEFAULT 0, CAN_DELETE NUMBER(1) DEFAULT 0, CAN_EXECUTE NUMBER(1) DEFAULT 0 ) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_ACCESS_RIGHTS ON VIADMIN.ACCESS_RIGHTS (GROUP_ID, OBJECT_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.ACCESS_RIGHTS ADD ( CONSTRAINT PK_ACCESS_RIGHTS PRIMARY KEY (GROUP_ID, OBJECT_ID) USING INDEX VIADMIN.PK_ACCESS_RIGHTS ENABLE VALIDATE); --DROP TABLE VIADMIN.CONNECTIONS CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.CONNECTIONS ( CONNECTION_ID INTEGER NOT NULL, CONNECTION_TYPE INTEGER NOT NULL, OBJECT_ID INTEGER NOT NULL, CONNECTION_NAME VARCHAR2(80 BYTE), CONNECTION_PARAMETERS BLOB, CONNECTION_COMMENTS BLOB, CREATED DATE NOT NULL, CREATED_BY VARCHAR2(32 BYTE), CHANGED DATE NOT NULL, CHANGED_BY VARCHAR2(32 BYTE) NOT NULL ) LOB (CONNECTION_COMMENTS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) LOB (CONNECTION_PARAMETERS) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 104K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_CONNECTIONS ON VIADMIN.CONNECTIONS (CONNECTION_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.CONNECTIONS ADD ( CONSTRAINT PK_CONNECTIONS PRIMARY KEY (CONNECTION_ID) USING INDEX VIADMIN.PK_CONNECTIONS ENABLE VALIDATE); --DROP TABLE VIADMIN.GROUP_MEMBERS CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.GROUP_MEMBERS ( GROUP_ID INTEGER NOT NULL, USER_ID INTEGER NOT NULL ) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.GROUP_MEMBERS_PK ON VIADMIN.GROUP_MEMBERS (USER_ID, GROUP_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE UNIQUE INDEX VIADMIN.PK_GROUP_MEMBERS ON VIADMIN.GROUP_MEMBERS (GROUP_ID, USER_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.GROUP_MEMBERS ADD ( CONSTRAINT PK_GROUP_MEMBERS PRIMARY KEY (GROUP_ID, USER_ID) USING INDEX VIADMIN.PK_GROUP_MEMBERS ENABLE VALIDATE); --DROP TABLE VIADMIN.QUEUE_ACTIONS_HISTORY CASCADE CONSTRAINTS; CREATE TABLE VIADMIN.QUEUE_ACTIONS_HISTORY ( QUEUE_ACTIONS_ID INTEGER NOT NULL, QUEUE_ID INTEGER NOT NULL, PARENT_ID INTEGER NOT NULL, ACTION_NAME VARCHAR2(80 BYTE), ACTION_TYPE INTEGER NOT NULL, LINE_NO INTEGER, STARTED DATE, FINISHED DATE, STATUS VARCHAR2(1 BYTE) NOT NULL, ERRORS INTEGER, OBJECT_ID INTEGER, OBJECT_DATA BLOB, LOG_FILE VARCHAR2(255 BYTE), LOG_DATA BLOB, BAD_RECORDS_FILE VARCHAR2(255 BYTE), BAD_RECORDS_DATA BLOB ) LOB (BAD_RECORDS_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) LOB (LOG_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) LOB (OBJECT_DATA) STORE AS SECUREFILE ( TABLESPACE "VisImport" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) TABLESPACE "VisImport" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; CREATE UNIQUE INDEX VIADMIN.PK_QUEUE_HISTORY_ACTIONS ON VIADMIN.QUEUE_ACTIONS_HISTORY (QUEUE_ACTIONS_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.QUEUE_ACTIONS_HISTORY ADD ( CONSTRAINT PK_QUEUE_HISTORY_ACTIONS PRIMARY KEY (QUEUE_ACTIONS_ID) USING INDEX VIADMIN.PK_QUEUE_HISTORY_ACTIONS ENABLE VALIDATE); CREATE INDEX VIADMIN.ACCESS_RIGHTS_IDX1 ON VIADMIN.ACCESS_RIGHTS (GROUP_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.ACCESS_RIGHTS_IDX2 ON VIADMIN.ACCESS_RIGHTS (OBJECT_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.GROUP_MEMBERS_IDX1 ON VIADMIN.GROUP_MEMBERS (USER_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.GROUP_MEMBERS_IDX2 ON VIADMIN.GROUP_MEMBERS (GROUP_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ); CREATE INDEX VIADMIN.QUEUE_ACTIONS_H_INDEX2 ON VIADMIN.QUEUE_ACTIONS_HISTORY (QUEUE_ID) LOGGING TABLESPACE "VisImport" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL DEFAULT ); ALTER TABLE VIADMIN.OBJECTS ADD ( CONSTRAINT FK_OBJECTS_OBJECT_TYPES FOREIGN KEY (OBJECT_TYPE) REFERENCES VIADMIN.OBJECT_TYPES (OBJECT_TYPE) ENABLE VALIDATE); ALTER TABLE VIADMIN.OBJECTS_HISTORY ADD ( CONSTRAINT FK_OBJECTS_HISTORY_OBJECTS FOREIGN KEY (OBJECT_ID) REFERENCES VIADMIN.OBJECTS (OBJECT_ID) ON DELETE CASCADE ENABLE VALIDATE); ALTER TABLE VIADMIN.OBJECTS_TREE ADD ( CONSTRAINT FK_OBJECTS_TREE_OBJECT_TYPES FOREIGN KEY (OBJECT_TYPE) REFERENCES VIADMIN.OBJECT_TYPES (OBJECT_TYPE) ENABLE VALIDATE); ALTER TABLE VIADMIN.QUEUE_ACTIONS ADD ( CONSTRAINT FK_QUEUE_ACTIONS_QUEUE FOREIGN KEY (QUEUE_ID) REFERENCES VIADMIN.QUEUE (QUEUE_ID) ON DELETE CASCADE ENABLE VALIDATE); ALTER TABLE VIADMIN.SCHEDULE ADD ( CONSTRAINT FK_SCHEDULE_OBJECTS_TREE FOREIGN KEY (OBJECT_ID) REFERENCES VIADMIN.OBJECTS_TREE (OBJECT_ID) ON DELETE CASCADE ENABLE VALIDATE); ALTER TABLE VIADMIN.ACCESS_RIGHTS ADD ( CONSTRAINT FK_ACCESS_RIGHTS_GROUPS FOREIGN KEY (GROUP_ID) REFERENCES VIADMIN.GROUPS (GROUP_ID) ON DELETE CASCADE ENABLE VALIDATE); ALTER TABLE VIADMIN.CONNECTIONS ADD ( CONSTRAINT FK_CONNECTIONS_OBJECTS_TYPES FOREIGN KEY (CONNECTION_TYPE) REFERENCES VIADMIN.OBJECT_TYPES (OBJECT_TYPE) ENABLE VALIDATE); ALTER TABLE VIADMIN.GROUP_MEMBERS ADD ( CONSTRAINT FK_GROUP_MEMBERS_GROUPS FOREIGN KEY (GROUP_ID) REFERENCES VIADMIN.GROUPS (GROUP_ID) ON DELETE CASCADE ENABLE VALIDATE , CONSTRAINT FK_GROUP_MEMBERS_USERS FOREIGN KEY (USER_ID) REFERENCES VIADMIN.USERS (USER_ID) ON DELETE CASCADE ENABLE VALIDATE); ALTER TABLE VIADMIN.QUEUE_ACTIONS_HISTORY ADD ( CONSTRAINT FK_QUEUE_ACTIONS_H_QUEUE_H FOREIGN KEY (QUEUE_ID) REFERENCES VIADMIN.QUEUE_HISTORY (QUEUE_ID) ON DELETE CASCADE ENABLE VALIDATE);