createskilldomaininfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Game Info
#
#  FileName    :  CreateSkillDomainInfo.sql
#  Description :  胶懦 档皋牢 包访 
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
# 2002.10.30    厘全芒        BestItemType column 眠啊
#
################################################################################


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

CREATE TABLE SkillDomainInfo (
  Type 			int(11) NOT NULL auto_increment,
  DomainType 	int(11) NOT NULL default '0',
  Level 		int(11) NOT NULL default '0',
  GoalExp 		int(11) NOT NULL default '0',
  AccumExp 		int(11) NOT NULL default '0',

  BestItemType  tinyint NOT NULL default '0',   # 秦寸 胶懦狼 Best Item Type

  PRIMARY KEY  (Type)

) TYPE=MyISAM;


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



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



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



################################################################################
# 单捞磐 持扁

## 档
INSERT INTO SkillDomainInfo VALUES (  1, 	0,   0,        50,         50, 0);
INSERT INTO SkillDomainInfo VALUES (  2, 	0,   1,        60,        110, 0);
INSERT INTO SkillDomainInfo VALUES (  3, 	0,   2,        90,        200, 0);
INSERT INTO SkillDomainInfo VALUES (  4, 	0,   3,       150,        350, 0);
INSERT INTO SkillDomainInfo VALUES (  5, 	0,   4,       250,        600, 0);
INSERT INTO SkillDomainInfo VALUES (  6, 	0,   5,       400,       1000, 0);
INSERT INTO SkillDomainInfo VALUES (  7, 	0,   6,       610,       1610, 0);
INSERT INTO SkillDomainInfo VALUES (  8, 	0,   7,       890,       2500, 0);
INSERT INTO SkillDomainInfo VALUES (  9, 	0,   8,      1250,       3750, 0);
INSERT INTO SkillDomainInfo VALUES ( 10, 	0,   9,      1700,       5450, 0);
INSERT INTO SkillDomainInfo VALUES ( 11, 	0,  10,      2250,       7700, 0);
INSERT INTO SkillDomainInfo VALUES ( 12, 	0,  11,      2910,      10610, 0);
INSERT INTO SkillDomainInfo VALUES ( 13, 	0,  12,      3690,      14300, 0);
INSERT INTO SkillDomainInfo VALUES ( 14, 	0,  13,      4600,      18900, 0);
INSERT INTO SkillDomainInfo VALUES ( 15, 	0,  14,      5650,      24550, 0);
INSERT INTO SkillDomainInfo VALUES ( 16, 	0,  15,      6850,      31400, 0);
INSERT INTO SkillDomainInfo VALUES ( 17, 	0,  16,      8210,      39610, 0);
INSERT INTO SkillDomainInfo VALUES ( 18, 	0,  17,      9740,      49350, 0);
INSERT INTO SkillDomainInfo VALUES ( 19, 	0,  18,     11450,      60800, 0);
INSERT INTO SkillDomainInfo VALUES ( 20, 	0,  19,     13350,      74150, 0);
INSERT INTO SkillDomainInfo VALUES ( 21, 	0,  20,     15450,      89600, 1);
INSERT INTO SkillDomainInfo VALUES ( 22, 	0,  21,     17760,     107360, 1);
INSERT INTO SkillDomainInfo VALUES ( 23, 	0,  22,     20290,     127650, 1);
INSERT INTO SkillDomainInfo VALUES ( 24, 	0,  23,     23050,     150700, 1);
INSERT INTO SkillDomainInfo VALUES ( 25, 	0,  24,     26050,     176750, 1);
INSERT INTO SkillDomainInfo VALUES ( 26, 	0,  25,     29300,     206050, 1);
INSERT INTO SkillDomainInfo VALUES ( 27, 	0,  26,     32810,     238860, 1);
INSERT INTO SkillDomainInfo VALUES ( 28, 	0,  27,     36590,     275450, 1);
INSERT INTO SkillDomainInfo VALUES ( 29, 	0,  28,     40650,     316100, 1);
INSERT INTO SkillDomainInfo VALUES ( 30, 	0,  29,     45000,     361100, 1);
INSERT INTO SkillDomainInfo VALUES ( 31, 	0,  30,     49650,     410750, 2);
INSERT INTO SkillDomainInfo VALUES ( 32, 	0,  31,     54610,     465360, 2);
INSERT INTO SkillDomainInfo VALUES ( 33, 	0,  32,     59890,     525250, 2);
INSERT INTO SkillDomainInfo VALUES ( 34, 	0,  33,     65500,     590750, 2);
INSERT INTO SkillDomainInfo VALUES ( 35, 	0,  34,     71450,     662200, 2);
INSERT INTO SkillDomainInfo VALUES ( 36, 	0,  35,     77750,     739950, 2);
INSERT INTO SkillDomainInfo VALUES ( 37, 	0,  36,     84410,     824360, 2);
INSERT INTO SkillDomainInfo VALUES ( 38, 	0,  37,     91440,     915800, 2);
INSERT INTO SkillDomainInfo VALUES ( 39, 	0,  38,     98850,    1014650, 2);
INSERT INTO SkillDomainInfo VALUES ( 40, 	0,  39,    106650,    1121300, 2);
INSERT INTO SkillDomainInfo VALUES ( 41, 	0,  40,    114850,    1236150, 2);
INSERT INTO SkillDomainInfo VALUES ( 42, 	0,  41,    123460,    1359610, 3);
INSERT INTO SkillDomainInfo VALUES ( 43, 	0,  42,    132490,    1492100, 3);
INSERT INTO SkillDomainInfo VALUES ( 44, 	0,  43,    141950,    1634050, 3);
INSERT INTO SkillDomainInfo VALUES ( 45, 	0,  44,    151850,    1785900, 3);
INSERT INTO SkillDomainInfo VALUES ( 46, 	0,  45,    162200,    1948100, 3);
INSERT INTO SkillDomainInfo VALUES ( 47, 	0,  46,    173010,    2121110, 3);
INSERT INTO SkillDomainInfo VALUES ( 48, 	0,  47,    184290,    2305400, 3);
INSERT INTO SkillDomainInfo VALUES ( 49, 	0,  48,    196050,    2501450, 3);
INSERT INTO SkillDomainInfo VALUES ( 50, 	0,  49,    208300,    2709750, 3);
INSERT INTO SkillDomainInfo VALUES ( 51, 	0,  50,    221050,    2930800, 3);
INSERT INTO SkillDomainInfo VALUES ( 52, 	0,  51,    234310,    3165110, 4);
INSERT INTO SkillDomainInfo VALUES ( 53, 	0,  52,    248090,    3413200, 4);
INSERT INTO SkillDomainInfo VALUES ( 54, 	0,  53,    262400,    3675600, 4);
INSERT INTO SkillDomainInfo VALUES ( 55, 	0,  54,    277250,    3952850, 4);
INSERT INTO SkillDomainInfo VALUES ( 56, 	0,  55,    292650,    4245500, 4);
INSERT INTO SkillDomainInfo VALUES ( 57, 	0,  56,    308610,    4554110, 4);
INSERT INTO SkillDomainInfo VALUES ( 58, 	0,  57,    325140,    4879250, 4);
INSERT INTO SkillDomainInfo VALUES ( 59, 	0,  58,    342250,    5221500, 4);
INSERT INTO SkillDomainInfo VALUES ( 60, 	0,  59,    359950,    5581450, 4);
INSERT INTO SkillDomainInfo VALUES ( 61, 	0,  60,    378250,    5959700, 4);
INSERT INTO SkillDomainInfo VALUES ( 62, 	0,  61,    397160,    6356860, 5);
INSERT INTO SkillDomainInfo VALUES ( 63, 	0,  62,    416690,    6773550, 5);
INSERT INTO SkillDomainInfo VALUES ( 64, 	0,  63,    436850,    7210400, 5);
INSERT INTO SkillDomainInfo VALUES ( 65, 	0,  64,    457650,    7668050, 5);
INSERT INTO SkillDomainInfo VALUES ( 66, 	0,  65,    479100,    8147150, 5);
INSERT INTO SkillDomainInfo VALUES ( 67, 	0,  66,    501210,    8648360, 5);
INSERT INTO SkillDomainInfo VALUES ( 68, 	0,  67,    523990,    9172350, 5);
INSERT INTO SkillDomainInfo VALUES ( 69, 	0,  68,    547450,    9719800, 5);
INSERT INTO SkillDomainInfo VALUES ( 70, 	0,  69,    571600,   10291400, 5);
INSERT INTO SkillDomainInfo VALUES ( 71, 	0,  70,    596450,   10887850, 5);
INSERT INTO SkillDomainInfo VALUES ( 72, 	0,  71,    622010,   11509860, 6);
INSERT INTO SkillDomainInfo VALUES ( 73, 	0,  72,    648290,   12158150, 6);
INSERT INTO SkillDomainInfo VALUES ( 74, 	0,  73,    675300,   12833450, 6);
INSERT INTO SkillDomainInfo VALUES ( 75, 	0,  74,    703050,   13536500, 6);
INSERT INTO SkillDomainInfo VALUES ( 76, 	0,  75,    731550,   14268050, 6);
INSERT INTO SkillDomainInfo VALUES ( 77, 	0,  76,    760810,   15028860, 6);
INSERT INTO SkillDomainInfo VALUES ( 78, 	0,  77,    790840,   15819700, 6);
INSERT INTO SkillDomainInfo VALUES ( 79, 	0,  78,    821650,   16641350, 6);
INSERT INTO SkillDomainInfo VALUES ( 80, 	0,  79,    853250,   17494600, 6);
INSERT INTO SkillDomainInfo VALUES ( 81, 	0,  80,    885650,   18380250, 6);
INSERT INTO SkillDomainInfo VALUES ( 82, 	0,  81,    918860,   19299110, 7);
INSERT INTO SkillDomainInfo VALUES ( 83, 	0,  82,    952890,   20252000, 7);
INSERT INTO SkillDomainInfo VALUES ( 84, 	0,  83,    987750,   21239750, 7);
INSERT INTO SkillDomainInfo VALUES ( 85, 	0,  84,   1023450,   22263200, 7);
INSERT INTO SkillDomainInfo VALUES ( 86, 	0,  85,   1060000,   23323200, 7);
INSERT INTO SkillDomainInfo VALUES ( 87, 	0,  86,   1097410,   24420610, 7);
INSERT INTO SkillDomainInfo VALUES ( 88, 	0,  87,   1135690,   25556300, 7);
INSERT INTO SkillDomainInfo VALUES ( 89, 	0,  88,   1174850,   26731150, 7);
INSERT INTO SkillDomainInfo VALUES ( 90, 	0,  89,   1214900,   27946050, 7);
INSERT INTO SkillDomainInfo VALUES ( 91, 	0,  90,   1255850,   29201900, 7);
INSERT INTO SkillDomainInfo VALUES ( 92, 	0,  91,   1297710,   30499610, 8);
INSERT INTO SkillDomainInfo VALUES ( 93, 	0,  92,   1340490,   31840100, 8);
INSERT INTO SkillDomainInfo VALUES ( 94, 	0,  93,   1384200,   33224300, 8);
INSERT INTO SkillDomainInfo VALUES ( 95, 	0,  94,   1428850,   34653150, 8);
INSERT INTO SkillDomainInfo VALUES ( 96, 	0,  95,   1474450,   36127600, 8);
INSERT INTO SkillDomainInfo VALUES ( 97, 	0,  96,   1521010,   37648610, 8);
INSERT INTO SkillDomainInfo VALUES ( 98, 	0,  97,   1568540,   39217150, 8);
INSERT INTO SkillDomainInfo VALUES ( 99, 	0,  98,   1617050,   40834200, 8);
INSERT INTO SkillDomainInfo VALUES (100, 	0,  99,   1666550,   42500750, 8);
INSERT INTO SkillDomainInfo VALUES (101, 	0, 100,   1719880,   44220630, 8);
INSERT INTO SkillDomainInfo VALUES (102,	0,	101,	1774916,	45995545,	9);
INSERT INTO SkillDomainInfo VALUES (103,	0,	102,	1831713,	47827258,	9);
INSERT INTO SkillDomainInfo VALUES (104,	0,	103,	1890328,	49717586,	9);
INSERT INTO SkillDomainInfo VALUES (105,	0,	104,	1950818,	51668405,	9);
INSERT INTO SkillDomainInfo VALUES (106,	0,	105,	2015195,	53683600,	9);
INSERT INTO SkillDomainInfo VALUES (107,	0,	106,	2081697,	55765297,	9);
INSERT INTO SkillDomainInfo VALUES (108,	0,	107,	2150393,	57915690,	9);
INSERT INTO SkillDomainInfo VALUES (109,	0,	108,	2221356,	60137045,	9);
INSERT INTO SkillDomainInfo VALUES (110,	0,	109,	2294661,	62431706,	9);
INSERT INTO SkillDomainInfo VALUES (111,	0,	110,	2372679,	64804385,	9);
INSERT INTO SkillDomainInfo VALUES (112,	0,	111,	2453350,	67257735,	10);
INSERT INTO SkillDomainInfo VALUES (113,	0,	112,	2536764,	69794499,	10);
INSERT INTO SkillDomainInfo VALUES (114,	0,	113,	2623014,	72417513,	10);
INSERT INTO SkillDomainInfo VALUES (115,	0,	114,	2712196,	75129709,	10);
INSERT INTO SkillDomainInfo VALUES (116,	0,	115,	2807123,	77936832,	10);
INSERT INTO SkillDomainInfo VALUES (117,	0,	116,	2905373,	80842205,	10);
INSERT INTO SkillDomainInfo VALUES (118,	0,	117,	3007061,	83849266,	10);
INSERT INTO SkillDomainInfo VALUES (119,	0,	118,	3112308,	86961573,	10);
INSERT INTO SkillDomainInfo VALUES (120,	0,	119,	3221239,	90182812,	10);
INSERT INTO SkillDomainInfo VALUES (121,	0,	120,	3337203,	93520015,	10);
INSERT INTO SkillDomainInfo VALUES (122,	0,	121,	3457342,	96977358,	11);
INSERT INTO SkillDomainInfo VALUES (123,	0,	122,	3581807,	100559164,	11);
INSERT INTO SkillDomainInfo VALUES (124,	0,	123,	3710752,	104269916,	11);
INSERT INTO SkillDomainInfo VALUES (125,	0,	124,	3844339,	108114255,	11);
INSERT INTO SkillDomainInfo VALUES (126,	0,	125,	3986579,	112100834,	11);
INSERT INTO SkillDomainInfo VALUES (127,	0,	126,	4134083,	116234917,	11);
INSERT INTO SkillDomainInfo VALUES (128,	0,	127,	4287044,	120521961,	11);
INSERT INTO SkillDomainInfo VALUES (129,	0,	128,	4445665,	124967626,	11);