Photo Organizer

film_iso

CREATE TABLE film_iso (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

None.

• film_type(format) references identifier
• photo_tech(iso_override) references identifier

• film_iso_id_sequence

None.

None.

• view_film
• view_film_type

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE film_iso (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

= Version 2.5 =

INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '6');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '8');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '10');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '12');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '16');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '20');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '25');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '32');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '40');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '50');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '80');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '100');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '125');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '160');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '200');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '250');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '320');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '400');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '500');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '640');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '800');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '1000');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '1250');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '1600');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '2000');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '2500');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '3200');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '4000');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '5000');
INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '6400');

= Version 2.27 =

INSERT INTO film_iso VALUES (NEXTVAL('film_iso_id_sequence'), '64');
ALTER TABLE film_iso ADD COLUMN value_2 INTEGER;
UPDATE film_iso SET value_2 = to_number(VALUE, '9999');
ALTER TABLE film_iso DROP COLUMN VALUE;
ALTER TABLE film_iso RENAME COLUMN value_2 TO VALUE;