1 DROP SCEMA reporter CASCADE;
2 CREATE SCHEMA reporter;
6 CREATE TABLE reporter.stage2 (
9 filename text not null,
13 create_date timestamp with time zone not null
15 edit_date timestamp with time zone not null
19 CREATE OR REPLACE FUNCTION reporter.force_edit_date_update () RETURNS TRIGGER AS $$
21 NEW.edit_date = NOW();
26 CREATE TRIGGER force_edit_date_update_trig
27 BEFORE UPDATE ON reporter.stage2
29 EXECUTE PROCEDURE reporter.force_edit_date_update ();
31 CREATE TABLE reporter.stage3 (
32 id serial primary key,
34 references reporter.stage2 (id)
38 filename text not null,
42 create_date timestamp with time zone not null