Database Schema Reference

Run UpdateSite13a.sql to get to schema 13a. Continue to next update.

Run UpdateSite14a.sql to get to schema 14a. Continue to next update.

Run UpdateSite15a.sql to get to schema 15a. Continue to next update.

Run UpdateSite16a.sql to get to schema 16a. Continue to next update.

Run UpdateSite17a.sql to get to schema 17a. Continue to next update.

Run UpdateSite18a.sql to get to schema 18a. Continue to next update.

Run UpdateSite19a.sql to get to schema 19a. Continue to next update.

Run UpdateSite20a.sql to get to schema 20a. Continue to next update.

Run UpdateSite20b.sql to get to schema 20b. Continue to next update.

Run UpdateSite21a.sql to get to schema 21a.

Run UpdateSite21b.sql to get to schema 21b.

Run UpdateSite22a.sql to get to schema 22a.

You are done if you are running a SQL Database using Windows Authentication or an Oracle Database.

If you are using a SQL Database with SQL Authentication, also run Site Grant.sql to apply the correct privileges.

CM4D Database Upgrade Path

Run Update13a.sql to get to schema 13a. Continue to next update.

Run Update13b.sql to get to schema 13b. Continue to next update.

Run Update14a.sql to get to schema 14a. Continue to next update.

Run Update15a.sql to get to schema 15a. Continue to next update.

Run Update16a.sql to get to schema 16a. Continue to next update.

Run Update17a.sql to get to schema 17a. Continue to next update.

Run Update18a.sql to get to schema 18a. Continue to next update.

Run Update19a.sql to get to schema 19a. Continue to next update.

Run Update20a.sql to get to schema 20a. Continue to next update.

Run Update20b.sql to get to schema 20b. Continue to next update.

Run Update21a.sql to get to schema 21a.

Run Update22a.sql to get to schema 22a.

You are done if you are running a SQL Database using Windows Authentication or an Oracle Database.

If you are using a SQL Database with SQL Authentication, also run Grant.sql to apply the correct privileges.

CM4D Versions and Schemas

The following table provides a cross-reference of the CM4D versions in which each database Schema was introduced. The scripts listed apply for both Oracle and SQL Server (unless otherwise indicated).

CM4D Version	Site Schema	Update Site Script	CM4D Schema	Update CM4D Script
v12.1	12a	UpdateSite12a.sql	12a	Update12a.sql
v13.1	13a	UpdateSite13a.sql	13a	Update13a.sql
v13.2	13a		13b	Update13b.sql
v14.1	14a	UpdateSite14a.sql	14a	Update14a.sql
v15.1	15a	UpdateSite15a.sql	15a	Update15a.sql
v16.1	16a	UpdateSite16a.sql	16a	Update16a.sql
v17.1	17a	UpdateSite17a.sql	17a	Update17a.sql
v18.1*	18a	UpdateSite18a.sql	18a	Update18a.sql
v19.1	19a	UpdateSite19a.sql	19a	Update19a.sql
v20.0	20a	UpdateSite20a.sql	20a	Update20a.sql
v20.1	20a		20b	Update20b.sql
v20.3	20b	UpdateSite20b.sql	20b
v20.4	20b		20b
v20.5*	20b		20b
v21.0	21a	UpdateSite21a.sql	21a	Update21a.sql
v21.1	21b	UpdateSite21b.sql	21a
v22.0	22a	UpdateSite22a.sql	22a	Update22a.sql