CREATE DATABASE IF NOT EXISTS majestic_css;
USE Majestic_CSS;

CREATE TABLE IF NOT EXISTS `categories` (
  `category` text NOT NULL,
  `subcategory` text NOT NULL,
  `catID` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`category`(30),`subcategory`(30)),
  UNIQUE KEY `catID` (`catID`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `items` (
  `itemID` int(10) unsigned NOT NULL auto_increment,
  `catID` int(10) unsigned default NULL,
  `filePath` text,
  `lineNum` int(10) unsigned default NULL,
  `scriptID` text,
  `defname` text,
  `name` text,
  `id` text,
  `description` text,
  `added` int(1) default '0',
  `deleted` int(1) default '0',
  `dupeitem` text,
  PRIMARY KEY  (`itemID`),
  UNIQUE KEY `itemID` (`itemID`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `files` (
  `filepath` text NOT NULL,
  `crc` text,
  PRIMARY KEY  (`filepath`(255))
) TYPE=MyISAM;

SELECT crc FROM files WHERE filepath='D:\scripts\items\sphere_d_item_armor.scp';

INSERT INTO files VALUES('D:\scripts\items\sphere_d_item_armor.scp','0x213ca726');

SELECT catID FROM Categories WHERE category="armor" AND subcategory="chainmail armor";

INSERT INTO Categories (category, subcategory) VALUES("armor", "chainmail armor");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(1, "D:\scripts\items\sphere_d_item_armor.scp", 20, "013bb", "i_chainmail_coif", "", "", "chainmail coif", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="chainmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(1, "D:\scripts\items\sphere_d_item_armor.scp", 38, "013bc", "i_chainmail_leggings_decoration", "", "", "chainmail leggings hanging", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="chainmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(1, "D:\scripts\items\sphere_d_item_armor.scp", 48, "013bd", "i_chainmail_tunic_decoration", "", "", "chainmail tunic hanging", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="chainmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(1, "D:\scripts\items\sphere_d_item_armor.scp", 58, "013be", "i_chainmail_leggings", "", "", "chainmail leggings", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="chainmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(1, "D:\scripts\items\sphere_d_item_armor.scp", 76, "013bf", "i_chainmail_tunic", "", "", "chainmail tunic hanging", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 95, "013c0", "013bb");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 99, "013c1", "013bc");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 103, "013c2", "013bd");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 107, "013c3", "013bc");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 111, "013c4", "013bf");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="leather armor";

INSERT INTO Categories (category, subcategory) VALUES("armor", "leather armor");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(2, "D:\scripts\items\sphere_d_item_armor.scp", 117, "013c5", "i_leather_sleeves", "", "", "leather sleeves", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="leather armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(2, "D:\scripts\items\sphere_d_item_armor.scp", 135, "013c6", "i_leather_gloves", "", "", "leather gloves", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="leather armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(2, "D:\scripts\items\sphere_d_item_armor.scp", 153, "013c7", "i_leather_gorget", "", "", "leather gorget", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 170, "013c8", "013c5");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="leather armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(2, "D:\scripts\items\sphere_d_item_armor.scp", 174, "013c9", "i_leather_leggings_decoration", "", "", "leather leggings hanging", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="leather armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(2, "D:\scripts\items\sphere_d_item_armor.scp", 184, "013ca", "i_leather_tunic_decoration", "", "", "leather tunic hanging", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="leather armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(2, "D:\scripts\items\sphere_d_item_armor.scp", 194, "013cb", "i_leather_leggings", "", "", "leather leggings", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="leather armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(2, "D:\scripts\items\sphere_d_item_armor.scp", 212, "013cc", "i_leather_tunic", "", "", "leather tunic", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 230, "013cd", "013c5");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 234, "013ce", "013c6");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 238, "013cf", "013c5");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 242, "013d0", "013c9");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 246, "013d1", "013ca");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 250, "013d2", "013cb");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 254, "013d3", "013cc");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="studded armor";

INSERT INTO Categories (category, subcategory) VALUES("armor", "studded armor");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(3, "D:\scripts\items\sphere_d_item_armor.scp", 260, "013d4", "i_studded_sleeves", "", "", "studded sleeves", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="studded armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(3, "D:\scripts\items\sphere_d_item_armor.scp", 278, "013d5", "i_studded_gloves", "", "", "studded gloves", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="studded armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(3, "D:\scripts\items\sphere_d_item_armor.scp", 296, "013d6", "i_studded_gorget", "", "", "studded gorget", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="studded armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(3, "D:\scripts\items\sphere_d_item_armor.scp", 315, "013d7", "i_studded_sleeves_decoration", "", "", "studded sleeves hanging", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="studded armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(3, "D:\scripts\items\sphere_d_item_armor.scp", 325, "013d8", "i_studded_leggings_decoration", "", "", "studded leggings hanging", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="studded armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(3, "D:\scripts\items\sphere_d_item_armor.scp", 335, "013d9", "i_studded_tunic_decoration", "", "", "studded tunic hanging", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="studded armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(3, "D:\scripts\items\sphere_d_item_armor.scp", 345, "013da", "i_studded_leggings", "", "", "studded leggings", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="studded armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(3, "D:\scripts\items\sphere_d_item_armor.scp", 363, "013db", "i_studded_tunic", "", "", "studded tunic", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 381, "013dc", "013d4");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 385, "013dd", "013d5");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 389, "013de", "013d7");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 393, "013df", "013d8");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 397, "013e0", "013d9");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 401, "013e1", "013da");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 405, "013e2", "013db");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="ringmail armor";

INSERT INTO Categories (category, subcategory) VALUES("armor", "ringmail armor");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(4, "D:\scripts\items\sphere_d_item_armor.scp", 411, "013e5", "i_ringmail_leggings_decoration", "", "", "ringmail leggings decoration", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 428, "013e6", "013e5");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="ringmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(4, "D:\scripts\items\sphere_d_item_armor.scp", 432, "013e7", "i_ringmail_tunic_decoration", "", "", "ringmail chest decoration", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 443, "013e8", "013e7");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="ringmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(4, "D:\scripts\items\sphere_d_item_armor.scp", 447, "013e9", "i_ringmail_sleeves_decoration", "", "", "ringmail sleeves decoration", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 457, "013ea", "013e9");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="ringmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(4, "D:\scripts\items\sphere_d_item_armor.scp", 461, "013eb", "i_ringmail_gloves", "", "", "ringmail gloves", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="ringmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(4, "D:\scripts\items\sphere_d_item_armor.scp", 479, "013ec", "i_ringmail_tunic", "", "", "ringmail tunic", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 497, "013ed", "013ec");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="ringmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(4, "D:\scripts\items\sphere_d_item_armor.scp", 501, "013ee", "i_ringmail_sleeves", "", "", "ringmail sleeves", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 518, "013ef", "013ee");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="ringmail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(4, "D:\scripts\items\sphere_d_item_armor.scp", 522, "013f0", "i_ringmail_leggings", "", "", "ringmail leggings", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 539, "013f1", "013f0");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 543, "013f2", "013eb");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="helmets";

INSERT INTO Categories (category, subcategory) VALUES("armor", "helmets");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(5, "D:\scripts\items\sphere_d_item_armor.scp", 549, "01408", "i_helm_closed", "", "", "closed helm", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 569, "01409", "01408");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="helmets";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(5, "D:\scripts\items\sphere_d_item_armor.scp", 573, "0140a", "i_helm_open", "", "", "helmet", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 593, "0140b", "0140a");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="helmets";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(5, "D:\scripts\items\sphere_d_item_armor.scp", 597, "0140c", "i_bascinet", "", "", "bascinet", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 616, "0140d", "0140c");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="helmets";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(5, "D:\scripts\items\sphere_d_item_armor.scp", 620, "0140e", "i_helm_nose", "", "", "nose helm", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 639, "0140f", "0140e");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="platemail armor";

INSERT INTO Categories (category, subcategory) VALUES("armor", "platemail armor");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(6, "D:\scripts\items\sphere_d_item_armor.scp", 643, "01410", "i_platemail_arms", "", "", "platemail arms", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="platemail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(6, "D:\scripts\items\sphere_d_item_armor.scp", 662, "01411", "i_platemail_leggings", "", "", "platemail legs", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="platemail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(6, "D:\scripts\items\sphere_d_item_armor.scp", 681, "01412", "i_platemail_helm", "", "", "platemail helm", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="platemail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(6, "D:\scripts\items\sphere_d_item_armor.scp", 699, "01413", "i_platemail_gorget", "", "", "platemail gorget", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="platemail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(6, "D:\scripts\items\sphere_d_item_armor.scp", 717, "01414", "i_platemail_gloves", "", "", "platemail gauntlets", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="platemail armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(6, "D:\scripts\items\sphere_d_item_armor.scp", 736, "01415", "i_platemail_chest", "", "", "platemail breastplate", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 755, "01416", "01415");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 759, "01417", "01410");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 763, "01418", "01414");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 767, "01419", "01412");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 771, "0141a", "01411");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="masks";

INSERT INTO Categories (category, subcategory) VALUES("armor", "masks");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(7, "D:\scripts\items\sphere_d_item_armor.scp", 777, "0141b", "i_mask_orc", "", "", "orc mask", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 794, "0141c", "0141b");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="bone armor";

INSERT INTO Categories (category, subcategory) VALUES("armor", "bone armor");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(8, "D:\scripts\items\sphere_d_item_armor.scp", 800, "0144e", "i_bone_arms", "", "", "bone arms", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="bone armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(8, "D:\scripts\items\sphere_d_item_armor.scp", 817, "0144f", "i_bone_chest", "", "", "bone chest", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="bone armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(8, "D:\scripts\items\sphere_d_item_armor.scp", 834, "01450", "i_bone_gloves", "", "", "bone gloves", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="bone armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(8, "D:\scripts\items\sphere_d_item_armor.scp", 851, "01451", "i_bone_helmet", "", "", "bone helmet", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="bone armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(8, "D:\scripts\items\sphere_d_item_armor.scp", 868, "01452", "i_bone_leggings", "", "", "bone legs", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 884, "01453", "0144e");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 888, "01454", "0144f");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 892, "01455", "01450");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 896, "01456", "01451");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 900, "01457", "01452");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="shields";

INSERT INTO Categories (category, subcategory) VALUES("armor", "shields");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(9, "D:\scripts\items\sphere_d_item_armor.scp", 906, "01b72", "i_shield_round_bronze", "", "", "round bronze shield", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="shields";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(9, "D:\scripts\items\sphere_d_item_armor.scp", 923, "01b73", "i_shield_buckler", "", "", "buckler", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="shields";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(9, "D:\scripts\items\sphere_d_item_armor.scp", 940, "01b74", "i_shield_kite_metal", "", "", "kite shield (metal)", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 959, "01b75", "01b74");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="shields";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(9, "D:\scripts\items\sphere_d_item_armor.scp", 963, "01b76", "i_shield_heater", "", "", "heater shield", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 982, "01b77", "01b76");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="shields";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(9, "D:\scripts\items\sphere_d_item_armor.scp", 986, "01b78", "i_shield_kite_wood", "", "", "kite shield (wooden)", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1004, "01b79", "01b78");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="shields";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(9, "D:\scripts\items\sphere_d_item_armor.scp", 1008, "01b7a", "i_shield_wood", "", "", "wooden shield", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="shields";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(9, "D:\scripts\items\sphere_d_item_armor.scp", 1025, "01b7b", "i_shield_round_metal", "", "", "metal shield", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="shields";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(9, "D:\scripts\items\sphere_d_item_armor.scp", 1043, "01bc3", "i_shield_chaos", "", "", "chaos shield", 1);

SELECT catID FROM Categories WHERE category="armor" AND subcategory="shields";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(9, "D:\scripts\items\sphere_d_item_armor.scp", 1071, "01bc4", "i_shield_order", "", "", "order shield", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1100, "01bc5", "01bc4");

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1104, "01bd2", "01bd1");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="female armor";

INSERT INTO Categories (category, subcategory) VALUES("armor", "female armor");

SELECT LAST_INSERT_ID();

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(10, "D:\scripts\items\sphere_d_item_armor.scp", 1108, "01c00", "i_armor_female_shorts", "", "", "leather shorts", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1126, "01c01", "01c00");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="female armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(10, "D:\scripts\items\sphere_d_item_armor.scp", 1130, "01c02", "i_armor_female_studded", "", "", "studded armor", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1149, "01c03", "01c02");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="female armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(10, "D:\scripts\items\sphere_d_item_armor.scp", 1153, "01c04", "i_armor_female_plate", "", "", "female plate armor", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1172, "01c05", "01c04");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="female armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(10, "D:\scripts\items\sphere_d_item_armor.scp", 1176, "01c06", "i_armor_female_leather", "", "", "leather armor", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1195, "01c07", "01c06");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="female armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(10, "D:\scripts\items\sphere_d_item_armor.scp", 1199, "01c08", "i_armor_female_skirt", "", "", "leather skirt", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1218, "01c09", "01c08");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="female armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(10, "D:\scripts\items\sphere_d_item_armor.scp", 1222, "01c0a", "i_armor_female_bustier", "", "", "leather bustier", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1241, "01c0b", "01c0a");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="female armor";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(10, "D:\scripts\items\sphere_d_item_armor.scp", 1245, "01c0c", "i_armor_female_bustier_studded", "", "", "studded bustier", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1264, "01c0d", "01c0c");

SELECT catID FROM Categories WHERE category="armor" AND subcategory="helmets";

INSERT INTO Items (catID, filePath, lineNum, scriptID, defname, name, id, description, added) 				 VALUES(5, "D:\scripts\items\sphere_d_item_armor.scp", 1268, "01f0b", "i_helm_orc", "", "", "orc helm", 1);

INSERT INTO Items (filePath, lineNum, scriptID, dupeitem) VALUES("D:\scripts\items\sphere_d_item_armor.scp", 1284, "01f0c", "01f0b");

UPDATE items, items AS items2 SET items.catID = items2.catID, items.name = items2.name, items.id = items2.id, items.description = items2.description, items.added = 1 WHERE items.dupeitem = items2.scriptID;