[platal.git] / upgrade / newdirectory-0.0.1 / 10_promotion.sql

INSERT INTO  profile_education (id, uid, grad_year, entry_year, eduid, degreeid, flags)
     SELECT  100, user_id, promo_sortie, promo, 20, 2, 'primary'
       FROM  auth_user_md5;

CREATE TABLE  profile_display (
  uid INT(11) NOT NULL DEFAULT 0,
  promo_display VARCHAR(255) DEFAULT '' NOT NULL,
  PRIMARY KEY(uid)
) CHARSET=utf8;

INSERT IGNORE INTO  profile_display (uid, promo_display)
            SELECT  uid, CONCAT("X", entry_year)
              FROM  profile_education
             WHERE  FIND_IN_SET('primary', flags);

-- vim:set syntax=mysql:
Commit	Line	Data
fb2c09c9 SJ	1	INSERT INTO profile_education (id, uid, grad_year, entry_year, eduid, degreeid, flags)
	2	SELECT 100, user_id, promo_sortie, promo, 20, 2, 'primary'
	3	FROM auth_user_md5;
	4
	5	CREATE TABLE profile_display (
	6	uid INT(11) NOT NULL DEFAULT 0,
	7	promo_display VARCHAR(255) DEFAULT '' NOT NULL,
	8	PRIMARY KEY(uid)
	9	) CHARSET=utf8;
	10
	11	INSERT IGNORE INTO profile_display (uid, promo_display)
	12	SELECT uid, CONCAT("X", entry_year)
	13	FROM profile_education
	14	WHERE FIND_IN_SET('primary', flags);
	15
	16	-- vim:set syntax=mysql: