<?php

// Install Query Arrays

// adds install arrays for all e.g. mysqli, mysql_pdo, etc.

// delete_tables
//		$value[0] - table name
//		$value[1] - SQL query
$delete_table[]			= ['acl',					$tbl_acl_drop];
$delete_table[]			= ['auth_token',			$tbl_auth_token_drop];
$delete_table[]			= ['cache',					$tbl_cache_drop];
$delete_table[]			= ['category',				$tbl_category_drop];
$delete_table[]			= ['category_assignment',	$tbl_category_assignment_drop];
$delete_table[]			= ['config',				$tbl_config_drop];
$delete_table[]			= ['external_link',			$tbl_external_link_drop];
$delete_table[]			= ['file',					$tbl_file_drop];
$delete_table[]			= ['file_link',				$tbl_file_link_drop];
$delete_table[]			= ['log',					$tbl_log_drop];
$delete_table[]			= ['menu',					$tbl_menu_drop];
$delete_table[]			= ['page',					$tbl_page_drop];
$delete_table[]			= ['page_link',				$tbl_page_link_drop];
$delete_table[]			= ['referrer',				$tbl_referrer_drop];
$delete_table[]			= ['revision',				$tbl_revision_drop];
$delete_table[]			= ['user',					$tbl_user_drop];
$delete_table[]			= ['user_setting',			$tbl_user_setting_drop];
$delete_table[]			= ['usergroup',				$tbl_usergroup_drop];
$delete_table[]			= ['usergroup_member',		$tbl_usergroup_member_drop];
$delete_table[]			= ['watch',					$tbl_watch_drop];
$delete_table[]			= ['word',					$tbl_word_drop];

// INSTALL
// create tables
//		$value[0] - table name
//		$value[1] - SQL query
$create_table[]			= ['acl',					$tbl_acl];
$create_table[]			= ['auth_token',			$tbl_auth_token];
$create_table[]			= ['cache',					$tbl_cache];
$create_table[]			= ['category',				$tbl_category];
$create_table[]			= ['category_assignment',	$tbl_category_assignment];
$create_table[]			= ['config',				$tbl_config];
$create_table[]			= ['external_link',			$tbl_external_link];
$create_table[]			= ['file',					$tbl_file];
$create_table[]			= ['file_link',				$tbl_file_link];
$create_table[]			= ['log',					$tbl_log];
$create_table[]			= ['menu',					$tbl_menu];
$create_table[]			= ['page',					$tbl_page];
$create_table[]			= ['page_link',				$tbl_page_link];
$create_table[]			= ['referrer',				$tbl_referrer];
$create_table[]			= ['revision',				$tbl_revision];
$create_table[]			= ['user',					$tbl_user];
$create_table[]			= ['user_setting',			$tbl_user_setting];
$create_table[]			= ['usergroup',				$tbl_usergroup];
$create_table[]			= ['usergroup_member',		$tbl_usergroup_member];
$create_table[]			= ['watch',					$tbl_watch];
$create_table[]			= ['word',					$tbl_word];

// insert_records
//		$value[0] - record type
//		$value[1] - SQL query
//		$value[2] - record
$insert_records[]		= [_t('InstallSystemAccount'),		$insert_user_system,			'system account'];
$insert_records[]		= [_t('InstallDeletedAccount'),		$insert_user_deleted,			'deleted account'];
$insert_records[]		= [_t('InstallAdmin'),				$insert_admin,					'admin user'];
$insert_records[]		= [_t('InstallAdminSetting'),		$insert_admin_setting,			'admin user settings'];
$insert_records[]		= [_t('InstallAdminGroup'),			$insert_admin_group,			'admin group'];
$insert_records[]		= [_t('InstallAdminGroupMember'),	$insert_admin_group_member,		'admin group member'];
$insert_records[]		= [_t('InstallModeratorGroup'),		$insert_moderator_group,		'moderator group'];
$insert_records[]		= [_t('InstallReviewerGroup'),		$insert_reviewer_group,			'reviewer group'];

// UPGRADE
// update tables
//		$value[0] - query type
//		$value[1] - table name
//		$value[2] - SQL query


// 6.1 ############

// acl


// bad behaviour


// cache


// category


// config
$upgrade['6.2.0'][]	= ['update',	'config',			$update_config_r6_1_1];

// file


// log

// menu


// page


#$upgrade['6.2.0'][]	= ['update',	'page',				$update_page_r6_x_0];

// page link


// referrer


// revision

// user


// user setting
$upgrade['6.2.1'][]		= ['alter',		'user_setting',		$alter_user_setting_r6_2_1];
$upgrade['6.2.1'][]		= ['alter',		'user_setting',		$alter_user_setting_r6_2_2];
$upgrade['6.2.1'][]		= ['alter',		'user_setting',		$alter_user_setting_r6_2_3];
$upgrade['6.2.1'][]		= ['alter',		'user_setting',		$alter_user_setting_r6_2_4];
$upgrade['6.2.1'][]		= ['alter',		'user_setting',		$alter_user_setting_r6_2_5];
$upgrade['6.2.1'][]		= ['alter',		'user_setting',		$alter_user_setting_r6_2_6];
$upgrade['6.2.1'][]		= ['alter',		'user_setting',		$alter_user_setting_r6_2_7];
$upgrade['6.2.1'][]		= ['alter',		'user_setting',		$alter_user_setting_r6_2_8];

// usergroup

// usergroup member


// watch


