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', 't',
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', 't',
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', 't',
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', 't',
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', 't',
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', 't',
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');
157 INSERT INTO actor.usr
158 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
159 VALUES (2, 1, '99999373998', 9, 'Hill', 'roberth1234',
160 'Robert', 'Louis', NOW() + '3 years'::INTERVAL, NULL, 'III');
162 INSERT INTO actor.usr_address
163 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
164 VALUES ('USA', 't', '18960', '759 Doubtful Government Extension', 'f',
165 'PA', 'Sellersville', '', '', CURRVAL('actor.usr_id_seq'));
167 INSERT INTO actor.card (barcode, usr)
168 VALUES ('99999373998', CURRVAL('actor.usr_id_seq'));
171 card = CURRVAL('actor.card_id_seq'),
172 billing_address = CURRVAL('actor.usr_address_id_seq'),
173 credit_forward_balance = '0',
174 mailing_address = CURRVAL('actor.usr_address_id_seq')
175 WHERE id=CURRVAL('actor.usr_id_seq');
179 INSERT INTO actor.usr
180 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
181 VALUES (2, 3, '99999376669', 7, 'Lopez', 'edwardl1234',
182 'Edward', 'Robert', NOW() + '3 years'::INTERVAL, NULL, 'II');
184 INSERT INTO actor.usr_address
185 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
186 VALUES ('USA', 't', '29593', '5431 Japanese Work Rapid', 'f',
187 'SC', 'Society hill', '', 'Darlington', CURRVAL('actor.usr_id_seq'));
189 INSERT INTO actor.card (barcode, usr)
190 VALUES ('99999376669', CURRVAL('actor.usr_id_seq'));
193 card = CURRVAL('actor.card_id_seq'),
194 billing_address = CURRVAL('actor.usr_address_id_seq'),
195 credit_forward_balance = '0',
196 mailing_address = CURRVAL('actor.usr_address_id_seq')
197 WHERE id=CURRVAL('actor.usr_id_seq');
200 INSERT INTO actor.usr
201 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
202 VALUES (2, 3, '99999361076', 8, 'Bell', 'andrewb1234',
203 'Andrew', 'Alberto', NOW() + '3 years'::INTERVAL, NULL, 'II');
205 INSERT INTO actor.usr_address
206 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
207 VALUES ('USA', 't', '61936', '5253 Agricultural Exhibition Stravenue', 't',
208 'IL', 'La place', '', 'Piatt', CURRVAL('actor.usr_id_seq'));
210 INSERT INTO actor.card (barcode, usr)
211 VALUES ('99999361076', CURRVAL('actor.usr_id_seq'));
214 card = CURRVAL('actor.card_id_seq'),
215 billing_address = CURRVAL('actor.usr_address_id_seq'),
216 credit_forward_balance = '0',
217 mailing_address = CURRVAL('actor.usr_address_id_seq')
218 WHERE id=CURRVAL('actor.usr_id_seq');
221 INSERT INTO actor.usr
222 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
223 VALUES (2, 1, '99999376988', 9, 'Mitchell', 'jenniferm1234',
224 'Jennifer', 'Dorothy', NOW() + '3 years'::INTERVAL, NULL, NULL);
226 INSERT INTO actor.usr_address
227 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
228 VALUES ('USA', 't', '61822', '8649 Raspy Goal Terrace', 't',
229 'IL', 'Champaign', '', 'Champaign', CURRVAL('actor.usr_id_seq'));
231 INSERT INTO actor.card (barcode, usr)
232 VALUES ('99999376988', CURRVAL('actor.usr_id_seq'));
235 card = CURRVAL('actor.card_id_seq'),
236 billing_address = CURRVAL('actor.usr_address_id_seq'),
237 credit_forward_balance = '0',
238 mailing_address = CURRVAL('actor.usr_address_id_seq')
239 WHERE id=CURRVAL('actor.usr_id_seq');
242 INSERT INTO actor.usr
243 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
244 VALUES (2, 3, '99999390791', 7, 'Ortiz', 'richardo1234',
245 'Richard', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
247 INSERT INTO actor.usr_address
248 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
249 VALUES ('USA', 'f', '23885', '2433 Uncomfortable Nature Greens', 't',
250 'VA', 'Sutherland', '', 'Dinwiddie', CURRVAL('actor.usr_id_seq'));
252 INSERT INTO actor.card (barcode, usr)
253 VALUES ('99999390791', CURRVAL('actor.usr_id_seq'));
256 card = CURRVAL('actor.card_id_seq'),
257 billing_address = CURRVAL('actor.usr_address_id_seq'),
258 credit_forward_balance = '0',
259 mailing_address = CURRVAL('actor.usr_address_id_seq')
260 WHERE id=CURRVAL('actor.usr_id_seq');
263 INSERT INTO actor.usr
264 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
265 VALUES (2, 1, '99999378730', 6, 'Wade', 'robertw1234',
266 'Robert', 'Coy', NOW() + '3 years'::INTERVAL, NULL, NULL);
268 INSERT INTO actor.usr_address
269 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
270 VALUES ('USA', 't', '55796', '3241 Communist Boat Boulevard', 't',
271 'MN', 'Winton', '', 'Saint louis', CURRVAL('actor.usr_id_seq'));
273 INSERT INTO actor.card (barcode, usr)
274 VALUES ('99999378730', CURRVAL('actor.usr_id_seq'));
277 card = CURRVAL('actor.card_id_seq'),
278 billing_address = CURRVAL('actor.usr_address_id_seq'),
279 credit_forward_balance = '0',
280 mailing_address = CURRVAL('actor.usr_address_id_seq')
281 WHERE id=CURRVAL('actor.usr_id_seq');
284 INSERT INTO actor.usr
285 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
286 VALUES (2, 3, '99999360638', 5, 'Wise', 'janetw1234',
287 'Janet', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
289 INSERT INTO actor.usr_address
290 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
291 VALUES ('USA', 'f', '64126', '6773 Government Hill', 't',
292 'MO', 'Kansas city', '', '', CURRVAL('actor.usr_id_seq'));
294 INSERT INTO actor.card (barcode, usr)
295 VALUES ('99999360638', CURRVAL('actor.usr_id_seq'));
298 card = CURRVAL('actor.card_id_seq'),
299 billing_address = CURRVAL('actor.usr_address_id_seq'),
300 credit_forward_balance = '0',
301 mailing_address = CURRVAL('actor.usr_address_id_seq')
302 WHERE id=CURRVAL('actor.usr_id_seq');
305 INSERT INTO actor.usr
306 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
307 VALUES (2, 1, '99999350419', 4, 'Torres', 'donaldt1234',
308 'Donald', 'Arnold', NOW() + '3 years'::INTERVAL, '1974-06-26', 'II');
310 INSERT INTO actor.usr_address
311 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
312 VALUES ('USA', 't', '40847', '7194 Gorgeous Edge Dale', 't',
313 'KY', 'Kenvir', '', 'Harlan', CURRVAL('actor.usr_id_seq'));
315 INSERT INTO actor.card (barcode, usr)
316 VALUES ('99999350419', CURRVAL('actor.usr_id_seq'));
319 card = CURRVAL('actor.card_id_seq'),
320 billing_address = CURRVAL('actor.usr_address_id_seq'),
321 credit_forward_balance = '0',
322 mailing_address = CURRVAL('actor.usr_address_id_seq')
323 WHERE id=CURRVAL('actor.usr_id_seq');
326 INSERT INTO actor.usr
327 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
328 VALUES (2, 1, '99999354736', 4, 'Miller', 'jeffm1234',
329 'Jeff', 'James', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
331 INSERT INTO actor.usr_address
332 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
333 VALUES ('USA', 't', '80920', '9674 Filthy Firm Meadows', 't',
334 'CO', 'Colorado springs', '', '', CURRVAL('actor.usr_id_seq'));
336 INSERT INTO actor.card (barcode, usr)
337 VALUES ('99999354736', CURRVAL('actor.usr_id_seq'));
340 card = CURRVAL('actor.card_id_seq'),
341 billing_address = CURRVAL('actor.usr_address_id_seq'),
342 credit_forward_balance = '0',
343 mailing_address = CURRVAL('actor.usr_address_id_seq')
344 WHERE id=CURRVAL('actor.usr_id_seq');
347 INSERT INTO actor.usr
348 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
349 VALUES (2, 1, '99999329662', 9, 'Estes', 'leonarde1234',
350 'Leonard', '', NOW() + '3 years'::INTERVAL, '1994-05-07', 'III');
352 INSERT INTO actor.usr_address
353 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
354 VALUES ('USA', 'f', '20724', '6145 Superior Dress Prairie', 't',
355 'MD', 'Laurel', '', '', CURRVAL('actor.usr_id_seq'));
357 INSERT INTO actor.card (barcode, usr)
358 VALUES ('99999329662', CURRVAL('actor.usr_id_seq'));
361 card = CURRVAL('actor.card_id_seq'),
362 billing_address = CURRVAL('actor.usr_address_id_seq'),
363 credit_forward_balance = '0',
364 mailing_address = CURRVAL('actor.usr_address_id_seq')
365 WHERE id=CURRVAL('actor.usr_id_seq');
368 INSERT INTO actor.usr
369 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
370 VALUES (2, 1, '99999397601', 8, 'Dunn', 'brittneyd1234',
371 'Brittney', 'Pamela', NOW() + '3 years'::INTERVAL, NULL, NULL);
373 INSERT INTO actor.usr_address
374 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
375 VALUES ('USA', 't', '73838', '9753 Confident Limit Shoal', 't',
376 'OK', 'Chester', '', '', CURRVAL('actor.usr_id_seq'));
378 INSERT INTO actor.card (barcode, usr)
379 VALUES ('99999397601', CURRVAL('actor.usr_id_seq'));
382 card = CURRVAL('actor.card_id_seq'),
383 billing_address = CURRVAL('actor.usr_address_id_seq'),
384 credit_forward_balance = '0',
385 mailing_address = CURRVAL('actor.usr_address_id_seq')
386 WHERE id=CURRVAL('actor.usr_id_seq');
389 INSERT INTO actor.usr
390 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
391 VALUES (2, 3, '99999377594', 4, 'Wiggins', 'jeanw1234',
392 'Jean', 'Verna', NOW() + '3 years'::INTERVAL, NULL, NULL);
394 INSERT INTO actor.usr_address
395 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
396 VALUES ('USA', 'f', '23018', '6115 Thoughtful Country Ridge', 't',
397 'VA', 'Bena', '', '', CURRVAL('actor.usr_id_seq'));
399 INSERT INTO actor.card (barcode, usr)
400 VALUES ('99999377594', CURRVAL('actor.usr_id_seq'));
403 card = CURRVAL('actor.card_id_seq'),
404 billing_address = CURRVAL('actor.usr_address_id_seq'),
405 credit_forward_balance = '0',
406 mailing_address = CURRVAL('actor.usr_address_id_seq')
407 WHERE id=CURRVAL('actor.usr_id_seq');
410 INSERT INTO actor.usr
411 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
412 VALUES (2, 1, '99999371252', 9, 'Thomas', 'lelat1234',
413 'Lela', 'Sarah', NOW() + '3 years'::INTERVAL, '1968-04-11', 'Sr');
415 INSERT INTO actor.usr_address
416 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
417 VALUES ('USA', 't', '60609', '4223 Spotty Chemical Stravenue', 't',
418 'IL', 'Chicago', '', 'Cook', CURRVAL('actor.usr_id_seq'));
420 INSERT INTO actor.card (barcode, usr)
421 VALUES ('99999371252', CURRVAL('actor.usr_id_seq'));
424 card = CURRVAL('actor.card_id_seq'),
425 billing_address = CURRVAL('actor.usr_address_id_seq'),
426 credit_forward_balance = '0',
427 mailing_address = CURRVAL('actor.usr_address_id_seq')
428 WHERE id=CURRVAL('actor.usr_id_seq');
431 INSERT INTO actor.usr
432 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
433 VALUES (2, 3, '99999398023', 8, 'Phillips', 'noahp1234',
434 'Noah', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, 'III');
436 INSERT INTO actor.usr_address
437 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
438 VALUES ('USA', 't', '33593', '2005 Inner Entry Harbor', 't',
439 'FL', 'Trilby', '', '', CURRVAL('actor.usr_id_seq'));
441 INSERT INTO actor.card (barcode, usr)
442 VALUES ('99999398023', CURRVAL('actor.usr_id_seq'));
445 card = CURRVAL('actor.card_id_seq'),
446 billing_address = CURRVAL('actor.usr_address_id_seq'),
447 credit_forward_balance = '0',
448 mailing_address = CURRVAL('actor.usr_address_id_seq')
449 WHERE id=CURRVAL('actor.usr_id_seq');
452 INSERT INTO actor.usr
453 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
454 VALUES (2, 3, '99999324566', 5, 'Mitchell', 'carolynm1234',
455 'Carolyn', 'Patrica', NOW() + '3 years'::INTERVAL, '1981-09-03', 'III');
457 INSERT INTO actor.usr_address
458 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
459 VALUES ('USA', 't', '50652', '5259 Film Crossing', 't',
460 'IA', 'Lincoln', '', 'Tama', CURRVAL('actor.usr_id_seq'));
462 INSERT INTO actor.card (barcode, usr)
463 VALUES ('99999324566', CURRVAL('actor.usr_id_seq'));
466 card = CURRVAL('actor.card_id_seq'),
467 billing_address = CURRVAL('actor.usr_address_id_seq'),
468 credit_forward_balance = '0',
469 mailing_address = CURRVAL('actor.usr_address_id_seq')
470 WHERE id=CURRVAL('actor.usr_id_seq');
473 INSERT INTO actor.usr
474 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
475 VALUES (2, 3, '99999379221', 5, 'Wells', 'kristenw1234',
476 'Kristen', 'Vivian', NOW() + '3 years'::INTERVAL, NULL, NULL);
478 INSERT INTO actor.usr_address
479 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
480 VALUES ('USA', 't', '12450', '2302 Prisoner Way', 't',
481 'NY', 'Lanesville', '', 'Greene', CURRVAL('actor.usr_id_seq'));
483 INSERT INTO actor.card (barcode, usr)
484 VALUES ('99999379221', CURRVAL('actor.usr_id_seq'));
487 card = CURRVAL('actor.card_id_seq'),
488 billing_address = CURRVAL('actor.usr_address_id_seq'),
489 credit_forward_balance = '0',
490 mailing_address = CURRVAL('actor.usr_address_id_seq')
491 WHERE id=CURRVAL('actor.usr_id_seq');
494 INSERT INTO actor.usr
495 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
496 VALUES (2, 1, '99999373350', 8, 'Lindsey', 'noahl1234',
497 'Noah', 'Keith', NOW() + '3 years'::INTERVAL, NULL, NULL);
499 INSERT INTO actor.usr_address
500 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
501 VALUES ('USA', 't', '50108', '7583 Low Surface Overpass', 't',
502 'IA', 'Grand river', '', 'Decatur', CURRVAL('actor.usr_id_seq'));
504 INSERT INTO actor.card (barcode, usr)
505 VALUES ('99999373350', CURRVAL('actor.usr_id_seq'));
508 card = CURRVAL('actor.card_id_seq'),
509 billing_address = CURRVAL('actor.usr_address_id_seq'),
510 credit_forward_balance = '0',
511 mailing_address = CURRVAL('actor.usr_address_id_seq')
512 WHERE id=CURRVAL('actor.usr_id_seq');
515 INSERT INTO actor.usr
516 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
517 VALUES (2, 3, '99999340920', 4, 'Williams', 'berthaw1234',
518 'Bertha', 'Katherine', NOW() + '3 years'::INTERVAL, NULL, NULL);
520 INSERT INTO actor.usr_address
521 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
522 VALUES ('USA', 't', '20646', '3301 Acid Canyon', 't',
523 'MD', 'La plata', '', 'Charles', CURRVAL('actor.usr_id_seq'));
525 INSERT INTO actor.card (barcode, usr)
526 VALUES ('99999340920', CURRVAL('actor.usr_id_seq'));
529 card = CURRVAL('actor.card_id_seq'),
530 billing_address = CURRVAL('actor.usr_address_id_seq'),
531 credit_forward_balance = '0',
532 mailing_address = CURRVAL('actor.usr_address_id_seq')
533 WHERE id=CURRVAL('actor.usr_id_seq');
536 INSERT INTO actor.usr
537 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
538 VALUES (2, 1, '99999398482', 7, 'Rodriguez', 'jamesr1234',
539 'James', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
541 INSERT INTO actor.usr_address
542 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
543 VALUES ('USA', 'f', '95066', '9801 Working-class Flower Meadow', 't',
544 'CA', 'Scotts valley', '', '', CURRVAL('actor.usr_id_seq'));
546 INSERT INTO actor.card (barcode, usr)
547 VALUES ('99999398482', CURRVAL('actor.usr_id_seq'));
550 card = CURRVAL('actor.card_id_seq'),
551 billing_address = CURRVAL('actor.usr_address_id_seq'),
552 credit_forward_balance = '0',
553 mailing_address = CURRVAL('actor.usr_address_id_seq')
554 WHERE id=CURRVAL('actor.usr_id_seq');
557 INSERT INTO actor.usr
558 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
559 VALUES (2, 3, '99999394378', 5, 'Byrd', 'matthewb1234',
560 'Matthew', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL);
562 INSERT INTO actor.usr_address
563 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
564 VALUES ('USA', 't', '43015', '9029 Note Court', 't',
565 'OH', 'Delaware', '', 'Delaware', CURRVAL('actor.usr_id_seq'));
567 INSERT INTO actor.card (barcode, usr)
568 VALUES ('99999394378', CURRVAL('actor.usr_id_seq'));
571 card = CURRVAL('actor.card_id_seq'),
572 billing_address = CURRVAL('actor.usr_address_id_seq'),
573 credit_forward_balance = '0',
574 mailing_address = CURRVAL('actor.usr_address_id_seq')
575 WHERE id=CURRVAL('actor.usr_id_seq');
578 INSERT INTO actor.usr
579 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
580 VALUES (2, 1, '99999382659', 4, 'Kelley', 'sandrak1234',
581 'Sandra', 'Pearlie', NOW() + '3 years'::INTERVAL, '1977-01-18', 'Sr');
583 INSERT INTO actor.usr_address
584 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
585 VALUES ('USA', 'f', '56568', '4246 Fun Post Street', 't',
586 'MN', 'Nielsville', '', 'Polk', CURRVAL('actor.usr_id_seq'));
588 INSERT INTO actor.card (barcode, usr)
589 VALUES ('99999382659', CURRVAL('actor.usr_id_seq'));
592 card = CURRVAL('actor.card_id_seq'),
593 billing_address = CURRVAL('actor.usr_address_id_seq'),
594 credit_forward_balance = '0',
595 mailing_address = CURRVAL('actor.usr_address_id_seq')
596 WHERE id=CURRVAL('actor.usr_id_seq');
599 INSERT INTO actor.usr
600 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
601 VALUES (2, 1, '99999387130', 7, 'Wilson', 'bethw1234',
602 'Beth', 'Michelle', NOW() + '3 years'::INTERVAL, NULL, NULL);
604 INSERT INTO actor.usr_address
605 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
606 VALUES ('USA', 'f', '15341', '7780 Horrible Winner Island', 't',
607 'PA', 'Holbrook', '', 'Greene', CURRVAL('actor.usr_id_seq'));
609 INSERT INTO actor.card (barcode, usr)
610 VALUES ('99999387130', CURRVAL('actor.usr_id_seq'));
613 card = CURRVAL('actor.card_id_seq'),
614 billing_address = CURRVAL('actor.usr_address_id_seq'),
615 credit_forward_balance = '0',
616 mailing_address = CURRVAL('actor.usr_address_id_seq')
617 WHERE id=CURRVAL('actor.usr_id_seq');
620 INSERT INTO actor.usr
621 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
622 VALUES (2, 3, '99999310765', 8, 'Daniels', 'randyd1234',
623 'Randy', 'Lawrence', NOW() + '3 years'::INTERVAL, NULL, NULL);
625 INSERT INTO actor.usr_address
626 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
627 VALUES ('USA', 'f', '29680', '4697 Subsequent Culture Pass', 't',
628 'SC', 'Simpsonville', '', 'Greenville', CURRVAL('actor.usr_id_seq'));
630 INSERT INTO actor.card (barcode, usr)
631 VALUES ('99999310765', CURRVAL('actor.usr_id_seq'));
634 card = CURRVAL('actor.card_id_seq'),
635 billing_address = CURRVAL('actor.usr_address_id_seq'),
636 credit_forward_balance = '0',
637 mailing_address = CURRVAL('actor.usr_address_id_seq')
638 WHERE id=CURRVAL('actor.usr_id_seq');
641 INSERT INTO actor.usr
642 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
643 VALUES (2, 1, '99999335545', 9, 'Simpson', 'steves1234',
644 'Steve', 'Raymond', NOW() + '3 years'::INTERVAL, NULL, NULL);
646 INSERT INTO actor.usr_address
647 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
648 VALUES ('USA', 'f', '88118', '2400 Communication Mount', 't',
649 'NM', 'Floyd', '', '', CURRVAL('actor.usr_id_seq'));
651 INSERT INTO actor.card (barcode, usr)
652 VALUES ('99999335545', CURRVAL('actor.usr_id_seq'));
655 card = CURRVAL('actor.card_id_seq'),
656 billing_address = CURRVAL('actor.usr_address_id_seq'),
657 credit_forward_balance = '0',
658 mailing_address = CURRVAL('actor.usr_address_id_seq')
659 WHERE id=CURRVAL('actor.usr_id_seq');
662 INSERT INTO actor.usr
663 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
664 VALUES (2, 3, '99999360529', 5, 'Hoskins', 'jimh1234',
665 'Jim', 'Michael', NOW() + '3 years'::INTERVAL, '1983-08-02', 'III');
667 INSERT INTO actor.usr_address
668 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
669 VALUES ('USA', 'f', '15015', '7815 Principal Element Center', 't',
670 'PA', 'Bradfordwoods', '', 'Allegheny', CURRVAL('actor.usr_id_seq'));
672 INSERT INTO actor.card (barcode, usr)
673 VALUES ('99999360529', CURRVAL('actor.usr_id_seq'));
676 card = CURRVAL('actor.card_id_seq'),
677 billing_address = CURRVAL('actor.usr_address_id_seq'),
678 credit_forward_balance = '0',
679 mailing_address = CURRVAL('actor.usr_address_id_seq')
680 WHERE id=CURRVAL('actor.usr_id_seq');
683 INSERT INTO actor.usr
684 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
685 VALUES (2, 3, '99999357038', 5, 'May', 'michaelm1234',
686 'Michael', '', NOW() + '3 years'::INTERVAL, '1988-03-06', 'II');
688 INSERT INTO actor.usr_address
689 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
690 VALUES ('USA', 'f', '20064', '4827 Shoulder Center', 't',
691 'DC', 'Washington', '', 'District of columbia', CURRVAL('actor.usr_id_seq'));
693 INSERT INTO actor.card (barcode, usr)
694 VALUES ('99999357038', CURRVAL('actor.usr_id_seq'));
697 card = CURRVAL('actor.card_id_seq'),
698 billing_address = CURRVAL('actor.usr_address_id_seq'),
699 credit_forward_balance = '0',
700 mailing_address = CURRVAL('actor.usr_address_id_seq')
701 WHERE id=CURRVAL('actor.usr_id_seq');
704 INSERT INTO actor.usr
705 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
706 VALUES (2, 3, '99999371688', 8, 'Ellison', 'done1234',
707 'Don', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL);
709 INSERT INTO actor.usr_address
710 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
711 VALUES ('USA', 'f', '20643', '1298 Golden Speed Hills', 't',
712 'MD', 'Ironsides', '', '', CURRVAL('actor.usr_id_seq'));
714 INSERT INTO actor.card (barcode, usr)
715 VALUES ('99999371688', CURRVAL('actor.usr_id_seq'));
718 card = CURRVAL('actor.card_id_seq'),
719 billing_address = CURRVAL('actor.usr_address_id_seq'),
720 credit_forward_balance = '0',
721 mailing_address = CURRVAL('actor.usr_address_id_seq')
722 WHERE id=CURRVAL('actor.usr_id_seq');
725 INSERT INTO actor.usr
726 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
727 VALUES (2, 1, '99999312757', 4, 'Hughes', 'josephh1234',
728 'Joseph', 'Bryant', NOW() + '3 years'::INTERVAL, NULL, NULL);
730 INSERT INTO actor.usr_address
731 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
732 VALUES ('USA', 't', '48613', '9736 Profitable Wine Spring', 't',
733 'MI', 'Bentley', '', 'Bay', CURRVAL('actor.usr_id_seq'));
735 INSERT INTO actor.card (barcode, usr)
736 VALUES ('99999312757', CURRVAL('actor.usr_id_seq'));
739 card = CURRVAL('actor.card_id_seq'),
740 billing_address = CURRVAL('actor.usr_address_id_seq'),
741 credit_forward_balance = '0',
742 mailing_address = CURRVAL('actor.usr_address_id_seq')
743 WHERE id=CURRVAL('actor.usr_id_seq');
746 INSERT INTO actor.usr
747 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
748 VALUES (2, 1, '99999399015', 8, 'Turner', 'cristinat1234',
749 'Cristina', 'Karen', NOW() + '3 years'::INTERVAL, NULL, NULL);
751 INSERT INTO actor.usr_address
752 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
753 VALUES ('USA', 't', '45844', '6445 Turkish Strike Shoal', 't',
754 'OH', 'Fort jennings', '', 'Putnam', CURRVAL('actor.usr_id_seq'));
756 INSERT INTO actor.card (barcode, usr)
757 VALUES ('99999399015', CURRVAL('actor.usr_id_seq'));
760 card = CURRVAL('actor.card_id_seq'),
761 billing_address = CURRVAL('actor.usr_address_id_seq'),
762 credit_forward_balance = '0',
763 mailing_address = CURRVAL('actor.usr_address_id_seq')
764 WHERE id=CURRVAL('actor.usr_id_seq');
767 INSERT INTO actor.usr
768 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
769 VALUES (2, 3, '99999313973', 4, 'Langley', 'victorl1234',
770 'Victor', 'James', NOW() + '3 years'::INTERVAL, NULL, NULL);
772 INSERT INTO actor.usr_address
773 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
774 VALUES ('USA', 'f', '94576', '1082 Capacity Hill', 't',
775 'CA', 'Deer park', '', 'Napa', CURRVAL('actor.usr_id_seq'));
777 INSERT INTO actor.card (barcode, usr)
778 VALUES ('99999313973', CURRVAL('actor.usr_id_seq'));
781 card = CURRVAL('actor.card_id_seq'),
782 billing_address = CURRVAL('actor.usr_address_id_seq'),
783 credit_forward_balance = '0',
784 mailing_address = CURRVAL('actor.usr_address_id_seq')
785 WHERE id=CURRVAL('actor.usr_id_seq');
788 INSERT INTO actor.usr
789 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
790 VALUES (2, 1, '99999311521', 6, 'Fields', 'davidf1234',
791 'David', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
793 INSERT INTO actor.usr_address
794 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
795 VALUES ('USA', 'f', '73939', '8788 Religious Writer Isle', 't',
796 'OK', 'Goodwell', '', 'Texas', CURRVAL('actor.usr_id_seq'));
798 INSERT INTO actor.card (barcode, usr)
799 VALUES ('99999311521', CURRVAL('actor.usr_id_seq'));
802 card = CURRVAL('actor.card_id_seq'),
803 billing_address = CURRVAL('actor.usr_address_id_seq'),
804 credit_forward_balance = '0',
805 mailing_address = CURRVAL('actor.usr_address_id_seq')
806 WHERE id=CURRVAL('actor.usr_id_seq');
809 INSERT INTO actor.usr
810 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
811 VALUES (2, 1, '99999388816', 7, 'Hoffman', 'gregoryh1234',
812 'Gregory', 'Thomas', NOW() + '3 years'::INTERVAL, '1999-11-13', 'II');
814 INSERT INTO actor.usr_address
815 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
816 VALUES ('USA', 't', '47163', '4971 Assembly Parkways', 't',
817 'IN', 'Otisco', '', 'Clark', CURRVAL('actor.usr_id_seq'));
819 INSERT INTO actor.card (barcode, usr)
820 VALUES ('99999388816', CURRVAL('actor.usr_id_seq'));
823 card = CURRVAL('actor.card_id_seq'),
824 billing_address = CURRVAL('actor.usr_address_id_seq'),
825 credit_forward_balance = '0',
826 mailing_address = CURRVAL('actor.usr_address_id_seq')
827 WHERE id=CURRVAL('actor.usr_id_seq');
830 INSERT INTO actor.usr
831 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
832 VALUES (2, 3, '99999345160', 8, 'Gonzalez', 'natalieg1234',
833 'Natalie', 'Joan', NOW() + '3 years'::INTERVAL, NULL, NULL);
835 INSERT INTO actor.usr_address
836 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
837 VALUES ('USA', 't', '17120', '8835 Amazing Reduction Course', 't',
838 'PA', 'Harrisburg', '', 'Dauphin', CURRVAL('actor.usr_id_seq'));
840 INSERT INTO actor.card (barcode, usr)
841 VALUES ('99999345160', CURRVAL('actor.usr_id_seq'));
844 card = CURRVAL('actor.card_id_seq'),
845 billing_address = CURRVAL('actor.usr_address_id_seq'),
846 credit_forward_balance = '0',
847 mailing_address = CURRVAL('actor.usr_address_id_seq')
848 WHERE id=CURRVAL('actor.usr_id_seq');
851 INSERT INTO actor.usr
852 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
853 VALUES (2, 3, '99999328966', 9, 'Rucker', 'drewr1234',
854 'Drew', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
856 INSERT INTO actor.usr_address
857 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
858 VALUES ('USA', 'f', '92253', '5158 Redundant Reality Creek', 't',
859 'CA', 'La quinta', '', 'Riverside', CURRVAL('actor.usr_id_seq'));
861 INSERT INTO actor.card (barcode, usr)
862 VALUES ('99999328966', CURRVAL('actor.usr_id_seq'));
865 card = CURRVAL('actor.card_id_seq'),
866 billing_address = CURRVAL('actor.usr_address_id_seq'),
867 credit_forward_balance = '0',
868 mailing_address = CURRVAL('actor.usr_address_id_seq')
869 WHERE id=CURRVAL('actor.usr_id_seq');
872 INSERT INTO actor.usr
873 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
874 VALUES (2, 3, '99999394635', 9, 'Mitchell', 'kimberlym1234',
875 'Kimberly', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
877 INSERT INTO actor.usr_address
878 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
879 VALUES ('USA', 'f', '85375', '9724 Land Corner', 't',
880 'AZ', 'Sun city west', '', '', CURRVAL('actor.usr_id_seq'));
882 INSERT INTO actor.card (barcode, usr)
883 VALUES ('99999394635', CURRVAL('actor.usr_id_seq'));
886 card = CURRVAL('actor.card_id_seq'),
887 billing_address = CURRVAL('actor.usr_address_id_seq'),
888 credit_forward_balance = '0',
889 mailing_address = CURRVAL('actor.usr_address_id_seq')
890 WHERE id=CURRVAL('actor.usr_id_seq');
893 INSERT INTO actor.usr
894 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
895 VALUES (2, 1, '99999333308', 7, 'Murray', 'heatherm1234',
896 'Heather', 'Margaret', NOW() + '3 years'::INTERVAL, NULL, NULL);
898 INSERT INTO actor.usr_address
899 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
900 VALUES ('USA', 'f', '51239', '5555 Project Bypass', 't',
901 'IA', 'Hull', '', 'Sioux', CURRVAL('actor.usr_id_seq'));
903 INSERT INTO actor.card (barcode, usr)
904 VALUES ('99999333308', CURRVAL('actor.usr_id_seq'));
907 card = CURRVAL('actor.card_id_seq'),
908 billing_address = CURRVAL('actor.usr_address_id_seq'),
909 credit_forward_balance = '0',
910 mailing_address = CURRVAL('actor.usr_address_id_seq')
911 WHERE id=CURRVAL('actor.usr_id_seq');
914 INSERT INTO actor.usr
915 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
916 VALUES (2, 1, '99999316647', 7, 'Sosa', 'robertas1234',
917 'Roberta', 'Norma', NOW() + '3 years'::INTERVAL, NULL, NULL);
919 INSERT INTO actor.usr_address
920 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
921 VALUES ('USA', 'f', '94010', '4571 Jealous Comparison Wells', 't',
922 'CA', 'Burlingame', '', '', CURRVAL('actor.usr_id_seq'));
924 INSERT INTO actor.card (barcode, usr)
925 VALUES ('99999316647', CURRVAL('actor.usr_id_seq'));
928 card = CURRVAL('actor.card_id_seq'),
929 billing_address = CURRVAL('actor.usr_address_id_seq'),
930 credit_forward_balance = '0',
931 mailing_address = CURRVAL('actor.usr_address_id_seq')
932 WHERE id=CURRVAL('actor.usr_id_seq');
935 INSERT INTO actor.usr
936 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
937 VALUES (2, 1, '99999389066', 4, 'Ramos', 'annetter1234',
938 'Annette', 'Angela', NOW() + '3 years'::INTERVAL, '1967-11-04', 'II');
940 INSERT INTO actor.usr_address
941 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
942 VALUES ('USA', 'f', '29621', '9196 Old Future Fort', 't',
943 'SC', 'Anderson', '', 'Anderson', CURRVAL('actor.usr_id_seq'));
945 INSERT INTO actor.card (barcode, usr)
946 VALUES ('99999389066', CURRVAL('actor.usr_id_seq'));
949 card = CURRVAL('actor.card_id_seq'),
950 billing_address = CURRVAL('actor.usr_address_id_seq'),
951 credit_forward_balance = '0',
952 mailing_address = CURRVAL('actor.usr_address_id_seq')
953 WHERE id=CURRVAL('actor.usr_id_seq');
956 INSERT INTO actor.usr
957 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
958 VALUES (2, 1, '99999380162', 8, 'Jackson', 'paulj1234',
959 'Paul', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
961 INSERT INTO actor.usr_address
962 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
963 VALUES ('USA', 't', '77651', '9869 Convention Pine', 't',
964 'TX', 'Port neches', '', 'Jefferson', CURRVAL('actor.usr_id_seq'));
966 INSERT INTO actor.card (barcode, usr)
967 VALUES ('99999380162', CURRVAL('actor.usr_id_seq'));
970 card = CURRVAL('actor.card_id_seq'),
971 billing_address = CURRVAL('actor.usr_address_id_seq'),
972 credit_forward_balance = '0',
973 mailing_address = CURRVAL('actor.usr_address_id_seq')
974 WHERE id=CURRVAL('actor.usr_id_seq');
977 INSERT INTO actor.usr
978 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
979 VALUES (2, 1, '99999318240', 7, 'Graham', 'johng1234',
980 'John', 'Charles', NOW() + '3 years'::INTERVAL, NULL, NULL);
982 INSERT INTO actor.usr_address
983 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
984 VALUES ('USA', 't', '03216', '3676 Sweet Campaign Courts', 't',
985 'NH', 'Andover', '', 'Merrimack', CURRVAL('actor.usr_id_seq'));
987 INSERT INTO actor.card (barcode, usr)
988 VALUES ('99999318240', CURRVAL('actor.usr_id_seq'));
991 card = CURRVAL('actor.card_id_seq'),
992 billing_address = CURRVAL('actor.usr_address_id_seq'),
993 credit_forward_balance = '0',
994 mailing_address = CURRVAL('actor.usr_address_id_seq')
995 WHERE id=CURRVAL('actor.usr_id_seq');
998 INSERT INTO actor.usr
999 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1000 VALUES (2, 3, '99999347267', 7, 'Michael', 'adamm1234',
1001 'Adam', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL);
1003 INSERT INTO actor.usr_address
1004 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1005 VALUES ('USA', 't', '68113', '7244 Brief Tree Crescent', 't',
1006 'NE', 'Offutt a f b', '', 'Sarpy', CURRVAL('actor.usr_id_seq'));
1008 INSERT INTO actor.card (barcode, usr)
1009 VALUES ('99999347267', CURRVAL('actor.usr_id_seq'));
1011 UPDATE actor.usr SET
1012 card = CURRVAL('actor.card_id_seq'),
1013 billing_address = CURRVAL('actor.usr_address_id_seq'),
1014 credit_forward_balance = '0',
1015 mailing_address = CURRVAL('actor.usr_address_id_seq')
1016 WHERE id=CURRVAL('actor.usr_id_seq');
1019 INSERT INTO actor.usr
1020 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1021 VALUES (2, 3, '99999344618', 7, 'Thomas', 'helent1234',
1022 'Helen', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1024 INSERT INTO actor.usr_address
1025 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1026 VALUES ('USA', 'f', '43534', '5066 Disabled Drink Ford', 't',
1027 'OH', 'Mc clure', '', 'Henry', CURRVAL('actor.usr_id_seq'));
1029 INSERT INTO actor.card (barcode, usr)
1030 VALUES ('99999344618', CURRVAL('actor.usr_id_seq'));
1032 UPDATE actor.usr SET
1033 card = CURRVAL('actor.card_id_seq'),
1034 billing_address = CURRVAL('actor.usr_address_id_seq'),
1035 credit_forward_balance = '0',
1036 mailing_address = CURRVAL('actor.usr_address_id_seq')
1037 WHERE id=CURRVAL('actor.usr_id_seq');
1040 INSERT INTO actor.usr
1041 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1042 VALUES (2, 1, '99999301966', 7, 'Rivas', 'meghanr1234',
1043 'Meghan', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1045 INSERT INTO actor.usr_address
1046 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1047 VALUES ('USA', 't', '48328', '1604 Other Factor Harbor', 't',
1048 'MI', 'Waterford', '', 'Oakland', CURRVAL('actor.usr_id_seq'));
1050 INSERT INTO actor.card (barcode, usr)
1051 VALUES ('99999301966', CURRVAL('actor.usr_id_seq'));
1053 UPDATE actor.usr SET
1054 card = CURRVAL('actor.card_id_seq'),
1055 billing_address = CURRVAL('actor.usr_address_id_seq'),
1056 credit_forward_balance = '0',
1057 mailing_address = CURRVAL('actor.usr_address_id_seq')
1058 WHERE id=CURRVAL('actor.usr_id_seq');
1061 INSERT INTO actor.usr
1062 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1063 VALUES (2, 3, '99999306663', 5, 'Hurst', 'williamh1234',
1064 'William', 'Ian', NOW() + '3 years'::INTERVAL, NULL, NULL);
1066 INSERT INTO actor.usr_address
1067 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1068 VALUES ('USA', 't', '76937', '7986 Line Grove', 't',
1069 'TX', 'Eola', '', '', CURRVAL('actor.usr_id_seq'));
1071 INSERT INTO actor.card (barcode, usr)
1072 VALUES ('99999306663', CURRVAL('actor.usr_id_seq'));
1074 UPDATE actor.usr SET
1075 card = CURRVAL('actor.card_id_seq'),
1076 billing_address = CURRVAL('actor.usr_address_id_seq'),
1077 credit_forward_balance = '0',
1078 mailing_address = CURRVAL('actor.usr_address_id_seq')
1079 WHERE id=CURRVAL('actor.usr_id_seq');
1082 INSERT INTO actor.usr
1083 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1084 VALUES (2, 3, '99999329410', 8, 'Bridges', 'kimberlyb1234',
1085 'Kimberly', 'Anna', NOW() + '3 years'::INTERVAL, NULL, NULL);
1087 INSERT INTO actor.usr_address
1088 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1089 VALUES ('USA', 't', '21047', '9992 Show Village', 't',
1090 'MD', 'Fallston', '', 'Harford', CURRVAL('actor.usr_id_seq'));
1092 INSERT INTO actor.card (barcode, usr)
1093 VALUES ('99999329410', CURRVAL('actor.usr_id_seq'));
1095 UPDATE actor.usr SET
1096 card = CURRVAL('actor.card_id_seq'),
1097 billing_address = CURRVAL('actor.usr_address_id_seq'),
1098 credit_forward_balance = '0',
1099 mailing_address = CURRVAL('actor.usr_address_id_seq')
1100 WHERE id=CURRVAL('actor.usr_id_seq');
1103 INSERT INTO actor.usr
1104 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1105 VALUES (2, 3, '99999396820', 6, 'Stewart', 'beatrices1234',
1106 'Beatrice', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL);
1108 INSERT INTO actor.usr_address
1109 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1110 VALUES ('USA', 't', '64123', '7373 Social Fact Roads', 't',
1111 'MO', 'Kansas city', '', 'Jackson', CURRVAL('actor.usr_id_seq'));
1113 INSERT INTO actor.card (barcode, usr)
1114 VALUES ('99999396820', CURRVAL('actor.usr_id_seq'));
1116 UPDATE actor.usr SET
1117 card = CURRVAL('actor.card_id_seq'),
1118 billing_address = CURRVAL('actor.usr_address_id_seq'),
1119 credit_forward_balance = '0',
1120 mailing_address = CURRVAL('actor.usr_address_id_seq')
1121 WHERE id=CURRVAL('actor.usr_id_seq');
1124 INSERT INTO actor.usr
1125 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1126 VALUES (2, 3, '99999398998', 7, 'Welsh', 'alejandraw1234',
1127 'Alejandra', 'Christine', NOW() + '3 years'::INTERVAL, '1973-11-18', 'III');
1129 INSERT INTO actor.usr_address
1130 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1131 VALUES ('USA', 't', '91615', '4270 Deafening Speed Stream', 't',
1132 'CA', 'North hollywood', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
1134 INSERT INTO actor.card (barcode, usr)
1135 VALUES ('99999398998', CURRVAL('actor.usr_id_seq'));
1137 UPDATE actor.usr SET
1138 card = CURRVAL('actor.card_id_seq'),
1139 billing_address = CURRVAL('actor.usr_address_id_seq'),
1140 credit_forward_balance = '0',
1141 mailing_address = CURRVAL('actor.usr_address_id_seq')
1142 WHERE id=CURRVAL('actor.usr_id_seq');
1145 INSERT INTO actor.usr
1146 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1147 VALUES (2, 3, '99999308688', 9, 'Osborne', 'leonao1234',
1148 'Leona', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1150 INSERT INTO actor.usr_address
1151 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1152 VALUES ('USA', 'f', '65261', '1368 Defiant Visit Drive', 't',
1153 'MO', 'Keytesville', '', 'Chariton', CURRVAL('actor.usr_id_seq'));
1155 INSERT INTO actor.card (barcode, usr)
1156 VALUES ('99999308688', CURRVAL('actor.usr_id_seq'));
1158 UPDATE actor.usr SET
1159 card = CURRVAL('actor.card_id_seq'),
1160 billing_address = CURRVAL('actor.usr_address_id_seq'),
1161 credit_forward_balance = '0',
1162 mailing_address = CURRVAL('actor.usr_address_id_seq')
1163 WHERE id=CURRVAL('actor.usr_id_seq');
1166 INSERT INTO actor.usr
1167 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1168 VALUES (2, 3, '99999321465', 4, 'Sinclair', 'luellas1234',
1169 'Luella', 'Carole', NOW() + '3 years'::INTERVAL, '1993-10-15', 'II');
1171 INSERT INTO actor.usr_address
1172 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1173 VALUES ('USA', 't', '45314', '3011 Thoughtful Law Terrace', 't',
1174 'OH', 'Cedarville', '', 'Greene', CURRVAL('actor.usr_id_seq'));
1176 INSERT INTO actor.card (barcode, usr)
1177 VALUES ('99999321465', CURRVAL('actor.usr_id_seq'));
1179 UPDATE actor.usr SET
1180 card = CURRVAL('actor.card_id_seq'),
1181 billing_address = CURRVAL('actor.usr_address_id_seq'),
1182 credit_forward_balance = '0',
1183 mailing_address = CURRVAL('actor.usr_address_id_seq')
1184 WHERE id=CURRVAL('actor.usr_id_seq');
1187 INSERT INTO actor.usr
1188 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1189 VALUES (2, 3, '99999399294', 5, 'Jones', 'joej1234',
1190 'Joe', 'Wayne', NOW() + '3 years'::INTERVAL, NULL, NULL);
1192 INSERT INTO actor.usr_address
1193 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1194 VALUES ('USA', 't', '12167', '1641 Jolly Period Bend', 't',
1195 'NY', 'Stamford', '', 'Delaware', CURRVAL('actor.usr_id_seq'));
1197 INSERT INTO actor.card (barcode, usr)
1198 VALUES ('99999399294', CURRVAL('actor.usr_id_seq'));
1200 UPDATE actor.usr SET
1201 card = CURRVAL('actor.card_id_seq'),
1202 billing_address = CURRVAL('actor.usr_address_id_seq'),
1203 credit_forward_balance = '0',
1204 mailing_address = CURRVAL('actor.usr_address_id_seq')
1205 WHERE id=CURRVAL('actor.usr_id_seq');
1208 INSERT INTO actor.usr
1209 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1210 VALUES (2, 3, '99999355645', 6, 'Duncan', 'willied1234',
1211 'Willie', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1213 INSERT INTO actor.usr_address
1214 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1215 VALUES ('USA', 'f', '34682', '9904 Australian Cash Squares', 't',
1216 'FL', 'Palm harbor', '', 'Pinellas', CURRVAL('actor.usr_id_seq'));
1218 INSERT INTO actor.card (barcode, usr)
1219 VALUES ('99999355645', CURRVAL('actor.usr_id_seq'));
1221 UPDATE actor.usr SET
1222 card = CURRVAL('actor.card_id_seq'),
1223 billing_address = CURRVAL('actor.usr_address_id_seq'),
1224 credit_forward_balance = '0',
1225 mailing_address = CURRVAL('actor.usr_address_id_seq')
1226 WHERE id=CURRVAL('actor.usr_id_seq');
1229 INSERT INTO actor.usr
1230 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1231 VALUES (2, 3, '99999359616', 6, 'Carney', 'andreac1234',
1232 'Andrea', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1234 INSERT INTO actor.usr_address
1235 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1236 VALUES ('USA', 't', '23442', '9706 Jealous Alternative Fort', 't',
1237 'VA', 'Temperanceville', '', 'Accomack', CURRVAL('actor.usr_id_seq'));
1239 INSERT INTO actor.card (barcode, usr)
1240 VALUES ('99999359616', CURRVAL('actor.usr_id_seq'));
1242 UPDATE actor.usr SET
1243 card = CURRVAL('actor.card_id_seq'),
1244 billing_address = CURRVAL('actor.usr_address_id_seq'),
1245 credit_forward_balance = '0',
1246 mailing_address = CURRVAL('actor.usr_address_id_seq')
1247 WHERE id=CURRVAL('actor.usr_id_seq');
1250 INSERT INTO actor.usr
1251 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1252 VALUES (2, 1, '99999359143', 9, 'Hunt', 'howardh1234',
1253 'Howard', 'Ralph', NOW() + '3 years'::INTERVAL, '1971-05-09', 'Jr');
1255 INSERT INTO actor.usr_address
1256 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1257 VALUES ('USA', 'f', '49337', '1182 Radical Letter Square', 't',
1258 'MI', 'Newaygo', '', 'Newaygo', CURRVAL('actor.usr_id_seq'));
1260 INSERT INTO actor.card (barcode, usr)
1261 VALUES ('99999359143', CURRVAL('actor.usr_id_seq'));
1263 UPDATE actor.usr SET
1264 card = CURRVAL('actor.card_id_seq'),
1265 billing_address = CURRVAL('actor.usr_address_id_seq'),
1266 credit_forward_balance = '0',
1267 mailing_address = CURRVAL('actor.usr_address_id_seq')
1268 WHERE id=CURRVAL('actor.usr_id_seq');
1271 INSERT INTO actor.usr
1272 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1273 VALUES (2, 3, '99999389009', 6, 'Martin', 'eddiem1234',
1274 'Eddie', 'Anthony', NOW() + '3 years'::INTERVAL, NULL, NULL);
1276 INSERT INTO actor.usr_address
1277 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1278 VALUES ('USA', 'f', '95031', '1938 Fundamental Distribution Lane', 't',
1279 'CA', 'Los gatos', '', '', CURRVAL('actor.usr_id_seq'));
1281 INSERT INTO actor.card (barcode, usr)
1282 VALUES ('99999389009', CURRVAL('actor.usr_id_seq'));
1284 UPDATE actor.usr SET
1285 card = CURRVAL('actor.card_id_seq'),
1286 billing_address = CURRVAL('actor.usr_address_id_seq'),
1287 credit_forward_balance = '0',
1288 mailing_address = CURRVAL('actor.usr_address_id_seq')
1289 WHERE id=CURRVAL('actor.usr_id_seq');
1292 INSERT INTO actor.usr
1293 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1294 VALUES (2, 1, '99999327461', 9, 'Barry', 'paulb1234',
1295 'Paul', 'Richard', NOW() + '3 years'::INTERVAL, NULL, NULL);
1297 INSERT INTO actor.usr_address
1298 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1299 VALUES ('USA', 't', '40583', '9317 Testy Soil Place', 't',
1300 'KY', 'Lexington', '', 'Fayette', CURRVAL('actor.usr_id_seq'));
1302 INSERT INTO actor.card (barcode, usr)
1303 VALUES ('99999327461', CURRVAL('actor.usr_id_seq'));
1305 UPDATE actor.usr SET
1306 card = CURRVAL('actor.card_id_seq'),
1307 billing_address = CURRVAL('actor.usr_address_id_seq'),
1308 credit_forward_balance = '0',
1309 mailing_address = CURRVAL('actor.usr_address_id_seq')
1310 WHERE id=CURRVAL('actor.usr_id_seq');
1313 INSERT INTO actor.usr
1314 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1315 VALUES (2, 1, '99999319193', 7, 'Wright', 'dennisw1234',
1316 'Dennis', 'Jimmie', NOW() + '3 years'::INTERVAL, '1992-09-05', 'II');
1318 INSERT INTO actor.usr_address
1319 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1320 VALUES ('USA', 'f', '24925', '7338 Drab Development Underpass', 't',
1321 'WV', 'Caldwell', '', 'Greenbrier', CURRVAL('actor.usr_id_seq'));
1323 INSERT INTO actor.card (barcode, usr)
1324 VALUES ('99999319193', CURRVAL('actor.usr_id_seq'));
1326 UPDATE actor.usr SET
1327 card = CURRVAL('actor.card_id_seq'),
1328 billing_address = CURRVAL('actor.usr_address_id_seq'),
1329 credit_forward_balance = '0',
1330 mailing_address = CURRVAL('actor.usr_address_id_seq')
1331 WHERE id=CURRVAL('actor.usr_id_seq');
1334 INSERT INTO actor.usr
1335 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1336 VALUES (2, 1, '99999378520', 5, 'Saunders', 'rubens1234',
1337 'Ruben', 'Eric', NOW() + '3 years'::INTERVAL, NULL, NULL);
1339 INSERT INTO actor.usr_address
1340 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1341 VALUES ('USA', 'f', '32648', '2941 Conservation Race Haven', 't',
1342 'FL', 'Horseshoe beach', '', '', CURRVAL('actor.usr_id_seq'));
1344 INSERT INTO actor.card (barcode, usr)
1345 VALUES ('99999378520', CURRVAL('actor.usr_id_seq'));
1347 UPDATE actor.usr SET
1348 card = CURRVAL('actor.card_id_seq'),
1349 billing_address = CURRVAL('actor.usr_address_id_seq'),
1350 credit_forward_balance = '0',
1351 mailing_address = CURRVAL('actor.usr_address_id_seq')
1352 WHERE id=CURRVAL('actor.usr_id_seq');
1355 INSERT INTO actor.usr
1356 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1357 VALUES (2, 3, '99999366196', 7, 'Lane', 'jenniferl1234',
1358 'Jennifer', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1360 INSERT INTO actor.usr_address
1361 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1362 VALUES ('USA', 't', '12456', '5547 Knee Underpass', 't',
1363 'NY', 'Mount marion', '', 'Ulster', CURRVAL('actor.usr_id_seq'));
1365 INSERT INTO actor.card (barcode, usr)
1366 VALUES ('99999366196', CURRVAL('actor.usr_id_seq'));
1368 UPDATE actor.usr SET
1369 card = CURRVAL('actor.card_id_seq'),
1370 billing_address = CURRVAL('actor.usr_address_id_seq'),
1371 credit_forward_balance = '0',
1372 mailing_address = CURRVAL('actor.usr_address_id_seq')
1373 WHERE id=CURRVAL('actor.usr_id_seq');
1376 INSERT INTO actor.usr
1377 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1378 VALUES (2, 1, '99999324371', 5, 'Madden', 'jom1234',
1379 'Jo', 'Mae', NOW() + '3 years'::INTERVAL, NULL, NULL);
1381 INSERT INTO actor.usr_address
1382 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1383 VALUES ('USA', 'f', '19612', '3125 League Brook', 't',
1384 'PA', 'Reading', '', 'Berks', CURRVAL('actor.usr_id_seq'));
1386 INSERT INTO actor.card (barcode, usr)
1387 VALUES ('99999324371', CURRVAL('actor.usr_id_seq'));
1389 UPDATE actor.usr SET
1390 card = CURRVAL('actor.card_id_seq'),
1391 billing_address = CURRVAL('actor.usr_address_id_seq'),
1392 credit_forward_balance = '0',
1393 mailing_address = CURRVAL('actor.usr_address_id_seq')
1394 WHERE id=CURRVAL('actor.usr_id_seq');
1397 INSERT INTO actor.usr
1398 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1399 VALUES (2, 3, '99999316280', 8, 'Harding', 'naomih1234',
1400 'Naomi', 'Julie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1402 INSERT INTO actor.usr_address
1403 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1404 VALUES ('USA', 't', '93021', '6693 Thin Entry Lake', 't',
1405 'CA', 'Moorpark', '', 'Ventura', CURRVAL('actor.usr_id_seq'));
1407 INSERT INTO actor.card (barcode, usr)
1408 VALUES ('99999316280', CURRVAL('actor.usr_id_seq'));
1410 UPDATE actor.usr SET
1411 card = CURRVAL('actor.card_id_seq'),
1412 billing_address = CURRVAL('actor.usr_address_id_seq'),
1413 credit_forward_balance = '0',
1414 mailing_address = CURRVAL('actor.usr_address_id_seq')
1415 WHERE id=CURRVAL('actor.usr_id_seq');
1418 INSERT INTO actor.usr
1419 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1420 VALUES (2, 3, '99999388575', 5, 'Davis', 'blaked1234',
1421 'Blake', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL);
1423 INSERT INTO actor.usr_address
1424 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1425 VALUES ('USA', 't', '13856', '8634 Need Bridge', 't',
1426 'NY', 'Walton', '', '', CURRVAL('actor.usr_id_seq'));
1428 INSERT INTO actor.card (barcode, usr)
1429 VALUES ('99999388575', CURRVAL('actor.usr_id_seq'));
1431 UPDATE actor.usr SET
1432 card = CURRVAL('actor.card_id_seq'),
1433 billing_address = CURRVAL('actor.usr_address_id_seq'),
1434 credit_forward_balance = '0',
1435 mailing_address = CURRVAL('actor.usr_address_id_seq')
1436 WHERE id=CURRVAL('actor.usr_id_seq');
1439 INSERT INTO actor.usr
1440 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1441 VALUES (2, 3, '99999336610', 4, 'Barnes', 'normab1234',
1442 'Norma', 'Gail', NOW() + '3 years'::INTERVAL, NOW() + '3 years'::INTERVAL, '');
1444 INSERT INTO actor.usr_address
1445 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1446 VALUES ('USA', 't', '23107', '218 Region River', 't',
1447 'VA', 'Maryus', '', 'Gloucester', CURRVAL('actor.usr_id_seq'));
1449 INSERT INTO actor.card (barcode, usr)
1450 VALUES ('99999336610', CURRVAL('actor.usr_id_seq'));
1452 UPDATE actor.usr SET
1453 card = CURRVAL('actor.card_id_seq'),
1454 billing_address = CURRVAL('actor.usr_address_id_seq'),
1455 credit_forward_balance = '0',
1456 mailing_address = CURRVAL('actor.usr_address_id_seq')
1457 WHERE id=CURRVAL('actor.usr_id_seq');
1460 INSERT INTO actor.usr
1461 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1462 VALUES (2, 3, '99999376864', 4, 'Anderson', 'leona1234',
1463 'Leon', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1465 INSERT INTO actor.usr_address
1466 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1467 VALUES ('USA', 'f', '27315', '9834 Standard Stravenue', 't',
1468 'NC', 'Providence', '', '', CURRVAL('actor.usr_id_seq'));
1470 INSERT INTO actor.card (barcode, usr)
1471 VALUES ('99999376864', CURRVAL('actor.usr_id_seq'));
1473 UPDATE actor.usr SET
1474 card = CURRVAL('actor.card_id_seq'),
1475 billing_address = CURRVAL('actor.usr_address_id_seq'),
1476 credit_forward_balance = '0',
1477 mailing_address = CURRVAL('actor.usr_address_id_seq')
1478 WHERE id=CURRVAL('actor.usr_id_seq');
1481 INSERT INTO actor.usr
1482 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1483 VALUES (2, 1, '99999391951', 7, 'Gillespie', 'mistyg1234',
1484 'Misty', 'Margaret', NOW() + '3 years'::INTERVAL, '1993-10-19', 'III');
1486 INSERT INTO actor.usr_address
1487 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1488 VALUES ('USA', 't', '47273', '4151 Severe Look Fort', 't',
1489 'IN', 'Scipio', '', 'Jennings', CURRVAL('actor.usr_id_seq'));
1491 INSERT INTO actor.card (barcode, usr)
1492 VALUES ('99999391951', CURRVAL('actor.usr_id_seq'));
1494 UPDATE actor.usr SET
1495 card = CURRVAL('actor.card_id_seq'),
1496 billing_address = CURRVAL('actor.usr_address_id_seq'),
1497 credit_forward_balance = '0',
1498 mailing_address = CURRVAL('actor.usr_address_id_seq')
1499 WHERE id=CURRVAL('actor.usr_id_seq');
1502 INSERT INTO actor.usr
1503 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1504 VALUES (2, 3, '99999368950', 7, 'Santos', 'esthers1234',
1505 'Esther', 'Mary', NOW() + '3 years'::INTERVAL, '1961-12-17', 'Sr');
1507 INSERT INTO actor.usr_address
1508 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1509 VALUES ('USA', 'f', '06468', '2774 Melted Stone Islands', 't',
1510 'CT', 'Monroe', '', 'Fairfield', CURRVAL('actor.usr_id_seq'));
1512 INSERT INTO actor.card (barcode, usr)
1513 VALUES ('99999368950', CURRVAL('actor.usr_id_seq'));
1515 UPDATE actor.usr SET
1516 card = CURRVAL('actor.card_id_seq'),
1517 billing_address = CURRVAL('actor.usr_address_id_seq'),
1518 credit_forward_balance = '0',
1519 mailing_address = CURRVAL('actor.usr_address_id_seq')
1520 WHERE id=CURRVAL('actor.usr_id_seq');
1523 INSERT INTO actor.usr
1524 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1525 VALUES (2, 3, '99999343281', 7, 'Bradley', 'rebeccab1234',
1526 'Rebecca', 'Vanessa', NOW() + '3 years'::INTERVAL, NULL, NULL);
1528 INSERT INTO actor.usr_address
1529 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1530 VALUES ('USA', 'f', '66948', '5933 Changing Terms Pike', 't',
1531 'KS', 'Jamestown', '', 'Cloud', CURRVAL('actor.usr_id_seq'));
1533 INSERT INTO actor.card (barcode, usr)
1534 VALUES ('99999343281', CURRVAL('actor.usr_id_seq'));
1536 UPDATE actor.usr SET
1537 card = CURRVAL('actor.card_id_seq'),
1538 billing_address = CURRVAL('actor.usr_address_id_seq'),
1539 credit_forward_balance = '0',
1540 mailing_address = CURRVAL('actor.usr_address_id_seq')
1541 WHERE id=CURRVAL('actor.usr_id_seq');
1544 INSERT INTO actor.usr
1545 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1546 VALUES (2, 1, '99999394534', 4, 'Hart', 'victorh1234',
1547 'Victor', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1549 INSERT INTO actor.usr_address
1550 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1551 VALUES ('USA', 't', '16833', '677 Breezy Agreement Mountain', 't',
1552 'PA', 'Curwensville', '', 'Clearfield', CURRVAL('actor.usr_id_seq'));
1554 INSERT INTO actor.card (barcode, usr)
1555 VALUES ('99999394534', CURRVAL('actor.usr_id_seq'));
1557 UPDATE actor.usr SET
1558 card = CURRVAL('actor.card_id_seq'),
1559 billing_address = CURRVAL('actor.usr_address_id_seq'),
1560 credit_forward_balance = '0',
1561 mailing_address = CURRVAL('actor.usr_address_id_seq')
1562 WHERE id=CURRVAL('actor.usr_id_seq');
1565 INSERT INTO actor.usr
1566 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1567 VALUES (2, 1, '99999323404', 8, 'Riley', 'edwardr1234',
1568 'Edward', 'Lonnie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1570 INSERT INTO actor.usr_address
1571 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1572 VALUES ('USA', 'f', '84412', '5806 Metropolitan Problem Annex', 't',
1573 'UT', 'Ogden', '', 'Weber', CURRVAL('actor.usr_id_seq'));
1575 INSERT INTO actor.card (barcode, usr)
1576 VALUES ('99999323404', CURRVAL('actor.usr_id_seq'));
1578 UPDATE actor.usr SET
1579 card = CURRVAL('actor.card_id_seq'),
1580 billing_address = CURRVAL('actor.usr_address_id_seq'),
1581 credit_forward_balance = '0',
1582 mailing_address = CURRVAL('actor.usr_address_id_seq')
1583 WHERE id=CURRVAL('actor.usr_id_seq');
1586 INSERT INTO actor.usr
1587 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1588 VALUES (2, 3, '99999375760', 5, 'Jordan', 'michellej1234',
1589 'Michelle', '', NOW() + '3 years'::INTERVAL, '1973-05-07', 'III');
1591 INSERT INTO actor.usr_address
1592 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1593 VALUES ('USA', 'f', '46970', '8951 Great Arrangement Mills', 't',
1594 'IN', 'Peru', '', 'Miami', CURRVAL('actor.usr_id_seq'));
1596 INSERT INTO actor.card (barcode, usr)
1597 VALUES ('99999375760', CURRVAL('actor.usr_id_seq'));
1599 UPDATE actor.usr SET
1600 card = CURRVAL('actor.card_id_seq'),
1601 billing_address = CURRVAL('actor.usr_address_id_seq'),
1602 credit_forward_balance = '0',
1603 mailing_address = CURRVAL('actor.usr_address_id_seq')
1604 WHERE id=CURRVAL('actor.usr_id_seq');
1607 INSERT INTO actor.usr
1608 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1609 VALUES (2, 1, '99999315742', 7, 'Brown', 'maryb1234',
1610 'Mary', 'Jill', NOW() + '3 years'::INTERVAL, NULL, NULL);
1612 INSERT INTO actor.usr_address
1613 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1614 VALUES ('USA', 'f', '75663', '4845 Boat Course', 't',
1615 'TX', 'Kilgore', '', 'Gregg', CURRVAL('actor.usr_id_seq'));
1617 INSERT INTO actor.card (barcode, usr)
1618 VALUES ('99999315742', CURRVAL('actor.usr_id_seq'));
1620 UPDATE actor.usr SET
1621 card = CURRVAL('actor.card_id_seq'),
1622 billing_address = CURRVAL('actor.usr_address_id_seq'),
1623 credit_forward_balance = '0',
1624 mailing_address = CURRVAL('actor.usr_address_id_seq')
1625 WHERE id=CURRVAL('actor.usr_id_seq');
1628 INSERT INTO actor.usr
1629 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1630 VALUES (2, 1, '99999322514', 7, 'Barber', 'shawnb1234',
1631 'Shawn', 'Thomas', NOW() + '3 years'::INTERVAL, '1988-10-21', 'II');
1633 INSERT INTO actor.usr_address
1634 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1635 VALUES ('USA', 't', '98464', '7111 Accurate Talk Canyon', 't',
1636 'WA', 'Tacoma', '', 'Pierce', CURRVAL('actor.usr_id_seq'));
1638 INSERT INTO actor.card (barcode, usr)
1639 VALUES ('99999322514', CURRVAL('actor.usr_id_seq'));
1641 UPDATE actor.usr SET
1642 card = CURRVAL('actor.card_id_seq'),
1643 billing_address = CURRVAL('actor.usr_address_id_seq'),
1644 credit_forward_balance = '0',
1645 mailing_address = CURRVAL('actor.usr_address_id_seq')
1646 WHERE id=CURRVAL('actor.usr_id_seq');
1649 INSERT INTO actor.usr
1650 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1651 VALUES (2, 1, '99999342144', 8, 'Harrison', 'williamh1234',
1652 'William', 'Phillip', NOW() + '3 years'::INTERVAL, '1990-04-09', 'II');
1654 INSERT INTO actor.usr_address
1655 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1656 VALUES ('USA', 'f', '79085', '9798 Marked West Fork', 't',
1657 'TX', 'Summerfield', '', 'Castro', CURRVAL('actor.usr_id_seq'));
1659 INSERT INTO actor.card (barcode, usr)
1660 VALUES ('99999342144', CURRVAL('actor.usr_id_seq'));
1662 UPDATE actor.usr SET
1663 card = CURRVAL('actor.card_id_seq'),
1664 billing_address = CURRVAL('actor.usr_address_id_seq'),
1665 credit_forward_balance = '0',
1666 mailing_address = CURRVAL('actor.usr_address_id_seq')
1667 WHERE id=CURRVAL('actor.usr_id_seq');
1670 INSERT INTO actor.usr
1671 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1672 VALUES (2, 1, '99999320546', 7, 'Porter', 'darlenep1234',
1673 'Darlene', 'Lisa', NOW() + '3 years'::INTERVAL, '1987-02-23', 'Jr');
1675 INSERT INTO actor.usr_address
1676 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1677 VALUES ('USA', 't', '24910', '3522 Channel Radial', 't',
1678 'WV', 'Alderson', '', 'Monroe', CURRVAL('actor.usr_id_seq'));
1680 INSERT INTO actor.card (barcode, usr)
1681 VALUES ('99999320546', CURRVAL('actor.usr_id_seq'));
1683 UPDATE actor.usr SET
1684 card = CURRVAL('actor.card_id_seq'),
1685 billing_address = CURRVAL('actor.usr_address_id_seq'),
1686 credit_forward_balance = '0',
1687 mailing_address = CURRVAL('actor.usr_address_id_seq')
1688 WHERE id=CURRVAL('actor.usr_id_seq');
1691 INSERT INTO actor.usr
1692 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1693 VALUES (2, 3, '99999315474', 8, 'Lopez', 'joycel1234',
1694 'Joyce', 'Donna', NOW() + '3 years'::INTERVAL, '1980-06-28', 'Sr');
1696 INSERT INTO actor.usr_address
1697 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1698 VALUES ('USA', 't', '89101', '9734 Civilian Position Hollow', 't',
1699 'NV', 'Las vegas', '', 'Clark', CURRVAL('actor.usr_id_seq'));
1701 INSERT INTO actor.card (barcode, usr)
1702 VALUES ('99999315474', CURRVAL('actor.usr_id_seq'));
1704 UPDATE actor.usr SET
1705 card = CURRVAL('actor.card_id_seq'),
1706 billing_address = CURRVAL('actor.usr_address_id_seq'),
1707 credit_forward_balance = '0',
1708 mailing_address = CURRVAL('actor.usr_address_id_seq')
1709 WHERE id=CURRVAL('actor.usr_id_seq');
1712 INSERT INTO actor.usr
1713 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1714 VALUES (2, 1, '99999371586', 9, 'Stevenson', 'larrys1234',
1715 'Larry', '', NOW() + '3 years'::INTERVAL, '1990-12-20', 'Sr');
1717 INSERT INTO actor.usr_address
1718 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1719 VALUES ('USA', 't', '46241', '5799 Constitutional Roof Groves', 't',
1720 'IN', 'Indianapolis', '', 'Marion', CURRVAL('actor.usr_id_seq'));
1722 INSERT INTO actor.card (barcode, usr)
1723 VALUES ('99999371586', CURRVAL('actor.usr_id_seq'));
1725 UPDATE actor.usr SET
1726 card = CURRVAL('actor.card_id_seq'),
1727 billing_address = CURRVAL('actor.usr_address_id_seq'),
1728 credit_forward_balance = '0',
1729 mailing_address = CURRVAL('actor.usr_address_id_seq')
1730 WHERE id=CURRVAL('actor.usr_id_seq');
1733 INSERT INTO actor.usr
1734 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1735 VALUES (2, 1, '99999329832', 4, 'Kinney', 'nicholask1234',
1736 'Nicholas', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1738 INSERT INTO actor.usr_address
1739 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1740 VALUES ('USA', 't', '90606', '411 Preliminary Library Square', 't',
1741 'CA', 'Whittier', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
1743 INSERT INTO actor.card (barcode, usr)
1744 VALUES ('99999329832', CURRVAL('actor.usr_id_seq'));
1746 UPDATE actor.usr SET
1747 card = CURRVAL('actor.card_id_seq'),
1748 billing_address = CURRVAL('actor.usr_address_id_seq'),
1749 credit_forward_balance = '0',
1750 mailing_address = CURRVAL('actor.usr_address_id_seq')
1751 WHERE id=CURRVAL('actor.usr_id_seq');
1754 INSERT INTO actor.usr
1755 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1756 VALUES (2, 3, '99999342948', 5, 'Bernard', 'omarb1234',
1757 'Omar', 'David', NOW() + '3 years'::INTERVAL, '1981-08-19', 'Jr');
1759 INSERT INTO actor.usr_address
1760 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1761 VALUES ('USA', 'f', '41567', '2546 Marvellous Index Ways', 't',
1762 'KY', 'Stone', '', 'Pike', CURRVAL('actor.usr_id_seq'));
1764 INSERT INTO actor.card (barcode, usr)
1765 VALUES ('99999342948', CURRVAL('actor.usr_id_seq'));
1767 UPDATE actor.usr SET
1768 card = CURRVAL('actor.card_id_seq'),
1769 billing_address = CURRVAL('actor.usr_address_id_seq'),
1770 credit_forward_balance = '0',
1771 mailing_address = CURRVAL('actor.usr_address_id_seq')
1772 WHERE id=CURRVAL('actor.usr_id_seq');
1775 INSERT INTO actor.usr
1776 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1777 VALUES (2, 3, '99999335091', 9, 'Brown', 'maryb1234',
1778 'Mary', 'Annie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1780 INSERT INTO actor.usr_address
1781 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1782 VALUES ('USA', 't', '07630', '48 Look Ridge', 't',
1783 'NJ', 'Emerson', '', '', CURRVAL('actor.usr_id_seq'));
1785 INSERT INTO actor.card (barcode, usr)
1786 VALUES ('99999335091', CURRVAL('actor.usr_id_seq'));
1788 UPDATE actor.usr SET
1789 card = CURRVAL('actor.card_id_seq'),
1790 billing_address = CURRVAL('actor.usr_address_id_seq'),
1791 credit_forward_balance = '0',
1792 mailing_address = CURRVAL('actor.usr_address_id_seq')
1793 WHERE id=CURRVAL('actor.usr_id_seq');
1796 INSERT INTO actor.usr
1797 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1798 VALUES (2, 3, '99999303411', 8, 'Smith', 'sarahs1234',
1799 'Sarah', '', NOW() + '3 years'::INTERVAL, '1990-01-13', 'II');
1801 INSERT INTO actor.usr_address
1802 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1803 VALUES ('USA', 'f', '34972', '845 Relative Dress Mall', 't',
1804 'FL', 'Okeechobee', '', 'Okeechobee', CURRVAL('actor.usr_id_seq'));
1806 INSERT INTO actor.card (barcode, usr)
1807 VALUES ('99999303411', CURRVAL('actor.usr_id_seq'));
1809 UPDATE actor.usr SET
1810 card = CURRVAL('actor.card_id_seq'),
1811 billing_address = CURRVAL('actor.usr_address_id_seq'),
1812 credit_forward_balance = '0',
1813 mailing_address = CURRVAL('actor.usr_address_id_seq')
1814 WHERE id=CURRVAL('actor.usr_id_seq');
1817 INSERT INTO actor.usr
1818 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1819 VALUES (2, 1, '99999327083', 8, 'Jones', 'coraj1234',
1820 'Cora', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1822 INSERT INTO actor.usr_address
1823 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1824 VALUES ('USA', 't', '65262', '9202 Tight Subject Highway', 't',
1825 'MO', 'Kingdom city', '', '', CURRVAL('actor.usr_id_seq'));
1827 INSERT INTO actor.card (barcode, usr)
1828 VALUES ('99999327083', CURRVAL('actor.usr_id_seq'));
1830 UPDATE actor.usr SET
1831 card = CURRVAL('actor.card_id_seq'),
1832 billing_address = CURRVAL('actor.usr_address_id_seq'),
1833 credit_forward_balance = '0',
1834 mailing_address = CURRVAL('actor.usr_address_id_seq')
1835 WHERE id=CURRVAL('actor.usr_id_seq');
1838 INSERT INTO actor.usr
1839 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1840 VALUES (2, 3, '99999300523', 7, 'Little', 'shawnl1234',
1841 'Shawn', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, NULL);
1843 INSERT INTO actor.usr_address
1844 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1845 VALUES ('USA', 'f', '86343', '8169 Vast Passage Key', 't',
1846 'AZ', 'Crown king', '', 'Yavapai', CURRVAL('actor.usr_id_seq'));
1848 INSERT INTO actor.card (barcode, usr)
1849 VALUES ('99999300523', CURRVAL('actor.usr_id_seq'));
1851 UPDATE actor.usr SET
1852 card = CURRVAL('actor.card_id_seq'),
1853 billing_address = CURRVAL('actor.usr_address_id_seq'),
1854 credit_forward_balance = '0',
1855 mailing_address = CURRVAL('actor.usr_address_id_seq')
1856 WHERE id=CURRVAL('actor.usr_id_seq');
1859 INSERT INTO actor.usr
1860 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1861 VALUES (2, 3, '99999328829', 6, 'Thurman', 'luannt1234',
1862 'Luann', 'Donna', NOW() + '3 years'::INTERVAL, NULL, NULL);
1864 INSERT INTO actor.usr_address
1865 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1866 VALUES ('USA', 't', '63463', '1967 Interesting Court Ford', 't',
1867 'MO', 'Philadelphia', '', 'Marion', CURRVAL('actor.usr_id_seq'));
1869 INSERT INTO actor.card (barcode, usr)
1870 VALUES ('99999328829', CURRVAL('actor.usr_id_seq'));
1872 UPDATE actor.usr SET
1873 card = CURRVAL('actor.card_id_seq'),
1874 billing_address = CURRVAL('actor.usr_address_id_seq'),
1875 credit_forward_balance = '0',
1876 mailing_address = CURRVAL('actor.usr_address_id_seq')
1877 WHERE id=CURRVAL('actor.usr_id_seq');
1880 INSERT INTO actor.usr
1881 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1882 VALUES (2, 3, '99999394673', 6, 'Scott', 'patricias1234',
1883 'Patricia', 'Robin', NOW() + '3 years'::INTERVAL, NULL, NULL);
1885 INSERT INTO actor.usr_address
1886 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1887 VALUES ('USA', 't', '44241', '8955 Due Population Alley', 't',
1888 'OH', 'Streetsboro', '', 'Portage', CURRVAL('actor.usr_id_seq'));
1890 INSERT INTO actor.card (barcode, usr)
1891 VALUES ('99999394673', CURRVAL('actor.usr_id_seq'));
1893 UPDATE actor.usr SET
1894 card = CURRVAL('actor.card_id_seq'),
1895 billing_address = CURRVAL('actor.usr_address_id_seq'),
1896 credit_forward_balance = '0',
1897 mailing_address = CURRVAL('actor.usr_address_id_seq')
1898 WHERE id=CURRVAL('actor.usr_id_seq');
1901 INSERT INTO actor.usr
1902 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1903 VALUES (2, 1, '99999355318', 5, 'Lamb', 'esperanzal1234',
1904 'Esperanza', 'Beth', NOW() + '3 years'::INTERVAL, '1995-06-13', 'III');
1906 INSERT INTO actor.usr_address
1907 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1908 VALUES ('USA', 'f', '05501', '9042 Just Show Turnpike', 't',
1909 'MA', 'Andover', '', 'Essex', CURRVAL('actor.usr_id_seq'));
1911 INSERT INTO actor.card (barcode, usr)
1912 VALUES ('99999355318', CURRVAL('actor.usr_id_seq'));
1914 UPDATE actor.usr SET
1915 card = CURRVAL('actor.card_id_seq'),
1916 billing_address = CURRVAL('actor.usr_address_id_seq'),
1917 credit_forward_balance = '0',
1918 mailing_address = CURRVAL('actor.usr_address_id_seq')
1919 WHERE id=CURRVAL('actor.usr_id_seq');
1922 INSERT INTO actor.usr
1923 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1924 VALUES (2, 1, '99999377675', 8, 'Brown', 'wendib1234',
1925 'Wendi', 'Mary', NOW() + '3 years'::INTERVAL, NULL, NULL);
1927 INSERT INTO actor.usr_address
1928 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1929 VALUES ('USA', 'f', '37721', '7546 Rude Agreement Highway', 't',
1930 'TN', 'Corryton', '', 'Knox', CURRVAL('actor.usr_id_seq'));
1932 INSERT INTO actor.card (barcode, usr)
1933 VALUES ('99999377675', CURRVAL('actor.usr_id_seq'));
1935 UPDATE actor.usr SET
1936 card = CURRVAL('actor.card_id_seq'),
1937 billing_address = CURRVAL('actor.usr_address_id_seq'),
1938 credit_forward_balance = '0',
1939 mailing_address = CURRVAL('actor.usr_address_id_seq')
1940 WHERE id=CURRVAL('actor.usr_id_seq');
1943 INSERT INTO actor.usr
1944 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1945 VALUES (2, 3, '99999363186', 5, 'Clarke', 'lawrencec1234',
1946 'Lawrence', 'Vern', NOW() + '3 years'::INTERVAL, NULL, NULL);
1948 INSERT INTO actor.usr_address
1949 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1950 VALUES ('USA', 't', '76234', '7903 Surprised Rule Loop', 't',
1951 'TX', 'Decatur', '', 'Wise', CURRVAL('actor.usr_id_seq'));
1953 INSERT INTO actor.card (barcode, usr)
1954 VALUES ('99999363186', CURRVAL('actor.usr_id_seq'));
1956 UPDATE actor.usr SET
1957 card = CURRVAL('actor.card_id_seq'),
1958 billing_address = CURRVAL('actor.usr_address_id_seq'),
1959 credit_forward_balance = '0',
1960 mailing_address = CURRVAL('actor.usr_address_id_seq')
1961 WHERE id=CURRVAL('actor.usr_id_seq');
1964 INSERT INTO actor.usr
1965 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1966 VALUES (2, 1, '99999346314', 8, 'Clark', 'danielc1234',
1967 'Daniel', 'Ricky', NOW() + '3 years'::INTERVAL, NULL, NULL);
1969 INSERT INTO actor.usr_address
1970 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1971 VALUES ('USA', 't', '70706', '8604 Defensive Case Trace', 't',
1972 'LA', 'Denham springs', '', '', CURRVAL('actor.usr_id_seq'));
1974 INSERT INTO actor.card (barcode, usr)
1975 VALUES ('99999346314', CURRVAL('actor.usr_id_seq'));
1977 UPDATE actor.usr SET
1978 card = CURRVAL('actor.card_id_seq'),
1979 billing_address = CURRVAL('actor.usr_address_id_seq'),
1980 credit_forward_balance = '0',
1981 mailing_address = CURRVAL('actor.usr_address_id_seq')
1982 WHERE id=CURRVAL('actor.usr_id_seq');
1985 INSERT INTO actor.usr
1986 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1987 VALUES (2, 1, '99999353477', 6, 'Dennis', 'johnd1234',
1988 'John', 'Robert', NOW() + '3 years'::INTERVAL, '1975-03-04', NULL);
1990 INSERT INTO actor.usr_address
1991 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1992 VALUES ('USA', 't', '14480', '8712 Legislative Box Shore', 't',
1993 'NY', 'Lakeville', '', 'Livingston', CURRVAL('actor.usr_id_seq'));
1995 INSERT INTO actor.card (barcode, usr)
1996 VALUES ('99999353477', CURRVAL('actor.usr_id_seq'));
1998 UPDATE actor.usr SET
1999 card = CURRVAL('actor.card_id_seq'),
2000 billing_address = CURRVAL('actor.usr_address_id_seq'),
2001 credit_forward_balance = '0',
2002 mailing_address = CURRVAL('actor.usr_address_id_seq')
2003 WHERE id=CURRVAL('actor.usr_id_seq');
2006 INSERT INTO actor.usr
2007 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2008 VALUES (2, 1, '99999312358', 4, 'Copeland', 'janc1234',
2009 'Jan', 'Lindsey', NOW() + '3 years'::INTERVAL, '1998-06-14', 'Jr');
2011 INSERT INTO actor.usr_address
2012 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2013 VALUES ('USA', 'f', '83204', '6713 River Bridge', 't',
2014 'ID', 'Pocatello', '', 'Bannock', CURRVAL('actor.usr_id_seq'));
2016 INSERT INTO actor.card (barcode, usr)
2017 VALUES ('99999312358', CURRVAL('actor.usr_id_seq'));
2019 UPDATE actor.usr SET
2020 card = CURRVAL('actor.card_id_seq'),
2021 billing_address = CURRVAL('actor.usr_address_id_seq'),
2022 credit_forward_balance = '0',
2023 mailing_address = CURRVAL('actor.usr_address_id_seq')
2024 WHERE id=CURRVAL('actor.usr_id_seq');
2027 INSERT INTO actor.usr
2028 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2029 VALUES (2, 1, '99999360839', 8, 'Brooks', 'pennyb1234',
2030 'Penny', 'Martha', NOW() + '3 years'::INTERVAL, '1980-03-13', 'II');
2032 INSERT INTO actor.usr_address
2033 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2034 VALUES ('USA', 't', '79120', '8208 Death Ramp', 't',
2035 'TX', 'Amarillo', '', 'Potter', CURRVAL('actor.usr_id_seq'));
2037 INSERT INTO actor.card (barcode, usr)
2038 VALUES ('99999360839', CURRVAL('actor.usr_id_seq'));
2040 UPDATE actor.usr SET
2041 card = CURRVAL('actor.card_id_seq'),
2042 billing_address = CURRVAL('actor.usr_address_id_seq'),
2043 credit_forward_balance = '0',
2044 mailing_address = CURRVAL('actor.usr_address_id_seq')
2045 WHERE id=CURRVAL('actor.usr_id_seq');
2048 INSERT INTO actor.usr
2049 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2050 VALUES (2, 3, '99999342446', 8, 'Johnson', 'jeannej1234',
2051 'Jeanne', '', NOW() + '3 years'::INTERVAL, '1980-02-03', NULL);
2053 INSERT INTO actor.usr_address
2054 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2055 VALUES ('USA', 't', '85036', '9634 Tough Division Junction', 't',
2056 'AZ', 'Phoenix', '', '', CURRVAL('actor.usr_id_seq'));
2058 INSERT INTO actor.card (barcode, usr)
2059 VALUES ('99999342446', CURRVAL('actor.usr_id_seq'));
2061 UPDATE actor.usr SET
2062 card = CURRVAL('actor.card_id_seq'),
2063 billing_address = CURRVAL('actor.usr_address_id_seq'),
2064 credit_forward_balance = '0',
2065 mailing_address = CURRVAL('actor.usr_address_id_seq')
2066 WHERE id=CURRVAL('actor.usr_id_seq');
2069 INSERT INTO actor.usr
2070 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2071 VALUES (2, 1, '99999358416', 4, 'Sanford', 'elizabeths1234',
2072 'Elizabeth', 'Vanessa', NOW() + '3 years'::INTERVAL, NULL, '');
2074 INSERT INTO actor.usr_address
2075 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2076 VALUES ('USA', 't', '98357', '6767 Application Course', 't',
2077 'WA', 'Neah bay', '', 'Clallam', CURRVAL('actor.usr_id_seq'));
2079 INSERT INTO actor.card (barcode, usr)
2080 VALUES ('99999358416', CURRVAL('actor.usr_id_seq'));
2082 UPDATE actor.usr SET
2083 card = CURRVAL('actor.card_id_seq'),
2084 billing_address = CURRVAL('actor.usr_address_id_seq'),
2085 credit_forward_balance = '0',
2086 mailing_address = CURRVAL('actor.usr_address_id_seq')
2087 WHERE id=CURRVAL('actor.usr_id_seq');
2090 INSERT INTO actor.usr
2091 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2092 VALUES (2, 3, '99999361389', 9, 'Ramirez', 'alanr1234',
2093 'Alan', 'Claude', NOW() + '3 years'::INTERVAL, NULL, '');
2095 INSERT INTO actor.usr_address
2096 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2097 VALUES ('USA', 't', '76060', '9964 Skinny Party Orchard', 't',
2098 'TX', 'Kennedale', '', 'Tarrant', CURRVAL('actor.usr_id_seq'));
2100 INSERT INTO actor.card (barcode, usr)
2101 VALUES ('99999361389', CURRVAL('actor.usr_id_seq'));
2103 UPDATE actor.usr SET
2104 card = CURRVAL('actor.card_id_seq'),
2105 billing_address = CURRVAL('actor.usr_address_id_seq'),
2106 credit_forward_balance = '0',
2107 mailing_address = CURRVAL('actor.usr_address_id_seq')
2108 WHERE id=CURRVAL('actor.usr_id_seq');