<project name="ArcSDE test targets" default="test" 
    xmlns:sde="antlib:net.sf.incanto.arcsde">

    <sde:sdeconnection id="sde.conn" 
        host="${db.sde.server}" 
        password="${db.inc.user}" 
        username="${db.inc.pass}"/>

    <sde:tablelist id="tablelist" pattern="${db.inc.user}.se*"/>
 
    <target name="test">
        <sde:registertable connection="sde.conn"
            rowidtype="sde" rowidcolumn="objectid"
            description="Test Business Table"
            minimumid="1"
            multiversioned="true"
            overwrite="true">
            <sde:tablelist refid="tablelist"/>
        </sde:registertable>

        <sde:multiversionview connection="sde.conn"
            replace="true" viewname="MV_@{tablename}">
            <sde:tablelist refid="tablelist"/>
        </sde:multiversionview>

        <sde:createindex connection="sde.conn"
          tablename="SE_TABLE1">
            <indexdef columnlist="fips" unique="false" 
                name="@{tablename}_FIPS"/>
        </sde:createindex>

        <sde:deleteindex connection="sde.conn"
          tablename="SE_TABLE1"
          indexname="@{tablename}_FIPS">
        </sde:deleteindex>

        <sde:unregistertable connection="sde.conn" 
            IgnoreNotRegistered="true"
            DeleteDependendObjects="true">
            <sde:tablelist refid="tablelist"/>
        </sde:unregistertable>

    </target>

</project>