<!--

// Release Vars [ Date, Release Version, Last Version, Upgrade SQL from last to release ( If this is "" it will change the release block `File Upgrade Type: File Only` as well as change the `Datebase Upgrade: NO` 

release_date="September  2008"
release_ap_version="3.2.6x"
last_ap_version="3.2.61"
// `release_upgrade_sql` is the FULL SQL Commands to be run.
// \r\n add a line break to the textarea
// \\r\\n adds \r\n to the database SQL
// ! IMPORTANT ! Must be a SINGLE LINE
release_upgrade_sql="ALTER TABLE `autopilot_batch` CHANGE `status` `status` ENUM( 'declined', 'error', 'completed', 'expired', 'bad card' ) NOT NULL DEFAULT 'declined';\r\n\r\nCREATE TABLE `autopilot_server_group_members` (\r\n  `id` int(5) NOT NULL auto_increment,\r\n  `group_id` int(5) NOT NULL default '0',\r\n  `server_id` int(5) NOT NULL default '0',\r\n  PRIMARY KEY  (`id`)\r\n) TYPE=MyISAM;\r\n\r\nCREATE TABLE `autopilot_server_groups` (\r\n  `id` int(5) NOT NULL auto_increment,\r\n  `group_name` varchar(255) NOT NULL default '',\r\n  `group_type` enum('whm','plesk') NOT NULL default 'whm',\r\n  `max_accounts` int(4) NOT NULL default '250',\r\n  `fallback` int(4) NOT NULL default '0',\r\n  PRIMARY KEY  (`id`)\r\n) TYPE=MyISAM;\r\n\r\nALTER TABLE `autopilot_email_groups` ADD `group_type` ENUM('client', 'admin') NOT NULL AFTER `group_name`;\r\nALTER TABLE `autopilot_email_events` ADD `event_type` ENUM('client', 'admin') NOT NULL AFTER `attributes`;\r\n\r\nINSERT INTO `autopilot_email_events` VALUES ('server_group_update', 'm_server_group_details,generated_on,email_signature', 'admin');\r\nINSERT INTO `autopilot_email_events` VALUES ('server_totals_update', 'm_server_totals_details,generated_on,email_signature', 'admin');\r\n\r\nDELETE FROM `autopilot_email_events` WHERE `event_id` LIKE 'invoice_%';\r\n\r\nINSERT INTO `autopilot_email_events` VALUES ('invoice_created', 'acc_first_name,acc_last_name,m_invoice_id,m_invoice_amount,m_invoice_due,m_order_profile_client_login,m_order_profile_currency_symbol,m_order_profile_currency,generated_on,email_signature', 'client');\r\nINSERT INTO `autopilot_email_events` VALUES ('invoice_paid', 'acc_first_name,acc_last_name,m_invoice_id,m_invoice_amount,m_invoice_amount_applied,m_invoice_due,m_order_profile_client_login,m_order_profile_currency_symbol,m_order_profile_currency,generated_on,email_signature', 'client');\r\nINSERT INTO `autopilot_email_events` VALUES ('invoice_past_due', 'acc_first_name,acc_last_name,m_invoice_id,m_invoice_amount,m_invoice_due,m_order_profile_client_login,m_order_profile_currency_symbol,m_order_profile_currency,generated_on,email_signature', 'client');\r\n\r\nINSERT INTO `autopilot_email` (`group_id`, `event_id`, `email_name`, `email_type`, `email_priority`, `email_copy_to`, `email_subject`, `email_message`, `default_email`, `default_from`, `system_locked`, `send_expire_email`) VALUES (1, 'server_group_update', 'Server Group Updated', 1, 1, '', 'Server Group Update', 'There has been a server group update, details are as follows:\\r\\n\\r\\n{m_server_group_details}\\r\\n\\r\\n{email_signature}\\r\\n\\r\\n---------------------------------------------------------------------------------\\r\\nThis e-mail was generated on: {generated_on}', 'you@yourcompany.com', 'Your Company', 'no', 0);\r\nINSERT INTO `autopilot_email` (`group_id`, `event_id`, `email_name`, `email_type`, `email_priority`, `email_copy_to`, `email_subject`, `email_message`, `default_email`, `default_from`, `system_locked`, `send_expire_email`) VALUES (1, 'server_totals_update', 'Sever Account Totals Updated', 1, 3, '', 'Sever Account Totals Updated', 'Your server account totals have been updated.  The details are below:\\r\\n\\r\\n{m_server_totals_details}\\r\\n\\r\\n{email_signature}\\r\\n\\r\\n---------------------------------------------------------------------------------\\r\\nThis e-mail was generated on: {generated_on}', 'you@yourcompany.com', 'Your Company', 'no', 0);\r\n\r\nALTER TABLE `autopilot_products` CHANGE `server_id` `server_id` VARCHAR(15) NOT NULL;\r\n\r\nALTER TABLE `autopilot_account_log` TYPE = MYISAM;\r\nALTER TABLE `autopilot_accounts` TYPE = MYISAM;\r\nALTER TABLE `autopilot_admin` TYPE = MYISAM;\r\nALTER TABLE `autopilot_admin_acl` TYPE = MYISAM;\r\nALTER TABLE `autopilot_admin_profile` TYPE = MYISAM;\r\nALTER TABLE `autopilot_agreements` TYPE = MYISAM;\r\nALTER TABLE `autopilot_api` TYPE = MYISAM;\r\nALTER TABLE `autopilot_as_emails` TYPE = MYISAM;\r\nALTER TABLE `autopilot_backups` TYPE = MYISAM;\r\nALTER TABLE `autopilot_batch` TYPE = MYISAM;\r\nALTER TABLE `autopilot_bookmarks` TYPE = MYISAM;\r\nALTER TABLE `autopilot_category` TYPE = MYISAM;\r\nALTER TABLE `autopilot_client_news` TYPE = MYISAM;\r\nALTER TABLE `autopilot_clients` TYPE = MYISAM;\r\nALTER TABLE `autopilot_config` TYPE = MYISAM;\r\nALTER TABLE `autopilot_coupons` TYPE = MYISAM;\r\nALTER TABLE `autopilot_cron` TYPE = MYISAM;\r\nALTER TABLE `autopilot_custom_modules` TYPE = MYISAM;\r\nALTER TABLE `autopilot_domains` TYPE = MYISAM;\r\nALTER TABLE `autopilot_email` TYPE = MYISAM;\r\nALTER TABLE `autopilot_email_events` TYPE = MYISAM;\r\nALTER TABLE `autopilot_email_groups` TYPE = MYISAM;\r\nALTER TABLE `autopilot_error_log` TYPE = MYISAM;\r\nALTER TABLE `autopilot_free_emails` TYPE = MYISAM;\r\nALTER TABLE `autopilot_history` TYPE = MYISAM;\r\nALTER TABLE `autopilot_hosting` TYPE = MYISAM;\r\nALTER TABLE `autopilot_hosting_type_specific` TYPE = MYISAM;\r\nALTER TABLE `autopilot_invoice` TYPE = MYISAM;\r\nALTER TABLE `autopilot_invoice_revisions` TYPE = MYISAM;\r\nALTER TABLE `autopilot_logger` TYPE = MYISAM;\r\nALTER TABLE `autopilot_my_notes` TYPE = MYISAM;\r\nALTER TABLE `autopilot_order` TYPE = MYISAM;\r\nALTER TABLE `autopilot_order_revisions` TYPE = MYISAM;\r\nALTER TABLE `autopilot_payment_processors` TYPE = MYISAM;\r\nALTER TABLE `autopilot_processor_attributes` TYPE = MYISAM;\r\nALTER TABLE `autopilot_processor_log` TYPE = MYISAM;\r\nALTER TABLE `autopilot_product_addons` TYPE = MYISAM;\r\nALTER TABLE `autopilot_products` TYPE = MYISAM;\r\nALTER TABLE `autopilot_profiles` TYPE = MYISAM;\r\nALTER TABLE `autopilot_public_config` TYPE = MYISAM;\r\nALTER TABLE `autopilot_register` TYPE = MYISAM;\r\nALTER TABLE `autopilot_register_revisions` TYPE = MYISAM;\r\nALTER TABLE `autopilot_registrar_attributes` TYPE = MYISAM;\r\nALTER TABLE `autopilot_registrars` TYPE = MYISAM;\r\nALTER TABLE `autopilot_reseller` TYPE = MYISAM;\r\nALTER TABLE `autopilot_servers` TYPE = MYISAM;\r\nALTER TABLE `autopilot_servers_ip` TYPE = MYISAM;\r\nALTER TABLE `autopilot_servers_panel_specific` TYPE = MYISAM;\r\nALTER TABLE `autopilot_sessions` TYPE = MYISAM;\r\nALTER TABLE `autopilot_storage` TYPE = MYISAM;\r\nALTER TABLE `autopilot_taxes` TYPE = MYISAM;\r\nALTER TABLE `autopilot_upgrade_package` TYPE = MYISAM;\r\nALTER TABLE `autopilot_whois` TYPE = MYISAM;\r\n\r\nOPTIMIZE TABLE `autopilot_accounts`, `autopilot_account_log`, `autopilot_admin`, `autopilot_admin_acl`, `autopilot_admin_profile`,\r\n`autopilot_agreements`, `autopilot_api`, `autopilot_as_emails`, `autopilot_backups`, `autopilot_batch`, `autopilot_bookmarks`,\r\n`autopilot_category`, `autopilot_clients`, `autopilot_client_news`, `autopilot_config`, `autopilot_coupons`, `autopilot_cron`,\r\n`autopilot_custom_modules`, `autopilot_domains`, `autopilot_email`, `autopilot_email_events`, `autopilot_email_groups`,\r\n`autopilot_error_log`, `autopilot_free_emails`, `autopilot_history`, `autopilot_hosting`, `autopilot_hosting_type_specific`,\r\n`autopilot_invoice`, `autopilot_invoice_revisions`, `autopilot_logger`, `autopilot_my_notes`, `autopilot_order`, `autopilot_order_revisions`,\r\n`autopilot_payment_processors`, `autopilot_processor_attributes`, `autopilot_processor_log`, `autopilot_products`, `autopilot_product_addons`,\r\n`autopilot_profiles`, `autopilot_public_config`, `autopilot_register`, `autopilot_register_revisions`, `autopilot_registrars`,\r\n`autopilot_registrar_attributes`, `autopilot_reseller`, `autopilot_servers`, `autopilot_servers_ip`, `autopilot_servers_panel_specific`,\r\n`autopilot_sessions`, `autopilot_storage`, `autopilot_taxes`, `autopilot_upgrade_package`, `autopilot_whois`;\r\n\r\nALTER TABLE `autopilot_profiles` ADD `turn_off` ENUM( 'no', 'yes' ) NOT NULL DEFAULT 'no', ADD `turn_off_message` VARCHAR( 255 ) NOT NULL DEFAULT 'Down for Maintenance. Please check back later.' AFTER `turn_off`;\r\n\r\nALTER TABLE  `autopilot_profiles` ADD  `show_all` ENUM(  'no',  'yes' ) NOT NULL;\r\n\r\nALTER TABLE `autopilot_profiles` CHANGE `email_signature` `email_signature` TEXT NOT NULL;\r\n\r\nUPDATE `autopilot_email_events` SET `event_type` = 'admin' WHERE `event_id` IN ('admin_client_area_news', 'admin_cron_backup', 'admin_new_server', 'admin_resend_password', 'cc_updated', 'server_group_update', 'server_totals_update');\r\n\r\nALTER TABLE `autopilot_product_addons` ADD `products` TEXT NOT NULL AFTER `addon_req`;\r\n\r\nALTER TABLE `autopilot_product_addons` DROP `addon_cost`;\r\n\r\n"

// Upgrade Archive. This contains two Arrays.
// One version, and One upgrade SQL archive array.
// Each release will add one value to the end of each.
// By adding the new version release and SQL [ Even if no DB updates, something needs to be in the archive array ]
// to the end of the arrays it will automatically add to the upgrade SQL select list and add the proper upgrades
// to the generated textarea SQL.

ap_version_array=["3.0.8", "3.0.9", "3.1.0", "3.1.1", "3.1.15", "3.1.20", "3.1.21", "3.1.22", "3.2.0"]

// NOTICE FOR UPGRADE SQL
// ! IMPORTANT ! MUST be on a single line
// Must add slashes ( NOT using PHP's addslashes ) for defininative \r\n for the database sql code
// Example \\r\\n will add \r\n for the SQL injection
// A single \r\n will simply line-break the textarea output.

ap_upgrade_sql_array=[
	
	// 0 Upgrade to 3.0.9
	"--\r\n-- Version 3.0.9 Upgrade SQL from Version 3.0.8\r\n--\r\n\r\nALTER TABLE `autopilot_domains` CHANGE `registrar` `registrar` VARCHAR( 255 ) DEFAULT 'none' NOT NULL;\r\nALTER TABLE `autopilot_profiles` CHANGE `currency_symbol` `currency_symbol` char(15) NOT NULL default '$';\r\nALTER TABLE `autopilot_products` ADD `email_id` BIGINT( 22 ) NOT NULL AFTER `max_purchase` , ADD `cc_email` TEXT NOT NULL AFTER `email_id`;\r\nALTER TABLE `autopilot_order` ADD `batch` ENUM( 'no', 'yes' ) NOT NULL AFTER `status`;\r\nALTER TABLE `autopilot_order_revisions` ADD `batch` ENUM( 'no', 'yes' ) NOT NULL AFTER `status`;\r\nALTER TABLE `autopilot_order` ADD `notes` TEXT NOT NULL AFTER `batch`;\r\nALTER TABLE `autopilot_payment_processors` ADD `can_batch` ENUM( 'no', 'yes' ) NOT NULL AFTER `sql_file`;\r\nALTER TABLE `autopilot_payment_processors` ADD `batch_file` VARCHAR( 255 ) NOT NULL AFTER `return_file`;\r\n\r\nUPDATE autopilot_payment_processors SET batch_file='authorize.net-1.0.0-batch.php' WHERE processor_key='36c8b5707eb7106ab3acf5c47b20db0d';\r\nUPDATE autopilot_payment_processors SET batch_file='linkpoint-1.0.0-batch.php' WHERE processor_key='c06927889fd574a4eef8a1c9e5025f7f';\r\nDROP TABLE IF EXISTS `autopilot_batch`;\r\nCREATE TABLE `autopilot_batch` (\r\n  `batch_id` bigint(22) unsigned NOT NULL auto_increment,\r\n  `client_id` bigint(22) NOT NULL default '0',\r\n  `invoice_id` bigint(22) NOT NULL default '0',\r\n  `log_id` bigint(22) NOT NULL default '0',\r\n  `status` enum('declined','error','completed') NOT NULL default 'declined',\r\n  `status_message` varchar(255) NOT NULL default '',\r\n  `amount` decimal(10,2) NOT NULL default '0.00',\r\n  `created` int(11) NOT NULL default '0',\r\n  PRIMARY KEY  (`batch_id`)\r\n) ENGINE=InnoDB;\r\n\r\n"
	
	// 1 Upgrade to 3.1.0
	, "--\r\n-- Version 3.1.0 Upgrade SQL from Version 3.0.9\r\n--\r\n\r\nALTER TABLE  `autopilot_order` ADD  `private` TEXT NOT NULL;\r\nALTER TABLE  `autopilot_coupons` ADD  `coupon_d_type` ENUM(  '1',  '2' ) NOT NULL AFTER  `coupon_type`;\r\n\r\n"
	
	// 2 Upgrade to 3.1.1
	, "--\r\n-- Version 3.1.1 Upgrade SQL from Version 3.1.0\r\n--\r\n\r\nINSERT INTO `autopilot_config` (`config_key`, `config_value`, `common_name`, `required`) VALUES ('http_charset', 'iso-8859-1', 'HTTP Charset:', 1);\r\n\r\nUPDATE `autopilot_email_events` SET `attributes` = 'client_first_name,client_last_name,site_name,site_link,site_email,cart_id,order_confirmation_total,client_phone,client_address,client_city,client_state,client_zip,client_country,client_email,email_signature,generated_on,items_ordered' WHERE `event_id` = 'client_new_order_confirmation' LIMIT 1;\r\n\r\nINSERT INTO `autopilot_email_events` ( `event_id` , `attributes` ) VALUES ('cc_updated', 'first_name,last_name,email_signature,generated_on');\r\nINSERT INTO `autopilot_email` (`email_id`, `group_id`, `event_id`, `email_name`, `email_type`, `email_priority`, `email_copy_to`, `email_subject`, `email_message`, `default_email`, `default_from`, `system_locked`, `send_expire_email`) VALUES (60, 25, 'cc_updated', 'Credit Card Updated by User', 1, 3, '', 'Credit Card Update: {first_name} {last_name}', 'Greetings,\\r\\nThe following user has just updated/added his/her credit card information.\\r\\n\\r\\nHave a great day!\\r\\n\\r\\nThanks,\\r\\n{email_signature}\\r\\n\\r\\n--------------------------------------------------------\\r\\nThis e-mail was generated on: {generated_on}', 'you@yourdomain.com', 'Your Name', 'no', 0);\r\n\r\n"

	// 3 Upgrade to 3.1.15
	, "--\r\n-- Version 3.1.15 Upgrade SQL from Version 3.1.1\r\n--\r\n\r\nINSERT INTO `autopilot_config` (`config_key`, `config_value`, `common_name`, `required`) VALUES ('enable_as', 'no',     'Enable Auto-Suspend', 0);\r\nINSERT INTO `autopilot_config` (`config_key`, `config_value`, `common_name`, `required`) VALUES ('suspend_after', '1',  'Suspend After', 0);\r\nINSERT INTO `autopilot_config` (`config_key`, `config_value`, `common_name`, `required`) VALUES ('enable_aus', 'no',    'Enable Auto-UnSuspend', 0);\r\nINSERT INTO `autopilot_config` (`config_key`, `config_value`, `common_name`, `required`) VALUES ('aus_payment', '1', 'Payment to Auto-UnSuspend', 0);\r\n\r\nALTER TABLE `autopilot_accounts` ADD `as_data` VARCHAR(255) NULL;\r\n\r\nCREATE TABLE `autopilot_as_emails` (\r\n  `id` int(5) NOT NULL auto_increment,\r\n  `inv_note` int(2) NOT NULL default '0',\r\n  `inv_email` int(4) NOT NULL default '0',\r\n  PRIMARY KEY  (`id`)\r\n) TYPE=MyISAM;\r\n\r\n"
	
	// 4 Upgrade to 3.1.20
	, "--\r\n-- Version 3.1.20 Upgrade SQL from Version 3.1.15\r\n--\r\n\r\nINSERT INTO `autopilot_email_events` ( `event_id`, `attributes`) VALUES ( 'plesk_new_user_account', 'generated_on,email_signature,m_plesk.username,m_plesk.password');\r\nINSERT INTO `autopilot_email` (`group_id`, `event_id`, `email_name`, `email_type`, `email_priority`, `email_copy_to`, `email_subject`, `email_message`, `default_email`, `default_from`, `system_locked`, `send_expire_email`) VALUES ('1','plesk_new_user_account','New Plesk User Account','1','3','','A new Plesk Client Account has been created for you!','Hello,\\r\\n\\r\\nA new plesk user account has been created for you. You may login using the following information:\\r\\n\\r\\nUsername: {m_plesk.username}\\r\\nPassword:  {m_plesk.password}\\r\\n\\r\\nThanks,\\r\\n\\r\\n{email_signature}\\r\\n\\r\\n\\r\\n------------------------------\\r\\nGenerated on: {generated_on}','you@yourdomain.com','My Business Name','no','0');\r\n\r\nALTER TABLE `autopilot_batch` CHANGE `status` `status` ENUM( 'error', 'declined', 'completed', 'archived' ) NOT NULL DEFAULT 'error';\r\n\r\nINSERT INTO `autopilot_email` (`group_id`, `event_id`, `email_name`, `email_type`, `email_priority`, `email_copy_to`, `email_subject`, `email_message`, `default_email`, `default_from`, `system_locked`, `send_expire_email`) VALUES (25, 'batch_card_charged', 'Batch - Card Charged', 1, 3, '', 'Your Credit Card was Charged', 'Greetings {first_name},\\r\\nWe have just charged the credit card for your account ending in {card_ending_in}. The transaction was successful. We appreciate your business.\\r\\n\\r\\n{email_signature}\\r\\n--------------------------------------\\r\\nThe e-mail was generated on: {generate_date}', 'you@yourdomain.com', 'Website Order', 'no', 0);\r\nINSERT INTO `autopilot_email` (`group_id`, `event_id`, `email_name`, `email_type`, `email_priority`, `email_copy_to`, `email_subject`, `email_message`, `default_email`, `default_from`, `system_locked`, `send_expire_email`) VALUES (25, 'batch_card_declined', 'Batch - Card Declined', 1, 3, '', 'Your Credit Card Was Declined', 'Greetings {first_name},\\r\\nWe have just tried to process the credit card for your account ending in {card_ending_in}. The transaction was declined. We will try again later, please update your credit card information in the client area if needed.\\r\\n\\r\\n{email_signature}\\r\\n--------------------------------------\\r\\nThe e-mail was generated on: {generate_date}', 'you@yourdomain.com', 'Website Order', 'no', 0);\r\nINSERT INTO `autopilot_email` (`group_id`, `event_id`, `email_name`, `email_type`, `email_priority`, `email_copy_to`, `email_subject`, `email_message`, `default_email`, `default_from`, `system_locked`, `send_expire_email`) VALUES (25, 'batch_card_expired', 'Batch - Card Expired', 1, 3, '', 'Your Credit Card is Expired', 'Greetings {first_name},\\r\\nWe have just tried to process the credit card for your account ending in {card_ending_in}. The transaction was declined due to your credit card being expired. Please update your credit card information in the client area and we will try the charge again.\\r\\n\\r\\n{email_signature}\\r\\n--------------------------------------\\r\\nThe e-mail was generated on: {generate_date}', 'you@yourdomain.com', 'Website Order', 'no', 0);\r\nINSERT INTO `autopilot_email_events` (`event_id`, `attributes`) VALUES ('batch_card_charged', 'first_name,card_ending_in,email_signature,generate_date');\r\nINSERT INTO `autopilot_email_events` (`event_id`, `attributes`) VALUES ('batch_card_declined', 'first_name,card_ending_in,email_signature,generate_date');\r\nINSERT INTO `autopilot_email_events` (`event_id`, `attributes`) VALUES ('batch_card_expired', 'first_name,card_ending_in,email_signature,generate_date');\r\n\r\n"
	
	// 5 Upgrade to 3.1.21
	, "--\r\n-- Version 3.1.21 Upgrade SQL from Version 3.1.20\r\n--\r\n\r\nCREATE TABLE `autopilot_error_log` (\r\n    `id` int(5) NOT NULL auto_increment,\r\n    `type` int(1) NOT NULL,\r\n    `at_time` int(16) NOT NULL,\r\n    `location` varchar(100) NOT NULL default '',\r\n    `message` text NOT NULL,\r\n    PRIMARY KEY (`id`)\r\n) TYPE=InnoDB;\r\n\r\n" 

	// 6 Upgrade to 3.1.22
	, "--\r\n-- Version 3.1.22 Upgrade SQL from Version 3.1.21\r\n--\r\n\r\nALTER TABLE  `autopilot_profiles` ADD  `http_charset` VARCHAR( 40 ) DEFAULT  'iso-8859-1' NOT NULL;\r\nALTER TABLE  `autopilot_accounts` ADD  `installed` INT( 16 ) NOT NULL;\r\n\r\nDROP TABLE IF EXISTS `autopilot_error_log`;\r\n\r\nCREATE TABLE `autopilot_error_log` (\r\n    `id` int(5) NOT NULL auto_increment,\r\n    `type` int(1) NOT NULL,\r\n    `at_time` int(16) NOT NULL,\r\n    `location` varchar(100) NOT NULL default '',\r\n    `message` text NOT NULL,\r\n    `extra` text NULL,\r\n    PRIMARY KEY (`id`)\r\n) TYPE=InnoDB;\r\n\r\nCREATE TABLE IF NOT EXISTS `autopilot_logger` (\r\n  `log_id` bigint(22) unsigned NOT NULL auto_increment,\r\n  `label` varchar(255) NOT NULL default '',\r\n  `data` text NOT NULL,\r\n  `to` varchar(255) NOT NULL default 'admin_global',\r\n  `viewed` enum('no','yes') NOT NULL default 'no',\r\n  `attachment` blob NOT NULL,\r\n  `global_queue_file` varchar(255) NOT NULL default '',\r\n  `serialize` blob NOT NULL,\r\n  `updated` int(10) NOT NULL default '0',\r\n  `created` int(10) NOT NULL default '0',\r\n  PRIMARY KEY  (`log_id`),\r\n  KEY `label` (`label`),\r\n  KEY `created` (`created`)\r\n) TYPE=InnoDB AUTO_INCREMENT=1;\r\n\r\n\r\n"

	// 7 Upgrade to 3.2.0
	, "--\r\n-- Version 3.2.0 Upgrade SQL from Version 3.1.22\r\n--\r\n\r\nALTER TABLE `autopilot_batch` CHANGE `status` `status` ENUM( 'declined', 'error', 'completed', 'expired', 'bad card' ) NOT NULL DEFAULT 'declined';\r\n\r\nCREATE TABLE `autopilot_server_group_members` (\r\n  `id` int(5) NOT NULL auto_increment,\r\n  `group_id` int(5) NOT NULL default '0',\r\n  `server_id` int(5) NOT NULL default '0',\r\n  PRIMARY KEY  (`id`)\r\n) TYPE=MyISAM;\r\n\r\nCREATE TABLE `autopilot_server_groups` (\r\n  `id` int(5) NOT NULL auto_increment,\r\n  `group_name` varchar(255) NOT NULL default '',\r\n  `group_type` enum('whm','plesk') NOT NULL default 'whm',\r\n  `max_accounts` int(4) NOT NULL default '250',\r\n  `fallback` int(4) NOT NULL default '0',\r\n  PRIMARY KEY  (`id`)\r\n) TYPE=MyISAM;\r\n\r\nALTER TABLE `autopilot_email_groups` ADD `group_type` ENUM('client', 'admin') NOT NULL AFTER `group_name`;\r\nALTER TABLE `autopilot_email_events` ADD `event_type` ENUM('client', 'admin') NOT NULL AFTER `attributes`;\r\n\r\nINSERT INTO `autopilot_email_events` VALUES ('server_group_update', 'm_server_group_details,generated_on,email_signature', 'admin');\r\nINSERT INTO `autopilot_email_events` VALUES ('server_totals_update', 'm_server_totals_details,generated_on,email_signature', 'admin');\r\n\r\nDELETE FROM `autopilot_email_events` WHERE `event_id` LIKE 'invoice_%';\r\n\r\nINSERT INTO `autopilot_email_events` VALUES ('invoice_created', 'acc_first_name,acc_last_name,m_invoice_id,m_invoice_amount,m_invoice_due,m_order_profile_client_login,m_order_profile_currency_symbol,m_order_profile_currency,generated_on,email_signature', 'client');\r\nINSERT INTO `autopilot_email_events` VALUES ('invoice_paid', 'acc_first_name,acc_last_name,m_invoice_id,m_invoice_amount,m_invoice_amount_applied,m_invoice_due,m_order_profile_client_login,m_order_profile_currency_symbol,m_order_profile_currency,generated_on,email_signature', 'client');\r\nINSERT INTO `autopilot_email_events` VALUES ('invoice_past_due', 'acc_first_name,acc_last_name,m_invoice_id,m_invoice_amount,m_invoice_due,m_order_profile_client_login,m_order_profile_currency_symbol,m_order_profile_currency,generated_on,email_signature', 'client');\r\n\r\nINSERT INTO `autopilot_email` (`group_id`, `event_id`, `email_name`, `email_type`, `email_priority`, `email_copy_to`, `email_subject`, `email_message`, `default_email`, `default_from`, `system_locked`, `send_expire_email`) VALUES (1, 'server_group_update', 'Server Group Updated', 1, 1, '', 'Server Group Update', 'There has been a server group update, details are as follows:\\r\\n\\r\\n{m_server_group_details}\\r\\n\\r\\n{email_signature}\\r\\n\\r\\n---------------------------------------------------------------------------------\\r\\nThis e-mail was generated on: {generated_on}', 'you@yourcompany.com', 'Your Company', 'no', 0);\r\nINSERT INTO `autopilot_email` (`group_id`, `event_id`, `email_name`, `email_type`, `email_priority`, `email_copy_to`, `email_subject`, `email_message`, `default_email`, `default_from`, `system_locked`, `send_expire_email`) VALUES (1, 'server_totals_update', 'Sever Account Totals Updated', 1, 3, '', 'Sever Account Totals Updated', 'Your server account totals have been updated.  The details are below:\\r\\n\\r\\n{m_server_totals_details}\\r\\n\\r\\n{email_signature}\\r\\n\\r\\n---------------------------------------------------------------------------------\\r\\nThis e-mail was generated on: {generated_on}', 'you@yourcompany.com', 'Your Company', 'no', 0);\r\n\r\nALTER TABLE `autopilot_products` CHANGE `server_id` `server_id` VARCHAR(15) NOT NULL;\r\n\r\nALTER TABLE `autopilot_account_log` TYPE = MYISAM;\r\nALTER TABLE `autopilot_accounts` TYPE = MYISAM;\r\nALTER TABLE `autopilot_admin` TYPE = MYISAM;\r\nALTER TABLE `autopilot_admin_acl` TYPE = MYISAM;\r\nALTER TABLE `autopilot_admin_profile` TYPE = MYISAM;\r\nALTER TABLE `autopilot_agreements` TYPE = MYISAM;\r\nALTER TABLE `autopilot_api` TYPE = MYISAM;\r\nALTER TABLE `autopilot_as_emails` TYPE = MYISAM;\r\nALTER TABLE `autopilot_backups` TYPE = MYISAM;\r\nALTER TABLE `autopilot_batch` TYPE = MYISAM;\r\nALTER TABLE `autopilot_bookmarks` TYPE = MYISAM;\r\nALTER TABLE `autopilot_category` TYPE = MYISAM;\r\nALTER TABLE `autopilot_client_news` TYPE = MYISAM;\r\nALTER TABLE `autopilot_clients` TYPE = MYISAM;\r\nALTER TABLE `autopilot_config` TYPE = MYISAM;\r\nALTER TABLE `autopilot_coupons` TYPE = MYISAM;\r\nALTER TABLE `autopilot_cron` TYPE = MYISAM;\r\nALTER TABLE `autopilot_custom_modules` TYPE = MYISAM;\r\nALTER TABLE `autopilot_domains` TYPE = MYISAM;\r\nALTER TABLE `autopilot_email` TYPE = MYISAM;\r\nALTER TABLE `autopilot_email_events` TYPE = MYISAM;\r\nALTER TABLE `autopilot_email_groups` TYPE = MYISAM;\r\nALTER TABLE `autopilot_error_log` TYPE = MYISAM;\r\nALTER TABLE `autopilot_free_emails` TYPE = MYISAM;\r\nALTER TABLE `autopilot_history` TYPE = MYISAM;\r\nALTER TABLE `autopilot_hosting` TYPE = MYISAM;\r\nALTER TABLE `autopilot_hosting_type_specific` TYPE = MYISAM;\r\nALTER TABLE `autopilot_invoice` TYPE = MYISAM;\r\nALTER TABLE `autopilot_invoice_revisions` TYPE = MYISAM;\r\nALTER TABLE `autopilot_logger` TYPE = MYISAM;\r\nALTER TABLE `autopilot_my_notes` TYPE = MYISAM;\r\nALTER TABLE `autopilot_order` TYPE = MYISAM;\r\nALTER TABLE `autopilot_order_revisions` TYPE = MYISAM;\r\nALTER TABLE `autopilot_payment_processors` TYPE = MYISAM;\r\nALTER TABLE `autopilot_processor_attributes` TYPE = MYISAM;\r\nALTER TABLE `autopilot_processor_log` TYPE = MYISAM;\r\nALTER TABLE `autopilot_product_addons` TYPE = MYISAM;\r\nALTER TABLE `autopilot_products` TYPE = MYISAM;\r\nALTER TABLE `autopilot_profiles` TYPE = MYISAM;\r\nALTER TABLE `autopilot_public_config` TYPE = MYISAM;\r\nALTER TABLE `autopilot_register` TYPE = MYISAM;\r\nALTER TABLE `autopilot_register_revisions` TYPE = MYISAM;\r\nALTER TABLE `autopilot_registrar_attributes` TYPE = MYISAM;\r\nALTER TABLE `autopilot_registrars` TYPE = MYISAM;\r\nALTER TABLE `autopilot_reseller` TYPE = MYISAM;\r\nALTER TABLE `autopilot_servers` TYPE = MYISAM;\r\nALTER TABLE `autopilot_servers_ip` TYPE = MYISAM;\r\nALTER TABLE `autopilot_servers_panel_specific` TYPE = MYISAM;\r\nALTER TABLE `autopilot_sessions` TYPE = MYISAM;\r\nALTER TABLE `autopilot_storage` TYPE = MYISAM;\r\nALTER TABLE `autopilot_taxes` TYPE = MYISAM;\r\nALTER TABLE `autopilot_upgrade_package` TYPE = MYISAM;\r\nALTER TABLE `autopilot_whois` TYPE = MYISAM;\r\n\r\nOPTIMIZE TABLE `autopilot_accounts`, `autopilot_account_log`, `autopilot_admin`, `autopilot_admin_acl`, `autopilot_admin_profile`,\r\n`autopilot_agreements`, `autopilot_api`, `autopilot_as_emails`, `autopilot_backups`, `autopilot_batch`, `autopilot_bookmarks`,\r\n`autopilot_category`, `autopilot_clients`, `autopilot_client_news`, `autopilot_config`, `autopilot_coupons`, `autopilot_cron`,\r\n`autopilot_custom_modules`, `autopilot_domains`, `autopilot_email`, `autopilot_email_events`, `autopilot_email_groups`,\r\n`autopilot_error_log`, `autopilot_free_emails`, `autopilot_history`, `autopilot_hosting`, `autopilot_hosting_type_specific`,\r\n`autopilot_invoice`, `autopilot_invoice_revisions`, `autopilot_logger`, `autopilot_my_notes`, `autopilot_order`, `autopilot_order_revisions`,\r\n`autopilot_payment_processors`, `autopilot_processor_attributes`, `autopilot_processor_log`, `autopilot_products`, `autopilot_product_addons`,\r\n`autopilot_profiles`, `autopilot_public_config`, `autopilot_register`, `autopilot_register_revisions`, `autopilot_registrars`,\r\n`autopilot_registrar_attributes`, `autopilot_reseller`, `autopilot_servers`, `autopilot_servers_ip`, `autopilot_servers_panel_specific`,\r\n`autopilot_sessions`, `autopilot_storage`, `autopilot_taxes`, `autopilot_upgrade_package`, `autopilot_whois`;\r\n\r\nALTER TABLE `autopilot_profiles` ADD `turn_off` ENUM( 'no', 'yes' ) NOT NULL DEFAULT 'no', ADD `turn_off_message` VARCHAR( 255 ) NOT NULL DEFAULT 'Down for Maintenance. Please check back later.' AFTER `turn_off`;\r\n\r\nALTER TABLE  `autopilot_profiles` ADD  `show_all` ENUM(  'no',  'yes' ) NOT NULL;\r\n\r\nALTER TABLE `autopilot_profiles` CHANGE `email_signature` `email_signature` TEXT NOT NULL;\r\n\r\nUPDATE `autopilot_email_events` SET `event_type` = 'admin' WHERE `event_id` IN ('admin_client_area_news', 'admin_cron_backup', 'admin_new_server', 'admin_resend_password', 'cc_updated', 'server_group_update', 'server_totals_update');\r\n\r\nALTER TABLE `autopilot_product_addons` ADD `products` TEXT NOT NULL AFTER `addon_req`;\r\n\r\nALTER TABLE `autopilot_product_addons` DROP `addon_cost`;\r\n\r\n\r\n"

	/*
	// 8 Upgrade to 3.x.x
	, "--\r\n-- Version 3.x.x Upgrade SQL from Version 3.x.x\r\n--\r\n\r\n Put SQL code here.\\r\\n\\r\\nIt Will All Automatically add to the textarea and select box.\r\n"
	*/
	
	]// Upgrade SQL Array close

//-->