Photo Organizer

imagemagick_composite_options

CREATE TABLE imagemagick_composite_options (
  identifier              INTEGER NOT NULL PRIMARY KEY,
  gravity                 VARCHAR(20) CHECK (gravity IN ('center', 'northwest', 'north', 'northeast', 'west', 'center', 'east', 'southwest', 'south', 'southeast')),
  watermark               INTEGER NOT NULL,
  photo_version           INTEGER REFERENCES photo_version(identifier)
);

• photo_version references photo_version(identifier)

• users(imagemagick_composite_options) references identifier

• imagemagick_composite_options_id_sequence

None.

None.

None.

Version 2.21

Version 2.33

= Version 2.21 =

CREATE TABLE imagemagick_composite_options (
  identifier              INTEGER NOT NULL PRIMARY KEY,
  gravity                 VARCHAR(20) CHECK (gravity IN ('center', 'northwest', 'north', 'northeast', 'west', 'center', 'east', 'southwest', 'south', 'southeast')),
  watermark               INTEGER NOT NULL,
  photo_version           INTEGER REFERENCES photo_version(identifier)
);

= Version 2.34 =

DROP TABLE imagemagick_composite_options;

= Version 2.21 =

INSERT INTO imagemagick_composite_options (identifier, gravity, watermark, photo_version) SELECT imagemagick_options, 'southeast' AS gravity, 50 AS watermark, NULL AS photo_version FROM users;