diff options
author | Andrew Dolgov <[email protected]> | 2008-01-30 11:54:16 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-01-30 11:54:16 +0100 |
commit | 2b6ed06b23041812d0319e5146426c06cbb50459 (patch) | |
tree | 38dbd5756cada0432c791e5a8370e601392998cf /schema/versions/mysql/32.sql | |
parent | 38426fb135bab4146d9e545be32a3ed6d93e4bf3 (diff) |
schema: add ttrss_prefs.access_level, bump version
Diffstat (limited to 'schema/versions/mysql/32.sql')
-rw-r--r-- | schema/versions/mysql/32.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/schema/versions/mysql/32.sql b/schema/versions/mysql/32.sql new file mode 100644 index 000000000..689e5072c --- /dev/null +++ b/schema/versions/mysql/32.sql @@ -0,0 +1,6 @@ +alter table ttrss_prefs add column access_level integer; +update ttrss_prefs set access_level = 0; +alter table ttrss_prefs change access_level access_level integer not null; +alter table ttrss_prefs alter column access_level set default 0; + +update ttrss_version set schema_version = 32; |