Advertisement
Bisa

Many to many SQL

Mar 12th, 2012
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.83 KB | None | 0 0
  1. CREATE  TABLE IF NOT EXISTS `categories` (
  2.   `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  3.   `name` VARCHAR(20) NOT NULL ,
  4.   PRIMARY KEY (`id`) )
  5. ENGINE = InnoDB;
  6.  
  7. CREATE  TABLE IF NOT EXISTS `events` (
  8.   `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  9.   `title` VARCHAR(30) NOT NULL ,
  10.   PRIMARY KEY (`event_id`))
  11. ENGINE = InnoDB;
  12.  
  13. CREATE  TABLE IF NOT EXISTS `eventcategories` (
  14.   `event_id` INT UNSIGNED NOT NULL ,
  15.   `category_id` INT UNSIGNED NOT NULL ,
  16.   INDEX `ecevent` (`event_id` ASC) ,
  17.   INDEX `eccategory` (`category_id` ASC) ,
  18.   CONSTRAINT `ecevent`
  19.     FOREIGN KEY (`event_id` )
  20.     REFERENCES `events` (`id` )
  21.     ON DELETE CASCADE
  22.     ON UPDATE CASCADE,
  23.   CONSTRAINT `eccategory`
  24.     FOREIGN KEY (`category_id` )
  25.     REFERENCES `categories` (`id` )
  26.     ON DELETE RESTRICT
  27.     ON UPDATE CASCADE)
  28. ENGINE = InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement