OpenEstate-SQL Change-Log

Inhaltsverzeichnis

0000025: [SQL-Schema] Countries are stored in a separate table. The country-names are translated to any known language.
0000026: [SQL-Schema] Datatypes for latitude and longitude were changed from float to decimal(18,15).

The database-structures are explicitly created for MySQL.
- AUTO INCREMENT was definied on all Primary-Keys.
- Prebuild database-structures for different databases will be published as required.
A definition-problem was corrected on the fields 'action_id' & 'type_id' from table 'openestate_objects'.
- The fields were defined with NOT NULL. But the Foreign-Key-option ON DELETE SET NULL could lead to conflicts.
- The fields are now defined as NULL.

Version-numbers for properties & contacts are saved in 'openestate_versions'.
Some Foreign-Keys have been redefined for better compability to the SQL-standards.
Naming of tables and fields have been adapted from the XML-specifications.
Some field-definitions have been corrected (default-values, NOT NULL, indices, etc.).