Mercurial > hg > rc2

annotate SQL/sqlite/2016081200.sql @ 8:bf99236cc5cd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
try to recover from upgrade fail
author Charlie Root
date Sat, 29 Dec 2018 07:07:34 -0500
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
8
bf99236cc5cd try to recover from upgrade fail
Charlie Root
parents:
diff changeset
1 DROP TABLE session;
bf99236cc5cd try to recover from upgrade fail
Charlie Root
parents:
diff changeset
2 CREATE TABLE session (
bf99236cc5cd try to recover from upgrade fail
Charlie Root
parents:
diff changeset
3 sess_id varchar(128) NOT NULL PRIMARY KEY,
bf99236cc5cd try to recover from upgrade fail
Charlie Root
parents:
diff changeset
4 changed datetime NOT NULL default '0000-00-00 00:00:00',
bf99236cc5cd try to recover from upgrade fail
Charlie Root
parents:
diff changeset
5 ip varchar(40) NOT NULL default '',
bf99236cc5cd try to recover from upgrade fail
Charlie Root
parents:
diff changeset
6 vars text NOT NULL
bf99236cc5cd try to recover from upgrade fail
Charlie Root
parents:
diff changeset
7 );
bf99236cc5cd try to recover from upgrade fail
Charlie Root
parents:
diff changeset
8
bf99236cc5cd try to recover from upgrade fail
Charlie Root
parents:
diff changeset
9 CREATE INDEX ix_session_changed ON session (changed);