Bureaucrats, emailconfirmed, Administrators
44
edits
Extrafields: Difference between revisions
Jump to navigation
Jump to search
→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 == | ||