Extension:CentralNotice/cn known devices table

From mediawiki.org
Jump to navigation Jump to search

Fields[edit]

dev_id[edit]

Primary key.

dev_name[edit]

Name of the device: 'desktop', 'android', 'iphone', 'pad', 'unkown', ...

dev_display_label[edit]

Schema summary[edit]

mysql> describe cn_known_devices;
+-------------------+----------------+------+-----+---------+----------------+
| Field             | Type           | Null | Key | Default | Extra          |
+-------------------+----------------+------+-----+---------+----------------+
| dev_id            | int(11)        | NO   | PRI | NULL    | auto_increment |
| dev_name          | varbinary(255) | NO   | MUL | NULL    |                |
| dev_display_label | varbinary(255) | NO   |     | NULL    |                |
+-------------------+----------------+------+-----+---------+----------------+