31,014
edits
Module development: Difference between revisions
Jump to navigation
Jump to search
→Create your .sql file
| Line 62: | Line 62: | ||
''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 ''' | * 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). | ||
* 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. | ||