Endless Paradigm

$queries[] = "ALTER TABLE `".TABLE_PREFIX."users` ADD `items` TEXT NOT NULL ;";
	
// Alter Users Table
$queries[] = "ALTER TABLE `".TABLE_PREFIX."users` ADD `money` INT( 10 ) NOT NULL DEFAULT '150' AFTER `postnum`;";
	
// Create Shop table
$queries[] = "CREATE TABLE `".TABLE_PREFIX."shop` (
`iid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 120 ) NOT NULL ,
`price` INT( 10 ) NOT NULL ,
`description` TEXT NOT NULL ,
`download` TEXT NOT NULL ,
`shop` VARCHAR( 120 ) NOT NULL ,
PRIMARY KEY ( `iid` )
);";

// Create Shops Table
$queries[] = "CREATE TABLE `".TABLE_PREFIX."shops` (
`sid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`shop` VARCHAR( 50 ) NOT NULL ,
`shop_templatename` VARCHAR( 255 ) NOT NULL ,
`shop_desc` TEXT NOT NULL ,
PRIMARY KEY ( `sid` )
);";

// Identify The Queries
foreach($queries as $query) {
	$db->query($query);
}