Dolibarr ERP CRM Wiki

Table llx cronjob: Difference between revisions

Page

Table llx cronjob (view source)

Revision as of 21:23, 6 September 2019

140 bytes added ,  7 years ago
m
→‎Keys
VisualWikitext
m (Eldy moved page Table llx cron to Table llx cronjob without leaving a redirect)
Tag: 2017 source edit
 
(2 intermediate revisions by the same user not shown)
Line 29: Line 29:
|technical index
|technical index
|-
|-
|name
|tms
|varchar(255)
|timestamp
|NO
|NO
|UNI
|
|
|
|
|key/name of constant
|
|Last update date
|-
|datec
|datetime
|NO
|
|
|
|Date creation
|-
|-
|entity
|jobtype
|int(11)
|varchar(10)
|NO
|NO
|UNI
|1
|
|
|multi company id
|
|
|Type of job
|-
|-
|value
|label
|text
|text
|NO
|
|
|
|
|
|
|value of constant.
|
|
|-
|-
|type
|command
|varchar(6)
|varchar(10)
|YES
|YES
|
|
|NULL
|
|
|type of constant (deprecated)
|
|
|-
|-
|visible
|tinyint(4)
|NO
|
|
|1
|
|
|is the constant visible in the page home->setup->other ?
|
|
|
|
|
|-
|
|
|
|
|
|
|
|-
|
|
|
|
|
|
|
|-
|
|
|
|
|
|
|
|-
|-
|note
|text
|YES
|
|
|NULL
|
|
|notes about the constant {{FieldTms}}
|
|
|
|
|
|-
|entity
|int(11)
|NO
|UNI
|1
|
|multi company id
|} 
|} 
==Keys==
==Keys==
Line 87: Line 127:
|rowid
|rowid
|-
|-
|uk_const
|idx_cronjob_status
|UNIQUE
|INDEX
|name,entity
|status
|-
|idx_cronjob_datelastrun
|INDEX
|datelastrun
|-
|idx_cronjob_datenextrun
|INDEX
|datenextrun
|-
|idx_cronjob_datestart
|INDEX
|datestart
|-
|idx_cronjob_dateend
|INDEX
|dateend
|} 
|} 
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/44201...44204"