manufacturer
CREATE TABLE manufacturer ( identifier INTEGER NOT NULL PRIMARY KEY, name VARCHAR(100), url VARCHAR(100), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier) );
None.
None.
Version 2.5
Still in use
= Version 2.5 =
CREATE TABLE manufacturer ( identifier INTEGER NOT NULL PRIMARY KEY, name VARCHAR(100), url VARCHAR(100), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier) ); <code> == DATA CHANGE history == = Version 2.5 = <code sql> INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Avery', 'http://www.avery.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Canon', 'http://www.canon.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Fuji Film', 'http://www.fujifilm.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Hasselblad', 'http://www.hasselblad.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Kodak', 'http://www.kodak.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Mamiya', 'http://www.mamiya.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Minolta', 'http://www.minolta.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Nikon', 'http://www.nikon-image.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Olympus', 'http://www.olympus.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Pentax', 'http://www.pentax.com', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Rollei', 'http://www.rollei.de', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Sinar', 'http://www.sinar.ch', now(), 1); INSERT INTO manufacturer VALUES (NEXTVAL('manufacturer_id_sequence'), 'Sony', 'http://www.sony.com', now(), 1);