import sql-ledger 2.4.4

[freeside.git] / sql-ledger / sql-ledger / sql / DB2-remove.sql

diff --git a/sql-ledger/sql-ledger/sql/DB2-remove.sql b/sql-ledger/sql-ledger/sql/DB2-remove.sql
new file mode 100644 (file)
index 0000000..413bebb
--- /dev/null
+++ b/sql-ledger/sql-ledger/sql/DB2-remove.sql
@@ -0,0 +1,47 @@
+-- DB2-remove.sql
+-- 
+-- 
+-- Jim Rawlings modified for use with SL 2.0.8 and DB2 v7.2 
+-- and higher August 27, 2003
+--
+--
+---------------------------------------------------------
+-- DDL Statements for object removal
+---------------------------------------------------------
+DROP TRIGGER partsgroupid;
+DROP TRIGGER projectid;
+DROP TRIGGER employeeid;
+DROP TRIGGER oeid;
+DROP TRIGGER apid;
+DROP TRIGGER arid;
+DROP TRIGGER partsid;
+DROP TRIGGER customerid;
+DROP TRIGGER vendorid;
+DROP TRIGGER invoiceid;
+DROP TRIGGER chartid;
+DROP TRIGGER glid;
+DROP SEQUENCE id RESTRICT;
+DROP TABLE partsgroup;
+DROP TABLE project;
+DROP TABLE shipto;
+DROP TABLE employee;
+DROP TABLE exchangerate;
+DROP TABLE orderitems;
+DROP TABLE oe;
+DROP TABLE vendortax;
+DROP TABLE customertax;
+DROP TABLE tax;
+DROP TABLE partstax;
+DROP TABLE ap;
+DROP TABLE ar;
+DROP TABLE assembly;
+DROP TABLE parts;
+DROP TABLE customer;
+DROP TABLE vendor;
+DROP TABLE invoice;
+DROP TABLE acc_trans;
+DROP TABLE defaults;
+DROP TABLE gifi;
+DROP TABLE chart;
+DROP TABLE gl;
+DROP TABLE makemodel;