summaryrefslogtreecommitdiff
path: root/schema/versions/pgsql/26.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2007-11-16 06:11:59 +0100
committerAndrew Dolgov <[email protected]>2007-11-16 06:11:59 +0100
commit54a3d3cf51ccc7e0ce838a2c982d06bca29a2bbb (patch)
treecc6cbc0d460e1ad596285c0eda97de2fc8aae772 /schema/versions/pgsql/26.sql
parente553f0a6d8c9d9fc0ec34314c0edb099d069ded5 (diff)
schema: add created field to ttrss_users
Diffstat (limited to 'schema/versions/pgsql/26.sql')
-rw-r--r--schema/versions/pgsql/26.sql3
1 files changed, 3 insertions, 0 deletions
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;