From 705245329bb81c7f237c8b24de1ca4fd1822e05b Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sat, 8 Dec 2007 02:38:53 +0000
Subject: Removing sql/legacy-- will package new download from the files in
 branches/1.2

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

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

diff --git a/sql/legacy/Pg-upgrade-1.8.4-1.8.5.sql b/sql/legacy/Pg-upgrade-1.8.4-1.8.5.sql
deleted file mode 100755
index 807857aa..00000000
--- a/sql/legacy/Pg-upgrade-1.8.4-1.8.5.sql
+++ /dev/null
@@ -1,63 +0,0 @@
---
-alter table customer rename column businessnumber to customernumber;
-create index customer_customernumber_key on customer (customernumber);
-alter table vendor rename column businessnumber to vendornumber;
-create index vendor_vendornumber_key on vendor (vendornumber);
---
-CREATE TABLE employee (
-  id int DEFAULT nextval ('id'),
-  login text,
-  name varchar(35),
-  addr1 varchar(35),
-  addr2 varchar(35),
-  addr3 varchar(35),
-  addr4 varchar(35),
-  workphone varchar(20),
-  homephone varchar(20),
-  startdate date default current_date,
-  enddate date,
-  notes text
-);
---
-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 column employee_id int;
-create index gl_employee_id_key on gl (employee_id);
-alter table ar add column employee_id int;
-create index ar_employee_id_key on ar (employee_id);
-alter table ap add column employee_id int;
-create index ap_employee_id_key on ap (employee_id);
-alter table oe add column employee_id int;
-create index oe_employee_id_key on oe (employee_id);
---
-alter table invoice add column unit varchar(5);
-alter table orderitems add column unit varchar(5);
---
-update chart set gifi_accno = '' where gifi_accno = NULL;
-alter table chart rename to chartold;
-CREATE TABLE chart (
-  id int DEFAULT nextval ('id'),
-  accno text NOT NULL,
-  description text,
-  charttype char(1) DEFAULT 'A',
-  category char(1),
-  link text,
-  gifi_accno text
-);
-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 alter column inventory_accno_id drop default;
---
-alter table defaults rename ordnumber to sonumber;
-alter table defaults add column ponumber text;
---
-update defaults set version = '1.8.5', ponumber = sonumber;
---
-- 
cgit v1.2.3

