Wie bkomme ich den rest weg, bitte helft mir!!!
* CREATE TABLE `phpbb_shopitems` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`shop` varchar(32) NOT NULL default '',
`sdesc` varchar(80) NOT NULL default '',
`ldesc` text NOT NULL,
`cost` int(20) unsigned default '100',
`stock` tinyint(3) unsigned default '10',
`maxstock` tinyint(3) unsigned default '100',
`sold` int(5) unsigned NOT NULL default '0',
`accessforum` int(4) default '0',
`special_link` varchar(255) NOT NULL default '',
`synth` text NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
)
+++ Successfull
* CREATE TABLE `phpbb_shops` (
`id` int(10) unsigned NOT NULL auto_increment,
`shopname` varchar(32) NOT NULL default '',
`shoptype` varchar(32) NOT NULL default '',
`type` varchar(32) NOT NULL default '',
`d_type` tinyint(3) NOT NULL default '0',
`district` tinyint(3) NOT NULL default '0',
`restocktime` int(20) unsigned default '86400',
`restockedtime` int(20) unsigned default '0',
`restockamount` int(4) unsigned default '5',
`url` varchar(255) default NULL,
`shop_owner` varchar(32) NOT NULL default '',
`template` varchar(32) NOT NULL default '',
`item_template` varchar(32) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `shopname` (`shopname`)
)
+++ Successfull
* CREATE TABLE `phpbb_transactions` (
`id` int(10) NOT NULL auto_increment,
`user_id` int(5) NOT NULL default '0',
`target_id` int(5) NOT NULL default '0',
`target_name` varchar(32) NOT NULL default '',
`type` varchar(32) NOT NULL default '',
`action` varchar(32) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
`misc` text NOT NULL,
`ip` varchar(16) NOT NULL default '',
`timestamp` int(32) default NULL,
UNIQUE KEY `id` (`id`)
)
+++ Successfull
* CREATE TABLE `phpbb_user_items` (
`id` int(20) NOT NULL auto_increment,
`user_id` int(20) NOT NULL default '0',
`item_id` int(20) NOT NULL default '0',
`item_name` varchar(32) NOT NULL default '',
`item_l_desc` text NOT NULL,
`item_s_desc` varchar(100) NOT NULL default '',
`worn` tinyint(1) NOT NULL default '0',
`die_time` int(20) NOT NULL default '0',
`special` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `item_id` (`item_id`),
KEY `user_id` (`user_id`)
)
+++ Successfull
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('multibuys', 'on')
!!! Error: Duplicate entry 'multibuys' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('restocks', 'on')
!!! Error: Duplicate entry 'restocks' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('sellrate', '55')
!!! Error: Duplicate entry 'sellrate' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewtopic', 'images')
!!! Error: Duplicate entry 'viewtopic' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewprofile', 'images')
!!! Error: Duplicate entry 'viewprofile' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewinventory', 'grouped')
!!! Error: Duplicate entry 'viewinventory' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('viewtopiclimit', '5')
!!! Error: Duplicate entry 'viewtopiclimit' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_orderby', 'name')
!!! Error: Duplicate entry 'shop_orderby' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_give', 'on')
!!! Error: Duplicate entry 'shop_give' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_trade', 'on')
!!! Error: Duplicate entry 'shop_trade' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_discard', 'on')
!!! Error: Duplicate entry 'shop_discard' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_invlimit', '0')
!!! Error: Duplicate entry 'shop_invlimit' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_owners', 'on')
!!! Error: Duplicate entry 'shop_owners' for key 1
* INSERT INTO phpbb_config (config_name, config_value) VALUES ('shop_districts', 'off')
!!! Error: Duplicate entry 'shop_districts' for key 1
* alter table phpbb_users add `user_trade` TEXT
!!! Error: Duplicate column name 'user_trade'
Completed with errors!
DANKE