INSERT INTO ConfigurationAdmin VALUES ('Site_Name', 'la_Text_Website', 'la_config_website_name', 'text', '', '', 10.02, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Site_Path', 'la_Text_Website', 'la_config_web_address', 'text', '', '', 10.01, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Backup_Path', 'la_Text_BackupPath', 'la_config_backup_path', 'text', '', '', 40.01, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Domain_Detect', 'la_Text_Website', 'la_config_detect_domain', 'text', '', '', 8, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Category_Sortfield', 'la_Text_General', 'la_category_sortfield_prompt', 'select', '', 'Name=la_Category_Name,Description=la_Category_Description,CreatedOn=la_Category_Date,EditorsPick=la_Category_Pick,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 1) AND (IsSystem = 0)</SQL>', 10.01, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('Category_Sortorder', 'la_Text_General', 'la_category_sortfield_prompt', 'select', '', 'asc=la_common_ascending,desc=la_common_descending', 10.01, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('Category_Sortfield2', 'la_Text_General', 'la_category_sortfield2_prompt', 'select', '', 'Name=la_Category_Name,Description=la_Category_Description,CreatedOn=la_Category_Date,EditorsPick=la_Category_Pick,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 1) AND (IsSystem = 0)</SQL>', 10.02, 1, 1);
INSERT INTO ConfigurationAdmin VALUES ('Category_Sortorder2', 'la_Text_General', 'la_category_sortfield2_prompt', 'select', '', 'asc=la_common_ascending,desc=la_common_descending', 10.02, 2, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_Category', 'la_Text_General', 'la_category_perpage_prompt', 'text', '', '', 10.03, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Category_DaysNew', 'la_Text_General', 'la_category_daysnew_prompt', 'text', '', '', 10.05, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Category_ShowPick', 'la_Text_General', 'la_category_showpick_prompt', 'checkbox', '', '', 10.06, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Category_MetaKey', 'la_Text_MetaInfo', 'la_category_metakey', 'text', '', '', 20.01, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Category_MetaDesc', 'la_Text_MetaInfo', 'la_category_metadesc', 'text', '', '', 20.02, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('User_NewGroup', 'la_Text_General', 'la_users_new_group', 'select', NULL, '0=lu_none,<SQL+>SELECT GroupId as OptionValue, Name as OptionName FROM <PREFIX>PortalGroup WHERE Enabled=1 AND Personal=0</SQL>', 10.08, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('User_GuestGroup', 'la_Text_General', 'la_users_guest_group', 'select', NULL, '0=lu_none,<SQL+>SELECT GroupId as OptionValue, Name as OptionName FROM <PREFIX>PortalGroup WHERE Enabled=1 AND Personal=0</SQL>', 10.1, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('RootPass', 'la_Text_General', 'la_prompt_root_pass', 'password', NULL, NULL, 10.12, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('Users_AllowReset', 'la_Text_General', 'la_prompt_allow_reset', 'text', NULL, NULL, 10.05, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('User_Allow_New', 'la_Text_General', 'la_users_allow_new', 'radio', '', '1=la_User_Instant,2=la_User_Not_Allowed,3=la_User_Upon_Approval', 10.01, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('User_Password_Auto', 'la_Text_General', 'la_users_password_auto', 'checkbox', '', '', 10.06, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('User_Votes_Deny', 'la_Text_Restrictions', 'la_users_votes_deny', 'text', '', '', 20.01, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('User_MembershipExpirationReminder', 'la_Text_General', 'la_MembershipExpirationReminder', 'text', NULL, '', 10.07, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('User_Review_Deny', 'la_Text_Restrictions', 'la_users_review_deny', 'text', '', '', 20.02, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Server_Name', 'la_Text_Website', 'la_config_server_name', 'text', '', '', 4, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('Config_Server_Time', 'la_Text_Date_Time_Settings', 'la_config_time_server', 'select', '', '1=la_m12,2=la_m11,3=la_m10,5=la_m9,6=la_m8,7=la_m7,8=la_m6,9=la_m5,10=la_m4,11=la_m3,12=la_m2,13=la_m1,14=la_m0,15=la_p1,16=la_p2,17=la_p3,18=la_p4,19=la_p5,20=la_p6,21=la_p7,22=la_p8,23=la_p9,24=la_p10,25=la_p11,26=la_p12,27=la_p13', 20.01, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Config_Site_Time', 'la_Text_Date_Time_Settings', 'la_config_site_zone', 'select', '', '1=la_m12,2=la_m11,3=la_m10,5=la_m9,6=la_m8,7=la_m7,8=la_m6,9=la_m5,10=la_m4,11=la_m3,12=la_m2,13=la_m1,14=la_m0,15=la_p1,16=la_p2,17=la_p3,18=la_p4,19=la_p5,20=la_p6,21=la_p7,22=la_p8,23=la_p9,24=la_p10,25=la_p11,26=la_p12,27=la_p13', 20.02, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Smtp_Server', 'la_Text_smtp_server', 'la_prompt_mailserver', 'text', NULL, NULL, 30.01, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Smtp_Port', 'la_Text_smtp_server', 'la_prompt_mailport', 'text', NULL, NULL, 30.02, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Smtp_Authenticate', 'la_Text_smtp_server', 'la_prompt_mailauthenticate', 'checkbox', NULL, NULL, 30.03, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Smtp_User', 'la_Text_smtp_server', 'la_prompt_smtp_user', 'text', NULL, NULL, 30.04, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Smtp_Pass', 'la_Text_smtp_server', 'la_prompt_smtp_pass', 'text', NULL, NULL, 30.05, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Smtp_DefaultHeaders', 'la_Text_smtp_server', 'la_prompt_smtpheaders', 'textarea', NULL, 'COLS=40 ROWS=5', 30.06, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('Smtp_AdminMailFrom', 'la_Text_smtp_server', 'la_prompt_AdminMailFrom', 'text', NULL, NULL, 30.07, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Perpage_Category_Short', 'la_Text_General', 'la_category_perpage__short_prompt', 'text', '', '', 10.04, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('CookieSessions', 'la_Text_Website', 'la_prompt_session_management', 'select', NULL, '0=lu_query_string,1=lu_cookies,2=lu_auto', 10.03, 0, 1);

INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Keyword_category', 'la_config_SearchRel_DefaultKeyword', 'la_text_keyword', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Pop_category', 'la_config_DefaultPop', 'la_text_popularity', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Rating_category', 'la_config_DefaultRating', 'la_prompt_Rating', 'text', NULL, NULL, 0, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Increase_category', 'la_config_DefaultIncreaseImportance', 'la_text_increase_importance', 'text', NULL, NULL, 0, 0, 1);

INSERT INTO ConfigurationAdmin VALUES ('SessionTimeout', 'la_Text_Website', 'la_prompt_session_timeout', 'text', '', '', 10.05, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SystemTagCache', 'la_Text_Website', 'la_prompt_syscache_enable', 'checkbox', NULL, NULL, 10.07, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('User_SubscriberGroup', 'la_Text_General', 'la_users_subscriber_group', 'select', NULL, '0=lu_none,<SQL+>SELECT GroupId as OptionValue, Name as OptionName FROM <PREFIX>PortalGroup WHERE Enabled=1 AND Personal=0</SQL>', 10.11, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Root_Name', 'la_Text_General', 'la_prompt_root_name', 'text', '', '', 10.07, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SocketBlockingMode', 'la_Text_Website', 'la_prompt_socket_blocking_mode', 'checkbox', NULL, NULL, 10.08, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('Min_UserName', 'la_Text_General', 'la_text_min_username', 'text', '', '', 10.03, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('Min_Password', 'la_Text_General', 'la_text_min_password', 'text', '', '', 10.04, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('Email_As_Login', 'la_Text_General', 'la_use_emails_as_login', 'checkbox', NULL, NULL, 10.02, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('RegistrationCaptcha', 'la_Text_General', 'la_registration_captcha', 'checkbox', NULL, NULL, 10.025, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('User_LoggedInGroup', 'la_Text_General', 'la_users_assign_all_to', 'select', NULL, '0=lu_none,<SQL+>SELECT GroupId as OptionValue, Name as OptionName FROM <PREFIX>PortalGroup WHERE Enabled=1 AND Personal=0</SQL>', 10.09, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('FirstDayOfWeek', 'la_Text_Date_Time_Settings', 'la_config_first_day_of_week', 'select', '', '0=la_sunday,1=la_monday', 20.03, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SSL_URL', 'la_Text_Website', 'la_config_ssl_url', 'text', '', '', 10.09, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Require_SSL', 'la_Text_Website', 'la_config_require_ssl', 'checkbox', '', '', 10.1, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('Force_HTTP_When_SSL_Not_Required', 'la_Text_Website', 'la_config_force_http', 'checkbox', '', '', 10.11, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SessionCookieName', 'la_Text_Website', 'la_prompt_session_cookie_name', 'text', '', '', 10.04, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('SessionReferrerCheck', 'la_Text_Website', 'la_promt_ReferrerCheck', 'checkbox', NULL, NULL, 10.06, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('UseModRewrite', 'la_Text_Website', 'la_config_use_modrewrite', 'checkbox', '', '', 10.12, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('UseModRewriteWithSSL', 'la_Text_Website', 'la_config_use_modrewrite_with_ssl', 'checkbox', '', '', 10.13, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('ErrorTemplate', 'la_Text_Website', 'la_config_error_template', 'text', '', '', 10.16, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('UseJSRedirect', 'la_Text_Website', 'la_config_use_js_redirect', 'checkbox', '', '', 10.14, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('MaxImportCategoryLevels', 'la_Text_General', 'la_prompt_max_import_category_levels', 'text', '', '', 10.08, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('UseCronForRegularEvent', 'la_Text_Website', 'la_UseCronForRegularEvent', 'checkbox', NULL, NULL, 10.15, 0, 0);
INSERT INTO ConfigurationAdmin VALUES ('NoPermissionTemplate', 'la_Text_Website', 'la_config_nopermission_template', 'text', '', '', 10.17, 0, 0);
INSERT INTO ConfigurationAdmin (VariableName, heading, prompt, element_type, validation, ValueList, DisplayOrder, GroupDisplayOrder, Install) VALUES ('UseOutputCompression', 'la_Text_Website', 'la_config_UseOutputCompression', 'checkbox', '', '', 10.18, 0, 1);
INSERT INTO ConfigurationAdmin (VariableName, heading, prompt, element_type, validation, ValueList, DisplayOrder, GroupDisplayOrder, Install) VALUES ('OutputCompressionLevel', 'la_Text_Website', 'la_config_OutputCompressionLevel', 'text', '', '', 10.19, 0, 1);
INSERT INTO ConfigurationAdmin VALUES ('MailFunctionHeaderSeparator', 'la_Text_smtp_server', 'la_config_MailFunctionHeaderSeparator', 'radio', NULL, '1=la_Linux,2=la_Windows', 30.08, 0, 0);

INSERT INTO ConfigurationValues VALUES (NULL, 'Columns_Category', '2', 'In-Portal', 'Categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'DomainSelect','1','In-Portal','in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Site_Path', '/', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Archive', '25', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'debug', '1', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_User', '100', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_LangEmail', '20', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Default_FromAddr', '', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'email_replyto', '', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'email_footer', 'message footer goes here', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Default_Theme', 'default', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Default_Language', 'English', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'SessionTimeout', '3600', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_SortOrder', 'asc', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Suggest_MinInterval', '3600', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'SubCat_ListCount', '3', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Timeout_Rating', '3600', 'In-Portal', 'System');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_SortField', 'u.CreatedOn', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Relations', '10', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Group_SortField', 'GroupName', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Group_SortOrder', 'asc', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Default_FromName', 'Webmaster', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Category', '10', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_Sortfield', 'Name', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_Sortorder', 'asc', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'MetaKeywords', NULL, 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Relation_LV_Sortfield', 'ItemType', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'ampm_time', '1', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Template', '10', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Phrase', '40', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Sessionlist', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_Sortfield2', 'Description', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_Sortorder2', 'asc', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_DaysNew', '8', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_ShowPick', '', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_MetaKey', '', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_MetaDesc', '', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'MetaDescription', NULL, 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_NewGroup', '13', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_Allow_New', '3', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_Password_Auto', '0', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_Votes_Deny', '5', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_Review_Deny', '5', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Name', '', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Company', '', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Reg_Number', '', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Website_Name', '', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Web_Address', '', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Server_Time', '14', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Config_Site_Time', '14', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Site_Name', 'In-Portal', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Backup_Path', '', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Items', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'GuestSessions', '1', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Smtp_Server', NULL, 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Smtp_Port', NULL, 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Smtp_User', NULL, 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Smtp_Pass', NULL, 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Smtp_SendHTML', '1', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Smtp_Authenticate', '0', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Email', '10', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Smtp_DefaultHeaders', 'X-Priority: 1\r\nX-MSMail-Priority: High\r\nX-Mailer: In-Portal', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Smtp_AdminMailFrom', 'portal@user.domain.name', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_Highlight_OpenTag', '<span class="match">', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'Category_Highlight_CloseTag', '</span>', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_GuestGroup', '14', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'RootPass', '', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Category_Short', '3', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'CookieSessions', '2', 'In-Portal', 'in-portal:configure_general');

INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Increase_category', '30', 'In-Portal', 'in-portal:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Keyword_category', '90', 'In-Portal', 'in-portal:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Pop_category', '5', 'In-Portal', 'in-portal:configuration_search');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_Rating_category', '5', 'In-Portal', 'in-portal:configuration_search');

INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_DefaultIncrease', '30', 'In-Portal', 'inportal:configure_searchdefault');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_DefaultKeyword', '80', 'In-Portal', 'SearchRel_DefaultKeyword');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_DefaultPop', '10', 'In-Portal', 'inportal:configuration_searchdefault');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchRel_DefaultRating', '10', 'In-Portal', 'inportal:configure_searchdefault');
INSERT INTO ConfigurationValues VALUES (NULL, 'SystemTagCache', '0', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Root_Name', 'lu_rootcategory_name', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_SubscriberGroup', '12', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'SocketBlockingMode', '0', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Min_UserName', '3', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'Min_Password', '5', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'LinksValidation_LV_Sortfield', 'ValidationTime', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'CustomConfig_LV_Sortfield', 'FieldName', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Event_LV_SortField', 'Description', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Theme_LV_SortField', 'Name', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Template_LV_SortField', 'FileName', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Lang_LV_SortField', 'PackName', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Phrase_LV_SortField', 'Phrase', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'LangEmail_LV_SortField', 'Description', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'CustomData_LV_SortField', 'FieldName', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Summary_SortField', 'Module', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Session_SortField', 'UserName', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'SearchLog_SortField', 'Keyword', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_StatItem', '10', 'inportal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Groups', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Event', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_BanRules', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_SearchLog', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_LV_lang', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_LV_Themes', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_LV_Catlist', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Reviews', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Modules', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Grouplist', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Images', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'EmailsL_SortField', 'time_sent', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_EmailsL', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_CustomData', '20', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Perpage_Review', '10', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Search_MinKeyword_Length', '3', 'In-Portal', '');
INSERT INTO ConfigurationValues VALUES (NULL, 'Users_AllowReset', '180', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'Email_As_Login', '0', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'RegistrationCaptcha', '0', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_LoggedInGroup', '15', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'User_MembershipExpirationReminder', '10', 'In-Portal:Users', 'in-portal:configure_users');
INSERT INTO ConfigurationValues VALUES (NULL, 'FirstDayOfWeek', '1', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'SSL_URL', '', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Require_SSL', '', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'Force_HTTP_When_SSL_Not_Required', '1', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'SessionCookieName', 'sid', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'UseModRewrite', '0', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'UseModRewriteWithSSL', '0', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'SessionReferrerCheck', '1', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'ErrorTemplate', 'error_notfound', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'UseJSRedirect', '0', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'MaxImportCategoryLevels', '10', 'In-Portal', 'in-portal:configure_categories');
INSERT INTO ConfigurationValues VALUES (NULL, 'UseCronForRegularEvent', '0', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (NULL, 'NoPermissionTemplate', 'no_permission', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues (VariableName, VariableValue, ModuleOwner, Section) VALUES ('UseOutputCompression', '0', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues (VariableName, VariableValue, ModuleOwner, Section) VALUES ('OutputCompressionLevel', '7', 'In-Portal', 'in-portal:configure_general');
INSERT INTO ConfigurationValues VALUES (0, 'MailFunctionHeaderSeparator', 1, 'In-Portal', 'in-portal:configure_general');

INSERT INTO Events VALUES (30, 'USER.ADD', 1, 0, 'In-Portal:Users', 'la_event_user.add', 0);
INSERT INTO Events VALUES (32, 'USER.ADD', 2, 0, 'In-Portal:Users', 'la_event_user.add', 1);
INSERT INTO Events VALUES (31, 'USER.APPROVE', 1, 0, 'In-Portal:Users', 'la_event_user.approve', 0);
INSERT INTO Events VALUES (33, 'USER.APPROVE', 2, 0, 'In-Portal:Users', 'la_event_user.approve', 1);
INSERT INTO Events VALUES (34, 'USER.VALIDATE', 1, 0, 'In-Portal:Users', 'la_event_user.validate', 0);
INSERT INTO Events VALUES (35, 'USER.VALIDATE', 2, 0, 'In-Portal:Users', 'la_event_user.validate', 1);
INSERT INTO Events VALUES (36, 'USER.DENY', 1, 0, 'In-Portal:Users', 'la_event_user.deny', 0);
INSERT INTO Events VALUES (37, 'USER.DENY', 2, 0, 'In-Portal:Users', 'la_event_user.deny', 1);
INSERT INTO Events VALUES (38, 'USER.PSWD', 2, 0, 'In-Portal:Users', 'la_event_user.forgotpw', 1);
INSERT INTO Events VALUES (39, 'USER.PSWD', 1, 0, 'In-Portal:Users', 'la_event_user.forgotpw', 0);
INSERT INTO Events VALUES (45, 'USER.ADD.PENDING', 1, 0, 'In-Portal:Users', 'la_event_user.add.pending', 0);
INSERT INTO Events VALUES (68, 'USER.ADD.PENDING', 2, 0, 'In-Portal:Users', 'la_event_user.add.pending', 1);
INSERT INTO Events VALUES (47, 'CATEGORY.ADD', 1, 0, 'In-Portal:Category', 'la_event_category.add', 0);
INSERT INTO Events VALUES (48, 'CATEGORY.ADD.PENDING', 1, 0, 'In-Portal:Category', 'la_event_category.add.pending', 0);
INSERT INTO Events VALUES (49, 'CATEGORY.ADD.PENDING', 2, 0, 'In-Portal:Category', 'la_event_category.add.pending', 1);
INSERT INTO Events VALUES (50, 'CATEGORY.ADD', 2, 0, 'In-Portal:Category', 'la_event_category.add', 1);
INSERT INTO Events VALUES (51, 'CATEGORY.DELETE', 1, 0, 'In-Portal:Category', 'la_event_category_delete', 0);
INSERT INTO Events VALUES (52, 'CATEGORY.DELETE', 2, 0, 'In-Portal:Category', 'la_event_category_delete', 1);
INSERT INTO Events VALUES (53, 'CATEGORY.MODIFY', 1, 0, 'In-Portal:Category', 'la_event_category.modify', 0);
INSERT INTO Events VALUES (54, 'CATEGORY.MODIFY', 2, 0, 'In-Portal:Category', 'la_event_category.modify', 1);
INSERT INTO Events VALUES (56, 'CATEGORY.APPROVE', 1, 0, 'In-Portal:Category', 'la_event_category.approve', 0);
INSERT INTO Events VALUES (57, 'CATEGORY.APPROVE', 2, 0, 'In-Portal:Category', 'la_event_category.approve', 1);
INSERT INTO Events VALUES (58, 'CATEGORY.DENY', 1, 0, 'In-Portal:Category', 'la_event_category.deny', 0);
INSERT INTO Events VALUES (59, 'CATEGORY.DENY', 2, 0, 'In-Portal:Category', 'la_event_category.deny', 1);
INSERT INTO Events VALUES (60, 'USER.SUBSCRIBE', 1, 0, 'In-Portal:Users', 'la_event_user.subscribe', 0);
INSERT INTO Events VALUES (61, 'USER.SUBSCRIBE', 2, 0, 'In-Portal:Users', 'la_event_user.subscribe', 1);
INSERT INTO Events VALUES (62, 'USER.UNSUBSCRIBE', 1, 0, 'In-Portal:Users', 'la_event_user.unsubscribe', 0);
INSERT INTO Events VALUES (63, 'USER.UNSUBSCRIBE', 2, 0, 'In-Portal:Users', 'la_event_user.unsubscribe', 1);
INSERT INTO Events VALUES (64, 'USER.SUGGEST', '1', '0', 'In-Portal:Users', 'la_event_user.suggest', '0');
INSERT INTO Events VALUES (65, 'USER.SUGGEST', '2', '0', 'In-Portal:Users', 'la_event_user.suggest', '1');
INSERT INTO Events VALUES (67, 'USER.PSWDC', '1', '0', 'In-Portal:Users', 'la_event_user.pswd_confirm', '0');
INSERT INTO Events VALUES ('', 'USER.MEMBERSHIP.EXPIRED', '1', '0', 'In-Portal:Users', 'la_event_user.membership_expired', '0');
INSERT INTO Events VALUES ('', 'USER.MEMBERSHIP.EXPIRED', '1', '0', 'In-Portal:Users', 'la_event_user.membership_expired', '1');
INSERT INTO Events VALUES ('', 'USER.MEMBERSHIP.EXPIRATION.NOTICE', '1', '0', 'In-Portal:Users', 'la_event_user.membership_expiration_notice', '0');
INSERT INTO Events VALUES ('', 'USER.MEMBERSHIP.EXPIRATION.NOTICE', '1', '0', 'In-Portal:Users', 'la_event_user.membership_expiration_notice', '1');
INSERT INTO Events (Event, Enabled, FromUserId, Module, Description, Type) VALUES ('COMMON.FOOTER', 1, 0, 'In-Portal', 'la_event_common.footer', 1);

INSERT INTO IdGenerator VALUES ('100');

INSERT INTO PortalGroup VALUES (15, 'Everyone', 'Everyone', 0, 1, 0, 1, 15);
INSERT INTO PortalGroup VALUES (13, 'Member', '', '1054738682', 0, 0, 1, 13);
INSERT INTO PortalGroup VALUES (12, 'Subscribers', '', '1054738670', 0, 0, 1, 12);
INSERT INTO PortalGroup VALUES (14, 'Guest', 'Guest User', '0', 1, 0, 1, 14);
INSERT INTO PortalGroup VALUES (11, 'admin', '', '1054738405', 0, 0, 1, 11);

INSERT INTO StdDestinations VALUES (1, 1, NULL, 'la_country_AFG', 'AFG', 'AF');
INSERT INTO StdDestinations VALUES (2, 1, NULL, 'la_country_ALB', 'ALB', 'AL');
INSERT INTO StdDestinations VALUES (3, 1, NULL, 'la_country_DZA', 'DZA', 'DZ');
INSERT INTO StdDestinations VALUES (4, 1, NULL, 'la_country_ASM', 'ASM', 'AS');
INSERT INTO StdDestinations VALUES (5, 1, NULL, 'la_country_AND', 'AND', 'AD');
INSERT INTO StdDestinations VALUES (6, 1, NULL, 'la_country_AGO', 'AGO', 'AO');
INSERT INTO StdDestinations VALUES (7, 1, NULL, 'la_country_AIA', 'AIA', 'AI');
INSERT INTO StdDestinations VALUES (8, 1, NULL, 'la_country_ATA', 'ATA', 'AQ');
INSERT INTO StdDestinations VALUES (9, 1, NULL, 'la_country_ATG', 'ATG', 'AG');
INSERT INTO StdDestinations VALUES (10, 1, NULL, 'la_country_ARG', 'ARG', 'AR');
INSERT INTO StdDestinations VALUES (11, 1, NULL, 'la_country_ARM', 'ARM', 'AM');
INSERT INTO StdDestinations VALUES (12, 1, NULL, 'la_country_ABW', 'ABW', 'AW');
INSERT INTO StdDestinations VALUES (13, 1, NULL, 'la_country_AUS', 'AUS', 'AU');
INSERT INTO StdDestinations VALUES (14, 1, NULL, 'la_country_AUT', 'AUT', 'AT');
INSERT INTO StdDestinations VALUES (15, 1, NULL, 'la_country_AZE', 'AZE', 'AZ');
INSERT INTO StdDestinations VALUES (16, 1, NULL, 'la_country_BHS', 'BHS', 'BS');
INSERT INTO StdDestinations VALUES (17, 1, NULL, 'la_country_BHR', 'BHR', 'BH');
INSERT INTO StdDestinations VALUES (18, 1, NULL, 'la_country_BGD', 'BGD', 'BD');
INSERT INTO StdDestinations VALUES (19, 1, NULL, 'la_country_BRB', 'BRB', 'BB');
INSERT INTO StdDestinations VALUES (20, 1, NULL, 'la_country_BLR', 'BLR', 'BY');
INSERT INTO StdDestinations VALUES (21, 1, NULL, 'la_country_BEL', 'BEL', 'BE');
INSERT INTO StdDestinations VALUES (22, 1, NULL, 'la_country_BLZ', 'BLZ', 'BZ');
INSERT INTO StdDestinations VALUES (23, 1, NULL, 'la_country_BEN', 'BEN', 'BJ');
INSERT INTO StdDestinations VALUES (24, 1, NULL, 'la_country_BMU', 'BMU', 'BM');
INSERT INTO StdDestinations VALUES (25, 1, NULL, 'la_country_BTN', 'BTN', 'BT');
INSERT INTO StdDestinations VALUES (26, 1, NULL, 'la_country_BOL', 'BOL', 'BO');
INSERT INTO StdDestinations VALUES (27, 1, NULL, 'la_country_BIH', 'BIH', 'BA');
INSERT INTO StdDestinations VALUES (28, 1, NULL, 'la_country_BWA', 'BWA', 'BW');
INSERT INTO StdDestinations VALUES (29, 1, NULL, 'la_country_BVT', 'BVT', 'BV');
INSERT INTO StdDestinations VALUES (30, 1, NULL, 'la_country_BRA', 'BRA', 'BR');
INSERT INTO StdDestinations VALUES (31, 1, NULL, 'la_country_IOT', 'IOT', 'IO');
INSERT INTO StdDestinations VALUES (32, 1, NULL, 'la_country_BRN', 'BRN', 'BN');
INSERT INTO StdDestinations VALUES (33, 1, NULL, 'la_country_BGR', 'BGR', 'BG');
INSERT INTO StdDestinations VALUES (34, 1, NULL, 'la_country_BFA', 'BFA', 'BF');
INSERT INTO StdDestinations VALUES (35, 1, NULL, 'la_country_BDI', 'BDI', 'BI');
INSERT INTO StdDestinations VALUES (36, 1, NULL, 'la_country_KHM', 'KHM', 'KH');
INSERT INTO StdDestinations VALUES (37, 1, NULL, 'la_country_CMR', 'CMR', 'CM');
INSERT INTO StdDestinations VALUES (38, 1, NULL, 'la_country_CAN', 'CAN', 'CA');
INSERT INTO StdDestinations VALUES (39, 1, NULL, 'la_country_CPV', 'CPV', 'CV');
INSERT INTO StdDestinations VALUES (40, 1, NULL, 'la_country_CYM', 'CYM', 'KY');
INSERT INTO StdDestinations VALUES (41, 1, NULL, 'la_country_CAF', 'CAF', 'CF');
INSERT INTO StdDestinations VALUES (42, 1, NULL, 'la_country_TCD', 'TCD', 'TD');
INSERT INTO StdDestinations VALUES (43, 1, NULL, 'la_country_CHL', 'CHL', 'CL');
INSERT INTO StdDestinations VALUES (44, 1, NULL, 'la_country_CHN', 'CHN', 'CN');
INSERT INTO StdDestinations VALUES (45, 1, NULL, 'la_country_CXR', 'CXR', 'CX');
INSERT INTO StdDestinations VALUES (46, 1, NULL, 'la_country_CCK', 'CCK', 'CC');
INSERT INTO StdDestinations VALUES (47, 1, NULL, 'la_country_COL', 'COL', 'CO');
INSERT INTO StdDestinations VALUES (48, 1, NULL, 'la_country_COM', 'COM', 'KM');
INSERT INTO StdDestinations VALUES (49, 1, NULL, 'la_country_COD', 'COD', 'CD');
INSERT INTO StdDestinations VALUES (50, 1, NULL, 'la_country_COG', 'COG', 'CG');
INSERT INTO StdDestinations VALUES (51, 1, NULL, 'la_country_COK', 'COK', 'CK');
INSERT INTO StdDestinations VALUES (52, 1, NULL, 'la_country_CRI', 'CRI', 'CR');
INSERT INTO StdDestinations VALUES (53, 1, NULL, 'la_country_CIV', 'CIV', 'CI');
INSERT INTO StdDestinations VALUES (54, 1, NULL, 'la_country_HRV', 'HRV', 'HR');
INSERT INTO StdDestinations VALUES (55, 1, NULL, 'la_country_CUB', 'CUB', 'CU');
INSERT INTO StdDestinations VALUES (56, 1, NULL, 'la_country_CYP', 'CYP', 'CY');
INSERT INTO StdDestinations VALUES (57, 1, NULL, 'la_country_CZE', 'CZE', 'CZ');
INSERT INTO StdDestinations VALUES (58, 1, NULL, 'la_country_DNK', 'DNK', 'DK');
INSERT INTO StdDestinations VALUES (59, 1, NULL, 'la_country_DJI', 'DJI', 'DJ');
INSERT INTO StdDestinations VALUES (60, 1, NULL, 'la_country_DMA', 'DMA', 'DM');
INSERT INTO StdDestinations VALUES (61, 1, NULL, 'la_country_DOM', 'DOM', 'DO');
INSERT INTO StdDestinations VALUES (62, 1, NULL, 'la_country_TLS', 'TLS', 'TL');
INSERT INTO StdDestinations VALUES (63, 1, NULL, 'la_country_ECU', 'ECU', 'EC');
INSERT INTO StdDestinations VALUES (64, 1, NULL, 'la_country_EGY', 'EGY', 'EG');
INSERT INTO StdDestinations VALUES (65, 1, NULL, 'la_country_SLV', 'SLV', 'SV');
INSERT INTO StdDestinations VALUES (66, 1, NULL, 'la_country_GNQ', 'GNQ', 'GQ');
INSERT INTO StdDestinations VALUES (67, 1, NULL, 'la_country_ERI', 'ERI', 'ER');
INSERT INTO StdDestinations VALUES (68, 1, NULL, 'la_country_EST', 'EST', 'EE');
INSERT INTO StdDestinations VALUES (69, 1, NULL, 'la_country_ETH', 'ETH', 'ET');
INSERT INTO StdDestinations VALUES (70, 1, NULL, 'la_country_FLK', 'FLK', 'FK');
INSERT INTO StdDestinations VALUES (71, 1, NULL, 'la_country_FRO', 'FRO', 'FO');
INSERT INTO StdDestinations VALUES (72, 1, NULL, 'la_country_FJI', 'FJI', 'FJ');
INSERT INTO StdDestinations VALUES (73, 1, NULL, 'la_country_FIN', 'FIN', 'FI');
INSERT INTO StdDestinations VALUES (74, 1, NULL, 'la_country_FRA', 'FRA', 'FR');
INSERT INTO StdDestinations VALUES (75, 1, NULL, 'la_country_FXX', 'FXX', 'FX');
INSERT INTO StdDestinations VALUES (76, 1, NULL, 'la_country_GUF', 'GUF', 'GF');
INSERT INTO StdDestinations VALUES (77, 1, NULL, 'la_country_PYF', 'PYF', 'PF');
INSERT INTO StdDestinations VALUES (78, 1, NULL, 'la_country_ATF', 'ATF', 'TF');
INSERT INTO StdDestinations VALUES (79, 1, NULL, 'la_country_GAB', 'GAB', 'GA');
INSERT INTO StdDestinations VALUES (80, 1, NULL, 'la_country_GMB', 'GMB', 'GM');
INSERT INTO StdDestinations VALUES (81, 1, NULL, 'la_country_GEO', 'GEO', 'GE');
INSERT INTO StdDestinations VALUES (82, 1, NULL, 'la_country_DEU', 'DEU', 'DE');
INSERT INTO StdDestinations VALUES (83, 1, NULL, 'la_country_GHA', 'GHA', 'GH');
INSERT INTO StdDestinations VALUES (84, 1, NULL, 'la_country_GIB', 'GIB', 'GI');
INSERT INTO StdDestinations VALUES (85, 1, NULL, 'la_country_GRC', 'GRC', 'GR');
INSERT INTO StdDestinations VALUES (86, 1, NULL, 'la_country_GRL', 'GRL', 'GL');
INSERT INTO StdDestinations VALUES (87, 1, NULL, 'la_country_GRD', 'GRD', 'GD');
INSERT INTO StdDestinations VALUES (88, 1, NULL, 'la_country_GLP', 'GLP', 'GP');
INSERT INTO StdDestinations VALUES (89, 1, NULL, 'la_country_GUM', 'GUM', 'GU');
INSERT INTO StdDestinations VALUES (90, 1, NULL, 'la_country_GTM', 'GTM', 'GT');
INSERT INTO StdDestinations VALUES (91, 1, NULL, 'la_country_GIN', 'GIN', 'GN');
INSERT INTO StdDestinations VALUES (92, 1, NULL, 'la_country_GNB', 'GNB', 'GW');
INSERT INTO StdDestinations VALUES (93, 1, NULL, 'la_country_GUY', 'GUY', 'GY');
INSERT INTO StdDestinations VALUES (94, 1, NULL, 'la_country_HTI', 'HTI', 'HT');
INSERT INTO StdDestinations VALUES (95, 1, NULL, 'la_country_HMD', 'HMD', 'HM');
INSERT INTO StdDestinations VALUES (96, 1, NULL, 'la_country_HND', 'HND', 'HN');
INSERT INTO StdDestinations VALUES (97, 1, NULL, 'la_country_HKG', 'HKG', 'HK');
INSERT INTO StdDestinations VALUES (98, 1, NULL, 'la_country_HUN', 'HUN', 'HU');
INSERT INTO StdDestinations VALUES (99, 1, NULL, 'la_country_ISL', 'ISL', 'IS');
INSERT INTO StdDestinations VALUES (100, 1, NULL, 'la_country_IND', 'IND', 'IN');
INSERT INTO StdDestinations VALUES (101, 1, NULL, 'la_country_IDN', 'IDN', 'ID');
INSERT INTO StdDestinations VALUES (102, 1, NULL, 'la_country_IRN', 'IRN', 'IR');
INSERT INTO StdDestinations VALUES (103, 1, NULL, 'la_country_IRQ', 'IRQ', 'IQ');
INSERT INTO StdDestinations VALUES (104, 1, NULL, 'la_country_IRL', 'IRL', 'IE');
INSERT INTO StdDestinations VALUES (105, 1, NULL, 'la_country_ISR', 'ISR', 'IL');
INSERT INTO StdDestinations VALUES (106, 1, NULL, 'la_country_ITA', 'ITA', 'IT');
INSERT INTO StdDestinations VALUES (107, 1, NULL, 'la_country_JAM', 'JAM', 'JM');
INSERT INTO StdDestinations VALUES (108, 1, NULL, 'la_country_JPN', 'JPN', 'JP');
INSERT INTO StdDestinations VALUES (109, 1, NULL, 'la_country_JOR', 'JOR', 'JO');
INSERT INTO StdDestinations VALUES (110, 1, NULL, 'la_country_KAZ', 'KAZ', 'KZ');
INSERT INTO StdDestinations VALUES (111, 1, NULL, 'la_country_KEN', 'KEN', 'KE');
INSERT INTO StdDestinations VALUES (112, 1, NULL, 'la_country_KIR', 'KIR', 'KI');
INSERT INTO StdDestinations VALUES (113, 1, NULL, 'la_country_PRK', 'PRK', 'KP');
INSERT INTO StdDestinations VALUES (114, 1, NULL, 'la_country_KOR', 'KOR', 'KR');
INSERT INTO StdDestinations VALUES (115, 1, NULL, 'la_country_KWT', 'KWT', 'KW');
INSERT INTO StdDestinations VALUES (116, 1, NULL, 'la_country_KGZ', 'KGZ', 'KG');
INSERT INTO StdDestinations VALUES (117, 1, NULL, 'la_country_LAO', 'LAO', 'LA');
INSERT INTO StdDestinations VALUES (118, 1, NULL, 'la_country_LVA', 'LVA', 'LV');
INSERT INTO StdDestinations VALUES (119, 1, NULL, 'la_country_LBN', 'LBN', 'LB');
INSERT INTO StdDestinations VALUES (120, 1, NULL, 'la_country_LSO', 'LSO', 'LS');
INSERT INTO StdDestinations VALUES (121, 1, NULL, 'la_country_LBR', 'LBR', 'LR');
INSERT INTO StdDestinations VALUES (122, 1, NULL, 'la_country_LBY', 'LBY', 'LY');
INSERT INTO StdDestinations VALUES (123, 1, NULL, 'la_country_LIE', 'LIE', 'LI');
INSERT INTO StdDestinations VALUES (124, 1, NULL, 'la_country_LTU', 'LTU', 'LT');
INSERT INTO StdDestinations VALUES (125, 1, NULL, 'la_country_LUX', 'LUX', 'LU');
INSERT INTO StdDestinations VALUES (126, 1, NULL, 'la_country_MAC', 'MAC', 'MO');
INSERT INTO StdDestinations VALUES (127, 1, NULL, 'la_country_MKD', 'MKD', 'MK');
INSERT INTO StdDestinations VALUES (128, 1, NULL, 'la_country_MDG', 'MDG', 'MG');
INSERT INTO StdDestinations VALUES (129, 1, NULL, 'la_country_MWI', 'MWI', 'MW');
INSERT INTO StdDestinations VALUES (130, 1, NULL, 'la_country_MYS', 'MYS', 'MY');
INSERT INTO StdDestinations VALUES (131, 1, NULL, 'la_country_MDV', 'MDV', 'MV');
INSERT INTO StdDestinations VALUES (132, 1, NULL, 'la_country_MLI', 'MLI', 'ML');
INSERT INTO StdDestinations VALUES (133, 1, NULL, 'la_country_MLT', 'MLT', 'MT');
INSERT INTO StdDestinations VALUES (134, 1, NULL, 'la_country_MHL', 'MHL', 'MH');
INSERT INTO StdDestinations VALUES (135, 1, NULL, 'la_country_MTQ', 'MTQ', 'MQ');
INSERT INTO StdDestinations VALUES (136, 1, NULL, 'la_country_MRT', 'MRT', 'MR');
INSERT INTO StdDestinations VALUES (137, 1, NULL, 'la_country_MUS', 'MUS', 'MU');
INSERT INTO StdDestinations VALUES (138, 1, NULL, 'la_country_MYT', 'MYT', 'YT');
INSERT INTO StdDestinations VALUES (139, 1, NULL, 'la_country_MEX', 'MEX', 'MX');
INSERT INTO StdDestinations VALUES (140, 1, NULL, 'la_country_FSM', 'FSM', 'FM');
INSERT INTO StdDestinations VALUES (141, 1, NULL, 'la_country_MDA', 'MDA', 'MD');
INSERT INTO StdDestinations VALUES (142, 1, NULL, 'la_country_MCO', 'MCO', 'MC');
INSERT INTO StdDestinations VALUES (143, 1, NULL, 'la_country_MNG', 'MNG', 'MN');
INSERT INTO StdDestinations VALUES (144, 1, NULL, 'la_country_MSR', 'MSR', 'MS');
INSERT INTO StdDestinations VALUES (145, 1, NULL, 'la_country_MAR', 'MAR', 'MA');
INSERT INTO StdDestinations VALUES (146, 1, NULL, 'la_country_MOZ', 'MOZ', 'MZ');
INSERT INTO StdDestinations VALUES (147, 1, NULL, 'la_country_MMR', 'MMR', 'MM');
INSERT INTO StdDestinations VALUES (148, 1, NULL, 'la_country_NAM', 'NAM', 'NA');
INSERT INTO StdDestinations VALUES (149, 1, NULL, 'la_country_NRU', 'NRU', 'NR');
INSERT INTO StdDestinations VALUES (150, 1, NULL, 'la_country_NPL', 'NPL', 'NP');
INSERT INTO StdDestinations VALUES (151, 1, NULL, 'la_country_NLD', 'NLD', 'NL');
INSERT INTO StdDestinations VALUES (152, 1, NULL, 'la_country_ANT', 'ANT', 'AN');
INSERT INTO StdDestinations VALUES (153, 1, NULL, 'la_country_NCL', 'NCL', 'NC');
INSERT INTO StdDestinations VALUES (154, 1, NULL, 'la_country_NZL', 'NZL', 'NZ');
INSERT INTO StdDestinations VALUES (155, 1, NULL, 'la_country_NIC', 'NIC', 'NI');
INSERT INTO StdDestinations VALUES (156, 1, NULL, 'la_country_NER', 'NER', 'NE');
INSERT INTO StdDestinations VALUES (157, 1, NULL, 'la_country_NGA', 'NGA', 'NG');
INSERT INTO StdDestinations VALUES (158, 1, NULL, 'la_country_NIU', 'NIU', 'NU');
INSERT INTO StdDestinations VALUES (159, 1, NULL, 'la_country_NFK', 'NFK', 'NF');
INSERT INTO StdDestinations VALUES (160, 1, NULL, 'la_country_MNP', 'MNP', 'MP');
INSERT INTO StdDestinations VALUES (161, 1, NULL, 'la_country_NOR', 'NOR', 'NO');
INSERT INTO StdDestinations VALUES (162, 1, NULL, 'la_country_OMN', 'OMN', 'OM');
INSERT INTO StdDestinations VALUES (163, 1, NULL, 'la_country_PAK', 'PAK', 'PK');
INSERT INTO StdDestinations VALUES (164, 1, NULL, 'la_country_PLW', 'PLW', 'PW');
INSERT INTO StdDestinations VALUES (165, 1, NULL, 'la_country_PSE', 'PSE', 'PS');
INSERT INTO StdDestinations VALUES (166, 1, NULL, 'la_country_PAN', 'PAN', 'PA');
INSERT INTO StdDestinations VALUES (167, 1, NULL, 'la_country_PNG', 'PNG', 'PG');
INSERT INTO StdDestinations VALUES (168, 1, NULL, 'la_country_PRY', 'PRY', 'PY');
INSERT INTO StdDestinations VALUES (169, 1, NULL, 'la_country_PER', 'PER', 'PE');
INSERT INTO StdDestinations VALUES (170, 1, NULL, 'la_country_PHL', 'PHL', 'PH');
INSERT INTO StdDestinations VALUES (171, 1, NULL, 'la_country_PCN', 'PCN', 'PN');
INSERT INTO StdDestinations VALUES (172, 1, NULL, 'la_country_POL', 'POL', 'PL');
INSERT INTO StdDestinations VALUES (173, 1, NULL, 'la_country_PRT', 'PRT', 'PT');
INSERT INTO StdDestinations VALUES (174, 1, NULL, 'la_country_PRI', 'PRI', 'PR');
INSERT INTO StdDestinations VALUES (175, 1, NULL, 'la_country_QAT', 'QAT', 'QA');
INSERT INTO StdDestinations VALUES (176, 1, NULL, 'la_country_REU', 'REU', 'RE');
INSERT INTO StdDestinations VALUES (177, 1, NULL, 'la_country_ROU', 'ROU', 'RO');
INSERT INTO StdDestinations VALUES (178, 1, NULL, 'la_country_RUS', 'RUS', 'RU');
INSERT INTO StdDestinations VALUES (179, 1, NULL, 'la_country_RWA', 'RWA', 'RW');
INSERT INTO StdDestinations VALUES (180, 1, NULL, 'la_country_KNA', 'KNA', 'KN');
INSERT INTO StdDestinations VALUES (181, 1, NULL, 'la_country_LCA', 'LCA', 'LC');
INSERT INTO StdDestinations VALUES (182, 1, NULL, 'la_country_VCT', 'VCT', 'VC');
INSERT INTO StdDestinations VALUES (183, 1, NULL, 'la_country_WSM', 'WSM', 'WS');
INSERT INTO StdDestinations VALUES (184, 1, NULL, 'la_country_SMR', 'SMR', 'SM');
INSERT INTO StdDestinations VALUES (185, 1, NULL, 'la_country_STP', 'STP', 'ST');
INSERT INTO StdDestinations VALUES (186, 1, NULL, 'la_country_SAU', 'SAU', 'SA');
INSERT INTO StdDestinations VALUES (187, 1, NULL, 'la_country_SEN', 'SEN', 'SN');
INSERT INTO StdDestinations VALUES (188, 1, NULL, 'la_country_SYC', 'SYC', 'SC');
INSERT INTO StdDestinations VALUES (189, 1, NULL, 'la_country_SLE', 'SLE', 'SL');
INSERT INTO StdDestinations VALUES (190, 1, NULL, 'la_country_SGP', 'SGP', 'SG');
INSERT INTO StdDestinations VALUES (191, 1, NULL, 'la_country_SVK', 'SVK', 'SK');
INSERT INTO StdDestinations VALUES (192, 1, NULL, 'la_country_SVN', 'SVN', 'SI');
INSERT INTO StdDestinations VALUES (193, 1, NULL, 'la_country_SLB', 'SLB', 'SB');
INSERT INTO StdDestinations VALUES (194, 1, NULL, 'la_country_SOM', 'SOM', 'SO');
INSERT INTO StdDestinations VALUES (195, 1, NULL, 'la_country_ZAF', 'ZAF', 'ZA');
INSERT INTO StdDestinations VALUES (196, 1, NULL, 'la_country_SGS', 'SGS', 'GS');
INSERT INTO StdDestinations VALUES (197, 1, NULL, 'la_country_ESP', 'ESP', 'ES');
INSERT INTO StdDestinations VALUES (198, 1, NULL, 'la_country_LKA', 'LKA', 'LK');
INSERT INTO StdDestinations VALUES (199, 1, NULL, 'la_country_SHN', 'SHN', 'SH');
INSERT INTO StdDestinations VALUES (200, 1, NULL, 'la_country_SPM', 'SPM', 'PM');
INSERT INTO StdDestinations VALUES (201, 1, NULL, 'la_country_SDN', 'SDN', 'SD');
INSERT INTO StdDestinations VALUES (202, 1, NULL, 'la_country_SUR', 'SUR', 'SR');
INSERT INTO StdDestinations VALUES (203, 1, NULL, 'la_country_SJM', 'SJM', 'SJ');
INSERT INTO StdDestinations VALUES (204, 1, NULL, 'la_country_SWZ', 'SWZ', 'SZ');
INSERT INTO StdDestinations VALUES (205, 1, NULL, 'la_country_SWE', 'SWE', 'SE');
INSERT INTO StdDestinations VALUES (206, 1, NULL, 'la_country_CHE', 'CHE', 'CH');
INSERT INTO StdDestinations VALUES (207, 1, NULL, 'la_country_SYR', 'SYR', 'SY');
INSERT INTO StdDestinations VALUES (208, 1, NULL, 'la_country_TWN', 'TWN', 'TW');
INSERT INTO StdDestinations VALUES (209, 1, NULL, 'la_country_TJK', 'TJK', 'TJ');
INSERT INTO StdDestinations VALUES (210, 1, NULL, 'la_country_TZA', 'TZA', 'TZ');
INSERT INTO StdDestinations VALUES (211, 1, NULL, 'la_country_THA', 'THA', 'TH');
INSERT INTO StdDestinations VALUES (212, 1, NULL, 'la_country_TGO', 'TGO', 'TG');
INSERT INTO StdDestinations VALUES (213, 1, NULL, 'la_country_TKL', 'TKL', 'TK');
INSERT INTO StdDestinations VALUES (214, 1, NULL, 'la_country_TON', 'TON', 'TO');
INSERT INTO StdDestinations VALUES (215, 1, NULL, 'la_country_TTO', 'TTO', 'TT');
INSERT INTO StdDestinations VALUES (216, 1, NULL, 'la_country_TUN', 'TUN', 'TN');
INSERT INTO StdDestinations VALUES (217, 1, NULL, 'la_country_TUR', 'TUR', 'TR');
INSERT INTO StdDestinations VALUES (218, 1, NULL, 'la_country_TKM', 'TKM', 'TM');
INSERT INTO StdDestinations VALUES (219, 1, NULL, 'la_country_TCA', 'TCA', 'TC');
INSERT INTO StdDestinations VALUES (220, 1, NULL, 'la_country_TUV', 'TUV', 'TV');
INSERT INTO StdDestinations VALUES (221, 1, NULL, 'la_country_UGA', 'UGA', 'UG');
INSERT INTO StdDestinations VALUES (222, 1, NULL, 'la_country_UKR', 'UKR', 'UA');
INSERT INTO StdDestinations VALUES (223, 1, NULL, 'la_country_ARE', 'ARE', 'AE');
INSERT INTO StdDestinations VALUES (224, 1, NULL, 'la_country_GBR', 'GBR', 'GB');
INSERT INTO StdDestinations VALUES (225, 1, NULL, 'la_country_USA', 'USA', 'US');
INSERT INTO StdDestinations VALUES (226, 1, NULL, 'la_country_UMI', 'UMI', 'UM');
INSERT INTO StdDestinations VALUES (227, 1, NULL, 'la_country_URY', 'URY', 'UY');
INSERT INTO StdDestinations VALUES (228, 1, NULL, 'la_country_UZB', 'UZB', 'UZ');
INSERT INTO StdDestinations VALUES (229, 1, NULL, 'la_country_VUT', 'VUT', 'VU');
INSERT INTO StdDestinations VALUES (230, 1, NULL, 'la_country_VAT', 'VAT', 'VA');
INSERT INTO StdDestinations VALUES (231, 1, NULL, 'la_country_VEN', 'VEN', 'VE');
INSERT INTO StdDestinations VALUES (232, 1, NULL, 'la_country_VNM', 'VNM', 'VN');
INSERT INTO StdDestinations VALUES (233, 1, NULL, 'la_country_VGB', 'VGB', 'VG');
INSERT INTO StdDestinations VALUES (234, 1, NULL, 'la_country_VIR', 'VIR', 'VI');
INSERT INTO StdDestinations VALUES (235, 1, NULL, 'la_country_WLF', 'WLF', 'WF');
INSERT INTO StdDestinations VALUES (236, 1, NULL, 'la_country_ESH', 'ESH', 'EH');
INSERT INTO StdDestinations VALUES (237, 1, NULL, 'la_country_YEM', 'YEM', 'YE');
INSERT INTO StdDestinations VALUES (238, 1, NULL, 'la_country_YUG', 'YUG', 'YU');
INSERT INTO StdDestinations VALUES (239, 1, NULL, 'la_country_ZMB', 'ZMB', 'ZM');
INSERT INTO StdDestinations VALUES (240, 1, NULL, 'la_country_ZWE', 'ZWE', 'ZW');
INSERT INTO StdDestinations VALUES (370, 2, 38, 'la_state_YT', 'YT', NULL);
INSERT INTO StdDestinations VALUES (369, 2, 38, 'la_state_SK', 'SK', NULL);
INSERT INTO StdDestinations VALUES (368, 2, 38, 'la_state_QC', 'QC', NULL);
INSERT INTO StdDestinations VALUES (367, 2, 38, 'la_state_PE', 'PE', NULL);
INSERT INTO StdDestinations VALUES (366, 2, 38, 'la_state_ON', 'ON', NULL);
INSERT INTO StdDestinations VALUES (365, 2, 38, 'la_state_NU', 'NU', NULL);
INSERT INTO StdDestinations VALUES (364, 2, 38, 'la_state_NS', 'NS', NULL);
INSERT INTO StdDestinations VALUES (363, 2, 38, 'la_state_NT', 'NT', NULL);
INSERT INTO StdDestinations VALUES (362, 2, 38, 'la_state_NL', 'NL', NULL);
INSERT INTO StdDestinations VALUES (361, 2, 38, 'la_state_NB', 'NB', NULL);
INSERT INTO StdDestinations VALUES (360, 2, 38, 'la_state_MB', 'MB', NULL);
INSERT INTO StdDestinations VALUES (359, 2, 38, 'la_state_BC', 'BC', NULL);
INSERT INTO StdDestinations VALUES (358, 2, 38, 'la_state_AB', 'AB', NULL);
INSERT INTO StdDestinations VALUES (357, 2, 225, 'la_state_DC', 'DC', NULL);
INSERT INTO StdDestinations VALUES (356, 2, 225, 'la_state_WY', 'WY', NULL);
INSERT INTO StdDestinations VALUES (355, 2, 225, 'la_state_WI', 'WI', NULL);
INSERT INTO StdDestinations VALUES (354, 2, 225, 'la_state_WV', 'WV', NULL);
INSERT INTO StdDestinations VALUES (353, 2, 225, 'la_state_WA', 'WA', NULL);
INSERT INTO StdDestinations VALUES (352, 2, 225, 'la_state_VA', 'VA', NULL);
INSERT INTO StdDestinations VALUES (351, 2, 225, 'la_state_VT', 'VT', NULL);
INSERT INTO StdDestinations VALUES (350, 2, 225, 'la_state_UT', 'UT', NULL);
INSERT INTO StdDestinations VALUES (349, 2, 225, 'la_state_TX', 'TX', NULL);
INSERT INTO StdDestinations VALUES (348, 2, 225, 'la_state_TN', 'TN', NULL);
INSERT INTO StdDestinations VALUES (347, 2, 225, 'la_state_SD', 'SD', NULL);
INSERT INTO StdDestinations VALUES (346, 2, 225, 'la_state_SC', 'SC', NULL);
INSERT INTO StdDestinations VALUES (345, 2, 225, 'la_state_RI', 'RI', NULL);
INSERT INTO StdDestinations VALUES (344, 2, 225, 'la_state_PR', 'PR', NULL);
INSERT INTO StdDestinations VALUES (343, 2, 225, 'la_state_PA', 'PA', NULL);
INSERT INTO StdDestinations VALUES (342, 2, 225, 'la_state_OR', 'OR', NULL);
INSERT INTO StdDestinations VALUES (341, 2, 225, 'la_state_OK', 'OK', NULL);
INSERT INTO StdDestinations VALUES (340, 2, 225, 'la_state_OH', 'OH', NULL);
INSERT INTO StdDestinations VALUES (339, 2, 225, 'la_state_ND', 'ND', NULL);
INSERT INTO StdDestinations VALUES (338, 2, 225, 'la_state_NC', 'NC', NULL);
INSERT INTO StdDestinations VALUES (337, 2, 225, 'la_state_NY', 'NY', NULL);
INSERT INTO StdDestinations VALUES (336, 2, 225, 'la_state_NM', 'NM', NULL);
INSERT INTO StdDestinations VALUES (335, 2, 225, 'la_state_NJ', 'NJ', NULL);
INSERT INTO StdDestinations VALUES (334, 2, 225, 'la_state_NH', 'NH', NULL);
INSERT INTO StdDestinations VALUES (333, 2, 225, 'la_state_NV', 'NV', NULL);
INSERT INTO StdDestinations VALUES (332, 2, 225, 'la_state_NE', 'NE', NULL);
INSERT INTO StdDestinations VALUES (331, 2, 225, 'la_state_MT', 'MT', NULL);
INSERT INTO StdDestinations VALUES (330, 2, 225, 'la_state_MO', 'MO', NULL);
INSERT INTO StdDestinations VALUES (329, 2, 225, 'la_state_MS', 'MS', NULL);
INSERT INTO StdDestinations VALUES (328, 2, 225, 'la_state_MN', 'MN', NULL);
INSERT INTO StdDestinations VALUES (327, 2, 225, 'la_state_MI', 'MI', NULL);
INSERT INTO StdDestinations VALUES (326, 2, 225, 'la_state_MA', 'MA', NULL);
INSERT INTO StdDestinations VALUES (325, 2, 225, 'la_state_MD', 'MD', NULL);
INSERT INTO StdDestinations VALUES (324, 2, 225, 'la_state_ME', 'ME', NULL);
INSERT INTO StdDestinations VALUES (323, 2, 225, 'la_state_LA', 'LA', NULL);
INSERT INTO StdDestinations VALUES (322, 2, 225, 'la_state_KY', 'KY', NULL);
INSERT INTO StdDestinations VALUES (321, 2, 225, 'la_state_KS', 'KS', NULL);
INSERT INTO StdDestinations VALUES (320, 2, 225, 'la_state_IA', 'IA', NULL);
INSERT INTO StdDestinations VALUES (319, 2, 225, 'la_state_IN', 'IN', NULL);
INSERT INTO StdDestinations VALUES (318, 2, 225, 'la_state_IL', 'IL', NULL);
INSERT INTO StdDestinations VALUES (317, 2, 225, 'la_state_ID', 'ID', NULL);
INSERT INTO StdDestinations VALUES (316, 2, 225, 'la_state_HI', 'HI', NULL);
INSERT INTO StdDestinations VALUES (315, 2, 225, 'la_state_GA', 'GA', NULL);
INSERT INTO StdDestinations VALUES (314, 2, 225, 'la_state_FL', 'FL', NULL);
INSERT INTO StdDestinations VALUES (313, 2, 225, 'la_state_DE', 'DE', NULL);
INSERT INTO StdDestinations VALUES (312, 2, 225, 'la_state_CT', 'CT', NULL);
INSERT INTO StdDestinations VALUES (311, 2, 225, 'la_state_CO', 'CO', NULL);
INSERT INTO StdDestinations VALUES (310, 2, 225, 'la_state_CA', 'CA', NULL);
INSERT INTO StdDestinations VALUES (309, 2, 225, 'la_state_AR', 'AR', NULL);
INSERT INTO StdDestinations VALUES (308, 2, 225, 'la_state_AZ', 'AZ', NULL);
INSERT INTO StdDestinations VALUES (307, 2, 225, 'la_state_AK', 'AK', NULL);
INSERT INTO StdDestinations VALUES (306, 2, 225, 'la_state_AL', 'AL', NULL);

INSERT INTO PermissionConfig (PermissionName, Description, ErrorMessage, ModuleId) VALUES ('CATEGORY.VIEW', 'lu_PermName_Category.View_desc', 'lu_PermName_Category.View_error', 'In-Portal');
INSERT INTO PermCache (CategoryId, PermId, ACL) VALUES (0, 1, '11,12,13,14,15');

INSERT INTO Permissions VALUES (0, 'LOGIN', 13, 1, 1, 0);
INSERT INTO Permissions VALUES (0, 'LOGIN', 11, 1, 1, 0);
INSERT INTO Permissions VALUES (0, 'ADMIN', 11, 1, 1, 0);

INSERT INTO Permissions VALUES (0, 'in-portal:root.view', 11, 1, 1, 0);
INSERT INTO Permissions VALUES (0, 'in-portal:system.view', 11, 1, 1, 0);

INSERT INTO Permissions VALUES (0, 'in-portal:user_list.view', 11, 1, 1, 0);
INSERT INTO Permissions VALUES (0, 'in-portal:user_list.add', 11, 1, 1, 0);
INSERT INTO Permissions VALUES (0, 'in-portal:user_list.edit', 11, 1, 1, 0);
INSERT INTO Permissions VALUES (0, 'in-portal:user_list.delete', 11, 1, 1, 0);

INSERT INTO Permissions VALUES (0, 'in-portal:configure_lang.view', 11, 1, 1, 0);
INSERT INTO Permissions VALUES (0, 'in-portal:configure_lang.add', 11, 1, 1, 0);
INSERT INTO Permissions VALUES (0, 'in-portal:configure_lang.edit', 11, 1, 1, 0);
INSERT INTO Permissions VALUES (0, 'in-portal:configure_lang.delete', 11, 1, 1, 0);

INSERT INTO Permissions VALUES (0, 'CATEGORY.VIEW', 11, 1, 0, 0);
INSERT INTO Permissions VALUES (0, 'CATEGORY.ADD', 11, 1, 0, 0);
INSERT INTO Permissions VALUES (0, 'CATEGORY.DELETE', 11, 1, 0, 0);
INSERT INTO Permissions VALUES (0, 'CATEGORY.MODIFY', 11, 1, 0, 0);

INSERT INTO Permissions VALUES (0, 'in-portal:service.view', 11, 1, 1, 0);

INSERT INTO SpiderUserAgents VALUES (1, 'ADSAComponent', '', 'ADSAComponent (postmaster@cnds.ucd.ie)');
INSERT INTO SpiderUserAgents VALUES (2, 'AOL-IWENG', '3.0', 'Mozilla/2.0 (Compatible; AOL-IWENG 3.0; Win16)');
INSERT INTO SpiderUserAgents VALUES (3, 'ASPseek', '1.2.10', 'ASPseek/1.2.10');
INSERT INTO SpiderUserAgents VALUES (4, 'Almaden', 'c01', 'http://www.almaden.ibm.com/cs/crawler   [c01]');
INSERT INTO SpiderUserAgents VALUES (5, 'Almaden', 'wf55', 'http://www.almaden.ibm.com/cs/crawler   [wf55]');
INSERT INTO SpiderUserAgents VALUES (6, 'Amsterdam 2002', '', 'Mozilla/4.0 (Search Engine Marketing Tactics Amsterdam 2002 Information Spider)');
INSERT INTO SpiderUserAgents VALUES (7, 'Antibot', '1.1.11', 'antibot-V1.1.11/i586-linux-2.2');
INSERT INTO SpiderUserAgents VALUES (8, 'AnyBrowser Search Engine', '', 'AnyBrowser.com Search Engine');
INSERT INTO SpiderUserAgents VALUES (9, 'Appie', '1.1', 'appie 1.1 (www.walhello.com)');
INSERT INTO SpiderUserAgents VALUES (10, 'Ask Jeeves', '', 'Mozilla/2.0 (compatible; Ask Jeeves)');
INSERT INTO SpiderUserAgents VALUES (11, 'Ask Jeeves Teoma', '', 'Mozilla/2.0 (compatible; Ask Jeeves/Teoma)');
INSERT INTO SpiderUserAgents VALUES (12, 'AvantGo', '3.2', 'Mozilla/3.0 (compatible; AvantGo 3.2)');
INSERT INTO SpiderUserAgents VALUES (13, 'BaiDuSpider', '', 'BaiDuSpider');
INSERT INTO SpiderUserAgents VALUES (14, 'BaiDuSpider', '', 'Baiduspider+(+http://www.baidu.com/search/spider.htm)');
INSERT INTO SpiderUserAgents VALUES (15, 'Big Brother', '', 'Big Brother (http://pauillac.inria.fr/~fpottier/)');
INSERT INTO SpiderUserAgents VALUES (16, 'BlogBot', '1.2', 'BlogBot/1.2');
INSERT INTO SpiderUserAgents VALUES (17, 'Boitho-robot', '1.0', 'boitho.com-robot/1.0');
INSERT INTO SpiderUserAgents VALUES (18, 'BorderManager', '3.0', 'Mozilla/4.0 (compatible; BorderManager 3.0)');
INSERT INTO SpiderUserAgents VALUES (19, 'BrailleBot', '1.0', 'BrailleBot 1.0');
INSERT INTO SpiderUserAgents VALUES (20, 'Bumblebee', '1.0', 'bumblebee/1.0 (bumblebee@relevare.com; http://www.relevare.com/)');
INSERT INTO SpiderUserAgents VALUES (21, 'Cd34', '0.1', 'cd34/0.1');
INSERT INTO SpiderUserAgents VALUES (22, 'ComMOOnity LambdaMOO', '1.8.1', 'ComMOOnity LambdaMOO/1.8.1');
INSERT INTO SpiderUserAgents VALUES (23, 'Cosmos', '0.9', 'cosmos/0.9_(robot@xyleme.com)');
INSERT INTO SpiderUserAgents VALUES (24, 'Crawl_Application', '', 'Crawl_Application');
INSERT INTO SpiderUserAgents VALUES (25, 'CrocCrawler', '3.3', 'CrocCrawler v3.3 [en] (http://www.croccrawler.com) (X11; I; Linux 2.0.44 i686)');
INSERT INTO SpiderUserAgents VALUES (26, 'CrocCrawler', '4.3', 'CrocCrawler v4.3 [en] (http://www.croccrawler.com) (X11; I; Linux 2.0.44 i686)');
INSERT INTO SpiderUserAgents VALUES (27, 'Custo', '2.0', 'Custo 2.0 (www.netwu.com)');
INSERT INTO SpiderUserAgents VALUES (28, 'DeMozulator', '1.0', 'DeMozulator 1.0 (MacOS, dMoz URL Check Agent, trebor@animeigo.com)');
INSERT INTO SpiderUserAgents VALUES (29, 'DeepIndex', '', 'DeepIndex (http://www.deepindex.com)');
INSERT INTO SpiderUserAgents VALUES (30, 'DoCoMo', '1.0', 'DoCoMo/1.0/N504i/c10/TB');
INSERT INTO SpiderUserAgents VALUES (31, 'DoCoMo', '1.0', 'DoCoMo/1.0/P504iS/c10/TB');
INSERT INTO SpiderUserAgents VALUES (32, 'Dual Proxy', '', 'Dual Proxy');
INSERT INTO SpiderUserAgents VALUES (33, 'FAST-WebCrawler', '3.2', 'FAST-WebCrawler/3.2 test');
INSERT INTO SpiderUserAgents VALUES (34, 'FAST-WebCrawler', '3.6', 'FAST-WebCrawler/3.6 (atw-crawler at fast dot no; http://fast.no/support/crawler.asp)');
INSERT INTO SpiderUserAgents VALUES (35, 'FAST-WebCrawler', '3.6', 'FAST-WebCrawler/3.6/FirstPage (atw-crawler at fast dot no;http://fast.no/support/crawler.asp)');
INSERT INTO SpiderUserAgents VALUES (36, 'FAST-WebCrawler', '3.6', 'FAST-WebCrawler/3.6/FirstPage (crawler@fast.no; http://fast.no/support.php?c=faqs/crawler)');
INSERT INTO SpiderUserAgents VALUES (37, 'FAST-WebCrawler', '3.7', 'FAST-WebCrawler/3.7 (atw-crawler at fast dot no; http://fast.no/support/crawler.asp)');
INSERT INTO SpiderUserAgents VALUES (38, 'FAST-WebCrawler', '3.7', 'FAST-WebCrawler/3.7/FirstPage (atw-crawler at fast dot no;http://fast.no/support/crawler.asp)');
INSERT INTO SpiderUserAgents VALUES (39, 'FAST-WebCrawler', '3.8', 'FAST-WebCrawler/3.8 (atw-crawler at fast dot no; http://fast.no/support/crawler.asp)');
INSERT INTO SpiderUserAgents VALUES (40, 'FAST-WebCrawler', '3.x', 'FAST-WebCrawler/3.x Multimedia');
INSERT INTO SpiderUserAgents VALUES (41, 'FAST-WebCrawler 3.x', '', 'FAST-WebCrawler/3.x Multimedia (mm dash crawler at fast dot no)');
INSERT INTO SpiderUserAgents VALUES (42, 'FDSE robot', '', 'Mozilla/4.0 (compatible: FDSE robot)');
INSERT INTO SpiderUserAgents VALUES (43, 'Firefly', '1.0', 'Firefly/1.0 (compatible; Mozilla 4.0; MSIE 5.5)');
INSERT INTO SpiderUserAgents VALUES (44, 'FlickBot', '1.1', 'Flickbot 1.1 RPT-HTTPClient/0.3-3');
INSERT INTO SpiderUserAgents VALUES (45, 'FlickBot', '2.0', 'FlickBot 2.0 RPT-HTTPClient/0.3-3');
INSERT INTO SpiderUserAgents VALUES (46, 'Fluffy the spider', '', 'Mozilla/3.0 (compatible; Fluffy the spider; http://www.searchhippo.com/; info@searchhippo.com)');
INSERT INTO SpiderUserAgents VALUES (47, 'FusionBot', '', 'Mozilla/4.0 (compatible; MSIE 5.0; www.galaxy.com; http://www.pgts.com.au/; +http://www.galaxy.com/info/crawler.html)');
INSERT INTO SpiderUserAgents VALUES (48, 'GAIS Robot', '1.1A2', 'GAIS Robot/1.1A2');
INSERT INTO SpiderUserAgents VALUES (49, 'Gatherer', '0.9', 'gatherer/0.9');
INSERT INTO SpiderUserAgents VALUES (50, 'Generic', '', 'Generic');
INSERT INTO SpiderUserAgents VALUES (51, 'GetRight', '4.5', 'GetRight/4.5e');
INSERT INTO SpiderUserAgents VALUES (52, 'Gigabot', '1.0', 'Gigabot/1.0');
INSERT INTO SpiderUserAgents VALUES (53, 'Girafabot', '', 'Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; Girafabot; girafabot at girafa dot com; http://www.girafa.com)');
INSERT INTO SpiderUserAgents VALUES (54, 'Googlebot', '2.1', 'Googlebot/2.1 (+http://www.googlebot.com/bot.html)');
INSERT INTO SpiderUserAgents VALUES (55, 'Googlebot-Image', '1.0', 'Googlebot-Image/1.0 (+http://www.googlebot.com/bot.html)');
INSERT INTO SpiderUserAgents VALUES (56, 'Grub-client', '', 'grub-client');
INSERT INTO SpiderUserAgents VALUES (57, 'Grub-client', '0.3.0', 'Mozilla/4.0 (compatible; grub-client-0.3.0; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (58, 'Grub-client', '1.0.3', 'Mozilla/4.0 (compatible; grub-client-1.0.3; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (59, 'Grub-client', '1.0.4', 'Mozilla/4.0 (compatible; grub-client-1.0.4; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (60, 'Grub-client', '1.0.5', 'Mozilla/4.0 (compatible; grub-client-1.0.5; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (61, 'Grub-client', '1.0.6', 'Mozilla/4.0 (compatible; grub-client-1.0.6; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (62, 'Grub-client', '1.0.7', 'Mozilla/4.0 (compatible; grub-client-1.0.7; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (63, 'Grub-client', '1.07', 'Mozilla/4.0 (compatible; grub-client-1.07; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (64, 'Grub-client', '1.1.1', 'Mozilla/4.0 (compatible; grub-client-1.1.1; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (65, 'Grub-client', '1.2.1', 'Mozilla/4.0 (compatible; grub-client-1.2.1; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (66, 'Grub-client', '1.3.1', 'Mozilla/4.0 (compatible; grub-client-1.3.1; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (67, 'Grub-client', '1.3.7', 'Mozilla/4.0 (compatible; grub-client-1.3.7; Crawl your own stuff with http://grub.org)');
INSERT INTO SpiderUserAgents VALUES (68, 'GulperBot', '0.2.4', 'Crawler [en] (compatible; Crawler Gulper Web Bot 0.2.4 www.ecsl.cs.sunysb.edu/~maxim/cgi-bin/Link/GulperBot)');
INSERT INTO SpiderUserAgents VALUES (69, 'GulperBot', '0.2.4', 'Mozilla/5.0 [en] (compatible; Gulper Web Bot 0.2.4 www.ecsl.cs.sunysb.edu/~maxim/cgi-bin/Link/GulperBot)');
INSERT INTO SpiderUserAgents VALUES (70, 'HTTrack 3.0x', '', 'Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)');
INSERT INTO SpiderUserAgents VALUES (71, 'Harvest-NG', '1.0.2', 'Harvest-NG/1.0.2');
INSERT INTO SpiderUserAgents VALUES (72, 'Hget', '0.3', 'hget/0.3');
INSERT INTO SpiderUserAgents VALUES (73, 'Hitwise Spider', '1.0', 'Hitwise Spider v1.0 http://www.hitwise.com');
INSERT INTO SpiderUserAgents VALUES (74, 'Htdig', '', 'htdig');
INSERT INTO SpiderUserAgents VALUES (75, 'Htdig', '3.1.5', 'htdig/3.1.5 (admin@ipc-opc.lan)');
INSERT INTO SpiderUserAgents VALUES (76, 'Htdig', '3.1.5', 'htdig/3.1.5 (unconfigured@htdig.searchengine.maintainer)');
INSERT INTO SpiderUserAgents VALUES (77, 'Htdig', '3.1.6', 'htdig/3.1.6 (http://computerorgs.com)');
INSERT INTO SpiderUserAgents VALUES (78, 'Httpcheck', '1.0', 'Httpcheck/1.0 (Perl 5.006001)');
INSERT INTO SpiderUserAgents VALUES (79, 'ICS', '1.2.105', 'Mozilla/4.0 (compatible; ICS 1.2.105)');
INSERT INTO SpiderUserAgents VALUES (80, 'IPiumBot', '', 'IPiumBot laurion(dot)com');
INSERT INTO SpiderUserAgents VALUES (81, 'Ia_archiver', '', 'ia_archiver');
INSERT INTO SpiderUserAgents VALUES (82, 'IcabotAccept', '', 'lcabotAccept: */*');
INSERT INTO SpiderUserAgents VALUES (83, 'IlTrovatore-Setaccio', '', 'IlTrovatore-Setaccio (+http://www.iltrovatore.it)');
INSERT INTO SpiderUserAgents VALUES (84, 'Imagefetch', '0.1', 'imagefetch/0.1 libwww-perl/5.66');
INSERT INTO SpiderUserAgents VALUES (85, 'Indy Library', '', 'Mozilla/3.0 (compatible; Indy Library)');
INSERT INTO SpiderUserAgents VALUES (86, 'InfoSeek Sidewinder', '1.0A', 'InfoSeek Sidewinder/1.0A');
INSERT INTO SpiderUserAgents VALUES (87, 'Ingrid', '3.0', 'Mozilla/3.0 (INGRID/3.0 MT; webcrawler@NOSPAMexperimental.net; http://aanmelden.ilse.nl/?aanmeld_mode=webhints)');
INSERT INTO SpiderUserAgents VALUES (88, 'Inktomi slurp', '', 'Mozilla/3.0 (Slurp/si; slurp@inktomi.com; http://www.inktomi.com/slurp.html)');
INSERT INTO SpiderUserAgents VALUES (89, 'Inktomi slurp', '', 'Mozilla/5.0 (Slurp/cat; slurp@inktomi.com; http://www.inktomi.com/slurp.html)');
INSERT INTO SpiderUserAgents VALUES (90, 'Inktomi slurp', '', 'Mozilla/5.0 (Slurp/si; slurp@inktomi.com; http://www.inktomi.com/slurp.html)');
INSERT INTO SpiderUserAgents VALUES (91, 'Inktomi slurp', '', 'Slurp/si-emb (slurp@inktomi.com; http://www.inktomi.com/slurp.html)');
INSERT INTO SpiderUserAgents VALUES (92, 'InternetLinkAgent', '3.1', 'InternetLinkAgent/3.1');
INSERT INTO SpiderUserAgents VALUES (93, 'Java', '1.4.0', 'Java1.4.0');
INSERT INTO SpiderUserAgents VALUES (94, 'JoBo', '1.3', 'JoBo/1.3 (http://www.matuschek.net/jobo.html)');
INSERT INTO SpiderUserAgents VALUES (95, 'KMcrawler', '', 'KMcrawler');
INSERT INTO SpiderUserAgents VALUES (96, 'Knowledge Engine', '', 'Knowledge Engine');
INSERT INTO SpiderUserAgents VALUES (97, 'LNSpiderguy', '', 'LNSpiderguy');
INSERT INTO SpiderUserAgents VALUES (98, 'Larbin', '', 'LARBIN-EXPERIMENTAL (efp@gmx.net)');
INSERT INTO SpiderUserAgents VALUES (99, 'Larbin', '', 'LARBIN-EXPERIMENTAL efp@gmx.net');
INSERT INTO SpiderUserAgents VALUES (100, 'Larbin', '', 'MSIE-5.13 (larbin@unspecified.mail)');
INSERT INTO SpiderUserAgents VALUES (101, 'Larbin', '', 'MSIE-5.13 larbin@unspecified.mail');
INSERT INTO SpiderUserAgents VALUES (102, 'Larbin', '', 'Mozilla (la2@unspecified.mail)');
INSERT INTO SpiderUserAgents VALUES (103, 'Larbin', '', 'Mozilla la2@unspecified.mail');
INSERT INTO SpiderUserAgents VALUES (104, 'Larbin', '', 'Mozilla/4.0 (efp@gmx.net)');
INSERT INTO SpiderUserAgents VALUES (105, 'Larbin', '', 'Mozilla/4.0 efp@gmx.net');
INSERT INTO SpiderUserAgents VALUES (106, 'Larbin', '', 'WinampMPEG/2.00 (larbin@unspecified.mail)');
INSERT INTO SpiderUserAgents VALUES (107, 'Larbin', '', 'WinampMPEG/2.00 larbin@unspecified.mail');
INSERT INTO SpiderUserAgents VALUES (108, 'Larbin', '', 'larbin (samualt9@bigfoot.com)');
INSERT INTO SpiderUserAgents VALUES (109, 'Larbin', '', 'larbin samualt9@bigfoot.com');
INSERT INTO SpiderUserAgents VALUES (110, 'Larbin', '2.6.2', 'larbin_2.6.2 (kalou@kalou.net)');
INSERT INTO SpiderUserAgents VALUES (111, 'Larbin', '2.6.2', 'larbin_2.6.2 (larbin2.6.2@unspecified.mail)');
INSERT INTO SpiderUserAgents VALUES (112, 'Larbin', '2.6.2', 'larbin_2.6.2 (larbin@correa.org)');
INSERT INTO SpiderUserAgents VALUES (113, 'Larbin', '2.6.2', 'larbin_2.6.2 (pimenas@systems.tuc.gr)');
INSERT INTO SpiderUserAgents VALUES (114, 'Larbin', '2.6.2', 'larbin_2.6.2 (sumeet_sobti@yahoo.com)');
INSERT INTO SpiderUserAgents VALUES (115, 'Larbin', '2.6.2', 'larbin_2.6.2 (vitalbox1@hotmail.com)');
INSERT INTO SpiderUserAgents VALUES (116, 'Larbin', '2.6.2', 'larbin_2.6.2 (vshelk@yahoo.com)');
INSERT INTO SpiderUserAgents VALUES (117, 'Larbin', '2.6.2', 'larbin_2.6.2 larbin2.6.2@unspecified.mail');
INSERT INTO SpiderUserAgents VALUES (118, 'Larbin', '2.6.2', 'larbin_2.6.2 larbin@correa.org');
INSERT INTO SpiderUserAgents VALUES (119, 'Larbin', '2.6.2', 'larbin_2.6.2 pimenas@systems.tuc.gr');
INSERT INTO SpiderUserAgents VALUES (120, 'Larbin', '2.6.2', 'larbin_2.6.2 sumeet_sobti@yahoo.com');
INSERT INTO SpiderUserAgents VALUES (121, 'Larbin', '2.6.2', 'larbin_2.6.2 vitalbox1@hotmail.com');
INSERT INTO SpiderUserAgents VALUES (122, 'Libwww-perl', '', 'Perl-Win32::Internet/0.082');
INSERT INTO SpiderUserAgents VALUES (123, 'Libwww-perl', '5.3.2', '/ libwww/5.3.2');
INSERT INTO SpiderUserAgents VALUES (124, 'Libwww-perl', '5.50', 'libwww-perl/5.50');
INSERT INTO SpiderUserAgents VALUES (125, 'Libwww-perl', '5.51', 'libwww-perl/5.51');
INSERT INTO SpiderUserAgents VALUES (126, 'Libwww-perl', '5.52', 'libwww-perl/5.52 FP/4.0');
INSERT INTO SpiderUserAgents VALUES (127, 'Libwww-perl', '5.53', 'libwww-perl/5.53');
INSERT INTO SpiderUserAgents VALUES (128, 'Libwww-perl', '5.63', 'libwww-perl/5.63');
INSERT INTO SpiderUserAgents VALUES (129, 'Libwww-perl', '5.64', 'libwww-perl/5.64');
INSERT INTO SpiderUserAgents VALUES (130, 'Libwww-perl', '5.65', 'libwww-perl/5.65');
INSERT INTO SpiderUserAgents VALUES (131, 'Libwww-perl', '5.66', 'rawiswar/0.1 libwww-perl/5.66');
INSERT INTO SpiderUserAgents VALUES (132, 'Linkbot', '3.0', 'Linkbot 3.0');
INSERT INTO SpiderUserAgents VALUES (133, 'Lite Bot', '0616B', 'Lite Bot 0616B');
INSERT INTO SpiderUserAgents VALUES (134, 'Lwp-request', '2.01', 'lwp-request/2.01');
INSERT INTO SpiderUserAgents VALUES (135, 'Lycos_Spider', '', 'Lycos_Spider_(modspider)');
INSERT INTO SpiderUserAgents VALUES (136, 'MS Data Access', '', 'Microsoft Data Access Internet Publishing Provider Cache Manager');
INSERT INTO SpiderUserAgents VALUES (137, 'MS Data Access', '', 'Microsoft Data Access Internet Publishing Provider DAV');
INSERT INTO SpiderUserAgents VALUES (138, 'MS Data Access', '', 'Microsoft Data Access Internet Publishing Provider DAV 1.1');
INSERT INTO SpiderUserAgents VALUES (139, 'MS Data Access', '', 'Microsoft Data Access Internet Publishing Provider Protocol Discovery');
INSERT INTO SpiderUserAgents VALUES (140, 'MS FrontPage', '4.0', 'MSFrontPage/4.0');
INSERT INTO SpiderUserAgents VALUES (141, 'MS FrontPage', '4.0', 'Mozilla/2.0 (compatible; MS FrontPage 4.0)');
INSERT INTO SpiderUserAgents VALUES (142, 'MS FrontPage', '5.0', 'MSFrontPage/5.0');
INSERT INTO SpiderUserAgents VALUES (143, 'MS FrontPage', '5.0', 'Mozilla/2.0 (compatible; MS FrontPage 5.0)');
INSERT INTO SpiderUserAgents VALUES (144, 'MSIECrawler', '', 'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; MSIECrawler)');
INSERT INTO SpiderUserAgents VALUES (145, 'MSIECrawler', '', 'Mozilla/4.0 (compatible; MSIE 5.5; Windows 98; Win 9x 4.90; Q312461; BTopenworld; MSIECrawler)');
INSERT INTO SpiderUserAgents VALUES (146, 'MSIECrawler', '', 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0; MSIECrawler)');
INSERT INTO SpiderUserAgents VALUES (147, 'MSIECrawler', '', 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; MSIECrawler)');
INSERT INTO SpiderUserAgents VALUES (148, 'MSIECrawler', '', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461; MSIECrawler)');
INSERT INTO SpiderUserAgents VALUES (149, 'MSIECrawler', '', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; matlas-2.0.2501; MSIECrawler)');
INSERT INTO SpiderUserAgents VALUES (150, 'MSIECrawler', '', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MSIECrawler)');
INSERT INTO SpiderUserAgents VALUES (151, 'MSProxy', '2.0', 'MSProxy/2.0');
INSERT INTO SpiderUserAgents VALUES (152, 'Mercator', '2.0', 'Mercator-2.0');
INSERT INTO SpiderUserAgents VALUES (153, 'MetaGer-LinkChecker', '', 'MetaGer-LinkChecker');
INSERT INTO SpiderUserAgents VALUES (154, 'Metacarta', '', 'metacarta (crawler@metacarta.com)');
INSERT INTO SpiderUserAgents VALUES (155, 'Metacarta', '', 'metacarta crawler@metacarta.com');
INSERT INTO SpiderUserAgents VALUES (156, 'Microsoft URL Control', '', 'Microsoft URL Control - 5.00.3609');
INSERT INTO SpiderUserAgents VALUES (157, 'Microsoft URL Control', '', 'Microsoft URL Control - 5.01.4319');
INSERT INTO SpiderUserAgents VALUES (158, 'Microsoft URL Control', '', 'Microsoft URL Control - 6.00.8169');
INSERT INTO SpiderUserAgents VALUES (159, 'Microsoft URL Control', '', 'Microsoft URL Control - 6.00.8862');
INSERT INTO SpiderUserAgents VALUES (160, 'Microsoft-ATL-Native', '7.00', 'Microsoft-ATL-Native/7.00');
INSERT INTO SpiderUserAgents VALUES (161, 'MicrosoftPrototypeCrawler', '', 'MicrosoftPrototypeCrawler (How''s my crawling? mailto:newbiecrawler@hotmail.com)');
INSERT INTO SpiderUserAgents VALUES (162, 'Moget', '1.0', 'moget/1.0 (moget@goo.ne.jp)');
INSERT INTO SpiderUserAgents VALUES (163, 'Moget', '2.1', 'moget/2.1 (moget@goo.ne.jp)');
INSERT INTO SpiderUserAgents VALUES (164, 'MysteryBot', '', 'Mozilla/3.01 (compatible;)');
INSERT INTO SpiderUserAgents VALUES (165, 'NG', '1.0', 'NG/1.0');
INSERT INTO SpiderUserAgents VALUES (166, 'NPBot', '', 'NPBot');
INSERT INTO SpiderUserAgents VALUES (167, 'NPBot', '', 'NPBot-1/2.0');
INSERT INTO SpiderUserAgents VALUES (168, 'NPBot', '', 'NPBot-1/2.0 (http://www.nameprotect.com/botinfo.html)');
INSERT INTO SpiderUserAgents VALUES (169, 'NationalDirectory-WebSpider', '1.3', 'NationalDirectory-WebSpider/1.3');
INSERT INTO SpiderUserAgents VALUES (170, 'NaverRobot', '1.0', 'dloader(NaverRobot)/1.0');
INSERT INTO SpiderUserAgents VALUES (171, 'NetAnts', '1.25', 'NetAnts/1.25');
INSERT INTO SpiderUserAgents VALUES (172, 'NetNose-Crawler', '2.0', 'Mozilla/4.0 (compatible; MSIE 5.0; NetNose-Crawler 2.0; A New Search Experience: http://www.netnose.com)');
INSERT INTO SpiderUserAgents VALUES (173, 'NetNoseCrawler v1.0', '', 'NetNoseCrawler/v1.0');
INSERT INTO SpiderUserAgents VALUES (174, 'NetResearchServer', '', 'NetResearchServer(http://www.look.com)');
INSERT INTO SpiderUserAgents VALUES (175, 'NetResearchServer', '2.4', 'NetResearchServer/2.4(loopimprovements.com/robot.html)');
INSERT INTO SpiderUserAgents VALUES (176, 'NetResearchServer', '2.5', 'NetResearchServer/2.5(loopimprovements.com/robot.html)');
INSERT INTO SpiderUserAgents VALUES (177, 'NetResearchServer', '2.7', 'NetResearchServer/2.7(loopimprovements.com/robot.html)');
INSERT INTO SpiderUserAgents VALUES (178, 'Netcraft Web Server Survey', '', 'Mozilla/4.0 (compatible; Netcraft Web Server Survey)');
INSERT INTO SpiderUserAgents VALUES (179, 'None', '', 'none');
INSERT INTO SpiderUserAgents VALUES (180, 'NutchCrawler', '', 'Robot: NutchCrawler, Owner: wdavies@acm.org');
INSERT INTO SpiderUserAgents VALUES (181, 'NutchOrg', '0.03', 'NutchOrg/0.03-dev (Nutch; http://www.nutch.org/docs/bot.html; nutch-agent@lists.sourceforge.net)');
INSERT INTO SpiderUserAgents VALUES (182, 'OWR_Crawler', '0.1', 'OWR_Crawler 0.1');
INSERT INTO SpiderUserAgents VALUES (183, 'Obot', '', 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0; obot)');
INSERT INTO SpiderUserAgents VALUES (184, 'Obot', '', 'oBot');
INSERT INTO SpiderUserAgents VALUES (185, 'Openbot', '3.0', 'Openfind data gatherer, Openbot/3.0+(robot-response@openfind.com.tw;+http://www.openfind.com.tw/robot.html)');
INSERT INTO SpiderUserAgents VALUES (186, 'OrangeBot', '', 'OrangeBot');
INSERT INTO SpiderUserAgents VALUES (187, 'Organica', '2.24', 'Mozilla/4.0 (compatible; Advanced Email Extractor v2.24)');
INSERT INTO SpiderUserAgents VALUES (188, 'PWS.Kiosk', '', 'PWS.Kiosk - Content Filtering');
INSERT INTO SpiderUserAgents VALUES (189, 'Parabot', '', 'parabot (paracite@ecs.soton.ac.uk)');
INSERT INTO SpiderUserAgents VALUES (190, 'Pavuk', '0.9', 'pavuk/0.9pl28 i586-pc-cygwin');
INSERT INTO SpiderUserAgents VALUES (191, 'Pavuk', '0.9', 'pavuk/0.9pl29b i686-pc-linux-gnu');
INSERT INTO SpiderUserAgents VALUES (192, 'Polybot', '1.0', 'polybot 1.0 (http://cis.poly.edu/polybot/)');
INSERT INTO SpiderUserAgents VALUES (193, 'Pompos', '1.1', 'Pompos/1.1 http://pompos.iliad.fr');
INSERT INTO SpiderUserAgents VALUES (194, 'Pompos', '1.2', 'Pompos/1.2 http://pompos.iliad.fr');
INSERT INTO SpiderUserAgents VALUES (195, 'Portal Manager', '0.7', 'Portal Manager 0.7');
INSERT INTO SpiderUserAgents VALUES (196, 'Potbot', '1.0', 'potbot 1.0');
INSERT INTO SpiderUserAgents VALUES (197, 'ProWebGuide Link Checker', '', 'ProWebGuide Link Checker (http://www.prowebguide.com)');
INSERT INTO SpiderUserAgents VALUES (198, 'Psbot', '0.1', 'psbot/0.1 (+http://www.picsearch.com/bot.html)');
INSERT INTO SpiderUserAgents VALUES (199, 'Pverify', '1.2', 'pverify/1.2');
INSERT INTO SpiderUserAgents VALUES (200, 'QuepasaCreep v0.9.13', '', 'QuepasaCreep v0.9.13');
INSERT INTO SpiderUserAgents VALUES (201, 'RPT-HTTPClient', '0.3', 'RPT-HTTPClient/0.3-3');
INSERT INTO SpiderUserAgents VALUES (202, 'Reifier', '', 'reifier.org (admin@reifier.org)');
INSERT INTO SpiderUserAgents VALUES (203, 'Reifier', '', 'reifier.org admin@reifier.org');
INSERT INTO SpiderUserAgents VALUES (204, 'Rico', '0.1', 'rico/0.1');
INSERT INTO SpiderUserAgents VALUES (205, 'RobotMidareru', '0.7', 'RobotMidareru/0.7libwww-perl/5.65');
INSERT INTO SpiderUserAgents VALUES (206, 'Robots.txt Validator', '', 'Search Engine World Robots.txt Validator at http://www.searchengineworld.com/cgi-bin/robotcheck.cgi');
INSERT INTO SpiderUserAgents VALUES (207, 'Robozilla', '1.0', 'Robozilla/1.0');
INSERT INTO SpiderUserAgents VALUES (208, 'SYCLIKControl LinkChecker', '', 'Mozilla/5.0 (compatible; SYCLIKControl/LinkChecker;)');
INSERT INTO SpiderUserAgents VALUES (209, 'Scooter', '1.0', 'Scooter/1.0');
INSERT INTO SpiderUserAgents VALUES (210, 'Scooter', '1.1', 'Scooter-ARS-1.1');
INSERT INTO SpiderUserAgents VALUES (211, 'Scooter', '3.2', 'Scooter-3.2');
INSERT INTO SpiderUserAgents VALUES (212, 'Scooter', '3.2', 'Scooter-3.2.BT');
INSERT INTO SpiderUserAgents VALUES (213, 'Scooter', '3.2', 'Scooter-3.2.EX');
INSERT INTO SpiderUserAgents VALUES (214, 'Scooter', '3.2', 'Scooter-3.2.FNR');
INSERT INTO SpiderUserAgents VALUES (215, 'Scooter', '3.2', 'Scooter-3.2.PDF');
INSERT INTO SpiderUserAgents VALUES (216, 'Scooter', '3.2', 'Scooter-3.2.SF0');
INSERT INTO SpiderUserAgents VALUES (217, 'Scooter', '3.2', 'Scooter-3.2.TX.FNR');
INSERT INTO SpiderUserAgents VALUES (218, 'Scooter', '3.2', 'Scooter-3.2.XX0');
INSERT INTO SpiderUserAgents VALUES (219, 'Scooter', '3.2', 'Scooter/3.2');
INSERT INTO SpiderUserAgents VALUES (220, 'Scooter', '3.2', 'Scooter/3.2.SF0');
INSERT INTO SpiderUserAgents VALUES (221, 'Scooter', '3.2', 'Scooter_x0-3.2.EX');
INSERT INTO SpiderUserAgents VALUES (222, 'Scooter', '3.3', 'Scooter/3.3');
INSERT INTO SpiderUserAgents VALUES (223, 'Scooter', '3.3', 'Scooter/3.3.QA');
INSERT INTO SpiderUserAgents VALUES (224, 'Scooter', '3.3', 'Scooter/3.3.QA.pczukor');
INSERT INTO SpiderUserAgents VALUES (225, 'Scooter', '3.3', 'Scooter/3.3.vscooter');
INSERT INTO SpiderUserAgents VALUES (226, 'Scooter', '3.3', 'Scooter/3.3_SF');
INSERT INTO SpiderUserAgents VALUES (227, 'Scrubby', '2.2', 'Scrubby/2.2 (http://www.scrubtheweb.com/)');
INSERT INTO SpiderUserAgents VALUES (228, 'Search Agent', '1.0', 'Search Agent 1.0');
INSERT INTO SpiderUserAgents VALUES (229, 'Semanticdiscovery', '0.1', 'semanticdiscovery/0.1');
INSERT INTO SpiderUserAgents VALUES (230, 'Sherlock', '1.3', 'sherlock/1.3 httpget/1.3');
INSERT INTO SpiderUserAgents VALUES (231, 'Sitecheck', '', 'InternetSeer.com');
INSERT INTO SpiderUserAgents VALUES (232, 'Sitecheck', '', 'sitecheck.internetseer.com (For more info see: http://sitecheck.internetseer.com)');
INSERT INTO SpiderUserAgents VALUES (233, 'Sitescooper', '3.1.2', 'sitescooper/3.1.2 (http://sitescooper.org) libwww-perl/5.51');
INSERT INTO SpiderUserAgents VALUES (234, 'SlySearch', '1.3', 'SlySearch/1.3 (http://www.slysearch.com)');
INSERT INTO SpiderUserAgents VALUES (235, 'SlySearch', '1.3', 'SlySearch/1.3 http://www.slysearch.com');
INSERT INTO SpiderUserAgents VALUES (236, 'Speedy_Spider', '', 'Speedy_Spider_(http://www.entireweb.com)');
INSERT INTO SpiderUserAgents VALUES (237, 'Sqworm', '2.9.85', 'Sqworm/2.9.85-BETA (beta_release; 20011115-775; i686-pc-linux-gnu)');
INSERT INTO SpiderUserAgents VALUES (238, 'Star Downloader', '', 'Star Downloader');
INSERT INTO SpiderUserAgents VALUES (239, 'Steeler', '1.3', 'Steeler/1.3 (http://www.tkl.iis.u-tokyo.ac.jp/~crawler/)');
INSERT INTO SpiderUserAgents VALUES (240, 'SuperCleaner', '2.56', 'Mozilla/4.0 (compatible; SuperCleaner 2.56; Windows NT 5.1)');
INSERT INTO SpiderUserAgents VALUES (241, 'Szukacz', '1.5', 'Szukacz/1.5');
INSERT INTO SpiderUserAgents VALUES (242, 'Szukacz', '1.5', 'Szukacz/1.5 (robot; www.szukacz.pl/jakdzialarobot.html; info@szukacz.pl)');
INSERT INTO SpiderUserAgents VALUES (243, 'TclSOAP', '1.0', 'Tcl http client package 1.0');
INSERT INTO SpiderUserAgents VALUES (244, 'TclSOAP', '2.3', 'Tcl http client package 2.3');
INSERT INTO SpiderUserAgents VALUES (245, 'Teradex Mapper', '', '(Teradex Mapper; mapper@teradex.com; http://www.teradex.com)');
INSERT INTO SpiderUserAgents VALUES (246, 'TulipChain', '5.7', 'TulipChain/5.7 (http://ostermiller.org/tulipchain/) Java/1.4.0_02 (http://java.sun.com/) Windows_Me/4.90');
INSERT INTO SpiderUserAgents VALUES (247, 'TurnitinBot', '1.4', 'TurnitinBot/1.4 (http://www.turnitin.com/robot/crawlerinfo.html)');
INSERT INTO SpiderUserAgents VALUES (248, 'TurnitinBot', '1.4', 'TurnitinBot/1.4 http://www.turnitin.com/robot/crawlerinfo.html');
INSERT INTO SpiderUserAgents VALUES (249, 'TurnitinBot', '1.5', 'TurnitinBot/1.5 (http://www.turnitin.com/robot/crawlerinfo.html)');
INSERT INTO SpiderUserAgents VALUES (250, 'TurnitinBot', '1.5', 'TurnitinBot/1.5 http://www.turnitin.com/robot/crawlerinfo.html');
INSERT INTO SpiderUserAgents VALUES (251, 'UIowaCrawler', '2.0', 'UIowaCrawler/2.0');
INSERT INTO SpiderUserAgents VALUES (252, 'UdmSearch', '3.1.20', 'UdmSearch/3.1.20');
INSERT INTO SpiderUserAgents VALUES (253, 'Vagabondo', '2.0', 'Vagabondo/2.0 MT (webagent at wise-guys dot nl)');
INSERT INTO SpiderUserAgents VALUES (254, 'Vagabondo', '2.0', 'Vagabondo/2.0 MT (webagent@NOSPAMwise-guys.nl)');
INSERT INTO SpiderUserAgents VALUES (255, 'Vagabondo', '2.1', 'Mozilla/5.0 (compatible; Vagabondo/2.1; webcrawler at wise-guys dot nl; http://webagent.wise-guys.nl/)');
INSERT INTO SpiderUserAgents VALUES (256, 'VoilaBot', '1.6', 'Mozilla/4.0 (compatible; MSIE 5.0; Windows 95) VoilaBot; 1.6');
INSERT INTO SpiderUserAgents VALUES (257, 'VoilaBot', '1.6', 'Mozilla/4.0_(compatible;_MSIE_5.0;_Windows_95)_VoilaBot/1.6 libwww/5.3.2');
INSERT INTO SpiderUserAgents VALUES (258, 'Vspider', '', 'vspider');
INSERT INTO SpiderUserAgents VALUES (259, 'W3C-checklink', '2.90', 'W3C-checklink/2.90 libwww-perl/5.64');
INSERT INTO SpiderUserAgents VALUES (260, 'W3C-checklink', '3.6.2.3', 'W3C-checklink/3.6.2.3 libwww-perl/5.64');
INSERT INTO SpiderUserAgents VALUES (261, 'W3C_Validator', '1.183', 'W3C_Validator/1.183 libwww-perl/5.64');
INSERT INTO SpiderUserAgents VALUES (262, 'W3C_Validator', '1.305.2.12', 'W3C_Validator/1.305.2.12 libwww-perl/5.64');
INSERT INTO SpiderUserAgents VALUES (263, 'WebFilter Robot', '1.0', 'WebFilter Robot 1.0');
INSERT INTO SpiderUserAgents VALUES (264, 'WebSearch', '', 'http://www.WebSearch.com.au/ (larbin2.6.2@unspecified.mail)');
INSERT INTO SpiderUserAgents VALUES (265, 'WebSearch', '', 'http://www.WebSearch.com.au/ - Australian Search Engine/3.1.3 (sites@websearch.com.au)');
INSERT INTO SpiderUserAgents VALUES (266, 'WebSearch', '', 'http://www.WebSearch.com.au/ - Australian Search Engine/3.1.6 (sites@websearch.com.au)');
INSERT INTO SpiderUserAgents VALUES (267, 'WebSearch', '', 'http://www.WebSearch.com.au/ larbin2.6.2@unspecified.mail');
INSERT INTO SpiderUserAgents VALUES (268, 'WebSearch', '', 'http://www.websearch.com.au (larbin2.6.2@unspecified.mail)');
INSERT INTO SpiderUserAgents VALUES (269, 'WebSearch', '', 'http://www.websearch.com.au larbin2.6.2@unspecified.mail');
INSERT INTO SpiderUserAgents VALUES (270, 'WebSearch', '', 'www.WebSearch.com.au (search@websearch.com.au)');
INSERT INTO SpiderUserAgents VALUES (271, 'WebSearch', '', 'www.WebSearch.com.au search@websearch.com.au');
INSERT INTO SpiderUserAgents VALUES (272, 'WebSearch', '2.0.1', 'WebSearch/2.0.1 (Dez@Blanchfield.COM.AU, http://www.WebSearch.com.au/)');
INSERT INTO SpiderUserAgents VALUES (273, 'WebcraftBoot', '', 'Thu Mar 27 18:20:34 CET 2003WebcraftBoot');
INSERT INTO SpiderUserAgents VALUES (274, 'WebcraftBoot', '1.4.1', 'Fri Nov 15 04:51:18 EST 2002WebcraftBoot Java/1.4.1_01');
INSERT INTO SpiderUserAgents VALUES (275, 'WebcraftBoot', '1.4.2', 'Sun Apr 20 22:00:01 EDT 2003WebcraftBoot Java/1.4.2-beta');
INSERT INTO SpiderUserAgents VALUES (276, 'WebcraftBoot', '1.4.2', 'Tue Apr 15 22:00:03 EDT 2003WebcraftBoot Java/1.4.2-beta');
INSERT INTO SpiderUserAgents VALUES (277, 'Webinator-indexer', '2.56', 'Mozilla/3.0 (compatible; Webinator-indexer.cyberalert.com/2.56)');
INSERT INTO SpiderUserAgents VALUES (278, 'Webwombat', '', 'www.webwombat.com.au');
INSERT INTO SpiderUserAgents VALUES (279, 'Wget', '1.5.2', 'Wget/1.5.2');
INSERT INTO SpiderUserAgents VALUES (280, 'Wget', '1.7', 'Wget/1.7');
INSERT INTO SpiderUserAgents VALUES (281, 'Wget', '1.8', 'Wget/1.8');
INSERT INTO SpiderUserAgents VALUES (282, 'Wget', '1.8.1', 'Wget/1.8.1');
INSERT INTO SpiderUserAgents VALUES (283, 'Wget', '1.8.2', 'Wget/1.8.2');
INSERT INTO SpiderUserAgents VALUES (284, 'Willow', '2.1', 'Willow Internet Crawler by Twotrees V2.1');
INSERT INTO SpiderUserAgents VALUES (285, 'Xenu Link Sleuth', '1.1a', 'Xenu''s Link Sleuth 1.1a');
INSERT INTO SpiderUserAgents VALUES (286, 'Xenu Link Sleuth', '1.2b', 'Xenu Link Sleuth 1.2b');
INSERT INTO SpiderUserAgents VALUES (287, 'Xenu Link Sleuth 1.2d', '', 'Xenu Link Sleuth 1.2d');
INSERT INTO SpiderUserAgents VALUES (288, 'Zao', '0.1', 'Zao/0.1 (http://www.kototoi.org/zao/)');
INSERT INTO SpiderUserAgents VALUES (289, 'Zeus', '57657', 'Zeus 57657 Webster Pro V2.9 Win32');
INSERT INTO SpiderUserAgents VALUES (290, 'ZyBorg', '1.0', 'Mozilla/4.0 compatible ZyBorg/1.0 (ZyBorg@WISEnutbot.com; http://www.WISEnutbot.com)');
INSERT INTO SpiderUserAgents VALUES (291, 'ZyBorg', '1.0', 'Mozilla/4.0 compatible ZyBorg/1.0 (wn.zyborg@looksmart.net; http://www.WISEnutbot.com)');
INSERT INTO SpiderUserAgents VALUES (292, 'unknown', '', 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Fetch API Request');
INSERT INTO SpiderUserAgents VALUES (293, 'unknown', '', 'Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322)');

INSERT INTO Modules (Name, Path, Var, Version, Loaded, LoadOrder, TemplatePath, RootCat, BuildDate) VALUES ('Core', 'core/', 'adm', '4.0.1', 1, 1, '', 0, '0');