xref: /dragonfly/contrib/file/magic/Magdir/sql (revision 9f3fc534)
1
2#------------------------------------------------------------------------------
3# sql:  file(1) magic for SQL files
4#
5# From: "Marty Leisner" <mleisner@eng.mc.xerox.com>
6# Recognize some MySQL files.
7#
80	beshort			0xfe01		MySQL table definition file
9>2	byte			x		Version %d
100	belong&0xffffff00	0xfefe0300	MySQL MISAM index file
11>3	byte			x		Version %d
120	belong&0xffffff00	0xfefe0700	MySQL MISAM compressed data file
13>3	byte			x		Version %d
140	belong&0xffffff00	0xfefe0500	MySQL ISAM index file
15>3	byte			x		Version %d
160	belong&0xffffff00	0xfefe0600	MySQL ISAM compressed data file
17>3	byte			x		Version %d
180	string		 	\376bin		MySQL replication log
19
20#------------------------------------------------------------------------------
21# iRiver H Series database file
22# From Ken Guest <ken@linux.ie>
23# As observed from iRivNavi.iDB and unencoded firmware
24#
250   string		iRivDB	iRiver Database file
26>11  string	>\0	Version %s
27>39  string		iHP-100	[H Series]
28
29#------------------------------------------------------------------------------
30# SQLite database files
31# Ken Guest <ken@linux.ie>, Ty Sarna, Zack Weinberg
32#
33# Version 1 used GDBM internally; its files cannot be distinguished
34# from other GDBM files.
35#
36# Version 2 used this format:
370	string	**\ This\ file\ contains\ an\ SQLite  SQLite 2.x database
38
39# Version 3 of SQLite allows applications to embed their own "user version"
40# number in the database.  Detect this and distinguish those files.
41
420   string  SQLite\ format\ 3
43>60 string  _MTN               Monotone source repository
44>60 belong  !0                 SQLite 3.x database, user version %u
45>60 belong  0                  SQLite 3.x database
46