blob: 4bb7f547b38133d825b6d5aefa0029b29fe55828 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
-- These changes have not been synced with the /util/sql/ files yet.
-- character database -> traits
CREATE TABLE traits (
id SERIAL PRIMARY KEY,
name varchar(250) NOT NULL UNIQUE,
description text NOT NULL DEFAULT '',
meta boolean NOT NULL DEFAULT false,
added timestamptz NOT NULL DEFAULT NOW(),
state smallint NOT NULL DEFAULT 0,
addedby integer NOT NULL DEFAULT 0 REFERENCES users (id)
);
CREATE TABLE traits_aliases (
alias varchar(250) NOT NULL PRIMARY KEY,
trait integer NOT NULL REFERENCES traits (id)
);
CREATE TABLE traits_parents (
trait integer NOT NULL REFERENCES traits (id),
parent integer NOT NULL REFERENCES traits (id),
PRIMARY KEY(trait, parent)
);
\i util/sql/func.sql
CREATE TRIGGER insert_notify AFTER INSERT ON traits FOR EACH STATEMENT EXECUTE PROCEDURE insert_notify();
|