summaryrefslogtreecommitdiff
path: root/sql/upgrade
diff options
context:
space:
mode:
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;