Details
-
Improvement
-
Resolution: Obsolete
-
Medium
-
None
-
4.0.7, 4.1.4, 4.2.0, extension/ezoracle 1.8.2, extension/ezoracle 2.0.2
-
None
Description
The current db schema structure is probably insufficient to detect some error conditions that could lead to unpredictable results - at least when oracle db is in use:
- there is no field indicating whether a trigger is enabled or not
a disabled trigger is a clear no-go situation; currently we could flag this as a non-existent trigger, but eZP will ask us to recreate it instead of asking us to activate it
- there is no field indicating whether some extra triggers are defined on an ezp table, the way that extra cols or extra indexes are