Eric @ EricBess WebHome

global $wpdb;
$wpdb->donators = $wpdb->prefix.'donators'; //Donators Table Name
### Function: Create Donators Table
register_activation_hook(__FILE__,'install');
function install(){
	global $wpdb;
 
	if(@is_file(ABSPATH.'/wp-admin/upgrade-functions.php')) {
		include_once(ABSPATH.'/wp-admin/upgrade-functions.php');
	} elseif(@is_file(ABSPATH.'/wp-admin/includes/upgrade.php')) {
		include_once(ABSPATH.'/wp-admin/includes/upgrade.php');
	} else {
		die('We have problem finding your \'/wp-admin/upgrade-functions.php\' and \'/wp-admin/includes/upgrade.php\'');
	}
 
	// Create Donators Table
	$create_table = "CREATE TABLE $wpdb->donators (".
			"ID bigint(20) NOT NULL auto_increment,".
			"BUYER_EMAIL varchar(100) NOT NULL default '',".
			"ITEMNAME varchar(255) NOT NULL default'',".
			"ITEMNUMBER varchar(50),".
			"URL varchar(255),".
			"USER_MEMO varchar(255),".
			"PAYMENTDATE varchar(50) NOT NULL default '',".
			"TXNID varchar(30) NOT NULL default '',".
			"PAYMENT_GROSS varchar(10) NOT NULL default '',".
			"PAYMENT_FEE varchar(10) NOT NULL default '',".
			"MC_CURRENCY varchar(5) NOT NULL default '',".
			"INVOICE varchar(255) NOT NULL default '',".
			"PRIMARY KEY (ID));";
	maybe_create_table($wpdb->donators, $create_table);	  
 
	add_option("donators_db_version", "1.0");
}