18 lines
468 B
SQL
18 lines
468 B
SQL
CREATE TABLE `photo` (
|
|
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
|
|
`src` text(256) NOT NULL,
|
|
`width` integer NOT NULL,
|
|
`height` integer NOT NULL,
|
|
`blur` blob NOT NULL,
|
|
`camera` text(128),
|
|
`title` text(128),
|
|
`description` text,
|
|
`exposureBiasValue` integer,
|
|
`fNumber` real,
|
|
`isoSpeedRatings` integer,
|
|
`focalLength` integer,
|
|
`takenAt` integer,
|
|
`lensModel` text(128)
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE UNIQUE INDEX `photo_src_unique` ON `photo` (`src`); |