Advertisement
Guest User

Untitled

a guest
May 9th, 2012
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.69 KB | None | 0 0
  1. mysql> USE test;
  2. Reading TABLE information FOR completion OF TABLE AND COLUMN names
  3. You can turn off this feature TO GET a quicker startup WITH -A
  4.  
  5. DATABASE changed
  6. mysql> CREATE TABLE `item` (
  7.     ->     `id` INT(11) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  8.     ->     `name` VARCHAR(30) NOT NULL,
  9.     ->     `description` MEDIUMTEXT
  10.     -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  11.  
  12. CREATE TABLE `image` (
  13.     `id` INT(11) UNSIGNED AUTO_INCREMENT,
  14.     `file` VARCHAR(255) UNIQUE NOT NULL,
  15.     `caption` VARCHAR(255),
  16.     PRIMARY KEY(`id`)
  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;Query OK, 0 ROWS affected (0.06 sec)
  18.  
  19. mysql>
  20. mysql> CREATE TABLE `image` (
  21.     ->     `id` INT(11) UNSIGNED AUTO_INCREMENT,
  22.     ->     `file` VARCHAR(255) UNIQUE NOT NULL,
  23.     ->     `caption` VARCHAR(255),
  24.     ->     PRIMARY KEY(`id`)
  25.     -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  26. Query OK, 0 ROWS affected (0.06 sec)
  27.  
  28. mysql> CREATE TABLE `item_image` (
  29.     ->     `item` INT(11) UNSIGNED NOT NULL,#foreign KEY
  30.     ->     `img` INT(11) UNSIGNED NOT NULL,#foreign KEY
  31.     ->     PRIMARY KEY(`item`,`img`)
  32.     -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  33. Query OK, 0 ROWS affected (0.05 sec)
  34.  
  35. mysql> DROP TABLE item_image;
  36. Query OK, 0 ROWS affected (0.03 sec)
  37.  
  38. mysql> CREATE TABLE `item_image` (
  39.     ->     `item` INT(11) UNSIGNED NOT NULL,
  40.     ->     `img` INT(11) UNSIGNED NOT NULL,
  41.     ->     PRIMARY KEY(`item`,`img`),
  42.     ->     FOREIGN KEY(`item`)
  43.     ->         REFERENCES `item` (`id`)
  44.     ->         ON DELETE CASCADE,
  45.     ->     FOREIGN KEY(`img`)
  46.     ->         REFERENCES `image` (`id`)
  47.     ->         ON DELETE CASCADE
  48.     -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  49. Query OK, 0 ROWS affected (0.08 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement