Advertisement
Guest User

Untitled

a guest
Nov 18th, 2012
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.26 KB | None | 0 0
  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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement