View Attach (2) Info

Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
png
 insert_methods.png 112.2 kB 1 29-Dec-2020 05:25 krivacsz
jpg
 sql_stats1.jpg 163.2 kB 1 29-Dec-2020 05:25 Ada Csaba

This page (revision-42) was last changed on 17-Nov-2023 16:11 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 20 changed 8 lines
CREATE TABLE META_INFO (
RID double NOT NULL,
SESSION_RID double NOT NULL,
TRANSFER_RID double NOT NULL,
ITEM_KEY varchar(100) default NULL,
ITEM_VALUE varchar(2000) default NULL,
PRIMARY KEY (RID)
);
CREATE TABLE META_INFO(RID DOUBLE NOT NULL PRIMARY KEY,SESSION_RID DOUBLE NOT NULL,TRANSFER_RID DOUBLE NOT NULL,ITEM_KEY VARCHAR(100) DEFAULT NULL,ITEM_VALUE VARCHAR(2000) DEFAULT NULL);
At line 29 changed 11 lines
CREATE TABLE SESSIONS (
RID double NOT NULL,
SESSION varchar(100) default NULL,
SERVER_GROUP varchar(50) default NULL,
USER_NAME varchar(100) default NULL,
START_TIME datetime default NULL,
END_TIME datetime default NULL,
SUCCESS_LOGIN varchar(10) default NULL,
IP varchar(50) default NULL,
PRIMARY KEY (RID)
);
CREATE TABLE SESSIONS(RID DOUBLE NOT NULL PRIMARY KEY,SESSION VARCHAR(100) DEFAULT NULL,SERVER_GROUP VARCHAR(50) DEFAULT NULL,USER_NAME VARCHAR(100) DEFAULT NULL,START_TIME DATETIME DEFAULT NULL,END_TIME DATETIME DEFAULT NULL,SUCCESS_LOGIN VARCHAR(10) DEFAULT NULL,IP VARCHAR(50) DEFAULT NULL);
At line 41 changed 13 lines
CREATE TABLE TRANSFERS (
RID double NOT NULL,
SESSION_RID double NOT NULL,
START_TIME datetime default NULL,
DIRECTION varchar(8) default NULL,
PATH varchar(255) default NULL,
FILE_NAME varchar(2000) default NULL,
URL varchar(2000) default NULL,
SPEED int default NULL,
TRANSFER_SIZE double default NULL,
IGNORE_SIZE varchar(1) default NULL,
PRIMARY KEY (RID)
);
CREATE TABLE TRANSFERS(RID DOUBLE NOT NULL PRIMARY KEY,SESSION_RID DOUBLE NOT NULL,START_TIME DATETIME DEFAULT NULL,DIRECTION VARCHAR(8) DEFAULT NULL,PATH VARCHAR(255) DEFAULT NULL,FILE_NAME VARCHAR(2000) DEFAULT NULL,URL VARCHAR(2000) DEFAULT NULL,SPEED INTEGER DEFAULT NULL,TRANSFER_SIZE DOUBLE DEFAULT NULL,IGNORE_SIZE VARCHAR(1) DEFAULT NULL);
At line 26 added 2 lines
ALTER TABLE `TRANSFERS` ADD INDEX (`SESSION_RID`,`TRANSFER_SIZE`,`DIRECTION`,`IGNORE_SIZE`,`START_TIME`);
Version Date Modified Size Author Changes ... Change note
42 17-Nov-2023 16:11 3.9 kB Ada Csaba to previous
41 17-Nov-2023 16:11 3.894 kB Ada Csaba to previous | to last
« This page (revision-42) was last changed on 17-Nov-2023 16:11 by Ada Csaba
G’day (anonymous guest)
CrushFTP10 | What's New

Referenced by
General Settings

JSPWiki