Commit | Line | Data |
---|---|---|
996300f7 RB |
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 |