From bd4ade6329c9ee99023ce38e44b36ab42e413581 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 4 Mar 2021 09:31:38 +0300 Subject: remove ttrss_version from base schema --- sql/mysql/schema.sql | 5 ----- sql/pgsql/schema.sql | 5 ----- 2 files changed, 10 deletions(-) diff --git a/sql/mysql/schema.sql b/sql/mysql/schema.sql index a3fbc827d..cb1536ab6 100644 --- a/sql/mysql/schema.sql +++ b/sql/mysql/schema.sql @@ -9,7 +9,6 @@ drop table if exists ttrss_access_keys; drop table if exists ttrss_user_labels2; drop table if exists ttrss_labels2; drop table if exists ttrss_feedbrowser_cache; -drop table if exists ttrss_version; drop table if exists ttrss_labels; drop table if exists ttrss_filters2_actions; drop table if exists ttrss_filters2_rules; @@ -296,10 +295,6 @@ create table ttrss_tags (id integer primary key auto_increment, index (owner_uid), foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8; -create table ttrss_version (schema_version int not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8; - -insert into ttrss_version values (142); - create table ttrss_enclosures (id integer primary key auto_increment, content_url text not null, content_type varchar(250) not null, diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql index ca7e8241c..f11b1a877 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -6,7 +6,6 @@ drop table if exists ttrss_access_keys; drop table if exists ttrss_user_labels2; drop table if exists ttrss_labels2; drop table if exists ttrss_feedbrowser_cache; -drop table if exists ttrss_version; drop table if exists ttrss_labels; drop table if exists ttrss_filters2_rules; drop table if exists ttrss_filters2_actions; @@ -278,10 +277,6 @@ create table ttrss_tags (id serial not null primary key, create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid); create index ttrss_tags_post_int_id_idx on ttrss_tags(post_int_id); -create table ttrss_version (schema_version int not null); - -insert into ttrss_version values (142); - create table ttrss_enclosures (id serial not null primary key, content_url text not null, content_type varchar(250) not null, -- cgit v1.2.3