upgrade/newdirectory-0.0.1/10_promotion.sql

   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: