createoptioninfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    :  CreateOptionInfo.sql
#  Description :  OptionInfo Table
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
# 2002.08.20    厘全芒        NextOptionRatio Column 眠啊
#                             Rare酒捞袍狼 免泅 犬伏阑 眉农窍绰 何盒(烙矫肺 5
#                             肺 例己登绢 乐澜)
################################################################################


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

CREATE TABLE OptionInfo (
  OptionType 			int(11)     NOT NULL default '0',
  Nickname 				varchar(50) NOT NULL default '',
  Name 					varchar(50) NOT NULL default '',
  HName 				varchar(50) NOT NULL default '',
  Class 				int(11)     NOT NULL default '0',
  PlusPoint 			int(11)     NOT NULL default '0',
  PriceMultiplier 		int(11)     NOT NULL default '0',
  ReqAbility 			varchar(50) NOT NULL default '',
  Color 				int(11)     NOT NULL default '0',
  Ratio 				int(11)     NOT NULL default '0',  # Gamble 犬伏
  OptionLevel 			int(11)     NOT NULL default '0',
  GambleLevel 			int(11)     NOT NULL default '0',

  UpgradeOptionType 	int(11)     NOT NULL default '0',
  UpgradeRatio 			int(11)     NOT NULL default '0',
  UpgradeSecondRatio 	int(11)     NOT NULL default '0',
  UpgradeCrashPercent 	tinyint(3)  NOT NULL default '0',
  PreviousOptionType 	tinyint unsigned NOT NULL default '0',  # Enchant俊辑 傈窜拌
                                                           # 狼 可记阑 眉农

  NextOptionRatio       tinyint(3)  NOT NULL default '0',  # Rare酒捞袍俊辑 
                                                           # 滴锅掳 可记捞 嘿阑
                                                           # 犬伏

  Grade					int(11)		NOT NULL default 0, # 鞍篮 可记努贰胶 郴俊辑 鞭荐.

  PRIMARY KEY  (OptionType)

) TYPE=MyISAM;


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



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



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



################################################################################
# 单捞磐 持扁
INSERT INTO OptionInfo VALUES (1, 'STR+1',  'Wolf',					  '狼',      0,   1,     150,'(SUM,2)(LEV,2)',   44, 75000,  3, 10,  2, 31, 43,  5,  0, 12, 0);
INSERT INTO OptionInfo VALUES (2, 'STR+2',  'Bear',					  '熊',      0,   2,     200,'(SUM,4)(LEV,4)',   41, 23000,  4, 22,  3, 20, 26, 10,  1, 10, 1);
INSERT INTO OptionInfo VALUES (3, 'STR+3',  'Ogre',					  '食人兽',    0,   3,     300,'(SUM,6)(LEV,6)',   38,  1800,  5, 51,  4,  6,  8, 20,  2,  5, 2);
INSERT INTO OptionInfo VALUES (4, 'STR+4',  'Giant',				  '巨人',  0,   4,     500,'(SUM,8)(LEV,8)',   35,   197,  6, 82,  5,  2,  2, 30,  3,  3, 3);
INSERT INTO OptionInfo VALUES (5, 'STR+5',  'Titan',				  '泰坦',    0,   5,    1000,'(SUM,10)(LEV,10)', 32,     3, 20, 93,  0,  0,  0,  0,  4,  2, 4);
INSERT INTO OptionInfo VALUES (6, 'DEX+1',  'Raven',				  '乌鸦',    1,   1,     150,'(SUM,1)(LEV,1)',   29, 75000,  3, 10,  7, 27, 37,  5,  0, 10, 0);
INSERT INTO OptionInfo VALUES (7, 'DEX+2',  'Owl',					  '猫头鹰',      1,   2,     200,'(SUM,2)(LEV,2)',   26, 23000,  4, 21,  8, 15, 21, 10,  6,  8, 1);
INSERT INTO OptionInfo VALUES (8, 'DEX+3',  'Hawk',					  '鹰',      1,   3,     300,'(SUM,3)(LEV,3)',   23,  1800,  5, 56,  9,  5,  7, 20,  7,  4, 2);
INSERT INTO OptionInfo VALUES (9, 'DEX+4',  'Eagle',				  '雕',      1,   4,     500,'(SUM,4)(LEV,4)',   20,   197,  6, 85, 10,  1,  1, 30,  8,  3, 3);
INSERT INTO OptionInfo VALUES (10,'DEX+5',  'Pheonix',				  '凤凰',    1,   5,    1000,'(SUM,5)(LEV,5)',   17,     3, 20, 95,  0,  0,  0,  0,  9,  1, 4);
INSERT INTO OptionInfo VALUES (11,'INT+1',  'HighBrain',			  '聪明人',2,   1,     150,'(SUM,1)(LEV,1)',   14, 75000,  3, 10, 12, 31, 43,  5,  0, 12, 0);
INSERT INTO OptionInfo VALUES (12,'INT+2',  'Wisdom',				  '智者',    2,   2,     200,'(SUM,2)(LEV,2)',   11, 23000,  4, 22, 13, 20, 26, 10, 11, 10, 1);
INSERT INTO OptionInfo VALUES (13,'INT+3',  'Sorcery',				  '法师',    2,   3,     300,'(SUM,3)(LEV,3)',    8,  1800,  5, 51, 14,  6,  8, 20, 12,  5, 2);
INSERT INTO OptionInfo VALUES (14,'INT+4',  'Wizardery',			  '大法师',  2,   4,     500,'(SUM,4)(LEV,4)',    5,   197,  6, 82, 15,  2,  2, 30, 13,  3, 3);
INSERT INTO OptionInfo VALUES (15,'INT+5',  'Magus',				  '先知',  2,   5,    1000,'(SUM,5)(LEV,5)',    2,     3, 20, 93,  0,  0,  0,  0, 14,  2, 4);
INSERT INTO OptionInfo VALUES (16,'HP+1',   'Life',					  '生命',    3,   3,     120,'(SUM,2)(LEV,2)',  240, 75000,  3, 10, 17, 27, 37,  5,  0, 10, 0);
INSERT INTO OptionInfo VALUES (17,'HP+2',   'Elixir',				  '长生',    3,   6,     150,'(SUM,4)(LEV,4)',  237, 23000,  4, 21, 18, 15, 21, 10, 16,  8, 1);
INSERT INTO OptionInfo VALUES (18,'HP+3',   'Resurrect',			  '无穷',  3,   9,     200,'(SUM,6)(LEV,6)',  234,  1800,  5, 55, 19,  5,  7, 20, 17,  4, 2);
INSERT INTO OptionInfo VALUES (19,'HP+4',   'Infinite',				  '复活',3,  12,     400,'(SUM,8)(LEV,8)',  231,   197,  6, 84, 20,  1,  1, 30, 18,  3, 3);
INSERT INTO OptionInfo VALUES (20,'HP+5',   'Immortal',				  '永恒',    3,  15,     800,'(SUM,10)(LEV,10)',228,     3, 20, 95,  0,  0,  0,  0, 19,  1, 4);
INSERT INTO OptionInfo VALUES (21,'MP+1',   'Soul',					  '心灵',      4,   5,     150,'(SUM,2)(LEV,2)',  255, 75000,  1, 10, 22, 31, 43,  5,  0, 12, 0);
INSERT INTO OptionInfo VALUES (22,'MP+2',   'Spirit',				  '精神',    4,  10,     200,'(SUM,4)(LEV,4)',  252, 23000,  2, 15, 23, 20, 26, 10, 21, 10, 1);
INSERT INTO OptionInfo VALUES (23,'MP+3',   'Will',					  '意志',        4,  15,     300,'(SUM,6)(LEV,6)',  249,  1750,  3, 43, 24,  6,  8, 20, 22,  5, 2);
INSERT INTO OptionInfo VALUES (24,'MP+4',   'Faith',				  '信赖',    4,  20,     500,'(SUM,8)(LEV,8)',  246,   240,  4, 67, 25,  2,  2, 30, 23,  3, 3);
INSERT INTO OptionInfo VALUES (25,'MP+5',   'Reliance',				  '信心',4,  25,    1000,'(SUM,10)(LEV,10)',243,    10, 20, 90,  0,  0,  0,  0, 24,  2, 4);
INSERT INTO OptionInfo VALUES (26,'HPSTL+1','Wraith',				  '鬼力',    5,   1,     200,'(SUM,5)(LEV,5)',  104, 80000, 97, 30, 27, 15, 21, 20,  0,  8, 0);
INSERT INTO OptionInfo VALUES (27,'HPSTL+2','Wight',				  '人力',    5,   2,     500,'(SUM,10)(LEV,10)', 99, 19999, 98, 60, 28,  6,  8, 30, 26,  2, 1);
INSERT INTO OptionInfo VALUES (28,'HPSTL+3','Incubus',				  '神力',  5,   3,    1000,'(SUM,15)(LEV,15)', 94,     1, 99, 94,  0,  0,  0,  0, 27,  1, 2);
INSERT INTO OptionInfo VALUES (29,'MPSTL+1','Lamia',				  '魔力',    6,   1,     200,'(SUM,5)(LEV,5)',   90, 80000, 97, 30, 30, 15, 21, 20,  0,  8, 0);
INSERT INTO OptionInfo VALUES (30,'MPSTL+2','Seiren',				  '灵力',    6,   2,     500,'(SUM,10)(LEV,10)', 85, 19999, 98, 60, 31,  6,  8, 30, 29,  2, 1);
INSERT INTO OptionInfo VALUES (31,'MPSTL+3','Succubus',				  '圣力',  6,   3,    1000,'(SUM,15)(LEV,15)', 80,     1, 99, 94,  0,  0,  0,  0, 30,  1, 2);
INSERT INTO OptionInfo VALUES (33,'HPRGN+2','Jupiter',				  '木星',    7,   3,     500,'(SUM,10)(LEV,10)',325,     0, 98, 0, 0,  0,  0, 0, 0, 0, 1);
INSERT INTO OptionInfo VALUES (34,'HPRGN+3','Uranus',				  '天王星',  7,   5,    1000,'(SUM,15)(LEV,15)',320,     0, 99, 0, 0,  0,  0, 0, 0, 0, 2);
INSERT INTO OptionInfo VALUES (35,'MPRGN+1','Pluto',				  '冥王星',    8,   1,     200,'(SUM,4)(LEV,4)',  315,     0, 97, 0, 0,  0,  0, 0, 0, 0, 0);
INSERT INTO OptionInfo VALUES (36,'MPRGN+2','Venus',				  '金星',    8,   3,     500,'(SUM,8)(LEV,8)',  310,     0, 98, 0, 0,  0,  0, 0, 0, 0, 1);
INSERT INTO OptionInfo VALUES (37,'MPRGN+3','Moon',					  '月亮',        8,   5,    1000,'(SUM,12)(LEV,12)',305,     0, 99, 0, 0,  0,  0, 0, 0, 0, 2);
INSERT INTO OptionInfo VALUES (38,'TOHIT+1','Pegasus',				  '飞马',  9,   1,     150,'(SUM,1)(LEV,1)',  255, 75000,  3, 10, 39, 31, 43,  5,  0, 12, 0);
INSERT INTO OptionInfo VALUES (39,'TOHIT+2','Gryphon',				  '狮鹫',    9,   2,     200,'(SUM,2)(LEV,2)',  252, 23000,  4, 23, 40, 20, 26, 10, 38, 10, 1);
INSERT INTO OptionInfo VALUES (40,'TOHIT+3','Chimera',				  '蝎狮',    9,   3,     300,'(SUM,3)(LEV,3)',  249,  1750,  5, 51, 41,  6,  8, 20, 39,  5, 2);
INSERT INTO OptionInfo VALUES (41,'TOHIT+4','Wyvern',				  '双足飞龙',    9,   4,     500,'(SUM,4)(LEV,4)',  246,   240,  6, 79, 42,  2,  2, 30, 40,  3, 3);
INSERT INTO OptionInfo VALUES (42,'TOHIT+5','Dragon',				  '黑龙',    9,   5,    1000,'(SUM,5)(LEV,5)',  243,    10, 20, 94,  0,  0,  0,  0, 41,  2, 4);
INSERT INTO OptionInfo VALUES (43,'DEF+1',  'Cockatrice',			  '毒蛇',10,  1,     150,'(SUM,1)(LEV,1)',  285, 75000,  2, 10, 44, 31, 43,  5,  0, 12, 0);
INSERT INTO OptionInfo VALUES (44,'DEF+2',  'Basilisk',				  '蛇怪',10,  2,     200,'(SUM,2)(LEV,2)',  282, 23000,  3, 22, 45, 20, 26, 10, 43, 10, 1);
INSERT INTO OptionInfo VALUES (45,'DEF+3',  'Gorgon',				  '女妖',    10,  3,     300,'(SUM,3)(LEV,3)',  279,  1750,  4, 48, 46,  6,  8, 20, 44,  5, 2);
INSERT INTO OptionInfo VALUES (46,'DEF+4',  'Medusa',				  '美杜莎',    10,  4,     500,'(SUM,4)(LEV,4)',  276,   240,  5, 75, 47,  2,  2, 30, 45,  3, 3);
INSERT INTO OptionInfo VALUES (47,'DEF+5',  'Behemoth',				  '比蒙巨兽',  10,  5,    1000,'(SUM,5)(LEV,5)',  273,    10, 20, 92,  0,  0,  0,  0, 46,  2, 4);
INSERT INTO OptionInfo VALUES (48,'DAM+1',  'Crushing',				  '猛烈',    11,  1,     150,'(SUM,2)(LEV,2)',  404, 75000,  4, 10, 49, 27, 37,  5,  0, 10, 0);
INSERT INTO OptionInfo VALUES (49,'DAM+2',  'Smashing',				  '粉碎',    11,  2,     250,'(SUM,4)(LEV,4)',  401, 23500,  5, 20, 50, 15, 21, 10, 48,  8, 1);
INSERT INTO OptionInfo VALUES (50,'DAM+3',  'Slaying',				  '屠杀',    11,  3,     500,'(SUM,6)(LEV,6)',  398,  1400,  6, 57, 51,  5,  7, 20, 49,  4, 2);
INSERT INTO OptionInfo VALUES (51,'DAM+4',  'Disruption',			  '破坏',  11,  4,    1000,'(SUM,8)(LEV,8)',  395,    99,  7, 88, 52,  1,  1, 30, 50,  3, 3);
INSERT INTO OptionInfo VALUES (52,'DAM+5',  'Destruction',			  '毁灭',11,  5,    2000,'(SUM,10)(LEV,10)',392,     1, 20, 96,  0,  0,  0,  0, 51,  1, 4);
INSERT INTO OptionInfo VALUES (53,'PRO+1',  'Protective',			  '保护',12,  1,     150,'(SUM,2)(LEV,2)',  344, 75000,  2, 10, 54, 31, 43,  5,  0, 12, 0);
INSERT INTO OptionInfo VALUES (54,'PRO+2',  'Shielded',				  '防御',    12,  2,     200,'(SUM,4)(LEV,4)',  341, 23000,  3, 25, 55, 20, 26, 10, 53, 10, 1);
INSERT INTO OptionInfo VALUES (55,'PRO+3',  'Guarded',				  '封闭',    12,  3,     300,'(SUM,6)(LEV,6)',  338,  1750,  4, 44, 56,  6,  8, 20, 54,  5, 2);
INSERT INTO OptionInfo VALUES (56,'PRO+4',  'Armored',				  '安全',    12,  4,     500,'(SUM,8)(LEV,8)',  335,   240,  5, 72, 57,  2,  2, 30, 55,  3, 3);
INSERT INTO OptionInfo VALUES (57,'PRO+5',  'Safe',					  '神佑',    12,  5,    1000,'(SUM,10)(LEV,10)',332,    10, 20, 91,  0,  0,  0,  0, 56,  2, 4);
INSERT INTO OptionInfo VALUES (58,'DUR+1',  'Hard',					  '坚硬',      13,120,     120,'',                329, 75000,  3, 10, 59, 31, 43,  5,  0, 13, 0);
INSERT INTO OptionInfo VALUES (59,'DUR+2',  'Solid',				  '牢固',    13,140,     150,'',                326, 23000,  4, 23, 60, 20, 26, 10, 58, 10, 1);
INSERT INTO OptionInfo VALUES (60,'DUR+3',  'Strong',				  '强壮',    13,160,     200,'',                323,  1500,  5, 51, 61,  6,  8, 20, 59,  6, 2);
INSERT INTO OptionInfo VALUES (61,'DUR+4',  'Iron',					  '金属',    13,180,     400,'',                320,   450,  6, 79, 62,  2,  2, 30, 60,  4, 3);
INSERT INTO OptionInfo VALUES (62,'DUR+5',  'Steel',				  '金钢',      13,200,     800,'',                317,    50, 20, 94,  0,  0,  0,  0, 61,  3, 4);
INSERT INTO OptionInfo VALUES (63,'PORES+1','Amber',				  '琥珀',      14,  5,     120,'(SUM,2)(LEV,2)',  269, 75000, 97, 30, 64, 17, 23, 20,  0, 13, 0);
INSERT INTO OptionInfo VALUES (64,'PORES+2','Opal',					  '红宝石',      14, 10,     150,'(SUM,4)(LEV,4)',  264, 19990, 98, 57, 65,  7,  9, 30, 63,  6, 1);