<Databases>
  <Database>
    <Tables>
      <Table Name="T_DEVICE_SCHEDULE" Schema="AKUZ">
        <DropColumns>
          <Column Name="MedicalServicePrgDeviceLink" />
        </DropColumns>
        <DropForeignKeys>
          <ForeignKey Name="FK_T_MEDICAL_SERVICE_PRG_DEVICE_LINK_T_DEVICE_SCHEDULE_MedicalServicePrgDeviceLink" ShortName="FK_T_MEDICAL_SERVICE_PRG_DEVICE_LINK_T_DEVICE_SCHEDULE_E1DC2493" />
        </DropForeignKeys>
        <AddColumns>
            <Column Name="DeviceScheduleList" Type="guid" IsNullable="1" />
          </AddColumns>
          <ForeignKeys>
            <ForeignKey Name="FK_T_DEVICE_SCHEDULE_LIST_T_DEVICE_SCHEDULE_DeviceScheduleList" Column="DeviceScheduleList" Table="T_DEVICE_SCHEDULE_LIST" TableSchema="AKUZ" TableColumn="DeviceScheduleListID" CascadeDelete="0" CascadeUpdate="0" />
          </ForeignKeys>
      </Table>
      <Table Name="T_DEVICE_SCHEDULE_LIST" Schema="AKUZ">
        <Columns>
          <Column Name="DateBegin" Type="date" IsNullable="0" />
          <Column Name="DateEnd" Type="date" IsNullable="0" />
          <Column Name="DeviceScheduleListID" Type="guid" IsNullable="0" />
          <Column Name="DayType" Type="int" IsNullable="0" />
          <Column Name="WeekType" Type="int" IsNullable="0" />
          <Column Name="MedicalServicePrgDeviceLink" Type="guid" IsNullable="0" />
        </Columns>
        <PrimaryKey Name="PK_T_DEVICE_SCHEDULE_LIST" Clustered="1">
          <Column Name="DeviceScheduleListID" />
        </PrimaryKey>
        <ForeignKeys>
          <ForeignKey Name="FK_T_MEDICAL_SERVICE_PRG_DEVICE_LINK_T_DEVICE_SCHEDULE_LIST_MedicalServicePrgDeviceLink" ShortName="FK_T_MEDICAL_SERVICE_PRG_DEVICE_LINK_T_DEVICE_SCHEDULE_FD337031" Column="MedicalServicePrgDeviceLink" Table="T_MEDICAL_SERVICE_PRG_DEVICE_LINK" TableSchema="AKUZ" TableColumn="MedicalServicePrgDeviceLinkID" CascadeDelete="0" CascadeUpdate="0" />
        </ForeignKeys>
      </Table>
    </Tables>
  </Database>
</Databases>