Language and development rules: Difference between revisions

Jump to navigation Jump to search
m
Line 249: Line 249:
== Mysql specificities ==
== Mysql specificities ==
* Tables must be declared with format InnoDB.
* Tables must be declared with format InnoDB.
This format support foreign keys and their restrictions, and transactions integrity is also supported. This guarantee that Dolibarr events keep all data with correct values between tables even even transaction modify different tables.
This format supports foreign keys and their restrictions, and transactions integrity is also supported. This guarantees that Dolibarr events keep all data with correct values between tables even when transaction modify different tables.


* Dolibarr must works even if Mysql option '''strict''' is active.
* Dolibarr must work even if Mysql option '''strict''' is active.
To activate it (recommanded when developping on Dolibarr), add the following line into the config file of your Mysql server (my.cnf or my.ini)
To activate it (recommended when developing on Dolibarr), add the following line into the config file of your Mysql server (my.cnf or my.ini)
<source lang="ini">
<source lang="ini">
sql-mode="STRICT_ALL_TABLES,ONLY_FULL_GROUP_BY,NO_ZERO_DATE"
sql-mode="STRICT_ALL_TABLES,ONLY_FULL_GROUP_BY,NO_ZERO_DATE"
304

edits

Navigation menu