diff options
author | YoungMin Park <[email protected]> | 2014-11-04 11:49:43 +0900 |
---|---|---|
committer | YoungMin Park <[email protected]> | 2014-11-04 11:49:43 +0900 |
commit | a5bbb2bec133bdee08b361628f32430ae3884107 (patch) | |
tree | b203105149ec234ebe155d5718d2cbb6390b4a45 /schema/versions/mysql | |
parent | 12727ad17d125eb2f3f243231ccca1cb0a5a7b4b (diff) | |
parent | 2f43089de1ead3f164b8b31967d1abbb784319fa (diff) |
Merge pull request #1 from gothfox/master
Update from original
Diffstat (limited to 'schema/versions/mysql')
-rw-r--r-- | schema/versions/mysql/122.sql | 7 | ||||
-rw-r--r-- | schema/versions/mysql/123.sql | 9 | ||||
-rw-r--r-- | schema/versions/mysql/124.sql | 8 | ||||
-rw-r--r-- | schema/versions/mysql/125.sql | 10 | ||||
-rw-r--r-- | schema/versions/mysql/126.sql | 8 |
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; |