Ticket #33997: create_version-table-database.sql
| File create_version-table-database.sql, 333 bytes (added by , 2 years ago) |
|---|
| Line | |
|---|---|
| 1 | CREATE TABLE DaasVersionTest( |
| 2 | value INT, |
| 3 | `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY WITHOUT SYSTEM VERSIONING, |
| 4 | start_timestamp TIMESTAMP(6) GENERATED ALWAYS AS ROW START, |
| 5 | end_timestamp TIMESTAMP(6) GENERATED ALWAYS AS ROW END, |
| 6 | PERIOD FOR SYSTEM_TIME(start_timestamp, end_timestamp) |
| 7 | ) WITH SYSTEM VERSIONING; |