View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-8) was last changed on 17-Nov-2023 16:14 by Ada Csaba

This page was created on 29-Dec-2020 05:25 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
8 17-Nov-2023 16:14 6.214 kB Ada Csaba to previous
7 04-Jul-2022 10:31 6.025 kB Ben Spink to previous | to last
6 29-Dec-2020 05:25 5.994 kB Ben Spink to previous | to last
5 29-Dec-2020 05:25 11.069 kB Ben Spink to previous | to last
4 29-Dec-2020 05:25 11.07 kB Ben Spink to previous | to last
3 29-Dec-2020 05:25 12.857 kB Ben Spink to previous | to last
2 29-Dec-2020 05:25 12.486 kB Ben Spink to previous | to last
1 29-Dec-2020 05:25 11.532 kB Ben Spink to last
« This page (revision-8) was last changed on 17-Nov-2023 16:14 by Ada Csaba
G’day (anonymous guest)
CrushFTP10 | What's New

Referenced by
LeftMenu

JSPWiki