From 0ca18bdebd500c752b7ae1dcc8f54c65fd2c25af Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sat, 1 Sep 2007 22:22:31 +0000
Subject: Moving employee table further up the creation script.

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1492 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Pg-database.sql | 36 ++++++++++++++++++------------------
 1 file changed, 18 insertions(+), 18 deletions(-)

(limited to 'sql')

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 8fca13ac..9b3b622b 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -530,6 +530,24 @@ ALTER TABLE company ADD COLUMN sic_code varchar;
 
 --
 --
+create table employee (
+  entity_id integer not null references entity(id) on delete cascade primary key,
+  entity_class_id integer references entity_class(id) not null check (entity_class_id = 3),
+  login text,
+  startdate date default current_date,
+  enddate date,
+  notes text,
+  role varchar(20),
+  sales bool default 'f',
+  ssn varchar(20),
+  iban varchar(34),
+  bic varchar(11),
+  managerid int,
+  employeenumber varchar(32),
+  dob date
+);
+
+COMMENT ON TABLE employee IS $$ Is a metadata table specific to employees $$;
 CREATE TABLE parts (
   id serial PRIMARY KEY,
   partnumber text,
@@ -748,24 +766,6 @@ CREATE TABLE exchangerate (
   PRIMARY KEY (curr, transdate)
 );
 --
-create table employee (
-  entity_id integer not null references entity(id) on delete cascade primary key,
-  entity_class_id integer references entity_class(id) not null check (entity_class_id = 3),
-  login text,
-  startdate date default current_date,
-  enddate date,
-  notes text,
-  role varchar(20),
-  sales bool default 'f',
-  ssn varchar(20),
-  iban varchar(34),
-  bic varchar(11),
-  managerid int,
-  employeenumber varchar(32),
-  dob date
-);
-
-COMMENT ON TABLE employee IS $$ Is a metadata table specific to employees $$;
 
 -- batch stuff
 
-- 
cgit v1.2.3