<?php
// +-------------------------------------------------------------+
// | HiveMail™ version 1.3.1
// +-------------------------------------------------------------+
// | HIVEMAIL™ IS NOT FREE SOFTWARE
// | If you have downloaded this software from a website other
// | than Hivemail or if you have otherwise received
// | this software from someone who is not a representative of
// | this organization you are involved in an illegal activity.
// +-------------------------------------------------------------+
// +-------------------------------------------------------------+

// ############################################################################
// Table structure
$tables[10] = array(
	'hive_language' => 'CREATE TABLE hive_language (
languageid INT UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR( 100 ) NOT NULL,
phrases TEXT NOT NULL,
userselectable TINYINT UNSIGNED NOT NULL,
textdir CHAR( 3 ) NOT NULL,
langcode VARCHAR( 20 ) NOT NULL,
htmlcharset VARCHAR( 40 ) NOT NULL,
emailcharset VARCHAR( 40 ) NOT NULL,
dateformat VARCHAR( 30 ) NOT NULL,
timeformat VARCHAR( 30 ) NOT NULL,
cal_use24 TINYINT UNSIGNED NOT NULL,
PRIMARY KEY ( languageid )
)',
	'hive_phrase' => 'CREATE TABLE hive_phrase (
phraseid INT UNSIGNED NOT NULL AUTO_INCREMENT,
phraseareaid INT UNSIGNED NOT NULL,
languageid INT NOT NULL,
variable VARCHAR( 200 ) NOT NULL,
value TEXT NOT NULL,
PRIMARY KEY ( phraseid )
)',
	'hive_phrasegroup' => 'CREATE TABLE hive_phrasegroup (
phrasegroupid INT UNSIGNED NOT NULL AUTO_INCREMENT,
phraseareaid INT UNSIGNED DEFAULT \'0\' NOT NULL,
title VARCHAR( 100 ) NOT NULL,
PRIMARY KEY ( phrasegroupid )
)',
	'hive_plan' => 'ALTER TABLE hive_plan CHANGE length length MEDIUMINT UNSIGNED DEFAULT \'0\' NOT NULL,
CHANGE triallength triallength MEDIUMINT UNSIGNED DEFAULT \'0\' NOT NULL,
CHANGE reminder reminder MEDIUMINT UNSIGNED DEFAULT \'0\' NOT NULL',
	'hive_setting' => 'ALTER TABLE hive_setting CHANGE settinggroupid grouptitle VARCHAR( 20 ) NOT NULL,
ADD typeoptions MEDIUMTEXT NOT NULL AFTER type',
	'hive_settinggroup' => 'ALTER TABLE hive_settinggroup CHANGE settinggroupid grouptitle VARCHAR( 20 ) NOT NULL,
CHANGE display display TINYINT( 3 ) DEFAULT \'0\' NOT NULL',
	'hive_user' => 'ALTER TABLE hive_user CHANGE vbuserid forumuserid INT UNSIGNED DEFAULT \'0\' NOT NULL,
ADD languageid INT UNSIGNED NOT NULL AFTER skinid',
);

// ############################################################################
// Records
$inserts[10] = array(
	// Change settings over to the new system
	'UPDATE hive_setting SET type = "textarea" WHERE type = "area"',
	'UPDATE hive_setting SET type = "select", typeoptions = "mbox||mbox//maildir||Maildir//mh||MH" WHERE type = "mboxselect"',
	'UPDATE hive_setting SET type = "select", typeoptions = "hive_skin" WHERE type = "select_skin"',
	'UPDATE hive_setting SET type = "select", typeoptions = "hive_usergroup" WHERE type = "select_usergroup"',
	'UPDATE hive_setting SET type = "radio", typeoptions = "yesno" WHERE type = "yesno"',
	'UPDATE hive_setting SET type = "radio", typeoptions = "1||Always require//-1||Only if needed//0||Never require" WHERE type = "altemail"',
	'UPDATE hive_settinggroup SET grouptitle = "general", description = "Overall options that don\'t fit in other groups." WHERE title = "General Options"',
	'UPDATE hive_settinggroup SET grouptitle = "user", description = "Settings that control global user limits." WHERE title = "User Options"',
	'UPDATE hive_settinggroup SET grouptitle = "internal", description = "Do NOT edit these variables, or your HiveMail installation may stop functioning correctly." WHERE title = "Internal Variables"',
	'UPDATE hive_settinggroup SET grouptitle = "pop3o", description = "Settings related to connecting to external POP3 accounts." WHERE title = "POP3 Options"',
	'UPDATE hive_settinggroup SET grouptitle = "pipeg", description = "" WHERE title = "Pipe Gateway"',
	'UPDATE hive_settinggroup SET grouptitle = "fileg", description = "Options relating to the File Gateway method of email collection. (At the current time, the File Gateway does not function.)" WHERE title = "File Gateway"',
	'UPDATE hive_settinggroup SET grouptitle = "pop3g", description = "Settings related to using the POP3 email gateway." WHERE title = "POP3 Gateway"',
	'UPDATE hive_settinggroup SET grouptitle = "admincp", description = "The settings in this section only affect the Admin Control Panel of HiveMail&trade;." WHERE title = "Admin Control Panel"',
	'UPDATE hive_settinggroup SET grouptitle = "email", description = "" WHERE title = "Email Settings"',
	'UPDATE hive_settinggroup SET grouptitle = "datetime", description = "" WHERE title = "Time and Date"',
	'UPDATE hive_settinggroup SET grouptitle = "safemode", description = "If PHP is running in Safe Mode you may need to modify these settings to make sure the program operates correctly." WHERE title = "Safe Mode"',
	'UPDATE hive_settinggroup SET grouptitle = "registration", description = "Settings related to user registration and new accounts." WHERE title = "Registration"',
	'UPDATE hive_settinggroup SET grouptitle = "reading", description = "" WHERE title = "Email Reading"',
	'UPDATE hive_settinggroup SET grouptitle = "processing", description = "Settings related to processing emails and spam." WHERE title = "Email Processing"',
	'UPDATE hive_settinggroup SET grouptitle = "storage", description = "Settings related to storing messages in files (instead of in the database)." WHERE title = "Message Storage"',
	'UPDATE hive_settinggroup SET grouptitle = "gzip", description = "If your server supports it, GZIP can reduce the amount of bandwidth your site uses by compressing pages before they are sent to the user\'s browser." WHERE title = "GZIP Compression"',
	'UPDATE hive_settinggroup SET grouptitle = "smtp", description = "If you need to use an external SMTP server to send emails from HiveMail, fill in the details in this section." WHERE title = "SMTP Settings"',
	'UPDATE hive_settinggroup SET grouptitle = "integration", description = "HiveMail&trade; can integrate with several forum packages, including vBulletin and Invision Power Board. See the Forum Integration section of the manual for more information. If you enable forum integration, be sure to fill out all settings in this section.", title="Forum Integration" WHERE title = "vBulletin Integration"',
	'UPDATE hive_settinggroup SET grouptitle = "hivepop3", description = "Settings related to the HivePOP3 plugin. (At the current time, the HivePOP3 plugin is not available.)" WHERE title = "HivePOP3 Settings"',
	'UPDATE hive_settinggroup SET grouptitle = "subs", description = "Settings related to using the Subscriptions feature." WHERE title = "Subscription Settings"',
	'UPDATE hive_setting SET grouptitle = "general" WHERE variable IN ("appname", "defaultskin", "domainname", "appurl", "useredirect", "maintain", "skinonlogin", "skinonlogingroup", "logindomains", "bannedips", "cookiedomain", "cookiepath", "indexname", "crlf", "supportemail")',
	'UPDATE hive_setting SET grouptitle = "user" WHERE variable IN ("minpercentforgauge", "maxperpage", "maxsoundfile", "maxemptybindays", "maxonline", "sendpwtoalt")',
	'UPDATE hive_setting SET grouptitle = "internal" WHERE variable IN ("pop3_lastrun", "versionnum", "flat_prefix", "last_expiry_check", "flat_curfolder", "flat_curcount", "defuseroptions", "last_atomic_clock_check", "atomic_clock_time_diff", "gatewaytype", "cp_lastannouncementcheck", "cp_announcementcache", "subs_lastcheck")',
	'UPDATE hive_setting SET grouptitle = "pop3o" WHERE variable IN ("pop3_useimap", "pop3_maxmsgs", "pop3_maxsize")',
	'UPDATE hive_setting SET grouptitle = "fileg" WHERE variable IN ("fg_path", "fg_format")',
	'UPDATE hive_setting SET grouptitle = "pop3g" WHERE variable IN ("pop3_server", "pop3_port", "pop3_username", "pop3_password", "pop3_runevery", "pop3_cron", "pop3_nodelete")',
	'UPDATE hive_setting SET grouptitle = "admincp" WHERE variable IN ("cp_templatetree", "cp_links", "cp_showannouncements", "cp_showstats")',
	'UPDATE hive_setting SET grouptitle = "email" WHERE variable IN ("smtp_errorfrom", "bounceback", "catchalluser", "mailer_name")',
	'UPDATE hive_setting SET grouptitle = "datetime" WHERE variable IN ("dateformat", "timeformat", "timeoffset", "time_server", "cal_use24")',
	'UPDATE hive_setting SET grouptitle = "safemode" WHERE variable IN ("safeupload", "tmppath")',
	'UPDATE hive_setting SET grouptitle = "registration" WHERE variable IN ("regopen", "moderate", "sendgreeting", "reservedtext", "newuseremail", "termsofservice", "regcodecheck", "regcodesameset", "reg_requirealtemail", "reg_maxipusage", "sendgreeting_html")',
	'UPDATE hive_setting SET grouptitle = "reading" WHERE variable IN ("allowcid", "framelinks", "allowbouncing")',
	'UPDATE hive_setting SET grouptitle = "processing" WHERE variable IN ("fwdpostmaster", "dnsbls", "globalblock", "globalsafe", "ignore_addys", "checkassassin", "maxprocsize")',
	'UPDATE hive_setting SET grouptitle = "storage" WHERE variable IN ("flat_use", "flat_path")',
	'UPDATE hive_setting SET grouptitle = "gzip" WHERE variable IN ("gzip_use", "gzip_level")',
	'UPDATE hive_setting SET grouptitle = "smtp" WHERE variable IN ("smtp_host", "smtp_port", "smtp_helo", "smtp_auth", "smtp_user", "smtp_pass", "smtp_persistent")',
	'UPDATE hive_setting SET grouptitle = "integration" WHERE variable IN ("integ_use", "integ_filepath", "integ_url", "integ_allownormal")',
	'UPDATE hive_setting SET grouptitle = "hivepop3" WHERE variable IN ("hivepop_enabled", "hivepop_serveraddr", "hivepop_serverport", "hivepop_allowdupe", "hivepop_path")',
	'UPDATE hive_setting SET grouptitle = "subs" WHERE variable IN ("subs_paypalemail", "subs_2cosellerid", "subs_2cosecretkey")',
	'UPDATE hive_settinggroup SET display = "-1" WHERE grouptitle = "pipeg"',

	// vBulletin -> Forum
	'INSERT INTO hive_setting SET title = "Forum system", grouptitle="integration", description = "Choose the forum system that you are enabling integration with.", variable = "integ_system", value = "", type = "select", typeoptions = "vb3||vBulletin 3.x//ipb13||Invision Power Board v1.2 or 1.3", display = 2',
	'UPDATE hive_setting SET title = "Enable forum integration", description = "Turn this on to enable forum integration. Depending on which forum system you use, you may need to make additional modifications to your forums.", variable = "integ_use" WHERE variable = "vb_use"',
	'UPDATE hive_setting SET title = "Location of forum files", description = "Please enter the complete absolute path to the forum program files. This is <i>not</i> the URL to your board! If you are not sure what the path to the files is, please contact your host.", variable = "integ_filepath", display = 3 WHERE variable = "vb_filepath"',
	'UPDATE hive_setting SET description = "The complete URL of your forums. Please do not add a trailing slash.", variable = "integ_url", display = 4 WHERE variable = "vb_url"',
	'UPDATE hive_setting SET description = "Enable this option if you want to allow users to sign up for a HiveMail™ account only, without first obtaining a forum account.", variable = "integ_allownormal", display = 5 WHERE variable = "vb_allownormal"',

	// Language
	'UPDATE hive_user SET languageid = 1',
	'INSERT INTO hive_setting SET title = "Default language", grouptitle = "general", description = "Choose the default language that users will see if they are not logged in or have not chosen a specific language.", variable = "defaultlang", value = "", type = "select", typeoptions = "hive_language", display = 9',
	'INSERT INTO hive_setting SET title = "Display language menu on login", grouptitle = "general", description = "Whether or not to show the language selection menu on the login screen, so users can choose a different language while logging into their account. This option will override the user\'s default language setting for that session.", variable = "langonlogin", value = 1, type = "radio", typeoptions = "yesno", display = 10',
	'UPDATE hive_setting SET display = 7 WHERE variable = "skinonlogin"',
	'UPDATE hive_setting SET display = 8 WHERE variable = "skinonlogingroup"',
	'UPDATE hive_setting SET display = 17 WHERE variable = "supportemail"',
	'UPDATE hive_setting SET display = 16 WHERE variable = "crlf"',
	'UPDATE hive_setting SET display = 15 WHERE variable = "indexname"',
	'UPDATE hive_setting SET display = 14 WHERE variable = "cookiepath"',
	'UPDATE hive_setting SET display = 13 WHERE variable = "cookiedomain"',
	'UPDATE hive_setting SET display = 11, description = "If set, logins will <b>only</b> be allowed from these domains. To specify multiple domain names, put each one on its own line.<br /><br />e.g. yourdomain.c0m would allow logins from users who login at mail.yourdomain.c0m, while users who fill out a login form at example2.net will be rejected<br /><br />Leaving this box blank allows logins from any domain." WHERE variable = "logindomains"',
	'UPDATE hive_setting SET display = 12, description = "IP addresses or hostnames which you wish to ban from using HiveMail&trade;. Wildcards may be used. One entry per line.<br /><br />e.g. 127.* would ban all users with IP addresses beginning with 127.<br />*.yourdomain.c0m would ban all users in the yourdomain.c0m domain." WHERE variable = "bannedips"',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "global_event", "Global Event")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "shared_event", "Shared Event")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "x_added_to_userlist_by_x", "{1} added to userlist by {2}")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "preferences", "Preferences")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "calendar_options", "Calendar Options")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "send_new_mail", "Send New Mail")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "spell_checker", "Spell Checker")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "move_up", "Move Up")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "move_down", "Move Down")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "folder_management", "Folder Management")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "and", "and")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "unread_message", "unread message")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "unread_messages", "unread messages")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "in_your", "in your")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "folder", "folder")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "top", "top")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "bottom", "bottom")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "aliases", "Aliases")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "autoresponder", "Autoresponder")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "compose_options", "Compose Options")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "folder_view_options", "Folder View Options")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "general_options", "General Options")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "password_and_security", "Password and Security")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "personal_information", "Personal Information")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "reading_options", "Reading Options")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "signatures", "Signatures")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "subscription_options", "Subscription Options")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "no_subject", "no subject")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "message_high_priority", "This message is high priority")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "message_low_priority", "This message is low priority")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "pop_accounts", "POP Accounts")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "read_mail", "Read Mail")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "copy_it_to_folder", "copy it to folder")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "move_it_to_folder", "move it to folder")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "highlight_it_in", "highlight it in")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "message_rules", "Message Rules")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "apply_rule", "Apply Rule")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "search_messages", "Search Messages")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "sign_up", "Sign Up")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "unread", "unread")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "total", "total")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "last_x_unread_messages_in_folder", "Last {1} unread messages in folder")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "from", "From")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "subject", "Subject")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "link", "Link")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "no_unread_in_folder", "No unread messages in this folder")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "last_checked_at_x", "Last checked at {1}")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "folder_inbox", "Inbox")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "folder_sentitems", "Sent Items")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "folder_trashcan", "Trash Can")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "folder_junkmail", "Junk Mail")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "rich_text_mode", "Rich Text Mode")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "plain_text_mode", "Plain Text Mode")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "when", "when")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "email_address", "email address")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "message", "message")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "recipients", "recipients")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "equals", "equals")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "contains", "contains")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "does_not_contain", "does not contain")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "begins_with", "begins with")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "ends_with", "ends with")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "email_is_from_account", "email is from account")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "delete_it", "delete it")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "mark_it_as_read", "mark it as read")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 1, -1, "flag_it", "flag it")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_sun_long", "Sunday")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_mon_long", "Monday")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_tue_long", "Tuesday")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_wed_long", "Wednesday")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_thu_long", "Thursday")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_fri_long", "Friday")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_sat_long", "Saturday")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_sun_short", "S")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_mon_short", "M")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_tue_short", "T")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_wed_short", "W")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_thu_short", "T")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_fri_short", "F")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "day_sat_short", "S")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_jan_long", "January")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_jan_short", "Jan")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_feb_long", "February")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_feb_short", "Feb")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_mar_long", "March")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_mar_short", "Mar")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_apr_long", "April")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_apr_short", "Apr")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_may_long", "May")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_may_short", "May")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_jun_long", "June")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_jun_short", "Jun")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_jul_long", "July")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_jul_short", "July")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_aug_long", "August")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_aug_short", "Aug")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_sep_long", "September")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_sep_short", "Sep")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_oct_long", "October")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_oct_short", "Oct")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_nov_long", "November")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_nov_short", "Nov")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_dec_long", "December")',
	'INSERT INTO hive_phrase (phraseid, phraseareaid, languageid, variable, value) VALUES (NULL, 2, -1, "month_dec_short", "Dec")',
	'INSERT INTO hive_phrasegroup (phrasegroupid, phraseareaid, title) VALUES (NULL, 1, "Global")',
	'INSERT INTO hive_phrasegroup (phrasegroupid, phraseareaid, title) VALUES (NULL, 2, "Calendar")',
	'INSERT INTO hive_language (languageid, title, userselectable, textdir, langcode, htmlcharset, emailcharset, dateformat, timeformat, cal_use24) VALUES (1, "English", 1, "ltr", "en", "ISO-8859-1", "iso-8859-1", "", "", 0)',

	// Link to the manual
	'INSERT INTO hive_cplink SET title = "HiveMail&trade; Manual", url = "#", display = 4, newwin = 1',
);

?>