All pastes #839160 Raw Edit

Stuff

public text v1 · immutable
#839160 ·published 2007-12-30 21:41 UTC
rendered paste body
[Err] 1050 - Table 'item_cache' already exists
[Err] /*Table structure for table `item_cache` */

CREATE TABLE `item_cache` (
  `item_id` int(11) NOT NULL default '0',
  `item_name` varchar(255) NOT NULL default '',
  `item_quality` tinyint(1) NOT NULL default '0',
  `item_html` text NOT NULL,
  `item_icon` varchar(255) NOT NULL default '',
  `item_armor` int(10) NOT NULL default '0',
  `item_dmg_high` int(10) default NULL,
  `item_dmg_low` int(10) default NULL,
  `item_speed` int(10) default NULL,
  `item_strength` int(10) NOT NULL default '0',
  `item_stamina` int(10) NOT NULL default '0',
  `item_agility` int(10) NOT NULL default '0',
  `item_intellect` int(10) NOT NULL default '0',
  `item_spirit` int(10) NOT NULL default '0',
  `item_critrating` int(10) NOT NULL default '0',
  `item_hitrating` int(10) NOT NULL default '0',
  `item_defenserating` int(10) NOT NULL default '0',
  `item_block` int(10) NOT NULL default '0',
  `item_attack` int(10) NOT NULL default '0',
  `item_dodgerating` int(10) NOT NULL default '0',
  `item_parryrating` int(10) NOT NULL default '0',
  `item_resiliencerating` int(10) NOT NULL default '0',
  `item_meleecritrating` int(10) NOT NULL default '0',
  `item_meleehitrating` int(10) NOT NULL default '0',
  `item_rangecritrating` int(10) NOT NULL default '0',
  `item_rangehitrating` int(10) NOT NULL default '0',
  `item_arcane_resist` int(10) NOT NULL default '0',
  `item_fire_resist` int(10) NOT NULL default '0',
  `item_frost_resist` int(10) NOT NULL default '0',
  `item_nature_resist` int(10) NOT NULL default '0',
  `item_shadow_resist` int(10) NOT NULL default '0',
  `item_holy_resist` int(10) NOT NULL default '0',
  `item_frostdmg` int(10) NOT NULL default '0',
  `item_firedmg` int(10) NOT NULL default '0',
  `item_naturedmg` int(10) NOT NULL default '0',
  `item_shadowdmg` int(10) NOT NULL default '0',
  `item_arcanedmg` int(10) NOT NULL default '0',
  `item_holydmg` int(10) NOT NULL default '0',
  `item_healing` int(10) NOT NULL default '0',
  `item_spelldmg` int(10) NOT NULL default '0',
  `item_spellhit` int(10) NOT NULL default '0',
  `item_spellcrit` int(10) NOT NULL default '0',
  `item_haste` int(10) NOT NULL default '0'  
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Cache table';
[Msg] Finished - Unsuccessfully
--------------------------------------------------