CREATE DATABASE simpleapi;
-- Table structure for users
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL,
`firstname` varchar(200) NOT NULL,
`lastname` varchar(200) NOT NULL,
`nickname` varchar(200) NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
);
ALTER TABLE `users` ADD PRIMARY KEY (`id`);
ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;