reverting change to db structure for now

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

1 files changed, 28 insertions, 0 deletions

diff --git a/sql/upgrade/1.2-1.3.sql b/sql/upgrade/1.2-1.3.sql
index e69de29b..d12ca25a 100644
--- a/sql/upgrade/1.2-1.3.sql
+++ b/sql/upgrade/1.2-1.3.sql
@@ -0,0 +1,28 @@
+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;