Login   Register  
PHP Classes
elePHPant
Icontem

File: user_sessions.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Volker Rubach  >  Simple Session (PDO / MySQL)  >  user_sessions.sql  >  Download  
File: user_sessions.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL Create Statement
Class: Simple Session (PDO / MySQL)
Store session data in MySQL using PDO
Author: By
Last change:
Date: 2012-02-10 16:16
Size: 477 bytes
 

Contents

Class file image Download 
--
-- Table structure for table `user_sessions`
--

CREATE TABLE IF NOT EXISTS `user_sessions` (
  `id` varchar(32) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `fingerprint` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `data` text COLLATE latin1_general_ci,
  `access` int(32) NOT NULL DEFAULT '0',
  `date` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;