summaryrefslogtreecommitdiff
path: root/schema/versions
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2011-04-01 15:25:19 +0400
committerAndrew Dolgov <[email protected]>2011-04-01 15:26:02 +0400
commit9507ab7f9272556ab0ea28a3688b995b4a14538a (patch)
treec4ef2f2bfdaf88bfe26aca2e6a90de803ce483fa /schema/versions
parent6110d441831e10547ff8f62243e87f979a5e69c8 (diff)
schema: remove ttrss_themes
Diffstat (limited to 'schema/versions')
-rw-r--r--schema/versions/mysql/83.sql3
-rw-r--r--schema/versions/pgsql/83.sql3
2 files changed, 6 insertions, 0 deletions
diff --git a/schema/versions/mysql/83.sql b/schema/versions/mysql/83.sql
index 6457539a1..6c7d5ce42 100644
--- a/schema/versions/mysql/83.sql
+++ b/schema/versions/mysql/83.sql
@@ -24,6 +24,9 @@ update ttrss_feeds set pubsub_state = 0;
alter table ttrss_feeds change pubsub_state pubsub_state integer not null;
alter table ttrss_feeds alter column pubsub_state set default 0;
+alter table ttrss_users drop column theme_id;
+drop table ttrss_themes;
+
update ttrss_version set schema_version = 83;
commit;
diff --git a/schema/versions/pgsql/83.sql b/schema/versions/pgsql/83.sql
index c622f8137..a89086551 100644
--- a/schema/versions/pgsql/83.sql
+++ b/schema/versions/pgsql/83.sql
@@ -24,6 +24,9 @@ update ttrss_feeds set pubsub_state = 0;
alter table ttrss_feeds alter column pubsub_state set not null;
alter table ttrss_feeds alter column pubsub_state set default 0;
+alter table ttrss_users drop column theme_id;
+drop table ttrss_themes;
+
update ttrss_version set schema_version = 83;
commit;