mail_text_template Table¶
Defines mail body text with localized support.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
entry |
mediumint(8) unsigned | PRI | NO | 0 | |
content_default |
text | NO | |||
content_loc1 |
text | YES | |||
content_loc2 |
text | YES | |||
content_loc3 |
text | YES | |||
content_loc4 |
text | YES | |||
content_loc5 |
text | YES | |||
content_loc6 |
text | YES | |||
content_loc7 |
text | YES |
Field Breakdown¶
entry- Primary Key. Mail template id referenced by reward/game systems.content_default- Default text (English).content_loc1- Localized body text; subject/subject_locN may exist depending on schema revision.content_loc2- Localized body text; subject/subject_locN may exist depending on schema revision.content_loc3- Localized body text; subject/subject_locN may exist depending on schema revision.content_loc4- Localized body text; subject/subject_locN may exist depending on schema revision.content_loc5- Localized body text; subject/subject_locN may exist depending on schema revision.content_loc6- Localized body text; subject/subject_locN may exist depending on schema revision.content_loc7- Localized body text; subject/subject_locN may exist depending on schema revision.