SF.net SVN: ledger-smb: [733] trunk/sql/legacy

[..hidden..]

Revision: 733
          http://svn.sourceforge.net/ledger-smb/?rev=733&view=rev
Author:   einhverfr
Date:     2006-12-05 21:21:33 -0800 (Tue, 05 Dec 2006)

Log Message:
-----------
Applying Mads' patch to upgrade scripts

Modified Paths:
--------------
    trunk/sql/legacy/Pg-upgrade-2.3.0-2.3.1.sql
    trunk/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql
    trunk/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql
    trunk/sql/legacy/Pg-upgrade-2.5.0-2.5.2.sql

Modified: trunk/sql/legacy/Pg-upgrade-2.3.0-2.3.1.sql
===================================================================
--- trunk/sql/legacy/Pg-upgrade-2.3.0-2.3.1.sql	2006-12-06 04:16:56 UTC (rev 732)
+++ trunk/sql/legacy/Pg-upgrade-2.3.0-2.3.1.sql	2006-12-06 05:21:33 UTC (rev 733)
@@ -1,5 +1,5 @@
 -- function check_department
-create function check_department() returns opaque as '
+create function check_department() returns trigger as '
 
 declare
   dpt_id int;
@@ -28,7 +28,7 @@
 create table dpt_trans (trans_id int, department_id int);
 
 -- function del_department
-create function del_department() returns opaque as '
+create function del_department() returns trigger as '
 begin
   delete from dpt_trans where trans_id = old.id;
   return NULL;
@@ -73,7 +73,7 @@
 alter table customer add column taxnumber text;
 alter table customer add column sic_code text;
 --
-create function del_customer() returns opaque as '
+create function del_customer() returns trigger as '
 begin
   delete from shipto where trans_id = old.id;
   delete from customertax where customer_id = old.id;
@@ -82,7 +82,7 @@
 ' language 'plpgsql';
 -- end function
 --
-create function del_vendor() returns opaque as '
+create function del_vendor() returns trigger as '
 begin
   delete from shipto where trans_id = old.id;
   delete from vendortax where vendor_id = old.id;
@@ -105,7 +105,7 @@
 alter table vendor add creditlimit float;
 --
 -- function del_exchangerate
-create function del_exchangerate() returns opaque as '
+create function del_exchangerate() returns trigger as '
 
 declare
   t_transdate date;
@@ -180,19 +180,13 @@
 --
 --
 create sequence orderitemsid maxvalue 100000 cycle;
-alter table orderitems add id int;
-alter table orderitems alter id set default nextval('orderitemsid');
+-- add id to orderitems, fill in id
+alter table orderitems add id int default nextval('orderitemsid');
 --
 create table warehouse (id int default nextval('id'), description text);
 --
 create table inventory (warehouse_id int, parts_id int, oe_id int, orderitems_id int, qty float4, shippingdate date);
 --
--- update orderitems, fill in id
-create table temp (id int default nextval('orderitemsid'), tempid oid);
-insert into temp (tempid) select oid from orderitems;
-update orderitems set id = temp.id from temp where orderitems.oid = temp.tempid;
-drop table temp;
---
 create index orderitems_id_key on orderitems (id);
 --
 alter table ar add shipvia text;
@@ -203,7 +197,7 @@
 alter table inventory add employee_id int;
 --
 --
-create function check_inventory() returns opaque as '
+create function check_inventory() returns trigger as '
 
 declare
   itemid int;
@@ -235,7 +229,7 @@
 );
 --
 -- function del_yearend
-create function del_yearend() returns opaque as '
+create function del_yearend() returns trigger as '
 begin
   delete from yearend where trans_id = old.id;
   return NULL;

Modified: trunk/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql
===================================================================
--- trunk/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql	2006-12-06 04:16:56 UTC (rev 732)
+++ trunk/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql	2006-12-06 05:21:33 UTC (rev 733)
@@ -4,7 +4,7 @@
 drop function del_customer();
 drop function del_vendor();
 --
-create function del_customer() returns opaque as '
+create function del_customer() returns trigger as '
 begin
   delete from shipto where trans_id = old.id;
   delete from customertax where customer_id = old.id;
@@ -17,7 +17,7 @@
 create trigger del_customer after delete on customer for each row execute procedure del_customer();
 -- end trigger
 --
-create function del_vendor() returns opaque as '
+create function del_vendor() returns trigger as '
 begin
   delete from shipto where trans_id = old.id;
   delete from vendortax where vendor_id = old.id;

Modified: trunk/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql
===================================================================
--- trunk/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql	2006-12-06 04:16:56 UTC (rev 732)
+++ trunk/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql	2006-12-06 05:21:33 UTC (rev 733)
@@ -10,7 +10,7 @@
 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 '
+create function del_recurring() returns trigger as '
 begin
   delete from recurring where id = old.id;
   delete from recurringemail where id = old.id;

Modified: trunk/sql/legacy/Pg-upgrade-2.5.0-2.5.2.sql
===================================================================
--- trunk/sql/legacy/Pg-upgrade-2.5.0-2.5.2.sql	2006-12-06 04:16:56 UTC (rev 732)
+++ trunk/sql/legacy/Pg-upgrade-2.5.0-2.5.2.sql	2006-12-06 05:21:33 UTC (rev 733)
@@ -76,7 +76,7 @@
 --
 drop trigger check_inventory on oe;
 drop function check_inventory();
-create function check_inventory() returns opaque as '
+create function check_inventory() returns trigger as '
 
 declare
   itemid int;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.