# Dump of table lychee_photos # ------------------------------------------------------------ CREATE TABLE IF NOT EXISTS `?` ( `id` bigint(14) NOT NULL, `title` varchar(100) NOT NULL, `description` varchar(1000) DEFAULT '', `url` varchar(100) NOT NULL, `tags` varchar(1000) NOT NULL DEFAULT '', `public` tinyint(1) NOT NULL, `type` varchar(10) NOT NULL, `width` int(11) NOT NULL, `height` int(11) NOT NULL, `size` varchar(20) NOT NULL, `iso` varchar(15) NOT NULL, `aperture` varchar(20) NOT NULL, `make` varchar(50) NOT NULL, `model` varchar(50) NOT NULL, `shutter` varchar(30) NOT NULL, `focal` varchar(20) NOT NULL, `takestamp` int(11) DEFAULT NULL, `star` tinyint(1) NOT NULL, `thumbUrl` varchar(50) NOT NULL, `album` varchar(30) NOT NULL DEFAULT '0', `checksum` VARCHAR(100) DEFAULT NULL, `medium` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;