<?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[6] = array(
	'hive_contact' => 'ALTER TABLE hive_contact
		ADD usergroupids varchar(250) NOT NULL default \'\' AFTER userid',
	'hive_usergroup' => 'ALTER TABLE hive_usergroup
		ADD permlink varchar(100) NOT NULL default \'\',
		ADD maxpopstorage float NOT NULL default \'0\'',
);

// ############################################################################
// Records
$inserts[6] = array(
	'UPDATE hive_usergroup SET perms = perms + 33554432 WHERE NOT(perms & 33554432)',
	'UPDATE hive_user SET options2 = options2 + 128',
	'UPDATE hive_rule SET action = CONCAT(action, \'~\'), cond = CONCAT(\'1~\', cond)',
	'INSERT INTO hive_setting SET title = \'Support email address\', settinggroupid = 1, description = \'Enter the email address you wish to be displayed to your users as the support email address. It appears in the footer of every page as well as in the Global Address Book. (Updating this option will update the Support contact that was inserted in the Global Address Book during installation.)\', variable = \'supportemail\', value = \'\', type = \'text\', display = 16',
	'INSERT INTO hive_setting SET title = \'Show statistics on index\', settinggroupid = 5, description = \'If this is set to Yes, the system will generate a statistics display for the main page of the Admin Control Panel. Depending on how many users and messages your system has, this may take a while to generate, so you may wish to disable it.\', variable = \'cp_showstats\', value = 1, type = \'yesno\', display = 6',
	'UPDATE hive_settinggroup SET display = 0 WHERE description = \'hivepop\'',
	'UPDATE hive_setting SET description= \'Enter the absolute path to the folder that contains the message and data files. If you change this and already have HivePOP3 running, please don\\\'t forget to move the existing files to the new location. If you don\\\'t, all existing messages that are waiting to be collected will be deleted.\' WHERE variable = \'hivepop_path\'',
	'INSERT INTO hive_setting SET title = \'Forward postmaster to administrator\', settinggroupid = 11, description = \'If this is enabled messages sent to the postmaster address will be forwarded the first administrator account, unless a user with the name postmaster exists.\', variable = \'fwdpostmaster\', value = 1, type = \'yesno\', display = 7',
);

?>