createuniqueiteminfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateUniqueItemInfo.sql
#  Description : 蜡聪农 酒捞袍 箭磊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
# 2002.08.23    厘全芒        Shoes, Amulet 酒捞袍 眠啊
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS UniqueItemInfo;

CREATE TABLE UniqueItemInfo (
  ItemClass 	tinyint(3) 	unsigned NOT NULL default '0',
  ItemType 		tinyint(3) 	unsigned NOT NULL default '0',
  LimitNumber 	int(10) 	unsigned NOT NULL default '0',
  CurrentNumber int(10) 	unsigned NOT NULL default '0',

  PRIMARY KEY  (ItemClass,ItemType)

) TYPE=MyISAM;


################################################################################
# 牢郸胶 积己



################################################################################
# Sequence 积己



################################################################################
# 鼻茄 汲沥 



################################################################################
# 单捞磐 持扁
INSERT INTO UniqueItemInfo VALUES (14,10,5,0); # Sword
INSERT INTO UniqueItemInfo VALUES (15,10,5,0); # Blade
INSERT INTO UniqueItemInfo VALUES (35, 8,5,0); # Mace
INSERT INTO UniqueItemInfo VALUES (17, 8,5,0); # Cross
INSERT INTO UniqueItemInfo VALUES (18, 8,5,0); # Glove
INSERT INTO UniqueItemInfo VALUES (26, 4,5,0); # Belt
INSERT INTO UniqueItemInfo VALUES (16, 9,5,0); # Shield
INSERT INTO UniqueItemInfo VALUES (10,10,5,0); # Necklace
INSERT INTO UniqueItemInfo VALUES ( 9,10,5,0); # Bracelet
INSERT INTO UniqueItemInfo VALUES ( 8,10,5,0); # Ring
INSERT INTO UniqueItemInfo VALUES (21,10,5,0); # SMG
INSERT INTO UniqueItemInfo VALUES (22,10,5,0); # AR
INSERT INTO UniqueItemInfo VALUES (20,10,5,0); # SG
INSERT INTO UniqueItemInfo VALUES (23,10,5,0); # SR
INSERT INTO UniqueItemInfo VALUES (32,10,5,0); # Vampire Necklace
INSERT INTO UniqueItemInfo VALUES (31, 9,5,0); # Vampire Bracelet
INSERT INTO UniqueItemInfo VALUES (30,10,5,0); # Vampire Ring
INSERT INTO UniqueItemInfo VALUES (19, 9,5,0); # Helmet
INSERT INTO UniqueItemInfo VALUES (11,16,5,0); # Coat
INSERT INTO UniqueItemInfo VALUES (11,17,5,0); # Coat
INSERT INTO UniqueItemInfo VALUES (12,16,5,0); # Trouser
INSERT INTO UniqueItemInfo VALUES (12,17,5,0); # Trouser
INSERT INTO UniqueItemInfo VALUES (42,10,5,0); # Vampire Earring
INSERT INTO UniqueItemInfo VALUES (33,12,5,0); # Vampire Coat
INSERT INTO UniqueItemInfo VALUES (33,13,5,0); # Vampire Coat
INSERT INTO UniqueItemInfo VALUES (44,15,5,0); # Vampire Weapon
INSERT INTO UniqueItemInfo VALUES (13, 7,5,0); # Shoes
INSERT INTO UniqueItemInfo VALUES (45,10,5,0); # Vampire Amulet

# 沥府官恩~ by sigi. 2002.12.27
ALTER TABLE UniqueItemInfo ADD COLUMN ItemClassName VARCHAR(30) NOT NULL DEFAULT '';
UPDATE UniqueItemInfo SET ItemClassName = 'MOTORCYCLE' WHERE ItemClass=0;
UPDATE UniqueItemInfo SET ItemClassName = 'POTION' WHERE ItemClass=1;
UPDATE UniqueItemInfo SET ItemClassName = 'WATER' WHERE ItemClass=2;
UPDATE UniqueItemInfo SET ItemClassName = 'HOLYWATER' WHERE ItemClass=3;
UPDATE UniqueItemInfo SET ItemClassName = 'MAGAZINE' WHERE ItemClass=4;
UPDATE UniqueItemInfo SET ItemClassName = 'BOMB_MATERIAL' WHERE ItemClass=5;
UPDATE UniqueItemInfo SET ItemClassName = 'ETC' WHERE ItemClass=6;
UPDATE UniqueItemInfo SET ItemClassName = 'KEY' WHERE ItemClass=7;
UPDATE UniqueItemInfo SET ItemClassName = 'RING' WHERE ItemClass=8;
UPDATE UniqueItemInfo SET ItemClassName = 'BRACELET' WHERE ItemClass=9;
UPDATE UniqueItemInfo SET ItemClassName = 'NECKLACE' WHERE ItemClass=10;
UPDATE UniqueItemInfo SET ItemClassName = 'COAT' WHERE ItemClass=11;
UPDATE UniqueItemInfo SET ItemClassName = 'TROUSER' WHERE ItemClass=12;
UPDATE UniqueItemInfo SET ItemClassName = 'SHOES' WHERE ItemClass=13;
UPDATE UniqueItemInfo SET ItemClassName = 'SWORD' WHERE ItemClass=14;
UPDATE UniqueItemInfo SET ItemClassName = 'BLADE' WHERE ItemClass=15;
UPDATE UniqueItemInfo SET ItemClassName = 'SHIELD' WHERE ItemClass=16;
UPDATE UniqueItemInfo SET ItemClassName = 'CROSS' WHERE ItemClass=17;
UPDATE UniqueItemInfo SET ItemClassName = 'GLOVE' WHERE ItemClass=18;
UPDATE UniqueItemInfo SET ItemClassName = 'HELM' WHERE ItemClass=19;
UPDATE UniqueItemInfo SET ItemClassName = 'SG' WHERE ItemClass=20;
UPDATE UniqueItemInfo SET ItemClassName = 'SMG' WHERE ItemClass=21;
UPDATE UniqueItemInfo SET ItemClassName = 'AR' WHERE ItemClass=22;
UPDATE UniqueItemInfo SET ItemClassName = 'SR' WHERE ItemClass=23;
UPDATE UniqueItemInfo SET ItemClassName = 'BOMB' WHERE ItemClass=24;
UPDATE UniqueItemInfo SET ItemClassName = 'MINE' WHERE ItemClass=25;
UPDATE UniqueItemInfo SET ItemClassName = 'BELT' WHERE ItemClass=26;
UPDATE UniqueItemInfo SET ItemClassName = 'LEARNINGITEM' WHERE ItemClass=27;
UPDATE UniqueItemInfo SET ItemClassName = 'MONEY' WHERE ItemClass=28;
UPDATE UniqueItemInfo SET ItemClassName = 'CORPSE' WHERE ItemClass=29;
UPDATE UniqueItemInfo SET ItemClassName = 'VAMPIRE_RING' WHERE ItemClass=30;
UPDATE UniqueItemInfo SET ItemClassName = 'VAMPIRE_BRACELET' WHERE ItemClass=31;
UPDATE UniqueItemInfo SET ItemClassName = 'VAMPIRE_NECKLACE' WHERE ItemClass=32;
UPDATE UniqueItemInfo SET ItemClassName = 'VAMPIRE_COAT' WHERE ItemClass=33;
UPDATE UniqueItemInfo SET ItemClassName = 'SKULL' WHERE ItemClass=34;
UPDATE UniqueItemInfo SET ItemClassName = 'MACE' WHERE ItemClass=35;
UPDATE UniqueItemInfo SET ItemClassName = 'SERUM' WHERE ItemClass=36;
UPDATE UniqueItemInfo SET ItemClassName = 'VAMPIRE_ETC' WHERE ItemClass=37;
UPDATE UniqueItemInfo SET ItemClassName = 'SLAYER_PORTAL_ITEM' WHERE ItemClass=38;
UPDATE UniqueItemInfo SET ItemClassName = 'VAMPIRE_PORTAL_ITEM' WHERE ItemClass=39;
UPDATE UniqueItemInfo SET ItemClassName = 'EVENT_GIFT_BOX' WHERE ItemClass=40;
UPDATE UniqueItemInfo SET ItemClassName = 'EVENT_STAR' WHERE ItemClass=41;
UPDATE UniqueItemInfo SET ItemClassName = 'VAMPIRE_EARRING' WHERE ItemClass=42;
UPDATE UniqueItemInfo SET ItemClassName = 'RELIC' WHERE ItemClass=43;
UPDATE UniqueItemInfo SET ItemClassName = 'VAMPIRE_WEAPON' WHERE ItemClass=44;
UPDATE UniqueItemInfo SET ItemClassName = 'VAMPIRE_AMULET' WHERE ItemClass=45;
UPDATE UniqueItemInfo SET ItemClassName = 'QUEST_ITEM' WHERE ItemClass=46;
UPDATE UniqueItemInfo SET ItemClassName = 'EVENT_TREE' WHERE ItemClass=47;
UPDATE UniqueItemInfo SET ItemClassName = 'EVENT_ETC' WHERE ItemClass=48;