Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Epidemics table sample schema
# MySQL Setup
SET default_storage_engine=InnoDB;
USE epidemics;
DROP TABLE IF EXISTS user;
CREATE TABLE user (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`username` VARCHAR(25) NOT NULL,
`password` VARCHAR(50) ,
`active` BIT(1)
)ENGINE=InnoDB;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment