PHP Classes

File: mysql.sql

Recommend this page to a friend!
  Classes of Ska-Man   My Session   mysql.sql   Download  
File: mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL Script
Class: My Session
Database based session management
Author: By
Last change: new release
Date: 13 years ago
Size: 645 bytes
 

Contents

Class file image Download
CREATE TABLE IF NOT EXISTS `mySession_Sessions` ( `sid` varchar(100) NOT NULL DEFAULT '', `expires` int(11) unsigned NOT NULL DEFAULT '0', `forced_expires` int(11) unsigned NOT NULL, `ua` varchar(40) NOT NULL DEFAULT '', PRIMARY KEY (`sid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS `mySession_Vars` ( `name` text NOT NULL, `value` text NOT NULL, `sid` varchar(100) NOT NULL, KEY `sid` (`sid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ALTER TABLE `mySession_Vars` ADD CONSTRAINT `mySession_Vars_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `mySession_Sessions` (`sid`) ON DELETE CASCADE;