1 DROP SCHEMA reporter CASCADE;
3 CREATE SCHEMA reporter;
7 CREATE TABLE reporter.stage1 (
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 TABLE reporter.stage2 (
20 id serial primary key,
22 references reporter.stage1 (id)
26 filename text not null,
30 create_date timestamp with time zone not null
32 edit_date timestamp with time zone not null
36 CREATE OR REPLACE FUNCTION reporter.force_edit_date_update () RETURNS TRIGGER AS $$
38 NEW.edit_date = NOW();
43 CREATE TRIGGER force_edit_date_update_trig
44 BEFORE UPDATE ON reporter.stage2
46 EXECUTE PROCEDURE reporter.force_edit_date_update ();
48 CREATE TABLE reporter.stage3 (
49 id serial primary key,
51 references reporter.stage2 (id)
55 filename text not null,
59 create_date timestamp with time zone not null