<?xml version="1.0" encoding="Windows-1251"?>
<data>
  <branches>
    <row>
      <id_branch> 0 </id_branch>
      <name>Офис  1 </name>
    </row>
    <row>
      <id_branch> 1 </id_branch>
      <name>Офис  2 </name>
    </row>
    <row>
      <id_branch> 2 </id_branch>
      <name>Офис  3 </name>
    </row>
    <row>
      <id_branch> 3 </id_branch>
      <name>Офис  4 </name>
    </row>
  </branches>
  <employees>
    <row>
       <ID_EMPLOYEE> 1112 </ID_EMPLOYEE>
       <NUMBER></NUMBER>
       <LAST_NAME>Иванов</LAST_NAME>
       <FIRST_NAME>Иван</FIRST_NAME>
       <MIDDLE_NAME>Иванович</MIDDLE_NAME>
       <USER_GROUPS_NAMES>Администратор</USER_GROUPS_NAMES>
       <ID_BRANCH> 1 </ID_BRANCH>
       <ID_GROUP> 2 </ID_GROUP>
       <ID_BOSS> 1112 </ID_BOSS>
       <ENABLED> 1 </ENABLED>
       <CELL_PHONE> 9020000000 </CELL_PHONE>
       <PHONE_1> 2274812 </PHONE_1>
    </row>
    <row>
       <ID_EMPLOYEE> 3207 </ID_EMPLOYEE>
       <NUMBER> 1 </NUMBER>
       <LAST_NAME>Сидоров</LAST_NAME>
       <FIRST_NAME>Сидор</FIRST_NAME>
       <MIDDLE_NAME>Сидорович</MIDDLE_NAME>
       <USER_GROUPS_NAMES>Риэлтер</USER_GROUPS_NAMES>
       <ID_BRANCH> 1 </ID_BRANCH>
       <ID_GROUP> 1 </ID_GROUP>
       <ID_BOSS> 1112 </ID_BOSS>
       <ENABLED> 1 </ENABLED>
       <CELL_PHONE></CELL_PHONE>
       <PHONE_1></PHONE_1>
    </row>
    <row>
       <ID_EMPLOYEE> 3007 </ID_EMPLOYEE>
       <NUMBER> 34 </NUMBER>
       <LAST_NAME>Петров</LAST_NAME>
       <FIRST_NAME>Петр</FIRST_NAME>
       <MIDDLE_NAME>Петрович</MIDDLE_NAME>
       <USER_GROUPS_NAMES>Риэлтер</USER_GROUPS_NAMES>
       <ID_BRANCH> 2 </ID_BRANCH>
       <ID_GROUP> 1 </ID_GROUP>
       <ID_BOSS> 1112 </ID_BOSS>
       <ENABLED> 1 </ENABLED>
       <CELL_PHONE></CELL_PHONE>
       <PHONE_1></PHONE_1>
    </row>
  </employees>
</data>

<?xml version="1.0" ?>
<Schema xmlns="urn:schemas-microsoft-com:xml-data" 
        xmlns:dt="urn:schemas-microsoft-com:xml:datatypes"  
        xmlns:sql="urn:schemas-microsoft-com:xml-sql" > 

   <ElementType name="id_branch" dt:type="int" />
   <ElementType name="name" dt:type="string" />

   <ElementType name="row"  sql:relation="bases_otdel">
      <element type="id_branch" sql:field="id" />
      <element type="name" sql:field="name" />
   </ElementType>

   <ElementType name="branches" sql:is-constant="1">
      <element type="row" />
   </ElementType>

   <ElementType name="data" sql:is-constant="1">
      <element type="branches" />
   </ElementType>
</Schema>