Datenbank ohne „unique“-Eigenschaft für den Dateinamen:
CREATE TABLE `exif2csv` (
`filename` varchar(255) NOT NULL,
`sourcefile` varchar(1024) NOT NULL,
`directory` varchar(1024) NOT NULL,
`filetype` varchar(10) NOT NULL,
`make` varchar(255) NOT NULL,
`model` varchar(255) NOT NULL,
`artist` varchar(64) NOT NULL,
`datetimeoriginal` datetime NOT NULL,
`createdate` datetime NOT NULL,
`shuttercount` int(11) NOT NULL,
KEY `createdate` (`createdate`),
KEY `sourcefile` (`sourcefile`(768)) USING HASH,
KEY `filename` (`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Daten aus dem Skript exif2csv'
Datenbank mit „unique“-Eigenschaft für den Dateinamen:
CREATE TABLE `exif2csv_unique` (
`filename` varchar(255) NOT NULL,
`sourcefile` varchar(1024) NOT NULL,
`directory` varchar(1024) NOT NULL,
`filetype` varchar(10) NOT NULL,
`make` varchar(255) NOT NULL,
`model` varchar(255) NOT NULL,
`artist` varchar(64) NOT NULL,
`datetimeoriginal` datetime NOT NULL,
`createdate` datetime NOT NULL,
`shuttercount` int(11) NOT NULL,
UNIQUE KEY `sourcefile` (`sourcefile`) USING HASH,
KEY `createdate` (`createdate`),
KEY `filename` (`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Daten aus dem Skript exif2csv'