Skip to content

Instantly share code, notes, and snippets.

@aarshtalati

aarshtalati/mysql_schema.sql

Last active March 27, 2018 12:09
Show Gist options
  • Save aarshtalati/12aa9895806aa222a18e5a749cdcc89f to your computer and use it in GitHub Desktop.
Save aarshtalati/12aa9895806aa222a18e5a749cdcc89f to your computer and use it in GitHub Desktop.
Download ZIP
Epidemics table sample schema
Raw
mysql_schema.sql
# 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