holidays
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | int | unsigned | PRI | NO | 0 | ||
| Region | smallint | unsigned | NO | 0 | |||
| Looping | tinyint | unsigned | NO | 0 | |||
| HolidayNameID | int | unsigned | NO | 0 | |||
| HolidayDescriptionID | int | unsigned | NO | 0 | |||
| Priority | tinyint | unsigned | NO | 0 | |||
| CalendarFilterType | tinyint | signed | NO | 0 | |||
| Flags | tinyint | unsigned | NO | 0 | |||
| Duration1 | smallint | unsigned | NO | 0 | |||
| Duration2 | smallint | unsigned | NO | 0 | |||
| Duration3 | smallint | unsigned | NO | 0 | |||
| Duration4 | smallint | unsigned | NO | 0 | |||
| Duration5 | smallint | unsigned | NO | 0 | |||
| Duration6 | smallint | unsigned | NO | 0 | |||
| Duration7 | smallint | unsigned | NO | 0 | |||
| Duration8 | smallint | unsigned | NO | 0 | |||
| Duration9 | smallint | unsigned | NO | 0 | |||
| Duration10 | smallint | unsigned | NO | 0 | |||
| Date1 | int | unsigned | NO | 0 | |||
| Date2 | int | unsigned | NO | 0 | |||
| Date3 | int | unsigned | NO | 0 | |||
| Date4 | int | unsigned | NO | 0 | |||
| Date5 | int | unsigned | NO | 0 | |||
| Date6 | int | unsigned | NO | 0 | |||
| Date7 | int | unsigned | NO | 0 | |||
| Date8 | int | unsigned | NO | 0 | |||
| Date9 | int | unsigned | NO | 0 | |||
| Date10 | int | unsigned | NO | 0 | |||
| Date11 | int | unsigned | NO | 0 | |||
| Date12 | int | unsigned | NO | 0 | |||
| Date13 | int | unsigned | NO | 0 | |||
| Date14 | int | unsigned | NO | 0 | |||
| Date15 | int | unsigned | NO | 0 | |||
| Date16 | int | unsigned | NO | 0 | |||
| Date17 | int | unsigned | NO | 0 | |||
| Date18 | int | unsigned | NO | 0 | |||
| Date19 | int | unsigned | NO | 0 | |||
| Date20 | int | unsigned | NO | 0 | |||
| Date21 | int | unsigned | NO | 0 | |||
| Date22 | int | unsigned | NO | 0 | |||
| Date23 | int | unsigned | NO | 0 | |||
| Date24 | int | unsigned | NO | 0 | |||
| Date25 | int | unsigned | NO | 0 | |||
| Date26 | int | unsigned | NO | 0 | |||
| CalendarFlags1 | tinyint | unsigned | NO | 0 | |||
| CalendarFlags2 | tinyint | unsigned | NO | 0 | |||
| CalendarFlags3 | tinyint | unsigned | NO | 0 | |||
| CalendarFlags4 | tinyint | unsigned | NO | 0 | |||
| CalendarFlags5 | tinyint | unsigned | NO | 0 | |||
| CalendarFlags6 | tinyint | unsigned | NO | 0 | |||
| CalendarFlags7 | tinyint | unsigned | NO | 0 | |||
| CalendarFlags8 | tinyint | unsigned | NO | 0 | |||
| CalendarFlags9 | tinyint | unsigned | NO | 0 | |||
| CalendarFlags10 | tinyint | unsigned | NO | 0 | |||
| TextureFileDataID1 | int | signed | NO | 0 | |||
| TextureFileDataID2 | int | signed | NO | 0 | |||
| TextureFileDataID3 | int | signed | NO | 0 | |||
| VerifiedBuild | int | signed | PRI | NO | 0 | ||
Description of fields
ID
- no description -
Region
- no description -
Looping
- no description -
HolidayNameID
- no description -
HolidayDescriptionID
- no description -
Priority
- no description -
CalendarFilterType
- no description -
Flags
- no description -
Duration1
- no description -
Duration2
- no description -
Duration3
- no description -
Duration4
- no description -
Duration5
- no description -
Duration6
- no description -
Duration7
- no description -
Duration8
- no description -
Duration9
- no description -
Duration10
- no description -
Date1
- no description -
Date2
- no description -
Date3
- no description -
Date4
- no description -
Date5
- no description -
Date6
- no description -
Date7
- no description -
Date8
- no description -
Date9
- no description -
Date10
- no description -
Date11
- no description -
Date12
- no description -
Date13
- no description -
Date14
- no description -
Date15
- no description -
Date16
- no description -
Date17
- no description -
Date18
- no description -
Date19
- no description -
Date20
- no description -
Date21
- no description -
Date22
- no description -
Date23
- no description -
Date24
- no description -
Date25
- no description -
Date26
- no description -
CalendarFlags1
- no description -
CalendarFlags2
- no description -
CalendarFlags3
- no description -
CalendarFlags4
- no description -
CalendarFlags5
- no description -
CalendarFlags6
- no description -
CalendarFlags7
- no description -
CalendarFlags8
- no description -
CalendarFlags9
- no description -
CalendarFlags10
- no description -
TextureFileDataID1
- no description -
TextureFileDataID2
- no description -
TextureFileDataID3
- no description -
VerifiedBuild
This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.
If value is 0 then it has not been parsed yet.
If value is above 0 then it has been parsed with WDB files from that specific client build.
If value is -1 then it is just a place holder until proper data are found on WDBs.
If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.
