<commit_before>--
--
-- Title:         Sample Data CMS File
--
-- Author:        <NAME> <<EMAIL>>
-- Copyright:     (c) 2012-2013, <NAME>. All Rights Reserved.
-- License:       GNU General Public License; See PH7.LICENSE.txt and PH7.COPYRIGHT.txt in the root directory.
-- Package:       PH7 / Install / Data / Sql
-- Version:       1.0
--
--

-- Sample Members --

SET @iTotalMembers = 12;
SET @iGroupId = 2; -- 1 = Visitor, 9 = Pending, 2 = Regular (Free), 4 = Platinum, 5 = Silver, 6 = Gold
SET @iUserStatus = 1; -- 0 = Offline, 1 = Online, 2 = Busy, 3 = Away
SET @sCurrentDate = CURRENT_TIMESTAMP;
SET @sPassword = SHA1(RAND() + UNIX_TIMESTAMP());


INSERT INTO pH7_Members (email, username, password, firstName, lastName, birthDate, sex, matchSex, ip, lastActivity, featured, active, userStatus, groupId, joinDate) VALUES

('<EMAIL>', 'garcia', @sPassword, '<PASSWORD>', 'Park', '1992-11-21', 'female', 'male', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'peter22', @sPassword, 'Peter', '<PASSWORD>hard', '1977-12-21', 'male', '', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'katin', @sPassword, 'Katin', 'Layjyr', '1988-12-21', 'female', 'male', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'trinityI', @sPassword, '<PASSWORD>', 'Rivic', '1988-12-21', 'female', 'male,female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'JohnH', @sPassword, '<PASSWORD>', '<PASSWORD>', '1988-12-21', 'male', 'female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', '<PASSWORD>R', @sPassword, '<PASSWORD>', 'Storn', '1968-12-21', 'male', '', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'kate62', @sPassword, '<PASSWORD>', 'Sl<PASSWORD>', '1988-12-21', 'female', 'male,female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'MarkO', @sPassword, '<PASSWORD>', '<PASSWORD>', '1978-01-21', 'male', 'male,female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'Tom4', @sPassword, '<PASSWORD>', '<PASSWORD>', '1992-12-21', 'male', 'female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'rachO0O', @sPassword, '<PASSWORD>', '<PASSWORD>', '1968-02-10', 'female', 'male', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'St<PASSWORD>', @sPassword, '<PASSWORD>', 'Upton', '1988-12-21', 'male', 'male,female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'EmmaROK', @sPassword, '<PASSWORD>', '<PASSWORD>', '1992-06-16', 'female', 'male,female,couple', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate);
SET @iProfileId = LAST_INSERT_ID();


INSERT INTO pH7_MembersInfo (profileId, description, city, state, zipCode, country) VALUES
(@iProfileId, 'Hello to all', 'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+1, 'Hello to all', 'New York', 'New York', '11226', 'US'),
(@iProfileId+2, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+3, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+4, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+5, 'Hi all, my name is Anton.',  'Abinsk', 'Abinsk', '353320', 'RU'),
(@iProfileId+6, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+7, 'Hi baby!<br /> I am a handsome man tall and dark as women love.<br /> Come talk to me because you will not regret it!',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+8, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+9, 'Hello to all',  'Dolton', 'Illinois', '60419', 'US'),
(@iProfileId+10, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+11,  'Hmmm, you\'ll see. I like to spend my free time on the Internet or traveling in different cities, places, mountain or sea...<br /> Listening good music of course.<br />See you soon! ;)', 'Soho', 'Westminster London', '139 L8', 'UK');


INSERT INTO pH7_MembersPrivacy (profileId, privacyProfile, searchProfile, userSaveViews) VALUES
(@iProfileId, 'all', 'yes', 'yes'),
(@iProfileId+1, 'all', 'yes', 'yes'),
(@iProfileId+2, 'all', 'yes', 'yes'),
(@iProfileId+3, 'all', 'yes', 'yes'),
(@iProfileId+4, 'all', 'yes', 'yes'),
(@iProfileId+5, 'all', 'yes', 'yes'),
(@iProfileId+6, 'all', 'yes', 'yes'),
(@iProfileId+7, 'all', 'yes', 'yes'),<commit_msg>Bug fix<commit_after>--
--
-- Title:         Sample Data CMS File
--
-- Author:        <NAME> <<EMAIL>>
-- Copyright:     (c) 2012-2013, <NAME>. All Rights Reserved.
-- License:       GNU General Public License; See PH7.LICENSE.txt and PH7.COPYRIGHT.txt in the root directory.
-- Package:       PH7 / Install / Data / Sql
-- Version:       1.0
--
--

-- Sample Members --

SET @iTotalMembers = 12;
SET @iGroupId = 2; -- 1 = Visitor, 9 = Pending, 2 = Regular (Free), 4 = Platinum, 5 = Silver, 6 = Gold
SET @iUserStatus = 1; -- 0 = Offline, 1 = Online, 2 = Busy, 3 = Away
SET @sCurrentDate = CURRENT_TIMESTAMP;
SET @sPassword = SHA1(RAND() + UNIX_TIMESTAMP());


INSERT INTO pH7_Members (email, username, password, firstName, lastName, birthDate, sex, matchSex, ip, lastActivity, featured, active, userStatus, groupId, joinDate) VALUES

('<EMAIL>', 'garcia', @sPassword, 'Grace', 'Park', '1992-11-21', 'female', 'male', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'peter22', @sPassword, 'Peter', 'Backhard', '1977-12-21', 'male', '', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'katin', @sPassword, 'Katin', '<PASSWORD>yr', '1988-12-21', 'female', 'male', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'trinityI', @sPassword, 'Trinity', 'Rivic', '1988-12-21', 'female', 'male,female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'JohnH', @sPassword, 'John', '<PASSWORD>gh', '1988-12-21', 'male', 'female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'AntonR', @sPassword, '<PASSWORD>on', 'Storn', '1968-12-21', 'male', '', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'kate62', @sPassword, '<PASSWORD>', 'Slater', '1988-12-21', 'female', 'male,female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'MarkO', @sPassword, 'Mark', 'Yohir', '1978-01-21', 'male', 'male,female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'Tom4', @sPassword, '<PASSWORD>', '<PASSWORD>', '1992-12-21', 'male', 'female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', '<PASSWORD>', @sPassword, 'Rachel', 'Žarko', '1968-02-10', 'female', 'male', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', '<PASSWORD>', @sPassword, '<PASSWORD>', 'Upton', '1988-12-21', 'male', 'male,female', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate),

('<EMAIL>', 'EmmaROK', @sPassword, '<PASSWORD>', 'Solon', '1992-06-16', 'female', 'male,female,couple', '127.0.0.1', @sCurrentDate, 0, 1, @iUserStatus, @iGroupId, @sCurrentDate);
SET @iProfileId = LAST_INSERT_ID();


INSERT INTO pH7_MembersInfo (profileId, description, city, state, zipCode, country) VALUES
(@iProfileId, 'Hello to all', 'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+1, 'Hello to all', 'New York', 'New York', '11226', 'US'),
(@iProfileId+2, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+3, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+4, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+5, 'Hi all, my name is Anton.',  'Abinsk', 'Abinsk', '353320', 'RU'),
(@iProfileId+6, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+7, 'Hi baby!<br /> I am a handsome man tall and dark as women love.<br /> Come talk to me because you will not regret it!',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+8, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+9, 'Hello to all',  'Dolton', 'Illinois', '60419', 'US'),
(@iProfileId+10, 'Hello to all',  'Manhattan', 'Manhattan', '10002', 'US'),
(@iProfileId+11,  'Hmmm, you''ll see. I like to spend my free time on the Internet or traveling in different cities, places, mountain or sea...<br /> Listening good music of course.<br />See you soon! ;)', 'Soho', 'Westminster London', '139 L8', 'UK');


INSERT INTO pH7_MembersPrivacy (profileId, privacyProfile, searchProfile, userSaveViews) VALUES
(@iProfileId, 'all', 'yes', 'yes'),
(@iProfileId+1, 'all', 'yes', 'yes'),
(@iProfileId+2, 'all', 'yes', 'yes'),
(@iProfileId+3, 'all', 'yes', 'yes'),
(@iProfileId+4, 'all', 'yes', 'yes'),
(@iProfileId+5, 'all', 'yes', 'yes'),
(@iProfileId+6, 'all', 'yes', 'yes'),
(@iProfileId+7, 'all', 'yes', 'yes'),
{'fraction_non_alphanumeric': 0.23903772553307817, 'fraction_numerical': 0.06746856205576818, 'mean_word_length': 5.575125808770669, 'pattern_counts': {'":': 0, '<': 72, '<?xml version=': 0, '>': 72, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 24, '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': '6640342', 'n_tokens_mistral': 3908, 'n_tokens_neox': 3517, 'n_words': 950}