@¤"-UюP>?@¤"-Uю`>?@¤"-UЂp>?p§&-UЂ яяяя?Ёp§&-Uђђяяяя?Ё`®"-U ЂA=+#-UpPAAРЛ"-UяяяяяяяяаA< t#-UаяяяярA`•#-Uр@яяяяA+p(&-UPяяяяяяяяB>p&-UPЂяяяяE+`®"-UЂА P=`®"-U° Q=РЛ"-UяяяяяяяяQ<0®#-UЂ Q Y$-Uяяяя QG`®"-UP (Q=РЛ"-Uяяяяяяяя0Q<0®#-U0 @QаX$-U@яяяя QHт#-U PQA+#-UР`RA°к&-UPpSupА"-UяяяяяяяяPPЃ$'-U PяяяяP`®"-UЂ`0U=°к&-U PUu°к&-Up`Uu+#-UpUApА"-UяяяяяяяяpUЃ$'-U°pяяяяU`®"-UЂА8Y=°к&-UpPYu+#-Uђ`YA I#-U°ЂђYт#-UђpYApА"-Uяяяяяяяя YЃ$'-Up яяяяY`«"-Uяяяя@\;А'-U`P\BА'-Up`\BА'-UPp\BРЛ"-UяяяяяяяяА\<$'-UААяяяя\p&-UА@яяяя^+°V&-UАP аH_R"'-Uђаяяяя_Р‚&-UА aa”`•#-U@яяяяa+`«"-Uяяяяр xb;РЛ"-Uяяяяяяяяb<`•#-UАяяяяb+`®"-Uа° Ђc=°к&-UАPcuРЛ"-Uяяяяяяяя c<$'-UЂ яяяяc ѕ"-U яяяяяяяяb*°V&-UА @€eR`•#-U@ яяяяe+`®"-Upр g=+#-UаPgA°V&-UАРPЁgRт#-UP`gAРЛ"-Uяяяяяяяя`g<$'-UР`яяяяg`®"-U``Аh=аQ&-UРPЂhQт#-UЂPhApА"-UяяяяяяяяђhЃ$'-UЂђяяяяh ѕ"-U`яяяяяяяяe*°V&-UАА°ИjR"'-UЂ°яяяяj ѕ"-UАяяяяяяяяa*Р‚&-UАpРбm” t#-UРяяяяаm`•#-Uа`яяяяm+°V&-UА ршnR"'-UЂряяяяn0„#-UряяяяpYPН#-Uа ps`•#-U Ђяяяяp+`®"-UР°q=°к&-UАPquИ"-Uяяяяяяяяяяяяq< ѕ"-U яяяяяяяя^*p&-UP@яяяяt+p(&-UPяяяяяяяяu> D&-U`@x`•#-U@Ђяяяяx+0„#-UРяяяяPyYPН#-UPА`ys`•#-U`яяяяy+`®"-U°ђz=`®"-UЂЂ z=+#-UpPzAРЛ"-Uяяяяяяяяpz<аШ$-Up@ЂzGт#-UЂPzAИ"-Uяяяяяяяяяяяяz< ѕ"-U@яяяяяяяяx*Рл"-UРяяяяяяяя}>`®"-U А(ѓ=+#-U°PѓA+#-U `ѓA+#-UђpѓAИ"-Uяяяяяяяяяяяяѓ<`®"-Uђ`0†=+#-UPP†A+#-U@`†A+#-U0p†AИ"-Uяяяяяяяяяяяя†<`®"-U 8‡=+#-UрP‡A+#-Uа`‡A+#-UРp‡AИ"-Uяяяяяяяяяяяя‡<Рл"-U яяяяяяяяЉ>Рл"-Uђяяяяяяяяяяяя‹>ИДAДAёїA0јВAh"°AЊёAP€ЇA°‹ёAP€ЇAP‚ЇAРяЇAЁ°A@ДA ); } return $this->is_success( $created ); } /** * Make status column as index. * * @return bool */ protected function make_status_column_index_instead_queue_name() { $queuename_column_exists = $this->column_exists( 'status' ); if ( ! $queuename_column_exists ) { return $this->is_success( false ); } if ( $this->index_exists( 'status_index' ) ) { return $this->is_success( true ); } if ( $this->index_exists( 'queue_name_index' ) ) { if ( ! $this->get_db()->query( "ALTER TABLE {$this->table_name} DROP INDEX `queue_name_index`" ) ) { return $this->is_success( false ); } } $index_added = $this->get_db()->query( "ALTER TABLE {$this->table_name} ADD INDEX `status_index` (`status`(191)) " ); return $this->is_success( $index_added ); } /** * Add error columns * * @return bool */ protected function add_error_columns() { return $this->add_error_message_column() && $this->add_error_code_column() && $this->make_error_code_column_index(); } /** * Add error_message column and index * * @return bool */ private function add_error_message_column() { $error_message_column_exists = $this->column_exists( 'error_message' ); $created = true; if ( ! $error_message_column_exists ) { $created &= $this->get_db()->query( "ALTER TABLE `{$this->table_name}` ADD COLUMN error_message longtext NULL default NULL AFTER hash" ); } return $this->is_success( $created ); } /** * Add error_code column and index * * @return bool */ private function add_error_code_column() { $error_code_column_exists = $this->column_exists( 'error_code' ); $created = true; if ( ! $error_code_column_exists ) { $created &= $this->get_db()->query( "ALTER TABLE `{$this->table_name}` ADD COLUMN error_code VARCHAR(32) NULL default NULL AFTER hash" ); } return $this->is_success( $created ); } /** * Make status column as index. * * @return bool */ private function make_error_code_column_index() { $error_code_column_exists = $this->column_exists( 'error_code' ); if ( ! $error_code_column_exists ) { return $this->is_success( false ); } if ( $this->index_exists( 'error_code_index' ) ) { return $this->is_success( true ); } $index_added = $this->get_db()->query( "ALTER TABLE {$this->table_name} ADD INDEX `error_code_index` (`error_code`) " ); return $this->is_success( $index_added ); } /** * Adds the submitted_at column * * @return bool */ protected function add_submitted_at_column() { $submitted_at_column_exists = $this->column_exists( 'submitted_at' ); $created = true; if ( ! $submitted_at_column_exists ) { $created &= $this->get_db()->query( "ALTER TABLE `{$this->table_name}` ADD COLUMN submitted_at timestamp NULL AFTER last_accessed" ); } return $this->is_success( $created ); } /** * Adds the next_retry_time column * * @return bool */ protected function add_next_retry_time_column() { $next_retry_time_exists = $this->column_exists( 'next_retry_time' ); $created = true; if ( ! $next_retry_time_exists ) { $created &= $this->get_db()->query( "ALTER TABLE `{$this->table_name}` ADD COLUMN next_retry_time timestamp NOT NULL default '0000-00-00 00:00:00' AFTER submitted_at" ); } return $this->is_success( $created ); } }