PHP Classes

File: src/Example/db.sql

Recommend this page to a friend!
  Classes of Mateus Fornari   Hypersistence   src/Example/db.sql   Download  
File: src/Example/db.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Hypersistence
Store and retrieve objects in databases using PDO
Author: By
Last change:
Date: 9 years ago
Size: 3,378 bytes
 

Contents

Class file image Download
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; CREATE SCHEMA IF NOT EXISTS `test` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; USE `test` ; -- ----------------------------------------------------- -- Table `test`.`city` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `test`.`city` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `test`.`person` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `test`.`person` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(45) NOT NULL, `email` VARCHAR(45) NOT NULL, `city_id` INT NULL, PRIMARY KEY (`id`), INDEX `fk_person_city1_idx` (`city_id` ASC), CONSTRAINT `fk_person_city1` FOREIGN KEY (`city_id`) REFERENCES `test`.`city` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `test`.`book` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `test`.`book` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `person_id` INT(11) NOT NULL, `title` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`), INDEX `fk_book_person_idx` (`person_id` ASC), CONSTRAINT `fk_book_person` FOREIGN KEY (`person_id`) REFERENCES `test`.`person` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `test`.`student` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `test`.`student` ( `id` INT(11) NOT NULL, `number` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_sudent_person1` FOREIGN KEY (`id`) REFERENCES `test`.`person` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `test`.`course` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `test`.`course` ( `id` INT NOT NULL AUTO_INCREMENT, `description` VARCHAR(60) NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `test`.`student_has_course` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `test`.`student_has_course` ( `student_id` INT(11) NOT NULL, `course_id` INT NOT NULL, PRIMARY KEY (`student_id`, `course_id`), INDEX `fk_student_has_course_course1_idx` (`course_id` ASC), INDEX `fk_student_has_course_student1_idx` (`student_id` ASC), CONSTRAINT `fk_student_has_course_student1` FOREIGN KEY (`student_id`) REFERENCES `test`.`student` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_student_has_course_course1` FOREIGN KEY (`course_id`) REFERENCES `test`.`course` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;