22 lines
637 B
YAML
22 lines
637 B
YAML
|
Settings:
|
||
|
|
Condition: 'TIMESTAMPDIFF(HOUR,last_change,NOW()) > 72'
|
||
|
|
PrimaryKey: 'seqid'
|
||
|
|
DeleteSource: true
|
||
|
|
DBConfig:
|
||
|
|
Username: apisvc
|
||
|
|
Password: wcqte
|
||
|
|
Server: 127.0.0.1
|
||
|
|
Port: 3306
|
||
|
|
Database: ewsv3_f715
|
||
|
|
SourceTable: uutinfo
|
||
|
|
DestinationTable: uutinfobkup
|
||
|
|
SourceColumns: [seqid,usn,mac,ipaddr,relay,item,status,message,first_ack,last_ack,last_change,partno,mo,sku,line,stage]
|
||
|
|
DestinationColumns: [usn,mac,ipaddr,relay,item,status,message,first_ack,last_ack,last_change,partno,mo,sku,line,stage]
|
||
|
|
FormatColumns:
|
||
|
|
Enablement: true
|
||
|
|
Reference: 'last_change'
|
||
|
|
Year: 'syear'
|
||
|
|
Month: 'smonth'
|
||
|
|
Day: 'sday'
|
||
|
|
Week: 'sweek'
|