if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {
    die ("You can't access this file directly...");
}

require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));
require("modules/".$module_name."/nukebb.php");

CREATE TABLE `nuke_user_shops` (
  `id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
  `user_id` INT( 10 ) NOT NULL ,
  `username` VARCHAR( 32 ) NOT NULL ,
  `shop_name` VARCHAR( 32 ) NOT NULL ,
  `shop_type` VARCHAR( 32 ) NOT NULL ,
  `shop_opened` INT( 30 ) NOT NULL ,
  `shop_updated` INT( 30 ) NOT NULL,
  `shop_status` INT( 1 ) DEFAULT '0' NOT NULL ,
  `amount_earnt` INT( 10 ) DEFAULT '0' NOT NULL ,
  `amount_holding` INT( 10 ) DEFAULT '0' NOT NULL ,
  `items_sold` INT( 10 ) DEFAULT '0' NOT NULL ,
  `items_holding` INT( 10 ) DEFAULT '0' NOT NULL ,
  PRIMARY KEY ( `user_id` ) ,
  INDEX ( `id` )
);

CREATE TABLE nuke_user_shops_items` (
  `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
  `shop_id` INT( 10 ) NOT NULL ,
  `item_id` INT( 10 ) NOT NULL ,
  `seller_notes` VARCHAR( 255 ) NOT NULL ,
  `cost` INT( 10 ) NOT NULL ,
  `time_added` MEDIUMINT( 30 ) NOT NULL ,
  INDEX ( `shop_id` ) ,
  PRIMARY KEY ( `id` )
);

INSERT INTO `nuke_bbconfig` (config_name, config_value) VALUES ('u_shops_enabled', '0');

INSERT INTO `nuke_bbconfig` (config_name, config_value) VALUES ('u_shops_open_cost', '0');

INSERT INTO `nuke_bbconfig` (config_name, config_value) VALUES ('u_shops_tax_percent', '0');

INSERT INTO `nuke_bbconfig` (config_name, config_value) VALUES ('u_shops_max_items', '100');