Skip to content

Instantly share code, notes, and snippets.

@herudi

herudi/create_database_expressmysql.sql

Last active February 25, 2019 05:05
Show Gist options
  • Save herudi/d26391500bbd5088f992a22402397f8b to your computer and use it in GitHub Desktop.
Save herudi/d26391500bbd5088f992a22402397f8b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create_database_expressmysql.sql
CREATE DATABASE IF NOT EXISTS `expressmysql`;
CREATE TABLE `person` (
`person_id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NULL DEFAULT NULL,
`address` VARCHAR(50) NULL DEFAULT NULL,
`phone` VARCHAR(15) NULL DEFAULT NULL,
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`person_id`))
ENGINE=InnoDB;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment