openphoto/frontend — comment on commit 0c5c6cdf3bce51897af474375ec56afa5b8910cb
File: src/configs/upgrade/db/mysql/mysql-schema-1.0.0.sql line 104
By jmathai:

Proposing this as the `op_table` structure.

CREATE TABLE IF NOT EXISTS `op_photo` (
`id` varchar(6) NOT NULL,
`owner` varchar(255) NOT NULL,
`appId` varchar(255) NOT NULL,
`host` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`description` text,
`key` varchar(255) DEFAULT NULL,
`hash` varchar(255) DEFAULT NULL,
`size` int(11) DEFAULT NULL,
`width` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`extra` varchar(1000) DEFAULT NULL,
`views` int(11) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`permission` int(11) DEFAULT NULL,
`license` varchar(255) DEFAULT NULL,
`dateTaken` int(11) DEFAULT NULL,
`dateTakenDay` int(11) DEFAULT NULL,
`dateTakenMonth` int(11) DEFAULT NULL,
`dateTakenYear` int(11) DEFAULT NULL,
`dateUploaded` int(11) DEFAULT NULL,
`dateUploadedDay` int(11) DEFAULT NULL,
`dateUploadedMonth` int(11) DEFAULT NULL,
`dateUploadedYear` int(11) DEFAULT NULL,
`pathOriginal` varchar(1000) DEFAULT NULL,
`pathBase` varchar(1000) DEFAULT NULL,
`tags` text,
UNIQUE KEY `id` (`id`,`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;