diff options
author | Andrew Dolgov <[email protected]> | 2006-03-02 09:32:44 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-03-02 09:32:44 +0100 |
commit | 09018e9526843334144d90c1891de2489148f85f (patch) | |
tree | f8cb246596ec592cb10cdc0ddd92ed44e792f8e7 /schema | |
parent | 8fd92701e9074b79a72982809a6a87f8e943399a (diff) |
new option: SESSION_CHECK_ADDRESS
Diffstat (limited to 'schema')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 1 | ||||
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 5 | ||||
-rw-r--r-- | schema/upgrade-1.1.3-1.1.4-mysql.sql | 1 | ||||
-rw-r--r-- | schema/upgrade-1.1.3-1.1.4-pgsql.sql | 3 |
4 files changed, 7 insertions, 3 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 540fc0f22..671577cf9 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -259,6 +259,7 @@ create table ttrss_scheduled_updates (id integer not null primary key auto_incre create table ttrss_sessions (id varchar(300) unique not null primary key, data text, expire integer not null, + ip_address varchar(15) not null default '', index (id), index (expire)) TYPE=InnoDB; diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index c6bc45217..e393353a8 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -232,8 +232,9 @@ create table ttrss_scheduled_updates (id serial not null primary key, entered timestamp not null default NOW()); create table ttrss_sessions (id varchar(300) unique not null primary key, - data text, - expire integer not null); + data text, + expire integer not null, + ip_address varchar(15) not null default ''); create index ttrss_sessions_expire_index on ttrss_sessions(expire); 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 32b45e897..37b3674dc 100644 --- a/schema/upgrade-1.1.3-1.1.4-mysql.sql +++ b/schema/upgrade-1.1.3-1.1.4-mysql.sql @@ -8,6 +8,7 @@ alter table ttrss_entries alter column author set default ''; create table ttrss_sessions (id varchar(300) unique not null primary key, data text, expire integer not null, + ip_address varchar(15) not null default '', index (id), index (expire)) TYPE=InnoDB; diff --git a/schema/upgrade-1.1.3-1.1.4-pgsql.sql b/schema/upgrade-1.1.3-1.1.4-pgsql.sql index d1d310f3d..0191d6ede 100644 --- a/schema/upgrade-1.1.3-1.1.4-pgsql.sql +++ b/schema/upgrade-1.1.3-1.1.4-pgsql.sql @@ -9,7 +9,8 @@ alter table ttrss_entries alter column author set default ''; create table ttrss_sessions (id varchar(300) unique not null primary key, data text, - expire integer not null); + expire integer not null, + ip_address varchar(15) not null default ''); create index ttrss_sessions_id_index on ttrss_sessions(id); create index ttrss_sessions_expire_index on ttrss_sessions(expire); |