1
2#------------------------------------------------------------------------------
3# $File: sql,v 1.15 2014/04/30 21:41:02 christos Exp $
4# sql: file(1) magic for SQL files
5#
6# From: "Marty Leisner" <mleisner@eng.mc.xerox.com>
7# Recognize some MySQL files.
8# Elan Ruusamae <glen@delfi.ee>, added MariaDB signatures
9# from https://bazaar.launchpad.net/~maria-captains/maria/5.5/view/head:/support-files/magic
10#
110 beshort 0xfe01 MySQL table definition file
--- 37 unchanged lines hidden (view full) ---
49# Version 2 used this format:
500 string **\ This\ file\ contains\ an\ SQLite SQLite 2.x database
51
52# Version 3 of SQLite allows applications to embed their own "user version"
53# number in the database at offset 60. Later, SQLite added an "application id"
54# at offset 68 that is preferred over "user version" for indicating the
55# associated application.
56#
570 string SQLite\ format\ 3
58>60 belong =0x5f4d544e Monotone source repository - SQLite3 database
59>68 belong =0x0f055112 Fossil checkout - SQLite3 database
60>68 belong =0x0f055113 Fossil global configuration - SQLite3 database
61>68 belong =0x0f055111 Fossil repository - SQLite3 database
62>68 belong =0x42654462 Bentley Systems BeSQLite Database - SQLite3 database
63>68 belong =0x42654c6e Bentley Systems Localization File - SQLite3 database
64>68 belong =0x47504b47 OGC GeoPackage file - SQLite3 database
65>68 default x SQLite 3.x database
66>>68 belong !0 \b, application id %u
67>>60 belong !0 \b, user version %d
68
69# SQLite Write-Ahead Log from SQLite version >= 3.7.0
70# http://www.sqlite.org/fileformat.html#walformat
710 belong&0xfffffffe 0x377f0682 SQLite Write-Ahead Log,
72>4 belong x version %d
73
74# SQLite Rollback Journal
75# http://www.sqlite.org/fileformat.html#rollbackjournal
760 string \xd9\xd5\x05\xf9\x20\xa1\x63\xd7 SQLite Rollback Journal
77
78# Panasonic channel list database svl.bin or svl.db added by Joerg Jenderek
79# http://www.ullrich.es/job/service-menue/panasonic/panasonic-sendersortierung-sat-am-pc/
80# pceditor_V2003.jar
810 string PSDB\0 Panasonic channel list database
82>126 string SQLite\ format\ 3
83>>&-15 indirect x \b; contains
2#------------------------------------------------------------------------------
3# $File: sql,v 1.15 2014/04/30 21:41:02 christos Exp $
4# sql: file(1) magic for SQL files
5#
6# From: "Marty Leisner" <mleisner@eng.mc.xerox.com>
7# Recognize some MySQL files.
8# Elan Ruusamae <glen@delfi.ee>, added MariaDB signatures
9# from https://bazaar.launchpad.net/~maria-captains/maria/5.5/view/head:/support-files/magic
10#
110 beshort 0xfe01 MySQL table definition file
--- 37 unchanged lines hidden (view full) ---
49# Version 2 used this format:
500 string **\ This\ file\ contains\ an\ SQLite SQLite 2.x database
51
52# Version 3 of SQLite allows applications to embed their own "user version"
53# number in the database at offset 60. Later, SQLite added an "application id"
54# at offset 68 that is preferred over "user version" for indicating the
55# associated application.
56#
570 string SQLite\ format\ 3
58>60 belong =0x5f4d544e Monotone source repository - SQLite3 database
59>68 belong =0x0f055112 Fossil checkout - SQLite3 database
60>68 belong =0x0f055113 Fossil global configuration - SQLite3 database
61>68 belong =0x0f055111 Fossil repository - SQLite3 database
62>68 belong =0x42654462 Bentley Systems BeSQLite Database - SQLite3 database
63>68 belong =0x42654c6e Bentley Systems Localization File - SQLite3 database
64>68 belong =0x47504b47 OGC GeoPackage file - SQLite3 database
65>68 default x SQLite 3.x database
66>>68 belong !0 \b, application id %u
67>>60 belong !0 \b, user version %d
68
69# SQLite Write-Ahead Log from SQLite version >= 3.7.0
70# http://www.sqlite.org/fileformat.html#walformat
710 belong&0xfffffffe 0x377f0682 SQLite Write-Ahead Log,
72>4 belong x version %d
73
74# SQLite Rollback Journal
75# http://www.sqlite.org/fileformat.html#rollbackjournal
760 string \xd9\xd5\x05\xf9\x20\xa1\x63\xd7 SQLite Rollback Journal
77
78# Panasonic channel list database svl.bin or svl.db added by Joerg Jenderek
79# http://www.ullrich.es/job/service-menue/panasonic/panasonic-sendersortierung-sat-am-pc/
80# pceditor_V2003.jar
810 string PSDB\0 Panasonic channel list database
82>126 string SQLite\ format\ 3
83>>&-15 indirect x \b; contains