sql 3.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. #------------------------------------------------------------------------------
  2. # $File: sql,v 1.14 2014/04/28 12:04:50 christos Exp $
  3. # sql: file(1) magic for SQL files
  4. #
  5. # From: "Marty Leisner" <mleisner@eng.mc.xerox.com>
  6. # Recognize some MySQL files.
  7. # Elan Ruusamae <glen@delfi.ee>, added MariaDB signatures
  8. # from https://bazaar.launchpad.net/~maria-captains/maria/5.5/view/head:/support-files/magic
  9. #
  10. 0 beshort 0xfe01 MySQL table definition file
  11. >2 byte x Version %d
  12. 0 belong&0xffffff00 0xfefe0700 MySQL MyISAM index file
  13. >3 byte x Version %d
  14. 0 belong&0xffffff00 0xfefe0800 MySQL MyISAM compressed data file
  15. >3 byte x Version %d
  16. 0 belong&0xffffff00 0xfefe0900 MySQL Maria index file
  17. >3 byte x Version %d
  18. 0 belong&0xffffff00 0xfefe0A00 MySQL Maria compressed data file
  19. >3 byte x Version %d
  20. 0 belong&0xffffff00 0xfefe0500 MySQL ISAM index file
  21. >3 byte x Version %d
  22. 0 belong&0xffffff00 0xfefe0600 MySQL ISAM compressed data file
  23. >3 byte x Version %d
  24. 0 string \376bin MySQL replication log
  25. 0 belong&0xffffff00 0xfefe0b00
  26. >4 string MARIALOG MySQL Maria transaction log file
  27. >>3 byte x Version %d
  28. 0 belong&0xffffff00 0xfefe0c00
  29. >4 string MACF MySQL Maria control file
  30. >>3 byte x Version %d
  31. #------------------------------------------------------------------------------
  32. # iRiver H Series database file
  33. # From Ken Guest <ken@linux.ie>
  34. # As observed from iRivNavi.iDB and unencoded firmware
  35. #
  36. 0 string iRivDB iRiver Database file
  37. >11 string >\0 Version %s
  38. >39 string iHP-100 [H Series]
  39. #------------------------------------------------------------------------------
  40. # SQLite database files
  41. # Ken Guest <ken@linux.ie>, Ty Sarna, Zack Weinberg
  42. #
  43. # Version 1 used GDBM internally; its files cannot be distinguished
  44. # from other GDBM files.
  45. #
  46. # Version 2 used this format:
  47. 0 string **\ This\ file\ contains\ an\ SQLite SQLite 2.x database
  48. # Version 3 of SQLite allows applications to embed their own "user version"
  49. # number in the database at offset 60. Later, SQLite added an "application id"
  50. # at offset 68 that is preferred over "user version" for indicating the
  51. # associated application.
  52. #
  53. 0 string SQLite\ format\ 3
  54. >60 belong =0x5f4d544e Monotone source repository - SQLite3 database
  55. >68 belong =0x0f055112 Fossil checkout - SQLite3 database
  56. >68 belong =0x0f055113 Fossil global configuration - SQLite3 database
  57. >68 belong =0x0f055111 Fossil repository - SQLite3 database
  58. >68 belong =0x42654462 Bentley Systems BeSQLite Database - SQLite3 database
  59. >68 belong =0x42654c6e Bentley Systems Localization File - SQLite3 database
  60. >68 belong =0x47504b47 OGC GeoPackage file - SQLite3 database
  61. >68 default x SQLite 3.x database
  62. >>68 belong !0 \b, application id %u
  63. >>60 belong !0 \b, user version %d
  64. # SQLite Write-Ahead Log from SQLite version >= 3.7.0
  65. # http://www.sqlite.org/fileformat.html#walformat
  66. 0 belong&0xfffffffe 0x377f0682 SQLite Write-Ahead Log,
  67. >4 belong x version %d
  68. # SQLite Rollback Journal
  69. # http://www.sqlite.org/fileformat.html#rollbackjournal
  70. 0 string \xd9\xd5\x05\xf9\x20\xa1\x63\xd7 SQLite Rollback Journal
  71. # Panasonic channel list database svl.bin or svl.db added by Joerg Jenderek
  72. # http://www.ullrich.es/job/service-menue/panasonic/panasonic-sendersortierung-sat-am-pc/
  73. # pceditor_V2003.jar
  74. 0 string PSDB\0 Panasonic channel list database
  75. >126 string SQLite\ format\ 3
  76. >>&-15 indirect x \b; contains