SYSTIMELINE

From Recital Documentation Wiki
Revision as of 09:45, 6 July 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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