From ea383fecc03ff242fe7e0b6b64e2ace82aa8f5d8 Mon Sep 17 00:00:00 2001
From: linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sat, 9 Sep 2006 17:20:12 +0000
Subject: Remove all non Pg Ports, they were unsupported and LedgerSMB is a Pg
 only project now.

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@47 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Oracle-upgrade-1.8.4-1.8.5.sql | 77 --------------------------------------
 1 file changed, 77 deletions(-)
 delete mode 100755 sql/Oracle-upgrade-1.8.4-1.8.5.sql

(limited to 'sql/Oracle-upgrade-1.8.4-1.8.5.sql')

diff --git a/sql/Oracle-upgrade-1.8.4-1.8.5.sql b/sql/Oracle-upgrade-1.8.4-1.8.5.sql
deleted file mode 100755
index d228b9ee..00000000
--- a/sql/Oracle-upgrade-1.8.4-1.8.5.sql
+++ /dev/null
@@ -1,77 +0,0 @@
---
-ALTER TABLE customer ADD (customernumber VARCHAR2(40));
-UPDATE customer SET customernumber = businessnumber;
-ALTER TABLE customer DROP COLUMN businessnumber;
-CREATE INDEX customer_customernumber_key ON customer (customernumber);
---
-ALTER TABLE vendor ADD (vendornumber VARCHAR2(40));
-UPDATE vendor SET vendornumber = businessnumber;
-ALTER TABLE vendor DROP COLUMN businessnumber;
-CREATE INDEX vendor_vendornumber_key ON vendor (vendornumber);
---
-CREATE TABLE employee (
-  id INTEGER,
-  login VARCHAR2(20),
-  name VARCHAR2(35),
-  addr1 VARCHAR2(35),
-  addr2 VARCHAR2(35),
-  addr3 VARCHAR2(35),
-  addr4 VARCHAR2(35),
-  workphone VARCHAR2(20),
-  homephone VARCHAR2(20),
-  startdate DATE DEFAULT SYSDATE,
-  enddate DATE,
-  notes VARCHAR2(4000)
-);
---
-CREATE OR REPLACE TRIGGER employeeid BEFORE INSERT ON employee FOR EACH ROW
-BEGIN
-  SELECT id.nextval
-  INTO :new.id
-  FROM DUAL;--
-END;;
---
-CREATE INDEX employee_id_key ON employee (id);
-CREATE UNIQUE INDEX employee_login_key ON employee (login);
-CREATE INDEX employee_name_key ON employee (name);
---
-ALTER TABLE gl ADD (employee_id INTEGER);
-CREATE INDEX gl_employee_id_key ON gl (employee_id);
-ALTER TABLE ar ADD (employee_id INTEGER);
-CREATE INDEX ar_employee_id_key ON ar (employee_id);
-ALTER TABLE ap ADD (employee_id INTEGER);
-CREATE INDEX ap_employee_id_key ON ap (employee_id);
-ALTER TABLE oe ADD (employee_id INTEGER);
-CREATE INDEX oe_employee_id_key ON oe (employee_id);
---
-ALTER TABLE invoice ADD (unit VARCHAR2(5));
-ALTER TABLE orderitems ADD (unit VARCHAR2(5));
---
-UPDATE chart SET gifi_accno = '' WHERE gifi_accno = NULL;
-ALTER TABLE chart RENAME TO chartold;
-CREATE TABLE chart (
-  id INTEGER,
-  accno VARCHAR2(20) NOT NULL,
-  description VARCHAR2(100),
-  charttype CHAR(1) DEFAULT 'A',
-  category CHAR(1),
-  link VARCHAR2(100),
-  gifi_accno VARCHAR2(20)
-);
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno) SELECT id, accno, description, charttype, category, link, gifi_accno from chartold;
-DROP TABLE chartold;
-CREATE INDEX chart_id_key ON chart (id);
-CREATE UNIQUE INDEX chart_accno_key ON chart (accno);
-CREATE INDEX chart_category_key ON chart (category);
-CREATE INDEX chart_link_key ON chart (link);
-CREATE INDEX chart_gifi_accno_key ON chart (gifi_accno);
---
-ALTER TABLE parts MODIFY inventory_accno_id;
---
-ALTER TABLE defaults ADD (sonumber VARCHAR2(30));
-UPDATE defaults SET sonumber = ordnumber;
-ALTER TABLE defaults DROP COLUMN ordnumber;
-ALTER TABLE defaults ADD (ponumber VARCHAR2(30));
---
-UPDATE defaults SET version = '1.8.5';
---
-- 
cgit v1.2.3

