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
- photo_version references photo_version(identifier)
Is referenced by tables
- users(imagemagick_composite_options) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
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