Create Snapshot Table
Follow these steps in order to create the snapshot table:
- Drop snapshot table,
nextSnapshotId table, and getNextSnapshotId proc.
- Create and populate
nextSnapshotId table; create snapshot table, index and primary key
- Create 1st foreign key
- Create 2nd foreign key
- Create 3rd foreign key
- Create 4th foreign key
- Create 5th foreign key
- Create 6th foreign key
- Create
getNextSnapshotId stored procedure