diff options
| author | Edmund von der Burg <evdb@mysociety.org> | 2011-05-20 17:25:28 +0100 |
|---|---|---|
| committer | Edmund von der Burg <evdb@mysociety.org> | 2011-05-20 17:25:28 +0100 |
| commit | a10e70f9acb9a7e95698ef361b8b3a412d160521 (patch) | |
| tree | 05385f6601b232294cbde777025b667b68c6cfc1 | |
| parent | cfcda98c6859672b843c15407e0c55d39da98b83 (diff) | |
Change so that all comments have the anonymous flat set to true or false
| -rw-r--r-- | db/schema_0004-create_users_from_comments_and_link.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/schema_0004-create_users_from_comments_and_link.sql b/db/schema_0004-create_users_from_comments_and_link.sql index 6dc50f531..0e4e2b5f2 100644 --- a/db/schema_0004-create_users_from_comments_and_link.sql +++ b/db/schema_0004-create_users_from_comments_and_link.sql @@ -32,10 +32,10 @@ WHERE users.name = ''; ALTER table comment ADD COLUMN anonymous BOOL; -UPDATE comment SET anonymous = true WHERE name = ''; - UPDATE comment SET anonymous = false WHERE name <> ''; +UPDATE comment SET anonymous = true WHERE anonymous is NULL; + -- tidy up now everythings in place ALTER table comment ALTER COLUMN user_id SET NOT NULL; |