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,ALLOW_INVALID_DATES';

CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `mydb` ;

-- -----------------------------------------------------
-- Table `mydb`.`items`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`items` (
  `id` INT(10) NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(255) NOT NULL ,
  `slug` VARCHAR(255) NOT NULL ,
  `thumb` VARCHAR(255) NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`categories`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`categories` (
  `id` INT(10) NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(255) NOT NULL ,
  `slug` VARCHAR(255) NOT NULL ,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`items_categories`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`items_categories` (
  `items_id` INT NOT NULL ,
  `categories_id` INT NOT NULL ,
  PRIMARY KEY (`items_id`, `categories_id`) ,
  INDEX `fk_items_has_categories_categories1_idx` (`categories_id` ASC) ,
  INDEX `fk_items_has_categories_items_idx` (`items_id` ASC) ,
  CONSTRAINT `fk_items_has_categories_items`
    FOREIGN KEY (`items_id` )
    REFERENCES `mydb`.`items` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_items_has_categories_categories1`
    FOREIGN KEY (`categories_id` )
    REFERENCES `mydb`.`categories` (`id` )
    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;

-- -----------------------------------------------------
-- Data for table `mydb`.`items`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`items` (`id`, `name`, `slug`, `thumb`) VALUES (1, 'Real Madrid', 'rmcf', NULL);
INSERT INTO `mydb`.`items` (`id`, `name`, `slug`, `thumb`) VALUES (2, 'Barcelona', 'barcelona', NULL);
INSERT INTO `mydb`.`items` (`id`, `name`, `slug`, `thumb`) VALUES (3, 'Sevilla', 'sevillacf', NULL);
INSERT INTO `mydb`.`items` (`id`, `name`, `slug`, `thumb`) VALUES (4, 'Internazionale de Millano', 'inter', NULL);
INSERT INTO `mydb`.`items` (`id`, `name`, `slug`, `thumb`) VALUES (5, 'Chelsea', 'chelsea', NULL);
INSERT INTO `mydb`.`items` (`id`, `name`, `slug`, `thumb`) VALUES (6, 'Manchester United', 'manutd', NULL);
INSERT INTO `mydb`.`items` (`id`, `name`, `slug`, `thumb`) VALUES (7, 'Lazio', 'lazio', NULL);

COMMIT;

-- -----------------------------------------------------
-- Data for table `mydb`.`categories`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`categories` (`id`, `name`, `slug`, `created_at`) VALUES (1, 'Liga de Futbol Profesional', 'lfp', '2013-01-01 00:00:00');
INSERT INTO `mydb`.`categories` (`id`, `name`, `slug`, `created_at`) VALUES (2, 'Calcio', 'calcio', '2013-01-02 00:00:00');
INSERT INTO `mydb`.`categories` (`id`, `name`, `slug`, `created_at`) VALUES (3, 'Premier League', 'pl', '2013-01-03 00:00:00');
INSERT INTO `mydb`.`categories` (`id`, `name`, `slug`, `created_at`) VALUES (4, 'UEFA Champions League', 'UCL', '2013-01-04 00:00:00');

COMMIT;

-- -----------------------------------------------------
-- Data for table `mydb`.`items_categories`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (1, 1);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (2, 1);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (4, 2);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (3, 1);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (5, 3);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (6, 3);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (7, 2);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (7, 4);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (1, 4);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (6, 4);
INSERT INTO `mydb`.`items_categories` (`items_id`, `categories_id`) VALUES (2, 4);

COMMIT;