Browse
Test DB Auto Increment Primary Keys Learn more
Reset To Default Cancel OK
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); 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); 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); ALTER TABLE `TRANSFERS` ADD INDEX (`SESSION_RID`,`TRANSFER_SIZE`,`DIRECTION`,`IGNORE_SIZE`,`START_TIME`); CREATE INDEX idx_sessions_time_user ON SESSIONS (START_TIME, END_TIME, USER_NAME); CREATE INDEX idx_sessions_success_user ON SESSIONS (SUCCESS_LOGIN, USER_NAME); CREATE INDEX idx_sessions_server_group_time ON SESSIONS (SERVER_GROUP, START_TIME); CREATE INDEX idx_transfers_session_time ON TRANSFERS (SESSION_RID, START_TIME); CREATE INDEX idx_transfers_direction_time ON TRANSFERS (DIRECTION, START_TIME); CREATE INDEX idx_transfers_names ON TRANSFERS (FILE_NAME(100), PATH(255), DIRECTION); CREATE INDEX idx_meta_info_transfer ON META_INFO (TRANSFER_RID); CREATE INDEX idx_meta_info_session ON META_INFO (SESSION_RID);
CREATE TABLE META_INFO(RID BIGINT NOT NULL PRIMARY KEY,SESSION_RID BIGINT NOT NULL,TRANSFER_RID BIGINT NOT NULL,ITEM_KEY VARCHAR(100) DEFAULT NULL,ITEM_VALUE VARCHAR(2000) DEFAULT NULL); CREATE TABLE SESSIONS(RID BIGINT 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); CREATE TABLE TRANSFERS(RID BIGINT NOT NULL PRIMARY KEY,SESSION_RID BIGINT 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 BIGINT DEFAULT NULL,IGNORE_SIZE VARCHAR(1) DEFAULT NULL); CREATE NONCLUSTERED INDEX idx_sessions_time_user ON SESSIONS (START_TIME, END_TIME, USER_NAME); CREATE NONCLUSTERED INDEX idx_sessions_success_user ON SESSIONS (SUCCESS_LOGIN, USER_NAME); CREATE NONCLUSTERED INDEX idx_sessions_server_group_time ON SESSIONS (SERVER_GROUP, START_TIME); CREATE NONCLUSTERED INDEX idx_transfers_session_time ON TRANSFERS (SESSION_RID, START_TIME); CREATE NONCLUSTERED INDEX idx_transfers_direction_time ON TRANSFERS (DIRECTION, START_TIME); CREATE NONCLUSTERED INDEX idx_transfers_names ON TRANSFERS (FILE_NAME, PATH, DIRECTION); CREATE NONCLUSTERED INDEX idx_meta_info_transfer ON META_INFO (TRANSFER_RID); CREATE NONCLUSTERED INDEX idx_meta_info_session ON META_INFO (SESSION_RID);
Example Queries: -- Select an example -- All Sessions All Transfers Sessions by Username Sessions by Username and Date Transfers by Username, Date and Direction
SQL Query:
Return Limit:
Execute Query Clear