[Cs-content-commits] SF.net SVN: cs-content:[419] trunk/1.0

[<cra...@us...>]

Revision: 419
          http://cs-content.svn.sourceforge.net/cs-content/?rev=419&view=rev
Author:   crazedsanity
Date:     2009-08-06 14:46:17 +0000 (Thu, 06 Aug 2009)

Log Message:
-----------
MySQL & PostgreSQL schema for database storage of sessions (cs_sessionDB{}).

Added Paths:
-----------
    trunk/1.0/schema/
    trunk/1.0/schema/db_session_schema.mysql.sql
    trunk/1.0/schema/db_session_schema.pgsql.sql

Added: trunk/1.0/schema/db_session_schema.mysql.sql
===================================================================
--- trunk/1.0/schema/db_session_schema.mysql.sql	                        (rev 0)
+++ trunk/1.0/schema/db_session_schema.mysql.sql	2009-08-06 14:46:17 UTC (rev 419)
@@ -0,0 +1,17 @@
+
+
+--
+-- Store session data in here.
+-- Idea originally from: http://www.developertutorials.com/tutorials/php/saving-php-session-data-database-050711
+--
+
+CREATE TABLE `test`.`sess_tmp` (
+  `session_store_id` int  NOT NULL AUTO_INCREMENT,
+  `session_id` varchar(32)  NOT NULL,
+  `user_id` varchar(16)  NOT NULL,
+  `date_created` datetime  NOT NULL,
+  `last_updated` datetime  NOT NULL,
+  `session_data` LONGTEXT  NOT NULL,
+  PRIMARY KEY (`session_store_id`)
+)
+ENGINE = MyISAM;
\ No newline at end of file

Added: trunk/1.0/schema/db_session_schema.pgsql.sql
===================================================================
--- trunk/1.0/schema/db_session_schema.pgsql.sql	                        (rev 0)
+++ trunk/1.0/schema/db_session_schema.pgsql.sql	2009-08-06 14:46:17 UTC (rev 419)
@@ -0,0 +1,16 @@
+
+
+--
+-- Store session data in here.
+-- Idea originally from: http://www.developertutorials.com/tutorials/php/saving-php-session-data-database-050711
+--
+
+CREATE TABLE cs_session_store_table (
+	session_store_id serial NOT NULL PRIMARY KEY,
+	session_id varchar(32) NOT NULL DEFAULT '' UNIQUE,
+	user_id varchar(16),
+	date_created timestamp NOT NULL DEFAULT NOW(),
+	last_updated timestamp NOT NULL DEFAULT NOW(),
+	session_data text
+);
+


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.