Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Nov 18th, 2012  |  syntax: None  |  size: 2.26 KB  |  views: 28  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. mysql> show create table file;
  2. +-------+-----------------------------------------------------------------------
  3. --------------------------------------------------------------------------------
  4. --------------------------------------------------------------------------------
  5. --------------------------------------------------------------------------------
  6. --------------------------------------------------------------------------------
  7. --------------------------------------------------------------------------------
  8. ----------------------------------------------+
  9. | Table | Create Table
  10.  
  11.  
  12.  
  13.  
  14.  
  15.                                               |
  16. +-------+-----------------------------------------------------------------------
  17. --------------------------------------------------------------------------------
  18. --------------------------------------------------------------------------------
  19. --------------------------------------------------------------------------------
  20. --------------------------------------------------------------------------------
  21. --------------------------------------------------------------------------------
  22. ----------------------------------------------+
  23. | file  | CREATE TABLE `file` (
  24.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  25.   `dir` bigint(20) NOT NULL,
  26.   `name` bigint(20) NOT NULL,
  27.   `size` bigint(20) NOT NULL,
  28.   `mod` datetime NOT NULL,
  29.   `deleted` bit(1) NOT NULL,
  30.   PRIMARY KEY (`id`),
  31.   KEY `dir` (`dir`),
  32.   KEY `name` (`name`),
  33.   KEY `filesize` (`size`),
  34.   CONSTRAINT `file_ibfk_1` FOREIGN KEY (`dir`) REFERENCES `directory` (`id`),
  35.   CONSTRAINT `file_ibfk_2` FOREIGN KEY (`name`) REFERENCES `NameList` (`id`)
  36. ) ENGINE=InnoDB AUTO_INCREMENT=20801 DEFAULT CHARSET=utf8 |
  37. +-------+-----------------------------------------------------------------------
  38. --------------------------------------------------------------------------------
  39. --------------------------------------------------------------------------------
  40. --------------------------------------------------------------------------------
  41. --------------------------------------------------------------------------------
  42. --------------------------------------------------------------------------------
  43. ----------------------------------------------+
  44. 1 row in set (0.00 sec)
  45.  
  46. mysql>
clone this paste RAW Paste Data