diff options
author | Andrew Dolgov <[email protected]> | 2008-04-30 07:34:08 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-04-30 07:34:08 +0100 |
commit | afb6038e47f07f3225d783f6ae10c13ef486f89e (patch) | |
tree | 7a442ec9f564cff52767ab9a41487db3bb6855c5 /schema/versions/mysql/36.sql | |
parent | 43fc671f796b1f9720544c1577a05f6fe9e4d1d2 (diff) |
add ttrss_user_entries.score; bump schema
Diffstat (limited to 'schema/versions/mysql/36.sql')
-rw-r--r-- | schema/versions/mysql/36.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/schema/versions/mysql/36.sql b/schema/versions/mysql/36.sql new file mode 100644 index 000000000..09bea8e17 --- /dev/null +++ b/schema/versions/mysql/36.sql @@ -0,0 +1,6 @@ +alter table ttrss_user_entries add column score integer; +update ttrss_user_entries set score = 0; +alter table ttrss_user_entries change score score integer not null; +alter table ttrss_user_entries alter column score set default 0; + +update ttrss_version set schema_version = 36; |