Itk

auditlogs

auditlogs
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
LOG_USER	varchar	10	No	No	No
LOG_MODULE	varchar	20	No	No	No
LOG_TBL	varchar	60	No	Yes	No
LOG_DATE	date	0	No	No	No
LOG_TIME	varchar	10	No	No	No
LOG_ENUMB	varchar	15	No	No	No
LOG_KEYREC	varchar	60	No	No	No
LOG_FIELD	varchar	20	No	No	No
LOG_OLDVAL	varchar	30	No	Yes	No
LOG_NEWVAL	varchar	30	No	Yes	No
LOG_CHANGE	varchar	1	No	Yes	No
LOG_IPADDR	varchar	20	No	No	No
LOG_PRNT	varchar	1	No	Yes	No
LOG_SQLEXEC	longtext	0	No	Yes	No

dailymhr2015

dailymhr2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
LOG_USER	varchar	10	No	No	No
LOG_MODULE	varchar	20	No	No	No
LOG_TBL	varchar	60	No	Yes	No
LOG_DATE	date	0	No	No	No
LOG_TIME	varchar	10	No	No	No
LOG_ENUMB	varchar	15	No	No	No
LOG_KEYREC	varchar	60	No	No	No
LOG_FIELD	varchar	20	No	No	No
LOG_OLDVAL	varchar	30	No	Yes	No
LOG_NEWVAL	varchar	30	No	Yes	No
LOG_CHANGE	varchar	1	No	Yes	No
LOG_IPADDR	varchar	20	No	No	No
LOG_PRNT	varchar	1	No	Yes	No
LOG_SQLEXEC	longtext	0	No	Yes	No