Forum PHP.pl

[SQL] pobierz, plaintext 
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';
 
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `mydb`;
 
-- -----------------------------------------------------
-- Table `mydb`.`OPERATORZY`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`OPERATORZY` (
  `idOPERATORZY` INT UNSIGNED NOT NULL ,
  `nazwa` VARCHAR(10) NOT NULL ,
  PRIMARY KEY (`idOPERATORZY`) )
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`DOLADOWANIA`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`DOLADOWANIA` (
  `idDOLADOWANIA` INT UNSIGNED NOT NULL ,
  `wartosc` INT NOT NULL ,
  `waznosc` INT NOT NULL ,
  PRIMARY KEY (`idDOLADOWANIA`) )
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`AKTYWNE`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`AKTYWNE` (
  `idAKTYWNE` INT UNSIGNED NOT NULL ,
  `czy_mozna_sprzedac` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`idAKTYWNE`) )
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`PRODUKTY`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`PRODUKTY` (
  `idPRODUKTY` INT UNSIGNED NOT NULL ,
  `id_operatora` INT UNSIGNED NOT NULL ,
  `id_doladowania` INT UNSIGNED NOT NULL ,
  `id_aktywne` INT UNSIGNED NOT NULL ,
  `opis` VARCHAR(45) NULL ,
  `obrazek` VARCHAR(45) NULL ,
  PRIMARY KEY (`idPRODUKTY`) ,
  INDEX `id_operatora` (`id_operatora` ASC) ,
  INDEX `id_doladowania` (`id_doladowania` ASC) ,
  INDEX `id_aktywne` (`id_aktywne` ASC) ,
  CONSTRAINT `id_operatora`
    FOREIGN KEY (`id_operatora` )
    REFERENCES `mydb`.`OPERATORZY` (`idOPERATORZY` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `id_doladowania`
    FOREIGN KEY (`id_doladowania` )
    REFERENCES `mydb`.`DOLADOWANIA` (`idDOLADOWANIA` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `id_aktywne`
    FOREIGN KEY (`id_aktywne` )
    REFERENCES `mydb`.`AKTYWNE` (`idAKTYWNE` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`TRESC`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`TRESC` (
  `idTRESC` INT NOT NULL ,
  `tresc` VARCHAR(14) NOT NULL ,
  PRIMARY KEY (`idTRESC`) )
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`DATA`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`DATA` (
  `idDATA` INT NOT NULL ,
  `data_dodania` DATE NOT NULL ,
  `data_sprzedazy` DATE NOT NULL ,
  PRIMARY KEY (`idDATA`) )
ENGINE = InnoDB;
 
 
-- -----------------------------------------------------
-- Table `mydb`.`KODY`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`KODY` (
  `idKODY` INT UNSIGNED NOT NULL ,
  `id_stan` INT NOT NULL ,
  `data_dodania` DATE NOT NULL ,
  `data_sprzedazy` DATE NOT NULL ,
  `operator` INT NOT NULL ,
  PRIMARY KEY (`idKODY`) ,
  INDEX `data_dodania` (`data_dodania` ASC) ,
  INDEX `data_sprzedazy` (`data_sprzedazy` ASC) ,
  CONSTRAINT `data_dodania`
    FOREIGN KEY (`data_dodania` )
    REFERENCES `mydb`.`DATA` (`data_dodania` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `data_sprzedazy`
    FOREIGN KEY (`data_sprzedazy` )
    REFERENCES `mydb`.`DATA` (`data_sprzedazy` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`STAN`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`STAN` (
  `idSTAN` INT NOT NULL ,
  `czy_sprzedane` VARCHAR(3) NOT NULL ,
  PRIMARY KEY (`idSTAN`) )
ENGINE = InnoDB;
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
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';
 
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `mydb`;
 
-- -----------------------------------------------------
-- Table `mydb`.`OPERATORZY`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`OPERATORZY` (
  `idOPERATORZY` INT NOT NULL AUTO_INCREMENT ,
  `nazwa` VARCHAR(10) NOT NULL ,
  PRIMARY KEY (`idOPERATORZY`) )
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`DOLADOWANIA`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`DOLADOWANIA` (
  `idDOLADOWANIA` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `wartosc` INT NOT NULL ,
  `waznosc` INT NOT NULL ,
  PRIMARY KEY (`idDOLADOWANIA`) )
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`AKTYWNE`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`AKTYWNE` (
  `idAKTYWNE` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `czy_mozna_sprzedac` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`idAKTYWNE`) )
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`PRODUKTY`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`PRODUKTY` (
  `idPRODUKTY` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `id_operatora` INT UNSIGNED NOT NULL ,
  `id_doladowania` INT UNSIGNED NOT NULL ,
  `id_aktywne` INT UNSIGNED NOT NULL ,
  `opis` VARCHAR(45) NULL ,
  `obrazek` VARCHAR(45) NULL ,
  PRIMARY KEY (`idPRODUKTY`) ,
  INDEX `id_operatora` (`id_operatora` ASC) ,
  INDEX `id_doladowania` (`id_doladowania` ASC) ,
  INDEX `id_aktywne` (`id_aktywne` ASC) ,
  CONSTRAINT `id_operatora`
    FOREIGN KEY (`id_operatora` )
    REFERENCES `mydb`.`OPERATORZY` (`idOPERATORZY` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `id_doladowania`
    FOREIGN KEY (`id_doladowania` )
    REFERENCES `mydb`.`DOLADOWANIA` (`idDOLADOWANIA` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `id_aktywne`
    FOREIGN KEY (`id_aktywne` )
    REFERENCES `mydb`.`AKTYWNE` (`idAKTYWNE` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`TRESC`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`TRESC` (
  `idTRESC` INT NOT NULL AUTO_INCREMENT ,
  `tresc` VARCHAR(14) NOT NULL ,
  PRIMARY KEY (`idTRESC`) )
ENGINE = InnoDB;
 
 
-- -----------------------------------------------------
-- Table `mydb`.`DATA`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`DATA` (
  `idDATA` INT NOT NULL AUTO_INCREMENT ,
  `data_dodania` INT NOT NULL ,
  `data_sprzedazy` INT NOT NULL ,
  `data_dod_a` INT NOT NULL ,
  `data_zak_a` INT NOT NULL ,
  PRIMARY KEY (`idDATA`) )
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`KODY`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`KODY` (
  `idKODY` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `id_stan` INT NOT NULL ,
  `id_operatora` INT NOT NULL ,
  `data_dodania` DATE NOT NULL ,
  `data_sprzedazy` DATE NOT NULL ,
  PRIMARY KEY (`idKODY`) ,
  INDEX `data_dodania` (`data_dodania` ASC) ,
  INDEX `data_sprzedazy` (`data_sprzedazy` ASC) ,
  INDEX `id_operatora` (`id_operatora` ASC) ,
  CONSTRAINT `data_dodania`
    FOREIGN KEY (`data_dodania` )
    REFERENCES `mydb`.`DATA` (`data_dodania` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `data_sprzedazy`
    FOREIGN KEY (`data_sprzedazy` )
    REFERENCES `mydb`.`DATA` (`data_sprzedazy` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `id_operatora`
    FOREIGN KEY (`id_operatora` )
    REFERENCES `mydb`.`OPERATORZY` (`idOPERATORZY` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`STAN`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`STAN` (
  `idSTAN` INT NOT NULL AUTO_INCREMENT ,
  `czy_sprzedane` VARCHAR(3) NOT NULL ,
  PRIMARY KEY (`idSTAN`) )
ENGINE = InnoDB;
 
-- -----------------------------------------------------
-- Table `mydb`.`AUKCJA`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`AUKCJA` (
  `idAUKCJA` INT NOT NULL AUTO_INCREMENT ,
  `data_dod_a` INT NOT NULL ,
  `data_zak_a` INT NOT NULL ,
  `cena_a` INT NOT NULL ,
  `numer_ident_a` INT NOT NULL ,
  `czas_trwania` INT NOT NULL ,
  `ilosc` INT NOT NULL ,
  PRIMARY KEY (`idAUKCJA`) ,
  INDEX `data_dod_a` (`data_dod_a` ASC) ,
  INDEX `data_zak_a` (`data_zak_a` ASC) ,
  CONSTRAINT `data_dod_a`
    FOREIGN KEY (`data_dod_a` )
    REFERENCES `mydb`.`DATA` (`data_dod_a` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `data_zak_a`
    FOREIGN KEY (`data_zak_a` )
    REFERENCES `mydb`.`DATA` (`data_zak_a` )
    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;
 
[SQL] pobierz, plaintext