diff options
| author | Andrew Dolgov <[email protected]> | 2006-03-02 13:15:28 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2006-03-02 13:15:28 +0100 |
| commit | 04febb0429adb24da43ac33bc6d925d450e10b60 (patch) | |
| tree | 1ac3f2598dde0a97a2a65cce8007942b5d17dd96 /schema/upgrade-1.1.3-1.1.4-mysql.sql | |
| parent | 9f3a7455689982f1c83c117f7f25396a8af687af (diff) | |
shrink session id length in db
Diffstat (limited to 'schema/upgrade-1.1.3-1.1.4-mysql.sql')
| -rw-r--r-- | schema/upgrade-1.1.3-1.1.4-mysql.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/schema/upgrade-1.1.3-1.1.4-mysql.sql b/schema/upgrade-1.1.3-1.1.4-mysql.sql index 37b3674dc..329a297c6 100644 --- a/schema/upgrade-1.1.3-1.1.4-mysql.sql +++ b/schema/upgrade-1.1.3-1.1.4-mysql.sql @@ -5,11 +5,11 @@ update ttrss_entries set author = ''; alter table ttrss_entries change author author varchar(250) not null; alter table ttrss_entries alter column author set default ''; -create table ttrss_sessions (id varchar(300) unique not null primary key, +create table ttrss_sessions (id varchar(250) not null primary key, data text, expire integer not null, ip_address varchar(15) not null default '', - index (id), + index (id), index (expire)) TYPE=InnoDB; update ttrss_version set schema_version = 6; |