1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE session(
id int(10) unsigned not null auto_increment,
session_id varchar(255) not null,
username varchar(10) not null collate utf8_bin,
user_lvl enum('standard', 'reseller', 'sysadmin', 'groupadm') not null default 'standard',
ip_addr varchar(255) not null,
port varchar(255) not null,
created datetime not null,
modified datetime not null,
last_action varchar(255) null default null,
constraint `PRIMARY` primary key(id),
key created_time(created, modified),
constraint session_id unique(session_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
