xref: /sqlite-3.40.0/magic.txt (revision 875b95d4)
1# This file contains suggested magic(5) text for the unix file(1)
2# utility for recognizing SQLite3 databases.
3#
4# When SQLite is used as an application file format, it is desirable to
5# have file(1) recognize the database file as being with the specific
6# application.  You can set the application_id for a database file
7# using:
8#
9#     PRAGMA application_id = INTEGER;
10#
11# INTEGER can be any signed 32-bit integer.  That integer is written as
12# a 4-byte big-endian integer into offset 68 of the database header.
13#
14# The Monotone application used "PRAGMA user_version=1598903374;" to set
15# its identifier long before "PRAGMA application_id" became available.
16# The user_version is very similar to application_id except that it is
17# stored at offset 60 instead of offset 68.  The application_id pragma
18# is preferred.  The rule using offset 60 for Monotone is for historical
19# compatibility only.
20#
210    string  =SQLite\ format\ 3
22>68  belong  =0x0f055112  Fossil checkout -
23>68  belong  =0x0f055113  Fossil global configuration -
24>68  belong  =0x0f055111  Fossil repository -
25>68  belong  =0x42654462  Bentley Systems BeSQLite Database -
26>68  belong  =0x42654c6e  Bentley Systems Localization File -
27>60  belong  =0x5f4d544e  Monotone source repository -
28>68  belong  =0x47504b47  OGC GeoPackage file -
29>68  belong  =0x47503130  OGC GeoPackage version 1.0 file -
30>68  belong  =0x45737269  Esri Spatially-Enabled Database -
31>68  belong  =0x4d504258  MBTiles tileset -
32>68  belong  =0x6a035744  TeXnicard card database
33>0   string  =SQLite      SQLite3 database
34