304
edits
| Line 249: | Line 249: | ||
== Mysql specificities == | == Mysql specificities == | ||
* Tables must be declared with format InnoDB. | * Tables must be declared with format InnoDB. | ||
This format | 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 | * Dolibarr must work even if Mysql option '''strict''' is active. | ||
To activate it ( | 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" | ||
edits