· 8 years ago · May 30, 2018, 02:20 AM
1CREATE TABLE IF NOT EXISTS `session` (
2 `id` char(32) NOT NULL,
3 `data` varchar(20000) NOT NULL,
4 `time_created` timestamp NOT NULL default '0000-00-00 00:00:00',
5 `time_updated` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
6 PRIMARY KEY (`id`),
7 KEY `time_created` (`time_created`),
8 KEY `time_updated` (`time_updated`)
9) ENGINE=MEMORY DEFAULT CHARSET=utf8;