Title Database - Revision history

TimmSkiller: Move table of contents to the correct location

2026-06-16T11:24:26Z

Move table of contents to the correct location

← Older revision		Revision as of 15:24, 16 June 2026
Line 1:		Line 1:
			__TOC__

	These files contain data relating to install/usage/management of installed 3DS titles. The database files are located at:		These files contain data relating to install/usage/management of installed 3DS titles. The database files are located at:

TimmSkiller: Restructure a bit to have a proper ToC

2026-05-27T15:27:25Z

Restructure a bit to have a proper ToC

← Older revision		Revision as of 19:27, 27 May 2026
Line 134:		Line 134:
	This is a variant of [[Inner FAT\|FAT filesystem]]. It consists one "root" directory and multiple "files". Each "file" is one title info entry described below.		This is a variant of [[Inner FAT\|FAT filesystem]]. It consists one "root" directory and multiple "files". Each "file" is one title info entry described below.

	== Title Info Entry ==		=== Title Info Entry ===

	An entry contains information taken from both the application NCCH file(s) and TMD.		An entry contains information taken from both the application NCCH file(s) and TMD.
Line 195:		Line 195:
	\|}		\|}

	For ticket.db ~~title info~~, there is a header indicates ticket count (as a Title ID can have more than one ticket installed). Then each entry contains the size, followed by the actual ticket data.		=== Ticket Info Entry ===
			For ticket.db entries, there is a header indicates ticket count (as a Title ID can have more than one ticket installed). Then each entry contains the size, followed by the actual ticket data.

	{\| class="wikitable"		{\| class="wikitable"
	\|+ Header		\|+ Header

TimmSkiller: Remove extraneous flags tables

2026-05-27T15:24:52Z

Remove extraneous flags tables

@@ Line 225: / Line 225: @@
 | X
 | [[Ticket|Ticket]] data
 |}

TimmSkiller: Complete full format of Title Info Entry

2026-05-27T15:24:16Z

Complete full format of Title Info Entry

← Older revision		Revision as of 19:24, 27 May 2026
Line 140:		Line 140:
	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-
	! Start		! Start !! Length !! Description
	! Length
	! Description
	\|-		\|-
	\| 0x0		\| 0x0 \|\| 0x8 \|\| u64, Title Size
	\| 8
	\| Title Size
	\|-		\|-
	\| 0x8		\| 0x8 \|\| 0x4 \|\| u32, Title Type from TMD (usually 0x40)
	\| 4
	\| Title Type(usually 0x40)
	\|-		\|-
	\| 0xC		\| 0xC \|\| 0x2 \|\| u16, Title Version
	\| 4
	\| Title Version
	\|-		\|-
	\| ~~0x10~~		\| 0xE \|\| 0x2 \|\| u16, Content index for Download Play Child content
	\| 4
	\| ~~Flags_0~~
	\|-		\|-
	\| ~~0x14~~		\| 0x10 \|\| 0x2 \|\| u16, Content index for Instruction Manual content
	\| 4
	\| ~~TMD~~ Content ID
	\|-		\|-
	\| ~~0x18~~		\| 0x12 \|\| 0x2 \|\| u16, Content index for Old3DS update partition (even though this is unused because digital titles don't have update partitions)
	\| 4
	\| ~~CMD~~ Content ID
	\|-		\|-
	\| ~~0x1c~~		\| 0x14 \|\| 0x4 \|\| TMD file ID (the ID part in <code>{ID}.tmd</code> inside the title folder)
	\| 4
	\| ~~Flags_1~~
	\|-		\|-
	\| ~~0x20~~		\| 0x18 \|\| 0x4 \|\| CMD file ID (the ID part in <code>{ID}.cmd</code> inside the title folder)
	\| 4
	\| ~~ExtdataID low~~ (~~zero if~~ title ~~doesn't use Extdata~~)
	\|-		\|-
	\| ~~0x24~~		\| 0x1C \|\| 0x4 \|\| save file ID (the ID part in <code>{ID}.sav</code> inside the title/data folder)
	\| 4
	\| ~~Reserved~~
	\|-		\|-
	\| ~~0x28~~		\| 0x20 \|\| 0x8 \|\| u64, extdata ID (zero if title does not use extdata)
	\| 8
	\| ~~Flags_2~~
	\|-		\|-
	\| ~~0x30~~		\| 0x28 \|\| 0x1 \|\| bool, has public.sav (DSiWare only)
	\| ~~0x10~~
	\| ~~Product Code~~
	\|-		\|-
	\| ~~0x40~~		\| 0x29 \|\| 0x1 \|\| bool, has private.sav (DSiWare only)
	\| ~~0x10~~
	\| ~~Reserved~~
	\|-		\|-
	\| ~~0x50~~		\| 0x2A \|\| 0x1 \|\| bool, has banner.sav (DSiWare only)
	\| ~~0x4~~
	\| ~~Unknown~~
	\|-		\|-
	\| ~~0x54~~		\| 0x2B \|\| 0x1 \|\| bool, requires moving public/private/banner.new to public/private/banner.sav (DSiWare only) (see [[AMPXI:WriteTWLSavedata]])
	\| ~~0x2c~~		\|-
	\| Reserved		\| 0x2C \|\| 0x1 \|\| u8, CMD format version (see [[Titles#Data_Structure\|Title Data Structure]])
			\|-
			\| 0x2D \|\| 0x1 \|\| bool, is user DSiWare title (as in, does not have system title bit set, see [[Title_list#TWL_(DSi)_Titles\|TWL (DSi) Titles]] for more information)
			\|-
			\| 0x2E \|\| 0x2 \|\| u16, New3DS update partition content index (even though this is unused because digital titles don't have update partitions)
			\|-
			\| 0x30 \|\| 0x10 \|\| Product code (first 12 bytes of raw .nds for DSiWare, which is the game title)
			\|-
			\| 0x40 \|\| 0x8 \|\| u64, ordering number. Used in some code paths to find the "latest" added entry, but this value is never written and always 0.
			\|-
			\| 0x48 \|\| 0x1 \|\| bool, is temporary (true for DLP child titles added into tmp_i/tmp_t.db)
			\|-
			\| 0x49 \|\| 0x1 \|\| u8, [[Application_Manager_Services#ImportTitleContextState\|ImportTitleContextState]]
			\|-
			\| 0x4A \|\| 0x1 \|\| bool, overwrite (set when reinstalling an existing title)
			\|-
			\| 0x4B \|\| 0x1 \|\| Reserved
			\|-
			\| 0x4C \|\| 0x4 \|\| Content ID for content index 0, 0xFFFFFFFF if not applicable
			\|-
			\| 0x50 \|\| 0x4 \|\| u32, random value generated during title installation (See [[CTXT]])
			\|-
			\| 0x54 \|\| 0x2C \|\| Reserved
	\|}		\|}

TimmSkiller: Correct information about pre-headers

2026-05-22T11:39:03Z

Correct information about pre-headers

← Older revision		Revision as of 15:39, 22 May 2026
Line 69:		Line 69:
	\|-		\|-
	\| 0x08		\| 0x08
	\| ~~0x78~~		\| 0x4
			\| Version (always 0)
			\|-
			\| 0xC
			\| 0x74
	\| Reserved		\| Reserved
	\|}		\|}

	For ticket.db different pre header is used:		For ticket.db, a different pre-header is used:

	{\| class="wikitable"		{\| class="wikitable"
Line 87:		Line 91:
	\| 0x04		\| 0x04
	\| 0x04		\| 0x04
	\| ~~Unknown~~ (always ~~0x00000001 ?~~)		\| Version (always 1)
	\|-		\|-
	\| 0x08		\| 0x08
	\| ~~0x04~~		\| 0x08
	\| ~~Unknown~~		\| Reserved
	\|-
	~~\| 0x0C~~
	~~\| 0x04~~
	~~\| Unknown (0x30 smaller than previous one)~~
	\|}		\|}

TimmSkiller: add mention to SDMCIDB

2026-05-22T11:35:37Z

add mention to SDMCIDB

← Older revision		Revision as of 15:35, 22 May 2026
Line 125:		Line 125:
	\| SD Card title.db		\| SD Card title.db
	\| TEMPTDB		\| TEMPTDB
			\|-
			\| (unused, likely supposed to be SD card import.db)
			\| SDMCIDB
	\|}		\|}

Ihaveamac: /* Title Info Entry */ tickets may be larger than 0x350

2023-09-13T09:16:27Z

Title Info Entry: tickets may be larger than 0x350

← Older revision		Revision as of 13:16, 13 September 2023
Line 223:		Line 223:
	\| 0x0		\| 0x0
	\| 4		\| 4
	\| Ticket data size X (=0x350)		\| Ticket data size X (often 0x350 but some DLC tickets may be larger)
	\|-		\|-
	\| 0x4		\| 0x4

Ihaveamac: /* Title Info Entry */ document actual ticket.db title info (multiple tickets can be installed for one Title ID)

2023-09-13T09:13:12Z

Title Info Entry: document actual ticket.db title info (multiple tickets can be installed for one Title ID)

← Older revision		Revision as of 13:13, 13 September 2023
Line 198:		Line 198:
	\|}		\|}

	For ticket.db title info ~~contains~~ a ~~small~~ header ~~and~~ actual ticket data:		For ticket.db title info, there is a header indicates ticket count (as a Title ID can have more than one ticket installed). Then each entry contains the size, followed by the actual ticket data.
	{\| class="wikitable"		{\| class="wikitable"
			\|+ Header
	\|-		\|-
	! Start		! Start
Line 207:		Line 208:
	\| 0x0		\| 0x0
	\| 4		\| 4
	\| ~~Unknown (always 0x00000001?)~~		\| Amount of tickets X
	\|-		\|-
	\| 0x4		\| 0x4
			\| X * (size of tickets + 4)
			\| Ticket entries
			\|}
			{\| class="wikitable"
			\|+ Ticket entry
			\|-
			! Start
			! Length
			! Description
			\|-
			\| 0x0
	\| 4		\| 4
	\| Ticket data size X (=0x350)		\| Ticket data size X (=0x350)
	\|-		\|-
	\| ~~0x8~~		\| 0x4
	\| X		\| X
	\| [[Ticket\|Ticket]] data		\| [[Ticket\|Ticket]] data

Ihaveamac: /* Title Info Entry */ 0x350 appears here, not 0x530

2019-05-30T23:25:07Z

Title Info Entry: 0x350 appears here, not 0x530

← Older revision		Revision as of 03:25, 31 May 2019
Line 211:		Line 211:
	\| 0x4		\| 0x4
	\| 4		\| 4
	\| Ticket data size X (=~~0x530~~)		\| Ticket data size X (=0x350)
	\|-		\|-
	\| 0x8		\| 0x8

Wwylele: Migrate to Inner FAT

2019-05-03T20:03:21Z

Migrate to Inner FAT

Show changes