summaryrefslogtreecommitdiff
path: root/SQL/sqlite/2011111600.sql
blob: cea0d129ec9e4228a160508c1f58a67143f253d4 (plain)
1
2
3
4
5
6
7
8
9
10
11
-- Updates from version 0.7-beta

DROP TABLE session;
CREATE TABLE session (
  sess_id varchar(128) NOT NULL PRIMARY KEY,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  changed datetime NOT NULL default '0000-00-00 00:00:00',
  ip varchar(40) NOT NULL default '',
  vars text NOT NULL
);
CREATE INDEX ix_session_changed ON session (changed);