8
edits
Module development: Difference between revisions
Jump to navigation
Jump to search
m
→Create your SQL tables and the PHP DAO class (optional): Language
No edit summary Tag: 2017 source edit |
|||
| Line 92: | Line 92: | ||
''Rules to follow:'' | ''Rules to follow:'' | ||
*Add the files about creating tables commands on the principle of | *Add the files about creating tables commands on the principle of an '''llx_mytable.sql''' file per table, with an optional '''llx_mytable.key.sql''' file (see existing files in '''install/mysql/tables''' for examples). | ||
*The recommended type and name for SQL 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. | ||