4 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
5 VALUES (13, 3, 'sforbes', 6, 'Forbes', 'samuelf1234',
6 'Samuel', 'Eugene', '2009-01-16', '1975-06-26', '');
8 INSERT INTO actor.usr_address
9 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
10 VALUES ('USA', 'f', '40065', '8751 Gentleman Burgs', 'f',
11 'KY', 'Shelbyville', '', 'Shelby', CURRVAL('actor.usr_id_seq'));
13 INSERT INTO actor.card (barcode, usr)
14 VALUES ('99999336514', CURRVAL('actor.usr_id_seq'));
17 card = CURRVAL('actor.card_id_seq'),
18 billing_address = CURRVAL('actor.usr_address_id_seq'),
19 credit_forward_balance = '0',
20 mailing_address = CURRVAL('actor.usr_address_id_seq')
21 WHERE id=CURRVAL('actor.usr_id_seq');
23 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
24 VALUES (CURRVAL('actor.usr_id_seq'), 6);
26 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
27 FROM actor.org_unit aou
28 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
31 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
32 VALUES (13, 1, 'vcampbell', 4, 'Campbell', 'vincentc1234',
33 'Vincent', 'Lawrence', '2014-03-03', '1998-10-17', '');
35 INSERT INTO actor.usr_address
36 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
37 VALUES ('USA', 'f', '45633', '5489 Suitable Way Knoll', 'f',
38 'OH', 'Hallsville', '', 'Ross', CURRVAL('actor.usr_id_seq'));
40 INSERT INTO actor.card (barcode, usr)
41 VALUES ('99999338171', CURRVAL('actor.usr_id_seq'));
44 card = CURRVAL('actor.card_id_seq'),
45 billing_address = CURRVAL('actor.usr_address_id_seq'),
46 credit_forward_balance = '0',
47 mailing_address = CURRVAL('actor.usr_address_id_seq')
48 WHERE id=CURRVAL('actor.usr_id_seq');
50 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
51 VALUES (CURRVAL('actor.usr_id_seq'), 4);
53 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
54 FROM actor.org_unit aou
55 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
58 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
59 VALUES (15, 3, 'afrey', 9, 'Frey', 'annief1234',
60 'Annie', 'Jessica', '2010-02-07', '1997-12-07', '');
62 INSERT INTO actor.usr_address
63 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
64 VALUES ('USA', 't', '54409', '7918 Subjective Volume Trail', 'f',
65 'WI', 'Antigo', '', '', CURRVAL('actor.usr_id_seq'));
67 INSERT INTO actor.card (barcode, usr)
68 VALUES ('99999364116', CURRVAL('actor.usr_id_seq'));
71 card = CURRVAL('actor.card_id_seq'),
72 billing_address = CURRVAL('actor.usr_address_id_seq'),
73 credit_forward_balance = '0',
74 mailing_address = CURRVAL('actor.usr_address_id_seq')
75 WHERE id=CURRVAL('actor.usr_id_seq');
77 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
78 VALUES (CURRVAL('actor.usr_id_seq'), 9);
80 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
81 FROM actor.org_unit aou
82 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
85 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
86 VALUES (15, 3, 'msalinas', 9, 'Salinas', 'marks1234',
87 'Mark', 'Christopher', '2007-06-08', '1999-06-13', 'II');
89 INSERT INTO actor.usr_address
90 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
91 VALUES ('USA', 'f', '25529', '1790 Lively Attitude Falls', 't',
92 'WV', 'Julian', '', 'Boone', CURRVAL('actor.usr_id_seq'));
94 INSERT INTO actor.card (barcode, usr)
95 VALUES ('99999313813', CURRVAL('actor.usr_id_seq'));
98 card = CURRVAL('actor.card_id_seq'),
99 billing_address = CURRVAL('actor.usr_address_id_seq'),
100 credit_forward_balance = '0',
101 mailing_address = CURRVAL('actor.usr_address_id_seq')
102 WHERE id=CURRVAL('actor.usr_id_seq');
104 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
105 VALUES (CURRVAL('actor.usr_id_seq'), 9);
107 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
108 FROM actor.org_unit aou
109 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
111 INSERT INTO actor.usr
112 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
113 VALUES (15, 1, 'klindsey', 8, 'Lindsey', 'kennethl1234',
114 'Kenneth', 'Jesse', '2014-12-27', '1964-10-19', '');
116 INSERT INTO actor.usr_address
117 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
118 VALUES ('USA', 't', '89077', '1552 Okay Communication Motorway', 'f',
119 'NV', 'Henderson', '', '', CURRVAL('actor.usr_id_seq'));
121 INSERT INTO actor.card (barcode, usr)
122 VALUES ('99999334832', CURRVAL('actor.usr_id_seq'));
125 card = CURRVAL('actor.card_id_seq'),
126 billing_address = CURRVAL('actor.usr_address_id_seq'),
127 credit_forward_balance = '0',
128 mailing_address = CURRVAL('actor.usr_address_id_seq')
129 WHERE id=CURRVAL('actor.usr_id_seq');
131 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
132 VALUES (CURRVAL('actor.usr_id_seq'), 8);
134 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
135 FROM actor.org_unit aou
136 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
138 INSERT INTO actor.usr
139 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
140 VALUES (15, 3, 'mdavis', 8, 'Davis', 'marthad1234',
141 'Martha', '', '2008-10-27', '1983-05-13', '');
143 INSERT INTO actor.usr_address
144 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
145 VALUES ('USA', 'f', '13156', '8717 Cabinet Fords', 'f',
146 'NY', 'Sterling', '', 'Cayuga', CURRVAL('actor.usr_id_seq'));
148 INSERT INTO actor.card (barcode, usr)
149 VALUES ('99999315736', CURRVAL('actor.usr_id_seq'));
152 card = CURRVAL('actor.card_id_seq'),
153 billing_address = CURRVAL('actor.usr_address_id_seq'),
154 credit_forward_balance = '0',
155 mailing_address = CURRVAL('actor.usr_address_id_seq')
156 WHERE id=CURRVAL('actor.usr_id_seq');
158 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
159 VALUES (CURRVAL('actor.usr_id_seq'), 8);
161 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
162 FROM actor.org_unit aou
163 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
165 INSERT INTO actor.usr
166 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
167 VALUES (15, 3, 'vfreeman', 7, 'Freeman', 'virginiaf1234',
168 'Virginia', 'Johanna', '2009-10-05', '1967-07-23', 'Jr');
170 INSERT INTO actor.usr_address
171 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
172 VALUES ('USA', 'f', '33122', '4033 Instant Matter Cape', 'f',
173 'FL', 'Miami', '', '', CURRVAL('actor.usr_id_seq'));
175 INSERT INTO actor.card (barcode, usr)
176 VALUES ('99999301938', CURRVAL('actor.usr_id_seq'));
179 card = CURRVAL('actor.card_id_seq'),
180 billing_address = CURRVAL('actor.usr_address_id_seq'),
181 credit_forward_balance = '0',
182 mailing_address = CURRVAL('actor.usr_address_id_seq')
183 WHERE id=CURRVAL('actor.usr_id_seq');
185 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
186 VALUES (CURRVAL('actor.usr_id_seq'), 7);
188 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
189 FROM actor.org_unit aou
190 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
192 INSERT INTO actor.usr
193 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
194 VALUES (15, 3, 'lmartinez', 7, 'Martinez', 'leroym1234',
195 'Leroy', 'Brian', '2013-05-19', '1968-03-11', '');
197 INSERT INTO actor.usr_address
198 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
199 VALUES ('USA', 't', '55046', '2511 Other Stream', 'f',
200 'MN', 'Lonsdale', '', 'Rice', CURRVAL('actor.usr_id_seq'));
202 INSERT INTO actor.card (barcode, usr)
203 VALUES ('99999385425', CURRVAL('actor.usr_id_seq'));
206 card = CURRVAL('actor.card_id_seq'),
207 billing_address = CURRVAL('actor.usr_address_id_seq'),
208 credit_forward_balance = '0',
209 mailing_address = CURRVAL('actor.usr_address_id_seq')
210 WHERE id=CURRVAL('actor.usr_id_seq');
212 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
213 VALUES (CURRVAL('actor.usr_id_seq'), 7);
215 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
216 FROM actor.org_unit aou
217 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
219 INSERT INTO actor.usr
220 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
221 VALUES (15, 1, 'warmstrong', 6, 'Armstrong', 'williama1234',
222 'William', 'William', '2014-05-28', '1980-08-13', '');
224 INSERT INTO actor.usr_address
225 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
226 VALUES ('USA', 'f', '55959', '1671 Cabinet Orchard', 'f',
227 'MN', 'Minnesota city', '', 'Winona', CURRVAL('actor.usr_id_seq'));
229 INSERT INTO actor.card (barcode, usr)
230 VALUES ('99999378711', CURRVAL('actor.usr_id_seq'));
233 card = CURRVAL('actor.card_id_seq'),
234 billing_address = CURRVAL('actor.usr_address_id_seq'),
235 credit_forward_balance = '0',
236 mailing_address = CURRVAL('actor.usr_address_id_seq')
237 WHERE id=CURRVAL('actor.usr_id_seq');
239 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
240 VALUES (CURRVAL('actor.usr_id_seq'), 6);
242 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
243 FROM actor.org_unit aou
244 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
246 INSERT INTO actor.usr
247 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
248 VALUES (15, 3, 'acotton', 6, 'Cotton', 'amyc1234',
249 'Amy', 'Ada', '2012-08-01', '1984-12-16', '');
251 INSERT INTO actor.usr_address
252 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
253 VALUES ('USA', 't', '34202', '1488 Glamorous Alternative Forks', 'f',
254 'FL', 'Bradenton', '', 'Manatee', CURRVAL('actor.usr_id_seq'));
256 INSERT INTO actor.card (barcode, usr)
257 VALUES ('99999323866', CURRVAL('actor.usr_id_seq'));
260 card = CURRVAL('actor.card_id_seq'),
261 billing_address = CURRVAL('actor.usr_address_id_seq'),
262 credit_forward_balance = '0',
263 mailing_address = CURRVAL('actor.usr_address_id_seq')
264 WHERE id=CURRVAL('actor.usr_id_seq');
266 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
267 VALUES (CURRVAL('actor.usr_id_seq'), 6);
269 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
270 FROM actor.org_unit aou
271 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
273 INSERT INTO actor.usr
274 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
275 VALUES (15, 1, 'sbarton', 5, 'Barton', 'sarahb1234',
276 'Sarah', 'Valerie', '2015-07-08', '1984-03-06', '');
278 INSERT INTO actor.usr_address
279 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
280 VALUES ('USA', 'f', '54655', '6986 Delighted Design Trail', 't',
281 'WI', 'Soldiers grove', '', 'Crawford', CURRVAL('actor.usr_id_seq'));
283 INSERT INTO actor.card (barcode, usr)
284 VALUES ('99999327258', CURRVAL('actor.usr_id_seq'));
287 card = CURRVAL('actor.card_id_seq'),
288 billing_address = CURRVAL('actor.usr_address_id_seq'),
289 credit_forward_balance = '0',
290 mailing_address = CURRVAL('actor.usr_address_id_seq')
291 WHERE id=CURRVAL('actor.usr_id_seq');
293 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
294 VALUES (CURRVAL('actor.usr_id_seq'), 5);
296 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
297 FROM actor.org_unit aou
298 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
300 INSERT INTO actor.usr
301 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
302 VALUES (15, 1, 'jhammond', 5, 'Hammond', 'jamesh1234',
303 'James', 'Michael', '2007-11-13', '1988-02-17', '');
305 INSERT INTO actor.usr_address
306 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
307 VALUES ('USA', 'f', '88211', '9144 White Support Squares', 'f',
308 'NM', 'Artesia', '', 'Eddy', CURRVAL('actor.usr_id_seq'));
310 INSERT INTO actor.card (barcode, usr)
311 VALUES ('99999385896', CURRVAL('actor.usr_id_seq'));
314 card = CURRVAL('actor.card_id_seq'),
315 billing_address = CURRVAL('actor.usr_address_id_seq'),
316 credit_forward_balance = '0',
317 mailing_address = CURRVAL('actor.usr_address_id_seq')
318 WHERE id=CURRVAL('actor.usr_id_seq');
320 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
321 VALUES (CURRVAL('actor.usr_id_seq'), 5);
323 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
324 FROM actor.org_unit aou
325 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
327 INSERT INTO actor.usr
328 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
329 VALUES (15, 3, 'ajoseph', 4, 'Joseph', 'alexj1234',
330 'Alex', 'Edward', '2008-05-19', '1968-02-14', '');
332 INSERT INTO actor.usr_address
333 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
334 VALUES ('USA', 't', '56308', '9081 Awake Minute Spring', 't',
335 'MN', 'Alexandria', '', 'Douglas', CURRVAL('actor.usr_id_seq'));
337 INSERT INTO actor.card (barcode, usr)
338 VALUES ('99999378073', CURRVAL('actor.usr_id_seq'));
341 card = CURRVAL('actor.card_id_seq'),
342 billing_address = CURRVAL('actor.usr_address_id_seq'),
343 credit_forward_balance = '0',
344 mailing_address = CURRVAL('actor.usr_address_id_seq')
345 WHERE id=CURRVAL('actor.usr_id_seq');
347 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
348 VALUES (CURRVAL('actor.usr_id_seq'), 4);
350 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
351 FROM actor.org_unit aou
352 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
354 INSERT INTO actor.usr
355 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
356 VALUES (15, 3, 'imccoy', 4, 'Mccoy', 'idam1234',
357 'Ida', 'Gloria', '2015-09-12', '1963-08-19', '');
359 INSERT INTO actor.usr_address
360 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
361 VALUES ('USA', 't', '40046', '9875 Support Row', 'f',
362 'KY', 'Mount eden', '', 'Spencer', CURRVAL('actor.usr_id_seq'));
364 INSERT INTO actor.card (barcode, usr)
365 VALUES ('99999321047', CURRVAL('actor.usr_id_seq'));
368 card = CURRVAL('actor.card_id_seq'),
369 billing_address = CURRVAL('actor.usr_address_id_seq'),
370 credit_forward_balance = '0',
371 mailing_address = CURRVAL('actor.usr_address_id_seq')
372 WHERE id=CURRVAL('actor.usr_id_seq');
374 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
375 VALUES (CURRVAL('actor.usr_id_seq'), 4);
377 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
378 FROM actor.org_unit aou
379 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
381 INSERT INTO actor.usr
382 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
383 VALUES (14, 3, 'dwright', 9, 'Wright', 'dennisw1234',
384 'Dennis', 'Ernest', '2010-01-06', '1998-07-28', '');
386 INSERT INTO actor.usr_address
387 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
388 VALUES ('USA', 'f', '03457', '2063 Sophisticated Status Plaza', 'f',
389 'NH', 'Nelson', '', 'Cheshire', CURRVAL('actor.usr_id_seq'));
391 INSERT INTO actor.card (barcode, usr)
392 VALUES ('99999348121', CURRVAL('actor.usr_id_seq'));
395 card = CURRVAL('actor.card_id_seq'),
396 billing_address = CURRVAL('actor.usr_address_id_seq'),
397 credit_forward_balance = '0',
398 mailing_address = CURRVAL('actor.usr_address_id_seq')
399 WHERE id=CURRVAL('actor.usr_id_seq');
401 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
402 VALUES (CURRVAL('actor.usr_id_seq'), 9);
404 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
405 FROM actor.org_unit aou
406 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
408 INSERT INTO actor.usr
409 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
410 VALUES (14, 1, 'alynch', 9, 'Lynch', 'armandol1234',
411 'Armando', '', '2015-05-16', '1967-08-16', '');
413 INSERT INTO actor.usr_address
414 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
415 VALUES ('USA', 'f', '31126', '7394 Show Valley', 'f',
416 'GA', 'Atlanta', '', 'Fulton', CURRVAL('actor.usr_id_seq'));
418 INSERT INTO actor.card (barcode, usr)
419 VALUES ('99999384116', CURRVAL('actor.usr_id_seq'));
422 card = CURRVAL('actor.card_id_seq'),
423 billing_address = CURRVAL('actor.usr_address_id_seq'),
424 credit_forward_balance = '0',
425 mailing_address = CURRVAL('actor.usr_address_id_seq')
426 WHERE id=CURRVAL('actor.usr_id_seq');
428 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
429 VALUES (CURRVAL('actor.usr_id_seq'), 9);
431 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
432 FROM actor.org_unit aou
433 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
435 INSERT INTO actor.usr
436 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
437 VALUES (14, 3, 'rgraham', 8, 'Graham', 'robertg1234',
438 'Robert', '', '2007-12-28', '1987-03-12', '');
440 INSERT INTO actor.usr_address
441 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
442 VALUES ('USA', 't', '98807', '2577 Stuck Benefit Tunnel', 'f',
443 'WA', 'Wenatchee', '', 'Chelan', CURRVAL('actor.usr_id_seq'));
445 INSERT INTO actor.card (barcode, usr)
446 VALUES ('99999311950', CURRVAL('actor.usr_id_seq'));
449 card = CURRVAL('actor.card_id_seq'),
450 billing_address = CURRVAL('actor.usr_address_id_seq'),
451 credit_forward_balance = '0',
452 mailing_address = CURRVAL('actor.usr_address_id_seq')
453 WHERE id=CURRVAL('actor.usr_id_seq');
455 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
456 VALUES (CURRVAL('actor.usr_id_seq'), 8);
458 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
459 FROM actor.org_unit aou
460 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
462 INSERT INTO actor.usr
463 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
464 VALUES (14, 1, 'sthompson', 8, 'Thompson', 'sherrit1234',
465 'Sherri', '', '2010-12-25', '1964-01-16', '');
467 INSERT INTO actor.usr_address
468 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
469 VALUES ('USA', 'f', '31758', '3587 Name Neck', 'f',
470 'GA', 'Thomasville', '', 'Thomas', CURRVAL('actor.usr_id_seq'));
472 INSERT INTO actor.card (barcode, usr)
473 VALUES ('99999384066', CURRVAL('actor.usr_id_seq'));
476 card = CURRVAL('actor.card_id_seq'),
477 billing_address = CURRVAL('actor.usr_address_id_seq'),
478 credit_forward_balance = '0',
479 mailing_address = CURRVAL('actor.usr_address_id_seq')
480 WHERE id=CURRVAL('actor.usr_id_seq');
482 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
483 VALUES (CURRVAL('actor.usr_id_seq'), 8);
485 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
486 FROM actor.org_unit aou
487 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
489 INSERT INTO actor.usr
490 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
491 VALUES (14, 1, 'ngarcia', 7, 'Garcia', 'nanetteg1234',
492 'Nanette', 'Helen', '2007-12-02', '1972-12-01', '');
494 INSERT INTO actor.usr_address
495 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
496 VALUES ('USA', 't', '11733', '6990 Icy Scene Street', 'f',
497 'NY', 'East setauket', '', 'Suffolk', CURRVAL('actor.usr_id_seq'));
499 INSERT INTO actor.card (barcode, usr)
500 VALUES ('99999332719', CURRVAL('actor.usr_id_seq'));
503 card = CURRVAL('actor.card_id_seq'),
504 billing_address = CURRVAL('actor.usr_address_id_seq'),
505 credit_forward_balance = '0',
506 mailing_address = CURRVAL('actor.usr_address_id_seq')
507 WHERE id=CURRVAL('actor.usr_id_seq');
509 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
510 VALUES (CURRVAL('actor.usr_id_seq'), 7);
512 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
513 FROM actor.org_unit aou
514 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
516 INSERT INTO actor.usr
517 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
518 VALUES (14, 3, 'rcook', 7, 'Cook', 'raymondc1234',
519 'Raymond', 'Boyd', '2008-11-11', '1968-12-05', '');
521 INSERT INTO actor.usr_address
522 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
523 VALUES ('USA', 't', '94533', '2004 Harsh Gold Tunnel', 'f',
524 'CA', 'Fairfield', '', 'Solano', CURRVAL('actor.usr_id_seq'));
526 INSERT INTO actor.card (barcode, usr)
527 VALUES ('99999392343', CURRVAL('actor.usr_id_seq'));
530 card = CURRVAL('actor.card_id_seq'),
531 billing_address = CURRVAL('actor.usr_address_id_seq'),
532 credit_forward_balance = '0',
533 mailing_address = CURRVAL('actor.usr_address_id_seq')
534 WHERE id=CURRVAL('actor.usr_id_seq');
536 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
537 VALUES (CURRVAL('actor.usr_id_seq'), 7);
539 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
540 FROM actor.org_unit aou
541 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
543 INSERT INTO actor.usr
544 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
545 VALUES (14, 3, 'kbrewer', 6, 'Brewer', 'katherineb1234',
546 'Katherine', '', '2006-01-16', '1980-12-04', '');
548 INSERT INTO actor.usr_address
549 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
550 VALUES ('USA', 'f', '59053', '6732 Recognition Street', 't',
551 'MT', 'Martinsdale', '', 'Meagher', CURRVAL('actor.usr_id_seq'));
553 INSERT INTO actor.card (barcode, usr)
554 VALUES ('99999383479', CURRVAL('actor.usr_id_seq'));
557 card = CURRVAL('actor.card_id_seq'),
558 billing_address = CURRVAL('actor.usr_address_id_seq'),
559 credit_forward_balance = '0',
560 mailing_address = CURRVAL('actor.usr_address_id_seq')
561 WHERE id=CURRVAL('actor.usr_id_seq');
563 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
564 VALUES (CURRVAL('actor.usr_id_seq'), 6);
566 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
567 FROM actor.org_unit aou
568 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
570 INSERT INTO actor.usr
571 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
572 VALUES (14, 1, 'cwashington', 6, 'Washington', 'christopherw1234',
573 'Christopher', '', '2006-06-25', '1998-08-05', '');
575 INSERT INTO actor.usr_address
576 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
577 VALUES ('USA', 't', '47360', '9934 Coloured Bar Grove', 'f',
578 'IN', 'Mooreland', '', 'Henry', CURRVAL('actor.usr_id_seq'));
580 INSERT INTO actor.card (barcode, usr)
581 VALUES ('99999380284', CURRVAL('actor.usr_id_seq'));
584 card = CURRVAL('actor.card_id_seq'),
585 billing_address = CURRVAL('actor.usr_address_id_seq'),
586 credit_forward_balance = '0',
587 mailing_address = CURRVAL('actor.usr_address_id_seq')
588 WHERE id=CURRVAL('actor.usr_id_seq');
590 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
591 VALUES (CURRVAL('actor.usr_id_seq'), 6);
593 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
594 FROM actor.org_unit aou
595 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
597 INSERT INTO actor.usr
598 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
599 VALUES (14, 3, 'dmurray', 5, 'Murray', 'dawnm1234',
600 'Dawn', 'Katherine', '2007-09-05', '1973-05-16', '');
602 INSERT INTO actor.usr_address
603 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
604 VALUES ('USA', 't', '59868', '4426 Temporary Demand River', 'f',
605 'MT', 'Seeley lake', '', 'Missoula', CURRVAL('actor.usr_id_seq'));
607 INSERT INTO actor.card (barcode, usr)
608 VALUES ('99999347656', CURRVAL('actor.usr_id_seq'));
611 card = CURRVAL('actor.card_id_seq'),
612 billing_address = CURRVAL('actor.usr_address_id_seq'),
613 credit_forward_balance = '0',
614 mailing_address = CURRVAL('actor.usr_address_id_seq')
615 WHERE id=CURRVAL('actor.usr_id_seq');
617 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
618 VALUES (CURRVAL('actor.usr_id_seq'), 5);
620 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
621 FROM actor.org_unit aou
622 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
624 INSERT INTO actor.usr
625 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
626 VALUES (14, 1, 'bwatts', 5, 'Watts', 'barbaraw1234',
627 'Barbara', 'Gloria', '2006-07-07', '1973-02-08', '');
629 INSERT INTO actor.usr_address
630 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
631 VALUES ('USA', 't', '51036', '4020 Marked Chemical Bayoo', 'f',
632 'IA', 'Maurice', '', 'Sioux', CURRVAL('actor.usr_id_seq'));
634 INSERT INTO actor.card (barcode, usr)
635 VALUES ('99999384489', CURRVAL('actor.usr_id_seq'));
638 card = CURRVAL('actor.card_id_seq'),
639 billing_address = CURRVAL('actor.usr_address_id_seq'),
640 credit_forward_balance = '0',
641 mailing_address = CURRVAL('actor.usr_address_id_seq')
642 WHERE id=CURRVAL('actor.usr_id_seq');
644 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
645 VALUES (CURRVAL('actor.usr_id_seq'), 5);
647 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
648 FROM actor.org_unit aou
649 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
651 INSERT INTO actor.usr
652 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
653 VALUES (14, 3, 'mmartin', 4, 'Martin', 'marym1234',
654 'Mary', 'Shannon', '2013-11-16', '1974-06-10', 'Sr');
656 INSERT INTO actor.usr_address
657 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
658 VALUES ('USA', 't', '16657', '7511 Fortunate Length Parkway', 't',
659 'PA', 'James creek', '', 'Huntingdon', CURRVAL('actor.usr_id_seq'));
661 INSERT INTO actor.card (barcode, usr)
662 VALUES ('99999336634', CURRVAL('actor.usr_id_seq'));
665 card = CURRVAL('actor.card_id_seq'),
666 billing_address = CURRVAL('actor.usr_address_id_seq'),
667 credit_forward_balance = '0',
668 mailing_address = CURRVAL('actor.usr_address_id_seq')
669 WHERE id=CURRVAL('actor.usr_id_seq');
671 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
672 VALUES (CURRVAL('actor.usr_id_seq'), 4);
674 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
675 FROM actor.org_unit aou
676 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
678 INSERT INTO actor.usr
679 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
680 VALUES (14, 3, 'vford', 4, 'Ford', 'vivianf1234',
681 'Vivian', 'Darlene', '2011-02-28', '1971-08-03', '');
683 INSERT INTO actor.usr_address
684 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
685 VALUES ('USA', 't', '23023', '3414 Energetic Weekend Circles', 'f',
686 'VA', 'Bruington', '', 'King and queen', CURRVAL('actor.usr_id_seq'));
688 INSERT INTO actor.card (barcode, usr)
689 VALUES ('99999361251', CURRVAL('actor.usr_id_seq'));
692 card = CURRVAL('actor.card_id_seq'),
693 billing_address = CURRVAL('actor.usr_address_id_seq'),
694 credit_forward_balance = '0',
695 mailing_address = CURRVAL('actor.usr_address_id_seq')
696 WHERE id=CURRVAL('actor.usr_id_seq');
698 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
699 VALUES (CURRVAL('actor.usr_id_seq'), 4);
701 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
702 FROM actor.org_unit aou
703 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
705 INSERT INTO actor.usr
706 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
707 VALUES (12, 1, 'gsuarez', 9, 'Suarez', 'garys1234',
708 'Gary', 'Joel', '2007-10-23', '1971-07-05', 'Sr');
710 INSERT INTO actor.usr_address
711 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
712 VALUES ('USA', 'f', '19244', '1613 Legislation River', 't',
713 'PA', 'Philadelphia', '', '', CURRVAL('actor.usr_id_seq'));
715 INSERT INTO actor.card (barcode, usr)
716 VALUES ('99999372079', CURRVAL('actor.usr_id_seq'));
719 card = CURRVAL('actor.card_id_seq'),
720 billing_address = CURRVAL('actor.usr_address_id_seq'),
721 credit_forward_balance = '0',
722 mailing_address = CURRVAL('actor.usr_address_id_seq')
723 WHERE id=CURRVAL('actor.usr_id_seq');
725 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
726 VALUES (CURRVAL('actor.usr_id_seq'), 9);
728 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
729 FROM actor.org_unit aou
730 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
732 INSERT INTO actor.usr
733 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
734 VALUES (12, 1, 'eellis', 9, 'Ellis', 'edwarde1234',
735 'Edward', 'David', '2010-10-23', '1998-05-05', '');
737 INSERT INTO actor.usr_address
738 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
739 VALUES ('USA', 't', '17349', '1977 Profound Conference Path', 'f',
740 'PA', 'New freedom', '', 'York', CURRVAL('actor.usr_id_seq'));
742 INSERT INTO actor.card (barcode, usr)
743 VALUES ('99999354444', CURRVAL('actor.usr_id_seq'));
746 card = CURRVAL('actor.card_id_seq'),
747 billing_address = CURRVAL('actor.usr_address_id_seq'),
748 credit_forward_balance = '0',
749 mailing_address = CURRVAL('actor.usr_address_id_seq')
750 WHERE id=CURRVAL('actor.usr_id_seq');
752 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
753 VALUES (CURRVAL('actor.usr_id_seq'), 9);
755 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
756 FROM actor.org_unit aou
757 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
759 INSERT INTO actor.usr
760 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
761 VALUES (12, 1, 'nward', 8, 'Ward', 'naomiw1234',
762 'Naomi', 'Angela', '2010-10-07', '1987-02-23', 'Sr');
764 INSERT INTO actor.usr_address
765 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
766 VALUES ('USA', 't', '20109', '2689 Standard Interview Vista', 't',
767 'VA', 'Manassas', '', '', CURRVAL('actor.usr_id_seq'));
769 INSERT INTO actor.card (barcode, usr)
770 VALUES ('99999326817', CURRVAL('actor.usr_id_seq'));
773 card = CURRVAL('actor.card_id_seq'),
774 billing_address = CURRVAL('actor.usr_address_id_seq'),
775 credit_forward_balance = '0',
776 mailing_address = CURRVAL('actor.usr_address_id_seq')
777 WHERE id=CURRVAL('actor.usr_id_seq');
779 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
780 VALUES (CURRVAL('actor.usr_id_seq'), 8);
782 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
783 FROM actor.org_unit aou
784 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
786 INSERT INTO actor.usr
787 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
788 VALUES (12, 1, 'jrichards', 8, 'Richards', 'josephr1234',
789 'Joseph', 'Thomas', '2008-04-15', '1976-03-11', '');
791 INSERT INTO actor.usr_address
792 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
793 VALUES ('USA', 'f', '78658', '3275 Error Freeway', 'f',
794 'TX', 'Ottine', '', 'Gonzales', CURRVAL('actor.usr_id_seq'));
796 INSERT INTO actor.card (barcode, usr)
797 VALUES ('99999318881', CURRVAL('actor.usr_id_seq'));
800 card = CURRVAL('actor.card_id_seq'),
801 billing_address = CURRVAL('actor.usr_address_id_seq'),
802 credit_forward_balance = '0',
803 mailing_address = CURRVAL('actor.usr_address_id_seq')
804 WHERE id=CURRVAL('actor.usr_id_seq');
806 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
807 VALUES (CURRVAL('actor.usr_id_seq'), 8);
809 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
810 FROM actor.org_unit aou
811 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
813 INSERT INTO actor.usr
814 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
815 VALUES (12, 3, 'rsanders', 7, 'Sanders', 'roslyns1234',
816 'Roslyn', '', '2007-08-15', '1995-05-22', '');
818 INSERT INTO actor.usr_address
819 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
820 VALUES ('USA', 't', '19975', '6946 Constitutional Word Freeway', 'f',
821 'DE', 'Selbyville', '', 'Sussex', CURRVAL('actor.usr_id_seq'));
823 INSERT INTO actor.card (barcode, usr)
824 VALUES ('99999356038', CURRVAL('actor.usr_id_seq'));
827 card = CURRVAL('actor.card_id_seq'),
828 billing_address = CURRVAL('actor.usr_address_id_seq'),
829 credit_forward_balance = '0',
830 mailing_address = CURRVAL('actor.usr_address_id_seq')
831 WHERE id=CURRVAL('actor.usr_id_seq');
833 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
834 VALUES (CURRVAL('actor.usr_id_seq'), 7);
836 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
837 FROM actor.org_unit aou
838 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
840 INSERT INTO actor.usr
841 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
842 VALUES (12, 1, 'nrivera', 7, 'Rivera', 'nancyr1234',
843 'Nancy', 'Anita', '2007-12-15', '1990-03-22', 'Sr');
845 INSERT INTO actor.usr_address
846 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
847 VALUES ('USA', 't', '27373', '263 Catholic End Field', 'f',
848 'NC', 'Wallburg', '', '', CURRVAL('actor.usr_id_seq'));
850 INSERT INTO actor.card (barcode, usr)
851 VALUES ('99999302274', CURRVAL('actor.usr_id_seq'));
854 card = CURRVAL('actor.card_id_seq'),
855 billing_address = CURRVAL('actor.usr_address_id_seq'),
856 credit_forward_balance = '0',
857 mailing_address = CURRVAL('actor.usr_address_id_seq')
858 WHERE id=CURRVAL('actor.usr_id_seq');
860 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
861 VALUES (CURRVAL('actor.usr_id_seq'), 7);
863 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
864 FROM actor.org_unit aou
865 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
867 INSERT INTO actor.usr
868 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
869 VALUES (12, 1, 'cmartin', 6, 'Martin', 'carlm1234',
870 'Carl', 'Charles', '2007-12-09', '1976-09-01', '');
872 INSERT INTO actor.usr_address
873 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
874 VALUES ('USA', 't', '61452', '6985 Welcome Statement Fort', 'f',
875 'IL', 'Littleton', '', 'Schuyler', CURRVAL('actor.usr_id_seq'));
877 INSERT INTO actor.card (barcode, usr)
878 VALUES ('99999339237', CURRVAL('actor.usr_id_seq'));
881 card = CURRVAL('actor.card_id_seq'),
882 billing_address = CURRVAL('actor.usr_address_id_seq'),
883 credit_forward_balance = '0',
884 mailing_address = CURRVAL('actor.usr_address_id_seq')
885 WHERE id=CURRVAL('actor.usr_id_seq');
887 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
888 VALUES (CURRVAL('actor.usr_id_seq'), 6);
890 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
891 FROM actor.org_unit aou
892 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
894 INSERT INTO actor.usr
895 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
896 VALUES (12, 1, 'telliott', 6, 'Elliott', 'thomase1234',
897 'Thomas', 'Marcus', '2010-09-07', '1973-05-25', '');
899 INSERT INTO actor.usr_address
900 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
901 VALUES ('USA', 't', '97624', '1283 Splendid West Manor', 'f',
902 'OR', 'Chiloquin', '', 'Klamath', CURRVAL('actor.usr_id_seq'));
904 INSERT INTO actor.card (barcode, usr)
905 VALUES ('99999340230', CURRVAL('actor.usr_id_seq'));
908 card = CURRVAL('actor.card_id_seq'),
909 billing_address = CURRVAL('actor.usr_address_id_seq'),
910 credit_forward_balance = '0',
911 mailing_address = CURRVAL('actor.usr_address_id_seq')
912 WHERE id=CURRVAL('actor.usr_id_seq');
914 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
915 VALUES (CURRVAL('actor.usr_id_seq'), 6);
917 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
918 FROM actor.org_unit aou
919 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
921 INSERT INTO actor.usr
922 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
923 VALUES (12, 3, 'ocherry', 5, 'Cherry', 'olgac1234',
924 'Olga', 'Marie', '2008-01-12', '1976-05-25', '');
926 INSERT INTO actor.usr_address
927 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
928 VALUES ('USA', 't', '17081', '9657 Scared Kind Street', 'f',
929 'PA', 'Plainfield', '', 'Cumberland', CURRVAL('actor.usr_id_seq'));
931 INSERT INTO actor.card (barcode, usr)
932 VALUES ('99999384061', CURRVAL('actor.usr_id_seq'));
935 card = CURRVAL('actor.card_id_seq'),
936 billing_address = CURRVAL('actor.usr_address_id_seq'),
937 credit_forward_balance = '0',
938 mailing_address = CURRVAL('actor.usr_address_id_seq')
939 WHERE id=CURRVAL('actor.usr_id_seq');
941 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
942 VALUES (CURRVAL('actor.usr_id_seq'), 5);
944 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
945 FROM actor.org_unit aou
946 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
948 INSERT INTO actor.usr
949 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
950 VALUES (12, 1, 'gdavenport', 5, 'Davenport', 'gwendolynd1234',
951 'Gwendolyn', '', '2011-11-26', '1974-06-28', 'Jr');
953 INSERT INTO actor.usr_address
954 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
955 VALUES ('USA', 'f', '85014', '110 Logical Tone Drive', 'f',
956 'AZ', 'Phoenix', '', 'Maricopa', CURRVAL('actor.usr_id_seq'));
958 INSERT INTO actor.card (barcode, usr)
959 VALUES ('99999372586', CURRVAL('actor.usr_id_seq'));
962 card = CURRVAL('actor.card_id_seq'),
963 billing_address = CURRVAL('actor.usr_address_id_seq'),
964 credit_forward_balance = '0',
965 mailing_address = CURRVAL('actor.usr_address_id_seq')
966 WHERE id=CURRVAL('actor.usr_id_seq');
968 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
969 VALUES (CURRVAL('actor.usr_id_seq'), 5);
971 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
972 FROM actor.org_unit aou
973 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
975 INSERT INTO actor.usr
976 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
977 VALUES (12, 3, 'sbrock', 4, 'Brock', 'scottb1234',
978 'Scott', 'George', '2013-08-01', '1994-07-12', '');
980 INSERT INTO actor.usr_address
981 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
982 VALUES ('USA', 't', '60132', '1760 Channel Bottom', 'f',
983 'IL', 'Carol stream', '', '', CURRVAL('actor.usr_id_seq'));
985 INSERT INTO actor.card (barcode, usr)
986 VALUES ('99999336715', CURRVAL('actor.usr_id_seq'));
989 card = CURRVAL('actor.card_id_seq'),
990 billing_address = CURRVAL('actor.usr_address_id_seq'),
991 credit_forward_balance = '0',
992 mailing_address = CURRVAL('actor.usr_address_id_seq')
993 WHERE id=CURRVAL('actor.usr_id_seq');
995 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
996 VALUES (CURRVAL('actor.usr_id_seq'), 4);
998 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
999 FROM actor.org_unit aou
1000 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1002 INSERT INTO actor.usr
1003 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1004 VALUES (12, 3, 'rjackson', 4, 'Jackson', 'ronaldj1234',
1005 'Ronald', 'Robert', '2011-08-21', '1998-12-07', 'Jr');
1007 INSERT INTO actor.usr_address
1008 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1009 VALUES ('USA', 'f', '04985', '5561 Native Reduction Crossing', 't',
1010 'ME', 'West forks', '', '', CURRVAL('actor.usr_id_seq'));
1012 INSERT INTO actor.card (barcode, usr)
1013 VALUES ('99999335465', CURRVAL('actor.usr_id_seq'));
1015 UPDATE actor.usr SET
1016 card = CURRVAL('actor.card_id_seq'),
1017 billing_address = CURRVAL('actor.usr_address_id_seq'),
1018 credit_forward_balance = '0',
1019 mailing_address = CURRVAL('actor.usr_address_id_seq')
1020 WHERE id=CURRVAL('actor.usr_id_seq');
1022 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1023 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1025 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1026 FROM actor.org_unit aou
1027 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1029 INSERT INTO actor.usr
1030 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1031 VALUES (11, 1, 'wjames', 9, 'James', 'waynej1234',
1032 'Wayne', 'George', '2013-04-20', '1976-01-17', '');
1034 INSERT INTO actor.usr_address
1035 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1036 VALUES ('USA', 't', '27014', '5542 Politics Hollow', 'f',
1037 'NC', 'Cooleemee', '', '', CURRVAL('actor.usr_id_seq'));
1039 INSERT INTO actor.card (barcode, usr)
1040 VALUES ('99999379835', CURRVAL('actor.usr_id_seq'));
1042 UPDATE actor.usr SET
1043 card = CURRVAL('actor.card_id_seq'),
1044 billing_address = CURRVAL('actor.usr_address_id_seq'),
1045 credit_forward_balance = '0',
1046 mailing_address = CURRVAL('actor.usr_address_id_seq')
1047 WHERE id=CURRVAL('actor.usr_id_seq');
1049 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1050 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1052 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1053 FROM actor.org_unit aou
1054 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1056 INSERT INTO actor.usr
1057 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1058 VALUES (11, 1, 'shernandez', 9, 'Hernandez', 'sarahh1234',
1059 'Sarah', 'Elaine', '2014-06-09', '1986-06-27', '');
1061 INSERT INTO actor.usr_address
1062 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1063 VALUES ('USA', 't', '89151', '4939 Family Divide', 't',
1064 'NV', 'Las vegas', '', 'Clark', CURRVAL('actor.usr_id_seq'));
1066 INSERT INTO actor.card (barcode, usr)
1067 VALUES ('99999346587', CURRVAL('actor.usr_id_seq'));
1069 UPDATE actor.usr SET
1070 card = CURRVAL('actor.card_id_seq'),
1071 billing_address = CURRVAL('actor.usr_address_id_seq'),
1072 credit_forward_balance = '0',
1073 mailing_address = CURRVAL('actor.usr_address_id_seq')
1074 WHERE id=CURRVAL('actor.usr_id_seq');
1076 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1077 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1079 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1080 FROM actor.org_unit aou
1081 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1083 INSERT INTO actor.usr
1084 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1085 VALUES (11, 3, 'latkins', 8, 'Atkins', 'louisa1234',
1086 'Louis', 'Edward', '2009-02-26', '1995-02-10', '');
1088 INSERT INTO actor.usr_address
1089 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1090 VALUES ('USA', 't', '44705', '2794 Uniform Value Square', 'f',
1091 'OH', 'Canton', '', 'Stark', CURRVAL('actor.usr_id_seq'));
1093 INSERT INTO actor.card (barcode, usr)
1094 VALUES ('99999377256', CURRVAL('actor.usr_id_seq'));
1096 UPDATE actor.usr SET
1097 card = CURRVAL('actor.card_id_seq'),
1098 billing_address = CURRVAL('actor.usr_address_id_seq'),
1099 credit_forward_balance = '0',
1100 mailing_address = CURRVAL('actor.usr_address_id_seq')
1101 WHERE id=CURRVAL('actor.usr_id_seq');
1103 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1104 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1106 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1107 FROM actor.org_unit aou
1108 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1110 INSERT INTO actor.usr
1111 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1112 VALUES (11, 3, 'wneal', 8, 'Neal', 'waynen1234',
1113 'Wayne', '', '2011-03-15', '1977-06-05', 'Jr');
1115 INSERT INTO actor.usr_address
1116 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1117 VALUES ('USA', 't', '35501', '6178 Relieved Rain Wells', 'f',
1118 'AL', 'Jasper', '', 'Walker', CURRVAL('actor.usr_id_seq'));
1120 INSERT INTO actor.card (barcode, usr)
1121 VALUES ('99999377249', CURRVAL('actor.usr_id_seq'));
1123 UPDATE actor.usr SET
1124 card = CURRVAL('actor.card_id_seq'),
1125 billing_address = CURRVAL('actor.usr_address_id_seq'),
1126 credit_forward_balance = '0',
1127 mailing_address = CURRVAL('actor.usr_address_id_seq')
1128 WHERE id=CURRVAL('actor.usr_id_seq');
1130 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1131 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1133 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1134 FROM actor.org_unit aou
1135 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1137 INSERT INTO actor.usr
1138 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1139 VALUES (11, 3, 'mharrison', 7, 'Harrison', 'michelleh1234',
1140 'Michelle', 'Patricia', '2015-12-05', '1979-12-11', '');
1142 INSERT INTO actor.usr_address
1143 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1144 VALUES ('USA', 't', '05345', '1766 Victorious Estate Avenue', 't',
1145 'VT', 'Newfane', '', 'Windham', CURRVAL('actor.usr_id_seq'));
1147 INSERT INTO actor.card (barcode, usr)
1148 VALUES ('99999376642', CURRVAL('actor.usr_id_seq'));
1150 UPDATE actor.usr SET
1151 card = CURRVAL('actor.card_id_seq'),
1152 billing_address = CURRVAL('actor.usr_address_id_seq'),
1153 credit_forward_balance = '0',
1154 mailing_address = CURRVAL('actor.usr_address_id_seq')
1155 WHERE id=CURRVAL('actor.usr_id_seq');
1157 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1158 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1160 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1161 FROM actor.org_unit aou
1162 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1164 INSERT INTO actor.usr
1165 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1166 VALUES (11, 3, 'hwomack', 7, 'Womack', 'howardw1234',
1167 'Howard', '', '2012-06-12', '1963-03-20', '');
1169 INSERT INTO actor.usr_address
1170 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1171 VALUES ('USA', 't', '06262', '5472 Exhibition Trace', 't',
1172 'CT', 'Quinebaug', '', '', CURRVAL('actor.usr_id_seq'));
1174 INSERT INTO actor.card (barcode, usr)
1175 VALUES ('99999342319', CURRVAL('actor.usr_id_seq'));
1177 UPDATE actor.usr SET
1178 card = CURRVAL('actor.card_id_seq'),
1179 billing_address = CURRVAL('actor.usr_address_id_seq'),
1180 credit_forward_balance = '0',
1181 mailing_address = CURRVAL('actor.usr_address_id_seq')
1182 WHERE id=CURRVAL('actor.usr_id_seq');
1184 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1185 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1187 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1188 FROM actor.org_unit aou
1189 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1191 INSERT INTO actor.usr
1192 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1193 VALUES (11, 3, 'vbacon', 6, 'Bacon', 'virginiab1234',
1194 'Virginia', 'Celia', '2010-08-13', '1992-11-20', '');
1196 INSERT INTO actor.usr_address
1197 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1198 VALUES ('USA', 't', '61638', '4639 Family Tunnel', 't',
1199 'IL', 'Peoria', '', '', CURRVAL('actor.usr_id_seq'));
1201 INSERT INTO actor.card (barcode, usr)
1202 VALUES ('99999362019', CURRVAL('actor.usr_id_seq'));
1204 UPDATE actor.usr SET
1205 card = CURRVAL('actor.card_id_seq'),
1206 billing_address = CURRVAL('actor.usr_address_id_seq'),
1207 credit_forward_balance = '0',
1208 mailing_address = CURRVAL('actor.usr_address_id_seq')
1209 WHERE id=CURRVAL('actor.usr_id_seq');
1211 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1212 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1214 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1215 FROM actor.org_unit aou
1216 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1218 INSERT INTO actor.usr
1219 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1220 VALUES (11, 1, 'lbrooks', 6, 'Brooks', 'lonnieb1234',
1221 'Lonnie', 'William', '2010-08-22', '1981-03-24', '');
1223 INSERT INTO actor.usr_address
1224 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1225 VALUES ('USA', 't', '83836', '8823 Side Fall', 'f',
1226 'ID', 'Hope', '', 'Bonner', CURRVAL('actor.usr_id_seq'));
1228 INSERT INTO actor.card (barcode, usr)
1229 VALUES ('99999326493', CURRVAL('actor.usr_id_seq'));
1231 UPDATE actor.usr SET
1232 card = CURRVAL('actor.card_id_seq'),
1233 billing_address = CURRVAL('actor.usr_address_id_seq'),
1234 credit_forward_balance = '0',
1235 mailing_address = CURRVAL('actor.usr_address_id_seq')
1236 WHERE id=CURRVAL('actor.usr_id_seq');
1238 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1239 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1241 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1242 FROM actor.org_unit aou
1243 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1245 INSERT INTO actor.usr
1246 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1247 VALUES (11, 3, 'mgonzales', 5, 'Gonzales', 'maryg1234',
1248 'Mary', 'Jessica', '2006-12-21', '1988-03-17', '');
1250 INSERT INTO actor.usr_address
1251 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1252 VALUES ('USA', 'f', '16213', '6608 Weary Drawing Lakes', 'f',
1253 'PA', 'Callensburg', '', 'Clarion', CURRVAL('actor.usr_id_seq'));
1255 INSERT INTO actor.card (barcode, usr)
1256 VALUES ('99999337760', CURRVAL('actor.usr_id_seq'));
1258 UPDATE actor.usr SET
1259 card = CURRVAL('actor.card_id_seq'),
1260 billing_address = CURRVAL('actor.usr_address_id_seq'),
1261 credit_forward_balance = '0',
1262 mailing_address = CURRVAL('actor.usr_address_id_seq')
1263 WHERE id=CURRVAL('actor.usr_id_seq');
1265 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1266 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1268 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1269 FROM actor.org_unit aou
1270 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1272 INSERT INTO actor.usr
1273 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1274 VALUES (11, 1, 'mterry', 5, 'Terry', 'michellet1234',
1275 'Michelle', 'Kristy', '2006-05-05', '1972-03-26', '');
1277 INSERT INTO actor.usr_address
1278 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1279 VALUES ('USA', 'f', '30817', '1658 Organisational Bedroom Square', 'f',
1280 'GA', 'Lincolnton', '', '', CURRVAL('actor.usr_id_seq'));
1282 INSERT INTO actor.card (barcode, usr)
1283 VALUES ('99999390692', CURRVAL('actor.usr_id_seq'));
1285 UPDATE actor.usr SET
1286 card = CURRVAL('actor.card_id_seq'),
1287 billing_address = CURRVAL('actor.usr_address_id_seq'),
1288 credit_forward_balance = '0',
1289 mailing_address = CURRVAL('actor.usr_address_id_seq')
1290 WHERE id=CURRVAL('actor.usr_id_seq');
1292 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1293 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1295 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1296 FROM actor.org_unit aou
1297 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1299 INSERT INTO actor.usr
1300 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1301 VALUES (11, 3, 'mmeeks', 4, 'Meeks', 'michellem1234',
1302 'Michelle', 'Myra', '2011-08-21', '1966-01-23', 'III');
1304 INSERT INTO actor.usr_address
1305 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1306 VALUES ('USA', 'f', '88240', '7269 Sister Gardens', 'f',
1307 'NM', 'Hobbs', '', 'Lea', CURRVAL('actor.usr_id_seq'));
1309 INSERT INTO actor.card (barcode, usr)
1310 VALUES ('99999396672', CURRVAL('actor.usr_id_seq'));
1312 UPDATE actor.usr SET
1313 card = CURRVAL('actor.card_id_seq'),
1314 billing_address = CURRVAL('actor.usr_address_id_seq'),
1315 credit_forward_balance = '0',
1316 mailing_address = CURRVAL('actor.usr_address_id_seq')
1317 WHERE id=CURRVAL('actor.usr_id_seq');
1319 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1320 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1322 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1323 FROM actor.org_unit aou
1324 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1326 INSERT INTO actor.usr
1327 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1328 VALUES (11, 3, 'epalmer', 4, 'Palmer', 'elvap1234',
1329 'Elva', 'Tiffany', '2009-05-01', '1987-08-21', 'Jr');
1331 INSERT INTO actor.usr_address
1332 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1333 VALUES ('USA', 't', '50595', '7864 Remarkable Status River', 'f',
1334 'IA', 'Webster city', '', 'Hamilton', CURRVAL('actor.usr_id_seq'));
1336 INSERT INTO actor.card (barcode, usr)
1337 VALUES ('99999335171', CURRVAL('actor.usr_id_seq'));
1339 UPDATE actor.usr SET
1340 card = CURRVAL('actor.card_id_seq'),
1341 billing_address = CURRVAL('actor.usr_address_id_seq'),
1342 credit_forward_balance = '0',
1343 mailing_address = CURRVAL('actor.usr_address_id_seq')
1344 WHERE id=CURRVAL('actor.usr_id_seq');
1346 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1347 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1349 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1350 FROM actor.org_unit aou
1351 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1353 INSERT INTO actor.usr
1354 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1355 VALUES (10, 3, 'mwilliams', 9, 'Williams', 'mattheww1234',
1356 'Matthew', '', '2007-01-20', '1977-10-25', '');
1358 INSERT INTO actor.usr_address
1359 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1360 VALUES ('USA', 'f', '60064', '7230 Trend Mount', 'f',
1361 'IL', 'North chicago', '', 'Lake', CURRVAL('actor.usr_id_seq'));
1363 INSERT INTO actor.card (barcode, usr)
1364 VALUES ('99999365046', CURRVAL('actor.usr_id_seq'));
1366 UPDATE actor.usr SET
1367 card = CURRVAL('actor.card_id_seq'),
1368 billing_address = CURRVAL('actor.usr_address_id_seq'),
1369 credit_forward_balance = '0',
1370 mailing_address = CURRVAL('actor.usr_address_id_seq')
1371 WHERE id=CURRVAL('actor.usr_id_seq');
1373 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1374 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1376 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1377 FROM actor.org_unit aou
1378 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1380 INSERT INTO actor.usr
1381 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1382 VALUES (10, 1, 'nperez', 9, 'Perez', 'nicholasp1234',
1383 'Nicholas', 'Joseph', '2008-01-11', '1990-09-27', '');
1385 INSERT INTO actor.usr_address
1386 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1387 VALUES ('USA', 'f', '55076', '9299 Democratic Hill Cliffs', 'f',
1388 'MN', 'Inver grove heights', '', '', CURRVAL('actor.usr_id_seq'));
1390 INSERT INTO actor.card (barcode, usr)
1391 VALUES ('99999391887', CURRVAL('actor.usr_id_seq'));
1393 UPDATE actor.usr SET
1394 card = CURRVAL('actor.card_id_seq'),
1395 billing_address = CURRVAL('actor.usr_address_id_seq'),
1396 credit_forward_balance = '0',
1397 mailing_address = CURRVAL('actor.usr_address_id_seq')
1398 WHERE id=CURRVAL('actor.usr_id_seq');
1400 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1401 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1403 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1404 FROM actor.org_unit aou
1405 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1407 INSERT INTO actor.usr
1408 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1409 VALUES (10, 3, 'bfisher', 8, 'Fisher', 'barbaraf1234',
1410 'Barbara', '', '2008-02-03', '1960-10-04', '');
1412 INSERT INTO actor.usr_address
1413 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1414 VALUES ('USA', 't', '61756', '9822 Excess Start Lock', 'f',
1415 'IL', 'Maroa', '', 'Macon', CURRVAL('actor.usr_id_seq'));
1417 INSERT INTO actor.card (barcode, usr)
1418 VALUES ('99999325028', CURRVAL('actor.usr_id_seq'));
1420 UPDATE actor.usr SET
1421 card = CURRVAL('actor.card_id_seq'),
1422 billing_address = CURRVAL('actor.usr_address_id_seq'),
1423 credit_forward_balance = '0',
1424 mailing_address = CURRVAL('actor.usr_address_id_seq')
1425 WHERE id=CURRVAL('actor.usr_id_seq');
1427 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1428 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1430 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1431 FROM actor.org_unit aou
1432 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1434 INSERT INTO actor.usr
1435 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1436 VALUES (10, 3, 'mmendoza', 8, 'Mendoza', 'miguelm1234',
1437 'Miguel', '', '2015-04-15', '1980-05-28', '');
1439 INSERT INTO actor.usr_address
1440 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1441 VALUES ('USA', 'f', '58773', '5831 Residential Respect Track', 'f',
1442 'ND', 'Powers lake', '', 'Burke', CURRVAL('actor.usr_id_seq'));
1444 INSERT INTO actor.card (barcode, usr)
1445 VALUES ('99999338966', CURRVAL('actor.usr_id_seq'));
1447 UPDATE actor.usr SET
1448 card = CURRVAL('actor.card_id_seq'),
1449 billing_address = CURRVAL('actor.usr_address_id_seq'),
1450 credit_forward_balance = '0',
1451 mailing_address = CURRVAL('actor.usr_address_id_seq')
1452 WHERE id=CURRVAL('actor.usr_id_seq');
1454 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1455 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1457 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1458 FROM actor.org_unit aou
1459 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1461 INSERT INTO actor.usr
1462 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1463 VALUES (10, 1, 'ldickinson', 7, 'Dickinson', 'leed1234',
1464 'Lee', 'Annie', '2014-07-19', '1986-02-08', '');
1466 INSERT INTO actor.usr_address
1467 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1468 VALUES ('USA', 't', '12803', '5030 Vision Loop', 'f',
1469 'NY', 'South glens falls', '', 'Saratoga', CURRVAL('actor.usr_id_seq'));
1471 INSERT INTO actor.card (barcode, usr)
1472 VALUES ('99999328210', CURRVAL('actor.usr_id_seq'));
1474 UPDATE actor.usr SET
1475 card = CURRVAL('actor.card_id_seq'),
1476 billing_address = CURRVAL('actor.usr_address_id_seq'),
1477 credit_forward_balance = '0',
1478 mailing_address = CURRVAL('actor.usr_address_id_seq')
1479 WHERE id=CURRVAL('actor.usr_id_seq');
1481 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1482 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1484 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1485 FROM actor.org_unit aou
1486 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1488 INSERT INTO actor.usr
1489 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1490 VALUES (10, 1, 'awilliams', 7, 'Williams', 'angelinaw1234',
1491 'Angelina', 'Joan', '2012-06-28', '1995-08-01', '');
1493 INSERT INTO actor.usr_address
1494 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1495 VALUES ('USA', 't', '25054', '1723 Multiple Object Canyon', 'f',
1496 'WV', 'Dawes', '', 'Kanawha', CURRVAL('actor.usr_id_seq'));
1498 INSERT INTO actor.card (barcode, usr)
1499 VALUES ('99999373939', CURRVAL('actor.usr_id_seq'));
1501 UPDATE actor.usr SET
1502 card = CURRVAL('actor.card_id_seq'),
1503 billing_address = CURRVAL('actor.usr_address_id_seq'),
1504 credit_forward_balance = '0',
1505 mailing_address = CURRVAL('actor.usr_address_id_seq')
1506 WHERE id=CURRVAL('actor.usr_id_seq');
1508 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1509 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1511 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1512 FROM actor.org_unit aou
1513 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1515 INSERT INTO actor.usr
1516 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1517 VALUES (10, 1, 'bsanchez', 6, 'Sanchez', 'beths1234',
1518 'Beth', 'Deborah', '2015-08-21', '1974-10-23', '');
1520 INSERT INTO actor.usr_address
1521 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1522 VALUES ('USA', 'f', '36426', '5148 Shaggy Farm Center', 'f',
1523 'AL', 'Brewton', '', 'Escambia', CURRVAL('actor.usr_id_seq'));
1525 INSERT INTO actor.card (barcode, usr)
1526 VALUES ('99999354471', CURRVAL('actor.usr_id_seq'));
1528 UPDATE actor.usr SET
1529 card = CURRVAL('actor.card_id_seq'),
1530 billing_address = CURRVAL('actor.usr_address_id_seq'),
1531 credit_forward_balance = '0',
1532 mailing_address = CURRVAL('actor.usr_address_id_seq')
1533 WHERE id=CURRVAL('actor.usr_id_seq');
1535 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1536 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1538 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1539 FROM actor.org_unit aou
1540 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1542 INSERT INTO actor.usr
1543 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1544 VALUES (10, 3, 'ethompson', 6, 'Thompson', 'elvint1234',
1545 'Elvin', '', '2009-08-26', '1968-06-21', '');
1547 INSERT INTO actor.usr_address
1548 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1549 VALUES ('USA', 't', '67664', '2800 Cheerful Animal Valley', 'f',
1550 'KS', 'Prairie view', '', '', CURRVAL('actor.usr_id_seq'));
1552 INSERT INTO actor.card (barcode, usr)
1553 VALUES ('99999320974', CURRVAL('actor.usr_id_seq'));
1555 UPDATE actor.usr SET
1556 card = CURRVAL('actor.card_id_seq'),
1557 billing_address = CURRVAL('actor.usr_address_id_seq'),
1558 credit_forward_balance = '0',
1559 mailing_address = CURRVAL('actor.usr_address_id_seq')
1560 WHERE id=CURRVAL('actor.usr_id_seq');
1562 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1563 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1565 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1566 FROM actor.org_unit aou
1567 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1569 INSERT INTO actor.usr
1570 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1571 VALUES (10, 1, 'dlawson', 5, 'Lawson', 'doral1234',
1572 'Dora', '', '2009-08-26', '1978-05-23', '');
1574 INSERT INTO actor.usr_address
1575 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1576 VALUES ('USA', 'f', '63957', '6016 General Dog Divide', 'f',
1577 'MO', 'Piedmont', '', 'Wayne', CURRVAL('actor.usr_id_seq'));
1579 INSERT INTO actor.card (barcode, usr)
1580 VALUES ('99999394437', CURRVAL('actor.usr_id_seq'));
1582 UPDATE actor.usr SET
1583 card = CURRVAL('actor.card_id_seq'),
1584 billing_address = CURRVAL('actor.usr_address_id_seq'),
1585 credit_forward_balance = '0',
1586 mailing_address = CURRVAL('actor.usr_address_id_seq')
1587 WHERE id=CURRVAL('actor.usr_id_seq');
1589 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1590 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1592 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1593 FROM actor.org_unit aou
1594 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1596 INSERT INTO actor.usr
1597 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1598 VALUES (10, 1, 'lvargas', 5, 'Vargas', 'laurav1234',
1599 'Laura', 'Mildred', '2013-04-01', '1989-07-04', 'III');
1601 INSERT INTO actor.usr_address
1602 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1603 VALUES ('USA', 't', '62526', '4689 Alert Minute Court', 'f',
1604 'IL', 'Decatur', '', '', CURRVAL('actor.usr_id_seq'));
1606 INSERT INTO actor.card (barcode, usr)
1607 VALUES ('99999317988', CURRVAL('actor.usr_id_seq'));
1609 UPDATE actor.usr SET
1610 card = CURRVAL('actor.card_id_seq'),
1611 billing_address = CURRVAL('actor.usr_address_id_seq'),
1612 credit_forward_balance = '0',
1613 mailing_address = CURRVAL('actor.usr_address_id_seq')
1614 WHERE id=CURRVAL('actor.usr_id_seq');
1616 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1617 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1619 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1620 FROM actor.org_unit aou
1621 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1623 INSERT INTO actor.usr
1624 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1625 VALUES (10, 3, 'wrandall', 4, 'Randall', 'williamr1234',
1626 'William', 'James', '2015-04-25', '1976-10-06', '');
1628 INSERT INTO actor.usr_address
1629 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1630 VALUES ('USA', 'f', '72117', '3448 Minor Solicitor Junction', 'f',
1631 'AR', 'North little rock', '', '', CURRVAL('actor.usr_id_seq'));
1633 INSERT INTO actor.card (barcode, usr)
1634 VALUES ('99999393617', CURRVAL('actor.usr_id_seq'));
1636 UPDATE actor.usr SET
1637 card = CURRVAL('actor.card_id_seq'),
1638 billing_address = CURRVAL('actor.usr_address_id_seq'),
1639 credit_forward_balance = '0',
1640 mailing_address = CURRVAL('actor.usr_address_id_seq')
1641 WHERE id=CURRVAL('actor.usr_id_seq');
1643 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1644 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1646 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1647 FROM actor.org_unit aou
1648 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1650 INSERT INTO actor.usr
1651 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1652 VALUES (10, 1, 'csmith', 4, 'Smith', 'cathys1234',
1653 'Cathy', 'Cheryl', '2014-07-22', '1989-02-17', '');
1655 INSERT INTO actor.usr_address
1656 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1657 VALUES ('USA', 'f', '81420', '784 Striking Theatre Fords', 't',
1658 'CO', 'Lazear', '', 'Delta', CURRVAL('actor.usr_id_seq'));
1660 INSERT INTO actor.card (barcode, usr)
1661 VALUES ('99999389406', CURRVAL('actor.usr_id_seq'));
1663 UPDATE actor.usr SET
1664 card = CURRVAL('actor.card_id_seq'),
1665 billing_address = CURRVAL('actor.usr_address_id_seq'),
1666 credit_forward_balance = '0',
1667 mailing_address = CURRVAL('actor.usr_address_id_seq')
1668 WHERE id=CURRVAL('actor.usr_id_seq');
1670 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1671 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1673 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1674 FROM actor.org_unit aou
1675 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1677 INSERT INTO actor.usr
1678 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1679 VALUES (9, 1, 'alopez', 9, 'Lopez', 'arlinel1234',
1680 'Arline', 'Amber', '2013-03-28', '1985-05-05', 'III');
1682 INSERT INTO actor.usr_address
1683 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1684 VALUES ('USA', 't', '19053', '5012 Unemployed Other Harbor', 'f',
1685 'PA', 'Feasterville trevose', '', 'Bucks', CURRVAL('actor.usr_id_seq'));
1687 INSERT INTO actor.card (barcode, usr)
1688 VALUES ('99999330939', CURRVAL('actor.usr_id_seq'));
1690 UPDATE actor.usr SET
1691 card = CURRVAL('actor.card_id_seq'),
1692 billing_address = CURRVAL('actor.usr_address_id_seq'),
1693 credit_forward_balance = '0',
1694 mailing_address = CURRVAL('actor.usr_address_id_seq')
1695 WHERE id=CURRVAL('actor.usr_id_seq');
1697 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1698 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1700 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1701 FROM actor.org_unit aou
1702 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1704 INSERT INTO actor.usr
1705 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1706 VALUES (9, 1, 'epeterson', 9, 'Peterson', 'emmap1234',
1707 'Emma', '', '2015-06-11', '1962-09-24', '');
1709 INSERT INTO actor.usr_address
1710 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1711 VALUES ('USA', 't', '07095', '9931 Hushed Passage Turnpike', 'f',
1712 'NJ', 'Woodbridge', '', 'Middlesex', CURRVAL('actor.usr_id_seq'));
1714 INSERT INTO actor.card (barcode, usr)
1715 VALUES ('99999346297', CURRVAL('actor.usr_id_seq'));
1717 UPDATE actor.usr SET
1718 card = CURRVAL('actor.card_id_seq'),
1719 billing_address = CURRVAL('actor.usr_address_id_seq'),
1720 credit_forward_balance = '0',
1721 mailing_address = CURRVAL('actor.usr_address_id_seq')
1722 WHERE id=CURRVAL('actor.usr_id_seq');
1724 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1725 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1727 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1728 FROM actor.org_unit aou
1729 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1731 INSERT INTO actor.usr
1732 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1733 VALUES (9, 1, 'okelly', 8, 'Kelly', 'opalk1234',
1734 'Opal', 'Sara', '2008-05-25', '1975-01-18', 'III');
1736 INSERT INTO actor.usr_address
1737 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1738 VALUES ('USA', 't', '79550', '8572 Ltd Bar Brook', 't',
1739 'TX', 'Snyder', '', 'Scurry', CURRVAL('actor.usr_id_seq'));
1741 INSERT INTO actor.card (barcode, usr)
1742 VALUES ('99999355455', CURRVAL('actor.usr_id_seq'));
1744 UPDATE actor.usr SET
1745 card = CURRVAL('actor.card_id_seq'),
1746 billing_address = CURRVAL('actor.usr_address_id_seq'),
1747 credit_forward_balance = '0',
1748 mailing_address = CURRVAL('actor.usr_address_id_seq')
1749 WHERE id=CURRVAL('actor.usr_id_seq');
1751 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1752 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1754 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1755 FROM actor.org_unit aou
1756 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1758 INSERT INTO actor.usr
1759 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1760 VALUES (9, 1, 'cdonovan', 8, 'Donovan', 'charlied1234',
1761 'Charlie', 'David', '2009-06-18', '1981-09-17', '');
1763 INSERT INTO actor.usr_address
1764 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1765 VALUES ('USA', 'f', '54017', '1926 Double Effort Spring', 'f',
1766 'WI', 'New richmond', '', '', CURRVAL('actor.usr_id_seq'));
1768 INSERT INTO actor.card (barcode, usr)
1769 VALUES ('99999348978', CURRVAL('actor.usr_id_seq'));
1771 UPDATE actor.usr SET
1772 card = CURRVAL('actor.card_id_seq'),
1773 billing_address = CURRVAL('actor.usr_address_id_seq'),
1774 credit_forward_balance = '0',
1775 mailing_address = CURRVAL('actor.usr_address_id_seq')
1776 WHERE id=CURRVAL('actor.usr_id_seq');
1778 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1779 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1781 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1782 FROM actor.org_unit aou
1783 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1785 INSERT INTO actor.usr
1786 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1787 VALUES (9, 3, 'msmith', 7, 'Smith', 'marthas1234',
1788 'Martha', 'Raquel', '2014-12-24', '1962-06-21', '');
1790 INSERT INTO actor.usr_address
1791 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1792 VALUES ('USA', 'f', '80534', '7185 Arbitrary Contrast Freeway', 'f',
1793 'CO', 'Johnstown', '', 'Weld', CURRVAL('actor.usr_id_seq'));
1795 INSERT INTO actor.card (barcode, usr)
1796 VALUES ('99999394964', CURRVAL('actor.usr_id_seq'));
1798 UPDATE actor.usr SET
1799 card = CURRVAL('actor.card_id_seq'),
1800 billing_address = CURRVAL('actor.usr_address_id_seq'),
1801 credit_forward_balance = '0',
1802 mailing_address = CURRVAL('actor.usr_address_id_seq')
1803 WHERE id=CURRVAL('actor.usr_id_seq');
1805 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1806 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1808 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1809 FROM actor.org_unit aou
1810 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1812 INSERT INTO actor.usr
1813 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1814 VALUES (9, 3, 'chouston', 7, 'Houston', 'cherylh1234',
1815 'Cheryl', '', '2014-09-18', '1975-12-15', '');
1817 INSERT INTO actor.usr_address
1818 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1819 VALUES ('USA', 't', '93703', '2782 Awake Day Square', 't',
1820 'CA', 'Fresno', '', 'Fresno', CURRVAL('actor.usr_id_seq'));
1822 INSERT INTO actor.card (barcode, usr)
1823 VALUES ('99999320969', CURRVAL('actor.usr_id_seq'));
1825 UPDATE actor.usr SET
1826 card = CURRVAL('actor.card_id_seq'),
1827 billing_address = CURRVAL('actor.usr_address_id_seq'),
1828 credit_forward_balance = '0',
1829 mailing_address = CURRVAL('actor.usr_address_id_seq')
1830 WHERE id=CURRVAL('actor.usr_id_seq');
1832 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1833 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1835 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1836 FROM actor.org_unit aou
1837 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1839 INSERT INTO actor.usr
1840 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1841 VALUES (9, 1, 'kwright', 6, 'Wright', 'kayw1234',
1842 'Kay', 'Anna', '2015-01-23', '1965-05-23', '');
1844 INSERT INTO actor.usr_address
1845 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1846 VALUES ('USA', 'f', '22834', '4585 Whole Harbor', 't',
1847 'VA', 'Linville', '', '', CURRVAL('actor.usr_id_seq'));
1849 INSERT INTO actor.card (barcode, usr)
1850 VALUES ('99999398195', CURRVAL('actor.usr_id_seq'));
1852 UPDATE actor.usr SET
1853 card = CURRVAL('actor.card_id_seq'),
1854 billing_address = CURRVAL('actor.usr_address_id_seq'),
1855 credit_forward_balance = '0',
1856 mailing_address = CURRVAL('actor.usr_address_id_seq')
1857 WHERE id=CURRVAL('actor.usr_id_seq');
1859 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1860 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1862 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1863 FROM actor.org_unit aou
1864 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1866 INSERT INTO actor.usr
1867 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1868 VALUES (9, 3, 'mlane', 6, 'Lane', 'michellel1234',
1869 'Michelle', 'Andrea', '2006-12-28', '1963-06-14', 'Sr');
1871 INSERT INTO actor.usr_address
1872 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1873 VALUES ('USA', 't', '98110', '8676 Thundering Loss Field', 't',
1874 'WA', 'Bainbridge island', '', 'Kitsap', CURRVAL('actor.usr_id_seq'));
1876 INSERT INTO actor.card (barcode, usr)
1877 VALUES ('99999333153', CURRVAL('actor.usr_id_seq'));
1879 UPDATE actor.usr SET
1880 card = CURRVAL('actor.card_id_seq'),
1881 billing_address = CURRVAL('actor.usr_address_id_seq'),
1882 credit_forward_balance = '0',
1883 mailing_address = CURRVAL('actor.usr_address_id_seq')
1884 WHERE id=CURRVAL('actor.usr_id_seq');
1886 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1887 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1889 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1890 FROM actor.org_unit aou
1891 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1893 INSERT INTO actor.usr
1894 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1895 VALUES (9, 1, 'rsmith', 5, 'Smith', 'roberts1234',
1896 'Robert', '', '2006-05-01', '1987-06-24', '');
1898 INSERT INTO actor.usr_address
1899 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1900 VALUES ('USA', 't', '00983', '231 Causal Expert Highway', 'f',
1901 'PR', 'Carolina', '', 'Carolina', CURRVAL('actor.usr_id_seq'));
1903 INSERT INTO actor.card (barcode, usr)
1904 VALUES ('99999362675', CURRVAL('actor.usr_id_seq'));
1906 UPDATE actor.usr SET
1907 card = CURRVAL('actor.card_id_seq'),
1908 billing_address = CURRVAL('actor.usr_address_id_seq'),
1909 credit_forward_balance = '0',
1910 mailing_address = CURRVAL('actor.usr_address_id_seq')
1911 WHERE id=CURRVAL('actor.usr_id_seq');
1913 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1914 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1916 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1917 FROM actor.org_unit aou
1918 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1920 INSERT INTO actor.usr
1921 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1922 VALUES (9, 1, 'cdodson', 5, 'Dodson', 'cleod1234',
1923 'Cleo', '', '2007-02-09', '1974-11-14', '');
1925 INSERT INTO actor.usr_address
1926 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1927 VALUES ('USA', 't', '25266', '53 Nice Customer Green', 'f',
1928 'WV', 'Newton', '', 'Roane', CURRVAL('actor.usr_id_seq'));
1930 INSERT INTO actor.card (barcode, usr)
1931 VALUES ('99999362218', CURRVAL('actor.usr_id_seq'));
1933 UPDATE actor.usr SET
1934 card = CURRVAL('actor.card_id_seq'),
1935 billing_address = CURRVAL('actor.usr_address_id_seq'),
1936 credit_forward_balance = '0',
1937 mailing_address = CURRVAL('actor.usr_address_id_seq')
1938 WHERE id=CURRVAL('actor.usr_id_seq');
1940 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1941 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1943 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1944 FROM actor.org_unit aou
1945 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1947 INSERT INTO actor.usr
1948 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1949 VALUES (9, 1, 'mneal', 4, 'Neal', 'melvinn1234',
1950 'Melvin', 'Richard', '2007-03-14', '1993-08-16', '');
1952 INSERT INTO actor.usr_address
1953 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1954 VALUES ('USA', 't', '10150', '668 Unconscious Gun Spring', 'f',
1955 'NY', 'New york', '', 'New york', CURRVAL('actor.usr_id_seq'));
1957 INSERT INTO actor.card (barcode, usr)
1958 VALUES ('99999317310', CURRVAL('actor.usr_id_seq'));
1960 UPDATE actor.usr SET
1961 card = CURRVAL('actor.card_id_seq'),
1962 billing_address = CURRVAL('actor.usr_address_id_seq'),
1963 credit_forward_balance = '0',
1964 mailing_address = CURRVAL('actor.usr_address_id_seq')
1965 WHERE id=CURRVAL('actor.usr_id_seq');
1967 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1968 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1970 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1971 FROM actor.org_unit aou
1972 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1974 INSERT INTO actor.usr
1975 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1976 VALUES (9, 3, 'awilliams', 4, 'Williams', 'annaw1234',
1977 'Anna', 'Justine', '2010-12-27', '1990-11-09', '');
1979 INSERT INTO actor.usr_address
1980 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1981 VALUES ('USA', 'f', '45809', '749 Software Center', 't',
1982 'OH', 'Gomer', '', 'Allen', CURRVAL('actor.usr_id_seq'));
1984 INSERT INTO actor.card (barcode, usr)
1985 VALUES ('99999392361', CURRVAL('actor.usr_id_seq'));
1987 UPDATE actor.usr SET
1988 card = CURRVAL('actor.card_id_seq'),
1989 billing_address = CURRVAL('actor.usr_address_id_seq'),
1990 credit_forward_balance = '0',
1991 mailing_address = CURRVAL('actor.usr_address_id_seq')
1992 WHERE id=CURRVAL('actor.usr_id_seq');
1994 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1995 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1997 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1998 FROM actor.org_unit aou
1999 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2001 INSERT INTO actor.usr
2002 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2003 VALUES (8, 1, 'emiller', 9, 'Miller', 'edmondm1234',
2004 'Edmond', 'Vance', '2008-05-04', '1993-05-16', '');
2006 INSERT INTO actor.usr_address
2007 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2008 VALUES ('USA', 'f', '92007', '2632 Unlikely Assumption Tunnel', 'f',
2009 'CA', 'Cardiff by the sea', '', 'San diego', CURRVAL('actor.usr_id_seq'));
2011 INSERT INTO actor.card (barcode, usr)
2012 VALUES ('99999371777', CURRVAL('actor.usr_id_seq'));
2014 UPDATE actor.usr SET
2015 card = CURRVAL('actor.card_id_seq'),
2016 billing_address = CURRVAL('actor.usr_address_id_seq'),
2017 credit_forward_balance = '0',
2018 mailing_address = CURRVAL('actor.usr_address_id_seq')
2019 WHERE id=CURRVAL('actor.usr_id_seq');
2021 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2022 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2024 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2025 FROM actor.org_unit aou
2026 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2028 INSERT INTO actor.usr
2029 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2030 VALUES (8, 3, 'vlogan', 9, 'Logan', 'vanessal1234',
2031 'Vanessa', 'Cassandra', '2009-05-17', '1991-02-01', '');
2033 INSERT INTO actor.usr_address
2034 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2035 VALUES ('USA', 'f', '44470', '2823 Eventual Hour Gateway', 'f',
2036 'OH', 'Southington', '', 'Trumbull', CURRVAL('actor.usr_id_seq'));
2038 INSERT INTO actor.card (barcode, usr)
2039 VALUES ('99999372363', CURRVAL('actor.usr_id_seq'));
2041 UPDATE actor.usr SET
2042 card = CURRVAL('actor.card_id_seq'),
2043 billing_address = CURRVAL('actor.usr_address_id_seq'),
2044 credit_forward_balance = '0',
2045 mailing_address = CURRVAL('actor.usr_address_id_seq')
2046 WHERE id=CURRVAL('actor.usr_id_seq');
2048 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2049 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2051 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2052 FROM actor.org_unit aou
2053 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2055 INSERT INTO actor.usr
2056 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2057 VALUES (8, 1, 'lthompson', 8, 'Thompson', 'lisat1234',
2058 'Lisa', 'Shirley', '2011-05-19', '1972-05-11', '');
2060 INSERT INTO actor.usr_address
2061 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2062 VALUES ('USA', 'f', '45690', '2166 Newspaper Grove', 't',
2063 'OH', 'Waverly', '', 'Pike', CURRVAL('actor.usr_id_seq'));
2065 INSERT INTO actor.card (barcode, usr)
2066 VALUES ('99999321149', CURRVAL('actor.usr_id_seq'));
2068 UPDATE actor.usr SET
2069 card = CURRVAL('actor.card_id_seq'),
2070 billing_address = CURRVAL('actor.usr_address_id_seq'),
2071 credit_forward_balance = '0',
2072 mailing_address = CURRVAL('actor.usr_address_id_seq')
2073 WHERE id=CURRVAL('actor.usr_id_seq');
2075 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2076 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2078 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2079 FROM actor.org_unit aou
2080 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2082 INSERT INTO actor.usr
2083 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2084 VALUES (8, 1, 'oshaffer', 8, 'Shaffer', 'ollies1234',
2085 'Ollie', 'Monica', '2006-05-16', '1977-01-17', '');
2087 INSERT INTO actor.usr_address
2088 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2089 VALUES ('USA', 't', '15534', '2134 Inc Boat Turnpike', 't',
2090 'PA', 'Buffalo mills', '', 'Bedford', CURRVAL('actor.usr_id_seq'));
2092 INSERT INTO actor.card (barcode, usr)
2093 VALUES ('99999335455', CURRVAL('actor.usr_id_seq'));
2095 UPDATE actor.usr SET
2096 card = CURRVAL('actor.card_id_seq'),
2097 billing_address = CURRVAL('actor.usr_address_id_seq'),
2098 credit_forward_balance = '0',
2099 mailing_address = CURRVAL('actor.usr_address_id_seq')
2100 WHERE id=CURRVAL('actor.usr_id_seq');
2102 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2103 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2105 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2106 FROM actor.org_unit aou
2107 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2109 INSERT INTO actor.usr
2110 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2111 VALUES (8, 1, 'randrews', 7, 'Andrews', 'raymonda1234',
2112 'Raymond', 'Willie', '2013-02-17', '1996-11-25', '');
2114 INSERT INTO actor.usr_address
2115 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2116 VALUES ('USA', 'f', '06018', '1944 Hot Tape Valley', 't',
2117 'CT', 'Canaan', '', '', CURRVAL('actor.usr_id_seq'));
2119 INSERT INTO actor.card (barcode, usr)
2120 VALUES ('99999346031', CURRVAL('actor.usr_id_seq'));
2122 UPDATE actor.usr SET
2123 card = CURRVAL('actor.card_id_seq'),
2124 billing_address = CURRVAL('actor.usr_address_id_seq'),
2125 credit_forward_balance = '0',
2126 mailing_address = CURRVAL('actor.usr_address_id_seq')
2127 WHERE id=CURRVAL('actor.usr_id_seq');
2129 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2130 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2132 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2133 FROM actor.org_unit aou
2134 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2136 INSERT INTO actor.usr
2137 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2138 VALUES (8, 3, 'emartinez', 7, 'Martinez', 'ednam1234',
2139 'Edna', 'Judith', '2007-04-22', '1990-04-23', '');
2141 INSERT INTO actor.usr_address
2142 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2143 VALUES ('USA', 't', '49270', '121 Consequence Club', 'f',
2144 'MI', 'Petersburg', '', '', CURRVAL('actor.usr_id_seq'));
2146 INSERT INTO actor.card (barcode, usr)
2147 VALUES ('99999336926', CURRVAL('actor.usr_id_seq'));
2149 UPDATE actor.usr SET
2150 card = CURRVAL('actor.card_id_seq'),
2151 billing_address = CURRVAL('actor.usr_address_id_seq'),
2152 credit_forward_balance = '0',
2153 mailing_address = CURRVAL('actor.usr_address_id_seq')
2154 WHERE id=CURRVAL('actor.usr_id_seq');
2156 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2157 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2159 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2160 FROM actor.org_unit aou
2161 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2163 INSERT INTO actor.usr
2164 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2165 VALUES (8, 3, 'jdavis', 6, 'Davis', 'jamesd1234',
2166 'James', 'Jerry', '2009-02-26', '1970-06-11', 'III');
2168 INSERT INTO actor.usr_address
2169 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2170 VALUES ('USA', 'f', '58064', '5708 Brainy West Bend', 'f',
2171 'ND', 'Page', '', 'Cass', CURRVAL('actor.usr_id_seq'));
2173 INSERT INTO actor.card (barcode, usr)
2174 VALUES ('99999363070', CURRVAL('actor.usr_id_seq'));
2176 UPDATE actor.usr SET
2177 card = CURRVAL('actor.card_id_seq'),
2178 billing_address = CURRVAL('actor.usr_address_id_seq'),
2179 credit_forward_balance = '0',
2180 mailing_address = CURRVAL('actor.usr_address_id_seq')
2181 WHERE id=CURRVAL('actor.usr_id_seq');
2183 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2184 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2186 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2187 FROM actor.org_unit aou
2188 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2190 INSERT INTO actor.usr
2191 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2192 VALUES (8, 1, 'droberts', 6, 'Roberts', 'dianer1234',
2193 'Diane', 'Teresa', '2006-12-18', '1969-02-18', '');
2195 INSERT INTO actor.usr_address
2196 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2197 VALUES ('USA', 'f', '00692', '9609 Advanced Tool Mountain', 't',
2198 'PR', 'Vega alta', '', 'Vega alta', CURRVAL('actor.usr_id_seq'));
2200 INSERT INTO actor.card (barcode, usr)
2201 VALUES ('99999357381', CURRVAL('actor.usr_id_seq'));
2203 UPDATE actor.usr SET
2204 card = CURRVAL('actor.card_id_seq'),
2205 billing_address = CURRVAL('actor.usr_address_id_seq'),
2206 credit_forward_balance = '0',
2207 mailing_address = CURRVAL('actor.usr_address_id_seq')
2208 WHERE id=CURRVAL('actor.usr_id_seq');
2210 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2211 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2213 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2214 FROM actor.org_unit aou
2215 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2217 INSERT INTO actor.usr
2218 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2219 VALUES (8, 1, 'psantiago', 5, 'Santiago', 'paiges1234',
2220 'Paige', 'Helen', '2011-06-07', '1979-08-23', 'Sr');
2222 INSERT INTO actor.usr_address
2223 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2224 VALUES ('USA', 't', '91608', '2852 Key Incident Avenue', 't',
2225 'CA', 'Universal city', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
2227 INSERT INTO actor.card (barcode, usr)
2228 VALUES ('99999394956', CURRVAL('actor.usr_id_seq'));
2230 UPDATE actor.usr SET
2231 card = CURRVAL('actor.card_id_seq'),
2232 billing_address = CURRVAL('actor.usr_address_id_seq'),
2233 credit_forward_balance = '0',
2234 mailing_address = CURRVAL('actor.usr_address_id_seq')
2235 WHERE id=CURRVAL('actor.usr_id_seq');
2237 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2238 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2240 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2241 FROM actor.org_unit aou
2242 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2244 INSERT INTO actor.usr
2245 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2246 VALUES (8, 1, 'awright', 5, 'Wright', 'alyssaw1234',
2247 'Alyssa', 'Christine', '2008-10-19', '1994-05-23', '');
2249 INSERT INTO actor.usr_address
2250 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2251 VALUES ('USA', 't', '80295', '7771 Alive Iron Mission', 'f',
2252 'CO', 'Denver', '', 'Denver', CURRVAL('actor.usr_id_seq'));
2254 INSERT INTO actor.card (barcode, usr)
2255 VALUES ('99999367802', CURRVAL('actor.usr_id_seq'));
2257 UPDATE actor.usr SET
2258 card = CURRVAL('actor.card_id_seq'),
2259 billing_address = CURRVAL('actor.usr_address_id_seq'),
2260 credit_forward_balance = '0',
2261 mailing_address = CURRVAL('actor.usr_address_id_seq')
2262 WHERE id=CURRVAL('actor.usr_id_seq');
2264 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2265 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2267 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2268 FROM actor.org_unit aou
2269 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2271 INSERT INTO actor.usr
2272 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2273 VALUES (8, 3, 'dbeck', 4, 'Beck', 'dianab1234',
2274 'Diana', 'Wilma', '2010-08-09', '1971-04-22', '');
2276 INSERT INTO actor.usr_address
2277 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2278 VALUES ('USA', 't', '58776', '1146 Ability Centers', 'f',
2279 'ND', 'Ross', '', 'Mountrail', CURRVAL('actor.usr_id_seq'));
2281 INSERT INTO actor.card (barcode, usr)
2282 VALUES ('99999361901', CURRVAL('actor.usr_id_seq'));
2284 UPDATE actor.usr SET
2285 card = CURRVAL('actor.card_id_seq'),
2286 billing_address = CURRVAL('actor.usr_address_id_seq'),
2287 credit_forward_balance = '0',
2288 mailing_address = CURRVAL('actor.usr_address_id_seq')
2289 WHERE id=CURRVAL('actor.usr_id_seq');
2291 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2292 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2294 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2295 FROM actor.org_unit aou
2296 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2298 INSERT INTO actor.usr
2299 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2300 VALUES (8, 1, 'mclark', 4, 'Clark', 'montyc1234',
2301 'Monty', 'Daniel', '2006-09-13', '1984-05-19', 'II');
2303 INSERT INTO actor.usr_address
2304 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2305 VALUES ('USA', 't', '55168', '3541 Radical Sir Avenue', 'f',
2306 'MN', 'Saint paul', '', 'Ramsey', CURRVAL('actor.usr_id_seq'));
2308 INSERT INTO actor.card (barcode, usr)
2309 VALUES ('99999381970', CURRVAL('actor.usr_id_seq'));
2311 UPDATE actor.usr SET
2312 card = CURRVAL('actor.card_id_seq'),
2313 billing_address = CURRVAL('actor.usr_address_id_seq'),
2314 credit_forward_balance = '0',
2315 mailing_address = CURRVAL('actor.usr_address_id_seq')
2316 WHERE id=CURRVAL('actor.usr_id_seq');
2318 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2319 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2321 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2322 FROM actor.org_unit aou
2323 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2325 INSERT INTO actor.usr
2326 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2327 VALUES (7, 3, 'hstone', 9, 'Stone', 'hazels1234',
2328 'Hazel', 'Sylvia', '2009-07-08', '1980-12-09', '');
2330 INSERT INTO actor.usr_address
2331 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2332 VALUES ('USA', 't', '93247', '4171 Impossible Defence Overpass', 'f',
2333 'CA', 'Lindsay', '', '', CURRVAL('actor.usr_id_seq'));
2335 INSERT INTO actor.card (barcode, usr)
2336 VALUES ('99999367834', CURRVAL('actor.usr_id_seq'));
2338 UPDATE actor.usr SET
2339 card = CURRVAL('actor.card_id_seq'),
2340 billing_address = CURRVAL('actor.usr_address_id_seq'),
2341 credit_forward_balance = '0',
2342 mailing_address = CURRVAL('actor.usr_address_id_seq')
2343 WHERE id=CURRVAL('actor.usr_id_seq');
2345 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2346 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2348 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2349 FROM actor.org_unit aou
2350 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2352 INSERT INTO actor.usr
2353 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2354 VALUES (7, 1, 'dgarza', 9, 'Garza', 'davidg1234',
2355 'David', 'Steven', '2014-04-28', '1969-03-28', '');
2357 INSERT INTO actor.usr_address
2358 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2359 VALUES ('USA', 't', '22513', '3627 Retail Kind Lodge', 'f',
2360 'VA', 'Merry point', '', 'Lancaster', CURRVAL('actor.usr_id_seq'));
2362 INSERT INTO actor.card (barcode, usr)
2363 VALUES ('99999377760', CURRVAL('actor.usr_id_seq'));
2365 UPDATE actor.usr SET
2366 card = CURRVAL('actor.card_id_seq'),
2367 billing_address = CURRVAL('actor.usr_address_id_seq'),
2368 credit_forward_balance = '0',
2369 mailing_address = CURRVAL('actor.usr_address_id_seq')
2370 WHERE id=CURRVAL('actor.usr_id_seq');
2372 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2373 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2375 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2376 FROM actor.org_unit aou
2377 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2379 INSERT INTO actor.usr
2380 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2381 VALUES (7, 3, 'jevans', 8, 'Evans', 'johne1234',
2382 'John', 'Timothy', '2006-01-16', '1973-09-26', '');
2384 INSERT INTO actor.usr_address
2385 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2386 VALUES ('USA', 't', '64778', '1212 Mid Top Parkway', 'f',
2387 'MO', 'Richards', '', 'Vernon', CURRVAL('actor.usr_id_seq'));
2389 INSERT INTO actor.card (barcode, usr)
2390 VALUES ('99999367573', CURRVAL('actor.usr_id_seq'));
2392 UPDATE actor.usr SET
2393 card = CURRVAL('actor.card_id_seq'),
2394 billing_address = CURRVAL('actor.usr_address_id_seq'),
2395 credit_forward_balance = '0',
2396 mailing_address = CURRVAL('actor.usr_address_id_seq')
2397 WHERE id=CURRVAL('actor.usr_id_seq');
2399 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2400 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2402 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2403 FROM actor.org_unit aou
2404 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2406 INSERT INTO actor.usr
2407 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2408 VALUES (7, 3, 'rpayton', 8, 'Payton', 'robertp1234',
2409 'Robert', 'Steven', '2006-05-21', '1994-05-07', 'Jr');
2411 INSERT INTO actor.usr_address
2412 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2413 VALUES ('USA', 't', '55336', '1642 Minor Potential Corners', 'f',
2414 'MN', 'Glencoe', '', '', CURRVAL('actor.usr_id_seq'));
2416 INSERT INTO actor.card (barcode, usr)
2417 VALUES ('99999394830', CURRVAL('actor.usr_id_seq'));
2419 UPDATE actor.usr SET
2420 card = CURRVAL('actor.card_id_seq'),
2421 billing_address = CURRVAL('actor.usr_address_id_seq'),
2422 credit_forward_balance = '0',
2423 mailing_address = CURRVAL('actor.usr_address_id_seq')
2424 WHERE id=CURRVAL('actor.usr_id_seq');
2426 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2427 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2429 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2430 FROM actor.org_unit aou
2431 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2433 INSERT INTO actor.usr
2434 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2435 VALUES (7, 3, 'ddavis', 7, 'Davis', 'donaldd1234',
2436 'Donald', 'Gene', '2009-09-15', '1999-11-24', '');
2438 INSERT INTO actor.usr_address
2439 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2440 VALUES ('USA', 'f', '48749', '5946 Gas Way', 't',
2441 'MI', 'Omer', '', 'Arenac', CURRVAL('actor.usr_id_seq'));
2443 INSERT INTO actor.card (barcode, usr)
2444 VALUES ('99999340278', CURRVAL('actor.usr_id_seq'));
2446 UPDATE actor.usr SET
2447 card = CURRVAL('actor.card_id_seq'),
2448 billing_address = CURRVAL('actor.usr_address_id_seq'),
2449 credit_forward_balance = '0',
2450 mailing_address = CURRVAL('actor.usr_address_id_seq')
2451 WHERE id=CURRVAL('actor.usr_id_seq');
2453 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2454 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2456 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2457 FROM actor.org_unit aou
2458 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2460 INSERT INTO actor.usr
2461 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2462 VALUES (7, 1, 'gadams', 7, 'Adams', 'genea1234',
2463 'Gene', '', '2007-03-24', '1974-02-18', 'III');
2465 INSERT INTO actor.usr_address
2466 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2467 VALUES ('USA', 't', '88525', '8265 Phone Trail', 't',
2468 'TX', 'El paso', '', 'El paso', CURRVAL('actor.usr_id_seq'));
2470 INSERT INTO actor.card (barcode, usr)
2471 VALUES ('99999349290', CURRVAL('actor.usr_id_seq'));
2473 UPDATE actor.usr SET
2474 card = CURRVAL('actor.card_id_seq'),
2475 billing_address = CURRVAL('actor.usr_address_id_seq'),
2476 credit_forward_balance = '0',
2477 mailing_address = CURRVAL('actor.usr_address_id_seq')
2478 WHERE id=CURRVAL('actor.usr_id_seq');
2480 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2481 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2483 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2484 FROM actor.org_unit aou
2485 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2487 INSERT INTO actor.usr
2488 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2489 VALUES (7, 1, 'hwhite', 6, 'White', 'humbertow1234',
2490 'Humberto', 'Kevin', '2011-07-06', '1997-09-08', 'Jr');
2492 INSERT INTO actor.usr_address
2493 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2494 VALUES ('USA', 'f', '25926', '6558 Willing Master Valley', 'f',
2495 'WV', 'Sprague', '', '', CURRVAL('actor.usr_id_seq'));
2497 INSERT INTO actor.card (barcode, usr)
2498 VALUES ('99999309750', CURRVAL('actor.usr_id_seq'));
2500 UPDATE actor.usr SET
2501 card = CURRVAL('actor.card_id_seq'),
2502 billing_address = CURRVAL('actor.usr_address_id_seq'),
2503 credit_forward_balance = '0',
2504 mailing_address = CURRVAL('actor.usr_address_id_seq')
2505 WHERE id=CURRVAL('actor.usr_id_seq');
2507 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2508 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2510 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2511 FROM actor.org_unit aou
2512 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2514 INSERT INTO actor.usr
2515 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2516 VALUES (7, 3, 'asnyder', 6, 'Snyder', 'anas1234',
2517 'Ana', '', '2007-12-19', '1991-05-23', 'III');
2519 INSERT INTO actor.usr_address
2520 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2521 VALUES ('USA', 't', '00922', '8532 Spare Offer Cliffs', 'f',
2522 'PR', 'San juan', '', 'San juan', CURRVAL('actor.usr_id_seq'));
2524 INSERT INTO actor.card (barcode, usr)
2525 VALUES ('99999332335', CURRVAL('actor.usr_id_seq'));
2527 UPDATE actor.usr SET
2528 card = CURRVAL('actor.card_id_seq'),
2529 billing_address = CURRVAL('actor.usr_address_id_seq'),
2530 credit_forward_balance = '0',
2531 mailing_address = CURRVAL('actor.usr_address_id_seq')
2532 WHERE id=CURRVAL('actor.usr_id_seq');
2534 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2535 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2537 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2538 FROM actor.org_unit aou
2539 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2541 INSERT INTO actor.usr
2542 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2543 VALUES (7, 1, 'jroberts', 5, 'Roberts', 'johnr1234',
2544 'John', 'Theodore', '2015-08-16', '1960-09-10', '');
2546 INSERT INTO actor.usr_address
2547 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2548 VALUES ('USA', 'f', '79550', '279 Passing Conference Street', 't',
2549 'TX', 'Snyder', '', 'Scurry', CURRVAL('actor.usr_id_seq'));
2551 INSERT INTO actor.card (barcode, usr)
2552 VALUES ('99999367122', CURRVAL('actor.usr_id_seq'));
2554 UPDATE actor.usr SET
2555 card = CURRVAL('actor.card_id_seq'),
2556 billing_address = CURRVAL('actor.usr_address_id_seq'),
2557 credit_forward_balance = '0',
2558 mailing_address = CURRVAL('actor.usr_address_id_seq')
2559 WHERE id=CURRVAL('actor.usr_id_seq');
2561 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2562 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2564 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2565 FROM actor.org_unit aou
2566 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2568 INSERT INTO actor.usr
2569 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2570 VALUES (7, 3, 'sheath', 5, 'Heath', 'stevenh1234',
2571 'Steven', 'Luke', '2013-01-18', '1988-11-15', '');
2573 INSERT INTO actor.usr_address
2574 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2575 VALUES ('USA', 'f', '94547', '4666 Pain Isle', 'f',
2576 'CA', 'Hercules', '', 'Contra costa', CURRVAL('actor.usr_id_seq'));
2578 INSERT INTO actor.card (barcode, usr)
2579 VALUES ('99999375796', CURRVAL('actor.usr_id_seq'));
2581 UPDATE actor.usr SET
2582 card = CURRVAL('actor.card_id_seq'),
2583 billing_address = CURRVAL('actor.usr_address_id_seq'),
2584 credit_forward_balance = '0',
2585 mailing_address = CURRVAL('actor.usr_address_id_seq')
2586 WHERE id=CURRVAL('actor.usr_id_seq');
2588 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2589 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2591 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2592 FROM actor.org_unit aou
2593 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2595 INSERT INTO actor.usr
2596 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2597 VALUES (7, 1, 'krush', 4, 'Rush', 'keithr1234',
2598 'Keith', '', '2009-08-26', '1978-01-18', '');
2600 INSERT INTO actor.usr_address
2601 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2602 VALUES ('USA', 't', '15257', '4464 Sense Station', 'f',
2603 'PA', 'Pittsburgh', '', '', CURRVAL('actor.usr_id_seq'));
2605 INSERT INTO actor.card (barcode, usr)
2606 VALUES ('99999345655', CURRVAL('actor.usr_id_seq'));
2608 UPDATE actor.usr SET
2609 card = CURRVAL('actor.card_id_seq'),
2610 billing_address = CURRVAL('actor.usr_address_id_seq'),
2611 credit_forward_balance = '0',
2612 mailing_address = CURRVAL('actor.usr_address_id_seq')
2613 WHERE id=CURRVAL('actor.usr_id_seq');
2615 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2616 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2618 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2619 FROM actor.org_unit aou
2620 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2622 INSERT INTO actor.usr
2623 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2624 VALUES (7, 3, 'lfarrell', 4, 'Farrell', 'lindaf1234',
2625 'Linda', 'Linda', '2013-12-28', '1996-12-05', '');
2627 INSERT INTO actor.usr_address
2628 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2629 VALUES ('USA', 't', '75155', '7746 Cooperative Fall Shoal', 'f',
2630 'TX', 'Rice', '', 'Navarro', CURRVAL('actor.usr_id_seq'));
2632 INSERT INTO actor.card (barcode, usr)
2633 VALUES ('99999344872', CURRVAL('actor.usr_id_seq'));
2635 UPDATE actor.usr SET
2636 card = CURRVAL('actor.card_id_seq'),
2637 billing_address = CURRVAL('actor.usr_address_id_seq'),
2638 credit_forward_balance = '0',
2639 mailing_address = CURRVAL('actor.usr_address_id_seq')
2640 WHERE id=CURRVAL('actor.usr_id_seq');
2642 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2643 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2645 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2646 FROM actor.org_unit aou
2647 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2649 INSERT INTO actor.usr
2650 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2651 VALUES (6, 3, 'rharrison', 9, 'Harrison', 'richardh1234',
2652 'Richard', 'Melvin', '2007-04-07', '1974-01-17', '');
2654 INSERT INTO actor.usr_address
2655 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2656 VALUES ('USA', 't', '06601', '2896 Jewish Lack Lodge', 'f',
2657 'CT', 'Bridgeport', '', '', CURRVAL('actor.usr_id_seq'));
2659 INSERT INTO actor.card (barcode, usr)
2660 VALUES ('99999399702', CURRVAL('actor.usr_id_seq'));
2662 UPDATE actor.usr SET
2663 card = CURRVAL('actor.card_id_seq'),
2664 billing_address = CURRVAL('actor.usr_address_id_seq'),
2665 credit_forward_balance = '0',
2666 mailing_address = CURRVAL('actor.usr_address_id_seq')
2667 WHERE id=CURRVAL('actor.usr_id_seq');
2669 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2670 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2672 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2673 FROM actor.org_unit aou
2674 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2676 INSERT INTO actor.usr
2677 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2678 VALUES (6, 1, 'ksmith', 9, 'Smith', 'kevins1234',
2679 'Kevin', 'Timothy', '2012-01-16', '1965-12-28', '');
2681 INSERT INTO actor.usr_address
2682 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2683 VALUES ('USA', 'f', '81523', '5119 Lot Isle', 't',
2684 'CO', 'Glade park', '', 'Mesa', CURRVAL('actor.usr_id_seq'));
2686 INSERT INTO actor.card (barcode, usr)
2687 VALUES ('99999394646', CURRVAL('actor.usr_id_seq'));
2689 UPDATE actor.usr SET
2690 card = CURRVAL('actor.card_id_seq'),
2691 billing_address = CURRVAL('actor.usr_address_id_seq'),
2692 credit_forward_balance = '0',
2693 mailing_address = CURRVAL('actor.usr_address_id_seq')
2694 WHERE id=CURRVAL('actor.usr_id_seq');
2696 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2697 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2699 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2700 FROM actor.org_unit aou
2701 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2703 INSERT INTO actor.usr
2704 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2705 VALUES (6, 1, 'fmoore', 8, 'Moore', 'florencem1234',
2706 'Florence', 'Michelle', '2010-07-20', '1977-02-07', 'Jr');
2708 INSERT INTO actor.usr_address
2709 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2710 VALUES ('USA', 't', '39440', '6398 Mathematical Condition Arcade', 't',
2711 'MS', 'Laurel', '', '', CURRVAL('actor.usr_id_seq'));
2713 INSERT INTO actor.card (barcode, usr)
2714 VALUES ('99999341034', CURRVAL('actor.usr_id_seq'));
2716 UPDATE actor.usr SET
2717 card = CURRVAL('actor.card_id_seq'),
2718 billing_address = CURRVAL('actor.usr_address_id_seq'),
2719 credit_forward_balance = '0',
2720 mailing_address = CURRVAL('actor.usr_address_id_seq')
2721 WHERE id=CURRVAL('actor.usr_id_seq');
2723 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2724 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2726 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2727 FROM actor.org_unit aou
2728 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2730 INSERT INTO actor.usr
2731 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2732 VALUES (6, 1, 'bcruz', 8, 'Cruz', 'bettyc1234',
2733 'Betty', 'Shirley', '2015-04-26', '1993-08-10', 'Sr');
2735 INSERT INTO actor.usr_address
2736 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2737 VALUES ('USA', 'f', '33630', '1062 Scornful Air Fort', 'f',
2738 'FL', 'Tampa', '', 'Hillsborough', CURRVAL('actor.usr_id_seq'));
2740 INSERT INTO actor.card (barcode, usr)
2741 VALUES ('99999363183', CURRVAL('actor.usr_id_seq'));
2743 UPDATE actor.usr SET
2744 card = CURRVAL('actor.card_id_seq'),
2745 billing_address = CURRVAL('actor.usr_address_id_seq'),
2746 credit_forward_balance = '0',
2747 mailing_address = CURRVAL('actor.usr_address_id_seq')
2748 WHERE id=CURRVAL('actor.usr_id_seq');
2750 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2751 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2753 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2754 FROM actor.org_unit aou
2755 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2757 INSERT INTO actor.usr
2758 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2759 VALUES (6, 1, 'jjohnson', 7, 'Johnson', 'joelj1234',
2760 'Joel', 'Allen', '2009-09-06', '1991-07-02', '');
2762 INSERT INTO actor.usr_address
2763 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2764 VALUES ('USA', 'f', '36028', '3220 Drunk Message Parkway', 'f',
2765 'AL', 'Dozier', '', '', CURRVAL('actor.usr_id_seq'));
2767 INSERT INTO actor.card (barcode, usr)
2768 VALUES ('99999370090', CURRVAL('actor.usr_id_seq'));
2770 UPDATE actor.usr SET
2771 card = CURRVAL('actor.card_id_seq'),
2772 billing_address = CURRVAL('actor.usr_address_id_seq'),
2773 credit_forward_balance = '0',
2774 mailing_address = CURRVAL('actor.usr_address_id_seq')
2775 WHERE id=CURRVAL('actor.usr_id_seq');
2777 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2778 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2780 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2781 FROM actor.org_unit aou
2782 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2784 INSERT INTO actor.usr
2785 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2786 VALUES (6, 1, 'kburton', 7, 'Burton', 'kristenb1234',
2787 'Kristen', 'Dena', '2011-08-07', '1986-08-22', '');
2789 INSERT INTO actor.usr_address
2790 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2791 VALUES ('USA', 'f', '42413', '4924 Part-time Charge Knoll', 'f',
2792 'KY', 'Hanson', '', 'Hopkins', CURRVAL('actor.usr_id_seq'));
2794 INSERT INTO actor.card (barcode, usr)
2795 VALUES ('99999372936', CURRVAL('actor.usr_id_seq'));
2797 UPDATE actor.usr SET
2798 card = CURRVAL('actor.card_id_seq'),
2799 billing_address = CURRVAL('actor.usr_address_id_seq'),
2800 credit_forward_balance = '0',
2801 mailing_address = CURRVAL('actor.usr_address_id_seq')
2802 WHERE id=CURRVAL('actor.usr_id_seq');
2804 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2805 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2807 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2808 FROM actor.org_unit aou
2809 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2811 INSERT INTO actor.usr
2812 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2813 VALUES (6, 1, 'rpineda', 6, 'Pineda', 'robertp1234',
2814 'Robert', 'Gordon', '2011-06-14', '1985-09-10', '');
2816 INSERT INTO actor.usr_address
2817 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2818 VALUES ('USA', 'f', '47703', '1587 Labour Holiday Park', 't',
2819 'IN', 'Evansville', '', 'Vanderburgh', CURRVAL('actor.usr_id_seq'));
2821 INSERT INTO actor.card (barcode, usr)
2822 VALUES ('99999349988', CURRVAL('actor.usr_id_seq'));
2824 UPDATE actor.usr SET
2825 card = CURRVAL('actor.card_id_seq'),
2826 billing_address = CURRVAL('actor.usr_address_id_seq'),
2827 credit_forward_balance = '0',
2828 mailing_address = CURRVAL('actor.usr_address_id_seq')
2829 WHERE id=CURRVAL('actor.usr_id_seq');
2831 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2832 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2834 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2835 FROM actor.org_unit aou
2836 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2838 INSERT INTO actor.usr
2839 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2840 VALUES (6, 1, 'avaldez', 6, 'Valdez', 'alissav1234',
2841 'Alissa', 'Gladys', '2013-05-24', '1994-03-25', 'Jr');
2843 INSERT INTO actor.usr_address
2844 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2845 VALUES ('USA', 'f', '64735', '4372 Fact Junction', 'f',
2846 'MO', 'Clinton', '', 'Henry', CURRVAL('actor.usr_id_seq'));
2848 INSERT INTO actor.card (barcode, usr)
2849 VALUES ('99999332255', CURRVAL('actor.usr_id_seq'));
2851 UPDATE actor.usr SET
2852 card = CURRVAL('actor.card_id_seq'),
2853 billing_address = CURRVAL('actor.usr_address_id_seq'),
2854 credit_forward_balance = '0',
2855 mailing_address = CURRVAL('actor.usr_address_id_seq')
2856 WHERE id=CURRVAL('actor.usr_id_seq');
2858 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2859 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2861 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2862 FROM actor.org_unit aou
2863 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2865 INSERT INTO actor.usr
2866 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2867 VALUES (6, 3, 'krowland', 5, 'Rowland', 'kennethr1234',
2868 'Kenneth', 'Ernest', '2006-05-03', '1978-10-08', '');
2870 INSERT INTO actor.usr_address
2871 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2872 VALUES ('USA', 'f', '98131', '8373 Resonant Investment Mission', 'f',
2873 'WA', 'Seattle', '', 'King', CURRVAL('actor.usr_id_seq'));
2875 INSERT INTO actor.card (barcode, usr)
2876 VALUES ('99999354715', CURRVAL('actor.usr_id_seq'));
2878 UPDATE actor.usr SET
2879 card = CURRVAL('actor.card_id_seq'),
2880 billing_address = CURRVAL('actor.usr_address_id_seq'),
2881 credit_forward_balance = '0',
2882 mailing_address = CURRVAL('actor.usr_address_id_seq')
2883 WHERE id=CURRVAL('actor.usr_id_seq');
2885 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2886 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2888 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2889 FROM actor.org_unit aou
2890 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2892 INSERT INTO actor.usr
2893 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2894 VALUES (6, 1, 'thansen', 5, 'Hansen', 'terranceh1234',
2895 'Terrance', '', '2008-02-17', '1969-10-10', '');
2897 INSERT INTO actor.usr_address
2898 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2899 VALUES ('USA', 't', '16550', '4446 Formidable Way Knolls', 't',
2900 'PA', 'Erie', '', 'Erie', CURRVAL('actor.usr_id_seq'));
2902 INSERT INTO actor.card (barcode, usr)
2903 VALUES ('99999363646', CURRVAL('actor.usr_id_seq'));
2905 UPDATE actor.usr SET
2906 card = CURRVAL('actor.card_id_seq'),
2907 billing_address = CURRVAL('actor.usr_address_id_seq'),
2908 credit_forward_balance = '0',
2909 mailing_address = CURRVAL('actor.usr_address_id_seq')
2910 WHERE id=CURRVAL('actor.usr_id_seq');
2912 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2913 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2915 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2916 FROM actor.org_unit aou
2917 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2919 INSERT INTO actor.usr
2920 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2921 VALUES (6, 3, 'breid', 4, 'Reid', 'barbarar1234',
2922 'Barbara', 'Amanda', '2014-06-15', '1992-07-12', '');
2924 INSERT INTO actor.usr_address
2925 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2926 VALUES ('USA', 'f', '04056', '3517 Hot School Brook', 'f',
2927 'ME', 'Newfield', '', 'York', CURRVAL('actor.usr_id_seq'));
2929 INSERT INTO actor.card (barcode, usr)
2930 VALUES ('99999365307', CURRVAL('actor.usr_id_seq'));
2932 UPDATE actor.usr SET
2933 card = CURRVAL('actor.card_id_seq'),
2934 billing_address = CURRVAL('actor.usr_address_id_seq'),
2935 credit_forward_balance = '0',
2936 mailing_address = CURRVAL('actor.usr_address_id_seq')
2937 WHERE id=CURRVAL('actor.usr_id_seq');
2939 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2940 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2942 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2943 FROM actor.org_unit aou
2944 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2946 INSERT INTO actor.usr
2947 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2948 VALUES (6, 1, 'mroberts', 4, 'Roberts', 'michaelr1234',
2949 'Michael', 'Stephen', '2007-08-12', '1994-10-06', '');
2951 INSERT INTO actor.usr_address
2952 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2953 VALUES ('USA', 't', '63541', '4668 Start Inlet', 'f',
2954 'MO', 'Glenwood', '', 'Schuyler', CURRVAL('actor.usr_id_seq'));
2956 INSERT INTO actor.card (barcode, usr)
2957 VALUES ('99999332788', CURRVAL('actor.usr_id_seq'));
2959 UPDATE actor.usr SET
2960 card = CURRVAL('actor.card_id_seq'),
2961 billing_address = CURRVAL('actor.usr_address_id_seq'),
2962 credit_forward_balance = '0',
2963 mailing_address = CURRVAL('actor.usr_address_id_seq')
2964 WHERE id=CURRVAL('actor.usr_id_seq');
2966 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2967 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2969 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2970 FROM actor.org_unit aou
2971 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2973 INSERT INTO actor.usr
2974 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2975 VALUES (5, 3, 'rkaufman', 9, 'Kaufman', 'rachelk1234',
2976 'Rachel', 'Vickie', '2008-04-24', '1962-01-23', '');
2978 INSERT INTO actor.usr_address
2979 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2980 VALUES ('USA', 't', '68659', '7270 Development Row', 'f',
2981 'NE', 'Rogers', '', '', CURRVAL('actor.usr_id_seq'));
2983 INSERT INTO actor.card (barcode, usr)
2984 VALUES ('99999340790', CURRVAL('actor.usr_id_seq'));
2986 UPDATE actor.usr SET
2987 card = CURRVAL('actor.card_id_seq'),
2988 billing_address = CURRVAL('actor.usr_address_id_seq'),
2989 credit_forward_balance = '0',
2990 mailing_address = CURRVAL('actor.usr_address_id_seq')
2991 WHERE id=CURRVAL('actor.usr_id_seq');
2993 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2994 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2996 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2997 FROM actor.org_unit aou
2998 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3000 INSERT INTO actor.usr
3001 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3002 VALUES (5, 3, 'csims', 9, 'Sims', 'christophers1234',
3003 'Christopher', 'John', '2015-10-05', '1991-01-07', '');
3005 INSERT INTO actor.usr_address
3006 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3007 VALUES ('USA', 't', '89013', '5637 Plastic Mill', 't',
3008 'NV', 'Goldfield', '', 'Esmeralda', CURRVAL('actor.usr_id_seq'));
3010 INSERT INTO actor.card (barcode, usr)
3011 VALUES ('99999386091', CURRVAL('actor.usr_id_seq'));
3013 UPDATE actor.usr SET
3014 card = CURRVAL('actor.card_id_seq'),
3015 billing_address = CURRVAL('actor.usr_address_id_seq'),
3016 credit_forward_balance = '0',
3017 mailing_address = CURRVAL('actor.usr_address_id_seq')
3018 WHERE id=CURRVAL('actor.usr_id_seq');
3020 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3021 VALUES (CURRVAL('actor.usr_id_seq'), 9);
3023 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3024 FROM actor.org_unit aou
3025 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3027 INSERT INTO actor.usr
3028 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3029 VALUES (5, 1, 'srobinson', 8, 'Robinson', 'sarahr1234',
3030 'Sarah', '', '2006-03-04', '1996-01-28', 'II');
3032 INSERT INTO actor.usr_address
3033 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3034 VALUES ('USA', 'f', '65897', '8092 Pure Name Bridge', 'f',
3035 'MO', 'Springfield', '', 'Greene', CURRVAL('actor.usr_id_seq'));
3037 INSERT INTO actor.card (barcode, usr)
3038 VALUES ('99999340199', CURRVAL('actor.usr_id_seq'));
3040 UPDATE actor.usr SET
3041 card = CURRVAL('actor.card_id_seq'),
3042 billing_address = CURRVAL('actor.usr_address_id_seq'),
3043 credit_forward_balance = '0',
3044 mailing_address = CURRVAL('actor.usr_address_id_seq')
3045 WHERE id=CURRVAL('actor.usr_id_seq');
3047 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3048 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3050 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3051 FROM actor.org_unit aou
3052 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3054 INSERT INTO actor.usr
3055 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3056 VALUES (5, 3, 'jpayton', 8, 'Payton', 'johnnyp1234',
3057 'Johnny', 'Vincent', '2008-10-19', '1965-09-23', '');
3059 INSERT INTO actor.usr_address
3060 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3061 VALUES ('USA', 't', '85738', '8772 Forthcoming Hope Fort', 'f',
3062 'AZ', 'Catalina', '', '', CURRVAL('actor.usr_id_seq'));
3064 INSERT INTO actor.card (barcode, usr)
3065 VALUES ('99999387186', CURRVAL('actor.usr_id_seq'));
3067 UPDATE actor.usr SET
3068 card = CURRVAL('actor.card_id_seq'),
3069 billing_address = CURRVAL('actor.usr_address_id_seq'),
3070 credit_forward_balance = '0',
3071 mailing_address = CURRVAL('actor.usr_address_id_seq')
3072 WHERE id=CURRVAL('actor.usr_id_seq');
3074 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3075 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3077 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3078 FROM actor.org_unit aou
3079 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3081 INSERT INTO actor.usr
3082 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3083 VALUES (5, 3, 'djamison', 7, 'Jamison', 'davidj1234',
3084 'David', 'Eric', '2009-07-04', '1993-08-11', '');
3086 INSERT INTO actor.usr_address
3087 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3088 VALUES ('USA', 'f', '59604', '9218 Moral Worker Summit', 'f',
3089 'MT', 'Helena', '', '', CURRVAL('actor.usr_id_seq'));
3091 INSERT INTO actor.card (barcode, usr)
3092 VALUES ('99999340530', CURRVAL('actor.usr_id_seq'));
3094 UPDATE actor.usr SET
3095 card = CURRVAL('actor.card_id_seq'),
3096 billing_address = CURRVAL('actor.usr_address_id_seq'),
3097 credit_forward_balance = '0',
3098 mailing_address = CURRVAL('actor.usr_address_id_seq')
3099 WHERE id=CURRVAL('actor.usr_id_seq');
3101 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3102 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3104 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3105 FROM actor.org_unit aou
3106 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3108 INSERT INTO actor.usr
3109 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3110 VALUES (5, 3, 'jford', 7, 'Ford', 'jamief1234',
3111 'Jamie', '', '2014-06-22', '1974-08-23', '');
3113 INSERT INTO actor.usr_address
3114 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3115 VALUES ('USA', 'f', '41746', '8268 Hill Valleys', 't',
3116 'KY', 'Happy', '', 'Perry', CURRVAL('actor.usr_id_seq'));
3118 INSERT INTO actor.card (barcode, usr)
3119 VALUES ('99999384455', CURRVAL('actor.usr_id_seq'));
3121 UPDATE actor.usr SET
3122 card = CURRVAL('actor.card_id_seq'),
3123 billing_address = CURRVAL('actor.usr_address_id_seq'),
3124 credit_forward_balance = '0',
3125 mailing_address = CURRVAL('actor.usr_address_id_seq')
3126 WHERE id=CURRVAL('actor.usr_id_seq');
3128 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3129 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3131 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3132 FROM actor.org_unit aou
3133 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3135 INSERT INTO actor.usr
3136 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3137 VALUES (5, 1, 'gwatson', 6, 'Watson', 'geraldw1234',
3138 'Gerald', 'Larry', '2006-10-09', '1967-11-15', '');
3140 INSERT INTO actor.usr_address
3141 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3142 VALUES ('USA', 'f', '85063', '881 Scary Holiday Radial', 'f',
3143 'AZ', 'Phoenix', '', 'Maricopa', CURRVAL('actor.usr_id_seq'));
3145 INSERT INTO actor.card (barcode, usr)
3146 VALUES ('99999385100', CURRVAL('actor.usr_id_seq'));
3148 UPDATE actor.usr SET
3149 card = CURRVAL('actor.card_id_seq'),
3150 billing_address = CURRVAL('actor.usr_address_id_seq'),
3151 credit_forward_balance = '0',
3152 mailing_address = CURRVAL('actor.usr_address_id_seq')
3153 WHERE id=CURRVAL('actor.usr_id_seq');
3155 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3156 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3158 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3159 FROM actor.org_unit aou
3160 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3162 INSERT INTO actor.usr
3163 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3164 VALUES (5, 1, 'clambert', 6, 'Lambert', 'charlesl1234',
3165 'Charles', 'William', '2013-06-14', '1995-09-22', 'Jr');
3167 INSERT INTO actor.usr_address
3168 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3169 VALUES ('USA', 't', '40291', '6026 Wide Development Port', 'f',
3170 'KY', 'Louisville', '', 'Jefferson', CURRVAL('actor.usr_id_seq'));
3172 INSERT INTO actor.card (barcode, usr)
3173 VALUES ('99999335749', CURRVAL('actor.usr_id_seq'));
3175 UPDATE actor.usr SET
3176 card = CURRVAL('actor.card_id_seq'),
3177 billing_address = CURRVAL('actor.usr_address_id_seq'),
3178 credit_forward_balance = '0',
3179 mailing_address = CURRVAL('actor.usr_address_id_seq')
3180 WHERE id=CURRVAL('actor.usr_id_seq');
3182 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3183 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3185 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3186 FROM actor.org_unit aou
3187 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3189 INSERT INTO actor.usr
3190 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3191 VALUES (5, 1, 'mbarber', 5, 'Barber', 'michealb1234',
3192 'Micheal', 'Ramon', '2010-10-04', '1988-11-26', '');
3194 INSERT INTO actor.usr_address
3195 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3196 VALUES ('USA', 'f', '91357', '9727 Proposed Executive Plaza', 't',
3197 'CA', 'Tarzana', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
3199 INSERT INTO actor.card (barcode, usr)
3200 VALUES ('99999361522', CURRVAL('actor.usr_id_seq'));
3202 UPDATE actor.usr SET
3203 card = CURRVAL('actor.card_id_seq'),
3204 billing_address = CURRVAL('actor.usr_address_id_seq'),
3205 credit_forward_balance = '0',
3206 mailing_address = CURRVAL('actor.usr_address_id_seq')
3207 WHERE id=CURRVAL('actor.usr_id_seq');
3209 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3210 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3212 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3213 FROM actor.org_unit aou
3214 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3216 INSERT INTO actor.usr
3217 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3218 VALUES (5, 3, 'tcruz', 5, 'Cruz', 'tomc1234',
3219 'Tom', 'Eugene', '2013-09-11', '1970-09-08', '');
3221 INSERT INTO actor.usr_address
3222 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3223 VALUES ('USA', 'f', '40546', '7481 Reform Road', 't',
3224 'KY', 'Lexington', '', 'Fayette', CURRVAL('actor.usr_id_seq'));
3226 INSERT INTO actor.card (barcode, usr)
3227 VALUES ('99999394278', CURRVAL('actor.usr_id_seq'));
3229 UPDATE actor.usr SET
3230 card = CURRVAL('actor.card_id_seq'),
3231 billing_address = CURRVAL('actor.usr_address_id_seq'),
3232 credit_forward_balance = '0',
3233 mailing_address = CURRVAL('actor.usr_address_id_seq')
3234 WHERE id=CURRVAL('actor.usr_id_seq');
3236 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3237 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3239 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3240 FROM actor.org_unit aou
3241 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3243 INSERT INTO actor.usr
3244 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3245 VALUES (5, 1, 'iwalton', 4, 'Walton', 'inezw1234',
3246 'Inez', 'Amanda', '2011-05-19', '1986-10-16', '');
3248 INSERT INTO actor.usr_address
3249 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3250 VALUES ('USA', 'f', '29053', '8589 Official Valleys', 'f',
3251 'SC', 'Gaston', '', '', CURRVAL('actor.usr_id_seq'));
3253 INSERT INTO actor.card (barcode, usr)
3254 VALUES ('99999356283', CURRVAL('actor.usr_id_seq'));
3256 UPDATE actor.usr SET
3257 card = CURRVAL('actor.card_id_seq'),
3258 billing_address = CURRVAL('actor.usr_address_id_seq'),
3259 credit_forward_balance = '0',
3260 mailing_address = CURRVAL('actor.usr_address_id_seq')
3261 WHERE id=CURRVAL('actor.usr_id_seq');
3263 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3264 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3266 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3267 FROM actor.org_unit aou
3268 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
3270 INSERT INTO actor.usr
3271 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3272 VALUES (5, 3, 'mtownsend', 4, 'Townsend', 'maryt1234',
3273 'Mary', '', '2015-04-06', '1995-03-03', 'Jr');
3275 INSERT INTO actor.usr_address
3276 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3277 VALUES ('USA', 't', '72464', '3321 Answer Stravenue', 't',
3278 'AR', 'Saint francis', '', '', CURRVAL('actor.usr_id_seq'));
3280 INSERT INTO actor.card (barcode, usr)
3281 VALUES ('99999336350', CURRVAL('actor.usr_id_seq'));
3283 UPDATE actor.usr SET
3284 card = CURRVAL('actor.card_id_seq'),
3285 billing_address = CURRVAL('actor.usr_address_id_seq'),
3286 credit_forward_balance = '0',
3287 mailing_address = CURRVAL('actor.usr_address_id_seq')
3288 WHERE id=CURRVAL('actor.usr_id_seq');
3290 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3291 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3293 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3294 FROM actor.org_unit aou
3295 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
3297 INSERT INTO actor.usr
3298 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3299 VALUES (4, 3, 'cmartinez', 9, 'Martinez', 'carolynm1234',
3300 'Carolyn', 'Sandra', '2007-04-03', '1988-07-18', '');
3302 INSERT INTO actor.usr_address
3303 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3304 VALUES ('USA', 't', '49654', '7081 Appalling Plant Causeway', 't',
3305 'MI', 'Leland', '', '', CURRVAL('actor.usr_id_seq'));
3307 INSERT INTO actor.card (barcode, usr)
3308 VALUES ('99999397121', CURRVAL('actor.usr_id_seq'));
3310 UPDATE actor.usr SET
3311 card = CURRVAL('actor.card_id_seq'),
3312 billing_address = CURRVAL('actor.usr_address_id_seq'),
3313 credit_forward_balance = '0',
3314 mailing_address = CURRVAL('actor.usr_address_id_seq')
3315 WHERE id=CURRVAL('actor.usr_id_seq');
3317 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3318 VALUES (CURRVAL('actor.usr_id_seq'), 9);
3320 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3321 FROM actor.org_unit aou
3322 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3324 INSERT INTO actor.usr
3325 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3326 VALUES (4, 1, 'jjohnson', 9, 'Johnson', 'jeremyj1234',
3327 'Jeremy', 'Mark', '2014-09-01', '1970-03-14', 'II');
3329 INSERT INTO actor.usr_address
3330 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3331 VALUES ('USA', 'f', '70358', '4786 Prior Politics Mission', 'f',
3332 'LA', 'Grand isle', '', '', CURRVAL('actor.usr_id_seq'));
3334 INSERT INTO actor.card (barcode, usr)
3335 VALUES ('99999397850', CURRVAL('actor.usr_id_seq'));
3337 UPDATE actor.usr SET
3338 card = CURRVAL('actor.card_id_seq'),
3339 billing_address = CURRVAL('actor.usr_address_id_seq'),
3340 credit_forward_balance = '0',
3341 mailing_address = CURRVAL('actor.usr_address_id_seq')
3342 WHERE id=CURRVAL('actor.usr_id_seq');
3344 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3345 VALUES (CURRVAL('actor.usr_id_seq'), 9);
3347 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3348 FROM actor.org_unit aou
3349 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3351 INSERT INTO actor.usr
3352 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3353 VALUES (4, 1, 'mscott', 8, 'Scott', 'maes1234',
3354 'Mae', 'Sue', '2011-10-01', '1964-12-02', '');
3356 INSERT INTO actor.usr_address
3357 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3358 VALUES ('USA', 'f', '14723', '1060 Letter Stravenue', 'f',
3359 'NY', 'Cherry creek', '', '', CURRVAL('actor.usr_id_seq'));
3361 INSERT INTO actor.card (barcode, usr)
3362 VALUES ('99999395984', CURRVAL('actor.usr_id_seq'));
3364 UPDATE actor.usr SET
3365 card = CURRVAL('actor.card_id_seq'),
3366 billing_address = CURRVAL('actor.usr_address_id_seq'),
3367 credit_forward_balance = '0',
3368 mailing_address = CURRVAL('actor.usr_address_id_seq')
3369 WHERE id=CURRVAL('actor.usr_id_seq');
3371 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3372 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3374 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3375 FROM actor.org_unit aou
3376 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3378 INSERT INTO actor.usr
3379 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3380 VALUES (4, 3, 'rstevens', 8, 'Stevens', 'russells1234',
3381 'Russell', 'Daniel', '2011-08-15', '1973-08-15', 'Jr');
3383 INSERT INTO actor.usr_address
3384 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3385 VALUES ('USA', 't', '29582', '7735 Street Creek', 'f',
3386 'SC', 'North myrtle beach', '', 'Horry', CURRVAL('actor.usr_id_seq'));
3388 INSERT INTO actor.card (barcode, usr)
3389 VALUES ('99999340524', CURRVAL('actor.usr_id_seq'));
3391 UPDATE actor.usr SET
3392 card = CURRVAL('actor.card_id_seq'),
3393 billing_address = CURRVAL('actor.usr_address_id_seq'),
3394 credit_forward_balance = '0',
3395 mailing_address = CURRVAL('actor.usr_address_id_seq')
3396 WHERE id=CURRVAL('actor.usr_id_seq');
3398 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3399 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3401 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3402 FROM actor.org_unit aou
3403 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3405 INSERT INTO actor.usr
3406 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3407 VALUES (4, 3, 'therrera', 7, 'Herrera', 'tracih1234',
3408 'Traci', 'Edith', '2009-10-13', '1994-07-07', 'Jr');
3410 INSERT INTO actor.usr_address
3411 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3412 VALUES ('USA', 'f', '84133', '7301 Watery Arrangement Radial', 'f',
3413 'UT', 'Salt lake city', '', '', CURRVAL('actor.usr_id_seq'));
3415 INSERT INTO actor.card (barcode, usr)
3416 VALUES ('99999386259', CURRVAL('actor.usr_id_seq'));
3418 UPDATE actor.usr SET
3419 card = CURRVAL('actor.card_id_seq'),
3420 billing_address = CURRVAL('actor.usr_address_id_seq'),
3421 credit_forward_balance = '0',
3422 mailing_address = CURRVAL('actor.usr_address_id_seq')
3423 WHERE id=CURRVAL('actor.usr_id_seq');
3425 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3426 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3428 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3429 FROM actor.org_unit aou
3430 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3432 INSERT INTO actor.usr
3433 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3434 VALUES (4, 3, 'vgrimes', 7, 'Grimes', 'virginiag1234',
3435 'Virginia', 'Jennifer', '2012-07-27', '1984-03-12', '');
3437 INSERT INTO actor.usr_address
3438 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3439 VALUES ('USA', 'f', '87027', '8666 Fluttering Situation Heights', 'f',
3440 'NM', 'La jara', '', 'Sandoval', CURRVAL('actor.usr_id_seq'));
3442 INSERT INTO actor.card (barcode, usr)
3443 VALUES ('99999318163', CURRVAL('actor.usr_id_seq'));
3445 UPDATE actor.usr SET
3446 card = CURRVAL('actor.card_id_seq'),
3447 billing_address = CURRVAL('actor.usr_address_id_seq'),
3448 credit_forward_balance = '0',
3449 mailing_address = CURRVAL('actor.usr_address_id_seq')
3450 WHERE id=CURRVAL('actor.usr_id_seq');
3452 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3453 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3455 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3456 FROM actor.org_unit aou
3457 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3459 INSERT INTO actor.usr
3460 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3461 VALUES (4, 1, 'pward', 6, 'Ward', 'paulw1234',
3462 'Paul', '', '2006-09-02', '1985-05-06', '');
3464 INSERT INTO actor.usr_address
3465 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3466 VALUES ('USA', 'f', '38233', '8859 Roasted Energy Falls', 'f',
3467 'TN', 'Kenton', '', '', CURRVAL('actor.usr_id_seq'));
3469 INSERT INTO actor.card (barcode, usr)
3470 VALUES ('99999346968', CURRVAL('actor.usr_id_seq'));
3472 UPDATE actor.usr SET
3473 card = CURRVAL('actor.card_id_seq'),
3474 billing_address = CURRVAL('actor.usr_address_id_seq'),
3475 credit_forward_balance = '0',
3476 mailing_address = CURRVAL('actor.usr_address_id_seq')
3477 WHERE id=CURRVAL('actor.usr_id_seq');
3479 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3480 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3482 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3483 FROM actor.org_unit aou
3484 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3486 INSERT INTO actor.usr
3487 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3488 VALUES (4, 3, 'bgreen', 6, 'Green', 'beatriceg1234',
3489 'Beatrice', 'Janette', '2014-12-09', '1964-12-06', '');
3491 INSERT INTO actor.usr_address
3492 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3493 VALUES ('USA', 't', '65438', '9082 Plain Bed Avenue', 'f',
3494 'MO', 'Birch tree', '', 'Shannon', CURRVAL('actor.usr_id_seq'));
3496 INSERT INTO actor.card (barcode, usr)
3497 VALUES ('99999345139', CURRVAL('actor.usr_id_seq'));
3499 UPDATE actor.usr SET
3500 card = CURRVAL('actor.card_id_seq'),
3501 billing_address = CURRVAL('actor.usr_address_id_seq'),
3502 credit_forward_balance = '0',
3503 mailing_address = CURRVAL('actor.usr_address_id_seq')
3504 WHERE id=CURRVAL('actor.usr_id_seq');
3506 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3507 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3509 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3510 FROM actor.org_unit aou
3511 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3513 INSERT INTO actor.usr
3514 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3515 VALUES (4, 1, 'sschmidt', 5, 'Schmidt', 'scotts1234',
3516 'Scott', 'Kyle', '2006-04-02', '1987-07-07', 'Sr');
3518 INSERT INTO actor.usr_address
3519 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3520 VALUES ('USA', 'f', '99670', '2204 Status Avenue', 'f',
3521 'AK', 'South naknek', '', '', CURRVAL('actor.usr_id_seq'));
3523 INSERT INTO actor.card (barcode, usr)
3524 VALUES ('99999393981', CURRVAL('actor.usr_id_seq'));
3526 UPDATE actor.usr SET
3527 card = CURRVAL('actor.card_id_seq'),
3528 billing_address = CURRVAL('actor.usr_address_id_seq'),
3529 credit_forward_balance = '0',
3530 mailing_address = CURRVAL('actor.usr_address_id_seq')
3531 WHERE id=CURRVAL('actor.usr_id_seq');
3533 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3534 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3536 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3537 FROM actor.org_unit aou
3538 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3540 INSERT INTO actor.usr
3541 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3542 VALUES (4, 3, 'jclark', 5, 'Clark', 'joannec1234',
3543 'Joanne', 'Andrea', '2009-10-21', '1985-03-16', '');
3545 INSERT INTO actor.usr_address
3546 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3547 VALUES ('USA', 'f', '35175', '7622 Thoughtless Science Pines', 'f',
3548 'AL', 'Union grove', '', 'Marshall', CURRVAL('actor.usr_id_seq'));
3550 INSERT INTO actor.card (barcode, usr)
3551 VALUES ('99999366354', CURRVAL('actor.usr_id_seq'));
3553 UPDATE actor.usr SET
3554 card = CURRVAL('actor.card_id_seq'),
3555 billing_address = CURRVAL('actor.usr_address_id_seq'),
3556 credit_forward_balance = '0',
3557 mailing_address = CURRVAL('actor.usr_address_id_seq')
3558 WHERE id=CURRVAL('actor.usr_id_seq');
3560 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3561 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3563 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3564 FROM actor.org_unit aou
3565 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3567 INSERT INTO actor.usr
3568 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3569 VALUES (4, 1, 'bbrown', 4, 'Brown', 'beverlyb1234',
3570 'Beverly', 'Florence', '2011-06-27', '1961-07-24', '');
3572 INSERT INTO actor.usr_address
3573 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3574 VALUES ('USA', 't', '29058', '2991 Trip Crescent', 't',
3575 'SC', 'Heath springs', '', 'Lancaster', CURRVAL('actor.usr_id_seq'));
3577 INSERT INTO actor.card (barcode, usr)
3578 VALUES ('99999338317', CURRVAL('actor.usr_id_seq'));
3580 UPDATE actor.usr SET
3581 card = CURRVAL('actor.card_id_seq'),
3582 billing_address = CURRVAL('actor.usr_address_id_seq'),
3583 credit_forward_balance = '0',
3584 mailing_address = CURRVAL('actor.usr_address_id_seq')
3585 WHERE id=CURRVAL('actor.usr_id_seq');
3587 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3588 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3590 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3591 FROM actor.org_unit aou
3592 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
3594 INSERT INTO actor.usr
3595 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3596 VALUES (4, 3, 'jmcginnis', 4, 'Mcginnis', 'josem1234',
3597 'Jose', 'David', '2015-10-22', '1976-01-24', '');
3599 INSERT INTO actor.usr_address
3600 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3601 VALUES ('USA', 't', '65055', '8231 Relieved Debt Cape', 'f',
3602 'MO', 'Mc girk', '', 'Moniteau', CURRVAL('actor.usr_id_seq'));
3604 INSERT INTO actor.card (barcode, usr)
3605 VALUES ('99999316430', CURRVAL('actor.usr_id_seq'));
3607 UPDATE actor.usr SET
3608 card = CURRVAL('actor.card_id_seq'),
3609 billing_address = CURRVAL('actor.usr_address_id_seq'),
3610 credit_forward_balance = '0',
3611 mailing_address = CURRVAL('actor.usr_address_id_seq')
3612 WHERE id=CURRVAL('actor.usr_id_seq');
3614 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3615 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3617 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3618 FROM actor.org_unit aou
3619 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;