WC_Install::create_tables │ public static │ WC 1.0

Set up the database tables which the plugin needs to function. WARNING: If you are modifying this method, make sure that its safe to call regardless of the state of database.

This is called from install method and is executed in-sync when WC is installed or updated. This can also be called optionally from verify_base_tables.

TODO: Add all crucial tables that we have created from workers in the past.

Tables:

woocommerce_attribute_taxonomies - Table for storing attribute taxonomies - these are user defined
woocommerce_downloadable_product_permissions - Table for storing user and guest download permissions.
	KEY(order_id, product_id, download_id) used for organizing downloads on the My Account page
woocommerce_order_items - Order line items are stored in a table to make them easily queryable for reports
woocommerce_order_itemmeta - Order line item meta is stored in a table for storing extra data.
woocommerce_tax_rates - Tax Rates are stored inside 2 tables making tax queries simple and efficient.
woocommerce_tax_rate_locations - Each rate can be applied to more than one postcode/city hence the second table.

Method of the class: WC_Install{}

No Hooks.

Returns

Array. Strings containing the results of the various update queries as returned by dbDelta.

Usage

$result = WC_Install::create_tables();

WC_Install::create_tables() WC Install::create tables code ^{WC 10.3.6}

public static function create_tables() {
	global $wpdb;

	$wpdb->hide_errors();

	require_once ABSPATH . 'wp-admin/includes/upgrade.php';

	/**
	 * Before updating with DBDELTA, remove any primary keys which could be
	 * modified due to schema updates.
	 */
	if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}woocommerce_downloadable_product_permissions';" ) ) {
		if ( ! $wpdb->get_var( "SHOW COLUMNS FROM `{$wpdb->prefix}woocommerce_downloadable_product_permissions` LIKE 'permission_id';" ) ) {
			$wpdb->query( "ALTER TABLE {$wpdb->prefix}woocommerce_downloadable_product_permissions DROP PRIMARY KEY, ADD `permission_id` bigint(20) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT;" );
		}
	}

	if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}wc_order_product_lookup';" ) ) {
		if ( 2 > $wpdb->get_var( "SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = '{$wpdb->prefix}wc_order_product_lookup' AND INDEX_NAME = 'PRIMARY'" ) ) {
			$wpdb->query( "ALTER TABLE {$wpdb->prefix}wc_order_product_lookup DROP PRIMARY KEY, ADD PRIMARY KEY (order_item_id, order_id)" );
		}
	}

	/**
	 * Change wp_woocommerce_sessions schema to use a bigint auto increment field instead of char(32) field as
	 * the primary key as it is not a good practice to use a char(32) field as the primary key of a table and as
	 * there were reports of issues with this table (see https://github.com/woocommerce/woocommerce/issues/20912).
	 *
	 * This query needs to run before dbDelta() as this WP function is not able to handle primary key changes
	 * (see https://github.com/woocommerce/woocommerce/issues/21534 and https://core.trac.wordpress.org/ticket/40357).
	 */
	if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}woocommerce_sessions'" ) ) {
		if ( ! $wpdb->get_var( "SHOW KEYS FROM {$wpdb->prefix}woocommerce_sessions WHERE Key_name = 'PRIMARY' AND Column_name = 'session_id'" ) ) {
			$wpdb->query(
				"ALTER TABLE `{$wpdb->prefix}woocommerce_sessions` DROP PRIMARY KEY, DROP KEY `session_id`, ADD PRIMARY KEY(`session_id`), ADD UNIQUE KEY(`session_key`)"
			);
		}
	}

	$db_delta_result = dbDelta( self::get_schema() );

	$comment_type_index_exists = $wpdb->get_row( "SHOW INDEX FROM {$wpdb->comments} WHERE column_name = 'comment_type' and key_name = 'woo_idx_comment_type'" );

	if ( is_null( $comment_type_index_exists ) ) {
		// Add an index to the field comment_type to improve the response time of the query
		// used by WC_Comments::wp_count_comments() to get the number of comments by type.
		$wpdb->query( "ALTER TABLE {$wpdb->comments} ADD INDEX woo_idx_comment_type (comment_type)" );
	}

	$date_type_index_exists = $wpdb->get_row( "SHOW INDEX FROM {$wpdb->comments} WHERE key_name = 'woo_idx_comment_date_type'" );

	if ( is_null( $date_type_index_exists ) ) {
		// Improve performance of the admin comments query when fetching the latest 25 comments while excluding reviews and internal notes.
		$wpdb->query( "ALTER TABLE {$wpdb->comments} ADD INDEX woo_idx_comment_date_type (comment_date_gmt, comment_type, comment_approved, comment_post_ID)" );
	}

	// Clear table caches.
	delete_transient( 'wc_attribute_taxonomies' );

	return $db_delta_result;
}