From dbb578056f0eea166b54e5b8ceec89f0233eef32 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 24 Oct 2012 11:05:42 -0400 Subject: [PATCH] Give most users NULL dobs and suffixes. Some users retain '' suffixes and others have more realisitic suffixes. Signed-off-by: Bill Erickson --- Open-ILS/tests/datasets/sql/users_patrons_100.sql | 144 +++++++------- Open-ILS/tests/datasets/sql/users_staff_134.sql | 218 +++++++++++----------- 2 files changed, 181 insertions(+), 181 deletions(-) diff --git a/Open-ILS/tests/datasets/sql/users_patrons_100.sql b/Open-ILS/tests/datasets/sql/users_patrons_100.sql index 4401fe04c6..65d64addcc 100644 --- a/Open-ILS/tests/datasets/sql/users_patrons_100.sql +++ b/Open-ILS/tests/datasets/sql/users_patrons_100.sql @@ -3,7 +3,7 @@ INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999395390', 9, 'Brooks', 'terrib1234', - 'Terri', 'Maria', '2008-01-01', '1973-03-17', ''); + 'Terri', 'Maria', '2008-01-01', NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -25,7 +25,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999320945', 5, 'Jackson', 'shannonj1234', - 'Shannon', 'Thomas', '1999-01-01', '1981-11-20', ''); + 'Shannon', 'Thomas', '1999-01-01', NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -46,7 +46,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999355250', 5, 'Jones', 'gregoryj1234', - 'Gregory', '', NOW() + '3 years'::INTERVAL, '1967-05-24', ''); + 'Gregory', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -67,7 +67,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999387993', 9, 'Moran', 'vincentm1234', - 'Vincent', 'Kenneth', NOW() + '3 years'::INTERVAL, '1996-05-28', ''); + 'Vincent', 'Kenneth', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -88,7 +88,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999335859', 8, 'Jones', 'gregoryj1234', - 'Gregory', 'Adam', NOW() + '3 years'::INTERVAL, '1987-03-06', ''); + 'Gregory', 'Adam', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -109,7 +109,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999373186', 7, 'Walker', 'brittanyw1234', - 'Brittany', 'Geraldine', NOW() + '3 years'::INTERVAL, '1995-02-20', ''); + 'Brittany', 'Geraldine', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -151,7 +151,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999373998', 9, 'Hill', 'roberth1234', - 'Robert', 'Louis', NOW() + '3 years'::INTERVAL, '1998-05-02', 'III'); + 'Robert', 'Louis', NOW() + '3 years'::INTERVAL, NULL, 'III'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -172,7 +172,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999376669', 7, 'Lopez', 'edwardl1234', - 'Edward', 'Robert', NOW() + '3 years'::INTERVAL, '1994-08-21', 'II'); + 'Edward', 'Robert', NOW() + '3 years'::INTERVAL, NULL, 'II'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -193,7 +193,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999361076', 8, 'Bell', 'andrewb1234', - 'Andrew', 'Alberto', NOW() + '3 years'::INTERVAL, '1999-04-16', 'II'); + 'Andrew', 'Alberto', NOW() + '3 years'::INTERVAL, NULL, 'II'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -214,7 +214,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999376988', 9, 'Mitchell', 'jenniferm1234', - 'Jennifer', 'Dorothy', NOW() + '3 years'::INTERVAL, '1981-08-19', ''); + 'Jennifer', 'Dorothy', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -235,7 +235,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999390791', 7, 'Ortiz', 'richardo1234', - 'Richard', '', NOW() + '3 years'::INTERVAL, '1978-06-13', ''); + 'Richard', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -256,7 +256,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999378730', 6, 'Wade', 'robertw1234', - 'Robert', 'Coy', NOW() + '3 years'::INTERVAL, '1985-12-21', ''); + 'Robert', 'Coy', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -277,7 +277,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999360638', 5, 'Wise', 'janetw1234', - 'Janet', '', NOW() + '3 years'::INTERVAL, '1992-08-12', ''); + 'Janet', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -319,7 +319,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999354736', 4, 'Miller', 'jeffm1234', - 'Jeff', 'James', NOW() + '3 years'::INTERVAL, '1977-03-17', 'Sr'); + 'Jeff', 'James', NOW() + '3 years'::INTERVAL, NULL, 'Sr'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -361,7 +361,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999397601', 8, 'Dunn', 'brittneyd1234', - 'Brittney', 'Pamela', NOW() + '3 years'::INTERVAL, '1998-06-28', ''); + 'Brittney', 'Pamela', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -382,7 +382,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999377594', 4, 'Wiggins', 'jeanw1234', - 'Jean', 'Verna', NOW() + '3 years'::INTERVAL, '1991-09-25', ''); + 'Jean', 'Verna', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -424,7 +424,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999398023', 8, 'Phillips', 'noahp1234', - 'Noah', 'Joseph', NOW() + '3 years'::INTERVAL, '1993-03-17', 'III'); + 'Noah', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, 'III'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -466,7 +466,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999379221', 5, 'Wells', 'kristenw1234', - 'Kristen', 'Vivian', NOW() + '3 years'::INTERVAL, '1971-01-16', ''); + 'Kristen', 'Vivian', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -487,7 +487,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999373350', 8, 'Lindsey', 'noahl1234', - 'Noah', 'Keith', NOW() + '3 years'::INTERVAL, '1972-11-08', ''); + 'Noah', 'Keith', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -508,7 +508,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999340920', 4, 'Williams', 'berthaw1234', - 'Bertha', 'Katherine', NOW() + '3 years'::INTERVAL, '1986-12-08', ''); + 'Bertha', 'Katherine', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -529,7 +529,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999398482', 7, 'Rodriguez', 'jamesr1234', - 'James', '', NOW() + '3 years'::INTERVAL, '1993-09-22', ''); + 'James', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -550,7 +550,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999394378', 5, 'Byrd', 'matthewb1234', - 'Matthew', 'David', NOW() + '3 years'::INTERVAL, '1965-12-15', ''); + 'Matthew', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -592,7 +592,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999387130', 7, 'Wilson', 'bethw1234', - 'Beth', 'Michelle', NOW() + '3 years'::INTERVAL, '1966-07-17', ''); + 'Beth', 'Michelle', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -613,7 +613,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999310765', 8, 'Daniels', 'randyd1234', - 'Randy', 'Lawrence', NOW() + '3 years'::INTERVAL, '1971-03-20', ''); + 'Randy', 'Lawrence', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -634,7 +634,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999335545', 9, 'Simpson', 'steves1234', - 'Steve', 'Raymond', NOW() + '3 years'::INTERVAL, '1961-07-04', ''); + 'Steve', 'Raymond', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -697,7 +697,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999371688', 8, 'Ellison', 'done1234', - 'Don', 'John', NOW() + '3 years'::INTERVAL, '1999-10-26', ''); + 'Don', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -718,7 +718,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999312757', 4, 'Hughes', 'josephh1234', - 'Joseph', 'Bryant', NOW() + '3 years'::INTERVAL, '1998-05-13', ''); + 'Joseph', 'Bryant', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -739,7 +739,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999399015', 8, 'Turner', 'cristinat1234', - 'Cristina', 'Karen', NOW() + '3 years'::INTERVAL, '1985-12-10', ''); + 'Cristina', 'Karen', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -760,7 +760,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999313973', 4, 'Langley', 'victorl1234', - 'Victor', 'James', NOW() + '3 years'::INTERVAL, '1993-01-09', ''); + 'Victor', 'James', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -781,7 +781,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999311521', 6, 'Fields', 'davidf1234', - 'David', '', NOW() + '3 years'::INTERVAL, '1990-08-11', ''); + 'David', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -823,7 +823,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999345160', 8, 'Gonzalez', 'natalieg1234', - 'Natalie', 'Joan', NOW() + '3 years'::INTERVAL, '1991-04-11', ''); + 'Natalie', 'Joan', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -844,7 +844,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999328966', 9, 'Rucker', 'drewr1234', - 'Drew', '', NOW() + '3 years'::INTERVAL, '1965-12-19', ''); + 'Drew', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -865,7 +865,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999394635', 9, 'Mitchell', 'kimberlym1234', - 'Kimberly', '', NOW() + '3 years'::INTERVAL, '1971-02-19', ''); + 'Kimberly', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -886,7 +886,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999333308', 7, 'Murray', 'heatherm1234', - 'Heather', 'Margaret', NOW() + '3 years'::INTERVAL, '1969-05-21', ''); + 'Heather', 'Margaret', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -907,7 +907,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999316647', 7, 'Sosa', 'robertas1234', - 'Roberta', 'Norma', NOW() + '3 years'::INTERVAL, '1962-09-02', ''); + 'Roberta', 'Norma', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -949,7 +949,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999380162', 8, 'Jackson', 'paulj1234', - 'Paul', '', NOW() + '3 years'::INTERVAL, '1969-05-16', ''); + 'Paul', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -970,7 +970,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999318240', 7, 'Graham', 'johng1234', - 'John', 'Charles', NOW() + '3 years'::INTERVAL, '1998-12-23', ''); + 'John', 'Charles', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -991,7 +991,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999347267', 7, 'Michael', 'adamm1234', - 'Adam', 'John', NOW() + '3 years'::INTERVAL, '1966-09-18', ''); + 'Adam', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1012,7 +1012,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999344618', 7, 'Thomas', 'helent1234', - 'Helen', '', NOW() + '3 years'::INTERVAL, '1998-07-15', ''); + 'Helen', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1033,7 +1033,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999301966', 7, 'Rivas', 'meghanr1234', - 'Meghan', '', NOW() + '3 years'::INTERVAL, '1977-08-22', ''); + 'Meghan', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1054,7 +1054,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999306663', 5, 'Hurst', 'williamh1234', - 'William', 'Ian', NOW() + '3 years'::INTERVAL, '1995-03-27', ''); + 'William', 'Ian', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1075,7 +1075,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999329410', 8, 'Bridges', 'kimberlyb1234', - 'Kimberly', 'Anna', NOW() + '3 years'::INTERVAL, '1981-01-13', ''); + 'Kimberly', 'Anna', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1096,7 +1096,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999396820', 6, 'Stewart', 'beatrices1234', - 'Beatrice', 'Gloria', NOW() + '3 years'::INTERVAL, '1966-12-25', ''); + 'Beatrice', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1138,7 +1138,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999308688', 9, 'Osborne', 'leonao1234', - 'Leona', '', NOW() + '3 years'::INTERVAL, '1999-04-08', ''); + 'Leona', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1180,7 +1180,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999399294', 5, 'Jones', 'joej1234', - 'Joe', 'Wayne', NOW() + '3 years'::INTERVAL, '1963-12-20', ''); + 'Joe', 'Wayne', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1201,7 +1201,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999355645', 6, 'Duncan', 'willied1234', - 'Willie', '', NOW() + '3 years'::INTERVAL, '1971-09-27', ''); + 'Willie', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1222,7 +1222,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999359616', 6, 'Carney', 'andreac1234', - 'Andrea', '', NOW() + '3 years'::INTERVAL, '1989-04-18', ''); + 'Andrea', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1264,7 +1264,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999389009', 6, 'Martin', 'eddiem1234', - 'Eddie', 'Anthony', NOW() + '3 years'::INTERVAL, '1997-12-09', ''); + 'Eddie', 'Anthony', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1285,7 +1285,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999327461', 9, 'Barry', 'paulb1234', - 'Paul', 'Richard', NOW() + '3 years'::INTERVAL, '1974-04-16', ''); + 'Paul', 'Richard', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1327,7 +1327,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999378520', 5, 'Saunders', 'rubens1234', - 'Ruben', 'Eric', NOW() + '3 years'::INTERVAL, '1975-06-22', ''); + 'Ruben', 'Eric', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1348,7 +1348,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999366196', 7, 'Lane', 'jenniferl1234', - 'Jennifer', '', NOW() + '3 years'::INTERVAL, '1961-10-22', ''); + 'Jennifer', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1369,7 +1369,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999324371', 5, 'Madden', 'jom1234', - 'Jo', 'Mae', NOW() + '3 years'::INTERVAL, '1976-04-01', ''); + 'Jo', 'Mae', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1390,7 +1390,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999316280', 8, 'Harding', 'naomih1234', - 'Naomi', 'Julie', NOW() + '3 years'::INTERVAL, '1986-05-21', ''); + 'Naomi', 'Julie', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1411,7 +1411,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999388575', 5, 'Davis', 'blaked1234', - 'Blake', 'George', NOW() + '3 years'::INTERVAL, '1977-06-17', ''); + 'Blake', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1453,7 +1453,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999376864', 4, 'Anderson', 'leona1234', - 'Leon', '', NOW() + '3 years'::INTERVAL, '1986-09-16', ''); + 'Leon', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1516,7 +1516,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999343281', 7, 'Bradley', 'rebeccab1234', - 'Rebecca', 'Vanessa', NOW() + '3 years'::INTERVAL, '1991-04-25', ''); + 'Rebecca', 'Vanessa', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1537,7 +1537,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999394534', 4, 'Hart', 'victorh1234', - 'Victor', '', NOW() + '3 years'::INTERVAL, '1977-01-10', ''); + 'Victor', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1558,7 +1558,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999323404', 8, 'Riley', 'edwardr1234', - 'Edward', 'Lonnie', NOW() + '3 years'::INTERVAL, '1992-07-19', ''); + 'Edward', 'Lonnie', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1600,7 +1600,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999315742', 7, 'Brown', 'maryb1234', - 'Mary', 'Jill', NOW() + '3 years'::INTERVAL, '1973-11-10', ''); + 'Mary', 'Jill', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1726,7 +1726,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999329832', 4, 'Kinney', 'nicholask1234', - 'Nicholas', '', NOW() + '3 years'::INTERVAL, '1989-05-24', ''); + 'Nicholas', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1768,7 +1768,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999335091', 9, 'Brown', 'maryb1234', - 'Mary', 'Annie', NOW() + '3 years'::INTERVAL, '1978-04-02', ''); + 'Mary', 'Annie', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1810,7 +1810,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999327083', 8, 'Jones', 'coraj1234', - 'Cora', '', NOW() + '3 years'::INTERVAL, '1968-06-08', ''); + 'Cora', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1831,7 +1831,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999300523', 7, 'Little', 'shawnl1234', - 'Shawn', 'Joseph', NOW() + '3 years'::INTERVAL, '1991-01-11', ''); + 'Shawn', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1852,7 +1852,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999328829', 6, 'Thurman', 'luannt1234', - 'Luann', 'Donna', NOW() + '3 years'::INTERVAL, '1990-08-19', ''); + 'Luann', 'Donna', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1873,7 +1873,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999394673', 6, 'Scott', 'patricias1234', - 'Patricia', 'Robin', NOW() + '3 years'::INTERVAL, '1998-08-28', ''); + 'Patricia', 'Robin', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1915,7 +1915,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999377675', 8, 'Brown', 'wendib1234', - 'Wendi', 'Mary', NOW() + '3 years'::INTERVAL, '1996-10-12', ''); + 'Wendi', 'Mary', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1936,7 +1936,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999363186', 5, 'Clarke', 'lawrencec1234', - 'Lawrence', 'Vern', NOW() + '3 years'::INTERVAL, '1982-05-20', ''); + 'Lawrence', 'Vern', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1957,7 +1957,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999346314', 8, 'Clark', 'danielc1234', - 'Daniel', 'Ricky', NOW() + '3 years'::INTERVAL, '1989-08-25', ''); + 'Daniel', 'Ricky', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1978,7 +1978,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999353477', 6, 'Dennis', 'johnd1234', - 'John', 'Robert', NOW() + '3 years'::INTERVAL, '1986-12-08', ''); + 'John', 'Robert', NOW() + '3 years'::INTERVAL, '1975-03-04', NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2041,7 +2041,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999342446', 8, 'Johnson', 'jeannej1234', - 'Jeanne', '', NOW() + '3 years'::INTERVAL, '1974-12-14', ''); + 'Jeanne', '', NOW() + '3 years'::INTERVAL, '1980-02-03', NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2062,7 +2062,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 1, '99999358416', 4, 'Sanford', 'elizabeths1234', - 'Elizabeth', 'Vanessa', NOW() + '3 years'::INTERVAL, '1960-12-04', ''); + 'Elizabeth', 'Vanessa', NOW() + '3 years'::INTERVAL, NULL, ''); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2083,7 +2083,7 @@ UPDATE actor.usr SET INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (2, 3, '99999361389', 9, 'Ramirez', 'alanr1234', - 'Alan', 'Claude', NOW() + '3 years'::INTERVAL, '1984-10-16', ''); + 'Alan', 'Claude', NOW() + '3 years'::INTERVAL, NULL, ''); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) diff --git a/Open-ILS/tests/datasets/sql/users_staff_134.sql b/Open-ILS/tests/datasets/sql/users_staff_134.sql index ab641844eb..b58f4e0668 100644 --- a/Open-ILS/tests/datasets/sql/users_staff_134.sql +++ b/Open-ILS/tests/datasets/sql/users_staff_134.sql @@ -1,7 +1,7 @@ INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (13, 3, 'sforbes', 6, 'Forbes', 'samuelf1234', - 'Samuel', 'Eugene', NOW() + '3 years'::INTERVAL, '1975-06-26', ''); + 'Samuel', 'Eugene', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -28,7 +28,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (13, 1, 'vcampbell', 4, 'Campbell', 'vincentc1234', - 'Vincent', 'Lawrence', NOW() + '3 years'::INTERVAL, '1998-10-17', ''); + 'Vincent', 'Lawrence', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -55,7 +55,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 3, 'afrey', 9, 'Frey', 'annief1234', - 'Annie', 'Jessica', NOW() + '3 years'::INTERVAL, '1997-12-07', ''); + 'Annie', 'Jessica', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -109,7 +109,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 1, 'klindsey', 8, 'Lindsey', 'kennethl1234', - 'Kenneth', 'Jesse', NOW() + '3 years'::INTERVAL, '1964-10-19', ''); + 'Kenneth', 'Jesse', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -136,7 +136,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 3, 'mdavis', 8, 'Davis', 'marthad1234', - 'Martha', '', NOW() + '3 years'::INTERVAL, '1983-05-13', ''); + 'Martha', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -190,7 +190,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 3, 'lmartinez', 7, 'Martinez', 'leroym1234', - 'Leroy', 'Brian', NOW() + '3 years'::INTERVAL, '1968-03-11', ''); + 'Leroy', 'Brian', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -217,7 +217,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 1, 'warmstrong', 6, 'Armstrong', 'williama1234', - 'William', 'William', NOW() + '3 years'::INTERVAL, '1980-08-13', ''); + 'William', 'William', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -244,7 +244,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 3, 'acotton', 6, 'Cotton', 'amyc1234', - 'Amy', 'Ada', NOW() + '3 years'::INTERVAL, '1984-12-16', ''); + 'Amy', 'Ada', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -271,7 +271,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 1, 'sbarton', 5, 'Barton', 'sarahb1234', - 'Sarah', 'Valerie', NOW() + '3 years'::INTERVAL, '1984-03-06', ''); + 'Sarah', 'Valerie', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -298,7 +298,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 1, 'jhammond', 5, 'Hammond', 'jamesh1234', - 'James', 'Michael', NOW() + '3 years'::INTERVAL, '1988-02-17', ''); + 'James', 'Michael', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -325,7 +325,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 3, 'ajoseph', 4, 'Joseph', 'alexj1234', - 'Alex', 'Edward', NOW() + '3 years'::INTERVAL, '1968-02-14', ''); + 'Alex', 'Edward', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -352,7 +352,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (15, 3, 'imccoy', 4, 'Mccoy', 'idam1234', - 'Ida', 'Gloria', NOW() + '3 years'::INTERVAL, '1963-08-19', ''); + 'Ida', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -379,7 +379,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 3, 'dwright', 9, 'Wright', 'dennisw1234', - 'Dennis', 'Ernest', NOW() + '3 years'::INTERVAL, '1998-07-28', ''); + 'Dennis', 'Ernest', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -406,7 +406,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 1, 'alynch', 9, 'Lynch', 'armandol1234', - 'Armando', '', NOW() + '3 years'::INTERVAL, '1967-08-16', ''); + 'Armando', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -433,7 +433,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 3, 'rgraham', 8, 'Graham', 'robertg1234', - 'Robert', '', NOW() + '3 years'::INTERVAL, '1987-03-12', ''); + 'Robert', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -460,7 +460,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 1, 'sthompson', 8, 'Thompson', 'sherrit1234', - 'Sherri', '', NOW() + '3 years'::INTERVAL, '1964-01-16', ''); + 'Sherri', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -487,7 +487,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 1, 'ngarcia', 7, 'Garcia', 'nanetteg1234', - 'Nanette', 'Helen', NOW() + '3 years'::INTERVAL, '1972-12-01', ''); + 'Nanette', 'Helen', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -514,7 +514,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 3, 'rcook', 7, 'Cook', 'raymondc1234', - 'Raymond', 'Boyd', NOW() + '3 years'::INTERVAL, '1968-12-05', ''); + 'Raymond', 'Boyd', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -541,7 +541,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 3, 'kbrewer', 6, 'Brewer', 'katherineb1234', - 'Katherine', '', NOW() + '3 years'::INTERVAL, '1980-12-04', ''); + 'Katherine', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -568,7 +568,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 1, 'cwashington', 6, 'Washington', 'christopherw1234', - 'Christopher', '', NOW() + '3 years'::INTERVAL, '1998-08-05', ''); + 'Christopher', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -595,7 +595,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 3, 'dmurray', 5, 'Murray', 'dawnm1234', - 'Dawn', 'Katherine', NOW() + '3 years'::INTERVAL, '1973-05-16', ''); + 'Dawn', 'Katherine', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -622,7 +622,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 1, 'bwatts', 5, 'Watts', 'barbaraw1234', - 'Barbara', 'Gloria', NOW() + '3 years'::INTERVAL, '1973-02-08', ''); + 'Barbara', 'Gloria', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -649,7 +649,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 3, 'mmartin', 4, 'Martin', 'marym1234', - 'Mary', 'Shannon', NOW() + '3 years'::INTERVAL, '1974-06-10', 'Sr'); + 'Mary', 'Shannon', NOW() + '3 years'::INTERVAL, NULL, 'Sr'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -676,7 +676,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (14, 3, 'vford', 4, 'Ford', 'vivianf1234', - 'Vivian', 'Darlene', NOW() + '3 years'::INTERVAL, '1971-08-03', ''); + 'Vivian', 'Darlene', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -703,7 +703,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 1, 'gsuarez', 9, 'Suarez', 'garys1234', - 'Gary', 'Joel', NOW() + '3 years'::INTERVAL, '1971-07-05', 'Sr'); + 'Gary', 'Joel', NOW() + '3 years'::INTERVAL, NULL, 'Sr'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -730,7 +730,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 1, 'eellis', 9, 'Ellis', 'edwarde1234', - 'Edward', 'David', NOW() + '3 years'::INTERVAL, '1998-05-05', ''); + 'Edward', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -757,7 +757,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 1, 'nward', 8, 'Ward', 'naomiw1234', - 'Naomi', 'Angela', NOW() + '3 years'::INTERVAL, '1987-02-23', 'Sr'); + 'Naomi', 'Angela', NOW() + '3 years'::INTERVAL, NULL, 'Sr'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -784,7 +784,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 1, 'jrichards', 8, 'Richards', 'josephr1234', - 'Joseph', 'Thomas', NOW() + '3 years'::INTERVAL, '1976-03-11', ''); + 'Joseph', 'Thomas', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -811,7 +811,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 3, 'rsanders', 7, 'Sanders', 'roslyns1234', - 'Roslyn', '', NOW() + '3 years'::INTERVAL, '1995-05-22', ''); + 'Roslyn', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -838,7 +838,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 1, 'nrivera', 7, 'Rivera', 'nancyr1234', - 'Nancy', 'Anita', NOW() + '3 years'::INTERVAL, '1990-03-22', 'Sr'); + 'Nancy', 'Anita', NOW() + '3 years'::INTERVAL, NULL, 'Sr'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -865,7 +865,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 1, 'cmartin', 6, 'Martin', 'carlm1234', - 'Carl', 'Charles', NOW() + '3 years'::INTERVAL, '1976-09-01', ''); + 'Carl', 'Charles', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -892,7 +892,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 1, 'telliott', 6, 'Elliott', 'thomase1234', - 'Thomas', 'Marcus', NOW() + '3 years'::INTERVAL, '1973-05-25', ''); + 'Thomas', 'Marcus', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -919,7 +919,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 3, 'ocherry', 5, 'Cherry', 'olgac1234', - 'Olga', 'Marie', NOW() + '3 years'::INTERVAL, '1976-05-25', ''); + 'Olga', 'Marie', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -946,7 +946,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 1, 'gdavenport', 5, 'Davenport', 'gwendolynd1234', - 'Gwendolyn', '', NOW() + '3 years'::INTERVAL, '1974-06-28', 'Jr'); + 'Gwendolyn', '', NOW() + '3 years'::INTERVAL, NULL, 'Jr'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -973,7 +973,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 3, 'sbrock', 4, 'Brock', 'scottb1234', - 'Scott', 'George', NOW() + '3 years'::INTERVAL, '1994-07-12', ''); + 'Scott', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1000,7 +1000,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (12, 3, 'rjackson', 4, 'Jackson', 'ronaldj1234', - 'Ronald', 'Robert', NOW() + '3 years'::INTERVAL, '1998-12-07', 'Jr'); + 'Ronald', 'Robert', NOW() + '3 years'::INTERVAL, NULL, 'Jr'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1027,7 +1027,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (11, 1, 'wjames', 9, 'James', 'waynej1234', - 'Wayne', 'George', NOW() + '3 years'::INTERVAL, '1976-01-17', ''); + 'Wayne', 'George', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1054,7 +1054,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (11, 1, 'shernandez', 9, 'Hernandez', 'sarahh1234', - 'Sarah', 'Elaine', NOW() + '3 years'::INTERVAL, '1986-06-27', ''); + 'Sarah', 'Elaine', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1081,7 +1081,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (11, 3, 'latkins', 8, 'Atkins', 'louisa1234', - 'Louis', 'Edward', NOW() + '3 years'::INTERVAL, '1995-02-10', ''); + 'Louis', 'Edward', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1135,7 +1135,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (11, 3, 'mharrison', 7, 'Harrison', 'michelleh1234', - 'Michelle', 'Patricia', NOW() + '3 years'::INTERVAL, '1979-12-11', ''); + 'Michelle', 'Patricia', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1162,7 +1162,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (11, 3, 'hwomack', 7, 'Womack', 'howardw1234', - 'Howard', '', NOW() + '3 years'::INTERVAL, '1963-03-20', ''); + 'Howard', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1189,7 +1189,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (11, 3, 'vbacon', 6, 'Bacon', 'virginiab1234', - 'Virginia', 'Celia', NOW() + '3 years'::INTERVAL, '1992-11-20', ''); + 'Virginia', 'Celia', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1216,7 +1216,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (11, 1, 'lbrooks', 6, 'Brooks', 'lonnieb1234', - 'Lonnie', 'William', NOW() + '3 years'::INTERVAL, '1981-03-24', ''); + 'Lonnie', 'William', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1243,7 +1243,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (11, 3, 'mgonzales', 5, 'Gonzales', 'maryg1234', - 'Mary', 'Jessica', NOW() + '3 years'::INTERVAL, '1988-03-17', ''); + 'Mary', 'Jessica', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1270,7 +1270,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (11, 1, 'mterry', 5, 'Terry', 'michellet1234', - 'Michelle', 'Kristy', NOW() + '3 years'::INTERVAL, '1972-03-26', ''); + 'Michelle', 'Kristy', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1351,7 +1351,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 3, 'mwilliams', 9, 'Williams', 'mattheww1234', - 'Matthew', '', NOW() + '3 years'::INTERVAL, '1977-10-25', ''); + 'Matthew', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1378,7 +1378,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 1, 'nperez', 9, 'Perez', 'nicholasp1234', - 'Nicholas', 'Joseph', NOW() + '3 years'::INTERVAL, '1990-09-27', ''); + 'Nicholas', 'Joseph', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1405,7 +1405,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 3, 'bfisher', 8, 'Fisher', 'barbaraf1234', - 'Barbara', '', NOW() + '3 years'::INTERVAL, '1960-10-04', ''); + 'Barbara', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1432,7 +1432,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 3, 'mmendoza', 8, 'Mendoza', 'miguelm1234', - 'Miguel', '', NOW() + '3 years'::INTERVAL, '1980-05-28', ''); + 'Miguel', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1459,7 +1459,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 1, 'ldickinson', 7, 'Dickinson', 'leed1234', - 'Lee', 'Annie', NOW() + '3 years'::INTERVAL, '1986-02-08', ''); + 'Lee', 'Annie', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1486,7 +1486,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 1, 'awilliams', 7, 'Williams', 'angelinaw1234', - 'Angelina', 'Joan', NOW() + '3 years'::INTERVAL, '1995-08-01', ''); + 'Angelina', 'Joan', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1513,7 +1513,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 1, 'bsanchez', 6, 'Sanchez', 'beths1234', - 'Beth', 'Deborah', NOW() + '3 years'::INTERVAL, '1974-10-23', ''); + 'Beth', 'Deborah', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1540,7 +1540,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 3, 'ethompson', 6, 'Thompson', 'elvint1234', - 'Elvin', '', NOW() + '3 years'::INTERVAL, '1968-06-21', ''); + 'Elvin', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1567,7 +1567,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 1, 'dlawson', 5, 'Lawson', 'doral1234', - 'Dora', '', NOW() + '3 years'::INTERVAL, '1978-05-23', ''); + 'Dora', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1621,7 +1621,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 3, 'wrandall', 4, 'Randall', 'williamr1234', - 'William', 'James', NOW() + '3 years'::INTERVAL, '1976-10-06', ''); + 'William', 'James', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1648,7 +1648,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (10, 1, 'csmith', 4, 'Smith', 'cathys1234', - 'Cathy', 'Cheryl', NOW() + '3 years'::INTERVAL, '1989-02-17', ''); + 'Cathy', 'Cheryl', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1702,7 +1702,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (9, 1, 'epeterson', 9, 'Peterson', 'emmap1234', - 'Emma', '', NOW() + '3 years'::INTERVAL, '1962-09-24', ''); + 'Emma', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1756,7 +1756,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (9, 1, 'cdonovan', 8, 'Donovan', 'charlied1234', - 'Charlie', 'David', NOW() + '3 years'::INTERVAL, '1981-09-17', ''); + 'Charlie', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1783,7 +1783,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (9, 3, 'msmith', 7, 'Smith', 'marthas1234', - 'Martha', 'Raquel', NOW() + '3 years'::INTERVAL, '1962-06-21', ''); + 'Martha', 'Raquel', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1810,7 +1810,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (9, 3, 'chouston', 7, 'Houston', 'cherylh1234', - 'Cheryl', '', NOW() + '3 years'::INTERVAL, '1975-12-15', ''); + 'Cheryl', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1837,7 +1837,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (9, 1, 'kwright', 6, 'Wright', 'kayw1234', - 'Kay', 'Anna', NOW() + '3 years'::INTERVAL, '1965-05-23', ''); + 'Kay', 'Anna', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1891,7 +1891,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (9, 1, 'rsmith', 5, 'Smith', 'roberts1234', - 'Robert', '', NOW() + '3 years'::INTERVAL, '1987-06-24', ''); + 'Robert', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1918,7 +1918,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (9, 1, 'cdodson', 5, 'Dodson', 'cleod1234', - 'Cleo', '', NOW() + '3 years'::INTERVAL, '1974-11-14', ''); + 'Cleo', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1945,7 +1945,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (9, 1, 'mneal', 4, 'Neal', 'melvinn1234', - 'Melvin', 'Richard', NOW() + '3 years'::INTERVAL, '1993-08-16', ''); + 'Melvin', 'Richard', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1972,7 +1972,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (9, 3, 'awilliams', 4, 'Williams', 'annaw1234', - 'Anna', 'Justine', NOW() + '3 years'::INTERVAL, '1990-11-09', ''); + 'Anna', 'Justine', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -1999,7 +1999,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (8, 1, 'emiller', 9, 'Miller', 'edmondm1234', - 'Edmond', 'Vance', NOW() + '3 years'::INTERVAL, '1993-05-16', ''); + 'Edmond', 'Vance', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2026,7 +2026,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (8, 3, 'vlogan', 9, 'Logan', 'vanessal1234', - 'Vanessa', 'Cassandra', NOW() + '3 years'::INTERVAL, '1991-02-01', ''); + 'Vanessa', 'Cassandra', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2053,7 +2053,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (8, 1, 'lthompson', 8, 'Thompson', 'lisat1234', - 'Lisa', 'Shirley', NOW() + '3 years'::INTERVAL, '1972-05-11', ''); + 'Lisa', 'Shirley', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2080,7 +2080,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (8, 1, 'oshaffer', 8, 'Shaffer', 'ollies1234', - 'Ollie', 'Monica', NOW() + '3 years'::INTERVAL, '1977-01-17', ''); + 'Ollie', 'Monica', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2107,7 +2107,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (8, 1, 'randrews', 7, 'Andrews', 'raymonda1234', - 'Raymond', 'Willie', NOW() + '3 years'::INTERVAL, '1996-11-25', ''); + 'Raymond', 'Willie', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2134,7 +2134,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (8, 3, 'emartinez', 7, 'Martinez', 'ednam1234', - 'Edna', 'Judith', NOW() + '3 years'::INTERVAL, '1990-04-23', ''); + 'Edna', 'Judith', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2188,7 +2188,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (8, 1, 'droberts', 6, 'Roberts', 'dianer1234', - 'Diane', 'Teresa', NOW() + '3 years'::INTERVAL, '1969-02-18', ''); + 'Diane', 'Teresa', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2242,7 +2242,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (8, 1, 'awright', 5, 'Wright', 'alyssaw1234', - 'Alyssa', 'Christine', NOW() + '3 years'::INTERVAL, '1994-05-23', ''); + 'Alyssa', 'Christine', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2269,7 +2269,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (8, 3, 'dbeck', 4, 'Beck', 'dianab1234', - 'Diana', 'Wilma', NOW() + '3 years'::INTERVAL, '1971-04-22', ''); + 'Diana', 'Wilma', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2323,7 +2323,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (7, 3, 'hstone', 9, 'Stone', 'hazels1234', - 'Hazel', 'Sylvia', NOW() + '3 years'::INTERVAL, '1980-12-09', ''); + 'Hazel', 'Sylvia', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2350,7 +2350,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (7, 1, 'dgarza', 9, 'Garza', 'davidg1234', - 'David', 'Steven', NOW() + '3 years'::INTERVAL, '1969-03-28', ''); + 'David', 'Steven', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2377,7 +2377,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (7, 3, 'jevans', 8, 'Evans', 'johne1234', - 'John', 'Timothy', NOW() + '3 years'::INTERVAL, '1973-09-26', ''); + 'John', 'Timothy', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2431,7 +2431,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (7, 3, 'ddavis', 7, 'Davis', 'donaldd1234', - 'Donald', 'Gene', NOW() + '3 years'::INTERVAL, '1999-11-24', ''); + 'Donald', 'Gene', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2539,7 +2539,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (7, 1, 'jroberts', 5, 'Roberts', 'johnr1234', - 'John', 'Theodore', NOW() + '3 years'::INTERVAL, '1960-09-10', ''); + 'John', 'Theodore', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2566,7 +2566,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (7, 3, 'sheath', 5, 'Heath', 'stevenh1234', - 'Steven', 'Luke', NOW() + '3 years'::INTERVAL, '1988-11-15', ''); + 'Steven', 'Luke', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2593,7 +2593,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (7, 1, 'krush', 4, 'Rush', 'keithr1234', - 'Keith', '', NOW() + '3 years'::INTERVAL, '1978-01-18', ''); + 'Keith', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2620,7 +2620,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (7, 3, 'lfarrell', 4, 'Farrell', 'lindaf1234', - 'Linda', 'Linda', NOW() + '3 years'::INTERVAL, '1996-12-05', ''); + 'Linda', 'Linda', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2647,7 +2647,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (6, 3, 'rharrison', 9, 'Harrison', 'richardh1234', - 'Richard', 'Melvin', NOW() + '3 years'::INTERVAL, '1974-01-17', ''); + 'Richard', 'Melvin', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2674,7 +2674,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (6, 1, 'ksmith', 9, 'Smith', 'kevins1234', - 'Kevin', 'Timothy', NOW() + '3 years'::INTERVAL, '1965-12-28', ''); + 'Kevin', 'Timothy', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2755,7 +2755,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (6, 1, 'jjohnson', 7, 'Johnson', 'joelj1234', - 'Joel', 'Allen', NOW() + '3 years'::INTERVAL, '1991-07-02', ''); + 'Joel', 'Allen', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2782,7 +2782,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (6, 1, 'kburton', 7, 'Burton', 'kristenb1234', - 'Kristen', 'Dena', NOW() + '3 years'::INTERVAL, '1986-08-22', ''); + 'Kristen', 'Dena', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2809,7 +2809,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (6, 1, 'rpineda', 6, 'Pineda', 'robertp1234', - 'Robert', 'Gordon', NOW() + '3 years'::INTERVAL, '1985-09-10', ''); + 'Robert', 'Gordon', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2863,7 +2863,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (6, 3, 'krowland', 5, 'Rowland', 'kennethr1234', - 'Kenneth', 'Ernest', NOW() + '3 years'::INTERVAL, '1978-10-08', ''); + 'Kenneth', 'Ernest', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2890,7 +2890,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (6, 1, 'thansen', 5, 'Hansen', 'terranceh1234', - 'Terrance', '', NOW() + '3 years'::INTERVAL, '1969-10-10', ''); + 'Terrance', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2917,7 +2917,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (6, 3, 'breid', 4, 'Reid', 'barbarar1234', - 'Barbara', 'Amanda', NOW() + '3 years'::INTERVAL, '1992-07-12', ''); + 'Barbara', 'Amanda', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2944,7 +2944,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (6, 1, 'mroberts', 4, 'Roberts', 'michaelr1234', - 'Michael', 'Stephen', NOW() + '3 years'::INTERVAL, '1994-10-06', ''); + 'Michael', 'Stephen', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2971,7 +2971,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (5, 3, 'rkaufman', 9, 'Kaufman', 'rachelk1234', - 'Rachel', 'Vickie', NOW() + '3 years'::INTERVAL, '1962-01-23', ''); + 'Rachel', 'Vickie', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -2998,7 +2998,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (5, 3, 'csims', 9, 'Sims', 'christophers1234', - 'Christopher', 'John', NOW() + '3 years'::INTERVAL, '1991-01-07', ''); + 'Christopher', 'John', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3052,7 +3052,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (5, 3, 'jpayton', 8, 'Payton', 'johnnyp1234', - 'Johnny', 'Vincent', NOW() + '3 years'::INTERVAL, '1965-09-23', ''); + 'Johnny', 'Vincent', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3079,7 +3079,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (5, 3, 'djamison', 7, 'Jamison', 'davidj1234', - 'David', 'Eric', NOW() + '3 years'::INTERVAL, '1993-08-11', ''); + 'David', 'Eric', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3106,7 +3106,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (5, 3, 'jford', 7, 'Ford', 'jamief1234', - 'Jamie', '', NOW() + '3 years'::INTERVAL, '1974-08-23', ''); + 'Jamie', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3133,7 +3133,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (5, 1, 'gwatson', 6, 'Watson', 'geraldw1234', - 'Gerald', 'Larry', NOW() + '3 years'::INTERVAL, '1967-11-15', ''); + 'Gerald', 'Larry', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3187,7 +3187,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (5, 1, 'mbarber', 5, 'Barber', 'michealb1234', - 'Micheal', 'Ramon', NOW() + '3 years'::INTERVAL, '1988-11-26', ''); + 'Micheal', 'Ramon', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3214,7 +3214,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (5, 3, 'tcruz', 5, 'Cruz', 'tomc1234', - 'Tom', 'Eugene', NOW() + '3 years'::INTERVAL, '1970-09-08', ''); + 'Tom', 'Eugene', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3241,7 +3241,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (5, 1, 'iwalton', 4, 'Walton', 'inezw1234', - 'Inez', 'Amanda', NOW() + '3 years'::INTERVAL, '1986-10-16', ''); + 'Inez', 'Amanda', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3295,7 +3295,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (4, 3, 'cmartinez', 9, 'Martinez', 'carolynm1234', - 'Carolyn', 'Sandra', NOW() + '3 years'::INTERVAL, '1988-07-18', ''); + 'Carolyn', 'Sandra', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3349,7 +3349,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (4, 1, 'mscott', 8, 'Scott', 'maes1234', - 'Mae', 'Sue', NOW() + '3 years'::INTERVAL, '1964-12-02', ''); + 'Mae', 'Sue', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3430,7 +3430,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (4, 3, 'vgrimes', 7, 'Grimes', 'virginiag1234', - 'Virginia', 'Jennifer', NOW() + '3 years'::INTERVAL, '1984-03-12', ''); + 'Virginia', 'Jennifer', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3457,7 +3457,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (4, 1, 'pward', 6, 'Ward', 'paulw1234', - 'Paul', '', NOW() + '3 years'::INTERVAL, '1985-05-06', ''); + 'Paul', '', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3484,7 +3484,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (4, 3, 'bgreen', 6, 'Green', 'beatriceg1234', - 'Beatrice', 'Janette', NOW() + '3 years'::INTERVAL, '1964-12-06', ''); + 'Beatrice', 'Janette', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3511,7 +3511,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (4, 1, 'sschmidt', 5, 'Schmidt', 'scotts1234', - 'Scott', 'Kyle', NOW() + '3 years'::INTERVAL, '1987-07-07', 'Sr'); + 'Scott', 'Kyle', NOW() + '3 years'::INTERVAL, NULL, 'Sr'); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3538,7 +3538,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (4, 3, 'jclark', 5, 'Clark', 'joannec1234', - 'Joanne', 'Andrea', NOW() + '3 years'::INTERVAL, '1985-03-16', ''); + 'Joanne', 'Andrea', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3565,7 +3565,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (4, 1, 'bbrown', 4, 'Brown', 'beverlyb1234', - 'Beverly', 'Florence', NOW() + '3 years'::INTERVAL, '1961-07-24', ''); + 'Beverly', 'Florence', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) @@ -3592,7 +3592,7 @@ UPDATE actor.usr usr SET usrname = LOWER(aou.shortname) || usrname INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, dob, suffix) VALUES (4, 3, 'jmcginnis', 4, 'Mcginnis', 'josem1234', - 'Jose', 'David', NOW() + '3 years'::INTERVAL, '1976-01-24', ''); + 'Jose', 'David', NOW() + '3 years'::INTERVAL, NULL, NULL); INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) -- 2.11.0