Hack23/cia

<?xml version="1.0" encoding="UTF-8"?>
<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.6.xsd">

    <changeSet author="auditViews" id="1414872417007-313" failOnError="true">
        
    <createView
            viewName="view_audit_data_summary">select min(snapshot_pk) as id,managed_type as data_type,count(*) as size from jv_snapshot where type='INITIAL' group by managed_type order by managed_type</createView>

    <createView
            viewName="view_audit_author_summary">select min(commit_pk) as id,author,count(*) as changes,min(commit_date) as first_date,max(commit_date) as last_date from jv_commit group by author</createView>                        
    </changeSet>

    <changeSet author="auditViews2" id="1414872417007-314" failOnError="true">
        
    <dropView viewName="view_audit_data_summary" /> <createView
            viewName="view_audit_data_summary">select min(snapshot_pk) as id,managed_type as data_type,count(*) as data_size from jv_snapshot where type='INITIAL' group by managed_type order by managed_type</createView>

    </changeSet>




</databaseChangeLog>