You are creating a primary table and an auxiliary table for an Item descriptor in the versioned
schema. What are the properties that must be added to the tables?
A.
You only need to add asset_version to both the tables.
B.
You need to add asset_version to both the tables.inaddition, the primary table required seven
other columns, such as version_editable, version_deleted, etc.
C.
You need to add asset_version to both the tables.inaddition, the auxiliary table requires seven
other columns, such as version_editable, version_deleted, etc.
D.
You need to add asset_version and seven other columns, such as version_editable, version
deleted to both the tables.
E.
You need to add asset, version to the primary table and seven columns, such
asversion_editable,version deleted, etc. to the auxiliary tables.
F.
You need to add seven columns, such as version_editable, version deleted, etc. to the primary
table and only asset_version to the auxiliary table.
Explanation:
Create and Install the Versioned Database Schema
In order to store asset version metadata, the asset management server’s database schema
requires additional columns for the primary tables used by your application’s repositories, and
additional tables to store versioning information.
Create the Versioned Schema
To modify the asset management server’s database schema to store versioning data, follow these
steps:
1. Copy each database DDL file that you plan to modify.
2. Add the following columns to every table that represents a primary table for an item descriptor:
asset_version INT NOT NULL
workspace_id VARCHAR(40) NOT NULL
branch_id VARCHAR(40) NOT NULL
is_head NUMERIC(1) NOT NULL
version_deleted NUMERIC(1) NOT NULL
version_editable NUMERIC(1) NOT NULL
pred_version INT NULL
checkin_date TIMESTAMP NULL
3.Add the following column to every table that represents an auxiliary or multi table in an item
descriptor:
asset_version INT NOT NULL
ATG Content Administration Programming Guide, Create and Install the Versioned
Database Schema