files

Table to keep track of individual image files.

CREATE TABLE files (
        identifier integer PRIMARY KEY,
        version    integer REFERENCES photo_version(identifier) NOT NULL,
        size       integer NOT NULL,
        x_res      integer NOT NULL,
        y_res      integer NOT NULL,
        path       text NOT NULL,
        created    timestamp without time zone NOT NULL,
        filesize   integer NOT NULL,
        params     text NOT NULL,
        comments   text,
        watermark  integer REFERENCES photo_version(identifier)
);

• version references photo_version(identifier)

• contact_info(state) references identifier
• location(state) references identifier

• files_id_sequence

• files_version_idx

None.

None.

Version 2.34

Still in use

= Version 2.34 =

--  Add a table to keep track of individual image files.
 
CREATE TABLE files (
        identifier integer PRIMARY KEY,
        version integer REFERENCES photo_version(identifier) NOT NULL,
        size integer NOT NULL,
        x_res integer NOT NULL,
        y_res integer NOT NULL,
        path text NOT NULL,
        created timestamp without time zone NOT NULL,
        filesize integer NOT NULL,
        params text NOT NULL,
        watermarked BOOLEAN NOT NULL,
        comments text
);

-- Update the files table to be smarter about watermarks
ALTER TABLE files DROP COLUMN watermarked;
ALTER TABLE files ADD COLUMN watermark integer REFERENCES photo_version(identifier);