diff options
author | Andrew Dolgov <[email protected]> | 2008-01-23 09:44:50 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-01-23 09:44:50 +0100 |
commit | 3c50da8334f5c7d09c531b14d14d26d7309ddeb0 (patch) | |
tree | 0357320962042774212c9e70c92ce32330cf8b7d /schema/versions | |
parent | 22f3e356c8d0f2178c1d401f9bb096d3ea142a8f (diff) |
schema: add ttrss_feeds.last_update_started, bump version
Diffstat (limited to 'schema/versions')
-rw-r--r-- | schema/versions/mysql/30.sql | 4 | ||||
-rw-r--r-- | schema/versions/pgsql/30.sql | 4 |
2 files changed, 8 insertions, 0 deletions
diff --git a/schema/versions/mysql/30.sql b/schema/versions/mysql/30.sql new file mode 100644 index 000000000..0cff2018a --- /dev/null +++ b/schema/versions/mysql/30.sql @@ -0,0 +1,4 @@ +alter table ttrss_feeds add column last_update_started datetime; +alter table ttrss_feeds alter column last_update_started set default null; + +update ttrss_version set schema_version = 30; diff --git a/schema/versions/pgsql/30.sql b/schema/versions/pgsql/30.sql new file mode 100644 index 000000000..d83eee1f1 --- /dev/null +++ b/schema/versions/pgsql/30.sql @@ -0,0 +1,4 @@ +alter table ttrss_feeds add column last_update_started timestamp; +alter table ttrss_feeds alter column last_update_started set default null; + +update ttrss_version set schema_version = 30; |