<commit_before>/*
Copyright (c) 2000-2013 "independIT Integrative Technologies GmbH",
Authors: <NAME>, <NAME>

schedulix Enterprise Job Scheduling System

independIT Integrative Technologies GmbH [http://www.independit.de]
mailto:<EMAIL>

This file is part of schedulix

schedulix is free software: 
you can redistribute it and/or modify it under the terms of the 
GNU Affero General Public License as published by the 
Free Software Foundation, either version 3 of the License, 
or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU Affero General Public License for more details.

You should have received a copy of the GNU Affero General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/


INSERT INTO OBJECTCOUNTER VALUES (1000);

INSERT INTO VERSIONCOUNTER VALUES (1);

INSERT INTO GROUPS (ID, NAME,     DELETE_VERSION, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
	VALUES     (80, 'PUBLIC', 0,              0,            0,         0,            0);

INSERT INTO GROUPS (ID, NAME,    DELETE_VERSION, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
	VALUES     (81, 'ADMIN', 0,              0,            0,         0,            0);

INSERT INTO USERS (ID, NAME,     PASSWD,                                SALT, METHOD, IS_ENABLED, DEFAULT_G_ID, CONNECTION_TYPE, DELETE_VERSION, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
	VALUES    (0,  'SYSTEM', '<PASSWORD> 75dde00e 8f0fd6f4 6cf65faf', null, 0,      1,          81,           0,               0,              0,            0,         0,            0);

INSERT INTO USERS (ID, NAME,     PASSWD,                                SALT, METHOD, IS_ENABLED, DEFAULT_G_ID, CONNECTION_TYPE, DELETE_VERSION, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
	VALUES    (1,  'NOBODY', 'xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx', null, 0,      0,          80,           0,               0,              0,            0,         0,            0);

INSERT INTO USERS (ID, NAME,       PASSWD,                              SALT, METHOD, IS_ENABLED, DEFAULT_G_ID, CONNECTION_TYPE, DELETE_VERSION, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
	VALUES    (2,  'INTERNAL', 'xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx', null, 0,    0,          81,           0,               0,              0,            0,         0,            0);

INSERT INTO USERS (ID, NAME,           PASSWD,                                SALT, METHOD, IS_ENABLED, DEFAULT_G_ID, CONNECTION_TYPE, DELETE_VERSION, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
       VALUES     (3, 'FE_PROPERTIES', 'xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx', null, 0,      0,          80,           0,               0,              0,            0,         0,            0);

INSERT INTO SCHEDULING_HIERARCHY (
	ID, SE_PARENT_ID, SE_CHILD_ID, ALIAS_NAME, IS_STATIC, IS_DISABLED, PRIORITY, SUSPEND, MERGE_MODE, ESTP_ID, ENABLE_MODE,
	CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS, VALID_FROM, VALID_TO)
VALUES (
	30, NULL,         NULL,        NULL,       0,         0,           0,        1,       3,          NULL,    0,
	0, 0, 0, 0, 0, 9223372036854775807);

INSERT INTO FOLDER (ID, NAME,     OWNER_ID, ENV_ID, PARENT_ID, VALID_FROM, VALID_TO,            CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS, INHERIT_PRIVS)
	VALUES     (40, 'SYSTEM', 81,       NULL,   NULL,      0,          9223372036854775807, 0,            0,         0,            0,         0);

INSERT INTO SCOPE (ID, NAME,     OWNER_ID, TYPE, METHOD, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS, INHERIT_PRIVS)
	VALUES    (50, 'GLOBAL', 81,       1,    0,      0,            0,         0,            0,         0);

INSERT INTO NAMED_RESOURCE (ID, NAME,       OWNER_ID, PARENT_ID, `USAGE`, RSP_ID, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS, INHERIT_PRIVS)
	VALUES             (60, 'RESOURCE', 81,       NULL,      8,       NULL,   0,            0,         0,            0,         0);

INSERT INTO SCHEDULE (ID, NAME,   OWNER_ID, INT_ID, PARENT_ID, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS, ACTIVE, INHERIT_PRIVS, TIME_ZONE)
	VALUES       (70, 'ROOT', 81,       NULL,   NULL,      0,            0,         0,            0,         1,      0,             'GMT');

INSERT INTO MEMBER (ID, G_ID, U_ID, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
	VALUES     (90, 81,   0,    0,            0,         0,            0);

INSERT INTO MEMBER (ID, G_ID, U_ID, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
	VALUES     (91, 80,   0,    0,            0,         0,            0);

INSERT INTO MEMBER (ID, G_ID, U_ID, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
	VALUES     (92, 80,   1,    0,            0,         0,            0);

INSERT INTO MEMBER (ID, G_ID, U_ID, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
	VALUES     (93, 81,   2,    0,            0,         0,            0);

INSERT INTO MEMBER (ID, G_ID, U_ID, CREATOR_U_ID, CREATE_TS, CHANGER_U_ID, CHANGE_TS)
        VALUES     (94, 80,   3,    0,            0,         0,            0);
<commit_msg>quoted all identifiers. GROUPS was added as reserved word in mysql 8.0.2<commit_after>/*
Copyright (c) 2000-2013 "independIT Integrative Technologies GmbH",
Authors: <NAME>, <NAME>

schedulix Enterprise Job Scheduling System

independIT Integrative Technologies GmbH [http://www.independit.de]
mailto:<EMAIL>

This file is part of schedulix

schedulix is free software: 
you can redistribute it and/or modify it under the terms of the 
GNU Affero General Public License as published by the 
Free Software Foundation, either version 3 of the License, 
or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU Affero General Public License for more details.

You should have received a copy of the GNU Affero General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/


INSERT INTO `OBJECTCOUNTER` VALUES (1000);

INSERT INTO `VERSIONCOUNTER` VALUES (1);

INSERT INTO `GROUPS` (`ID`,  `NAME`, `DELETE_VERSION`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
	VALUES     (80, 'PUBLIC', 0,              0,            0,         0,            0);

INSERT INTO `GROUPS` (`ID`,  `NAME`, `DELETE_VERSION`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
	VALUES     (81, 'ADMIN', 0,              0,            0,         0,            0);

INSERT INTO `USERS` (`ID`,       `NAME`,                              `PASSWD`, `SALT`, `METHOD`, `IS_ENABLED`, `DEFAULT_G_ID`, `CONNECTION_TYPE`, `DELETE_VERSION`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
	VALUES    (0,  'SYSTEM', 'ba143b7e 75dde00e 8f0fd6f4 <PASSWORD>', null, 0,      1,          81,           0,               0,              0,            0,         0,            0);

INSERT INTO `USERS` (`ID`,       `NAME`,                              `PASSWD`, `SALT`, `METHOD`, `IS_ENABLED`, `DEFAULT_G_ID`, `CONNECTION_TYPE`, `DELETE_VERSION`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
	VALUES    (1,  'NOBODY', 'xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx', null, 0,      0,          80,           0,               0,              0,            0,         0,            0);

INSERT INTO `USERS` (`ID`,       `NAME`,                              `PASSWD`, `SALT`, `METHOD`, `IS_ENABLED`, `DEFAULT_G_ID`, `CONNECTION_TYPE`, `DELETE_VERSION`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
	VALUES    (2,  'INTERNAL', 'xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx', null, 0,    0,          81,           0,               0,              0,            0,         0,            0);

INSERT INTO `USERS` (`ID`,       `NAME`,                              `PASSWD`, `SALT`, `METHOD`, `IS_ENABLED`, `DEFAULT_G_ID`, `CONNECTION_TYPE`, `DELETE_VERSION`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
       VALUES     (3, 'FE_PROPERTIES', 'xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx', null, 0,      0,          80,           0,               0,              0,            0,         0,            0);

INSERT INTO `SCHEDULING_HIERARCHY` (
	`ID`, `SE_PARENT_ID`, `SE_CHILD_ID`, `ALIAS_NAME`, `IS_STATIC`, `IS_DISABLED`, `PRIORITY`, `SUSPEND`, `MERGE_MODE`, `ESTP_ID`, `ENABLE_MODE`,
	`CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`, `VALID_FROM`,         `VALID_TO`)
VALUES (
	30, NULL,         NULL,        NULL,       0,         0,           0,        1,       3,          NULL,    0,
	0, 0, 0, 0, 0, 9223372036854775807);

INSERT INTO `FOLDER` (`ID`,  `NAME`,     `OWNER_ID`, `ENV_ID`, `PARENT_ID`, `VALID_FROM`,          `VALID_TO`,            `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`, `INHERIT_PRIVS`)
	VALUES     (40, 'SYSTEM', 81,       NULL,   NULL,      0,          9223372036854775807, 0,            0,         0,            0,         0);

INSERT INTO `SCOPE` (`ID`,  `NAME`,     `OWNER_ID`, `TYPE`, `METHOD`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`, `INHERIT_PRIVS`)
	VALUES    (50, 'GLOBAL', 81,       1,    0,      0,            0,         0,            0,         0);

INSERT INTO `NAMED_RESOURCE` (`ID`,    `NAME`,       `OWNER_ID`, `PARENT_ID`, `USAGE`, `RSP_ID`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`, `INHERIT_PRIVS`)
	VALUES             (60, 'RESOURCE', 81,       NULL,      8,       NULL,   0,            0,         0,            0,         0);

INSERT INTO `SCHEDULE` (`ID`, `NAME`,   `OWNER_ID`, `INT_ID`, `PARENT_ID`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`, `ACTIVE`, `INHERIT_PRIVS`, `TIME_ZONE`)
	VALUES       (70, 'ROOT', 81,       NULL,   NULL,      0,            0,         0,            0,         1,      0,             'GMT');

INSERT INTO `MEMBER` (`ID`, `G_ID`, `U_ID`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
	VALUES     (90, 81,   0,    0,            0,         0,            0);

INSERT INTO `MEMBER` (`ID`, `G_ID`, `U_ID`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
	VALUES     (91, 80,   0,    0,            0,         0,            0);

INSERT INTO `MEMBER` (`ID`, `G_ID`, `U_ID`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
	VALUES     (92, 80,   1,    0,            0,         0,            0);

INSERT INTO `MEMBER` (`ID`, `G_ID`, `U_ID`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
	VALUES     (93, 81,   2,    0,            0,         0,            0);

INSERT INTO `MEMBER` (`ID`, `G_ID`, `U_ID`, `CREATOR_U_ID`, `CREATE_TS`, `CHANGER_U_ID`, `CHANGE_TS`)
        VALUES     (94, 80,   3,    0,            0,         0,            0);

{'fraction_non_alphanumeric': 0.11986301369863013, 'fraction_numerical': 0.0410958904109589, 'mean_word_length': 2.0505364201016376, 'pattern_counts': {'":': 0, '<': 13, '<?xml version=': 0, '>': 13, 'https://': 0, 'lorem ipsum': 0, 'www.': 4, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 24, 'word_list_counts': {'cursed_substrings.json': 80, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1633576', 'n_tokens_mistral': 4168, 'n_tokens_neox': 3828, 'n_words': 1093}