User Tools

Site Tools


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

None.

None.

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 10:28 by Luud