SHARE
TWEET

Untitled

a guest Nov 18th, 2012 28 Never
  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>
RAW Paste Data
Top