150479Speter#	$OpenBSD: sql,v 1.2 2008/05/08 01:40:57 chl Exp $
215842Swosch
3113091Sobrien#------------------------------------------------------------------------------
4117558Snjl# sql:  file(1) magic for SQL files
5117539Snjl#
6211725Simp# From: "Marty Leisner" <mleisner@eng.mc.xerox.com>
715842Swosch# Recognize some MySQL files.
83259Sdg#
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