| drh | 4ee09b4 | 2013-05-01 19:49:27 +0000 | [diff] [blame] | 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 |
| drh | 8a28a31 | 2013-05-01 20:40:46 +0000 | [diff] [blame] | 12 | # a 4-byte big-endian integer into offset 68 of the database header. |
| drh | 4ee09b4 | 2013-05-01 19:49:27 +0000 | [diff] [blame] | 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 |
| drh | 8a28a31 | 2013-05-01 20:40:46 +0000 | [diff] [blame] | 17 | # stored at offset 68 instead of offset 60. The application_id pragma |
| 18 | # is preferred. The rule using offset 60 for Monotone is for historical |
| 19 | # compatibility only. |
| drh | 4ee09b4 | 2013-05-01 19:49:27 +0000 | [diff] [blame] | 20 | # |
| 21 | 0 string =SQLite\ format\ 3 |
| drh | b8a67ec | 2013-05-01 20:36:23 +0000 | [diff] [blame] | 22 | >68 belong =0x0f055112 Fossil checkout - |
| 23 | >68 belong =0x0f055113 Fossil global configuration - |
| drh | 17f37c7 | 2013-05-23 20:52:16 +0000 | [diff] [blame] | 24 | >68 belong =0x0f055111 Fossil repository - |
| drh | 178e7ee | 2013-05-03 20:08:16 +0000 | [diff] [blame] | 25 | >68 belong =0x42654462 Bentley Systems BeSQLite Database - |
| 26 | >68 belong =0x42654c6e Bentley Systems Localization File - |
| drh | b8a67ec | 2013-05-01 20:36:23 +0000 | [diff] [blame] | 27 | >60 belong =0x5f4d544e Monotone source repository - |
| drh | 17f37c7 | 2013-05-23 20:52:16 +0000 | [diff] [blame] | 28 | >68 belong =0x47504b47 OGC GeoPackage file - |
| drh | c0f1d0c | 2013-10-14 10:46:05 +0000 | [diff] [blame] | 29 | >68 belong =0x47503130 OGC GeoPackage version 1.0 file - |
| drh | c7401d5 | 2013-10-30 03:25:45 +0000 | [diff] [blame] | 30 | >68 belong =0x45737269 Esri Spatially-Enabled Database - |
| drh | 2fe7081 | 2014-06-16 18:17:21 +0000 | [diff] [blame] | 31 | >68 belong =0x4d504258 MBTiles tileset - |
| drh | b8a67ec | 2013-05-01 20:36:23 +0000 | [diff] [blame] | 32 | >0 string =SQLite SQLite3 database |