SF.net SVN: ledger-smb: [1492] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1492
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1492&view=rev
Author:   einhverfr
Date:     2007-09-01 15:22:31 -0700 (Sat, 01 Sep 2007)

Log Message:
-----------
Moving employee table further up the creation script.

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-09-01 21:50:10 UTC (rev 1491)
+++ trunk/sql/Pg-database.sql	2007-09-01 22:22:31 UTC (rev 1492)
@@ -530,6 +530,24 @@
 
 --
 --
+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,25 +766,7 @@
   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
 
 CREATE TABLE batch_class (


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