createeventtreeinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateEventTreeInfo.sql
#  Description : 农府胶付胶 飘府 酒捞袍 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.09.13    硅犁屈          积己
################################################################################


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

CREATE TABLE EventTreeInfo (
  ItemType 		tinyint(3) 	unsigned NOT NULL default '0',
  Name 			varchar(30)			 NOT NULL default '',
  EName 		varchar(30)			 NOT NULL default '',
  Price 		int(10) 	unsigned NOT NULL default '0',
  Volume 		tinyint(3) 	unsigned NOT NULL default '0',
  Weight 		tinyint(3) 	unsigned NOT NULL default '0',
  Ratio 		int(11) 	 		 NOT NULL default '0',
  ItemLevel 	tinyint(3) 	unsigned NOT NULL default '0',

  PRIMARY KEY  (ItemType)

) TYPE=MyISAM;


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



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



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



################################################################################
# 单捞磐 持扁
INSERT INTO EventTreeInfo VALUES ( 0,'Part Santa of Christmas Tree',	'Part Santa of Christmas Tree',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES ( 1,'Part Rudolph of Christmas Tree',	'Part Rudolph of Christmas Tree', 0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES ( 2,'Part Gift of Christmas Tree ',	'Part Gift of Christmas Tree',    0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES ( 3,'Part Party of Christmas Tree ',	'Part Party of Christmas Tree',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES ( 4,'Part Tree of Christmas Tree ',  'Part Tree of Christmas Tree',    0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES ( 5,'Part Card of Christmas Tree ',  'Part Card of Christmas Tree',    0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES ( 6,'Part Carol of Christmas Tree ',  'Part Carol of Christmas Tree',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES ( 7,'Part Seal of Christmas Tree ',	'Part Seal of Christmas Tree',    0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES ( 8,'Part Snow of Christmas Tree ',	'Part Snow of Christmas Tree',    0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES ( 9,'Part Sleigh of Christmas Tree ',	'Part Sleigh of Christmas Tree',  0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (10,'Part Star of Christmas Tree ',	'Part Star of Christmas Tree',    0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (11,'Part o Angel f Christmas Tree ',	'Part Angel of Christmas Tree',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (12,'圣诞树',         'Christmas Tree',                     0, 6, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (13,'古老石碑碎片Q部分',	'Part Q Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (14,'古老石碑碎片A部分',	'Part A Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (15,'古老石碑碎片Z部分',	'Part Z Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (16,'古老石碑碎片W部分',	'Part W Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (17,'古老石碑碎片S部分',	'Part S Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (18,'古老石碑碎片X部分',	'Part X Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (19,'古老石碑碎片E部分',	'Part E Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (20,'古老石碑碎片D部分',	'Part D Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (21,'古老石碑碎片C部分',	'Part C Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (22,'古老石碑碎片R部分',	'Part R Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (23,'古老石碑碎片F部分',	'Part F Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (24,'古老石碑碎片V部分',	'Part V Ancient Document',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (25,'古老石碑',	'Ancient Document',   0, 6, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (26,'路标1',	'Signpost 1',   4000000, 2, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (27,'路标2',	'Signpost 2',   6000000, 2, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (28,'路标3',	'Signpost 3',   8000000, 2, 1, 0, 0);

INSERT INTO EventTreeInfo VALUES (29,'粘土娃娃的碎片1',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (30,'粘土娃娃的碎片2',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (31,'粘土娃娃的碎片3',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (32,'粘土娃娃的碎片4',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (33,'粘土娃娃的碎片5',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (34,'粘土娃娃的碎片6',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (35,'粘土娃娃的碎片7',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (36,'粘土娃娃的碎片8',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (37,'粘土娃娃的碎片9',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (38,'粘土娃娃的碎片10',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (39,'粘土娃娃的碎片11',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (40,'粘土娃娃的碎片12',	'Part Of Clay Doll',   0, 1, 1, 0, 0);
INSERT INTO EventTreeInfo VALUES (41,'粘土娃娃',	'Clay Doll',   0, 6, 1, 0, 0);