Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-2514

Implement SQL storage backend

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.1.6
    • Component/s: Core VCS
    • Impact type:
      Content model Change
    • Upgrade notes:
      Hide

      Some development versions had a column hierarchy.parent instead of the now current hierarchy.parentid.
      To migrate such databases:
      ALTER TABLE hierarchy DROP CONSTRAINT hierarchy_parent_hierarchy_fk;
      DROP INDEX hierarchy_parent_idx;
      DROP INDEX hierarchy_parent_name_idx;
      Then for PostgreSQL:
      ALTER TABLE hierarchy RENAME COLUMN parent TO parentid;
      Or for Derby (10.4):
      RENAME COLUMN hierarchy.parent TO parentid;
      Then for all databases:
      ALTER TABLE hierarchy ADD CONSTRAINT hierarchy_parentid_hierarchy_fk FOREIGN KEY (parentid) REFERENCES hierarchy ON DELETE CASCADE;
      CREATE INDEX hierarchy_parentid_idx ON hierarchy (parentid);
      CREATE INDEX hierarchy_parentid_name_idx ON hierarchy (parentid, name);

      Show
      Some development versions had a column hierarchy.parent instead of the now current hierarchy.parentid. To migrate such databases: ALTER TABLE hierarchy DROP CONSTRAINT hierarchy_parent_hierarchy_fk; DROP INDEX hierarchy_parent_idx; DROP INDEX hierarchy_parent_name_idx; Then for PostgreSQL: ALTER TABLE hierarchy RENAME COLUMN parent TO parentid; Or for Derby (10.4): RENAME COLUMN hierarchy.parent TO parentid; Then for all databases: ALTER TABLE hierarchy ADD CONSTRAINT hierarchy_parentid_hierarchy_fk FOREIGN KEY (parentid) REFERENCES hierarchy ON DELETE CASCADE; CREATE INDEX hierarchy_parentid_idx ON hierarchy (parentid); CREATE INDEX hierarchy_parentid_name_idx ON hierarchy (parentid, name);

      Description

      Implement a storage backend based on SQL tables.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: