· 9 years ago · Jan 13, 2017, 01:48 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) NOT NULL,
3 `name` varchar(40) NOT NULL,
4 `email` varchar(55) NOT NULL,
5 `password` varchar(32) NOT NULL,
6 `hash` varchar(32) NOT NULL
7) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
8
9ALTER TABLE `users`
10 ADD PRIMARY KEY (`id`);