Difference between revisions of "Itk"

From SPGC Document Wiki
Jump to: navigation, search
(Created page with "==auditlogs== {| class="wikitable" \ !colspan="7" | auditlogs |- ! style="text-align:left;" | Column Name ! Data Type ! Length ! Is PrimaryKey ! Is Not Null ! Auto Increment |...")
 
(→‎auditlogs)
Line 9: Line 9:
 
! Is Not Null
 
! Is Not Null
 
! Auto Increment
 
! Auto Increment
−
|-
 
−
|recid
 
−
|int
 
−
|30
 
−
|Yes
 
−
|Yes
 
−
|Yes
 
 
|-
 
|-
 
|LOG_USER
 
|LOG_USER
 
|varchar
 
|varchar
−
|25
+
|10
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
 
|LOG_MODULE
 
|LOG_MODULE
 
|varchar
 
|varchar
−
|50
+
|20
−
|No
+
−
|Yes
+
−
|No
+
−
|-
+
−
|LOG_KEYREC
+
−
|varchar
+
−
|50
+
 
|No
 
|No
 
|No
 
|No
Line 40: Line 26:
 
|LOG_TBL
 
|LOG_TBL
 
|varchar
 
|varchar
−
|50
+
|60
−
|No
+
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
 
|LOG_DATE
 
|LOG_DATE
−
|datetime
+
|date
 
|0
 
|0
−
|Yes
+
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_TIME
 +
|varchar
 +
|10
 +
|No
 
|No
 
|No
 
|No
 
|No
Line 54: Line 47:
 
|LOG_ENUMB
 
|LOG_ENUMB
 
|varchar
 
|varchar
−
|25
+
|15
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|LOG_MODFLD
+
|LOG_KEYREC
−
|longtext
+
|varchar
−
|0
+
|60
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
 
|LOG_FIELD
 
|LOG_FIELD
 
|varchar
 
|varchar
−
|25
+
|20
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
 
|LOG_OLDVAL
 
|LOG_OLDVAL
 
|varchar
 
|varchar
−
|40
+
|30
 
|No
 
|No
 
|Yes
 
|Yes
Line 82: Line 75:
 
|LOG_NEWVAL
 
|LOG_NEWVAL
 
|varchar
 
|varchar
−
|40
+
|30
 
|No
 
|No
 
|Yes
 
|Yes
−
|No
 
−
|-
 
−
|LOG_SQLEXEC
 
−
|longtext
 
−
|0
 
−
|No
 
−
|No
 
 
|No
 
|No
 
|-
 
|-
 
|LOG_CHANGE
 
|LOG_CHANGE
 
|varchar
 
|varchar
−
|25
+
|1
 
|No
 
|No
 
|Yes
 
|Yes
Line 103: Line 89:
 
|LOG_IPADDR
 
|LOG_IPADDR
 
|varchar
 
|varchar
−
|25
+
|20
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
 
|LOG_PRNT
 
|LOG_PRNT
 
|varchar
 
|varchar
−
|25
+
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOG_SQLEXEC
 +
|longtext
 +
|0
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|}
 
|}

Revision as of 13:27, 9 August 2016

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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Itk&oldid=2777"