podoc:film_iso_sql_table
Database Table Description of "film_iso"
Name
film_iso
Description
Purpose
Schema
CREATE TABLE film_iso ( identifier INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10) );
References tables
None.
Is referenced by tables
- film_type(format) references identifier
- photo_tech(iso_override) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
History
Used first
Version 2.5
Used last
Still in use
Schema change history
= Version 2.5 =
CREATE TABLE film_iso ( identifier INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10) );
Data change history
= 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;
podoc/film_iso_sql_table.txt · Last modified: 2007/04/20 14:28 by Luud