Uploaded image for project: 'EJBCA'
  1. EJBCA
  2. ECA-8131

Create DB update scripts and ORM files for new SCT table

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: EJBCA 7.2.0
    • Component/s: None
    • Labels:

      Description

      Create DB update scripts and ORM files for new SCT cache table. (Maybe not use 'cache' in a table name?)

      The database structure should basically be:

      • [string] pk (from GUID)
      • [b64 string] certificate fingerprint
      • [int] log id (mainly if we want to remove one log)
      • [long] certificate expiration date (for cleaning up SCTs for expired certs)
      • [b64 string] sct data (base64 encode the value into a clob)

      primary key: pk
      index: certificate fingerprint

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ulf_undmark Ulf Undmark
              Reporter:
              samuel Samuel Lidén Borell
              Verified by:
              Bastian Fredriksson
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2 days Original Estimate - 2 days
                  2d
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 1 hour
                  2d 1h