Page Menu
Home
WickedGov Phorge
Search
Configure Global Search
Log In
Files
F4123395
tables.json
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
19 KB
Referenced Files
None
Subscribers
None
tables.json
View Options
[
{
"name"
:
"cn_notices"
,
"columns"
:
[
{
"name"
:
"not_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"not_name"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
255
}
},
{
"name"
:
"not_start"
,
"type"
:
"mwtimestamp"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"not_end"
,
"type"
:
"mwtimestamp"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"not_enabled"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"not_preferred"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"not_throttle"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"default"
:
100
}
},
{
"name"
:
"not_locked"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"not_geo"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"not_buckets"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
1
}
},
{
"name"
:
"not_weight"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"default"
:
100
}
},
{
"name"
:
"not_mobile_carrier"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"not_archived"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"not_type"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
}
],
"indexes"
:
[],
"pk"
:
[
"not_id"
]
},
{
"name"
:
"cn_assignments"
,
"columns"
:
[
{
"name"
:
"asn_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"not_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"tmp_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"tmp_weight"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"asn_bucket"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
,
"default"
:
0
}
}
],
"indexes"
:
[
{
"name"
:
"asn_not"
,
"columns"
:
[
"not_id"
],
"unique"
:
false
},
{
"name"
:
"asn_tmp"
,
"columns"
:
[
"tmp_id"
],
"unique"
:
false
},
{
"name"
:
"asn_bucket"
,
"columns"
:
[
"asn_bucket"
],
"unique"
:
false
}
],
"pk"
:
[
"asn_id"
]
},
{
"name"
:
"cn_templates"
,
"columns"
:
[
{
"name"
:
"tmp_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"tmp_name"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"tmp_display_anon"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
1
}
},
{
"name"
:
"tmp_display_account"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
1
}
},
{
"name"
:
"tmp_fundraising"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"tmp_autolink"
,
"comment"
:
"Note: no longer used"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"tmp_landing_pages"
,
"comment"
:
"Note: no longer used"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"tmp_archived"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"tmp_category"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"tmp_preview_sandbox"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"tmp_is_template"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
}
],
"indexes"
:
[
{
"name"
:
"tmp_name"
,
"columns"
:
[
"tmp_name"
],
"unique"
:
false
},
{
"name"
:
"tmp_category"
,
"columns"
:
[
"tmp_category"
],
"unique"
:
false
}
],
"pk"
:
[
"tmp_id"
]
},
{
"name"
:
"cn_notice_languages"
,
"columns"
:
[
{
"name"
:
"nl_notice_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"nl_language"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
32
}
}
],
"indexes"
:
[],
"pk"
:
[
"nl_notice_id"
,
"nl_language"
]
},
{
"name"
:
"cn_notice_projects"
,
"columns"
:
[
{
"name"
:
"np_notice_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"np_project"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
32
}
}
],
"indexes"
:
[],
"pk"
:
[
"np_notice_id"
,
"np_project"
]
},
{
"name"
:
"cn_notice_countries"
,
"columns"
:
[
{
"name"
:
"nc_notice_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"nc_country"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
2
}
}
],
"indexes"
:
[],
"pk"
:
[
"nc_notice_id"
,
"nc_country"
]
},
{
"name"
:
"cn_notice_regions"
,
"columns"
:
[
{
"name"
:
"nr_notice_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"nr_region"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
6
}
}
],
"indexes"
:
[],
"pk"
:
[
"nr_notice_id"
,
"nr_region"
]
},
{
"name"
:
"cn_template_mixins"
,
"columns"
:
[
{
"name"
:
"tmxn_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"tmp_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"page_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"mixin_name"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
255
}
}
],
"indexes"
:
[
{
"name"
:
"tmxn_tmp_id"
,
"columns"
:
[
"tmp_id"
],
"unique"
:
false
},
{
"name"
:
"tmxn_page_id"
,
"columns"
:
[
"page_id"
],
"unique"
:
false
},
{
"name"
:
"tmxn_mixin_name"
,
"columns"
:
[
"mixin_name"
],
"unique"
:
false
}
],
"pk"
:
[
"tmxn_id"
]
},
{
"name"
:
"cn_notice_mixins"
,
"columns"
:
[
{
"name"
:
"nmxn_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"nmxn_not_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"nmxn_mixin_name"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
255
}
},
{
"name"
:
"nmxn_enabled"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
1
,
"default"
:
0
}
}
],
"indexes"
:
[
{
"name"
:
"nmxn_not_id_idx"
,
"columns"
:
[
"nmxn_not_id"
],
"unique"
:
false
},
{
"name"
:
"nmxn_mixin_name_idx"
,
"columns"
:
[
"nmxn_mixin_name"
],
"unique"
:
false
},
{
"name"
:
"nmxn_not_id_mixin_name"
,
"columns"
:
[
"nmxn_not_id"
,
"nmxn_mixin_name"
],
"unique"
:
true
}
],
"pk"
:
[
"nmxn_id"
]
},
{
"name"
:
"cn_notice_mixin_params"
,
"columns"
:
[
{
"name"
:
"nmxnp_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"nmxnp_notice_mixin_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"nmxnp_param_name"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
255
}
},
{
"name"
:
"nmxnp_param_value"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
65530
}
}
],
"indexes"
:
[
{
"name"
:
"nmxnp_notice_mixin_id_idx"
,
"columns"
:
[
"nmxnp_notice_mixin_id"
],
"unique"
:
false
},
{
"name"
:
"nmxnp_param_name_value_idx"
,
"columns"
:
[
"nmxnp_param_name"
,
"nmxnp_param_value"
],
"options"
:
{
"lengths"
:
[
null
,
50
]
},
"unique"
:
false
},
{
"name"
:
"nmxn_notice_mixin_id_param_name"
,
"columns"
:
[
"nmxnp_notice_mixin_id"
,
"nmxnp_param_name"
],
"unique"
:
true
}
],
"pk"
:
[
"nmxnp_id"
]
},
{
"name"
:
"cn_known_devices"
,
"columns"
:
[
{
"name"
:
"dev_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"dev_name"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
255
}
},
{
"name"
:
"dev_display_label"
,
"type"
:
"binary"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
255
}
}
],
"indexes"
:
[
{
"name"
:
"dev_name"
,
"columns"
:
[
"dev_name"
],
"unique"
:
false
}
],
"pk"
:
[
"dev_id"
]
},
{
"name"
:
"cn_template_devices"
,
"columns"
:
[
{
"name"
:
"tdev_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"tmp_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"dev_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
}
],
"indexes"
:
[
{
"name"
:
"tdev_template_id"
,
"columns"
:
[
"tmp_id"
],
"unique"
:
false
}
],
"pk"
:
[
"tdev_id"
]
},
{
"name"
:
"cn_known_mobile_carriers"
,
"columns"
:
[
{
"name"
:
"mc_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"mc_name"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
255
}
},
{
"name"
:
"mc_display_label"
,
"type"
:
"binary"
,
"options"
:
{
"notnull"
:
true
,
"length"
:
255
}
}
],
"indexes"
:
[
{
"name"
:
"mc_name"
,
"columns"
:
[
"mc_name"
],
"unique"
:
false
}
],
"pk"
:
[
"mc_id"
]
},
{
"name"
:
"cn_notice_mobile_carriers"
,
"columns"
:
[
{
"name"
:
"nmc_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
}
},
{
"name"
:
"not_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"mc_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
}
}
],
"indexes"
:
[
{
"name"
:
"nmc_not_id"
,
"columns"
:
[
"not_id"
],
"unique"
:
false
},
{
"name"
:
"nmc_carrier_id"
,
"columns"
:
[
"mc_id"
],
"unique"
:
false
}
],
"pk"
:
[
"nmc_id"
]
},
{
"name"
:
"cn_notice_log"
,
"columns"
:
[
{
"name"
:
"notlog_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"notlog_timestamp"
,
"type"
:
"mwtimestamp"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"notlog_user_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"notlog_action"
,
"type"
:
"mwenum"
,
"options"
:
{
"notnull"
:
true
,
"PlatformOptions"
:
{
"enum_values"
:
[
"created"
,
"modified"
,
"removed"
]
},
"default"
:
"modified"
}
},
{
"name"
:
"notlog_not_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"notlog_not_name"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"notlog_begin_projects"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"notlog_end_projects"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"notlog_begin_languages"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_end_languages"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_begin_countries"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_end_countries"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_begin_regions"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_end_regions"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_begin_start"
,
"type"
:
"mwtimestamp"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_end_start"
,
"type"
:
"mwtimestamp"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_begin_end"
,
"type"
:
"mwtimestamp"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_end_end"
,
"type"
:
"mwtimestamp"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_begin_enabled"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_end_enabled"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_begin_preferred"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_end_preferred"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_begin_throttle"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_end_throttle"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_begin_locked"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_end_locked"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_begin_geo"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_end_geo"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_begin_banners"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_end_banners"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_begin_buckets"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_end_buckets"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"notlog_begin_mobile_carrier"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_end_mobile_carrier"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_begin_weight"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_end_weight"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_begin_archived"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_end_archived"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
}
},
{
"name"
:
"notlog_begin_mixins"
,
"type"
:
"blob"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_end_mixins"
,
"type"
:
"blob"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"notlog_comment"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"notlog_begin_type"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"notlog_end_type"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
}
],
"indexes"
:
[
{
"name"
:
"notlog_timestamp"
,
"columns"
:
[
"notlog_timestamp"
],
"unique"
:
false
},
{
"name"
:
"notlog_user_id"
,
"columns"
:
[
"notlog_user_id"
,
"notlog_timestamp"
],
"unique"
:
false
},
{
"name"
:
"notlog_not_id"
,
"columns"
:
[
"notlog_not_id"
,
"notlog_timestamp"
],
"unique"
:
false
}
],
"pk"
:
[
"notlog_id"
]
},
{
"name"
:
"cn_template_log"
,
"columns"
:
[
{
"name"
:
"tmplog_id"
,
"type"
:
"integer"
,
"options"
:
{
"autoincrement"
:
true
,
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"tmplog_timestamp"
,
"type"
:
"mwtimestamp"
,
"options"
:
{
"notnull"
:
true
}
},
{
"name"
:
"tmplog_user_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"tmplog_action"
,
"type"
:
"mwenum"
,
"options"
:
{
"notnull"
:
true
,
"PlatformOptions"
:
{
"enum_values"
:
[
"created"
,
"modified"
,
"removed"
]
},
"default"
:
"modified"
}
},
{
"name"
:
"tmplog_template_id"
,
"type"
:
"integer"
,
"options"
:
{
"notnull"
:
true
,
"unsigned"
:
true
}
},
{
"name"
:
"tmplog_template_name"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"tmplog_begin_anon"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_end_anon"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_begin_account"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_end_account"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_begin_fundraising"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_end_fundraising"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_begin_autolink"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_end_autolink"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_begin_landingpages"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"tmplog_end_landingpages"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"tmplog_content_change"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
,
"default"
:
0
}
},
{
"name"
:
"tmplog_begin_prioritylangs"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"tmplog_end_prioritylangs"
,
"type"
:
"text"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
65530
}
},
{
"name"
:
"tmplog_begin_archived"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_end_archived"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_begin_category"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"tmplog_end_category"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
},
{
"name"
:
"tmplog_begin_preview_sandbox"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_end_preview_sandbox"
,
"type"
:
"mwtinyint"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
1
}
},
{
"name"
:
"tmplog_begin_controller_mixin"
,
"type"
:
"binary"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
4096
}
},
{
"name"
:
"tmplog_end_controller_mixin"
,
"type"
:
"binary"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
4096
}
},
{
"name"
:
"tmplog_begin_devices"
,
"type"
:
"binary"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
512
}
},
{
"name"
:
"tmplog_end_devices"
,
"type"
:
"binary"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
512
}
},
{
"name"
:
"tmplog_comment"
,
"type"
:
"string"
,
"options"
:
{
"notnull"
:
false
,
"length"
:
255
}
}
],
"indexes"
:
[
{
"name"
:
"tmplog_timestamp"
,
"columns"
:
[
"tmplog_timestamp"
],
"unique"
:
false
},
{
"name"
:
"tmplog_user_id"
,
"columns"
:
[
"tmplog_user_id"
,
"tmplog_timestamp"
],
"unique"
:
false
},
{
"name"
:
"tmplog_template_id"
,
"columns"
:
[
"tmplog_template_id"
,
"tmplog_timestamp"
],
"unique"
:
false
}
],
"pk"
:
[
"tmplog_id"
]
}
]
File Metadata
Details
Attached
Mime Type
application/json
Expires
Wed, Aug 19, 06:07 (4 d, 6 h ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
93/89/701988095b36f34fa734faf8dcdc
Default Alt Text
tables.json (19 KB)
Attached To
Mode
rMWPROD MediaWiki Production
Attached
Detach File
Event Timeline
Log In to Comment