<?xml version="1.0" encoding="ISO-8859-1" ?>
<?xml-stylesheet type="text/xsl" href="xsl/mdb2_changeset.xsl"?>
<instructionset>
  <name>openads</name>
  <version>506</version>
  <comments></comments>
  <constructive>
    <changeset>
      <name>openads</name>
      <version>506</version>
      <change>
    <table>
    <name>campaigns</name>
    <add>
      <field>
        <name>block</name>
        <type>openads_int</type>
        <length>11</length>
        <notnull>1</notnull>
        <default>0</default>
        <was>block</was>
      </field>
        <field>
          <name>capping</name>
          <type>openads_int</type>
          <length>11</length>
          <notnull>1</notnull>
          <default>0</default>
          <was>capping</was>
        </field>
          <field>
            <name>session_capping</name>
            <type>openads_int</type>
            <length>11</length>
            <notnull>1</notnull>
            <default>0</default>
            <was>session_capping</was>
          </field>
        </add>
    </table>
    <table>
      <name>data_intermediate_ad_connection</name>
      <add>
        <field>
          <name>tracker_channel_ids</name>
          <type>openads_varchar</type>
          <length>64</length>
          <notnull></notnull>
          <default></default>
          <was>tracker_channel_ids</was>
        </field>
          <field>
            <name>connection_channel_ids</name>
            <type>openads_varchar</type>
            <length>64</length>
            <notnull></notnull>
            <default></default>
            <was>connection_channel_ids</was>
          </field>
        </add>
      </table>
        <table>
          <name>data_raw_ad_click</name>
          <add>
            <field>
              <name>channel_ids</name>
              <type>openads_varchar</type>
              <length>64</length>
              <notnull></notnull>
              <default></default>
              <was>channel_ids</was>
            </field>
          </add>
        </table>
          <table>
            <name>data_raw_ad_impression</name>
            <add>
              <field>
                <name>channel_ids</name>
                <type>openads_varchar</type>
                <length>64</length>
                <notnull></notnull>
                <default></default>
                <was>channel_ids</was>
              </field>
            </add>
          </table>
            <table>
              <name>data_raw_ad_request</name>
              <add>
                <field>
                  <name>channel_ids</name>
                  <type>openads_varchar</type>
                  <length>64</length>
                  <notnull></notnull>
                  <default></default>
                  <was>channel_ids</was>
                </field>
              </add>
            </table>
              <table>
                <name>data_raw_tracker_click</name>
                <add>
                  <field>
                    <name>channel_ids</name>
                    <type>openads_varchar</type>
                    <length>64</length>
                    <notnull></notnull>
                    <default></default>
                    <was>channel_ids</was>
                  </field>
                </add>
              </table>
                <table>
                  <name>data_raw_tracker_impression</name>
                  <add>
                    <field>
                      <name>channel_ids</name>
                      <type>openads_varchar</type>
                      <length>64</length>
                      <notnull></notnull>
                      <default></default>
                      <was>channel_ids</was>
                    </field>
                  </add>
                </table>
        </change>
      </changeset>
    </constructive>
    <destructive>
      <changeset>
        <name>openads</name>
        <version>506</version>
      </changeset>
    </destructive>
  </instructionset>
