Posted By

pdswan on 07/29/09

Tagged

mysql
codeigniter

Versions (?)

Last Edited at 07/29/09 01:40pm

Statistics

Viewed 966 times

Favorited by 4 user(s)

Related snippets

CodeIgniter Session Table SQL

/ Published in: SQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

CREATE TABLE IF NOT EXISTS  `ci_sessions` (
session_id VARCHAR(40) DEFAULT '0' NOT NULL,
ip_address VARCHAR(16) DEFAULT '0' NOT NULL,
user_agent VARCHAR(50) NOT NULL,
last_activity INT(10) UNSIGNED DEFAULT 0 NOT NULL,
user_data text NOT NULL,
PRIMARY KEY (session_id)
);