Module development: Difference between revisions

Module development (view source)

14 bytes added , 7 years ago

m

31,003

edits

@@ Line 59: / Line 59: @@
 If your module is designed to manage data of its own, which are not available in the standard version of Dolibarr, it is necessary to define SQL tables to store the data.
-Scripts for creating tables and load data for your own module must be placed in a directory: Create a subdirectory called "sql" into directory of your module (eg htdocs/mymodule/sql) to put the sql scripts that you will create.
+Scripts for creating tables and load data by your own module are saved into a subdirectory called "/mymodule/sql".
 Then check into your descriptor file, into function '''init''' that the line
@@ Line 69: / Line 69: @@
 ''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).
+The recommended type and name of 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.