summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r--util/sql/schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 960b1978..9f78cf51 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -387,7 +387,7 @@ CREATE TABLE staff ( -- dbentry_type=s
id SERIAL PRIMARY KEY,
locked boolean NOT NULL DEFAULT FALSE,
hidden boolean NOT NULL DEFAULT FALSE,
- aid integer NOT NULL, -- staff_alias.aid
+ aid integer NOT NULL DEFAULT 0, -- staff_alias.aid
gender gender NOT NULL DEFAULT 'unknown',
lang language NOT NULL DEFAULT 'ja',
"desc" text NOT NULL DEFAULT '',
@@ -400,7 +400,7 @@ CREATE TABLE staff ( -- dbentry_type=s
-- staff_hist
CREATE TABLE staff_hist (
chid integer NOT NULL PRIMARY KEY,
- aid integer NOT NULL, -- Can't refer to staff_alias.id, because the alias might have been deleted
+ aid integer NOT NULL DEFAULT 0, -- Can't refer to staff_alias.id, because the alias might have been deleted
gender gender NOT NULL DEFAULT 'unknown',
lang language NOT NULL DEFAULT 'ja',
"desc" text NOT NULL DEFAULT '',