summaryrefslogtreecommitdiff
path: root/schema/versions/mysql
diff options
context:
space:
mode:
Diffstat (limited to 'schema/versions/mysql')
-rw-r--r--schema/versions/mysql/122.sql7
-rw-r--r--schema/versions/mysql/123.sql9
-rw-r--r--schema/versions/mysql/124.sql8
-rw-r--r--schema/versions/mysql/125.sql10
-rw-r--r--schema/versions/mysql/126.sql8
5 files changed, 42 insertions, 0 deletions
diff --git a/schema/versions/mysql/122.sql b/schema/versions/mysql/122.sql
new file mode 100644
index 000000000..397b97bfc
--- /dev/null
+++ b/schema/versions/mysql/122.sql
@@ -0,0 +1,7 @@
+begin;
+
+alter table ttrss_entries add column lang varchar(2);
+
+update ttrss_version set schema_version = 122;
+
+commit;
diff --git a/schema/versions/mysql/123.sql b/schema/versions/mysql/123.sql
new file mode 100644
index 000000000..f311d060b
--- /dev/null
+++ b/schema/versions/mysql/123.sql
@@ -0,0 +1,9 @@
+begin;
+
+ALTER TABLE ttrss_counters_cache ENGINE=InnoDB DEFAULT CHARSET=UTF8;
+ALTER TABLE ttrss_cat_counters_cache ENGINE=InnoDB DEFAULT CHARSET=UTF8;
+ALTER TABLE ttrss_feedbrowser_cache ENGINE=InnoDB DEFAULT CHARSET=UTF8;
+
+update ttrss_version set schema_version = 123;
+
+commit;
diff --git a/schema/versions/mysql/124.sql b/schema/versions/mysql/124.sql
new file mode 100644
index 000000000..96ae46341
--- /dev/null
+++ b/schema/versions/mysql/124.sql
@@ -0,0 +1,8 @@
+begin;
+
+alter table ttrss_users add column resetpass_token varchar(250);
+alter table ttrss_users alter column resetpass_token set default null;
+
+update ttrss_version set schema_version = 124;
+
+commit;
diff --git a/schema/versions/mysql/125.sql b/schema/versions/mysql/125.sql
new file mode 100644
index 000000000..9f004d963
--- /dev/null
+++ b/schema/versions/mysql/125.sql
@@ -0,0 +1,10 @@
+begin;
+
+alter table ttrss_users drop column resetpass_token;
+
+alter table ttrss_users add column resetpass_token varchar(250);
+alter table ttrss_users alter column resetpass_token set default null;
+
+update ttrss_version set schema_version = 125;
+
+commit;
diff --git a/schema/versions/mysql/126.sql b/schema/versions/mysql/126.sql
new file mode 100644
index 000000000..6ff661e71
--- /dev/null
+++ b/schema/versions/mysql/126.sql
@@ -0,0 +1,8 @@
+begin;
+
+alter table ttrss_enclosures add column width integer not null default 0;
+alter table ttrss_enclosures add column height integer not null default 0;
+
+update ttrss_version set schema_version = 126;
+
+commit;