9 lines
252 B
SQL
9 lines
252 B
SQL
CREATE TABLE claims (
|
|
id INTEGER PRIMARY KEY NOT NULL,
|
|
player_id INTEGER NOT NULL,
|
|
loot_id INTEGER NOT NULL,
|
|
resolve INTEGER NOT NULL DEFAULT 0,
|
|
FOREIGN KEY (player_id) REFERENCES players(id),
|
|
FOREIGN KEY (loot_id) REFERENCES looted(id)
|
|
);
|