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');
47 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
48 VALUES (2, 3, '99999355250', 5, 'Jones', 'gregoryj1234',
49 'Gregory', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
51 INSERT INTO actor.usr_address
52 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
53 VALUES ('USA', 'f', '55927', '5150 Dinner Expressway', 'f',
54 'MN', 'Dodge center', '', 'Dodge', CURRVAL('actor.usr_id_seq'));
56 INSERT INTO actor.card (barcode, usr)
57 VALUES ('99999355250', CURRVAL('actor.usr_id_seq'));
60 card = CURRVAL('actor.card_id_seq'),
61 billing_address = CURRVAL('actor.usr_address_id_seq'),
62 credit_forward_balance = '0',
63 mailing_address = CURRVAL('actor.usr_address_id_seq')
64 WHERE id=CURRVAL('actor.usr_id_seq');
68 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
69 VALUES (2, 1, '99999387993', 9, 'Moran', 'vincentm1234',
70 'Vincent', 'Kenneth', NOW() + '3 years'::INTERVAL, NULL, NULL);
72 INSERT INTO actor.usr_address
73 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
74 VALUES ('USA', 't', '22611', '8496 Random Trust Points', 'f',
75 'VA', 'Berryville', '', '', CURRVAL('actor.usr_id_seq'));
77 INSERT INTO actor.card (barcode, usr)
78 VALUES ('99999387993', CURRVAL('actor.usr_id_seq'));
81 card = CURRVAL('actor.card_id_seq'),
82 billing_address = CURRVAL('actor.usr_address_id_seq'),
83 credit_forward_balance = '0',
84 mailing_address = CURRVAL('actor.usr_address_id_seq')
85 WHERE id=CURRVAL('actor.usr_id_seq');
89 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
90 VALUES (2, 1, '99999335859', 8, 'Jones', 'gregoryj1234',
91 'Gregory', 'Adam', NOW() + '3 years'::INTERVAL, NULL, NULL);
93 INSERT INTO actor.usr_address
94 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
95 VALUES ('USA', 'f', '99502', '7626 Secret Institute Courts', 'f',
96 'AK', 'Anchorage', '', '', CURRVAL('actor.usr_id_seq'));
98 INSERT INTO actor.card (barcode, usr)
99 VALUES ('99999335859', CURRVAL('actor.usr_id_seq'));
102 card = CURRVAL('actor.card_id_seq'),
103 billing_address = CURRVAL('actor.usr_address_id_seq'),
104 credit_forward_balance = '0',
105 mailing_address = CURRVAL('actor.usr_address_id_seq')
106 WHERE id=CURRVAL('actor.usr_id_seq');
109 INSERT INTO actor.usr
110 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
111 VALUES (2, 1, '99999373186', 7, 'Walker', 'brittanyw1234',
112 'Brittany', 'Geraldine', NOW() + '3 years'::INTERVAL, NULL, NULL);
114 INSERT INTO actor.usr_address
115 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
116 VALUES ('USA', 'f', '40445', '7044 Regular Index Path', 'f',
117 'KY', 'Livingston', '', 'Rockcastle', CURRVAL('actor.usr_id_seq'));
119 INSERT INTO actor.card (barcode, usr)
120 VALUES ('99999373186', CURRVAL('actor.usr_id_seq'));
123 card = CURRVAL('actor.card_id_seq'),
124 billing_address = CURRVAL('actor.usr_address_id_seq'),
125 credit_forward_balance = '0',
126 mailing_address = CURRVAL('actor.usr_address_id_seq')
127 WHERE id=CURRVAL('actor.usr_id_seq');
130 INSERT INTO actor.usr
131 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
132 VALUES (2, 1, '99999384262', 9, 'Miller', 'ernestom1234',
133 'Ernesto', 'Robert', NOW() + '3 years'::INTERVAL, '1997-02-02', 'II');
135 INSERT INTO actor.usr_address
136 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
137 VALUES ('USA', 't', '33157', '3403 Thundering Heat Meadows', 'f',
138 'FL', 'Miami', '', '', CURRVAL('actor.usr_id_seq'));
140 INSERT INTO actor.card (barcode, usr)
141 VALUES ('99999384262', CURRVAL('actor.usr_id_seq'));
144 card = CURRVAL('actor.card_id_seq'),
145 billing_address = CURRVAL('actor.usr_address_id_seq'),
146 credit_forward_balance = '0',
147 mailing_address = CURRVAL('actor.usr_address_id_seq')
148 WHERE id=CURRVAL('actor.usr_id_seq');
151 INSERT INTO actor.usr
152 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
153 VALUES (2, 1, '99999373998', 9, 'Hill', 'roberth1234',
154 'Robert', 'Louis', NOW() + '3 years'::INTERVAL, NULL, 'III');
156 INSERT INTO actor.usr_address
157 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
158 VALUES ('USA', 't', '18960', '759 Doubtful Government Extension', 't',
159 'PA', 'Sellersville', '', '', CURRVAL('actor.usr_id_seq'));
161 INSERT INTO actor.card (barcode, usr)
162 VALUES ('99999373998', CURRVAL('actor.usr_id_seq'));
165 card = CURRVAL('actor.card_id_seq'),
166 billing_address = CURRVAL('actor.usr_address_id_seq'),
167 credit_forward_balance = '0',
168 mailing_address = CURRVAL('actor.usr_address_id_seq')
169 WHERE id=CURRVAL('actor.usr_id_seq');
172 INSERT INTO actor.usr
173 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
174 VALUES (2, 3, '99999376669', 7, 'Lopez', 'edwardl1234',
175 'Edward', 'Robert', NOW() + '3 years'::INTERVAL, NULL, 'II');
177 INSERT INTO actor.usr_address
178 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
179 VALUES ('USA', 't', '29593', '5431 Japanese Work Rapid', 'f',
180 'SC', 'Society hill', '', 'Darlington', CURRVAL('actor.usr_id_seq'));
182 INSERT INTO actor.card (barcode, usr)
183 VALUES ('99999376669', CURRVAL('actor.usr_id_seq'));
186 card = CURRVAL('actor.card_id_seq'),
187 billing_address = CURRVAL('actor.usr_address_id_seq'),
188 credit_forward_balance = '0',
189 mailing_address = CURRVAL('actor.usr_address_id_seq')
190 WHERE id=CURRVAL('actor.usr_id_seq');
193 INSERT INTO actor.usr
194 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
195 VALUES (2, 3, '99999361076', 8, 'Bell', 'andrewb1234',
196 'Andrew', 'Alberto', NOW() + '3 years'::INTERVAL, NULL, 'II');
198 INSERT INTO actor.usr_address
199 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
200 VALUES ('USA', 't', '61936', '5253 Agricultural Exhibition Stravenue', 'f',
201 'IL', 'La place', '', 'Piatt', CURRVAL('actor.usr_id_seq'));
203 INSERT INTO actor.card (barcode, usr)
204 VALUES ('99999361076', CURRVAL('actor.usr_id_seq'));
207 card = CURRVAL('actor.card_id_seq'),
208 billing_address = CURRVAL('actor.usr_address_id_seq'),
209 credit_forward_balance = '0',
210 mailing_address = CURRVAL('actor.usr_address_id_seq')
211 WHERE id=CURRVAL('actor.usr_id_seq');
214 INSERT INTO actor.usr
215 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
216 VALUES (2, 1, '99999376988', 9, 'Mitchell', 'jenniferm1234',
217 'Jennifer', 'Dorothy', NOW() + '3 years'::INTERVAL, NULL, NULL);
219 INSERT INTO actor.usr_address
220 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
221 VALUES ('USA', 't', '61822', '8649 Raspy Goal Terrace', 't',
222 'IL', 'Champaign', '', 'Champaign', CURRVAL('actor.usr_id_seq'));
224 INSERT INTO actor.card (barcode, usr)
225 VALUES ('99999376988', CURRVAL('actor.usr_id_seq'));
228 card = CURRVAL('actor.card_id_seq'),
229 billing_address = CURRVAL('actor.usr_address_id_seq'),
230 credit_forward_balance = '0',
231 mailing_address = CURRVAL('actor.usr_address_id_seq')
232 WHERE id=CURRVAL('actor.usr_id_seq');
235 INSERT INTO actor.usr
236 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
237 VALUES (2, 3, '99999390791', 7, 'Ortiz', 'richardo1234',
238 'Richard', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
240 INSERT INTO actor.usr_address
241 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
242 VALUES ('USA', 'f', '23885', '2433 Uncomfortable Nature Greens', 'f',
243 'VA', 'Sutherland', '', 'Dinwiddie', CURRVAL('actor.usr_id_seq'));
245 INSERT INTO actor.card (barcode, usr)
246 VALUES ('99999390791', CURRVAL('actor.usr_id_seq'));
249 card = CURRVAL('actor.card_id_seq'),
250 billing_address = CURRVAL('actor.usr_address_id_seq'),
251 credit_forward_balance = '0',
252 mailing_address = CURRVAL('actor.usr_address_id_seq')
253 WHERE id=CURRVAL('actor.usr_id_seq');
256 INSERT INTO actor.usr
257 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
258 VALUES (2, 1, '99999378730', 6, 'Wade', 'robertw1234',
259 'Robert', 'Coy', NOW() + '3 years'::INTERVAL, NULL, NULL);
261 INSERT INTO actor.usr_address
262 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
263 VALUES ('USA', 't', '55796', '3241 Communist Boat Boulevard', 'f',
264 'MN', 'Winton', '', 'Saint louis', CURRVAL('actor.usr_id_seq'));
266 INSERT INTO actor.card (barcode, usr)
267 VALUES ('99999378730', CURRVAL('actor.usr_id_seq'));
270 card = CURRVAL('actor.card_id_seq'),
271 billing_address = CURRVAL('actor.usr_address_id_seq'),
272 credit_forward_balance = '0',
273 mailing_address = CURRVAL('actor.usr_address_id_seq')
274 WHERE id=CURRVAL('actor.usr_id_seq');
277 INSERT INTO actor.usr
278 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
279 VALUES (2, 3, '99999360638', 5, 'Wise', 'janetw1234',
280 'Janet', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
282 INSERT INTO actor.usr_address
283 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
284 VALUES ('USA', 'f', '64126', '6773 Government Hill', 'f',
285 'MO', 'Kansas city', '', '', CURRVAL('actor.usr_id_seq'));
287 INSERT INTO actor.card (barcode, usr)
288 VALUES ('99999360638', CURRVAL('actor.usr_id_seq'));
291 card = CURRVAL('actor.card_id_seq'),
292 billing_address = CURRVAL('actor.usr_address_id_seq'),
293 credit_forward_balance = '0',
294 mailing_address = CURRVAL('actor.usr_address_id_seq')
295 WHERE id=CURRVAL('actor.usr_id_seq');
298 INSERT INTO actor.usr
299 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
300 VALUES (2, 1, '99999350419', 4, 'Torres', 'donaldt1234',
301 'Donald', 'Arnold', NOW() + '3 years'::INTERVAL, '1974-06-26', 'II');
303 INSERT INTO actor.usr_address
304 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
305 VALUES ('USA', 't', '40847', '7194 Gorgeous Edge Dale', 'f',
306 'KY', 'Kenvir', '', 'Harlan', CURRVAL('actor.usr_id_seq'));
308 INSERT INTO actor.card (barcode, usr)
309 VALUES ('99999350419', CURRVAL('actor.usr_id_seq'));
312 card = CURRVAL('actor.card_id_seq'),
313 billing_address = CURRVAL('actor.usr_address_id_seq'),
314 credit_forward_balance = '0',
315 mailing_address = CURRVAL('actor.usr_address_id_seq')
316 WHERE id=CURRVAL('actor.usr_id_seq');
319 INSERT INTO actor.usr
320 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
321 VALUES (2, 1, '99999354736', 4, 'Miller', 'jeffm1234',
322 'Jeff', 'James', NOW() + '3 years'::INTERVAL, NULL, 'Sr');
324 INSERT INTO actor.usr_address
325 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
326 VALUES ('USA', 't', '80920', '9674 Filthy Firm Meadows', 'f',
327 'CO', 'Colorado springs', '', '', CURRVAL('actor.usr_id_seq'));
329 INSERT INTO actor.card (barcode, usr)
330 VALUES ('99999354736', CURRVAL('actor.usr_id_seq'));
333 card = CURRVAL('actor.card_id_seq'),
334 billing_address = CURRVAL('actor.usr_address_id_seq'),
335 credit_forward_balance = '0',
336 mailing_address = CURRVAL('actor.usr_address_id_seq')
337 WHERE id=CURRVAL('actor.usr_id_seq');
340 INSERT INTO actor.usr
341 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
342 VALUES (2, 1, '99999329662', 9, 'Estes', 'leonarde1234',
343 'Leonard', '', NOW() + '3 years'::INTERVAL, '1994-05-07', 'III');
345 INSERT INTO actor.usr_address
346 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
347 VALUES ('USA', 'f', '20724', '6145 Superior Dress Prairie', 't',
348 'MD', 'Laurel', '', '', CURRVAL('actor.usr_id_seq'));
350 INSERT INTO actor.card (barcode, usr)
351 VALUES ('99999329662', CURRVAL('actor.usr_id_seq'));
354 card = CURRVAL('actor.card_id_seq'),
355 billing_address = CURRVAL('actor.usr_address_id_seq'),
356 credit_forward_balance = '0',
357 mailing_address = CURRVAL('actor.usr_address_id_seq')
358 WHERE id=CURRVAL('actor.usr_id_seq');
361 INSERT INTO actor.usr
362 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
363 VALUES (2, 1, '99999397601', 8, 'Dunn', 'brittneyd1234',
364 'Brittney', 'Pamela', NOW() + '3 years'::INTERVAL, NULL, NULL);
366 INSERT INTO actor.usr_address
367 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
368 VALUES ('USA', 't', '73838', '9753 Confident Limit Shoal', 'f',
369 'OK', 'Chester', '', '', CURRVAL('actor.usr_id_seq'));
371 INSERT INTO actor.card (barcode, usr)
372 VALUES ('99999397601', CURRVAL('actor.usr_id_seq'));
375 card = CURRVAL('actor.card_id_seq'),
376 billing_address = CURRVAL('actor.usr_address_id_seq'),
377 credit_forward_balance = '0',
378 mailing_address = CURRVAL('actor.usr_address_id_seq')
379 WHERE id=CURRVAL('actor.usr_id_seq');
382 INSERT INTO actor.usr
383 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
384 VALUES (2, 3, '99999377594', 4, 'Wiggins', 'jeanw1234',
385 'Jean', 'Verna', NOW() + '3 years'::INTERVAL, NULL, NULL);
387 INSERT INTO actor.usr_address
388 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
389 VALUES ('USA', 'f', '23018', '6115 Thoughtful Country Ridge', 'f',
390 'VA', 'Bena', '', '', CURRVAL('actor.usr_id_seq'));
392 INSERT INTO actor.card (barcode, usr)
393 VALUES ('99999377594', CURRVAL('actor.usr_id_seq'));
396 card = CURRVAL('actor.card_id_seq'),
397 billing_address = CURRVAL('actor.usr_address_id_seq'),
398 credit_forward_balance = '0',
399 mailing_address = CURRVAL('actor.usr_address_id_seq')
400 WHERE id=CURRVAL('actor.usr_id_seq');
403 INSERT INTO actor.usr
404 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
405 VALUES (2, 1, '99999371252', 9, 'Thomas', 'lelat1234',
406 'Lela', 'Sarah', NOW() + '3 years'::INTERVAL, '1968-04-11', 'Sr');
408 INSERT INTO actor.usr_address
409 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
410 VALUES ('USA', 't', '60609', '4223 Spotty Chemical Stravenue', 'f',
411 'IL', 'Chicago', '', 'Cook', CURRVAL('actor.usr_id_seq'));
413 INSERT INTO actor.card (barcode, usr)
414 VALUES ('99999371252', CURRVAL('actor.usr_id_seq'));
417 card = CURRVAL('actor.card_id_seq'),
418 billing_address = CURRVAL('actor.usr_address_id_seq'),
419 credit_forward_balance = '0',
420 mailing_address = CURRVAL('actor.usr_address_id_seq')
421 WHERE id=CURRVAL('actor.usr_id_seq');
424 INSERT INTO actor.usr
425 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
426 VALUES (2, 3, '99999398023', 8, 'Phillips', 'noahp1234',
427 'Noah', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, 'III');
429 INSERT INTO actor.usr_address
430 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
431 VALUES ('USA', 't', '33593', '2005 Inner Entry Harbor', 'f',
432 'FL', 'Trilby', '', '', CURRVAL('actor.usr_id_seq'));
434 INSERT INTO actor.card (barcode, usr)
435 VALUES ('99999398023', CURRVAL('actor.usr_id_seq'));
438 card = CURRVAL('actor.card_id_seq'),
439 billing_address = CURRVAL('actor.usr_address_id_seq'),
440 credit_forward_balance = '0',
441 mailing_address = CURRVAL('actor.usr_address_id_seq')
442 WHERE id=CURRVAL('actor.usr_id_seq');
445 INSERT INTO actor.usr
446 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
447 VALUES (2, 3, '99999324566', 5, 'Mitchell', 'carolynm1234',
448 'Carolyn', 'Patrica', NOW() + '3 years'::INTERVAL, '1981-09-03', 'III');
450 INSERT INTO actor.usr_address
451 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
452 VALUES ('USA', 't', '50652', '5259 Film Crossing', 't',
453 'IA', 'Lincoln', '', 'Tama', CURRVAL('actor.usr_id_seq'));
455 INSERT INTO actor.card (barcode, usr)
456 VALUES ('99999324566', CURRVAL('actor.usr_id_seq'));
459 card = CURRVAL('actor.card_id_seq'),
460 billing_address = CURRVAL('actor.usr_address_id_seq'),
461 credit_forward_balance = '0',
462 mailing_address = CURRVAL('actor.usr_address_id_seq')
463 WHERE id=CURRVAL('actor.usr_id_seq');
466 INSERT INTO actor.usr
467 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
468 VALUES (2, 3, '99999379221', 5, 'Wells', 'kristenw1234',
469 'Kristen', 'Vivian', NOW() + '3 years'::INTERVAL, NULL, NULL);
471 INSERT INTO actor.usr_address
472 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
473 VALUES ('USA', 't', '12450', '2302 Prisoner Way', 'f',
474 'NY', 'Lanesville', '', 'Greene', CURRVAL('actor.usr_id_seq'));
476 INSERT INTO actor.card (barcode, usr)
477 VALUES ('99999379221', CURRVAL('actor.usr_id_seq'));
480 card = CURRVAL('actor.card_id_seq'),
481 billing_address = CURRVAL('actor.usr_address_id_seq'),
482 credit_forward_balance = '0',
483 mailing_address = CURRVAL('actor.usr_address_id_seq')
484 WHERE id=CURRVAL('actor.usr_id_seq');
487 INSERT INTO actor.usr
488 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
489 VALUES (2, 1, '99999373350', 8, 'Lindsey', 'noahl1234',
490 'Noah', 'Keith', NOW() + '3 years'::INTERVAL, NULL, NULL);
492 INSERT INTO actor.usr_address
493 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
494 VALUES ('USA', 't', '50108', '7583 Low Surface Overpass', 'f',
495 'IA', 'Grand river', '', 'Decatur', CURRVAL('actor.usr_id_seq'));
497 INSERT INTO actor.card (barcode, usr)
498 VALUES ('99999373350', CURRVAL('actor.usr_id_seq'));
501 card = CURRVAL('actor.card_id_seq'),
502 billing_address = CURRVAL('actor.usr_address_id_seq'),
503 credit_forward_balance = '0',
504 mailing_address = CURRVAL('actor.usr_address_id_seq')
505 WHERE id=CURRVAL('actor.usr_id_seq');
508 INSERT INTO actor.usr
509 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
510 VALUES (2, 3, '99999340920', 4, 'Williams', 'berthaw1234',
511 'Bertha', 'Katherine', NOW() + '3 years'::INTERVAL, NULL, NULL);
513 INSERT INTO actor.usr_address
514 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
515 VALUES ('USA', 't', '20646', '3301 Acid Canyon', 'f',
516 'MD', 'La plata', '', 'Charles', CURRVAL('actor.usr_id_seq'));
518 INSERT INTO actor.card (barcode, usr)
519 VALUES ('99999340920', CURRVAL('actor.usr_id_seq'));
522 card = CURRVAL('actor.card_id_seq'),
523 billing_address = CURRVAL('actor.usr_address_id_seq'),
524 credit_forward_balance = '0',
525 mailing_address = CURRVAL('actor.usr_address_id_seq')
526 WHERE id=CURRVAL('actor.usr_id_seq');
529 INSERT INTO actor.usr
530 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
531 VALUES (2, 1, '99999398482', 7, 'Rodriguez', 'jamesr1234',
532 'James', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
534 INSERT INTO actor.usr_address
535 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
536 VALUES ('USA', 'f', '95066', '9801 Working-class Flower Meadow', 'f',
537 'CA', 'Scotts valley', '', '', CURRVAL('actor.usr_id_seq'));
539 INSERT INTO actor.card (barcode, usr)
540 VALUES ('99999398482', CURRVAL('actor.usr_id_seq'));
543 card = CURRVAL('actor.card_id_seq'),
544 billing_address = CURRVAL('actor.usr_address_id_seq'),
545 credit_forward_balance = '0',
546 mailing_address = CURRVAL('actor.usr_address_id_seq')
547 WHERE id=CURRVAL('actor.usr_id_seq');
550 INSERT INTO actor.usr
551 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
552 VALUES (2, 3, '99999394378', 5, 'Byrd', 'matthewb1234',
553 'Matthew', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL);
555 INSERT INTO actor.usr_address
556 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
557 VALUES ('USA', 't', '43015', '9029 Note Court', 't',
558 'OH', 'Delaware', '', 'Delaware', CURRVAL('actor.usr_id_seq'));
560 INSERT INTO actor.card (barcode, usr)
561 VALUES ('99999394378', CURRVAL('actor.usr_id_seq'));
564 card = CURRVAL('actor.card_id_seq'),
565 billing_address = CURRVAL('actor.usr_address_id_seq'),
566 credit_forward_balance = '0',
567 mailing_address = CURRVAL('actor.usr_address_id_seq')
568 WHERE id=CURRVAL('actor.usr_id_seq');
571 INSERT INTO actor.usr
572 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
573 VALUES (2, 1, '99999382659', 4, 'Kelley', 'sandrak1234',
574 'Sandra', 'Pearlie', NOW() + '3 years'::INTERVAL, '1977-01-18', 'Sr');
576 INSERT INTO actor.usr_address
577 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
578 VALUES ('USA', 'f', '56568', '4246 Fun Post Street', 'f',
579 'MN', 'Nielsville', '', 'Polk', CURRVAL('actor.usr_id_seq'));
581 INSERT INTO actor.card (barcode, usr)
582 VALUES ('99999382659', CURRVAL('actor.usr_id_seq'));
585 card = CURRVAL('actor.card_id_seq'),
586 billing_address = CURRVAL('actor.usr_address_id_seq'),
587 credit_forward_balance = '0',
588 mailing_address = CURRVAL('actor.usr_address_id_seq')
589 WHERE id=CURRVAL('actor.usr_id_seq');
592 INSERT INTO actor.usr
593 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
594 VALUES (2, 1, '99999387130', 7, 'Wilson', 'bethw1234',
595 'Beth', 'Michelle', NOW() + '3 years'::INTERVAL, NULL, NULL);
597 INSERT INTO actor.usr_address
598 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
599 VALUES ('USA', 'f', '15341', '7780 Horrible Winner Island', 'f',
600 'PA', 'Holbrook', '', 'Greene', CURRVAL('actor.usr_id_seq'));
602 INSERT INTO actor.card (barcode, usr)
603 VALUES ('99999387130', CURRVAL('actor.usr_id_seq'));
606 card = CURRVAL('actor.card_id_seq'),
607 billing_address = CURRVAL('actor.usr_address_id_seq'),
608 credit_forward_balance = '0',
609 mailing_address = CURRVAL('actor.usr_address_id_seq')
610 WHERE id=CURRVAL('actor.usr_id_seq');
613 INSERT INTO actor.usr
614 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
615 VALUES (2, 3, '99999310765', 8, 'Daniels', 'randyd1234',
616 'Randy', 'Lawrence', NOW() + '3 years'::INTERVAL, NULL, NULL);
618 INSERT INTO actor.usr_address
619 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
620 VALUES ('USA', 'f', '29680', '4697 Subsequent Culture Pass', 'f',
621 'SC', 'Simpsonville', '', 'Greenville', CURRVAL('actor.usr_id_seq'));
623 INSERT INTO actor.card (barcode, usr)
624 VALUES ('99999310765', CURRVAL('actor.usr_id_seq'));
627 card = CURRVAL('actor.card_id_seq'),
628 billing_address = CURRVAL('actor.usr_address_id_seq'),
629 credit_forward_balance = '0',
630 mailing_address = CURRVAL('actor.usr_address_id_seq')
631 WHERE id=CURRVAL('actor.usr_id_seq');
634 INSERT INTO actor.usr
635 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
636 VALUES (2, 1, '99999335545', 9, 'Simpson', 'steves1234',
637 'Steve', 'Raymond', NOW() + '3 years'::INTERVAL, NULL, NULL);
639 INSERT INTO actor.usr_address
640 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
641 VALUES ('USA', 'f', '88118', '2400 Communication Mount', 'f',
642 'NM', 'Floyd', '', '', CURRVAL('actor.usr_id_seq'));
644 INSERT INTO actor.card (barcode, usr)
645 VALUES ('99999335545', CURRVAL('actor.usr_id_seq'));
648 card = CURRVAL('actor.card_id_seq'),
649 billing_address = CURRVAL('actor.usr_address_id_seq'),
650 credit_forward_balance = '0',
651 mailing_address = CURRVAL('actor.usr_address_id_seq')
652 WHERE id=CURRVAL('actor.usr_id_seq');
655 INSERT INTO actor.usr
656 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
657 VALUES (2, 3, '99999360529', 5, 'Hoskins', 'jimh1234',
658 'Jim', 'Michael', NOW() + '3 years'::INTERVAL, '1983-08-02', 'III');
660 INSERT INTO actor.usr_address
661 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
662 VALUES ('USA', 'f', '15015', '7815 Principal Element Center', 't',
663 'PA', 'Bradfordwoods', '', 'Allegheny', CURRVAL('actor.usr_id_seq'));
665 INSERT INTO actor.card (barcode, usr)
666 VALUES ('99999360529', CURRVAL('actor.usr_id_seq'));
669 card = CURRVAL('actor.card_id_seq'),
670 billing_address = CURRVAL('actor.usr_address_id_seq'),
671 credit_forward_balance = '0',
672 mailing_address = CURRVAL('actor.usr_address_id_seq')
673 WHERE id=CURRVAL('actor.usr_id_seq');
676 INSERT INTO actor.usr
677 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
678 VALUES (2, 3, '99999357038', 5, 'May', 'michaelm1234',
679 'Michael', '', NOW() + '3 years'::INTERVAL, '1988-03-06', 'II');
681 INSERT INTO actor.usr_address
682 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
683 VALUES ('USA', 'f', '20064', '4827 Shoulder Center', 'f',
684 'DC', 'Washington', '', 'District of columbia', CURRVAL('actor.usr_id_seq'));
686 INSERT INTO actor.card (barcode, usr)
687 VALUES ('99999357038', CURRVAL('actor.usr_id_seq'));
690 card = CURRVAL('actor.card_id_seq'),
691 billing_address = CURRVAL('actor.usr_address_id_seq'),
692 credit_forward_balance = '0',
693 mailing_address = CURRVAL('actor.usr_address_id_seq')
694 WHERE id=CURRVAL('actor.usr_id_seq');
697 INSERT INTO actor.usr
698 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
699 VALUES (2, 3, '99999371688', 8, 'Ellison', 'done1234',
700 'Don', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL);
702 INSERT INTO actor.usr_address
703 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
704 VALUES ('USA', 'f', '20643', '1298 Golden Speed Hills', 't',
705 'MD', 'Ironsides', '', '', CURRVAL('actor.usr_id_seq'));
707 INSERT INTO actor.card (barcode, usr)
708 VALUES ('99999371688', CURRVAL('actor.usr_id_seq'));
711 card = CURRVAL('actor.card_id_seq'),
712 billing_address = CURRVAL('actor.usr_address_id_seq'),
713 credit_forward_balance = '0',
714 mailing_address = CURRVAL('actor.usr_address_id_seq')
715 WHERE id=CURRVAL('actor.usr_id_seq');
718 INSERT INTO actor.usr
719 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
720 VALUES (2, 1, '99999312757', 4, 'Hughes', 'josephh1234',
721 'Joseph', 'Bryant', NOW() + '3 years'::INTERVAL, NULL, NULL);
723 INSERT INTO actor.usr_address
724 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
725 VALUES ('USA', 't', '48613', '9736 Profitable Wine Spring', 'f',
726 'MI', 'Bentley', '', 'Bay', CURRVAL('actor.usr_id_seq'));
728 INSERT INTO actor.card (barcode, usr)
729 VALUES ('99999312757', CURRVAL('actor.usr_id_seq'));
732 card = CURRVAL('actor.card_id_seq'),
733 billing_address = CURRVAL('actor.usr_address_id_seq'),
734 credit_forward_balance = '0',
735 mailing_address = CURRVAL('actor.usr_address_id_seq')
736 WHERE id=CURRVAL('actor.usr_id_seq');
739 INSERT INTO actor.usr
740 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
741 VALUES (2, 1, '99999399015', 8, 'Turner', 'cristinat1234',
742 'Cristina', 'Karen', NOW() + '3 years'::INTERVAL, NULL, NULL);
744 INSERT INTO actor.usr_address
745 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
746 VALUES ('USA', 't', '45844', '6445 Turkish Strike Shoal', 't',
747 'OH', 'Fort jennings', '', 'Putnam', CURRVAL('actor.usr_id_seq'));
749 INSERT INTO actor.card (barcode, usr)
750 VALUES ('99999399015', CURRVAL('actor.usr_id_seq'));
753 card = CURRVAL('actor.card_id_seq'),
754 billing_address = CURRVAL('actor.usr_address_id_seq'),
755 credit_forward_balance = '0',
756 mailing_address = CURRVAL('actor.usr_address_id_seq')
757 WHERE id=CURRVAL('actor.usr_id_seq');
760 INSERT INTO actor.usr
761 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
762 VALUES (2, 3, '99999313973', 4, 'Langley', 'victorl1234',
763 'Victor', 'James', NOW() + '3 years'::INTERVAL, NULL, NULL);
765 INSERT INTO actor.usr_address
766 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
767 VALUES ('USA', 'f', '94576', '1082 Capacity Hill', 'f',
768 'CA', 'Deer park', '', 'Napa', CURRVAL('actor.usr_id_seq'));
770 INSERT INTO actor.card (barcode, usr)
771 VALUES ('99999313973', CURRVAL('actor.usr_id_seq'));
774 card = CURRVAL('actor.card_id_seq'),
775 billing_address = CURRVAL('actor.usr_address_id_seq'),
776 credit_forward_balance = '0',
777 mailing_address = CURRVAL('actor.usr_address_id_seq')
778 WHERE id=CURRVAL('actor.usr_id_seq');
781 INSERT INTO actor.usr
782 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
783 VALUES (2, 1, '99999311521', 6, 'Fields', 'davidf1234',
784 'David', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
786 INSERT INTO actor.usr_address
787 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
788 VALUES ('USA', 'f', '73939', '8788 Religious Writer Isle', 'f',
789 'OK', 'Goodwell', '', 'Texas', CURRVAL('actor.usr_id_seq'));
791 INSERT INTO actor.card (barcode, usr)
792 VALUES ('99999311521', CURRVAL('actor.usr_id_seq'));
795 card = CURRVAL('actor.card_id_seq'),
796 billing_address = CURRVAL('actor.usr_address_id_seq'),
797 credit_forward_balance = '0',
798 mailing_address = CURRVAL('actor.usr_address_id_seq')
799 WHERE id=CURRVAL('actor.usr_id_seq');
802 INSERT INTO actor.usr
803 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
804 VALUES (2, 1, '99999388816', 7, 'Hoffman', 'gregoryh1234',
805 'Gregory', 'Thomas', NOW() + '3 years'::INTERVAL, '1999-11-13', 'II');
807 INSERT INTO actor.usr_address
808 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
809 VALUES ('USA', 't', '47163', '4971 Assembly Parkways', 'f',
810 'IN', 'Otisco', '', 'Clark', CURRVAL('actor.usr_id_seq'));
812 INSERT INTO actor.card (barcode, usr)
813 VALUES ('99999388816', CURRVAL('actor.usr_id_seq'));
816 card = CURRVAL('actor.card_id_seq'),
817 billing_address = CURRVAL('actor.usr_address_id_seq'),
818 credit_forward_balance = '0',
819 mailing_address = CURRVAL('actor.usr_address_id_seq')
820 WHERE id=CURRVAL('actor.usr_id_seq');
823 INSERT INTO actor.usr
824 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
825 VALUES (2, 3, '99999345160', 8, 'Gonzalez', 'natalieg1234',
826 'Natalie', 'Joan', NOW() + '3 years'::INTERVAL, NULL, NULL);
828 INSERT INTO actor.usr_address
829 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
830 VALUES ('USA', 't', '17120', '8835 Amazing Reduction Course', 'f',
831 'PA', 'Harrisburg', '', 'Dauphin', CURRVAL('actor.usr_id_seq'));
833 INSERT INTO actor.card (barcode, usr)
834 VALUES ('99999345160', CURRVAL('actor.usr_id_seq'));
837 card = CURRVAL('actor.card_id_seq'),
838 billing_address = CURRVAL('actor.usr_address_id_seq'),
839 credit_forward_balance = '0',
840 mailing_address = CURRVAL('actor.usr_address_id_seq')
841 WHERE id=CURRVAL('actor.usr_id_seq');
844 INSERT INTO actor.usr
845 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
846 VALUES (2, 3, '99999328966', 9, 'Rucker', 'drewr1234',
847 'Drew', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
849 INSERT INTO actor.usr_address
850 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
851 VALUES ('USA', 'f', '92253', '5158 Redundant Reality Creek', 'f',
852 'CA', 'La quinta', '', 'Riverside', CURRVAL('actor.usr_id_seq'));
854 INSERT INTO actor.card (barcode, usr)
855 VALUES ('99999328966', CURRVAL('actor.usr_id_seq'));
858 card = CURRVAL('actor.card_id_seq'),
859 billing_address = CURRVAL('actor.usr_address_id_seq'),
860 credit_forward_balance = '0',
861 mailing_address = CURRVAL('actor.usr_address_id_seq')
862 WHERE id=CURRVAL('actor.usr_id_seq');
865 INSERT INTO actor.usr
866 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
867 VALUES (2, 3, '99999394635', 9, 'Mitchell', 'kimberlym1234',
868 'Kimberly', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
870 INSERT INTO actor.usr_address
871 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
872 VALUES ('USA', 'f', '85375', '9724 Land Corner', 'f',
873 'AZ', 'Sun city west', '', '', CURRVAL('actor.usr_id_seq'));
875 INSERT INTO actor.card (barcode, usr)
876 VALUES ('99999394635', CURRVAL('actor.usr_id_seq'));
879 card = CURRVAL('actor.card_id_seq'),
880 billing_address = CURRVAL('actor.usr_address_id_seq'),
881 credit_forward_balance = '0',
882 mailing_address = CURRVAL('actor.usr_address_id_seq')
883 WHERE id=CURRVAL('actor.usr_id_seq');
886 INSERT INTO actor.usr
887 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
888 VALUES (2, 1, '99999333308', 7, 'Murray', 'heatherm1234',
889 'Heather', 'Margaret', NOW() + '3 years'::INTERVAL, NULL, NULL);
891 INSERT INTO actor.usr_address
892 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
893 VALUES ('USA', 'f', '51239', '5555 Project Bypass', 'f',
894 'IA', 'Hull', '', 'Sioux', CURRVAL('actor.usr_id_seq'));
896 INSERT INTO actor.card (barcode, usr)
897 VALUES ('99999333308', CURRVAL('actor.usr_id_seq'));
900 card = CURRVAL('actor.card_id_seq'),
901 billing_address = CURRVAL('actor.usr_address_id_seq'),
902 credit_forward_balance = '0',
903 mailing_address = CURRVAL('actor.usr_address_id_seq')
904 WHERE id=CURRVAL('actor.usr_id_seq');
907 INSERT INTO actor.usr
908 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
909 VALUES (2, 1, '99999316647', 7, 'Sosa', 'robertas1234',
910 'Roberta', 'Norma', NOW() + '3 years'::INTERVAL, NULL, NULL);
912 INSERT INTO actor.usr_address
913 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
914 VALUES ('USA', 'f', '94010', '4571 Jealous Comparison Wells', 'f',
915 'CA', 'Burlingame', '', '', CURRVAL('actor.usr_id_seq'));
917 INSERT INTO actor.card (barcode, usr)
918 VALUES ('99999316647', CURRVAL('actor.usr_id_seq'));
921 card = CURRVAL('actor.card_id_seq'),
922 billing_address = CURRVAL('actor.usr_address_id_seq'),
923 credit_forward_balance = '0',
924 mailing_address = CURRVAL('actor.usr_address_id_seq')
925 WHERE id=CURRVAL('actor.usr_id_seq');
928 INSERT INTO actor.usr
929 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
930 VALUES (2, 1, '99999389066', 4, 'Ramos', 'annetter1234',
931 'Annette', 'Angela', NOW() + '3 years'::INTERVAL, '1967-11-04', 'II');
933 INSERT INTO actor.usr_address
934 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
935 VALUES ('USA', 'f', '29621', '9196 Old Future Fort', 'f',
936 'SC', 'Anderson', '', 'Anderson', CURRVAL('actor.usr_id_seq'));
938 INSERT INTO actor.card (barcode, usr)
939 VALUES ('99999389066', CURRVAL('actor.usr_id_seq'));
942 card = CURRVAL('actor.card_id_seq'),
943 billing_address = CURRVAL('actor.usr_address_id_seq'),
944 credit_forward_balance = '0',
945 mailing_address = CURRVAL('actor.usr_address_id_seq')
946 WHERE id=CURRVAL('actor.usr_id_seq');
949 INSERT INTO actor.usr
950 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
951 VALUES (2, 1, '99999380162', 8, 'Jackson', 'paulj1234',
952 'Paul', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
954 INSERT INTO actor.usr_address
955 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
956 VALUES ('USA', 't', '77651', '9869 Convention Pine', 't',
957 'TX', 'Port neches', '', 'Jefferson', CURRVAL('actor.usr_id_seq'));
959 INSERT INTO actor.card (barcode, usr)
960 VALUES ('99999380162', CURRVAL('actor.usr_id_seq'));
963 card = CURRVAL('actor.card_id_seq'),
964 billing_address = CURRVAL('actor.usr_address_id_seq'),
965 credit_forward_balance = '0',
966 mailing_address = CURRVAL('actor.usr_address_id_seq')
967 WHERE id=CURRVAL('actor.usr_id_seq');
970 INSERT INTO actor.usr
971 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
972 VALUES (2, 1, '99999318240', 7, 'Graham', 'johng1234',
973 'John', 'Charles', NOW() + '3 years'::INTERVAL, NULL, NULL);
975 INSERT INTO actor.usr_address
976 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
977 VALUES ('USA', 't', '03216', '3676 Sweet Campaign Courts', 'f',
978 'NH', 'Andover', '', 'Merrimack', CURRVAL('actor.usr_id_seq'));
980 INSERT INTO actor.card (barcode, usr)
981 VALUES ('99999318240', CURRVAL('actor.usr_id_seq'));
984 card = CURRVAL('actor.card_id_seq'),
985 billing_address = CURRVAL('actor.usr_address_id_seq'),
986 credit_forward_balance = '0',
987 mailing_address = CURRVAL('actor.usr_address_id_seq')
988 WHERE id=CURRVAL('actor.usr_id_seq');
991 INSERT INTO actor.usr
992 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
993 VALUES (2, 3, '99999347267', 7, 'Michael', 'adamm1234',
994 'Adam', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL);
996 INSERT INTO actor.usr_address
997 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
998 VALUES ('USA', 't', '68113', '7244 Brief Tree Crescent', 'f',
999 'NE', 'Offutt a f b', '', 'Sarpy', CURRVAL('actor.usr_id_seq'));
1001 INSERT INTO actor.card (barcode, usr)
1002 VALUES ('99999347267', CURRVAL('actor.usr_id_seq'));
1004 UPDATE actor.usr SET
1005 card = CURRVAL('actor.card_id_seq'),
1006 billing_address = CURRVAL('actor.usr_address_id_seq'),
1007 credit_forward_balance = '0',
1008 mailing_address = CURRVAL('actor.usr_address_id_seq')
1009 WHERE id=CURRVAL('actor.usr_id_seq');
1012 INSERT INTO actor.usr
1013 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1014 VALUES (2, 3, '99999344618', 7, 'Thomas', 'helent1234',
1015 'Helen', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1017 INSERT INTO actor.usr_address
1018 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1019 VALUES ('USA', 'f', '43534', '5066 Disabled Drink Ford', 'f',
1020 'OH', 'Mc clure', '', 'Henry', CURRVAL('actor.usr_id_seq'));
1022 INSERT INTO actor.card (barcode, usr)
1023 VALUES ('99999344618', CURRVAL('actor.usr_id_seq'));
1025 UPDATE actor.usr SET
1026 card = CURRVAL('actor.card_id_seq'),
1027 billing_address = CURRVAL('actor.usr_address_id_seq'),
1028 credit_forward_balance = '0',
1029 mailing_address = CURRVAL('actor.usr_address_id_seq')
1030 WHERE id=CURRVAL('actor.usr_id_seq');
1033 INSERT INTO actor.usr
1034 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1035 VALUES (2, 1, '99999301966', 7, 'Rivas', 'meghanr1234',
1036 'Meghan', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1038 INSERT INTO actor.usr_address
1039 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1040 VALUES ('USA', 't', '48328', '1604 Other Factor Harbor', 't',
1041 'MI', 'Waterford', '', 'Oakland', CURRVAL('actor.usr_id_seq'));
1043 INSERT INTO actor.card (barcode, usr)
1044 VALUES ('99999301966', CURRVAL('actor.usr_id_seq'));
1046 UPDATE actor.usr SET
1047 card = CURRVAL('actor.card_id_seq'),
1048 billing_address = CURRVAL('actor.usr_address_id_seq'),
1049 credit_forward_balance = '0',
1050 mailing_address = CURRVAL('actor.usr_address_id_seq')
1051 WHERE id=CURRVAL('actor.usr_id_seq');
1054 INSERT INTO actor.usr
1055 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1056 VALUES (2, 3, '99999306663', 5, 'Hurst', 'williamh1234',
1057 'William', 'Ian', NOW() + '3 years'::INTERVAL, NULL, NULL);
1059 INSERT INTO actor.usr_address
1060 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1061 VALUES ('USA', 't', '76937', '7986 Line Grove', 'f',
1062 'TX', 'Eola', '', '', CURRVAL('actor.usr_id_seq'));
1064 INSERT INTO actor.card (barcode, usr)
1065 VALUES ('99999306663', CURRVAL('actor.usr_id_seq'));
1067 UPDATE actor.usr SET
1068 card = CURRVAL('actor.card_id_seq'),
1069 billing_address = CURRVAL('actor.usr_address_id_seq'),
1070 credit_forward_balance = '0',
1071 mailing_address = CURRVAL('actor.usr_address_id_seq')
1072 WHERE id=CURRVAL('actor.usr_id_seq');
1075 INSERT INTO actor.usr
1076 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1077 VALUES (2, 3, '99999329410', 8, 'Bridges', 'kimberlyb1234',
1078 'Kimberly', 'Anna', NOW() + '3 years'::INTERVAL, NULL, NULL);
1080 INSERT INTO actor.usr_address
1081 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1082 VALUES ('USA', 't', '21047', '9992 Show Village', 'f',
1083 'MD', 'Fallston', '', 'Harford', CURRVAL('actor.usr_id_seq'));
1085 INSERT INTO actor.card (barcode, usr)
1086 VALUES ('99999329410', CURRVAL('actor.usr_id_seq'));
1088 UPDATE actor.usr SET
1089 card = CURRVAL('actor.card_id_seq'),
1090 billing_address = CURRVAL('actor.usr_address_id_seq'),
1091 credit_forward_balance = '0',
1092 mailing_address = CURRVAL('actor.usr_address_id_seq')
1093 WHERE id=CURRVAL('actor.usr_id_seq');
1096 INSERT INTO actor.usr
1097 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1098 VALUES (2, 3, '99999396820', 6, 'Stewart', 'beatrices1234',
1099 'Beatrice', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL);
1101 INSERT INTO actor.usr_address
1102 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1103 VALUES ('USA', 't', '64123', '7373 Social Fact Roads', 'f',
1104 'MO', 'Kansas city', '', 'Jackson', CURRVAL('actor.usr_id_seq'));
1106 INSERT INTO actor.card (barcode, usr)
1107 VALUES ('99999396820', CURRVAL('actor.usr_id_seq'));
1109 UPDATE actor.usr SET
1110 card = CURRVAL('actor.card_id_seq'),
1111 billing_address = CURRVAL('actor.usr_address_id_seq'),
1112 credit_forward_balance = '0',
1113 mailing_address = CURRVAL('actor.usr_address_id_seq')
1114 WHERE id=CURRVAL('actor.usr_id_seq');
1117 INSERT INTO actor.usr
1118 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1119 VALUES (2, 3, '99999398998', 7, 'Welsh', 'alejandraw1234',
1120 'Alejandra', 'Christine', NOW() + '3 years'::INTERVAL, '1973-11-18', 'III');
1122 INSERT INTO actor.usr_address
1123 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1124 VALUES ('USA', 't', '91615', '4270 Deafening Speed Stream', 'f',
1125 'CA', 'North hollywood', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
1127 INSERT INTO actor.card (barcode, usr)
1128 VALUES ('99999398998', CURRVAL('actor.usr_id_seq'));
1130 UPDATE actor.usr SET
1131 card = CURRVAL('actor.card_id_seq'),
1132 billing_address = CURRVAL('actor.usr_address_id_seq'),
1133 credit_forward_balance = '0',
1134 mailing_address = CURRVAL('actor.usr_address_id_seq')
1135 WHERE id=CURRVAL('actor.usr_id_seq');
1138 INSERT INTO actor.usr
1139 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1140 VALUES (2, 3, '99999308688', 9, 'Osborne', 'leonao1234',
1141 'Leona', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1143 INSERT INTO actor.usr_address
1144 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1145 VALUES ('USA', 'f', '65261', '1368 Defiant Visit Drive', 'f',
1146 'MO', 'Keytesville', '', 'Chariton', CURRVAL('actor.usr_id_seq'));
1148 INSERT INTO actor.card (barcode, usr)
1149 VALUES ('99999308688', CURRVAL('actor.usr_id_seq'));
1151 UPDATE actor.usr SET
1152 card = CURRVAL('actor.card_id_seq'),
1153 billing_address = CURRVAL('actor.usr_address_id_seq'),
1154 credit_forward_balance = '0',
1155 mailing_address = CURRVAL('actor.usr_address_id_seq')
1156 WHERE id=CURRVAL('actor.usr_id_seq');
1159 INSERT INTO actor.usr
1160 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1161 VALUES (2, 3, '99999321465', 4, 'Sinclair', 'luellas1234',
1162 'Luella', 'Carole', NOW() + '3 years'::INTERVAL, '1993-10-15', 'II');
1164 INSERT INTO actor.usr_address
1165 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1166 VALUES ('USA', 't', '45314', '3011 Thoughtful Law Terrace', 'f',
1167 'OH', 'Cedarville', '', 'Greene', CURRVAL('actor.usr_id_seq'));
1169 INSERT INTO actor.card (barcode, usr)
1170 VALUES ('99999321465', CURRVAL('actor.usr_id_seq'));
1172 UPDATE actor.usr SET
1173 card = CURRVAL('actor.card_id_seq'),
1174 billing_address = CURRVAL('actor.usr_address_id_seq'),
1175 credit_forward_balance = '0',
1176 mailing_address = CURRVAL('actor.usr_address_id_seq')
1177 WHERE id=CURRVAL('actor.usr_id_seq');
1180 INSERT INTO actor.usr
1181 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1182 VALUES (2, 3, '99999399294', 5, 'Jones', 'joej1234',
1183 'Joe', 'Wayne', NOW() + '3 years'::INTERVAL, NULL, NULL);
1185 INSERT INTO actor.usr_address
1186 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1187 VALUES ('USA', 't', '12167', '1641 Jolly Period Bend', 'f',
1188 'NY', 'Stamford', '', 'Delaware', CURRVAL('actor.usr_id_seq'));
1190 INSERT INTO actor.card (barcode, usr)
1191 VALUES ('99999399294', CURRVAL('actor.usr_id_seq'));
1193 UPDATE actor.usr SET
1194 card = CURRVAL('actor.card_id_seq'),
1195 billing_address = CURRVAL('actor.usr_address_id_seq'),
1196 credit_forward_balance = '0',
1197 mailing_address = CURRVAL('actor.usr_address_id_seq')
1198 WHERE id=CURRVAL('actor.usr_id_seq');
1201 INSERT INTO actor.usr
1202 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1203 VALUES (2, 3, '99999355645', 6, 'Duncan', 'willied1234',
1204 'Willie', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1206 INSERT INTO actor.usr_address
1207 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1208 VALUES ('USA', 'f', '34682', '9904 Australian Cash Squares', 'f',
1209 'FL', 'Palm harbor', '', 'Pinellas', CURRVAL('actor.usr_id_seq'));
1211 INSERT INTO actor.card (barcode, usr)
1212 VALUES ('99999355645', CURRVAL('actor.usr_id_seq'));
1214 UPDATE actor.usr SET
1215 card = CURRVAL('actor.card_id_seq'),
1216 billing_address = CURRVAL('actor.usr_address_id_seq'),
1217 credit_forward_balance = '0',
1218 mailing_address = CURRVAL('actor.usr_address_id_seq')
1219 WHERE id=CURRVAL('actor.usr_id_seq');
1222 INSERT INTO actor.usr
1223 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1224 VALUES (2, 3, '99999359616', 6, 'Carney', 'andreac1234',
1225 'Andrea', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1227 INSERT INTO actor.usr_address
1228 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1229 VALUES ('USA', 't', '23442', '9706 Jealous Alternative Fort', 't',
1230 'VA', 'Temperanceville', '', 'Accomack', CURRVAL('actor.usr_id_seq'));
1232 INSERT INTO actor.card (barcode, usr)
1233 VALUES ('99999359616', CURRVAL('actor.usr_id_seq'));
1235 UPDATE actor.usr SET
1236 card = CURRVAL('actor.card_id_seq'),
1237 billing_address = CURRVAL('actor.usr_address_id_seq'),
1238 credit_forward_balance = '0',
1239 mailing_address = CURRVAL('actor.usr_address_id_seq')
1240 WHERE id=CURRVAL('actor.usr_id_seq');
1243 INSERT INTO actor.usr
1244 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1245 VALUES (2, 1, '99999359143', 9, 'Hunt', 'howardh1234',
1246 'Howard', 'Ralph', NOW() + '3 years'::INTERVAL, '1971-05-09', 'Jr');
1248 INSERT INTO actor.usr_address
1249 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1250 VALUES ('USA', 'f', '49337', '1182 Radical Letter Square', 'f',
1251 'MI', 'Newaygo', '', 'Newaygo', CURRVAL('actor.usr_id_seq'));
1253 INSERT INTO actor.card (barcode, usr)
1254 VALUES ('99999359143', CURRVAL('actor.usr_id_seq'));
1256 UPDATE actor.usr SET
1257 card = CURRVAL('actor.card_id_seq'),
1258 billing_address = CURRVAL('actor.usr_address_id_seq'),
1259 credit_forward_balance = '0',
1260 mailing_address = CURRVAL('actor.usr_address_id_seq')
1261 WHERE id=CURRVAL('actor.usr_id_seq');
1264 INSERT INTO actor.usr
1265 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1266 VALUES (2, 3, '99999389009', 6, 'Martin', 'eddiem1234',
1267 'Eddie', 'Anthony', NOW() + '3 years'::INTERVAL, NULL, NULL);
1269 INSERT INTO actor.usr_address
1270 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1271 VALUES ('USA', 'f', '95031', '1938 Fundamental Distribution Lane', 'f',
1272 'CA', 'Los gatos', '', '', CURRVAL('actor.usr_id_seq'));
1274 INSERT INTO actor.card (barcode, usr)
1275 VALUES ('99999389009', CURRVAL('actor.usr_id_seq'));
1277 UPDATE actor.usr SET
1278 card = CURRVAL('actor.card_id_seq'),
1279 billing_address = CURRVAL('actor.usr_address_id_seq'),
1280 credit_forward_balance = '0',
1281 mailing_address = CURRVAL('actor.usr_address_id_seq')
1282 WHERE id=CURRVAL('actor.usr_id_seq');
1285 INSERT INTO actor.usr
1286 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1287 VALUES (2, 1, '99999327461', 9, 'Barry', 'paulb1234',
1288 'Paul', 'Richard', NOW() + '3 years'::INTERVAL, NULL, NULL);
1290 INSERT INTO actor.usr_address
1291 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1292 VALUES ('USA', 't', '40583', '9317 Testy Soil Place', 'f',
1293 'KY', 'Lexington', '', 'Fayette', CURRVAL('actor.usr_id_seq'));
1295 INSERT INTO actor.card (barcode, usr)
1296 VALUES ('99999327461', CURRVAL('actor.usr_id_seq'));
1298 UPDATE actor.usr SET
1299 card = CURRVAL('actor.card_id_seq'),
1300 billing_address = CURRVAL('actor.usr_address_id_seq'),
1301 credit_forward_balance = '0',
1302 mailing_address = CURRVAL('actor.usr_address_id_seq')
1303 WHERE id=CURRVAL('actor.usr_id_seq');
1306 INSERT INTO actor.usr
1307 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1308 VALUES (2, 1, '99999319193', 7, 'Wright', 'dennisw1234',
1309 'Dennis', 'Jimmie', NOW() + '3 years'::INTERVAL, '1992-09-05', 'II');
1311 INSERT INTO actor.usr_address
1312 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1313 VALUES ('USA', 'f', '24925', '7338 Drab Development Underpass', 't',
1314 'WV', 'Caldwell', '', 'Greenbrier', CURRVAL('actor.usr_id_seq'));
1316 INSERT INTO actor.card (barcode, usr)
1317 VALUES ('99999319193', CURRVAL('actor.usr_id_seq'));
1319 UPDATE actor.usr SET
1320 card = CURRVAL('actor.card_id_seq'),
1321 billing_address = CURRVAL('actor.usr_address_id_seq'),
1322 credit_forward_balance = '0',
1323 mailing_address = CURRVAL('actor.usr_address_id_seq')
1324 WHERE id=CURRVAL('actor.usr_id_seq');
1327 INSERT INTO actor.usr
1328 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1329 VALUES (2, 1, '99999378520', 5, 'Saunders', 'rubens1234',
1330 'Ruben', 'Eric', NOW() + '3 years'::INTERVAL, NULL, NULL);
1332 INSERT INTO actor.usr_address
1333 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1334 VALUES ('USA', 'f', '32648', '2941 Conservation Race Haven', 'f',
1335 'FL', 'Horseshoe beach', '', '', CURRVAL('actor.usr_id_seq'));
1337 INSERT INTO actor.card (barcode, usr)
1338 VALUES ('99999378520', CURRVAL('actor.usr_id_seq'));
1340 UPDATE actor.usr SET
1341 card = CURRVAL('actor.card_id_seq'),
1342 billing_address = CURRVAL('actor.usr_address_id_seq'),
1343 credit_forward_balance = '0',
1344 mailing_address = CURRVAL('actor.usr_address_id_seq')
1345 WHERE id=CURRVAL('actor.usr_id_seq');
1348 INSERT INTO actor.usr
1349 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1350 VALUES (2, 3, '99999366196', 7, 'Lane', 'jenniferl1234',
1351 'Jennifer', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1353 INSERT INTO actor.usr_address
1354 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1355 VALUES ('USA', 't', '12456', '5547 Knee Underpass', 'f',
1356 'NY', 'Mount marion', '', 'Ulster', CURRVAL('actor.usr_id_seq'));
1358 INSERT INTO actor.card (barcode, usr)
1359 VALUES ('99999366196', CURRVAL('actor.usr_id_seq'));
1361 UPDATE actor.usr SET
1362 card = CURRVAL('actor.card_id_seq'),
1363 billing_address = CURRVAL('actor.usr_address_id_seq'),
1364 credit_forward_balance = '0',
1365 mailing_address = CURRVAL('actor.usr_address_id_seq')
1366 WHERE id=CURRVAL('actor.usr_id_seq');
1369 INSERT INTO actor.usr
1370 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1371 VALUES (2, 1, '99999324371', 5, 'Madden', 'jom1234',
1372 'Jo', 'Mae', NOW() + '3 years'::INTERVAL, NULL, NULL);
1374 INSERT INTO actor.usr_address
1375 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1376 VALUES ('USA', 'f', '19612', '3125 League Brook', 'f',
1377 'PA', 'Reading', '', 'Berks', CURRVAL('actor.usr_id_seq'));
1379 INSERT INTO actor.card (barcode, usr)
1380 VALUES ('99999324371', CURRVAL('actor.usr_id_seq'));
1382 UPDATE actor.usr SET
1383 card = CURRVAL('actor.card_id_seq'),
1384 billing_address = CURRVAL('actor.usr_address_id_seq'),
1385 credit_forward_balance = '0',
1386 mailing_address = CURRVAL('actor.usr_address_id_seq')
1387 WHERE id=CURRVAL('actor.usr_id_seq');
1390 INSERT INTO actor.usr
1391 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1392 VALUES (2, 3, '99999316280', 8, 'Harding', 'naomih1234',
1393 'Naomi', 'Julie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1395 INSERT INTO actor.usr_address
1396 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1397 VALUES ('USA', 't', '93021', '6693 Thin Entry Lake', 't',
1398 'CA', 'Moorpark', '', 'Ventura', CURRVAL('actor.usr_id_seq'));
1400 INSERT INTO actor.card (barcode, usr)
1401 VALUES ('99999316280', CURRVAL('actor.usr_id_seq'));
1403 UPDATE actor.usr SET
1404 card = CURRVAL('actor.card_id_seq'),
1405 billing_address = CURRVAL('actor.usr_address_id_seq'),
1406 credit_forward_balance = '0',
1407 mailing_address = CURRVAL('actor.usr_address_id_seq')
1408 WHERE id=CURRVAL('actor.usr_id_seq');
1411 INSERT INTO actor.usr
1412 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1413 VALUES (2, 3, '99999388575', 5, 'Davis', 'blaked1234',
1414 'Blake', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL);
1416 INSERT INTO actor.usr_address
1417 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1418 VALUES ('USA', 't', '13856', '8634 Need Bridge', 'f',
1419 'NY', 'Walton', '', '', CURRVAL('actor.usr_id_seq'));
1421 INSERT INTO actor.card (barcode, usr)
1422 VALUES ('99999388575', CURRVAL('actor.usr_id_seq'));
1424 UPDATE actor.usr SET
1425 card = CURRVAL('actor.card_id_seq'),
1426 billing_address = CURRVAL('actor.usr_address_id_seq'),
1427 credit_forward_balance = '0',
1428 mailing_address = CURRVAL('actor.usr_address_id_seq')
1429 WHERE id=CURRVAL('actor.usr_id_seq');
1432 INSERT INTO actor.usr
1433 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1434 VALUES (2, 3, '99999336610', 4, 'Barnes', 'normab1234',
1435 'Norma', 'Gail', NOW() + '3 years'::INTERVAL, NOW() + '3 years'::INTERVAL, '');
1437 INSERT INTO actor.usr_address
1438 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1439 VALUES ('USA', 't', '23107', '218 Region River', 'f',
1440 'VA', 'Maryus', '', 'Gloucester', CURRVAL('actor.usr_id_seq'));
1442 INSERT INTO actor.card (barcode, usr)
1443 VALUES ('99999336610', CURRVAL('actor.usr_id_seq'));
1445 UPDATE actor.usr SET
1446 card = CURRVAL('actor.card_id_seq'),
1447 billing_address = CURRVAL('actor.usr_address_id_seq'),
1448 credit_forward_balance = '0',
1449 mailing_address = CURRVAL('actor.usr_address_id_seq')
1450 WHERE id=CURRVAL('actor.usr_id_seq');
1453 INSERT INTO actor.usr
1454 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1455 VALUES (2, 3, '99999376864', 4, 'Anderson', 'leona1234',
1456 'Leon', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1458 INSERT INTO actor.usr_address
1459 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1460 VALUES ('USA', 'f', '27315', '9834 Standard Stravenue', 'f',
1461 'NC', 'Providence', '', '', CURRVAL('actor.usr_id_seq'));
1463 INSERT INTO actor.card (barcode, usr)
1464 VALUES ('99999376864', CURRVAL('actor.usr_id_seq'));
1466 UPDATE actor.usr SET
1467 card = CURRVAL('actor.card_id_seq'),
1468 billing_address = CURRVAL('actor.usr_address_id_seq'),
1469 credit_forward_balance = '0',
1470 mailing_address = CURRVAL('actor.usr_address_id_seq')
1471 WHERE id=CURRVAL('actor.usr_id_seq');
1474 INSERT INTO actor.usr
1475 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1476 VALUES (2, 1, '99999391951', 7, 'Gillespie', 'mistyg1234',
1477 'Misty', 'Margaret', NOW() + '3 years'::INTERVAL, '1993-10-19', 'III');
1479 INSERT INTO actor.usr_address
1480 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1481 VALUES ('USA', 't', '47273', '4151 Severe Look Fort', 'f',
1482 'IN', 'Scipio', '', 'Jennings', CURRVAL('actor.usr_id_seq'));
1484 INSERT INTO actor.card (barcode, usr)
1485 VALUES ('99999391951', CURRVAL('actor.usr_id_seq'));
1487 UPDATE actor.usr SET
1488 card = CURRVAL('actor.card_id_seq'),
1489 billing_address = CURRVAL('actor.usr_address_id_seq'),
1490 credit_forward_balance = '0',
1491 mailing_address = CURRVAL('actor.usr_address_id_seq')
1492 WHERE id=CURRVAL('actor.usr_id_seq');
1495 INSERT INTO actor.usr
1496 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1497 VALUES (2, 3, '99999368950', 7, 'Santos', 'esthers1234',
1498 'Esther', 'Mary', NOW() + '3 years'::INTERVAL, '1961-12-17', 'Sr');
1500 INSERT INTO actor.usr_address
1501 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1502 VALUES ('USA', 'f', '06468', '2774 Melted Stone Islands', 'f',
1503 'CT', 'Monroe', '', 'Fairfield', CURRVAL('actor.usr_id_seq'));
1505 INSERT INTO actor.card (barcode, usr)
1506 VALUES ('99999368950', CURRVAL('actor.usr_id_seq'));
1508 UPDATE actor.usr SET
1509 card = CURRVAL('actor.card_id_seq'),
1510 billing_address = CURRVAL('actor.usr_address_id_seq'),
1511 credit_forward_balance = '0',
1512 mailing_address = CURRVAL('actor.usr_address_id_seq')
1513 WHERE id=CURRVAL('actor.usr_id_seq');
1516 INSERT INTO actor.usr
1517 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1518 VALUES (2, 3, '99999343281', 7, 'Bradley', 'rebeccab1234',
1519 'Rebecca', 'Vanessa', NOW() + '3 years'::INTERVAL, NULL, NULL);
1521 INSERT INTO actor.usr_address
1522 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1523 VALUES ('USA', 'f', '66948', '5933 Changing Terms Pike', 'f',
1524 'KS', 'Jamestown', '', 'Cloud', CURRVAL('actor.usr_id_seq'));
1526 INSERT INTO actor.card (barcode, usr)
1527 VALUES ('99999343281', CURRVAL('actor.usr_id_seq'));
1529 UPDATE actor.usr SET
1530 card = CURRVAL('actor.card_id_seq'),
1531 billing_address = CURRVAL('actor.usr_address_id_seq'),
1532 credit_forward_balance = '0',
1533 mailing_address = CURRVAL('actor.usr_address_id_seq')
1534 WHERE id=CURRVAL('actor.usr_id_seq');
1537 INSERT INTO actor.usr
1538 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1539 VALUES (2, 1, '99999394534', 4, 'Hart', 'victorh1234',
1540 'Victor', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1542 INSERT INTO actor.usr_address
1543 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1544 VALUES ('USA', 't', '16833', '677 Breezy Agreement Mountain', 'f',
1545 'PA', 'Curwensville', '', 'Clearfield', CURRVAL('actor.usr_id_seq'));
1547 INSERT INTO actor.card (barcode, usr)
1548 VALUES ('99999394534', CURRVAL('actor.usr_id_seq'));
1550 UPDATE actor.usr SET
1551 card = CURRVAL('actor.card_id_seq'),
1552 billing_address = CURRVAL('actor.usr_address_id_seq'),
1553 credit_forward_balance = '0',
1554 mailing_address = CURRVAL('actor.usr_address_id_seq')
1555 WHERE id=CURRVAL('actor.usr_id_seq');
1558 INSERT INTO actor.usr
1559 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1560 VALUES (2, 1, '99999323404', 8, 'Riley', 'edwardr1234',
1561 'Edward', 'Lonnie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1563 INSERT INTO actor.usr_address
1564 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1565 VALUES ('USA', 'f', '84412', '5806 Metropolitan Problem Annex', 'f',
1566 'UT', 'Ogden', '', 'Weber', CURRVAL('actor.usr_id_seq'));
1568 INSERT INTO actor.card (barcode, usr)
1569 VALUES ('99999323404', CURRVAL('actor.usr_id_seq'));
1571 UPDATE actor.usr SET
1572 card = CURRVAL('actor.card_id_seq'),
1573 billing_address = CURRVAL('actor.usr_address_id_seq'),
1574 credit_forward_balance = '0',
1575 mailing_address = CURRVAL('actor.usr_address_id_seq')
1576 WHERE id=CURRVAL('actor.usr_id_seq');
1579 INSERT INTO actor.usr
1580 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1581 VALUES (2, 3, '99999375760', 5, 'Jordan', 'michellej1234',
1582 'Michelle', '', NOW() + '3 years'::INTERVAL, '1973-05-07', 'III');
1584 INSERT INTO actor.usr_address
1585 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1586 VALUES ('USA', 'f', '46970', '8951 Great Arrangement Mills', 'f',
1587 'IN', 'Peru', '', 'Miami', CURRVAL('actor.usr_id_seq'));
1589 INSERT INTO actor.card (barcode, usr)
1590 VALUES ('99999375760', CURRVAL('actor.usr_id_seq'));
1592 UPDATE actor.usr SET
1593 card = CURRVAL('actor.card_id_seq'),
1594 billing_address = CURRVAL('actor.usr_address_id_seq'),
1595 credit_forward_balance = '0',
1596 mailing_address = CURRVAL('actor.usr_address_id_seq')
1597 WHERE id=CURRVAL('actor.usr_id_seq');
1600 INSERT INTO actor.usr
1601 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1602 VALUES (2, 1, '99999315742', 7, 'Brown', 'maryb1234',
1603 'Mary', 'Jill', NOW() + '3 years'::INTERVAL, NULL, NULL);
1605 INSERT INTO actor.usr_address
1606 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1607 VALUES ('USA', 'f', '75663', '4845 Boat Course', 'f',
1608 'TX', 'Kilgore', '', 'Gregg', CURRVAL('actor.usr_id_seq'));
1610 INSERT INTO actor.card (barcode, usr)
1611 VALUES ('99999315742', CURRVAL('actor.usr_id_seq'));
1613 UPDATE actor.usr SET
1614 card = CURRVAL('actor.card_id_seq'),
1615 billing_address = CURRVAL('actor.usr_address_id_seq'),
1616 credit_forward_balance = '0',
1617 mailing_address = CURRVAL('actor.usr_address_id_seq')
1618 WHERE id=CURRVAL('actor.usr_id_seq');
1621 INSERT INTO actor.usr
1622 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1623 VALUES (2, 1, '99999322514', 7, 'Barber', 'shawnb1234',
1624 'Shawn', 'Thomas', NOW() + '3 years'::INTERVAL, '1988-10-21', 'II');
1626 INSERT INTO actor.usr_address
1627 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1628 VALUES ('USA', 't', '98464', '7111 Accurate Talk Canyon', 't',
1629 'WA', 'Tacoma', '', 'Pierce', CURRVAL('actor.usr_id_seq'));
1631 INSERT INTO actor.card (barcode, usr)
1632 VALUES ('99999322514', CURRVAL('actor.usr_id_seq'));
1634 UPDATE actor.usr SET
1635 card = CURRVAL('actor.card_id_seq'),
1636 billing_address = CURRVAL('actor.usr_address_id_seq'),
1637 credit_forward_balance = '0',
1638 mailing_address = CURRVAL('actor.usr_address_id_seq')
1639 WHERE id=CURRVAL('actor.usr_id_seq');
1642 INSERT INTO actor.usr
1643 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1644 VALUES (2, 1, '99999342144', 8, 'Harrison', 'williamh1234',
1645 'William', 'Phillip', NOW() + '3 years'::INTERVAL, '1990-04-09', 'II');
1647 INSERT INTO actor.usr_address
1648 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1649 VALUES ('USA', 'f', '79085', '9798 Marked West Fork', 't',
1650 'TX', 'Summerfield', '', 'Castro', CURRVAL('actor.usr_id_seq'));
1652 INSERT INTO actor.card (barcode, usr)
1653 VALUES ('99999342144', CURRVAL('actor.usr_id_seq'));
1655 UPDATE actor.usr SET
1656 card = CURRVAL('actor.card_id_seq'),
1657 billing_address = CURRVAL('actor.usr_address_id_seq'),
1658 credit_forward_balance = '0',
1659 mailing_address = CURRVAL('actor.usr_address_id_seq')
1660 WHERE id=CURRVAL('actor.usr_id_seq');
1663 INSERT INTO actor.usr
1664 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1665 VALUES (2, 1, '99999320546', 7, 'Porter', 'darlenep1234',
1666 'Darlene', 'Lisa', NOW() + '3 years'::INTERVAL, '1987-02-23', 'Jr');
1668 INSERT INTO actor.usr_address
1669 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1670 VALUES ('USA', 't', '24910', '3522 Channel Radial', 'f',
1671 'WV', 'Alderson', '', 'Monroe', CURRVAL('actor.usr_id_seq'));
1673 INSERT INTO actor.card (barcode, usr)
1674 VALUES ('99999320546', CURRVAL('actor.usr_id_seq'));
1676 UPDATE actor.usr SET
1677 card = CURRVAL('actor.card_id_seq'),
1678 billing_address = CURRVAL('actor.usr_address_id_seq'),
1679 credit_forward_balance = '0',
1680 mailing_address = CURRVAL('actor.usr_address_id_seq')
1681 WHERE id=CURRVAL('actor.usr_id_seq');
1684 INSERT INTO actor.usr
1685 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1686 VALUES (2, 3, '99999315474', 8, 'Lopez', 'joycel1234',
1687 'Joyce', 'Donna', NOW() + '3 years'::INTERVAL, '1980-06-28', 'Sr');
1689 INSERT INTO actor.usr_address
1690 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1691 VALUES ('USA', 't', '89101', '9734 Civilian Position Hollow', 'f',
1692 'NV', 'Las vegas', '', 'Clark', CURRVAL('actor.usr_id_seq'));
1694 INSERT INTO actor.card (barcode, usr)
1695 VALUES ('99999315474', CURRVAL('actor.usr_id_seq'));
1697 UPDATE actor.usr SET
1698 card = CURRVAL('actor.card_id_seq'),
1699 billing_address = CURRVAL('actor.usr_address_id_seq'),
1700 credit_forward_balance = '0',
1701 mailing_address = CURRVAL('actor.usr_address_id_seq')
1702 WHERE id=CURRVAL('actor.usr_id_seq');
1705 INSERT INTO actor.usr
1706 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1707 VALUES (2, 1, '99999371586', 9, 'Stevenson', 'larrys1234',
1708 'Larry', '', NOW() + '3 years'::INTERVAL, '1990-12-20', 'Sr');
1710 INSERT INTO actor.usr_address
1711 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1712 VALUES ('USA', 't', '46241', '5799 Constitutional Roof Groves', 'f',
1713 'IN', 'Indianapolis', '', 'Marion', CURRVAL('actor.usr_id_seq'));
1715 INSERT INTO actor.card (barcode, usr)
1716 VALUES ('99999371586', CURRVAL('actor.usr_id_seq'));
1718 UPDATE actor.usr SET
1719 card = CURRVAL('actor.card_id_seq'),
1720 billing_address = CURRVAL('actor.usr_address_id_seq'),
1721 credit_forward_balance = '0',
1722 mailing_address = CURRVAL('actor.usr_address_id_seq')
1723 WHERE id=CURRVAL('actor.usr_id_seq');
1726 INSERT INTO actor.usr
1727 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1728 VALUES (2, 1, '99999329832', 4, 'Kinney', 'nicholask1234',
1729 'Nicholas', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1731 INSERT INTO actor.usr_address
1732 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1733 VALUES ('USA', 't', '90606', '411 Preliminary Library Square', 't',
1734 'CA', 'Whittier', '', 'Los angeles', CURRVAL('actor.usr_id_seq'));
1736 INSERT INTO actor.card (barcode, usr)
1737 VALUES ('99999329832', CURRVAL('actor.usr_id_seq'));
1739 UPDATE actor.usr SET
1740 card = CURRVAL('actor.card_id_seq'),
1741 billing_address = CURRVAL('actor.usr_address_id_seq'),
1742 credit_forward_balance = '0',
1743 mailing_address = CURRVAL('actor.usr_address_id_seq')
1744 WHERE id=CURRVAL('actor.usr_id_seq');
1747 INSERT INTO actor.usr
1748 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1749 VALUES (2, 3, '99999342948', 5, 'Bernard', 'omarb1234',
1750 'Omar', 'David', NOW() + '3 years'::INTERVAL, '1981-08-19', 'Jr');
1752 INSERT INTO actor.usr_address
1753 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1754 VALUES ('USA', 'f', '41567', '2546 Marvellous Index Ways', 'f',
1755 'KY', 'Stone', '', 'Pike', CURRVAL('actor.usr_id_seq'));
1757 INSERT INTO actor.card (barcode, usr)
1758 VALUES ('99999342948', CURRVAL('actor.usr_id_seq'));
1760 UPDATE actor.usr SET
1761 card = CURRVAL('actor.card_id_seq'),
1762 billing_address = CURRVAL('actor.usr_address_id_seq'),
1763 credit_forward_balance = '0',
1764 mailing_address = CURRVAL('actor.usr_address_id_seq')
1765 WHERE id=CURRVAL('actor.usr_id_seq');
1768 INSERT INTO actor.usr
1769 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1770 VALUES (2, 3, '99999335091', 9, 'Brown', 'maryb1234',
1771 'Mary', 'Annie', NOW() + '3 years'::INTERVAL, NULL, NULL);
1773 INSERT INTO actor.usr_address
1774 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1775 VALUES ('USA', 't', '07630', '48 Look Ridge', 'f',
1776 'NJ', 'Emerson', '', '', CURRVAL('actor.usr_id_seq'));
1778 INSERT INTO actor.card (barcode, usr)
1779 VALUES ('99999335091', CURRVAL('actor.usr_id_seq'));
1781 UPDATE actor.usr SET
1782 card = CURRVAL('actor.card_id_seq'),
1783 billing_address = CURRVAL('actor.usr_address_id_seq'),
1784 credit_forward_balance = '0',
1785 mailing_address = CURRVAL('actor.usr_address_id_seq')
1786 WHERE id=CURRVAL('actor.usr_id_seq');
1789 INSERT INTO actor.usr
1790 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1791 VALUES (2, 3, '99999303411', 8, 'Smith', 'sarahs1234',
1792 'Sarah', '', NOW() + '3 years'::INTERVAL, '1990-01-13', 'II');
1794 INSERT INTO actor.usr_address
1795 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1796 VALUES ('USA', 'f', '34972', '845 Relative Dress Mall', 'f',
1797 'FL', 'Okeechobee', '', 'Okeechobee', CURRVAL('actor.usr_id_seq'));
1799 INSERT INTO actor.card (barcode, usr)
1800 VALUES ('99999303411', CURRVAL('actor.usr_id_seq'));
1802 UPDATE actor.usr SET
1803 card = CURRVAL('actor.card_id_seq'),
1804 billing_address = CURRVAL('actor.usr_address_id_seq'),
1805 credit_forward_balance = '0',
1806 mailing_address = CURRVAL('actor.usr_address_id_seq')
1807 WHERE id=CURRVAL('actor.usr_id_seq');
1810 INSERT INTO actor.usr
1811 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1812 VALUES (2, 1, '99999327083', 8, 'Jones', 'coraj1234',
1813 'Cora', '', NOW() + '3 years'::INTERVAL, NULL, NULL);
1815 INSERT INTO actor.usr_address
1816 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1817 VALUES ('USA', 't', '65262', '9202 Tight Subject Highway', 'f',
1818 'MO', 'Kingdom city', '', '', CURRVAL('actor.usr_id_seq'));
1820 INSERT INTO actor.card (barcode, usr)
1821 VALUES ('99999327083', CURRVAL('actor.usr_id_seq'));
1823 UPDATE actor.usr SET
1824 card = CURRVAL('actor.card_id_seq'),
1825 billing_address = CURRVAL('actor.usr_address_id_seq'),
1826 credit_forward_balance = '0',
1827 mailing_address = CURRVAL('actor.usr_address_id_seq')
1828 WHERE id=CURRVAL('actor.usr_id_seq');
1831 INSERT INTO actor.usr
1832 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1833 VALUES (2, 3, '99999300523', 7, 'Little', 'shawnl1234',
1834 'Shawn', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, NULL);
1836 INSERT INTO actor.usr_address
1837 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1838 VALUES ('USA', 'f', '86343', '8169 Vast Passage Key', 'f',
1839 'AZ', 'Crown king', '', 'Yavapai', CURRVAL('actor.usr_id_seq'));
1841 INSERT INTO actor.card (barcode, usr)
1842 VALUES ('99999300523', CURRVAL('actor.usr_id_seq'));
1844 UPDATE actor.usr SET
1845 card = CURRVAL('actor.card_id_seq'),
1846 billing_address = CURRVAL('actor.usr_address_id_seq'),
1847 credit_forward_balance = '0',
1848 mailing_address = CURRVAL('actor.usr_address_id_seq')
1849 WHERE id=CURRVAL('actor.usr_id_seq');
1852 INSERT INTO actor.usr
1853 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1854 VALUES (2, 3, '99999328829', 6, 'Thurman', 'luannt1234',
1855 'Luann', 'Donna', NOW() + '3 years'::INTERVAL, NULL, NULL);
1857 INSERT INTO actor.usr_address
1858 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1859 VALUES ('USA', 't', '63463', '1967 Interesting Court Ford', 'f',
1860 'MO', 'Philadelphia', '', 'Marion', CURRVAL('actor.usr_id_seq'));
1862 INSERT INTO actor.card (barcode, usr)
1863 VALUES ('99999328829', CURRVAL('actor.usr_id_seq'));
1865 UPDATE actor.usr SET
1866 card = CURRVAL('actor.card_id_seq'),
1867 billing_address = CURRVAL('actor.usr_address_id_seq'),
1868 credit_forward_balance = '0',
1869 mailing_address = CURRVAL('actor.usr_address_id_seq')
1870 WHERE id=CURRVAL('actor.usr_id_seq');
1873 INSERT INTO actor.usr
1874 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1875 VALUES (2, 3, '99999394673', 6, 'Scott', 'patricias1234',
1876 'Patricia', 'Robin', NOW() + '3 years'::INTERVAL, NULL, NULL);
1878 INSERT INTO actor.usr_address
1879 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1880 VALUES ('USA', 't', '44241', '8955 Due Population Alley', 'f',
1881 'OH', 'Streetsboro', '', 'Portage', CURRVAL('actor.usr_id_seq'));
1883 INSERT INTO actor.card (barcode, usr)
1884 VALUES ('99999394673', CURRVAL('actor.usr_id_seq'));
1886 UPDATE actor.usr SET
1887 card = CURRVAL('actor.card_id_seq'),
1888 billing_address = CURRVAL('actor.usr_address_id_seq'),
1889 credit_forward_balance = '0',
1890 mailing_address = CURRVAL('actor.usr_address_id_seq')
1891 WHERE id=CURRVAL('actor.usr_id_seq');
1894 INSERT INTO actor.usr
1895 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1896 VALUES (2, 1, '99999355318', 5, 'Lamb', 'esperanzal1234',
1897 'Esperanza', 'Beth', NOW() + '3 years'::INTERVAL, '1995-06-13', 'III');
1899 INSERT INTO actor.usr_address
1900 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1901 VALUES ('USA', 'f', '05501', '9042 Just Show Turnpike', 'f',
1902 'MA', 'Andover', '', 'Essex', CURRVAL('actor.usr_id_seq'));
1904 INSERT INTO actor.card (barcode, usr)
1905 VALUES ('99999355318', CURRVAL('actor.usr_id_seq'));
1907 UPDATE actor.usr SET
1908 card = CURRVAL('actor.card_id_seq'),
1909 billing_address = CURRVAL('actor.usr_address_id_seq'),
1910 credit_forward_balance = '0',
1911 mailing_address = CURRVAL('actor.usr_address_id_seq')
1912 WHERE id=CURRVAL('actor.usr_id_seq');
1915 INSERT INTO actor.usr
1916 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1917 VALUES (2, 1, '99999377675', 8, 'Brown', 'wendib1234',
1918 'Wendi', 'Mary', NOW() + '3 years'::INTERVAL, NULL, NULL);
1920 INSERT INTO actor.usr_address
1921 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1922 VALUES ('USA', 'f', '37721', '7546 Rude Agreement Highway', 'f',
1923 'TN', 'Corryton', '', 'Knox', CURRVAL('actor.usr_id_seq'));
1925 INSERT INTO actor.card (barcode, usr)
1926 VALUES ('99999377675', CURRVAL('actor.usr_id_seq'));
1928 UPDATE actor.usr SET
1929 card = CURRVAL('actor.card_id_seq'),
1930 billing_address = CURRVAL('actor.usr_address_id_seq'),
1931 credit_forward_balance = '0',
1932 mailing_address = CURRVAL('actor.usr_address_id_seq')
1933 WHERE id=CURRVAL('actor.usr_id_seq');
1936 INSERT INTO actor.usr
1937 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1938 VALUES (2, 3, '99999363186', 5, 'Clarke', 'lawrencec1234',
1939 'Lawrence', 'Vern', NOW() + '3 years'::INTERVAL, NULL, NULL);
1941 INSERT INTO actor.usr_address
1942 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1943 VALUES ('USA', 't', '76234', '7903 Surprised Rule Loop', 'f',
1944 'TX', 'Decatur', '', 'Wise', CURRVAL('actor.usr_id_seq'));
1946 INSERT INTO actor.card (barcode, usr)
1947 VALUES ('99999363186', CURRVAL('actor.usr_id_seq'));
1949 UPDATE actor.usr SET
1950 card = CURRVAL('actor.card_id_seq'),
1951 billing_address = CURRVAL('actor.usr_address_id_seq'),
1952 credit_forward_balance = '0',
1953 mailing_address = CURRVAL('actor.usr_address_id_seq')
1954 WHERE id=CURRVAL('actor.usr_id_seq');
1957 INSERT INTO actor.usr
1958 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1959 VALUES (2, 1, '99999346314', 8, 'Clark', 'danielc1234',
1960 'Daniel', 'Ricky', NOW() + '3 years'::INTERVAL, NULL, NULL);
1962 INSERT INTO actor.usr_address
1963 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1964 VALUES ('USA', 't', '70706', '8604 Defensive Case Trace', 't',
1965 'LA', 'Denham springs', '', '', CURRVAL('actor.usr_id_seq'));
1967 INSERT INTO actor.card (barcode, usr)
1968 VALUES ('99999346314', CURRVAL('actor.usr_id_seq'));
1970 UPDATE actor.usr SET
1971 card = CURRVAL('actor.card_id_seq'),
1972 billing_address = CURRVAL('actor.usr_address_id_seq'),
1973 credit_forward_balance = '0',
1974 mailing_address = CURRVAL('actor.usr_address_id_seq')
1975 WHERE id=CURRVAL('actor.usr_id_seq');
1978 INSERT INTO actor.usr
1979 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
1980 VALUES (2, 1, '99999353477', 6, 'Dennis', 'johnd1234',
1981 'John', 'Robert', NOW() + '3 years'::INTERVAL, '1975-03-04', NULL);
1983 INSERT INTO actor.usr_address
1984 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
1985 VALUES ('USA', 't', '14480', '8712 Legislative Box Shore', 'f',
1986 'NY', 'Lakeville', '', 'Livingston', CURRVAL('actor.usr_id_seq'));
1988 INSERT INTO actor.card (barcode, usr)
1989 VALUES ('99999353477', CURRVAL('actor.usr_id_seq'));
1991 UPDATE actor.usr SET
1992 card = CURRVAL('actor.card_id_seq'),
1993 billing_address = CURRVAL('actor.usr_address_id_seq'),
1994 credit_forward_balance = '0',
1995 mailing_address = CURRVAL('actor.usr_address_id_seq')
1996 WHERE id=CURRVAL('actor.usr_id_seq');
1999 INSERT INTO actor.usr
2000 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2001 VALUES (2, 1, '99999312358', 4, 'Copeland', 'janc1234',
2002 'Jan', 'Lindsey', NOW() + '3 years'::INTERVAL, '1998-06-14', 'Jr');
2004 INSERT INTO actor.usr_address
2005 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2006 VALUES ('USA', 'f', '83204', '6713 River Bridge', 'f',
2007 'ID', 'Pocatello', '', 'Bannock', CURRVAL('actor.usr_id_seq'));
2009 INSERT INTO actor.card (barcode, usr)
2010 VALUES ('99999312358', CURRVAL('actor.usr_id_seq'));
2012 UPDATE actor.usr SET
2013 card = CURRVAL('actor.card_id_seq'),
2014 billing_address = CURRVAL('actor.usr_address_id_seq'),
2015 credit_forward_balance = '0',
2016 mailing_address = CURRVAL('actor.usr_address_id_seq')
2017 WHERE id=CURRVAL('actor.usr_id_seq');
2020 INSERT INTO actor.usr
2021 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2022 VALUES (2, 1, '99999360839', 8, 'Brooks', 'pennyb1234',
2023 'Penny', 'Martha', NOW() + '3 years'::INTERVAL, '1980-03-13', 'II');
2025 INSERT INTO actor.usr_address
2026 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2027 VALUES ('USA', 't', '79120', '8208 Death Ramp', 'f',
2028 'TX', 'Amarillo', '', 'Potter', CURRVAL('actor.usr_id_seq'));
2030 INSERT INTO actor.card (barcode, usr)
2031 VALUES ('99999360839', CURRVAL('actor.usr_id_seq'));
2033 UPDATE actor.usr SET
2034 card = CURRVAL('actor.card_id_seq'),
2035 billing_address = CURRVAL('actor.usr_address_id_seq'),
2036 credit_forward_balance = '0',
2037 mailing_address = CURRVAL('actor.usr_address_id_seq')
2038 WHERE id=CURRVAL('actor.usr_id_seq');
2041 INSERT INTO actor.usr
2042 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2043 VALUES (2, 3, '99999342446', 8, 'Johnson', 'jeannej1234',
2044 'Jeanne', '', NOW() + '3 years'::INTERVAL, '1980-02-03', NULL);
2046 INSERT INTO actor.usr_address
2047 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2048 VALUES ('USA', 't', '85036', '9634 Tough Division Junction', 't',
2049 'AZ', 'Phoenix', '', '', CURRVAL('actor.usr_id_seq'));
2051 INSERT INTO actor.card (barcode, usr)
2052 VALUES ('99999342446', CURRVAL('actor.usr_id_seq'));
2054 UPDATE actor.usr SET
2055 card = CURRVAL('actor.card_id_seq'),
2056 billing_address = CURRVAL('actor.usr_address_id_seq'),
2057 credit_forward_balance = '0',
2058 mailing_address = CURRVAL('actor.usr_address_id_seq')
2059 WHERE id=CURRVAL('actor.usr_id_seq');
2062 INSERT INTO actor.usr
2063 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2064 VALUES (2, 1, '99999358416', 4, 'Sanford', 'elizabeths1234',
2065 'Elizabeth', 'Vanessa', NOW() + '3 years'::INTERVAL, NULL, '');
2067 INSERT INTO actor.usr_address
2068 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2069 VALUES ('USA', 't', '98357', '6767 Application Course', 'f',
2070 'WA', 'Neah bay', '', 'Clallam', CURRVAL('actor.usr_id_seq'));
2072 INSERT INTO actor.card (barcode, usr)
2073 VALUES ('99999358416', CURRVAL('actor.usr_id_seq'));
2075 UPDATE actor.usr SET
2076 card = CURRVAL('actor.card_id_seq'),
2077 billing_address = CURRVAL('actor.usr_address_id_seq'),
2078 credit_forward_balance = '0',
2079 mailing_address = CURRVAL('actor.usr_address_id_seq')
2080 WHERE id=CURRVAL('actor.usr_id_seq');
2083 INSERT INTO actor.usr
2084 (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix)
2085 VALUES (2, 3, '99999361389', 9, 'Ramirez', 'alanr1234',
2086 'Alan', 'Claude', NOW() + '3 years'::INTERVAL, NULL, '');
2088 INSERT INTO actor.usr_address
2089 (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr)
2090 VALUES ('USA', 't', '76060', '9964 Skinny Party Orchard', 't',
2091 'TX', 'Kennedale', '', 'Tarrant', CURRVAL('actor.usr_id_seq'));
2093 INSERT INTO actor.card (barcode, usr)
2094 VALUES ('99999361389', CURRVAL('actor.usr_id_seq'));
2096 UPDATE actor.usr SET
2097 card = CURRVAL('actor.card_id_seq'),
2098 billing_address = CURRVAL('actor.usr_address_id_seq'),
2099 credit_forward_balance = '0',
2100 mailing_address = CURRVAL('actor.usr_address_id_seq')
2101 WHERE id=CURRVAL('actor.usr_id_seq');