summaryrefslogtreecommitdiff
path: root/sql/upgrade
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-04-16 20:45:12 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-04-16 20:45:12 +0000
commit32a7b3767cf974884815aba83f4684152220b59e (patch)
tree41f76b2bbf19ccc5ef61f7ba4d1b8912db2b54d3 /sql/upgrade
parent931df9e552022754005d6e5d4614f5a68199695c (diff)
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
Diffstat (limited to 'sql/upgrade')
-rw-r--r--sql/upgrade/1.2-1.3.sql28
1 files changed, 0 insertions, 28 deletions
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;