[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_pholio.pholio_image
   2    ADD `isObsolete` TINYINT(1) NOT NULL DEFAULT '0';
   3  
   4  ALTER TABLE {$NAMESPACE}_pholio.pholio_image
   5    DROP KEY `mockID`;
   6  
   7  ALTER TABLE {$NAMESPACE}_pholio.pholio_image
   8    ADD KEY `mockID` (`mockID`, `isObsolete`, `sequence`);
   9  
  10  ALTER TABLE {$NAMESPACE}_pholio.pholio_image
  11    ADD `phid` VARCHAR(64) NOT NULL COLLATE utf8_bin AFTER `id`;
  12  
  13  ALTER TABLE {$NAMESPACE}_pholio.pholio_image
  14    CHANGE `mockID` `mockID` INT(10) UNSIGNED;