304
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
m
→DDL file format
| Line 154: | Line 154: | ||
* Each table is defined by its own file whose name is <tt>llx_''mytable''.sql</tt> | * Each table is defined by its own file whose name is <tt>llx_''mytable''.sql</tt> | ||
A comment will be added for each field to explain its usage. | A comment will be added for each field to explain its usage. | ||
* All foreign keys, performance indexes or other constraints | * All foreign keys, performance indexes or other constraints has to be defined in another file called <tt>llx_''mytable''.key.sql</tt> | ||
These files must be stored in the directory '''install/mysql/tables''' for all standard files or '''mymodule/tables''' for tables provided by an external module. | These files must be stored in the directory '''install/mysql/tables''' for all standard files or '''mymodule/tables''' for tables provided by an external module. | ||
Example '''file for table llx_mytable.sql''': | Example '''file for creating the table llx_mytable will be llx_mytable.sql''': | ||
<source lang="sql"> | <source lang="sql"> | ||
| Line 196: | Line 196: | ||
</source> | </source> | ||
Example '''file for keys/indexes will be llx_mytable.key.sql''': | Example '''file for creating keys/indexes for the table llx_mytable will be llx_mytable.key.sql''': | ||
<source lang="sql"> | <source lang="sql"> | ||