<?xml version="1.0" encoding="ISO-8859-1" ?>
<?xml-stylesheet type="text/xsl" href="xsl/mdb2_changeset.xsl"?>
<instructionset>
  <name>openads</name>
  <version>543</version>
  <comments>UAPP Step 1</comments>
  <constructive>
    <changeset>
      <name>openads</name>
      <version>543</version>
      <add>
        <table>
        <name>account_user_assoc</name>
        <was>account_user_assoc</was>
      </table>
        <table>
        <name>account_user_permission_assoc</name>
        <was>account_user_permission_assoc</was>
      </table>
        <table>
        <name>accounts</name>
        <was>accounts</was>
      </table>
        <table>
        <name>users</name>
        <was>users</was>
      </table>
    </add>
    <change>
      <table>
        <name>affiliates</name>
        <add>
          <field>
            <name>account_id</name>
            <type>openads_mediumint</type>
            <length>9</length>
            <notnull></notnull>
            <default></default>
            <was>account_id</was>
          </field>
        </add>
        <index>
          <add>
            <name>account_id</name>
            <was>account_id</was>
            <unique>true</unique>
            <indexfield>
              <name>account_id</name>
              <sorting>ascending</sorting>
            </indexfield>
          </add>
        </index>
      </table>
        <table>
          <name>agency</name>
          <add>
            <field>
              <name>account_id</name>
              <type>openads_mediumint</type>
              <length>9</length>
              <notnull></notnull>
              <default></default>
              <was>account_id</was>
            </field>
          </add>
          <index>
            <add>
              <name>account_id</name>
              <was>account_id</was>
              <unique>true</unique>
              <indexfield>
                <name>account_id</name>
                <sorting>ascending</sorting>
              </indexfield>
            </add>
          </index>
        </table>
          <table>
            <name>clients</name>
            <add>
              <field>
                <name>account_id</name>
                <type>openads_mediumint</type>
                <length>9</length>
                <notnull></notnull>
                <default></default>
                <was>account_id</was>
              </field>
            </add>
            <index>
              <add>
                <name>account_id</name>
                <was>account_id</was>
                <unique>true</unique>
                <indexfield>
                  <name>account_id</name>
                  <sorting>ascending</sorting>
                </indexfield>
              </add>
            </index>
          </table>
        </change>
      </changeset>
    </constructive>
    <destructive>
      <changeset>
        <name>openads</name>
        <version>543</version>
      </changeset>
    </destructive>
  </instructionset>
