diff options
author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-12-08 02:38:53 +0000 |
---|---|---|
committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-12-08 02:38:53 +0000 |
commit | 705245329bb81c7f237c8b24de1ca4fd1822e05b (patch) | |
tree | bb412077edf650bb2f3a7ca5743cc52bfaa9669f /sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql | |
parent | dcf0f09c7da42575e8df2592a1b980517823bc08 (diff) |
Removing sql/legacy-- will package new download from the files in branches/1.2
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1964 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql')
-rwxr-xr-x | sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql | 31 |
1 files changed, 0 insertions, 31 deletions
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 deleted file mode 100755 index 82da5cd6..00000000 --- a/sql/legacy/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 trigger 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'; |