· 8 years ago · Jan 14, 2018, 12:30 AM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(8) NOT NULL AUTO_INCREMENT,
3 `fullname` varchar(30) NOT NULL,
4 `username` varchar(30) NOT NULL,
5 `password` varchar(255) NOT NULL,
6 `email` varchar(255) NOT NULL,
7 PRIMARY KEY (`id`),
8 UNIQUE KEY `user_name_unique` (`username`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;