SQLMaker Meta Table

The meta table description tells you everything you need about the internal SQLMaker table, which contains additional database information about alias names, relations, scripts (not implemented yet) and layouts.

 

structure.txt

Like the structure.txt file for normal tables, this file contains the basic structure and must not be altered.

 

data.txt

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

	type	id	parentId	name	comment	dependencies	t1	t2	b1	i1	i2	i3	i4	i5
column	100	id	parentTableId	name	comment	notifier_col_Ids	formula	auto enter1)		rep	storage2)	base_aliasId	flags3)	display4)
media	95	id	(parentLayoutId)	path				mime	cont
layout	90	id	parentTableId	path	comment		title not unique	mime	cont	parentAliasId	maxRecords	Views
scriptstep	85	id	parentScriptId	name	comment	child_IDs
script	80	id		name	comment	col_IDs
relation	30	id	leftAliasId	int. name	comment	col_IDs	link	label		rightAliasId
alias	20	id	targetTableId	name	comment		foreignDb	foreignHost
table	10	id		name	comment

1) Given String is 'mode,inc,data', so the data may contain ',' without an escape sequence

Name	Hex Value	Flag	Description
NONE	0x00
DATE	0x01
TIME	0x02
USER	0x03
SERIAL	0x04
DATA	0x08
UPDATE	0x10	x	When set then an existing cell value will be overwritten

2) Storage mode

Name	Value	Description
INVALID	-1	True when sqlmaker find inconsistencies between the meta table and the native database
STORED	0	Stored under the given name in the underlying RDB
UNSTORED_TEXT	1
UNSTORED_NUMBER	2
UNSTORED_DATE	3
UNSTORED_TIME	4

3) Flags

Name	Value	Description
AUTO_INDEX	0x100	When set to true, then an index is automatically created as soon as a search on this field is performed or this field is part of a relation (join)
AUTO_CHANGE	0x200	When set to true and a value is entered which extends the size or type of this column, then the table structure will be updated automatically

4) Display (Currently unused)