phpBB.de

Code: Alles auswählen

CREATE TABLE phpbb_shop_item (
	item_id INT( 25 ) NOT NULL AUTO_INCREMENT ,
	item_name VARCHAR( 255 ) ,
	item_price INT( 25 ) ,
	item_cat INT( 25 ) ,
	item_desc VARCHAR( 255 ) ,
         item_pic VARCHAR ( 255 ) ,
	PRIMARY KEY ( item_id ) 
);

CREATE TABLE phpbb_shop_cat(
	cat_id INT( 25 ) NOT NULL AUTO_INCREMENT ,
	cat_name VARCHAR( 255 ) NOT NULL ,
	PRIMARY KEY ( cat_id ) 
);

CREATE TABLE phpbb_shop_config (
	config_name VARCHAR( 255 ) NOT NULL ,
	config_value VARCHAR( 255 ) NOT NULL 
);

CREATE TABLE phpbb_shop_buyed (
	buy_id int(255) NOT NULL auto_increment,
	buy_item int(25) NOT NULL default '0',
	buy_user int(25) NOT NULL default '0',
	PRIMARY KEY  (buy_id) 
);

INSERT INTO phpbb_shop_config ( config_name , config_value ) 
VALUES ('pn_admins', '2'), 
('pn_from', '2'), 
('waehrung', ''), 
('cash_field', ''), 
('shop_version', '1.2.0'), 
('send_pn', '1');