@@ -38,103 +38,103 @@ |
||
| 38 | 38 | * @since 4.0 |
| 39 | 39 | */ |
| 40 | 40 | if (function_exists('espresso_version')) { |
| 41 | - if (! function_exists('espresso_duplicate_plugin_error')) { |
|
| 42 | - /** |
|
| 43 | - * espresso_duplicate_plugin_error |
|
| 44 | - * displays if more than one version of EE is activated at the same time |
|
| 45 | - */ |
|
| 46 | - function espresso_duplicate_plugin_error() |
|
| 47 | - { |
|
| 48 | - ?> |
|
| 41 | + if (! function_exists('espresso_duplicate_plugin_error')) { |
|
| 42 | + /** |
|
| 43 | + * espresso_duplicate_plugin_error |
|
| 44 | + * displays if more than one version of EE is activated at the same time |
|
| 45 | + */ |
|
| 46 | + function espresso_duplicate_plugin_error() |
|
| 47 | + { |
|
| 48 | + ?> |
|
| 49 | 49 | <div class="error"> |
| 50 | 50 | <p> |
| 51 | 51 | <?php |
| 52 | - echo esc_html__( |
|
| 53 | - 'Can not run multiple versions of Event Espresso! One version has been automatically deactivated. Please verify that you have the correct version you want still active.', |
|
| 54 | - 'event_espresso' |
|
| 55 | - ); ?> |
|
| 52 | + echo esc_html__( |
|
| 53 | + 'Can not run multiple versions of Event Espresso! One version has been automatically deactivated. Please verify that you have the correct version you want still active.', |
|
| 54 | + 'event_espresso' |
|
| 55 | + ); ?> |
|
| 56 | 56 | </p> |
| 57 | 57 | </div> |
| 58 | 58 | <?php |
| 59 | - espresso_deactivate_plugin(plugin_basename(__FILE__)); |
|
| 60 | - } |
|
| 61 | - } |
|
| 62 | - add_action('admin_notices', 'espresso_duplicate_plugin_error', 1); |
|
| 59 | + espresso_deactivate_plugin(plugin_basename(__FILE__)); |
|
| 60 | + } |
|
| 61 | + } |
|
| 62 | + add_action('admin_notices', 'espresso_duplicate_plugin_error', 1); |
|
| 63 | 63 | } else { |
| 64 | - define('EE_MIN_PHP_VER_REQUIRED', '5.4.0'); |
|
| 65 | - if (! version_compare(PHP_VERSION, EE_MIN_PHP_VER_REQUIRED, '>=')) { |
|
| 66 | - /** |
|
| 67 | - * espresso_minimum_php_version_error |
|
| 68 | - * |
|
| 69 | - * @return void |
|
| 70 | - */ |
|
| 71 | - function espresso_minimum_php_version_error() |
|
| 72 | - { |
|
| 73 | - ?> |
|
| 64 | + define('EE_MIN_PHP_VER_REQUIRED', '5.4.0'); |
|
| 65 | + if (! version_compare(PHP_VERSION, EE_MIN_PHP_VER_REQUIRED, '>=')) { |
|
| 66 | + /** |
|
| 67 | + * espresso_minimum_php_version_error |
|
| 68 | + * |
|
| 69 | + * @return void |
|
| 70 | + */ |
|
| 71 | + function espresso_minimum_php_version_error() |
|
| 72 | + { |
|
| 73 | + ?> |
|
| 74 | 74 | <div class="error"> |
| 75 | 75 | <p> |
| 76 | 76 | <?php |
| 77 | - printf( |
|
| 78 | - esc_html__( |
|
| 79 | - 'We\'re sorry, but Event Espresso requires PHP version %1$s or greater in order to operate. You are currently running version %2$s.%3$sIn order to update your version of PHP, you will need to contact your current hosting provider.%3$sFor information on stable PHP versions, please go to %4$s.', |
|
| 80 | - 'event_espresso' |
|
| 81 | - ), |
|
| 82 | - EE_MIN_PHP_VER_REQUIRED, |
|
| 83 | - PHP_VERSION, |
|
| 84 | - '<br/>', |
|
| 85 | - '<a href="http://php.net/downloads.php">http://php.net/downloads.php</a>' |
|
| 86 | - ); |
|
| 87 | - ?> |
|
| 77 | + printf( |
|
| 78 | + esc_html__( |
|
| 79 | + 'We\'re sorry, but Event Espresso requires PHP version %1$s or greater in order to operate. You are currently running version %2$s.%3$sIn order to update your version of PHP, you will need to contact your current hosting provider.%3$sFor information on stable PHP versions, please go to %4$s.', |
|
| 80 | + 'event_espresso' |
|
| 81 | + ), |
|
| 82 | + EE_MIN_PHP_VER_REQUIRED, |
|
| 83 | + PHP_VERSION, |
|
| 84 | + '<br/>', |
|
| 85 | + '<a href="http://php.net/downloads.php">http://php.net/downloads.php</a>' |
|
| 86 | + ); |
|
| 87 | + ?> |
|
| 88 | 88 | </p> |
| 89 | 89 | </div> |
| 90 | 90 | <?php |
| 91 | - espresso_deactivate_plugin(plugin_basename(__FILE__)); |
|
| 92 | - } |
|
| 91 | + espresso_deactivate_plugin(plugin_basename(__FILE__)); |
|
| 92 | + } |
|
| 93 | 93 | |
| 94 | - add_action('admin_notices', 'espresso_minimum_php_version_error', 1); |
|
| 95 | - } else { |
|
| 96 | - define('EVENT_ESPRESSO_MAIN_FILE', __FILE__); |
|
| 97 | - /** |
|
| 98 | - * espresso_version |
|
| 99 | - * Returns the plugin version |
|
| 100 | - * |
|
| 101 | - * @return string |
|
| 102 | - */ |
|
| 103 | - function espresso_version() |
|
| 104 | - { |
|
| 105 | - return apply_filters('FHEE__espresso__espresso_version', '4.10.1.rc.098'); |
|
| 106 | - } |
|
| 94 | + add_action('admin_notices', 'espresso_minimum_php_version_error', 1); |
|
| 95 | + } else { |
|
| 96 | + define('EVENT_ESPRESSO_MAIN_FILE', __FILE__); |
|
| 97 | + /** |
|
| 98 | + * espresso_version |
|
| 99 | + * Returns the plugin version |
|
| 100 | + * |
|
| 101 | + * @return string |
|
| 102 | + */ |
|
| 103 | + function espresso_version() |
|
| 104 | + { |
|
| 105 | + return apply_filters('FHEE__espresso__espresso_version', '4.10.1.rc.098'); |
|
| 106 | + } |
|
| 107 | 107 | |
| 108 | - /** |
|
| 109 | - * espresso_plugin_activation |
|
| 110 | - * adds a wp-option to indicate that EE has been activated via the WP admin plugins page |
|
| 111 | - */ |
|
| 112 | - function espresso_plugin_activation() |
|
| 113 | - { |
|
| 114 | - update_option('ee_espresso_activation', true); |
|
| 115 | - } |
|
| 108 | + /** |
|
| 109 | + * espresso_plugin_activation |
|
| 110 | + * adds a wp-option to indicate that EE has been activated via the WP admin plugins page |
|
| 111 | + */ |
|
| 112 | + function espresso_plugin_activation() |
|
| 113 | + { |
|
| 114 | + update_option('ee_espresso_activation', true); |
|
| 115 | + } |
|
| 116 | 116 | |
| 117 | - register_activation_hook(EVENT_ESPRESSO_MAIN_FILE, 'espresso_plugin_activation'); |
|
| 117 | + register_activation_hook(EVENT_ESPRESSO_MAIN_FILE, 'espresso_plugin_activation'); |
|
| 118 | 118 | |
| 119 | - require_once __DIR__ . '/core/bootstrap_espresso.php'; |
|
| 120 | - bootstrap_espresso(); |
|
| 121 | - } |
|
| 119 | + require_once __DIR__ . '/core/bootstrap_espresso.php'; |
|
| 120 | + bootstrap_espresso(); |
|
| 121 | + } |
|
| 122 | 122 | } |
| 123 | 123 | if (! function_exists('espresso_deactivate_plugin')) { |
| 124 | - /** |
|
| 125 | - * deactivate_plugin |
|
| 126 | - * usage: espresso_deactivate_plugin( plugin_basename( __FILE__ )); |
|
| 127 | - * |
|
| 128 | - * @access public |
|
| 129 | - * @param string $plugin_basename - the results of plugin_basename( __FILE__ ) for the plugin's main file |
|
| 130 | - * @return void |
|
| 131 | - */ |
|
| 132 | - function espresso_deactivate_plugin($plugin_basename = '') |
|
| 133 | - { |
|
| 134 | - if (! function_exists('deactivate_plugins')) { |
|
| 135 | - require_once ABSPATH . 'wp-admin/includes/plugin.php'; |
|
| 136 | - } |
|
| 137 | - unset($_GET['activate'], $_REQUEST['activate']); |
|
| 138 | - deactivate_plugins($plugin_basename); |
|
| 139 | - } |
|
| 124 | + /** |
|
| 125 | + * deactivate_plugin |
|
| 126 | + * usage: espresso_deactivate_plugin( plugin_basename( __FILE__ )); |
|
| 127 | + * |
|
| 128 | + * @access public |
|
| 129 | + * @param string $plugin_basename - the results of plugin_basename( __FILE__ ) for the plugin's main file |
|
| 130 | + * @return void |
|
| 131 | + */ |
|
| 132 | + function espresso_deactivate_plugin($plugin_basename = '') |
|
| 133 | + { |
|
| 134 | + if (! function_exists('deactivate_plugins')) { |
|
| 135 | + require_once ABSPATH . 'wp-admin/includes/plugin.php'; |
|
| 136 | + } |
|
| 137 | + unset($_GET['activate'], $_REQUEST['activate']); |
|
| 138 | + deactivate_plugins($plugin_basename); |
|
| 139 | + } |
|
| 140 | 140 | } |
@@ -15,9 +15,9 @@ discard block |
||
| 15 | 15 | $stages = glob(EE_CORE . 'data_migration_scripts/4_10_0_stages/*'); |
| 16 | 16 | $class_to_filepath = []; |
| 17 | 17 | foreach ($stages as $filepath) { |
| 18 | - $matches = []; |
|
| 19 | - preg_match('~4_10_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
| 20 | - $class_to_filepath[ $matches[1] ] = $filepath; |
|
| 18 | + $matches = []; |
|
| 19 | + preg_match('~4_10_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
| 20 | + $class_to_filepath[ $matches[1] ] = $filepath; |
|
| 21 | 21 | } |
| 22 | 22 | // give addons a chance to autoload their stages too |
| 23 | 23 | $class_to_filepath = apply_filters('FHEE__EE_DMS_4_10_0__autoloaded_stages', $class_to_filepath); |
@@ -35,66 +35,66 @@ discard block |
||
| 35 | 35 | */ |
| 36 | 36 | class EE_DMS_Core_4_10_0 extends EE_Data_Migration_Script_Base |
| 37 | 37 | { |
| 38 | - /** |
|
| 39 | - * |
|
| 40 | - * @param TableManager $table_manager |
|
| 41 | - * @param TableAnalysis $table_analysis |
|
| 42 | - */ |
|
| 43 | - public function __construct( |
|
| 44 | - TableManager $table_manager = null, |
|
| 45 | - TableAnalysis $table_analysis = null, |
|
| 46 | - EE_DMS_Core_4_9_0 $dms_4_9 |
|
| 47 | - ) { |
|
| 48 | - $this->previous_dms = $dms_4_9; |
|
| 49 | - $this->_pretty_name = esc_html__("Data Update to Event Espresso 4.10.0", "event_espresso"); |
|
| 50 | - $this->_priority = 10; |
|
| 51 | - $this->_migration_stages = array( |
|
| 52 | - new EE_DMS_4_10_0_Event_Question_Group(), |
|
| 53 | - ); |
|
| 54 | - parent::__construct($table_manager, $table_analysis); |
|
| 55 | - } |
|
| 38 | + /** |
|
| 39 | + * |
|
| 40 | + * @param TableManager $table_manager |
|
| 41 | + * @param TableAnalysis $table_analysis |
|
| 42 | + */ |
|
| 43 | + public function __construct( |
|
| 44 | + TableManager $table_manager = null, |
|
| 45 | + TableAnalysis $table_analysis = null, |
|
| 46 | + EE_DMS_Core_4_9_0 $dms_4_9 |
|
| 47 | + ) { |
|
| 48 | + $this->previous_dms = $dms_4_9; |
|
| 49 | + $this->_pretty_name = esc_html__("Data Update to Event Espresso 4.10.0", "event_espresso"); |
|
| 50 | + $this->_priority = 10; |
|
| 51 | + $this->_migration_stages = array( |
|
| 52 | + new EE_DMS_4_10_0_Event_Question_Group(), |
|
| 53 | + ); |
|
| 54 | + parent::__construct($table_manager, $table_analysis); |
|
| 55 | + } |
|
| 56 | 56 | |
| 57 | 57 | |
| 58 | 58 | |
| 59 | - /** |
|
| 60 | - * Whether to migrate or not. |
|
| 61 | - * |
|
| 62 | - * @param array $version_array |
|
| 63 | - * @return bool |
|
| 64 | - */ |
|
| 65 | - public function can_migrate_from_version($version_array) |
|
| 66 | - { |
|
| 67 | - $version_string = $version_array['Core']; |
|
| 68 | - if (version_compare($version_string, '4.10.0.decaf', '<') && version_compare($version_string, '4.9.0.decaf', '>=')) { |
|
| 69 | - return true; |
|
| 70 | - } elseif (! $version_string) { |
|
| 71 | - // echo "no version string provided: $version_string"; |
|
| 72 | - // no version string provided... this must be pre 4.3 |
|
| 73 | - return false;// changed mind. dont want people thinking they should migrate yet because they cant |
|
| 74 | - } |
|
| 75 | - return false; |
|
| 76 | - } |
|
| 59 | + /** |
|
| 60 | + * Whether to migrate or not. |
|
| 61 | + * |
|
| 62 | + * @param array $version_array |
|
| 63 | + * @return bool |
|
| 64 | + */ |
|
| 65 | + public function can_migrate_from_version($version_array) |
|
| 66 | + { |
|
| 67 | + $version_string = $version_array['Core']; |
|
| 68 | + if (version_compare($version_string, '4.10.0.decaf', '<') && version_compare($version_string, '4.9.0.decaf', '>=')) { |
|
| 69 | + return true; |
|
| 70 | + } elseif (! $version_string) { |
|
| 71 | + // echo "no version string provided: $version_string"; |
|
| 72 | + // no version string provided... this must be pre 4.3 |
|
| 73 | + return false;// changed mind. dont want people thinking they should migrate yet because they cant |
|
| 74 | + } |
|
| 75 | + return false; |
|
| 76 | + } |
|
| 77 | 77 | |
| 78 | 78 | |
| 79 | 79 | |
| 80 | - /** |
|
| 81 | - * @return bool |
|
| 82 | - */ |
|
| 83 | - public function schema_changes_before_migration() |
|
| 84 | - { |
|
| 85 | - require_once(EE_HELPERS . 'EEH_Activation.helper.php'); |
|
| 86 | - $now_in_mysql = current_time('mysql', true); |
|
| 87 | - $table_name = 'esp_answer'; |
|
| 88 | - $sql = " ANS_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 80 | + /** |
|
| 81 | + * @return bool |
|
| 82 | + */ |
|
| 83 | + public function schema_changes_before_migration() |
|
| 84 | + { |
|
| 85 | + require_once(EE_HELPERS . 'EEH_Activation.helper.php'); |
|
| 86 | + $now_in_mysql = current_time('mysql', true); |
|
| 87 | + $table_name = 'esp_answer'; |
|
| 88 | + $sql = " ANS_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 89 | 89 | REG_ID int(10) unsigned NOT NULL, |
| 90 | 90 | QST_ID int(10) unsigned NOT NULL, |
| 91 | 91 | ANS_value text NOT NULL, |
| 92 | 92 | PRIMARY KEY (ANS_ID), |
| 93 | 93 | KEY REG_ID (REG_ID), |
| 94 | 94 | KEY QST_ID (QST_ID)"; |
| 95 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 96 | - $table_name = 'esp_attendee_meta'; |
|
| 97 | - $sql = "ATTM_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 95 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 96 | + $table_name = 'esp_attendee_meta'; |
|
| 97 | + $sql = "ATTM_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 98 | 98 | ATT_ID bigint(20) unsigned NOT NULL, |
| 99 | 99 | ATT_fname varchar(45) NOT NULL, |
| 100 | 100 | ATT_lname varchar(45) NOT NULL, |
@@ -111,9 +111,9 @@ discard block |
||
| 111 | 111 | KEY ATT_email (ATT_email(191)), |
| 112 | 112 | KEY ATT_lname (ATT_lname), |
| 113 | 113 | KEY ATT_fname (ATT_fname)"; |
| 114 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 115 | - $table_name = 'esp_checkin'; |
|
| 116 | - $sql = "CHK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 114 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 115 | + $table_name = 'esp_checkin'; |
|
| 116 | + $sql = "CHK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 117 | 117 | REG_ID int(10) unsigned NOT NULL, |
| 118 | 118 | DTT_ID int(10) unsigned NOT NULL, |
| 119 | 119 | CHK_in tinyint(1) unsigned NOT NULL DEFAULT 1, |
@@ -121,9 +121,9 @@ discard block |
||
| 121 | 121 | PRIMARY KEY (CHK_ID), |
| 122 | 122 | KEY REG_ID (REG_ID), |
| 123 | 123 | KEY DTT_ID (DTT_ID)"; |
| 124 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 125 | - $table_name = 'esp_country'; |
|
| 126 | - $sql = "CNT_ISO varchar(2) NOT NULL, |
|
| 124 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 125 | + $table_name = 'esp_country'; |
|
| 126 | + $sql = "CNT_ISO varchar(2) NOT NULL, |
|
| 127 | 127 | CNT_ISO3 varchar(3) NOT NULL, |
| 128 | 128 | RGN_ID tinyint(3) unsigned DEFAULT NULL, |
| 129 | 129 | CNT_name varchar(45) NOT NULL, |
@@ -139,29 +139,29 @@ discard block |
||
| 139 | 139 | CNT_is_EU tinyint(1) DEFAULT '0', |
| 140 | 140 | CNT_active tinyint(1) DEFAULT '0', |
| 141 | 141 | PRIMARY KEY (CNT_ISO)"; |
| 142 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 143 | - $table_name = 'esp_currency'; |
|
| 144 | - $sql = "CUR_code varchar(6) NOT NULL, |
|
| 142 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 143 | + $table_name = 'esp_currency'; |
|
| 144 | + $sql = "CUR_code varchar(6) NOT NULL, |
|
| 145 | 145 | CUR_single varchar(45) DEFAULT 'dollar', |
| 146 | 146 | CUR_plural varchar(45) DEFAULT 'dollars', |
| 147 | 147 | CUR_sign varchar(45) DEFAULT '$', |
| 148 | 148 | CUR_dec_plc varchar(1) NOT NULL DEFAULT '2', |
| 149 | 149 | CUR_active tinyint(1) DEFAULT '0', |
| 150 | 150 | PRIMARY KEY (CUR_code)"; |
| 151 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 152 | - // note: although this table is no longer in use, |
|
| 153 | - // it hasn't been removed because then queries to the model will have errors. |
|
| 154 | - // but you should expect this table and its corresponding model to be removed in |
|
| 155 | - // the next few months |
|
| 156 | - $table_name = 'esp_currency_payment_method'; |
|
| 157 | - $sql = "CPM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 151 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 152 | + // note: although this table is no longer in use, |
|
| 153 | + // it hasn't been removed because then queries to the model will have errors. |
|
| 154 | + // but you should expect this table and its corresponding model to be removed in |
|
| 155 | + // the next few months |
|
| 156 | + $table_name = 'esp_currency_payment_method'; |
|
| 157 | + $sql = "CPM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 158 | 158 | CUR_code varchar(6) NOT NULL, |
| 159 | 159 | PMD_ID int(11) NOT NULL, |
| 160 | 160 | PRIMARY KEY (CPM_ID), |
| 161 | 161 | KEY PMD_ID (PMD_ID)"; |
| 162 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 163 | - $table_name = 'esp_datetime'; |
|
| 164 | - $sql = "DTT_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 162 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 163 | + $table_name = 'esp_datetime'; |
|
| 164 | + $sql = "DTT_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 165 | 165 | EVT_ID bigint(20) unsigned NOT NULL, |
| 166 | 166 | DTT_name varchar(255) NOT NULL DEFAULT '', |
| 167 | 167 | DTT_description text NOT NULL, |
@@ -178,25 +178,25 @@ discard block |
||
| 178 | 178 | KEY DTT_EVT_start (DTT_EVT_start), |
| 179 | 179 | KEY EVT_ID (EVT_ID), |
| 180 | 180 | KEY DTT_is_primary (DTT_is_primary)"; |
| 181 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 182 | - $table_name = "esp_datetime_ticket"; |
|
| 183 | - $sql = "DTK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 181 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 182 | + $table_name = "esp_datetime_ticket"; |
|
| 183 | + $sql = "DTK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 184 | 184 | DTT_ID int(10) unsigned NOT NULL, |
| 185 | 185 | TKT_ID int(10) unsigned NOT NULL, |
| 186 | 186 | PRIMARY KEY (DTK_ID), |
| 187 | 187 | KEY DTT_ID (DTT_ID), |
| 188 | 188 | KEY TKT_ID (TKT_ID)"; |
| 189 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 190 | - $table_name = 'esp_event_message_template'; |
|
| 191 | - $sql = "EMT_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
| 189 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 190 | + $table_name = 'esp_event_message_template'; |
|
| 191 | + $sql = "EMT_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
| 192 | 192 | EVT_ID bigint(20) unsigned NOT NULL DEFAULT 0, |
| 193 | 193 | GRP_ID int(10) unsigned NOT NULL DEFAULT 0, |
| 194 | 194 | PRIMARY KEY (EMT_ID), |
| 195 | 195 | KEY EVT_ID (EVT_ID), |
| 196 | 196 | KEY GRP_ID (GRP_ID)"; |
| 197 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 198 | - $table_name = 'esp_event_meta'; |
|
| 199 | - $sql = "EVTM_ID int(10) NOT NULL AUTO_INCREMENT, |
|
| 197 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 198 | + $table_name = 'esp_event_meta'; |
|
| 199 | + $sql = "EVTM_ID int(10) NOT NULL AUTO_INCREMENT, |
|
| 200 | 200 | EVT_ID bigint(20) unsigned NOT NULL, |
| 201 | 201 | EVT_display_desc tinyint(1) unsigned NOT NULL DEFAULT 1, |
| 202 | 202 | EVT_display_ticket_selector tinyint(1) unsigned NOT NULL DEFAULT 1, |
@@ -211,9 +211,9 @@ discard block |
||
| 211 | 211 | EVT_donations tinyint(1) NULL, |
| 212 | 212 | PRIMARY KEY (EVTM_ID), |
| 213 | 213 | KEY EVT_ID (EVT_ID)"; |
| 214 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 215 | - $table_name = 'esp_event_question_group'; |
|
| 216 | - $sql = "EQG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 214 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 215 | + $table_name = 'esp_event_question_group'; |
|
| 216 | + $sql = "EQG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 217 | 217 | EVT_ID bigint(20) unsigned NOT NULL, |
| 218 | 218 | QSG_ID int(10) unsigned NOT NULL, |
| 219 | 219 | EQG_primary tinyint(1) unsigned NOT NULL DEFAULT 0, |
@@ -221,25 +221,25 @@ discard block |
||
| 221 | 221 | PRIMARY KEY (EQG_ID), |
| 222 | 222 | KEY EVT_ID (EVT_ID), |
| 223 | 223 | KEY QSG_ID (QSG_ID)"; |
| 224 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 225 | - $table_name = 'esp_event_venue'; |
|
| 226 | - $sql = "EVV_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 224 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 225 | + $table_name = 'esp_event_venue'; |
|
| 226 | + $sql = "EVV_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 227 | 227 | EVT_ID bigint(20) unsigned NOT NULL, |
| 228 | 228 | VNU_ID bigint(20) unsigned NOT NULL, |
| 229 | 229 | EVV_primary tinyint(1) unsigned NOT NULL DEFAULT 0, |
| 230 | 230 | PRIMARY KEY (EVV_ID)"; |
| 231 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 232 | - $table_name = 'esp_extra_meta'; |
|
| 233 | - $sql = "EXM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 231 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 232 | + $table_name = 'esp_extra_meta'; |
|
| 233 | + $sql = "EXM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 234 | 234 | OBJ_ID int(11) DEFAULT NULL, |
| 235 | 235 | EXM_type varchar(45) DEFAULT NULL, |
| 236 | 236 | EXM_key varchar(45) DEFAULT NULL, |
| 237 | 237 | EXM_value text, |
| 238 | 238 | PRIMARY KEY (EXM_ID), |
| 239 | 239 | KEY EXM_type (EXM_type,OBJ_ID,EXM_key)"; |
| 240 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 241 | - $table_name = 'esp_extra_join'; |
|
| 242 | - $sql = "EXJ_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 240 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 241 | + $table_name = 'esp_extra_join'; |
|
| 242 | + $sql = "EXJ_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 243 | 243 | EXJ_first_model_id varchar(6) NOT NULL, |
| 244 | 244 | EXJ_first_model_name varchar(20) NOT NULL, |
| 245 | 245 | EXJ_second_model_id varchar(6) NOT NULL, |
@@ -247,9 +247,9 @@ discard block |
||
| 247 | 247 | PRIMARY KEY (EXJ_ID), |
| 248 | 248 | KEY first_model (EXJ_first_model_name,EXJ_first_model_id), |
| 249 | 249 | KEY second_model (EXJ_second_model_name,EXJ_second_model_id)"; |
| 250 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 251 | - $table_name = 'esp_line_item'; |
|
| 252 | - $sql = "LIN_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 250 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 251 | + $table_name = 'esp_line_item'; |
|
| 252 | + $sql = "LIN_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 253 | 253 | LIN_code varchar(245) NOT NULL DEFAULT '', |
| 254 | 254 | TXN_ID int(11) DEFAULT NULL, |
| 255 | 255 | LIN_name varchar(245) NOT NULL DEFAULT '', |
@@ -270,9 +270,9 @@ discard block |
||
| 270 | 270 | KEY txn_type_timestamp (TXN_ID,LIN_type,LIN_timestamp), |
| 271 | 271 | KEY txn_obj_id_obj_type (TXN_ID,OBJ_ID,OBJ_type), |
| 272 | 272 | KEY obj_id_obj_type (OBJ_ID,OBJ_type)"; |
| 273 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 274 | - $table_name = 'esp_log'; |
|
| 275 | - $sql = "LOG_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 273 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 274 | + $table_name = 'esp_log'; |
|
| 275 | + $sql = "LOG_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 276 | 276 | LOG_time datetime DEFAULT NULL, |
| 277 | 277 | OBJ_ID varchar(45) DEFAULT NULL, |
| 278 | 278 | OBJ_type varchar(45) DEFAULT NULL, |
@@ -283,9 +283,9 @@ discard block |
||
| 283 | 283 | KEY LOG_time (LOG_time), |
| 284 | 284 | KEY OBJ (OBJ_type,OBJ_ID), |
| 285 | 285 | KEY LOG_type (LOG_type)"; |
| 286 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 287 | - $table_name = 'esp_message'; |
|
| 288 | - $sql = "MSG_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
| 286 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 287 | + $table_name = 'esp_message'; |
|
| 288 | + $sql = "MSG_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
| 289 | 289 | GRP_ID int(10) unsigned NULL, |
| 290 | 290 | MSG_token varchar(255) NULL, |
| 291 | 291 | TXN_ID int(10) unsigned NULL, |
@@ -317,18 +317,18 @@ discard block |
||
| 317 | 317 | KEY STS_ID (STS_ID), |
| 318 | 318 | KEY MSG_created (MSG_created), |
| 319 | 319 | KEY MSG_modified (MSG_modified)"; |
| 320 | - $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 321 | - $table_name = 'esp_message_template'; |
|
| 322 | - $sql = "MTP_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 320 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 321 | + $table_name = 'esp_message_template'; |
|
| 322 | + $sql = "MTP_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 323 | 323 | GRP_ID int(10) unsigned NOT NULL, |
| 324 | 324 | MTP_context varchar(50) NOT NULL, |
| 325 | 325 | MTP_template_field varchar(30) NOT NULL, |
| 326 | 326 | MTP_content text NOT NULL, |
| 327 | 327 | PRIMARY KEY (MTP_ID), |
| 328 | 328 | KEY GRP_ID (GRP_ID)"; |
| 329 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 330 | - $table_name = 'esp_message_template_group'; |
|
| 331 | - $sql = "GRP_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 329 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 330 | + $table_name = 'esp_message_template_group'; |
|
| 331 | + $sql = "GRP_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 332 | 332 | MTP_user_id int(10) NOT NULL DEFAULT '1', |
| 333 | 333 | MTP_name varchar(245) NOT NULL DEFAULT '', |
| 334 | 334 | MTP_description varchar(245) NOT NULL DEFAULT '', |
@@ -340,9 +340,9 @@ discard block |
||
| 340 | 340 | MTP_is_active tinyint(1) NOT NULL DEFAULT '1', |
| 341 | 341 | PRIMARY KEY (GRP_ID), |
| 342 | 342 | KEY MTP_user_id (MTP_user_id)"; |
| 343 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 344 | - $table_name = 'esp_payment'; |
|
| 345 | - $sql = "PAY_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 343 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 344 | + $table_name = 'esp_payment'; |
|
| 345 | + $sql = "PAY_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 346 | 346 | TXN_ID int(10) unsigned DEFAULT NULL, |
| 347 | 347 | STS_ID varchar(3) DEFAULT NULL, |
| 348 | 348 | PAY_timestamp datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
@@ -359,9 +359,9 @@ discard block |
||
| 359 | 359 | PRIMARY KEY (PAY_ID), |
| 360 | 360 | KEY PAY_timestamp (PAY_timestamp), |
| 361 | 361 | KEY TXN_ID (TXN_ID)"; |
| 362 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 363 | - $table_name = 'esp_payment_method'; |
|
| 364 | - $sql = "PMD_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 362 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 363 | + $table_name = 'esp_payment_method'; |
|
| 364 | + $sql = "PMD_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 365 | 365 | PMD_type varchar(124) DEFAULT NULL, |
| 366 | 366 | PMD_name varchar(255) DEFAULT NULL, |
| 367 | 367 | PMD_desc text, |
@@ -377,24 +377,24 @@ discard block |
||
| 377 | 377 | PRIMARY KEY (PMD_ID), |
| 378 | 378 | UNIQUE KEY PMD_slug_UNIQUE (PMD_slug), |
| 379 | 379 | KEY PMD_type (PMD_type)"; |
| 380 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 381 | - $table_name = "esp_ticket_price"; |
|
| 382 | - $sql = "TKP_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 380 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 381 | + $table_name = "esp_ticket_price"; |
|
| 382 | + $sql = "TKP_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 383 | 383 | TKT_ID int(10) unsigned NOT NULL, |
| 384 | 384 | PRC_ID int(10) unsigned NOT NULL, |
| 385 | 385 | PRIMARY KEY (TKP_ID), |
| 386 | 386 | KEY TKT_ID (TKT_ID), |
| 387 | 387 | KEY PRC_ID (PRC_ID)"; |
| 388 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 389 | - $table_name = "esp_ticket_template"; |
|
| 390 | - $sql = "TTM_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 388 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 389 | + $table_name = "esp_ticket_template"; |
|
| 390 | + $sql = "TTM_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 391 | 391 | TTM_name varchar(45) NOT NULL, |
| 392 | 392 | TTM_description text, |
| 393 | 393 | TTM_file varchar(45), |
| 394 | 394 | PRIMARY KEY (TTM_ID)"; |
| 395 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 396 | - $table_name = 'esp_question'; |
|
| 397 | - $sql = 'QST_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 395 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 396 | + $table_name = 'esp_question'; |
|
| 397 | + $sql = 'QST_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 398 | 398 | QST_display_text text NOT NULL, |
| 399 | 399 | QST_admin_label varchar(255) NOT NULL, |
| 400 | 400 | QST_system varchar(25) DEFAULT NULL, |
@@ -408,18 +408,18 @@ discard block |
||
| 408 | 408 | QST_deleted tinyint(2) unsigned NOT NULL DEFAULT 0, |
| 409 | 409 | PRIMARY KEY (QST_ID), |
| 410 | 410 | KEY QST_order (QST_order)'; |
| 411 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 412 | - $table_name = 'esp_question_group_question'; |
|
| 413 | - $sql = "QGQ_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 411 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 412 | + $table_name = 'esp_question_group_question'; |
|
| 413 | + $sql = "QGQ_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 414 | 414 | QSG_ID int(10) unsigned NOT NULL, |
| 415 | 415 | QST_ID int(10) unsigned NOT NULL, |
| 416 | 416 | QGQ_order int(10) unsigned NOT NULL DEFAULT 0, |
| 417 | 417 | PRIMARY KEY (QGQ_ID), |
| 418 | 418 | KEY QST_ID (QST_ID), |
| 419 | 419 | KEY QSG_ID_order (QSG_ID,QGQ_order)"; |
| 420 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 421 | - $table_name = 'esp_question_option'; |
|
| 422 | - $sql = "QSO_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 420 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 421 | + $table_name = 'esp_question_option'; |
|
| 422 | + $sql = "QSO_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 423 | 423 | QSO_value varchar(255) NOT NULL, |
| 424 | 424 | QSO_desc text NOT NULL, |
| 425 | 425 | QST_ID int(10) unsigned NOT NULL, |
@@ -429,9 +429,9 @@ discard block |
||
| 429 | 429 | PRIMARY KEY (QSO_ID), |
| 430 | 430 | KEY QST_ID (QST_ID), |
| 431 | 431 | KEY QSO_order (QSO_order)"; |
| 432 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 433 | - $table_name = 'esp_registration'; |
|
| 434 | - $sql = "REG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 432 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 433 | + $table_name = 'esp_registration'; |
|
| 434 | + $sql = "REG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 435 | 435 | EVT_ID bigint(20) unsigned NOT NULL, |
| 436 | 436 | ATT_ID bigint(20) unsigned NOT NULL, |
| 437 | 437 | TXN_ID int(10) unsigned NOT NULL, |
@@ -455,18 +455,18 @@ discard block |
||
| 455 | 455 | KEY TKT_ID (TKT_ID), |
| 456 | 456 | KEY EVT_ID (EVT_ID), |
| 457 | 457 | KEY STS_ID (STS_ID)"; |
| 458 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 459 | - $table_name = 'esp_registration_payment'; |
|
| 460 | - $sql = "RPY_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 458 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 459 | + $table_name = 'esp_registration_payment'; |
|
| 460 | + $sql = "RPY_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 461 | 461 | REG_ID int(10) unsigned NOT NULL, |
| 462 | 462 | PAY_ID int(10) unsigned NULL, |
| 463 | 463 | RPY_amount decimal(12,3) NOT NULL DEFAULT '0.00', |
| 464 | 464 | PRIMARY KEY (RPY_ID), |
| 465 | 465 | KEY REG_ID (REG_ID), |
| 466 | 466 | KEY PAY_ID (PAY_ID)"; |
| 467 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 468 | - $table_name = 'esp_state'; |
|
| 469 | - $sql = "STA_ID smallint(5) unsigned NOT NULL AUTO_INCREMENT, |
|
| 467 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 468 | + $table_name = 'esp_state'; |
|
| 469 | + $sql = "STA_ID smallint(5) unsigned NOT NULL AUTO_INCREMENT, |
|
| 470 | 470 | CNT_ISO varchar(2) NOT NULL, |
| 471 | 471 | STA_abbrev varchar(24) NOT NULL, |
| 472 | 472 | STA_name varchar(100) NOT NULL, |
@@ -474,9 +474,9 @@ discard block |
||
| 474 | 474 | PRIMARY KEY (STA_ID), |
| 475 | 475 | KEY STA_abbrev (STA_abbrev), |
| 476 | 476 | KEY CNT_ISO (CNT_ISO)"; |
| 477 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 478 | - $table_name = 'esp_status'; |
|
| 479 | - $sql = "STS_ID varchar(3) NOT NULL, |
|
| 477 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 478 | + $table_name = 'esp_status'; |
|
| 479 | + $sql = "STS_ID varchar(3) NOT NULL, |
|
| 480 | 480 | STS_code varchar(45) NOT NULL, |
| 481 | 481 | STS_type varchar(45) NOT NULL, |
| 482 | 482 | STS_can_edit tinyint(1) NOT NULL DEFAULT 0, |
@@ -484,9 +484,9 @@ discard block |
||
| 484 | 484 | STS_open tinyint(1) NOT NULL DEFAULT 1, |
| 485 | 485 | UNIQUE KEY STS_ID_UNIQUE (STS_ID), |
| 486 | 486 | KEY STS_type (STS_type)"; |
| 487 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 488 | - $table_name = 'esp_transaction'; |
|
| 489 | - $sql = "TXN_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 487 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 488 | + $table_name = 'esp_transaction'; |
|
| 489 | + $sql = "TXN_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 490 | 490 | TXN_timestamp datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 491 | 491 | TXN_total decimal(12,3) DEFAULT '0.00', |
| 492 | 492 | TXN_paid decimal(12,3) NOT NULL DEFAULT '0.00', |
@@ -498,9 +498,9 @@ discard block |
||
| 498 | 498 | PRIMARY KEY (TXN_ID), |
| 499 | 499 | KEY TXN_timestamp (TXN_timestamp), |
| 500 | 500 | KEY STS_ID (STS_ID)"; |
| 501 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 502 | - $table_name = 'esp_venue_meta'; |
|
| 503 | - $sql = "VNUM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 501 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 502 | + $table_name = 'esp_venue_meta'; |
|
| 503 | + $sql = "VNUM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
| 504 | 504 | VNU_ID bigint(20) unsigned NOT NULL DEFAULT 0, |
| 505 | 505 | VNU_address varchar(255) DEFAULT NULL, |
| 506 | 506 | VNU_address2 varchar(255) DEFAULT NULL, |
@@ -519,10 +519,10 @@ discard block |
||
| 519 | 519 | KEY VNU_ID (VNU_ID), |
| 520 | 520 | KEY STA_ID (STA_ID), |
| 521 | 521 | KEY CNT_ISO (CNT_ISO)"; |
| 522 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 523 | - // modified tables |
|
| 524 | - $table_name = "esp_price"; |
|
| 525 | - $sql = "PRC_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 522 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 523 | + // modified tables |
|
| 524 | + $table_name = "esp_price"; |
|
| 525 | + $sql = "PRC_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 526 | 526 | PRT_ID tinyint(3) unsigned NOT NULL, |
| 527 | 527 | PRC_amount decimal(12,3) NOT NULL DEFAULT '0.00', |
| 528 | 528 | PRC_name varchar(245) NOT NULL, |
@@ -535,9 +535,9 @@ discard block |
||
| 535 | 535 | PRC_parent int(10) unsigned DEFAULT 0, |
| 536 | 536 | PRIMARY KEY (PRC_ID), |
| 537 | 537 | KEY PRT_ID (PRT_ID)"; |
| 538 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 539 | - $table_name = "esp_price_type"; |
|
| 540 | - $sql = "PRT_ID tinyint(3) unsigned NOT NULL AUTO_INCREMENT, |
|
| 538 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 539 | + $table_name = "esp_price_type"; |
|
| 540 | + $sql = "PRT_ID tinyint(3) unsigned NOT NULL AUTO_INCREMENT, |
|
| 541 | 541 | PRT_name varchar(45) NOT NULL, |
| 542 | 542 | PBT_ID tinyint(3) unsigned NOT NULL DEFAULT '1', |
| 543 | 543 | PRT_is_percent tinyint(1) NOT NULL DEFAULT '0', |
@@ -546,9 +546,9 @@ discard block |
||
| 546 | 546 | PRT_deleted tinyint(1) NOT NULL DEFAULT '0', |
| 547 | 547 | UNIQUE KEY PRT_name_UNIQUE (PRT_name), |
| 548 | 548 | PRIMARY KEY (PRT_ID)"; |
| 549 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 550 | - $table_name = "esp_ticket"; |
|
| 551 | - $sql = "TKT_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 549 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB '); |
|
| 550 | + $table_name = "esp_ticket"; |
|
| 551 | + $sql = "TKT_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 552 | 552 | TTM_ID int(10) unsigned NOT NULL, |
| 553 | 553 | TKT_name varchar(245) NOT NULL DEFAULT '', |
| 554 | 554 | TKT_description text NOT NULL, |
@@ -571,9 +571,9 @@ discard block |
||
| 571 | 571 | TKT_deleted tinyint(1) NOT NULL DEFAULT '0', |
| 572 | 572 | PRIMARY KEY (TKT_ID), |
| 573 | 573 | KEY TKT_start_date (TKT_start_date)"; |
| 574 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 575 | - $table_name = 'esp_question_group'; |
|
| 576 | - $sql = 'QSG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 574 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 575 | + $table_name = 'esp_question_group'; |
|
| 576 | + $sql = 'QSG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
| 577 | 577 | QSG_name varchar(255) NOT NULL, |
| 578 | 578 | QSG_identifier varchar(100) NOT NULL, |
| 579 | 579 | QSG_desc text NULL, |
@@ -586,38 +586,38 @@ discard block |
||
| 586 | 586 | PRIMARY KEY (QSG_ID), |
| 587 | 587 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier), |
| 588 | 588 | KEY QSG_order (QSG_order)'; |
| 589 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 590 | - $this->insert_default_data(); |
|
| 591 | - return true; |
|
| 592 | - } |
|
| 589 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
| 590 | + $this->insert_default_data(); |
|
| 591 | + return true; |
|
| 592 | + } |
|
| 593 | 593 | |
| 594 | - /** |
|
| 595 | - * Inserts default data on new installs |
|
| 596 | - * @since 4.10.0.p |
|
| 597 | - * @throws EE_Error |
|
| 598 | - * @throws InvalidArgumentException |
|
| 599 | - * @throws ReflectionException |
|
| 600 | - * @throws InvalidDataTypeException |
|
| 601 | - * @throws InvalidInterfaceException |
|
| 602 | - */ |
|
| 603 | - public function insert_default_data() |
|
| 604 | - { |
|
| 605 | - $this->previous_dms->insert_default_data(); |
|
| 606 | - } |
|
| 594 | + /** |
|
| 595 | + * Inserts default data on new installs |
|
| 596 | + * @since 4.10.0.p |
|
| 597 | + * @throws EE_Error |
|
| 598 | + * @throws InvalidArgumentException |
|
| 599 | + * @throws ReflectionException |
|
| 600 | + * @throws InvalidDataTypeException |
|
| 601 | + * @throws InvalidInterfaceException |
|
| 602 | + */ |
|
| 603 | + public function insert_default_data() |
|
| 604 | + { |
|
| 605 | + $this->previous_dms->insert_default_data(); |
|
| 606 | + } |
|
| 607 | 607 | |
| 608 | 608 | |
| 609 | 609 | |
| 610 | - /** |
|
| 611 | - * @return boolean |
|
| 612 | - */ |
|
| 613 | - public function schema_changes_after_migration() |
|
| 614 | - { |
|
| 615 | - return true; |
|
| 616 | - } |
|
| 610 | + /** |
|
| 611 | + * @return boolean |
|
| 612 | + */ |
|
| 613 | + public function schema_changes_after_migration() |
|
| 614 | + { |
|
| 615 | + return true; |
|
| 616 | + } |
|
| 617 | 617 | |
| 618 | 618 | |
| 619 | 619 | |
| 620 | - public function migration_page_hooks() |
|
| 621 | - { |
|
| 622 | - } |
|
| 620 | + public function migration_page_hooks() |
|
| 621 | + { |
|
| 622 | + } |
|
| 623 | 623 | } |
@@ -12,12 +12,12 @@ discard block |
||
| 12 | 12 | // unfortunately, this needs to be done upon INCLUSION of this file, |
| 13 | 13 | // instead of construction, because it only gets constructed on first page load |
| 14 | 14 | // (all other times it gets resurrected from a wordpress option) |
| 15 | -$stages = glob(EE_CORE . 'data_migration_scripts/4_10_0_stages/*'); |
|
| 15 | +$stages = glob(EE_CORE.'data_migration_scripts/4_10_0_stages/*'); |
|
| 16 | 16 | $class_to_filepath = []; |
| 17 | 17 | foreach ($stages as $filepath) { |
| 18 | 18 | $matches = []; |
| 19 | 19 | preg_match('~4_10_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
| 20 | - $class_to_filepath[ $matches[1] ] = $filepath; |
|
| 20 | + $class_to_filepath[$matches[1]] = $filepath; |
|
| 21 | 21 | } |
| 22 | 22 | // give addons a chance to autoload their stages too |
| 23 | 23 | $class_to_filepath = apply_filters('FHEE__EE_DMS_4_10_0__autoloaded_stages', $class_to_filepath); |
@@ -67,10 +67,10 @@ discard block |
||
| 67 | 67 | $version_string = $version_array['Core']; |
| 68 | 68 | if (version_compare($version_string, '4.10.0.decaf', '<') && version_compare($version_string, '4.9.0.decaf', '>=')) { |
| 69 | 69 | return true; |
| 70 | - } elseif (! $version_string) { |
|
| 70 | + } elseif ( ! $version_string) { |
|
| 71 | 71 | // echo "no version string provided: $version_string"; |
| 72 | 72 | // no version string provided... this must be pre 4.3 |
| 73 | - return false;// changed mind. dont want people thinking they should migrate yet because they cant |
|
| 73 | + return false; // changed mind. dont want people thinking they should migrate yet because they cant |
|
| 74 | 74 | } |
| 75 | 75 | return false; |
| 76 | 76 | } |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | */ |
| 83 | 83 | public function schema_changes_before_migration() |
| 84 | 84 | { |
| 85 | - require_once(EE_HELPERS . 'EEH_Activation.helper.php'); |
|
| 85 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
| 86 | 86 | $now_in_mysql = current_time('mysql', true); |
| 87 | 87 | $table_name = 'esp_answer'; |
| 88 | 88 | $sql = " ANS_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |