Database Schema Archive
This topic is only intended as a reference to legacy versions of CM4D, in case you are upgrading from a very old version. For more recent versions, see the topic Database Schema Reference.
The following tables provides a cross-reference of outdated CM4D versions and each database Schema. 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 |
|
CM4D Version |
Site Schema |
Update Site Script |
CM4D Schema |
Update CM4D Script |
|
|
v10.610 |
10 |
SITE UPDATE 10.sql |
17 |
UPDATE 17.SQL |
|
|
v10.700 |
11 or 20 |
SITE UPDATE 20 FROM 10.SQL |
18 |
UPDATE 18.SQL |
|
|
v10.705 |
20 |
19 |
UPDATE 19.SQL |
||
|
v10.720* |
12 |
SQL SITE UPDATE 20.sql ORA SITE UPDATE 12.sql |
19 |
||
|
v10.750 |
21 |
25 | UPDATE 25.SQL | ||
|
v10.761 |
21 |
SQL |
SITE UPDATE 21.SQL |
25 |
|
|
ORA |
SITE UPDATE 21.SQL SITE UPDATE 21 FROM 12.sql |
||||
|
v10.795 |
21 |
26 |
UPDATE 26.SQL |
||
|
v10.810 |
21 |
27 |
UPDATE 27.SQL |
||
|
v10.825 |
22 |
SITE UPDATE 22.SQL |
27 |
||
|
v10.861 |
23 |
SITE UPDATE 23.SQL |
28 |
UPDATE 28.SQL |
|
|
v10.900 |
24 |
SITE UPDATE 24.sql |
29 |
UPDATE 29.SQL |
|
|
v10.910 |
25 |
SITE UPDATE 25.sql |
30 |
UPDATE 30.SQL |
|
|
v10.952 |
26 |
UpdateSite26.sql |
31 |
Update31.sql |
|
|
v10.977 |
27 |
UpdateSite27.sql |
31 |
||
|
v11.1.1 |
28 |
UpdateSite28.sql |
32 |
Update32.sql |
|
|
v11.2.1 |
28 |
33 |
Update33.sql |
||
|
v11.3.1 |
29 |
UpdateSite29.sql |
34 |
Update34.sql |
|
|
v11.3.3 |
30 |
UpdateSite30.sql |
34 |
||
|
v11.3.4 |
30 |
35 |
Update35.sql |
||
|
v11.4.1 |
31 |
UpdateSite31.sql |
36 |
Update36.sql |
|
Can we improve this topic?