php和tomcat session结构

php

CREATE TABLE `session` (

`skey` char(32) CHARACTER SET ascii NOT NULL,

`data` text COLLATE utf8mb4_bin,

`expire` int(11) NOT NULL,

PRIMARY KEY (`skey`),

KEY `index_session_expire` (`expire`) USING BTREE

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

tomcat

CREATE TABLE sessions (

session_id    VARCHAR(100) NOT NULL PRIMARY KEY,

valid_session CHAR(1) NOT NULL,

max_inactive  INT NOT NULL,

last_access   BIGINT NOT NULL,

app_name      VARCHAR (255),

session_data  MEDIUMBLOB,

KEY kapp_name(app_name)

);