in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Aug 17, 12:07 AM

in-portal
View Options

	Index: branches/unlabeled/unlabeled-1.5.2/core/install/install_data.sql
	===================================================================
	--- branches/unlabeled/unlabeled-1.5.2/core/install/install_data.sql (revision 7770)
	+++ branches/unlabeled/unlabeled-1.5.2/core/install/install_data.sql (revision 7771)
	@@ -1,876 +1,582 @@
	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');

	Property changes on: branches/unlabeled/unlabeled-1.5.2/core/install/install_data.sql
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.5.2.4
	\ No newline at end of property
	+1.5.2.5
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql
	===================================================================
	--- branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql (revision 7770)
	+++ branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql (revision 7771)
	@@ -1,308 +1,6 @@
	# ===== v 4.0.1 =====
	ALTER TABLE EmailLog ADD EventParams TEXT NOT NULL;

	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 (0, 'MailFunctionHeaderSeparator', 1, 'In-Portal', 'in-portal:configure_general');

	-CREATE TABLE SpiderUserAgents (
	- `AgentId` int(10) unsigned NOT NULL auto_increment,
	- `Name` varchar(255) NOT NULL default '',
	- `Version` varchar(100) NOT NULL default '',
	- `UserAgent` varchar(255) NOT NULL default '',
	- PRIMARY KEY (`AgentId`),
	- KEY `UserAgent` (`UserAgent`(100))
	-);
	-
	-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)');

	Property changes on: branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.2.2.2
	\ No newline at end of property
	+1.2.2.3
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql
	===================================================================
	--- branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql (revision 7770)
	+++ branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql (revision 7771)
	@@ -1,433 +1,424 @@
	CREATE TABLE PermissionConfig (
	PermissionConfigId int(11) NOT NULL auto_increment,
	PermissionName varchar(30) NOT NULL default '',
	Description varchar(255) NOT NULL default '',
	ErrorMessage varchar(255) NOT NULL default '',
	ModuleId varchar(20) NOT NULL default '0',
	PRIMARY KEY (PermissionConfigId),
	KEY PermissionName (PermissionName)
	);

	CREATE TABLE Permissions (
	PermissionId int(11) NOT NULL auto_increment,
	Permission varchar(255) NOT NULL default '',
	GroupId int(11) default '0',
	PermissionValue int(11) NOT NULL default '0',
	`Type` tinyint(4) NOT NULL default '0',
	CatId int(11) NOT NULL default '0',
	PRIMARY KEY (PermissionId),
	UNIQUE KEY PermIndex (Permission,GroupId,CatId,`Type`)
	);

	CREATE TABLE CustomField (
	CustomFieldId int(11) NOT NULL auto_increment,
	Type int(11) NOT NULL default '0',
	FieldName varchar(255) NOT NULL default '',
	FieldLabel varchar(40) default NULL,
	Heading varchar(60) default NULL,
	Prompt varchar(60) default NULL,
	ElementType varchar(50) NOT NULL default '',
	ValueList varchar(255) default NULL,
	DisplayOrder int(11) NOT NULL default '0',
	OnGeneralTab tinyint(4) NOT NULL default '0',
	IsSystem tinyint(3) unsigned NOT NULL default '0',
	PRIMARY KEY (CustomFieldId),
	KEY Type (Type)
	);

	CREATE TABLE ConfigurationAdmin (
	VariableName varchar(80) NOT NULL default '',
	heading varchar(255) default NULL,
	prompt varchar(255) default NULL,
	element_type varchar(20) NOT NULL default '',
	validation varchar(255) default NULL,
	ValueList text default NULL,
	DisplayOrder double NOT NULL default '0',
	GroupDisplayOrder double NOT NULL default '0',
	Install int(11) NOT NULL default '1',
	PRIMARY KEY (VariableName)
	);

	CREATE TABLE ConfigurationValues (
	VariableId int(11) NOT NULL auto_increment,
	VariableName varchar(255) NOT NULL default '',
	VariableValue varchar(255) default NULL,
	ModuleOwner varchar(20) default 'In-Portal',
	Section varchar(255) NOT NULL default '',
	PRIMARY KEY (VariableId),
	UNIQUE KEY VariableName (VariableName)
	);

	CREATE TABLE EmailMessage (
	EmailMessageId int(10) NOT NULL auto_increment,
	Template longtext,
	MessageType enum('html','text') NOT NULL default 'text',
	LanguageId int(11) NOT NULL default '0',
	EventId int(11) NOT NULL default '0',
	Subject text,
	PRIMARY KEY (EmailMessageId)
	);

	CREATE TABLE EmailQueue (
	Subject text NOT NULL,
	toaddr text NOT NULL,
	fromaddr text NOT NULL,
	message blob,
	headers blob,
	queued timestamp NOT NULL
	);

	CREATE TABLE EmailSubscribers (
	EmailMessageId int(11) NOT NULL default '0',
	PortalUserId int(11) NOT NULL default '0'
	);

	CREATE TABLE Events (
	EventId int(11) NOT NULL auto_increment,
	Event varchar(40) NOT NULL default '',
	Enabled int(11) NOT NULL default '1',
	FromUserId int(11) NOT NULL default '0',
	Module varchar(40) NOT NULL default '',
	Description varchar(255) NOT NULL default '',
	Type int(11) NOT NULL default '0',
	PRIMARY KEY (EventId)
	);

	CREATE TABLE IdGenerator (
	lastid int(11) default NULL
	);

	CREATE TABLE Language (
	LanguageId int(11) NOT NULL auto_increment,
	PackName varchar(40) NOT NULL default '',
	LocalName varchar(40) NOT NULL default '',
	Enabled int(11) NOT NULL default '0',
	PrimaryLang int(11) NOT NULL default '0',
	IconURL varchar(255) default NULL,
	DateFormat varchar(50) NOT NULL default '',
	TimeFormat varchar(50) NOT NULL default '',
	InputDateFormat varchar(50) NOT NULL default '',
	InputTimeFormat varchar(50) NOT NULL default '',
	DecimalPoint char(2) NOT NULL default '.',
	ThousandSep tinytext NULL,
	Charset varchar(20) NOT NULL default '',
	UnitSystem tinyint(4) NOT NULL default '1',
	PRIMARY KEY (LanguageId)
	);

	CREATE TABLE Modules (
	Name varchar(255) NOT NULL default '',
	Path varchar(255) NOT NULL default '',
	Var varchar(10) NOT NULL default '',
	Version varchar(10) NOT NULL default '',
	Loaded tinyint(4) NOT NULL default '1',
	LoadOrder tinyint(4) NOT NULL default '0',
	TemplatePath varchar(255) NOT NULL default '',
	RootCat int(11) NOT NULL default '0',
	BuildDate double NOT NULL default '0',
	PRIMARY KEY (Name)
	);

	CREATE TABLE PersistantSessionData (
	PortalUserId int(11) NOT NULL default '0',
	VariableName varchar(255) NOT NULL default '',
	VariableValue text NOT NULL,
	PRIMARY KEY (PortalUserId,VariableName),
	KEY UserId (PortalUserId),
	KEY VariableName (VariableName)
	);

	CREATE TABLE Phrase (
	Phrase varchar(255) NOT NULL default '',
	Translation text NOT NULL default '',
	PhraseType int(11) NOT NULL default '0',
	PhraseId int(11) NOT NULL auto_increment,
	LanguageId int(11) NOT NULL default '0',
	LastChanged int(10) unsigned NOT NULL default '0',
	LastChangeIP varchar(15) NOT NULL default '',
	Module varchar(30) NOT NULL default '',
	PRIMARY KEY (PhraseId),
	KEY LanguageId (LanguageId),
	INDEX Phrase_Index (Phrase)
	);

	CREATE TABLE PhraseCache (
	Template varchar(40) NOT NULL default '',
	PhraseList text NOT NULL,
	CacheDate int(11) NOT NULL default '0',
	ThemeId int(11) NOT NULL default '0',
	StylesheetId int(10) unsigned NOT NULL default '0',
	ConfigVariables text,
	PRIMARY KEY (Template)
	);

	CREATE TABLE PortalGroup (
	GroupId int(11) NOT NULL auto_increment,
	Name varchar(255) NOT NULL default '',
	Description varchar(255) default NULL,
	CreatedOn double NOT NULL default '0',
	System tinyint(4) NOT NULL default '0',
	Personal tinyint(4) NOT NULL default '0',
	Enabled tinyint(4) NOT NULL default '1',
	ResourceId int(11) NOT NULL default '0',
	PRIMARY KEY (GroupId),
	UNIQUE KEY Name (Name),
	UNIQUE KEY ResourceId (ResourceId),
	KEY Personal (Personal),
	KEY Enabled (Enabled)
	);

	CREATE TABLE PortalUser (
	PortalUserId int(11) NOT NULL auto_increment,
	Login varchar(255) default NULL,
	`Password` varchar(255) default NULL,
	FirstName varchar(255) default NULL,
	LastName varchar(255) default NULL,
	Company varchar(255) NOT NULL default '',
	Email varchar(255) NOT NULL default '',
	CreatedOn double NOT NULL default '0',
	Phone varchar(20) default NULL,
	Fax varchar(255) NOT NULL default '',
	Street varchar(255) default NULL,
	Street2 varchar(255) NOT NULL default '',
	City varchar(20) default NULL,
	State varchar(20) NOT NULL default '',
	Zip varchar(20) default NULL,
	Country varchar(20) NOT NULL default '',
	ResourceId int(11) NOT NULL default '0',
	`Status` tinyint(4) NOT NULL default '2',
	Modified int(11) NOT NULL default '0',
	dob double NOT NULL default '0',
	tz int(11) default NULL,
	ip varchar(20) default NULL,
	IsBanned tinyint(1) NOT NULL default '0',
	PassResetTime bigint(20) default NULL,
	PwResetConfirm varchar(255) default NULL,
	PwRequestTime bigint(25) default NULL,
	MinPwResetDelay int(11) NOT NULL default '1800',
	PRIMARY KEY (PortalUserId),
	UNIQUE KEY ResourceId (ResourceId),
	UNIQUE KEY Login (Login),
	KEY CreatedOn (CreatedOn)
	);

	CREATE TABLE PortalUserCustomData (
	CustomDataId int(11) NOT NULL auto_increment,
	ResourceId int(10) unsigned NOT NULL default '0',
	KEY ResourceId (ResourceId),
	PRIMARY KEY (CustomDataId)
	);

	CREATE TABLE SessionData (
	SessionKey varchar(50) NOT NULL default '',
	VariableName varchar(255) NOT NULL default '',
	VariableValue text NOT NULL,
	PRIMARY KEY (SessionKey,VariableName),
	KEY SessionKey (SessionKey),
	KEY VariableName (VariableName)
	);

	CREATE TABLE Theme (
	ThemeId int(11) NOT NULL auto_increment,
	Name varchar(40) NOT NULL default '',
	Enabled int(11) NOT NULL default '1',
	Description varchar(255) default NULL,
	PrimaryTheme int(11) NOT NULL default '0',
	CacheTimeout int(11) NOT NULL default '0',
	StylesheetId int(10) unsigned NOT NULL default '0',
	PRIMARY KEY (ThemeId)
	);

	CREATE TABLE ThemeFiles (
	FileId int(11) NOT NULL auto_increment,
	ThemeId int(11) NOT NULL default '0',
	FileName varchar(255) NOT NULL default '',
	FilePath varchar(255) NOT NULL default '',
	Description varchar(255) default NULL,
	FileType int(11) NOT NULL default '0',
	FileFound tinyint(3) unsigned NOT NULL default '0',
	PRIMARY KEY (FileId),
	KEY theme (ThemeId),
	KEY FileName (FileName),
	KEY FilePath (FilePath),
	KEY FileFound (FileFound)
	);

	CREATE TABLE UserGroup (
	PortalUserId int(11) NOT NULL default '0',
	GroupId int(11) NOT NULL default '0',
	MembershipExpires int(10) unsigned default NULL,
	PrimaryGroup tinyint(4) NOT NULL default '1',
	ExpirationReminderSent tinyint(4) NOT NULL default '0',
	PRIMARY KEY (PortalUserId,GroupId),
	KEY GroupId (GroupId),
	KEY PrimaryGroup (PrimaryGroup)
	);

	CREATE TABLE UserSession (
	SessionKey varchar(50) NOT NULL default '',
	CurrentTempKey varchar(50) default NULL,
	PrevTempKey varchar(50) default NULL,
	LastAccessed double NOT NULL default '0',
	PortalUserId varchar(255) NOT NULL default '',
	Language varchar(255) NOT NULL default '',
	Theme varchar(255) NOT NULL default '',
	GroupId int(11) NOT NULL default '0',
	IpAddress varchar(20) NOT NULL default '0.0.0.0',
	Status int(11) NOT NULL default '1',
	GroupList varchar(255) default NULL,
	tz int(11) default NULL,
	PRIMARY KEY (SessionKey),
	KEY UserId (PortalUserId),
	KEY LastAccessed (LastAccessed)
	);

	CREATE TABLE EmailLog (
	EmailLogId int(11) NOT NULL auto_increment,
	fromuser varchar(200) default NULL,
	addressto varchar(255) default NULL,
	`subject` varchar(255) default NULL,
	`timestamp` bigint(20) default '0',
	event varchar(100) default NULL,
	EventParams text NOT NULL,
	PRIMARY KEY (EmailLogId)
	);

	CREATE TABLE Cache (
	VarName varchar(255) NOT NULL default '',
	Data longtext,
	Cached int(11) default NULL,
	LifeTime int(11) NOT NULL default '-1',
	PRIMARY KEY (VarName),
	KEY Cached (Cached)
	);

	CREATE TABLE StdDestinations (
	DestId int(11) NOT NULL auto_increment,
	DestType int(11) NOT NULL default '0',
	DestParentId int(11) default NULL,
	DestName varchar(255) NOT NULL default '',
	DestAbbr char(3) NOT NULL default '',
	DestAbbr2 char(2) default '',
	PRIMARY KEY (DestId)
	);

	CREATE TABLE Category (
	CategoryId int(11) NOT NULL auto_increment,
	`Type` int(11) NOT NULL default '0',
	ParentId int(11) NOT NULL default '0',
	Name varchar(255) NOT NULL default '',
	l1_Name varchar(255) NOT NULL default '',
	l2_Name varchar(255) NOT NULL default '',
	l3_Name varchar(255) NOT NULL default '',
	l4_Name varchar(255) NOT NULL default '',
	l5_Name varchar(255) NOT NULL default '',
	Filename varchar(255) NOT NULL default '',
	AutomaticFilename tinyint(3) unsigned NOT NULL default '1',
	Description text NOT NULL,
	l1_Description text NOT NULL,
	l2_Description text NOT NULL,
	l3_Description text NOT NULL,
	l4_Description text NOT NULL,
	l5_Description text NOT NULL,
	CreatedOn int(11) NOT NULL default '0',
	EditorsPick tinyint(4) NOT NULL default '0',
	`Status` tinyint(4) NOT NULL default '0',
	Pop tinyint(4) default NULL,
	Priority int(11) NOT NULL default '0',
	MetaKeywords varchar(255) default NULL,
	CachedDescendantCatsQty int(11) default NULL,
	CachedNavbar text NOT NULL,
	l1_CachedNavbar text NOT NULL,
	l2_CachedNavbar text NOT NULL,
	l3_CachedNavbar text NOT NULL,
	l4_CachedNavbar text NOT NULL,
	l5_CachedNavbar text NOT NULL,
	CreatedById int(11) NOT NULL default '0',
	ResourceId int(11) default NULL,
	ParentPath text NOT NULL,
	NamedParentPath text NOT NULL,
	MetaDescription varchar(255) default NULL,
	HotItem int(11) NOT NULL default '2',
	NewItem int(11) NOT NULL default '2',
	PopItem int(11) NOT NULL default '2',
	Modified int(11) NOT NULL default '0',
	ModifiedById int(11) NOT NULL default '0',
	CategoryTemplate varchar(255) NOT NULL default '',
	CachedCategoryTemplate varchar(255) NOT NULL default '',
	PRIMARY KEY (CategoryId),
	UNIQUE KEY ResourceId (ResourceId),
	KEY ParentId (ParentId),
	KEY Modified (Modified),
	KEY Priority (Priority),
	KEY sorting (Name,Priority),
	KEY Filename (Filename(5)),
	KEY l1_Name (l1_Name(5)),
	KEY l2_Name (l2_Name(5)),
	KEY l3_Name (l3_Name(5)),
	KEY l4_Name (l4_Name(5)),
	KEY l5_Name (l5_Name(5)),
	KEY l1_Description (l1_Description(5)),
	KEY l2_Description (l2_Description(5)),
	KEY l3_Description (l3_Description(5)),
	KEY l4_Description (l4_Description(5)),
	KEY l5_Description (l5_Description(5))
	);

	CREATE TABLE CategoryCustomData (
	CustomDataId int(11) NOT NULL auto_increment,
	ResourceId int(10) unsigned NOT NULL default '0',
	KEY ResourceId (ResourceId),
	PRIMARY KEY (CustomDataId)
	);

	CREATE TABLE CategoryItems (
	`CategoryId` int(11) NOT NULL default '0',
	`ItemResourceId` int(11) NOT NULL default '0',
	`PrimaryCat` tinyint(4) NOT NULL default '0',
	`ItemPrefix` varchar(50) NOT NULL default '',
	`Filename` varchar(255) NOT NULL default '',
	UNIQUE KEY `CategoryId` (`CategoryId`,`ItemResourceId`),
	KEY `PrimaryCat` (`PrimaryCat`),
	KEY `ItemPrefix` (`ItemPrefix`),
	KEY `Filename` (`Filename`(4))
	);

	CREATE TABLE PermCache (
	PermCacheId int(11) NOT NULL auto_increment,
	CategoryId int(11) NOT NULL default '0',
	PermId int(11) NOT NULL default '0',
	ACL varchar(255) NOT NULL default '',
	DACL varchar(255) NOT NULL default '',
	PRIMARY KEY (PermCacheId),
	KEY CategoryId (CategoryId),
	KEY PermId (PermId)
	);

	CREATE TABLE Stylesheets (
	StylesheetId int(11) NOT NULL auto_increment,
	Name varchar(255) NOT NULL default '',
	Description varchar(255) NOT NULL default '',
	AdvancedCSS text NOT NULL,
	LastCompiled int(10) unsigned NOT NULL default '0',
	Enabled int(11) NOT NULL default '0',
	PRIMARY KEY (StylesheetId)
	);

	CREATE TABLE PopupSizes (
	PopupId int(10) unsigned NOT NULL auto_increment,
	TemplateName varchar(255) NOT NULL default '',
	PopupWidth int(11) NOT NULL default '0',
	PopupHeight int(11) NOT NULL default '0',
	PRIMARY KEY (PopupId),
	KEY TemplateName (TemplateName)
	);
	-
	-CREATE TABLE SpiderUserAgents (
	- `AgentId` int(10) unsigned NOT NULL auto_increment,
	- `Name` varchar(255) NOT NULL default '',
	- `Version` varchar(100) NOT NULL default '',
	- `UserAgent` varchar(255) NOT NULL default '',
	- PRIMARY KEY (`AgentId`),
	- KEY `UserAgent` (`UserAgent`(100))
	-);

	Property changes on: branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.4.2.2
	\ No newline at end of property
	+1.4.2.3
	\ No newline at end of property

in-portalNo OneTemporaryActions

File Metadata

in-portalView Options

Event Timeline

in-portal
No OneTemporary
Actions

in-portal
View Options