· 8 years ago · Jun 19, 2018, 03:24 PM
1CREATE TABLE IF NOT EXISTS ci_sessions (
2 session_id varchar(40) NOT NULL DEFAULT '0',
3 ip_address varchar(45) NOT NULL DEFAULT '0',
4 user_agent varchar(120) NOT NULL,
5 last_activity int check (last_activity > 0) NOT NULL DEFAULT '0',
6 user_data text NOT NULL,
7 PRIMARY KEY (session_id)
8) ;
9
10CREATE INDEX last_activity_idx ON ci_sessions (last_activity);
11
12$config['sess_driver'] = 'database';
13$config['sess_cookie_name'] = 'ci_session';
14$config['sess_expiration'] = 7200;
15$config['sess_save_path'] = 'ci_sessions';
16$config['sess_match_ip'] = FALSE;
17$config['sess_time_to_update'] = 300;
18$config['sess_regenerate_destroy'] = FALSE;
19
20Severity: Warning
21
22CREATE TABLE "ci_sessions" (
23 "id" varchar(128) NOT NULL,
24 "ip_address" varchar(45) NOT NULL,
25 "timestamp" bigint DEFAULT 0 NOT NULL,
26 "data" text DEFAULT '' NOT NULL
27);
28
29CREATE INDEX "ci_sessions_timestamp" ON "ci_sessions" ("timestamp");