<commit_before><?php

/**
 * Upgrade 3.2.11 removes the public folder and private folder columns
 * from community and user tables
 */
class Upgrade_3_2_11 extends MIDASUpgrade
{

  public function preUpgrade()
    {
    }

  public function mysql()
    {
    $this->db->query("ALTER TABLE `community` DROP `publicfolder_id`");
    $this->db->query("ALTER TABLE `community` DROP `privatefolder_id`");
    $this->db->query("ALTER TABLE `user` DROP `publicfolder_id`");
    $this->db->query("ALTER TABLE `user` DROP `privatefolder_id`");
    }

  public function pgsql()
    {
    $this->db->query("ALTER TABLE community DROP COLUMN publicfolder_id");
    $this->db->query("ALTER TABLE community DROP COLUMN privatefolder_id");
    $this->db->query("ALTER TABLE user DROP COLUMN publicfolder_id");
    $this->db->query("ALTER TABLE user DROP COLUMN privatefolder_id");
    }

  public function postUpgrade()
    {
    }

}
?><commit_msg>BUG: refs #674. Fix reserved word usage bug on pgsql upgrade script<commit_after><?php

/**
 * Upgrade 3.2.11 removes the public folder and private folder columns
 * from community and user tables
 */
class Upgrade_3_2_11 extends MIDASUpgrade
{

  public function preUpgrade()
    {
    }

  public function mysql()
    {
    $this->db->query("ALTER TABLE `community` DROP `publicfolder_id`");
    $this->db->query("ALTER TABLE `community` DROP `privatefolder_id`");
    $this->db->query("ALTER TABLE `user` DROP `publicfolder_id`");
    $this->db->query("ALTER TABLE `user` DROP `privatefolder_id`");
    }

  public function pgsql()
    {
    $this->db->query("ALTER TABLE community DROP COLUMN publicfolder_id");
    $this->db->query("ALTER TABLE community DROP COLUMN privatefolder_id");
    $this->db->query("ALTER TABLE \"user\" DROP COLUMN publicfolder_id");
    $this->db->query("ALTER TABLE \"user\" DROP COLUMN privatefolder_id");
    }

  public function postUpgrade()
    {
    }

}
?>
{'fraction_non_alphanumeric': 0.14026915113871635, 'fraction_numerical': 0.009834368530020704, 'mean_word_length': 3.844611528822055, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 37, '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': '5503318', 'n_tokens_mistral': 642, 'n_tokens_neox': 627, 'n_words': 163}