orientations

CREATE TABLE orientations (
  identifier             integer NOT NULL PRIMARY KEY,
  name                   varchar(100),
  im_transform           varchar(100)
);

None.

• photo_version(photo) references identifier

• orientations_id_sequence

None.

None.

None.

Version 2.26

Still in use

= Version 2.26 =

CREATE TABLE orientations (
  identifier             integer NOT NULL PRIMARY KEY,
  name                   varchar(100),
  im_transform           varchar(100)
);

= Version 2.26 =

INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), 'Normal (0 deg)',      ' ');
INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), 'Mirrored',            ' -flop ');
INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), 'Upsidedown',          ' -rotate 180 ');
INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), 'Upsidedown Mirrored', ' -flip ');
INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), '90 deg CW Mirrored',  ' -flip -rotate 90 ');
INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), '90 deg CCW',          ' -rotate 270 ');
INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), '90 deg CCW Mirrored', ' -flop -rotate 90 ');
INSERT INTO orientations VALUES (NEXTVAL('orientations_id_sequence'), '90 deg CW',           ' -rotate 90 ');