film_iso
CREATE TABLE film_iso ( identifier INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10) );
None.
None.
None.
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;