31,003
edits
Module development: Difference between revisions
Jump to navigation
Jump to search
m
→Create your SQL tables and the PHP DAO class (optional)
| Line 70: | Line 70: | ||
* 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 | 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. | ||