· 8 years ago · May 29, 2018, 11:22 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3 `email` varchar(127) NOT NULL,
4 `username` varchar(32) NOT NULL DEFAULT '',
5 `password` char(50) NOT NULL,
6 `last_login` int(10) unsigned DEFAULT NULL,
7 PRIMARY KEY (`id`),
8 UNIQUE KEY `uniq_username` (`username`),
9 UNIQUE KEY `uniq_email` (`email`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;