blob: f471f5330296a11d5459bcc7360343958f6f2a68 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
-- NOTE(fusion): This file contains the migration script from v0.1 to v0.2. It
-- 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`.
--==============================================================================
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;
|
