upgrade/account/09_photos.sql

   1 CREATE TABLE  profile_photos
   2         LIKE  photo;
   3  INSERT INTO  profile_photos
   4       SELECT  *
   5         FROM  photo;
   6
   7   ALTER TABLE  profile_photos
   8 CHANGE COLUMN  uid pid INT(6) not null;
   9
  10
  11 # vim:set ft=mysql: