From eba55f8361fc36179e36bf8a3cea5067b5341e37 Mon Sep 17 00:00:00 2001 From: fusion32 Date: Sat, 18 Oct 2025 18:21:31 -0300 Subject: update documentation + wrap the few SQLite scripts --- sqlite/z-001-migrate-v01-to-v02.sql | 30 +++++++++++++++++++++++------- 1 file changed, 23 insertions(+), 7 deletions(-) (limited to 'sqlite/z-001-migrate-v01-to-v02.sql') diff --git a/sqlite/z-001-migrate-v01-to-v02.sql b/sqlite/z-001-migrate-v01-to-v02.sql index b7df053..f471f53 100644 --- a/sqlite/z-001-migrate-v01-to-v02.sql +++ b/sqlite/z-001-migrate-v01-to-v02.sql @@ -1,14 +1,30 @@ -- NOTE(fusion): This file contains the migration script from v0.1 to v0.2. It --- can be placed into `patches/` to upgrade an existing database. Note that these --- changes are already present in the latest `schema.sql`, so trying to patch a --- newly created database will probably result in errors. See `sqlite/README.txt` --- for more details. +-- must be manually executed as `sqlite3 -bail -echo tibia.db < migration.sql` +-- because the original schema didn't have a `Patches` table which is necessary +-- with the new automatic patching system. Future migration scripts can be placed +-- in `patches/` for automatic execution but not this one unfortunately. +-- These changes are already present in the latest `schema.sql`, so trying to +-- apply it to a newly created database will result in errors. For more details +-- see `sqlite/README.txt`. --============================================================================== -ALTER TABLE Worlds RENAME COLUMN OnlineRecord TO OnlinePeak; -ALTER TABLE Worlds RENAME COLUMN OnlineRecordTimestamp TO OnlinePeakTimestamp; -ALTER TABLE CharacterRights RENAME COLUMN Right TO Name; +BEGIN; + +PRAGMA application_id = 0x54694442; + +PRAGMA user_version = 1; +CREATE TABLE Patches ( + FileName TEXT NOT NULL COLLATE NOCASE, + Timestamp INTEGER NOT NULL, + UNIQUE (FileName) +); + +ALTER TABLE Worlds RENAME COLUMN OnlineRecord TO OnlinePeak; +ALTER TABLE Worlds RENAME COLUMN OnlineRecordTimestamp TO OnlinePeakTimestamp; ALTER TABLE Worlds ADD COLUMN LastStartup INTEGER NOT NULL DEFAULT 0; ALTER TABLE Worlds ADD COLUMN LastShutdown INTEGER NOT NULL DEFAULT 0; +ALTER TABLE CharacterRights RENAME COLUMN Right TO Name; + +COMMIT; -- cgit v1.2.3