Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-43372

SQL Scripts liferay-portal-sql-6.1.2-ce-ga3 are missing tables for WSRP

    Details

      Description

      The SQL Scripts provided in liferay-portal-sql-6.1.2-ce-ga3.zip
      are missing the tables for WSRP.
      After successful deployment of the WSRP Porlet the creating
      of producers or consumers did not work because of database errors.

      After adding the following contentent in the liferay6.1.2_create-minimal-uniqa-postgresql.sql, the WSRP Portlet works.

      CREATE TABLE WSRP_WSRPCONSUMER
      (
      UUID_ VARCHAR(75),
      WSRPCONSUMERID BIGINT not null PRIMARY KEY,
      COMPANYID BIGINT,
      CREATEDATE TIMESTAMP null,
      MODIFIEDDATE TIMESTAMP null,
      NAME VARCHAR(75),
      URL text null,
      WSDL text null,
      REGISTRATIONCONTEXTSTRING text null,
      REGISTRATIONPROPERTIESSTRING text null,
      FORWARDCOOKIES VARCHAR(255),
      FORWARDHEADERS VARCHAR(255),
      MARKUPCHARACTERSETS VARCHAR(255)
      );

      CREATE INDEX IX_8F3348D ON WSRP_WSRPCONSUMER (COMPANYID ASC);
      CREATE INDEX IX_8B675499 ON WSRP_WSRPCONSUMER(UUID_);

      CREATE TABLE WSRP_WSRPCONSUMERPORTLET
      (
      UUID_ VARCHAR(75),
      WSRPCONSUMERPORTLETID BIGINT NOT NULL PRIMARY KEY,
      COMPANYID BIGINT,
      CREATEDATE TIMESTAMP null,
      MODIFIEDDATE TIMESTAMP null,
      WSRPCONSUMERID BIGINT,
      NAME VARCHAR(75),
      PORTLETHANDLE text null
      );

      CREATE INDEX IX_82D5F2C9 ON WSRP_WSRPCONSUMERPORTLET(UUID_);
      CREATE INDEX IX_1CEEF2AA ON WSRP_WSRPCONSUMERPORTLET(WSRPCONSUMERID);
      CREATE INDEX IX_D5F95908 ON WSRP_WSRPCONSUMERPORTLET(WSRPCONSUMERID,PORTLETHANDLE);

      CREATE TABLE WSRP_WSRPPRODUCER
      (
      UUID_ VARCHAR(75),
      WSRPPRODUCERID BIGINT NOT NULL PRIMARY KEY,
      GROUPID BIGINT,
      COMPANYID BIGINT,
      CREATEDATE TIMESTAMP null,
      MODIFIEDDATE TIMESTAMP null,
      NAME VARCHAR(75),
      VERSION VARCHAR(75),
      PORTLETIDS text null
      );

      CREATE INDEX IX_DD08A671 ON WSRP_WSRPPRODUCER(COMPANYID);
      CREATE INDEX IX_19A9587D ON WSRP_WSRPPRODUCER(UUID_);
      CREATE UNIQUE INDEX IX_DDBB58CD ON WSRP_WSRPPRODUCER(UUID_,GROUPID);

        Attachments

          Activity

            People

            • Assignee:
              mika.koivisto Mika Koivisto
              Reporter:
              gerhard.karl@gmx.at Gerhard Karl (Inactive)
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 40 weeks, 1 day ago

                Packages

                Version Package
                6.1.2 CE GA3