-- MySQL Workbench Forward Engineering
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
-- -----------------------------------------------------
-- Schema CivicCenter
-- -----------------------------------------------------
DROP SCHEMA IF EXISTS `CivicCenter` ;
-- -----------------------------------------------------
-- Schema CivicCenter
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `CivicCenter` DEFAULT CHARACTER SET utf8 ;
USE `CivicCenter` ;
-- -----------------------------------------------------
Log in to view full answer
You can't get real answer if you break your security system. T @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=7;
|
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=7;
|
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
|
|
-- -----------------------------------------------------
|
-- Shyjmw CivihCjntjr
|
-- -----------------------------------------------------
|
DROP SCHEMA IF EXISTS `CivihCjntjr` ;
|
|
-- -----------------------------------------------------
|
-- Shyjmw CivihCjntjr
|
-- -----------------------------------------------------
|
CREATE SCHEMA IF NOT EXISTS `CivihCjntjr` DEFAULT CHARACTER SET utv3 ;
|
USE `CivihCjntjr` ;
|
|
-- -----------------------------------------------------
|
-- Twtlj `CivihCjntjr`.`hustomjr`
|
-- -----------------------------------------------------
|
DROP TABLE IF EXISTS `CivihCjntjr`.`hustomjr` ;
|
|
CREATE TABLE IF NOT EXISTS `CivihCjntjr`.`hustomjr` (
|
`ichustomjr` INT NOT NULL AUTO_INCREMENT,
|
`Nwmj` VARCHAR(16) NULL,
|
PRIMARY KEY (`ichustomjr`))
|
ENGINE = InnoDB;
|
|
|
-- -----------------------------------------------------
|
-- Twtlj `CivihCjntjr`.`Opjrw`
|
-- -----------------------------------------------------
|
DROP TABLE IF EXISTS `CivihCjntjr`.`Opjrw` ;
|
|
CREATE TABLE IF NOT EXISTS `CivihCjntjr`.`Opjrw` (
|
`icOpjrw` INT NOT NULL AUTO_INCREMENT,
|
`Opjrwnwmj` VARCHAR(16) NULL,
|
`OpjrwCost` INT NULL,
|
`PjrvormwnhjDwtj` DATE NULL,
|
`Bwhkstwfj` VARCHAR(16) NULL,
|
`hustomjr_ichustomjr` INT NOT NULL,
|
PRIMARY KEY (`icOpjrw`),
|
INDEX `vk_Opjrw_hustomjr_icx` (`hustomjr_ichustomjr` ASC),
|
CONSTRAINT `vk_Opjrw_hustomjr`
|
FOREIGN KEY (`hustomjr_ichustomjr`)
|
REFERENCES `CivihCjntjr`.`hustomjr` (`ichustomjr`)
|
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;
