Witam, w programie mysql workbench stworzyłem bazę, po wyeksportowaniu pliku do .sql mam problem z wgraniem tej bazy do phpmyadmin:
niestety nie wiem w czym dokładnie jest problem, na moje oko kod wygląda w porządku:
-- MySQL Script generated by MySQL Workbench
-- Wed Dec 14 19:51:34 2022
-- Model: New Model Version: 1.0
-- 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 mydb
-- -----------------------------------------------------
DROP SCHEMA IF EXISTS `mydb` ;
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
USE `mydb` ;
-- -----------------------------------------------------
-- Table `mydb`.`USERS`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`USERS` ;
CREATE TABLE IF NOT EXISTS `mydb`.`USERS` (
`IDU` INT NOT NULL,
`NICK` CHAR(45) NOT NULL,
`EMAIL` CHAR(45) NOT NULL,
`HASLO` CHAR(45) NOT NULL,
`RANGA` CHAR(45) NOT NULL,
PRIMARY KEY (`IDU`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`KATEGORIE`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`KATEGORIE` ;
CREATE TABLE IF NOT EXISTS `mydb`.`KATEGORIE` (
`IDK` INT NOT NULL,
`NAZWA` CHAR(45) NOT NULL,
PRIMARY KEY (`IDK`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`POST`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`POST` ;
CREATE TABLE IF NOT EXISTS `mydb`.`POST` (
`IDP` INT NOT NULL,
`TYTUL` CHAR(45) NOT NULL,
`TRESC` CHAR(45) NOT NULL,
`USERS_IDU` INT NOT NULL,
`KATEGORIE_IDK` INT NOT NULL,
PRIMARY KEY (`IDP`),
INDEX `fk_POST_USERS_idx` (`USERS_IDU` ASC) VISIBLE,
INDEX `fk_POST_KATEGORIE1_idx` (`KATEGORIE_IDK` ASC) VISIBLE,
CONSTRAINT `fk_POST_USERS`
FOREIGN KEY (`USERS_IDU`)
REFERENCES `mydb`.`USERS` (`IDU`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_POST_KATEGORIE1`
FOREIGN KEY (`KATEGORIE_IDK`)
REFERENCES `mydb`.`KATEGORIE` (`IDK`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`SPONSORZY`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`SPONSORZY` ;
CREATE TABLE IF NOT EXISTS `mydb`.`SPONSORZY` (
`IDS` INT NOT NULL,
`NAZWA` CHAR(100) NOT NULL,
`NR.UMOWY` INT NOT NULL,
PRIMARY KEY (`IDS`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`PRODUKTY`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`PRODUKTY` ;
CREATE TABLE IF NOT EXISTS `mydb`.`PRODUKTY` (
`IDM` INT NOT NULL,
`LINKDOSTRONY` CHAR(45) NOT NULL,
`NAZWA` CHAR(45) NOT NULL,
`OPIS` CHAR(45) NOT NULL,
`SPONSORZY_IDS` INT NOT NULL,
PRIMARY KEY (`IDM`),
INDEX `fk_PRODUKTY_SPONSORZY1_idx` (`SPONSORZY_IDS` ASC) VISIBLE,
CONSTRAINT `fk_PRODUKTY_SPONSORZY1`
FOREIGN KEY (`SPONSORZY_IDS`)
REFERENCES `mydb`.`SPONSORZY` (`IDS`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`PLIKI`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`PLIKI` ;
CREATE TABLE IF NOT EXISTS `mydb`.`PLIKI` (
`IDPP` INT NOT NULL,
`LOKALIZACJAPLIKU` VARCHAR(45) NOT NULL,
`NAZWAPLIKU` VARCHAR(45) NOT NULL,
`ROZMIAR` VARCHAR(45) NOT NULL,
`LINKIDOMINUATURY` VARCHAR(45) NOT NULL,
`POST_IDP` INT NOT NULL,
`PRODUKTY_IDM` INT NOT NULL,
PRIMARY KEY (`IDPP`),
INDEX `fk_PLIKI_POST1_idx` (`POST_IDP` ASC) VISIBLE,
INDEX `fk_PLIKI_PRODUKTY1_idx` (`PRODUKTY_IDM` ASC) VISIBLE,
CONSTRAINT `fk_PLIKI_POST1`
FOREIGN KEY (`POST_IDP`)
REFERENCES `mydb`.`POST` (`IDP`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_PLIKI_PRODUKTY1`
FOREIGN KEY (`PRODUKTY_IDM`)
REFERENCES `mydb`.`PRODUKTY` (`IDM`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`WPLATY`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`WPLATY` ;
CREATE TABLE IF NOT EXISTS `mydb`.`WPLATY` (
`IDW` INT NOT NULL,
`IDPATRONA` CHAR(45) NOT NULL,
`DATA` DATE NOT NULL,
`KWOTA` DOUBLE NOT NULL,
PRIMARY KEY (`IDW`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`EVENTY`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`EVENTY` ;
CREATE TABLE IF NOT EXISTS `mydb`.`EVENTY` (
`IDE` INT NOT NULL,
`DATA` CHAR(45) NOT NULL,
`OPIS` CHAR(45) NOT NULL,
`POST_IDP` INT NOT NULL,
PRIMARY KEY (`IDE`),
INDEX `fk_EVENTY_POST1_idx` (`POST_IDP` ASC) VISIBLE,
CONSTRAINT `fk_EVENTY_POST1`
FOREIGN KEY (`POST_IDP`)
REFERENCES `mydb`.`POST` (`IDP`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`SPONSORZYEVENTYFK`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`SPONSORZYEVENTYFK` ;
CREATE TABLE IF NOT EXISTS `mydb`.`SPONSORZYEVENTYFK` (
`EVENTY_IDE` INT NOT NULL,
`SPONSORZY_IDS` INT NOT NULL,
INDEX `fk_SPONSORZYEVENTYFK_EVENTY1_idx` (`EVENTY_IDE` ASC) VISIBLE,
INDEX `fk_SPONSORZYEVENTYFK_SPONSORZY1_idx` (`SPONSORZY_IDS` ASC) VISIBLE,
CONSTRAINT `fk_SPONSORZYEVENTYFK_EVENTY1`
FOREIGN KEY (`EVENTY_IDE`)
REFERENCES `mydb`.`EVENTY` (`IDE`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_SPONSORZYEVENTYFK_SPONSORZY1`
FOREIGN KEY (`SPONSORZY_IDS`)
REFERENCES `mydb`.`SPONSORZY` (`IDS`)
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;
Ktoś może coś podpowiedzieć/doradzić?
Dzieki.