xref: /openbsd-src/usr.bin/file/magdir/sql (revision 380b5c7d6f55f6a87af6c6189307b5cf65aa3391)
1*380b5c7dSchl#	$OpenBSD: sql,v 1.2 2008/05/08 01:40:57 chl Exp $
236c0c0feStedu
336c0c0feStedu#------------------------------------------------------------------------------
436c0c0feStedu# sql:  file(1) magic for SQL files
536c0c0feStedu#
636c0c0feStedu# From: "Marty Leisner" <mleisner@eng.mc.xerox.com>
736c0c0feStedu# Recognize some MySQL files.
836c0c0feStedu#
936c0c0feStedu0	beshort			0xfe01		MySQL table definition file
1036c0c0feStedu>2	byte			x		Version %d
1136c0c0feStedu0	belong&0xffffff00	0xfefe0300	MySQL MISAM index file
1236c0c0feStedu>3	byte			x		Version %d
1336c0c0feStedu0	belong&0xffffff00	0xfefe0700	MySQL MISAM compressed data file
1436c0c0feStedu>3	byte			x		Version %d
1536c0c0feStedu0	belong&0xffffff00	0xfefe0500	MySQL ISAM index file
1636c0c0feStedu>3	byte			x		Version %d
1736c0c0feStedu0	belong&0xffffff00	0xfefe0600	MySQL ISAM compressed data file
1836c0c0feStedu>3	byte			x		Version %d
1936c0c0feStedu0	string		 	\376bin		MySQL replication log
20*380b5c7dSchl
21*380b5c7dSchl#------------------------------------------------------------------------------
22*380b5c7dSchl# iRiver H Series database file
23*380b5c7dSchl# From Ken Guest <ken@linux.ie>
24*380b5c7dSchl# As observed from iRivNavi.iDB and unencoded firmware
25*380b5c7dSchl#
26*380b5c7dSchl0   string		iRivDB	iRiver Database file
27*380b5c7dSchl>11  string	>\0	Version %s
28*380b5c7dSchl>39  string		iHP-100	[H Series]
29*380b5c7dSchl
30*380b5c7dSchl#------------------------------------------------------------------------------
31*380b5c7dSchl# SQLite database files
32*380b5c7dSchl# Ken Guest <ken@linux.ie>, Ty Sarna, Zack Weinberg
33*380b5c7dSchl#
34*380b5c7dSchl# Version 1 used GDBM internally; its files cannot be distinguished
35*380b5c7dSchl# from other GDBM files.
36*380b5c7dSchl#
37*380b5c7dSchl# Version 2 used this format:
38*380b5c7dSchl0	string	**\ This\ file\ contains\ an\ SQLite  SQLite 2.x database
39*380b5c7dSchl
40*380b5c7dSchl# Version 3 of SQLite allows applications to embed their own "user version"
41*380b5c7dSchl# number in the database.  Detect this and distinguish those files.
42*380b5c7dSchl
43*380b5c7dSchl0   string  SQLite\ format\ 3
44*380b5c7dSchl>60 string  _MTN               Monotone source repository
45*380b5c7dSchl>60 belong  !0                 SQLite 3.x database, user version %u
46*380b5c7dSchl>60 belong  0                  SQLite 3.x database
47