summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-09-01 22:22:31 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-09-01 22:22:31 +0000
commit0ca18bdebd500c752b7ae1dcc8f54c65fd2c25af (patch)
treee9944b91acddc67b809db9b6c2ad879d56c2ee6c
parente5f8255e73273411a2a8cd72c5a8697b8fa0c3ec (diff)
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
-rw-r--r--sql/Pg-database.sql36
1 files changed, 18 insertions, 18 deletions
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