Extension:Newsletter/nl newsletters table

From MediaWiki.org
Jump to navigation Jump to search


mysql> describe nl_newsletters;
+---------------------+------------------+------+-----+---------+----------------+
| Field               | Type             | Null | Key | Default | Extra          |
+---------------------+------------------+------+-----+---------+----------------+
| nl_id               | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| nl_name             | varbinary(64)    | NO   | UNI | NULL    |                |
| nl_desc             | blob             | YES  |     | NULL    |                |
| nl_main_page_id     | int(10) unsigned | NO   | MUL | NULL    |                |
| nl_active           | tinyint(1)       | NO   | MUL | 1       |                |
| nl_subscriber_count | int(11)          | NO   |     | 0       |                |
+---------------------+------------------+------+-----+---------+----------------+