Legacy DB Views generator

Recreate database Views as they were before iTop 2.7.0.
Starting from iTop 3.0.0, there is no more Views out-of-the-box, this extension brings them back.

• On iTop 3.0.0 and above, this extension creates at Setup one View per class of the Datamodel. The views are identical to those build before iTop 2.7.
• On iTop 2.7.0 to 2.7.3 included, this extension restores the Views as they were before iTop 2.7 the out-of-the-box views have some columns badly named
• On other version, this extension is useless

Use the Standard installation process as for most extensions.

• Views are not performant for tables above 30 000 entries, because they are generic, join every External Key and do this recursively.
• If you are facing the above performance issue, create you own views, more specific, doing just the required joins.

What this extension does at every Setup, Move To Production and Move To test:

• Delete and rebuild the views according to the latest Datamodel

This is the way iTop Views should look like for the class Person

This is the way views look like with an iTop 2.7.0 to 2.7.3 included:

The column names on Blob are different: