summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-04-17 18:24:57 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-04-17 18:24:57 +0000
commitdd86414b916db1e2dd8da72c1d7504fa5ffdf409 (patch)
treeb7b07ac94cb2c8712f4cd12180a1fa434d0f7f9c /sql
parent32a7b3767cf974884815aba83f4684152220b59e (diff)
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
Diffstat (limited to 'sql')
-rw-r--r--sql/upgrade/1.2-1.3.sql28
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;