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/Pg-upgrade-2.4.4-2.5.0.sql | 31 ------------------------------- 1 file changed, 31 deletions(-) delete mode 100755 sql/Pg-upgrade-2.4.4-2.5.0.sql (limited to 'sql/Pg-upgrade-2.4.4-2.5.0.sql') diff --git a/sql/Pg-upgrade-2.4.4-2.5.0.sql b/sql/Pg-upgrade-2.4.4-2.5.0.sql deleted file mode 100755 index 5d3b9b9d..00000000 --- a/sql/Pg-upgrade-2.4.4-2.5.0.sql +++ /dev/null @@ -1,31 +0,0 @@ --- -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