Details
-
Type:
Bug
-
Status: Awaiting Review
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 11.0, 12.0
-
Fix Version/s: None
-
Component/s: Reference
-
Labels:None
Description
The Oracle 11 conversion script has a table that cannot be created (SST_PRESENCE_TOTALS) because the unique constraint has incorrect syntax. From SAK-29600.
Instead of
UNIQUE KEY(SITE_ID, USER_ID),
I think it should look like
CONSTRAINT unique_sst_presence_totals UNIQUE(SITE_ID, USER_ID),