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

create database phpsession;
grant all privileges on phpsession.* to phpsession 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
6ea7df9b ER	1	create database phpsession;
	2	grant all privileges on phpsession.* to phpsession identified by "phpsession";
	3	use phpsession;
	4	create table phpsession (
	5	sess_key char(64) not null,
	6	sess_mtime int(10) unsigned not null,
	7	sess_host char(64) not null,
	8	sess_val mediumblob not null,
	9
	10	index i_key(sess_key(6)),
	11	index i_mtime(sess_mtime),
	12	index i_host(sess_host)
	13	);