| 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 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 72 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 90 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 108 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 133 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 159 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 182 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 203 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 227 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 248 changed one line |
| -- CREATE VFS_PROPERTIES |
| -- CREATE USER_PROPERTIES |
| 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); |
|
|
