From 1a3d95e55adf7c762de7e26ac1fa5fe0548d8d2b Mon Sep 17 00:00:00 2001 From: Christos Zoulas Date: Mon, 22 Jan 2007 06:40:50 +0000 Subject: [PATCH] sqlite improvements --- magic/Magdir/database | 4 ---- magic/Magdir/sql | 19 +++++++++++++++---- 2 files changed, 15 insertions(+), 8 deletions(-) diff --git a/magic/Magdir/database b/magic/Magdir/database index b2f68d98..aef8469c 100644 --- a/magic/Magdir/database +++ b/magic/Magdir/database @@ -210,7 +210,3 @@ 16 string MIT-MAGIC-COOKIE-1 X11 Xauthority data 17 string MIT-MAGIC-COOKIE-1 X11 Xauthority data 18 string MIT-MAGIC-COOKIE-1 X11 Xauthority data - -# SQLite (Ty Sarna) -0 string **\ This\ file\ contains\ an\ SQLite SQLite Database ->&1 regex [^\ ]+ Version %s diff --git a/magic/Magdir/sql b/magic/Magdir/sql index 016e030b..21c6e515 100644 --- a/magic/Magdir/sql +++ b/magic/Magdir/sql @@ -27,8 +27,19 @@ >39 string iHP-100 [H Series] #------------------------------------------------------------------------------ -# SQLite database file -# From Ken Guest +# SQLite database files +# Ken Guest , Ty Sarna, Zack Weinberg +# +# Version 1 used GDBM internally; its files cannot be distinguished +# from other GDBM files. # -0 string SQLite SQLite database ->14 string >\0 (Version %s) +# Version 2 used this format: +0 string **\ This\ file\ contains\ an\ SQLite SQLite 2.x database + +# Version 3 of SQLite allows applications to embed their own "user version" +# number in the database. Detect this and distinguish those files. + +0 string SQLite\ format\ 3 +>60 string _MTN Monotone source repository +>60 belong !0 SQLite 3.x database, user version %u +>60 belong 0 SQLite 3.x database -- 2.40.0