<commit_before>SET NAMES utf8;

--
-- Sample data for groups
--

INSERT INTO groups(name, sess_seconds) VALUES
("Trial", 3600),
("Basic", 7200),
("Premium", 7200);

--
-- Sample data for images
--

INSERT INTO images(width, height, url, title, artist, gallery, organization, media) VALUES
(512, 362, "https://lh3.ggpht.com/iqWhX4gA_fDh_XUFb6bjoCVusT6lIAW4r1KCbBFLDyeqSczEwdzzwEA4SUn5Z_qDlef4", "Bodegón", "<NAME>", NULL, "Google Open Gallery", "Art"),
(379, 512, "https://lh3.ggpht.com/RbL9u5vdZMxltINmK5w48iS3_fMhfjVR7SxD-MMB1OZShj9OnynDhdAcvk7N3JDzvdbR-tk", "Portrait of <NAME>", "<NAME>", "The J. Paul Getty Museum", "Google Cultural Institute", "Art"),
(455, 512, "https://lh3.ggpht.com/tF611zF3LcdZLnJqCPmnNwvsuN4rAjwPNzrO5Uu4G8HT1iPUzmBI7w", "The wattles", "<NAME>", "Art Gallery of New South Wales", "Google Cultural Institute", "Art"),
(512, 384, "https://lh4.ggpht.com/CpBfF0vqJ2eqiL5Af3J5VtbqmIZQ9IpM2NJFdmE_49gGV2YIm0muJnMibzjpm-9cqxfOgg", "Envol pastel", "Octave Pixel", "galerie TACT: Fresh artistes", "Google Open Gallery", "Art"),
(2048, 1365, "https://lh3.ggpht.com/XprZKBFc-ErF-K_KKJEcWqiwwrsbn3BCg4yBlManYe0x2c-E6K4m2EFT1vYjrrae_VUMslw", "Manhattan", "<NAME>", "Featured photos", "Google+", "Photo"),
(512, 222, "https://lh3.ggpht.com/6swp7Zh21xlvw8NOEXYrMrUrcMSzzNvPd-3nZsR5RrrTQRTaMrKsdhIx4nHbVYyNmib2Jo_T9rR-gXQ", NULL, "<NAME>", NULL, NULL, "Photo"),
(512, 342, "https://lh3.ggpht.com/Vor04AFDXMTOb9tE0D0eK5zkuyKwHjvfjegcFd1sJxlfZWMeTFbjuMTo0PPQ6pHHQx5--Cc4eT48d9g", NULL, "<NAME>", NULL, NULL, "Photo"),
(512, 311, "https://lh3.ggpht.com/sDM3YrHDSPg4o75K8cna0M2N0yMSkXEC80Cc8AQL0YiNntHbmo9YPkRJ936wmsDubXGeBCxneBeTFpU", NULL, "<NAME>", NULL, NULL, "Photo"),
(2048, 1365, "https://lh3.ggpht.com/pwOiNl9yVpvleSguShs3MtXwUOPfMLtrQ3B4WUEoj0UR2bXgUEG1", "Early morning Bronte Beach", "Gil Baillache", NULL, NULL, "Photo");

--
-- Sample data for images-groups
--

INSERT INTO images_groups(group_id, image_id) VALUES
(1, 5),
(2, 1),
(2, 4),
(2, 5),
(3, 1),
(3, 2),
(3, 3),
(3, 4),
(3, 5),
(3, 6),
(3, 7),
(3, 8),
(3, 9);

--
-- Sample data for users
--

INSERT INTO users (group_id, guid, first_name, middle_init, last_name, email, addr, city, state, zip, gender, status) VALUES
(2, "3efd7840-14f8-4c34-83fe-8b036661e607", "Charles", "A", "Bohner", "<EMAIL>", "4347 Walnut Avenue", "Boise", "ID", "83702", "M", TRUE),
(2, "6be47a14-1e5c-422a-8b41-8d95e469002f", "Julie", "C", "Roesch", "<EMAIL>", "1971 Tyler Avenue", "Ft Lauderdale", "FL", "33311", "F", TRUE),
(2, "568e1607-752d-4853-ae21-a1b29d3359f6", "Bob", "C", "Smith", "<EMAIL>", "320 Barfield Lane", "Indianapolis", "IN", "46278", "M", TRUE),
(2, "6c672ab8-c3d4-4f7b-81d1-b0a11bd7b984", "Dorothy", "J", "Fernandez", "<EMAIL>", "2512 Douglas Dairy Road", "Gate City", "VA", "24251", "F", TRUE),
(3, "7db0f8e6-4d65-4df2-b3ed-de6b8e02dac4", "William", "G", "Lukes", "<EMAIL>", "1763 Brookside Drive", "Birmingham", "AL", "35222", "M", TRUE),
(2, "dcadc958-c1c9-44e7-ba79-91ba10b2d05c", "Anna", "H", "Khan", "<EMAIL>", "2580 Williams Mine Road", "Somerville", "NJ", "08876", "F", TRUE),
(2, "d80fbec2-0ce3-40cb-9f07-70e236372d6c", "Randall", "K", "Fellows", "<EMAIL>", "2447 Emma Street", "Lubbock", "TX", "79410", "M", TRUE),
(2, "7017b2e1-8d87-4dfd-87d6-5579b82741b4", "Kimberly", "M", "Miller", "<EMAIL>", "2329 Chardonnay Drive", "La Center", "WA", "98629", "F", TRUE),
(2, "26d52f8c-49b7-426e-931d-8ad5f351e4fa", "Bill", "T", "Rios", "<EMAIL>", "3823 Eagle Street", "Fairview Heights", "IL", "62208", "M", TRUE),
(3, "3f88265e-b2b2-450c-878d-59f14ee76bfd", "Jennifer", "C", "Taylor", "<EMAIL>", "4771 Simons Hollow Road", "Middletown", "PA", "10940", "F", TRUE),
(3, "3695ea56-b8c4-47f0-8e70-8825e3cf81d9", "John", "R", "Breen", "<EMAIL>", "4530 Collins Street", "Tampa", "FL", "33624", "M", TRUE),
(3, "6c5ef621-4d48-4b65-9199-3be4e8431039", "Zada", "R", "Coppa", "<EMAIL>", "2671 Tree Frog Lane", "Kansas City", "MO", "64106", "F", TRUE),
(2, "a6e8d104-7f47-417c-af0b-e4ebd96b15ae", "Martin", "A", "Walker", "<EMAIL>", "2938 Kimberly Way", "Boston", "MA", "02109", "M", TRUE),<commit_msg>Update sample data, add images and remove deprecated ones<commit_after>SET NAMES utf8;

--
-- Sample data for groups
--

INSERT INTO groups(name, sess_seconds) VALUES
("Trial", 3600),
("Basic", 7200),
("Premium", 7200);

--
-- Sample data for images
--

INSERT INTO images(width, height, url, title, artist, gallery, organization, media) VALUES
(2048, 1363, "https://lh3.googleusercontent.com/e3FUFq1JSt7xRjwF-0C2DVUynCwsmu27TNqpo1p8OTK0TxrhxkFR6w", "Del Norte Coast Redwoods State Park, CA", "<NAME>", "Featured photos", "Google+", "Photo"),
(379, 512, "https://lh3.ggpht.com/RbL9u5vdZMxltINmK5w48iS3_fMhfjVR7SxD-MMB1OZShj9OnynDhdAcvk7N3JDzvdbR-tk", "Portrait of <NAME>", "<NAME>", "The J. Paul Getty Museum", "Google Cultural Institute", "Art"),
(455, 512, "https://lh3.ggpht.com/tF611zF3LcdZLnJqCPmnNwvsuN4rAjwPNzrO5Uu4G8HT1iPUzmBI7w", "The wattles", "<NAME>", "Art Gallery of New South Wales", "Google Cultural Institute", "Art"),
(512, 384, "https://lh4.ggpht.com/CpBfF0vqJ2eqiL5Af3J5VtbqmIZQ9IpM2NJFdmE_49gGV2YIm0muJnMibzjpm-9cqxfOgg", "Envol pastel", "Octave Pixel", "galerie TACT: Fresh artistes", "Google Open Gallery", "Art"),
(2048, 1365, "https://lh3.ggpht.com/XprZKBFc-ErF-K_KKJEcWqiwwrsbn3BCg4yBlManYe0x2c-E6K4m2EFT1vYjrrae_VUMslw", "Manhattan", "Anatoliy Urbanskiy", "Featured photos", "Google+", "Photo"),
(512, 222, "https://lh3.ggpht.com/6swp7Zh21xlvw8NOEXYrMrUrcMSzzNvPd-3nZsR5RrrTQRTaMrKsdhIx4nHbVYyNmib2Jo_T9rR-gXQ", NULL, "<NAME>", NULL, NULL, "Photo"),
(512, 342, "https://lh3.ggpht.com/Vor04AFDXMTOb9tE0D0eK5zkuyKwHjvfjegcFd1sJxlfZWMeTFbjuMTo0PPQ6pHHQx5--Cc4eT48d9g", NULL, "<NAME>", NULL, NULL, "Photo"),
(512, 311, "https://lh3.ggpht.com/sDM3YrHDSPg4o75K8cna0M2N0yMSkXEC80Cc8AQL0YiNntHbmo9YPkRJ936wmsDubXGeBCxneBeTFpU", NULL, "<NAME>", NULL, NULL, "Photo"),
(2048, 1365, "https://lh3.ggpht.com/pwOiNl9yVpvleSguShs3MtXwUOPfMLtrQ3B4WUEoj0UR2bXgUEG1", "Early morning Bronte Beach", "<NAME>", NULL, NULL, "Photo"),
(5211, 3211, "https://lh3.googleusercontent.com/hOr_QhX6R5di5iNPeZrnnkRTYryR5wZOMImK-6a1PtR3xf2c_8vdf8IKREFTsk238M6I9CuDNVR_KKkvC-0GdkY", NULL, "<NAME>", "Featured photos", "Google+", "Photo"),
(4897, 3266, "https://lh3.googleusercontent.com/GsfNjcjFACRpeMD9-xrFY63QYmZluzEBSVEfbHosF3UkYSCgKRVqpQWYKnnmm-9vKLyzeQ1ZWK8LdT1T6ZYJEwc", NULL, "<NAME>", "Featured photos", "Google+", "Photo"),
(2048, 1367, "https://lh3.googleusercontent.com/lkrPyI9ETvIB-ghAZyAZMKLXE0MI2nRqnPy_U6YbWd8hajrLr06mFA", "Milsons Point, Sydney, Australia", "<NAME>", "Featured photos", "Google+", "Photo");

--
-- Sample data for images-groups
--

INSERT INTO images_groups(group_id, image_id) VALUES
(1, 5),
(2, 1),
(2, 4),
(2, 5),
(3, 1),
(3, 2),
(3, 3),
(3, 4),
(3, 5),
(3, 6),
(3, 7),
(3, 8),
(3, 9),
(3, 10),
(3, 11),
(3, 12);

--
-- Sample data for users
--

INSERT INTO users (group_id, guid, first_name, middle_init, last_name, email, addr, city, state, zip, gender, status) VALUES
(2, "3efd7840-14f8-4c34-83fe-8b036661e607", "Charles", "A", "Bohner", "<EMAIL>", "4347 Walnut Avenue", "Boise", "ID", "83702", "M", TRUE),
(2, "6be47a14-1e5c-422a-8b41-8d95e469002f", "Julie", "C", "Roesch", "<EMAIL>", "1971 Tyler Avenue", "Ft Lauderdale", "FL", "33311", "F", TRUE),
(2, "568e1607-752d-4853-ae21-a1b29d3359f6", "Bob", "C", "Smith", "<EMAIL>", "320 Barfield Lane", "Indianapolis", "IN", "46278", "M", TRUE),
(2, "6c672ab8-c3d4-4f7b-81d1-b0a11bd7b984", "Dorothy", "J", "Fernandez", "<EMAIL>", "2512 Douglas Dairy Road", "Gate City", "VA", "24251", "F", TRUE),
(3, "7db0f8e6-4d65-4df2-b3ed-de6b8e02dac4", "William", "G", "Lukes", "<EMAIL>", "1763 Brookside Drive", "Birmingham", "AL", "35222", "M", TRUE),
(2, "dcadc958-c1c9-44e7-ba79-91ba10b2d05c", "Anna", "H", "Khan", "<EMAIL>", "2580 Williams Mine Road", "Somerville", "NJ", "08876", "F", TRUE),
(2, "d80fbec2-0ce3-40cb-9f07-70e236372d6c", "Randall", "K", "Fellows", "<EMAIL>", "2447 Emma Street", "Lubbock", "TX", "79410", "M", TRUE),
(2, "7017b2e1-8d87-4dfd-87d6-5579b82741b4", "Kimberly", "M", "Miller", "<EMAIL>", "2329 Chardonnay Drive", "La Center", "WA", "98629", "F", TRUE),
(2, "26d52f8c-49b7-426e-931d-8ad5f351e4fa", "Bill", "T", "Rios", "<EMAIL>", "3823 Eagle Street", "Fairview Heights", "IL", "62208", "M", TRUE),
(3, "3f88265e-b2b2-450c-878d-59f14ee76bfd", "Jennifer", "C", "Taylor", "<EMAIL>", "4771 Simons Hollow Road", "Middletown", "PA", "10940", "F", TRUE),
(3, "3695ea56-b8c4-47f0-8e70-8825e3cf81d9", "John", "R", "Breen", "<EMAIL>", "4530 Collins Street", "Tampa", "FL", "33624", "M", TRUE),
(3, "6c5ef621-4d48-4b65-9199-3be4e8431039", "Zada", "R", "Coppa", "<EMAIL>", "2671 Tree Frog Lane", "Kansas City", "MO", "64106", "F", TRUE),
(2, "a6e8d104-7f47-417c-af0b-e4ebd96b15ae", "Martin", "A", "Walker", "<EMAIL>", "2938 Kimberly Way", "Boston", "MA", "02109", "M", TRUE),
{'fraction_non_alphanumeric': 0.21776569227283027, 'fraction_numerical': 0.14332653523680036, 'mean_word_length': 6.763412489006156, 'pattern_counts': {'":': 0, '<': 48, '<?xml version=': 0, '>': 48, 'https://': 21, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '747639', 'n_tokens_mistral': 4958, 'n_tokens_neox': 4316, 'n_words': 810}