· 7 years ago · Dec 10, 2018, 07:56 AM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
4 `password` char(64) COLLATE utf8_unicode_ci NOT NULL,
5 `salt` char(16) COLLATE utf8_unicode_ci NOT NULL,
6 PRIMARY KEY (`id`),
7 UNIQUE KEY `username` (`username`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;