diff options
author | Art4 <[email protected]> | 2015-02-19 23:17:43 +0100 |
---|---|---|
committer | Art4 <[email protected]> | 2015-02-19 23:17:43 +0100 |
commit | d9c042c4c536f1afbf206aeea09b0b127b7b6418 (patch) | |
tree | 9d7ef18c6d9d4c8f8f4d1c9a5dbfceeb9fd5acf4 /schema/versions | |
parent | cf42b79120290ee5866136a0c4656e6999f06045 (diff) | |
parent | 4ca621a36016de1fbb5447e1c1de0b607ba94a7c (diff) |
Merge branch 'master' into patch-1
Conflicts:
locale/de_DE/LC_MESSAGES/messages.po
Diffstat (limited to 'schema/versions')
-rw-r--r-- | schema/versions/mysql/127.sql | 18 | ||||
-rw-r--r-- | schema/versions/pgsql/127.sql | 8 |
2 files changed, 26 insertions, 0 deletions
diff --git a/schema/versions/mysql/127.sql b/schema/versions/mysql/127.sql new file mode 100644 index 000000000..5dcc23b2f --- /dev/null +++ b/schema/versions/mysql/127.sql @@ -0,0 +1,18 @@ +BEGIN; + +ALTER TABLE ttrss_enclosures DROP INDEX post_id; +ALTER TABLE ttrss_entries DROP INDEX ttrss_entries_guid_index; +ALTER TABLE ttrss_feeds DROP INDEX owner_uid; +ALTER TABLE ttrss_feeds DROP INDEX cat_id; +ALTER TABLE ttrss_prefs DROP INDEX ttrss_prefs_pref_name_idx; +ALTER TABLE ttrss_sessions DROP INDEX id_2; +ALTER TABLE ttrss_sessions DROP INDEX id; +ALTER TABLE ttrss_user_entries DROP INDEX ref_id; +ALTER TABLE ttrss_user_entries DROP INDEX owner_uid; +ALTER TABLE ttrss_user_entries DROP INDEX feed_id; +ALTER TABLE ttrss_user_prefs DROP INDEX pref_name; +ALTER TABLE ttrss_user_prefs DROP INDEX owner_uid; + +UPDATE ttrss_version SET schema_version = 127; + +COMMIT; diff --git a/schema/versions/pgsql/127.sql b/schema/versions/pgsql/127.sql new file mode 100644 index 000000000..7895aacc0 --- /dev/null +++ b/schema/versions/pgsql/127.sql @@ -0,0 +1,8 @@ +BEGIN; + +DROP INDEX ttrss_entries_guid_index; +DROP INDEX ttrss_prefs_pref_name_idx; + +UPDATE ttrss_version SET schema_version = 127; + +COMMIT; |