2 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3 VALUES (13, 3, 'sforbes', 6, 'Forbes', 'samuelf1234',
4 'Samuel', 'Eugene', NOW() + '3 years'::INTERVAL, NULL, NULL);
6 INSERT INTO actor.usr_address
7 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
8 VALUES ('USA', 'f', '40065', '8751 Gentleman Burgs', 'f',
9 'KY', 'Shelbyville', '', 'Shelby', CURRVAL('actor.usr_id_seq'));
11 INSERT INTO actor.card (barcode, usr)
12 VALUES ('99999336514', CURRVAL('actor.usr_id_seq'));
15 card = CURRVAL('actor.card_id_seq'),
16 billing_address = CURRVAL('actor.usr_address_id_seq'),
17 credit_forward_balance = '0',
18 mailing_address = CURRVAL('actor.usr_address_id_seq')
19 WHERE id=CURRVAL('actor.usr_id_seq');
21 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
22 VALUES (CURRVAL('actor.usr_id_seq'), 6);
24 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
25 FROM actor.org_unit aou
26 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
29 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
30 VALUES (13, 1, 'vcampbell', 4, 'Campbell', 'vincentc1234',
31 'Vincent', 'Lawrence', NOW() + '3 years'::INTERVAL, NULL, NULL);
33 INSERT INTO actor.usr_address
34 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
35 VALUES ('USA', 'f', '45633', '5489 Suitable Way Knoll', 'f',
36 'OH', 'Hallsville', '', 'Ross', CURRVAL('actor.usr_id_seq'));
38 INSERT INTO actor.card (barcode, usr)
39 VALUES ('99999338171', CURRVAL('actor.usr_id_seq'));
42 card = CURRVAL('actor.card_id_seq'),
43 billing_address = CURRVAL('actor.usr_address_id_seq'),
44 credit_forward_balance = '0',
45 mailing_address = CURRVAL('actor.usr_address_id_seq')
46 WHERE id=CURRVAL('actor.usr_id_seq');
48 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
49 VALUES (CURRVAL('actor.usr_id_seq'), 4);
51 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
52 FROM actor.org_unit aou
53 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
56 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
57 VALUES (15, 3, 'afrey', 9, 'Frey', 'annief1234',
58 'Annie', 'Jessica', NOW() + '3 years'::INTERVAL, NULL, NULL);
60 INSERT INTO actor.usr_address
61 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
62 VALUES ('USA', 't', '54409', '7918 Subjective Volume Trail', 'f',
63 'WI', 'Antigo', '', '', CURRVAL('actor.usr_id_seq'));
65 INSERT INTO actor.card (barcode, usr)
66 VALUES ('99999364116', CURRVAL('actor.usr_id_seq'));
69 card = CURRVAL('actor.card_id_seq'),
70 billing_address = CURRVAL('actor.usr_address_id_seq'),
71 credit_forward_balance = '0',
72 mailing_address = CURRVAL('actor.usr_address_id_seq')
73 WHERE id=CURRVAL('actor.usr_id_seq');
75 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
76 VALUES (CURRVAL('actor.usr_id_seq'), 9);
78 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
79 FROM actor.org_unit aou
80 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
83 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
84 VALUES (15, 3, 'msalinas', 9, 'Salinas', 'marks1234',
85 'Mark', 'Christopher', NOW() + '3 years'::INTERVAL, '1999-06-13', 'II');
87 INSERT INTO actor.usr_address
88 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
89 VALUES ('USA', 'f', '25529', '1790 Lively Attitude Falls', 't',
90 'WV', 'Julian', '', 'Boone', CURRVAL('actor.usr_id_seq'));
92 INSERT INTO actor.card (barcode, usr)
93 VALUES ('99999313813', CURRVAL('actor.usr_id_seq'));
96 card = CURRVAL('actor.card_id_seq'),
97 billing_address = CURRVAL('actor.usr_address_id_seq'),
98 credit_forward_balance = '0',
99 mailing_address = CURRVAL('actor.usr_address_id_seq')
100 WHERE id=CURRVAL('actor.usr_id_seq');
102 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
103 VALUES (CURRVAL('actor.usr_id_seq'), 9);
105 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
106 FROM actor.org_unit aou
107 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
109 INSERT INTO actor.usr
110 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
111 VALUES (15, 1, 'klindsey', 8, 'Lindsey', 'kennethl1234',
112 'Kenneth', 'Jesse', NOW() + '3 years'::INTERVAL, NULL, NULL);
114 INSERT INTO actor.usr_address
115 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
116 VALUES ('USA', 't', '89077', '1552 Okay Communication Motorway', 'f',
117 'NV', 'Henderson', '', '', CURRVAL('actor.usr_id_seq'));
119 INSERT INTO actor.card (barcode, usr)
120 VALUES ('99999334832', CURRVAL('actor.usr_id_seq'));
123 card = CURRVAL('actor.card_id_seq'),
124 billing_address = CURRVAL('actor.usr_address_id_seq'),
125 credit_forward_balance = '0',
126 mailing_address = CURRVAL('actor.usr_address_id_seq')
127 WHERE id=CURRVAL('actor.usr_id_seq');
129 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
130 VALUES (CURRVAL('actor.usr_id_seq'), 8);
132 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
133 FROM actor.org_unit aou
134 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
136 INSERT INTO actor.usr
137 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
138 VALUES (15, 3, 'mdavis', 8, 'Davis', 'marthad1234',
139 'Martha', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
141 INSERT INTO actor.usr_address
142 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
143 VALUES ('USA', 'f', '13156', '8717 Cabinet Fords', 'f',
144 'NY', 'Sterling', '', 'Cayuga', CURRVAL('actor.usr_id_seq'));
146 INSERT INTO actor.card (barcode, usr)
147 VALUES ('99999315736', CURRVAL('actor.usr_id_seq'));
150 card = CURRVAL('actor.card_id_seq'),
151 billing_address = CURRVAL('actor.usr_address_id_seq'),
152 credit_forward_balance = '0',
153 mailing_address = CURRVAL('actor.usr_address_id_seq')
154 WHERE id=CURRVAL('actor.usr_id_seq');
156 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
157 VALUES (CURRVAL('actor.usr_id_seq'), 8);
159 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
160 FROM actor.org_unit aou
161 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
163 INSERT INTO actor.usr
164 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
165 VALUES (15, 3, 'vfreeman', 7, 'Freeman', 'virginiaf1234',
166 'Virginia', 'Johanna', NOW() + '3 years'::INTERVAL, '1967-07-23', 'Jr');
168 INSERT INTO actor.usr_address
169 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
170 VALUES ('USA', 'f', '33122', '4033 Instant Matter Cape', 'f',
171 'FL', 'Miami', '', '', CURRVAL('actor.usr_id_seq'));
173 INSERT INTO actor.card (barcode, usr)
174 VALUES ('99999301938', CURRVAL('actor.usr_id_seq'));
177 card = CURRVAL('actor.card_id_seq'),
178 billing_address = CURRVAL('actor.usr_address_id_seq'),
179 credit_forward_balance = '0',
180 mailing_address = CURRVAL('actor.usr_address_id_seq')
181 WHERE id=CURRVAL('actor.usr_id_seq');
183 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
184 VALUES (CURRVAL('actor.usr_id_seq'), 7);
186 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
187 FROM actor.org_unit aou
188 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
190 INSERT INTO actor.usr
191 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
192 VALUES (15, 3, 'lmartinez', 7, 'Martinez', 'leroym1234',
193 'Leroy', 'Brian', NOW() + '3 years'::INTERVAL, NULL, NULL);
195 INSERT INTO actor.usr_address
196 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
197 VALUES ('USA', 't', '55046', '2511 Other Stream', 'f',
198 'MN', 'Lonsdale', '', 'Rice', CURRVAL('actor.usr_id_seq'));
200 INSERT INTO actor.card (barcode, usr)
201 VALUES ('99999385425', CURRVAL('actor.usr_id_seq'));
204 card = CURRVAL('actor.card_id_seq'),
205 billing_address = CURRVAL('actor.usr_address_id_seq'),
206 credit_forward_balance = '0',
207 mailing_address = CURRVAL('actor.usr_address_id_seq')
208 WHERE id=CURRVAL('actor.usr_id_seq');
210 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
211 VALUES (CURRVAL('actor.usr_id_seq'), 7);
213 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
214 FROM actor.org_unit aou
215 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
217 INSERT INTO actor.usr
218 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
219 VALUES (15, 1, 'warmstrong', 6, 'Armstrong', 'williama1234',
220 'William', 'William', NOW() + '3 years'::INTERVAL, NULL, NULL);
222 INSERT INTO actor.usr_address
223 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
224 VALUES ('USA', 'f', '55959', '1671 Cabinet Orchard', 'f',
225 'MN', 'Minnesota city', '', 'Winona', CURRVAL('actor.usr_id_seq'));
227 INSERT INTO actor.card (barcode, usr)
228 VALUES ('99999378711', CURRVAL('actor.usr_id_seq'));
231 card = CURRVAL('actor.card_id_seq'),
232 billing_address = CURRVAL('actor.usr_address_id_seq'),
233 credit_forward_balance = '0',
234 mailing_address = CURRVAL('actor.usr_address_id_seq')
235 WHERE id=CURRVAL('actor.usr_id_seq');
237 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
238 VALUES (CURRVAL('actor.usr_id_seq'), 6);
240 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
241 FROM actor.org_unit aou
242 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
244 INSERT INTO actor.usr
245 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
246 VALUES (15, 3, 'acotton', 6, 'Cotton', 'amyc1234',
247 'Amy', 'Ada', NOW() + '3 years'::INTERVAL, NULL, NULL);
249 INSERT INTO actor.usr_address
250 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
251 VALUES ('USA', 't', '34202', '1488 Glamorous Alternative Forks', 'f',
252 'FL', 'Bradenton', '', 'Manatee', CURRVAL('actor.usr_id_seq'));
254 INSERT INTO actor.card (barcode, usr)
255 VALUES ('99999323866', CURRVAL('actor.usr_id_seq'));
258 card = CURRVAL('actor.card_id_seq'),
259 billing_address = CURRVAL('actor.usr_address_id_seq'),
260 credit_forward_balance = '0',
261 mailing_address = CURRVAL('actor.usr_address_id_seq')
262 WHERE id=CURRVAL('actor.usr_id_seq');
264 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
265 VALUES (CURRVAL('actor.usr_id_seq'), 6);
267 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
268 FROM actor.org_unit aou
269 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
271 INSERT INTO actor.usr
272 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
273 VALUES (15, 1, 'sbarton', 5, 'Barton', 'sarahb1234',
274 'Sarah', 'Valerie', NOW() + '3 years'::INTERVAL, NULL, NULL);
276 INSERT INTO actor.usr_address
277 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
278 VALUES ('USA', 'f', '54655', '6986 Delighted Design Trail', 't',
279 'WI', 'Soldiers grove', '', 'Crawford', CURRVAL('actor.usr_id_seq'));
281 INSERT INTO actor.card (barcode, usr)
282 VALUES ('99999327258', CURRVAL('actor.usr_id_seq'));
285 card = CURRVAL('actor.card_id_seq'),
286 billing_address = CURRVAL('actor.usr_address_id_seq'),
287 credit_forward_balance = '0',
288 mailing_address = CURRVAL('actor.usr_address_id_seq')
289 WHERE id=CURRVAL('actor.usr_id_seq');
291 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
292 VALUES (CURRVAL('actor.usr_id_seq'), 5);
294 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
295 FROM actor.org_unit aou
296 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
298 INSERT INTO actor.usr
299 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
300 VALUES (15, 1, 'jhammond', 5, 'Hammond', 'jamesh1234',
301 'James', 'Michael', NOW() + '3 years'::INTERVAL, NULL, NULL);
303 INSERT INTO actor.usr_address
304 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
305 VALUES ('USA', 'f', '88211', '9144 White Support Squares', 'f',
306 'NM', 'Artesia', '', 'Eddy', CURRVAL('actor.usr_id_seq'));
308 INSERT INTO actor.card (barcode, usr)
309 VALUES ('99999385896', CURRVAL('actor.usr_id_seq'));
312 card = CURRVAL('actor.card_id_seq'),
313 billing_address = CURRVAL('actor.usr_address_id_seq'),
314 credit_forward_balance = '0',
315 mailing_address = CURRVAL('actor.usr_address_id_seq')
316 WHERE id=CURRVAL('actor.usr_id_seq');
318 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
319 VALUES (CURRVAL('actor.usr_id_seq'), 5);
321 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
322 FROM actor.org_unit aou
323 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
325 INSERT INTO actor.usr
326 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
327 VALUES (15, 3, 'ajoseph', 4, 'Joseph', 'alexj1234',
328 'Alex', 'Edward', NOW() + '3 years'::INTERVAL, NULL, NULL);
330 INSERT INTO actor.usr_address
331 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
332 VALUES ('USA', 't', '56308', '9081 Awake Minute Spring', 't',
333 'MN', 'Alexandria', '', 'Douglas', CURRVAL('actor.usr_id_seq'));
335 INSERT INTO actor.card (barcode, usr)
336 VALUES ('99999378073', CURRVAL('actor.usr_id_seq'));
339 card = CURRVAL('actor.card_id_seq'),
340 billing_address = CURRVAL('actor.usr_address_id_seq'),
341 credit_forward_balance = '0',
342 mailing_address = CURRVAL('actor.usr_address_id_seq')
343 WHERE id=CURRVAL('actor.usr_id_seq');
345 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
346 VALUES (CURRVAL('actor.usr_id_seq'), 4);
348 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
349 FROM actor.org_unit aou
350 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
352 INSERT INTO actor.usr
353 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
354 VALUES (15, 3, 'imccoy', 4, 'Mccoy', 'idam1234',
355 'Ida', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL);
357 INSERT INTO actor.usr_address
358 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
359 VALUES ('USA', 't', '40046', '9875 Support Row', 'f',
360 'KY', 'Mount eden', '', 'Spencer', CURRVAL('actor.usr_id_seq'));
362 INSERT INTO actor.card (barcode, usr)
363 VALUES ('99999321047', CURRVAL('actor.usr_id_seq'));
366 card = CURRVAL('actor.card_id_seq'),
367 billing_address = CURRVAL('actor.usr_address_id_seq'),
368 credit_forward_balance = '0',
369 mailing_address = CURRVAL('actor.usr_address_id_seq')
370 WHERE id=CURRVAL('actor.usr_id_seq');
372 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
373 VALUES (CURRVAL('actor.usr_id_seq'), 4);
375 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
376 FROM actor.org_unit aou
377 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
379 INSERT INTO actor.usr
380 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
381 VALUES (14, 3, 'dwright', 9, 'Wright', 'dennisw1234',
382 'Dennis', 'Ernest', NOW() + '3 years'::INTERVAL, NULL, NULL);
384 INSERT INTO actor.usr_address
385 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
386 VALUES ('USA', 'f', '03457', '2063 Sophisticated Status Plaza', 'f',
387 'NH', 'Nelson', '', 'Cheshire', CURRVAL('actor.usr_id_seq'));
389 INSERT INTO actor.card (barcode, usr)
390 VALUES ('99999348121', CURRVAL('actor.usr_id_seq'));
393 card = CURRVAL('actor.card_id_seq'),
394 billing_address = CURRVAL('actor.usr_address_id_seq'),
395 credit_forward_balance = '0',
396 mailing_address = CURRVAL('actor.usr_address_id_seq')
397 WHERE id=CURRVAL('actor.usr_id_seq');
399 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
400 VALUES (CURRVAL('actor.usr_id_seq'), 9);
402 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
403 FROM actor.org_unit aou
404 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
406 INSERT INTO actor.usr
407 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
408 VALUES (14, 1, 'alynch', 9, 'Lynch', 'armandol1234',
409 'Armando', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
411 INSERT INTO actor.usr_address
412 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
413 VALUES ('USA', 'f', '31126', '7394 Show Valley', 'f',
414 'GA', 'Atlanta', '', 'Fulton', CURRVAL('actor.usr_id_seq'));
416 INSERT INTO actor.card (barcode, usr)
417 VALUES ('99999384116', CURRVAL('actor.usr_id_seq'));
420 card = CURRVAL('actor.card_id_seq'),
421 billing_address = CURRVAL('actor.usr_address_id_seq'),
422 credit_forward_balance = '0',
423 mailing_address = CURRVAL('actor.usr_address_id_seq')
424 WHERE id=CURRVAL('actor.usr_id_seq');
426 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
427 VALUES (CURRVAL('actor.usr_id_seq'), 9);
429 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
430 FROM actor.org_unit aou
431 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
433 INSERT INTO actor.usr
434 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
435 VALUES (14, 3, 'rgraham', 8, 'Graham', 'robertg1234',
436 'Robert', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
438 INSERT INTO actor.usr_address
439 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
440 VALUES ('USA', 't', '98807', '2577 Stuck Benefit Tunnel', 'f',
441 'WA', 'Wenatchee', '', 'Chelan', CURRVAL('actor.usr_id_seq'));
443 INSERT INTO actor.card (barcode, usr)
444 VALUES ('99999311950', CURRVAL('actor.usr_id_seq'));
447 card = CURRVAL('actor.card_id_seq'),
448 billing_address = CURRVAL('actor.usr_address_id_seq'),
449 credit_forward_balance = '0',
450 mailing_address = CURRVAL('actor.usr_address_id_seq')
451 WHERE id=CURRVAL('actor.usr_id_seq');
453 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
454 VALUES (CURRVAL('actor.usr_id_seq'), 8);
456 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
457 FROM actor.org_unit aou
458 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
460 INSERT INTO actor.usr
461 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
462 VALUES (14, 1, 'sthompson', 8, 'Thompson', 'sherrit1234',
463 'Sherri', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
465 INSERT INTO actor.usr_address
466 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
467 VALUES ('USA', 'f', '31758', '3587 Name Neck', 'f',
468 'GA', 'Thomasville', '', 'Thomas', CURRVAL('actor.usr_id_seq'));
470 INSERT INTO actor.card (barcode, usr)
471 VALUES ('99999384066', CURRVAL('actor.usr_id_seq'));
474 card = CURRVAL('actor.card_id_seq'),
475 billing_address = CURRVAL('actor.usr_address_id_seq'),
476 credit_forward_balance = '0',
477 mailing_address = CURRVAL('actor.usr_address_id_seq')
478 WHERE id=CURRVAL('actor.usr_id_seq');
480 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
481 VALUES (CURRVAL('actor.usr_id_seq'), 8);
483 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
484 FROM actor.org_unit aou
485 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
487 INSERT INTO actor.usr
488 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
489 VALUES (14, 1, 'ngarcia', 7, 'Garcia', 'nanetteg1234',
490 'Nanette', 'Helen', NOW() + '3 years'::INTERVAL, NULL, NULL);
492 INSERT INTO actor.usr_address
493 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
494 VALUES ('USA', 't', '11733', '6990 Icy Scene Street', 'f',
495 'NY', 'East setauket', '', 'Suffolk', CURRVAL('actor.usr_id_seq'));
497 INSERT INTO actor.card (barcode, usr)
498 VALUES ('99999332719', CURRVAL('actor.usr_id_seq'));
501 card = CURRVAL('actor.card_id_seq'),
502 billing_address = CURRVAL('actor.usr_address_id_seq'),
503 credit_forward_balance = '0',
504 mailing_address = CURRVAL('actor.usr_address_id_seq')
505 WHERE id=CURRVAL('actor.usr_id_seq');
507 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
508 VALUES (CURRVAL('actor.usr_id_seq'), 7);
510 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
511 FROM actor.org_unit aou
512 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
514 INSERT INTO actor.usr
515 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
516 VALUES (14, 3, 'rcook', 7, 'Cook', 'raymondc1234',
517 'Raymond', 'Boyd', NOW() + '3 years'::INTERVAL, NULL, NULL);
519 INSERT INTO actor.usr_address
520 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
521 VALUES ('USA', 't', '94533', '2004 Harsh Gold Tunnel', 'f',
522 'CA', 'Fairfield', '', 'Solano', CURRVAL('actor.usr_id_seq'));
524 INSERT INTO actor.card (barcode, usr)
525 VALUES ('99999392343', CURRVAL('actor.usr_id_seq'));
528 card = CURRVAL('actor.card_id_seq'),
529 billing_address = CURRVAL('actor.usr_address_id_seq'),
530 credit_forward_balance = '0',
531 mailing_address = CURRVAL('actor.usr_address_id_seq')
532 WHERE id=CURRVAL('actor.usr_id_seq');
534 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
535 VALUES (CURRVAL('actor.usr_id_seq'), 7);
537 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
538 FROM actor.org_unit aou
539 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
541 INSERT INTO actor.usr
542 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
543 VALUES (14, 3, 'kbrewer', 6, 'Brewer', 'katherineb1234',
544 'Katherine', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
546 INSERT INTO actor.usr_address
547 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
548 VALUES ('USA', 'f', '59053', '6732 Recognition Street', 't',
549 'MT', 'Martinsdale', '', 'Meagher', CURRVAL('actor.usr_id_seq'));
551 INSERT INTO actor.card (barcode, usr)
552 VALUES ('99999383479', CURRVAL('actor.usr_id_seq'));
555 card = CURRVAL('actor.card_id_seq'),
556 billing_address = CURRVAL('actor.usr_address_id_seq'),
557 credit_forward_balance = '0',
558 mailing_address = CURRVAL('actor.usr_address_id_seq')
559 WHERE id=CURRVAL('actor.usr_id_seq');
561 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
562 VALUES (CURRVAL('actor.usr_id_seq'), 6);
564 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
565 FROM actor.org_unit aou
566 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
568 INSERT INTO actor.usr
569 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
570 VALUES (14, 1, 'cwashington', 6, 'Washington', 'christopherw1234',
571 'Christopher', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
573 INSERT INTO actor.usr_address
574 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
575 VALUES ('USA', 't', '47360', '9934 Coloured Bar Grove', 'f',
576 'IN', 'Mooreland', '', 'Henry', CURRVAL('actor.usr_id_seq'));
578 INSERT INTO actor.card (barcode, usr)
579 VALUES ('99999380284', CURRVAL('actor.usr_id_seq'));
582 card = CURRVAL('actor.card_id_seq'),
583 billing_address = CURRVAL('actor.usr_address_id_seq'),
584 credit_forward_balance = '0',
585 mailing_address = CURRVAL('actor.usr_address_id_seq')
586 WHERE id=CURRVAL('actor.usr_id_seq');
588 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
589 VALUES (CURRVAL('actor.usr_id_seq'), 6);
591 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
592 FROM actor.org_unit aou
593 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
595 INSERT INTO actor.usr
596 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
597 VALUES (14, 3, 'dmurray', 5, 'Murray', 'dawnm1234',
598 'Dawn', 'Katherine', NOW() + '3 years'::INTERVAL, NULL, NULL);
600 INSERT INTO actor.usr_address
601 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
602 VALUES ('USA', 't', '59868', '4426 Temporary Demand River', 'f',
603 'MT', 'Seeley lake', '', 'Missoula', CURRVAL('actor.usr_id_seq'));
605 INSERT INTO actor.card (barcode, usr)
606 VALUES ('99999347656', CURRVAL('actor.usr_id_seq'));
609 card = CURRVAL('actor.card_id_seq'),
610 billing_address = CURRVAL('actor.usr_address_id_seq'),
611 credit_forward_balance = '0',
612 mailing_address = CURRVAL('actor.usr_address_id_seq')
613 WHERE id=CURRVAL('actor.usr_id_seq');
615 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
616 VALUES (CURRVAL('actor.usr_id_seq'), 5);
618 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
619 FROM actor.org_unit aou
620 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
622 INSERT INTO actor.usr
623 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
624 VALUES (14, 1, 'bwatts', 5, 'Watts', 'barbaraw1234',
625 'Barbara', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL);
627 INSERT INTO actor.usr_address
628 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
629 VALUES ('USA', 't', '51036', '4020 Marked Chemical Bayoo', 'f',
630 'IA', 'Maurice', '', 'Sioux', CURRVAL('actor.usr_id_seq'));
632 INSERT INTO actor.card (barcode, usr)
633 VALUES ('99999384489', CURRVAL('actor.usr_id_seq'));
636 card = CURRVAL('actor.card_id_seq'),
637 billing_address = CURRVAL('actor.usr_address_id_seq'),
638 credit_forward_balance = '0',
639 mailing_address = CURRVAL('actor.usr_address_id_seq')
640 WHERE id=CURRVAL('actor.usr_id_seq');
642 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
643 VALUES (CURRVAL('actor.usr_id_seq'), 5);
645 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
646 FROM actor.org_unit aou
647 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
649 INSERT INTO actor.usr
650 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
651 VALUES (14, 3, 'mmartin', 4, 'Martin', 'marym1234',
652 'Mary', 'Shannon', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
654 INSERT INTO actor.usr_address
655 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
656 VALUES ('USA', 't', '16657', '7511 Fortunate Length Parkway', 't',
657 'PA', 'James creek', '', 'Huntingdon', CURRVAL('actor.usr_id_seq'));
659 INSERT INTO actor.card (barcode, usr)
660 VALUES ('99999336634', CURRVAL('actor.usr_id_seq'));
663 card = CURRVAL('actor.card_id_seq'),
664 billing_address = CURRVAL('actor.usr_address_id_seq'),
665 credit_forward_balance = '0',
666 mailing_address = CURRVAL('actor.usr_address_id_seq')
667 WHERE id=CURRVAL('actor.usr_id_seq');
669 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
670 VALUES (CURRVAL('actor.usr_id_seq'), 4);
672 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
673 FROM actor.org_unit aou
674 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
676 INSERT INTO actor.usr
677 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
678 VALUES (14, 3, 'vford', 4, 'Ford', 'vivianf1234',
679 'Vivian', 'Darlene', NOW() + '3 years'::INTERVAL, NULL, NULL);
681 INSERT INTO actor.usr_address
682 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
683 VALUES ('USA', 't', '23023', '3414 Energetic Weekend Circles', 'f',
684 'VA', 'Bruington', '', 'King and queen', CURRVAL('actor.usr_id_seq'));
686 INSERT INTO actor.card (barcode, usr)
687 VALUES ('99999361251', CURRVAL('actor.usr_id_seq'));
690 card = CURRVAL('actor.card_id_seq'),
691 billing_address = CURRVAL('actor.usr_address_id_seq'),
692 credit_forward_balance = '0',
693 mailing_address = CURRVAL('actor.usr_address_id_seq')
694 WHERE id=CURRVAL('actor.usr_id_seq');
696 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
697 VALUES (CURRVAL('actor.usr_id_seq'), 4);
699 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
700 FROM actor.org_unit aou
701 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
703 INSERT INTO actor.usr
704 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
705 VALUES (12, 1, 'gsuarez', 9, 'Suarez', 'garys1234',
706 'Gary', 'Joel', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
708 INSERT INTO actor.usr_address
709 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
710 VALUES ('USA', 'f', '19244', '1613 Legislation River', 't',
711 'PA', 'Philadelphia', '', '', CURRVAL('actor.usr_id_seq'));
713 INSERT INTO actor.card (barcode, usr)
714 VALUES ('99999372079', CURRVAL('actor.usr_id_seq'));
717 card = CURRVAL('actor.card_id_seq'),
718 billing_address = CURRVAL('actor.usr_address_id_seq'),
719 credit_forward_balance = '0',
720 mailing_address = CURRVAL('actor.usr_address_id_seq')
721 WHERE id=CURRVAL('actor.usr_id_seq');
723 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
724 VALUES (CURRVAL('actor.usr_id_seq'), 9);
726 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
727 FROM actor.org_unit aou
728 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
730 INSERT INTO actor.usr
731 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
732 VALUES (12, 1, 'eellis', 9, 'Ellis', 'edwarde1234',
733 'Edward', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL);
735 INSERT INTO actor.usr_address
736 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
737 VALUES ('USA', 't', '17349', '1977 Profound Conference Path', 'f',
738 'PA', 'New freedom', '', 'York', CURRVAL('actor.usr_id_seq'));
740 INSERT INTO actor.card (barcode, usr)
741 VALUES ('99999354444', CURRVAL('actor.usr_id_seq'));
744 card = CURRVAL('actor.card_id_seq'),
745 billing_address = CURRVAL('actor.usr_address_id_seq'),
746 credit_forward_balance = '0',
747 mailing_address = CURRVAL('actor.usr_address_id_seq')
748 WHERE id=CURRVAL('actor.usr_id_seq');
750 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
751 VALUES (CURRVAL('actor.usr_id_seq'), 9);
753 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
754 FROM actor.org_unit aou
755 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
757 INSERT INTO actor.usr
758 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
759 VALUES (12, 1, 'nward', 8, 'Ward', 'naomiw1234',
760 'Naomi', 'Angela', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
762 INSERT INTO actor.usr_address
763 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
764 VALUES ('USA', 't', '20109', '2689 Standard Interview Vista', 't',
765 'VA', 'Manassas', '', '', CURRVAL('actor.usr_id_seq'));
767 INSERT INTO actor.card (barcode, usr)
768 VALUES ('99999326817', CURRVAL('actor.usr_id_seq'));
771 card = CURRVAL('actor.card_id_seq'),
772 billing_address = CURRVAL('actor.usr_address_id_seq'),
773 credit_forward_balance = '0',
774 mailing_address = CURRVAL('actor.usr_address_id_seq')
775 WHERE id=CURRVAL('actor.usr_id_seq');
777 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
778 VALUES (CURRVAL('actor.usr_id_seq'), 8);
780 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
781 FROM actor.org_unit aou
782 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
784 INSERT INTO actor.usr
785 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
786 VALUES (12, 1, 'jrichards', 8, 'Richards', 'josephr1234',
787 'Joseph', 'Thomas', NOW() + '3 years'::INTERVAL, NULL, NULL);
789 INSERT INTO actor.usr_address
790 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
791 VALUES ('USA', 'f', '78658', '3275 Error Freeway', 'f',
792 'TX', 'Ottine', '', 'Gonzales', CURRVAL('actor.usr_id_seq'));
794 INSERT INTO actor.card (barcode, usr)
795 VALUES ('99999318881', CURRVAL('actor.usr_id_seq'));
798 card = CURRVAL('actor.card_id_seq'),
799 billing_address = CURRVAL('actor.usr_address_id_seq'),
800 credit_forward_balance = '0',
801 mailing_address = CURRVAL('actor.usr_address_id_seq')
802 WHERE id=CURRVAL('actor.usr_id_seq');
804 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
805 VALUES (CURRVAL('actor.usr_id_seq'), 8);
807 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
808 FROM actor.org_unit aou
809 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
811 INSERT INTO actor.usr
812 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
813 VALUES (12, 3, 'rsanders', 7, 'Sanders', 'roslyns1234',
814 'Roslyn', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
816 INSERT INTO actor.usr_address
817 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
818 VALUES ('USA', 't', '19975', '6946 Constitutional Word Freeway', 'f',
819 'DE', 'Selbyville', '', 'Sussex', CURRVAL('actor.usr_id_seq'));
821 INSERT INTO actor.card (barcode, usr)
822 VALUES ('99999356038', CURRVAL('actor.usr_id_seq'));
825 card = CURRVAL('actor.card_id_seq'),
826 billing_address = CURRVAL('actor.usr_address_id_seq'),
827 credit_forward_balance = '0',
828 mailing_address = CURRVAL('actor.usr_address_id_seq')
829 WHERE id=CURRVAL('actor.usr_id_seq');
831 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
832 VALUES (CURRVAL('actor.usr_id_seq'), 7);
834 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
835 FROM actor.org_unit aou
836 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
838 INSERT INTO actor.usr
839 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
840 VALUES (12, 1, 'nrivera', 7, 'Rivera', 'nancyr1234',
841 'Nancy', 'Anita', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
843 INSERT INTO actor.usr_address
844 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
845 VALUES ('USA', 't', '27373', '263 Catholic End Field', 'f',
846 'NC', 'Wallburg', '', '', CURRVAL('actor.usr_id_seq'));
848 INSERT INTO actor.card (barcode, usr)
849 VALUES ('99999302274', CURRVAL('actor.usr_id_seq'));
852 card = CURRVAL('actor.card_id_seq'),
853 billing_address = CURRVAL('actor.usr_address_id_seq'),
854 credit_forward_balance = '0',
855 mailing_address = CURRVAL('actor.usr_address_id_seq')
856 WHERE id=CURRVAL('actor.usr_id_seq');
858 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
859 VALUES (CURRVAL('actor.usr_id_seq'), 7);
861 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
862 FROM actor.org_unit aou
863 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
865 INSERT INTO actor.usr
866 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
867 VALUES (12, 1, 'cmartin', 6, 'Martin', 'carlm1234',
868 'Carl', 'Charles', NOW() + '3 years'::INTERVAL, NULL, NULL);
870 INSERT INTO actor.usr_address
871 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
872 VALUES ('USA', 't', '61452', '6985 Welcome Statement Fort', 'f',
873 'IL', 'Littleton', '', 'Schuyler', CURRVAL('actor.usr_id_seq'));
875 INSERT INTO actor.card (barcode, usr)
876 VALUES ('99999339237', CURRVAL('actor.usr_id_seq'));
879 card = CURRVAL('actor.card_id_seq'),
880 billing_address = CURRVAL('actor.usr_address_id_seq'),
881 credit_forward_balance = '0',
882 mailing_address = CURRVAL('actor.usr_address_id_seq')
883 WHERE id=CURRVAL('actor.usr_id_seq');
885 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
886 VALUES (CURRVAL('actor.usr_id_seq'), 6);
888 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
889 FROM actor.org_unit aou
890 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
892 INSERT INTO actor.usr
893 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
894 VALUES (12, 1, 'telliott', 6, 'Elliott', 'thomase1234',
895 'Thomas', 'Marcus', NOW() + '3 years'::INTERVAL, NULL, NULL);
897 INSERT INTO actor.usr_address
898 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
899 VALUES ('USA', 't', '97624', '1283 Splendid West Manor', 'f',
900 'OR', 'Chiloquin', '', 'Klamath', CURRVAL('actor.usr_id_seq'));
902 INSERT INTO actor.card (barcode, usr)
903 VALUES ('99999340230', CURRVAL('actor.usr_id_seq'));
906 card = CURRVAL('actor.card_id_seq'),
907 billing_address = CURRVAL('actor.usr_address_id_seq'),
908 credit_forward_balance = '0',
909 mailing_address = CURRVAL('actor.usr_address_id_seq')
910 WHERE id=CURRVAL('actor.usr_id_seq');
912 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
913 VALUES (CURRVAL('actor.usr_id_seq'), 6);
915 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
916 FROM actor.org_unit aou
917 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
919 INSERT INTO actor.usr
920 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
921 VALUES (12, 3, 'ocherry', 5, 'Cherry', 'olgac1234',
922 'Olga', 'Marie', NOW() + '3 years'::INTERVAL, NULL, NULL);
924 INSERT INTO actor.usr_address
925 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
926 VALUES ('USA', 't', '17081', '9657 Scared Kind Street', 'f',
927 'PA', 'Plainfield', '', 'Cumberland', CURRVAL('actor.usr_id_seq'));
929 INSERT INTO actor.card (barcode, usr)
930 VALUES ('99999384061', CURRVAL('actor.usr_id_seq'));
933 card = CURRVAL('actor.card_id_seq'),
934 billing_address = CURRVAL('actor.usr_address_id_seq'),
935 credit_forward_balance = '0',
936 mailing_address = CURRVAL('actor.usr_address_id_seq')
937 WHERE id=CURRVAL('actor.usr_id_seq');
939 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
940 VALUES (CURRVAL('actor.usr_id_seq'), 5);
942 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
943 FROM actor.org_unit aou
944 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
946 INSERT INTO actor.usr
947 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
948 VALUES (12, 1, 'gdavenport', 5, 'Davenport', 'gwendolynd1234',
949 'Gwendolyn', '', NOW() + '3 years'::INTERVAL, NULL, 'Jr');
951 INSERT INTO actor.usr_address
952 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
953 VALUES ('USA', 'f', '85014', '110 Logical Tone Drive', 'f',
954 'AZ', 'Phoenix', '', 'Maricopa', CURRVAL('actor.usr_id_seq'));
956 INSERT INTO actor.card (barcode, usr)
957 VALUES ('99999372586', CURRVAL('actor.usr_id_seq'));
960 card = CURRVAL('actor.card_id_seq'),
961 billing_address = CURRVAL('actor.usr_address_id_seq'),
962 credit_forward_balance = '0',
963 mailing_address = CURRVAL('actor.usr_address_id_seq')
964 WHERE id=CURRVAL('actor.usr_id_seq');
966 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
967 VALUES (CURRVAL('actor.usr_id_seq'), 5);
969 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
970 FROM actor.org_unit aou
971 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
973 INSERT INTO actor.usr
974 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
975 VALUES (12, 3, 'sbrock', 4, 'Brock', 'scottb1234',
976 'Scott', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL);
978 INSERT INTO actor.usr_address
979 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
980 VALUES ('USA', 't', '60132', '1760 Channel Bottom', 'f',
981 'IL', 'Carol stream', '', '', CURRVAL('actor.usr_id_seq'));
983 INSERT INTO actor.card (barcode, usr)
984 VALUES ('99999336715', CURRVAL('actor.usr_id_seq'));
987 card = CURRVAL('actor.card_id_seq'),
988 billing_address = CURRVAL('actor.usr_address_id_seq'),
989 credit_forward_balance = '0',
990 mailing_address = CURRVAL('actor.usr_address_id_seq')
991 WHERE id=CURRVAL('actor.usr_id_seq');
993 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
994 VALUES (CURRVAL('actor.usr_id_seq'), 4);
996 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
997 FROM actor.org_unit aou
998 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1000 INSERT INTO actor.usr
1001 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1002 VALUES (12, 3, 'rjackson', 4, 'Jackson', 'ronaldj1234',
1003 'Ronald', 'Robert', NOW() + '3 years'::INTERVAL, NULL, 'Jr');
1005 INSERT INTO actor.usr_address
1006 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1007 VALUES ('USA', 'f', '04985', '5561 Native Reduction Crossing', 't',
1008 'ME', 'West forks', '', '', CURRVAL('actor.usr_id_seq'));
1010 INSERT INTO actor.card (barcode, usr)
1011 VALUES ('99999335465', CURRVAL('actor.usr_id_seq'));
1013 UPDATE actor.usr SET
1014 card = CURRVAL('actor.card_id_seq'),
1015 billing_address = CURRVAL('actor.usr_address_id_seq'),
1016 credit_forward_balance = '0',
1017 mailing_address = CURRVAL('actor.usr_address_id_seq')
1018 WHERE id=CURRVAL('actor.usr_id_seq');
1020 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1021 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1023 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1024 FROM actor.org_unit aou
1025 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1027 INSERT INTO actor.usr
1028 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1029 VALUES (11, 1, 'wjames', 9, 'James', 'waynej1234',
1030 'Wayne', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL);
1032 INSERT INTO actor.usr_address
1033 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1034 VALUES ('USA', 't', '27014', '5542 Politics Hollow', 'f',
1035 'NC', 'Cooleemee', '', '', CURRVAL('actor.usr_id_seq'));
1037 INSERT INTO actor.card (barcode, usr)
1038 VALUES ('99999379835', CURRVAL('actor.usr_id_seq'));
1040 UPDATE actor.usr SET
1041 card = CURRVAL('actor.card_id_seq'),
1042 billing_address = CURRVAL('actor.usr_address_id_seq'),
1043 credit_forward_balance = '0',
1044 mailing_address = CURRVAL('actor.usr_address_id_seq')
1045 WHERE id=CURRVAL('actor.usr_id_seq');
1047 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1048 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1050 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1051 FROM actor.org_unit aou
1052 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1054 INSERT INTO actor.usr
1055 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1056 VALUES (11, 1, 'shernandez', 9, 'Hernandez', 'sarahh1234',
1057 'Sarah', 'Elaine', NOW() + '3 years'::INTERVAL, NULL, NULL);
1059 INSERT INTO actor.usr_address
1060 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1061 VALUES ('USA', 't', '89151', '4939 Family Divide', 't',
1062 'NV', 'Las vegas', '', 'Clark', CURRVAL('actor.usr_id_seq'));
1064 INSERT INTO actor.card (barcode, usr)
1065 VALUES ('99999346587', CURRVAL('actor.usr_id_seq'));
1067 UPDATE actor.usr SET
1068 card = CURRVAL('actor.card_id_seq'),
1069 billing_address = CURRVAL('actor.usr_address_id_seq'),
1070 credit_forward_balance = '0',
1071 mailing_address = CURRVAL('actor.usr_address_id_seq')
1072 WHERE id=CURRVAL('actor.usr_id_seq');
1074 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1075 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1077 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1078 FROM actor.org_unit aou
1079 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1081 INSERT INTO actor.usr
1082 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1083 VALUES (11, 3, 'latkins', 8, 'Atkins', 'louisa1234',
1084 'Louis', 'Edward', NOW() + '3 years'::INTERVAL, NULL, NULL);
1086 INSERT INTO actor.usr_address
1087 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1088 VALUES ('USA', 't', '44705', '2794 Uniform Value Square', 'f',
1089 'OH', 'Canton', '', 'Stark', CURRVAL('actor.usr_id_seq'));
1091 INSERT INTO actor.card (barcode, usr)
1092 VALUES ('99999377256', CURRVAL('actor.usr_id_seq'));
1094 UPDATE actor.usr SET
1095 card = CURRVAL('actor.card_id_seq'),
1096 billing_address = CURRVAL('actor.usr_address_id_seq'),
1097 credit_forward_balance = '0',
1098 mailing_address = CURRVAL('actor.usr_address_id_seq')
1099 WHERE id=CURRVAL('actor.usr_id_seq');
1101 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1102 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1104 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1105 FROM actor.org_unit aou
1106 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1108 INSERT INTO actor.usr
1109 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1110 VALUES (11, 3, 'wneal', 8, 'Neal', 'waynen1234',
1111 'Wayne', '', NOW() + '3 years'::INTERVAL, '1977-06-05', 'Jr');
1113 INSERT INTO actor.usr_address
1114 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1115 VALUES ('USA', 't', '35501', '6178 Relieved Rain Wells', 'f',
1116 'AL', 'Jasper', '', 'Walker', CURRVAL('actor.usr_id_seq'));
1118 INSERT INTO actor.card (barcode, usr)
1119 VALUES ('99999377249', CURRVAL('actor.usr_id_seq'));
1121 UPDATE actor.usr SET
1122 card = CURRVAL('actor.card_id_seq'),
1123 billing_address = CURRVAL('actor.usr_address_id_seq'),
1124 credit_forward_balance = '0',
1125 mailing_address = CURRVAL('actor.usr_address_id_seq')
1126 WHERE id=CURRVAL('actor.usr_id_seq');
1128 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1129 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1131 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1132 FROM actor.org_unit aou
1133 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1135 INSERT INTO actor.usr
1136 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1137 VALUES (11, 3, 'mharrison', 7, 'Harrison', 'michelleh1234',
1138 'Michelle', 'Patricia', NOW() + '3 years'::INTERVAL, NULL, NULL);
1140 INSERT INTO actor.usr_address
1141 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1142 VALUES ('USA', 't', '05345', '1766 Victorious Estate Avenue', 't',
1143 'VT', 'Newfane', '', 'Windham', CURRVAL('actor.usr_id_seq'));
1145 INSERT INTO actor.card (barcode, usr)
1146 VALUES ('99999376642', CURRVAL('actor.usr_id_seq'));
1148 UPDATE actor.usr SET
1149 card = CURRVAL('actor.card_id_seq'),
1150 billing_address = CURRVAL('actor.usr_address_id_seq'),
1151 credit_forward_balance = '0',
1152 mailing_address = CURRVAL('actor.usr_address_id_seq')
1153 WHERE id=CURRVAL('actor.usr_id_seq');
1155 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1156 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1158 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1159 FROM actor.org_unit aou
1160 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1162 INSERT INTO actor.usr
1163 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1164 VALUES (11, 3, 'hwomack', 7, 'Womack', 'howardw1234',
1165 'Howard', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1167 INSERT INTO actor.usr_address
1168 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1169 VALUES ('USA', 't', '06262', '5472 Exhibition Trace', 't',
1170 'CT', 'Quinebaug', '', '', CURRVAL('actor.usr_id_seq'));
1172 INSERT INTO actor.card (barcode, usr)
1173 VALUES ('99999342319', CURRVAL('actor.usr_id_seq'));
1175 UPDATE actor.usr SET
1176 card = CURRVAL('actor.card_id_seq'),
1177 billing_address = CURRVAL('actor.usr_address_id_seq'),
1178 credit_forward_balance = '0',
1179 mailing_address = CURRVAL('actor.usr_address_id_seq')
1180 WHERE id=CURRVAL('actor.usr_id_seq');
1182 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1183 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1185 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1186 FROM actor.org_unit aou
1187 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1189 INSERT INTO actor.usr
1190 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1191 VALUES (11, 3, 'vbacon', 6, 'Bacon', 'virginiab1234',
1192 'Virginia', 'Celia', NOW() + '3 years'::INTERVAL, NULL, NULL);
1194 INSERT INTO actor.usr_address
1195 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1196 VALUES ('USA', 't', '61638', '4639 Family Tunnel', 't',
1197 'IL', 'Peoria', '', '', CURRVAL('actor.usr_id_seq'));
1199 INSERT INTO actor.card (barcode, usr)
1200 VALUES ('99999362019', CURRVAL('actor.usr_id_seq'));
1202 UPDATE actor.usr SET
1203 card = CURRVAL('actor.card_id_seq'),
1204 billing_address = CURRVAL('actor.usr_address_id_seq'),
1205 credit_forward_balance = '0',
1206 mailing_address = CURRVAL('actor.usr_address_id_seq')
1207 WHERE id=CURRVAL('actor.usr_id_seq');
1209 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1210 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1212 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1213 FROM actor.org_unit aou
1214 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1216 INSERT INTO actor.usr
1217 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1218 VALUES (11, 1, 'lbrooks', 6, 'Brooks', 'lonnieb1234',
1219 'Lonnie', 'William', NOW() + '3 years'::INTERVAL, NULL, NULL);
1221 INSERT INTO actor.usr_address
1222 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1223 VALUES ('USA', 't', '83836', '8823 Side Fall', 'f',
1224 'ID', 'Hope', '', 'Bonner', CURRVAL('actor.usr_id_seq'));
1226 INSERT INTO actor.card (barcode, usr)
1227 VALUES ('99999326493', CURRVAL('actor.usr_id_seq'));
1229 UPDATE actor.usr SET
1230 card = CURRVAL('actor.card_id_seq'),
1231 billing_address = CURRVAL('actor.usr_address_id_seq'),
1232 credit_forward_balance = '0',
1233 mailing_address = CURRVAL('actor.usr_address_id_seq')
1234 WHERE id=CURRVAL('actor.usr_id_seq');
1236 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1237 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1239 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1240 FROM actor.org_unit aou
1241 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1243 INSERT INTO actor.usr
1244 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1245 VALUES (11, 3, 'mgonzales', 5, 'Gonzales', 'maryg1234',
1246 'Mary', 'Jessica', NOW() + '3 years'::INTERVAL, NULL, NULL);
1248 INSERT INTO actor.usr_address
1249 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1250 VALUES ('USA', 'f', '16213', '6608 Weary Drawing Lakes', 'f',
1251 'PA', 'Callensburg', '', 'Clarion', CURRVAL('actor.usr_id_seq'));
1253 INSERT INTO actor.card (barcode, usr)
1254 VALUES ('99999337760', CURRVAL('actor.usr_id_seq'));
1256 UPDATE actor.usr SET
1257 card = CURRVAL('actor.card_id_seq'),
1258 billing_address = CURRVAL('actor.usr_address_id_seq'),
1259 credit_forward_balance = '0',
1260 mailing_address = CURRVAL('actor.usr_address_id_seq')
1261 WHERE id=CURRVAL('actor.usr_id_seq');
1263 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1264 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1266 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1267 FROM actor.org_unit aou
1268 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1270 INSERT INTO actor.usr
1271 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1272 VALUES (11, 1, 'mterry', 5, 'Terry', 'michellet1234',
1273 'Michelle', 'Kristy', NOW() + '3 years'::INTERVAL, NULL, NULL);
1275 INSERT INTO actor.usr_address
1276 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1277 VALUES ('USA', 'f', '30817', '1658 Organisational Bedroom Square', 'f',
1278 'GA', 'Lincolnton', '', '', CURRVAL('actor.usr_id_seq'));
1280 INSERT INTO actor.card (barcode, usr)
1281 VALUES ('99999390692', CURRVAL('actor.usr_id_seq'));
1283 UPDATE actor.usr SET
1284 card = CURRVAL('actor.card_id_seq'),
1285 billing_address = CURRVAL('actor.usr_address_id_seq'),
1286 credit_forward_balance = '0',
1287 mailing_address = CURRVAL('actor.usr_address_id_seq')
1288 WHERE id=CURRVAL('actor.usr_id_seq');
1290 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1291 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1293 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1294 FROM actor.org_unit aou
1295 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1297 INSERT INTO actor.usr
1298 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1299 VALUES (11, 3, 'mmeeks', 4, 'Meeks', 'michellem1234',
1300 'Michelle', 'Myra', NOW() + '3 years'::INTERVAL, '1966-01-23', 'III');
1302 INSERT INTO actor.usr_address
1303 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1304 VALUES ('USA', 'f', '88240', '7269 Sister Gardens', 'f',
1305 'NM', 'Hobbs', '', 'Lea', CURRVAL('actor.usr_id_seq'));
1307 INSERT INTO actor.card (barcode, usr)
1308 VALUES ('99999396672', CURRVAL('actor.usr_id_seq'));
1310 UPDATE actor.usr SET
1311 card = CURRVAL('actor.card_id_seq'),
1312 billing_address = CURRVAL('actor.usr_address_id_seq'),
1313 credit_forward_balance = '0',
1314 mailing_address = CURRVAL('actor.usr_address_id_seq')
1315 WHERE id=CURRVAL('actor.usr_id_seq');
1317 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1318 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1320 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1321 FROM actor.org_unit aou
1322 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1324 INSERT INTO actor.usr
1325 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1326 VALUES (11, 3, 'epalmer', 4, 'Palmer', 'elvap1234',
1327 'Elva', 'Tiffany', NOW() + '3 years'::INTERVAL, '1987-08-21', 'Jr');
1329 INSERT INTO actor.usr_address
1330 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1331 VALUES ('USA', 't', '50595', '7864 Remarkable Status River', 'f',
1332 'IA', 'Webster city', '', 'Hamilton', CURRVAL('actor.usr_id_seq'));
1334 INSERT INTO actor.card (barcode, usr)
1335 VALUES ('99999335171', CURRVAL('actor.usr_id_seq'));
1337 UPDATE actor.usr SET
1338 card = CURRVAL('actor.card_id_seq'),
1339 billing_address = CURRVAL('actor.usr_address_id_seq'),
1340 credit_forward_balance = '0',
1341 mailing_address = CURRVAL('actor.usr_address_id_seq')
1342 WHERE id=CURRVAL('actor.usr_id_seq');
1344 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1345 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1347 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1348 FROM actor.org_unit aou
1349 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1351 INSERT INTO actor.usr
1352 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1353 VALUES (10, 3, 'mwilliams', 9, 'Williams', 'mattheww1234',
1354 'Matthew', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1356 INSERT INTO actor.usr_address
1357 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1358 VALUES ('USA', 'f', '60064', '7230 Trend Mount', 'f',
1359 'IL', 'North chicago', '', 'Lake', CURRVAL('actor.usr_id_seq'));
1361 INSERT INTO actor.card (barcode, usr)
1362 VALUES ('99999365046', CURRVAL('actor.usr_id_seq'));
1364 UPDATE actor.usr SET
1365 card = CURRVAL('actor.card_id_seq'),
1366 billing_address = CURRVAL('actor.usr_address_id_seq'),
1367 credit_forward_balance = '0',
1368 mailing_address = CURRVAL('actor.usr_address_id_seq')
1369 WHERE id=CURRVAL('actor.usr_id_seq');
1371 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1372 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1374 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1375 FROM actor.org_unit aou
1376 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1378 INSERT INTO actor.usr
1379 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1380 VALUES (10, 1, 'nperez', 9, 'Perez', 'nicholasp1234',
1381 'Nicholas', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, NULL);
1383 INSERT INTO actor.usr_address
1384 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1385 VALUES ('USA', 'f', '55076', '9299 Democratic Hill Cliffs', 'f',
1386 'MN', 'Inver grove heights', '', '', CURRVAL('actor.usr_id_seq'));
1388 INSERT INTO actor.card (barcode, usr)
1389 VALUES ('99999391887', CURRVAL('actor.usr_id_seq'));
1391 UPDATE actor.usr SET
1392 card = CURRVAL('actor.card_id_seq'),
1393 billing_address = CURRVAL('actor.usr_address_id_seq'),
1394 credit_forward_balance = '0',
1395 mailing_address = CURRVAL('actor.usr_address_id_seq')
1396 WHERE id=CURRVAL('actor.usr_id_seq');
1398 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1399 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1401 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1402 FROM actor.org_unit aou
1403 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1405 INSERT INTO actor.usr
1406 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1407 VALUES (10, 3, 'bfisher', 8, 'Fisher', 'barbaraf1234',
1408 'Barbara', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1410 INSERT INTO actor.usr_address
1411 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1412 VALUES ('USA', 't', '61756', '9822 Excess Start Lock', 'f',
1413 'IL', 'Maroa', '', 'Macon', CURRVAL('actor.usr_id_seq'));
1415 INSERT INTO actor.card (barcode, usr)
1416 VALUES ('99999325028', CURRVAL('actor.usr_id_seq'));
1418 UPDATE actor.usr SET
1419 card = CURRVAL('actor.card_id_seq'),
1420 billing_address = CURRVAL('actor.usr_address_id_seq'),
1421 credit_forward_balance = '0',
1422 mailing_address = CURRVAL('actor.usr_address_id_seq')
1423 WHERE id=CURRVAL('actor.usr_id_seq');
1425 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1426 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1428 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1429 FROM actor.org_unit aou
1430 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1432 INSERT INTO actor.usr
1433 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1434 VALUES (10, 3, 'mmendoza', 8, 'Mendoza', 'miguelm1234',
1435 'Miguel', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1437 INSERT INTO actor.usr_address
1438 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1439 VALUES ('USA', 'f', '58773', '5831 Residential Respect Track', 'f',
1440 'ND', 'Powers lake', '', 'Burke', CURRVAL('actor.usr_id_seq'));
1442 INSERT INTO actor.card (barcode, usr)
1443 VALUES ('99999338966', CURRVAL('actor.usr_id_seq'));
1445 UPDATE actor.usr SET
1446 card = CURRVAL('actor.card_id_seq'),
1447 billing_address = CURRVAL('actor.usr_address_id_seq'),
1448 credit_forward_balance = '0',
1449 mailing_address = CURRVAL('actor.usr_address_id_seq')
1450 WHERE id=CURRVAL('actor.usr_id_seq');
1452 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1453 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1455 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1456 FROM actor.org_unit aou
1457 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1459 INSERT INTO actor.usr
1460 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1461 VALUES (10, 1, 'ldickinson', 7, 'Dickinson', 'leed1234',
1462 'Lee', 'Annie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1464 INSERT INTO actor.usr_address
1465 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1466 VALUES ('USA', 't', '12803', '5030 Vision Loop', 'f',
1467 'NY', 'South glens falls', '', 'Saratoga', CURRVAL('actor.usr_id_seq'));
1469 INSERT INTO actor.card (barcode, usr)
1470 VALUES ('99999328210', CURRVAL('actor.usr_id_seq'));
1472 UPDATE actor.usr SET
1473 card = CURRVAL('actor.card_id_seq'),
1474 billing_address = CURRVAL('actor.usr_address_id_seq'),
1475 credit_forward_balance = '0',
1476 mailing_address = CURRVAL('actor.usr_address_id_seq')
1477 WHERE id=CURRVAL('actor.usr_id_seq');
1479 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1480 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1482 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1483 FROM actor.org_unit aou
1484 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1486 INSERT INTO actor.usr
1487 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1488 VALUES (10, 1, 'awilliams', 7, 'Williams', 'angelinaw1234',
1489 'Angelina', 'Joan', NOW() + '3 years'::INTERVAL, NULL, NULL);
1491 INSERT INTO actor.usr_address
1492 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1493 VALUES ('USA', 't', '25054', '1723 Multiple Object Canyon', 'f',
1494 'WV', 'Dawes', '', 'Kanawha', CURRVAL('actor.usr_id_seq'));
1496 INSERT INTO actor.card (barcode, usr)
1497 VALUES ('99999373939', CURRVAL('actor.usr_id_seq'));
1499 UPDATE actor.usr SET
1500 card = CURRVAL('actor.card_id_seq'),
1501 billing_address = CURRVAL('actor.usr_address_id_seq'),
1502 credit_forward_balance = '0',
1503 mailing_address = CURRVAL('actor.usr_address_id_seq')
1504 WHERE id=CURRVAL('actor.usr_id_seq');
1506 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1507 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1509 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1510 FROM actor.org_unit aou
1511 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1513 INSERT INTO actor.usr
1514 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1515 VALUES (10, 1, 'bsanchez', 6, 'Sanchez', 'beths1234',
1516 'Beth', 'Deborah', NOW() + '3 years'::INTERVAL, NULL, NULL);
1518 INSERT INTO actor.usr_address
1519 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1520 VALUES ('USA', 'f', '36426', '5148 Shaggy Farm Center', 'f',
1521 'AL', 'Brewton', '', 'Escambia', CURRVAL('actor.usr_id_seq'));
1523 INSERT INTO actor.card (barcode, usr)
1524 VALUES ('99999354471', CURRVAL('actor.usr_id_seq'));
1526 UPDATE actor.usr SET
1527 card = CURRVAL('actor.card_id_seq'),
1528 billing_address = CURRVAL('actor.usr_address_id_seq'),
1529 credit_forward_balance = '0',
1530 mailing_address = CURRVAL('actor.usr_address_id_seq')
1531 WHERE id=CURRVAL('actor.usr_id_seq');
1533 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1534 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1536 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1537 FROM actor.org_unit aou
1538 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1540 INSERT INTO actor.usr
1541 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1542 VALUES (10, 3, 'ethompson', 6, 'Thompson', 'elvint1234',
1543 'Elvin', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1545 INSERT INTO actor.usr_address
1546 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1547 VALUES ('USA', 't', '67664', '2800 Cheerful Animal Valley', 'f',
1548 'KS', 'Prairie view', '', '', CURRVAL('actor.usr_id_seq'));
1550 INSERT INTO actor.card (barcode, usr)
1551 VALUES ('99999320974', CURRVAL('actor.usr_id_seq'));
1553 UPDATE actor.usr SET
1554 card = CURRVAL('actor.card_id_seq'),
1555 billing_address = CURRVAL('actor.usr_address_id_seq'),
1556 credit_forward_balance = '0',
1557 mailing_address = CURRVAL('actor.usr_address_id_seq')
1558 WHERE id=CURRVAL('actor.usr_id_seq');
1560 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1561 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1563 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1564 FROM actor.org_unit aou
1565 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1567 INSERT INTO actor.usr
1568 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1569 VALUES (10, 1, 'dlawson', 5, 'Lawson', 'doral1234',
1570 'Dora', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1572 INSERT INTO actor.usr_address
1573 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1574 VALUES ('USA', 'f', '63957', '6016 General Dog Divide', 'f',
1575 'MO', 'Piedmont', '', 'Wayne', CURRVAL('actor.usr_id_seq'));
1577 INSERT INTO actor.card (barcode, usr)
1578 VALUES ('99999394437', CURRVAL('actor.usr_id_seq'));
1580 UPDATE actor.usr SET
1581 card = CURRVAL('actor.card_id_seq'),
1582 billing_address = CURRVAL('actor.usr_address_id_seq'),
1583 credit_forward_balance = '0',
1584 mailing_address = CURRVAL('actor.usr_address_id_seq')
1585 WHERE id=CURRVAL('actor.usr_id_seq');
1587 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1588 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1590 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1591 FROM actor.org_unit aou
1592 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1594 INSERT INTO actor.usr
1595 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1596 VALUES (10, 1, 'lvargas', 5, 'Vargas', 'laurav1234',
1597 'Laura', 'Mildred', NOW() + '3 years'::INTERVAL, '1989-07-04', 'III');
1599 INSERT INTO actor.usr_address
1600 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1601 VALUES ('USA', 't', '62526', '4689 Alert Minute Court', 'f',
1602 'IL', 'Decatur', '', '', CURRVAL('actor.usr_id_seq'));
1604 INSERT INTO actor.card (barcode, usr)
1605 VALUES ('99999317988', CURRVAL('actor.usr_id_seq'));
1607 UPDATE actor.usr SET
1608 card = CURRVAL('actor.card_id_seq'),
1609 billing_address = CURRVAL('actor.usr_address_id_seq'),
1610 credit_forward_balance = '0',
1611 mailing_address = CURRVAL('actor.usr_address_id_seq')
1612 WHERE id=CURRVAL('actor.usr_id_seq');
1614 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1615 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1617 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1618 FROM actor.org_unit aou
1619 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1621 INSERT INTO actor.usr
1622 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1623 VALUES (10, 3, 'wrandall', 4, 'Randall', 'williamr1234',
1624 'William', 'James', NOW() + '3 years'::INTERVAL, NULL, NULL);
1626 INSERT INTO actor.usr_address
1627 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1628 VALUES ('USA', 'f', '72117', '3448 Minor Solicitor Junction', 'f',
1629 'AR', 'North little rock', '', '', CURRVAL('actor.usr_id_seq'));
1631 INSERT INTO actor.card (barcode, usr)
1632 VALUES ('99999393617', CURRVAL('actor.usr_id_seq'));
1634 UPDATE actor.usr SET
1635 card = CURRVAL('actor.card_id_seq'),
1636 billing_address = CURRVAL('actor.usr_address_id_seq'),
1637 credit_forward_balance = '0',
1638 mailing_address = CURRVAL('actor.usr_address_id_seq')
1639 WHERE id=CURRVAL('actor.usr_id_seq');
1641 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1642 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1644 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1645 FROM actor.org_unit aou
1646 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1648 INSERT INTO actor.usr
1649 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1650 VALUES (10, 1, 'csmith', 4, 'Smith', 'cathys1234',
1651 'Cathy', 'Cheryl', NOW() + '3 years'::INTERVAL, NULL, NULL);
1653 INSERT INTO actor.usr_address
1654 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1655 VALUES ('USA', 'f', '81420', '784 Striking Theatre Fords', 't',
1656 'CO', 'Lazear', '', 'Delta', CURRVAL('actor.usr_id_seq'));
1658 INSERT INTO actor.card (barcode, usr)
1659 VALUES ('99999389406', CURRVAL('actor.usr_id_seq'));
1661 UPDATE actor.usr SET
1662 card = CURRVAL('actor.card_id_seq'),
1663 billing_address = CURRVAL('actor.usr_address_id_seq'),
1664 credit_forward_balance = '0',
1665 mailing_address = CURRVAL('actor.usr_address_id_seq')
1666 WHERE id=CURRVAL('actor.usr_id_seq');
1668 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1669 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1671 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1672 FROM actor.org_unit aou
1673 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1675 INSERT INTO actor.usr
1676 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1677 VALUES (9, 1, 'alopez', 9, 'Lopez', 'arlinel1234',
1678 'Arline', 'Amber', NOW() + '3 years'::INTERVAL, '1985-05-05', 'III');
1680 INSERT INTO actor.usr_address
1681 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1682 VALUES ('USA', 't', '19053', '5012 Unemployed Other Harbor', 'f',
1683 'PA', 'Feasterville trevose', '', 'Bucks', CURRVAL('actor.usr_id_seq'));
1685 INSERT INTO actor.card (barcode, usr)
1686 VALUES ('99999330939', CURRVAL('actor.usr_id_seq'));
1688 UPDATE actor.usr SET
1689 card = CURRVAL('actor.card_id_seq'),
1690 billing_address = CURRVAL('actor.usr_address_id_seq'),
1691 credit_forward_balance = '0',
1692 mailing_address = CURRVAL('actor.usr_address_id_seq')
1693 WHERE id=CURRVAL('actor.usr_id_seq');
1695 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1696 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1698 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1699 FROM actor.org_unit aou
1700 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1702 INSERT INTO actor.usr
1703 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1704 VALUES (9, 1, 'epeterson', 9, 'Peterson', 'emmap1234',
1705 'Emma', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1707 INSERT INTO actor.usr_address
1708 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1709 VALUES ('USA', 't', '07095', '9931 Hushed Passage Turnpike', 'f',
1710 'NJ', 'Woodbridge', '', 'Middlesex', CURRVAL('actor.usr_id_seq'));
1712 INSERT INTO actor.card (barcode, usr)
1713 VALUES ('99999346297', CURRVAL('actor.usr_id_seq'));
1715 UPDATE actor.usr SET
1716 card = CURRVAL('actor.card_id_seq'),
1717 billing_address = CURRVAL('actor.usr_address_id_seq'),
1718 credit_forward_balance = '0',
1719 mailing_address = CURRVAL('actor.usr_address_id_seq')
1720 WHERE id=CURRVAL('actor.usr_id_seq');
1722 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1723 VALUES (CURRVAL('actor.usr_id_seq'), 9);
1725 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1726 FROM actor.org_unit aou
1727 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
1729 INSERT INTO actor.usr
1730 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1731 VALUES (9, 1, 'okelly', 8, 'Kelly', 'opalk1234',
1732 'Opal', 'Sara', NOW() + '3 years'::INTERVAL, '1975-01-18', 'III');
1734 INSERT INTO actor.usr_address
1735 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1736 VALUES ('USA', 't', '79550', '8572 Ltd Bar Brook', 't',
1737 'TX', 'Snyder', '', 'Scurry', CURRVAL('actor.usr_id_seq'));
1739 INSERT INTO actor.card (barcode, usr)
1740 VALUES ('99999355455', CURRVAL('actor.usr_id_seq'));
1742 UPDATE actor.usr SET
1743 card = CURRVAL('actor.card_id_seq'),
1744 billing_address = CURRVAL('actor.usr_address_id_seq'),
1745 credit_forward_balance = '0',
1746 mailing_address = CURRVAL('actor.usr_address_id_seq')
1747 WHERE id=CURRVAL('actor.usr_id_seq');
1749 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1750 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1752 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1753 FROM actor.org_unit aou
1754 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1756 INSERT INTO actor.usr
1757 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1758 VALUES (9, 1, 'cdonovan', 8, 'Donovan', 'charlied1234',
1759 'Charlie', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL);
1761 INSERT INTO actor.usr_address
1762 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1763 VALUES ('USA', 'f', '54017', '1926 Double Effort Spring', 'f',
1764 'WI', 'New richmond', '', '', CURRVAL('actor.usr_id_seq'));
1766 INSERT INTO actor.card (barcode, usr)
1767 VALUES ('99999348978', CURRVAL('actor.usr_id_seq'));
1769 UPDATE actor.usr SET
1770 card = CURRVAL('actor.card_id_seq'),
1771 billing_address = CURRVAL('actor.usr_address_id_seq'),
1772 credit_forward_balance = '0',
1773 mailing_address = CURRVAL('actor.usr_address_id_seq')
1774 WHERE id=CURRVAL('actor.usr_id_seq');
1776 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1777 VALUES (CURRVAL('actor.usr_id_seq'), 8);
1779 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1780 FROM actor.org_unit aou
1781 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
1783 INSERT INTO actor.usr
1784 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1785 VALUES (9, 3, 'msmith', 7, 'Smith', 'marthas1234',
1786 'Martha', 'Raquel', NOW() + '3 years'::INTERVAL, NULL, NULL);
1788 INSERT INTO actor.usr_address
1789 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1790 VALUES ('USA', 'f', '80534', '7185 Arbitrary Contrast Freeway', 'f',
1791 'CO', 'Johnstown', '', 'Weld', CURRVAL('actor.usr_id_seq'));
1793 INSERT INTO actor.card (barcode, usr)
1794 VALUES ('99999394964', CURRVAL('actor.usr_id_seq'));
1796 UPDATE actor.usr SET
1797 card = CURRVAL('actor.card_id_seq'),
1798 billing_address = CURRVAL('actor.usr_address_id_seq'),
1799 credit_forward_balance = '0',
1800 mailing_address = CURRVAL('actor.usr_address_id_seq')
1801 WHERE id=CURRVAL('actor.usr_id_seq');
1803 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1804 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1806 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1807 FROM actor.org_unit aou
1808 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1810 INSERT INTO actor.usr
1811 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1812 VALUES (9, 3, 'chouston', 7, 'Houston', 'cherylh1234',
1813 'Cheryl', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1815 INSERT INTO actor.usr_address
1816 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1817 VALUES ('USA', 't', '93703', '2782 Awake Day Square', 't',
1818 'CA', 'Fresno', '', 'Fresno', CURRVAL('actor.usr_id_seq'));
1820 INSERT INTO actor.card (barcode, usr)
1821 VALUES ('99999320969', CURRVAL('actor.usr_id_seq'));
1823 UPDATE actor.usr SET
1824 card = CURRVAL('actor.card_id_seq'),
1825 billing_address = CURRVAL('actor.usr_address_id_seq'),
1826 credit_forward_balance = '0',
1827 mailing_address = CURRVAL('actor.usr_address_id_seq')
1828 WHERE id=CURRVAL('actor.usr_id_seq');
1830 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1831 VALUES (CURRVAL('actor.usr_id_seq'), 7);
1833 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1834 FROM actor.org_unit aou
1835 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
1837 INSERT INTO actor.usr
1838 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1839 VALUES (9, 1, 'kwright', 6, 'Wright', 'kayw1234',
1840 'Kay', 'Anna', NOW() + '3 years'::INTERVAL, NULL, NULL);
1842 INSERT INTO actor.usr_address
1843 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1844 VALUES ('USA', 'f', '22834', '4585 Whole Harbor', 't',
1845 'VA', 'Linville', '', '', CURRVAL('actor.usr_id_seq'));
1847 INSERT INTO actor.card (barcode, usr)
1848 VALUES ('99999398195', CURRVAL('actor.usr_id_seq'));
1850 UPDATE actor.usr SET
1851 card = CURRVAL('actor.card_id_seq'),
1852 billing_address = CURRVAL('actor.usr_address_id_seq'),
1853 credit_forward_balance = '0',
1854 mailing_address = CURRVAL('actor.usr_address_id_seq')
1855 WHERE id=CURRVAL('actor.usr_id_seq');
1857 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1858 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1860 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1861 FROM actor.org_unit aou
1862 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1864 INSERT INTO actor.usr
1865 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1866 VALUES (9, 3, 'mlane', 6, 'Lane', 'michellel1234',
1867 'Michelle', 'Andrea', NOW() + '3 years'::INTERVAL, '1963-06-14', 'Sr');
1869 INSERT INTO actor.usr_address
1870 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1871 VALUES ('USA', 't', '98110', '8676 Thundering Loss Field', 't',
1872 'WA', 'Bainbridge island', '', 'Kitsap', CURRVAL('actor.usr_id_seq'));
1874 INSERT INTO actor.card (barcode, usr)
1875 VALUES ('99999333153', CURRVAL('actor.usr_id_seq'));
1877 UPDATE actor.usr SET
1878 card = CURRVAL('actor.card_id_seq'),
1879 billing_address = CURRVAL('actor.usr_address_id_seq'),
1880 credit_forward_balance = '0',
1881 mailing_address = CURRVAL('actor.usr_address_id_seq')
1882 WHERE id=CURRVAL('actor.usr_id_seq');
1884 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1885 VALUES (CURRVAL('actor.usr_id_seq'), 6);
1887 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1888 FROM actor.org_unit aou
1889 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
1891 INSERT INTO actor.usr
1892 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1893 VALUES (9, 1, 'rsmith', 5, 'Smith', 'roberts1234',
1894 'Robert', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1896 INSERT INTO actor.usr_address
1897 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1898 VALUES ('USA', 't', '00983', '231 Causal Expert Highway', 'f',
1899 'PR', 'Carolina', '', 'Carolina', CURRVAL('actor.usr_id_seq'));
1901 INSERT INTO actor.card (barcode, usr)
1902 VALUES ('99999362675', CURRVAL('actor.usr_id_seq'));
1904 UPDATE actor.usr SET
1905 card = CURRVAL('actor.card_id_seq'),
1906 billing_address = CURRVAL('actor.usr_address_id_seq'),
1907 credit_forward_balance = '0',
1908 mailing_address = CURRVAL('actor.usr_address_id_seq')
1909 WHERE id=CURRVAL('actor.usr_id_seq');
1911 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1912 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1914 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1915 FROM actor.org_unit aou
1916 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1918 INSERT INTO actor.usr
1919 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1920 VALUES (9, 1, 'cdodson', 5, 'Dodson', 'cleod1234',
1921 'Cleo', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1923 INSERT INTO actor.usr_address
1924 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1925 VALUES ('USA', 't', '25266', '53 Nice Customer Green', 'f',
1926 'WV', 'Newton', '', 'Roane', CURRVAL('actor.usr_id_seq'));
1928 INSERT INTO actor.card (barcode, usr)
1929 VALUES ('99999362218', CURRVAL('actor.usr_id_seq'));
1931 UPDATE actor.usr SET
1932 card = CURRVAL('actor.card_id_seq'),
1933 billing_address = CURRVAL('actor.usr_address_id_seq'),
1934 credit_forward_balance = '0',
1935 mailing_address = CURRVAL('actor.usr_address_id_seq')
1936 WHERE id=CURRVAL('actor.usr_id_seq');
1938 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1939 VALUES (CURRVAL('actor.usr_id_seq'), 5);
1941 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1942 FROM actor.org_unit aou
1943 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
1945 INSERT INTO actor.usr
1946 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1947 VALUES (9, 1, 'mneal', 4, 'Neal', 'melvinn1234',
1948 'Melvin', 'Richard', NOW() + '3 years'::INTERVAL, NULL, NULL);
1950 INSERT INTO actor.usr_address
1951 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1952 VALUES ('USA', 't', '10150', '668 Unconscious Gun Spring', 'f',
1953 'NY', 'New york', '', 'New york', CURRVAL('actor.usr_id_seq'));
1955 INSERT INTO actor.card (barcode, usr)
1956 VALUES ('99999317310', CURRVAL('actor.usr_id_seq'));
1958 UPDATE actor.usr SET
1959 card = CURRVAL('actor.card_id_seq'),
1960 billing_address = CURRVAL('actor.usr_address_id_seq'),
1961 credit_forward_balance = '0',
1962 mailing_address = CURRVAL('actor.usr_address_id_seq')
1963 WHERE id=CURRVAL('actor.usr_id_seq');
1965 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1966 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1968 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1969 FROM actor.org_unit aou
1970 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1972 INSERT INTO actor.usr
1973 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1974 VALUES (9, 3, 'awilliams', 4, 'Williams', 'annaw1234',
1975 'Anna', 'Justine', NOW() + '3 years'::INTERVAL, NULL, NULL);
1977 INSERT INTO actor.usr_address
1978 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1979 VALUES ('USA', 'f', '45809', '749 Software Center', 't',
1980 'OH', 'Gomer', '', 'Allen', CURRVAL('actor.usr_id_seq'));
1982 INSERT INTO actor.card (barcode, usr)
1983 VALUES ('99999392361', CURRVAL('actor.usr_id_seq'));
1985 UPDATE actor.usr SET
1986 card = CURRVAL('actor.card_id_seq'),
1987 billing_address = CURRVAL('actor.usr_address_id_seq'),
1988 credit_forward_balance = '0',
1989 mailing_address = CURRVAL('actor.usr_address_id_seq')
1990 WHERE id=CURRVAL('actor.usr_id_seq');
1992 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
1993 VALUES (CURRVAL('actor.usr_id_seq'), 4);
1995 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
1996 FROM actor.org_unit aou
1997 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
1999 INSERT INTO actor.usr
2000 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2001 VALUES (8, 1, 'emiller', 9, 'Miller', 'edmondm1234',
2002 'Edmond', 'Vance', NOW() + '3 years'::INTERVAL, NULL, NULL);
2004 INSERT INTO actor.usr_address
2005 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2006 VALUES ('USA', 'f', '92007', '2632 Unlikely Assumption Tunnel', 'f',
2007 'CA', 'Cardiff by the sea', '', 'San diego', CURRVAL('actor.usr_id_seq'));
2009 INSERT INTO actor.card (barcode, usr)
2010 VALUES ('99999371777', CURRVAL('actor.usr_id_seq'));
2012 UPDATE actor.usr SET
2013 card = CURRVAL('actor.card_id_seq'),
2014 billing_address = CURRVAL('actor.usr_address_id_seq'),
2015 credit_forward_balance = '0',
2016 mailing_address = CURRVAL('actor.usr_address_id_seq')
2017 WHERE id=CURRVAL('actor.usr_id_seq');
2019 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2020 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2022 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2023 FROM actor.org_unit aou
2024 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2026 INSERT INTO actor.usr
2027 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2028 VALUES (8, 3, 'vlogan', 9, 'Logan', 'vanessal1234',
2029 'Vanessa', 'Cassandra', NOW() + '3 years'::INTERVAL, NULL, NULL);
2031 INSERT INTO actor.usr_address
2032 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2033 VALUES ('USA', 'f', '44470', '2823 Eventual Hour Gateway', 'f',
2034 'OH', 'Southington', '', 'Trumbull', CURRVAL('actor.usr_id_seq'));
2036 INSERT INTO actor.card (barcode, usr)
2037 VALUES ('99999372363', CURRVAL('actor.usr_id_seq'));
2039 UPDATE actor.usr SET
2040 card = CURRVAL('actor.card_id_seq'),
2041 billing_address = CURRVAL('actor.usr_address_id_seq'),
2042 credit_forward_balance = '0',
2043 mailing_address = CURRVAL('actor.usr_address_id_seq')
2044 WHERE id=CURRVAL('actor.usr_id_seq');
2046 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2047 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2049 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2050 FROM actor.org_unit aou
2051 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2053 INSERT INTO actor.usr
2054 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2055 VALUES (8, 1, 'lthompson', 8, 'Thompson', 'lisat1234',
2056 'Lisa', 'Shirley', NOW() + '3 years'::INTERVAL, NULL, NULL);
2058 INSERT INTO actor.usr_address
2059 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2060 VALUES ('USA', 'f', '45690', '2166 Newspaper Grove', 't',
2061 'OH', 'Waverly', '', 'Pike', CURRVAL('actor.usr_id_seq'));
2063 INSERT INTO actor.card (barcode, usr)
2064 VALUES ('99999321149', CURRVAL('actor.usr_id_seq'));
2066 UPDATE actor.usr SET
2067 card = CURRVAL('actor.card_id_seq'),
2068 billing_address = CURRVAL('actor.usr_address_id_seq'),
2069 credit_forward_balance = '0',
2070 mailing_address = CURRVAL('actor.usr_address_id_seq')
2071 WHERE id=CURRVAL('actor.usr_id_seq');
2073 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2074 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2076 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2077 FROM actor.org_unit aou
2078 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2080 INSERT INTO actor.usr
2081 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2082 VALUES (8, 1, 'oshaffer', 8, 'Shaffer', 'ollies1234',
2083 'Ollie', 'Monica', NOW() + '3 years'::INTERVAL, NULL, NULL);
2085 INSERT INTO actor.usr_address
2086 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2087 VALUES ('USA', 't', '15534', '2134 Inc Boat Turnpike', 't',
2088 'PA', 'Buffalo mills', '', 'Bedford', CURRVAL('actor.usr_id_seq'));
2090 INSERT INTO actor.card (barcode, usr)
2091 VALUES ('99999335455', CURRVAL('actor.usr_id_seq'));
2093 UPDATE actor.usr SET
2094 card = CURRVAL('actor.card_id_seq'),
2095 billing_address = CURRVAL('actor.usr_address_id_seq'),
2096 credit_forward_balance = '0',
2097 mailing_address = CURRVAL('actor.usr_address_id_seq')
2098 WHERE id=CURRVAL('actor.usr_id_seq');
2100 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2101 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2103 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2104 FROM actor.org_unit aou
2105 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2107 INSERT INTO actor.usr
2108 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2109 VALUES (8, 1, 'randrews', 7, 'Andrews', 'raymonda1234',
2110 'Raymond', 'Willie', NOW() + '3 years'::INTERVAL, NULL, NULL);
2112 INSERT INTO actor.usr_address
2113 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2114 VALUES ('USA', 'f', '06018', '1944 Hot Tape Valley', 't',
2115 'CT', 'Canaan', '', '', CURRVAL('actor.usr_id_seq'));
2117 INSERT INTO actor.card (barcode, usr)
2118 VALUES ('99999346031', CURRVAL('actor.usr_id_seq'));
2120 UPDATE actor.usr SET
2121 card = CURRVAL('actor.card_id_seq'),
2122 billing_address = CURRVAL('actor.usr_address_id_seq'),
2123 credit_forward_balance = '0',
2124 mailing_address = CURRVAL('actor.usr_address_id_seq')
2125 WHERE id=CURRVAL('actor.usr_id_seq');
2127 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2128 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2130 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2131 FROM actor.org_unit aou
2132 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2134 INSERT INTO actor.usr
2135 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2136 VALUES (8, 3, 'emartinez', 7, 'Martinez', 'ednam1234',
2137 'Edna', 'Judith', NOW() + '3 years'::INTERVAL, NULL, NULL);
2139 INSERT INTO actor.usr_address
2140 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2141 VALUES ('USA', 't', '49270', '121 Consequence Club', 'f',
2142 'MI', 'Petersburg', '', '', CURRVAL('actor.usr_id_seq'));
2144 INSERT INTO actor.card (barcode, usr)
2145 VALUES ('99999336926', CURRVAL('actor.usr_id_seq'));
2147 UPDATE actor.usr SET
2148 card = CURRVAL('actor.card_id_seq'),
2149 billing_address = CURRVAL('actor.usr_address_id_seq'),
2150 credit_forward_balance = '0',
2151 mailing_address = CURRVAL('actor.usr_address_id_seq')
2152 WHERE id=CURRVAL('actor.usr_id_seq');
2154 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2155 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2157 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2158 FROM actor.org_unit aou
2159 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2161 INSERT INTO actor.usr
2162 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2163 VALUES (8, 3, 'jdavis', 6, 'Davis', 'jamesd1234',
2164 'James', 'Jerry', NOW() + '3 years'::INTERVAL, '1970-06-11', 'III');
2166 INSERT INTO actor.usr_address
2167 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2168 VALUES ('USA', 'f', '58064', '5708 Brainy West Bend', 'f',
2169 'ND', 'Page', '', 'Cass', CURRVAL('actor.usr_id_seq'));
2171 INSERT INTO actor.card (barcode, usr)
2172 VALUES ('99999363070', CURRVAL('actor.usr_id_seq'));
2174 UPDATE actor.usr SET
2175 card = CURRVAL('actor.card_id_seq'),
2176 billing_address = CURRVAL('actor.usr_address_id_seq'),
2177 credit_forward_balance = '0',
2178 mailing_address = CURRVAL('actor.usr_address_id_seq')
2179 WHERE id=CURRVAL('actor.usr_id_seq');
2181 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2182 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2184 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2185 FROM actor.org_unit aou
2186 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2188 INSERT INTO actor.usr
2189 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2190 VALUES (8, 1, 'droberts', 6, 'Roberts', 'dianer1234',
2191 'Diane', 'Teresa', NOW() + '3 years'::INTERVAL, NULL, NULL);
2193 INSERT INTO actor.usr_address
2194 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2195 VALUES ('USA', 'f', '00692', '9609 Advanced Tool Mountain', 't',
2196 'PR', 'Vega alta', '', 'Vega alta', CURRVAL('actor.usr_id_seq'));
2198 INSERT INTO actor.card (barcode, usr)
2199 VALUES ('99999357381', CURRVAL('actor.usr_id_seq'));
2201 UPDATE actor.usr SET
2202 card = CURRVAL('actor.card_id_seq'),
2203 billing_address = CURRVAL('actor.usr_address_id_seq'),
2204 credit_forward_balance = '0',
2205 mailing_address = CURRVAL('actor.usr_address_id_seq')
2206 WHERE id=CURRVAL('actor.usr_id_seq');
2208 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2209 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2211 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2212 FROM actor.org_unit aou
2213 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2215 INSERT INTO actor.usr
2216 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2217 VALUES (8, 1, 'psantiago', 5, 'Santiago', 'paiges1234',
2218 'Paige', 'Helen', NOW() + '3 years'::INTERVAL, '1979-08-23', 'Sr');
2220 INSERT INTO actor.usr_address
2221 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2222 VALUES ('USA', 't', '91608', '2852 Key Incident Avenue', 't',
2223 'CA', 'Universal city', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
2225 INSERT INTO actor.card (barcode, usr)
2226 VALUES ('99999394956', CURRVAL('actor.usr_id_seq'));
2228 UPDATE actor.usr SET
2229 card = CURRVAL('actor.card_id_seq'),
2230 billing_address = CURRVAL('actor.usr_address_id_seq'),
2231 credit_forward_balance = '0',
2232 mailing_address = CURRVAL('actor.usr_address_id_seq')
2233 WHERE id=CURRVAL('actor.usr_id_seq');
2235 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2236 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2238 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2239 FROM actor.org_unit aou
2240 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2242 INSERT INTO actor.usr
2243 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2244 VALUES (8, 1, 'awright', 5, 'Wright', 'alyssaw1234',
2245 'Alyssa', 'Christine', NOW() + '3 years'::INTERVAL, NULL, NULL);
2247 INSERT INTO actor.usr_address
2248 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2249 VALUES ('USA', 't', '80295', '7771 Alive Iron Mission', 'f',
2250 'CO', 'Denver', '', 'Denver', CURRVAL('actor.usr_id_seq'));
2252 INSERT INTO actor.card (barcode, usr)
2253 VALUES ('99999367802', CURRVAL('actor.usr_id_seq'));
2255 UPDATE actor.usr SET
2256 card = CURRVAL('actor.card_id_seq'),
2257 billing_address = CURRVAL('actor.usr_address_id_seq'),
2258 credit_forward_balance = '0',
2259 mailing_address = CURRVAL('actor.usr_address_id_seq')
2260 WHERE id=CURRVAL('actor.usr_id_seq');
2262 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2263 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2265 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2266 FROM actor.org_unit aou
2267 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2269 INSERT INTO actor.usr
2270 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2271 VALUES (8, 3, 'dbeck', 4, 'Beck', 'dianab1234',
2272 'Diana', 'Wilma', NOW() + '3 years'::INTERVAL, NULL, NULL);
2274 INSERT INTO actor.usr_address
2275 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2276 VALUES ('USA', 't', '58776', '1146 Ability Centers', 'f',
2277 'ND', 'Ross', '', 'Mountrail', CURRVAL('actor.usr_id_seq'));
2279 INSERT INTO actor.card (barcode, usr)
2280 VALUES ('99999361901', CURRVAL('actor.usr_id_seq'));
2282 UPDATE actor.usr SET
2283 card = CURRVAL('actor.card_id_seq'),
2284 billing_address = CURRVAL('actor.usr_address_id_seq'),
2285 credit_forward_balance = '0',
2286 mailing_address = CURRVAL('actor.usr_address_id_seq')
2287 WHERE id=CURRVAL('actor.usr_id_seq');
2289 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2290 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2292 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2293 FROM actor.org_unit aou
2294 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2296 INSERT INTO actor.usr
2297 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2298 VALUES (8, 1, 'mclark', 4, 'Clark', 'montyc1234',
2299 'Monty', 'Daniel', NOW() + '3 years'::INTERVAL, '1984-05-19', 'II');
2301 INSERT INTO actor.usr_address
2302 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2303 VALUES ('USA', 't', '55168', '3541 Radical Sir Avenue', 'f',
2304 'MN', 'Saint paul', '', 'Ramsey', CURRVAL('actor.usr_id_seq'));
2306 INSERT INTO actor.card (barcode, usr)
2307 VALUES ('99999381970', CURRVAL('actor.usr_id_seq'));
2309 UPDATE actor.usr SET
2310 card = CURRVAL('actor.card_id_seq'),
2311 billing_address = CURRVAL('actor.usr_address_id_seq'),
2312 credit_forward_balance = '0',
2313 mailing_address = CURRVAL('actor.usr_address_id_seq')
2314 WHERE id=CURRVAL('actor.usr_id_seq');
2316 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2317 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2319 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2320 FROM actor.org_unit aou
2321 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2323 INSERT INTO actor.usr
2324 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2325 VALUES (7, 3, 'hstone', 9, 'Stone', 'hazels1234',
2326 'Hazel', 'Sylvia', NOW() + '3 years'::INTERVAL, NULL, NULL);
2328 INSERT INTO actor.usr_address
2329 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2330 VALUES ('USA', 't', '93247', '4171 Impossible Defence Overpass', 'f',
2331 'CA', 'Lindsay', '', '', CURRVAL('actor.usr_id_seq'));
2333 INSERT INTO actor.card (barcode, usr)
2334 VALUES ('99999367834', CURRVAL('actor.usr_id_seq'));
2336 UPDATE actor.usr SET
2337 card = CURRVAL('actor.card_id_seq'),
2338 billing_address = CURRVAL('actor.usr_address_id_seq'),
2339 credit_forward_balance = '0',
2340 mailing_address = CURRVAL('actor.usr_address_id_seq')
2341 WHERE id=CURRVAL('actor.usr_id_seq');
2343 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2344 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2346 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2347 FROM actor.org_unit aou
2348 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2350 INSERT INTO actor.usr
2351 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2352 VALUES (7, 1, 'dgarza', 9, 'Garza', 'davidg1234',
2353 'David', 'Steven', NOW() + '3 years'::INTERVAL, NULL, NULL);
2355 INSERT INTO actor.usr_address
2356 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2357 VALUES ('USA', 't', '22513', '3627 Retail Kind Lodge', 'f',
2358 'VA', 'Merry point', '', 'Lancaster', CURRVAL('actor.usr_id_seq'));
2360 INSERT INTO actor.card (barcode, usr)
2361 VALUES ('99999377760', CURRVAL('actor.usr_id_seq'));
2363 UPDATE actor.usr SET
2364 card = CURRVAL('actor.card_id_seq'),
2365 billing_address = CURRVAL('actor.usr_address_id_seq'),
2366 credit_forward_balance = '0',
2367 mailing_address = CURRVAL('actor.usr_address_id_seq')
2368 WHERE id=CURRVAL('actor.usr_id_seq');
2370 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2371 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2373 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2374 FROM actor.org_unit aou
2375 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2377 INSERT INTO actor.usr
2378 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2379 VALUES (7, 3, 'jevans', 8, 'Evans', 'johne1234',
2380 'John', 'Timothy', NOW() + '3 years'::INTERVAL, NULL, NULL);
2382 INSERT INTO actor.usr_address
2383 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2384 VALUES ('USA', 't', '64778', '1212 Mid Top Parkway', 'f',
2385 'MO', 'Richards', '', 'Vernon', CURRVAL('actor.usr_id_seq'));
2387 INSERT INTO actor.card (barcode, usr)
2388 VALUES ('99999367573', CURRVAL('actor.usr_id_seq'));
2390 UPDATE actor.usr SET
2391 card = CURRVAL('actor.card_id_seq'),
2392 billing_address = CURRVAL('actor.usr_address_id_seq'),
2393 credit_forward_balance = '0',
2394 mailing_address = CURRVAL('actor.usr_address_id_seq')
2395 WHERE id=CURRVAL('actor.usr_id_seq');
2397 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2398 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2400 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2401 FROM actor.org_unit aou
2402 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2404 INSERT INTO actor.usr
2405 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2406 VALUES (7, 3, 'rpayton', 8, 'Payton', 'robertp1234',
2407 'Robert', 'Steven', NOW() + '3 years'::INTERVAL, '1994-05-07', 'Jr');
2409 INSERT INTO actor.usr_address
2410 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2411 VALUES ('USA', 't', '55336', '1642 Minor Potential Corners', 'f',
2412 'MN', 'Glencoe', '', '', CURRVAL('actor.usr_id_seq'));
2414 INSERT INTO actor.card (barcode, usr)
2415 VALUES ('99999394830', CURRVAL('actor.usr_id_seq'));
2417 UPDATE actor.usr SET
2418 card = CURRVAL('actor.card_id_seq'),
2419 billing_address = CURRVAL('actor.usr_address_id_seq'),
2420 credit_forward_balance = '0',
2421 mailing_address = CURRVAL('actor.usr_address_id_seq')
2422 WHERE id=CURRVAL('actor.usr_id_seq');
2424 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2425 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2427 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2428 FROM actor.org_unit aou
2429 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2431 INSERT INTO actor.usr
2432 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2433 VALUES (7, 3, 'ddavis', 7, 'Davis', 'donaldd1234',
2434 'Donald', 'Gene', NOW() + '3 years'::INTERVAL, NULL, NULL);
2436 INSERT INTO actor.usr_address
2437 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2438 VALUES ('USA', 'f', '48749', '5946 Gas Way', 't',
2439 'MI', 'Omer', '', 'Arenac', CURRVAL('actor.usr_id_seq'));
2441 INSERT INTO actor.card (barcode, usr)
2442 VALUES ('99999340278', CURRVAL('actor.usr_id_seq'));
2444 UPDATE actor.usr SET
2445 card = CURRVAL('actor.card_id_seq'),
2446 billing_address = CURRVAL('actor.usr_address_id_seq'),
2447 credit_forward_balance = '0',
2448 mailing_address = CURRVAL('actor.usr_address_id_seq')
2449 WHERE id=CURRVAL('actor.usr_id_seq');
2451 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2452 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2454 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2455 FROM actor.org_unit aou
2456 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2458 INSERT INTO actor.usr
2459 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2460 VALUES (7, 1, 'gadams', 7, 'Adams', 'genea1234',
2461 'Gene', '', NOW() + '3 years'::INTERVAL, '1974-02-18', 'III');
2463 INSERT INTO actor.usr_address
2464 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2465 VALUES ('USA', 't', '88525', '8265 Phone Trail', 't',
2466 'TX', 'El paso', '', 'El paso', CURRVAL('actor.usr_id_seq'));
2468 INSERT INTO actor.card (barcode, usr)
2469 VALUES ('99999349290', CURRVAL('actor.usr_id_seq'));
2471 UPDATE actor.usr SET
2472 card = CURRVAL('actor.card_id_seq'),
2473 billing_address = CURRVAL('actor.usr_address_id_seq'),
2474 credit_forward_balance = '0',
2475 mailing_address = CURRVAL('actor.usr_address_id_seq')
2476 WHERE id=CURRVAL('actor.usr_id_seq');
2478 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2479 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2481 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2482 FROM actor.org_unit aou
2483 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2485 INSERT INTO actor.usr
2486 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2487 VALUES (7, 1, 'hwhite', 6, 'White', 'humbertow1234',
2488 'Humberto', 'Kevin', NOW() + '3 years'::INTERVAL, '1997-09-08', 'Jr');
2490 INSERT INTO actor.usr_address
2491 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2492 VALUES ('USA', 'f', '25926', '6558 Willing Master Valley', 'f',
2493 'WV', 'Sprague', '', '', CURRVAL('actor.usr_id_seq'));
2495 INSERT INTO actor.card (barcode, usr)
2496 VALUES ('99999309750', CURRVAL('actor.usr_id_seq'));
2498 UPDATE actor.usr SET
2499 card = CURRVAL('actor.card_id_seq'),
2500 billing_address = CURRVAL('actor.usr_address_id_seq'),
2501 credit_forward_balance = '0',
2502 mailing_address = CURRVAL('actor.usr_address_id_seq')
2503 WHERE id=CURRVAL('actor.usr_id_seq');
2505 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2506 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2508 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2509 FROM actor.org_unit aou
2510 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2512 INSERT INTO actor.usr
2513 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2514 VALUES (7, 3, 'asnyder', 6, 'Snyder', 'anas1234',
2515 'Ana', '', NOW() + '3 years'::INTERVAL, '1991-05-23', 'III');
2517 INSERT INTO actor.usr_address
2518 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2519 VALUES ('USA', 't', '00922', '8532 Spare Offer Cliffs', 'f',
2520 'PR', 'San juan', '', 'San juan', CURRVAL('actor.usr_id_seq'));
2522 INSERT INTO actor.card (barcode, usr)
2523 VALUES ('99999332335', CURRVAL('actor.usr_id_seq'));
2525 UPDATE actor.usr SET
2526 card = CURRVAL('actor.card_id_seq'),
2527 billing_address = CURRVAL('actor.usr_address_id_seq'),
2528 credit_forward_balance = '0',
2529 mailing_address = CURRVAL('actor.usr_address_id_seq')
2530 WHERE id=CURRVAL('actor.usr_id_seq');
2532 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2533 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2535 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2536 FROM actor.org_unit aou
2537 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2539 INSERT INTO actor.usr
2540 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2541 VALUES (7, 1, 'jroberts', 5, 'Roberts', 'johnr1234',
2542 'John', 'Theodore', NOW() + '3 years'::INTERVAL, NULL, NULL);
2544 INSERT INTO actor.usr_address
2545 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2546 VALUES ('USA', 'f', '79550', '279 Passing Conference Street', 't',
2547 'TX', 'Snyder', '', 'Scurry', CURRVAL('actor.usr_id_seq'));
2549 INSERT INTO actor.card (barcode, usr)
2550 VALUES ('99999367122', CURRVAL('actor.usr_id_seq'));
2552 UPDATE actor.usr SET
2553 card = CURRVAL('actor.card_id_seq'),
2554 billing_address = CURRVAL('actor.usr_address_id_seq'),
2555 credit_forward_balance = '0',
2556 mailing_address = CURRVAL('actor.usr_address_id_seq')
2557 WHERE id=CURRVAL('actor.usr_id_seq');
2559 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2560 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2562 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2563 FROM actor.org_unit aou
2564 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2566 INSERT INTO actor.usr
2567 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2568 VALUES (7, 3, 'sheath', 5, 'Heath', 'stevenh1234',
2569 'Steven', 'Luke', NOW() + '3 years'::INTERVAL, NULL, NULL);
2571 INSERT INTO actor.usr_address
2572 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2573 VALUES ('USA', 'f', '94547', '4666 Pain Isle', 'f',
2574 'CA', 'Hercules', '', 'Contra costa', CURRVAL('actor.usr_id_seq'));
2576 INSERT INTO actor.card (barcode, usr)
2577 VALUES ('99999375796', CURRVAL('actor.usr_id_seq'));
2579 UPDATE actor.usr SET
2580 card = CURRVAL('actor.card_id_seq'),
2581 billing_address = CURRVAL('actor.usr_address_id_seq'),
2582 credit_forward_balance = '0',
2583 mailing_address = CURRVAL('actor.usr_address_id_seq')
2584 WHERE id=CURRVAL('actor.usr_id_seq');
2586 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2587 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2589 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2590 FROM actor.org_unit aou
2591 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2593 INSERT INTO actor.usr
2594 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2595 VALUES (7, 1, 'krush', 4, 'Rush', 'keithr1234',
2596 'Keith', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
2598 INSERT INTO actor.usr_address
2599 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2600 VALUES ('USA', 't', '15257', '4464 Sense Station', 'f',
2601 'PA', 'Pittsburgh', '', '', CURRVAL('actor.usr_id_seq'));
2603 INSERT INTO actor.card (barcode, usr)
2604 VALUES ('99999345655', CURRVAL('actor.usr_id_seq'));
2606 UPDATE actor.usr SET
2607 card = CURRVAL('actor.card_id_seq'),
2608 billing_address = CURRVAL('actor.usr_address_id_seq'),
2609 credit_forward_balance = '0',
2610 mailing_address = CURRVAL('actor.usr_address_id_seq')
2611 WHERE id=CURRVAL('actor.usr_id_seq');
2613 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2614 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2616 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2617 FROM actor.org_unit aou
2618 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2620 INSERT INTO actor.usr
2621 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2622 VALUES (7, 3, 'lfarrell', 4, 'Farrell', 'lindaf1234',
2623 'Linda', 'Linda', NOW() + '3 years'::INTERVAL, NULL, NULL);
2625 INSERT INTO actor.usr_address
2626 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2627 VALUES ('USA', 't', '75155', '7746 Cooperative Fall Shoal', 'f',
2628 'TX', 'Rice', '', 'Navarro', CURRVAL('actor.usr_id_seq'));
2630 INSERT INTO actor.card (barcode, usr)
2631 VALUES ('99999344872', CURRVAL('actor.usr_id_seq'));
2633 UPDATE actor.usr SET
2634 card = CURRVAL('actor.card_id_seq'),
2635 billing_address = CURRVAL('actor.usr_address_id_seq'),
2636 credit_forward_balance = '0',
2637 mailing_address = CURRVAL('actor.usr_address_id_seq')
2638 WHERE id=CURRVAL('actor.usr_id_seq');
2640 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2641 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2643 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2644 FROM actor.org_unit aou
2645 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2647 INSERT INTO actor.usr
2648 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2649 VALUES (6, 3, 'rharrison', 9, 'Harrison', 'richardh1234',
2650 'Richard', 'Melvin', NOW() + '3 years'::INTERVAL, NULL, NULL);
2652 INSERT INTO actor.usr_address
2653 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2654 VALUES ('USA', 't', '06601', '2896 Jewish Lack Lodge', 'f',
2655 'CT', 'Bridgeport', '', '', CURRVAL('actor.usr_id_seq'));
2657 INSERT INTO actor.card (barcode, usr)
2658 VALUES ('99999399702', CURRVAL('actor.usr_id_seq'));
2660 UPDATE actor.usr SET
2661 card = CURRVAL('actor.card_id_seq'),
2662 billing_address = CURRVAL('actor.usr_address_id_seq'),
2663 credit_forward_balance = '0',
2664 mailing_address = CURRVAL('actor.usr_address_id_seq')
2665 WHERE id=CURRVAL('actor.usr_id_seq');
2667 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2668 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2670 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2671 FROM actor.org_unit aou
2672 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2674 INSERT INTO actor.usr
2675 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2676 VALUES (6, 1, 'ksmith', 9, 'Smith', 'kevins1234',
2677 'Kevin', 'Timothy', NOW() + '3 years'::INTERVAL, NULL, NULL);
2679 INSERT INTO actor.usr_address
2680 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2681 VALUES ('USA', 'f', '81523', '5119 Lot Isle', 't',
2682 'CO', 'Glade park', '', 'Mesa', CURRVAL('actor.usr_id_seq'));
2684 INSERT INTO actor.card (barcode, usr)
2685 VALUES ('99999394646', CURRVAL('actor.usr_id_seq'));
2687 UPDATE actor.usr SET
2688 card = CURRVAL('actor.card_id_seq'),
2689 billing_address = CURRVAL('actor.usr_address_id_seq'),
2690 credit_forward_balance = '0',
2691 mailing_address = CURRVAL('actor.usr_address_id_seq')
2692 WHERE id=CURRVAL('actor.usr_id_seq');
2694 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2695 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2697 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2698 FROM actor.org_unit aou
2699 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2701 INSERT INTO actor.usr
2702 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2703 VALUES (6, 1, 'fmoore', 8, 'Moore', 'florencem1234',
2704 'Florence', 'Michelle', NOW() + '3 years'::INTERVAL, '1977-02-07', 'Jr');
2706 INSERT INTO actor.usr_address
2707 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2708 VALUES ('USA', 't', '39440', '6398 Mathematical Condition Arcade', 't',
2709 'MS', 'Laurel', '', '', CURRVAL('actor.usr_id_seq'));
2711 INSERT INTO actor.card (barcode, usr)
2712 VALUES ('99999341034', CURRVAL('actor.usr_id_seq'));
2714 UPDATE actor.usr SET
2715 card = CURRVAL('actor.card_id_seq'),
2716 billing_address = CURRVAL('actor.usr_address_id_seq'),
2717 credit_forward_balance = '0',
2718 mailing_address = CURRVAL('actor.usr_address_id_seq')
2719 WHERE id=CURRVAL('actor.usr_id_seq');
2721 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2722 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2724 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2725 FROM actor.org_unit aou
2726 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2728 INSERT INTO actor.usr
2729 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2730 VALUES (6, 1, 'bcruz', 8, 'Cruz', 'bettyc1234',
2731 'Betty', 'Shirley', NOW() + '3 years'::INTERVAL, '1993-08-10', 'Sr');
2733 INSERT INTO actor.usr_address
2734 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2735 VALUES ('USA', 'f', '33630', '1062 Scornful Air Fort', 'f',
2736 'FL', 'Tampa', '', 'Hillsborough', CURRVAL('actor.usr_id_seq'));
2738 INSERT INTO actor.card (barcode, usr)
2739 VALUES ('99999363183', CURRVAL('actor.usr_id_seq'));
2741 UPDATE actor.usr SET
2742 card = CURRVAL('actor.card_id_seq'),
2743 billing_address = CURRVAL('actor.usr_address_id_seq'),
2744 credit_forward_balance = '0',
2745 mailing_address = CURRVAL('actor.usr_address_id_seq')
2746 WHERE id=CURRVAL('actor.usr_id_seq');
2748 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2749 VALUES (CURRVAL('actor.usr_id_seq'), 8);
2751 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2752 FROM actor.org_unit aou
2753 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
2755 INSERT INTO actor.usr
2756 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2757 VALUES (6, 1, 'jjohnson', 7, 'Johnson', 'joelj1234',
2758 'Joel', 'Allen', NOW() + '3 years'::INTERVAL, NULL, NULL);
2760 INSERT INTO actor.usr_address
2761 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2762 VALUES ('USA', 'f', '36028', '3220 Drunk Message Parkway', 'f',
2763 'AL', 'Dozier', '', '', CURRVAL('actor.usr_id_seq'));
2765 INSERT INTO actor.card (barcode, usr)
2766 VALUES ('99999370090', CURRVAL('actor.usr_id_seq'));
2768 UPDATE actor.usr SET
2769 card = CURRVAL('actor.card_id_seq'),
2770 billing_address = CURRVAL('actor.usr_address_id_seq'),
2771 credit_forward_balance = '0',
2772 mailing_address = CURRVAL('actor.usr_address_id_seq')
2773 WHERE id=CURRVAL('actor.usr_id_seq');
2775 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2776 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2778 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2779 FROM actor.org_unit aou
2780 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2782 INSERT INTO actor.usr
2783 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2784 VALUES (6, 1, 'kburton', 7, 'Burton', 'kristenb1234',
2785 'Kristen', 'Dena', NOW() + '3 years'::INTERVAL, NULL, NULL);
2787 INSERT INTO actor.usr_address
2788 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2789 VALUES ('USA', 'f', '42413', '4924 Part-time Charge Knoll', 'f',
2790 'KY', 'Hanson', '', 'Hopkins', CURRVAL('actor.usr_id_seq'));
2792 INSERT INTO actor.card (barcode, usr)
2793 VALUES ('99999372936', CURRVAL('actor.usr_id_seq'));
2795 UPDATE actor.usr SET
2796 card = CURRVAL('actor.card_id_seq'),
2797 billing_address = CURRVAL('actor.usr_address_id_seq'),
2798 credit_forward_balance = '0',
2799 mailing_address = CURRVAL('actor.usr_address_id_seq')
2800 WHERE id=CURRVAL('actor.usr_id_seq');
2802 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2803 VALUES (CURRVAL('actor.usr_id_seq'), 7);
2805 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2806 FROM actor.org_unit aou
2807 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
2809 INSERT INTO actor.usr
2810 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2811 VALUES (6, 1, 'rpineda', 6, 'Pineda', 'robertp1234',
2812 'Robert', 'Gordon', NOW() + '3 years'::INTERVAL, NULL, NULL);
2814 INSERT INTO actor.usr_address
2815 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2816 VALUES ('USA', 'f', '47703', '1587 Labour Holiday Park', 't',
2817 'IN', 'Evansville', '', 'Vanderburgh', CURRVAL('actor.usr_id_seq'));
2819 INSERT INTO actor.card (barcode, usr)
2820 VALUES ('99999349988', CURRVAL('actor.usr_id_seq'));
2822 UPDATE actor.usr SET
2823 card = CURRVAL('actor.card_id_seq'),
2824 billing_address = CURRVAL('actor.usr_address_id_seq'),
2825 credit_forward_balance = '0',
2826 mailing_address = CURRVAL('actor.usr_address_id_seq')
2827 WHERE id=CURRVAL('actor.usr_id_seq');
2829 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2830 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2832 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2833 FROM actor.org_unit aou
2834 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2836 INSERT INTO actor.usr
2837 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2838 VALUES (6, 1, 'avaldez', 6, 'Valdez', 'alissav1234',
2839 'Alissa', 'Gladys', NOW() + '3 years'::INTERVAL, '1994-03-25', 'Jr');
2841 INSERT INTO actor.usr_address
2842 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2843 VALUES ('USA', 'f', '64735', '4372 Fact Junction', 'f',
2844 'MO', 'Clinton', '', 'Henry', CURRVAL('actor.usr_id_seq'));
2846 INSERT INTO actor.card (barcode, usr)
2847 VALUES ('99999332255', CURRVAL('actor.usr_id_seq'));
2849 UPDATE actor.usr SET
2850 card = CURRVAL('actor.card_id_seq'),
2851 billing_address = CURRVAL('actor.usr_address_id_seq'),
2852 credit_forward_balance = '0',
2853 mailing_address = CURRVAL('actor.usr_address_id_seq')
2854 WHERE id=CURRVAL('actor.usr_id_seq');
2856 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2857 VALUES (CURRVAL('actor.usr_id_seq'), 6);
2859 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2860 FROM actor.org_unit aou
2861 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
2863 INSERT INTO actor.usr
2864 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2865 VALUES (6, 3, 'krowland', 5, 'Rowland', 'kennethr1234',
2866 'Kenneth', 'Ernest', NOW() + '3 years'::INTERVAL, NULL, NULL);
2868 INSERT INTO actor.usr_address
2869 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2870 VALUES ('USA', 'f', '98131', '8373 Resonant Investment Mission', 'f',
2871 'WA', 'Seattle', '', 'King', CURRVAL('actor.usr_id_seq'));
2873 INSERT INTO actor.card (barcode, usr)
2874 VALUES ('99999354715', CURRVAL('actor.usr_id_seq'));
2876 UPDATE actor.usr SET
2877 card = CURRVAL('actor.card_id_seq'),
2878 billing_address = CURRVAL('actor.usr_address_id_seq'),
2879 credit_forward_balance = '0',
2880 mailing_address = CURRVAL('actor.usr_address_id_seq')
2881 WHERE id=CURRVAL('actor.usr_id_seq');
2883 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2884 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2886 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2887 FROM actor.org_unit aou
2888 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2890 INSERT INTO actor.usr
2891 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2892 VALUES (6, 1, 'thansen', 5, 'Hansen', 'terranceh1234',
2893 'Terrance', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
2895 INSERT INTO actor.usr_address
2896 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2897 VALUES ('USA', 't', '16550', '4446 Formidable Way Knolls', 't',
2898 'PA', 'Erie', '', 'Erie', CURRVAL('actor.usr_id_seq'));
2900 INSERT INTO actor.card (barcode, usr)
2901 VALUES ('99999363646', CURRVAL('actor.usr_id_seq'));
2903 UPDATE actor.usr SET
2904 card = CURRVAL('actor.card_id_seq'),
2905 billing_address = CURRVAL('actor.usr_address_id_seq'),
2906 credit_forward_balance = '0',
2907 mailing_address = CURRVAL('actor.usr_address_id_seq')
2908 WHERE id=CURRVAL('actor.usr_id_seq');
2910 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2911 VALUES (CURRVAL('actor.usr_id_seq'), 5);
2913 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2914 FROM actor.org_unit aou
2915 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
2917 INSERT INTO actor.usr
2918 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2919 VALUES (6, 3, 'breid', 4, 'Reid', 'barbarar1234',
2920 'Barbara', 'Amanda', NOW() + '3 years'::INTERVAL, NULL, NULL);
2922 INSERT INTO actor.usr_address
2923 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2924 VALUES ('USA', 'f', '04056', '3517 Hot School Brook', 'f',
2925 'ME', 'Newfield', '', 'York', CURRVAL('actor.usr_id_seq'));
2927 INSERT INTO actor.card (barcode, usr)
2928 VALUES ('99999365307', CURRVAL('actor.usr_id_seq'));
2930 UPDATE actor.usr SET
2931 card = CURRVAL('actor.card_id_seq'),
2932 billing_address = CURRVAL('actor.usr_address_id_seq'),
2933 credit_forward_balance = '0',
2934 mailing_address = CURRVAL('actor.usr_address_id_seq')
2935 WHERE id=CURRVAL('actor.usr_id_seq');
2937 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2938 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2940 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2941 FROM actor.org_unit aou
2942 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2944 INSERT INTO actor.usr
2945 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2946 VALUES (6, 1, 'mroberts', 4, 'Roberts', 'michaelr1234',
2947 'Michael', 'Stephen', NOW() + '3 years'::INTERVAL, NULL, NULL);
2949 INSERT INTO actor.usr_address
2950 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2951 VALUES ('USA', 't', '63541', '4668 Start Inlet', 'f',
2952 'MO', 'Glenwood', '', 'Schuyler', CURRVAL('actor.usr_id_seq'));
2954 INSERT INTO actor.card (barcode, usr)
2955 VALUES ('99999332788', CURRVAL('actor.usr_id_seq'));
2957 UPDATE actor.usr SET
2958 card = CURRVAL('actor.card_id_seq'),
2959 billing_address = CURRVAL('actor.usr_address_id_seq'),
2960 credit_forward_balance = '0',
2961 mailing_address = CURRVAL('actor.usr_address_id_seq')
2962 WHERE id=CURRVAL('actor.usr_id_seq');
2964 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2965 VALUES (CURRVAL('actor.usr_id_seq'), 4);
2967 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2968 FROM actor.org_unit aou
2969 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
2971 INSERT INTO actor.usr
2972 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2973 VALUES (5, 3, 'rkaufman', 9, 'Kaufman', 'rachelk1234',
2974 'Rachel', 'Vickie', NOW() + '3 years'::INTERVAL, NULL, NULL);
2976 INSERT INTO actor.usr_address
2977 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2978 VALUES ('USA', 't', '68659', '7270 Development Row', 'f',
2979 'NE', 'Rogers', '', '', CURRVAL('actor.usr_id_seq'));
2981 INSERT INTO actor.card (barcode, usr)
2982 VALUES ('99999340790', CURRVAL('actor.usr_id_seq'));
2984 UPDATE actor.usr SET
2985 card = CURRVAL('actor.card_id_seq'),
2986 billing_address = CURRVAL('actor.usr_address_id_seq'),
2987 credit_forward_balance = '0',
2988 mailing_address = CURRVAL('actor.usr_address_id_seq')
2989 WHERE id=CURRVAL('actor.usr_id_seq');
2991 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
2992 VALUES (CURRVAL('actor.usr_id_seq'), 9);
2994 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
2995 FROM actor.org_unit aou
2996 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
2998 INSERT INTO actor.usr
2999 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3000 VALUES (5, 3, 'csims', 9, 'Sims', 'christophers1234',
3001 'Christopher', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL);
3003 INSERT INTO actor.usr_address
3004 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3005 VALUES ('USA', 't', '89013', '5637 Plastic Mill', 't',
3006 'NV', 'Goldfield', '', 'Esmeralda', CURRVAL('actor.usr_id_seq'));
3008 INSERT INTO actor.card (barcode, usr)
3009 VALUES ('99999386091', CURRVAL('actor.usr_id_seq'));
3011 UPDATE actor.usr SET
3012 card = CURRVAL('actor.card_id_seq'),
3013 billing_address = CURRVAL('actor.usr_address_id_seq'),
3014 credit_forward_balance = '0',
3015 mailing_address = CURRVAL('actor.usr_address_id_seq')
3016 WHERE id=CURRVAL('actor.usr_id_seq');
3018 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3019 VALUES (CURRVAL('actor.usr_id_seq'), 9);
3021 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3022 FROM actor.org_unit aou
3023 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3025 INSERT INTO actor.usr
3026 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3027 VALUES (5, 1, 'srobinson', 8, 'Robinson', 'sarahr1234',
3028 'Sarah', '', NOW() + '3 years'::INTERVAL, '1996-01-28', 'II');
3030 INSERT INTO actor.usr_address
3031 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3032 VALUES ('USA', 'f', '65897', '8092 Pure Name Bridge', 'f',
3033 'MO', 'Springfield', '', 'Greene', CURRVAL('actor.usr_id_seq'));
3035 INSERT INTO actor.card (barcode, usr)
3036 VALUES ('99999340199', CURRVAL('actor.usr_id_seq'));
3038 UPDATE actor.usr SET
3039 card = CURRVAL('actor.card_id_seq'),
3040 billing_address = CURRVAL('actor.usr_address_id_seq'),
3041 credit_forward_balance = '0',
3042 mailing_address = CURRVAL('actor.usr_address_id_seq')
3043 WHERE id=CURRVAL('actor.usr_id_seq');
3045 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3046 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3048 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3049 FROM actor.org_unit aou
3050 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3052 INSERT INTO actor.usr
3053 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3054 VALUES (5, 3, 'jpayton', 8, 'Payton', 'johnnyp1234',
3055 'Johnny', 'Vincent', NOW() + '3 years'::INTERVAL, NULL, NULL);
3057 INSERT INTO actor.usr_address
3058 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3059 VALUES ('USA', 't', '85738', '8772 Forthcoming Hope Fort', 'f',
3060 'AZ', 'Catalina', '', '', CURRVAL('actor.usr_id_seq'));
3062 INSERT INTO actor.card (barcode, usr)
3063 VALUES ('99999387186', CURRVAL('actor.usr_id_seq'));
3065 UPDATE actor.usr SET
3066 card = CURRVAL('actor.card_id_seq'),
3067 billing_address = CURRVAL('actor.usr_address_id_seq'),
3068 credit_forward_balance = '0',
3069 mailing_address = CURRVAL('actor.usr_address_id_seq')
3070 WHERE id=CURRVAL('actor.usr_id_seq');
3072 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3073 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3075 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3076 FROM actor.org_unit aou
3077 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3079 INSERT INTO actor.usr
3080 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3081 VALUES (5, 3, 'djamison', 7, 'Jamison', 'davidj1234',
3082 'David', 'Eric', NOW() + '3 years'::INTERVAL, NULL, NULL);
3084 INSERT INTO actor.usr_address
3085 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3086 VALUES ('USA', 'f', '59604', '9218 Moral Worker Summit', 'f',
3087 'MT', 'Helena', '', '', CURRVAL('actor.usr_id_seq'));
3089 INSERT INTO actor.card (barcode, usr)
3090 VALUES ('99999340530', CURRVAL('actor.usr_id_seq'));
3092 UPDATE actor.usr SET
3093 card = CURRVAL('actor.card_id_seq'),
3094 billing_address = CURRVAL('actor.usr_address_id_seq'),
3095 credit_forward_balance = '0',
3096 mailing_address = CURRVAL('actor.usr_address_id_seq')
3097 WHERE id=CURRVAL('actor.usr_id_seq');
3099 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3100 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3102 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3103 FROM actor.org_unit aou
3104 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3106 INSERT INTO actor.usr
3107 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3108 VALUES (5, 3, 'jford', 7, 'Ford', 'jamief1234',
3109 'Jamie', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
3111 INSERT INTO actor.usr_address
3112 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3113 VALUES ('USA', 'f', '41746', '8268 Hill Valleys', 't',
3114 'KY', 'Happy', '', 'Perry', CURRVAL('actor.usr_id_seq'));
3116 INSERT INTO actor.card (barcode, usr)
3117 VALUES ('99999384455', CURRVAL('actor.usr_id_seq'));
3119 UPDATE actor.usr SET
3120 card = CURRVAL('actor.card_id_seq'),
3121 billing_address = CURRVAL('actor.usr_address_id_seq'),
3122 credit_forward_balance = '0',
3123 mailing_address = CURRVAL('actor.usr_address_id_seq')
3124 WHERE id=CURRVAL('actor.usr_id_seq');
3126 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3127 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3129 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3130 FROM actor.org_unit aou
3131 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3133 INSERT INTO actor.usr
3134 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3135 VALUES (5, 1, 'gwatson', 6, 'Watson', 'geraldw1234',
3136 'Gerald', 'Larry', NOW() + '3 years'::INTERVAL, NULL, NULL);
3138 INSERT INTO actor.usr_address
3139 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3140 VALUES ('USA', 'f', '85063', '881 Scary Holiday Radial', 'f',
3141 'AZ', 'Phoenix', '', 'Maricopa', CURRVAL('actor.usr_id_seq'));
3143 INSERT INTO actor.card (barcode, usr)
3144 VALUES ('99999385100', CURRVAL('actor.usr_id_seq'));
3146 UPDATE actor.usr SET
3147 card = CURRVAL('actor.card_id_seq'),
3148 billing_address = CURRVAL('actor.usr_address_id_seq'),
3149 credit_forward_balance = '0',
3150 mailing_address = CURRVAL('actor.usr_address_id_seq')
3151 WHERE id=CURRVAL('actor.usr_id_seq');
3153 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3154 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3156 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3157 FROM actor.org_unit aou
3158 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3160 INSERT INTO actor.usr
3161 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3162 VALUES (5, 1, 'clambert', 6, 'Lambert', 'charlesl1234',
3163 'Charles', 'William', NOW() + '3 years'::INTERVAL, '1995-09-22', 'Jr');
3165 INSERT INTO actor.usr_address
3166 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3167 VALUES ('USA', 't', '40291', '6026 Wide Development Port', 'f',
3168 'KY', 'Louisville', '', 'Jefferson', CURRVAL('actor.usr_id_seq'));
3170 INSERT INTO actor.card (barcode, usr)
3171 VALUES ('99999335749', CURRVAL('actor.usr_id_seq'));
3173 UPDATE actor.usr SET
3174 card = CURRVAL('actor.card_id_seq'),
3175 billing_address = CURRVAL('actor.usr_address_id_seq'),
3176 credit_forward_balance = '0',
3177 mailing_address = CURRVAL('actor.usr_address_id_seq')
3178 WHERE id=CURRVAL('actor.usr_id_seq');
3180 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3181 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3183 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3184 FROM actor.org_unit aou
3185 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3187 INSERT INTO actor.usr
3188 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3189 VALUES (5, 1, 'mbarber', 5, 'Barber', 'michealb1234',
3190 'Micheal', 'Ramon', NOW() + '3 years'::INTERVAL, NULL, NULL);
3192 INSERT INTO actor.usr_address
3193 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3194 VALUES ('USA', 'f', '91357', '9727 Proposed Executive Plaza', 't',
3195 'CA', 'Tarzana', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
3197 INSERT INTO actor.card (barcode, usr)
3198 VALUES ('99999361522', CURRVAL('actor.usr_id_seq'));
3200 UPDATE actor.usr SET
3201 card = CURRVAL('actor.card_id_seq'),
3202 billing_address = CURRVAL('actor.usr_address_id_seq'),
3203 credit_forward_balance = '0',
3204 mailing_address = CURRVAL('actor.usr_address_id_seq')
3205 WHERE id=CURRVAL('actor.usr_id_seq');
3207 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3208 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3210 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3211 FROM actor.org_unit aou
3212 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3214 INSERT INTO actor.usr
3215 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3216 VALUES (5, 3, 'tcruz', 5, 'Cruz', 'tomc1234',
3217 'Tom', 'Eugene', NOW() + '3 years'::INTERVAL, NULL, NULL);
3219 INSERT INTO actor.usr_address
3220 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3221 VALUES ('USA', 'f', '40546', '7481 Reform Road', 't',
3222 'KY', 'Lexington', '', 'Fayette', CURRVAL('actor.usr_id_seq'));
3224 INSERT INTO actor.card (barcode, usr)
3225 VALUES ('99999394278', CURRVAL('actor.usr_id_seq'));
3227 UPDATE actor.usr SET
3228 card = CURRVAL('actor.card_id_seq'),
3229 billing_address = CURRVAL('actor.usr_address_id_seq'),
3230 credit_forward_balance = '0',
3231 mailing_address = CURRVAL('actor.usr_address_id_seq')
3232 WHERE id=CURRVAL('actor.usr_id_seq');
3234 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3235 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3237 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3238 FROM actor.org_unit aou
3239 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3241 INSERT INTO actor.usr
3242 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3243 VALUES (5, 1, 'iwalton', 4, 'Walton', 'inezw1234',
3244 'Inez', 'Amanda', NOW() + '3 years'::INTERVAL, NULL, NULL);
3246 INSERT INTO actor.usr_address
3247 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3248 VALUES ('USA', 'f', '29053', '8589 Official Valleys', 'f',
3249 'SC', 'Gaston', '', '', CURRVAL('actor.usr_id_seq'));
3251 INSERT INTO actor.card (barcode, usr)
3252 VALUES ('99999356283', CURRVAL('actor.usr_id_seq'));
3254 UPDATE actor.usr SET
3255 card = CURRVAL('actor.card_id_seq'),
3256 billing_address = CURRVAL('actor.usr_address_id_seq'),
3257 credit_forward_balance = '0',
3258 mailing_address = CURRVAL('actor.usr_address_id_seq')
3259 WHERE id=CURRVAL('actor.usr_id_seq');
3261 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3262 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3264 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3265 FROM actor.org_unit aou
3266 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
3268 INSERT INTO actor.usr
3269 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3270 VALUES (5, 3, 'mtownsend', 4, 'Townsend', 'maryt1234',
3271 'Mary', '', NOW() + '3 years'::INTERVAL, '1995-03-03', 'Jr');
3273 INSERT INTO actor.usr_address
3274 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3275 VALUES ('USA', 't', '72464', '3321 Answer Stravenue', 't',
3276 'AR', 'Saint francis', '', '', CURRVAL('actor.usr_id_seq'));
3278 INSERT INTO actor.card (barcode, usr)
3279 VALUES ('99999336350', CURRVAL('actor.usr_id_seq'));
3281 UPDATE actor.usr SET
3282 card = CURRVAL('actor.card_id_seq'),
3283 billing_address = CURRVAL('actor.usr_address_id_seq'),
3284 credit_forward_balance = '0',
3285 mailing_address = CURRVAL('actor.usr_address_id_seq')
3286 WHERE id=CURRVAL('actor.usr_id_seq');
3288 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3289 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3291 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3292 FROM actor.org_unit aou
3293 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
3295 INSERT INTO actor.usr
3296 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3297 VALUES (4, 3, 'cmartinez', 9, 'Martinez', 'carolynm1234',
3298 'Carolyn', 'Sandra', NOW() + '3 years'::INTERVAL, NULL, NULL);
3300 INSERT INTO actor.usr_address
3301 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3302 VALUES ('USA', 't', '49654', '7081 Appalling Plant Causeway', 't',
3303 'MI', 'Leland', '', '', CURRVAL('actor.usr_id_seq'));
3305 INSERT INTO actor.card (barcode, usr)
3306 VALUES ('99999397121', CURRVAL('actor.usr_id_seq'));
3308 UPDATE actor.usr SET
3309 card = CURRVAL('actor.card_id_seq'),
3310 billing_address = CURRVAL('actor.usr_address_id_seq'),
3311 credit_forward_balance = '0',
3312 mailing_address = CURRVAL('actor.usr_address_id_seq')
3313 WHERE id=CURRVAL('actor.usr_id_seq');
3315 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3316 VALUES (CURRVAL('actor.usr_id_seq'), 9);
3318 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3319 FROM actor.org_unit aou
3320 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3322 INSERT INTO actor.usr
3323 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3324 VALUES (4, 1, 'jjohnson', 9, 'Johnson', 'jeremyj1234',
3325 'Jeremy', 'Mark', NOW() + '3 years'::INTERVAL, '1970-03-14', 'II');
3327 INSERT INTO actor.usr_address
3328 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3329 VALUES ('USA', 'f', '70358', '4786 Prior Politics Mission', 'f',
3330 'LA', 'Grand isle', '', '', CURRVAL('actor.usr_id_seq'));
3332 INSERT INTO actor.card (barcode, usr)
3333 VALUES ('99999397850', CURRVAL('actor.usr_id_seq'));
3335 UPDATE actor.usr SET
3336 card = CURRVAL('actor.card_id_seq'),
3337 billing_address = CURRVAL('actor.usr_address_id_seq'),
3338 credit_forward_balance = '0',
3339 mailing_address = CURRVAL('actor.usr_address_id_seq')
3340 WHERE id=CURRVAL('actor.usr_id_seq');
3342 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3343 VALUES (CURRVAL('actor.usr_id_seq'), 9);
3345 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3346 FROM actor.org_unit aou
3347 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 9;
3349 INSERT INTO actor.usr
3350 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3351 VALUES (4, 1, 'mscott', 8, 'Scott', 'maes1234',
3352 'Mae', 'Sue', NOW() + '3 years'::INTERVAL, NULL, NULL);
3354 INSERT INTO actor.usr_address
3355 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3356 VALUES ('USA', 'f', '14723', '1060 Letter Stravenue', 'f',
3357 'NY', 'Cherry creek', '', '', CURRVAL('actor.usr_id_seq'));
3359 INSERT INTO actor.card (barcode, usr)
3360 VALUES ('99999395984', CURRVAL('actor.usr_id_seq'));
3362 UPDATE actor.usr SET
3363 card = CURRVAL('actor.card_id_seq'),
3364 billing_address = CURRVAL('actor.usr_address_id_seq'),
3365 credit_forward_balance = '0',
3366 mailing_address = CURRVAL('actor.usr_address_id_seq')
3367 WHERE id=CURRVAL('actor.usr_id_seq');
3369 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3370 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3372 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3373 FROM actor.org_unit aou
3374 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3376 INSERT INTO actor.usr
3377 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3378 VALUES (4, 3, 'rstevens', 8, 'Stevens', 'russells1234',
3379 'Russell', 'Daniel', NOW() + '3 years'::INTERVAL, '1973-08-15', 'Jr');
3381 INSERT INTO actor.usr_address
3382 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3383 VALUES ('USA', 't', '29582', '7735 Street Creek', 'f',
3384 'SC', 'North myrtle beach', '', 'Horry', CURRVAL('actor.usr_id_seq'));
3386 INSERT INTO actor.card (barcode, usr)
3387 VALUES ('99999340524', CURRVAL('actor.usr_id_seq'));
3389 UPDATE actor.usr SET
3390 card = CURRVAL('actor.card_id_seq'),
3391 billing_address = CURRVAL('actor.usr_address_id_seq'),
3392 credit_forward_balance = '0',
3393 mailing_address = CURRVAL('actor.usr_address_id_seq')
3394 WHERE id=CURRVAL('actor.usr_id_seq');
3396 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3397 VALUES (CURRVAL('actor.usr_id_seq'), 8);
3399 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3400 FROM actor.org_unit aou
3401 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 8;
3403 INSERT INTO actor.usr
3404 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3405 VALUES (4, 3, 'therrera', 7, 'Herrera', 'tracih1234',
3406 'Traci', 'Edith', NOW() + '3 years'::INTERVAL, '1994-07-07', 'Jr');
3408 INSERT INTO actor.usr_address
3409 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3410 VALUES ('USA', 'f', '84133', '7301 Watery Arrangement Radial', 'f',
3411 'UT', 'Salt lake city', '', '', CURRVAL('actor.usr_id_seq'));
3413 INSERT INTO actor.card (barcode, usr)
3414 VALUES ('99999386259', CURRVAL('actor.usr_id_seq'));
3416 UPDATE actor.usr SET
3417 card = CURRVAL('actor.card_id_seq'),
3418 billing_address = CURRVAL('actor.usr_address_id_seq'),
3419 credit_forward_balance = '0',
3420 mailing_address = CURRVAL('actor.usr_address_id_seq')
3421 WHERE id=CURRVAL('actor.usr_id_seq');
3423 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3424 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3426 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3427 FROM actor.org_unit aou
3428 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3430 INSERT INTO actor.usr
3431 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3432 VALUES (4, 3, 'vgrimes', 7, 'Grimes', 'virginiag1234',
3433 'Virginia', 'Jennifer', NOW() + '3 years'::INTERVAL, NULL, NULL);
3435 INSERT INTO actor.usr_address
3436 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3437 VALUES ('USA', 'f', '87027', '8666 Fluttering Situation Heights', 'f',
3438 'NM', 'La jara', '', 'Sandoval', CURRVAL('actor.usr_id_seq'));
3440 INSERT INTO actor.card (barcode, usr)
3441 VALUES ('99999318163', CURRVAL('actor.usr_id_seq'));
3443 UPDATE actor.usr SET
3444 card = CURRVAL('actor.card_id_seq'),
3445 billing_address = CURRVAL('actor.usr_address_id_seq'),
3446 credit_forward_balance = '0',
3447 mailing_address = CURRVAL('actor.usr_address_id_seq')
3448 WHERE id=CURRVAL('actor.usr_id_seq');
3450 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3451 VALUES (CURRVAL('actor.usr_id_seq'), 7);
3453 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3454 FROM actor.org_unit aou
3455 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 7;
3457 INSERT INTO actor.usr
3458 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3459 VALUES (4, 1, 'pward', 6, 'Ward', 'paulw1234',
3460 'Paul', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
3462 INSERT INTO actor.usr_address
3463 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3464 VALUES ('USA', 'f', '38233', '8859 Roasted Energy Falls', 'f',
3465 'TN', 'Kenton', '', '', CURRVAL('actor.usr_id_seq'));
3467 INSERT INTO actor.card (barcode, usr)
3468 VALUES ('99999346968', CURRVAL('actor.usr_id_seq'));
3470 UPDATE actor.usr SET
3471 card = CURRVAL('actor.card_id_seq'),
3472 billing_address = CURRVAL('actor.usr_address_id_seq'),
3473 credit_forward_balance = '0',
3474 mailing_address = CURRVAL('actor.usr_address_id_seq')
3475 WHERE id=CURRVAL('actor.usr_id_seq');
3477 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3478 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3480 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3481 FROM actor.org_unit aou
3482 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3484 INSERT INTO actor.usr
3485 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3486 VALUES (4, 3, 'bgreen', 6, 'Green', 'beatriceg1234',
3487 'Beatrice', 'Janette', NOW() + '3 years'::INTERVAL, NULL, NULL);
3489 INSERT INTO actor.usr_address
3490 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3491 VALUES ('USA', 't', '65438', '9082 Plain Bed Avenue', 'f',
3492 'MO', 'Birch tree', '', 'Shannon', CURRVAL('actor.usr_id_seq'));
3494 INSERT INTO actor.card (barcode, usr)
3495 VALUES ('99999345139', CURRVAL('actor.usr_id_seq'));
3497 UPDATE actor.usr SET
3498 card = CURRVAL('actor.card_id_seq'),
3499 billing_address = CURRVAL('actor.usr_address_id_seq'),
3500 credit_forward_balance = '0',
3501 mailing_address = CURRVAL('actor.usr_address_id_seq')
3502 WHERE id=CURRVAL('actor.usr_id_seq');
3504 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3505 VALUES (CURRVAL('actor.usr_id_seq'), 6);
3507 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3508 FROM actor.org_unit aou
3509 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 6;
3511 INSERT INTO actor.usr
3512 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3513 VALUES (4, 1, 'sschmidt', 5, 'Schmidt', 'scotts1234',
3514 'Scott', 'Kyle', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
3516 INSERT INTO actor.usr_address
3517 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3518 VALUES ('USA', 'f', '99670', '2204 Status Avenue', 'f',
3519 'AK', 'South naknek', '', '', CURRVAL('actor.usr_id_seq'));
3521 INSERT INTO actor.card (barcode, usr)
3522 VALUES ('99999393981', CURRVAL('actor.usr_id_seq'));
3524 UPDATE actor.usr SET
3525 card = CURRVAL('actor.card_id_seq'),
3526 billing_address = CURRVAL('actor.usr_address_id_seq'),
3527 credit_forward_balance = '0',
3528 mailing_address = CURRVAL('actor.usr_address_id_seq')
3529 WHERE id=CURRVAL('actor.usr_id_seq');
3531 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3532 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3534 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3535 FROM actor.org_unit aou
3536 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3538 INSERT INTO actor.usr
3539 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3540 VALUES (4, 3, 'jclark', 5, 'Clark', 'joannec1234',
3541 'Joanne', 'Andrea', NOW() + '3 years'::INTERVAL, NULL, NULL);
3543 INSERT INTO actor.usr_address
3544 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3545 VALUES ('USA', 'f', '35175', '7622 Thoughtless Science Pines', 'f',
3546 'AL', 'Union grove', '', 'Marshall', CURRVAL('actor.usr_id_seq'));
3548 INSERT INTO actor.card (barcode, usr)
3549 VALUES ('99999366354', CURRVAL('actor.usr_id_seq'));
3551 UPDATE actor.usr SET
3552 card = CURRVAL('actor.card_id_seq'),
3553 billing_address = CURRVAL('actor.usr_address_id_seq'),
3554 credit_forward_balance = '0',
3555 mailing_address = CURRVAL('actor.usr_address_id_seq')
3556 WHERE id=CURRVAL('actor.usr_id_seq');
3558 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3559 VALUES (CURRVAL('actor.usr_id_seq'), 5);
3561 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3562 FROM actor.org_unit aou
3563 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 5;
3565 INSERT INTO actor.usr
3566 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3567 VALUES (4, 1, 'bbrown', 4, 'Brown', 'beverlyb1234',
3568 'Beverly', 'Florence', NOW() + '3 years'::INTERVAL, NULL, NULL);
3570 INSERT INTO actor.usr_address
3571 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3572 VALUES ('USA', 't', '29058', '2991 Trip Crescent', 't',
3573 'SC', 'Heath springs', '', 'Lancaster', CURRVAL('actor.usr_id_seq'));
3575 INSERT INTO actor.card (barcode, usr)
3576 VALUES ('99999338317', CURRVAL('actor.usr_id_seq'));
3578 UPDATE actor.usr SET
3579 card = CURRVAL('actor.card_id_seq'),
3580 billing_address = CURRVAL('actor.usr_address_id_seq'),
3581 credit_forward_balance = '0',
3582 mailing_address = CURRVAL('actor.usr_address_id_seq')
3583 WHERE id=CURRVAL('actor.usr_id_seq');
3585 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3586 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3588 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3589 FROM actor.org_unit aou
3590 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;
3592 INSERT INTO actor.usr
3593 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
3594 VALUES (4, 3, 'jmcginnis', 4, 'Mcginnis', 'josem1234',
3595 'Jose', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL);
3597 INSERT INTO actor.usr_address
3598 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
3599 VALUES ('USA', 't', '65055', '8231 Relieved Debt Cape', 'f',
3600 'MO', 'Mc girk', '', 'Moniteau', CURRVAL('actor.usr_id_seq'));
3602 INSERT INTO actor.card (barcode, usr)
3603 VALUES ('99999316430', CURRVAL('actor.usr_id_seq'));
3605 UPDATE actor.usr SET
3606 card = CURRVAL('actor.card_id_seq'),
3607 billing_address = CURRVAL('actor.usr_address_id_seq'),
3608 credit_forward_balance = '0',
3609 mailing_address = CURRVAL('actor.usr_address_id_seq')
3610 WHERE id=CURRVAL('actor.usr_id_seq');
3612 INSERT INTO permission.usr_work_ou_map (usr, work_ou)
3613 VALUES (CURRVAL('actor.usr_id_seq'), 4);
3615 UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname
3616 FROM actor.org_unit aou
3617 WHERE usr.id = CURRVAL('actor.usr_id_seq') AND aou.id = 4;