summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2021-03-04 09:31:38 +0300
committerAndrew Dolgov <[email protected]>2021-03-04 09:31:38 +0300
commitbd4ade6329c9ee99023ce38e44b36ab42e413581 (patch)
treeb4a1e9c0eca6cae36bfc19a125d5e9a9db6805f1 /sql
parent5eb0f3d640374a82a026164942adc79bb1262576 (diff)
remove ttrss_version from base schema
Diffstat (limited to 'sql')
-rw-r--r--sql/mysql/schema.sql5
-rw-r--r--sql/pgsql/schema.sql5
2 files changed, 0 insertions, 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,