<?php
global $gBitSystem, $gUpgradeFrom, $gUpgradeTo;

$upgrades = [

'BONNIE' => [
	'CLYDE' => [
[ 'RENAMETABLE' => [
		'tiki_sent_newsletters' => 'tiki_newsletters_editions',
		'tiki_newsletter_subscriptions' => 'tiki_mail_subscriptions',
]],
// STEP 1
[ 'DATADICT' => [
	[ 'RENAMECOLUMN' => [
		'tiki_newsletters' => [ '`nlId`' => '`nl_id` I4 AUTO' ],
		'tiki_newsletters' => [ '`allowUserSub`' => "`allow_user_sub` C(1) default 'y'" ],
		'tiki_newsletters' => [ '`allowAnySub`' => '`allow_any_sub` C(1)' ],
		'tiki_newsletters' => [ '`unsubMsg`' => "`unsub_msg` C(1) default 'y'" ],
		'tiki_newsletters' => [ '`validateAddr`' => "`validate_addr` C(1) default 'y'" ],
		'tiki_newsletters' => [ '`lastSent`' => '`last_sent` I8' ],
		'tiki_newsletters_editions' => [ '`editionId`' => '`edition_id` I4 AUTO' ],
		'tiki_newsletter_subscriptions' => [ '`code`' => "`sub_code` C(36)" ],
		'tiki_newsletter_subscriptions' => [ '`valid`' => "`is_valid` C(1)" ],
		'tiki_newsletter_subscriptions' => [ '`subscribed`' => "`subscribed_date` I8" ],
	]],
	// ALTER
	[ 'ALTER' => [
		'tiki_newsletters' => [
			'content_id' => [ '`content_id`', 'I4' ],
		],
		'tiki_newsletters_editions' => [
			'content_id' => [ '`content_id`', 'I4' ],
			'nl_content_id' => [ '`nl_content_id`', 'I4' ],
			'is_draft' => [ '`is_draft`', 'C(1)' ],
		],
		'tiki_newsletter_subscriptions' => [
			'nl_content_id' => [ '`nl_content_id`', 'I4' ],
			'response_content_id' => [ '`response_content_id`', 'I4' ],
			'unsubscribe_all' => [ '`unsubscribe_all`', 'C(1)' ],
			'unsubscribe_date' => [ '`unsubscribe_date`', 'I8' ],
		],
	]],
	// CREATE
	[ 'CREATE' =>  [
	]],
]],

// STEP 3
[ 'QUERY' =>
	[ 'SQL92' => [
		],
], ],

// STEP 6
[ 'DATADICT' => [
	[ 'DROPCOLUMN' => [
		'tiki_newsletters' => [ '`name`', '`description`', '`created`', '`users`', '`editions`' ],
	]],
]],
	],
],

	'BWR1' => [
		'BWR2' => [
// de-tikify tables
[ 'DATADICT' => [
	[ 'RENAMETABLE' => [
		'tiki_newsletters'          => 'newsletters',
		'tiki_newsletters_editions' => 'newsletters_editions',
		'tiki_mail_subscriptions'   => 'mail_subscriptions',
		'tiki_mail_errors'          => 'mail_errors',
		'tiki_mail_mailings'        => 'mail_mailings',
		'tiki_mail_queue'           => 'mail_queue',
	]],
	[ 'CREATE' =>  [
		'mail_clickthrough' => "
			user_id I4 NOTNULL,
			content_id I4 NOTNULL,
			clicked_url C(250) NOTNULL,
			clicks I4
			CONSTRAINT ', CONSTRAINT `mail_clickthrough_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`),
						  CONSTRAINT `mail_clickthrough_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)'
		",
	]],
	[ 'ALTER' => [
		'mail_queue' => [
			'last_read_ip' => [ '`last_read_ip`', 'VARCHAR(40)' ],
		],
	]],
]],
		],
	],
];

if( isset( $upgrades[$gUpgradeFrom][$gUpgradeTo] ) ) {
	$gBitSystem->registerUpgrade( NEWSLETTERS_PKG_NAME, $upgrades[$gUpgradeFrom][$gUpgradeTo] );
}

?>