<commit_before><databaseChangeLog
	xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
		http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">

<!-- When using one of the following commands, a rollback script is not required
AddColumn
AddDefaultValue
AddForeignKeyConstraint
AddLookupTable
AddNotNullConstraint
AddPrimaryKey
AddUniqueConstraint
CreateIndex
CreateSequence
CreateTable
CreateView
DropNotNullConstraint
RenameColumn
RenameTable
RenameView
TagDatabase
-->
 	<changeSet id="UPDATE IBIS PROP TABLE" author="<NAME>">
 		<comment>For some reason oracle is a bit silly so we cant update?</comment>
		<dropColumn tableName="IBISPROP" columnName="LASTMODBY"/>
		<addColumn tableName="IBISPROP">
			<column name="LASTMODBY" type="java.sql.Types.VARCHAR(100)"/>
		</addColumn>
 	</changeSet>
 	
	<changeSet id="IBISTEMP" author="<NAME>">
		<validCheckSum>7:4e0dba09800e08930e4d452e11f83566</validCheckSum>
		<comment>Add IBISTEMP Table</comment>
		<createTable tableName="IBISTEMP">
			<column name="TKEY" type="INT" autoIncrement="true">
				<constraints primaryKey="true" nullable="false" primaryKeyName="PK_IBISTEMP"/>
			</column>
			<column name="TCHAR" type="java.sql.Types.CHAR(1)"/>
			<column name="TVARCHAR" type="java.sql.Types.VARCHAR(100)"/>
			<column name="TNUMBER" type="java.sql.Types.DECIMAL(17, 5)"/>
			<column name="TTIMESTAMP" type="DATETIME"/>
			<column name="TDATE" type="TIME"/>
			<column name="TBLOB1" type="LONGBLOB"/>
			<column name="TCLOB" type="CLOB"/> <!-- is set as LONGTEXT for MySQL and MariaDB -->
			<column name="TBLOB2" type="LONGBLOB"/>
		</createTable>
		<modifySql dbms="mssql" >
			<replace replace="[int] IDENTITY (1, 1)" with="INT"/>
		</modifySql>
	</changeSet>

	<changeSet id="IBISTEMP_SEQ" author="<NAME>" onValidationFail="MARK_RAN">
		<comment>Set sequence for IBISTEMP Table</comment>
		<createSequence sequenceName="SEQ_IBISTEMP" startValue="56789"/>
	</changeSet>

	<changeSet id="IAF_Util:8" author="<NAME>">
		<comment>Add IBISFILETRIGGER Table</comment>
		<createTable tableName="IBISFILETRIGGER">
			<column name="ID" type="BIGINT" autoIncrement="true">
				<constraints primaryKey="true" nullable="false" primaryKeyName="PK_IBISFILETRIGGER" />
			</column>
			<column name="MESSAGEID" type="java.sql.Types.VARCHAR(256)">	<!-- uniquely identifying the content of the file -->
				<constraints unique="true" uniqueConstraintName="UQ_IBISFILETRIGGER_MESSAGEID" nullable="false" />
			</column>
			<column name="FILENAME" type="java.sql.Types.VARCHAR(100)" />	<!-- name of the file that will be processed -->
			<column name="FILEURI" type="java.sql.Types.VARCHAR(256)" >			<!-- canonical name of the file points to the location of the file in the filesystem-->
				<constraints unique="true" uniqueConstraintName="UQ_IBISFILETRIGGER_URI" nullable="false" />
			</column>
			<column name="CREATED_AT" type="DATETIME" />
			<column name="FILESIZE" type="INTEGER" />
			<column name="FLOWID" type="java.sql.Types.VARCHAR(100)" />
			<column name="MESSAGE" type="java.sql.Types.VARCHAR(1000)" />	<!-- an xml that contains information about the file and the flow. An example can be found in src\test\testtool\ManagedFileHandler\scenario01\message.xml --><commit_msg>Fix iaf-test MSSQL identity insert (#2618)<commit_after><databaseChangeLog
	xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
		http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">

<!-- When using one of the following commands, a rollback script is not required
AddColumn
AddDefaultValue
AddForeignKeyConstraint
AddLookupTable
AddNotNullConstraint
AddPrimaryKey
AddUniqueConstraint
CreateIndex
CreateSequence
CreateTable
CreateView
DropNotNullConstraint
RenameColumn
RenameTable
RenameView
TagDatabase
-->
 	<changeSet id="UPDATE IBIS PROP TABLE" author="<NAME>">
 		<comment>For some reason oracle is a bit silly so we cant update?</comment>
		<dropColumn tableName="IBISPROP" columnName="LASTMODBY"/>
		<addColumn tableName="IBISPROP">
			<column name="LASTMODBY" type="java.sql.Types.VARCHAR(100)"/>
		</addColumn>
 	</changeSet>
 	
	<changeSet id="IBISTEMP" author="<NAME>">
		<validCheckSum>7:4e0dba09800e08930e4d452e11f83566</validCheckSum>
		<comment>Add IBISTEMP Table</comment>
		<createTable tableName="IBISTEMP">
			<column name="TKEY" type="INT" autoIncrement="true">
				<constraints primaryKey="true" nullable="false" primaryKeyName="PK_IBISTEMP"/>
			</column>
			<column name="TCHAR" type="java.sql.Types.CHAR(1)"/>
			<column name="TVARCHAR" type="java.sql.Types.VARCHAR(100)"/>
			<column name="TNUMBER" type="java.sql.Types.DECIMAL(17, 5)"/>
			<column name="TTIMESTAMP" type="DATETIME"/>
			<column name="TDATE" type="TIME"/>
			<column name="TBLOB1" type="LONGBLOB"/>
			<column name="TCLOB" type="CLOB"/> <!-- is set as LONGTEXT for MySQL and MariaDB -->
			<column name="TBLOB2" type="LONGBLOB"/>
		</createTable>
		<modifySql dbms="mssql" >
			<replace replace="IDENTITY (1, 1)" with=""/> <!-- required to be able to use/test SQL translation -->
		</modifySql>
	</changeSet>

	<changeSet id="IBISTEMP_SEQ" author="<NAME>" onValidationFail="MARK_RAN">
		<comment>Set sequence for IBISTEMP Table</comment>
		<createSequence sequenceName="SEQ_IBISTEMP" startValue="56789"/>
	</changeSet>

	<changeSet id="IAF_Util:8" author="<NAME>">
		<comment>Add IBISFILETRIGGER Table</comment>
		<createTable tableName="IBISFILETRIGGER">
			<column name="ID" type="BIGINT" autoIncrement="true">
				<constraints primaryKey="true" nullable="false" primaryKeyName="PK_IBISFILETRIGGER" />
			</column>
			<column name="MESSAGEID" type="java.sql.Types.VARCHAR(256)">	<!-- uniquely identifying the content of the file -->
				<constraints unique="true" uniqueConstraintName="UQ_IBISFILETRIGGER_MESSAGEID" nullable="false" />
			</column>
			<column name="FILENAME" type="java.sql.Types.VARCHAR(100)" />	<!-- name of the file that will be processed -->
			<column name="FILEURI" type="java.sql.Types.VARCHAR(256)" >			<!-- canonical name of the file points to the location of the file in the filesystem-->
				<constraints unique="true" uniqueConstraintName="UQ_IBISFILETRIGGER_URI" nullable="false" />
			</column>
			<column name="CREATED_AT" type="DATETIME" />
			<column name="FILESIZE" type="INTEGER" />
			<column name="FLOWID" type="java.sql.Types.VARCHAR(100)" />
			<column name="MESSAGE" type="java.sql.Types.VARCHAR(1000)" />	<!-- an xml that contains information about the file and the flow. An example can be found in src\test\testtool\ManagedFileHandler\scenario01\message.xml -->
{'fraction_non_alphanumeric': 0.1526447620450862, 'fraction_numerical': 0.020922351554442317, 'mean_word_length': 5.45861084681256, 'pattern_counts': {'":': 0, '<': 132, '<?xml version=': 0, '>': 132, 'https://': 0, 'lorem ipsum': 0, 'www.': 8, 'xml': 14}, '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': '2131633', 'n_tokens_mistral': 2531, 'n_tokens_neox': 2271, 'n_words': 478}