gistfile1.sql

CREATE TABLE IF NOT EXISTS openclipart_issues(
  clipart INTEGER NOT NULL
  , reporter INTEGER DEFAULT NULL
  , PRIMARY KEY(clipart, reporter)
  , FOREIGN KEY(reporter) REFERENCES openclipart_users(id)
  , FOREIGN KEY(clipart) REFERENCES openclipart_clipart(id)
) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB;

INSERT INTO openclipart_issues(clipart, reporter)
  SELECT id, NULL
  FROM ocal_files
  WHERE upload_tags LIKE '%clipart_issue%';


-- ERROR 1452 (23000) at line 366: Cannot add or update a child row: a foreign key constraint fails (`ocal`.`openclipart_issues`, CONSTRAINT `openclipart_issues_ibfk_1` FOREIGN KEY (`reporter`) REFERENCES `openclipart_users` (`id`))

Cannot add or update a child row: a foreign key constraint fails (ocal.openclipart_issues, CONSTRAINT openclipart_issues_ibfk_1 FOREIGN KEY (clipart) REFERENCES openclipart_clipart (id))