[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_pholio.pholio_mock
   2    ADD COLUMN status VARCHAR(12) NOT NULL COLLATE utf8_bin;
   3  
   4  UPDATE {$NAMESPACE}_pholio.pholio_mock
   5    SET status = "open" WHERE status = "";