Initial Import

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/ledger-smb@1 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 47 insertions, 0 deletions

diff --git a/sql/DB2-remove.sql b/sql/DB2-remove.sql
new file mode 100755
index 00000000..413bebb2
--- /dev/null
+++ b/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;