31,003
edits
Module development: Difference between revisions
Jump to navigation
Jump to search
m
→Create your .sql file
| Line 46: | Line 46: | ||
''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 '''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 '''includes/mysql/tables''' for examples). | ||
* To manage data, you must create a file called '''data.sql''' inside directory '''/mymodule/sql/''' that contains SQL command to add/edit/delete datas. | * To manage data, you must create a file called '''data.sql''' inside directory '''/mymodule/sql/''' that contains SQL command to add/edit/delete datas. | ||