From a7b11aa41a7247f149962327e0bb4833f2a2e68f Mon Sep 17 00:00:00 2001 From: einhverfr Date: Tue, 31 Oct 2006 05:42:52 +0000 Subject: Moving Pg-upgrade* into sql/legacy directory git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@420 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100755 sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql (limited to 'sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql') diff --git a/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql b/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql new file mode 100755 index 00000000..5d3b9b9d --- /dev/null +++ b/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql @@ -0,0 +1,31 @@ +-- +alter table ar add ponumber text; +alter table ap add ponumber text; +alter table oe add ponumber text; +-- +alter table project add startdate date; +alter table project add enddate date; +-- +create table recurring (id int, reference text, startdate date, nextdate date, enddate date, repeat int2, unit varchar(6), howmany int, payment bool default 'f'); +create table recurringemail (id int, formname text, format text, message text); +create table recurringprint (id int, formname text, format text, printer text); +-- +create function del_recurring() returns opaque as ' +begin + delete from recurring where id = old.id; + delete from recurringemail where id = old.id; + delete from recurringprint where id = old.id; + return NULL; +end; +' language 'plpgsql'; +--end function +create trigger del_recurring after delete on ar for each row execute procedure del_recurring(); +-- end trigger +create trigger del_recurring after delete on ap for each row execute procedure del_recurring(); +-- end trigger +create trigger del_recurring after delete on gl for each row execute procedure del_recurring(); +-- end trigger +create trigger del_recurring after delete on oe for each row execute procedure del_recurring(); +-- end trigger +-- +update defaults set version = '2.5.0'; -- cgit v1.2.3