File: mysql-tables.sql

-- MySQL database structure for class mk_db_session by Mariusz Kaczmarczyk
-- http://www.phpclasses.org/browse/package/3143.html


-- (replace <prefix> with what you set to mk_db_session::db_table_prefix):

CREATE TABLE <prefix>session_ids (
	id INT(20) NOT NULL AUTO_INCREMENT,
	client_id_name VARCHAR(32) NOT NULL DEFAULT "",
	start_s70 BIGINT(20) NOT NULL DEFAULT "0",
	last_s70 BIGINT(20) NOT NULL DEFAULT "0",
	remote_addr VARCHAR(64) DEFAULT NULL,
	active ENUM("0", "1") DEFAULT "1",
	PRIMARY KEY (id),
	UNIQUE KEY client_id_name (client_id_name)
) COMMENT="session IDs storage";

CREATE TABLE <prefix>session_var (
	id INT(20) NOT NULL AUTO_INCREMENT,
	session_id VARCHAR(64) NOT NULL DEFAULT "",
	var_name VARCHAR(64) NOT NULL DEFAULT "",
	type ENUM("boolean", "integer", "double", "string", "array", "NULL") DEFAULT "string",
	value BLOB,
	PRIMARY KEY (id)
) COMMENT="session variables storage";