xref: /sqlite-3.40.0/magic.txt (revision b8a67ec8)
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.  In
13# the tests below, this integer is sometimes rendered as a string.  For
14# example, instead of "belong =1598444364" we write "string =_FSL" and
15# instead of "belong =1598903374" we write "string =_MTN".
16#
17# The Monotone application used "PRAGMA user_version=1598903374;" to set
18# its identifier long before "PRAGMA application_id" became available.
19# The user_version is very similar to application_id except that it is
20# stored at offset 68 instead of offset 60.  The user of
21# "PRAGMA application_id" is preferred now.  The rules using offset 60
22# for Monotone are for historical compatibility only.
23#
240    string  =SQLite\ format\ 3
25>68  belong  =0x0f055111  Fossil repository -
26>68  belong  =0x0f055112  Fossil checkout -
27>68  belong  =0x0f055113  Fossil global configuration -
28>60  belong  =0x5f4d544e  Monotone source repository -
29>0   string  =SQLite      SQLite3 database
30