· 8 years ago · Jul 15, 2018, 07:50 PM
1CREATE TABLE IF NOT EXISTS `accounts` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `username` varchar(30) NOT NULL,
4 `password` varchar(255) NOT NULL,
5 `created` datetime NOT NULL,
6 `admin` int(11) NOT NULL DEFAULT '0',
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;