ich habe folgende MySQL anweisungen in python umzusetzen mit SQLite:
Code: Alles auswählen
CREATE TABLE `item_template` (
`entry` int(255) unsigned NOT NULL default '0',
`class` int(30) unsigned NOT NULL default '0',
`subclass` int(30) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`name2` varchar(255) NOT NULL default '',
`name3` varchar(255) NOT NULL default '',
`name4` varchar(255) NOT NULL default '',
`displayid` int(70) unsigned NOT NULL default '0',
`Quality` int(30) unsigned NOT NULL default '0',
`Flags` int(30) unsigned NOT NULL default '0',
`BuyPrice` int(30) unsigned NOT NULL default '0',
`SellPrice` int(30) unsigned NOT NULL default '0',
`InventoryType` int(30) unsigned NOT NULL default '0',
`AllowableClass` int(30) unsigned NOT NULL default '0',
`AllowableRace` int(30) unsigned NOT NULL default '0',
`ItemLevel` int(30) unsigned NOT NULL default '0',
`RequiredLevel` int(30) unsigned NOT NULL default '0',
`RequiredSkill` int(30) unsigned NOT NULL default '0',
`RequiredSkillRank` int(30) unsigned NOT NULL default '0',
`requiredspell` int(30) unsigned NOT NULL default '0',
`requiredhonorrank` int(30) unsigned NOT NULL default '0',
`RequiredCityRank` int(30) unsigned NOT NULL default '0',
`RequiredReputationFaction` int(30) unsigned NOT NULL default '0',
`RequiredRaputationRank` int(30) unsigned NOT NULL default '0',
`maxcount` int(30) unsigned NOT NULL default '0',
`stackable` int(30) unsigned NOT NULL default '0',
`ContainerSlots` int(30) unsigned NOT NULL default '0',
`stat_type1` int(30) unsigned NOT NULL default '0',
`stat_value1` int(30) unsigned NOT NULL default '0',
`stat_type2` int(30) unsigned NOT NULL default '0',
`stat_value2` int(30) unsigned NOT NULL default '0',
`stat_type3` int(30) unsigned NOT NULL default '0',
`stat_value3` int(30) unsigned NOT NULL default '0',
`stat_type4` int(30) unsigned NOT NULL default '0',
`stat_value4` int(30) unsigned NOT NULL default '0',
`stat_type5` int(30) unsigned NOT NULL default '0',
`stat_value5` int(30) unsigned NOT NULL default '0',
`stat_type6` int(30) unsigned NOT NULL default '0',
`stat_value6` int(30) unsigned NOT NULL default '0',
`stat_type7` int(30) unsigned NOT NULL default '0',
`stat_value7` int(30) unsigned NOT NULL default '0',
`stat_type8` int(30) unsigned NOT NULL default '0',
`stat_value8` int(30) unsigned NOT NULL default '0',
`stat_type9` int(30) unsigned NOT NULL default '0',
`stat_value9` int(30) unsigned NOT NULL default '0',
`stat_type10` int(30) unsigned NOT NULL default '0',
`stat_value10` int(30) unsigned NOT NULL default '0',
`dmg_min1` int(30) unsigned NOT NULL default '0',
`dmg_max1` int(30) unsigned NOT NULL default '0',
`dmg_type1` int(30) unsigned NOT NULL default '0',
`dmg_min2` int(30) unsigned NOT NULL default '0',
`dmg_max2` int(30) unsigned NOT NULL default '0',
`dmg_type2` int(30) unsigned NOT NULL default '0',
`dmg_min3` int(30) unsigned NOT NULL default '0',
`dmg_max3` int(30) unsigned NOT NULL default '0',
`dmg_type3` int(30) unsigned NOT NULL default '0',
`dmg_min4` int(30) unsigned NOT NULL default '0',
`dmg_max4` int(30) unsigned NOT NULL default '0',
`dmg_type4` int(30) unsigned NOT NULL default '0',
`dmg_min5` int(30) unsigned NOT NULL default '0',
`dmg_max5` int(30) unsigned NOT NULL default '0',
`dmg_type5` int(30) unsigned NOT NULL default '0',
`armor` int(30) unsigned NOT NULL default '0',
`holy_res` int(30) unsigned NOT NULL default '0',
`fire_res` int(30) unsigned NOT NULL default '0',
`nature_res` int(30) unsigned NOT NULL default '0',
`frost_res` int(30) unsigned NOT NULL default '0',
`shadow_res` int(30) unsigned NOT NULL default '0',
`arcane_res` int(30) unsigned NOT NULL default '0',
`delay` int(11) unsigned NOT NULL default '1000',
`ammo_type` int(30) unsigned NOT NULL default '0',
`spellid_1` int(30) unsigned NOT NULL default '0',
`spelltrigger_1` int(30) unsigned NOT NULL default '0',
`spellcharges_1` int(30) unsigned NOT NULL default '0',
`spellcooldown_1` int(30) unsigned NOT NULL default '0',
`spellcategory_1` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_1` int(30) unsigned NOT NULL default '0',
`spellid_2` int(30) unsigned NOT NULL default '0',
`spelltrigger_2` int(30) unsigned NOT NULL default '0',
`spellcharges_2` int(30) unsigned NOT NULL default '0',
`spellcooldown_2` int(30) unsigned NOT NULL default '0',
`spellcategory_2` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_2` int(30) unsigned NOT NULL default '0',
`spellid_3` int(30) unsigned NOT NULL default '0',
`spelltrigger_3` int(30) unsigned NOT NULL default '0',
`spellcharges_3` int(30) unsigned NOT NULL default '0',
`spellcooldown_3` int(30) unsigned NOT NULL default '0',
`spellcategory_3` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_3` int(30) unsigned NOT NULL default '0',
`spellid_4` int(30) unsigned NOT NULL default '0',
`spelltrigger_4` int(30) unsigned NOT NULL default '0',
`spellcharges_4` int(30) unsigned NOT NULL default '0',
`spellcooldown_4` int(30) unsigned NOT NULL default '0',
`spellcategory_4` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_4` int(30) unsigned NOT NULL default '0',
`spellid_5` int(30) unsigned NOT NULL default '0',
`spelltrigger_5` int(30) unsigned NOT NULL default '0',
`spellcharges_5` int(30) unsigned NOT NULL default '0',
`spellcooldown_5` int(30) unsigned NOT NULL default '0',
`spellcategory_5` int(30) unsigned NOT NULL default '0',
`spellcategorycooldown_5` int(30) unsigned NOT NULL default '0',
`bonding` int(30) unsigned NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`PageText` int(30) unsigned NOT NULL default '0',
`LanguageID` int(30) unsigned NOT NULL default '0',
`PageMaterial` int(30) unsigned NOT NULL default '0',
`startquest` int(30) unsigned NOT NULL default '0',
`lockid` int(30) unsigned NOT NULL default '0',
`Material` int(30) unsigned NOT NULL default '0',
`sheath` int(30) unsigned NOT NULL default '0',
`Extra` int(30) unsigned NOT NULL default '0',
`block` int(30) unsigned NOT NULL default '0',
`itemset` int(30) unsigned NOT NULL default '0',
`MaxDurability` int(30) unsigned NOT NULL default '0',
`area` int(30) unsigned NOT NULL default '0',
`ScriptName` varchar(100) NOT NULL default '',
PRIMARY KEY (`entry`),
KEY `items_index` (`class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
mfg