php-pecl-session_mysql.sql

   1 /*
   2
   3 CREATE DATABASE phpsession;
   4
   5 GRANT SELECT,UPDATE,INSERT,DELETE
   6     ON phpsession.* TO 'phpsession'@'localhost' IDENTIFIED BY 'phpsession';
   7
   8 USE PHPSESSION;
   9 */
  10
  11 CREATE TABLE phpsession (
  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 );