From f188d54236256e3b820425a98d7d06e422673a97 Mon Sep 17 00:00:00 2001 From: fusion32 Date: Mon, 13 Oct 2025 14:56:50 -0300 Subject: beginning of postgres driver + overall tweaks --- sqlite/schema.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'sqlite') 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, -- cgit v1.2.3