Dauert noch etwas, aber nicht mehr allzu lange
@ThePat
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');