1
2
3
4
5
6
7
8
9
10
11
12
13

CREATE TABLE `sessions` (
  `sess_id` varchar(33) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `type` smallint(5) unsigned NOT NULL,
  `login` varchar(255) CHARACTER SET utf8 NOT NULL,
  `ip_address` varchar(39) CHARACTER SET ascii NOT NULL,
  `login_time` datetime NOT NULL,
  `click_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified` int(10) unsigned DEFAULT NULL,
  `lifetime` int(10) unsigned DEFAULT NULL,
  `data` mediumblob,
  `ip_dual_stack` varchar(39) CHARACTER SET ascii DEFAULT NULL,
  PRIMARY KEY (`sess_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `sessions` ( `sess_id` varchar(33) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `type` smallint(5) unsigned NOT NULL, `login` varchar(255) CHARACTER SET utf8 NOT NULL, `ip_address` varchar(39) CHARACTER SET ascii NOT NULL, `login_time` datetime NOT NULL, `click_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `modified` int(10) unsigned DEFAULT NULL, `lifetime` int(10) unsigned DEFAULT NULL, `data` mediumblob, `ip_dual_stack` varchar(39) CHARACTER SET ascii DEFAULT NULL, PRIMARY KEY (`sess_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1