From f188d54236256e3b820425a98d7d06e422673a97 Mon Sep 17 00:00:00 2001
From: fusion32 <marcopuzziello@gmail.com>
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/schema.sql')

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

