· 8 years ago · Apr 04, 2018, 08:12 PM
1# MySQL Setup
2SET default_storage_engine=InnoDB;
3USE epidemics;
4
5DROP TABLE IF EXISTS user;
6
7CREATE TABLE user (
8`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
9`username` VARCHAR(25) NOT NULL,
10`password` VARCHAR(50) ,
11`active` BIT(1)
12)ENGINE=InnoDB;