[packages/php-pecl-session_mysql.git] / php-pecl-session_mysql.sql

/*

CREATE DATABASE phpsession;

GRANT SELECT,UPDATE,INSERT,DELETE
    ON phpsession.* TO 'phpsession'@'localhost' IDENTIFIED BY 'phpsession';

USE PHPSESSION;
*/

CREATE TABLE phpsession (
	sess_key char(64) not null,
	sess_mtime int(10) unsigned not null,
	sess_host char(64) not null,
	sess_val mediumblob not null,

	index i_key(sess_key(6)),
	index i_mtime(sess_mtime),
	index i_host(sess_host)
);
Commit	Line	Data
4f02ba63 ER	1	/*
4f02ba63 ER	2
61d7d411 ER	3	CREATE DATABASE phpsession;
	4
	5	GRANT SELECT,UPDATE,INSERT,DELETE
	6	ON phpsession.* TO 'phpsession'@'localhost' IDENTIFIED BY 'phpsession';
	7
	8	USE PHPSESSION;
4f02ba63 ER	9	*/
4f02ba63 ER	10
61d7d411	11	CREATE TABLE phpsession (
6ea7df9b ER	12	sess_key char(64) not null,
	13	sess_mtime int(10) unsigned not null,
	14	sess_host char(64) not null,
	15	sess_val mediumblob not null,
	16
	17	index i_key(sess_key(6)),
	18	index i_mtime(sess_mtime),
	19	index i_host(sess_host)
	20	);