phpBB.de

CREATE TABLE phpbb_store_inventory (
inventory_id bigint(8) NOT NULL auto_increment,
inventory_item bigint(8) NOT NULL default '0',
inventory_store bigint(8) default NULL,
inventory_user bigint(8) default NULL,
inventory_price bigint(8) NOT NULL default '0',
inventory_amount bigint(8) NOT NULL default '0',
restock_time varchar(255) default NULL,
restock_amount bigint(8) default NULL,
restock_last varchar(255) default NULL,
UNIQUE KEY item_id (inventory_id)
) TYPE=MyISAM;

CREATE TABLE phpbb_store_items (
item_id bigint(8) NOT NULL auto_increment,
item_name varchar(99) NOT NULL default '',
item_description varchar(255) default NULL,
item_image varchar(255) default NULL,
item_special tinyint(1) NOT NULL default '0',
UNIQUE KEY item_id (item_id)
) TYPE=MyISAM;

CREATE TABLE phpbb_store_list (
store_id bigint(8) NOT NULL auto_increment,
owner_id bigint(8) NOT NULL default '0',
store_name varchar(100) NOT NULL default '',
store_description varchar(255) default NULL,
cash_id bigint(8) NOT NULL default '0',
UNIQUE KEY store_id (store_id)
) TYPE=MyISAM;

ALTER TABLE phpbb_users ADD stores_owned BIGINT(8) DEFAULT '0' NOT NULL;