User Tools

Site Tools


podoc:imagemagick_composite_options_sql_table

Database Table Description of "imagemagick_composite_options"

Name

imagemagick_composite_options

Description

Purpose

Schema

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

References tables

Is referenced by tables

  • users(imagemagick_composite_options) references identifier

None.

None.

None.

History

Used first

Version 2.21

Used last

Version 2.33

Schema change history

= 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;
Data change history

= 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;
podoc/imagemagick_composite_options_sql_table.txt · Last modified: 2007/10/19 18:53 by Luud