[platal.git] / upgrade / account / 09_photos.sql

CREATE TABLE  profile_photos
        LIKE  photo;
 INSERT INTO  profile_photos
      SELECT  *
        FROM  photo;

  ALTER TABLE  profile_photos
CHANGE COLUMN  uid pid INT(6) not null;


# vim:set ft=mysql:
Commit	Line	Data
5c4ea53f FB	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: