Subversion Repositories DevTools

<?xml version="1.0"?>
<parser>
    <struct name="test_types" sqltablename="TEST_TYPES"  sql="SELECT * FROM TEST_TYPES">
        <field name="f1" sqlcolumnname="TEST_TYPE_ID" datatype="U32" fk="TEST_TYPES_FK"></field>
        <field name="f2" sqlcolumnname="TEST_TYPE_NAME" datatype="ASCII" width="50"></field>
    </struct>
    <struct name="unit_tests" sqltablename="UNIT_TESTS">
        <field name="f1" sqlcolumnname="PV_ID" datatype="U32" fk="PV_ID"></field>
        <field name="f2" sqlcolumnname="TEST_TYPES_FK" datatype="U32"></field>
        <repeat name="r1">
            <field structname="test_types"/>
        </repeat>
    </struct>
    <struct name="package_build_env" sqltablename="PACKAGE_BUILD_ENV">
        <field name="f1" sqlcolumnname="PV_ID" datatype="U32" fk="PV_ID"></field>
        <field name="f2" sqlcolumnname="BE_ID" datatype="U32"></field>
        <field name="f3" sqlcolumnname="BUILD_TYPE" datatype="U32"></field>
    </struct>
    <struct name="package_dependencies" sqltablename="PACKAGE_DEPENDENCIES">
        <field name="f1" sqlcolumnname="PV_ID" datatype="U32" fk="PV_ID"></field>
        <field name="f2" sqlcolumnname="DPV_ID" datatype="U32"></field>
     </struct>
    <struct name="package_versions" sqltablename="PACKAGE_VERSIONS">
        <field name="f1" sqlcolumnname="PV_ID" datatype="U32" fk="PV_ID"></field>
        <field name="f2" sqlcolumnname="PKG_ID" datatype="U32"></field>
        <field name="f3" sqlcolumnname="PKG_VERSION" datatype="ASCII" width="50"></field>
        <field name="f4" sqlcolumnname="DLOCKED" datatype="ASCII" width="1"></field>
        <field name="f5" sqlcolumnname="V_EXT" datatype="ASCII" width="50"></field>
        <field name="f6" sqlcolumnname="PKG_LABEL" datatype="ASCII" width="50"></field>
        <field name="f7" sqlcolumnname="SRC_PATH" datatype="ASCII" width="2000"></field>
        <field name="f8" sqlcolumnname="BUILD_TYPE" datatype="ASCII" width="1"></field>
        <field name="f9" sqlcolumnname="CHANGE_TYPE" datatype="ASCII" width="1"></field>
        <repeat name="r1">
            <field structname="package_dependencies"/>
        </repeat>
        <repeat name="r2">
            <field structname="package_build_env"/>
        </repeat>
        <repeat name="r3">
            <field structname="unit_tests"/>
        </repeat>
      </struct>
      <struct name="release_content" sqltablename="RELEASE_CONTENT">
        <field name="f1" sqlcolumnname="RTAG_ID" datatype="U32" fk="RTAG_ID"></field>
        <field name="f2" sqlcolumnname="PV_ID" datatype="U32"></field>
        <field name="f3" sqlcolumnname="BASE_VIEW_ID" datatype="U32"></field>
        <repeat name="r1">
            <field structname="package_versions"/>
        </repeat>
    </struct>
   <struct name="planned" sqltablename="PLANNED">
        <field name="f1" sqlcolumnname="RTAG_ID" datatype="U32" fk="RTAG_ID"></field>
        <field name="f2" sqlcolumnname="PV_ID" datatype="U32"></field>
        <field name="f3" sqlcolumnname="VIEW_ID" datatype="U32"></field>
        <repeat name="r1">
            <field structname="package_versions"/>
        </repeat>
    </struct>
    <struct name="release_tags" sqltablename="RELEASE_TAGS">
        <field name="f1" sqlcolumnname="RTAG_ID" datatype="U32"></field>
        <field name="f2" sqlcolumnname="PROJ_ID" datatype="U32" fk="PROJ_ID"></field>
        <field name="f3" sqlcolumnname="RTAG_NAME" datatype="ASCII" width="50"></field>
        <field name="f4" sqlcolumnname="OFFICIAL" datatype="ASCII" width="1"></field>
        <repeat name="r1">
            <field structname="release_content"/>
        </repeat>
        <repeat name="r2">
            <field structname="planned"/>
        </repeat>
    </struct>
   <struct name="package_versions2" sqltablename="PACKAGE_VERSIONS2">
        <field name="f1" sqlcolumnname="PKG_ID" datatype="U32"></field>
        <field name="f2" sqlcolumnname="PKG_VERSION" datatype="ASCII" width="50"></field>
  </struct>
   <struct name="views" sqltablename="VIEWS" sql="SELECT * FROM VIEWS WHERE BASE_VIEW='Y'">
        <field name="f1" sqlcolumnname="VIEW_ID" datatype="U32"></field>
        <field name="f2" sqlcolumnname="VIEW_NAME" datatype="ASCII" width="30"></field>
    </struct>
    <struct name="build_environments" sqltablename="BUILD_ENVIRONMENTS" sql="SELECT * FROM BUILD_ENVIRONMENTS">
        <field name="f1" sqlcolumnname="BE_ID" datatype="U32"></field>
        <field name="f2" sqlcolumnname="BE_NAME" datatype="ASCII" width="255"></field>
    </struct>
    <struct name="packages" sqltablename="PACKAGES" sql="SELECT * FROM PACKAGES">
        <field name="f1" sqlcolumnname="PKG_ID" datatype="U32"></field>
        <field name="f2" sqlcolumnname="PKG_NAME" datatype="ASCII" width="50"></field>
    </struct>
    <struct name="projects" sqltablename="PROJECTS" sql="SELECT * FROM PROJECTS">
        <field name="f1" sqlcolumnname="PROJ_ID" datatype="U32"></field>
        <field name="f2" sqlcolumnname="PROJ_NAME" datatype="ASCII" width="50"></field>
        <repeat name="r1">
            <field structname="release_tags"/>
        </repeat>
    </struct>
</parser>