<?php

	$upgrade_queries = array();

	/*
		These are all to do with admin users.
	*/
	$upgrade_queries['admins'][] = array(
		'desc' => 'add perhour limiting to admin users',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%admins ADD COLUMN PerHour INT DEFAULT 0'
	);

	$upgrade_queries['admins'][] = array(
		'desc' => 'add permonth limiting to admin users',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%admins ADD COLUMN PerMonth INT DEFAULT 0'
	);

	$upgrade_queries['admins'][] = array(
		'desc' => 'add emailserver option to admin users',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%admins ADD COLUMN EmailServer VARCHAR(255) DEFAULT \'\''
	);

	$upgrade_queries['admins'][] = array(
		'desc' => 'add emailserverport option to admin users',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%admins ADD COLUMN EmailServerPort INT DEFAULT 25'
	);

	$upgrade_queries['admins'][] = array(
		'desc' => 'add displaysummaries to admin users',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%admins ADD COLUMN DisplaySummaries CHAR(1) DEFAULT 1'
	);

	$upgrade_queries['admins'][] = array(
		'desc' => 'add attachments limiting to admin users',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%admins ADD COLUMN Attachments CHAR(1) DEFAULT 1'
	);

	$upgrade_queries['admins'][] = array(
		'desc' => 'switch displaysummaries on for all users',
		'query' => 'UPDATE %%TABLEPREFIX%%admins SET DisplaySummaries=1'
	);

	$upgrade_queries['admins'][] = array(
		'desc' => 'switch attachments off for all users',
		'query' => 'UPDATE %%TABLEPREFIX%%admins SET Attachments=0'
	);


	/*
		Autoresponder changes.
	*/
	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'add attachments to autoresponders',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN AttachmentIDs varchar(255)'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'add \'sendname\' to autoresponders',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN SendName varchar(255)'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'add returnpath to autoresponders',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN ReturnPath VARCHAR(50)'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'add saving of searchcriteria to autoresponders',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN SearchCriteria TEXT'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'record admin user to autoresponder',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN AdminID INT DEFAULT 0'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'add option to track links in autoresponders',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN TrackLinks CHAR(1) DEFAULT 0'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'add option to track opens in autoresponders',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN TrackOpens CHAR(1) DEFAULT 0'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'add multipart option to autoresponders',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN Multipart CHAR(1) DEFAULT 0'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'add names to autoresponders',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN Name VARCHAR(255)'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'add names to autoresponders',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%autoresponders ADD COLUMN ReplyTo VARCHAR(50)'
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'update names of autoresponders',
		'query' => 'UPDATE %%TABLEPREFIX%%autoresponders SET Name=Subject'
	);


	/*
		Banned Email changes..
	*/
	$upgrade_queries['banned_emails'][] = array(
		'desc' => 'remove unneeded global column from banned_emails',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%banned_emails DROP COLUMN Global'
	);

	$upgrade_queries['banned_emails'][] = array(
		'desc' => 'change bannedemail address to be a max of 100 chars long',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%banned_emails change Email Email VARCHAR(100)'
	);

	$upgrade_queries['banned_emails'][] = array(
		'desc' => 'create index on banned_emails email address',
		'query' => 'CREATE INDEX ss2004_banned_email_address ON %%TABLEPREFIX%%banned_emails(email (100))'
	);

	$upgrade_queries['banned_emails'][] = array(
		'desc' => 'create index on banned_emails list',
		'query' => 'CREATE INDEX ss2004_banned_listid ON %%TABLEPREFIX%%banned_emails (listid)'
	);


	/*
		Import changes.
	*/
	$upgrade_queries['imports'][] = array(
		'desc' => 'add option to overwrite records when importing',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%imports ADD COLUMN OverWrite CHAR(1) DEFAULT 0'
	);


	/*
		Composed_Emails
	*/
	$upgrade_queries['composed_emails'][] = array(
		'desc' => 'add attachments to composed emails',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%composed_emails ADD COLUMN AttachmentIDs VARCHAR(255)'
	);


	/*
		Email_opens
	*/
	$upgrade_queries['email_opens'][] = array(
		'desc' => 'add emailtype to email_opens so we can record autoresponders etc',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%email_opens ADD COLUMN EmailType VARCHAR(10)'
	);

	$upgrade_queries['email_opens'][] = array(
		'desc' => 'create index on sendid for email_opens',
		'query' => 'CREATE INDEX ss2004_SendID ON %%TABLEPREFIX%%email_opens(SendID)'
	);

	$upgrade_queries['email_opens'][] = array(
		'desc' => 'create index on memberid for email_opens',
		'query' => 'CREATE INDEX ss2004_MemberID ON %%TABLEPREFIX%%email_opens(MemberID)'
	);


	/*
		Form changes.
	*/
	$upgrade_queries['forms'][] = array(
		'desc' => 'drop unnused column (archivelink) from forms',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%forms DROP COLUMN ArchiveLink'
	);
	$upgrade_queries['forms'][] = array(
		'desc' => 'drop unnused column (emailfields) from forms',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%forms DROP COLUMN ArchiveLink'
	);
	$upgrade_queries['forms'][] = array(
		'desc' => 'add SendName to forms',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%forms ADD COLUMN SendName varchar(255)'
	);
	$upgrade_queries['forms'][] = array(
		'desc' => 'add SendEmail to forms',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%forms ADD COLUMN SendEmail varchar(255)'
	);

	/*
		Form Fields.
	*/
	$upgrade_queries['form_fields'][] = array(
		'desc' => 'drop unnused column (setvalue) from form_fields',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%form_fields DROP COLUMN setvalue'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'drop unnused column (thevalue) from form_fields',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%form_fields DROP COLUMN thevalue'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'drop unnused column (combine) from form_fields',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%form_fields DROP COLUMN combine'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'drop unnused column (combinewith) from form_fields',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%form_fields DROP COLUMN combinewith'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'drop unnused column (typeoption) from form_fields',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%form_fields DROP COLUMN typeoption'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'drop unnused column (include) from form_fields',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%form_fields DROP COLUMN Include'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'add new fieldorder column to form_fields',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%form_fields ADD COLUMN FieldOrder INT DEFAULT 0'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'add new adminid column to form_fields',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%form_fields ADD COLUMN AdminID INT'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'create an index on form_fields fieldid',
		'query' => 'CREATE INDEX ss2004_FieldID ON %%TABLEPREFIX%%form_fields(FieldID)'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'create an index on form_fields formid',
		'query' => 'CREATE INDEX ss2004_FormID ON %%TABLEPREFIX%%form_fields(FormID)'
	);

	$upgrade_queries['form_fields'][] = array(
		'desc' => 'Include all fields on all forms by default',
		'query' => 'INSERT INTO %%TABLEPREFIX%%form_fields (formid, fieldid, adminid, fieldorder) SELECT f.formid, lf.fieldid, f.adminid, 0 from %%TABLEPREFIX%%forms f, %%TABLEPREFIX%%list_fields lf'
	);


	/*
		Form Responses.
	*/
	$upgrade_queries['form_responses'][] = array(
		'desc' => 'change responsename to max 100 chars',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%form_responses CHANGE ResponseName ResponseName VARCHAR(100)'
	);
	$upgrade_queries['form_responses'][] = array(
		'desc' => 'create index on form_fields formid',
		'query' => 'CREATE INDEX ss2004_FormID ON %%TABLEPREFIX%%form_responses(FormID)'
	);
	$upgrade_queries['form_responses'][] = array(
		'desc' => 'create index on form_fields responsename',
		'query' => 'CREATE INDEX ss2004_ResponseName ON %%TABLEPREFIX%%form_responses(ResponseName (100))'
	);


	/*
		Links
	*/
	$upgrade_queries['links'][] = array(
		'desc' => 'drop linkname from links table',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%links DROP COLUMN LinkName'
	);
	$upgrade_queries['links'][] = array(
		'desc' => 'drop dateentered column from links table',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%links DROP COLUMN DateEntered'
	);
	$upgrade_queries['links'][] = array(
		'desc' => 'drop status column from links table',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%links DROP COLUMN Status'
	);
	$upgrade_queries['links'][] = array(
		'desc' => 'Save which newsletter the link is for',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%links ADD COLUMN ComposedID INT'
	);
	$upgrade_queries['links'][] = array(
		'desc' => 'Save what type of link it is',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%links ADD COLUMN LinkType VARCHAR(10)'
	);
	$upgrade_queries['links'][] = array(
		'desc' => 'create an index on the url',
		'query' => 'CREATE INDEX ss2004_URL ON %%TABLEPREFIX%%links(URL (255))'
	);
	$upgrade_queries['links'][] = array(
		'desc' => 'create an index on the linktype',
		'query' => 'CREATE INDEX ss2004_LinkType ON %%TABLEPREFIX%%links(LinkType (10))'
	);
	$upgrade_queries['links'][] = array(
		'desc' => 'create an index on the newsletter id',
		'query' => 'CREATE INDEX ss2004_ComposedID ON %%TABLEPREFIX%%links(ComposedID)'
	);


	/*
		Lists
	*/
	$upgrade_queries['lists'][] = array(
		'desc' => 'add notifyowner column to lists',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%lists ADD COLUMN NotifyOwner CHAR(1) DEFAULT 0'
	);


	/*
		Link Clicks
	*/
	$upgrade_queries['link_clicks'][] = array(
		'desc' => 'track which newsletter was opened',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%link_clicks ADD COLUMN ComposedID INT'
	);
	$upgrade_queries['link_clicks'][] = array(
		'desc' => 'add listid to link_clicks',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%link_clicks ADD COLUMN ListID INT'
	);
	$upgrade_queries['link_clicks'][] = array(
		'desc' => 'add linktype (send/autoresponder) to link_clicks',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%link_clicks ADD COLUMN LinkType VARCHAR(10)'
	);
	$upgrade_queries['link_clicks'][] = array(
		'desc' => 'change ip address from text to max 50 chars',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%link_clicks change IPAddress IPAddress VARCHAR(50)'
	);
	$upgrade_queries['link_clicks'][] = array(
		'desc' => 'create index on linkid and memberid for link_clicks table',
		'query' => 'CREATE INDEX ss2004_link_clicks_lm_idx ON %%TABLEPREFIX%%link_clicks(linkid, memberid)'
	);


	/*
		List_Field_Values table.
	*/
	$upgrade_queries['list_field_values'][] = array(
		'desc' => 'create index on list_field_values fieldid',
		'query' => 'CREATE INDEX ss2004_lfv_fieldid ON %%TABLEPREFIX%%list_field_values(fieldid)'
	);
	$upgrade_queries['list_field_values'][] = array(
		'desc' => 'create index on list_field_values userid',
		'query' => 'CREATE INDEX ss2004_lfv_UserID ON %%TABLEPREFIX%%list_field_values(UserID)'
	);
	$upgrade_queries['list_field_values'][] = array(
		'desc' => 'create index on list_field_values listid',
		'query' => 'CREATE INDEX ss2004_lfv_ListID ON %%TABLEPREFIX%%list_field_values(ListID)'
	);
	$upgrade_queries['list_field_values'][] = array(
		'desc' => 'create index on list_field_values value',
		'query' => 'CREATE INDEX ss2004_lfv_Value ON %%TABLEPREFIX%%list_field_values(Value (255))'
	);


	/*
		Member changes.
	*/
	$upgrade_queries['members'][] = array(
		'desc' => 'drop adminnotes from members table',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%members DROP COLUMN AdminNotes'
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'drop lastconfirmdate from members table',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%members DROP COLUMN LastConfirmationDate'
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'change email address in members table to max 100 chars',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%members CHANGE Email Email VARCHAR(100)'
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'change confirmcode for members to max 32 chars',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%members CHANGE ConfirmCode ConfirmCode CHAR(32) NOT NULL DEFAULT \'\''
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'create index on members email address',
		'query' => 'CREATE INDEX ss2004_members_email_address ON %%TABLEPREFIX%%members(Email)'
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'create index on members list',
		'query' => 'CREATE INDEX ss2004_members_listid ON %%TABLEPREFIX%%members (listid)'
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'create index on members status',
		'query' => 'CREATE INDEX ss2004_st ON %%TABLEPREFIX%%members(Status)'
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'create index on members confirmation status',
		'query' => 'CREATE INDEX ss2004_conf ON %%TABLEPREFIX%%members(Confirmed)'
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'create index on members confirm code',
		'query' => 'CREATE INDEX ss2004_members_confirm_code ON %%TABLEPREFIX%%members(ConfirmCode (32))'
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'create index on members last responderid',
		'query' => 'CREATE INDEX ss2004_LastResponderID ON %%TABLEPREFIX%%members(LastResponderID)'
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'create index on members subscribe date',
		'query' => 'CREATE INDEX ss2004_subscribe_date ON %%TABLEPREFIX%%members(SubscribeDate)'
	);


	/*
		Export changes.
	*/
	$upgrade_queries['export'][] = array(
		'desc' => 'create index on export users exportid',
		'query' => 'CREATE INDEX ss2004_export_users_eid ON %%TABLEPREFIX%%export_users(exportid)'
	);
	$upgrade_queries['export'][] = array(
		'desc' => 'create index on export users memberid',
		'query' => 'CREATE INDEX ss2004_export_users_mid ON %%TABLEPREFIX%%export_users(memberid)'
	);


	/*
		Send changes
	*/
	$upgrade_queries['sends'][] = array(
		'desc' => 'add newsletter archives link to sends',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%sends ADD COLUMN newsletter_archives TEXT'
	);
	$upgrade_queries['sends'][] = array(
		'desc' => 'add notifyowner to sends table',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%sends ADD COLUMN NotifyOwner CHAR(1) DEFAULT 0'
	);
	$upgrade_queries['sends'][] = array(
		'desc' => 'add searchcriteria to sends',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%sends ADD COLUMN SearchCriteria TEXT'
	);
	$upgrade_queries['sends'][] = array(
		'desc' => 'add tracklinks to sends',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%sends ADD COLUMN TrackLinks CHAR(1) DEFAULT 0'
	);
	$upgrade_queries['sends'][] = array(
		'desc' => 'add trackopens to sends',
		'query' => 'ALTER TABLE %%TABLEPREFIX%%sends ADD COLUMN TrackOpens CHAR(1) DEFAULT 0'
	);


	/*
		send_recipients changes.
	*/
	$upgrade_queries['send_recipients'][] = array(
		'desc' => 'create index on send recipients (sendid)',
		'query' => 'CREATE INDEX ss2004_sendid ON %%TABLEPREFIX%%send_recipients(SendID)'
	);
	$upgrade_queries['send_recipients'][] = array(
		'desc' => 'create index on send recipients (memberid)',
		'query' => 'CREATE INDEX ss2004_memid ON %%TABLEPREFIX%%send_recipients(MemberID)'
	);
	$upgrade_queries['send_recipients'][] = array(
		'desc' => 'create index on send recipients (problems)',
		'query' => 'CREATE INDEX ss2004_prob ON %%TABLEPREFIX%%send_recipients(Problems)'
	);


	/*
		Change formats for all members, lists, autoresponders, templates, newsletters.
	*/
	$upgrade_queries['members'][] = array(
		'desc' => 'change format of members (html)',
		'query' => 'UPDATE %%TABLEPREFIX%%members SET Format=\'2\' WHERE Format=\'1\''
	);
	$upgrade_queries['members'][] = array(
		'desc' => 'change format of members (text)',
		'query' => 'UPDATE %%TABLEPREFIX%%members SET Format=\'1\' WHERE Format=\'0\''
	);

	$upgrade_queries['lists'][] = array(
		'desc' => 'change format of lists (text+html)',
		'query' => 'UPDATE %%TABLEPREFIX%%lists SET Formats=\'4\' WHERE Formats=\'1\''
	);
	$upgrade_queries['lists'][] = array(
		'desc' => 'change format of lists (text)',
		'query' => 'UPDATE %%TABLEPREFIX%%lists SET Formats=\'1\' WHERE Formats=\'2\''
	);
	$upgrade_queries['lists'][] = array(
		'desc' => 'change format of lists (html)',
		'query' => 'UPDATE %%TABLEPREFIX%%lists SET Formats=\'2\' WHERE Formats=\'3\''
	);
	$upgrade_queries['lists'][] = array(
		'desc' => 'change format of lists (text+html num 2)',
		'query' => 'UPDATE %%TABLEPREFIX%%lists SET Formats=\'3\' WHERE Formats=\'4\''
	);

	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'change format of autoresponders (text)',
		'query' => 'UPDATE %%TABLEPREFIX%%autoresponders SET Format=\'4\' WHERE Format=\'2\''
	);
	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'change format of autoresponders (html)',
		'query' => 'UPDATE %%TABLEPREFIX%%autoresponders SET Format=\'2\' WHERE Format=\'1\''
	);
	$upgrade_queries['autoresponders'][] = array(
		'desc' => 'change format of autoresponders (text num 2)',
		'query' => 'UPDATE %%TABLEPREFIX%%autoresponders SET Format=\'1\' WHERE Format=\'4\''
	);


	$upgrade_queries['composed_emails'][] = array(
		'desc' => 'change format of composed_emails (text)',
		'query' => 'UPDATE %%TABLEPREFIX%%composed_emails SET Format=\'4\' WHERE Format=\'2\''
	);
	$upgrade_queries['composed_emails'][] = array(
		'desc' => 'change format of composed_emails (html)',
		'query' => 'UPDATE %%TABLEPREFIX%%composed_emails SET Format=\'2\' WHERE Format=\'1\''
	);
	$upgrade_queries['composed_emails'][] = array(
		'desc' => 'change format of composed_emails (text num 2)',
		'query' => 'UPDATE %%TABLEPREFIX%%composed_emails SET Format=\'1\' WHERE Format=\'4\''
	);

	$upgrade_queries['templates'][] = array(
		'desc' => 'change format of templates (text)',
		'query' => 'UPDATE %%TABLEPREFIX%%templates SET Format=\'4\' WHERE Format=\'2\''
	);
	$upgrade_queries['templates'][] = array(
		'desc' => 'change format of templates (html)',
		'query' => 'UPDATE %%TABLEPREFIX%%templates SET Format=\'2\' WHERE Format=\'1\''
	);
	$upgrade_queries['templates'][] = array(
		'desc' => 'change format of templates (text num 2)',
		'query' => 'UPDATE %%TABLEPREFIX%%templates SET Format=\'1\' WHERE Format=\'4\''
	);

	/*
		New tables to create!
	*/
	$upgrade_queries['zz_end_new_tables'][] = array(
		'desc' => 'create new attachments table',
		'query' => 'CREATE TABLE %%TABLEPREFIX%%attachments (AttachmentID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, AttachmentFilename VARCHAR(255), AttachmentName VARCHAR(255), AttachmentDescription VARCHAR(255), Status CHAR(1), DateEntered INT, AdminID INT, KEY AttachmentName(AttachmentName), KEY AdminID(AdminID))'
	);

	$upgrade_queries['zz_end_new_tables'][] = array(
		'desc' => 'create new autoresponder queue for recipients',
		'query' => 'CREATE TABLE %%TABLEPREFIX%%autoresponder_recipients(AutoresponderID INT, MemberID INT, KEY ResponderID(AutoresponderID), Key MemberID(MemberID))'
	);

	$upgrade_queries['zz_end_new_tables'][] = array(
		'desc' => 'new table to save import mappings',
		'query' => 'CREATE TABLE %%TABLEPREFIX%%import_mappings (MapID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, AdminID INT, ListID INT, ImportMap TEXT, ImportType VARCHAR(10), KEY AdminID(AdminID), KEY ImportType(ImportType), KEY ListID(ListID))'
	);

	$upgrade_queries['zz_end_new_tables'][] = array(
		'desc' => 'create new sends_per_hour table',
		'query' => 'CREATE TABLE %%TABLEPREFIX%%sends_perhour (SendID INT, ListID INT, HourStarted INT, HourEnded INT, EmailsSent INT, KEY SendID(SendID), KEY ListID(ListID))'
	);

	$upgrade_queries['zz_end_new_tables'][] = array(
		'desc' => 'create new sends_permonth table',
		'query' => 'CREATE TABLE %%TABLEPREFIX%%sends_permonth (ThisMonth INT, EmailsSent INT, AdminID INT, ListID INT, TimeStamp INT, SendID INT, SendType VARCHAR(10), KEY ThisMonth (ThisMonth), KEY AdminID(AdminID), KEY ListID(ListID), KEY SendID(SendID))'
	);

	$upgrade_queries['zz_end_new_tables'][] = array(
		'desc' => 'create new server_sends table for scheduling',
		'query' => 'CREATE TABLE %%TABLEPREFIX%%server_sends(ServerSendID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, SendID INT, InProgress CHAR(1) DEFAULT 0, AdminID INT, SendTime INT, Paused CHAR(1) DEFAULT 0, Resumed CHAR(1) DEFAULT 0, Finished CHAR(1) DEFAULT 0, Notified CHAR(1) DEFAULT 0, KEY SendTime(SendTime))'
	);

?>