From 6141945fa4840d1c76e28410fb571efbcdc76624 Mon Sep 17 00:00:00 2001 From: dbs Date: Wed, 23 Jan 2008 03:17:07 +0000 Subject: [PATCH] Reorder admin user insert statements to satisfy foreign key dependencies git-svn-id: svn://svn.open-ils.org/ILS/trunk@8471 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index b43a7cee59..88d8fd7665 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -657,12 +657,6 @@ INSERT INTO actor.org_address VALUES (DEFAULT,DEFAULT,DEFAULT,1,oils_i18n_gettex UPDATE actor.org_unit SET holds_address = 1, ill_address = 1, billing_address = 1, mailing_address = 1; --- Just so that there is a user... -INSERT INTO actor.usr ( profile, card, usrname, passwd, first_given_name, family_name, dob, master_account, super_user, ident_type, ident_value, home_ou ) VALUES ( 1, 1, 'admin', 'open-ils', oils_i18n_gettext('Administrator'), oils_i18n_gettext('System Account'), '1979-01-22', TRUE, TRUE, 1, 'identification', 1 ); - -INSERT INTO actor.card (usr, barcode) VALUES (1,'101010101010101'); - - --006.data.permissions.sql: INSERT INTO permission.perm_list VALUES (-1, 'EVERYTHING', NULL), @@ -934,7 +928,13 @@ INSERT INTO permission.grp_perm_map VALUES (133, 5, 102, 0, false), (138, 5, 104, 1, false); --- Admin user +-- Admin user account +INSERT INTO actor.usr ( profile, card, usrname, passwd, first_given_name, family_name, dob, master_account, super_user, ident_type, ident_value, home_ou ) VALUES ( 1, 1, 'admin', 'open-ils', oils_i18n_gettext('Administrator'), oils_i18n_gettext('System Account'), '1979-01-22', TRUE, TRUE, 1, 'identification', 1 ); + +-- Admin user barcode +INSERT INTO actor.card (usr, barcode) VALUES (1,'101010101010101'); + +-- Admin user permissions INSERT INTO permission.usr_perm_map (usr,perm,depth) VALUES (1,-1,0); --010.schema.biblio.sql: -- 2.11.0