· 7 years ago · Feb 28, 2019, 09:18 AM
1CREATE DATABASE IF NOT EXISTS `expressmysql`;
2
3CREATE TABLE `person` (
4`person_id` INT(11) NOT NULL AUTO_INCREMENT,
5`name` VARCHAR(50) NULL DEFAULT NULL,
6`address` VARCHAR(50) NULL DEFAULT NULL,
7`phone` VARCHAR(15) NULL DEFAULT NULL,
8`created_at` TIMESTAMP NULL DEFAULT NULL,
9`updated_at` TIMESTAMP NULL DEFAULT NULL,
10PRIMARY KEY (`person_id`))
11ENGINE=InnoDB;