Cumulusmx.db: Difference between revisions

Cumulusmx.db (view source)

66 bytes removed , 09:45, 1 October 2022

m

1,648

edits

@@ Line 215: / Line 215: @@
 |-
 | 0
-| Timestamp
+| key
-| datetime
+| integer
-| Primary Key, can never be NULL, No Default Value,
+| Primary Key, Not NULL, No Default Value,
-| Dates and times for the last 7 days, at whatever interval available (at logging interval for historic archive data, at one minute intervals while MX is running)
+| An autoincrement integer for every SQL statement entered in the cache
+|-
+|-
+| 1
+| statement
+| varchar
+| Not NULL, No Default Value,
+| Contains the actual SQL statement that failed
 |-
 |}
-#key; An autoincrement integer for every SQL statement entered in the cache
+#key;
 #statement; A varchar (string) containing the SQL statement that failed
 = SQLite Sequence =
 No relevant information on this table is known