From c0fb0a5ec04c064bb848534185b51c5d1b7bdaaf Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 4 Mar 2021 08:30:52 +0300 Subject: wip for db_migrations for core schema --- schema/versions/pgsql/141.sql | 11 ----------- 1 file changed, 11 deletions(-) delete mode 100644 schema/versions/pgsql/141.sql (limited to 'schema/versions/pgsql/141.sql') diff --git a/schema/versions/pgsql/141.sql b/schema/versions/pgsql/141.sql deleted file mode 100644 index 679ca9498..000000000 --- a/schema/versions/pgsql/141.sql +++ /dev/null @@ -1,11 +0,0 @@ -create table ttrss_user_prefs2 ( - owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE, - pref_name varchar(250) not null, - profile integer references ttrss_settings_profiles(id) ON DELETE CASCADE, - value text not null); - -create index ttrss_user_prefs2_owner_uid_index on ttrss_user_prefs2(owner_uid); -create index ttrss_user_prefs2_pref_name_idx on ttrss_user_prefs2(pref_name); -create unique index ttrss_user_prefs2_composite_idx on ttrss_user_prefs2(pref_name, owner_uid, coalesce(profile, -1)); - -update ttrss_version set schema_version = 141; -- cgit v1.2.3