Core table COU columns

Text

ALTER TABLE osmm.boundaryline ADD COLUMN version_date date;
COMMIT;
UPDATE osmm.boundaryline SET version_date = versiondate::date;
COMMIT;

ALTER TABLE osmm.boundaryline ADD COLUMN start_date date;
COMMIT;
UPDATE osmm.boundaryline SET start_date = '050106';
COMMIT;

ALTER TABLE osmm.boundaryline ADD COLUMN change_date date;
COMMIT;
UPDATE osmm.boundaryline SET change_date = '301231';
COMMIT;

ALTER TABLE osmm.boundaryline ADD COLUMN status varchar(1);
COMMIT;
UPDATE osmm.boundaryline SET status = 'L';
COMMIT;

ALTER TABLE osmm.cartographicsymbol ADD COLUMN version_date date;
COMMIT;
UPDATE osmm.cartographicsymbol SET version_date = versiondate::date;
COMMIT;

ALTER TABLE osmm.cartographicsymbol ADD COLUMN start_date date;
COMMIT;
UPDATE osmm.cartographicsymbol SET start_date = '050106';
COMMIT;

ALTER TABLE osmm.cartographicsymbol ADD COLUMN change_date date;
COMMIT;
UPDATE osmm.cartographicsymbol SET change_date = '301231';
COMMIT;

ALTER TABLE osmm.cartographicsymbol ADD COLUMN status varchar(1);
COMMIT;
UPDATE osmm.cartographicsymbol SET status = 'L';
COMMIT;

ALTER TABLE osmm.cartographictext ADD COLUMN version_date date;
COMMIT;
UPDATE osmm.cartographictext SET version_date = versiondate::date;
COMMIT;

ALTER TABLE osmm.cartographictext ADD COLUMN start_date date;
COMMIT;
UPDATE osmm.cartographictext SET start_date = '050106';
COMMIT;

ALTER TABLE osmm.cartographictext ADD COLUMN change_date date;
COMMIT;
UPDATE osmm.cartographictext SET change_date = '301231';
COMMIT;

ALTER TABLE osmm.cartographictext ADD COLUMN status varchar(1);
COMMIT;
UPDATE osmm.cartographictext SET status = 'L';
COMMIT;


ALTER TABLE osmm.topographicarea ADD COLUMN version_date date;
COMMIT;
UPDATE osmm.topographicarea SET version_date = versiondate::date;
COMMIT;

ALTER TABLE osmm.topographicarea ADD COLUMN start_date date;
COMMIT;
UPDATE osmm.topographicarea SET start_date = '050106';
COMMIT;

ALTER TABLE osmm.topographicarea ADD COLUMN change_date date;
COMMIT;
UPDATE osmm.topographicarea SET change_date = '301231';
COMMIT;

ALTER TABLE osmm.topographicarea ADD COLUMN status varchar(1);
COMMIT;
UPDATE osmm.topographicarea SET status = 'L';
COMMIT;

ALTER TABLE osmm.topographicline ADD COLUMN version_date date;
COMMIT;
UPDATE osmm.topographicline SET version_date = versiondate::date;
COMMIT;

ALTER TABLE osmm.topographicline ADD COLUMN start_date date;
COMMIT;
UPDATE osmm.topographicline SET start_date = '050106';
COMMIT;

ALTER TABLE osmm.topographicline ADD COLUMN change_date date;
COMMIT;
UPDATE osmm.topographicline SET change_date = '301231';
COMMIT;

ALTER TABLE osmm.topographicline ADD COLUMN status varchar(1);
COMMIT;
UPDATE osmm.topographicline SET status = 'L';
COMMIT;

ALTER TABLE osmm.topographicpoint ADD COLUMN version_date date;
COMMIT;
UPDATE osmm.topographicpoint SET version_date = versiondate::date;
COMMIT;

ALTER TABLE osmm.topographicpoint ADD COLUMN start_date date;
COMMIT;
UPDATE osmm.topographicpoint SET start_date = '050106';
COMMIT;

ALTER TABLE osmm.topographicpoint ADD COLUMN change_date date;
COMMIT;
UPDATE osmm.topographicpoint SET change_date = '301231';
COMMIT;

ALTER TABLE osmm.topographicpoint ADD COLUMN status varchar(1);
COMMIT;
UPDATE osmm.topographicpoint SET status = 'L';
COMMIT;