diff options
author | Andrew Dolgov <[email protected]> | 2010-10-27 12:05:20 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2010-10-27 12:05:20 +0400 |
commit | 25ea280502fbb0fb7fc51f355df8fc644dfc994d (patch) | |
tree | 1a2eb0a3a5f6d98702ac9340dbb33ee6ebf17a1e /schema/versions/pgsql | |
parent | 70543b6a400f292c6ed03d0489d0d696d1e13606 (diff) |
add ttrss_entries.date_updated; use date_updated instead of date_enered for expiry checking (bump schema)
Diffstat (limited to 'schema/versions/pgsql')
-rw-r--r-- | schema/versions/pgsql/67.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/schema/versions/pgsql/67.sql b/schema/versions/pgsql/67.sql new file mode 100644 index 000000000..1e2aa4429 --- /dev/null +++ b/schema/versions/pgsql/67.sql @@ -0,0 +1,9 @@ +begin; + +alter table ttrss_entries add column date_updated timestamp; +update ttrss_entries set date_updated = date_entered; +alter table ttrss_entries alter column date_updated set not null; + +update ttrss_version set schema_version = 67; + +commit; |