Extension:UrlShortener/urlshortcodes table

From mediawiki.org
Jump to navigation Jump to search
mysql> describe urlshortcodes;
+--------------+------------+------+-----+---------+----------------+
| Field        | Type       | Null | Key | Default | Extra          |
+--------------+------------+------+-----+---------+----------------+
| usc_id       | int(11)    | NO   | PRI | NULL    | auto_increment |
| usc_url_hash | binary(32) | NO   | UNI | NULL    |                |
| usc_url      | blob       | NO   |     | NULL    |                |
| usc_deleted  | tinyint(1) | NO   |     | 0       |                |
+--------------+------------+------+-----+---------+----------------+