Bonjour,

Merci d'avance pour votre aide ;)
J'ai un petit soucis sur une requete SQL ( qui n'est pas de moi ), lorsque je l'execute, j'ai cette erreur :

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE phpbb_adr_shops_items (
  item_id int(8) NOT NULL auto_increment,
 ' at line 4

CREATE TABLE `phpbb_adr_shops_items` (
  `item_id` int(8) NOT NULL auto_increment,
  `item_owner_id` int(8) NOT NULL default '0',
  `item_price` int(8) NOT NULL default '0',
  `item_quality` int(8) NOT NULL default '0',
  `item_power` int(8) NOT NULL default '0',
  `item_duration` int(8) NOT NULL default '0',
  `item_duration_max` int(8) NOT NULL default '1',
  `item_icon` varchar(255) NOT NULL default '',
  `item_name` varchar(255) NOT NULL default '',
  `item_desc` varchar(255) NOT NULL default '',
  `item_type_use` int(8) NOT NULL default '16',
  `item_in_shop` tinyint(1) NOT NULL default '0',
  `item_store_id` int(8) NOT NULL default '1',
  `item_loottables` text NOT NULL,
  `item_weight` int(12) NOT NULL default '25',
  `item_auth` int(1) NOT NULL default '0',
  `item_max_skill` int(8) NOT NULL default '25',
  `item_add_power` int(8) NOT NULL default '0',
  `item_mp_use` int(8) NOT NULL default '0',
  `item_monster_thief` tinyint(1) NOT NULL default '0',
  `item_element` int(4) NOT NULL default '0',
  `item_element_str_dmg` int(4) NOT NULL default '100',
  `item_element_same_dmg` int(4) NOT NULL default '100',
  `item_element_weak_dmg` int(4) NOT NULL default '100',
  `item_in_warehouse` tinyint(1) NOT NULL default '0',
  `item_sell_back_percentage` int(3) NOT NULL default '50',
  `item_stolen_id` int(12) NOT NULL default '0',
  `item_steal_dc` smallint(3) NOT NULL default '0',
  `item_bought_timestamp` int(12) NOT NULL default '0',
  `item_zone` int(8) NOT NULL default '0',
  `item_zone_name` varchar(255) NOT NULL default '0',
  `item_fake_type_use` varchar(255) NOT NULL default '0',
  `item_restrict_align_enable` tinyint(1) NOT NULL default '0',
  `item_restrict_align` varchar(255) NOT NULL default '0',
  `item_restrict_class_enable` tinyint(1) NOT NULL default '0',
  `item_restrict_class` varchar(255) NOT NULL default '0',
  `item_restrict_element_enable` tinyint(1) NOT NULL default '0',
  `item_restrict_element` varchar(255) NOT NULL default '0',
  `item_restrict_race_enable` tinyint(1) NOT NULL default '0',
  `item_restrict_race` varchar(255) NOT NULL default '0',
  `item_restrict_level` int(8) NOT NULL default '0',
  `item_restrict_str` int(8) NOT NULL default '0',
  `item_restrict_dex` int(8) NOT NULL default '0',
  `item_restrict_int` int(8) NOT NULL default '0',
  `item_restrict_wis` int(8) NOT NULL default '0',
  `item_restrict_cha` int(8) NOT NULL default '0',
  `item_restrict_con` int(8) NOT NULL default '0',
  `item_crit_hit` smallint(3) NOT NULL default '20',
  `item_crit_hit_mod` smallint(3) NOT NULL default '2',
  `item_stolen_timestamp` int(12) NOT NULL default '0',
  `item_stolen_by` varchar(255) NOT NULL default '',
  `item_donated_timestamp` int(12) NOT NULL default '0',
  `item_donated_by` varchar(255) NOT NULL default '',
  `item_brewing_recipe` int(1) NOT NULL default '0',
  `item_recipe_linked_item` int(8) unsigned NOT NULL default '0',
  `item_brewing_items_req` text NOT NULL,
  `item_effect` text NOT NULL,
  `item_original_recipe_id` int(8) NOT NULL default '0',
  `item_recipe_skill_id` int(8) NOT NULL default '0',
  `item_stock` int(8) default '0',
  `item_last_stock` varchar(255) default '0',
  KEY `item_id` (`item_id`),
  KEY `item_owner_id` (`item_owner_id`)
) TYPE=MyISAM  AUTO_INCREMENT=6879 ;

Configuration: Windows XP
Firefox 3.0.11