<commit_before>REPLACE INTO Consortia (id, short_name, full_name) VALUES
(
    ( 1, "Astro"          , "Astrophysics and Remote Sensing"                                           ) ,
    ( 2, "BioinfCompBio"  , "Bioinformatics and Computational Biology"                                  ) ,
    ( 3, "BuiltEnv"       , "The Bartlett - Built Environment"                                          ) ,
    ( 4, "Climate"        , "Climate Change and Earth Observation"                                      ) ,
    ( 5, "ENGFEAandCFD"   , "Engineering - Finite Element Analysis & Computational Fluid Dynamics"      ) ,
    ( 6, "EngDAandMD"     , "Engineering Sciences – Optimisation, Data Analysis and Molecular Dynamics" ) ,
    ( 7, "Economics"      , "Economics"                                                                 ) ,
    ( 8, "Epidemiology"   , "Epidemiology"                                                              ) ,
    ( 9, "HEP"            , "High Energy Physics"                                                       ) ,
    (10, "ISD"            , "Information Services Division"                                             ) ,
    (11, "NGS"            , "Next Generation Sequencing"                                                ) ,
    (12, "TYCOrgPharmMat" , "Thomas Young Centre - Organic and Pharmaceutical Materials"                ) ,
    (13, "TYCEarthMat"    , "Thomas Young Centre - Earth Materials"                                     ) ,
    (14, "TYCNano"        , "Thomas Young Centre - Nanoscience and Defects"                             ) ,
    (15, "TYCCatSurf"     , "Thomas Young Centre - Surface Science and Catalysis"                       ) ,
    (16, "Maths"          , "Mathematical Sciences"                                                     ) ,
    (17, "MedImaging"     , "Medical Imaging"                                                           ) ,
    (18, "MolQuantDynam"  , "Molecular Quantum Dynamics and Electronic Structure"                       ) ,
    (19, "NeuroSci"       , "Neuroscience"                                                              ) ,
    (20, "sochistsci"     , "Social and Historical Sciences"                                            ) ,
    (21, "SysBioMed"      , "Systems Biomedicine"                                                       ) ,
    (22, "PENDING"        , "(None of these fit my research area)"                                      ) 
);

REPLACE INTO Services (id, name) VALUES
(
    (1, 'Legion'),
    (2, 'Iridis'),
    (3, 'Emerald')
);

INSERT INTO Event_Types (event_type) VALUES
(
    ('submitted'),
    ('approved'),
    ('declined')
);

INSERT INTO User_Types (user_type) VALUES
(
    ('Principle Investigator'),
    ('Non-PI Researcher'),
    ('PhD/EngD Student'),
    ('Masters Student (Postgraduate)'),
    ('Masters Student (Undergraduate)'),
    ('Other Undergraduate')
);

INSERT INTO User_Experience_Levels (level_text) VALUES
(
    ("Novice with No Local Support"),
    ("Novice with Local Support"),
    ("Linux experience but no HPC"),
    ("Linux and HPC experience")
);

REPLACE INTO Privileged_Users 
    (id, username, full_name, 
        super_special_rainbow_pegasus_powers, 
        receives_emails, email_address) 
    VALUES
(
    (1, "ccaabaa", "<NAME>", TRUE, TRUE, "<EMAIL>"),
    (2, "ccaabcs", "<NAME>", TRUE, TRUE, "<EMAIL>"),
    (3, "uccaiki", "<NAME>", TRUE, TRUE, "<EMAIL>"),
    (4, "uccaoke", "<NAME>", TRUE, TRUE, "<EMAIL>"),
    (5, "ccaacla", "<NAME>", FALSE, TRUE, "<EMAIL>")
);

INSERT INTO Consortium_Permissions (privileged_user_id, approves_for_consortium) VALUES
(
    (5, 22) -- Clare for PENDING
);

<commit_msg>Added new consortia<commit_after>REPLACE INTO Consortia (short_name, full_name) VALUES
(
    ( "Astro"             , "Astrophysics and Remote Sensing"                                           ) ,
    ( "BioinfCompBio"     , "Bioinformatics and Computational Biology"                                  ) ,
    ( "BuiltEnv"          , "The Bartlett - Built Environment"                                          ) ,
    ( "Climate"           , "Climate Change and Earth Observation"                                      ) ,
    ( "digitalhumanities" , "Digital Humanities"                                                        ) ,
    ( "ENGFEAandCFD"      , "Engineering - Finite Element Analysis & Computational Fluid Dynamics"      ) ,
    ( "EngDAandMD"        , "Engineering Sciences – Optimisation, Data Analysis and Molecular Dynamics" ) ,
    ( "Economics"         , "Economics"                                                                 ) ,
    ( "Epidemiology"      , "Epidemiology"                                                              ) ,
    ( "gatsbyneuro"       , "The Gatsby Computational Neuroscience Unit"                                ) ,
    ( "HEP"               , "High Energy Physics"                                                       ) ,
    ( "ISD"               , "Information Services Division"                                             ) ,
    ( "NGS"               , "Next Generation Sequencing"                                                ) ,
    ( "TYCOrgPharmMat"    , "Thomas Young Centre - Organic and Pharmaceutical Materials"                ) ,
    ( "TYCEarthMat"       , "Thomas Young Centre - Earth Materials"                                     ) ,
    ( "TYCNano"           , "Thomas Young Centre - Nanoscience and Defects"                             ) ,
    ( "TYCCatSurf"        , "Thomas Young Centre - Surface Science and Catalysis"                       ) ,
    ( "Maths"             , "Mathematical Sciences"                                                     ) ,
    ( "MedImaging"        , "Medical Imaging"                                                           ) ,
    ( "MolQuantDynam"     , "Molecular Quantum Dynamics and Electronic Structure"                       ) ,
    ( "NeuroSci"          , "Neuroscience"                                                              ) ,
    ( "sochistsci"        , "Social and Historical Sciences"                                            ) ,
    ( "SysBioMed"         , "Systems Biomedicine"                                                       ) ,
    ( "PENDING"           , "[None of these fit my research area]"                                      )
);

REPLACE INTO Services (id, name) VALUES
(
    (1, 'Legion'),
    (2, 'Iridis'),
    (3, 'Emerald')
);

INSERT INTO Event_Types (event_type) VALUES
(
    ('submitted'),
    ('approved'),
    ('declined')
);

INSERT INTO User_Types (user_type) VALUES
(
    ('Principle Investigator'),
    ('Non-PI Researcher'),
    ('PhD/EngD Student'),
    ('Masters Student (Postgraduate)'),
    ('Masters Student (Undergraduate)'),
    ('Other Undergraduate')
);

INSERT INTO User_Experience_Levels (level_text) VALUES
(
    ("Novice with No Local Support"),
    ("Novice with Local Support"),
    ("Linux experience but no HPC"),
    ("Linux and HPC experience")
);

REPLACE INTO Privileged_Users 
    (id, username, full_name, 
        super_special_rainbow_pegasus_powers, 
        receives_emails, email_address) 
    VALUES
(
    (1, "ccaabaa", "<NAME>", TRUE, TRUE, "<EMAIL>"),
    (2, "ccaabcs", "<NAME>", TRUE, TRUE, "<EMAIL>"),
    (3, "uccaiki", "<NAME>", TRUE, TRUE, "<EMAIL>"),
    (4, "uccaoke", "<NAME>", TRUE, TRUE, "<EMAIL>"),
    (5, "ccaacla", "<NAME>", FALSE, TRUE, "<EMAIL>")
);

INSERT INTO Consortium_Permissions (privileged_user_id, approves_for_consortium) VALUES
(
    --(5, 22) -- Clare for PENDING
);


{'fraction_non_alphanumeric': 0.11392739273927392, 'fraction_numerical': 0.0075247524752475245, 'mean_word_length': 1.3118706133658835, 'pattern_counts': {'":': 0, '<': 23, '<?xml version=': 0, '>': 23, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 58, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2170193', 'n_tokens_mistral': 2099, 'n_tokens_neox': 1925, 'n_words': 502}