podoc:orientations_sql_table
This is an old revision of the document!
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.
Related sequences
Related indexes
None.
Related functions
None.
Related views
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.1177076600.txt.gz · Last modified: 2007/04/20 13:43 by Luud