---\r
--- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)\r
---\r
--- Licensed under the Apache License, Version 2.0 (the "License");\r
--- you may not use this file except in compliance with the License.\r
--- You may obtain a copy of the License at\r
---\r
--- http://www.apache.org/licenses/LICENSE-2.0\r
---\r
--- Unless required by applicable law or agreed to in writing, software\r
--- distributed under the License is distributed on an "AS IS" BASIS,\r
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\r
--- See the License for the specific language governing permissions and\r
--- limitations under the License.\r
---\r
-\r
-create table ACT_ID_GROUP (\r
- ID_ varchar(64),\r
- REV_ integer,\r
- NAME_ varchar(255),\r
- TYPE_ varchar(255),\r
- primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_MEMBERSHIP (\r
- USER_ID_ varchar(64),\r
- GROUP_ID_ varchar(64),\r
- primary key (USER_ID_, GROUP_ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_USER (\r
- ID_ varchar(64),\r
- REV_ integer,\r
- FIRST_ varchar(255),\r
- LAST_ varchar(255),\r
- EMAIL_ varchar(255),\r
- PWD_ varchar(255),\r
- SALT_ varchar(255),\r
- LOCK_EXP_TIME_ timestamp NULL,\r
- ATTEMPTS_ integer,\r
- PICTURE_ID_ varchar(64),\r
- primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_INFO (\r
- ID_ varchar(64),\r
- REV_ integer,\r
- USER_ID_ varchar(64),\r
- TYPE_ varchar(64),\r
- KEY_ varchar(255),\r
- VALUE_ varchar(255),\r
- PASSWORD_ LONGBLOB,\r
- PARENT_ID_ varchar(255),\r
- primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_TENANT (\r
- ID_ varchar(64),\r
- REV_ integer,\r
- NAME_ varchar(255),\r
- primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-create table ACT_ID_TENANT_MEMBER (\r
- ID_ varchar(64) not null,\r
- TENANT_ID_ varchar(64) not null,\r
- USER_ID_ varchar(64),\r
- GROUP_ID_ varchar(64),\r
- primary key (ID_)\r
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;\r
-\r
-alter table ACT_ID_MEMBERSHIP\r
- add constraint ACT_FK_MEMB_GROUP\r
- foreign key (GROUP_ID_)\r
- references ACT_ID_GROUP (ID_);\r
-\r
-alter table ACT_ID_MEMBERSHIP\r
- add constraint ACT_FK_MEMB_USER\r
- foreign key (USER_ID_)\r
- references ACT_ID_USER (ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
- add constraint ACT_UNIQ_TENANT_MEMB_USER\r
- unique (TENANT_ID_, USER_ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
- add constraint ACT_UNIQ_TENANT_MEMB_GROUP\r
- unique (TENANT_ID_, GROUP_ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
- add constraint ACT_FK_TENANT_MEMB\r
- foreign key (TENANT_ID_)\r
- references ACT_ID_TENANT (ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
- add constraint ACT_FK_TENANT_MEMB_USER\r
- foreign key (USER_ID_)\r
- references ACT_ID_USER (ID_);\r
-\r
-alter table ACT_ID_TENANT_MEMBER\r
- add constraint ACT_FK_TENANT_MEMB_GROUP\r
- foreign key (GROUP_ID_)\r
- references ACT_ID_GROUP (ID_);\r
+--
+-- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
+--
+-- Licensed under the Apache License, Version 2.0 (the "License");
+-- you may not use this file except in compliance with the License.
+-- You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+--
+
+create table ACT_ID_GROUP (
+ ID_ varchar(64),
+ REV_ integer,
+ NAME_ varchar(255),
+ TYPE_ varchar(255),
+ primary key (ID_)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
+
+create table ACT_ID_MEMBERSHIP (
+ USER_ID_ varchar(64),
+ GROUP_ID_ varchar(64),
+ primary key (USER_ID_, GROUP_ID_)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
+
+create table ACT_ID_USER (
+ ID_ varchar(64),
+ REV_ integer,
+ FIRST_ varchar(255),
+ LAST_ varchar(255),
+ EMAIL_ varchar(255),
+ PWD_ varchar(255),
+ SALT_ varchar(255),
+ LOCK_EXP_TIME_ timestamp NULL,
+ ATTEMPTS_ integer,
+ PICTURE_ID_ varchar(64),
+ primary key (ID_)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
+
+create table ACT_ID_INFO (
+ ID_ varchar(64),
+ REV_ integer,
+ USER_ID_ varchar(64),
+ TYPE_ varchar(64),
+ KEY_ varchar(255),
+ VALUE_ varchar(255),
+ PASSWORD_ LONGBLOB,
+ PARENT_ID_ varchar(255),
+ primary key (ID_)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
+
+create table ACT_ID_TENANT (
+ ID_ varchar(64),
+ REV_ integer,
+ NAME_ varchar(255),
+ primary key (ID_)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
+
+create table ACT_ID_TENANT_MEMBER (
+ ID_ varchar(64) not null,
+ TENANT_ID_ varchar(64) not null,
+ USER_ID_ varchar(64),
+ GROUP_ID_ varchar(64),
+ primary key (ID_)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
+
+alter table ACT_ID_MEMBERSHIP
+ add constraint ACT_FK_MEMB_GROUP
+ foreign key (GROUP_ID_)
+ references ACT_ID_GROUP (ID_);
+
+alter table ACT_ID_MEMBERSHIP
+ add constraint ACT_FK_MEMB_USER
+ foreign key (USER_ID_)
+ references ACT_ID_USER (ID_);
+
+alter table ACT_ID_TENANT_MEMBER
+ add constraint ACT_UNIQ_TENANT_MEMB_USER
+ unique (TENANT_ID_, USER_ID_);
+
+alter table ACT_ID_TENANT_MEMBER
+ add constraint ACT_UNIQ_TENANT_MEMB_GROUP
+ unique (TENANT_ID_, GROUP_ID_);
+
+alter table ACT_ID_TENANT_MEMBER
+ add constraint ACT_FK_TENANT_MEMB
+ foreign key (TENANT_ID_)
+ references ACT_ID_TENANT (ID_);
+
+alter table ACT_ID_TENANT_MEMBER
+ add constraint ACT_FK_TENANT_MEMB_USER
+ foreign key (USER_ID_)
+ references ACT_ID_USER (ID_);
+
+alter table ACT_ID_TENANT_MEMBER
+ add constraint ACT_FK_TENANT_MEMB_GROUP
+ foreign key (GROUP_ID_)
+ references ACT_ID_GROUP (ID_);