ezbuild Files

EZbuild metameta xls file

The file metameta.xls is used to generate a MySQL database.
The database is the input for ezbuild metameta environment.
With this environment a meta environment can be created.

Every sheet in the workbook describes a table.
The sheet menu is the main page and has 3 columns and many buttons.
The first column describes the name of all the sheets in the workbook.
The second column called generate holds 1 or blank.
To navigate to the work book click on the Select sheet button when your cursor is in the A column.
If this column holds 1 the table will be generated.

The MySQL code is generated in a sheet and can be exported by using
the button output mysql code. The path of the output mysql file can be
parameterized by filling in cell D2 of the menu sheet file.

The table descriptions (for instance table mm_choice) are present as separate sheets.
Every sheet representing a table has columns described on row 1.
A sheet can have column sel_ these columns are skipped during generation.
They are used to select columns using a validation area and a lookup field on finding the number of the ID field.

The MySQL type of field can be filled in as an Excell comment on the first row:
The comment can hold:

mysql type like varchar(100)
AI for autoincrement fields
null allowed
iskey (for primary key fields e.g used in couple tables)

The generator drops tables in the generated mysql code.
The button check tables generates an overview of all the tables with their types in sheet check.
In the sheet check you can see if you made mistakes (e.g. columns without type).

Conventions used:

tables start by mm_ since this is metameta data
boolean fields start with is_ and uses mysql type int(4)
key fields ends with ID (capitals)
foreign keys start with <>_<key column>ID for example the field used_languageID refers to an entry in the language table.
the key of language is the AI field languageID.

the generated mysql database is input for the website ezbuild metameta. In this site you can search easily and start editing the
tables. The site is june 8 2014 in the middle of creation.

This site will generate a meta ezbuild site.
This meta site can be used to generate target data.
This is why Excel in combination of VBA is used metameta can not have web code since you will need metametameta and so on.

Room for improvement:
check if a column is unique for a table