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

Typos in create database postgresql script

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: EJBCA 6.15.2.1
    • Fix Version/s: EJBCA 7.2.0
    • Component/s: None
    • Labels:
      None
    • Environment:
      ejbca: 6.15.2.1
    • Issue discovered during:
      Community

      Description

      File: ejbca/doc/sql-scripts/create-tables-ejbca-postgres.sql

       

      Error in TEXT BINARY -> BYTEA and INT(8) -> BIGINT:

      CREATE TABLE AcmeNonceData (
          nonce BYTEA NOT NULL,
          timeExpires BIGINT NOT NULL,
          rowProtection TEXT,
          rowVersion INT4 NOT NULL,
          PRIMARY KEY (nonce)
      );
      
      
      CREATE TABLE AcmeAccountData (
          accountId BYTEA NOT NULL,
          currentKeyId BYTEA NOT NULL,
          rawData TEXT,
          rowProtection TEXT,
          rowVersion INT4 NOT NULL,
          PRIMARY KEY (accountId)
      );
      
      
      CREATE TABLE AcmeOrderData (
          orderId BYTEA NOT NULL,
          accountId BYTEA NOT NULL,
          fingerprint BYTEA,
          status BYTEA NOT NULL,
          rawData TEXT,
          rowProtection TEXT,
          rowVersion INT4 NOT NULL,
          PRIMARY KEY (orderId)
      );
      
      
      CREATE TABLE AcmeChallengeData (
          challengeId BYTEA NOT NULL,
          authorizationId BYTEA NOT NULL,
          type BYTEA NOT NULL,
          rawData TEXT,
          rowProtection TEXT,
          rowVersion INT4 NOT NULL,
          PRIMARY KEY (challengeId)
      );
      
      
      CREATE TABLE AcmeAuthorizationData (
          authorizationId BYTEA NOT NULL,
          orderId BYTEA,
          accountId BYTEA NOT NULL,
          rawData TEXT,
          rowProtection TEXT,
          rowVersion INT4 NOT NULL,
          PRIMARY KEY (authorizationId)
      );
      
      
      alter table AccessRulesData add constraint FKABB4C1DFDBBC970 foreign key (AdminGroupData_accessRules) references AdminGroupData;
      
      
      alter table AdminEntityData add constraint FKD9A99EBCB3A110AD foreign key (AdminGroupData_adminEntities) references AdminGroupData;
      

        Attachments

          Activity

            People

            Assignee:
            tomas Tomas Gustavsson
            Reporter:
            shizacat Alexey
            Verified by:
            Samuel Lidén Borell
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 15 minutes Original Estimate - 15 minutes
                15m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 30 minutes
                30m