ryaGvrPz

1-- Dump for MySQL 5.X
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema petdb
9-- -----------------------------------------------------
10DROP SCHEMA IF EXISTS `petdb` ;
11
12-- -----------------------------------------------------
13-- Schema petdb
14-- -----------------------------------------------------
15CREATE SCHEMA IF NOT EXISTS `petdb` DEFAULT CHARACTER SET utf8mb4 ;
16USE `petdb` ;
17
18-- -----------------------------------------------------
19-- Table `petdb`.`pets`
20-- -----------------------------------------------------
21DROP TABLE IF EXISTS `petdb`.`pets` ;
22
23CREATE TABLE IF NOT EXISTS `petdb`.`pets` (
24  `id` INT NOT NULL AUTO_INCREMENT,
25  `name` VARCHAR(45) NOT NULL,
26  `species` VARCHAR(45) NOT NULL,
27  `gender` CHAR(1) NOT NULL,
28  `birthday` DATE NULL,
29  PRIMARY KEY (`id`))
30ENGINE = InnoDB;
31
32
33SET SQL_MODE=@OLD_SQL_MODE;
34SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
35SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
36
37-- -----------------------------------------------------
38-- Data for table `petdb`.`pets`
39-- -----------------------------------------------------
40START TRANSACTION;
41USE `petdb`;
42INSERT INTO `petdb`.`pets` (`id`, `name`, `species`, `gender`, `birthday`) VALUES (1, 'Fritz', 'dog', 'm', '2016-12-03');
43INSERT INTO `petdb`.`pets` (`id`, `name`, `species`, `gender`, `birthday`) VALUES (2, 'Sweety', 'cat', 'w', '2015-06-23');
44INSERT INTO `petdb`.`pets` (`id`, `name`, `species`, `gender`, `birthday`) VALUES (3, 'Tequila', 'parakeet', 'w', '2017-01-05');
45INSERT INTO `petdb`.`pets` (`id`, `name`, `species`, `gender`, `birthday`) VALUES (4, 'Rambo', 'parakeet', 'm', NULL);
46INSERT INTO `petdb`.`pets` (`id`, `name`, `species`, `gender`, `birthday`) VALUES (5, 'Smokey', 'cat', 'm', '2016-01-17');
47INSERT INTO `petdb`.`pets` (`id`, `name`, `species`, `gender`, `birthday`) VALUES (6, 'Missy', 'dog', 'w', '2013-03-09');
48INSERT INTO `petdb`.`pets` (`id`, `name`, `species`, `gender`, `birthday`) VALUES (6, 'Uni-🙈', 'monkey', 'm', '2014-04-01');
49
50COMMIT;