From 3b0f23de404fb1616a80db06b8641d2f44a80291 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 28 Mar 2006 04:45:30 +0100 Subject: [PATCH] schema: drop ip_address from ttrss_sessions --- schema/upgrade-1.1.4-1.1.5-mysql.sql | 2 ++ schema/upgrade-1.1.4-1.1.5-pgsql.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/schema/upgrade-1.1.4-1.1.5-mysql.sql b/schema/upgrade-1.1.4-1.1.5-mysql.sql index 2c48e039..9fec820f 100644 --- a/schema/upgrade-1.1.4-1.1.5-mysql.sql +++ b/schema/upgrade-1.1.4-1.1.5-mysql.sql @@ -5,5 +5,7 @@ update ttrss_feeds set rtl_content = false; alter table ttrss_feeds change rtl_content rtl_content bool not null; alter table ttrss_feeds alter column rtl_content set default false; +alter table ttrss_sessions drop column ip_address; + update ttrss_version set schema_version = 7; diff --git a/schema/upgrade-1.1.4-1.1.5-pgsql.sql b/schema/upgrade-1.1.4-1.1.5-pgsql.sql index 67bb7d86..405daf62 100644 --- a/schema/upgrade-1.1.4-1.1.5-pgsql.sql +++ b/schema/upgrade-1.1.4-1.1.5-pgsql.sql @@ -7,6 +7,8 @@ update ttrss_feeds set rtl_content = false; alter table ttrss_feeds alter column rtl_content set not null; alter table ttrss_feeds alter column rtl_content set default false; +alter table ttrss_sessions drop column ip_address; + update ttrss_version set schema_version = 7; commit; -- 2.39.5