From 32306b5f8ffe4ce594409aa6e89626740b225a39 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 15 Nov 2004 10:35:56 +0000
Subject: import sql-ledger 2.4.4

---
 sql-ledger/sql/DB2-remove.sql | 47 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 47 insertions(+)
 create mode 100644 sql-ledger/sql/DB2-remove.sql

(limited to 'sql-ledger/sql/DB2-remove.sql')

diff --git a/sql-ledger/sql/DB2-remove.sql b/sql-ledger/sql/DB2-remove.sql
new file mode 100644
index 000000000..413bebb2d
--- /dev/null
+++ b/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;
-- 
cgit v1.2.1