· 6 years ago · Oct 17, 2019, 06:10 PM
1USE `qhogimrzh51pr146`;
2
3CREATE TABLE IF NOT EXISTS `accounts` (
4 `id` int(11) NOT NULL,
5 `username` varchar(50) NOT NULL,
6 `password` varchar(255) NOT NULL,
7 `email` varchar(100) NOT NULL
8) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
9
10INSERT INTO `accounts` (`id`, `username`, `password`, `email`) VALUES (1, 'test', 'test', 'test@test.com');
11
12ALTER TABLE `accounts` ADD PRIMARY KEY (`id`);
13ALTER TABLE `accounts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;