View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-6) was last changed on 05-May-2017 11:47 by Ben Spink

This page was created on 09-Oct-2016 18:14 by Ben Spink

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 2 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 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 changed 6 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 TABLE CRUSHFTP.MODIFIED_TIMES (
SERVER_GROUP VARCHAR2(50),
PROP_NAME VARCHAR2(255),
PROP_VALUE VARCHAR2(255)
)
TABLESPACE CRUSHFTPDATA
;
At line 272 changed 2 lines
CREATE UNIQUE INDEX CRUSHFTP.IDX_CRUSH_WEB_CUSTOM_USERID_SO ON CRUSHFTP.WEB_CUSTOMIZATIONS (USERID, SORT_ORDER)
PCTFREE 10 INITRANS 2 MAXTRANS 255
--
-- 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
At line 275 changed one line
TABLESPACE CRUSHFTPINDX;
TABLESPACE CRUSHFTPDATA;
At line 165 added 40 lines
CREATE SEQUENCE CRUSHFTP.USERS_SEQ
INCREMENT BY 1
NOMAXVALUE
START WITH 1
MINVALUE 1
NOCACHE
NOCYCLE
ORDER;
-- trigger to get the next sequence-value for userid
CREATE OR REPLACE TRIGGER CRUSHFTP.USERS_TRG BEFORE INSERT OR UPDATE ON CRUSHFTP.USERS
FOR EACH ROW
DECLARE
v_newVal NUMBER(12) := 0;
v_incval NUMBER(12) := 0;
BEGIN
IF INSERTING AND :new.USERID IS NULL THEN
SELECT USERS_SEQ.NEXTVAL INTO v_newVal FROM DUAL;
IF v_newVal = 1 THEN
SELECT NVL(max(USERID),0) INTO v_newVal FROM USERS;
v_newVal := v_newVal + 1;
LOOP
EXIT WHEN v_incval>=v_newVal;
SELECT USERS_SEQ.nextval INTO v_incval FROM dual;
END LOOP;
END IF;
:new.USERID := v_newVal;
END IF;
END;
/
--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);
Version Date Modified Size Author Changes ... Change note
6 05-May-2017 11:47 5.994 kB Ben Spink to previous
5 01-May-2017 16:51 11.069 kB Ben Spink to previous | to last
4 09-Oct-2016 18:14 11.07 kB Ben Spink to previous | to last
3 09-Oct-2016 18:14 12.857 kB Ben Spink to previous | to last
2 09-Oct-2016 18:14 12.486 kB Ben Spink to previous | to last
1 09-Oct-2016 18:14 11.532 kB Ben Spink to last
« This page (revision-6) was last changed on 05-May-2017 11:47 by Ben Spink
G’day (anonymous guest)

OLD WIKI!!!#

New: CrushFTPv9#

OLD WIKI!!!#


CrushFTP8 | What's New

Referenced by
LeftMenu

JSPWiki