<?xml version="1.0" encoding="ISO-8859-1" ?>
<?xml-stylesheet type="text/xsl" href="xsl/mdb2_changeset.xsl"?>
<instructionset>
  <name>openads</name>
  <version>129.34a</version>
  <comments>adds missing indexes for 2.3.34-beta</comments>
  <constructive>
    <changeset>
      <name>openads</name>
      <version>129.34a</version>
      <change>
          <table>
            <name>affiliates</name>
          <index>
            <add>
              <name>affiliates_agencyid</name>
              <was>affiliates_agencyid</was>
              <indexfield>
                <name>agencyid</name>
                <sorting>ascending</sorting>
              </indexfield>
            </add>
          </index>
      </table>
        <table>
          <name>banners</name>
        <index>
          <add>
            <name>banners_campaignid</name>
            <was>banners_campaignid</was>
            <indexfield>
              <name>campaignid</name>
              <sorting>ascending</sorting>
            </indexfield>
          </add>
        </index>
    </table>
      <table>
        <name>clients</name>
      <index>
        <add>
          <name>clients_agencyid</name>
          <was>clients_agencyid</was>
          <indexfield>
            <name>agencyid</name>
            <sorting>ascending</sorting>
          </indexfield>
        </add>
      </index>
  </table>
        <table>
          <name>zones</name>
        <index>
          <add>
            <name>affiliateid</name>
            <was>affiliateid</was>
            <indexfield>
              <name>affiliateid</name>
              <sorting>ascending</sorting>
            </indexfield>
          </add>
        </index>
      </table>
        </change>
      </changeset>
    </constructive>
    <destructive>
      <changeset>
        <name>openads</name>
        <version>129.34a</version>
      </changeset>
    </destructive>
  </instructionset>
