<commit_before>create table ACT_PROPERTY (
    NAME_ varchar(300),
    VALUE_ varchar(300),
    REV_ integer,
    primary key (NAME_)
);

insert into ACT_PROPERTY
values ('schema.version', '5.0.alpha4-SNAPSHOT', 1);

insert into ACT_PROPERTY
values ('next.dbid', '1', 1);

create table ACT_BYTEARRAY (
    ID_ varchar(255),
    REV_ integer,
    NAME_ varchar(255),
    DEPLOYMENT_ID_ varchar(255),
    BYTES_ LONGBLOB,
    primary key (ID_)
);

create table ACT_DEPLOYMENT (
    ID_ varchar(255),
    NAME_ varchar(255),
    DEPLOY_TIME_ timestamp,
    primary key (ID_)
);

create table ACT_EXECUTION (
    ID_ varchar(255),
    REV_ integer,
    PROC_INST_ID_ varchar(255),
    PARENT_ID_ varchar(255),
    PROC_DEF_ID_ varchar(255),
    SUPER_EXEC_ varchar(255),
    ACTIVITY_ID_ varchar(255),
    IS_ACTIVE_ TINYINT,
    IS_CONCURRENT_ TINYINT,
    IS_SCOPE_ TINYINT,
    primary key (ID_)
);

create table ACT_JOB (
    ID_ varchar(255) NOT NULL,
    TYPE_ varchar(255) NOT NULL,
    LOCK_EXP_TIME_ timestamp,
    LOCK_OWNER_ varchar(255),
    EXCLUSIVE_ boolean,
    EXECUTION_ID_ varchar(255),
    PROCESS_INSTANCE_ID_ varchar(255),
    RETRIES_ integer,
    EXCEPTION_ varchar(255),
    DUEDATE_ timestamp NULL,
    REPEAT_ varchar(255),
    HANDLER_TYPE_ varchar(255),
    HANDLER_CFG_ varchar(255),
    primary key (ID_)
);

create table ACT_ID_GROUP (
    ID_ varchar(255),
    REV_ integer,
    NAME_ varchar(255),
    TYPE_ varchar(255),
    primary key (ID_)
);

create table ACT_ID_MEMBERSHIP (
    USER_ID_ varchar(255),
    GROUP_ID_ varchar(255),
    primary key (USER_ID_, GROUP_ID_)
);

create table ACT_ID_USER (
    ID_ varchar(255),
    REV_ integer,
    FIRST_ varchar(255),
    LAST_ varchar(255),
    EMAIL_ varchar(255),
    PWD_ varchar(255),
    primary key (ID_)
);

create table ACT_PROCESSDEFINITION (
    ID_ varchar(255),
    NAME_ varchar(255),
    KEY_ varchar(255),
    VERSION_ integer,
    DEPLOYMENT_ID_ varchar(255),
    primary key (ID_)
);

create table ACT_TASK (
    ID_ varchar(255),
    REV_ integer,
    NAME_ varchar(255),
    DESCRIPTION_ varchar(255),
    ASSIGNEE_ varchar(255),
    PRIORITY_ integer,
    EXECUTION_ID_ varchar(255),
    PROC_INST_ID_ varchar(255),
    PROC_DEF_ID_ varchar(255),
    CREATE_TIME_ timestamp,
    START_DEADLINE_ timestamp,
    COMPLETION_DEADLINE_ timestamp,
    SKIPPABLE_ TINYINT,
    primary key (ID_)
);

create table ACT_TASKINVOLVEMENT (
    ID_ varchar(255),
    REV_ integer,
    GROUP_ID_ varchar(255),
    TYPE_ varchar(255),
    USER_ID_ varchar(255),
    TASK_ID_ varchar(255),
    primary key (ID_)
);

create table ACT_VARIABLE (
    ID_ varchar(300) not null,
    REV_ integer,
    TYPE_ varchar(255) not null,
    NAME_ varchar(255) not null,
    EXECUTION_ID_ varchar(255),
    TASK_ID_ varchar(255),
    BYTEARRAY_ID_ varchar(255),
    DATE_ timestamp,
    DOUBLE_ double,
    LONG_ bigint,
    TEXT_ varchar(255),
    primary key (ID_)
);


alter table ACT_BYTEARRAY 
    add constraint FK_BYTEARR_DEPL 
    foreign key (DEPLOYMENT_ID_) 
    references ACT_DEPLOYMENT (ID_);

alter table ACT_EXECUTION
    add constraint FK_EXE_PROCINST 
    foreign key (PROC_INST_ID_) 
    references ACT_EXECUTION (ID_)
    on delete cascade
    on update cascade;

alter table ACT_EXECUTION
    add constraint FK_EXE_PARENT 
    foreign key (PARENT_ID_) 
    references ACT_EXECUTION (ID_);
    
alter table ACT_EXECUTION
    add constraint FK_EXE_SUPER 
    foreign key (SUPER_EXEC_) 
    references ACT_EXECUTION;
    
alter table ACT_ID_MEMBERSHIP 
    add constraint FK_MEMB_GROUP 
    foreign key (GROUP_ID_) 
    references ACT_ID_GROUP (ID_);

alter table ACT_ID_MEMBERSHIP 
    add constraint FK_MEMB_USER 
    foreign key (USER_ID_) 
    references ACT_ID_USER (ID_);

alter table ACT_TASKINVOLVEMENT
    add constraint FK_TSKASS_TASK 
    foreign key (TASK_ID_) 
    references ACT_TASK (ID_);
    
alter table ACT_TASK
    add constraint FK_TASK_EXEC
    foreign key (EXECUTION_ID_)
    references ACT_EXECUTION (ID_);
    
alter table ACT_TASK
    add constraint FK_TASK_PROCINST
    foreign key (PROC_INST_ID_)
    references ACT_EXECUTION (ID_);
    
alter table ACT_TASK
  add constraint FK_TASK_PROCDEF
  foreign key (PROC_DEF_ID_)
  references ACT_PROCESSDEFINITION (ID_);
  
alter table ACT_VARIABLE 
    add constraint FK_VAR_TASK 
    foreign key (TASK_ID_) 
    references ACT_TASK (ID_);

alter table ACT_VARIABLE 
    add constraint FK_VAR_EXE 
    foreign key (EXECUTION_ID_) 
    references ACT_EXECUTION (ID_);

alter table ACT_VARIABLE 
    add constraint FK_VAR_BYTEARRAY 
    foreign key (BYTEARRAY_ID_) 
    references ACT_BYTEARRAY (ID_);<commit_msg>fixed FK_EXE_SUPER for mysql<commit_after>create table ACT_PROPERTY (
    NAME_ varchar(300),
    VALUE_ varchar(300),
    REV_ integer,
    primary key (NAME_)
);

insert into ACT_PROPERTY
values ('schema.version', '5.0.alpha4-SNAPSHOT', 1);

insert into ACT_PROPERTY
values ('next.dbid', '1', 1);

create table ACT_BYTEARRAY (
    ID_ varchar(255),
    REV_ integer,
    NAME_ varchar(255),
    DEPLOYMENT_ID_ varchar(255),
    BYTES_ LONGBLOB,
    primary key (ID_)
);

create table ACT_DEPLOYMENT (
    ID_ varchar(255),
    NAME_ varchar(255),
    DEPLOY_TIME_ timestamp,
    primary key (ID_)
);

create table ACT_EXECUTION (
    ID_ varchar(255),
    REV_ integer,
    PROC_INST_ID_ varchar(255),
    PARENT_ID_ varchar(255),
    PROC_DEF_ID_ varchar(255),
    SUPER_EXEC_ varchar(255),
    ACTIVITY_ID_ varchar(255),
    IS_ACTIVE_ TINYINT,
    IS_CONCURRENT_ TINYINT,
    IS_SCOPE_ TINYINT,
    primary key (ID_)
);

create table ACT_JOB (
    ID_ varchar(255) NOT NULL,
    TYPE_ varchar(255) NOT NULL,
    LOCK_EXP_TIME_ timestamp,
    LOCK_OWNER_ varchar(255),
    EXCLUSIVE_ boolean,
    EXECUTION_ID_ varchar(255),
    PROCESS_INSTANCE_ID_ varchar(255),
    RETRIES_ integer,
    EXCEPTION_ varchar(255),
    DUEDATE_ timestamp NULL,
    REPEAT_ varchar(255),
    HANDLER_TYPE_ varchar(255),
    HANDLER_CFG_ varchar(255),
    primary key (ID_)
);

create table ACT_ID_GROUP (
    ID_ varchar(255),
    REV_ integer,
    NAME_ varchar(255),
    TYPE_ varchar(255),
    primary key (ID_)
);

create table ACT_ID_MEMBERSHIP (
    USER_ID_ varchar(255),
    GROUP_ID_ varchar(255),
    primary key (USER_ID_, GROUP_ID_)
);

create table ACT_ID_USER (
    ID_ varchar(255),
    REV_ integer,
    FIRST_ varchar(255),
    LAST_ varchar(255),
    EMAIL_ varchar(255),
    PWD_ varchar(255),
    primary key (ID_)
);

create table ACT_PROCESSDEFINITION (
    ID_ varchar(255),
    NAME_ varchar(255),
    KEY_ varchar(255),
    VERSION_ integer,
    DEPLOYMENT_ID_ varchar(255),
    primary key (ID_)
);

create table ACT_TASK (
    ID_ varchar(255),
    REV_ integer,
    NAME_ varchar(255),
    DESCRIPTION_ varchar(255),
    ASSIGNEE_ varchar(255),
    PRIORITY_ integer,
    EXECUTION_ID_ varchar(255),
    PROC_INST_ID_ varchar(255),
    PROC_DEF_ID_ varchar(255),
    CREATE_TIME_ timestamp,
    START_DEADLINE_ timestamp,
    COMPLETION_DEADLINE_ timestamp,
    SKIPPABLE_ TINYINT,
    primary key (ID_)
);

create table ACT_TASKINVOLVEMENT (
    ID_ varchar(255),
    REV_ integer,
    GROUP_ID_ varchar(255),
    TYPE_ varchar(255),
    USER_ID_ varchar(255),
    TASK_ID_ varchar(255),
    primary key (ID_)
);

create table ACT_VARIABLE (
    ID_ varchar(300) not null,
    REV_ integer,
    TYPE_ varchar(255) not null,
    NAME_ varchar(255) not null,
    EXECUTION_ID_ varchar(255),
    TASK_ID_ varchar(255),
    BYTEARRAY_ID_ varchar(255),
    DATE_ timestamp,
    DOUBLE_ double,
    LONG_ bigint,
    TEXT_ varchar(255),
    primary key (ID_)
);


alter table ACT_BYTEARRAY 
    add constraint FK_BYTEARR_DEPL 
    foreign key (DEPLOYMENT_ID_) 
    references ACT_DEPLOYMENT (ID_);

alter table ACT_EXECUTION
    add constraint FK_EXE_PROCINST 
    foreign key (PROC_INST_ID_) 
    references ACT_EXECUTION (ID_)
    on delete cascade
    on update cascade;

alter table ACT_EXECUTION
    add constraint FK_EXE_PARENT 
    foreign key (PARENT_ID_) 
    references ACT_EXECUTION (ID_);
    
alter table ACT_EXECUTION
    add constraint FK_EXE_SUPER 
    foreign key (SUPER_EXEC_) 
    references ACT_EXECUTION (ID_);
    
alter table ACT_ID_MEMBERSHIP 
    add constraint FK_MEMB_GROUP 
    foreign key (GROUP_ID_) 
    references ACT_ID_GROUP (ID_);

alter table ACT_ID_MEMBERSHIP 
    add constraint FK_MEMB_USER 
    foreign key (USER_ID_) 
    references ACT_ID_USER (ID_);

alter table ACT_TASKINVOLVEMENT
    add constraint FK_TSKASS_TASK 
    foreign key (TASK_ID_) 
    references ACT_TASK (ID_);
    
alter table ACT_TASK
    add constraint FK_TASK_EXEC
    foreign key (EXECUTION_ID_)
    references ACT_EXECUTION (ID_);
    
alter table ACT_TASK
    add constraint FK_TASK_PROCINST
    foreign key (PROC_INST_ID_)
    references ACT_EXECUTION (ID_);
    
alter table ACT_TASK
  add constraint FK_TASK_PROCDEF
  foreign key (PROC_DEF_ID_)
  references ACT_PROCESSDEFINITION (ID_);
  
alter table ACT_VARIABLE 
    add constraint FK_VAR_TASK 
    foreign key (TASK_ID_) 
    references ACT_TASK (ID_);

alter table ACT_VARIABLE 
    add constraint FK_VAR_EXE 
    foreign key (EXECUTION_ID_) 
    references ACT_EXECUTION (ID_);

alter table ACT_VARIABLE 
    add constraint FK_VAR_BYTEARRAY 
    foreign key (BYTEARRAY_ID_) 
    references ACT_BYTEARRAY (ID_);
{'fraction_non_alphanumeric': 0.07148829431438126, 'fraction_numerical': 0.03574414715719063, 'mean_word_length': 3.135263612791703, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4377946', 'n_tokens_mistral': 3851, 'n_tokens_neox': 3285, 'n_words': 845}