From cc6235e21c4ddb21671466bac74cd760db0a5b65 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 6 Mar 2013 13:10:21 -0500 Subject: [PATCH] User seed data has (mostly) valid addresses Make all but 3 (2 patrons, 1 staff) user addresses in the sample SQL seed data valid. Prior to this, most addresses were marked as non-valid. Signed-off-by: Bill Erickson Signed-off-by: Ben Shum --- .../tests/datasets/sql/users_patrons_100.sql | 164 +++++++-------- .../tests/datasets/sql/users_staff_134.sql | 195 +++++++++--------- 2 files changed, 181 insertions(+), 178 deletions(-) diff --git a/Open-ILS/tests/datasets/sql/users_patrons_100.sql b/Open-ILS/tests/datasets/sql/users_patrons_100.sql index 668b539415..9ed900b600 100644 --- a/Open-ILS/tests/datasets/sql/users_patrons_100.sql +++ b/Open-ILS/tests/datasets/sql/users_patrons_100.sql @@ -29,7 +29,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '41301', '3481 Facility Island', 'f', + VALUES ('USA', 't', '41301', '3481 Facility Island', 't', 'KY', 'Campton', '', 'Wolfe', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -51,7 +51,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '55927', '5150 Dinner Expressway', 'f', + VALUES ('USA', 'f', '55927', '5150 Dinner Expressway', 't', 'MN', 'Dodge center', '', 'Dodge', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -73,7 +73,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '22611', '8496 Random Trust Points', 'f', + VALUES ('USA', 't', '22611', '8496 Random Trust Points', 't', 'VA', 'Berryville', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -95,7 +95,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '99502', '7626 Secret Institute Courts', 'f', + VALUES ('USA', 'f', '99502', '7626 Secret Institute Courts', 't', 'AK', 'Anchorage', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -117,7 +117,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '40445', '7044 Regular Index Path', 'f', + VALUES ('USA', 'f', '40445', '7044 Regular Index Path', 't', 'KY', 'Livingston', '', 'Rockcastle', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -139,7 +139,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '33157', '3403 Thundering Heat Meadows', 'f', + VALUES ('USA', 't', '33157', '3403 Thundering Heat Meadows', 't', 'FL', 'Miami', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -153,6 +153,7 @@ UPDATE actor.usr SET WHERE id=CURRVAL('actor.usr_id_seq'); +-- Invalid address 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', @@ -160,7 +161,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '18960', '759 Doubtful Government Extension', 't', + VALUES ('USA', 't', '18960', '759 Doubtful Government Extension', 'f', 'PA', 'Sellersville', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -174,6 +175,7 @@ UPDATE actor.usr SET WHERE id=CURRVAL('actor.usr_id_seq'); +-- Invalid address 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', @@ -181,7 +183,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '29593', '5431 Japanese Work Rapid', 'f', + VALUES ('USA', 't', '29593', '5431 Japanese Work Rapid', 'f', 'SC', 'Society hill', '', 'Darlington', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -202,7 +204,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '61936', '5253 Agricultural Exhibition Stravenue', 'f', + VALUES ('USA', 't', '61936', '5253 Agricultural Exhibition Stravenue', 't', 'IL', 'La place', '', 'Piatt', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -244,7 +246,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '23885', '2433 Uncomfortable Nature Greens', 'f', + VALUES ('USA', 'f', '23885', '2433 Uncomfortable Nature Greens', 't', 'VA', 'Sutherland', '', 'Dinwiddie', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -265,7 +267,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '55796', '3241 Communist Boat Boulevard', 'f', + VALUES ('USA', 't', '55796', '3241 Communist Boat Boulevard', 't', 'MN', 'Winton', '', 'Saint louis', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -286,7 +288,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '64126', '6773 Government Hill', 'f', + VALUES ('USA', 'f', '64126', '6773 Government Hill', 't', 'MO', 'Kansas city', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -307,7 +309,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '40847', '7194 Gorgeous Edge Dale', 'f', + VALUES ('USA', 't', '40847', '7194 Gorgeous Edge Dale', 't', 'KY', 'Kenvir', '', 'Harlan', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -328,7 +330,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '80920', '9674 Filthy Firm Meadows', 'f', + VALUES ('USA', 't', '80920', '9674 Filthy Firm Meadows', 't', 'CO', 'Colorado springs', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -370,7 +372,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '73838', '9753 Confident Limit Shoal', 'f', + VALUES ('USA', 't', '73838', '9753 Confident Limit Shoal', 't', 'OK', 'Chester', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -391,7 +393,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '23018', '6115 Thoughtful Country Ridge', 'f', + VALUES ('USA', 'f', '23018', '6115 Thoughtful Country Ridge', 't', 'VA', 'Bena', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -412,7 +414,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '60609', '4223 Spotty Chemical Stravenue', 'f', + VALUES ('USA', 't', '60609', '4223 Spotty Chemical Stravenue', 't', 'IL', 'Chicago', '', 'Cook', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -433,7 +435,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '33593', '2005 Inner Entry Harbor', 'f', + VALUES ('USA', 't', '33593', '2005 Inner Entry Harbor', 't', 'FL', 'Trilby', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -475,7 +477,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '12450', '2302 Prisoner Way', 'f', + VALUES ('USA', 't', '12450', '2302 Prisoner Way', 't', 'NY', 'Lanesville', '', 'Greene', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -496,7 +498,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '50108', '7583 Low Surface Overpass', 'f', + VALUES ('USA', 't', '50108', '7583 Low Surface Overpass', 't', 'IA', 'Grand river', '', 'Decatur', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -517,7 +519,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '20646', '3301 Acid Canyon', 'f', + VALUES ('USA', 't', '20646', '3301 Acid Canyon', 't', 'MD', 'La plata', '', 'Charles', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -538,7 +540,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '95066', '9801 Working-class Flower Meadow', 'f', + VALUES ('USA', 'f', '95066', '9801 Working-class Flower Meadow', 't', 'CA', 'Scotts valley', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -580,7 +582,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '56568', '4246 Fun Post Street', 'f', + VALUES ('USA', 'f', '56568', '4246 Fun Post Street', 't', 'MN', 'Nielsville', '', 'Polk', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -601,7 +603,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '15341', '7780 Horrible Winner Island', 'f', + VALUES ('USA', 'f', '15341', '7780 Horrible Winner Island', 't', 'PA', 'Holbrook', '', 'Greene', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -622,7 +624,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '29680', '4697 Subsequent Culture Pass', 'f', + VALUES ('USA', 'f', '29680', '4697 Subsequent Culture Pass', 't', 'SC', 'Simpsonville', '', 'Greenville', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -643,7 +645,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '88118', '2400 Communication Mount', 'f', + VALUES ('USA', 'f', '88118', '2400 Communication Mount', 't', 'NM', 'Floyd', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -685,7 +687,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '20064', '4827 Shoulder Center', 'f', + VALUES ('USA', 'f', '20064', '4827 Shoulder Center', 't', 'DC', 'Washington', '', 'District of columbia', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -727,7 +729,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '48613', '9736 Profitable Wine Spring', 'f', + VALUES ('USA', 't', '48613', '9736 Profitable Wine Spring', 't', 'MI', 'Bentley', '', 'Bay', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -769,7 +771,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '94576', '1082 Capacity Hill', 'f', + VALUES ('USA', 'f', '94576', '1082 Capacity Hill', 't', 'CA', 'Deer park', '', 'Napa', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -790,7 +792,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '73939', '8788 Religious Writer Isle', 'f', + VALUES ('USA', 'f', '73939', '8788 Religious Writer Isle', 't', 'OK', 'Goodwell', '', 'Texas', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -811,7 +813,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '47163', '4971 Assembly Parkways', 'f', + VALUES ('USA', 't', '47163', '4971 Assembly Parkways', 't', 'IN', 'Otisco', '', 'Clark', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -832,7 +834,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '17120', '8835 Amazing Reduction Course', 'f', + VALUES ('USA', 't', '17120', '8835 Amazing Reduction Course', 't', 'PA', 'Harrisburg', '', 'Dauphin', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -853,7 +855,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '92253', '5158 Redundant Reality Creek', 'f', + VALUES ('USA', 'f', '92253', '5158 Redundant Reality Creek', 't', 'CA', 'La quinta', '', 'Riverside', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -874,7 +876,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '85375', '9724 Land Corner', 'f', + VALUES ('USA', 'f', '85375', '9724 Land Corner', 't', 'AZ', 'Sun city west', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -895,7 +897,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '51239', '5555 Project Bypass', 'f', + VALUES ('USA', 'f', '51239', '5555 Project Bypass', 't', 'IA', 'Hull', '', 'Sioux', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -916,7 +918,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '94010', '4571 Jealous Comparison Wells', 'f', + VALUES ('USA', 'f', '94010', '4571 Jealous Comparison Wells', 't', 'CA', 'Burlingame', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -937,7 +939,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '29621', '9196 Old Future Fort', 'f', + VALUES ('USA', 'f', '29621', '9196 Old Future Fort', 't', 'SC', 'Anderson', '', 'Anderson', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -979,7 +981,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '03216', '3676 Sweet Campaign Courts', 'f', + VALUES ('USA', 't', '03216', '3676 Sweet Campaign Courts', 't', 'NH', 'Andover', '', 'Merrimack', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1000,7 +1002,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '68113', '7244 Brief Tree Crescent', 'f', + VALUES ('USA', 't', '68113', '7244 Brief Tree Crescent', 't', 'NE', 'Offutt a f b', '', 'Sarpy', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1021,7 +1023,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '43534', '5066 Disabled Drink Ford', 'f', + VALUES ('USA', 'f', '43534', '5066 Disabled Drink Ford', 't', 'OH', 'Mc clure', '', 'Henry', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1063,7 +1065,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '76937', '7986 Line Grove', 'f', + VALUES ('USA', 't', '76937', '7986 Line Grove', 't', 'TX', 'Eola', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1084,7 +1086,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '21047', '9992 Show Village', 'f', + VALUES ('USA', 't', '21047', '9992 Show Village', 't', 'MD', 'Fallston', '', 'Harford', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1105,7 +1107,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '64123', '7373 Social Fact Roads', 'f', + VALUES ('USA', 't', '64123', '7373 Social Fact Roads', 't', 'MO', 'Kansas city', '', 'Jackson', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1126,7 +1128,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '91615', '4270 Deafening Speed Stream', 'f', + VALUES ('USA', 't', '91615', '4270 Deafening Speed Stream', 't', 'CA', 'North hollywood', '', 'Los angeles', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1147,7 +1149,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '65261', '1368 Defiant Visit Drive', 'f', + VALUES ('USA', 'f', '65261', '1368 Defiant Visit Drive', 't', 'MO', 'Keytesville', '', 'Chariton', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1168,7 +1170,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '45314', '3011 Thoughtful Law Terrace', 'f', + VALUES ('USA', 't', '45314', '3011 Thoughtful Law Terrace', 't', 'OH', 'Cedarville', '', 'Greene', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1189,7 +1191,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '12167', '1641 Jolly Period Bend', 'f', + VALUES ('USA', 't', '12167', '1641 Jolly Period Bend', 't', 'NY', 'Stamford', '', 'Delaware', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1210,7 +1212,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '34682', '9904 Australian Cash Squares', 'f', + VALUES ('USA', 'f', '34682', '9904 Australian Cash Squares', 't', 'FL', 'Palm harbor', '', 'Pinellas', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1252,7 +1254,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '49337', '1182 Radical Letter Square', 'f', + VALUES ('USA', 'f', '49337', '1182 Radical Letter Square', 't', 'MI', 'Newaygo', '', 'Newaygo', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1273,7 +1275,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '95031', '1938 Fundamental Distribution Lane', 'f', + VALUES ('USA', 'f', '95031', '1938 Fundamental Distribution Lane', 't', 'CA', 'Los gatos', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1294,7 +1296,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '40583', '9317 Testy Soil Place', 'f', + VALUES ('USA', 't', '40583', '9317 Testy Soil Place', 't', 'KY', 'Lexington', '', 'Fayette', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1336,7 +1338,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '32648', '2941 Conservation Race Haven', 'f', + VALUES ('USA', 'f', '32648', '2941 Conservation Race Haven', 't', 'FL', 'Horseshoe beach', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1357,7 +1359,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '12456', '5547 Knee Underpass', 'f', + VALUES ('USA', 't', '12456', '5547 Knee Underpass', 't', 'NY', 'Mount marion', '', 'Ulster', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1378,7 +1380,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '19612', '3125 League Brook', 'f', + VALUES ('USA', 'f', '19612', '3125 League Brook', 't', 'PA', 'Reading', '', 'Berks', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1420,7 +1422,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '13856', '8634 Need Bridge', 'f', + VALUES ('USA', 't', '13856', '8634 Need Bridge', 't', 'NY', 'Walton', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1441,7 +1443,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '23107', '218 Region River', 'f', + VALUES ('USA', 't', '23107', '218 Region River', 't', 'VA', 'Maryus', '', 'Gloucester', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1462,7 +1464,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '27315', '9834 Standard Stravenue', 'f', + VALUES ('USA', 'f', '27315', '9834 Standard Stravenue', 't', 'NC', 'Providence', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1483,7 +1485,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '47273', '4151 Severe Look Fort', 'f', + VALUES ('USA', 't', '47273', '4151 Severe Look Fort', 't', 'IN', 'Scipio', '', 'Jennings', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1504,7 +1506,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '06468', '2774 Melted Stone Islands', 'f', + VALUES ('USA', 'f', '06468', '2774 Melted Stone Islands', 't', 'CT', 'Monroe', '', 'Fairfield', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1525,7 +1527,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '66948', '5933 Changing Terms Pike', 'f', + VALUES ('USA', 'f', '66948', '5933 Changing Terms Pike', 't', 'KS', 'Jamestown', '', 'Cloud', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1546,7 +1548,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '16833', '677 Breezy Agreement Mountain', 'f', + VALUES ('USA', 't', '16833', '677 Breezy Agreement Mountain', 't', 'PA', 'Curwensville', '', 'Clearfield', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1567,7 +1569,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '84412', '5806 Metropolitan Problem Annex', 'f', + VALUES ('USA', 'f', '84412', '5806 Metropolitan Problem Annex', 't', 'UT', 'Ogden', '', 'Weber', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1588,7 +1590,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '46970', '8951 Great Arrangement Mills', 'f', + VALUES ('USA', 'f', '46970', '8951 Great Arrangement Mills', 't', 'IN', 'Peru', '', 'Miami', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1609,7 +1611,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '75663', '4845 Boat Course', 'f', + VALUES ('USA', 'f', '75663', '4845 Boat Course', 't', 'TX', 'Kilgore', '', 'Gregg', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1672,7 +1674,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '24910', '3522 Channel Radial', 'f', + VALUES ('USA', 't', '24910', '3522 Channel Radial', 't', 'WV', 'Alderson', '', 'Monroe', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1693,7 +1695,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '89101', '9734 Civilian Position Hollow', 'f', + VALUES ('USA', 't', '89101', '9734 Civilian Position Hollow', 't', 'NV', 'Las vegas', '', 'Clark', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1714,7 +1716,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '46241', '5799 Constitutional Roof Groves', 'f', + VALUES ('USA', 't', '46241', '5799 Constitutional Roof Groves', 't', 'IN', 'Indianapolis', '', 'Marion', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1756,7 +1758,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '41567', '2546 Marvellous Index Ways', 'f', + VALUES ('USA', 'f', '41567', '2546 Marvellous Index Ways', 't', 'KY', 'Stone', '', 'Pike', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1777,7 +1779,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '07630', '48 Look Ridge', 'f', + VALUES ('USA', 't', '07630', '48 Look Ridge', 't', 'NJ', 'Emerson', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1798,7 +1800,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '34972', '845 Relative Dress Mall', 'f', + VALUES ('USA', 'f', '34972', '845 Relative Dress Mall', 't', 'FL', 'Okeechobee', '', 'Okeechobee', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1819,7 +1821,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '65262', '9202 Tight Subject Highway', 'f', + VALUES ('USA', 't', '65262', '9202 Tight Subject Highway', 't', 'MO', 'Kingdom city', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1840,7 +1842,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '86343', '8169 Vast Passage Key', 'f', + VALUES ('USA', 'f', '86343', '8169 Vast Passage Key', 't', 'AZ', 'Crown king', '', 'Yavapai', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1861,7 +1863,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '63463', '1967 Interesting Court Ford', 'f', + VALUES ('USA', 't', '63463', '1967 Interesting Court Ford', 't', 'MO', 'Philadelphia', '', 'Marion', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1882,7 +1884,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '44241', '8955 Due Population Alley', 'f', + VALUES ('USA', 't', '44241', '8955 Due Population Alley', 't', 'OH', 'Streetsboro', '', 'Portage', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1903,7 +1905,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '05501', '9042 Just Show Turnpike', 'f', + VALUES ('USA', 'f', '05501', '9042 Just Show Turnpike', 't', 'MA', 'Andover', '', 'Essex', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1924,7 +1926,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '37721', '7546 Rude Agreement Highway', 'f', + VALUES ('USA', 'f', '37721', '7546 Rude Agreement Highway', 't', 'TN', 'Corryton', '', 'Knox', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1945,7 +1947,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '76234', '7903 Surprised Rule Loop', 'f', + VALUES ('USA', 't', '76234', '7903 Surprised Rule Loop', 't', 'TX', 'Decatur', '', 'Wise', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1987,7 +1989,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '14480', '8712 Legislative Box Shore', 'f', + VALUES ('USA', 't', '14480', '8712 Legislative Box Shore', 't', 'NY', 'Lakeville', '', 'Livingston', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2008,7 +2010,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '83204', '6713 River Bridge', 'f', + VALUES ('USA', 'f', '83204', '6713 River Bridge', 't', 'ID', 'Pocatello', '', 'Bannock', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2029,7 +2031,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '79120', '8208 Death Ramp', 'f', + VALUES ('USA', 't', '79120', '8208 Death Ramp', 't', 'TX', 'Amarillo', '', 'Potter', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2071,7 +2073,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '98357', '6767 Application Course', 'f', + VALUES ('USA', 't', '98357', '6767 Application Course', 't', 'WA', 'Neah bay', '', 'Clallam', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) diff --git a/Open-ILS/tests/datasets/sql/users_staff_134.sql b/Open-ILS/tests/datasets/sql/users_staff_134.sql index b58f4e0668..6ca31b83cb 100644 --- a/Open-ILS/tests/datasets/sql/users_staff_134.sql +++ b/Open-ILS/tests/datasets/sql/users_staff_134.sql @@ -1,3 +1,4 @@ +-- Invalid address 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', @@ -5,7 +6,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '40065', '8751 Gentleman Burgs', 'f', + VALUES ('USA', 'f', '40065', '8751 Gentleman Burgs', 'f', 'KY', 'Shelbyville', '', 'Shelby', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -32,7 +33,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '45633', '5489 Suitable Way Knoll', 'f', + VALUES ('USA', 'f', '45633', '5489 Suitable Way Knoll', 't', 'OH', 'Hallsville', '', 'Ross', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -59,7 +60,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '54409', '7918 Subjective Volume Trail', 'f', + VALUES ('USA', 't', '54409', '7918 Subjective Volume Trail', 't', 'WI', 'Antigo', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -113,7 +114,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '89077', '1552 Okay Communication Motorway', 'f', + VALUES ('USA', 't', '89077', '1552 Okay Communication Motorway', 't', 'NV', 'Henderson', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -140,7 +141,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '13156', '8717 Cabinet Fords', 'f', + VALUES ('USA', 'f', '13156', '8717 Cabinet Fords', 't', 'NY', 'Sterling', '', 'Cayuga', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -167,7 +168,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '33122', '4033 Instant Matter Cape', 'f', + VALUES ('USA', 'f', '33122', '4033 Instant Matter Cape', 't', 'FL', 'Miami', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -194,7 +195,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '55046', '2511 Other Stream', 'f', + VALUES ('USA', 't', '55046', '2511 Other Stream', 't', 'MN', 'Lonsdale', '', 'Rice', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -221,7 +222,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '55959', '1671 Cabinet Orchard', 'f', + VALUES ('USA', 'f', '55959', '1671 Cabinet Orchard', 't', 'MN', 'Minnesota city', '', 'Winona', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -248,7 +249,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '34202', '1488 Glamorous Alternative Forks', 'f', + VALUES ('USA', 't', '34202', '1488 Glamorous Alternative Forks', 't', 'FL', 'Bradenton', '', 'Manatee', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -302,7 +303,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '88211', '9144 White Support Squares', 'f', + VALUES ('USA', 'f', '88211', '9144 White Support Squares', 't', 'NM', 'Artesia', '', 'Eddy', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -356,7 +357,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '40046', '9875 Support Row', 'f', + VALUES ('USA', 't', '40046', '9875 Support Row', 't', 'KY', 'Mount eden', '', 'Spencer', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -383,7 +384,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '03457', '2063 Sophisticated Status Plaza', 'f', + VALUES ('USA', 'f', '03457', '2063 Sophisticated Status Plaza', 't', 'NH', 'Nelson', '', 'Cheshire', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -410,7 +411,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '31126', '7394 Show Valley', 'f', + VALUES ('USA', 'f', '31126', '7394 Show Valley', 't', 'GA', 'Atlanta', '', 'Fulton', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -437,7 +438,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '98807', '2577 Stuck Benefit Tunnel', 'f', + VALUES ('USA', 't', '98807', '2577 Stuck Benefit Tunnel', 't', 'WA', 'Wenatchee', '', 'Chelan', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -464,7 +465,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '31758', '3587 Name Neck', 'f', + VALUES ('USA', 'f', '31758', '3587 Name Neck', 't', 'GA', 'Thomasville', '', 'Thomas', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -491,7 +492,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '11733', '6990 Icy Scene Street', 'f', + VALUES ('USA', 't', '11733', '6990 Icy Scene Street', 't', 'NY', 'East setauket', '', 'Suffolk', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -518,7 +519,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '94533', '2004 Harsh Gold Tunnel', 'f', + VALUES ('USA', 't', '94533', '2004 Harsh Gold Tunnel', 't', 'CA', 'Fairfield', '', 'Solano', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -572,7 +573,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '47360', '9934 Coloured Bar Grove', 'f', + VALUES ('USA', 't', '47360', '9934 Coloured Bar Grove', 't', 'IN', 'Mooreland', '', 'Henry', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -599,7 +600,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '59868', '4426 Temporary Demand River', 'f', + VALUES ('USA', 't', '59868', '4426 Temporary Demand River', 't', 'MT', 'Seeley lake', '', 'Missoula', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -626,7 +627,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '51036', '4020 Marked Chemical Bayoo', 'f', + VALUES ('USA', 't', '51036', '4020 Marked Chemical Bayoo', 't', 'IA', 'Maurice', '', 'Sioux', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -680,7 +681,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '23023', '3414 Energetic Weekend Circles', 'f', + VALUES ('USA', 't', '23023', '3414 Energetic Weekend Circles', 't', 'VA', 'Bruington', '', 'King and queen', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -734,7 +735,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '17349', '1977 Profound Conference Path', 'f', + VALUES ('USA', 't', '17349', '1977 Profound Conference Path', 't', 'PA', 'New freedom', '', 'York', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -788,7 +789,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '78658', '3275 Error Freeway', 'f', + VALUES ('USA', 'f', '78658', '3275 Error Freeway', 't', 'TX', 'Ottine', '', 'Gonzales', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -815,7 +816,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '19975', '6946 Constitutional Word Freeway', 'f', + VALUES ('USA', 't', '19975', '6946 Constitutional Word Freeway', 't', 'DE', 'Selbyville', '', 'Sussex', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -842,7 +843,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '27373', '263 Catholic End Field', 'f', + VALUES ('USA', 't', '27373', '263 Catholic End Field', 't', 'NC', 'Wallburg', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -869,7 +870,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '61452', '6985 Welcome Statement Fort', 'f', + VALUES ('USA', 't', '61452', '6985 Welcome Statement Fort', 't', 'IL', 'Littleton', '', 'Schuyler', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -896,7 +897,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '97624', '1283 Splendid West Manor', 'f', + VALUES ('USA', 't', '97624', '1283 Splendid West Manor', 't', 'OR', 'Chiloquin', '', 'Klamath', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -923,7 +924,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '17081', '9657 Scared Kind Street', 'f', + VALUES ('USA', 't', '17081', '9657 Scared Kind Street', 't', 'PA', 'Plainfield', '', 'Cumberland', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -950,7 +951,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '85014', '110 Logical Tone Drive', 'f', + VALUES ('USA', 'f', '85014', '110 Logical Tone Drive', 't', 'AZ', 'Phoenix', '', 'Maricopa', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -977,7 +978,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '60132', '1760 Channel Bottom', 'f', + VALUES ('USA', 't', '60132', '1760 Channel Bottom', 't', 'IL', 'Carol stream', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1031,7 +1032,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '27014', '5542 Politics Hollow', 'f', + VALUES ('USA', 't', '27014', '5542 Politics Hollow', 't', 'NC', 'Cooleemee', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1085,7 +1086,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '44705', '2794 Uniform Value Square', 'f', + VALUES ('USA', 't', '44705', '2794 Uniform Value Square', 't', 'OH', 'Canton', '', 'Stark', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1112,7 +1113,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '35501', '6178 Relieved Rain Wells', 'f', + VALUES ('USA', 't', '35501', '6178 Relieved Rain Wells', 't', 'AL', 'Jasper', '', 'Walker', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1220,7 +1221,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '83836', '8823 Side Fall', 'f', + VALUES ('USA', 't', '83836', '8823 Side Fall', 't', 'ID', 'Hope', '', 'Bonner', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1247,7 +1248,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '16213', '6608 Weary Drawing Lakes', 'f', + VALUES ('USA', 'f', '16213', '6608 Weary Drawing Lakes', 't', 'PA', 'Callensburg', '', 'Clarion', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1274,7 +1275,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '30817', '1658 Organisational Bedroom Square', 'f', + VALUES ('USA', 'f', '30817', '1658 Organisational Bedroom Square', 't', 'GA', 'Lincolnton', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1301,7 +1302,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '88240', '7269 Sister Gardens', 'f', + VALUES ('USA', 'f', '88240', '7269 Sister Gardens', 't', 'NM', 'Hobbs', '', 'Lea', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1328,7 +1329,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '50595', '7864 Remarkable Status River', 'f', + VALUES ('USA', 't', '50595', '7864 Remarkable Status River', 't', 'IA', 'Webster city', '', 'Hamilton', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1355,7 +1356,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '60064', '7230 Trend Mount', 'f', + VALUES ('USA', 'f', '60064', '7230 Trend Mount', 't', 'IL', 'North chicago', '', 'Lake', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1382,7 +1383,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '55076', '9299 Democratic Hill Cliffs', 'f', + VALUES ('USA', 'f', '55076', '9299 Democratic Hill Cliffs', 't', 'MN', 'Inver grove heights', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1409,7 +1410,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '61756', '9822 Excess Start Lock', 'f', + VALUES ('USA', 't', '61756', '9822 Excess Start Lock', 't', 'IL', 'Maroa', '', 'Macon', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1436,7 +1437,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '58773', '5831 Residential Respect Track', 'f', + VALUES ('USA', 'f', '58773', '5831 Residential Respect Track', 't', 'ND', 'Powers lake', '', 'Burke', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1463,7 +1464,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '12803', '5030 Vision Loop', 'f', + VALUES ('USA', 't', '12803', '5030 Vision Loop', 't', 'NY', 'South glens falls', '', 'Saratoga', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1490,7 +1491,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '25054', '1723 Multiple Object Canyon', 'f', + VALUES ('USA', 't', '25054', '1723 Multiple Object Canyon', 't', 'WV', 'Dawes', '', 'Kanawha', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1517,7 +1518,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '36426', '5148 Shaggy Farm Center', 'f', + VALUES ('USA', 'f', '36426', '5148 Shaggy Farm Center', 't', 'AL', 'Brewton', '', 'Escambia', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1544,7 +1545,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '67664', '2800 Cheerful Animal Valley', 'f', + VALUES ('USA', 't', '67664', '2800 Cheerful Animal Valley', 't', 'KS', 'Prairie view', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1571,7 +1572,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '63957', '6016 General Dog Divide', 'f', + VALUES ('USA', 'f', '63957', '6016 General Dog Divide', 't', 'MO', 'Piedmont', '', 'Wayne', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1598,7 +1599,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '62526', '4689 Alert Minute Court', 'f', + VALUES ('USA', 't', '62526', '4689 Alert Minute Court', 't', 'IL', 'Decatur', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1625,7 +1626,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '72117', '3448 Minor Solicitor Junction', 'f', + VALUES ('USA', 'f', '72117', '3448 Minor Solicitor Junction', 't', 'AR', 'North little rock', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1679,7 +1680,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '19053', '5012 Unemployed Other Harbor', 'f', + VALUES ('USA', 't', '19053', '5012 Unemployed Other Harbor', 't', 'PA', 'Feasterville trevose', '', 'Bucks', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1706,7 +1707,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '07095', '9931 Hushed Passage Turnpike', 'f', + VALUES ('USA', 't', '07095', '9931 Hushed Passage Turnpike', 't', 'NJ', 'Woodbridge', '', 'Middlesex', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1760,7 +1761,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '54017', '1926 Double Effort Spring', 'f', + VALUES ('USA', 'f', '54017', '1926 Double Effort Spring', 't', 'WI', 'New richmond', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1787,7 +1788,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '80534', '7185 Arbitrary Contrast Freeway', 'f', + VALUES ('USA', 'f', '80534', '7185 Arbitrary Contrast Freeway', 't', 'CO', 'Johnstown', '', 'Weld', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1895,7 +1896,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '00983', '231 Causal Expert Highway', 'f', + VALUES ('USA', 't', '00983', '231 Causal Expert Highway', 't', 'PR', 'Carolina', '', 'Carolina', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1922,7 +1923,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '25266', '53 Nice Customer Green', 'f', + VALUES ('USA', 't', '25266', '53 Nice Customer Green', 't', 'WV', 'Newton', '', 'Roane', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -1949,7 +1950,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '10150', '668 Unconscious Gun Spring', 'f', + VALUES ('USA', 't', '10150', '668 Unconscious Gun Spring', 't', 'NY', 'New york', '', 'New york', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2003,7 +2004,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '92007', '2632 Unlikely Assumption Tunnel', 'f', + VALUES ('USA', 'f', '92007', '2632 Unlikely Assumption Tunnel', 't', 'CA', 'Cardiff by the sea', '', 'San diego', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2030,7 +2031,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '44470', '2823 Eventual Hour Gateway', 'f', + VALUES ('USA', 'f', '44470', '2823 Eventual Hour Gateway', 't', 'OH', 'Southington', '', 'Trumbull', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2138,7 +2139,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '49270', '121 Consequence Club', 'f', + VALUES ('USA', 't', '49270', '121 Consequence Club', 't', 'MI', 'Petersburg', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2165,7 +2166,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '58064', '5708 Brainy West Bend', 'f', + VALUES ('USA', 'f', '58064', '5708 Brainy West Bend', 't', 'ND', 'Page', '', 'Cass', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2246,7 +2247,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '80295', '7771 Alive Iron Mission', 'f', + VALUES ('USA', 't', '80295', '7771 Alive Iron Mission', 't', 'CO', 'Denver', '', 'Denver', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2273,7 +2274,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '58776', '1146 Ability Centers', 'f', + VALUES ('USA', 't', '58776', '1146 Ability Centers', 't', 'ND', 'Ross', '', 'Mountrail', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2300,7 +2301,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '55168', '3541 Radical Sir Avenue', 'f', + VALUES ('USA', 't', '55168', '3541 Radical Sir Avenue', 't', 'MN', 'Saint paul', '', 'Ramsey', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2327,7 +2328,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '93247', '4171 Impossible Defence Overpass', 'f', + VALUES ('USA', 't', '93247', '4171 Impossible Defence Overpass', 't', 'CA', 'Lindsay', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2354,7 +2355,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '22513', '3627 Retail Kind Lodge', 'f', + VALUES ('USA', 't', '22513', '3627 Retail Kind Lodge', 't', 'VA', 'Merry point', '', 'Lancaster', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2381,7 +2382,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '64778', '1212 Mid Top Parkway', 'f', + VALUES ('USA', 't', '64778', '1212 Mid Top Parkway', 't', 'MO', 'Richards', '', 'Vernon', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2408,7 +2409,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '55336', '1642 Minor Potential Corners', 'f', + VALUES ('USA', 't', '55336', '1642 Minor Potential Corners', 't', 'MN', 'Glencoe', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2489,7 +2490,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '25926', '6558 Willing Master Valley', 'f', + VALUES ('USA', 'f', '25926', '6558 Willing Master Valley', 't', 'WV', 'Sprague', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2516,7 +2517,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '00922', '8532 Spare Offer Cliffs', 'f', + VALUES ('USA', 't', '00922', '8532 Spare Offer Cliffs', 't', 'PR', 'San juan', '', 'San juan', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2570,7 +2571,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '94547', '4666 Pain Isle', 'f', + VALUES ('USA', 'f', '94547', '4666 Pain Isle', 't', 'CA', 'Hercules', '', 'Contra costa', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2597,7 +2598,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '15257', '4464 Sense Station', 'f', + VALUES ('USA', 't', '15257', '4464 Sense Station', 't', 'PA', 'Pittsburgh', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2624,7 +2625,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '75155', '7746 Cooperative Fall Shoal', 'f', + VALUES ('USA', 't', '75155', '7746 Cooperative Fall Shoal', 't', 'TX', 'Rice', '', 'Navarro', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2651,7 +2652,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '06601', '2896 Jewish Lack Lodge', 'f', + VALUES ('USA', 't', '06601', '2896 Jewish Lack Lodge', 't', 'CT', 'Bridgeport', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2732,7 +2733,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '33630', '1062 Scornful Air Fort', 'f', + VALUES ('USA', 'f', '33630', '1062 Scornful Air Fort', 't', 'FL', 'Tampa', '', 'Hillsborough', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2759,7 +2760,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '36028', '3220 Drunk Message Parkway', 'f', + VALUES ('USA', 'f', '36028', '3220 Drunk Message Parkway', 't', 'AL', 'Dozier', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2786,7 +2787,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '42413', '4924 Part-time Charge Knoll', 'f', + VALUES ('USA', 'f', '42413', '4924 Part-time Charge Knoll', 't', 'KY', 'Hanson', '', 'Hopkins', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2840,7 +2841,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '64735', '4372 Fact Junction', 'f', + VALUES ('USA', 'f', '64735', '4372 Fact Junction', 't', 'MO', 'Clinton', '', 'Henry', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2867,7 +2868,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '98131', '8373 Resonant Investment Mission', 'f', + VALUES ('USA', 'f', '98131', '8373 Resonant Investment Mission', 't', 'WA', 'Seattle', '', 'King', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2921,7 +2922,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '04056', '3517 Hot School Brook', 'f', + VALUES ('USA', 'f', '04056', '3517 Hot School Brook', 't', 'ME', 'Newfield', '', 'York', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2948,7 +2949,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '63541', '4668 Start Inlet', 'f', + VALUES ('USA', 't', '63541', '4668 Start Inlet', 't', 'MO', 'Glenwood', '', 'Schuyler', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -2975,7 +2976,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '68659', '7270 Development Row', 'f', + VALUES ('USA', 't', '68659', '7270 Development Row', 't', 'NE', 'Rogers', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3029,7 +3030,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '65897', '8092 Pure Name Bridge', 'f', + VALUES ('USA', 'f', '65897', '8092 Pure Name Bridge', 't', 'MO', 'Springfield', '', 'Greene', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3056,7 +3057,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '85738', '8772 Forthcoming Hope Fort', 'f', + VALUES ('USA', 't', '85738', '8772 Forthcoming Hope Fort', 't', 'AZ', 'Catalina', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3083,7 +3084,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '59604', '9218 Moral Worker Summit', 'f', + VALUES ('USA', 'f', '59604', '9218 Moral Worker Summit', 't', 'MT', 'Helena', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3137,7 +3138,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '85063', '881 Scary Holiday Radial', 'f', + VALUES ('USA', 'f', '85063', '881 Scary Holiday Radial', 't', 'AZ', 'Phoenix', '', 'Maricopa', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3164,7 +3165,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '40291', '6026 Wide Development Port', 'f', + VALUES ('USA', 't', '40291', '6026 Wide Development Port', 't', 'KY', 'Louisville', '', 'Jefferson', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3245,7 +3246,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '29053', '8589 Official Valleys', 'f', + VALUES ('USA', 'f', '29053', '8589 Official Valleys', 't', 'SC', 'Gaston', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3326,7 +3327,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '70358', '4786 Prior Politics Mission', 'f', + VALUES ('USA', 'f', '70358', '4786 Prior Politics Mission', 't', 'LA', 'Grand isle', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3353,7 +3354,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '14723', '1060 Letter Stravenue', 'f', + VALUES ('USA', 'f', '14723', '1060 Letter Stravenue', 't', 'NY', 'Cherry creek', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3380,7 +3381,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '29582', '7735 Street Creek', 'f', + VALUES ('USA', 't', '29582', '7735 Street Creek', 't', 'SC', 'North myrtle beach', '', 'Horry', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3407,7 +3408,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '84133', '7301 Watery Arrangement Radial', 'f', + VALUES ('USA', 'f', '84133', '7301 Watery Arrangement Radial', 't', 'UT', 'Salt lake city', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3434,7 +3435,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '87027', '8666 Fluttering Situation Heights', 'f', + VALUES ('USA', 'f', '87027', '8666 Fluttering Situation Heights', 't', 'NM', 'La jara', '', 'Sandoval', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3461,7 +3462,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '38233', '8859 Roasted Energy Falls', 'f', + VALUES ('USA', 'f', '38233', '8859 Roasted Energy Falls', 't', 'TN', 'Kenton', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3488,7 +3489,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '65438', '9082 Plain Bed Avenue', 'f', + VALUES ('USA', 't', '65438', '9082 Plain Bed Avenue', 't', 'MO', 'Birch tree', '', 'Shannon', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3515,7 +3516,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '99670', '2204 Status Avenue', 'f', + VALUES ('USA', 'f', '99670', '2204 Status Avenue', 't', 'AK', 'South naknek', '', '', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3542,7 +3543,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 'f', '35175', '7622 Thoughtless Science Pines', 'f', + VALUES ('USA', 'f', '35175', '7622 Thoughtless Science Pines', 't', 'AL', 'Union grove', '', 'Marshall', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) @@ -3596,7 +3597,7 @@ INSERT INTO actor.usr INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) - VALUES ('USA', 't', '65055', '8231 Relieved Debt Cape', 'f', + VALUES ('USA', 't', '65055', '8231 Relieved Debt Cape', 't', 'MO', 'Mc girk', '', 'Moniteau', CURRVAL('actor.usr_id_seq')); INSERT INTO actor.card (barcode, usr) -- 2.43.2