Difference between revisions of "SYSTIMELINE"

From Recital Documentation Wiki
Jump to: navigation, search
 
(5 intermediate revisions by 2 users not shown)
Line 4: Line 4:
  
 
==See Also==
 
==See Also==
[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]]
+
[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[UNWATCH()]], [[WATCH()]], [[WATCHCHANGED()]], [[WATCHING()]], [[WATCHRESET()]]
  
  
Line 13: Line 13:
 
{| class="wikitable"
 
{| class="wikitable"
 
!Column||Data Type||Width||Description
 
!Column||Data Type||Width||Description
 +
|-
 +
|DATABASE||C||30||Master database name
 
|-
 
|-
 
|TABLE||C||30||Master table name
 
|TABLE||C||30||Master table name
Line 22: Line 24:
 
|USER||C||20||User login that changed the data
 
|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
 
|COMMAND||C||20||Command that changed the data
 
|-
 
|-
|OLDDATA||M||8||Data affected by change
+
|OLDDATA||M||8||Data before change
 
|-
 
|-
|NEWDATA||M||8||Affected data prior to change
+
|NEWDATA||M||8||Data after change
 
|-
 
|-
 
|}
 
|}
Line 46: Line 48:
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:System Tables]]
 
[[Category:System Tables]]
 +
[[Category:Database Timelines]]

Latest revision as of 09:45, 6 July 2011

Purpose

Stores database timelines row versioning records


See Also

CLEAR TIMELINE, LIST TIMELINE, ROLLBACK TIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTEM TABLES, UNWATCH(), WATCH(), WATCHCHANGED(), WATCHING(), WATCHRESET()


Description

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


Example

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


Products

Recital, Recital Server