| At line 1 added 3 lines |
| __IMPORTANT: due to the security updates since CrushFTP version 10.5.2+ any JDBC driver jar file needs to be placed into the CrushFTP10/plugins/lib/ directory, or it won't load.__ |
| \\ |
| \\ |
| At line 5 added 2 lines |
|
|
| At line 12 changed one line |
| PASSWORD VARCHAR2(255) NOT NULL, |
| PASSWORD VARCHAR2(255), |
| At line 35 removed 7 lines |
| ALTER TABLE CRUSHFTP.USER_PROPERTIES ADD ( |
| CONSTRAINT CRUSH_USER_PROPERTIES_PK PRIMARY KEY (USERID, PROP_NAME) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_USER_PROP_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| At line 46 added one line |
| SORT_ORDER NUMBER(3), |
| At line 53 removed 7 lines |
| ALTER TABLE CRUSHFTP.DOMAIN_ROOT_LIST ADD ( |
| CONSTRAINT CRUSH_DOMAIN_ROOT_LIST_PK PRIMARY KEY (USERID, DOMAIN, PATH) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_DOMAIN_ROOT_LIST_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
| |
| At line 61 removed 40 lines |
| -- CREATE EVENTS |
| -- |
| CREATE TABLE CRUSHFTP.EVENTS ( |
| USERID NUMBER(8) NOT NULL, |
| SQL_FIELD_NAME VARCHAR2(255) NOT NULL, |
| COMMAND VARCHAR2(255) NOT NULL, |
| EVENT_DIR_DATA VARCHAR2(255), |
| EVENT_IF_LIST VARCHAR2(255), |
| EVENT_ACTION_LIST VARCHAR2(255), |
| EVENT_USER_ACTION_LIST VARCHAR2(255), |
| EVENT_AFTER_LIST VARCHAR2(255), |
| EVENT_PLUGIN_LIST VARCHAR2(255) NOT NULL, |
| SQL_FIELD_FROM VARCHAR2(255), |
| SQL_FIELD_TO VARCHAR2(255), |
| CC VARCHAR2(255), |
| BCC VARCHAR2(255), |
| SUBJECT VARCHAR2(255), |
| BODY VARCHAR2(255), |
| EVENT_ALWAYS_CB VARCHAR2(10) DEFAULT 'false', |
| EVENT_AFTER_CB VARCHAR2(10) DEFAULT 'false', |
| EVENT_NOW_CB VARCHAR2(10) DEFAULT 'false', |
| EVENT_IF_CB VARCHAR2(10) DEFAULT 'false', |
| SORT_ORDER NUMBER(3)) |
| PCTFREE 10 INITRANS 1 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPDATA; |
|
| ALTER TABLE CRUSHFTP.EVENTS ADD ( |
| CONSTRAINT CRUSH_EVENTS_PK PRIMARY KEY (USERID, SQL_FIELD_NAME) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_EVENTS_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| CREATE UNIQUE INDEX CRUSHFTP.IDX_CRUSH_EVENTS_USERID_SO ON CRUSHFTP.EVENTS (USERID, SORT_ORDER) |
| PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX; |
|
| -- |
| At line 112 removed 7 lines |
| ALTER TABLE CRUSHFTP.EVENTS5 ADD ( |
| CONSTRAINT CRUSH_EVENTS5_PK PRIMARY KEY (USERID, EVENT_NAME, PROP_NAME) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_EVENTS5_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| At line 130 removed 7 lines |
| ALTER TABLE CRUSHFTP.GROUPS ADD ( |
| CONSTRAINT CRUSH_GROUP_PK PRIMARY KEY (GROUPNAME, USERID) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_GROUP_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| At line 148 removed 12 lines |
| ALTER TABLE CRUSHFTP.INHERITANCE ADD ( |
| CONSTRAINT CRUSH_INHERITANCE_PK PRIMARY KEY (USERID, INHERIT_USERNAME) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_INHERITANCE_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| CREATE UNIQUE INDEX CRUSHFTP.IDX_CRUSH_INHERITANCE_USRID_SO ON CRUSHFTP.INHERITANCE (USERID, SORT_ORDER) |
| PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX; |
|
| At line 173 removed 13 lines |
| ALTER TABLE CRUSHFTP.IP_RESTRICTIONS ADD ( |
| CONSTRAINT CRUSH_IP_RESTR_PK PRIMARY KEY (USERID, START_IP) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_IP_RESTR_TYPE_C CHECK (TYPE IN ('A','D')), |
| CONSTRAINT CRUSH_IP_RESTR_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| CREATE UNIQUE INDEX CRUSHFTP.IDX_CRUSH_IP_RESTR_USERID_SO ON CRUSHFTP.IP_RESTRICTIONS (USERID, SORT_ORDER) |
| PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX; |
|
| At line 191 changed 3 lines |
| URL VARCHAR2(255) NOT NULL, |
| TYPE VARCHAR2(50) NOT NULL, |
| PATH VARCHAR2(255) NOT NULL, |
| URL VARCHAR2(255), |
| TYPE VARCHAR2(50), |
| PATH VARCHAR2(255), |
| At line 199 removed 12 lines |
| ALTER TABLE CRUSHFTP.VFS ADD ( |
| CONSTRAINT CRUSH_VFS_PK PRIMARY KEY (USERID, PATH) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_VFS_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| CREATE UNIQUE INDEX CRUSHFTP.IDX_CRUSH_VFS_USERID_SO ON CRUSHFTP.VFS (USERID, SORT_ORDER) |
| PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX; |
|
| At line 222 removed 7 lines |
| ALTER TABLE CRUSHFTP.VFS_PERMISSIONS ADD ( |
| CONSTRAINT CRUSH_VFS_PERMISSIONS_PK PRIMARY KEY (USERID, PATH) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_VFS_PERMISSIONS_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| At line 235 changed one line |
| SQL_FIELD_VALUE VARCHAR2(255) NOT NULL, |
| SQL_FIELD_VALUE VARCHAR2(255), |
| FOR_MENU VARCHAR2(10), |
| FOR_CONTEXT_MENU VARCHAR2(10), |
| At line 241 removed 12 lines |
| ALTER TABLE CRUSHFTP.WEB_BUTTONS ADD ( |
| CONSTRAINT CRUSH_WEB_BUTTONS_PK PRIMARY KEY (USERID, SQL_FIELD_KEY) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_WEB_BUTTONS_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| CREATE UNIQUE INDEX CRUSHFTP.IDX_CRUSH_WEB_BUTTONS_USRID_SO ON CRUSHFTP.WEB_BUTTONS (USERID, SORT_ORDER) |
| PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX; |
|
| At line 259 changed one line |
| SQL_FIELD_VALUE VARCHAR2(255) NOT NULL, |
| SQL_FIELD_VALUE VARCHAR2(255), |
| At line 265 removed 12 lines |
| ALTER TABLE CRUSHFTP.WEB_CUSTOMIZATIONS ADD ( |
| CONSTRAINT CRUSH_WEB_CUSTOMIZATIONS_PK PRIMARY KEY (USERID, SQL_FIELD_KEY) |
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX, |
| CONSTRAINT CRUSH_WEB_CUSTOM_USER_FK FOREIGN KEY (USERID) REFERENCES CRUSHFTP.USERS (USERID) ON DELETE CASCADE); |
|
| CREATE UNIQUE INDEX CRUSHFTP.IDX_CRUSH_WEB_CUSTOM_USERID_SO ON CRUSHFTP.WEB_CUSTOMIZATIONS (USERID, SORT_ORDER) |
| PCTFREE 10 INITRANS 2 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPINDX; |
|
| At line 157 added 13 lines |
| -- |
| -- CREATE USER_PROPERTIES |
| -- |
| CREATE TABLE CRUSHFTP.VFS_PROPERTIES ( |
| USERID NUMBER(8) NOT NULL, |
| PATH VARCHAR2(1024), |
| PROP_NAME VARCHAR2(255) NOT NULL, |
| PROP_VALUE VARCHAR2(2000)) |
| PCTFREE 10 INITRANS 1 MAXTRANS 255 |
| STORAGE (INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT) |
| TABLESPACE CRUSHFTPDATA; |
|
|
| At line 199 added one line |
| / |
| At line 201 added 8 lines |
| --following is the additional table |
| CREATE TABLE CRUSHFTP.CRUSHFTP_LOG ( |
| LOG_ROW_NUM NUMBER NOT NULL PRIMARY KEY, |
| LOG_MILLIS NUMBER NOT NULL, |
| LOG_TAG VARCHAR2(50) DEFAULT NULL, |
| LOG_DATA VARCHAR2(2000) DEFAULT NULL); |
|
|
