Login   Register  
PHP Classes
elePHPant
Icontem

File: setup.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Guilherme Blanco  >  DcSessionManager  >  setup.sql  >  Download  
File: setup.sql
Role: Auxiliary data
Content type: text/plain
Description: MySQL Table
Class: DcSessionManager
Manage sessions using a MySQL table to store data
Author: By
Last change:
Date: 2004-05-04 20:22
Size: 351 bytes
 

Contents

Class file image Download 
CREATE TABLE `sessHandler` (
    `sHashId` CHAR( 32 ) NOT NULL ,
    `sSessId` CHAR( 32 ) NOT NULL ,
    `sValues` TEXT,
    `dDateRegistered` DATETIME NOT NULL ,
    `nExpire` BIGINT UNSIGNED NOT NULL ,
    `bSaveSession` INT DEFAULT '0' NOT NULL ,
    PRIMARY KEY ( `sHashId` , `sSessId` ) ,
    INDEX ( `dDateRegistered` , `nExpire` )
);