User Tools

Site Tools


podoc:orientations_sql_table

Database Table Description of "orientations"

Name

orientations

Description

Purpose

Schema

CREATE TABLE orientations (
  identifier             INTEGER NOT NULL PRIMARY KEY,
  name                   VARCHAR(100),
  im_transform           VARCHAR(100)
);

References tables

None.

Is referenced by tables

None.

None.

None.

History

Used first

Version 2.26

Used last

Still in use

Schema change history

= Version 2.26 =

CREATE TABLE orientations (
  identifier             INTEGER NOT NULL PRIMARY KEY,
  name                   VARCHAR(100),
  im_transform           VARCHAR(100)
);
Data change history

= 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 ');
podoc/orientations_sql_table.txt · Last modified: 2007/04/20 14:10 by Luud