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();
4 INSERT INTO profiles
SET hrpid
= "blah.admin.42", birthdate_ref
= "1942-12-25";
5 SET @PID
= LAST_INSERT_PID();
7 INSERT INTO account_profiles
SET uid
= @UID
, pid
= @PID
, perms
= "owner";
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";
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';
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');
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
;