304
edits
Changes
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 will be defined in another file called <tt>llx_''mytable''.key.sql</tt>
+* 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">