From 32a7b3767cf974884815aba83f4684152220b59e Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Mon, 16 Apr 2007 20:45:12 +0000
Subject: Rolling back tentative db commits for 1.3 pending Josh D's redesign
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1074 4979c152-3d1c-0410-bac9-87ea11338e46
---
sql/upgrade/1.2-1.3.sql | 28 ----------------------------
1 file changed, 28 deletions(-)
(limited to 'sql/upgrade')
diff --git a/sql/upgrade/1.2-1.3.sql b/sql/upgrade/1.2-1.3.sql
index d12ca25a..e69de29b 100644
--- a/sql/upgrade/1.2-1.3.sql
+++ b/sql/upgrade/1.2-1.3.sql
@@ -1,28 +0,0 @@
-BEGIN;
-
-ALTER TABLE employee RENAME TO employees;
-
-CREATE TABLE locations (
- id SERIAL PRIMARY KEY,
- companyname text,
- address1 text,
- address2 text,
- city text,
- state text,
- country text,
- zipcode text
-);
-
-CREATE SEQUENCE employees_id_seq;
-SELECT setval('employees_id_seq', (select max(id) + 1 FROM employees));
-
-ALTER TABLE employees ADD COLUMN locations_id integer;
-ALTER TABLE employees ADD FOREIGN KEY (locations_id) REFERENCES locations(id);
-ALTER TABLE employees ALTER COLUMN id DROP DEFAULT;
-ALTER TABLE employees ALTER COLUMN id SET DEFAULT nextval('employee_id_seq');
-
-DROP RULE employee_id_track_i ON employees; -- no longer needed
-
-CREATE TABLE account_links AS
-
-COMMIT;
--
cgit v1.2.3