Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement