xref: /dragonfly/contrib/file/magic/Magdir/sql (revision 9f7604d7)
1
2#------------------------------------------------------------------------------
3# $File: sql,v 1.6 2009/09/19 16:28:12 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#
90	beshort			0xfe01		MySQL table definition file
10>2	byte			x		Version %d
110	belong&0xffffff00	0xfefe0300	MySQL MISAM index file
12>3	byte			x		Version %d
130	belong&0xffffff00	0xfefe0700	MySQL MISAM compressed data file
14>3	byte			x		Version %d
150	belong&0xffffff00	0xfefe0500	MySQL ISAM index file
16>3	byte			x		Version %d
170	belong&0xffffff00	0xfefe0600	MySQL ISAM compressed data file
18>3	byte			x		Version %d
190	string		 	\376bin		MySQL replication log
20
21#------------------------------------------------------------------------------
22# iRiver H Series database file
23# From Ken Guest <ken@linux.ie>
24# As observed from iRivNavi.iDB and unencoded firmware
25#
260   string		iRivDB	iRiver Database file
27>11  string	>\0	Version %s
28>39  string		iHP-100	[H Series]
29
30#------------------------------------------------------------------------------
31# SQLite database files
32# Ken Guest <ken@linux.ie>, Ty Sarna, Zack Weinberg
33#
34# Version 1 used GDBM internally; its files cannot be distinguished
35# from other GDBM files.
36#
37# Version 2 used this format:
380	string	**\ This\ file\ contains\ an\ SQLite  SQLite 2.x database
39
40# Version 3 of SQLite allows applications to embed their own "user version"
41# number in the database.  Detect this and distinguish those files.
42
430   string  SQLite\ format\ 3
44>60 string  _MTN               Monotone source repository
45>60 belong  !0                 SQLite 3.x database, user version %u
46>60 belong  0                  SQLite 3.x database
47