summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql3
-rw-r--r--schema/ttrss_schema_pgsql.sql3
-rw-r--r--schema/versions/mysql/25.sql3
-rw-r--r--schema/versions/pgsql/25.sql3
4 files changed, 10 insertions, 2 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 88f1080f9..24041bb88 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -30,6 +30,7 @@ create table ttrss_themes(id integer not null primary key auto_increment,
insert into ttrss_themes (theme_name, theme_path) values ('Old-skool', 'compat');
insert into ttrss_themes (theme_name, theme_path) values ('Graycube', 'graycube');
insert into ttrss_themes (theme_name, theme_path) values ('Default (Compact)', 'compact');
+insert into ttrss_themes (theme_name, theme_path) values ('Three-pane', '3pane');
create table ttrss_users (id integer primary key not null auto_increment,
login varchar(120) not null unique,
@@ -199,7 +200,7 @@ create table ttrss_tags (id integer primary key auto_increment,
create table ttrss_version (schema_version int not null) TYPE=InnoDB;
-insert into ttrss_version values (24);
+insert into ttrss_version values (25);
create table ttrss_prefs_types (id integer not null primary key,
type_name varchar(100) not null) TYPE=InnoDB;
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index bb4c45375..c75e210f1 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -27,6 +27,7 @@ create table ttrss_themes(id serial not null primary key,
insert into ttrss_themes (theme_name, theme_path) values ('Old-skool', 'compat');
insert into ttrss_themes (theme_name, theme_path) values ('Graycube', 'graycube');
insert into ttrss_themes (theme_name, theme_path) values ('Default (Compact)', 'compact');
+insert into ttrss_themes (theme_name, theme_path) values ('Three-pane', '3pane');
create table ttrss_users (id serial not null primary key,
login varchar(120) not null unique,
@@ -178,7 +179,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid);
create table ttrss_version (schema_version int not null);
-insert into ttrss_version values (24);
+insert into ttrss_version values (25);
create table ttrss_prefs_types (id integer not null primary key,
type_name varchar(100) not null);
diff --git a/schema/versions/mysql/25.sql b/schema/versions/mysql/25.sql
new file mode 100644
index 000000000..c3f3d5ea4
--- /dev/null
+++ b/schema/versions/mysql/25.sql
@@ -0,0 +1,3 @@
+insert into ttrss_themes (theme_name, theme_path) values ('Three-pane', '3pane');
+
+update ttrss_version set schema_version = 25;
diff --git a/schema/versions/pgsql/25.sql b/schema/versions/pgsql/25.sql
new file mode 100644
index 000000000..c3f3d5ea4
--- /dev/null
+++ b/schema/versions/pgsql/25.sql
@@ -0,0 +1,3 @@
+insert into ttrss_themes (theme_name, theme_path) values ('Three-pane', '3pane');
+
+update ttrss_version set schema_version = 25;