click_stream.sql

来自「Java的框架」· SQL 代码 · 共 28 行

USE PRRM;

CREATE TABLE IF NOT EXISTS CLICK_STREAM (
		SESSION_ID VARCHAR(255) NOT NULL PRIMARY KEY,
    USERNAME VARCHAR(20) NOT NULL,
    HOSTNAME VARCHAR(255),
    INITIAL_REFERRER TEXT,
    STREAM_START DATETIME,
    LAST_REQUEST DATETIME,
    STREAM_LENGTH BIGINT,
    BOT BIT    
)		ENGINE=INNODB
;

CREATE TABLE IF NOT EXISTS CLICK_STREAM_REQUEST (
		ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
		SESSION_ID VARCHAR(255) NOT NULL,
		PROTOCOL VARCHAR (255),
		SERVER_NAME VARCHAR (255),
		SERVER_PORT SMALLINT,
    REQUEST_URI TEXT,
    QUERY_STRING TEXT,
    REMOTE_USER VARCHAR (255),
    TIME_STAMP DATETIME,
    INDEX (SESSION_ID),
		FOREIGN KEY (SESSION_ID) REFERENCES CLICK_STREAM (SESSION_ID) ON DELETE CASCADE
)		ENGINE=INNODB
;