Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-1908

Harmonize column data type in sql scripts

XMLWordPrintable

      change VARCHAR to UTF8 compatible type --> NVARCHAR2

      create table ACT_RE_PROCDEF (
      ID_ NVARCHAR2(64) NOT NULL,
      REV_ INTEGER,
      CATEGORY_ NVARCHAR2(255),
      NAME_ NVARCHAR2(255),
      KEY_ NVARCHAR2(255) NOT NULL,
      VERSION_ INTEGER NOT NULL,
      DEPLOYMENT_ID_ NVARCHAR2(64),
      RESOURCE_NAME_ NVARCHAR2(2000),
      DGRM_RESOURCE_NAME_ varchar(4000),
      HAS_START_FORM_KEY_ NUMBER(1,0) CHECK (HAS_START_FORM_KEY_ IN (1,0)),
      SUSPENSION_STATE_ INTEGER,
      primary key (ID_)
      );

      create table ACT_RU_AUTHORIZATION (
      ID_ varchar(64) not null,
      REV_ integer not null,
      TYPE_ integer not null,
      GROUP_ID_ varchar(255),
      USER_ID_ varchar(255),
      RESOURCE_TYPE_ integer not null,
      RESOURCE_ID_ varchar(64),
      PERMS_ integer,
      primary key (ID_)
      );

        This is the controller panel for Smart Panels app

              smirnov Roman Smirnov
              michael.schoettes Michael Schoettes
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: