3 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
4 VALUES (13, 3, 'sforbes', 6, 'Forbes', 'samuelf1234',
5 'Samuel', 'Eugene', NOW() + '3 years'::INTERVAL, NULL, NULL);
7 INSERT INTO actor.usr_address
8 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
9 VALUES ('USA', 'f', '40065', '8751 Gentleman Burgs', 'f',
10 'KY', 'Shelbyville', '', 'Shelby', CURRVAL('actor.usr_id_seq'));
12 INSERT INTO actor.card (barcode, usr)
13 VALUES ('99999336514', CURRVAL('actor.usr_id_seq'));
16 card = CURRVAL('actor.card_id_seq'),
17 billing_address = CURRVAL('actor.usr_address_id_seq'),
18 credit_forward_balance = '0',
19 mailing_address = CURRVAL('actor.usr_address_id_seq')
20 WHERE id=CURRVAL('actor.usr_id_seq');
22 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
23 VALUES (CURRVAL('actor.usr_id_seq'), 6);
25 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
26 FROM actor.org_unit aou
27 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
30 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
31 VALUES (13, 1, 'vcampbell', 4, 'Campbell', 'vincentc1234',
32 'Vincent', 'Lawrence', NOW() + '3 years'::INTERVAL, NULL, NULL);
34 INSERT INTO actor.usr_address
35 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
36 VALUES ('USA', 'f', '45633', '5489 Suitable Way Knoll', 't',
37 'OH', 'Hallsville', '', 'Ross', CURRVAL('actor.usr_id_seq'));
39 INSERT INTO actor.card (barcode, usr)
40 VALUES ('99999338171', CURRVAL('actor.usr_id_seq'));
43 card = CURRVAL('actor.card_id_seq'),
44 billing_address = CURRVAL('actor.usr_address_id_seq'),
45 credit_forward_balance = '0',
46 mailing_address = CURRVAL('actor.usr_address_id_seq')
47 WHERE id=CURRVAL('actor.usr_id_seq');
49 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
50 VALUES (CURRVAL('actor.usr_id_seq'), 4);
52 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
53 FROM actor.org_unit aou
54 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
57 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
58 VALUES (15, 3, 'afrey', 9, 'Frey', 'annief1234',
59 'Annie', 'Jessica', NOW() + '3 years'::INTERVAL, NULL, NULL);
61 INSERT INTO actor.usr_address
62 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
63 VALUES ('USA', 't', '54409', '7918 Subjective Volume Trail', 't',
64 'WI', 'Antigo', '', '', CURRVAL('actor.usr_id_seq'));
66 INSERT INTO actor.card (barcode, usr)
67 VALUES ('99999364116', CURRVAL('actor.usr_id_seq'));
70 card = CURRVAL('actor.card_id_seq'),
71 billing_address = CURRVAL('actor.usr_address_id_seq'),
72 credit_forward_balance = '0',
73 mailing_address = CURRVAL('actor.usr_address_id_seq')
74 WHERE id=CURRVAL('actor.usr_id_seq');
76 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
77 VALUES (CURRVAL('actor.usr_id_seq'), 9);
79 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
80 FROM actor.org_unit aou
81 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
84 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
85 VALUES (15, 3, 'msalinas', 9, 'Salinas', 'marks1234',
86 'Mark', 'Christopher', NOW() + '3 years'::INTERVAL, '1999-06-13', 'II');
88 INSERT INTO actor.usr_address
89 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
90 VALUES ('USA', 'f', '25529', '1790 Lively Attitude Falls', 't',
91 'WV', 'Julian', '', 'Boone', CURRVAL('actor.usr_id_seq'));
93 INSERT INTO actor.card (barcode, usr)
94 VALUES ('99999313813', CURRVAL('actor.usr_id_seq'));
97 card = CURRVAL('actor.card_id_seq'),
98 billing_address = CURRVAL('actor.usr_address_id_seq'),
99 credit_forward_balance = '0',
100 mailing_address = CURRVAL('actor.usr_address_id_seq')
101 WHERE id=CURRVAL('actor.usr_id_seq');
103 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
104 VALUES (CURRVAL('actor.usr_id_seq'), 9);
106 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
107 FROM actor.org_unit aou
108 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
110 INSERT INTO actor.usr
111 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
112 VALUES (15, 1, 'klindsey', 8, 'Lindsey', 'kennethl1234',
113 'Kenneth', 'Jesse', NOW() + '3 years'::INTERVAL, NULL, NULL);
115 INSERT INTO actor.usr_address
116 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
117 VALUES ('USA', 't', '89077', '1552 Okay Communication Motorway', 't',
118 'NV', 'Henderson', '', '', CURRVAL('actor.usr_id_seq'));
120 INSERT INTO actor.card (barcode, usr)
121 VALUES ('99999334832', CURRVAL('actor.usr_id_seq'));
124 card = CURRVAL('actor.card_id_seq'),
125 billing_address = CURRVAL('actor.usr_address_id_seq'),
126 credit_forward_balance = '0',
127 mailing_address = CURRVAL('actor.usr_address_id_seq')
128 WHERE id=CURRVAL('actor.usr_id_seq');
130 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
131 VALUES (CURRVAL('actor.usr_id_seq'), 8);
133 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
134 FROM actor.org_unit aou
135 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
137 INSERT INTO actor.usr
138 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
139 VALUES (15, 3, 'mdavis', 8, 'Davis', 'marthad1234',
140 'Martha', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
142 INSERT INTO actor.usr_address
143 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
144 VALUES ('USA', 'f', '13156', '8717 Cabinet Fords', 't',
145 'NY', 'Sterling', '', 'Cayuga', CURRVAL('actor.usr_id_seq'));
147 INSERT INTO actor.card (barcode, usr)
148 VALUES ('99999315736', CURRVAL('actor.usr_id_seq'));
151 card = CURRVAL('actor.card_id_seq'),
152 billing_address = CURRVAL('actor.usr_address_id_seq'),
153 credit_forward_balance = '0',
154 mailing_address = CURRVAL('actor.usr_address_id_seq')
155 WHERE id=CURRVAL('actor.usr_id_seq');
157 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
158 VALUES (CURRVAL('actor.usr_id_seq'), 8);
160 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
161 FROM actor.org_unit aou
162 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
164 INSERT INTO actor.usr
165 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
166 VALUES (15, 3, 'vfreeman', 7, 'Freeman', 'virginiaf1234',
167 'Virginia', 'Johanna', NOW() + '3 years'::INTERVAL, '1967-07-23', 'Jr');
169 INSERT INTO actor.usr_address
170 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
171 VALUES ('USA', 'f', '33122', '4033 Instant Matter Cape', 't',
172 'FL', 'Miami', '', '', CURRVAL('actor.usr_id_seq'));
174 INSERT INTO actor.card (barcode, usr)
175 VALUES ('99999301938', CURRVAL('actor.usr_id_seq'));
178 card = CURRVAL('actor.card_id_seq'),
179 billing_address = CURRVAL('actor.usr_address_id_seq'),
180 credit_forward_balance = '0',
181 mailing_address = CURRVAL('actor.usr_address_id_seq')
182 WHERE id=CURRVAL('actor.usr_id_seq');
184 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
185 VALUES (CURRVAL('actor.usr_id_seq'), 7);
187 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
188 FROM actor.org_unit aou
189 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
191 INSERT INTO actor.usr
192 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
193 VALUES (15, 3, 'lmartinez', 7, 'Martinez', 'leroym1234',
194 'Leroy', 'Brian', NOW() + '3 years'::INTERVAL, NULL, NULL);
196 INSERT INTO actor.usr_address
197 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
198 VALUES ('USA', 't', '55046', '2511 Other Stream', 't',
199 'MN', 'Lonsdale', '', 'Rice', CURRVAL('actor.usr_id_seq'));
201 INSERT INTO actor.card (barcode, usr)
202 VALUES ('99999385425', CURRVAL('actor.usr_id_seq'));
205 card = CURRVAL('actor.card_id_seq'),
206 billing_address = CURRVAL('actor.usr_address_id_seq'),
207 credit_forward_balance = '0',
208 mailing_address = CURRVAL('actor.usr_address_id_seq')
209 WHERE id=CURRVAL('actor.usr_id_seq');
211 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
212 VALUES (CURRVAL('actor.usr_id_seq'), 7);
214 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
215 FROM actor.org_unit aou
216 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
218 INSERT INTO actor.usr
219 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
220 VALUES (15, 1, 'warmstrong', 6, 'Armstrong', 'williama1234',
221 'William', 'William', NOW() + '3 years'::INTERVAL, NULL, NULL);
223 INSERT INTO actor.usr_address
224 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
225 VALUES ('USA', 'f', '55959', '1671 Cabinet Orchard', 't',
226 'MN', 'Minnesota city', '', 'Winona', CURRVAL('actor.usr_id_seq'));
228 INSERT INTO actor.card (barcode, usr)
229 VALUES ('99999378711', CURRVAL('actor.usr_id_seq'));
232 card = CURRVAL('actor.card_id_seq'),
233 billing_address = CURRVAL('actor.usr_address_id_seq'),
234 credit_forward_balance = '0',
235 mailing_address = CURRVAL('actor.usr_address_id_seq')
236 WHERE id=CURRVAL('actor.usr_id_seq');
238 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
239 VALUES (CURRVAL('actor.usr_id_seq'), 6);
241 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
242 FROM actor.org_unit aou
243 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
245 INSERT INTO actor.usr
246 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
247 VALUES (15, 3, 'acotton', 6, 'Cotton', 'amyc1234',
248 'Amy', 'Ada', NOW() + '3 years'::INTERVAL, NULL, NULL);
250 INSERT INTO actor.usr_address
251 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
252 VALUES ('USA', 't', '34202', '1488 Glamorous Alternative Forks', 't',
253 'FL', 'Bradenton', '', 'Manatee', CURRVAL('actor.usr_id_seq'));
255 INSERT INTO actor.card (barcode, usr)
256 VALUES ('99999323866', CURRVAL('actor.usr_id_seq'));
259 card = CURRVAL('actor.card_id_seq'),
260 billing_address = CURRVAL('actor.usr_address_id_seq'),
261 credit_forward_balance = '0',
262 mailing_address = CURRVAL('actor.usr_address_id_seq')
263 WHERE id=CURRVAL('actor.usr_id_seq');
265 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
266 VALUES (CURRVAL('actor.usr_id_seq'), 6);
268 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
269 FROM actor.org_unit aou
270 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
272 INSERT INTO actor.usr
273 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
274 VALUES (15, 1, 'sbarton', 5, 'Barton', 'sarahb1234',
275 'Sarah', 'Valerie', NOW() + '3 years'::INTERVAL, NULL, NULL);
277 INSERT INTO actor.usr_address
278 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
279 VALUES ('USA', 'f', '54655', '6986 Delighted Design Trail', 't',
280 'WI', 'Soldiers grove', '', 'Crawford', CURRVAL('actor.usr_id_seq'));
282 INSERT INTO actor.card (barcode, usr)
283 VALUES ('99999327258', CURRVAL('actor.usr_id_seq'));
286 card = CURRVAL('actor.card_id_seq'),
287 billing_address = CURRVAL('actor.usr_address_id_seq'),
288 credit_forward_balance = '0',
289 mailing_address = CURRVAL('actor.usr_address_id_seq')
290 WHERE id=CURRVAL('actor.usr_id_seq');
292 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
293 VALUES (CURRVAL('actor.usr_id_seq'), 5);
295 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
296 FROM actor.org_unit aou
297 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
299 INSERT INTO actor.usr
300 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
301 VALUES (15, 1, 'jhammond', 5, 'Hammond', 'jamesh1234',
302 'James', 'Michael', NOW() + '3 years'::INTERVAL, NULL, NULL);
304 INSERT INTO actor.usr_address
305 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
306 VALUES ('USA', 'f', '88211', '9144 White Support Squares', 't',
307 'NM', 'Artesia', '', 'Eddy', CURRVAL('actor.usr_id_seq'));
309 INSERT INTO actor.card (barcode, usr)
310 VALUES ('99999385896', CURRVAL('actor.usr_id_seq'));
313 card = CURRVAL('actor.card_id_seq'),
314 billing_address = CURRVAL('actor.usr_address_id_seq'),
315 credit_forward_balance = '0',
316 mailing_address = CURRVAL('actor.usr_address_id_seq')
317 WHERE id=CURRVAL('actor.usr_id_seq');
319 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
320 VALUES (CURRVAL('actor.usr_id_seq'), 5);
322 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
323 FROM actor.org_unit aou
324 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
326 INSERT INTO actor.usr
327 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
328 VALUES (15, 3, 'ajoseph', 4, 'Joseph', 'alexj1234',
329 'Alex', 'Edward', NOW() + '3 years'::INTERVAL, NULL, NULL);
331 INSERT INTO actor.usr_address
332 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
333 VALUES ('USA', 't', '56308', '9081 Awake Minute Spring', 't',
334 'MN', 'Alexandria', '', 'Douglas', CURRVAL('actor.usr_id_seq'));
336 INSERT INTO actor.card (barcode, usr)
337 VALUES ('99999378073', CURRVAL('actor.usr_id_seq'));
340 card = CURRVAL('actor.card_id_seq'),
341 billing_address = CURRVAL('actor.usr_address_id_seq'),
342 credit_forward_balance = '0',
343 mailing_address = CURRVAL('actor.usr_address_id_seq')
344 WHERE id=CURRVAL('actor.usr_id_seq');
346 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
347 VALUES (CURRVAL('actor.usr_id_seq'), 4);
349 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
350 FROM actor.org_unit aou
351 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
353 INSERT INTO actor.usr
354 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
355 VALUES (15, 3, 'imccoy', 4, 'Mccoy', 'idam1234',
356 'Ida', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL);
358 INSERT INTO actor.usr_address
359 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
360 VALUES ('USA', 't', '40046', '9875 Support Row', 't',
361 'KY', 'Mount eden', '', 'Spencer', CURRVAL('actor.usr_id_seq'));
363 INSERT INTO actor.card (barcode, usr)
364 VALUES ('99999321047', CURRVAL('actor.usr_id_seq'));
367 card = CURRVAL('actor.card_id_seq'),
368 billing_address = CURRVAL('actor.usr_address_id_seq'),
369 credit_forward_balance = '0',
370 mailing_address = CURRVAL('actor.usr_address_id_seq')
371 WHERE id=CURRVAL('actor.usr_id_seq');
373 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
374 VALUES (CURRVAL('actor.usr_id_seq'), 4);
376 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
377 FROM actor.org_unit aou
378 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
380 INSERT INTO actor.usr
381 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
382 VALUES (14, 3, 'dwright', 9, 'Wright', 'dennisw1234',
383 'Dennis', 'Ernest', NOW() + '3 years'::INTERVAL, NULL, NULL);
385 INSERT INTO actor.usr_address
386 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
387 VALUES ('USA', 'f', '03457', '2063 Sophisticated Status Plaza', 't',
388 'NH', 'Nelson', '', 'Cheshire', CURRVAL('actor.usr_id_seq'));
390 INSERT INTO actor.card (barcode, usr)
391 VALUES ('99999348121', CURRVAL('actor.usr_id_seq'));
394 card = CURRVAL('actor.card_id_seq'),
395 billing_address = CURRVAL('actor.usr_address_id_seq'),
396 credit_forward_balance = '0',
397 mailing_address = CURRVAL('actor.usr_address_id_seq')
398 WHERE id=CURRVAL('actor.usr_id_seq');
400 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
401 VALUES (CURRVAL('actor.usr_id_seq'), 9);
403 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
404 FROM actor.org_unit aou
405 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
407 INSERT INTO actor.usr
408 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
409 VALUES (14, 1, 'alynch', 9, 'Lynch', 'armandol1234',
410 'Armando', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
412 INSERT INTO actor.usr_address
413 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
414 VALUES ('USA', 'f', '31126', '7394 Show Valley', 't',
415 'GA', 'Atlanta', '', 'Fulton', CURRVAL('actor.usr_id_seq'));
417 INSERT INTO actor.card (barcode, usr)
418 VALUES ('99999384116', CURRVAL('actor.usr_id_seq'));
421 card = CURRVAL('actor.card_id_seq'),
422 billing_address = CURRVAL('actor.usr_address_id_seq'),
423 credit_forward_balance = '0',
424 mailing_address = CURRVAL('actor.usr_address_id_seq')
425 WHERE id=CURRVAL('actor.usr_id_seq');
427 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
428 VALUES (CURRVAL('actor.usr_id_seq'), 9);
430 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
431 FROM actor.org_unit aou
432 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
434 INSERT INTO actor.usr
435 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
436 VALUES (14, 3, 'rgraham', 8, 'Graham', 'robertg1234',
437 'Robert', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
439 INSERT INTO actor.usr_address
440 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
441 VALUES ('USA', 't', '98807', '2577 Stuck Benefit Tunnel', 't',
442 'WA', 'Wenatchee', '', 'Chelan', CURRVAL('actor.usr_id_seq'));
444 INSERT INTO actor.card (barcode, usr)
445 VALUES ('99999311950', CURRVAL('actor.usr_id_seq'));
448 card = CURRVAL('actor.card_id_seq'),
449 billing_address = CURRVAL('actor.usr_address_id_seq'),
450 credit_forward_balance = '0',
451 mailing_address = CURRVAL('actor.usr_address_id_seq')
452 WHERE id=CURRVAL('actor.usr_id_seq');
454 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
455 VALUES (CURRVAL('actor.usr_id_seq'), 8);
457 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
458 FROM actor.org_unit aou
459 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
461 INSERT INTO actor.usr
462 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
463 VALUES (14, 1, 'sthompson', 8, 'Thompson', 'sherrit1234',
464 'Sherri', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
466 INSERT INTO actor.usr_address
467 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
468 VALUES ('USA', 'f', '31758', '3587 Name Neck', 't',
469 'GA', 'Thomasville', '', 'Thomas', CURRVAL('actor.usr_id_seq'));
471 INSERT INTO actor.card (barcode, usr)
472 VALUES ('99999384066', CURRVAL('actor.usr_id_seq'));
475 card = CURRVAL('actor.card_id_seq'),
476 billing_address = CURRVAL('actor.usr_address_id_seq'),
477 credit_forward_balance = '0',
478 mailing_address = CURRVAL('actor.usr_address_id_seq')
479 WHERE id=CURRVAL('actor.usr_id_seq');
481 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
482 VALUES (CURRVAL('actor.usr_id_seq'), 8);
484 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
485 FROM actor.org_unit aou
486 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
488 INSERT INTO actor.usr
489 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
490 VALUES (14, 1, 'ngarcia', 7, 'Garcia', 'nanetteg1234',
491 'Nanette', 'Helen', NOW() + '3 years'::INTERVAL, NULL, NULL);
493 INSERT INTO actor.usr_address
494 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
495 VALUES ('USA', 't', '11733', '6990 Icy Scene Street', 't',
496 'NY', 'East setauket', '', 'Suffolk', CURRVAL('actor.usr_id_seq'));
498 INSERT INTO actor.card (barcode, usr)
499 VALUES ('99999332719', CURRVAL('actor.usr_id_seq'));
502 card = CURRVAL('actor.card_id_seq'),
503 billing_address = CURRVAL('actor.usr_address_id_seq'),
504 credit_forward_balance = '0',
505 mailing_address = CURRVAL('actor.usr_address_id_seq')
506 WHERE id=CURRVAL('actor.usr_id_seq');
508 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
509 VALUES (CURRVAL('actor.usr_id_seq'), 7);
511 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
512 FROM actor.org_unit aou
513 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
515 INSERT INTO actor.usr
516 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
517 VALUES (14, 3, 'rcook', 7, 'Cook', 'raymondc1234',
518 'Raymond', 'Boyd', NOW() + '3 years'::INTERVAL, NULL, NULL);
520 INSERT INTO actor.usr_address
521 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
522 VALUES ('USA', 't', '94533', '2004 Harsh Gold Tunnel', 't',
523 'CA', 'Fairfield', '', 'Solano', CURRVAL('actor.usr_id_seq'));
525 INSERT INTO actor.card (barcode, usr)
526 VALUES ('99999392343', CURRVAL('actor.usr_id_seq'));
529 card = CURRVAL('actor.card_id_seq'),
530 billing_address = CURRVAL('actor.usr_address_id_seq'),
531 credit_forward_balance = '0',
532 mailing_address = CURRVAL('actor.usr_address_id_seq')
533 WHERE id=CURRVAL('actor.usr_id_seq');
535 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
536 VALUES (CURRVAL('actor.usr_id_seq'), 7);
538 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
539 FROM actor.org_unit aou
540 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
542 INSERT INTO actor.usr
543 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
544 VALUES (14, 3, 'kbrewer', 6, 'Brewer', 'katherineb1234',
545 'Katherine', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
547 INSERT INTO actor.usr_address
548 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
549 VALUES ('USA', 'f', '59053', '6732 Recognition Street', 't',
550 'MT', 'Martinsdale', '', 'Meagher', CURRVAL('actor.usr_id_seq'));
552 INSERT INTO actor.card (barcode, usr)
553 VALUES ('99999383479', CURRVAL('actor.usr_id_seq'));
556 card = CURRVAL('actor.card_id_seq'),
557 billing_address = CURRVAL('actor.usr_address_id_seq'),
558 credit_forward_balance = '0',
559 mailing_address = CURRVAL('actor.usr_address_id_seq')
560 WHERE id=CURRVAL('actor.usr_id_seq');
562 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
563 VALUES (CURRVAL('actor.usr_id_seq'), 6);
565 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
566 FROM actor.org_unit aou
567 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
569 INSERT INTO actor.usr
570 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
571 VALUES (14, 1, 'cwashington', 6, 'Washington', 'christopherw1234',
572 'Christopher', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
574 INSERT INTO actor.usr_address
575 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
576 VALUES ('USA', 't', '47360', '9934 Coloured Bar Grove', 't',
577 'IN', 'Mooreland', '', 'Henry', CURRVAL('actor.usr_id_seq'));
579 INSERT INTO actor.card (barcode, usr)
580 VALUES ('99999380284', CURRVAL('actor.usr_id_seq'));
583 card = CURRVAL('actor.card_id_seq'),
584 billing_address = CURRVAL('actor.usr_address_id_seq'),
585 credit_forward_balance = '0',
586 mailing_address = CURRVAL('actor.usr_address_id_seq')
587 WHERE id=CURRVAL('actor.usr_id_seq');
589 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
590 VALUES (CURRVAL('actor.usr_id_seq'), 6);
592 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
593 FROM actor.org_unit aou
594 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
596 INSERT INTO actor.usr
597 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
598 VALUES (14, 3, 'dmurray', 5, 'Murray', 'dawnm1234',
599 'Dawn', 'Katherine', NOW() + '3 years'::INTERVAL, NULL, NULL);
601 INSERT INTO actor.usr_address
602 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
603 VALUES ('USA', 't', '59868', '4426 Temporary Demand River', 't',
604 'MT', 'Seeley lake', '', 'Missoula', CURRVAL('actor.usr_id_seq'));
606 INSERT INTO actor.card (barcode, usr)
607 VALUES ('99999347656', CURRVAL('actor.usr_id_seq'));
610 card = CURRVAL('actor.card_id_seq'),
611 billing_address = CURRVAL('actor.usr_address_id_seq'),
612 credit_forward_balance = '0',
613 mailing_address = CURRVAL('actor.usr_address_id_seq')
614 WHERE id=CURRVAL('actor.usr_id_seq');
616 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
617 VALUES (CURRVAL('actor.usr_id_seq'), 5);
619 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
620 FROM actor.org_unit aou
621 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
623 INSERT INTO actor.usr
624 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
625 VALUES (14, 1, 'bwatts', 5, 'Watts', 'barbaraw1234',
626 'Barbara', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL);
628 INSERT INTO actor.usr_address
629 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
630 VALUES ('USA', 't', '51036', '4020 Marked Chemical Bayoo', 't',
631 'IA', 'Maurice', '', 'Sioux', CURRVAL('actor.usr_id_seq'));
633 INSERT INTO actor.card (barcode, usr)
634 VALUES ('99999384489', CURRVAL('actor.usr_id_seq'));
637 card = CURRVAL('actor.card_id_seq'),
638 billing_address = CURRVAL('actor.usr_address_id_seq'),
639 credit_forward_balance = '0',
640 mailing_address = CURRVAL('actor.usr_address_id_seq')
641 WHERE id=CURRVAL('actor.usr_id_seq');
643 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
644 VALUES (CURRVAL('actor.usr_id_seq'), 5);
646 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
647 FROM actor.org_unit aou
648 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
650 INSERT INTO actor.usr
651 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
652 VALUES (14, 3, 'mmartin', 4, 'Martin', 'marym1234',
653 'Mary', 'Shannon', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
655 INSERT INTO actor.usr_address
656 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
657 VALUES ('USA', 't', '16657', '7511 Fortunate Length Parkway', 't',
658 'PA', 'James creek', '', 'Huntingdon', CURRVAL('actor.usr_id_seq'));
660 INSERT INTO actor.card (barcode, usr)
661 VALUES ('99999336634', CURRVAL('actor.usr_id_seq'));
664 card = CURRVAL('actor.card_id_seq'),
665 billing_address = CURRVAL('actor.usr_address_id_seq'),
666 credit_forward_balance = '0',
667 mailing_address = CURRVAL('actor.usr_address_id_seq')
668 WHERE id=CURRVAL('actor.usr_id_seq');
670 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
671 VALUES (CURRVAL('actor.usr_id_seq'), 4);
673 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
674 FROM actor.org_unit aou
675 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
677 INSERT INTO actor.usr
678 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
679 VALUES (14, 3, 'vford', 4, 'Ford', 'vivianf1234',
680 'Vivian', 'Darlene', NOW() + '3 years'::INTERVAL, NULL, NULL);
682 INSERT INTO actor.usr_address
683 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
684 VALUES ('USA', 't', '23023', '3414 Energetic Weekend Circles', 't',
685 'VA', 'Bruington', '', 'King and queen', CURRVAL('actor.usr_id_seq'));
687 INSERT INTO actor.card (barcode, usr)
688 VALUES ('99999361251', CURRVAL('actor.usr_id_seq'));
691 card = CURRVAL('actor.card_id_seq'),
692 billing_address = CURRVAL('actor.usr_address_id_seq'),
693 credit_forward_balance = '0',
694 mailing_address = CURRVAL('actor.usr_address_id_seq')
695 WHERE id=CURRVAL('actor.usr_id_seq');
697 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
698 VALUES (CURRVAL('actor.usr_id_seq'), 4);
700 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
701 FROM actor.org_unit aou
702 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
704 INSERT INTO actor.usr
705 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
706 VALUES (12, 1, 'gsuarez', 9, 'Suarez', 'garys1234',
707 'Gary', 'Joel', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
709 INSERT INTO actor.usr_address
710 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
711 VALUES ('USA', 'f', '19244', '1613 Legislation River', 't',
712 'PA', 'Philadelphia', '', '', CURRVAL('actor.usr_id_seq'));
714 INSERT INTO actor.card (barcode, usr)
715 VALUES ('99999372079', CURRVAL('actor.usr_id_seq'));
718 card = CURRVAL('actor.card_id_seq'),
719 billing_address = CURRVAL('actor.usr_address_id_seq'),
720 credit_forward_balance = '0',
721 mailing_address = CURRVAL('actor.usr_address_id_seq')
722 WHERE id=CURRVAL('actor.usr_id_seq');
724 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
725 VALUES (CURRVAL('actor.usr_id_seq'), 9);
727 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
728 FROM actor.org_unit aou
729 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
731 INSERT INTO actor.usr
732 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
733 VALUES (12, 1, 'eellis', 9, 'Ellis', 'edwarde1234',
734 'Edward', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL);
736 INSERT INTO actor.usr_address
737 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
738 VALUES ('USA', 't', '17349', '1977 Profound Conference Path', 't',
739 'PA', 'New freedom', '', 'York', CURRVAL('actor.usr_id_seq'));
741 INSERT INTO actor.card (barcode, usr)
742 VALUES ('99999354444', CURRVAL('actor.usr_id_seq'));
745 card = CURRVAL('actor.card_id_seq'),
746 billing_address = CURRVAL('actor.usr_address_id_seq'),
747 credit_forward_balance = '0',
748 mailing_address = CURRVAL('actor.usr_address_id_seq')
749 WHERE id=CURRVAL('actor.usr_id_seq');
751 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
752 VALUES (CURRVAL('actor.usr_id_seq'), 9);
754 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
755 FROM actor.org_unit aou
756 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
758 INSERT INTO actor.usr
759 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
760 VALUES (12, 1, 'nward', 8, 'Ward', 'naomiw1234',
761 'Naomi', 'Angela', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
763 INSERT INTO actor.usr_address
764 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
765 VALUES ('USA', 't', '20109', '2689 Standard Interview Vista', 't',
766 'VA', 'Manassas', '', '', CURRVAL('actor.usr_id_seq'));
768 INSERT INTO actor.card (barcode, usr)
769 VALUES ('99999326817', CURRVAL('actor.usr_id_seq'));
772 card = CURRVAL('actor.card_id_seq'),
773 billing_address = CURRVAL('actor.usr_address_id_seq'),
774 credit_forward_balance = '0',
775 mailing_address = CURRVAL('actor.usr_address_id_seq')
776 WHERE id=CURRVAL('actor.usr_id_seq');
778 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
779 VALUES (CURRVAL('actor.usr_id_seq'), 8);
781 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
782 FROM actor.org_unit aou
783 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
785 INSERT INTO actor.usr
786 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
787 VALUES (12, 1, 'jrichards', 8, 'Richards', 'josephr1234',
788 'Joseph', 'Thomas', NOW() + '3 years'::INTERVAL, NULL, NULL);
790 INSERT INTO actor.usr_address
791 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
792 VALUES ('USA', 'f', '78658', '3275 Error Freeway', 't',
793 'TX', 'Ottine', '', 'Gonzales', CURRVAL('actor.usr_id_seq'));
795 INSERT INTO actor.card (barcode, usr)
796 VALUES ('99999318881', CURRVAL('actor.usr_id_seq'));
799 card = CURRVAL('actor.card_id_seq'),
800 billing_address = CURRVAL('actor.usr_address_id_seq'),
801 credit_forward_balance = '0',
802 mailing_address = CURRVAL('actor.usr_address_id_seq')
803 WHERE id=CURRVAL('actor.usr_id_seq');
805 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
806 VALUES (CURRVAL('actor.usr_id_seq'), 8);
808 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
809 FROM actor.org_unit aou
810 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
812 INSERT INTO actor.usr
813 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
814 VALUES (12, 3, 'rsanders', 7, 'Sanders', 'roslyns1234',
815 'Roslyn', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
817 INSERT INTO actor.usr_address
818 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
819 VALUES ('USA', 't', '19975', '6946 Constitutional Word Freeway', 't',
820 'DE', 'Selbyville', '', 'Sussex', CURRVAL('actor.usr_id_seq'));
822 INSERT INTO actor.card (barcode, usr)
823 VALUES ('99999356038', CURRVAL('actor.usr_id_seq'));
826 card = CURRVAL('actor.card_id_seq'),
827 billing_address = CURRVAL('actor.usr_address_id_seq'),
828 credit_forward_balance = '0',
829 mailing_address = CURRVAL('actor.usr_address_id_seq')
830 WHERE id=CURRVAL('actor.usr_id_seq');
832 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
833 VALUES (CURRVAL('actor.usr_id_seq'), 7);
835 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
836 FROM actor.org_unit aou
837 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
839 INSERT INTO actor.usr
840 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
841 VALUES (12, 1, 'nrivera', 7, 'Rivera', 'nancyr1234',
842 'Nancy', 'Anita', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
844 INSERT INTO actor.usr_address
845 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
846 VALUES ('USA', 't', '27373', '263 Catholic End Field', 't',
847 'NC', 'Wallburg', '', '', CURRVAL('actor.usr_id_seq'));
849 INSERT INTO actor.card (barcode, usr)
850 VALUES ('99999302274', CURRVAL('actor.usr_id_seq'));
853 card = CURRVAL('actor.card_id_seq'),
854 billing_address = CURRVAL('actor.usr_address_id_seq'),
855 credit_forward_balance = '0',
856 mailing_address = CURRVAL('actor.usr_address_id_seq')
857 WHERE id=CURRVAL('actor.usr_id_seq');
859 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
860 VALUES (CURRVAL('actor.usr_id_seq'), 7);
862 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
863 FROM actor.org_unit aou
864 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
866 INSERT INTO actor.usr
867 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
868 VALUES (12, 1, 'cmartin', 6, 'Martin', 'carlm1234',
869 'Carl', 'Charles', NOW() + '3 years'::INTERVAL, NULL, NULL);
871 INSERT INTO actor.usr_address
872 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
873 VALUES ('USA', 't', '61452', '6985 Welcome Statement Fort', 't',
874 'IL', 'Littleton', '', 'Schuyler', CURRVAL('actor.usr_id_seq'));
876 INSERT INTO actor.card (barcode, usr)
877 VALUES ('99999339237', CURRVAL('actor.usr_id_seq'));
880 card = CURRVAL('actor.card_id_seq'),
881 billing_address = CURRVAL('actor.usr_address_id_seq'),
882 credit_forward_balance = '0',
883 mailing_address = CURRVAL('actor.usr_address_id_seq')
884 WHERE id=CURRVAL('actor.usr_id_seq');
886 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
887 VALUES (CURRVAL('actor.usr_id_seq'), 6);
889 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
890 FROM actor.org_unit aou
891 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
893 INSERT INTO actor.usr
894 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
895 VALUES (12, 1, 'telliott', 6, 'Elliott', 'thomase1234',
896 'Thomas', 'Marcus', NOW() + '3 years'::INTERVAL, NULL, NULL);
898 INSERT INTO actor.usr_address
899 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
900 VALUES ('USA', 't', '97624', '1283 Splendid West Manor', 't',
901 'OR', 'Chiloquin', '', 'Klamath', CURRVAL('actor.usr_id_seq'));
903 INSERT INTO actor.card (barcode, usr)
904 VALUES ('99999340230', CURRVAL('actor.usr_id_seq'));
907 card = CURRVAL('actor.card_id_seq'),
908 billing_address = CURRVAL('actor.usr_address_id_seq'),
909 credit_forward_balance = '0',
910 mailing_address = CURRVAL('actor.usr_address_id_seq')
911 WHERE id=CURRVAL('actor.usr_id_seq');
913 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
914 VALUES (CURRVAL('actor.usr_id_seq'), 6);
916 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
917 FROM actor.org_unit aou
918 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
920 INSERT INTO actor.usr
921 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
922 VALUES (12, 3, 'ocherry', 5, 'Cherry', 'olgac1234',
923 'Olga', 'Marie', NOW() + '3 years'::INTERVAL, NULL, NULL);
925 INSERT INTO actor.usr_address
926 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
927 VALUES ('USA', 't', '17081', '9657 Scared Kind Street', 't',
928 'PA', 'Plainfield', '', 'Cumberland', CURRVAL('actor.usr_id_seq'));
930 INSERT INTO actor.card (barcode, usr)
931 VALUES ('99999384061', CURRVAL('actor.usr_id_seq'));
934 card = CURRVAL('actor.card_id_seq'),
935 billing_address = CURRVAL('actor.usr_address_id_seq'),
936 credit_forward_balance = '0',
937 mailing_address = CURRVAL('actor.usr_address_id_seq')
938 WHERE id=CURRVAL('actor.usr_id_seq');
940 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
941 VALUES (CURRVAL('actor.usr_id_seq'), 5);
943 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
944 FROM actor.org_unit aou
945 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
947 INSERT INTO actor.usr
948 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
949 VALUES (12, 1, 'gdavenport', 5, 'Davenport', 'gwendolynd1234',
950 'Gwendolyn', '', NOW() + '3 years'::INTERVAL, NULL, 'Jr');
952 INSERT INTO actor.usr_address
953 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
954 VALUES ('USA', 'f', '85014', '110 Logical Tone Drive', 't',
955 'AZ', 'Phoenix', '', 'Maricopa', CURRVAL('actor.usr_id_seq'));
957 INSERT INTO actor.card (barcode, usr)
958 VALUES ('99999372586', CURRVAL('actor.usr_id_seq'));
961 card = CURRVAL('actor.card_id_seq'),
962 billing_address = CURRVAL('actor.usr_address_id_seq'),
963 credit_forward_balance = '0',
964 mailing_address = CURRVAL('actor.usr_address_id_seq')
965 WHERE id=CURRVAL('actor.usr_id_seq');
967 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
968 VALUES (CURRVAL('actor.usr_id_seq'), 5);
970 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
971 FROM actor.org_unit aou
972 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
974 INSERT INTO actor.usr
975 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
976 VALUES (12, 3, 'sbrock', 4, 'Brock', 'scottb1234',
977 'Scott', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL);
979 INSERT INTO actor.usr_address
980 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
981 VALUES ('USA', 't', '60132', '1760 Channel Bottom', 't',
982 'IL', 'Carol stream', '', '', CURRVAL('actor.usr_id_seq'));
984 INSERT INTO actor.card (barcode, usr)
985 VALUES ('99999336715', CURRVAL('actor.usr_id_seq'));
988 card = CURRVAL('actor.card_id_seq'),
989 billing_address = CURRVAL('actor.usr_address_id_seq'),
990 credit_forward_balance = '0',
991 mailing_address = CURRVAL('actor.usr_address_id_seq')
992 WHERE id=CURRVAL('actor.usr_id_seq');
994 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
995 VALUES (CURRVAL('actor.usr_id_seq'), 4);
997 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
998 FROM actor.org_unit aou
999 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1001 INSERT INTO actor.usr
1002 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1003 VALUES (12, 3, 'rjackson', 4, 'Jackson', 'ronaldj1234',
1004 'Ronald', 'Robert', NOW() + '3 years'::INTERVAL, NULL, 'Jr');
1006 INSERT INTO actor.usr_address
1007 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1008 VALUES ('USA', 'f', '04985', '5561 Native Reduction Crossing', 't',
1009 'ME', 'West forks', '', '', CURRVAL('actor.usr_id_seq'));
1011 INSERT INTO actor.card (barcode, usr)
1012 VALUES ('99999335465', CURRVAL('actor.usr_id_seq'));
1014 UPDATE actor.usr SET
1015 card = CURRVAL('actor.card_id_seq'),
1016 billing_address = CURRVAL('actor.usr_address_id_seq'),
1017 credit_forward_balance = '0',
1018 mailing_address = CURRVAL('actor.usr_address_id_seq')
1019 WHERE id=CURRVAL('actor.usr_id_seq');
1021 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1022 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1024 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1025 FROM actor.org_unit aou
1026 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1028 INSERT INTO actor.usr
1029 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1030 VALUES (11, 1, 'wjames', 9, 'James', 'waynej1234',
1031 'Wayne', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL);
1033 INSERT INTO actor.usr_address
1034 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1035 VALUES ('USA', 't', '27014', '5542 Politics Hollow', 't',
1036 'NC', 'Cooleemee', '', '', CURRVAL('actor.usr_id_seq'));
1038 INSERT INTO actor.card (barcode, usr)
1039 VALUES ('99999379835', CURRVAL('actor.usr_id_seq'));
1041 UPDATE actor.usr SET
1042 card = CURRVAL('actor.card_id_seq'),
1043 billing_address = CURRVAL('actor.usr_address_id_seq'),
1044 credit_forward_balance = '0',
1045 mailing_address = CURRVAL('actor.usr_address_id_seq')
1046 WHERE id=CURRVAL('actor.usr_id_seq');
1048 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1049 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1051 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1052 FROM actor.org_unit aou
1053 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1055 INSERT INTO actor.usr
1056 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1057 VALUES (11, 1, 'shernandez', 9, 'Hernandez', 'sarahh1234',
1058 'Sarah', 'Elaine', NOW() + '3 years'::INTERVAL, NULL, NULL);
1060 INSERT INTO actor.usr_address
1061 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1062 VALUES ('USA', 't', '89151', '4939 Family Divide', 't',
1063 'NV', 'Las vegas', '', 'Clark', CURRVAL('actor.usr_id_seq'));
1065 INSERT INTO actor.card (barcode, usr)
1066 VALUES ('99999346587', CURRVAL('actor.usr_id_seq'));
1068 UPDATE actor.usr SET
1069 card = CURRVAL('actor.card_id_seq'),
1070 billing_address = CURRVAL('actor.usr_address_id_seq'),
1071 credit_forward_balance = '0',
1072 mailing_address = CURRVAL('actor.usr_address_id_seq')
1073 WHERE id=CURRVAL('actor.usr_id_seq');
1075 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1076 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1078 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1079 FROM actor.org_unit aou
1080 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1082 INSERT INTO actor.usr
1083 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1084 VALUES (11, 3, 'latkins', 8, 'Atkins', 'louisa1234',
1085 'Louis', 'Edward', NOW() + '3 years'::INTERVAL, NULL, NULL);
1087 INSERT INTO actor.usr_address
1088 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1089 VALUES ('USA', 't', '44705', '2794 Uniform Value Square', 't',
1090 'OH', 'Canton', '', 'Stark', CURRVAL('actor.usr_id_seq'));
1092 INSERT INTO actor.card (barcode, usr)
1093 VALUES ('99999377256', CURRVAL('actor.usr_id_seq'));
1095 UPDATE actor.usr SET
1096 card = CURRVAL('actor.card_id_seq'),
1097 billing_address = CURRVAL('actor.usr_address_id_seq'),
1098 credit_forward_balance = '0',
1099 mailing_address = CURRVAL('actor.usr_address_id_seq')
1100 WHERE id=CURRVAL('actor.usr_id_seq');
1102 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1103 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1105 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1106 FROM actor.org_unit aou
1107 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1109 INSERT INTO actor.usr
1110 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1111 VALUES (11, 3, 'wneal', 8, 'Neal', 'waynen1234',
1112 'Wayne', '', NOW() + '3 years'::INTERVAL, '1977-06-05', 'Jr');
1114 INSERT INTO actor.usr_address
1115 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1116 VALUES ('USA', 't', '35501', '6178 Relieved Rain Wells', 't',
1117 'AL', 'Jasper', '', 'Walker', CURRVAL('actor.usr_id_seq'));
1119 INSERT INTO actor.card (barcode, usr)
1120 VALUES ('99999377249', CURRVAL('actor.usr_id_seq'));
1122 UPDATE actor.usr SET
1123 card = CURRVAL('actor.card_id_seq'),
1124 billing_address = CURRVAL('actor.usr_address_id_seq'),
1125 credit_forward_balance = '0',
1126 mailing_address = CURRVAL('actor.usr_address_id_seq')
1127 WHERE id=CURRVAL('actor.usr_id_seq');
1129 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1130 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1132 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1133 FROM actor.org_unit aou
1134 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1136 INSERT INTO actor.usr
1137 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1138 VALUES (11, 3, 'mharrison', 7, 'Harrison', 'michelleh1234',
1139 'Michelle', 'Patricia', NOW() + '3 years'::INTERVAL, NULL, NULL);
1141 INSERT INTO actor.usr_address
1142 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1143 VALUES ('USA', 't', '05345', '1766 Victorious Estate Avenue', 't',
1144 'VT', 'Newfane', '', 'Windham', CURRVAL('actor.usr_id_seq'));
1146 INSERT INTO actor.card (barcode, usr)
1147 VALUES ('99999376642', CURRVAL('actor.usr_id_seq'));
1149 UPDATE actor.usr SET
1150 card = CURRVAL('actor.card_id_seq'),
1151 billing_address = CURRVAL('actor.usr_address_id_seq'),
1152 credit_forward_balance = '0',
1153 mailing_address = CURRVAL('actor.usr_address_id_seq')
1154 WHERE id=CURRVAL('actor.usr_id_seq');
1156 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1157 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1159 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1160 FROM actor.org_unit aou
1161 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1163 INSERT INTO actor.usr
1164 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1165 VALUES (11, 3, 'hwomack', 7, 'Womack', 'howardw1234',
1166 'Howard', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1168 INSERT INTO actor.usr_address
1169 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1170 VALUES ('USA', 't', '06262', '5472 Exhibition Trace', 't',
1171 'CT', 'Quinebaug', '', '', CURRVAL('actor.usr_id_seq'));
1173 INSERT INTO actor.card (barcode, usr)
1174 VALUES ('99999342319', CURRVAL('actor.usr_id_seq'));
1176 UPDATE actor.usr SET
1177 card = CURRVAL('actor.card_id_seq'),
1178 billing_address = CURRVAL('actor.usr_address_id_seq'),
1179 credit_forward_balance = '0',
1180 mailing_address = CURRVAL('actor.usr_address_id_seq')
1181 WHERE id=CURRVAL('actor.usr_id_seq');
1183 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1184 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1186 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1187 FROM actor.org_unit aou
1188 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1190 INSERT INTO actor.usr
1191 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1192 VALUES (11, 3, 'vbacon', 6, 'Bacon', 'virginiab1234',
1193 'Virginia', 'Celia', NOW() + '3 years'::INTERVAL, NULL, NULL);
1195 INSERT INTO actor.usr_address
1196 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1197 VALUES ('USA', 't', '61638', '4639 Family Tunnel', 't',
1198 'IL', 'Peoria', '', '', CURRVAL('actor.usr_id_seq'));
1200 INSERT INTO actor.card (barcode, usr)
1201 VALUES ('99999362019', CURRVAL('actor.usr_id_seq'));
1203 UPDATE actor.usr SET
1204 card = CURRVAL('actor.card_id_seq'),
1205 billing_address = CURRVAL('actor.usr_address_id_seq'),
1206 credit_forward_balance = '0',
1207 mailing_address = CURRVAL('actor.usr_address_id_seq')
1208 WHERE id=CURRVAL('actor.usr_id_seq');
1210 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1211 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1213 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1214 FROM actor.org_unit aou
1215 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1217 INSERT INTO actor.usr
1218 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1219 VALUES (11, 1, 'lbrooks', 6, 'Brooks', 'lonnieb1234',
1220 'Lonnie', 'William', NOW() + '3 years'::INTERVAL, NULL, NULL);
1222 INSERT INTO actor.usr_address
1223 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1224 VALUES ('USA', 't', '83836', '8823 Side Fall', 't',
1225 'ID', 'Hope', '', 'Bonner', CURRVAL('actor.usr_id_seq'));
1227 INSERT INTO actor.card (barcode, usr)
1228 VALUES ('99999326493', CURRVAL('actor.usr_id_seq'));
1230 UPDATE actor.usr SET
1231 card = CURRVAL('actor.card_id_seq'),
1232 billing_address = CURRVAL('actor.usr_address_id_seq'),
1233 credit_forward_balance = '0',
1234 mailing_address = CURRVAL('actor.usr_address_id_seq')
1235 WHERE id=CURRVAL('actor.usr_id_seq');
1237 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1238 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1240 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1241 FROM actor.org_unit aou
1242 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1244 INSERT INTO actor.usr
1245 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1246 VALUES (11, 3, 'mgonzales', 5, 'Gonzales', 'maryg1234',
1247 'Mary', 'Jessica', NOW() + '3 years'::INTERVAL, NULL, NULL);
1249 INSERT INTO actor.usr_address
1250 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1251 VALUES ('USA', 'f', '16213', '6608 Weary Drawing Lakes', 't',
1252 'PA', 'Callensburg', '', 'Clarion', CURRVAL('actor.usr_id_seq'));
1254 INSERT INTO actor.card (barcode, usr)
1255 VALUES ('99999337760', CURRVAL('actor.usr_id_seq'));
1257 UPDATE actor.usr SET
1258 card = CURRVAL('actor.card_id_seq'),
1259 billing_address = CURRVAL('actor.usr_address_id_seq'),
1260 credit_forward_balance = '0',
1261 mailing_address = CURRVAL('actor.usr_address_id_seq')
1262 WHERE id=CURRVAL('actor.usr_id_seq');
1264 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1265 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1267 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1268 FROM actor.org_unit aou
1269 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1271 INSERT INTO actor.usr
1272 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1273 VALUES (11, 1, 'mterry', 5, 'Terry', 'michellet1234',
1274 'Michelle', 'Kristy', NOW() + '3 years'::INTERVAL, NULL, NULL);
1276 INSERT INTO actor.usr_address
1277 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1278 VALUES ('USA', 'f', '30817', '1658 Organisational Bedroom Square', 't',
1279 'GA', 'Lincolnton', '', '', CURRVAL('actor.usr_id_seq'));
1281 INSERT INTO actor.card (barcode, usr)
1282 VALUES ('99999390692', CURRVAL('actor.usr_id_seq'));
1284 UPDATE actor.usr SET
1285 card = CURRVAL('actor.card_id_seq'),
1286 billing_address = CURRVAL('actor.usr_address_id_seq'),
1287 credit_forward_balance = '0',
1288 mailing_address = CURRVAL('actor.usr_address_id_seq')
1289 WHERE id=CURRVAL('actor.usr_id_seq');
1291 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1292 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1294 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1295 FROM actor.org_unit aou
1296 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1298 INSERT INTO actor.usr
1299 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1300 VALUES (11, 3, 'mmeeks', 4, 'Meeks', 'michellem1234',
1301 'Michelle', 'Myra', NOW() + '3 years'::INTERVAL, '1966-01-23', 'III');
1303 INSERT INTO actor.usr_address
1304 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1305 VALUES ('USA', 'f', '88240', '7269 Sister Gardens', 't',
1306 'NM', 'Hobbs', '', 'Lea', CURRVAL('actor.usr_id_seq'));
1308 INSERT INTO actor.card (barcode, usr)
1309 VALUES ('99999396672', CURRVAL('actor.usr_id_seq'));
1311 UPDATE actor.usr SET
1312 card = CURRVAL('actor.card_id_seq'),
1313 billing_address = CURRVAL('actor.usr_address_id_seq'),
1314 credit_forward_balance = '0',
1315 mailing_address = CURRVAL('actor.usr_address_id_seq')
1316 WHERE id=CURRVAL('actor.usr_id_seq');
1318 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1319 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1321 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1322 FROM actor.org_unit aou
1323 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1325 INSERT INTO actor.usr
1326 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1327 VALUES (11, 3, 'epalmer', 4, 'Palmer', 'elvap1234',
1328 'Elva', 'Tiffany', NOW() + '3 years'::INTERVAL, '1987-08-21', 'Jr');
1330 INSERT INTO actor.usr_address
1331 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1332 VALUES ('USA', 't', '50595', '7864 Remarkable Status River', 't',
1333 'IA', 'Webster city', '', 'Hamilton', CURRVAL('actor.usr_id_seq'));
1335 INSERT INTO actor.card (barcode, usr)
1336 VALUES ('99999335171', CURRVAL('actor.usr_id_seq'));
1338 UPDATE actor.usr SET
1339 card = CURRVAL('actor.card_id_seq'),
1340 billing_address = CURRVAL('actor.usr_address_id_seq'),
1341 credit_forward_balance = '0',
1342 mailing_address = CURRVAL('actor.usr_address_id_seq')
1343 WHERE id=CURRVAL('actor.usr_id_seq');
1345 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1346 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1348 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1349 FROM actor.org_unit aou
1350 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1352 INSERT INTO actor.usr
1353 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1354 VALUES (10, 3, 'mwilliams', 9, 'Williams', 'mattheww1234',
1355 'Matthew', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1357 INSERT INTO actor.usr_address
1358 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1359 VALUES ('USA', 'f', '60064', '7230 Trend Mount', 't',
1360 'IL', 'North chicago', '', 'Lake', CURRVAL('actor.usr_id_seq'));
1362 INSERT INTO actor.card (barcode, usr)
1363 VALUES ('99999365046', CURRVAL('actor.usr_id_seq'));
1365 UPDATE actor.usr SET
1366 card = CURRVAL('actor.card_id_seq'),
1367 billing_address = CURRVAL('actor.usr_address_id_seq'),
1368 credit_forward_balance = '0',
1369 mailing_address = CURRVAL('actor.usr_address_id_seq')
1370 WHERE id=CURRVAL('actor.usr_id_seq');
1372 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1373 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1375 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1376 FROM actor.org_unit aou
1377 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1379 INSERT INTO actor.usr
1380 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1381 VALUES (10, 1, 'nperez', 9, 'Perez', 'nicholasp1234',
1382 'Nicholas', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, NULL);
1384 INSERT INTO actor.usr_address
1385 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1386 VALUES ('USA', 'f', '55076', '9299 Democratic Hill Cliffs', 't',
1387 'MN', 'Inver grove heights', '', '', CURRVAL('actor.usr_id_seq'));
1389 INSERT INTO actor.card (barcode, usr)
1390 VALUES ('99999391887', CURRVAL('actor.usr_id_seq'));
1392 UPDATE actor.usr SET
1393 card = CURRVAL('actor.card_id_seq'),
1394 billing_address = CURRVAL('actor.usr_address_id_seq'),
1395 credit_forward_balance = '0',
1396 mailing_address = CURRVAL('actor.usr_address_id_seq')
1397 WHERE id=CURRVAL('actor.usr_id_seq');
1399 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1400 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1402 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1403 FROM actor.org_unit aou
1404 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1406 INSERT INTO actor.usr
1407 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1408 VALUES (10, 3, 'bfisher', 8, 'Fisher', 'barbaraf1234',
1409 'Barbara', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1411 INSERT INTO actor.usr_address
1412 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1413 VALUES ('USA', 't', '61756', '9822 Excess Start Lock', 't',
1414 'IL', 'Maroa', '', 'Macon', CURRVAL('actor.usr_id_seq'));
1416 INSERT INTO actor.card (barcode, usr)
1417 VALUES ('99999325028', CURRVAL('actor.usr_id_seq'));
1419 UPDATE actor.usr SET
1420 card = CURRVAL('actor.card_id_seq'),
1421 billing_address = CURRVAL('actor.usr_address_id_seq'),
1422 credit_forward_balance = '0',
1423 mailing_address = CURRVAL('actor.usr_address_id_seq')
1424 WHERE id=CURRVAL('actor.usr_id_seq');
1426 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1427 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1429 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1430 FROM actor.org_unit aou
1431 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1433 INSERT INTO actor.usr
1434 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1435 VALUES (10, 3, 'mmendoza', 8, 'Mendoza', 'miguelm1234',
1436 'Miguel', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1438 INSERT INTO actor.usr_address
1439 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1440 VALUES ('USA', 'f', '58773', '5831 Residential Respect Track', 't',
1441 'ND', 'Powers lake', '', 'Burke', CURRVAL('actor.usr_id_seq'));
1443 INSERT INTO actor.card (barcode, usr)
1444 VALUES ('99999338966', CURRVAL('actor.usr_id_seq'));
1446 UPDATE actor.usr SET
1447 card = CURRVAL('actor.card_id_seq'),
1448 billing_address = CURRVAL('actor.usr_address_id_seq'),
1449 credit_forward_balance = '0',
1450 mailing_address = CURRVAL('actor.usr_address_id_seq')
1451 WHERE id=CURRVAL('actor.usr_id_seq');
1453 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1454 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1456 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1457 FROM actor.org_unit aou
1458 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1460 INSERT INTO actor.usr
1461 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1462 VALUES (10, 1, 'ldickinson', 7, 'Dickinson', 'leed1234',
1463 'Lee', 'Annie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1465 INSERT INTO actor.usr_address
1466 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1467 VALUES ('USA', 't', '12803', '5030 Vision Loop', 't',
1468 'NY', 'South glens falls', '', 'Saratoga', CURRVAL('actor.usr_id_seq'));
1470 INSERT INTO actor.card (barcode, usr)
1471 VALUES ('99999328210', CURRVAL('actor.usr_id_seq'));
1473 UPDATE actor.usr SET
1474 card = CURRVAL('actor.card_id_seq'),
1475 billing_address = CURRVAL('actor.usr_address_id_seq'),
1476 credit_forward_balance = '0',
1477 mailing_address = CURRVAL('actor.usr_address_id_seq')
1478 WHERE id=CURRVAL('actor.usr_id_seq');
1480 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1481 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1483 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1484 FROM actor.org_unit aou
1485 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1487 INSERT INTO actor.usr
1488 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1489 VALUES (10, 1, 'awilliams', 7, 'Williams', 'angelinaw1234',
1490 'Angelina', 'Joan', NOW() + '3 years'::INTERVAL, NULL, NULL);
1492 INSERT INTO actor.usr_address
1493 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1494 VALUES ('USA', 't', '25054', '1723 Multiple Object Canyon', 't',
1495 'WV', 'Dawes', '', 'Kanawha', CURRVAL('actor.usr_id_seq'));
1497 INSERT INTO actor.card (barcode, usr)
1498 VALUES ('99999373939', CURRVAL('actor.usr_id_seq'));
1500 UPDATE actor.usr SET
1501 card = CURRVAL('actor.card_id_seq'),
1502 billing_address = CURRVAL('actor.usr_address_id_seq'),
1503 credit_forward_balance = '0',
1504 mailing_address = CURRVAL('actor.usr_address_id_seq')
1505 WHERE id=CURRVAL('actor.usr_id_seq');
1507 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1508 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1510 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1511 FROM actor.org_unit aou
1512 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1514 INSERT INTO actor.usr
1515 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1516 VALUES (10, 1, 'bsanchez', 6, 'Sanchez', 'beths1234',
1517 'Beth', 'Deborah', NOW() + '3 years'::INTERVAL, NULL, NULL);
1519 INSERT INTO actor.usr_address
1520 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1521 VALUES ('USA', 'f', '36426', '5148 Shaggy Farm Center', 't',
1522 'AL', 'Brewton', '', 'Escambia', CURRVAL('actor.usr_id_seq'));
1524 INSERT INTO actor.card (barcode, usr)
1525 VALUES ('99999354471', CURRVAL('actor.usr_id_seq'));
1527 UPDATE actor.usr SET
1528 card = CURRVAL('actor.card_id_seq'),
1529 billing_address = CURRVAL('actor.usr_address_id_seq'),
1530 credit_forward_balance = '0',
1531 mailing_address = CURRVAL('actor.usr_address_id_seq')
1532 WHERE id=CURRVAL('actor.usr_id_seq');
1534 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1535 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1537 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1538 FROM actor.org_unit aou
1539 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1541 INSERT INTO actor.usr
1542 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1543 VALUES (10, 3, 'ethompson', 6, 'Thompson', 'elvint1234',
1544 'Elvin', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1546 INSERT INTO actor.usr_address
1547 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1548 VALUES ('USA', 't', '67664', '2800 Cheerful Animal Valley', 't',
1549 'KS', 'Prairie view', '', '', CURRVAL('actor.usr_id_seq'));
1551 INSERT INTO actor.card (barcode, usr)
1552 VALUES ('99999320974', CURRVAL('actor.usr_id_seq'));
1554 UPDATE actor.usr SET
1555 card = CURRVAL('actor.card_id_seq'),
1556 billing_address = CURRVAL('actor.usr_address_id_seq'),
1557 credit_forward_balance = '0',
1558 mailing_address = CURRVAL('actor.usr_address_id_seq')
1559 WHERE id=CURRVAL('actor.usr_id_seq');
1561 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1562 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1564 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1565 FROM actor.org_unit aou
1566 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1568 INSERT INTO actor.usr
1569 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1570 VALUES (10, 1, 'dlawson', 5, 'Lawson', 'doral1234',
1571 'Dora', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1573 INSERT INTO actor.usr_address
1574 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1575 VALUES ('USA', 'f', '63957', '6016 General Dog Divide', 't',
1576 'MO', 'Piedmont', '', 'Wayne', CURRVAL('actor.usr_id_seq'));
1578 INSERT INTO actor.card (barcode, usr)
1579 VALUES ('99999394437', CURRVAL('actor.usr_id_seq'));
1581 UPDATE actor.usr SET
1582 card = CURRVAL('actor.card_id_seq'),
1583 billing_address = CURRVAL('actor.usr_address_id_seq'),
1584 credit_forward_balance = '0',
1585 mailing_address = CURRVAL('actor.usr_address_id_seq')
1586 WHERE id=CURRVAL('actor.usr_id_seq');
1588 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1589 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1591 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1592 FROM actor.org_unit aou
1593 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1595 INSERT INTO actor.usr
1596 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1597 VALUES (10, 1, 'lvargas', 5, 'Vargas', 'laurav1234',
1598 'Laura', 'Mildred', NOW() + '3 years'::INTERVAL, '1989-07-04', 'III');
1600 INSERT INTO actor.usr_address
1601 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1602 VALUES ('USA', 't', '62526', '4689 Alert Minute Court', 't',
1603 'IL', 'Decatur', '', '', CURRVAL('actor.usr_id_seq'));
1605 INSERT INTO actor.card (barcode, usr)
1606 VALUES ('99999317988', CURRVAL('actor.usr_id_seq'));
1608 UPDATE actor.usr SET
1609 card = CURRVAL('actor.card_id_seq'),
1610 billing_address = CURRVAL('actor.usr_address_id_seq'),
1611 credit_forward_balance = '0',
1612 mailing_address = CURRVAL('actor.usr_address_id_seq')
1613 WHERE id=CURRVAL('actor.usr_id_seq');
1615 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1616 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1618 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1619 FROM actor.org_unit aou
1620 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1622 INSERT INTO actor.usr
1623 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1624 VALUES (10, 3, 'wrandall', 4, 'Randall', 'williamr1234',
1625 'William', 'James', NOW() + '3 years'::INTERVAL, NULL, NULL);
1627 INSERT INTO actor.usr_address
1628 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1629 VALUES ('USA', 'f', '72117', '3448 Minor Solicitor Junction', 't',
1630 'AR', 'North little rock', '', '', CURRVAL('actor.usr_id_seq'));
1632 INSERT INTO actor.card (barcode, usr)
1633 VALUES ('99999393617', CURRVAL('actor.usr_id_seq'));
1635 UPDATE actor.usr SET
1636 card = CURRVAL('actor.card_id_seq'),
1637 billing_address = CURRVAL('actor.usr_address_id_seq'),
1638 credit_forward_balance = '0',
1639 mailing_address = CURRVAL('actor.usr_address_id_seq')
1640 WHERE id=CURRVAL('actor.usr_id_seq');
1642 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1643 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1645 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1646 FROM actor.org_unit aou
1647 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1649 INSERT INTO actor.usr
1650 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1651 VALUES (10, 1, 'csmith', 4, 'Smith', 'cathys1234',
1652 'Cathy', 'Cheryl', NOW() + '3 years'::INTERVAL, NULL, NULL);
1654 INSERT INTO actor.usr_address
1655 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1656 VALUES ('USA', 'f', '81420', '784 Striking Theatre Fords', 't',
1657 'CO', 'Lazear', '', 'Delta', CURRVAL('actor.usr_id_seq'));
1659 INSERT INTO actor.card (barcode, usr)
1660 VALUES ('99999389406', CURRVAL('actor.usr_id_seq'));
1662 UPDATE actor.usr SET
1663 card = CURRVAL('actor.card_id_seq'),
1664 billing_address = CURRVAL('actor.usr_address_id_seq'),
1665 credit_forward_balance = '0',
1666 mailing_address = CURRVAL('actor.usr_address_id_seq')
1667 WHERE id=CURRVAL('actor.usr_id_seq');
1669 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1670 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1672 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1673 FROM actor.org_unit aou
1674 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1676 INSERT INTO actor.usr
1677 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1678 VALUES (9, 1, 'alopez', 9, 'Lopez', 'arlinel1234',
1679 'Arline', 'Amber', NOW() + '3 years'::INTERVAL, '1985-05-05', 'III');
1681 INSERT INTO actor.usr_address
1682 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1683 VALUES ('USA', 't', '19053', '5012 Unemployed Other Harbor', 't',
1684 'PA', 'Feasterville trevose', '', 'Bucks', CURRVAL('actor.usr_id_seq'));
1686 INSERT INTO actor.card (barcode, usr)
1687 VALUES ('99999330939', CURRVAL('actor.usr_id_seq'));
1689 UPDATE actor.usr SET
1690 card = CURRVAL('actor.card_id_seq'),
1691 billing_address = CURRVAL('actor.usr_address_id_seq'),
1692 credit_forward_balance = '0',
1693 mailing_address = CURRVAL('actor.usr_address_id_seq')
1694 WHERE id=CURRVAL('actor.usr_id_seq');
1696 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1697 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1699 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1700 FROM actor.org_unit aou
1701 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1703 INSERT INTO actor.usr
1704 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1705 VALUES (9, 1, 'epeterson', 9, 'Peterson', 'emmap1234',
1706 'Emma', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1708 INSERT INTO actor.usr_address
1709 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1710 VALUES ('USA', 't', '07095', '9931 Hushed Passage Turnpike', 't',
1711 'NJ', 'Woodbridge', '', 'Middlesex', CURRVAL('actor.usr_id_seq'));
1713 INSERT INTO actor.card (barcode, usr)
1714 VALUES ('99999346297', CURRVAL('actor.usr_id_seq'));
1716 UPDATE actor.usr SET
1717 card = CURRVAL('actor.card_id_seq'),
1718 billing_address = CURRVAL('actor.usr_address_id_seq'),
1719 credit_forward_balance = '0',
1720 mailing_address = CURRVAL('actor.usr_address_id_seq')
1721 WHERE id=CURRVAL('actor.usr_id_seq');
1723 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1724 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1726 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1727 FROM actor.org_unit aou
1728 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1730 INSERT INTO actor.usr
1731 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1732 VALUES (9, 1, 'okelly', 8, 'Kelly', 'opalk1234',
1733 'Opal', 'Sara', NOW() + '3 years'::INTERVAL, '1975-01-18', 'III');
1735 INSERT INTO actor.usr_address
1736 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1737 VALUES ('USA', 't', '79550', '8572 Ltd Bar Brook', 't',
1738 'TX', 'Snyder', '', 'Scurry', CURRVAL('actor.usr_id_seq'));
1740 INSERT INTO actor.card (barcode, usr)
1741 VALUES ('99999355455', CURRVAL('actor.usr_id_seq'));
1743 UPDATE actor.usr SET
1744 card = CURRVAL('actor.card_id_seq'),
1745 billing_address = CURRVAL('actor.usr_address_id_seq'),
1746 credit_forward_balance = '0',
1747 mailing_address = CURRVAL('actor.usr_address_id_seq')
1748 WHERE id=CURRVAL('actor.usr_id_seq');
1750 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1751 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1753 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1754 FROM actor.org_unit aou
1755 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1757 INSERT INTO actor.usr
1758 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1759 VALUES (9, 1, 'cdonovan', 8, 'Donovan', 'charlied1234',
1760 'Charlie', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL);
1762 INSERT INTO actor.usr_address
1763 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1764 VALUES ('USA', 'f', '54017', '1926 Double Effort Spring', 't',
1765 'WI', 'New richmond', '', '', CURRVAL('actor.usr_id_seq'));
1767 INSERT INTO actor.card (barcode, usr)
1768 VALUES ('99999348978', CURRVAL('actor.usr_id_seq'));
1770 UPDATE actor.usr SET
1771 card = CURRVAL('actor.card_id_seq'),
1772 billing_address = CURRVAL('actor.usr_address_id_seq'),
1773 credit_forward_balance = '0',
1774 mailing_address = CURRVAL('actor.usr_address_id_seq')
1775 WHERE id=CURRVAL('actor.usr_id_seq');
1777 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1778 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1780 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1781 FROM actor.org_unit aou
1782 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1784 INSERT INTO actor.usr
1785 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1786 VALUES (9, 3, 'msmith', 7, 'Smith', 'marthas1234',
1787 'Martha', 'Raquel', NOW() + '3 years'::INTERVAL, NULL, NULL);
1789 INSERT INTO actor.usr_address
1790 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1791 VALUES ('USA', 'f', '80534', '7185 Arbitrary Contrast Freeway', 't',
1792 'CO', 'Johnstown', '', 'Weld', CURRVAL('actor.usr_id_seq'));
1794 INSERT INTO actor.card (barcode, usr)
1795 VALUES ('99999394964', CURRVAL('actor.usr_id_seq'));
1797 UPDATE actor.usr SET
1798 card = CURRVAL('actor.card_id_seq'),
1799 billing_address = CURRVAL('actor.usr_address_id_seq'),
1800 credit_forward_balance = '0',
1801 mailing_address = CURRVAL('actor.usr_address_id_seq')
1802 WHERE id=CURRVAL('actor.usr_id_seq');
1804 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1805 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1807 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1808 FROM actor.org_unit aou
1809 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1811 INSERT INTO actor.usr
1812 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1813 VALUES (9, 3, 'chouston', 7, 'Houston', 'cherylh1234',
1814 'Cheryl', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1816 INSERT INTO actor.usr_address
1817 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1818 VALUES ('USA', 't', '93703', '2782 Awake Day Square', 't',
1819 'CA', 'Fresno', '', 'Fresno', CURRVAL('actor.usr_id_seq'));
1821 INSERT INTO actor.card (barcode, usr)
1822 VALUES ('99999320969', CURRVAL('actor.usr_id_seq'));
1824 UPDATE actor.usr SET
1825 card = CURRVAL('actor.card_id_seq'),
1826 billing_address = CURRVAL('actor.usr_address_id_seq'),
1827 credit_forward_balance = '0',
1828 mailing_address = CURRVAL('actor.usr_address_id_seq')
1829 WHERE id=CURRVAL('actor.usr_id_seq');
1831 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1832 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1834 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1835 FROM actor.org_unit aou
1836 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1838 INSERT INTO actor.usr
1839 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1840 VALUES (9, 1, 'kwright', 6, 'Wright', 'kayw1234',
1841 'Kay', 'Anna', NOW() + '3 years'::INTERVAL, NULL, NULL);
1843 INSERT INTO actor.usr_address
1844 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1845 VALUES ('USA', 'f', '22834', '4585 Whole Harbor', 't',
1846 'VA', 'Linville', '', '', CURRVAL('actor.usr_id_seq'));
1848 INSERT INTO actor.card (barcode, usr)
1849 VALUES ('99999398195', CURRVAL('actor.usr_id_seq'));
1851 UPDATE actor.usr SET
1852 card = CURRVAL('actor.card_id_seq'),
1853 billing_address = CURRVAL('actor.usr_address_id_seq'),
1854 credit_forward_balance = '0',
1855 mailing_address = CURRVAL('actor.usr_address_id_seq')
1856 WHERE id=CURRVAL('actor.usr_id_seq');
1858 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1859 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1861 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1862 FROM actor.org_unit aou
1863 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1865 INSERT INTO actor.usr
1866 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1867 VALUES (9, 3, 'mlane', 6, 'Lane', 'michellel1234',
1868 'Michelle', 'Andrea', NOW() + '3 years'::INTERVAL, '1963-06-14', 'Sr');
1870 INSERT INTO actor.usr_address
1871 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1872 VALUES ('USA', 't', '98110', '8676 Thundering Loss Field', 't',
1873 'WA', 'Bainbridge island', '', 'Kitsap', CURRVAL('actor.usr_id_seq'));
1875 INSERT INTO actor.card (barcode, usr)
1876 VALUES ('99999333153', CURRVAL('actor.usr_id_seq'));
1878 UPDATE actor.usr SET
1879 card = CURRVAL('actor.card_id_seq'),
1880 billing_address = CURRVAL('actor.usr_address_id_seq'),
1881 credit_forward_balance = '0',
1882 mailing_address = CURRVAL('actor.usr_address_id_seq')
1883 WHERE id=CURRVAL('actor.usr_id_seq');
1885 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1886 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1888 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1889 FROM actor.org_unit aou
1890 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1892 INSERT INTO actor.usr
1893 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1894 VALUES (9, 1, 'rsmith', 5, 'Smith', 'roberts1234',
1895 'Robert', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1897 INSERT INTO actor.usr_address
1898 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1899 VALUES ('USA', 't', '00983', '231 Causal Expert Highway', 't',
1900 'PR', 'Carolina', '', 'Carolina', CURRVAL('actor.usr_id_seq'));
1902 INSERT INTO actor.card (barcode, usr)
1903 VALUES ('99999362675', CURRVAL('actor.usr_id_seq'));
1905 UPDATE actor.usr SET
1906 card = CURRVAL('actor.card_id_seq'),
1907 billing_address = CURRVAL('actor.usr_address_id_seq'),
1908 credit_forward_balance = '0',
1909 mailing_address = CURRVAL('actor.usr_address_id_seq')
1910 WHERE id=CURRVAL('actor.usr_id_seq');
1912 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1913 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1915 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1916 FROM actor.org_unit aou
1917 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1919 INSERT INTO actor.usr
1920 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1921 VALUES (9, 1, 'cdodson', 5, 'Dodson', 'cleod1234',
1922 'Cleo', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1924 INSERT INTO actor.usr_address
1925 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1926 VALUES ('USA', 't', '25266', '53 Nice Customer Green', 't',
1927 'WV', 'Newton', '', 'Roane', CURRVAL('actor.usr_id_seq'));
1929 INSERT INTO actor.card (barcode, usr)
1930 VALUES ('99999362218', CURRVAL('actor.usr_id_seq'));
1932 UPDATE actor.usr SET
1933 card = CURRVAL('actor.card_id_seq'),
1934 billing_address = CURRVAL('actor.usr_address_id_seq'),
1935 credit_forward_balance = '0',
1936 mailing_address = CURRVAL('actor.usr_address_id_seq')
1937 WHERE id=CURRVAL('actor.usr_id_seq');
1939 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1940 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1942 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1943 FROM actor.org_unit aou
1944 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1946 INSERT INTO actor.usr
1947 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1948 VALUES (9, 1, 'mneal', 4, 'Neal', 'melvinn1234',
1949 'Melvin', 'Richard', NOW() + '3 years'::INTERVAL, NULL, NULL);
1951 INSERT INTO actor.usr_address
1952 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1953 VALUES ('USA', 't', '10150', '668 Unconscious Gun Spring', 't',
1954 'NY', 'New york', '', 'New york', CURRVAL('actor.usr_id_seq'));
1956 INSERT INTO actor.card (barcode, usr)
1957 VALUES ('99999317310', CURRVAL('actor.usr_id_seq'));
1959 UPDATE actor.usr SET
1960 card = CURRVAL('actor.card_id_seq'),
1961 billing_address = CURRVAL('actor.usr_address_id_seq'),
1962 credit_forward_balance = '0',
1963 mailing_address = CURRVAL('actor.usr_address_id_seq')
1964 WHERE id=CURRVAL('actor.usr_id_seq');
1966 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1967 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1969 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1970 FROM actor.org_unit aou
1971 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1973 INSERT INTO actor.usr
1974 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1975 VALUES (9, 3, 'awilliams', 4, 'Williams', 'annaw1234',
1976 'Anna', 'Justine', NOW() + '3 years'::INTERVAL, NULL, NULL);
1978 INSERT INTO actor.usr_address
1979 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1980 VALUES ('USA', 'f', '45809', '749 Software Center', 't',
1981 'OH', 'Gomer', '', 'Allen', CURRVAL('actor.usr_id_seq'));
1983 INSERT INTO actor.card (barcode, usr)
1984 VALUES ('99999392361', CURRVAL('actor.usr_id_seq'));
1986 UPDATE actor.usr SET
1987 card = CURRVAL('actor.card_id_seq'),
1988 billing_address = CURRVAL('actor.usr_address_id_seq'),
1989 credit_forward_balance = '0',
1990 mailing_address = CURRVAL('actor.usr_address_id_seq')
1991 WHERE id=CURRVAL('actor.usr_id_seq');
1993 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1994 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1996 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1997 FROM actor.org_unit aou
1998 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2000 INSERT INTO actor.usr
2001 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2002 VALUES (8, 1, 'emiller', 9, 'Miller', 'edmondm1234',
2003 'Edmond', 'Vance', NOW() + '3 years'::INTERVAL, NULL, NULL);
2005 INSERT INTO actor.usr_address
2006 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2007 VALUES ('USA', 'f', '92007', '2632 Unlikely Assumption Tunnel', 't',
2008 'CA', 'Cardiff by the sea', '', 'San diego', CURRVAL('actor.usr_id_seq'));
2010 INSERT INTO actor.card (barcode, usr)
2011 VALUES ('99999371777', CURRVAL('actor.usr_id_seq'));
2013 UPDATE actor.usr SET
2014 card = CURRVAL('actor.card_id_seq'),
2015 billing_address = CURRVAL('actor.usr_address_id_seq'),
2016 credit_forward_balance = '0',
2017 mailing_address = CURRVAL('actor.usr_address_id_seq')
2018 WHERE id=CURRVAL('actor.usr_id_seq');
2020 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2021 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2023 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2024 FROM actor.org_unit aou
2025 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2027 INSERT INTO actor.usr
2028 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2029 VALUES (8, 3, 'vlogan', 9, 'Logan', 'vanessal1234',
2030 'Vanessa', 'Cassandra', NOW() + '3 years'::INTERVAL, NULL, NULL);
2032 INSERT INTO actor.usr_address
2033 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2034 VALUES ('USA', 'f', '44470', '2823 Eventual Hour Gateway', 't',
2035 'OH', 'Southington', '', 'Trumbull', CURRVAL('actor.usr_id_seq'));
2037 INSERT INTO actor.card (barcode, usr)
2038 VALUES ('99999372363', CURRVAL('actor.usr_id_seq'));
2040 UPDATE actor.usr SET
2041 card = CURRVAL('actor.card_id_seq'),
2042 billing_address = CURRVAL('actor.usr_address_id_seq'),
2043 credit_forward_balance = '0',
2044 mailing_address = CURRVAL('actor.usr_address_id_seq')
2045 WHERE id=CURRVAL('actor.usr_id_seq');
2047 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2048 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2050 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2051 FROM actor.org_unit aou
2052 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2054 INSERT INTO actor.usr
2055 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2056 VALUES (8, 1, 'lthompson', 8, 'Thompson', 'lisat1234',
2057 'Lisa', 'Shirley', NOW() + '3 years'::INTERVAL, NULL, NULL);
2059 INSERT INTO actor.usr_address
2060 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2061 VALUES ('USA', 'f', '45690', '2166 Newspaper Grove', 't',
2062 'OH', 'Waverly', '', 'Pike', CURRVAL('actor.usr_id_seq'));
2064 INSERT INTO actor.card (barcode, usr)
2065 VALUES ('99999321149', CURRVAL('actor.usr_id_seq'));
2067 UPDATE actor.usr SET
2068 card = CURRVAL('actor.card_id_seq'),
2069 billing_address = CURRVAL('actor.usr_address_id_seq'),
2070 credit_forward_balance = '0',
2071 mailing_address = CURRVAL('actor.usr_address_id_seq')
2072 WHERE id=CURRVAL('actor.usr_id_seq');
2074 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2075 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2077 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2078 FROM actor.org_unit aou
2079 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2081 INSERT INTO actor.usr
2082 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2083 VALUES (8, 1, 'oshaffer', 8, 'Shaffer', 'ollies1234',
2084 'Ollie', 'Monica', NOW() + '3 years'::INTERVAL, NULL, NULL);
2086 INSERT INTO actor.usr_address
2087 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2088 VALUES ('USA', 't', '15534', '2134 Inc Boat Turnpike', 't',
2089 'PA', 'Buffalo mills', '', 'Bedford', CURRVAL('actor.usr_id_seq'));
2091 INSERT INTO actor.card (barcode, usr)
2092 VALUES ('99999335455', CURRVAL('actor.usr_id_seq'));
2094 UPDATE actor.usr SET
2095 card = CURRVAL('actor.card_id_seq'),
2096 billing_address = CURRVAL('actor.usr_address_id_seq'),
2097 credit_forward_balance = '0',
2098 mailing_address = CURRVAL('actor.usr_address_id_seq')
2099 WHERE id=CURRVAL('actor.usr_id_seq');
2101 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2102 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2104 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2105 FROM actor.org_unit aou
2106 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2108 INSERT INTO actor.usr
2109 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2110 VALUES (8, 1, 'randrews', 7, 'Andrews', 'raymonda1234',
2111 'Raymond', 'Willie', NOW() + '3 years'::INTERVAL, NULL, NULL);
2113 INSERT INTO actor.usr_address
2114 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2115 VALUES ('USA', 'f', '06018', '1944 Hot Tape Valley', 't',
2116 'CT', 'Canaan', '', '', CURRVAL('actor.usr_id_seq'));
2118 INSERT INTO actor.card (barcode, usr)
2119 VALUES ('99999346031', CURRVAL('actor.usr_id_seq'));
2121 UPDATE actor.usr SET
2122 card = CURRVAL('actor.card_id_seq'),
2123 billing_address = CURRVAL('actor.usr_address_id_seq'),
2124 credit_forward_balance = '0',
2125 mailing_address = CURRVAL('actor.usr_address_id_seq')
2126 WHERE id=CURRVAL('actor.usr_id_seq');
2128 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2129 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2131 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2132 FROM actor.org_unit aou
2133 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2135 INSERT INTO actor.usr
2136 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2137 VALUES (8, 3, 'emartinez', 7, 'Martinez', 'ednam1234',
2138 'Edna', 'Judith', NOW() + '3 years'::INTERVAL, NULL, NULL);
2140 INSERT INTO actor.usr_address
2141 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2142 VALUES ('USA', 't', '49270', '121 Consequence Club', 't',
2143 'MI', 'Petersburg', '', '', CURRVAL('actor.usr_id_seq'));
2145 INSERT INTO actor.card (barcode, usr)
2146 VALUES ('99999336926', CURRVAL('actor.usr_id_seq'));
2148 UPDATE actor.usr SET
2149 card = CURRVAL('actor.card_id_seq'),
2150 billing_address = CURRVAL('actor.usr_address_id_seq'),
2151 credit_forward_balance = '0',
2152 mailing_address = CURRVAL('actor.usr_address_id_seq')
2153 WHERE id=CURRVAL('actor.usr_id_seq');
2155 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2156 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2158 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2159 FROM actor.org_unit aou
2160 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2162 INSERT INTO actor.usr
2163 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2164 VALUES (8, 3, 'jdavis', 6, 'Davis', 'jamesd1234',
2165 'James', 'Jerry', NOW() + '3 years'::INTERVAL, '1970-06-11', 'III');
2167 INSERT INTO actor.usr_address
2168 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2169 VALUES ('USA', 'f', '58064', '5708 Brainy West Bend', 't',
2170 'ND', 'Page', '', 'Cass', CURRVAL('actor.usr_id_seq'));
2172 INSERT INTO actor.card (barcode, usr)
2173 VALUES ('99999363070', CURRVAL('actor.usr_id_seq'));
2175 UPDATE actor.usr SET
2176 card = CURRVAL('actor.card_id_seq'),
2177 billing_address = CURRVAL('actor.usr_address_id_seq'),
2178 credit_forward_balance = '0',
2179 mailing_address = CURRVAL('actor.usr_address_id_seq')
2180 WHERE id=CURRVAL('actor.usr_id_seq');
2182 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2183 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2185 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2186 FROM actor.org_unit aou
2187 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2189 INSERT INTO actor.usr
2190 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2191 VALUES (8, 1, 'droberts', 6, 'Roberts', 'dianer1234',
2192 'Diane', 'Teresa', NOW() + '3 years'::INTERVAL, NULL, NULL);
2194 INSERT INTO actor.usr_address
2195 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2196 VALUES ('USA', 'f', '00692', '9609 Advanced Tool Mountain', 't',
2197 'PR', 'Vega alta', '', 'Vega alta', CURRVAL('actor.usr_id_seq'));
2199 INSERT INTO actor.card (barcode, usr)
2200 VALUES ('99999357381', CURRVAL('actor.usr_id_seq'));
2202 UPDATE actor.usr SET
2203 card = CURRVAL('actor.card_id_seq'),
2204 billing_address = CURRVAL('actor.usr_address_id_seq'),
2205 credit_forward_balance = '0',
2206 mailing_address = CURRVAL('actor.usr_address_id_seq')
2207 WHERE id=CURRVAL('actor.usr_id_seq');
2209 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2210 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2212 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2213 FROM actor.org_unit aou
2214 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2216 INSERT INTO actor.usr
2217 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2218 VALUES (8, 1, 'psantiago', 5, 'Santiago', 'paiges1234',
2219 'Paige', 'Helen', NOW() + '3 years'::INTERVAL, '1979-08-23', 'Sr');
2221 INSERT INTO actor.usr_address
2222 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2223 VALUES ('USA', 't', '91608', '2852 Key Incident Avenue', 't',
2224 'CA', 'Universal city', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
2226 INSERT INTO actor.card (barcode, usr)
2227 VALUES ('99999394956', CURRVAL('actor.usr_id_seq'));
2229 UPDATE actor.usr SET
2230 card = CURRVAL('actor.card_id_seq'),
2231 billing_address = CURRVAL('actor.usr_address_id_seq'),
2232 credit_forward_balance = '0',
2233 mailing_address = CURRVAL('actor.usr_address_id_seq')
2234 WHERE id=CURRVAL('actor.usr_id_seq');
2236 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2237 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2239 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2240 FROM actor.org_unit aou
2241 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2243 INSERT INTO actor.usr
2244 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2245 VALUES (8, 1, 'awright', 5, 'Wright', 'alyssaw1234',
2246 'Alyssa', 'Christine', NOW() + '3 years'::INTERVAL, NULL, NULL);
2248 INSERT INTO actor.usr_address
2249 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2250 VALUES ('USA', 't', '80295', '7771 Alive Iron Mission', 't',
2251 'CO', 'Denver', '', 'Denver', CURRVAL('actor.usr_id_seq'));
2253 INSERT INTO actor.card (barcode, usr)
2254 VALUES ('99999367802', CURRVAL('actor.usr_id_seq'));
2256 UPDATE actor.usr SET
2257 card = CURRVAL('actor.card_id_seq'),
2258 billing_address = CURRVAL('actor.usr_address_id_seq'),
2259 credit_forward_balance = '0',
2260 mailing_address = CURRVAL('actor.usr_address_id_seq')
2261 WHERE id=CURRVAL('actor.usr_id_seq');
2263 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2264 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2266 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2267 FROM actor.org_unit aou
2268 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2270 INSERT INTO actor.usr
2271 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2272 VALUES (8, 3, 'dbeck', 4, 'Beck', 'dianab1234',
2273 'Diana', 'Wilma', NOW() + '3 years'::INTERVAL, NULL, NULL);
2275 INSERT INTO actor.usr_address
2276 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2277 VALUES ('USA', 't', '58776', '1146 Ability Centers', 't',
2278 'ND', 'Ross', '', 'Mountrail', CURRVAL('actor.usr_id_seq'));
2280 INSERT INTO actor.card (barcode, usr)
2281 VALUES ('99999361901', CURRVAL('actor.usr_id_seq'));
2283 UPDATE actor.usr SET
2284 card = CURRVAL('actor.card_id_seq'),
2285 billing_address = CURRVAL('actor.usr_address_id_seq'),
2286 credit_forward_balance = '0',
2287 mailing_address = CURRVAL('actor.usr_address_id_seq')
2288 WHERE id=CURRVAL('actor.usr_id_seq');
2290 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2291 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2293 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2294 FROM actor.org_unit aou
2295 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2297 INSERT INTO actor.usr
2298 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2299 VALUES (8, 1, 'mclark', 4, 'Clark', 'montyc1234',
2300 'Monty', 'Daniel', NOW() + '3 years'::INTERVAL, '1984-05-19', 'II');
2302 INSERT INTO actor.usr_address
2303 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2304 VALUES ('USA', 't', '55168', '3541 Radical Sir Avenue', 't',
2305 'MN', 'Saint paul', '', 'Ramsey', CURRVAL('actor.usr_id_seq'));
2307 INSERT INTO actor.card (barcode, usr)
2308 VALUES ('99999381970', CURRVAL('actor.usr_id_seq'));
2310 UPDATE actor.usr SET
2311 card = CURRVAL('actor.card_id_seq'),
2312 billing_address = CURRVAL('actor.usr_address_id_seq'),
2313 credit_forward_balance = '0',
2314 mailing_address = CURRVAL('actor.usr_address_id_seq')
2315 WHERE id=CURRVAL('actor.usr_id_seq');
2317 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2318 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2320 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2321 FROM actor.org_unit aou
2322 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2324 INSERT INTO actor.usr
2325 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2326 VALUES (7, 3, 'hstone', 9, 'Stone', 'hazels1234',
2327 'Hazel', 'Sylvia', NOW() + '3 years'::INTERVAL, NULL, NULL);
2329 INSERT INTO actor.usr_address
2330 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2331 VALUES ('USA', 't', '93247', '4171 Impossible Defence Overpass', 't',
2332 'CA', 'Lindsay', '', '', CURRVAL('actor.usr_id_seq'));
2334 INSERT INTO actor.card (barcode, usr)
2335 VALUES ('99999367834', CURRVAL('actor.usr_id_seq'));
2337 UPDATE actor.usr SET
2338 card = CURRVAL('actor.card_id_seq'),
2339 billing_address = CURRVAL('actor.usr_address_id_seq'),
2340 credit_forward_balance = '0',
2341 mailing_address = CURRVAL('actor.usr_address_id_seq')
2342 WHERE id=CURRVAL('actor.usr_id_seq');
2344 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2345 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2347 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2348 FROM actor.org_unit aou
2349 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2351 INSERT INTO actor.usr
2352 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2353 VALUES (7, 1, 'dgarza', 9, 'Garza', 'davidg1234',
2354 'David', 'Steven', NOW() + '3 years'::INTERVAL, NULL, NULL);
2356 INSERT INTO actor.usr_address
2357 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2358 VALUES ('USA', 't', '22513', '3627 Retail Kind Lodge', 't',
2359 'VA', 'Merry point', '', 'Lancaster', CURRVAL('actor.usr_id_seq'));
2361 INSERT INTO actor.card (barcode, usr)
2362 VALUES ('99999377760', CURRVAL('actor.usr_id_seq'));
2364 UPDATE actor.usr SET
2365 card = CURRVAL('actor.card_id_seq'),
2366 billing_address = CURRVAL('actor.usr_address_id_seq'),
2367 credit_forward_balance = '0',
2368 mailing_address = CURRVAL('actor.usr_address_id_seq')
2369 WHERE id=CURRVAL('actor.usr_id_seq');
2371 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2372 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2374 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2375 FROM actor.org_unit aou
2376 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2378 INSERT INTO actor.usr
2379 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2380 VALUES (7, 3, 'jevans', 8, 'Evans', 'johne1234',
2381 'John', 'Timothy', NOW() + '3 years'::INTERVAL, NULL, NULL);
2383 INSERT INTO actor.usr_address
2384 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2385 VALUES ('USA', 't', '64778', '1212 Mid Top Parkway', 't',
2386 'MO', 'Richards', '', 'Vernon', CURRVAL('actor.usr_id_seq'));
2388 INSERT INTO actor.card (barcode, usr)
2389 VALUES ('99999367573', CURRVAL('actor.usr_id_seq'));
2391 UPDATE actor.usr SET
2392 card = CURRVAL('actor.card_id_seq'),
2393 billing_address = CURRVAL('actor.usr_address_id_seq'),
2394 credit_forward_balance = '0',
2395 mailing_address = CURRVAL('actor.usr_address_id_seq')
2396 WHERE id=CURRVAL('actor.usr_id_seq');
2398 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2399 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2401 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2402 FROM actor.org_unit aou
2403 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2405 INSERT INTO actor.usr
2406 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2407 VALUES (7, 3, 'rpayton', 8, 'Payton', 'robertp1234',
2408 'Robert', 'Steven', NOW() + '3 years'::INTERVAL, '1994-05-07', 'Jr');
2410 INSERT INTO actor.usr_address
2411 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2412 VALUES ('USA', 't', '55336', '1642 Minor Potential Corners', 't',
2413 'MN', 'Glencoe', '', '', CURRVAL('actor.usr_id_seq'));
2415 INSERT INTO actor.card (barcode, usr)
2416 VALUES ('99999394830', CURRVAL('actor.usr_id_seq'));
2418 UPDATE actor.usr SET
2419 card = CURRVAL('actor.card_id_seq'),
2420 billing_address = CURRVAL('actor.usr_address_id_seq'),
2421 credit_forward_balance = '0',
2422 mailing_address = CURRVAL('actor.usr_address_id_seq')
2423 WHERE id=CURRVAL('actor.usr_id_seq');
2425 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2426 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2428 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2429 FROM actor.org_unit aou
2430 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2432 INSERT INTO actor.usr
2433 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2434 VALUES (7, 3, 'ddavis', 7, 'Davis', 'donaldd1234',
2435 'Donald', 'Gene', NOW() + '3 years'::INTERVAL, NULL, NULL);
2437 INSERT INTO actor.usr_address
2438 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2439 VALUES ('USA', 'f', '48749', '5946 Gas Way', 't',
2440 'MI', 'Omer', '', 'Arenac', CURRVAL('actor.usr_id_seq'));
2442 INSERT INTO actor.card (barcode, usr)
2443 VALUES ('99999340278', CURRVAL('actor.usr_id_seq'));
2445 UPDATE actor.usr SET
2446 card = CURRVAL('actor.card_id_seq'),
2447 billing_address = CURRVAL('actor.usr_address_id_seq'),
2448 credit_forward_balance = '0',
2449 mailing_address = CURRVAL('actor.usr_address_id_seq')
2450 WHERE id=CURRVAL('actor.usr_id_seq');
2452 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2453 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2455 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2456 FROM actor.org_unit aou
2457 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2459 INSERT INTO actor.usr
2460 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2461 VALUES (7, 1, 'gadams', 7, 'Adams', 'genea1234',
2462 'Gene', '', NOW() + '3 years'::INTERVAL, '1974-02-18', 'III');
2464 INSERT INTO actor.usr_address
2465 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2466 VALUES ('USA', 't', '88525', '8265 Phone Trail', 't',
2467 'TX', 'El paso', '', 'El paso', CURRVAL('actor.usr_id_seq'));
2469 INSERT INTO actor.card (barcode, usr)
2470 VALUES ('99999349290', CURRVAL('actor.usr_id_seq'));
2472 UPDATE actor.usr SET
2473 card = CURRVAL('actor.card_id_seq'),
2474 billing_address = CURRVAL('actor.usr_address_id_seq'),
2475 credit_forward_balance = '0',
2476 mailing_address = CURRVAL('actor.usr_address_id_seq')
2477 WHERE id=CURRVAL('actor.usr_id_seq');
2479 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2480 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2482 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2483 FROM actor.org_unit aou
2484 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2486 INSERT INTO actor.usr
2487 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2488 VALUES (7, 1, 'hwhite', 6, 'White', 'humbertow1234',
2489 'Humberto', 'Kevin', NOW() + '3 years'::INTERVAL, '1997-09-08', 'Jr');
2491 INSERT INTO actor.usr_address
2492 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2493 VALUES ('USA', 'f', '25926', '6558 Willing Master Valley', 't',
2494 'WV', 'Sprague', '', '', CURRVAL('actor.usr_id_seq'));
2496 INSERT INTO actor.card (barcode, usr)
2497 VALUES ('99999309750', CURRVAL('actor.usr_id_seq'));
2499 UPDATE actor.usr SET
2500 card = CURRVAL('actor.card_id_seq'),
2501 billing_address = CURRVAL('actor.usr_address_id_seq'),
2502 credit_forward_balance = '0',
2503 mailing_address = CURRVAL('actor.usr_address_id_seq')
2504 WHERE id=CURRVAL('actor.usr_id_seq');
2506 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2507 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2509 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2510 FROM actor.org_unit aou
2511 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2513 INSERT INTO actor.usr
2514 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2515 VALUES (7, 3, 'asnyder', 6, 'Snyder', 'anas1234',
2516 'Ana', '', NOW() + '3 years'::INTERVAL, '1991-05-23', 'III');
2518 INSERT INTO actor.usr_address
2519 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2520 VALUES ('USA', 't', '00922', '8532 Spare Offer Cliffs', 't',
2521 'PR', 'San juan', '', 'San juan', CURRVAL('actor.usr_id_seq'));
2523 INSERT INTO actor.card (barcode, usr)
2524 VALUES ('99999332335', CURRVAL('actor.usr_id_seq'));
2526 UPDATE actor.usr SET
2527 card = CURRVAL('actor.card_id_seq'),
2528 billing_address = CURRVAL('actor.usr_address_id_seq'),
2529 credit_forward_balance = '0',
2530 mailing_address = CURRVAL('actor.usr_address_id_seq')
2531 WHERE id=CURRVAL('actor.usr_id_seq');
2533 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2534 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2536 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2537 FROM actor.org_unit aou
2538 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2540 INSERT INTO actor.usr
2541 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2542 VALUES (7, 1, 'jroberts', 5, 'Roberts', 'johnr1234',
2543 'John', 'Theodore', NOW() + '3 years'::INTERVAL, NULL, NULL);
2545 INSERT INTO actor.usr_address
2546 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2547 VALUES ('USA', 'f', '79550', '279 Passing Conference Street', 't',
2548 'TX', 'Snyder', '', 'Scurry', CURRVAL('actor.usr_id_seq'));
2550 INSERT INTO actor.card (barcode, usr)
2551 VALUES ('99999367122', CURRVAL('actor.usr_id_seq'));
2553 UPDATE actor.usr SET
2554 card = CURRVAL('actor.card_id_seq'),
2555 billing_address = CURRVAL('actor.usr_address_id_seq'),
2556 credit_forward_balance = '0',
2557 mailing_address = CURRVAL('actor.usr_address_id_seq')
2558 WHERE id=CURRVAL('actor.usr_id_seq');
2560 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2561 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2563 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2564 FROM actor.org_unit aou
2565 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2567 INSERT INTO actor.usr
2568 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2569 VALUES (7, 3, 'sheath', 5, 'Heath', 'stevenh1234',
2570 'Steven', 'Luke', NOW() + '3 years'::INTERVAL, NULL, NULL);
2572 INSERT INTO actor.usr_address
2573 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2574 VALUES ('USA', 'f', '94547', '4666 Pain Isle', 't',
2575 'CA', 'Hercules', '', 'Contra costa', CURRVAL('actor.usr_id_seq'));
2577 INSERT INTO actor.card (barcode, usr)
2578 VALUES ('99999375796', CURRVAL('actor.usr_id_seq'));
2580 UPDATE actor.usr SET
2581 card = CURRVAL('actor.card_id_seq'),
2582 billing_address = CURRVAL('actor.usr_address_id_seq'),
2583 credit_forward_balance = '0',
2584 mailing_address = CURRVAL('actor.usr_address_id_seq')
2585 WHERE id=CURRVAL('actor.usr_id_seq');
2587 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2588 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2590 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2591 FROM actor.org_unit aou
2592 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2594 INSERT INTO actor.usr
2595 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2596 VALUES (7, 1, 'krush', 4, 'Rush', 'keithr1234',
2597 'Keith', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
2599 INSERT INTO actor.usr_address
2600 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2601 VALUES ('USA', 't', '15257', '4464 Sense Station', 't',
2602 'PA', 'Pittsburgh', '', '', CURRVAL('actor.usr_id_seq'));
2604 INSERT INTO actor.card (barcode, usr)
2605 VALUES ('99999345655', CURRVAL('actor.usr_id_seq'));
2607 UPDATE actor.usr SET
2608 card = CURRVAL('actor.card_id_seq'),
2609 billing_address = CURRVAL('actor.usr_address_id_seq'),
2610 credit_forward_balance = '0',
2611 mailing_address = CURRVAL('actor.usr_address_id_seq')
2612 WHERE id=CURRVAL('actor.usr_id_seq');
2614 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2615 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2617 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2618 FROM actor.org_unit aou
2619 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2621 INSERT INTO actor.usr
2622 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2623 VALUES (7, 3, 'lfarrell', 4, 'Farrell', 'lindaf1234',
2624 'Linda', 'Linda', NOW() + '3 years'::INTERVAL, NULL, NULL);
2626 INSERT INTO actor.usr_address
2627 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2628 VALUES ('USA', 't', '75155', '7746 Cooperative Fall Shoal', 't',
2629 'TX', 'Rice', '', 'Navarro', CURRVAL('actor.usr_id_seq'));
2631 INSERT INTO actor.card (barcode, usr)
2632 VALUES ('99999344872', CURRVAL('actor.usr_id_seq'));
2634 UPDATE actor.usr SET
2635 card = CURRVAL('actor.card_id_seq'),
2636 billing_address = CURRVAL('actor.usr_address_id_seq'),
2637 credit_forward_balance = '0',
2638 mailing_address = CURRVAL('actor.usr_address_id_seq')
2639 WHERE id=CURRVAL('actor.usr_id_seq');
2641 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2642 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2644 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2645 FROM actor.org_unit aou
2646 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2648 INSERT INTO actor.usr
2649 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2650 VALUES (6, 3, 'rharrison', 9, 'Harrison', 'richardh1234',
2651 'Richard', 'Melvin', NOW() + '3 years'::INTERVAL, NULL, NULL);
2653 INSERT INTO actor.usr_address
2654 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2655 VALUES ('USA', 't', '06601', '2896 Jewish Lack Lodge', 't',
2656 'CT', 'Bridgeport', '', '', CURRVAL('actor.usr_id_seq'));
2658 INSERT INTO actor.card (barcode, usr)
2659 VALUES ('99999399702', CURRVAL('actor.usr_id_seq'));
2661 UPDATE actor.usr SET
2662 card = CURRVAL('actor.card_id_seq'),
2663 billing_address = CURRVAL('actor.usr_address_id_seq'),
2664 credit_forward_balance = '0',
2665 mailing_address = CURRVAL('actor.usr_address_id_seq')
2666 WHERE id=CURRVAL('actor.usr_id_seq');
2668 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2669 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2671 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2672 FROM actor.org_unit aou
2673 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2675 INSERT INTO actor.usr
2676 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2677 VALUES (6, 1, 'ksmith', 9, 'Smith', 'kevins1234',
2678 'Kevin', 'Timothy', NOW() + '3 years'::INTERVAL, NULL, NULL);
2680 INSERT INTO actor.usr_address
2681 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2682 VALUES ('USA', 'f', '81523', '5119 Lot Isle', 't',
2683 'CO', 'Glade park', '', 'Mesa', CURRVAL('actor.usr_id_seq'));
2685 INSERT INTO actor.card (barcode, usr)
2686 VALUES ('99999394646', CURRVAL('actor.usr_id_seq'));
2688 UPDATE actor.usr SET
2689 card = CURRVAL('actor.card_id_seq'),
2690 billing_address = CURRVAL('actor.usr_address_id_seq'),
2691 credit_forward_balance = '0',
2692 mailing_address = CURRVAL('actor.usr_address_id_seq')
2693 WHERE id=CURRVAL('actor.usr_id_seq');
2695 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2696 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2698 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2699 FROM actor.org_unit aou
2700 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2702 INSERT INTO actor.usr
2703 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2704 VALUES (6, 1, 'fmoore', 8, 'Moore', 'florencem1234',
2705 'Florence', 'Michelle', NOW() + '3 years'::INTERVAL, '1977-02-07', 'Jr');
2707 INSERT INTO actor.usr_address
2708 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2709 VALUES ('USA', 't', '39440', '6398 Mathematical Condition Arcade', 't',
2710 'MS', 'Laurel', '', '', CURRVAL('actor.usr_id_seq'));
2712 INSERT INTO actor.card (barcode, usr)
2713 VALUES ('99999341034', CURRVAL('actor.usr_id_seq'));
2715 UPDATE actor.usr SET
2716 card = CURRVAL('actor.card_id_seq'),
2717 billing_address = CURRVAL('actor.usr_address_id_seq'),
2718 credit_forward_balance = '0',
2719 mailing_address = CURRVAL('actor.usr_address_id_seq')
2720 WHERE id=CURRVAL('actor.usr_id_seq');
2722 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2723 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2725 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2726 FROM actor.org_unit aou
2727 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2729 INSERT INTO actor.usr
2730 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2731 VALUES (6, 1, 'bcruz', 8, 'Cruz', 'bettyc1234',
2732 'Betty', 'Shirley', NOW() + '3 years'::INTERVAL, '1993-08-10', 'Sr');
2734 INSERT INTO actor.usr_address
2735 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2736 VALUES ('USA', 'f', '33630', '1062 Scornful Air Fort', 't',
2737 'FL', 'Tampa', '', 'Hillsborough', CURRVAL('actor.usr_id_seq'));
2739 INSERT INTO actor.card (barcode, usr)
2740 VALUES ('99999363183', CURRVAL('actor.usr_id_seq'));
2742 UPDATE actor.usr SET
2743 card = CURRVAL('actor.card_id_seq'),
2744 billing_address = CURRVAL('actor.usr_address_id_seq'),
2745 credit_forward_balance = '0',
2746 mailing_address = CURRVAL('actor.usr_address_id_seq')
2747 WHERE id=CURRVAL('actor.usr_id_seq');
2749 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2750 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2752 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2753 FROM actor.org_unit aou
2754 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2756 INSERT INTO actor.usr
2757 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2758 VALUES (6, 1, 'jjohnson', 7, 'Johnson', 'joelj1234',
2759 'Joel', 'Allen', NOW() + '3 years'::INTERVAL, NULL, NULL);
2761 INSERT INTO actor.usr_address
2762 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2763 VALUES ('USA', 'f', '36028', '3220 Drunk Message Parkway', 't',
2764 'AL', 'Dozier', '', '', CURRVAL('actor.usr_id_seq'));
2766 INSERT INTO actor.card (barcode, usr)
2767 VALUES ('99999370090', CURRVAL('actor.usr_id_seq'));
2769 UPDATE actor.usr SET
2770 card = CURRVAL('actor.card_id_seq'),
2771 billing_address = CURRVAL('actor.usr_address_id_seq'),
2772 credit_forward_balance = '0',
2773 mailing_address = CURRVAL('actor.usr_address_id_seq')
2774 WHERE id=CURRVAL('actor.usr_id_seq');
2776 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2777 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2779 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2780 FROM actor.org_unit aou
2781 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2783 INSERT INTO actor.usr
2784 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2785 VALUES (6, 1, 'kburton', 7, 'Burton', 'kristenb1234',
2786 'Kristen', 'Dena', NOW() + '3 years'::INTERVAL, NULL, NULL);
2788 INSERT INTO actor.usr_address
2789 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2790 VALUES ('USA', 'f', '42413', '4924 Part-time Charge Knoll', 't',
2791 'KY', 'Hanson', '', 'Hopkins', CURRVAL('actor.usr_id_seq'));
2793 INSERT INTO actor.card (barcode, usr)
2794 VALUES ('99999372936', CURRVAL('actor.usr_id_seq'));
2796 UPDATE actor.usr SET
2797 card = CURRVAL('actor.card_id_seq'),
2798 billing_address = CURRVAL('actor.usr_address_id_seq'),
2799 credit_forward_balance = '0',
2800 mailing_address = CURRVAL('actor.usr_address_id_seq')
2801 WHERE id=CURRVAL('actor.usr_id_seq');
2803 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2804 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2806 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2807 FROM actor.org_unit aou
2808 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2810 INSERT INTO actor.usr
2811 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2812 VALUES (6, 1, 'rpineda', 6, 'Pineda', 'robertp1234',
2813 'Robert', 'Gordon', NOW() + '3 years'::INTERVAL, NULL, NULL);
2815 INSERT INTO actor.usr_address
2816 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2817 VALUES ('USA', 'f', '47703', '1587 Labour Holiday Park', 't',
2818 'IN', 'Evansville', '', 'Vanderburgh', CURRVAL('actor.usr_id_seq'));
2820 INSERT INTO actor.card (barcode, usr)
2821 VALUES ('99999349988', CURRVAL('actor.usr_id_seq'));
2823 UPDATE actor.usr SET
2824 card = CURRVAL('actor.card_id_seq'),
2825 billing_address = CURRVAL('actor.usr_address_id_seq'),
2826 credit_forward_balance = '0',
2827 mailing_address = CURRVAL('actor.usr_address_id_seq')
2828 WHERE id=CURRVAL('actor.usr_id_seq');
2830 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2831 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2833 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2834 FROM actor.org_unit aou
2835 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2837 INSERT INTO actor.usr
2838 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2839 VALUES (6, 1, 'avaldez', 6, 'Valdez', 'alissav1234',
2840 'Alissa', 'Gladys', NOW() + '3 years'::INTERVAL, '1994-03-25', 'Jr');
2842 INSERT INTO actor.usr_address
2843 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2844 VALUES ('USA', 'f', '64735', '4372 Fact Junction', 't',
2845 'MO', 'Clinton', '', 'Henry', CURRVAL('actor.usr_id_seq'));
2847 INSERT INTO actor.card (barcode, usr)
2848 VALUES ('99999332255', CURRVAL('actor.usr_id_seq'));
2850 UPDATE actor.usr SET
2851 card = CURRVAL('actor.card_id_seq'),
2852 billing_address = CURRVAL('actor.usr_address_id_seq'),
2853 credit_forward_balance = '0',
2854 mailing_address = CURRVAL('actor.usr_address_id_seq')
2855 WHERE id=CURRVAL('actor.usr_id_seq');
2857 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2858 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2860 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2861 FROM actor.org_unit aou
2862 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2864 INSERT INTO actor.usr
2865 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2866 VALUES (6, 3, 'krowland', 5, 'Rowland', 'kennethr1234',
2867 'Kenneth', 'Ernest', NOW() + '3 years'::INTERVAL, NULL, NULL);
2869 INSERT INTO actor.usr_address
2870 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2871 VALUES ('USA', 'f', '98131', '8373 Resonant Investment Mission', 't',
2872 'WA', 'Seattle', '', 'King', CURRVAL('actor.usr_id_seq'));
2874 INSERT INTO actor.card (barcode, usr)
2875 VALUES ('99999354715', CURRVAL('actor.usr_id_seq'));
2877 UPDATE actor.usr SET
2878 card = CURRVAL('actor.card_id_seq'),
2879 billing_address = CURRVAL('actor.usr_address_id_seq'),
2880 credit_forward_balance = '0',
2881 mailing_address = CURRVAL('actor.usr_address_id_seq')
2882 WHERE id=CURRVAL('actor.usr_id_seq');
2884 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2885 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2887 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2888 FROM actor.org_unit aou
2889 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2891 INSERT INTO actor.usr
2892 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2893 VALUES (6, 1, 'thansen', 5, 'Hansen', 'terranceh1234',
2894 'Terrance', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
2896 INSERT INTO actor.usr_address
2897 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2898 VALUES ('USA', 't', '16550', '4446 Formidable Way Knolls', 't',
2899 'PA', 'Erie', '', 'Erie', CURRVAL('actor.usr_id_seq'));
2901 INSERT INTO actor.card (barcode, usr)
2902 VALUES ('99999363646', CURRVAL('actor.usr_id_seq'));
2904 UPDATE actor.usr SET
2905 card = CURRVAL('actor.card_id_seq'),
2906 billing_address = CURRVAL('actor.usr_address_id_seq'),
2907 credit_forward_balance = '0',
2908 mailing_address = CURRVAL('actor.usr_address_id_seq')
2909 WHERE id=CURRVAL('actor.usr_id_seq');
2911 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2912 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2914 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2915 FROM actor.org_unit aou
2916 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2918 INSERT INTO actor.usr
2919 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2920 VALUES (6, 3, 'breid', 4, 'Reid', 'barbarar1234',
2921 'Barbara', 'Amanda', NOW() + '3 years'::INTERVAL, NULL, NULL);
2923 INSERT INTO actor.usr_address
2924 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2925 VALUES ('USA', 'f', '04056', '3517 Hot School Brook', 't',
2926 'ME', 'Newfield', '', 'York', CURRVAL('actor.usr_id_seq'));
2928 INSERT INTO actor.card (barcode, usr)
2929 VALUES ('99999365307', CURRVAL('actor.usr_id_seq'));
2931 UPDATE actor.usr SET
2932 card = CURRVAL('actor.card_id_seq'),
2933 billing_address = CURRVAL('actor.usr_address_id_seq'),
2934 credit_forward_balance = '0',
2935 mailing_address = CURRVAL('actor.usr_address_id_seq')
2936 WHERE id=CURRVAL('actor.usr_id_seq');
2938 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2939 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2941 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2942 FROM actor.org_unit aou
2943 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2945 INSERT INTO actor.usr
2946 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2947 VALUES (6, 1, 'mroberts', 4, 'Roberts', 'michaelr1234',
2948 'Michael', 'Stephen', NOW() + '3 years'::INTERVAL, NULL, NULL);
2950 INSERT INTO actor.usr_address
2951 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2952 VALUES ('USA', 't', '63541', '4668 Start Inlet', 't',
2953 'MO', 'Glenwood', '', 'Schuyler', CURRVAL('actor.usr_id_seq'));
2955 INSERT INTO actor.card (barcode, usr)
2956 VALUES ('99999332788', CURRVAL('actor.usr_id_seq'));
2958 UPDATE actor.usr SET
2959 card = CURRVAL('actor.card_id_seq'),
2960 billing_address = CURRVAL('actor.usr_address_id_seq'),
2961 credit_forward_balance = '0',
2962 mailing_address = CURRVAL('actor.usr_address_id_seq')
2963 WHERE id=CURRVAL('actor.usr_id_seq');
2965 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2966 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2968 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2969 FROM actor.org_unit aou
2970 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2972 INSERT INTO actor.usr
2973 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2974 VALUES (5, 3, 'rkaufman', 9, 'Kaufman', 'rachelk1234',
2975 'Rachel', 'Vickie', NOW() + '3 years'::INTERVAL, NULL, NULL);
2977 INSERT INTO actor.usr_address
2978 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2979 VALUES ('USA', 't', '68659', '7270 Development Row', 't',
2980 'NE', 'Rogers', '', '', CURRVAL('actor.usr_id_seq'));
2982 INSERT INTO actor.card (barcode, usr)
2983 VALUES ('99999340790', CURRVAL('actor.usr_id_seq'));
2985 UPDATE actor.usr SET
2986 card = CURRVAL('actor.card_id_seq'),
2987 billing_address = CURRVAL('actor.usr_address_id_seq'),
2988 credit_forward_balance = '0',
2989 mailing_address = CURRVAL('actor.usr_address_id_seq')
2990 WHERE id=CURRVAL('actor.usr_id_seq');
2992 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2993 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2995 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2996 FROM actor.org_unit aou
2997 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2999 INSERT INTO actor.usr
3000 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3001 VALUES (5, 3, 'csims', 9, 'Sims', 'christophers1234',
3002 'Christopher', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL);
3004 INSERT INTO actor.usr_address
3005 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3006 VALUES ('USA', 't', '89013', '5637 Plastic Mill', 't',
3007 'NV', 'Goldfield', '', 'Esmeralda', CURRVAL('actor.usr_id_seq'));
3009 INSERT INTO actor.card (barcode, usr)
3010 VALUES ('99999386091', CURRVAL('actor.usr_id_seq'));
3012 UPDATE actor.usr SET
3013 card = CURRVAL('actor.card_id_seq'),
3014 billing_address = CURRVAL('actor.usr_address_id_seq'),
3015 credit_forward_balance = '0',
3016 mailing_address = CURRVAL('actor.usr_address_id_seq')
3017 WHERE id=CURRVAL('actor.usr_id_seq');
3019 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3020 VALUES (CURRVAL('actor.usr_id_seq'), 9);
3022 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3023 FROM actor.org_unit aou
3024 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3026 INSERT INTO actor.usr
3027 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3028 VALUES (5, 1, 'srobinson', 8, 'Robinson', 'sarahr1234',
3029 'Sarah', '', NOW() + '3 years'::INTERVAL, '1996-01-28', 'II');
3031 INSERT INTO actor.usr_address
3032 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3033 VALUES ('USA', 'f', '65897', '8092 Pure Name Bridge', 't',
3034 'MO', 'Springfield', '', 'Greene', CURRVAL('actor.usr_id_seq'));
3036 INSERT INTO actor.card (barcode, usr)
3037 VALUES ('99999340199', CURRVAL('actor.usr_id_seq'));
3039 UPDATE actor.usr SET
3040 card = CURRVAL('actor.card_id_seq'),
3041 billing_address = CURRVAL('actor.usr_address_id_seq'),
3042 credit_forward_balance = '0',
3043 mailing_address = CURRVAL('actor.usr_address_id_seq')
3044 WHERE id=CURRVAL('actor.usr_id_seq');
3046 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3047 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3049 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3050 FROM actor.org_unit aou
3051 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3053 INSERT INTO actor.usr
3054 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3055 VALUES (5, 3, 'jpayton', 8, 'Payton', 'johnnyp1234',
3056 'Johnny', 'Vincent', NOW() + '3 years'::INTERVAL, NULL, NULL);
3058 INSERT INTO actor.usr_address
3059 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3060 VALUES ('USA', 't', '85738', '8772 Forthcoming Hope Fort', 't',
3061 'AZ', 'Catalina', '', '', CURRVAL('actor.usr_id_seq'));
3063 INSERT INTO actor.card (barcode, usr)
3064 VALUES ('99999387186', CURRVAL('actor.usr_id_seq'));
3066 UPDATE actor.usr SET
3067 card = CURRVAL('actor.card_id_seq'),
3068 billing_address = CURRVAL('actor.usr_address_id_seq'),
3069 credit_forward_balance = '0',
3070 mailing_address = CURRVAL('actor.usr_address_id_seq')
3071 WHERE id=CURRVAL('actor.usr_id_seq');
3073 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3074 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3076 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3077 FROM actor.org_unit aou
3078 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3080 INSERT INTO actor.usr
3081 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3082 VALUES (5, 3, 'djamison', 7, 'Jamison', 'davidj1234',
3083 'David', 'Eric', NOW() + '3 years'::INTERVAL, NULL, NULL);
3085 INSERT INTO actor.usr_address
3086 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3087 VALUES ('USA', 'f', '59604', '9218 Moral Worker Summit', 't',
3088 'MT', 'Helena', '', '', CURRVAL('actor.usr_id_seq'));
3090 INSERT INTO actor.card (barcode, usr)
3091 VALUES ('99999340530', CURRVAL('actor.usr_id_seq'));
3093 UPDATE actor.usr SET
3094 card = CURRVAL('actor.card_id_seq'),
3095 billing_address = CURRVAL('actor.usr_address_id_seq'),
3096 credit_forward_balance = '0',
3097 mailing_address = CURRVAL('actor.usr_address_id_seq')
3098 WHERE id=CURRVAL('actor.usr_id_seq');
3100 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3101 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3103 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3104 FROM actor.org_unit aou
3105 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3107 INSERT INTO actor.usr
3108 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3109 VALUES (5, 3, 'jford', 7, 'Ford', 'jamief1234',
3110 'Jamie', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
3112 INSERT INTO actor.usr_address
3113 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3114 VALUES ('USA', 'f', '41746', '8268 Hill Valleys', 't',
3115 'KY', 'Happy', '', 'Perry', CURRVAL('actor.usr_id_seq'));
3117 INSERT INTO actor.card (barcode, usr)
3118 VALUES ('99999384455', CURRVAL('actor.usr_id_seq'));
3120 UPDATE actor.usr SET
3121 card = CURRVAL('actor.card_id_seq'),
3122 billing_address = CURRVAL('actor.usr_address_id_seq'),
3123 credit_forward_balance = '0',
3124 mailing_address = CURRVAL('actor.usr_address_id_seq')
3125 WHERE id=CURRVAL('actor.usr_id_seq');
3127 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3128 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3130 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3131 FROM actor.org_unit aou
3132 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3134 INSERT INTO actor.usr
3135 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3136 VALUES (5, 1, 'gwatson', 6, 'Watson', 'geraldw1234',
3137 'Gerald', 'Larry', NOW() + '3 years'::INTERVAL, NULL, NULL);
3139 INSERT INTO actor.usr_address
3140 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3141 VALUES ('USA', 'f', '85063', '881 Scary Holiday Radial', 't',
3142 'AZ', 'Phoenix', '', 'Maricopa', CURRVAL('actor.usr_id_seq'));
3144 INSERT INTO actor.card (barcode, usr)
3145 VALUES ('99999385100', CURRVAL('actor.usr_id_seq'));
3147 UPDATE actor.usr SET
3148 card = CURRVAL('actor.card_id_seq'),
3149 billing_address = CURRVAL('actor.usr_address_id_seq'),
3150 credit_forward_balance = '0',
3151 mailing_address = CURRVAL('actor.usr_address_id_seq')
3152 WHERE id=CURRVAL('actor.usr_id_seq');
3154 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3155 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3157 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3158 FROM actor.org_unit aou
3159 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3161 INSERT INTO actor.usr
3162 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3163 VALUES (5, 1, 'clambert', 6, 'Lambert', 'charlesl1234',
3164 'Charles', 'William', NOW() + '3 years'::INTERVAL, '1995-09-22', 'Jr');
3166 INSERT INTO actor.usr_address
3167 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3168 VALUES ('USA', 't', '40291', '6026 Wide Development Port', 't',
3169 'KY', 'Louisville', '', 'Jefferson', CURRVAL('actor.usr_id_seq'));
3171 INSERT INTO actor.card (barcode, usr)
3172 VALUES ('99999335749', CURRVAL('actor.usr_id_seq'));
3174 UPDATE actor.usr SET
3175 card = CURRVAL('actor.card_id_seq'),
3176 billing_address = CURRVAL('actor.usr_address_id_seq'),
3177 credit_forward_balance = '0',
3178 mailing_address = CURRVAL('actor.usr_address_id_seq')
3179 WHERE id=CURRVAL('actor.usr_id_seq');
3181 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3182 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3184 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3185 FROM actor.org_unit aou
3186 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3188 INSERT INTO actor.usr
3189 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3190 VALUES (5, 1, 'mbarber', 5, 'Barber', 'michealb1234',
3191 'Micheal', 'Ramon', NOW() + '3 years'::INTERVAL, NULL, NULL);
3193 INSERT INTO actor.usr_address
3194 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3195 VALUES ('USA', 'f', '91357', '9727 Proposed Executive Plaza', 't',
3196 'CA', 'Tarzana', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
3198 INSERT INTO actor.card (barcode, usr)
3199 VALUES ('99999361522', CURRVAL('actor.usr_id_seq'));
3201 UPDATE actor.usr SET
3202 card = CURRVAL('actor.card_id_seq'),
3203 billing_address = CURRVAL('actor.usr_address_id_seq'),
3204 credit_forward_balance = '0',
3205 mailing_address = CURRVAL('actor.usr_address_id_seq')
3206 WHERE id=CURRVAL('actor.usr_id_seq');
3208 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3209 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3211 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3212 FROM actor.org_unit aou
3213 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3215 INSERT INTO actor.usr
3216 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3217 VALUES (5, 3, 'tcruz', 5, 'Cruz', 'tomc1234',
3218 'Tom', 'Eugene', NOW() + '3 years'::INTERVAL, NULL, NULL);
3220 INSERT INTO actor.usr_address
3221 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3222 VALUES ('USA', 'f', '40546', '7481 Reform Road', 't',
3223 'KY', 'Lexington', '', 'Fayette', CURRVAL('actor.usr_id_seq'));
3225 INSERT INTO actor.card (barcode, usr)
3226 VALUES ('99999394278', CURRVAL('actor.usr_id_seq'));
3228 UPDATE actor.usr SET
3229 card = CURRVAL('actor.card_id_seq'),
3230 billing_address = CURRVAL('actor.usr_address_id_seq'),
3231 credit_forward_balance = '0',
3232 mailing_address = CURRVAL('actor.usr_address_id_seq')
3233 WHERE id=CURRVAL('actor.usr_id_seq');
3235 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3236 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3238 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3239 FROM actor.org_unit aou
3240 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3242 INSERT INTO actor.usr
3243 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3244 VALUES (5, 1, 'iwalton', 4, 'Walton', 'inezw1234',
3245 'Inez', 'Amanda', NOW() + '3 years'::INTERVAL, NULL, NULL);
3247 INSERT INTO actor.usr_address
3248 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3249 VALUES ('USA', 'f', '29053', '8589 Official Valleys', 't',
3250 'SC', 'Gaston', '', '', CURRVAL('actor.usr_id_seq'));
3252 INSERT INTO actor.card (barcode, usr)
3253 VALUES ('99999356283', CURRVAL('actor.usr_id_seq'));
3255 UPDATE actor.usr SET
3256 card = CURRVAL('actor.card_id_seq'),
3257 billing_address = CURRVAL('actor.usr_address_id_seq'),
3258 credit_forward_balance = '0',
3259 mailing_address = CURRVAL('actor.usr_address_id_seq')
3260 WHERE id=CURRVAL('actor.usr_id_seq');
3262 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3263 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3265 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3266 FROM actor.org_unit aou
3267 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
3269 INSERT INTO actor.usr
3270 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3271 VALUES (5, 3, 'mtownsend', 4, 'Townsend', 'maryt1234',
3272 'Mary', '', NOW() + '3 years'::INTERVAL, '1995-03-03', 'Jr');
3274 INSERT INTO actor.usr_address
3275 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3276 VALUES ('USA', 't', '72464', '3321 Answer Stravenue', 't',
3277 'AR', 'Saint francis', '', '', CURRVAL('actor.usr_id_seq'));
3279 INSERT INTO actor.card (barcode, usr)
3280 VALUES ('99999336350', CURRVAL('actor.usr_id_seq'));
3282 UPDATE actor.usr SET
3283 card = CURRVAL('actor.card_id_seq'),
3284 billing_address = CURRVAL('actor.usr_address_id_seq'),
3285 credit_forward_balance = '0',
3286 mailing_address = CURRVAL('actor.usr_address_id_seq')
3287 WHERE id=CURRVAL('actor.usr_id_seq');
3289 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3290 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3292 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3293 FROM actor.org_unit aou
3294 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
3296 INSERT INTO actor.usr
3297 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3298 VALUES (4, 3, 'cmartinez', 9, 'Martinez', 'carolynm1234',
3299 'Carolyn', 'Sandra', NOW() + '3 years'::INTERVAL, NULL, NULL);
3301 INSERT INTO actor.usr_address
3302 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3303 VALUES ('USA', 't', '49654', '7081 Appalling Plant Causeway', 't',
3304 'MI', 'Leland', '', '', CURRVAL('actor.usr_id_seq'));
3306 INSERT INTO actor.card (barcode, usr)
3307 VALUES ('99999397121', CURRVAL('actor.usr_id_seq'));
3309 UPDATE actor.usr SET
3310 card = CURRVAL('actor.card_id_seq'),
3311 billing_address = CURRVAL('actor.usr_address_id_seq'),
3312 credit_forward_balance = '0',
3313 mailing_address = CURRVAL('actor.usr_address_id_seq')
3314 WHERE id=CURRVAL('actor.usr_id_seq');
3316 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3317 VALUES (CURRVAL('actor.usr_id_seq'), 9);
3319 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3320 FROM actor.org_unit aou
3321 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3323 INSERT INTO actor.usr
3324 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3325 VALUES (4, 1, 'jjohnson', 9, 'Johnson', 'jeremyj1234',
3326 'Jeremy', 'Mark', NOW() + '3 years'::INTERVAL, '1970-03-14', 'II');
3328 INSERT INTO actor.usr_address
3329 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3330 VALUES ('USA', 'f', '70358', '4786 Prior Politics Mission', 't',
3331 'LA', 'Grand isle', '', '', CURRVAL('actor.usr_id_seq'));
3333 INSERT INTO actor.card (barcode, usr)
3334 VALUES ('99999397850', CURRVAL('actor.usr_id_seq'));
3336 UPDATE actor.usr SET
3337 card = CURRVAL('actor.card_id_seq'),
3338 billing_address = CURRVAL('actor.usr_address_id_seq'),
3339 credit_forward_balance = '0',
3340 mailing_address = CURRVAL('actor.usr_address_id_seq')
3341 WHERE id=CURRVAL('actor.usr_id_seq');
3343 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3344 VALUES (CURRVAL('actor.usr_id_seq'), 9);
3346 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3347 FROM actor.org_unit aou
3348 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3350 INSERT INTO actor.usr
3351 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3352 VALUES (4, 1, 'mscott', 8, 'Scott', 'maes1234',
3353 'Mae', 'Sue', NOW() + '3 years'::INTERVAL, NULL, NULL);
3355 INSERT INTO actor.usr_address
3356 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3357 VALUES ('USA', 'f', '14723', '1060 Letter Stravenue', 't',
3358 'NY', 'Cherry creek', '', '', CURRVAL('actor.usr_id_seq'));
3360 INSERT INTO actor.card (barcode, usr)
3361 VALUES ('99999395984', CURRVAL('actor.usr_id_seq'));
3363 UPDATE actor.usr SET
3364 card = CURRVAL('actor.card_id_seq'),
3365 billing_address = CURRVAL('actor.usr_address_id_seq'),
3366 credit_forward_balance = '0',
3367 mailing_address = CURRVAL('actor.usr_address_id_seq')
3368 WHERE id=CURRVAL('actor.usr_id_seq');
3370 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3371 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3373 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3374 FROM actor.org_unit aou
3375 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3377 INSERT INTO actor.usr
3378 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3379 VALUES (4, 3, 'rstevens', 8, 'Stevens', 'russells1234',
3380 'Russell', 'Daniel', NOW() + '3 years'::INTERVAL, '1973-08-15', 'Jr');
3382 INSERT INTO actor.usr_address
3383 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3384 VALUES ('USA', 't', '29582', '7735 Street Creek', 't',
3385 'SC', 'North myrtle beach', '', 'Horry', CURRVAL('actor.usr_id_seq'));
3387 INSERT INTO actor.card (barcode, usr)
3388 VALUES ('99999340524', CURRVAL('actor.usr_id_seq'));
3390 UPDATE actor.usr SET
3391 card = CURRVAL('actor.card_id_seq'),
3392 billing_address = CURRVAL('actor.usr_address_id_seq'),
3393 credit_forward_balance = '0',
3394 mailing_address = CURRVAL('actor.usr_address_id_seq')
3395 WHERE id=CURRVAL('actor.usr_id_seq');
3397 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3398 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3400 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3401 FROM actor.org_unit aou
3402 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3404 INSERT INTO actor.usr
3405 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3406 VALUES (4, 3, 'therrera', 7, 'Herrera', 'tracih1234',
3407 'Traci', 'Edith', NOW() + '3 years'::INTERVAL, '1994-07-07', 'Jr');
3409 INSERT INTO actor.usr_address
3410 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3411 VALUES ('USA', 'f', '84133', '7301 Watery Arrangement Radial', 't',
3412 'UT', 'Salt lake city', '', '', CURRVAL('actor.usr_id_seq'));
3414 INSERT INTO actor.card (barcode, usr)
3415 VALUES ('99999386259', CURRVAL('actor.usr_id_seq'));
3417 UPDATE actor.usr SET
3418 card = CURRVAL('actor.card_id_seq'),
3419 billing_address = CURRVAL('actor.usr_address_id_seq'),
3420 credit_forward_balance = '0',
3421 mailing_address = CURRVAL('actor.usr_address_id_seq')
3422 WHERE id=CURRVAL('actor.usr_id_seq');
3424 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3425 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3427 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3428 FROM actor.org_unit aou
3429 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3431 INSERT INTO actor.usr
3432 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3433 VALUES (4, 3, 'vgrimes', 7, 'Grimes', 'virginiag1234',
3434 'Virginia', 'Jennifer', NOW() + '3 years'::INTERVAL, NULL, NULL);
3436 INSERT INTO actor.usr_address
3437 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3438 VALUES ('USA', 'f', '87027', '8666 Fluttering Situation Heights', 't',
3439 'NM', 'La jara', '', 'Sandoval', CURRVAL('actor.usr_id_seq'));
3441 INSERT INTO actor.card (barcode, usr)
3442 VALUES ('99999318163', CURRVAL('actor.usr_id_seq'));
3444 UPDATE actor.usr SET
3445 card = CURRVAL('actor.card_id_seq'),
3446 billing_address = CURRVAL('actor.usr_address_id_seq'),
3447 credit_forward_balance = '0',
3448 mailing_address = CURRVAL('actor.usr_address_id_seq')
3449 WHERE id=CURRVAL('actor.usr_id_seq');
3451 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3452 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3454 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3455 FROM actor.org_unit aou
3456 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3458 INSERT INTO actor.usr
3459 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3460 VALUES (4, 1, 'pward', 6, 'Ward', 'paulw1234',
3461 'Paul', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
3463 INSERT INTO actor.usr_address
3464 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3465 VALUES ('USA', 'f', '38233', '8859 Roasted Energy Falls', 't',
3466 'TN', 'Kenton', '', '', CURRVAL('actor.usr_id_seq'));
3468 INSERT INTO actor.card (barcode, usr)
3469 VALUES ('99999346968', CURRVAL('actor.usr_id_seq'));
3471 UPDATE actor.usr SET
3472 card = CURRVAL('actor.card_id_seq'),
3473 billing_address = CURRVAL('actor.usr_address_id_seq'),
3474 credit_forward_balance = '0',
3475 mailing_address = CURRVAL('actor.usr_address_id_seq')
3476 WHERE id=CURRVAL('actor.usr_id_seq');
3478 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3479 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3481 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3482 FROM actor.org_unit aou
3483 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3485 INSERT INTO actor.usr
3486 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3487 VALUES (4, 3, 'bgreen', 6, 'Green', 'beatriceg1234',
3488 'Beatrice', 'Janette', NOW() + '3 years'::INTERVAL, NULL, NULL);
3490 INSERT INTO actor.usr_address
3491 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3492 VALUES ('USA', 't', '65438', '9082 Plain Bed Avenue', 't',
3493 'MO', 'Birch tree', '', 'Shannon', CURRVAL('actor.usr_id_seq'));
3495 INSERT INTO actor.card (barcode, usr)
3496 VALUES ('99999345139', CURRVAL('actor.usr_id_seq'));
3498 UPDATE actor.usr SET
3499 card = CURRVAL('actor.card_id_seq'),
3500 billing_address = CURRVAL('actor.usr_address_id_seq'),
3501 credit_forward_balance = '0',
3502 mailing_address = CURRVAL('actor.usr_address_id_seq')
3503 WHERE id=CURRVAL('actor.usr_id_seq');
3505 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3506 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3508 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3509 FROM actor.org_unit aou
3510 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3512 INSERT INTO actor.usr
3513 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3514 VALUES (4, 1, 'sschmidt', 5, 'Schmidt', 'scotts1234',
3515 'Scott', 'Kyle', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
3517 INSERT INTO actor.usr_address
3518 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3519 VALUES ('USA', 'f', '99670', '2204 Status Avenue', 't',
3520 'AK', 'South naknek', '', '', CURRVAL('actor.usr_id_seq'));
3522 INSERT INTO actor.card (barcode, usr)
3523 VALUES ('99999393981', CURRVAL('actor.usr_id_seq'));
3525 UPDATE actor.usr SET
3526 card = CURRVAL('actor.card_id_seq'),
3527 billing_address = CURRVAL('actor.usr_address_id_seq'),
3528 credit_forward_balance = '0',
3529 mailing_address = CURRVAL('actor.usr_address_id_seq')
3530 WHERE id=CURRVAL('actor.usr_id_seq');
3532 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3533 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3535 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3536 FROM actor.org_unit aou
3537 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3539 INSERT INTO actor.usr
3540 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3541 VALUES (4, 3, 'jclark', 5, 'Clark', 'joannec1234',
3542 'Joanne', 'Andrea', NOW() + '3 years'::INTERVAL, NULL, NULL);
3544 INSERT INTO actor.usr_address
3545 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3546 VALUES ('USA', 'f', '35175', '7622 Thoughtless Science Pines', 't',
3547 'AL', 'Union grove', '', 'Marshall', CURRVAL('actor.usr_id_seq'));
3549 INSERT INTO actor.card (barcode, usr)
3550 VALUES ('99999366354', CURRVAL('actor.usr_id_seq'));
3552 UPDATE actor.usr SET
3553 card = CURRVAL('actor.card_id_seq'),
3554 billing_address = CURRVAL('actor.usr_address_id_seq'),
3555 credit_forward_balance = '0',
3556 mailing_address = CURRVAL('actor.usr_address_id_seq')
3557 WHERE id=CURRVAL('actor.usr_id_seq');
3559 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3560 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3562 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3563 FROM actor.org_unit aou
3564 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3566 INSERT INTO actor.usr
3567 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3568 VALUES (4, 1, 'bbrown', 4, 'Brown', 'beverlyb1234',
3569 'Beverly', 'Florence', NOW() + '3 years'::INTERVAL, NULL, NULL);
3571 INSERT INTO actor.usr_address
3572 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3573 VALUES ('USA', 't', '29058', '2991 Trip Crescent', 't',
3574 'SC', 'Heath springs', '', 'Lancaster', CURRVAL('actor.usr_id_seq'));
3576 INSERT INTO actor.card (barcode, usr)
3577 VALUES ('99999338317', CURRVAL('actor.usr_id_seq'));
3579 UPDATE actor.usr SET
3580 card = CURRVAL('actor.card_id_seq'),
3581 billing_address = CURRVAL('actor.usr_address_id_seq'),
3582 credit_forward_balance = '0',
3583 mailing_address = CURRVAL('actor.usr_address_id_seq')
3584 WHERE id=CURRVAL('actor.usr_id_seq');
3586 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3587 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3589 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3590 FROM actor.org_unit aou
3591 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
3593 INSERT INTO actor.usr
3594 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3595 VALUES (4, 3, 'jmcginnis', 4, 'Mcginnis', 'josem1234',
3596 'Jose', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL);
3598 INSERT INTO actor.usr_address
3599 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3600 VALUES ('USA', 't', '65055', '8231 Relieved Debt Cape', 't',
3601 'MO', 'Mc girk', '', 'Moniteau', CURRVAL('actor.usr_id_seq'));
3603 INSERT INTO actor.card (barcode, usr)
3604 VALUES ('99999316430', CURRVAL('actor.usr_id_seq'));
3606 UPDATE actor.usr SET
3607 card = CURRVAL('actor.card_id_seq'),
3608 billing_address = CURRVAL('actor.usr_address_id_seq'),
3609 credit_forward_balance = '0',
3610 mailing_address = CURRVAL('actor.usr_address_id_seq')
3611 WHERE id=CURRVAL('actor.usr_id_seq');
3613 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3614 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3616 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3617 FROM actor.org_unit aou
3618 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;