<commit_before>
-- Table containing the project staff 
--
CREATE TABLE if not exists gems__staff (
        gsf_id_user          bigint unsigned not null auto_increment,

        gsf_login            varchar(20) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
                               not null unique key,
        gsf_password         varchar(32) CHARACTER SET '<PASSWORD>' COLLATE 'utf8_general_ci'
                               not null,

        gsf_active           boolean not null default 1, 
	gsf_failed_logins    int(11) unsigned not null default 0,
        gsf_id_primary_group bigint unsigned
                               references gems__groups (ggp_id_group),
        gsf_id_organization  bigint not null 
                               references gems__organizations (gor_id_organization),
        gsf_iso_lang         char(2) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
                               not null default 'nl' references gems__languages (gml_iso_lang),
        gsf_logout_on_survey boolean not null default 0,

        gsf_email            varchar(100) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
                               unique key,

        gsf_first_name       varchar(30) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        gsf_surname_prefix   varchar(10) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        gsf_last_name        varchar(30) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        gsf_gender           char(1) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
                               not null default 'U',
        -- gsf_birthday         date,
        -- gsf_function         varchar(40) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',

        -- gsf_address_1        varchar(80) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_address_2        varchar(80) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_zipcode          varchar(10) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_city             varchar(40) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_region           varchar(40) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_iso_country      char(2) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
        --                          references phpwcms__phpwcms_country (country_iso),
        gsf_phone_1          varchar(25) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_phone_2          varchar(25) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_phone_3          varchar(25) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',

        gsf_reset_key        varchar(64) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null,
        gsf_reset_requested  timestamp null,

        gsf_changed          timestamp not null default current_timestamp on update current_timestamp,
        gsf_changed_by       bigint unsigned not null,
        gsf_created          timestamp not null,
        gsf_created_by       bigint unsigned not null,

        PRIMARY KEY(gsf_id_user)
    )
    ENGINE=InnoDB
    AUTO_INCREMENT = 2001
    CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

<commit_msg>Fixed table create script<commit_after>
-- Table containing the project staff 
--
CREATE TABLE if not exists gems__staff (
        gsf_id_user          bigint unsigned not null auto_increment,

        gsf_login            varchar(20) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
                               not null unique key,
        gsf_password         varchar(32) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
                               not null,

        gsf_active           boolean not null default 1, 
	gsf_failed_logins    int(11) unsigned not null default 0,
        gsf_last_failed      timestamp null,
        gsf_id_primary_group bigint unsigned
                               references gems__groups (ggp_id_group),
        gsf_id_organization  bigint not null 
                               references gems__organizations (gor_id_organization),
        gsf_iso_lang         char(2) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
                               not null default 'nl' references gems__languages (gml_iso_lang),
        gsf_logout_on_survey boolean not null default 0,

        gsf_email            varchar(100) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
                               unique key,

        gsf_first_name       varchar(30) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        gsf_surname_prefix   varchar(10) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        gsf_last_name        varchar(30) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        gsf_gender           char(1) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
                               not null default 'U',
        -- gsf_birthday         date,
        -- gsf_function         varchar(40) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',

        -- gsf_address_1        varchar(80) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_address_2        varchar(80) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_zipcode          varchar(10) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_city             varchar(40) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_region           varchar(40) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_iso_country      char(2) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
        --                          references phpwcms__phpwcms_country (country_iso),
        gsf_phone_1          varchar(25) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_phone_2          varchar(25) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',
        -- gsf_phone_3          varchar(25) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci',

        gsf_reset_key        varchar(64) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null,
        gsf_reset_requested  timestamp null,

        gsf_changed          timestamp not null default current_timestamp on update current_timestamp,
        gsf_changed_by       bigint unsigned not null,
        gsf_created          timestamp not null,
        gsf_created_by       bigint unsigned not null,

        PRIMARY KEY(gsf_id_user)
    )
    ENGINE=InnoDB
    AUTO_INCREMENT = 2001
    CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';


{'fraction_non_alphanumeric': 0.06154082259054635, 'fraction_numerical': 0.027470841006752608, 'mean_word_length': 1.969020501138952, 'pattern_counts': {'":': 0, '<': 4, '<?xml version=': 0, '>': 4, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 10, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2347447', 'n_tokens_mistral': 2152, 'n_tokens_neox': 2036, 'n_words': 494}