-- Upgrade: schema_version 9 to 10
--

ALTER TABLE patches DROP COLUMN content_SHA1;
DROP TABLE patch_contents;

UPDATE schema_version SET version_nbr = 10;

-- Upgrade: schema_version 9 to 10
--

ALTER TABLE patches DROP COLUMN content_SHA1;
DROP TABLE patch_contents;

UPDATE accounts SET full_name = NULL WHERE full_name = 'null null';

UPDATE schema_version SET version_nbr = 10;

Fix "null null" user names during schema upgrade from 9 to 10
Fix "null null" user names during schema upgrade from 9 to 10

A couple of commits back we fixed the OpenID account creator to
correctly set the full_name to NULL if the first name and the
last name weren't supplied by the OpenID provider.  However, a
site may have many accounts with this name already stored in
the database.  Since null is not a very typical given name, nor
a typical family name/surname, we should be reasonably OK to do
this global search-replace on the accounts table.

Signed-off-by: Shawn O. Pearce <f3ea74d906fa9fe97c1fef6bad9cb871485c7045@google.com>
