Difference between revisions of "SYSTIMELINE"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
| (10 intermediate revisions by 4 users not shown) | |||
| Line 3: | Line 3: | ||
==See Also== | ==See Also== | ||
| − | [[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[TIMELINE()]] | + | [[ALTER DATABASE]], [[CLEAR TIMELINE]], [[:Category:Database Timelines|Database Timelines Commands and Functions]], [[Database Timelines (Video)]], [[DTOS()]], [[LIST TIMELINE]], [[MetaData Editor]], [[ROLLBACK TIMELINE]], [[SET SYSTIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[TIMELINE()]], [[Timeline Section Attributes]], [[Understanding database timelines in Lianja|Understanding Database Timelines]] |
==Description== | ==Description== | ||
| − | + | The systimeline table is stored in the system database and holds database timelines row versioning information. | |
| − | {| class="wikitable" | + | {| class="wikitable" width="100%" |
!Column||Data Type||Width||Description | !Column||Data Type||Width||Description | ||
|- | |- | ||
| Line 32: | Line 32: | ||
|- | |- | ||
|} | |} | ||
| + | |||
| + | Note: the systimeline table only exists after [[SET TIMELINE]] has been set ON and timeline entries have been created. | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | SELECT * FROM systimeline WHERE between(timestamp, ' | + | SELECT * FROM system!systimeline WHERE between(left(timestamp,8), '20171001', '20171007') |
</code> | </code> | ||
| Line 43: | Line 45: | ||
[[Category:Databases]] | [[Category:Databases]] | ||
[[Category:Database Timelines]] | [[Category:Database Timelines]] | ||
| + | [[Category:Lianja VFP Extensions]] | ||
| + | [[Category:VFP Command Extensions]] | ||
Latest revision as of 06:20, 22 April 2020
Contents
Purpose
Stores database timelines row versioning records
See Also
ALTER DATABASE, CLEAR TIMELINE, Database Timelines Commands and Functions, Database Timelines (Video), DTOS(), LIST TIMELINE, MetaData Editor, ROLLBACK TIMELINE, SET SYSTIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTEM TABLES, TIMELINE(), Timeline Section Attributes, Understanding Database Timelines
Description
The systimeline table is stored in the system database and holds database timelines row versioning information.
| 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 |
Note: the systimeline table only exists after SET TIMELINE has been set ON and timeline entries have been created.
Example
SELECT * FROM system!systimeline WHERE between(left(timestamp,8), '20171001', '20171007')
