· 4 years ago · Jan 18, 2021, 10:28 PM
1-- CREATE TABLE IF NOT EXISTS rules (
2-- RuleNo integer PRIMARY KEY,
3-- Rule TEXT
4-- );
5
6CREATE TABLE IF NOT EXISTS BountyHunter (
7 DiscordID integer PRIMARY KEY,
8 HunterName TEXT DEFAULT BLANK,
9 Bounties_Completed integer DEFAULT 0,
10 Bounty_Value integer DEFAULT 0,
11 Guild TEXT DEFAULT NONE
12);
13
14CREATE TABLE IF NOT EXISTS BountyBoard (
15 PlacedByID integer PRIMARY KEY,
16 TargetID integer,
17 ValueDead integer,
18 ValueAlive integer,
19 OtherInfo TEXT
20);
21
22CREATE TABLE IF NOT EXISTS Assassins (
23 DiscordID integer PRIMARY KEY,
24 AssassinName TEXT DEFAULT BLANK,
25 Completed integer DEFAULT 0,
26 AssainationValue integer DEFAULT 0
27);