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 12 changed one line
PASSWORD VARCHAR2(255) NOT NULL,
PASSWORD VARCHAR2(255),
At line 59 removed 28 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;
At line 88 removed 12 lines
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 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 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 259 changed one line
SQL_FIELD_VALUE VARCHAR2(255) NOT NULL,
SQL_FIELD_VALUE VARCHAR2(255),
At line 290 changed one line
PATH VARCHAR2(1024) NOT NULL,
PATH VARCHAR2(1024),
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