sql (267897) | sql (298192) |
---|---|
1 2#------------------------------------------------------------------------------ | 1 2#------------------------------------------------------------------------------ |
3# $File: sql,v 1.15 2014/04/30 21:41:02 christos Exp $ | 3# $File: sql,v 1.18 2015/12/04 20:38:43 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# | 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 | 570 string SQLite\ format\ 3 SQLite 3.x database 58!:mime application/x-sqlite3 59# seldom found extension sqlite3 like in SyncData.sqlite3 60# db 61# Avira Antivir use extension "dbe" like in avevtdb.dbe, avguard_tchk.dbe 62# Unfortunately extension sqlite also used for other databases starting with string 63# "TTCONTAINER" like in tracks.sqlite contentconsumer.sqlite contentproducerrepository.sqlite 64# and with string "ZV-zlib" in like extra.sqlite 65!:ext sqlite/sqlite3/db/dbe 66>60 belong =0x5f4d544e (Monotone source repository) 67>68 belong =0x0f055112 (Fossil checkout) 68>68 belong =0x0f055113 (Fossil global configuration) 69>68 belong =0x0f055111 (Fossil repository) 70>68 belong =0x42654462 (Bentley Systems BeSQLite Database) 71>68 belong =0x42654c6e (Bentley Systems Localization File) 72>68 belong =0x47504b47 (OGC GeoPackage file) 73>68 default x |
66>>68 belong !0 \b, application id %u 67>>60 belong !0 \b, user version %d | 74>>68 belong !0 \b, application id %u 75>>60 belong !0 \b, user version %d |
76>96 belong x \b, last written using SQLite version %d |
|
68 | 77 |
78 |
|
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, | 79# SQLite Write-Ahead Log from SQLite version >= 3.7.0 80# http://www.sqlite.org/fileformat.html#walformat 810 belong&0xfffffffe 0x377f0682 SQLite Write-Ahead Log, |
82!:ext sqlite-wal/db-wal |
|
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 | 83>4 belong x version %d 84 85# SQLite Rollback Journal 86# http://www.sqlite.org/fileformat.html#rollbackjournal 870 string \xd9\xd5\x05\xf9\x20\xa1\x63\xd7 SQLite Rollback Journal 88 89# 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 | 90# https://github.com/PredatH0r/ChanSort 910 string PSDB\0 Panasonic channel list DataBase 92!:ext db/bin 93#!:mime application/x-db-svl-panasonic |
82>126 string SQLite\ format\ 3 | 94>126 string SQLite\ format\ 3 |
95#!:mime application/x-panasonic-sqlite3 |
|
83>>&-15 indirect x \b; contains | 96>>&-15 indirect x \b; contains |