File: schema.sql

package info (click to toggle)
crossfire-maps 1.75.0%2Bdfsg1-1
  • links: PTS
  • area: main
  • in suites: bookworm, bullseye, forky, sid, trixie
  • size: 275,656 kB
  • sloc: python: 7,711; sql: 92; sh: 73; makefile: 7
file content (25 lines) | stat: -rw-r--r-- 656 bytes parent folder | download 
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
 
CREATE TABLE IF NOT EXISTS schema(version INT);

CREATE TABLE regions(
    faction      TEXT,
    region       TEXT,    -- region name (or 'ALL') this faction controls
    influence    NUMERIC,
    CONSTRAINT   influence_range CHECK(influence BETWEEN 0 AND 1)
);

CREATE TABLE relations(
    faction      TEXT,
    race         TEXT,
    attitude     NUMERIC,
    PRIMARY KEY  (faction, race)
);

CREATE TABLE reputations(
    name         TEXT,          -- player name
    faction      TEXT,
    reputation   NUMERIC,
    PRIMARY KEY  (name, faction),
    CONSTRAINT   reputation_range CHECK(reputation BETWEEN -1 AND 1)
);

INSERT INTO schema VALUES(1);