31,014
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
→DDL file format
| Line 166: | Line 166: | ||
entity integer DEFAULT 1 NOT NULL, -- multi company id | entity integer DEFAULT 1 NOT NULL, -- multi company id | ||
ref_ext varchar(255),-- reference into an external system (not used by dolibarr) | ref_ext varchar(255),-- reference into an external system (not used by dolibarr) | ||
field_one integer, | field_one integer, | ||
field_two integer NOT NULL, | field_two integer NOT NULL, | ||
fk_field integer, | fk_field integer, | ||
field_date datetime, | field_date datetime, | ||
datec datetime NOT NULL default CURRENT_TIMESTAMP, -- creation datetime | datec datetime NOT NULL default CURRENT_TIMESTAMP, -- creation datetime | ||
tms timestamp NOT NULL default CURRENT_TIMESTAMP, -- update time stamp | tms timestamp NOT NULL default CURRENT_TIMESTAMP, -- update time stamp | ||
fk_user_author integer NOT NULL, -- Author foreign key of llx_user | fk_user_author integer NOT NULL, -- Author, foreign key of llx_user | ||
fk_user_mod integer NOT NULL | fk_user_mod integer NOT NULL -- Last updater, foreign key of llx_user | ||
)type=innodb; | )type=innodb; | ||
</source> | </source> | ||