photos_table.sql 908 B

123456789101112131415161718192021222324252627
  1. # Dump of table lychee_photos
  2. # Version 2.5
  3. # ------------------------------------------------------------
  4. CREATE TABLE IF NOT EXISTS `lychee_photos` (
  5. `id` bigint(14) NOT NULL,
  6. `title` varchar(50) NOT NULL,
  7. `description` varchar(1000) DEFAULT '',
  8. `url` varchar(100) NOT NULL,
  9. `tags` varchar(1000) NOT NULL DEFAULT '',
  10. `public` tinyint(1) NOT NULL,
  11. `type` varchar(10) NOT NULL,
  12. `width` int(11) NOT NULL,
  13. `height` int(11) NOT NULL,
  14. `size` varchar(20) NOT NULL,
  15. `iso` varchar(15) NOT NULL,
  16. `aperture` varchar(20) NOT NULL,
  17. `make` varchar(50) NOT NULL,
  18. `model` varchar(50) NOT NULL,
  19. `shutter` varchar(30) NOT NULL,
  20. `focal` varchar(20) NOT NULL,
  21. `takestamp` int(11) DEFAULT NULL,
  22. `star` tinyint(1) NOT NULL,
  23. `thumbUrl` varchar(50) NOT NULL,
  24. `album` varchar(30) NOT NULL DEFAULT '0',
  25. PRIMARY KEY (`id`)
  26. ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;