From 58775b35d1f131ba308d757ecea079bf7651836b Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 1 Feb 2008 20:38:03 +0000 Subject: [PATCH] adding the usr->barcode link git-svn-id: svn://svn.open-ils.org/ILS/trunk@8577 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 1 + 1 file changed, 1 insertion(+) 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 88d8fd7665..6d80f1b762 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -933,6 +933,7 @@ INSERT INTO actor.usr ( profile, card, usrname, passwd, first_given_name, family -- Admin user barcode INSERT INTO actor.card (usr, barcode) VALUES (1,'101010101010101'); +UPDATE actor.usr SET card = (SELECT id FROM actor.card WHERE barcode = '101010101010101') WHERE id = 1; -- Admin user permissions INSERT INTO permission.usr_perm_map (usr,perm,depth) VALUES (1,-1,0); -- 2.11.0