304
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
m
→DDL file format
| Line 152: | Line 152: | ||
== DDL file format == | == DDL file format == | ||
Files containing definition of the database structure (DDL files) must be '''2 per table''': | Files containing definition of the database structure (DDL files) must be '''2 per table''': | ||
* The first file defines the table and its fields. The file name contains the table name like <tt>llx_''mytable''.sql</tt> | * The first file defines the table and its fields. The file name contains the table name, e.g. like this: <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. | ||
* The second file defines all foreign keys, performance indexes or other constraints and the file name will be like <tt>llx_''mytable''.key.sql</tt> | * The second file defines all foreign keys, performance indexes or other constraints and the file name will be like: <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. | ||