upgrade/setup/001_admin_account.sql

   1 INSERT INTO accounts SET hruid = "blah.admin.42", type = "x", is_admin = 1, password = SHA1("Dummy4dminPassw0rd"), state = "active";
   2 SET @UID = LAST_INSERT_ID();
   3
   4 INSERT INTO profiles SET hrpid = "blah.admin.42", birthdate_ref = "1942-12-25";
   5 SET @PID = LAST_INSERT_PID();
   6
   7 INSERT INTO account_profiles SET uid = @UID, pid = @PID, perms = "owner";
   8
   9 INSERT INTO profile_display SET pid = @PID, yourself = "admin", public_name = "Blah Admin", promo = "X1942", sort_name = "ADMIN Blah", directory_name = "ADMIN Blah", short_name = "Admin", private_name = "Blah Admin";
  10
  11 SET @x_eduid = (SELECT id FROM profile_education_enum WHERE abbreviation = 'X');
  12 SET @ing_degreeid = (SELECT id FROM profile_education_degree_enum WHERE abbreviation = 'Ing.');
  13 INSERT INTO profile_education SET pid = @PID, eduid = @x_eduid, degreeid = @ing_degreeid, entry_year = 1942, grad_year = 1945, flags = 'primary';
  14
  15 SET @name_ini_id = (SELECT id FROM profile_name_enum WHERE type = 'name_ini');
  16 SET @firstname_ini_id = (SELECT id FROM profile_name_enum WHERE type = 'name_ini');
  17
  18 INSERT INTO profile_name SET pid = @PID, name = 'Admin', typeid = @name_ini_id;
  19 INSERT INTO profile_name SET pid = @PID, name = 'Blah', typeid = @firstname_ini_id;
  20