| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596 |
- #------------------------------------------------------------------------------
- # $File: sql,v 1.18 2015/12/04 20:38:43 christos Exp $
- # sql: file(1) magic for SQL files
- #
- # From: "Marty Leisner" <mleisner@eng.mc.xerox.com>
- # Recognize some MySQL files.
- # Elan Ruusamae <glen@delfi.ee>, added MariaDB signatures
- # from https://bazaar.launchpad.net/~maria-captains/maria/5.5/view/head:/support-files/magic
- #
- 0 beshort 0xfe01 MySQL table definition file
- >2 byte x Version %d
- 0 belong&0xffffff00 0xfefe0700 MySQL MyISAM index file
- >3 byte x Version %d
- 0 belong&0xffffff00 0xfefe0800 MySQL MyISAM compressed data file
- >3 byte x Version %d
- 0 belong&0xffffff00 0xfefe0900 MySQL Maria index file
- >3 byte x Version %d
- 0 belong&0xffffff00 0xfefe0A00 MySQL Maria compressed data file
- >3 byte x Version %d
- 0 belong&0xffffff00 0xfefe0500 MySQL ISAM index file
- >3 byte x Version %d
- 0 belong&0xffffff00 0xfefe0600 MySQL ISAM compressed data file
- >3 byte x Version %d
- 0 string \376bin MySQL replication log
- 0 belong&0xffffff00 0xfefe0b00
- >4 string MARIALOG MySQL Maria transaction log file
- >>3 byte x Version %d
- 0 belong&0xffffff00 0xfefe0c00
- >4 string MACF MySQL Maria control file
- >>3 byte x Version %d
- #------------------------------------------------------------------------------
- # iRiver H Series database file
- # From Ken Guest <ken@linux.ie>
- # As observed from iRivNavi.iDB and unencoded firmware
- #
- 0 string iRivDB iRiver Database file
- >11 string >\0 Version %s
- >39 string iHP-100 [H Series]
- #------------------------------------------------------------------------------
- # SQLite database files
- # Ken Guest <ken@linux.ie>, Ty Sarna, Zack Weinberg
- #
- # Version 1 used GDBM internally; its files cannot be distinguished
- # from other GDBM files.
- #
- # Version 2 used this format:
- 0 string **\ This\ file\ contains\ an\ SQLite SQLite 2.x database
- # Version 3 of SQLite allows applications to embed their own "user version"
- # number in the database at offset 60. Later, SQLite added an "application id"
- # at offset 68 that is preferred over "user version" for indicating the
- # associated application.
- #
- 0 string SQLite\ format\ 3 SQLite 3.x database
- !:mime application/x-sqlite3
- # seldom found extension sqlite3 like in SyncData.sqlite3
- # db
- # Avira Antivir use extension "dbe" like in avevtdb.dbe, avguard_tchk.dbe
- # Unfortunately extension sqlite also used for other databases starting with string
- # "TTCONTAINER" like in tracks.sqlite contentconsumer.sqlite contentproducerrepository.sqlite
- # and with string "ZV-zlib" in like extra.sqlite
- !:ext sqlite/sqlite3/db/dbe
- >60 belong =0x5f4d544e (Monotone source repository)
- >68 belong =0x0f055112 (Fossil checkout)
- >68 belong =0x0f055113 (Fossil global configuration)
- >68 belong =0x0f055111 (Fossil repository)
- >68 belong =0x42654462 (Bentley Systems BeSQLite Database)
- >68 belong =0x42654c6e (Bentley Systems Localization File)
- >68 belong =0x47504b47 (OGC GeoPackage file)
- >68 default x
- >>68 belong !0 \b, application id %u
- >>60 belong !0 \b, user version %d
- >96 belong x \b, last written using SQLite version %d
- # SQLite Write-Ahead Log from SQLite version >= 3.7.0
- # http://www.sqlite.org/fileformat.html#walformat
- 0 belong&0xfffffffe 0x377f0682 SQLite Write-Ahead Log,
- !:ext sqlite-wal/db-wal
- >4 belong x version %d
- # SQLite Rollback Journal
- # http://www.sqlite.org/fileformat.html#rollbackjournal
- 0 string \xd9\xd5\x05\xf9\x20\xa1\x63\xd7 SQLite Rollback Journal
- # Panasonic channel list database svl.bin or svl.db added by Joerg Jenderek
- # https://github.com/PredatH0r/ChanSort
- 0 string PSDB\0 Panasonic channel list DataBase
- !:ext db/bin
- #!:mime application/x-db-svl-panasonic
- >126 string SQLite\ format\ 3
- #!:mime application/x-panasonic-sqlite3
- >>&-15 indirect x \b; contains
|
