Difference between revisions of "SYSTIMELINE"

Revision as of 00:00, 2 December 2009

Stores database timelines row versioning records

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.

Column	Data Type	Width	Description
DATABASE	C	30	Master database name
TABLE	C	30	Master table name
RUID	C	16	Unique row id
RID	I	11	Table row id
USER	C	20	User login that changed the data
LOCATION	C	30	IP address where data was changed from
TIMESTAMP	C	16	Timestamp of change
COMMAND	C	20	Command that changed the data
OLDDATA	M	8	Data before change
NEWDATA	M	8	Data after change

SELECT * FROM systimeline WHERE between(timestamp, '20091001', '20091007')

Recital, Recital Server

@@ Line 13: / Line 13: @@
 {| class="wikitable"
 !Column||Data Type||Width||Description
+|-
+|DATABASE||C||30||Master database name
 |-
 |TABLE||C||30||Master table name
@@ Line 22: / Line 24: @@
 |USER||C||20||User login that changed the data
 |-
-|LOCATION||C||30||IP address of the master data server
+|LOCATION||C||30||IP address where data was changed from
 |-
-|TIMESTAMP||C||16||Timestamp from the master record
+|TIMESTAMP||C||16||Timestamp of change
 |-
 |COMMAND||C||20||Command that changed the data
 |-
-|OLDDATA||M||8||Affected data prior to change
+|OLDDATA||M||8||Data before change
 |-
 |NEWDATA||M||8||Data after change
 |-
 |}
 ==Example==