INSERT INTO cyber_lookup ( `vName` ,`vValue` )
VALUES ( 'profFeatureText', 'Have your profile placed at the top of search listings by making it "Featured" for ${FEATUREAMT}');
INSERT INTO cyber_lookup (`vName`, `vValue`) VALUES ('enable_captcha', 'Yes'), ('enable_user_search', 'Yes');
INSERT INTO cyber_lookup (`vName`, `vValue`) VALUES ('recaptcha_public_key', ''), ('recaptcha_private_key', '');
ALTER TABLE `cyber_Help` ADD COLUMN `helptext` TEXT NULL AFTER `himage`;
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(11, 1, 'Main', 'The main settings lets you define the primary parameters upon which the site operates', 9, '1', '1239251994_themeeditor.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(4, 26, 'Sign Up', 'Here, you can sign up with the website.', 3, '1', '1239272826_register.gif', 'Sign up with the website here.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(46, 7, 'Alert Settings', 'Here, you can control the alert system. You can also decide how/when it will be displayed.', 44, '1', '1239271935_events.gif', 'Control the alert system. Decide how and when it will be displayed.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(12, 1, 'Admin Profile', 'The area specifies all the private data of the site admin like the password and emails', 10, '1', '1239251959_editprofile.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(13, 1, 'Registration', 'The area specifies all the registration options of the site like plan type and amount.', 11, '1', '1239251951_register.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(14, 1, 'Payment', 'The area specifies all the payment options of the site like payment gateways and login information.', 12, '1', '1239251901_Manage-Payments.jpg', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(15, 1, 'Mail Template', 'The area specifies all the email contents for the mails mails being sent out of the system.', 13, '1', '1239251894_message.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(16, 1, 'Background Check Settings', 'The area specifies login information to the backgroundcheck.com API', 14, '1', '1239251885_home.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(17, 1, 'Chat', 'The area could be used to clear out the old chat logs to free the system resources.', 15, '1', '1239251847_chat.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(18, 2, 'Manage Users', 'All the users registered with the site could be managed from this screen.', 16, '1', '1239251836_user.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(19, 3, 'Manage Payments', 'All the payments received by the site could be seen here', 17, '1', '1239251826_Manage-Payments.jpg', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(20, 9, 'Manage Interest', 'This screen shows all the interests expressed between all members', 18, '1', '1239251810_features.jpg', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(21, 10, 'Manage Messages', 'This will display all messages sent between all memebers', 19, '1', '1239251487_message.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(22, 11, 'View Referral Source', 'All details regarding how a user heard about your site will be available on this screen', 20, '1', '1239259533_testimonisles.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(23, 12, 'Manage Events', 'Single events could be managed from this screen', 21, '1', '1239259509_events.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(24, 13, 'Manage Abuse', 'Abuses posted by members against other members could be managed from here.', 22, '1', '1239259499_home.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(25, 14, 'Manage Contents', 'You can manage the content pages from this screen.', 23, '1', '1239259489_editprofile.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(26, 15, 'Manage Current Style', 'You can edit the CSS style sheet from this screen. We recommend that you select a theme that matches your website and edit the CSS to give a unique look and feel.', 24, '1', '1239259448_themeeditor.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(27, 16, 'Manage Free Codes', 'The free code(s) are for every user so that they can test the site free of cost.  This is a great marketing tool to seed your website.', 25, '1', '1239259438_other.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(28, 17, 'Manage Testimonials', 'All testimonials by the users can be managed from this section.', 26, '1', '1239259428_testimonisles.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(29, 18, 'Manage Backgroundcheck results', 'You can manage the status of the background checks right here. This is a crucial feature for the safety of our members. For this feature to work, you need a background check provider like: backgroundchecks.com.', 27, '1', '1239259417_other.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(30, 20, 'Manage Metatags', 'You can set/change your meta tags from here.', 28, '1', '1239259394_other.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(31, 21, 'Manage Success Stories', 'Users can post successful dating stories here. The admin can edit these stories.', 29, '1', '1239259384_story.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(32, 24, 'Manage Countries', 'You can select/manage countries from here.', 30, '1', '1239259346_other.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(33, 23, 'Manage States', 'You can select/manage states from here.', 31, '1', '1239259357_other.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(34, 25, 'Help Category', 'You can list the help categories here.', 33, '1', '1239259304_home.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(35, 25, 'Admin Section Help', 'The admin help will handle any topic listed here.', 34, '1', '1239259295_home.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(36, 25, 'Client Section Help', 'All the client site help topics are managed here', 32, '1', '1239271631_home.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(37, 26, 'My Profile', 'My Profile gives you a preview of your profile page', 35, '1', '1239271440_user.gif', 'Use "My Profile" to preview your profile page.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(38, 26, 'Search/Browse', 'You can search for profiles that match your search criteria from here.', 36, '1', '1239271422_sarch.gif', 'Search for profiles that match your specific criteria.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(39, 26, 'Background Check', 'You can apply for a Background Check to make your profile more popular and trustworthy.', 37, '1', '1239271393_other.gif', 'Use the background check feature to make your profile more popular and trustworthy.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(40, 26, 'Hot List', 'This page will show all of the profiles located in the ''Hot List''.', 38, '1', '1239271383_features.jpg', 'This page displays all profiles on the "Hot List".');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(41, 26, ' Mail', 'Here, you can view your inbox, outbox, and the chat forum using Instant Messenger. Now, you can see all of the messages you have either received or sent to other members of the site.', 39, '1', '1239271372_message.gif', 'View your inbox, outbox, and the chat forum using the instant messenger. Now you can see all of the messages you have either received or sent to other members of the site.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(42, 26, 'Tell a Friend', 'You could tell your friends about this site using this page.', 40, '1', '1239271361_Manage referral.jpg', 'Spread the word! Telll your friends about this site using this page.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(43, 26, ' Events', 'You could see all the upcoming single events from this screen.', 41, '1', '1239271223_events.gif', 'See all upcoming singles events from this screen.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(44, 26, 'Contact Us', 'This page could be used to contact the site administrator.', 42, '1', '1239271465_editprofile.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(45, 7, 'Profile', 'Here, you can submit your personal information for all of your members to see. Examples include: appearance, life style, etc.', 43, '1', '1239271514_editprofile.gif', 'Add your personal information so members can get an idea of who you are.  Examples include: appearance, lifestyle, etc.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(47, 7, 'Change Password', 'You could change your password from here.', 45, '1', '1239271899_other.gif', 'Want to change your password? Change it here.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(48, 7, 'My Payments', 'You can see all of your payments here.', 46, '1', '1239271907_Manage-Payments.jpg', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(49, 6, 'IM List/Requests', 'All IM friend requests are listed here.', 47, '1', '1239272017_chat.gif', 'All instant message friend requests are listed here');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(50, 6, 'Message Received', 'This should be called the ''Inbox''. You can view all of your inbox messages here.', 48, '1', '1239271978_message.gif', 'This is your inbox.  View all of your inbox messages here.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(51, 6, 'Message Sent', 'All messages sent are displayed here.', 49, '1', '1239271971_message.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(52, 6, 'Interest Received', 'You can view people who are interested in you. ''Received Interests'' should be the title.', 50, '1', '1239272003_features.jpg', 'View people who are interested in you. These are interests you have received from other people.');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(53, 6, 'Interest Sent', 'What is interest sent? It should be called, Interests instead. You can see who you are interested in here.', 51, '1', '1239271962_features.jpg', 'You can see who you are interested in here.  These are all the alerts you have sent to other members to let them know you would like to get to know them. ');
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(54, 4, 'Background Check', 'You can apply for a Background Check to make your profile more popular and trustworthy.', 52, '1', '1239272066_other.gif', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(55, 4, 'Hot List', 'This page will show all the profiles that has been added by you as HOT.', 53, '1', '1239272093_features.jpg', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(56, 4, ' Buy Credits', 'You can purchase more credits here.', 54, '1', '1239272265_Feedbacks.jpg', NULL);
INSERT INTO `cyber_Help` (`hid`, `hcid`, `htitle`, `hdescription`, `hposition`, `active`, `himage`, `helptext`) VALUES(57, 4, ' Success Story', 'All the success stories could be read from here.', 55, '1', '1239272404_story.gif', 'Read the success stories of other members.');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(1, 1, 'AL', 'ALABAMA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(2, 1, 'AK', 'ALASKA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(4, 1, 'AZ', 'ARIZONA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(197, 0, '', 'as12', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(6, 1, 'CA', 'CALIFORNIA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(7, 1, 'CO', 'COLORADO', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(8, 1, 'CT', 'CONNECTICUT', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(9, 1, 'DE', 'DELAWARE', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(225, 0, '', 'Aliant(Canada)', '1');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(11, 1, 'DC', 'DISTRICT OF COLUMBIA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(12, 1, 'FL', 'FLORIDA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(13, 1, 'GA', 'GEORGIA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(14, 1, 'AR', 'ARKANSAS', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(15, 1, 'HI', 'HAWAII', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(16, 1, 'ID', 'IDAHO', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(17, 1, 'IL', 'ILLINOIS', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(18, 1, 'IN', 'INDIANA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(19, 1, 'IA', 'IOWA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(20, 1, 'KS', 'KANSAS', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(21, 1, 'KY', 'KENTUCKY', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(22, 1, 'LA', 'LOUISIANA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(23, 1, 'ME', 'MAINE', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(25, 1, 'MD', 'MARYLAND', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(26, 1, 'MA', 'MASSACHUSETTS', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(27, 1, 'MI', 'MICHIGAN', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(28, 1, 'MN', 'MINNESOTA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(29, 1, 'MS', 'MISSISSIPPI', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(30, 1, 'MO', 'MISSOURI', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(31, 1, 'MT', 'MONTANA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(32, 1, 'NE', 'NEBRASKA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(33, 1, 'NV', 'NEVADA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(34, 1, 'NH', 'NEW HAMPSHIRE', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(35, 1, 'NJ', 'NEW JERSEY', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(36, 1, 'NM', 'NEW MEXICO', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(37, 1, 'NY', 'NEW YORK', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(38, 1, 'NC', 'NORTH CAROLINA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(39, 1, 'ND', 'NORTH DAKOTA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(40, 1, 'MP', 'NORTHERN MARIANA ISLANDS', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(41, 1, 'OH', 'OHIO', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(42, 1, 'OK', 'OKLAHOMA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(43, 1, 'OR', 'OREGON', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(44, 1, 'PW', 'PALAU', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(45, 1, 'PA', 'PENNSYLVANIA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(46, 1, 'PR', 'PUERTO RICO', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(47, 1, 'RI', 'RHODE ISLAND', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(48, 1, 'SC', 'SOUTH CAROLINA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(49, 1, 'SD', 'SOUTH DAKOTA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(50, 1, 'TN', 'TENNESSEE', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(51, 1, 'TX', 'TEXAS', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(52, 1, 'UT', 'UTAH', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(53, 1, 'VT', 'VERMONT', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(54, 1, 'VI', 'VIRGIN ISLANDS', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(55, 1, 'VA', 'VIRGINIA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(56, 1, 'WA', 'WASHINGTON', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(57, 1, 'WV', 'WEST VIRGINIA', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(58, 1, 'WI', 'WISCONSIN', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(59, 1, 'WY', 'WYOMING', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(222, 0, '', 'abc1', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(62, 3, 'BC', 'British Columbia', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(63, 3, 'MB', 'Manitoba', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(64, 3, 'NB', 'New Brunswick', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(217, 0, '', 'Algeria', '1');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(66, 3, 'NT', 'Northwest Territories', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(67, 3, 'NS', 'Nova Scotia', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(68, 3, 'NU', 'Nunavut', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(224, 0, '', 'ds', '1');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(220, 0, '', '12', '1');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(221, 0, '', '1', '1');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(227, 0, '', 'Algeria1', '1');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(228, 0, '', 'a', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(229, 0, '', 'abc1', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(77, 2, 'BM', 'Bihar', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(78, 2, 'CHH', 'Chhattisgarh', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(79, 2, 'ND', 'New Delhi', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(195, 0, '', 'Algeria', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(81, 2, 'GJ', 'Gujarat', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(82, 2, 'HA', 'Haryana', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(83, 2, 'HP', 'Himachal Pradesh', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(84, 2, 'JK', 'Jammu and Kashmir', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(86, 2, 'KT', 'Karnataka', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(88, 2, 'MP', 'Madhya Pradesh', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(89, 2, 'MH', 'Maharashtra', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(90, 2, 'MN', 'Manipur', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(91, 2, 'MG', 'Meghalaya', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(93, 2, 'MZ', 'Mizoram', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(94, 2, 'NG', 'Nagaland', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(95, 2, 'OR', 'Orissa', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(96, 2, 'PN', 'Punjab', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(97, 2, 'RJ', 'Rajasthan', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(98, 2, 'SK', 'Sikkim', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(99, 2, 'TN', 'Tamil Nadu', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(100, 2, 'TP', 'Tripura', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(101, 2, 'UT', 'Uttaranchal', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(102, 2, 'UP', 'Uttar Pradesh', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(103, 2, 'WB', 'West Bengal', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(110, 17, 'VT', 'Victoria', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(112, 17, 'WA', 'Western Australia', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(113, 211, 'BF', 'Bedfordshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(114, 211, 'BK', 'Berkshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(115, 211, 'BH', 'Buckinghamshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(116, 211, 'CB', 'Cambridgeshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(117, 211, 'CS', 'Cheshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(118, 211, 'CW', 'Cornwall', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(119, 211, 'CR', 'Cumbria', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(120, 211, 'DB', 'Derbyshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(121, 211, 'DV', 'Devon', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(122, 211, 'DS', 'Dorset', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(123, 211, 'DH', 'Durham', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(124, 211, 'ES', 'Essex', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(125, 211, 'GS', 'Gloucestershire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(126, 211, 'HP', 'Hampshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(127, 211, 'HF', 'Hertfordshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(128, 211, 'HD', 'Huntingdonshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(129, 211, 'KE', 'Kent', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(130, 211, 'LC', 'Lancashire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(131, 211, 'LS', 'Leicestershire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(132, 211, 'LN', 'Lincolnshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(133, 211, 'MD', 'Middlesex', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(134, 211, 'NF', 'Norfolk', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(135, 211, 'NA', 'Northamptonshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(136, 211, 'NU', 'Northumberland', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(137, 211, 'NT', 'Nottinghamshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(138, 211, 'OF', 'Oxfordshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(139, 211, 'RL', 'Rutland', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(140, 211, 'SP', 'Shropshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(141, 211, 'SS', 'Somerset', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(142, 211, 'SF', 'Staffordshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(143, 211, 'SL', 'Suffolk', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(144, 211, 'SR', 'Surrey', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(145, 211, 'SX', 'Sussex', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(146, 211, 'WW', 'Warwickshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(147, 211, 'WM', 'Westmoreland', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(148, 211, 'WL', 'Wiltshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(149, 211, 'WT', 'Worcestershire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(150, 211, 'YK', 'Yorkshire', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(160, 0, '', 'as12', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(163, 0, '', 's', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(196, 0, '', 'Algeria', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(165, 0, '', 'dd', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(193, 289, '', 'Albania', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(194, 0, '', 'Algeria1', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(180, 0, '', 'hhh', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(198, 0, '', 'Albania', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(192, 0, '', 'Albania1', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(200, 0, '', 'Angola1', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(214, 6, 'abc11', 'abc11', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(203, 0, '', 'Andorra', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(204, 0, '', 'Albania', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(205, 0, '', 'AmericanSamoa', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(207, 0, '', 'Canada', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(208, 0, '', 'Albania1', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(209, 0, '', 'Albania', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(210, 0, '', 'Albania', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(211, 0, '', 'Albania1', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(212, 0, '', 'Anguilla', 'A');
INSERT INTO `cyber_state` (`ts_id`, `tc_id`, `ts_code`, `ts_name`, `ts_status`) VALUES(213, 0, '', 'Andorra', 'A');
INSERT INTO `cyber_lookup` (`vName`) VALUES ('enable_same_sex_search');
UPDATE `cyber_lookup` SET `vValue`='N' WHERE  `vName`='enable_same_sex_search' AND `vValue`='' LIMIT 1;
INSERT INTO `cyber_lookup` (`vName`) VALUES ('propay_demo');
INSERT INTO `cyber_lookup` (`vName`) VALUES ('propay_token');
INSERT INTO `cyber_lookup` (`vName`) VALUES ('propay_billerid');
INSERT INTO `cyber_lookup` (`vName`) VALUES ('iPhone_parse_phrase');
INSERT INTO `cyber_lookup` (`vName`,`vValue`) VALUES ('PMFileName','iphone.pm');
INSERT INTO `cyber_lookup` (`vName`,`vValue`) VALUES ('enable_pushbk_notification','N');
INSERT INTO `cyber_lookup` (`vName`) VALUES ('facebook_app_id');
INSERT INTO `cyber_lookup` (`vName`) VALUES ('facebook_secret_id');
ALTER TABLE `cyber_Help` ADD COLUMN `helptext` TEXT NULL AFTER `himage`;
CREATE TABLE `cyber_user_devices` (
	`user_device_id` INT(10) NULL AUTO_INCREMENT,
	`user_id` INT(10) NULL DEFAULT '0',
	`device` VARCHAR(255) NULL,
	`device_id` VARCHAR(255) NULL,
	PRIMARY KEY (`user_device_id`)
)ENGINE=MyISAM;