<?xml version="1.0" encoding="ISO-8859-1" ?>
<?xml-stylesheet type="text/xsl" href="xsl/mdb2_changeset.xsl"?>
<instructionset>
  <name>openads</name>
  <version>127</version>
  <comments>Added missing columns to upgrade from 2.0 to 2.3.</comments>
  <constructive>
    <changeset>
      <name>openads</name>
      <version>127</version>
      <change>
        <table>
          <name>zones</name>
          <add>
            <field>
              <name>category</name>
              <type>openads_text</type>
              <notnull>1</notnull>
              <default></default>
              <was>category</was>
            </field>
              <field>
                <name>ad_selection</name>
                <type>openads_text</type>
                <notnull>1</notnull>
                <default></default>
                <was>ad_selection</was>
              </field>
                <field>
                  <name>forceappend</name>
                  <type>openads_enum</type>
                  <length>&apos;t&apos;,&apos;f&apos;</length>
                  <notnull></notnull>
                  <default>f</default>
                  <was>forceappend</was>
                </field>
                  <field>
                    <name>inventory_forecast_type</name>
                    <type>openads_smallint</type>
                    <length>6</length>
                    <notnull>1</notnull>
                    <default>0</default>
                    <was>inventory_forecast_type</was>
                  </field>
                    <field>
                      <name>comments</name>
                      <type>openads_text</type>
                      <notnull></notnull>
                      <default></default>
                      <was>comments</was>
                    </field>
                      <field>
                        <name>cost</name>
                        <type>openads_decimal</type>
                        <length>10,4</length>
                        <notnull></notnull>
                        <default></default>
                        <was>cost</was>
                      </field>
                        <field>
                          <name>cost_type</name>
                          <type>openads_smallint</type>
                          <length>6</length>
                          <notnull></notnull>
                          <default></default>
                          <was>cost_type</was>
                        </field>
                          <field>
                            <name>cost_variable_id</name>
                            <type>openads_varchar</type>
                            <length>255</length>
                            <notnull>1</notnull>
                            <default></default>
                            <was>cost_variable_id</was>
                          </field>
                            <field>
                              <name>technology_cost</name>
                              <type>openads_decimal</type>
                              <length>10,4</length>
                              <notnull></notnull>
                              <was>technology_cost</was>
                              <default></default>
                            </field>
                              <field>
                                <name>technology_cost_type</name>
                                <type>openads_smallint</type>
                                <length>6</length>
                                <notnull></notnull>
                                <default></default>
                                <was>technology_cost_type</was>
                              </field>
                                <field>
                                  <name>updated</name>
                                  <type>openads_datetime</type>
                                  <notnull></notnull>
                                  <default></default>
                                  <was>updated</was>
                                </field>
                                  <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>
                                </change>
                              </changeset>
                            </constructive>
                            <destructive>
                              <changeset>
                                <name>openads</name>
                                <version>127</version>
                              </changeset>
                            </destructive>
                          </instructionset>
