diff options
author | Andrew Dolgov <[email protected]> | 2007-11-16 06:11:59 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2007-11-16 06:11:59 +0100 |
commit | 54a3d3cf51ccc7e0ce838a2c982d06bca29a2bbb (patch) | |
tree | cc6cbc0d460e1ad596285c0eda97de2fc8aae772 /schema/versions | |
parent | e553f0a6d8c9d9fc0ec34314c0edb099d069ded5 (diff) |
schema: add created field to ttrss_users
Diffstat (limited to 'schema/versions')
-rw-r--r-- | schema/versions/mysql/26.sql | 3 | ||||
-rw-r--r-- | schema/versions/pgsql/26.sql | 3 |
2 files changed, 6 insertions, 0 deletions
diff --git a/schema/versions/mysql/26.sql b/schema/versions/mysql/26.sql index d7593c5e9..513be9a6e 100644 --- a/schema/versions/mysql/26.sql +++ b/schema/versions/mysql/26.sql @@ -1,3 +1,6 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('PURGE_UNREAD_ARTICLES', 1, 'true', 'Purge unread articles',3); +alter table ttrss_users add column created datetime; +alter table ttrss_users alter column created set default null; + update ttrss_version set schema_version = 26; diff --git a/schema/versions/pgsql/26.sql b/schema/versions/pgsql/26.sql index d7593c5e9..48b966190 100644 --- a/schema/versions/pgsql/26.sql +++ b/schema/versions/pgsql/26.sql @@ -1,3 +1,6 @@ insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('PURGE_UNREAD_ARTICLES', 1, 'true', 'Purge unread articles',3); +alter table ttrss_users add column created timestamp; +alter table ttrss_users alter column created set default null; + update ttrss_version set schema_version = 26; |