canmove, Confirmed users
1,511
edits
Socorro/SocorroUI/Installation: Difference between revisions
create sessions table
Ryansnyder (talk | contribs) |
(create sessions table) |
||
| Line 21: | Line 21: | ||
INSERT INTO product_visibility (productdims_id, start_date, end_date, featured) | INSERT INTO product_visibility (productdims_id, start_date, end_date, featured) | ||
VALUES (1, '2010-11-05', '2011-02-05', true); | VALUES (1, '2010-11-05', '2011-02-05', true); | ||
</code> | |||
Create the sessions table for Kohana: | |||
<code> | |||
CREATE TABLE sessions ( | |||
session_id varchar(127) NOT NULL, | |||
last_activity integer NOT NULL, | |||
data text NOT NULL, | |||
CONSTRAINT session_id_pkey PRIMARY KEY (session_id), | |||
CONSTRAINT last_activity_check CHECK (last_activity >= 0) | |||
); | |||
</code> | </code> | ||