Versions Compared

Old Version 6

changes.mady.by.user Francesco Chicchiriccò

Saved on

compared with

New Version 7

changes.mady.by.user Francesco Chicchiriccò

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. /
    for the root realm, e.g. the only row where the parent column has NULL value
  2. {parent row's fullPath value}/{current row's name value}
    for any other row

For example:

idnameparentfullPath

8915e471-9683-4356-8c92-d2a6e1993de5

/NULL/

345f0a30-5a32-442c-bd7f-c1bbcdedf293

child18915e471-9683-4356-8c92-d2a6e1993de5/child1

d419af73-fe15-4774-95be-131b6b1f1044

child28915e471-9683-4356-8c92-d2a6e1993de5/child2

28807a32-1314-4a85-8fe2-0d59a1a05479

nephew18915e471-9683-4356-8c92-d2a6e1993de5/child1/nephew1

Cleanup

Code Block
languagesql
DROP TABLE ReportReportlet;
-- this statement might be needed and adjusted to the effective constraint name
ALTER TABLE Report DROP CONSTRAINT Report_ibfk_1;
ALTER TABLE Report DROP COLUMN template_id;
DROP TABLE ReportTemplate;

Indexes

New indexes shall be created to improve overall performance.

...