createitemclass.sql

天之炼狱OpenDE_SQL.tar.gz

-- MySQL dump 8.22
--
-- Host: 61.78.53.167    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.54-log

--
-- Table structure for table 'ItemClass'
--

CREATE TABLE ItemClass (
  ItemClass int(11) NOT NULL default '0',
  Name varchar(20) NOT NULL default '',
  PRIMARY KEY  (ItemClass)
) TYPE=MyISAM;

--
-- Dumping data for table '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,'RELIC');
INSERT INTO ItemClass VALUES (44,'VAMPIRE_WEAPON');
INSERT INTO ItemClass VALUES (45,'VAMPIRE_AMULET');
INSERT INTO ItemClass VALUES (46,'QUEST_ITEM');
INSERT INTO ItemClass VALUES (47,'MAX');