SF.net SVN: ledger-smb: [1075] trunk/sql/upgrade/1.2-1.3.sql

[..hidden..]

Revision: 1075
          http://svn.sourceforge.net/ledger-smb/?rev=1075&view=rev
Author:   einhverfr
Date:     2007-04-17 11:24:57 -0700 (Tue, 17 Apr 2007)

Log Message:
-----------
reverting change to db structure for now

Modified Paths:
--------------
    trunk/sql/upgrade/1.2-1.3.sql

Modified: trunk/sql/upgrade/1.2-1.3.sql
===================================================================
--- trunk/sql/upgrade/1.2-1.3.sql	2007-04-16 20:45:12 UTC (rev 1074)
+++ trunk/sql/upgrade/1.2-1.3.sql	2007-04-17 18:24:57 UTC (rev 1075)
@@ -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;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.