47 lines
1.3 KiB
PHP
47 lines
1.3 KiB
PHP
<?php
|
|
|
|
namespace WPDesk\ShopMagic\migrations;
|
|
|
|
use ShopMagicVendor\WPDesk\Migrations\AbstractMigration;
|
|
use WPDesk\ShopMagic\Database\DatabaseTable;
|
|
|
|
final class Version_40 extends AbstractMigration {
|
|
|
|
public function up(): bool {
|
|
$charset_collate = $this->get_collation_statement_from_existing_table();
|
|
if ( $charset_collate === null ) {
|
|
$charset_collate = $this->wpdb->get_charset_collate();
|
|
}
|
|
$table_guest_name = DatabaseTable::guest();
|
|
|
|
$sql = "CREATE TABLE IF NOT EXISTS {$table_guest_name} (
|
|
id int NOT NULL AUTO_INCREMENT,
|
|
email varchar(255) NOT NULL,
|
|
tracking_key varchar(32) NOT NULL,
|
|
created datetime NOT NULL,
|
|
updated datetime NOT NULL,
|
|
PRIMARY KEY (id)
|
|
) {$charset_collate};";
|
|
|
|
return $this->wpdb->query( $sql );
|
|
}
|
|
|
|
private function get_collation_statement_from_existing_table(): ?string {
|
|
$charset = $this->wpdb->get_col_charset( $this->wpdb->users, 'user_email' );
|
|
if ( $charset instanceof \WP_Error || $charset === false ) {
|
|
return null;
|
|
}
|
|
|
|
$col_info = $this->wpdb->get_row( "SHOW FULL COLUMNS FROM {$this->wpdb->users} WHERE Field = 'user_email'",
|
|
ARRAY_A );
|
|
|
|
if ( is_array( $col_info ) && isset( $col_info['Collation'] ) ) {
|
|
$collation = $col_info['Collation'];
|
|
} else {
|
|
return null;
|
|
}
|
|
|
|
return "DEFAULT CHARACTER SET {$charset} COLLATE {$collation}";
|
|
}
|
|
}
|