27,414
edits
Changes
Jump to navigation
Jump to search
mLine 70:
Line 70: − +
→Create your SQL tables and the PHP DAO class (optional)
* Add the files about creating tables commands on the principle of a file '''llx_matable.sql''' per table, with a possibly file '''llx_matable.key.sql''' (see existing files in '''install/mysql/tables''' for examples).
* Add the files about creating tables commands on the principle of a file '''llx_matable.sql''' per table, with a possibly file '''llx_matable.key.sql''' (see existing files in '''install/mysql/tables''' for examples).
The recommended type and name of fields are defined into page [[Language_and_development_rules#Table_and_fields_structures]].
The recommended type and name for SQL fields are defined into page [[Language_and_development_rules#Table_and_fields_structures]].
* To manage data, you must create a file called '''data.sql''' inside directory '''/mymodule/sql/''' that contains SQL command to add/edit/delete data.
* To manage data, you must create a file called '''data.sql''' inside directory '''/mymodule/sql/''' that contains SQL command to add/edit/delete data.