createshoptemplate.sql

天之炼狱OpenDE_SQL.tar.gz

-- MySQL dump 8.22
--
-- Host: localhost    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.51-log

--
-- Table structure for table 'ShopTemplate'
--
--	2002.09.30	硅犁屈		墨福膏 藕芒 荐沥

DROP TABLE IF EXISTS ShopTemplate;

CREATE TABLE ShopTemplate (
  ID int(10) unsigned NOT NULL default '0',
  ShopType tinyint(3) unsigned NOT NULL default '0',
  ItemClass tinyint(3) unsigned NOT NULL default '0',
  MinItemType tinyint(3) unsigned NOT NULL default '0',
  MaxItemType tinyint(3) unsigned NOT NULL default '0',
  MinOptionLevel tinyint(3) unsigned NOT NULL default '0',
  MaxOptionLevel tinyint(3) unsigned NOT NULL default '0',
  NPCID smallint(5) unsigned NOT NULL default '0',
  UNIQUE KEY ShopTemplate_u1 (ID)
) TYPE=MyISAM;

--
-- Dumping data for table 'ShopTemplate'
--

####################################################
# 夸矫窍扼 - BASIC
INSERT INTO ShopTemplate VALUES (10, 0, 13,0,2,0,0,100);
INSERT INTO ShopTemplate VALUES (20, 0, 18,0,2,0,0,100);
# 夸矫窍扼 - SPECIAL
INSERT INTO ShopTemplate VALUES (30, 1, 13,0,2,1,4,100);
INSERT INTO ShopTemplate VALUES (40, 1, 18,0,2,1,4,100);


####################################################
# 弊风滚 - BASIC
INSERT INTO ShopTemplate VALUES (110, 0,  8,0,2,0,0,95);
INSERT INTO ShopTemplate VALUES (120, 0,  9,0,2,0,0,95);
INSERT INTO ShopTemplate VALUES (130, 0, 10,0,2,0,0,95);
# 弊风滚 - SPECIAL
INSERT INTO ShopTemplate VALUES (140, 1,  8,0,2,1,4,95);
INSERT INTO ShopTemplate VALUES (150, 1,  9,0,2,1,4,95);
INSERT INTO ShopTemplate VALUES (160, 1, 10,0,2,1,4,95);
INSERT INTO ShopTemplate VALUES (170, 0, 41,7,7,0,0,95); 
# 弊风滚 - Gamble
INSERT INTO ShopTemplate VALUES (180, 2, 11, 0,0,0,0,95); # 内飘
INSERT INTO ShopTemplate VALUES (181, 2, 12, 0,0,0,0,95); # 官瘤
INSERT INTO ShopTemplate VALUES (182, 2, 13, 0,0,0,0,95); # 脚惯
INSERT INTO ShopTemplate VALUES (183, 2, 18, 0,0,0,0,95); # 厘癌
INSERT INTO ShopTemplate VALUES (184, 2, 19, 0,0,0,0,95); # 秋镐
INSERT INTO ShopTemplate VALUES (185, 2,  8, 0,0,0,0,95); # 馆瘤
INSERT INTO ShopTemplate VALUES (186, 2,  9, 0,0,0,0,95); # 迫骂
INSERT INTO ShopTemplate VALUES (187, 2, 10, 0,0,0,0,95); # 格吧捞
INSERT INTO ShopTemplate VALUES (188, 2, 26, 0,0,0,0,95); # 骇飘
INSERT INTO ShopTemplate VALUES (189, 2, 14, 3,3,0,0,95); # 八
INSERT INTO ShopTemplate VALUES (190, 2, 15, 0,0,0,0,95); # 档
INSERT INTO ShopTemplate VALUES (191, 2, 16, 2,2,0,0,95); # 规菩
INSERT INTO ShopTemplate VALUES (192, 2, 17, 0,0,0,0,95); # 皋捞胶
INSERT INTO ShopTemplate VALUES (193, 2, 35, 0,0,0,0,95); # 皋捞胶
INSERT INTO ShopTemplate VALUES (194, 2, 20, 0,0,0,0,95); # SG
INSERT INTO ShopTemplate VALUES (195, 2, 21, 0,0,0,0,95); # SMG
INSERT INTO ShopTemplate VALUES (196, 2, 22, 0,0,0,0,95); # AR
INSERT INTO ShopTemplate VALUES (197, 2, 23, 0,0,0,0,95); # SR



####################################################
# 魂靛扼 - BASIC
INSERT INTO ShopTemplate VALUES (210, 0, 11,0,5,0,0,97);
INSERT INTO ShopTemplate VALUES (220, 0, 12,0,5,0,0,97);
INSERT INTO ShopTemplate VALUES (230, 0, 19,0,2,0,0,97);
INSERT INTO ShopTemplate VALUES (240, 0, 26,0,1,0,0,97);
# 魂靛扼 - SPECIAL
INSERT INTO ShopTemplate VALUES (250, 1, 11,0,5,1,4,97);
INSERT INTO ShopTemplate VALUES (260, 1, 12,0,5,1,4,97);
INSERT INTO ShopTemplate VALUES (270, 1, 19,0,2,1,4,97);
INSERT INTO ShopTemplate VALUES (280, 1, 26,0,1,1,4,97);


####################################################
# 窍胶宏肺 - BASIC
INSERT INTO ShopTemplate VALUES (310, 0, 16,0,2,0,0,110); # 规菩
# 窍胶宏肺 - SPECIAL
INSERT INTO ShopTemplate VALUES (320, 1, 16,0,2,1,4,110); # 规菩


####################################################
# 咯客 - BASIC
INSERT INTO ShopTemplate VALUES (410, 0, 15,0,2,0,0,14);
# 咯客 - SPECIAL
INSERT INTO ShopTemplate VALUES (420, 1, 15,0,2,1,4,14);


####################################################
# 茄 - BASIC
INSERT INTO ShopTemplate VALUES (510, 0, 14,0,2,0,0,24);  # 八
# 茄 - SPECIAL
INSERT INTO ShopTemplate VALUES (520, 1, 14,0,2,1,4,24);  # 八


####################################################
# 黎 - BASIC
INSERT INTO ShopTemplate VALUES (610, 0,  0,0, 0,0,0,109); # 坷配官捞
INSERT INTO ShopTemplate VALUES (620, 0,  4,0,15,0,0,109); # 藕芒
INSERT INTO ShopTemplate VALUES (630, 0, 38,0, 2,0,0,109); # 秋扁



####################################################
# 家衬 - BASIC
INSERT INTO ShopTemplate VALUES (710, 0, 11, 0,5,0,0,99); # 内飘
INSERT INTO ShopTemplate VALUES (720, 0, 12, 0,5,0,0,99); # 官瘤
INSERT INTO ShopTemplate VALUES (730, 0, 19, 0,2,0,0,99); # 秋镐
INSERT INTO ShopTemplate VALUES (740, 0, 26, 0,1,0,0,99); # 骇飘

INSERT INTO ShopTemplate VALUES (750, 1, 11, 0,5,1,4,99); # 内飘
INSERT INTO ShopTemplate VALUES (760, 1, 12, 0,5,1,4,99); # 官瘤
INSERT INTO ShopTemplate VALUES (770, 1, 19, 0,2,1,4,99); # 秋镐
INSERT INTO ShopTemplate VALUES (780, 1, 26, 0,1,1,4,99); # 骇飘



####################################################
# 农肺快 - BASIC
INSERT INTO ShopTemplate VALUES (830, 0, 24, 0,2,0,0,102); # 气藕
INSERT INTO ShopTemplate VALUES (840, 0, 25, 0,2,0,0,102); # 瘤汾
INSERT INTO ShopTemplate VALUES (940, 0,  5, 0,9,0,0,102); # 气藕 犁丰
# 农肺快 - SPECIAL
INSERT INTO ShopTemplate VALUES (850, 1, 13, 0,2,1,4,102); # 脚惯 
INSERT INTO ShopTemplate VALUES (860, 1, 18, 0,2,1,4,102); # 厘癌



####################################################
# 农扼捞橇 - BASIC
INSERT INTO ShopTemplate VALUES (910, 0,  8, 0,2,0, 0,23); # 傅
INSERT INTO ShopTemplate VALUES (920, 0,  9, 0,2,0, 0,23); # 迫骂
INSERT INTO ShopTemplate VALUES (930, 0, 10, 0,2,0, 0,23); # 格吧捞
# 农扼捞橇 - SPECIAL
INSERT INTO ShopTemplate VALUES (950, 1,  8, 0,2,1,4,23); # 傅
INSERT INTO ShopTemplate VALUES (960, 1,  9, 0,2,1,4,23); # 迫骂
INSERT INTO ShopTemplate VALUES (970, 1, 10, 0,2,1,4,23); # 格吧捞


####################################################
# 靛饭捞农 - BASIC
INSERT INTO ShopTemplate VALUES (1010, 0, 20, 0,2,0,0,11); # SG
INSERT INTO ShopTemplate VALUES (1020, 0, 22, 0,2,0,0,11); # AR
# 靛饭捞农 - SPECIAL
INSERT INTO ShopTemplate VALUES (1030, 1, 20, 0,2,1,4,11); # SG
INSERT INTO ShopTemplate VALUES (1040, 1, 22, 0,2,1,4,11); # AR

####################################################
# 胶颇福藕 - BASIC
INSERT INTO ShopTemplate VALUES (1110, 0, 21, 0,2,0,0,12); # SMG
# 胶颇福藕 - SPECIAL
INSERT INTO ShopTemplate VALUES (1120, 1, 21, 0,2,1,4,12); # SMG


####################################################
# 莉 - BASIC
INSERT INTO ShopTemplate VALUES (1210, 0, 23, 0,2,0,0,15); # SR
# 莉 - SPECIAL
INSERT INTO ShopTemplate VALUES (1220, 1, 23, 0,2,1,4,15); # SR



####################################################
# 橇饭靛腐 - BASIC
INSERT INTO ShopTemplate VALUES (1310, 0,  0, 0, 0,0,0,158); # 坷配官捞
INSERT INTO ShopTemplate VALUES (1320, 0,  4, 0,15,0,0,158); # 藕芒
INSERT INTO ShopTemplate VALUES (1330, 0, 38, 0, 2,0,0,158); # 秋扁
 


#######################################################
# 抗宏霸聪 - BASIC
INSERT INTO ShopTemplate VALUES (1410, 0,  8, 0,2,0,0,159); # 馆瘤
INSERT INTO ShopTemplate VALUES (1420, 0,  9, 0,2,0,0,159); # 迫骂
INSERT INTO ShopTemplate VALUES (1430, 0, 10, 0,2,0,0,159); # 格吧捞
# 抗宏霸聪 - SPECIAL
INSERT INTO ShopTemplate VALUES (1440, 1,  8, 0,2,1,4,159); # 馆瘤
INSERT INTO ShopTemplate VALUES (1450, 1,  9, 0,2,1,4,159); # 迫骂
INSERT INTO ShopTemplate VALUES (1460, 1, 10, 0,2,1,4,159); # 格吧捞


#######################################################
# 聪妮扼捞 - BASIC
INSERT INTO ShopTemplate VALUES (1510, 0, 11, 0,5,0,0,160); # 内飘
INSERT INTO ShopTemplate VALUES (1520, 0, 12, 0,5,0,0,160); # 官瘤
INSERT INTO ShopTemplate VALUES (1530, 0, 19, 0,2,0,0,160); # 秋镐
INSERT INTO ShopTemplate VALUES (1540, 0, 26, 0,1,0,0,160); # 骇飘
# 聪妮扼捞 - SPECIAL
INSERT INTO ShopTemplate VALUES (1550, 1, 11, 0,5,1,4,160); # 内飘
INSERT INTO ShopTemplate VALUES (1560, 1, 12, 0,5,1,4,160); # 官瘤 
INSERT INTO ShopTemplate VALUES (1570, 1, 19, 0,2,1,4,160); # 秋镐
INSERT INTO ShopTemplate VALUES (1580, 1, 26, 0,1,1,4,160); # 骇飘



#######################################################
# 府瞒靛郊 - BASIC
INSERT INTO ShopTemplate VALUES (1610, 0, 13, 0,2,0,0,161); # 脚惯
INSERT INTO ShopTemplate VALUES (1620, 0, 18, 0,2,0,0,161); # 厘癌
# 府瞒靛郊 - SPECIAL
INSERT INTO ShopTemplate VALUES (1630, 1, 13, 0,2,1,4,161); # 脚惯 
INSERT INTO ShopTemplate VALUES (1640, 1, 18, 0,2,1,4,161); # 厘癌



#######################################################
# 茄聪惯 - BASIC
INSERT INTO ShopTemplate VALUES (1710, 0, 35, 0,2,0,0,25); # 皋捞胶
# 茄聪惯 - SPECIAL
INSERT INTO ShopTemplate VALUES (1720, 1, 35, 0,2,1,4,25); # 皋捞胶


#######################################################
# 箕葛福 - BASIC
INSERT INTO ShopTemplate VALUES (1810, 0,  8, 0,2,0,0,162); # 馆瘤
INSERT INTO ShopTemplate VALUES (1820, 0,  9, 0,2,0,0,162); # 迫骂
INSERT INTO ShopTemplate VALUES (1830, 0, 10, 0,2,0,0,162); # 格吧捞

INSERT INTO ShopTemplate VALUES (1840, 1,  8, 0,2,1,4,162); # 馆瘤
INSERT INTO ShopTemplate VALUES (1850, 1,  9, 0,2,1,4,162); # 迫骂
INSERT INTO ShopTemplate VALUES (1960, 1, 10, 0,2,1,4,162); # 格吧捞



#######################################################
# 扼儒付畴橇 - BASIC
INSERT INTO ShopTemplate VALUES (2010, 0, 17, 0,2,0,0,163); # 绞磊啊
# 扼儒付畴橇 - SPECIAL
INSERT INTO ShopTemplate VALUES (2020, 1, 17, 0,2,1,4,163); # 绞磊啊


#######################################################
# 漠 - BASIC
INSERT INTO ShopTemplate VALUES (2110, 0,  0, 0, 0,0,0,19); # 坷配官捞
INSERT INTO ShopTemplate VALUES (2120, 0,  4, 0,15,0,0,19); # 藕芒
INSERT INTO ShopTemplate VALUES (2130, 0, 38, 0, 2,0,0,19); # 秋扁



#######################################################
# 疥静 - BASIC