SQLMaker File Format

Here you can find all internals to read and write *.sqm files. Like OpenOffice or MS Office 2007 these files are a ZIP archive which contains text files with all relevant information.

The *.sqm file format is a standard zip file with the extension sqm instead of zip. To view or extract you simply need to add ".zip" to your file name.

The extracted file contains a bunch of directories. Each one represents a table and contains two files, structure.txt and data.txt. Both are comma separated text files.

structure.txt

This file contains the native SQL information about a table. This is the current column list:

1. name
   The column name
2. type
   The column type. Currently all MySQL types are allowed. Other RDB types are tolerated.
3. size
   The column size. For column types which do not need a size (TEXT, BLOB, DATE, etc.) this field has to be set to "0"
4. options
   A collection of flags in decimal representation. Currently these flags are in use:

   Name	Hex Value	Description
   NOT_NULL	0x01	When true, this column does not allow empty cells
   UNSIGNED	0x02	SQL unsigned flag
   ZEROFILL	0x04	SQL zerofill flag
   BINARY	0x08	SQL binary flag
   AUTO_INCREMENT	0x10	MySQL autoincrement flag

5. def
   The default value for this column
6. indexName
   The index type in decimal representation.

   Name	Hex Value
   NONE	0x00
   INDEX	0x20
   UNIQUE	0x40
   PRIMARY_KEY	0x80

   The field should be renamed to indexType later
   

data.txt

This file contains the data of the current table. The first line contains the field names.