diff options
| author | fusion32 <marcopuzziello@gmail.com> | 2025-10-13 14:56:50 -0300 |
|---|---|---|
| committer | fusion32 <marcopuzziello@gmail.com> | 2025-10-13 14:56:50 -0300 |
| commit | f188d54236256e3b820425a98d7d06e422673a97 (patch) | |
| tree | 49de4d219606d0457cac4d2b73e4f0f9aa22b3f3 /sqlite | |
| parent | 46c653293381dcc1188013d3e2c3f7587a199dc4 (diff) | |
| download | querymanager-f188d54236256e3b820425a98d7d06e422673a97.tar.gz querymanager-f188d54236256e3b820425a98d7d06e422673a97.zip | |
beginning of postgres driver + overall tweaks
Diffstat (limited to 'sqlite')
| -rw-r--r-- | sqlite/schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/sqlite/schema.sql b/sqlite/schema.sql index 677d778..106c780 100644 --- a/sqlite/schema.sql +++ b/sqlite/schema.sql @@ -36,7 +36,7 @@ CREATE TABLE IF NOT EXISTS Characters ( Sex INTEGER NOT NULL, Guild TEXT NOT NULL COLLATE NOCASE DEFAULT '', Rank TEXT NOT NULL COLLATE NOCASE DEFAULT '', - Title TEXT NOT NULL COLLATE NOCASE DEFAULT '', + Title TEXT NOT NULL DEFAULT '', Level INTEGER NOT NULL DEFAULT 0, Profession TEXT NOT NULL DEFAULT '', Residence TEXT NOT NULL DEFAULT '', @@ -132,9 +132,9 @@ CREATE TABLE IF NOT EXISTS HouseOwners ( PRIMARY KEY (WorldID, HouseID) ); --- NOTE(fusion): An auction would have a non null `FinishTime` but it doesn't make --- sense to finish an auction just to restart it afterwards so it should only be --- set after the first bid, along with `BidderID` and `BidAmount`. +-- NOTE(fusion): Auctions with a NULL `FinishTime` aren't active, to avoid running +-- multiple times with no actual bidder. It should be set after the first bid along +-- with `BidderID` and `BidAmount`. CREATE TABLE IF NOT EXISTS HouseAuctions ( WorldID INTEGER NOT NULL, HouseID INTEGER NOT NULL, |