<?php
////////////////////////

# TABLE EXAMPLES

////////////////////////
	////////////////////////
	# Create Table
	////////////////////////
	global $wpdb;
	$sql = "
		CREATE TABLE IF NOT EXISTS {$wpdb->base_prefix}new_table (
			id INT NOT NULL AUTO_INCREMENT,
			first_name varchar(15) DEFAULT '' NOT NULL,
			last_name varchar(15) DEFAULT '' NOT NULL,
			`col` varchar(16) DEFAULT '' NOT NULL,
			date timestamp DEFAULT CURRENT_TIMESTAMP,
			last_update timestamp DEFAULT '0000-00-00 00:00:00',
			extra longtext DEFAULT '' NOT NULL,
			PRIMARY KEY(id)
		) ENGINE=MEMORY;
	";
	$wpdb->query($sql);
		
	///////////////////////////////////////
	# Add New Table to the $wpdb Object
	///////////////////////////////////////
	add_action( 'init', 'wpdb_add_new_table' );
	function wpdb_add_new_table() {
		global $wpdb;
		$wpdb->new_table = "{$wpdb->base_prefix}new_table";
	}
	
	////////////////////////
	# Empty Table
	////////////////////////
	global $wpdb;
	$sql = " TRUNCATE TABLE $wpdb->new_table ";
	$wpdb->query($sql);
	
	////////////////////////
	# Drop Table
	////////////////////////
	global $wpdb;
	$sql = " DROP TABLE $wpdb->new_table ";
	$wpdb->query($sql);
?>