31,003
edits
Module development: Difference between revisions
Jump to navigation
Jump to search
m
→Create your .sql file
| Line 69: | Line 69: | ||
''Rules to follow:'' | ''Rules to follow:'' | ||
* 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 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. | ||
* Don't use the double quote for strings (eg 'chaine' not "chaine") because the double quote have a specific meaning in PostGreSQL | * Don't use the double quote for strings (eg 'chaine' not "chaine") because the double quote have a specific meaning in PostGreSQL | ||