<commit_before><?xml version="1.0"?>

<properties xmlns="http://www.jasig.org/uPortal/database/properties">

  <!-- Set to false to disable execution of DROP, CREATE, and/or POPULATE TABLE SQL statements -->

  <drop-tables>true</drop-tables>
  <create-tables>true</create-tables>
  <populate-tables>true</populate-tables>

  <!-- Location of tables.xml file -->
  <tables-uri>properties/tables.xml</tables-uri>

  <!-- Location of tables.xsl stylesheet -->
  <tables-xsl-uri>webpages/stylesheets/org/jasig/portal/tools/DbLoader/tables.xsl</tables-xsl-uri>

  <!-- Location of data.xml file -->
  <data-uri>properties/data.xml</data-uri>

  <!-- DbLoader can dump DROP, CREATE, and INSERT statements to a file. If <create-script> is
       set to true, the script file will be created in <portal base directory>/properties -->

  <create-script>true</create-script>
  <script-file-name>dbloader.script</script-file-name>
  <statement-terminator>;</statement-terminator>

  <!-- Mappings for cases where database metadata is incomplete.
       "db-name", "db-version", "driver-name", and "driver-version"
       must match the values returned by
       java.sql.Connection.getMetaData().getDatabaseProductName(),
       java.sql.Connection.getMetaData().getDatabaseProductVersion(),
       java.sql.Connection.getMetaData().getDriverName(), and
       java.sql.Connection.getMetaData().getDriverVersion() -->

  <db-type-mapping>
    <db-name>HypersonicSQL</db-name>
    <db-version>1.4</db-version>
    <driver-name>HypersonicSQL Driver</driver-name>
    <driver-version>1.4</driver-version>
    <type><generic>INTEGER</generic><local>INTEGER</local></type>
    <type><generic>VARCHAR</generic><local>VARCHAR</local></type>
    <type><generic>LONGVARCHAR</generic><local>LONGVARCHAR</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>InstantDB</db-name>
    <db-version>Version 3.26</db-version>
    <driver-name>InstantDB JDBC Driver</driver-name>
    <driver-version>Version 3.26</driver-version>
    <type><generic>LONGVARCHAR</generic><local>BINARY</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>Microsoft SQL Server</db-name>
    <db-version>07.00.0699</db-version>
    <driver-name>JDBC-ODBC Bridge (SQLSRV32.DLL)</driver-name>
    <driver-version>2.0001 (03.70.0820)</driver-version>
    <type><generic>INTEGER</generic><local>INTEGER</local></type>
    <type><generic>VARCHAR</generic><local>VARCHAR</local></type>
    <type><generic>LONGVARCHAR</generic><local>TEXT</local></type>
    <type><generic>TIMESTAMP</generic><local>DATETIME</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>Microsoft SQL Server</db-name>
    <db-version>Microsoft SQL Server  7.00 - 7.00.699 (Intel X86) 
	May 21 1999 14:08:18 
	Copyright (c) 1988-1998 Microsoft Corporation
	Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4)
</db-version>
    <driver-name>weblogic.jdbc.mssqlserver4.Driver</driver-name>
    <driver-version>3.1</driver-version>
    <type><generic>TIMESTAMP</generic><local>DATETIME</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>MySQL</db-name>
    <db-version>3.23.34a</db-version>
    <driver-name><NAME>&apos; MySQL Driver</driver-name>
    <driver-version>1.2b</driver-version>
    <type><generic>LONGVARCHAR</generic><local>TEXT</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>Oracle</db-name>
    <!-- Line break has to be here -->
    <db-version>Oracle8 Enterprise Edition Release 8.0.6.2.0 - Production
PL/SQL Release 8.0.6.2.0 - Production</db-version>
    <driver-name>Oracle JDBC driver</driver-name>
    <driver-version>8.1.6.0.0</driver-version>
    <type><generic>TIMESTAMP</generic><local>DATE</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>Oracle</db-name>
    <!-- Line breaks have to be here -->
    <db-version>Oracle8i Enterprise Edition Release 8.172.16.17.32 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production</db-version>
    <driver-name>Oracle JDBC driver</driver-name>
    <driver-version>8.1.7.0.0</driver-version>
    <type><generic>TIMESTAMP</generic><local>DATE</local></type>
    <!-- map more types here -->
  </db-type-mapping>
  
</properties>
<commit_msg>added mappings for Postgresql 7.1.2<commit_after><?xml version="1.0"?>

<properties xmlns="http://www.jasig.org/uPortal/database/properties">

  <!-- Set to false to disable execution of DROP, CREATE, and/or POPULATE TABLE SQL statements -->

  <drop-tables>true</drop-tables>
  <create-tables>true</create-tables>
  <populate-tables>true</populate-tables>

  <!-- Location of tables.xml file -->
  <tables-uri>properties/tables.xml</tables-uri>

  <!-- Location of tables.xsl stylesheet -->
  <tables-xsl-uri>webpages/stylesheets/org/jasig/portal/tools/DbLoader/tables.xsl</tables-xsl-uri>

  <!-- Location of data.xml file -->
  <data-uri>properties/data.xml</data-uri>

  <!-- DbLoader can dump DROP, CREATE, and INSERT statements to a file. If <create-script> is
       set to true, the script file will be created in <portal base directory>/properties -->

  <create-script>true</create-script>
  <script-file-name>dbloader.script</script-file-name>
  <statement-terminator>;</statement-terminator>

  <!-- Mappings for cases where database metadata is incomplete.
       "db-name", "db-version", "driver-name", and "driver-version"
       must match the values returned by
       java.sql.Connection.getMetaData().getDatabaseProductName(),
       java.sql.Connection.getMetaData().getDatabaseProductVersion(),
       java.sql.Connection.getMetaData().getDriverName(), and
       java.sql.Connection.getMetaData().getDriverVersion() -->

  <db-type-mapping>
    <db-name>HypersonicSQL</db-name>
    <db-version>1.4</db-version>
    <driver-name>HypersonicSQL Driver</driver-name>
    <driver-version>1.4</driver-version>
    <type><generic>INTEGER</generic><local>INTEGER</local></type>
    <type><generic>VARCHAR</generic><local>VARCHAR</local></type>
    <type><generic>LONGVARCHAR</generic><local>LONGVARCHAR</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>InstantDB</db-name>
    <db-version>Version 3.26</db-version>
    <driver-name>InstantDB JDBC Driver</driver-name>
    <driver-version>Version 3.26</driver-version>
    <type><generic>LONGVARCHAR</generic><local>BINARY</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>Microsoft SQL Server</db-name>
    <db-version>07.00.0699</db-version>
    <driver-name>JDBC-ODBC Bridge (SQLSRV32.DLL)</driver-name>
    <driver-version>2.0001 (03.70.0820)</driver-version>
    <type><generic>INTEGER</generic><local>INTEGER</local></type>
    <type><generic>VARCHAR</generic><local>VARCHAR</local></type>
    <type><generic>LONGVARCHAR</generic><local>TEXT</local></type>
    <type><generic>TIMESTAMP</generic><local>DATETIME</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>Microsoft SQL Server</db-name>
    <db-version>Microsoft SQL Server  7.00 - 7.00.699 (Intel X86) 
	May 21 1999 14:08:18 
	Copyright (c) 1988-1998 Microsoft Corporation
	Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4)
</db-version>
    <driver-name>weblogic.jdbc.mssqlserver4.Driver</driver-name>
    <driver-version>3.1</driver-version>
    <type><generic>TIMESTAMP</generic><local>DATETIME</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>MySQL</db-name>
    <db-version>3.23.34a</db-version>
    <driver-name><NAME>&apos; MySQL Driver</driver-name>
    <driver-version>1.2b</driver-version>
    <type><generic>LONGVARCHAR</generic><local>TEXT</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>Oracle</db-name>
    <!-- Line break has to be here -->
    <db-version>Oracle8 Enterprise Edition Release 8.0.6.2.0 - Production
PL/SQL Release 8.0.6.2.0 - Production</db-version>
    <driver-name>Oracle JDBC driver</driver-name>
    <driver-version>8.1.6.0.0</driver-version>
    <type><generic>TIMESTAMP</generic><local>DATE</local></type>
    <!-- map more types here -->
  </db-type-mapping>

  <db-type-mapping>
    <db-name>Oracle</db-name>
    <!-- Line breaks have to be here -->
    <db-version>Oracle8i Enterprise Edition Release 172.16.58.3.0 - Production
With the Partitioning option
JServer Release 172.16.58.3.0 - Production</db-version>
    <driver-name>Oracle JDBC driver</driver-name>
    <driver-version>8.1.7.0.0</driver-version>
    <type><generic>TIMESTAMP</generic><local>DATE</local></type>
    <!-- map more types here -->
  </db-type-mapping>
  
<db-type-mapping>
    <db-name>PostgreSQL</db-name>
    <db-version>7.1.2</db-version>
    <driver-name>PostgreSQL Native Driver</driver-name>
    <driver-version>PostgreSQL 7.1.2 JDBC2</driver-version>
    <type><generic>LONGVARCHAR</generic><local>TEXT</local></type>
    <type><generic>VARCHAR</generic><local>VARCHAR</local></type>
  </db-type-mapping>


</properties>

{'fraction_non_alphanumeric': 0.17714592274678112, 'fraction_numerical': 0.027145922746781116, 'mean_word_length': 3.655844155844156, 'pattern_counts': {'":': 0, '<': 387, '<?xml version=': 2, '>': 387, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 12}, 'pii_count': 12, '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': '1169625', 'n_tokens_mistral': 3299, 'n_tokens_neox': 3120, 'n_words': 520}