PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Lars Moelleken   PHP Session MySQL Handler   install/session_data.sql   Download  
File: install/session_data.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Session MySQL Handler
Handler for storing session data in MySQL
Author: By
Last change: [*]: try to fix travis-ci build v2.1
[+]: testing more future-proof sql-query (no code changes, so it's still no BC) v2
[+]: testing more future-proof sql-query (no code changes, so it's still no BC)
Date: 8 years ago
Size: 423 bytes
 

Contents

Class file image Download 
CREATE TABLE session_data (
  session_id varchar(128) NOT NULL default "",
  hash varchar(128) NOT NULL default "",
  session_data blob NOT NULL,
  session_expire int(11) NOT NULL default "0",
  PRIMARY KEY session_id (`session_id`),
  KEY hash (`hash`),
  KEY session_expire (`session_expire`),
  KEY select_helper_index (`session_id`, `hash`, `session_expire`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;