...
- auto increment for all ID fields in database
- further unification of fields (all primary keys and foreign keys are represented solely by INT)
- further cleaning of indexes
Refined schema (step 6)
Experiment database
- all text fields are now represented by VARCHAR (it's still a subject to change)
- using TEXT as type of column lead to strange issues in some of the SQL engines (e.g. H2)