Bureaucrats, emailconfirmed, Administrators
44
edits
Changes
→Datatables extrafield tables models : add example of sql file
Line 18:
Line 18:
== Datatables extrafield tables models ==
== Datatables extrafield tables models ==
+
llx_''BaseTableNAme''_extrafields
llx_''BaseTableNAme''_extrafields
rowid integer AUTO_INCREMENT PRIMARY KEY,
rowid integer AUTO_INCREMENT PRIMARY KEY,
Line 23:
Line 24:
fk_object integer NOT NULL,
fk_object integer NOT NULL,
import_key varchar(14)
import_key varchar(14)
+
+
+An example of mysql definition file for extrafields implementation on an object :
+
+ create table llx_place_room_extrafields
+ (
+ rowid integer AUTO_INCREMENT PRIMARY KEY,
+ tms timestamp,
+ fk_object integer NOT NULL,
+ import_key varchar(14) -- import key
+ ) ENGINE=innodb;
== Load class for extrafields ==
== Load class for extrafields ==