createitemclass.sql

天之炼狱OpenDE_SQL.tar.gz

/******************************************************************************/
/*                                                                            */
/*  PROJECT  : ONLINE GAME DARKEDEN                                           */
/*  Module   : Database - 款康磊 扁贱 包府                                    */
/*                                                                            */
/*  Filename : CreateItemClassTable.sql                                       */
/*                                                                            */
/*  累己老   : 2002斥 10岿 17老                                               */
/*  累己磊   : 厘全芒                                                         */
/*                                                                            */
/*  汲疙     : ItemClasTable篮 扁夯利栏肺 辑滚狼 悼累苞绰 酒公 惑包绝绰       */
/*             Table捞促. 橇肺弊伐惑俊辑 Item篮 ItemCalss肺 牢侥捞 登绰单     */
/*             巩力绰 Database俊 捞 ItemClassCode啊 涝仿捞 登绢 乐绰 巴捞促.  */
/*             搬惫 烹拌摹甫 郴绰 苞沥俊辑绰 绢驴 荐 绝捞 捞 抛捞喉捞         */
/*             曼绊啊 登绢具 窍绰 巴捞促.                                     */
/*                                                                            */
/*  History                                                                   */
/*                                                                            */
/*  荐沥老     荐沥磊             荐沥郴开                                    */
/*---------- ---------------- ----------------------------------------------- */
/*2002.10.17   厘全芒            脚痹积己                                     */
/******************************************************************************/

DROP TABLE IF EXISTS ItemClass;

CREATE TABLE ItemClass
(
     ItemClass int NOT NULL,
	 Name      varchar(20) NOT NULL,

     PRIMARY KEY(ItemClass)
);

INSERT INTO ItemClass VALUES(0,'MOTORCYCLE');
INSERT INTO ItemClass VALUES(1,'POTION');
INSERT INTO ItemClass VALUES(2,'WATER');    
INSERT INTO ItemClass VALUES(3,'HOLYWATER');
INSERT INTO ItemClass VALUES(4,'MAGAZINE');
INSERT INTO ItemClass VALUES(5,'BOMB_MATERIAL');
INSERT INTO ItemClass VALUES(6,'ETC');
INSERT INTO ItemClass VALUES(7,'KEY');
INSERT INTO ItemClass VALUES(8,'RING');
INSERT INTO ItemClass VALUES(9,'BRACELET');
INSERT INTO ItemClass VALUES(10,'NECKLACE');
INSERT INTO ItemClass VALUES(11,'COAT');                 
INSERT INTO ItemClass VALUES(12,'TROUSER');              
INSERT INTO ItemClass VALUES(13,'SHOES');                
INSERT INTO ItemClass VALUES(14,'SWORD');               
INSERT INTO ItemClass VALUES(15,'BLADE');              
INSERT INTO ItemClass VALUES(16,'SHIELD');            
INSERT INTO ItemClass VALUES(17,'CROSS');            
INSERT INTO ItemClass VALUES(18,'GLOVE');           
INSERT INTO ItemClass VALUES(19,'HELM');           
INSERT INTO ItemClass VALUES(20,'SG'); 
INSERT INTO ItemClass VALUES(21,'SMG'); 
INSERT INTO ItemClass VALUES(22,'AR');
INSERT INTO ItemClass VALUES(23,'SR'); 
INSERT INTO ItemClass VALUES(24,'BOMB'); 
INSERT INTO ItemClass VALUES(25,'MINE'); 
INSERT INTO ItemClass VALUES(26,'BELT');
INSERT INTO ItemClass VALUES(27,'LEARNINGITEM'); 
INSERT INTO ItemClass VALUES(28,'MONEY'); 
INSERT INTO ItemClass VALUES(29,'CORPSE');
INSERT INTO ItemClass VALUES(30,'VAMPIRE_RING'); 
INSERT INTO ItemClass VALUES(31,'VAMPIRE_BRACELET');
INSERT INTO ItemClass VALUES(32,'VAMPIRE_NECKLACE');
INSERT INTO ItemClass VALUES(33,'VAMPIRE_COAT'); 
INSERT INTO ItemClass VALUES(34,'SKULL'); 
INSERT INTO ItemClass VALUES(35,'MACE'); 
INSERT INTO ItemClass VALUES(36,'SERUM'); 
INSERT INTO ItemClass VALUES(37,'VAMPIRE_ETC');
INSERT INTO ItemClass VALUES(38,'SLAYER_PORTAL_ITEM'); 
INSERT INTO ItemClass VALUES(39,'VAMPIRE_PORTAL_ITEM');
INSERT INTO ItemClass VALUES(40,'EVENT_GIFT_BOX'); 
INSERT INTO ItemClass VALUES(41,'EVENT_STAR'); 
INSERT INTO ItemClass VALUES(42,'VAMPIRE_EARRING'); 
INSERT INTO ItemClass VALUES(43,'EVENT_TREE'); 
INSERT INTO ItemClass VALUES(44,'EVENT_ETC');