diff options
author | Andrew Dolgov <[email protected]> | 2011-04-01 15:32:27 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2011-04-01 15:32:27 +0400 |
commit | dd0345769a772272bcca7be2ecbfd107012c9d57 (patch) | |
tree | 3483bc2a2383aedf05e8e8d75a0706fe69a9b6fc | |
parent | 9507ab7f9272556ab0ea28a3688b995b4a14538a (diff) |
schema: mysql: remove foreign key to ttrss_themes before dropping theme_id from ttrss_users
-rw-r--r-- | schema/versions/mysql/83.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/schema/versions/mysql/83.sql b/schema/versions/mysql/83.sql index 6c7d5ce42..5e791b23d 100644 --- a/schema/versions/mysql/83.sql +++ b/schema/versions/mysql/83.sql @@ -24,7 +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 foreign key ttrss_users_ibfk_1 alter table ttrss_users drop column theme_id; + drop table ttrss_themes; update ttrss_version set schema_version = 83; |