User Tools

Site Tools


podoc:files_sql_table

Database Table Description of "files"

Name

files

Description

Purpose

Table to keep track of individual image files.

Schema

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)
);

References tables

Is referenced by tables

None.

None.

History

Used first

Version 2.34

Used last

Still in use

Schema change history

= 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);
Data change history
podoc/files_sql_table.txt · Last modified: 2007/10/19 16:48 by Luud