4 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
5 VALUES (2, 3, '99999395390', 9, 'Brooks', 'terrib1234',
6 'Terri', 'Maria', '2008-01-01', NULL, NULL);
8 INSERT INTO actor.usr_address
9 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
10 VALUES ('USA', 'f', '32961', '1809 Target Way', 't',
11 'FL', 'Vero beach', '', 'Indian river', CURRVAL('actor.usr_id_seq'));
13 INSERT INTO actor.card (barcode, usr)
14 VALUES ('99999395390', CURRVAL('actor.usr_id_seq'));
17 card = CURRVAL('actor.card_id_seq'),
18 billing_address = CURRVAL('actor.usr_address_id_seq'),
19 credit_forward_balance = '0',
20 mailing_address = CURRVAL('actor.usr_address_id_seq')
21 WHERE id=CURRVAL('actor.usr_id_seq');
26 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
27 VALUES (2, 1, '99999320945', 5, 'Jackson', 'shannonj1234',
28 'Shannon', 'Thomas', '1999-01-01', NULL, NULL);
30 INSERT INTO actor.usr_address
31 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
32 VALUES ('USA', 't', '41301', '3481 Facility Island', 'f',
33 'KY', 'Campton', '', 'Wolfe', CURRVAL('actor.usr_id_seq'));
35 INSERT INTO actor.card (barcode, usr)
36 VALUES ('99999320945', CURRVAL('actor.usr_id_seq'));
39 card = CURRVAL('actor.card_id_seq'),
40 billing_address = CURRVAL('actor.usr_address_id_seq'),
41 credit_forward_balance = '0',
42 mailing_address = CURRVAL('actor.usr_address_id_seq')
43 WHERE id=CURRVAL('actor.usr_id_seq');
46 -- Soon to expire patron
48 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
49 VALUES (2, 3, '99999355250', 5, 'Jones', 'gregoryj1234',
50 'Gregory', '', NOW() + '1 day'::INTERVAL, NULL, NULL);
52 INSERT INTO actor.usr_address
53 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
54 VALUES ('USA', 'f', '55927', '5150 Dinner Expressway', 'f',
55 'MN', 'Dodge center', '', 'Dodge', CURRVAL('actor.usr_id_seq'));
57 INSERT INTO actor.card (barcode, usr)
58 VALUES ('99999355250', CURRVAL('actor.usr_id_seq'));
61 card = CURRVAL('actor.card_id_seq'),
62 billing_address = CURRVAL('actor.usr_address_id_seq'),
63 credit_forward_balance = '0',
64 mailing_address = CURRVAL('actor.usr_address_id_seq')
65 WHERE id=CURRVAL('actor.usr_id_seq');
68 -- Soon to expire patron
70 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
71 VALUES (2, 1, '99999387993', 9, 'Moran', 'vincentm1234',
72 'Vincent', 'Kenneth', NOW() + '1 week'::INTERVAL, NULL, NULL);
74 INSERT INTO actor.usr_address
75 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
76 VALUES ('USA', 't', '22611', '8496 Random Trust Points', 'f',
77 'VA', 'Berryville', '', '', CURRVAL('actor.usr_id_seq'));
79 INSERT INTO actor.card (barcode, usr)
80 VALUES ('99999387993', CURRVAL('actor.usr_id_seq'));
83 card = CURRVAL('actor.card_id_seq'),
84 billing_address = CURRVAL('actor.usr_address_id_seq'),
85 credit_forward_balance = '0',
86 mailing_address = CURRVAL('actor.usr_address_id_seq')
87 WHERE id=CURRVAL('actor.usr_id_seq');
90 -- Soon to expire patron
92 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
93 VALUES (2, 1, '99999335859', 8, 'Jones', 'gregoryj1234',
94 'Gregory', 'Adam', NOW() + '3 weeks'::INTERVAL, NULL, NULL);
96 INSERT INTO actor.usr_address
97 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
98 VALUES ('USA', 'f', '99502', '7626 Secret Institute Courts', 'f',
99 'AK', 'Anchorage', '', '', CURRVAL('actor.usr_id_seq'));
101 INSERT INTO actor.card (barcode, usr)
102 VALUES ('99999335859', CURRVAL('actor.usr_id_seq'));
105 card = CURRVAL('actor.card_id_seq'),
106 billing_address = CURRVAL('actor.usr_address_id_seq'),
107 credit_forward_balance = '0',
108 mailing_address = CURRVAL('actor.usr_address_id_seq')
109 WHERE id=CURRVAL('actor.usr_id_seq');
112 -- Recently expired patron
113 INSERT INTO actor.usr
114 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
115 VALUES (2, 1, '99999373186', 7, 'Walker', 'brittanyw1234',
116 'Brittany', 'Geraldine', NOW() - '1 week'::INTERVAL, NULL, NULL);
118 INSERT INTO actor.usr_address
119 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
120 VALUES ('USA', 'f', '40445', '7044 Regular Index Path', 'f',
121 'KY', 'Livingston', '', 'Rockcastle', CURRVAL('actor.usr_id_seq'));
123 INSERT INTO actor.card (barcode, usr)
124 VALUES ('99999373186', CURRVAL('actor.usr_id_seq'));
127 card = CURRVAL('actor.card_id_seq'),
128 billing_address = CURRVAL('actor.usr_address_id_seq'),
129 credit_forward_balance = '0',
130 mailing_address = CURRVAL('actor.usr_address_id_seq')
131 WHERE id=CURRVAL('actor.usr_id_seq');
134 -- Recently expired patron
135 INSERT INTO actor.usr
136 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
137 VALUES (2, 1, '99999384262', 9, 'Miller', 'ernestom1234',
138 'Ernesto', 'Robert', NOW() - '3 weeks'::INTERVAL, '1997-02-02', 'II');
140 INSERT INTO actor.usr_address
141 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
142 VALUES ('USA', 't', '33157', '3403 Thundering Heat Meadows', 'f',
143 'FL', 'Miami', '', '', CURRVAL('actor.usr_id_seq'));
145 INSERT INTO actor.card (barcode, usr)
146 VALUES ('99999384262', CURRVAL('actor.usr_id_seq'));
149 card = CURRVAL('actor.card_id_seq'),
150 billing_address = CURRVAL('actor.usr_address_id_seq'),
151 credit_forward_balance = '0',
152 mailing_address = CURRVAL('actor.usr_address_id_seq')
153 WHERE id=CURRVAL('actor.usr_id_seq');
156 INSERT INTO actor.usr
157 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
158 VALUES (2, 1, '99999373998', 9, 'Hill', 'roberth1234',
159 'Robert', 'Louis', NOW() + '3 years'::INTERVAL, NULL, 'III');
161 INSERT INTO actor.usr_address
162 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
163 VALUES ('USA', 't', '18960', '759 Doubtful Government Extension', 't',
164 'PA', 'Sellersville', '', '', CURRVAL('actor.usr_id_seq'));
166 INSERT INTO actor.card (barcode, usr)
167 VALUES ('99999373998', CURRVAL('actor.usr_id_seq'));
170 card = CURRVAL('actor.card_id_seq'),
171 billing_address = CURRVAL('actor.usr_address_id_seq'),
172 credit_forward_balance = '0',
173 mailing_address = CURRVAL('actor.usr_address_id_seq')
174 WHERE id=CURRVAL('actor.usr_id_seq');
177 INSERT INTO actor.usr
178 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
179 VALUES (2, 3, '99999376669', 7, 'Lopez', 'edwardl1234',
180 'Edward', 'Robert', NOW() + '3 years'::INTERVAL, NULL, 'II');
182 INSERT INTO actor.usr_address
183 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
184 VALUES ('USA', 't', '29593', '5431 Japanese Work Rapid', 'f',
185 'SC', 'Society hill', '', 'Darlington', CURRVAL('actor.usr_id_seq'));
187 INSERT INTO actor.card (barcode, usr)
188 VALUES ('99999376669', CURRVAL('actor.usr_id_seq'));
191 card = CURRVAL('actor.card_id_seq'),
192 billing_address = CURRVAL('actor.usr_address_id_seq'),
193 credit_forward_balance = '0',
194 mailing_address = CURRVAL('actor.usr_address_id_seq')
195 WHERE id=CURRVAL('actor.usr_id_seq');
198 INSERT INTO actor.usr
199 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
200 VALUES (2, 3, '99999361076', 8, 'Bell', 'andrewb1234',
201 'Andrew', 'Alberto', NOW() + '3 years'::INTERVAL, NULL, 'II');
203 INSERT INTO actor.usr_address
204 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
205 VALUES ('USA', 't', '61936', '5253 Agricultural Exhibition Stravenue', 'f',
206 'IL', 'La place', '', 'Piatt', CURRVAL('actor.usr_id_seq'));
208 INSERT INTO actor.card (barcode, usr)
209 VALUES ('99999361076', CURRVAL('actor.usr_id_seq'));
212 card = CURRVAL('actor.card_id_seq'),
213 billing_address = CURRVAL('actor.usr_address_id_seq'),
214 credit_forward_balance = '0',
215 mailing_address = CURRVAL('actor.usr_address_id_seq')
216 WHERE id=CURRVAL('actor.usr_id_seq');
219 INSERT INTO actor.usr
220 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
221 VALUES (2, 1, '99999376988', 9, 'Mitchell', 'jenniferm1234',
222 'Jennifer', 'Dorothy', NOW() + '3 years'::INTERVAL, NULL, NULL);
224 INSERT INTO actor.usr_address
225 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
226 VALUES ('USA', 't', '61822', '8649 Raspy Goal Terrace', 't',
227 'IL', 'Champaign', '', 'Champaign', CURRVAL('actor.usr_id_seq'));
229 INSERT INTO actor.card (barcode, usr)
230 VALUES ('99999376988', CURRVAL('actor.usr_id_seq'));
233 card = CURRVAL('actor.card_id_seq'),
234 billing_address = CURRVAL('actor.usr_address_id_seq'),
235 credit_forward_balance = '0',
236 mailing_address = CURRVAL('actor.usr_address_id_seq')
237 WHERE id=CURRVAL('actor.usr_id_seq');
240 INSERT INTO actor.usr
241 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
242 VALUES (2, 3, '99999390791', 7, 'Ortiz', 'richardo1234',
243 'Richard', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
245 INSERT INTO actor.usr_address
246 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
247 VALUES ('USA', 'f', '23885', '2433 Uncomfortable Nature Greens', 'f',
248 'VA', 'Sutherland', '', 'Dinwiddie', CURRVAL('actor.usr_id_seq'));
250 INSERT INTO actor.card (barcode, usr)
251 VALUES ('99999390791', CURRVAL('actor.usr_id_seq'));
254 card = CURRVAL('actor.card_id_seq'),
255 billing_address = CURRVAL('actor.usr_address_id_seq'),
256 credit_forward_balance = '0',
257 mailing_address = CURRVAL('actor.usr_address_id_seq')
258 WHERE id=CURRVAL('actor.usr_id_seq');
261 INSERT INTO actor.usr
262 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
263 VALUES (2, 1, '99999378730', 6, 'Wade', 'robertw1234',
264 'Robert', 'Coy', NOW() + '3 years'::INTERVAL, NULL, NULL);
266 INSERT INTO actor.usr_address
267 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
268 VALUES ('USA', 't', '55796', '3241 Communist Boat Boulevard', 'f',
269 'MN', 'Winton', '', 'Saint louis', CURRVAL('actor.usr_id_seq'));
271 INSERT INTO actor.card (barcode, usr)
272 VALUES ('99999378730', CURRVAL('actor.usr_id_seq'));
275 card = CURRVAL('actor.card_id_seq'),
276 billing_address = CURRVAL('actor.usr_address_id_seq'),
277 credit_forward_balance = '0',
278 mailing_address = CURRVAL('actor.usr_address_id_seq')
279 WHERE id=CURRVAL('actor.usr_id_seq');
282 INSERT INTO actor.usr
283 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
284 VALUES (2, 3, '99999360638', 5, 'Wise', 'janetw1234',
285 'Janet', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
287 INSERT INTO actor.usr_address
288 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
289 VALUES ('USA', 'f', '64126', '6773 Government Hill', 'f',
290 'MO', 'Kansas city', '', '', CURRVAL('actor.usr_id_seq'));
292 INSERT INTO actor.card (barcode, usr)
293 VALUES ('99999360638', CURRVAL('actor.usr_id_seq'));
296 card = CURRVAL('actor.card_id_seq'),
297 billing_address = CURRVAL('actor.usr_address_id_seq'),
298 credit_forward_balance = '0',
299 mailing_address = CURRVAL('actor.usr_address_id_seq')
300 WHERE id=CURRVAL('actor.usr_id_seq');
303 INSERT INTO actor.usr
304 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
305 VALUES (2, 1, '99999350419', 4, 'Torres', 'donaldt1234',
306 'Donald', 'Arnold', NOW() + '3 years'::INTERVAL, '1974-06-26', 'II');
308 INSERT INTO actor.usr_address
309 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
310 VALUES ('USA', 't', '40847', '7194 Gorgeous Edge Dale', 'f',
311 'KY', 'Kenvir', '', 'Harlan', CURRVAL('actor.usr_id_seq'));
313 INSERT INTO actor.card (barcode, usr)
314 VALUES ('99999350419', CURRVAL('actor.usr_id_seq'));
317 card = CURRVAL('actor.card_id_seq'),
318 billing_address = CURRVAL('actor.usr_address_id_seq'),
319 credit_forward_balance = '0',
320 mailing_address = CURRVAL('actor.usr_address_id_seq')
321 WHERE id=CURRVAL('actor.usr_id_seq');
324 INSERT INTO actor.usr
325 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
326 VALUES (2, 1, '99999354736', 4, 'Miller', 'jeffm1234',
327 'Jeff', 'James', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
329 INSERT INTO actor.usr_address
330 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
331 VALUES ('USA', 't', '80920', '9674 Filthy Firm Meadows', 'f',
332 'CO', 'Colorado springs', '', '', CURRVAL('actor.usr_id_seq'));
334 INSERT INTO actor.card (barcode, usr)
335 VALUES ('99999354736', CURRVAL('actor.usr_id_seq'));
338 card = CURRVAL('actor.card_id_seq'),
339 billing_address = CURRVAL('actor.usr_address_id_seq'),
340 credit_forward_balance = '0',
341 mailing_address = CURRVAL('actor.usr_address_id_seq')
342 WHERE id=CURRVAL('actor.usr_id_seq');
345 INSERT INTO actor.usr
346 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
347 VALUES (2, 1, '99999329662', 9, 'Estes', 'leonarde1234',
348 'Leonard', '', NOW() + '3 years'::INTERVAL, '1994-05-07', 'III');
350 INSERT INTO actor.usr_address
351 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
352 VALUES ('USA', 'f', '20724', '6145 Superior Dress Prairie', 't',
353 'MD', 'Laurel', '', '', CURRVAL('actor.usr_id_seq'));
355 INSERT INTO actor.card (barcode, usr)
356 VALUES ('99999329662', CURRVAL('actor.usr_id_seq'));
359 card = CURRVAL('actor.card_id_seq'),
360 billing_address = CURRVAL('actor.usr_address_id_seq'),
361 credit_forward_balance = '0',
362 mailing_address = CURRVAL('actor.usr_address_id_seq')
363 WHERE id=CURRVAL('actor.usr_id_seq');
366 INSERT INTO actor.usr
367 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
368 VALUES (2, 1, '99999397601', 8, 'Dunn', 'brittneyd1234',
369 'Brittney', 'Pamela', NOW() + '3 years'::INTERVAL, NULL, NULL);
371 INSERT INTO actor.usr_address
372 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
373 VALUES ('USA', 't', '73838', '9753 Confident Limit Shoal', 'f',
374 'OK', 'Chester', '', '', CURRVAL('actor.usr_id_seq'));
376 INSERT INTO actor.card (barcode, usr)
377 VALUES ('99999397601', CURRVAL('actor.usr_id_seq'));
380 card = CURRVAL('actor.card_id_seq'),
381 billing_address = CURRVAL('actor.usr_address_id_seq'),
382 credit_forward_balance = '0',
383 mailing_address = CURRVAL('actor.usr_address_id_seq')
384 WHERE id=CURRVAL('actor.usr_id_seq');
387 INSERT INTO actor.usr
388 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
389 VALUES (2, 3, '99999377594', 4, 'Wiggins', 'jeanw1234',
390 'Jean', 'Verna', NOW() + '3 years'::INTERVAL, NULL, NULL);
392 INSERT INTO actor.usr_address
393 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
394 VALUES ('USA', 'f', '23018', '6115 Thoughtful Country Ridge', 'f',
395 'VA', 'Bena', '', '', CURRVAL('actor.usr_id_seq'));
397 INSERT INTO actor.card (barcode, usr)
398 VALUES ('99999377594', CURRVAL('actor.usr_id_seq'));
401 card = CURRVAL('actor.card_id_seq'),
402 billing_address = CURRVAL('actor.usr_address_id_seq'),
403 credit_forward_balance = '0',
404 mailing_address = CURRVAL('actor.usr_address_id_seq')
405 WHERE id=CURRVAL('actor.usr_id_seq');
408 INSERT INTO actor.usr
409 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
410 VALUES (2, 1, '99999371252', 9, 'Thomas', 'lelat1234',
411 'Lela', 'Sarah', NOW() + '3 years'::INTERVAL, '1968-04-11', 'Sr');
413 INSERT INTO actor.usr_address
414 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
415 VALUES ('USA', 't', '60609', '4223 Spotty Chemical Stravenue', 'f',
416 'IL', 'Chicago', '', 'Cook', CURRVAL('actor.usr_id_seq'));
418 INSERT INTO actor.card (barcode, usr)
419 VALUES ('99999371252', CURRVAL('actor.usr_id_seq'));
422 card = CURRVAL('actor.card_id_seq'),
423 billing_address = CURRVAL('actor.usr_address_id_seq'),
424 credit_forward_balance = '0',
425 mailing_address = CURRVAL('actor.usr_address_id_seq')
426 WHERE id=CURRVAL('actor.usr_id_seq');
429 INSERT INTO actor.usr
430 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
431 VALUES (2, 3, '99999398023', 8, 'Phillips', 'noahp1234',
432 'Noah', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, 'III');
434 INSERT INTO actor.usr_address
435 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
436 VALUES ('USA', 't', '33593', '2005 Inner Entry Harbor', 'f',
437 'FL', 'Trilby', '', '', CURRVAL('actor.usr_id_seq'));
439 INSERT INTO actor.card (barcode, usr)
440 VALUES ('99999398023', CURRVAL('actor.usr_id_seq'));
443 card = CURRVAL('actor.card_id_seq'),
444 billing_address = CURRVAL('actor.usr_address_id_seq'),
445 credit_forward_balance = '0',
446 mailing_address = CURRVAL('actor.usr_address_id_seq')
447 WHERE id=CURRVAL('actor.usr_id_seq');
450 INSERT INTO actor.usr
451 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
452 VALUES (2, 3, '99999324566', 5, 'Mitchell', 'carolynm1234',
453 'Carolyn', 'Patrica', NOW() + '3 years'::INTERVAL, '1981-09-03', 'III');
455 INSERT INTO actor.usr_address
456 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
457 VALUES ('USA', 't', '50652', '5259 Film Crossing', 't',
458 'IA', 'Lincoln', '', 'Tama', CURRVAL('actor.usr_id_seq'));
460 INSERT INTO actor.card (barcode, usr)
461 VALUES ('99999324566', CURRVAL('actor.usr_id_seq'));
464 card = CURRVAL('actor.card_id_seq'),
465 billing_address = CURRVAL('actor.usr_address_id_seq'),
466 credit_forward_balance = '0',
467 mailing_address = CURRVAL('actor.usr_address_id_seq')
468 WHERE id=CURRVAL('actor.usr_id_seq');
471 INSERT INTO actor.usr
472 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
473 VALUES (2, 3, '99999379221', 5, 'Wells', 'kristenw1234',
474 'Kristen', 'Vivian', NOW() + '3 years'::INTERVAL, NULL, NULL);
476 INSERT INTO actor.usr_address
477 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
478 VALUES ('USA', 't', '12450', '2302 Prisoner Way', 'f',
479 'NY', 'Lanesville', '', 'Greene', CURRVAL('actor.usr_id_seq'));
481 INSERT INTO actor.card (barcode, usr)
482 VALUES ('99999379221', CURRVAL('actor.usr_id_seq'));
485 card = CURRVAL('actor.card_id_seq'),
486 billing_address = CURRVAL('actor.usr_address_id_seq'),
487 credit_forward_balance = '0',
488 mailing_address = CURRVAL('actor.usr_address_id_seq')
489 WHERE id=CURRVAL('actor.usr_id_seq');
492 INSERT INTO actor.usr
493 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
494 VALUES (2, 1, '99999373350', 8, 'Lindsey', 'noahl1234',
495 'Noah', 'Keith', NOW() + '3 years'::INTERVAL, NULL, NULL);
497 INSERT INTO actor.usr_address
498 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
499 VALUES ('USA', 't', '50108', '7583 Low Surface Overpass', 'f',
500 'IA', 'Grand river', '', 'Decatur', CURRVAL('actor.usr_id_seq'));
502 INSERT INTO actor.card (barcode, usr)
503 VALUES ('99999373350', CURRVAL('actor.usr_id_seq'));
506 card = CURRVAL('actor.card_id_seq'),
507 billing_address = CURRVAL('actor.usr_address_id_seq'),
508 credit_forward_balance = '0',
509 mailing_address = CURRVAL('actor.usr_address_id_seq')
510 WHERE id=CURRVAL('actor.usr_id_seq');
513 INSERT INTO actor.usr
514 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
515 VALUES (2, 3, '99999340920', 4, 'Williams', 'berthaw1234',
516 'Bertha', 'Katherine', NOW() + '3 years'::INTERVAL, NULL, NULL);
518 INSERT INTO actor.usr_address
519 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
520 VALUES ('USA', 't', '20646', '3301 Acid Canyon', 'f',
521 'MD', 'La plata', '', 'Charles', CURRVAL('actor.usr_id_seq'));
523 INSERT INTO actor.card (barcode, usr)
524 VALUES ('99999340920', CURRVAL('actor.usr_id_seq'));
527 card = CURRVAL('actor.card_id_seq'),
528 billing_address = CURRVAL('actor.usr_address_id_seq'),
529 credit_forward_balance = '0',
530 mailing_address = CURRVAL('actor.usr_address_id_seq')
531 WHERE id=CURRVAL('actor.usr_id_seq');
534 INSERT INTO actor.usr
535 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
536 VALUES (2, 1, '99999398482', 7, 'Rodriguez', 'jamesr1234',
537 'James', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
539 INSERT INTO actor.usr_address
540 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
541 VALUES ('USA', 'f', '95066', '9801 Working-class Flower Meadow', 'f',
542 'CA', 'Scotts valley', '', '', CURRVAL('actor.usr_id_seq'));
544 INSERT INTO actor.card (barcode, usr)
545 VALUES ('99999398482', CURRVAL('actor.usr_id_seq'));
548 card = CURRVAL('actor.card_id_seq'),
549 billing_address = CURRVAL('actor.usr_address_id_seq'),
550 credit_forward_balance = '0',
551 mailing_address = CURRVAL('actor.usr_address_id_seq')
552 WHERE id=CURRVAL('actor.usr_id_seq');
555 INSERT INTO actor.usr
556 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
557 VALUES (2, 3, '99999394378', 5, 'Byrd', 'matthewb1234',
558 'Matthew', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL);
560 INSERT INTO actor.usr_address
561 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
562 VALUES ('USA', 't', '43015', '9029 Note Court', 't',
563 'OH', 'Delaware', '', 'Delaware', CURRVAL('actor.usr_id_seq'));
565 INSERT INTO actor.card (barcode, usr)
566 VALUES ('99999394378', CURRVAL('actor.usr_id_seq'));
569 card = CURRVAL('actor.card_id_seq'),
570 billing_address = CURRVAL('actor.usr_address_id_seq'),
571 credit_forward_balance = '0',
572 mailing_address = CURRVAL('actor.usr_address_id_seq')
573 WHERE id=CURRVAL('actor.usr_id_seq');
576 INSERT INTO actor.usr
577 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
578 VALUES (2, 1, '99999382659', 4, 'Kelley', 'sandrak1234',
579 'Sandra', 'Pearlie', NOW() + '3 years'::INTERVAL, '1977-01-18', 'Sr');
581 INSERT INTO actor.usr_address
582 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
583 VALUES ('USA', 'f', '56568', '4246 Fun Post Street', 'f',
584 'MN', 'Nielsville', '', 'Polk', CURRVAL('actor.usr_id_seq'));
586 INSERT INTO actor.card (barcode, usr)
587 VALUES ('99999382659', CURRVAL('actor.usr_id_seq'));
590 card = CURRVAL('actor.card_id_seq'),
591 billing_address = CURRVAL('actor.usr_address_id_seq'),
592 credit_forward_balance = '0',
593 mailing_address = CURRVAL('actor.usr_address_id_seq')
594 WHERE id=CURRVAL('actor.usr_id_seq');
597 INSERT INTO actor.usr
598 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
599 VALUES (2, 1, '99999387130', 7, 'Wilson', 'bethw1234',
600 'Beth', 'Michelle', NOW() + '3 years'::INTERVAL, NULL, NULL);
602 INSERT INTO actor.usr_address
603 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
604 VALUES ('USA', 'f', '15341', '7780 Horrible Winner Island', 'f',
605 'PA', 'Holbrook', '', 'Greene', CURRVAL('actor.usr_id_seq'));
607 INSERT INTO actor.card (barcode, usr)
608 VALUES ('99999387130', CURRVAL('actor.usr_id_seq'));
611 card = CURRVAL('actor.card_id_seq'),
612 billing_address = CURRVAL('actor.usr_address_id_seq'),
613 credit_forward_balance = '0',
614 mailing_address = CURRVAL('actor.usr_address_id_seq')
615 WHERE id=CURRVAL('actor.usr_id_seq');
618 INSERT INTO actor.usr
619 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
620 VALUES (2, 3, '99999310765', 8, 'Daniels', 'randyd1234',
621 'Randy', 'Lawrence', NOW() + '3 years'::INTERVAL, NULL, NULL);
623 INSERT INTO actor.usr_address
624 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
625 VALUES ('USA', 'f', '29680', '4697 Subsequent Culture Pass', 'f',
626 'SC', 'Simpsonville', '', 'Greenville', CURRVAL('actor.usr_id_seq'));
628 INSERT INTO actor.card (barcode, usr)
629 VALUES ('99999310765', CURRVAL('actor.usr_id_seq'));
632 card = CURRVAL('actor.card_id_seq'),
633 billing_address = CURRVAL('actor.usr_address_id_seq'),
634 credit_forward_balance = '0',
635 mailing_address = CURRVAL('actor.usr_address_id_seq')
636 WHERE id=CURRVAL('actor.usr_id_seq');
639 INSERT INTO actor.usr
640 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
641 VALUES (2, 1, '99999335545', 9, 'Simpson', 'steves1234',
642 'Steve', 'Raymond', NOW() + '3 years'::INTERVAL, NULL, NULL);
644 INSERT INTO actor.usr_address
645 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
646 VALUES ('USA', 'f', '88118', '2400 Communication Mount', 'f',
647 'NM', 'Floyd', '', '', CURRVAL('actor.usr_id_seq'));
649 INSERT INTO actor.card (barcode, usr)
650 VALUES ('99999335545', CURRVAL('actor.usr_id_seq'));
653 card = CURRVAL('actor.card_id_seq'),
654 billing_address = CURRVAL('actor.usr_address_id_seq'),
655 credit_forward_balance = '0',
656 mailing_address = CURRVAL('actor.usr_address_id_seq')
657 WHERE id=CURRVAL('actor.usr_id_seq');
660 INSERT INTO actor.usr
661 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
662 VALUES (2, 3, '99999360529', 5, 'Hoskins', 'jimh1234',
663 'Jim', 'Michael', NOW() + '3 years'::INTERVAL, '1983-08-02', 'III');
665 INSERT INTO actor.usr_address
666 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
667 VALUES ('USA', 'f', '15015', '7815 Principal Element Center', 't',
668 'PA', 'Bradfordwoods', '', 'Allegheny', CURRVAL('actor.usr_id_seq'));
670 INSERT INTO actor.card (barcode, usr)
671 VALUES ('99999360529', CURRVAL('actor.usr_id_seq'));
674 card = CURRVAL('actor.card_id_seq'),
675 billing_address = CURRVAL('actor.usr_address_id_seq'),
676 credit_forward_balance = '0',
677 mailing_address = CURRVAL('actor.usr_address_id_seq')
678 WHERE id=CURRVAL('actor.usr_id_seq');
681 INSERT INTO actor.usr
682 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
683 VALUES (2, 3, '99999357038', 5, 'May', 'michaelm1234',
684 'Michael', '', NOW() + '3 years'::INTERVAL, '1988-03-06', 'II');
686 INSERT INTO actor.usr_address
687 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
688 VALUES ('USA', 'f', '20064', '4827 Shoulder Center', 'f',
689 'DC', 'Washington', '', 'District of columbia', CURRVAL('actor.usr_id_seq'));
691 INSERT INTO actor.card (barcode, usr)
692 VALUES ('99999357038', CURRVAL('actor.usr_id_seq'));
695 card = CURRVAL('actor.card_id_seq'),
696 billing_address = CURRVAL('actor.usr_address_id_seq'),
697 credit_forward_balance = '0',
698 mailing_address = CURRVAL('actor.usr_address_id_seq')
699 WHERE id=CURRVAL('actor.usr_id_seq');
702 INSERT INTO actor.usr
703 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
704 VALUES (2, 3, '99999371688', 8, 'Ellison', 'done1234',
705 'Don', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL);
707 INSERT INTO actor.usr_address
708 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
709 VALUES ('USA', 'f', '20643', '1298 Golden Speed Hills', 't',
710 'MD', 'Ironsides', '', '', CURRVAL('actor.usr_id_seq'));
712 INSERT INTO actor.card (barcode, usr)
713 VALUES ('99999371688', CURRVAL('actor.usr_id_seq'));
716 card = CURRVAL('actor.card_id_seq'),
717 billing_address = CURRVAL('actor.usr_address_id_seq'),
718 credit_forward_balance = '0',
719 mailing_address = CURRVAL('actor.usr_address_id_seq')
720 WHERE id=CURRVAL('actor.usr_id_seq');
723 INSERT INTO actor.usr
724 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
725 VALUES (2, 1, '99999312757', 4, 'Hughes', 'josephh1234',
726 'Joseph', 'Bryant', NOW() + '3 years'::INTERVAL, NULL, NULL);
728 INSERT INTO actor.usr_address
729 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
730 VALUES ('USA', 't', '48613', '9736 Profitable Wine Spring', 'f',
731 'MI', 'Bentley', '', 'Bay', CURRVAL('actor.usr_id_seq'));
733 INSERT INTO actor.card (barcode, usr)
734 VALUES ('99999312757', CURRVAL('actor.usr_id_seq'));
737 card = CURRVAL('actor.card_id_seq'),
738 billing_address = CURRVAL('actor.usr_address_id_seq'),
739 credit_forward_balance = '0',
740 mailing_address = CURRVAL('actor.usr_address_id_seq')
741 WHERE id=CURRVAL('actor.usr_id_seq');
744 INSERT INTO actor.usr
745 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
746 VALUES (2, 1, '99999399015', 8, 'Turner', 'cristinat1234',
747 'Cristina', 'Karen', NOW() + '3 years'::INTERVAL, NULL, NULL);
749 INSERT INTO actor.usr_address
750 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
751 VALUES ('USA', 't', '45844', '6445 Turkish Strike Shoal', 't',
752 'OH', 'Fort jennings', '', 'Putnam', CURRVAL('actor.usr_id_seq'));
754 INSERT INTO actor.card (barcode, usr)
755 VALUES ('99999399015', CURRVAL('actor.usr_id_seq'));
758 card = CURRVAL('actor.card_id_seq'),
759 billing_address = CURRVAL('actor.usr_address_id_seq'),
760 credit_forward_balance = '0',
761 mailing_address = CURRVAL('actor.usr_address_id_seq')
762 WHERE id=CURRVAL('actor.usr_id_seq');
765 INSERT INTO actor.usr
766 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
767 VALUES (2, 3, '99999313973', 4, 'Langley', 'victorl1234',
768 'Victor', 'James', NOW() + '3 years'::INTERVAL, NULL, NULL);
770 INSERT INTO actor.usr_address
771 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
772 VALUES ('USA', 'f', '94576', '1082 Capacity Hill', 'f',
773 'CA', 'Deer park', '', 'Napa', CURRVAL('actor.usr_id_seq'));
775 INSERT INTO actor.card (barcode, usr)
776 VALUES ('99999313973', CURRVAL('actor.usr_id_seq'));
779 card = CURRVAL('actor.card_id_seq'),
780 billing_address = CURRVAL('actor.usr_address_id_seq'),
781 credit_forward_balance = '0',
782 mailing_address = CURRVAL('actor.usr_address_id_seq')
783 WHERE id=CURRVAL('actor.usr_id_seq');
786 INSERT INTO actor.usr
787 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
788 VALUES (2, 1, '99999311521', 6, 'Fields', 'davidf1234',
789 'David', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
791 INSERT INTO actor.usr_address
792 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
793 VALUES ('USA', 'f', '73939', '8788 Religious Writer Isle', 'f',
794 'OK', 'Goodwell', '', 'Texas', CURRVAL('actor.usr_id_seq'));
796 INSERT INTO actor.card (barcode, usr)
797 VALUES ('99999311521', CURRVAL('actor.usr_id_seq'));
800 card = CURRVAL('actor.card_id_seq'),
801 billing_address = CURRVAL('actor.usr_address_id_seq'),
802 credit_forward_balance = '0',
803 mailing_address = CURRVAL('actor.usr_address_id_seq')
804 WHERE id=CURRVAL('actor.usr_id_seq');
807 INSERT INTO actor.usr
808 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
809 VALUES (2, 1, '99999388816', 7, 'Hoffman', 'gregoryh1234',
810 'Gregory', 'Thomas', NOW() + '3 years'::INTERVAL, '1999-11-13', 'II');
812 INSERT INTO actor.usr_address
813 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
814 VALUES ('USA', 't', '47163', '4971 Assembly Parkways', 'f',
815 'IN', 'Otisco', '', 'Clark', CURRVAL('actor.usr_id_seq'));
817 INSERT INTO actor.card (barcode, usr)
818 VALUES ('99999388816', CURRVAL('actor.usr_id_seq'));
821 card = CURRVAL('actor.card_id_seq'),
822 billing_address = CURRVAL('actor.usr_address_id_seq'),
823 credit_forward_balance = '0',
824 mailing_address = CURRVAL('actor.usr_address_id_seq')
825 WHERE id=CURRVAL('actor.usr_id_seq');
828 INSERT INTO actor.usr
829 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
830 VALUES (2, 3, '99999345160', 8, 'Gonzalez', 'natalieg1234',
831 'Natalie', 'Joan', NOW() + '3 years'::INTERVAL, NULL, NULL);
833 INSERT INTO actor.usr_address
834 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
835 VALUES ('USA', 't', '17120', '8835 Amazing Reduction Course', 'f',
836 'PA', 'Harrisburg', '', 'Dauphin', CURRVAL('actor.usr_id_seq'));
838 INSERT INTO actor.card (barcode, usr)
839 VALUES ('99999345160', CURRVAL('actor.usr_id_seq'));
842 card = CURRVAL('actor.card_id_seq'),
843 billing_address = CURRVAL('actor.usr_address_id_seq'),
844 credit_forward_balance = '0',
845 mailing_address = CURRVAL('actor.usr_address_id_seq')
846 WHERE id=CURRVAL('actor.usr_id_seq');
849 INSERT INTO actor.usr
850 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
851 VALUES (2, 3, '99999328966', 9, 'Rucker', 'drewr1234',
852 'Drew', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
854 INSERT INTO actor.usr_address
855 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
856 VALUES ('USA', 'f', '92253', '5158 Redundant Reality Creek', 'f',
857 'CA', 'La quinta', '', 'Riverside', CURRVAL('actor.usr_id_seq'));
859 INSERT INTO actor.card (barcode, usr)
860 VALUES ('99999328966', CURRVAL('actor.usr_id_seq'));
863 card = CURRVAL('actor.card_id_seq'),
864 billing_address = CURRVAL('actor.usr_address_id_seq'),
865 credit_forward_balance = '0',
866 mailing_address = CURRVAL('actor.usr_address_id_seq')
867 WHERE id=CURRVAL('actor.usr_id_seq');
870 INSERT INTO actor.usr
871 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
872 VALUES (2, 3, '99999394635', 9, 'Mitchell', 'kimberlym1234',
873 'Kimberly', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
875 INSERT INTO actor.usr_address
876 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
877 VALUES ('USA', 'f', '85375', '9724 Land Corner', 'f',
878 'AZ', 'Sun city west', '', '', CURRVAL('actor.usr_id_seq'));
880 INSERT INTO actor.card (barcode, usr)
881 VALUES ('99999394635', CURRVAL('actor.usr_id_seq'));
884 card = CURRVAL('actor.card_id_seq'),
885 billing_address = CURRVAL('actor.usr_address_id_seq'),
886 credit_forward_balance = '0',
887 mailing_address = CURRVAL('actor.usr_address_id_seq')
888 WHERE id=CURRVAL('actor.usr_id_seq');
891 INSERT INTO actor.usr
892 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
893 VALUES (2, 1, '99999333308', 7, 'Murray', 'heatherm1234',
894 'Heather', 'Margaret', NOW() + '3 years'::INTERVAL, NULL, NULL);
896 INSERT INTO actor.usr_address
897 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
898 VALUES ('USA', 'f', '51239', '5555 Project Bypass', 'f',
899 'IA', 'Hull', '', 'Sioux', CURRVAL('actor.usr_id_seq'));
901 INSERT INTO actor.card (barcode, usr)
902 VALUES ('99999333308', CURRVAL('actor.usr_id_seq'));
905 card = CURRVAL('actor.card_id_seq'),
906 billing_address = CURRVAL('actor.usr_address_id_seq'),
907 credit_forward_balance = '0',
908 mailing_address = CURRVAL('actor.usr_address_id_seq')
909 WHERE id=CURRVAL('actor.usr_id_seq');
912 INSERT INTO actor.usr
913 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
914 VALUES (2, 1, '99999316647', 7, 'Sosa', 'robertas1234',
915 'Roberta', 'Norma', NOW() + '3 years'::INTERVAL, NULL, NULL);
917 INSERT INTO actor.usr_address
918 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
919 VALUES ('USA', 'f', '94010', '4571 Jealous Comparison Wells', 'f',
920 'CA', 'Burlingame', '', '', CURRVAL('actor.usr_id_seq'));
922 INSERT INTO actor.card (barcode, usr)
923 VALUES ('99999316647', CURRVAL('actor.usr_id_seq'));
926 card = CURRVAL('actor.card_id_seq'),
927 billing_address = CURRVAL('actor.usr_address_id_seq'),
928 credit_forward_balance = '0',
929 mailing_address = CURRVAL('actor.usr_address_id_seq')
930 WHERE id=CURRVAL('actor.usr_id_seq');
933 INSERT INTO actor.usr
934 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
935 VALUES (2, 1, '99999389066', 4, 'Ramos', 'annetter1234',
936 'Annette', 'Angela', NOW() + '3 years'::INTERVAL, '1967-11-04', 'II');
938 INSERT INTO actor.usr_address
939 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
940 VALUES ('USA', 'f', '29621', '9196 Old Future Fort', 'f',
941 'SC', 'Anderson', '', 'Anderson', CURRVAL('actor.usr_id_seq'));
943 INSERT INTO actor.card (barcode, usr)
944 VALUES ('99999389066', CURRVAL('actor.usr_id_seq'));
947 card = CURRVAL('actor.card_id_seq'),
948 billing_address = CURRVAL('actor.usr_address_id_seq'),
949 credit_forward_balance = '0',
950 mailing_address = CURRVAL('actor.usr_address_id_seq')
951 WHERE id=CURRVAL('actor.usr_id_seq');
954 INSERT INTO actor.usr
955 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
956 VALUES (2, 1, '99999380162', 8, 'Jackson', 'paulj1234',
957 'Paul', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
959 INSERT INTO actor.usr_address
960 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
961 VALUES ('USA', 't', '77651', '9869 Convention Pine', 't',
962 'TX', 'Port neches', '', 'Jefferson', CURRVAL('actor.usr_id_seq'));
964 INSERT INTO actor.card (barcode, usr)
965 VALUES ('99999380162', CURRVAL('actor.usr_id_seq'));
968 card = CURRVAL('actor.card_id_seq'),
969 billing_address = CURRVAL('actor.usr_address_id_seq'),
970 credit_forward_balance = '0',
971 mailing_address = CURRVAL('actor.usr_address_id_seq')
972 WHERE id=CURRVAL('actor.usr_id_seq');
975 INSERT INTO actor.usr
976 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
977 VALUES (2, 1, '99999318240', 7, 'Graham', 'johng1234',
978 'John', 'Charles', NOW() + '3 years'::INTERVAL, NULL, NULL);
980 INSERT INTO actor.usr_address
981 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
982 VALUES ('USA', 't', '03216', '3676 Sweet Campaign Courts', 'f',
983 'NH', 'Andover', '', 'Merrimack', CURRVAL('actor.usr_id_seq'));
985 INSERT INTO actor.card (barcode, usr)
986 VALUES ('99999318240', CURRVAL('actor.usr_id_seq'));
989 card = CURRVAL('actor.card_id_seq'),
990 billing_address = CURRVAL('actor.usr_address_id_seq'),
991 credit_forward_balance = '0',
992 mailing_address = CURRVAL('actor.usr_address_id_seq')
993 WHERE id=CURRVAL('actor.usr_id_seq');
996 INSERT INTO actor.usr
997 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
998 VALUES (2, 3, '99999347267', 7, 'Michael', 'adamm1234',
999 'Adam', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL);
1001 INSERT INTO actor.usr_address
1002 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1003 VALUES ('USA', 't', '68113', '7244 Brief Tree Crescent', 'f',
1004 'NE', 'Offutt a f b', '', 'Sarpy', CURRVAL('actor.usr_id_seq'));
1006 INSERT INTO actor.card (barcode, usr)
1007 VALUES ('99999347267', CURRVAL('actor.usr_id_seq'));
1009 UPDATE actor.usr SET
1010 card = CURRVAL('actor.card_id_seq'),
1011 billing_address = CURRVAL('actor.usr_address_id_seq'),
1012 credit_forward_balance = '0',
1013 mailing_address = CURRVAL('actor.usr_address_id_seq')
1014 WHERE id=CURRVAL('actor.usr_id_seq');
1017 INSERT INTO actor.usr
1018 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1019 VALUES (2, 3, '99999344618', 7, 'Thomas', 'helent1234',
1020 'Helen', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1022 INSERT INTO actor.usr_address
1023 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1024 VALUES ('USA', 'f', '43534', '5066 Disabled Drink Ford', 'f',
1025 'OH', 'Mc clure', '', 'Henry', CURRVAL('actor.usr_id_seq'));
1027 INSERT INTO actor.card (barcode, usr)
1028 VALUES ('99999344618', CURRVAL('actor.usr_id_seq'));
1030 UPDATE actor.usr SET
1031 card = CURRVAL('actor.card_id_seq'),
1032 billing_address = CURRVAL('actor.usr_address_id_seq'),
1033 credit_forward_balance = '0',
1034 mailing_address = CURRVAL('actor.usr_address_id_seq')
1035 WHERE id=CURRVAL('actor.usr_id_seq');
1038 INSERT INTO actor.usr
1039 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1040 VALUES (2, 1, '99999301966', 7, 'Rivas', 'meghanr1234',
1041 'Meghan', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1043 INSERT INTO actor.usr_address
1044 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1045 VALUES ('USA', 't', '48328', '1604 Other Factor Harbor', 't',
1046 'MI', 'Waterford', '', 'Oakland', CURRVAL('actor.usr_id_seq'));
1048 INSERT INTO actor.card (barcode, usr)
1049 VALUES ('99999301966', CURRVAL('actor.usr_id_seq'));
1051 UPDATE actor.usr SET
1052 card = CURRVAL('actor.card_id_seq'),
1053 billing_address = CURRVAL('actor.usr_address_id_seq'),
1054 credit_forward_balance = '0',
1055 mailing_address = CURRVAL('actor.usr_address_id_seq')
1056 WHERE id=CURRVAL('actor.usr_id_seq');
1059 INSERT INTO actor.usr
1060 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1061 VALUES (2, 3, '99999306663', 5, 'Hurst', 'williamh1234',
1062 'William', 'Ian', NOW() + '3 years'::INTERVAL, NULL, NULL);
1064 INSERT INTO actor.usr_address
1065 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1066 VALUES ('USA', 't', '76937', '7986 Line Grove', 'f',
1067 'TX', 'Eola', '', '', CURRVAL('actor.usr_id_seq'));
1069 INSERT INTO actor.card (barcode, usr)
1070 VALUES ('99999306663', CURRVAL('actor.usr_id_seq'));
1072 UPDATE actor.usr SET
1073 card = CURRVAL('actor.card_id_seq'),
1074 billing_address = CURRVAL('actor.usr_address_id_seq'),
1075 credit_forward_balance = '0',
1076 mailing_address = CURRVAL('actor.usr_address_id_seq')
1077 WHERE id=CURRVAL('actor.usr_id_seq');
1080 INSERT INTO actor.usr
1081 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1082 VALUES (2, 3, '99999329410', 8, 'Bridges', 'kimberlyb1234',
1083 'Kimberly', 'Anna', NOW() + '3 years'::INTERVAL, NULL, NULL);
1085 INSERT INTO actor.usr_address
1086 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1087 VALUES ('USA', 't', '21047', '9992 Show Village', 'f',
1088 'MD', 'Fallston', '', 'Harford', CURRVAL('actor.usr_id_seq'));
1090 INSERT INTO actor.card (barcode, usr)
1091 VALUES ('99999329410', CURRVAL('actor.usr_id_seq'));
1093 UPDATE actor.usr SET
1094 card = CURRVAL('actor.card_id_seq'),
1095 billing_address = CURRVAL('actor.usr_address_id_seq'),
1096 credit_forward_balance = '0',
1097 mailing_address = CURRVAL('actor.usr_address_id_seq')
1098 WHERE id=CURRVAL('actor.usr_id_seq');
1101 INSERT INTO actor.usr
1102 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1103 VALUES (2, 3, '99999396820', 6, 'Stewart', 'beatrices1234',
1104 'Beatrice', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL);
1106 INSERT INTO actor.usr_address
1107 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1108 VALUES ('USA', 't', '64123', '7373 Social Fact Roads', 'f',
1109 'MO', 'Kansas city', '', 'Jackson', CURRVAL('actor.usr_id_seq'));
1111 INSERT INTO actor.card (barcode, usr)
1112 VALUES ('99999396820', CURRVAL('actor.usr_id_seq'));
1114 UPDATE actor.usr SET
1115 card = CURRVAL('actor.card_id_seq'),
1116 billing_address = CURRVAL('actor.usr_address_id_seq'),
1117 credit_forward_balance = '0',
1118 mailing_address = CURRVAL('actor.usr_address_id_seq')
1119 WHERE id=CURRVAL('actor.usr_id_seq');
1122 INSERT INTO actor.usr
1123 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1124 VALUES (2, 3, '99999398998', 7, 'Welsh', 'alejandraw1234',
1125 'Alejandra', 'Christine', NOW() + '3 years'::INTERVAL, '1973-11-18', 'III');
1127 INSERT INTO actor.usr_address
1128 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1129 VALUES ('USA', 't', '91615', '4270 Deafening Speed Stream', 'f',
1130 'CA', 'North hollywood', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
1132 INSERT INTO actor.card (barcode, usr)
1133 VALUES ('99999398998', CURRVAL('actor.usr_id_seq'));
1135 UPDATE actor.usr SET
1136 card = CURRVAL('actor.card_id_seq'),
1137 billing_address = CURRVAL('actor.usr_address_id_seq'),
1138 credit_forward_balance = '0',
1139 mailing_address = CURRVAL('actor.usr_address_id_seq')
1140 WHERE id=CURRVAL('actor.usr_id_seq');
1143 INSERT INTO actor.usr
1144 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1145 VALUES (2, 3, '99999308688', 9, 'Osborne', 'leonao1234',
1146 'Leona', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1148 INSERT INTO actor.usr_address
1149 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1150 VALUES ('USA', 'f', '65261', '1368 Defiant Visit Drive', 'f',
1151 'MO', 'Keytesville', '', 'Chariton', CURRVAL('actor.usr_id_seq'));
1153 INSERT INTO actor.card (barcode, usr)
1154 VALUES ('99999308688', CURRVAL('actor.usr_id_seq'));
1156 UPDATE actor.usr SET
1157 card = CURRVAL('actor.card_id_seq'),
1158 billing_address = CURRVAL('actor.usr_address_id_seq'),
1159 credit_forward_balance = '0',
1160 mailing_address = CURRVAL('actor.usr_address_id_seq')
1161 WHERE id=CURRVAL('actor.usr_id_seq');
1164 INSERT INTO actor.usr
1165 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1166 VALUES (2, 3, '99999321465', 4, 'Sinclair', 'luellas1234',
1167 'Luella', 'Carole', NOW() + '3 years'::INTERVAL, '1993-10-15', 'II');
1169 INSERT INTO actor.usr_address
1170 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1171 VALUES ('USA', 't', '45314', '3011 Thoughtful Law Terrace', 'f',
1172 'OH', 'Cedarville', '', 'Greene', CURRVAL('actor.usr_id_seq'));
1174 INSERT INTO actor.card (barcode, usr)
1175 VALUES ('99999321465', CURRVAL('actor.usr_id_seq'));
1177 UPDATE actor.usr SET
1178 card = CURRVAL('actor.card_id_seq'),
1179 billing_address = CURRVAL('actor.usr_address_id_seq'),
1180 credit_forward_balance = '0',
1181 mailing_address = CURRVAL('actor.usr_address_id_seq')
1182 WHERE id=CURRVAL('actor.usr_id_seq');
1185 INSERT INTO actor.usr
1186 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1187 VALUES (2, 3, '99999399294', 5, 'Jones', 'joej1234',
1188 'Joe', 'Wayne', NOW() + '3 years'::INTERVAL, NULL, NULL);
1190 INSERT INTO actor.usr_address
1191 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1192 VALUES ('USA', 't', '12167', '1641 Jolly Period Bend', 'f',
1193 'NY', 'Stamford', '', 'Delaware', CURRVAL('actor.usr_id_seq'));
1195 INSERT INTO actor.card (barcode, usr)
1196 VALUES ('99999399294', CURRVAL('actor.usr_id_seq'));
1198 UPDATE actor.usr SET
1199 card = CURRVAL('actor.card_id_seq'),
1200 billing_address = CURRVAL('actor.usr_address_id_seq'),
1201 credit_forward_balance = '0',
1202 mailing_address = CURRVAL('actor.usr_address_id_seq')
1203 WHERE id=CURRVAL('actor.usr_id_seq');
1206 INSERT INTO actor.usr
1207 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1208 VALUES (2, 3, '99999355645', 6, 'Duncan', 'willied1234',
1209 'Willie', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1211 INSERT INTO actor.usr_address
1212 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1213 VALUES ('USA', 'f', '34682', '9904 Australian Cash Squares', 'f',
1214 'FL', 'Palm harbor', '', 'Pinellas', CURRVAL('actor.usr_id_seq'));
1216 INSERT INTO actor.card (barcode, usr)
1217 VALUES ('99999355645', CURRVAL('actor.usr_id_seq'));
1219 UPDATE actor.usr SET
1220 card = CURRVAL('actor.card_id_seq'),
1221 billing_address = CURRVAL('actor.usr_address_id_seq'),
1222 credit_forward_balance = '0',
1223 mailing_address = CURRVAL('actor.usr_address_id_seq')
1224 WHERE id=CURRVAL('actor.usr_id_seq');
1227 INSERT INTO actor.usr
1228 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1229 VALUES (2, 3, '99999359616', 6, 'Carney', 'andreac1234',
1230 'Andrea', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1232 INSERT INTO actor.usr_address
1233 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1234 VALUES ('USA', 't', '23442', '9706 Jealous Alternative Fort', 't',
1235 'VA', 'Temperanceville', '', 'Accomack', CURRVAL('actor.usr_id_seq'));
1237 INSERT INTO actor.card (barcode, usr)
1238 VALUES ('99999359616', CURRVAL('actor.usr_id_seq'));
1240 UPDATE actor.usr SET
1241 card = CURRVAL('actor.card_id_seq'),
1242 billing_address = CURRVAL('actor.usr_address_id_seq'),
1243 credit_forward_balance = '0',
1244 mailing_address = CURRVAL('actor.usr_address_id_seq')
1245 WHERE id=CURRVAL('actor.usr_id_seq');
1248 INSERT INTO actor.usr
1249 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1250 VALUES (2, 1, '99999359143', 9, 'Hunt', 'howardh1234',
1251 'Howard', 'Ralph', NOW() + '3 years'::INTERVAL, '1971-05-09', 'Jr');
1253 INSERT INTO actor.usr_address
1254 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1255 VALUES ('USA', 'f', '49337', '1182 Radical Letter Square', 'f',
1256 'MI', 'Newaygo', '', 'Newaygo', CURRVAL('actor.usr_id_seq'));
1258 INSERT INTO actor.card (barcode, usr)
1259 VALUES ('99999359143', CURRVAL('actor.usr_id_seq'));
1261 UPDATE actor.usr SET
1262 card = CURRVAL('actor.card_id_seq'),
1263 billing_address = CURRVAL('actor.usr_address_id_seq'),
1264 credit_forward_balance = '0',
1265 mailing_address = CURRVAL('actor.usr_address_id_seq')
1266 WHERE id=CURRVAL('actor.usr_id_seq');
1269 INSERT INTO actor.usr
1270 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1271 VALUES (2, 3, '99999389009', 6, 'Martin', 'eddiem1234',
1272 'Eddie', 'Anthony', NOW() + '3 years'::INTERVAL, NULL, NULL);
1274 INSERT INTO actor.usr_address
1275 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1276 VALUES ('USA', 'f', '95031', '1938 Fundamental Distribution Lane', 'f',
1277 'CA', 'Los gatos', '', '', CURRVAL('actor.usr_id_seq'));
1279 INSERT INTO actor.card (barcode, usr)
1280 VALUES ('99999389009', CURRVAL('actor.usr_id_seq'));
1282 UPDATE actor.usr SET
1283 card = CURRVAL('actor.card_id_seq'),
1284 billing_address = CURRVAL('actor.usr_address_id_seq'),
1285 credit_forward_balance = '0',
1286 mailing_address = CURRVAL('actor.usr_address_id_seq')
1287 WHERE id=CURRVAL('actor.usr_id_seq');
1290 INSERT INTO actor.usr
1291 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1292 VALUES (2, 1, '99999327461', 9, 'Barry', 'paulb1234',
1293 'Paul', 'Richard', NOW() + '3 years'::INTERVAL, NULL, NULL);
1295 INSERT INTO actor.usr_address
1296 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1297 VALUES ('USA', 't', '40583', '9317 Testy Soil Place', 'f',
1298 'KY', 'Lexington', '', 'Fayette', CURRVAL('actor.usr_id_seq'));
1300 INSERT INTO actor.card (barcode, usr)
1301 VALUES ('99999327461', CURRVAL('actor.usr_id_seq'));
1303 UPDATE actor.usr SET
1304 card = CURRVAL('actor.card_id_seq'),
1305 billing_address = CURRVAL('actor.usr_address_id_seq'),
1306 credit_forward_balance = '0',
1307 mailing_address = CURRVAL('actor.usr_address_id_seq')
1308 WHERE id=CURRVAL('actor.usr_id_seq');
1311 INSERT INTO actor.usr
1312 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1313 VALUES (2, 1, '99999319193', 7, 'Wright', 'dennisw1234',
1314 'Dennis', 'Jimmie', NOW() + '3 years'::INTERVAL, '1992-09-05', 'II');
1316 INSERT INTO actor.usr_address
1317 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1318 VALUES ('USA', 'f', '24925', '7338 Drab Development Underpass', 't',
1319 'WV', 'Caldwell', '', 'Greenbrier', CURRVAL('actor.usr_id_seq'));
1321 INSERT INTO actor.card (barcode, usr)
1322 VALUES ('99999319193', CURRVAL('actor.usr_id_seq'));
1324 UPDATE actor.usr SET
1325 card = CURRVAL('actor.card_id_seq'),
1326 billing_address = CURRVAL('actor.usr_address_id_seq'),
1327 credit_forward_balance = '0',
1328 mailing_address = CURRVAL('actor.usr_address_id_seq')
1329 WHERE id=CURRVAL('actor.usr_id_seq');
1332 INSERT INTO actor.usr
1333 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1334 VALUES (2, 1, '99999378520', 5, 'Saunders', 'rubens1234',
1335 'Ruben', 'Eric', NOW() + '3 years'::INTERVAL, NULL, NULL);
1337 INSERT INTO actor.usr_address
1338 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1339 VALUES ('USA', 'f', '32648', '2941 Conservation Race Haven', 'f',
1340 'FL', 'Horseshoe beach', '', '', CURRVAL('actor.usr_id_seq'));
1342 INSERT INTO actor.card (barcode, usr)
1343 VALUES ('99999378520', CURRVAL('actor.usr_id_seq'));
1345 UPDATE actor.usr SET
1346 card = CURRVAL('actor.card_id_seq'),
1347 billing_address = CURRVAL('actor.usr_address_id_seq'),
1348 credit_forward_balance = '0',
1349 mailing_address = CURRVAL('actor.usr_address_id_seq')
1350 WHERE id=CURRVAL('actor.usr_id_seq');
1353 INSERT INTO actor.usr
1354 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1355 VALUES (2, 3, '99999366196', 7, 'Lane', 'jenniferl1234',
1356 'Jennifer', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1358 INSERT INTO actor.usr_address
1359 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1360 VALUES ('USA', 't', '12456', '5547 Knee Underpass', 'f',
1361 'NY', 'Mount marion', '', 'Ulster', CURRVAL('actor.usr_id_seq'));
1363 INSERT INTO actor.card (barcode, usr)
1364 VALUES ('99999366196', CURRVAL('actor.usr_id_seq'));
1366 UPDATE actor.usr SET
1367 card = CURRVAL('actor.card_id_seq'),
1368 billing_address = CURRVAL('actor.usr_address_id_seq'),
1369 credit_forward_balance = '0',
1370 mailing_address = CURRVAL('actor.usr_address_id_seq')
1371 WHERE id=CURRVAL('actor.usr_id_seq');
1374 INSERT INTO actor.usr
1375 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1376 VALUES (2, 1, '99999324371', 5, 'Madden', 'jom1234',
1377 'Jo', 'Mae', NOW() + '3 years'::INTERVAL, NULL, NULL);
1379 INSERT INTO actor.usr_address
1380 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1381 VALUES ('USA', 'f', '19612', '3125 League Brook', 'f',
1382 'PA', 'Reading', '', 'Berks', CURRVAL('actor.usr_id_seq'));
1384 INSERT INTO actor.card (barcode, usr)
1385 VALUES ('99999324371', CURRVAL('actor.usr_id_seq'));
1387 UPDATE actor.usr SET
1388 card = CURRVAL('actor.card_id_seq'),
1389 billing_address = CURRVAL('actor.usr_address_id_seq'),
1390 credit_forward_balance = '0',
1391 mailing_address = CURRVAL('actor.usr_address_id_seq')
1392 WHERE id=CURRVAL('actor.usr_id_seq');
1395 INSERT INTO actor.usr
1396 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1397 VALUES (2, 3, '99999316280', 8, 'Harding', 'naomih1234',
1398 'Naomi', 'Julie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1400 INSERT INTO actor.usr_address
1401 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1402 VALUES ('USA', 't', '93021', '6693 Thin Entry Lake', 't',
1403 'CA', 'Moorpark', '', 'Ventura', CURRVAL('actor.usr_id_seq'));
1405 INSERT INTO actor.card (barcode, usr)
1406 VALUES ('99999316280', CURRVAL('actor.usr_id_seq'));
1408 UPDATE actor.usr SET
1409 card = CURRVAL('actor.card_id_seq'),
1410 billing_address = CURRVAL('actor.usr_address_id_seq'),
1411 credit_forward_balance = '0',
1412 mailing_address = CURRVAL('actor.usr_address_id_seq')
1413 WHERE id=CURRVAL('actor.usr_id_seq');
1416 INSERT INTO actor.usr
1417 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1418 VALUES (2, 3, '99999388575', 5, 'Davis', 'blaked1234',
1419 'Blake', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL);
1421 INSERT INTO actor.usr_address
1422 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1423 VALUES ('USA', 't', '13856', '8634 Need Bridge', 'f',
1424 'NY', 'Walton', '', '', CURRVAL('actor.usr_id_seq'));
1426 INSERT INTO actor.card (barcode, usr)
1427 VALUES ('99999388575', CURRVAL('actor.usr_id_seq'));
1429 UPDATE actor.usr SET
1430 card = CURRVAL('actor.card_id_seq'),
1431 billing_address = CURRVAL('actor.usr_address_id_seq'),
1432 credit_forward_balance = '0',
1433 mailing_address = CURRVAL('actor.usr_address_id_seq')
1434 WHERE id=CURRVAL('actor.usr_id_seq');
1437 INSERT INTO actor.usr
1438 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1439 VALUES (2, 3, '99999336610', 4, 'Barnes', 'normab1234',
1440 'Norma', 'Gail', NOW() + '3 years'::INTERVAL, NOW() + '3 years'::INTERVAL, '');
1442 INSERT INTO actor.usr_address
1443 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1444 VALUES ('USA', 't', '23107', '218 Region River', 'f',
1445 'VA', 'Maryus', '', 'Gloucester', CURRVAL('actor.usr_id_seq'));
1447 INSERT INTO actor.card (barcode, usr)
1448 VALUES ('99999336610', CURRVAL('actor.usr_id_seq'));
1450 UPDATE actor.usr SET
1451 card = CURRVAL('actor.card_id_seq'),
1452 billing_address = CURRVAL('actor.usr_address_id_seq'),
1453 credit_forward_balance = '0',
1454 mailing_address = CURRVAL('actor.usr_address_id_seq')
1455 WHERE id=CURRVAL('actor.usr_id_seq');
1458 INSERT INTO actor.usr
1459 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1460 VALUES (2, 3, '99999376864', 4, 'Anderson', 'leona1234',
1461 'Leon', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1463 INSERT INTO actor.usr_address
1464 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1465 VALUES ('USA', 'f', '27315', '9834 Standard Stravenue', 'f',
1466 'NC', 'Providence', '', '', CURRVAL('actor.usr_id_seq'));
1468 INSERT INTO actor.card (barcode, usr)
1469 VALUES ('99999376864', CURRVAL('actor.usr_id_seq'));
1471 UPDATE actor.usr SET
1472 card = CURRVAL('actor.card_id_seq'),
1473 billing_address = CURRVAL('actor.usr_address_id_seq'),
1474 credit_forward_balance = '0',
1475 mailing_address = CURRVAL('actor.usr_address_id_seq')
1476 WHERE id=CURRVAL('actor.usr_id_seq');
1479 INSERT INTO actor.usr
1480 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1481 VALUES (2, 1, '99999391951', 7, 'Gillespie', 'mistyg1234',
1482 'Misty', 'Margaret', NOW() + '3 years'::INTERVAL, '1993-10-19', 'III');
1484 INSERT INTO actor.usr_address
1485 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1486 VALUES ('USA', 't', '47273', '4151 Severe Look Fort', 'f',
1487 'IN', 'Scipio', '', 'Jennings', CURRVAL('actor.usr_id_seq'));
1489 INSERT INTO actor.card (barcode, usr)
1490 VALUES ('99999391951', CURRVAL('actor.usr_id_seq'));
1492 UPDATE actor.usr SET
1493 card = CURRVAL('actor.card_id_seq'),
1494 billing_address = CURRVAL('actor.usr_address_id_seq'),
1495 credit_forward_balance = '0',
1496 mailing_address = CURRVAL('actor.usr_address_id_seq')
1497 WHERE id=CURRVAL('actor.usr_id_seq');
1500 INSERT INTO actor.usr
1501 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1502 VALUES (2, 3, '99999368950', 7, 'Santos', 'esthers1234',
1503 'Esther', 'Mary', NOW() + '3 years'::INTERVAL, '1961-12-17', 'Sr');
1505 INSERT INTO actor.usr_address
1506 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1507 VALUES ('USA', 'f', '06468', '2774 Melted Stone Islands', 'f',
1508 'CT', 'Monroe', '', 'Fairfield', CURRVAL('actor.usr_id_seq'));
1510 INSERT INTO actor.card (barcode, usr)
1511 VALUES ('99999368950', CURRVAL('actor.usr_id_seq'));
1513 UPDATE actor.usr SET
1514 card = CURRVAL('actor.card_id_seq'),
1515 billing_address = CURRVAL('actor.usr_address_id_seq'),
1516 credit_forward_balance = '0',
1517 mailing_address = CURRVAL('actor.usr_address_id_seq')
1518 WHERE id=CURRVAL('actor.usr_id_seq');
1521 INSERT INTO actor.usr
1522 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1523 VALUES (2, 3, '99999343281', 7, 'Bradley', 'rebeccab1234',
1524 'Rebecca', 'Vanessa', NOW() + '3 years'::INTERVAL, NULL, NULL);
1526 INSERT INTO actor.usr_address
1527 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1528 VALUES ('USA', 'f', '66948', '5933 Changing Terms Pike', 'f',
1529 'KS', 'Jamestown', '', 'Cloud', CURRVAL('actor.usr_id_seq'));
1531 INSERT INTO actor.card (barcode, usr)
1532 VALUES ('99999343281', CURRVAL('actor.usr_id_seq'));
1534 UPDATE actor.usr SET
1535 card = CURRVAL('actor.card_id_seq'),
1536 billing_address = CURRVAL('actor.usr_address_id_seq'),
1537 credit_forward_balance = '0',
1538 mailing_address = CURRVAL('actor.usr_address_id_seq')
1539 WHERE id=CURRVAL('actor.usr_id_seq');
1542 INSERT INTO actor.usr
1543 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1544 VALUES (2, 1, '99999394534', 4, 'Hart', 'victorh1234',
1545 'Victor', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1547 INSERT INTO actor.usr_address
1548 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1549 VALUES ('USA', 't', '16833', '677 Breezy Agreement Mountain', 'f',
1550 'PA', 'Curwensville', '', 'Clearfield', CURRVAL('actor.usr_id_seq'));
1552 INSERT INTO actor.card (barcode, usr)
1553 VALUES ('99999394534', CURRVAL('actor.usr_id_seq'));
1555 UPDATE actor.usr SET
1556 card = CURRVAL('actor.card_id_seq'),
1557 billing_address = CURRVAL('actor.usr_address_id_seq'),
1558 credit_forward_balance = '0',
1559 mailing_address = CURRVAL('actor.usr_address_id_seq')
1560 WHERE id=CURRVAL('actor.usr_id_seq');
1563 INSERT INTO actor.usr
1564 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1565 VALUES (2, 1, '99999323404', 8, 'Riley', 'edwardr1234',
1566 'Edward', 'Lonnie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1568 INSERT INTO actor.usr_address
1569 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1570 VALUES ('USA', 'f', '84412', '5806 Metropolitan Problem Annex', 'f',
1571 'UT', 'Ogden', '', 'Weber', CURRVAL('actor.usr_id_seq'));
1573 INSERT INTO actor.card (barcode, usr)
1574 VALUES ('99999323404', CURRVAL('actor.usr_id_seq'));
1576 UPDATE actor.usr SET
1577 card = CURRVAL('actor.card_id_seq'),
1578 billing_address = CURRVAL('actor.usr_address_id_seq'),
1579 credit_forward_balance = '0',
1580 mailing_address = CURRVAL('actor.usr_address_id_seq')
1581 WHERE id=CURRVAL('actor.usr_id_seq');
1584 INSERT INTO actor.usr
1585 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1586 VALUES (2, 3, '99999375760', 5, 'Jordan', 'michellej1234',
1587 'Michelle', '', NOW() + '3 years'::INTERVAL, '1973-05-07', 'III');
1589 INSERT INTO actor.usr_address
1590 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1591 VALUES ('USA', 'f', '46970', '8951 Great Arrangement Mills', 'f',
1592 'IN', 'Peru', '', 'Miami', CURRVAL('actor.usr_id_seq'));
1594 INSERT INTO actor.card (barcode, usr)
1595 VALUES ('99999375760', CURRVAL('actor.usr_id_seq'));
1597 UPDATE actor.usr SET
1598 card = CURRVAL('actor.card_id_seq'),
1599 billing_address = CURRVAL('actor.usr_address_id_seq'),
1600 credit_forward_balance = '0',
1601 mailing_address = CURRVAL('actor.usr_address_id_seq')
1602 WHERE id=CURRVAL('actor.usr_id_seq');
1605 INSERT INTO actor.usr
1606 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1607 VALUES (2, 1, '99999315742', 7, 'Brown', 'maryb1234',
1608 'Mary', 'Jill', NOW() + '3 years'::INTERVAL, NULL, NULL);
1610 INSERT INTO actor.usr_address
1611 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1612 VALUES ('USA', 'f', '75663', '4845 Boat Course', 'f',
1613 'TX', 'Kilgore', '', 'Gregg', CURRVAL('actor.usr_id_seq'));
1615 INSERT INTO actor.card (barcode, usr)
1616 VALUES ('99999315742', CURRVAL('actor.usr_id_seq'));
1618 UPDATE actor.usr SET
1619 card = CURRVAL('actor.card_id_seq'),
1620 billing_address = CURRVAL('actor.usr_address_id_seq'),
1621 credit_forward_balance = '0',
1622 mailing_address = CURRVAL('actor.usr_address_id_seq')
1623 WHERE id=CURRVAL('actor.usr_id_seq');
1626 INSERT INTO actor.usr
1627 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1628 VALUES (2, 1, '99999322514', 7, 'Barber', 'shawnb1234',
1629 'Shawn', 'Thomas', NOW() + '3 years'::INTERVAL, '1988-10-21', 'II');
1631 INSERT INTO actor.usr_address
1632 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1633 VALUES ('USA', 't', '98464', '7111 Accurate Talk Canyon', 't',
1634 'WA', 'Tacoma', '', 'Pierce', CURRVAL('actor.usr_id_seq'));
1636 INSERT INTO actor.card (barcode, usr)
1637 VALUES ('99999322514', CURRVAL('actor.usr_id_seq'));
1639 UPDATE actor.usr SET
1640 card = CURRVAL('actor.card_id_seq'),
1641 billing_address = CURRVAL('actor.usr_address_id_seq'),
1642 credit_forward_balance = '0',
1643 mailing_address = CURRVAL('actor.usr_address_id_seq')
1644 WHERE id=CURRVAL('actor.usr_id_seq');
1647 INSERT INTO actor.usr
1648 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1649 VALUES (2, 1, '99999342144', 8, 'Harrison', 'williamh1234',
1650 'William', 'Phillip', NOW() + '3 years'::INTERVAL, '1990-04-09', 'II');
1652 INSERT INTO actor.usr_address
1653 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1654 VALUES ('USA', 'f', '79085', '9798 Marked West Fork', 't',
1655 'TX', 'Summerfield', '', 'Castro', CURRVAL('actor.usr_id_seq'));
1657 INSERT INTO actor.card (barcode, usr)
1658 VALUES ('99999342144', CURRVAL('actor.usr_id_seq'));
1660 UPDATE actor.usr SET
1661 card = CURRVAL('actor.card_id_seq'),
1662 billing_address = CURRVAL('actor.usr_address_id_seq'),
1663 credit_forward_balance = '0',
1664 mailing_address = CURRVAL('actor.usr_address_id_seq')
1665 WHERE id=CURRVAL('actor.usr_id_seq');
1668 INSERT INTO actor.usr
1669 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1670 VALUES (2, 1, '99999320546', 7, 'Porter', 'darlenep1234',
1671 'Darlene', 'Lisa', NOW() + '3 years'::INTERVAL, '1987-02-23', 'Jr');
1673 INSERT INTO actor.usr_address
1674 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1675 VALUES ('USA', 't', '24910', '3522 Channel Radial', 'f',
1676 'WV', 'Alderson', '', 'Monroe', CURRVAL('actor.usr_id_seq'));
1678 INSERT INTO actor.card (barcode, usr)
1679 VALUES ('99999320546', CURRVAL('actor.usr_id_seq'));
1681 UPDATE actor.usr SET
1682 card = CURRVAL('actor.card_id_seq'),
1683 billing_address = CURRVAL('actor.usr_address_id_seq'),
1684 credit_forward_balance = '0',
1685 mailing_address = CURRVAL('actor.usr_address_id_seq')
1686 WHERE id=CURRVAL('actor.usr_id_seq');
1689 INSERT INTO actor.usr
1690 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1691 VALUES (2, 3, '99999315474', 8, 'Lopez', 'joycel1234',
1692 'Joyce', 'Donna', NOW() + '3 years'::INTERVAL, '1980-06-28', 'Sr');
1694 INSERT INTO actor.usr_address
1695 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1696 VALUES ('USA', 't', '89101', '9734 Civilian Position Hollow', 'f',
1697 'NV', 'Las vegas', '', 'Clark', CURRVAL('actor.usr_id_seq'));
1699 INSERT INTO actor.card (barcode, usr)
1700 VALUES ('99999315474', CURRVAL('actor.usr_id_seq'));
1702 UPDATE actor.usr SET
1703 card = CURRVAL('actor.card_id_seq'),
1704 billing_address = CURRVAL('actor.usr_address_id_seq'),
1705 credit_forward_balance = '0',
1706 mailing_address = CURRVAL('actor.usr_address_id_seq')
1707 WHERE id=CURRVAL('actor.usr_id_seq');
1710 INSERT INTO actor.usr
1711 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1712 VALUES (2, 1, '99999371586', 9, 'Stevenson', 'larrys1234',
1713 'Larry', '', NOW() + '3 years'::INTERVAL, '1990-12-20', 'Sr');
1715 INSERT INTO actor.usr_address
1716 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1717 VALUES ('USA', 't', '46241', '5799 Constitutional Roof Groves', 'f',
1718 'IN', 'Indianapolis', '', 'Marion', CURRVAL('actor.usr_id_seq'));
1720 INSERT INTO actor.card (barcode, usr)
1721 VALUES ('99999371586', CURRVAL('actor.usr_id_seq'));
1723 UPDATE actor.usr SET
1724 card = CURRVAL('actor.card_id_seq'),
1725 billing_address = CURRVAL('actor.usr_address_id_seq'),
1726 credit_forward_balance = '0',
1727 mailing_address = CURRVAL('actor.usr_address_id_seq')
1728 WHERE id=CURRVAL('actor.usr_id_seq');
1731 INSERT INTO actor.usr
1732 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1733 VALUES (2, 1, '99999329832', 4, 'Kinney', 'nicholask1234',
1734 'Nicholas', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1736 INSERT INTO actor.usr_address
1737 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1738 VALUES ('USA', 't', '90606', '411 Preliminary Library Square', 't',
1739 'CA', 'Whittier', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
1741 INSERT INTO actor.card (barcode, usr)
1742 VALUES ('99999329832', CURRVAL('actor.usr_id_seq'));
1744 UPDATE actor.usr SET
1745 card = CURRVAL('actor.card_id_seq'),
1746 billing_address = CURRVAL('actor.usr_address_id_seq'),
1747 credit_forward_balance = '0',
1748 mailing_address = CURRVAL('actor.usr_address_id_seq')
1749 WHERE id=CURRVAL('actor.usr_id_seq');
1752 INSERT INTO actor.usr
1753 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1754 VALUES (2, 3, '99999342948', 5, 'Bernard', 'omarb1234',
1755 'Omar', 'David', NOW() + '3 years'::INTERVAL, '1981-08-19', 'Jr');
1757 INSERT INTO actor.usr_address
1758 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1759 VALUES ('USA', 'f', '41567', '2546 Marvellous Index Ways', 'f',
1760 'KY', 'Stone', '', 'Pike', CURRVAL('actor.usr_id_seq'));
1762 INSERT INTO actor.card (barcode, usr)
1763 VALUES ('99999342948', CURRVAL('actor.usr_id_seq'));
1765 UPDATE actor.usr SET
1766 card = CURRVAL('actor.card_id_seq'),
1767 billing_address = CURRVAL('actor.usr_address_id_seq'),
1768 credit_forward_balance = '0',
1769 mailing_address = CURRVAL('actor.usr_address_id_seq')
1770 WHERE id=CURRVAL('actor.usr_id_seq');
1773 INSERT INTO actor.usr
1774 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1775 VALUES (2, 3, '99999335091', 9, 'Brown', 'maryb1234',
1776 'Mary', 'Annie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1778 INSERT INTO actor.usr_address
1779 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1780 VALUES ('USA', 't', '07630', '48 Look Ridge', 'f',
1781 'NJ', 'Emerson', '', '', CURRVAL('actor.usr_id_seq'));
1783 INSERT INTO actor.card (barcode, usr)
1784 VALUES ('99999335091', CURRVAL('actor.usr_id_seq'));
1786 UPDATE actor.usr SET
1787 card = CURRVAL('actor.card_id_seq'),
1788 billing_address = CURRVAL('actor.usr_address_id_seq'),
1789 credit_forward_balance = '0',
1790 mailing_address = CURRVAL('actor.usr_address_id_seq')
1791 WHERE id=CURRVAL('actor.usr_id_seq');
1794 INSERT INTO actor.usr
1795 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1796 VALUES (2, 3, '99999303411', 8, 'Smith', 'sarahs1234',
1797 'Sarah', '', NOW() + '3 years'::INTERVAL, '1990-01-13', 'II');
1799 INSERT INTO actor.usr_address
1800 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1801 VALUES ('USA', 'f', '34972', '845 Relative Dress Mall', 'f',
1802 'FL', 'Okeechobee', '', 'Okeechobee', CURRVAL('actor.usr_id_seq'));
1804 INSERT INTO actor.card (barcode, usr)
1805 VALUES ('99999303411', CURRVAL('actor.usr_id_seq'));
1807 UPDATE actor.usr SET
1808 card = CURRVAL('actor.card_id_seq'),
1809 billing_address = CURRVAL('actor.usr_address_id_seq'),
1810 credit_forward_balance = '0',
1811 mailing_address = CURRVAL('actor.usr_address_id_seq')
1812 WHERE id=CURRVAL('actor.usr_id_seq');
1815 INSERT INTO actor.usr
1816 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1817 VALUES (2, 1, '99999327083', 8, 'Jones', 'coraj1234',
1818 'Cora', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1820 INSERT INTO actor.usr_address
1821 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1822 VALUES ('USA', 't', '65262', '9202 Tight Subject Highway', 'f',
1823 'MO', 'Kingdom city', '', '', CURRVAL('actor.usr_id_seq'));
1825 INSERT INTO actor.card (barcode, usr)
1826 VALUES ('99999327083', CURRVAL('actor.usr_id_seq'));
1828 UPDATE actor.usr SET
1829 card = CURRVAL('actor.card_id_seq'),
1830 billing_address = CURRVAL('actor.usr_address_id_seq'),
1831 credit_forward_balance = '0',
1832 mailing_address = CURRVAL('actor.usr_address_id_seq')
1833 WHERE id=CURRVAL('actor.usr_id_seq');
1836 INSERT INTO actor.usr
1837 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1838 VALUES (2, 3, '99999300523', 7, 'Little', 'shawnl1234',
1839 'Shawn', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, NULL);
1841 INSERT INTO actor.usr_address
1842 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1843 VALUES ('USA', 'f', '86343', '8169 Vast Passage Key', 'f',
1844 'AZ', 'Crown king', '', 'Yavapai', CURRVAL('actor.usr_id_seq'));
1846 INSERT INTO actor.card (barcode, usr)
1847 VALUES ('99999300523', CURRVAL('actor.usr_id_seq'));
1849 UPDATE actor.usr SET
1850 card = CURRVAL('actor.card_id_seq'),
1851 billing_address = CURRVAL('actor.usr_address_id_seq'),
1852 credit_forward_balance = '0',
1853 mailing_address = CURRVAL('actor.usr_address_id_seq')
1854 WHERE id=CURRVAL('actor.usr_id_seq');
1857 INSERT INTO actor.usr
1858 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1859 VALUES (2, 3, '99999328829', 6, 'Thurman', 'luannt1234',
1860 'Luann', 'Donna', NOW() + '3 years'::INTERVAL, NULL, NULL);
1862 INSERT INTO actor.usr_address
1863 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1864 VALUES ('USA', 't', '63463', '1967 Interesting Court Ford', 'f',
1865 'MO', 'Philadelphia', '', 'Marion', CURRVAL('actor.usr_id_seq'));
1867 INSERT INTO actor.card (barcode, usr)
1868 VALUES ('99999328829', CURRVAL('actor.usr_id_seq'));
1870 UPDATE actor.usr SET
1871 card = CURRVAL('actor.card_id_seq'),
1872 billing_address = CURRVAL('actor.usr_address_id_seq'),
1873 credit_forward_balance = '0',
1874 mailing_address = CURRVAL('actor.usr_address_id_seq')
1875 WHERE id=CURRVAL('actor.usr_id_seq');
1878 INSERT INTO actor.usr
1879 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1880 VALUES (2, 3, '99999394673', 6, 'Scott', 'patricias1234',
1881 'Patricia', 'Robin', NOW() + '3 years'::INTERVAL, NULL, NULL);
1883 INSERT INTO actor.usr_address
1884 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1885 VALUES ('USA', 't', '44241', '8955 Due Population Alley', 'f',
1886 'OH', 'Streetsboro', '', 'Portage', CURRVAL('actor.usr_id_seq'));
1888 INSERT INTO actor.card (barcode, usr)
1889 VALUES ('99999394673', CURRVAL('actor.usr_id_seq'));
1891 UPDATE actor.usr SET
1892 card = CURRVAL('actor.card_id_seq'),
1893 billing_address = CURRVAL('actor.usr_address_id_seq'),
1894 credit_forward_balance = '0',
1895 mailing_address = CURRVAL('actor.usr_address_id_seq')
1896 WHERE id=CURRVAL('actor.usr_id_seq');
1899 INSERT INTO actor.usr
1900 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1901 VALUES (2, 1, '99999355318', 5, 'Lamb', 'esperanzal1234',
1902 'Esperanza', 'Beth', NOW() + '3 years'::INTERVAL, '1995-06-13', 'III');
1904 INSERT INTO actor.usr_address
1905 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1906 VALUES ('USA', 'f', '05501', '9042 Just Show Turnpike', 'f',
1907 'MA', 'Andover', '', 'Essex', CURRVAL('actor.usr_id_seq'));
1909 INSERT INTO actor.card (barcode, usr)
1910 VALUES ('99999355318', CURRVAL('actor.usr_id_seq'));
1912 UPDATE actor.usr SET
1913 card = CURRVAL('actor.card_id_seq'),
1914 billing_address = CURRVAL('actor.usr_address_id_seq'),
1915 credit_forward_balance = '0',
1916 mailing_address = CURRVAL('actor.usr_address_id_seq')
1917 WHERE id=CURRVAL('actor.usr_id_seq');
1920 INSERT INTO actor.usr
1921 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1922 VALUES (2, 1, '99999377675', 8, 'Brown', 'wendib1234',
1923 'Wendi', 'Mary', NOW() + '3 years'::INTERVAL, NULL, NULL);
1925 INSERT INTO actor.usr_address
1926 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1927 VALUES ('USA', 'f', '37721', '7546 Rude Agreement Highway', 'f',
1928 'TN', 'Corryton', '', 'Knox', CURRVAL('actor.usr_id_seq'));
1930 INSERT INTO actor.card (barcode, usr)
1931 VALUES ('99999377675', CURRVAL('actor.usr_id_seq'));
1933 UPDATE actor.usr SET
1934 card = CURRVAL('actor.card_id_seq'),
1935 billing_address = CURRVAL('actor.usr_address_id_seq'),
1936 credit_forward_balance = '0',
1937 mailing_address = CURRVAL('actor.usr_address_id_seq')
1938 WHERE id=CURRVAL('actor.usr_id_seq');
1941 INSERT INTO actor.usr
1942 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1943 VALUES (2, 3, '99999363186', 5, 'Clarke', 'lawrencec1234',
1944 'Lawrence', 'Vern', NOW() + '3 years'::INTERVAL, NULL, NULL);
1946 INSERT INTO actor.usr_address
1947 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1948 VALUES ('USA', 't', '76234', '7903 Surprised Rule Loop', 'f',
1949 'TX', 'Decatur', '', 'Wise', CURRVAL('actor.usr_id_seq'));
1951 INSERT INTO actor.card (barcode, usr)
1952 VALUES ('99999363186', CURRVAL('actor.usr_id_seq'));
1954 UPDATE actor.usr SET
1955 card = CURRVAL('actor.card_id_seq'),
1956 billing_address = CURRVAL('actor.usr_address_id_seq'),
1957 credit_forward_balance = '0',
1958 mailing_address = CURRVAL('actor.usr_address_id_seq')
1959 WHERE id=CURRVAL('actor.usr_id_seq');
1962 INSERT INTO actor.usr
1963 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1964 VALUES (2, 1, '99999346314', 8, 'Clark', 'danielc1234',
1965 'Daniel', 'Ricky', NOW() + '3 years'::INTERVAL, NULL, NULL);
1967 INSERT INTO actor.usr_address
1968 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1969 VALUES ('USA', 't', '70706', '8604 Defensive Case Trace', 't',
1970 'LA', 'Denham springs', '', '', CURRVAL('actor.usr_id_seq'));
1972 INSERT INTO actor.card (barcode, usr)
1973 VALUES ('99999346314', CURRVAL('actor.usr_id_seq'));
1975 UPDATE actor.usr SET
1976 card = CURRVAL('actor.card_id_seq'),
1977 billing_address = CURRVAL('actor.usr_address_id_seq'),
1978 credit_forward_balance = '0',
1979 mailing_address = CURRVAL('actor.usr_address_id_seq')
1980 WHERE id=CURRVAL('actor.usr_id_seq');
1983 INSERT INTO actor.usr
1984 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1985 VALUES (2, 1, '99999353477', 6, 'Dennis', 'johnd1234',
1986 'John', 'Robert', NOW() + '3 years'::INTERVAL, '1975-03-04', NULL);
1988 INSERT INTO actor.usr_address
1989 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1990 VALUES ('USA', 't', '14480', '8712 Legislative Box Shore', 'f',
1991 'NY', 'Lakeville', '', 'Livingston', CURRVAL('actor.usr_id_seq'));
1993 INSERT INTO actor.card (barcode, usr)
1994 VALUES ('99999353477', CURRVAL('actor.usr_id_seq'));
1996 UPDATE actor.usr SET
1997 card = CURRVAL('actor.card_id_seq'),
1998 billing_address = CURRVAL('actor.usr_address_id_seq'),
1999 credit_forward_balance = '0',
2000 mailing_address = CURRVAL('actor.usr_address_id_seq')
2001 WHERE id=CURRVAL('actor.usr_id_seq');
2004 INSERT INTO actor.usr
2005 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2006 VALUES (2, 1, '99999312358', 4, 'Copeland', 'janc1234',
2007 'Jan', 'Lindsey', NOW() + '3 years'::INTERVAL, '1998-06-14', 'Jr');
2009 INSERT INTO actor.usr_address
2010 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2011 VALUES ('USA', 'f', '83204', '6713 River Bridge', 'f',
2012 'ID', 'Pocatello', '', 'Bannock', CURRVAL('actor.usr_id_seq'));
2014 INSERT INTO actor.card (barcode, usr)
2015 VALUES ('99999312358', CURRVAL('actor.usr_id_seq'));
2017 UPDATE actor.usr SET
2018 card = CURRVAL('actor.card_id_seq'),
2019 billing_address = CURRVAL('actor.usr_address_id_seq'),
2020 credit_forward_balance = '0',
2021 mailing_address = CURRVAL('actor.usr_address_id_seq')
2022 WHERE id=CURRVAL('actor.usr_id_seq');
2025 INSERT INTO actor.usr
2026 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2027 VALUES (2, 1, '99999360839', 8, 'Brooks', 'pennyb1234',
2028 'Penny', 'Martha', NOW() + '3 years'::INTERVAL, '1980-03-13', 'II');
2030 INSERT INTO actor.usr_address
2031 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2032 VALUES ('USA', 't', '79120', '8208 Death Ramp', 'f',
2033 'TX', 'Amarillo', '', 'Potter', CURRVAL('actor.usr_id_seq'));
2035 INSERT INTO actor.card (barcode, usr)
2036 VALUES ('99999360839', CURRVAL('actor.usr_id_seq'));
2038 UPDATE actor.usr SET
2039 card = CURRVAL('actor.card_id_seq'),
2040 billing_address = CURRVAL('actor.usr_address_id_seq'),
2041 credit_forward_balance = '0',
2042 mailing_address = CURRVAL('actor.usr_address_id_seq')
2043 WHERE id=CURRVAL('actor.usr_id_seq');
2046 INSERT INTO actor.usr
2047 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2048 VALUES (2, 3, '99999342446', 8, 'Johnson', 'jeannej1234',
2049 'Jeanne', '', NOW() + '3 years'::INTERVAL, '1980-02-03', NULL);
2051 INSERT INTO actor.usr_address
2052 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2053 VALUES ('USA', 't', '85036', '9634 Tough Division Junction', 't',
2054 'AZ', 'Phoenix', '', '', CURRVAL('actor.usr_id_seq'));
2056 INSERT INTO actor.card (barcode, usr)
2057 VALUES ('99999342446', CURRVAL('actor.usr_id_seq'));
2059 UPDATE actor.usr SET
2060 card = CURRVAL('actor.card_id_seq'),
2061 billing_address = CURRVAL('actor.usr_address_id_seq'),
2062 credit_forward_balance = '0',
2063 mailing_address = CURRVAL('actor.usr_address_id_seq')
2064 WHERE id=CURRVAL('actor.usr_id_seq');
2067 INSERT INTO actor.usr
2068 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2069 VALUES (2, 1, '99999358416', 4, 'Sanford', 'elizabeths1234',
2070 'Elizabeth', 'Vanessa', NOW() + '3 years'::INTERVAL, NULL, '');
2072 INSERT INTO actor.usr_address
2073 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2074 VALUES ('USA', 't', '98357', '6767 Application Course', 'f',
2075 'WA', 'Neah bay', '', 'Clallam', CURRVAL('actor.usr_id_seq'));
2077 INSERT INTO actor.card (barcode, usr)
2078 VALUES ('99999358416', CURRVAL('actor.usr_id_seq'));
2080 UPDATE actor.usr SET
2081 card = CURRVAL('actor.card_id_seq'),
2082 billing_address = CURRVAL('actor.usr_address_id_seq'),
2083 credit_forward_balance = '0',
2084 mailing_address = CURRVAL('actor.usr_address_id_seq')
2085 WHERE id=CURRVAL('actor.usr_id_seq');
2088 INSERT INTO actor.usr
2089 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2090 VALUES (2, 3, '99999361389', 9, 'Ramirez', 'alanr1234',
2091 'Alan', 'Claude', NOW() + '3 years'::INTERVAL, NULL, '');
2093 INSERT INTO actor.usr_address
2094 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2095 VALUES ('USA', 't', '76060', '9964 Skinny Party Orchard', 't',
2096 'TX', 'Kennedale', '', 'Tarrant', CURRVAL('actor.usr_id_seq'));
2098 INSERT INTO actor.card (barcode, usr)
2099 VALUES ('99999361389', CURRVAL('actor.usr_id_seq'));
2101 UPDATE actor.usr SET
2102 card = CURRVAL('actor.card_id_seq'),
2103 billing_address = CURRVAL('actor.usr_address_id_seq'),
2104 credit_forward_balance = '0',
2105 mailing_address = CURRVAL('actor.usr_address_id_seq')
2106 WHERE id=CURRVAL('actor.usr_id_seq');