Uploaded image for project: 'eXo-JCR'
  1. eXo-JCR
  2. EXOJCR-606

Remove ID column from JCR_xVALUE table

    Details

      Description

      ID column in JCR_xVALUE table used historically and has no actual sense.
      But for this column we're using additional database options such as sequence and trigger on Oracle, or identity on many others database.

      A new table script can be (Oracle dialect, single-db):
      CREATE TABLE JCR_SVALUE(
      PROPERTY_ID VARCHAR(96) NOT NULL,
      ORDER_NUM INTEGER NOT NULL,
      DATA BLOB,
      STORAGE_DESC VARCHAR(512),
      CONSTRAINT JCR_PK_SVALUE PRIMARY KEY(PROPERTY_ID, ORDER_NUM),
      CONSTRAINT JCR_FK_SVALUE_PROPERTY FOREIGN KEY(PROPERTY_ID) REFERENCES JCR_SITEM(ID)
      )

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  pnedonosko Peter Nedonosko
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - 1 day, 4 hours Original Estimate - 1 day, 4 hours
                    1d 4h
                    Remaining:
                    Time Spent - 1 day, 5 hours Remaining Estimate - 3 days, 7 hours
                    3d 7h
                    Logged:
                    Time Spent - 1 day, 5 hours Remaining Estimate - 3 days, 7 hours
                    1d 5h