· 7 years ago · Dec 15, 2018, 12:00 AM
1CREATE TABLE IF NOT EXISTS `charquest_1` (
2 `CharID` int(10) unsigned NOT NULL default '0',
3 `SourceLabel` int(10) unsigned NOT NULL default '0',
4 `SourceID` int(10) unsigned NOT NULL default '0',
5 `TimeStart` int(10) unsigned NOT NULL default '0',
6 `Duration` int(10) unsigned NOT NULL default '0',
7 `NPCID` int(10) unsigned NOT NULL default '0',
8 `EnemyID1` int(10) unsigned NOT NULL default '0',
9 `EnemyID2` int(10) unsigned NOT NULL default '0',
10 `EnemyID3` int(10) unsigned NOT NULL default '0',
11 `EnemyID4` int(10) unsigned NOT NULL default '0',
12 `EnemyID5` int(10) unsigned NOT NULL default '0',
13 `LabelID1` int(10) unsigned NOT NULL default '0',
14 `LabelID2` int(10) unsigned NOT NULL default '0',
15 `LabelID3` int(10) unsigned NOT NULL default '0',
16 `LabelID4` int(10) unsigned NOT NULL default '0',
17 `LabelID5` int(10) unsigned NOT NULL default '0',
18 `ItemID1` int(10) unsigned NOT NULL default '0',
19 `ItemID2` int(10) unsigned NOT NULL default '0',
20 `ItemID3` int(10) unsigned NOT NULL default '0',
21 `ItemID4` int(10) unsigned NOT NULL default '0',
22 `ItemID5` int(10) unsigned NOT NULL default '0',
23 `XP` int(10) unsigned NOT NULL default '0',
24 `TreasureItemID1` int(10) unsigned NOT NULL default '0',
25 `TreasureItemID2` int(10) unsigned NOT NULL default '0',
26 `TreasureItemID3` int(10) unsigned NOT NULL default '0',
27 `TreasureItemID4` int(10) unsigned NOT NULL default '0',
28 `TreasureItemID5` int(10) unsigned NOT NULL default '0',
29 `Radius` float(10,5) default '0.00000',
30 `QuestStringID1` smallint(5) unsigned default '0',
31 `QuestParam1ID1` int(10) unsigned default '0',
32 `QuestParam2ID1` int(10) unsigned default '0',
33 `QuestParam3ID1` int(10) unsigned default '0',
34 `QuestParam4ID1` int(10) unsigned default '0',
35 `QuestParam5ID1` int(10) unsigned default '0',
36 `QuestStringID2` smallint(5) unsigned default '0',
37 `QuestParam1ID2` int(10) unsigned default '0',
38 `QuestParam2ID2` int(10) unsigned default '0',
39 `QuestParam3ID2` int(10) unsigned default '0',
40 `QuestParam4ID2` int(10) unsigned default '0',
41 `QuestParam5ID2` int(10) unsigned default '0',
42 `QuestStringID3` smallint(5) unsigned default '0',
43 `QuestParam1ID3` int(10) unsigned default '0',
44 `QuestParam2ID3` int(10) unsigned default '0',
45 `QuestParam3ID3` int(10) unsigned default '0',
46 `QuestParam4ID3` int(10) unsigned default '0',
47 `QuestParam5ID3` int(10) unsigned default '0',
48 `QuestStringID4` smallint(5) unsigned default '0',
49 `QuestParam1ID4` int(10) unsigned default '0',
50 `QuestParam2ID4` int(10) unsigned default '0',
51 `QuestParam3ID4` int(10) unsigned default '0',
52 `QuestParam4ID4` int(10) unsigned default '0',
53 `QuestParam5ID4` int(10) unsigned default '0',
54 `QuestStringID5` smallint(5) unsigned default '0',
55 `QuestParam1ID5` int(10) unsigned default '0',
56 `QuestParam2ID5` int(10) unsigned default '0',
57 `QuestParam3ID5` int(10) unsigned default '0',
58 `QuestParam4ID5` int(10) unsigned default '0',
59 `QuestParam5ID5` int(10) unsigned default '0',
60 `QuestStringID6` smallint(5) unsigned default '0',
61 `QuestParam1ID6` int(10) unsigned default '0',
62 `QuestParam2ID6` int(10) unsigned default '0',
63 `QuestParam3ID6` int(10) unsigned default '0',
64 `QuestParam4ID6` int(10) unsigned default '0',
65 `QuestParam5ID6` int(10) unsigned default '0',
66 `QuestStringID7` smallint(5) unsigned default '0',
67 `QuestParam1ID7` int(10) unsigned default '0',
68 `QuestParam2ID7` int(10) unsigned default '0',
69 `QuestParam3ID7` int(10) unsigned default '0',
70 `QuestParam4ID7` int(10) unsigned default '0',
71 `QuestParam5ID7` int(10) unsigned default '0',
72 `Type` int(10) unsigned NOT NULL default '0',
73 `State` tinyint(3) unsigned NOT NULL default '0',
74 `LocID1` smallint(5) unsigned NOT NULL default '0',
75 `LocID2` smallint(5) unsigned NOT NULL default '0',
76 `LocID3` smallint(5) unsigned NOT NULL default '0',
77 `LocID4` smallint(5) unsigned NOT NULL default '0',
78 `LocID5` smallint(5) unsigned NOT NULL default '0',
79 `Difficulty` tinyint(3) unsigned NOT NULL default '0',
80 `ReturnFlag` tinyint(3) unsigned NOT NULL default '0',
81 `Enemy1Count` tinyint(3) unsigned NOT NULL default '0',
82 `Enemy2Count` tinyint(3) unsigned NOT NULL default '0',
83 `Enemy3Count` tinyint(3) unsigned NOT NULL default '0',
84 `Enemy4Count` tinyint(3) unsigned NOT NULL default '0',
85 `Enemy5Count` tinyint(3) unsigned NOT NULL default '0',
86 `Item1Count` tinyint(3) unsigned NOT NULL default '0',
87 `Item2Count` tinyint(3) unsigned NOT NULL default '0',
88 `Item3Count` tinyint(3) unsigned NOT NULL default '0',
89 `Item4Count` tinyint(3) unsigned NOT NULL default '0',
90 `Item5Count` tinyint(3) unsigned NOT NULL default '0',
91 `TreasureQuantity1` tinyint(3) unsigned NOT NULL default '0',
92 `TreasureQuantity2` tinyint(3) unsigned NOT NULL default '0',
93 `TreasureQuantity3` tinyint(3) unsigned NOT NULL default '0',
94 `TreasureQuantity4` tinyint(3) unsigned NOT NULL default '0',
95 `TreasureQuantity5` tinyint(3) unsigned NOT NULL default '0',
96 `Gold` smallint(5) unsigned default '0',
97 `ChainToTag` int(10) unsigned default '0',
98 `ChainStringID` smallint(5) unsigned default '0',
99 `LastQuestCount` tinyint(3) unsigned default '0',
100 `LastQuest1` int(10) unsigned default '0',
101 `LastQuest2` int(10) unsigned default '0',
102 `LastQuest3` int(10) unsigned default '0',
103 `LastQuest4` int(10) unsigned default '0',
104 `LastQuest5` int(10) unsigned default '0',
105 `LastQuest6` int(10) unsigned default '0',
106 `LastQuest7` int(10) unsigned default '0',
107 `LastQuest8` int(10) unsigned default '0',
108 `LastQuest9` int(10) unsigned default '0',
109 `LastQuest10` int(10) unsigned default '0',
110 `LastQuestIndex` int(10) unsigned default '0',
111 `LocStr` smallint(5) unsigned default '0',
112 PRIMARY KEY (`CharID`),
113 KEY `charid` (`CharID`)
114) ENGINE=MyISAM DEFAULT CHARSET=latin1