<?xml version="1.0" encoding="ISO-8859-1" ?>
<?xml-stylesheet type="text/xsl" href="xsl/mdb2_changeset.xsl"?>
<instructionset>
  <name>openads</name>
  <version>331</version>
  <comments>Added the missing indexes</comments>
  <constructive>
    <changeset>
      <name>openads</name>
      <version>331</version>
      <change>
        <table>
          <name>affiliates</name>
        <index>
          <add>
            <name>agencyid</name>
            <was>agencyid</was>
            <indexfield>
              <name>agencyid</name>
              <sorting>ascending</sorting>
            </indexfield>
          </add>
        </index>
      </table>
        <table>
          <name>campaigns</name>
        <index>
          <add>
            <name>clientid</name>
            <was>clientid</was>
            <indexfield>
              <name>clientid</name>
              <sorting>ascending</sorting>
            </indexfield>
          </add>
        </index>
      </table>
        <table>
          <name>clients</name>
        <index>
          <add>
            <name>agencyid</name>
            <was>agencyid</was>
            <indexfield>
              <name>agencyid</name>
              <sorting>ascending</sorting>
            </indexfield>
          </add>
        </index>
      </table>
        <table>
          <name>trackers</name>
        <index>
          <add>
            <name>clientid</name>
            <was>clientid</was>
            <indexfield>
              <name>clientid</name>
              <sorting>ascending</sorting>
            </indexfield>
          </add>
        </index>
      </table>
        <table>
          <name>variables</name>
        <index>
          <add>
            <name>variables_is_unique</name>
            <was>variables_is_unique</was>
            <indexfield>
              <name>is_unique</name>
              <sorting>ascending</sorting>
            </indexfield>
          </add>
        </index>
      </table>
        <table>
          <name>variables</name>
        <index>
          <add>
            <name>trackerid</name>
            <was>trackerid</was>
            <indexfield>
              <name>trackerid</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>331</version>
  </changeset>
</destructive>
</instructionset>
