Jump to content

Extension:CampaignEvents/campaign events table

From mediawiki.org
mysql> describe campaign_events;
+---------------------------+---------------------+------+-----+---------+----------------+
| Field                     | Type                | Null | Key | Default | Extra          |
+---------------------------+---------------------+------+-----+---------+----------------+
| event_id                  | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| event_name                | varbinary(255)      | NO   |     | NULL    |                |
| event_page_namespace      | int(10) unsigned    | NO   |     | NULL    |                |
| event_page_title          | varbinary(255)      | NO   |     | NULL    |                |
| event_page_wiki           | varbinary(64)       | NO   | MUL | NULL    |                |
| event_page_prefixedtext   | varbinary(512)      | NO   |     | NULL    |                |
| event_chat_url            | blob                | NO   |     | NULL    |                |
| event_status              | int(11)             | NO   |     | NULL    |                |
| event_timezone            | varbinary(64)       | NO   | MUL | NULL    |                |
| event_start_local         | binary(14)          | NO   |     | NULL    |                |
| event_start_utc           | binary(14)          | NO   |     | NULL    |                |
| event_end_local           | binary(14)          | NO   |     | NULL    |                |
| event_end_utc             | binary(14)          | NO   |     | NULL    |                |
| event_meeting_type        | int(11)             | NO   |     | NULL    |                |
| event_meeting_url         | blob                | NO   |     | NULL    |                |
| event_created_at          | binary(14)          | NO   |     | NULL    |                |
| event_last_edit           | binary(14)          | NO   |     | NULL    |                |
| event_deleted_at          | binary(14)          | YES  |     | NULL    |                |
| event_is_test_event       | tinyint(1)          | NO   |     | 0       |                |
| event_types               | int(11)             | NO   |     | 0       |                |
| event_track_contributions | tinyint(1)          | NO   |     | 0       |                |
+---------------------------+---------------------+------+-----+---------+----------------+