new option: SESSION_CHECK_ADDRESS

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);