schema/versions/mysql/127.sql

   1 BEGIN;
   2
   3 ALTER TABLE ttrss_enclosures DROP INDEX post_id;
   4 ALTER TABLE ttrss_entries DROP INDEX ttrss_entries_guid_index;
   5 ALTER TABLE ttrss_feeds DROP INDEX owner_uid;
   6 ALTER TABLE ttrss_feeds DROP INDEX cat_id;
   7 ALTER TABLE ttrss_prefs DROP INDEX ttrss_prefs_pref_name_idx;
   8 ALTER TABLE ttrss_sessions DROP INDEX id_2;
   9 ALTER TABLE ttrss_sessions DROP INDEX id;
  10 ALTER TABLE ttrss_user_entries DROP INDEX ref_id;
  11 ALTER TABLE ttrss_user_entries DROP INDEX owner_uid;
  12 ALTER TABLE ttrss_user_entries DROP INDEX feed_id;
  13 ALTER TABLE ttrss_user_prefs DROP INDEX pref_name;
  14 ALTER TABLE ttrss_user_prefs DROP INDEX owner_uid;
  15
  16 UPDATE ttrss_version SET schema_version = 127;
  17
  18 COMMIT;