-- ----------------------------------------------------------------------
-- MySQL GRT Application
-- SQL Script
-- ----------------------------------------------------------------------

SET FOREIGN_KEY_CHECKS = 0;

CREATE DATABASE IF NOT EXISTS `a2z`;
-- -------------------------------------
-- Tables

DROP TABLE IF EXISTS `a2z`.`aaa`;
CREATE TABLE `a2z`.`aaa` (
  `idaaa` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `aaa1` VARCHAR(45)NULL,
  `aaa2` DOUBLE NULL,
  `aaa3` DATETIME NULL,
  PRIMARY KEY (`idaaa`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`bbb`;
CREATE TABLE `a2z`.`bbb` (
  `idbbb` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `bbb1` VARCHAR(45)NULL,
  `bbb3` DATE NULL,
  `FKaaa_idaaa`  INT(11) UNSIGNED NOT NULL,
  `bbb4` VARCHAR(45)NULL,
  PRIMARY KEY (`idbbb`),
  CONSTRAINT `FKaaa` FOREIGN KEY `FKaaa` (`FKaaa_idaaa`)
    REFERENCES `a2z`.`aaa` (`idaaa`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`ccc`;
CREATE TABLE `a2z`.`ccc` (
  `idccc` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ccc1` INT UNSIGNED NOT NULL,
  `ccc2` VARCHAR(45)NULL,
  PRIMARY KEY (`idccc`, `ccc1`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`ddd`;
CREATE TABLE `a2z`.`ddd` (
  `idddd` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ddd1` VARCHAR(45)NULL,
  `ddd2` VARCHAR(45)NULL,
  `FKccc_idccc`  INT(11) UNSIGNED NOT NULL,
  `FKccc_ccc1`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idddd`),
  CONSTRAINT `FKccc` FOREIGN KEY `FKccc` (`FKccc_idccc`, `FKccc_ccc1`)
    REFERENCES `a2z`.`ccc` (`idccc`, `ccc1`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`eee`;
CREATE TABLE `a2z`.`eee` (
  `ideee` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `eee1` VARCHAR(45)NULL,
  `eee2` VARCHAR(45)NULL,
  PRIMARY KEY (`ideee`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`fff`;
CREATE TABLE `a2z`.`fff` (
  `idfff` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `fff1` INT(10) NULL,
  `fff2` BOOLEAN NULL,
  `FKeee_ideee`  INT(11) UNSIGNED NOT NULL,
  `FKbbb_idbbb`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idfff`),
  CONSTRAINT `FKeee` FOREIGN KEY `FKeee` (`FKeee_ideee`)
    REFERENCES `a2z`.`eee` (`ideee`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKbbb` FOREIGN KEY `FKbbb` (`FKbbb_idbbb`)
    REFERENCES `a2z`.`bbb` (`idbbb`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`ggg`;
CREATE TABLE `a2z`.`ggg` (
  `idggg` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ggg1` VARCHAR(45)NULL,
  `ggg2` VARCHAR(45)NULL,
  `FKfff_idfff`  INT(11) UNSIGNED NOT NULL,
  `FKkkk_idkkk`  INT(11) UNSIGNED NOT NULL,
  `FKkkk_kkk1`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idggg`),
  CONSTRAINT `FKfff` FOREIGN KEY `FKfff` (`FKfff_idfff`)
    REFERENCES `a2z`.`fff` (`idfff`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKkkk` FOREIGN KEY `FKkkk` (`FKkkk_idkkk`, `FKkkk_kkk1`)
    REFERENCES `a2z`.`kkk` (`idkkk`, `kkk1`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`hhh`;
CREATE TABLE `a2z`.`hhh` (
  `idhhh` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `hhh1` VARCHAR(45)NULL,
  `hhh2` VARCHAR(45)NULL,
  `FKggg_idggg`  INT(11) UNSIGNED NOT NULL,
  `FKddd_idddd`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idhhh`),
  CONSTRAINT `FKggg` FOREIGN KEY `FKggg` (`FKggg_idggg`)
    REFERENCES `a2z`.`ggg` (`idggg`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKddd` FOREIGN KEY `FKddd` (`FKddd_idddd`)
    REFERENCES `a2z`.`ddd` (`idddd`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`iii`;
CREATE TABLE `a2z`.`iii` (
  `idiii` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `iii1` VARCHAR(45)NULL,
  `iii2` VARCHAR(45)NULL,
  PRIMARY KEY (`idiii`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`jjj`;
CREATE TABLE `a2z`.`jjj` (
  `idjjj` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `jjj1` VARCHAR(45)NULL,
  `jjj2` VARCHAR(45)NULL,
  `FKiii_idiii`  INT(11) UNSIGNED NOT NULL,
  `FKkkk_idkkk`  INT(11) UNSIGNED NOT NULL,
  `FKkkk_kkk1`  INT(11) UNSIGNED NOT NULL,
  `FKnnn_idnnn`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idjjj`),
  CONSTRAINT `FKiii` FOREIGN KEY `FKiii` (`FKiii_idiii`)
    REFERENCES `a2z`.`iii` (`idiii`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKkkk2` FOREIGN KEY `FKkkk` (`FKkkk_idkkk`, `FKkkk_kkk1`)
    REFERENCES `a2z`.`kkk` (`idkkk`, `kkk1`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKnnn2` FOREIGN KEY `FKnnn` (`FKnnn_idnnn`)
    REFERENCES `a2z`.`nnn` (`idnnn`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`kkk`;
CREATE TABLE `a2z`.`kkk` (
  `idkkk` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `kkk1` INT(11) UNSIGNED NOT NULL,
  `kkk2` VARCHAR(45)NULL,
  `kkk3` DOUBLE NULL,
  `FKlll_idlll`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idkkk`, `kkk1`),
  CONSTRAINT `FKlll` FOREIGN KEY `FKlll` (`FKlll_idlll`)
    REFERENCES `a2z`.`lll` (`idlll`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`lll`;
CREATE TABLE `a2z`.`lll` (
  `idlll` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `lll1` VARCHAR(45)NULL,
  `lll2` VARCHAR(45)NULL,
  PRIMARY KEY (`idlll`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`mmm`;
CREATE TABLE `a2z`.`mmm` (
  `idmmm` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mmm1` VARCHAR(45)NULL,
  `mmm2` VARCHAR(45)NULL,
  PRIMARY KEY (`idmmm`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`nnn`;
CREATE TABLE `a2z`.`nnn` (
  `idnnn` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nnn1` VARCHAR(45)NULL,
  `nnn2` VARCHAR(45)NULL,
  `FKmmm_idmmm`  INT(11) UNSIGNED NOT NULL,
  `FKrrr_FKqqq_idqqq`  INT(11) UNSIGNED NOT NULL,
  `FKrrr_idrrr`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idnnn`),
  CONSTRAINT `FKmmm` FOREIGN KEY `FKmmm` (`FKmmm_idmmm`)
    REFERENCES `a2z`.`mmm` (`idmmm`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKrrr` FOREIGN KEY `FKrrr` (`FKrrr_FKqqq_idqqq`, `FKrrr_idrrr`)
    REFERENCES `a2z`.`rrr` (`FKqqq_idqqq`, `idrrr`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`ooo`;
CREATE TABLE `a2z`.`ooo` (
  `idooo` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ooo1` VARCHAR(45)NULL,
  `ooo2` VARCHAR(45)NULL,
  `FKppp_idppp`  INT(11) UNSIGNED NOT NULL,
  `FKttt_FKsss_FKrrr_FKqqq_idqqq`  INT(11) UNSIGNED NOT NULL,
  `FKttt_FKsss_FKrrr_idrrr`  INT(11) UNSIGNED NOT NULL,
  `FKttt_FKsss_idsss`  INT(11) UNSIGNED NOT NULL,
  `FKttt_idttt`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idooo`),
  CONSTRAINT `FKppp` FOREIGN KEY `FKppp` (`FKppp_idppp`)
    REFERENCES `a2z`.`ppp` (`idppp`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKttt` FOREIGN KEY `FKttt` (`FKttt_FKsss_FKrrr_FKqqq_idqqq`, `FKttt_FKsss_FKrrr_idrrr`, `FKttt_FKsss_idsss`, `FKttt_idttt`)
    REFERENCES `a2z`.`ttt` (`FKsss_FKrrr_FKqqq_idqqq`, `FKsss_FKrrr_idrrr`, `FKsss_idsss`, `idttt`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`ppp`;
CREATE TABLE `a2z`.`ppp` (
  `idppp` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ppp1` VARCHAR(45)NULL,
  `ppp2` VARCHAR(45)NULL,
  PRIMARY KEY (`idppp`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`nm_no`;
CREATE TABLE `a2z`.`nm_no` (
  `FKnnn_idnnn`  INT(11) UNSIGNED NOT NULL,
  `FKooo_idooo`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`FKnnn_idnnn`, `FKooo_idooo`),
  CONSTRAINT `FKnnn` FOREIGN KEY `FKnnn` (`FKnnn_idnnn`)
    REFERENCES `a2z`.`nnn` (`idnnn`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKooo` FOREIGN KEY `FKooo` (`FKooo_idooo`)
    REFERENCES `a2z`.`ooo` (`idooo`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`nm_lp`;
CREATE TABLE `a2z`.`nm_lp` (
  `FKlll_idlll` INT(11) UNSIGNED NOT NULL,
  `FKppp_idppp` INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`FKlll_idlll`, `FKppp_idppp`),
  CONSTRAINT `FKlll2` FOREIGN KEY `FKlll` (`FKlll_idlll`)
    REFERENCES `a2z`.`lll` (`idlll`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKppp2` FOREIGN KEY `FKppp` (`FKppp_idppp`)
    REFERENCES `a2z`.`ppp` (`idppp`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`qqq`;
CREATE TABLE `a2z`.`qqq` (
  `idqqq` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `qqq1` VARCHAR(45)NULL,
  `qqq2` INT(11) NULL,
  PRIMARY KEY (`idqqq`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`rrr`;
CREATE TABLE `a2z`.`rrr` (
  `idrrr` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `FKqqq_idqqq`  INT(11) UNSIGNED NOT NULL,
  `rrr1` VARCHAR(45)NULL,
  `rrr2` VARCHAR(45)NULL,
  `FKvvv_idvvv`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idrrr`, `FKqqq_idqqq`),
  CONSTRAINT `FKqqq` FOREIGN KEY `FKqqq` (`FKqqq_idqqq`)
    REFERENCES `a2z`.`qqq` (`idqqq`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `FKvvv` FOREIGN KEY `FKvvv` (`FKvvv_idvvv`)
    REFERENCES `a2z`.`vvv` (`idvvv`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`sss`;
CREATE TABLE `a2z`.`sss` (
  `idsss` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sss1` VARCHAR(45)NULL,
  `sss2` VARCHAR(45)NULL,
  `FKrrr_FKqqq_idqqq` INT(11) UNSIGNED NOT NULL,
  `FKrrr_idrrr` INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idsss`, `FKrrr_FKqqq_idqqq`, `FKrrr_idrrr`),
  CONSTRAINT `FKrrr3` FOREIGN KEY `FKrrr` (`FKrrr_FKqqq_idqqq`, `FKrrr_idrrr`)
    REFERENCES `a2z`.`rrr` (`FKqqq_idqqq`, `idrrr`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`ttt`;
CREATE TABLE `a2z`.`ttt` (
  `idttt` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ttt1` DATETIME NULL,
  `ttt2` VARCHAR(45)NULL,
  `FKsss_FKrrr_FKqqq_idqqq`  INT(11) UNSIGNED NOT NULL,
  `FKsss_FKrrr_idrrr`  INT(11) UNSIGNED NOT NULL,
  `FKsss_idsss`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idttt`, `FKsss_FKrrr_FKqqq_idqqq`, `FKsss_FKrrr_idrrr`, `FKsss_idsss`),
  CONSTRAINT `FKsss` FOREIGN KEY `FKsss` (`FKsss_FKrrr_FKqqq_idqqq`, `FKsss_FKrrr_idrrr`, `FKsss_idsss`)
    REFERENCES `a2z`.`sss` (`FKrrr_FKqqq_idqqq`, `FKrrr_idrrr`, `idsss`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`uuu`;
CREATE TABLE `a2z`.`uuu` (
  `iduuu` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`iduuu`)
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

DROP TABLE IF EXISTS `a2z`.`vvv`;
CREATE TABLE `a2z`.`vvv` (
  `idvvv` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `FKuuu_iduuu`  INT(11) UNSIGNED NOT NULL,
  PRIMARY KEY (`idvvv`),
  CONSTRAINT `FKuuu` FOREIGN KEY `FKuuu` (`FKuuu_iduuu`)
    REFERENCES `a2z`.`uuu` (`iduuu`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;


SET FOREIGN_KEY_CHECKS = 1;

-- ----------------------------------------------------------------------
-- EOF