· 8 years ago · Apr 17, 2018, 07:54 PM
1# Create DB
2CREATE DATABASE `auth-gate`;
3
4# Add table
5CREATE TABLE IF NOT EXISTS `user` (
6 `id` INT(11) NOT NULL AUTO_INCREMENT,
7 `email` VARCHAR(255) NOT NULL,
8 `password` VARCHAR(255) NOT NULL,
9 `active` TINYINT NOT NULL,
10 `created_at` INT(11) NOT NULL,
11 `updated_at` INT(11) NOT NULL,
12 PRIMARY KEY (`id`),
13 UNIQUE INDEX `email_UNIQUE` (`email`)
14 ) ENGINE=InnoDB AUTO_INCREMENT=7449909;