<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
	xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" 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.2.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
	
	<changeSet author="ddeucher" id="P4J-AddIndexesForP4JReports">
		<preConditions onFail="MARK_RAN">
        	<not>
        		<indexExists schemaName='${defaultSchema}' indexName='P4JIntervalData_SystemEndTime'></indexExists>
        	</not>
    	</preConditions>
		<createIndex indexName="P4JIntervalData_SystemEndTime"
			tableName="P4JIntervalData" unique="true">
			<column name="SystemID" />
			<column name="EndTime" />
		</createIndex>
	</changeSet>	

	<changeSet author="databaseLabel" id="0007.0"/>
</databaseChangeLog>


<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
	xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" 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.2.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
	
	<changeSet author="ddeucher" id="P4J-AddIndexesForP4JReports">
		<preConditions onFail="MARK_RAN">
        	<not>
        		<indexExists schemaName='${defaultSchema}' indexName='P4JIntervalData_SystemEndTime'></indexExists>
        	</not>
    	</preConditions>
		<createIndex indexName="P4JIntervalData_SystemEndTime"
			tableName="P4JIntervalData" unique="false">
			<column name="SystemID" />
			<column name="EndTime" />
		</createIndex>
	</changeSet>	

	<changeSet author="databaseLabel" id="0007.0"/>
</databaseChangeLog>


Index incorrectly created as unique
Index incorrectly created as unique

