Permalink
Switch branches/tags
Nothing to show
Find file
af52b73 May 7, 2013
10 lines (9 sloc) 530 Bytes
# Why you should use `utf8mb4` instead of `utf8`: http://mathiasbynens.be/notes/mysql-utf8mb4
CREATE TABLE `redirect` (
`slug` varchar(14) collate utf8mb4_unicode_ci NOT NULL,
`url` varchar(620) collate utf8mb4_unicode_ci NOT NULL,
`date` datetime NOT NULL,
`hits` bigint(20) NOT NULL default '0',
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for the URL shortener';
INSERT INTO `redirect` VALUES ('a', 'https://github.com/mathiasbynens/php-url-shortener', NOW(), 1);