- database schema extraced from README

Changed files:
    php-pecl-session_mysql.sql -> 1.1

diff --git a/php-pecl-session_mysql.sql b/php-pecl-session_mysql.sql
new file mode 100644 (file)
index 0000000..f316e07
--- /dev/null
+++ b/php-pecl-session_mysql.sql
@@ -0,0 +1,13 @@
+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)
+);