3 alter table pohead add column pohead_location_id INTEGER DEFAULT 0;
5 CREATE INDEX pohead_location_id_ix ON pohead USING btree (pohead_location_id);
7 alter table pohead add column pohead_bg_va TEXT;
9 alter table pohead add column pohead_bg_arrival_est_day DATE;
11 alter table pohead add column pohead_bg_available_est_day DATE;
13 alter table pohead add column pohead_bg_available_latest_day DATE;
15 alter table pohead add column pohead_last_updated DATE;
17 alter table pohead add column pohead_notes TEXT;
20 CREATE OR REPLACE FUNCTION pohead_last_updated() RETURNS trigger
26 NEW.pohead_last_updated := NOW()::DATE;
32 LANGUAGE plpgsql VOLATILE
35 ALTER FUNCTION pohead_last_updated()
39 CREATE TRIGGER _pohead_last_updated
40 BEFORE INSERT OR UPDATE ON pohead
41 FOR EACH ROW EXECUTE PROCEDURE pohead_last_updated();