All pastes #590845 Raw Edit

Untitled

public text v1 · immutable
#590845 ·published 2007-06-26 20:21 UTC
rendered paste body
+-----------------------+---------------------+------+-----+---------+-------+
| Field                 | Type                | Null | Key | Default | Extra |
+-----------------------+---------------------+------+-----+---------+-------+
| entry                 | int(11) unsigned    | NO   | PRI | 0       |       |
| ZoneOrSort            | int(11)             | NO   |     | 0       |       |
| MinLevel              | int(11) unsigned    | NO   |     | 0       |       |
| QuestLevel            | int(11) unsigned    | NO   |     | 0       |       |
| Type                  | int(11) unsigned    | NO   |     | 0       |       |
| RequiredRaces         | int(11) unsigned    | NO   |     | 0       |       |
| RequiredSkillValue    | int(11) unsigned    | NO   |     | 1       |       |
| RequiredRepFaction    | int(11) unsigned    | NO   |     | 0       |       |
| RequiredRepValue      | int(11) unsigned    | NO   |     | 0       |       |
| SuggestedPlayers      | int(11) unsigned    | NO   |     | 0       |       |
| LimitTime             | int(11) unsigned    | NO   |     | 0       |       |
| SpecialFlags          | int(11) unsigned    | NO   |     | 0       |       |
| PrevQuestId           | int(11)             | NO   |     | 0       |       |
| NextQuestId           | int(11)             | NO   |     | 0       |       |
| ExclusiveGroup        | int(11) unsigned    | NO   |     | 0       |       |
| NextQuestInChain      | int(11) unsigned    | NO   |     | 0       |       |
| SrcItemId             | int(11) unsigned    | NO   |     | 0       |       |
| SrcItemCount          | int(11) unsigned    | NO   |     | 0       |       |
| SrcSpell              | int(11) unsigned    | NO   |     | 0       |       |
| Title                 | text                | YES  |     | NULL    |       |
| Details               | text                | YES  |     | NULL    |       |
| Objectives            | text                | YES  |     | NULL    |       |
| OfferRewardText       | text                | YES  |     | NULL    |       |
| RequestItemsText      | text                | YES  |     | NULL    |       |
| EndText               | text                | YES  |     | NULL    |       |
| ObjectiveText1        | text                | YES  |     | NULL    |       |
| ObjectiveText2        | text                | YES  |     | NULL    |       |
| ObjectiveText3        | text                | YES  |     | NULL    |       |
| ObjectiveText4        | text                | YES  |     | NULL    |       |
| ReqItemId1            | int(11) unsigned    | NO   |     | 0       |       |
| ReqItemId2            | int(11) unsigned    | NO   |     | 0       |       |
| ReqItemId3            | int(11) unsigned    | NO   |     | 0       |       |
| ReqItemId4            | int(11) unsigned    | NO   |     | 0       |       |
| ReqItemCount1         | int(11) unsigned    | NO   |     | 0       |       |
| ReqItemCount2         | int(11) unsigned    | NO   |     | 0       |       |
| ReqItemCount3         | int(11) unsigned    | NO   |     | 0       |       |
| ReqItemCount4         | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceCount1       | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceCount2       | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceCount3       | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceCount4       | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceId1          | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceId2          | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceId3          | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceId4          | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceRef1         | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceRef2         | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceRef3         | int(11) unsigned    | NO   |     | 0       |       |
| ReqSourceRef4         | int(11) unsigned    | NO   |     | 0       |       |
| ReqCreatureOrGOId1    | int(11)             | NO   |     | 0       |       |
| ReqCreatureOrGOId2    | int(11)             | NO   |     | 0       |       |
| ReqCreatureOrGOId3    | int(11)             | NO   |     | 0       |       |
| ReqCreatureOrGOId4    | int(11)             | NO   |     | 0       |       |
| ReqCreatureOrGOCount1 | int(11) unsigned    | NO   |     | 0       |       |
| ReqCreatureOrGOCount2 | int(11) unsigned    | NO   |     | 0       |       |
| ReqCreatureOrGOCount3 | int(11) unsigned    | NO   |     | 0       |       |
| ReqCreatureOrGOCount4 | int(11) unsigned    | NO   |     | 0       |       |
| ReqSpellCast1         | int(11) unsigned    | NO   |     | 0       |       |
| ReqSpellCast2         | int(11) unsigned    | NO   |     | 0       |       |
| ReqSpellCast3         | int(11) unsigned    | NO   |     | 0       |       |
| ReqSpellCast4         | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemId1      | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemId2      | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemId3      | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemId4      | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemId5      | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemId6      | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemCount1   | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemCount2   | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemCount3   | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemCount4   | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemCount5   | int(11) unsigned    | NO   |     | 0       |       |
| RewChoiceItemCount6   | int(11) unsigned    | NO   |     | 0       |       |
| RewItemId1            | int(11) unsigned    | NO   |     | 0       |       |
| RewItemId2            | int(11) unsigned    | NO   |     | 0       |       |
| RewItemId3            | int(11) unsigned    | NO   |     | 0       |       |
| RewItemId4            | int(11) unsigned    | NO   |     | 0       |       |
| RewItemCount1         | int(11) unsigned    | NO   |     | 0       |       |
| RewItemCount2         | int(11) unsigned    | NO   |     | 0       |       |
| RewItemCount3         | int(11) unsigned    | NO   |     | 0       |       |
| RewItemCount4         | int(11) unsigned    | NO   |     | 0       |       |
| RewRepFaction1        | int(11) unsigned    | NO   |     | 0       |       |
| RewRepFaction2        | int(11) unsigned    | NO   |     | 0       |       |
| RewRepFaction3        | int(11) unsigned    | NO   |     | 0       |       |
| RewRepFaction4        | int(11) unsigned    | NO   |     | 0       |       |
| RewRepFaction5        | int(11) unsigned    | NO   |     | 0       |       |
| RewRepValue1          | int(11)             | NO   |     | 0       |       |
| RewRepValue2          | int(11)             | NO   |     | 0       |       |
| RewRepValue3          | int(11)             | NO   |     | 0       |       |
| RewRepValue4          | int(11)             | NO   |     | 0       |       |
| RewRepValue5          | int(11)             | NO   |     | 0       |       |
| RewOrReqMoney         | int(11)             | NO   |     | 0       |       |
| RewXpOrMoney          | int(11) unsigned    | NO   |     | 0       |       |
| RewSpell              | int(11) unsigned    | NO   |     | 0       |       |
| PointMapId            | int(11) unsigned    | NO   |     | 0       |       |
| PointX                | float               | NO   |     | 0       |       |
| PointY                | float               | NO   |     | 0       |       |
| PointOpt              | int(2) unsigned     | NO   |     | 0       |       |
| DetailsEmote1         | int(11)             | NO   |     | 0       |       |
| DetailsEmote2         | int(11)             | NO   |     | 0       |       |
| DetailsEmote3         | int(11)             | NO   |     | 0       |       |
| DetailsEmote4         | int(11)             | NO   |     | 0       |       |
| IncompleteEmote       | int(11) unsigned    | NO   |     | 0       |       |
| CompleteEmote         | int(11) unsigned    | NO   |     | 1       |       |
| OfferRewardEmote1     | int(11)             | NO   |     | 0       |       |
| OfferRewardEmote2     | int(11)             | NO   |     | 0       |       |
| OfferRewardEmote3     | int(11)             | NO   |     | 0       |       |
| OfferRewardEmote4     | int(11)             | NO   |     | 0       |       |
| StartScript           | int(11) unsigned    | NO   |     | 0       |       |
| CompleteScript        | int(11) unsigned    | NO   |     | 0       |       |
| Repeatable            | tinyint(1) unsigned | NO   |     | 0       |       |
+-----------------------+---------------------+------+-----+---------+-------+