<?xml version="1.0" encoding="ISO-8859-1" ?>
<?xml-stylesheet type="text/xsl" href="xsl/mdb2_changeset.xsl"?>
<instructionset>
  <name>openads</name>
  <version>124</version>
  <comments>Added changes required for upgrade from 2.0 schema to 2.3 schema.</comments>
  <constructive>
    <changeset>
      <name>openads</name>
      <version>124</version>
      <change>
        <table>
          <name>banners</name>
          <add>
            <field>
              <name>campaignid</name>
              <type>openads_mediumint</type>
              <length>9</length>
              <notnull>1</notnull>
              <default>0</default>
              <was>campaignid</was>
            </field>
              <field>
                <name>adserver</name>
                <type>openads_varchar</type>
                <length>50</length>
                <notnull>1</notnull>
                <default></default>
                <was>adserver</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>
                  <field>
                    <name>acl_plugins</name>
                    <type>openads_text</type>
                    <notnull>1</notnull>
                    <default></default>
                    <was>acl_plugins</was>
                  </field>
                    <field>
                      <name>alt_filename</name>
                      <type>openads_varchar</type>
                      <length>255</length>
                      <notnull>1</notnull>
                      <default></default>
                      <was>alt_filename</was>
                    </field>
                      <field>
                        <name>alt_imageurl</name>
                        <type>openads_varchar</type>
                        <length>255</length>
                        <notnull>1</notnull>
                        <default></default>
                        <was>alt_imageurl</was>
                      </field>
                        <field>
                          <name>alt_contenttype</name>
                          <type>openads_enum</type>
                          <length>&apos;gif&apos;,&apos;jpg&apos;,&apos;png&apos;</length>
                          <notnull>1</notnull>
                          <default>gif</default>
                          <was>alt_contenttype</was>
                        </field>
                          <field>
                            <name>comments</name>
                            <type>openads_text</type>
                            <notnull></notnull>
                            <default></default>
                            <was>comments</was>
                          </field>
                            <field>
                              <name>updated</name>
                              <type>openads_datetime</type>
                              <notnull></notnull>
                              <default></default>
                              <was>updated</was>
                            </field>
                          </add>
                          <change>
                            <field>
                              <name>target</name>
                              <length>16</length>
                            </field>
                            <field>
                              <name>url</name>
                              <length></length>
                            </field>
                          </change>
                        </table>
                      </change>
                    </changeset>
                  </constructive>
                  <destructive>
                    <changeset>
                      <name>openads</name>
                      <version>124</version>
                      <change>
                        <table>
                          <name>banners</name>
                        <remove>
                          <field>
                            <name>clientid</name>
                          </field>
                            <field>
                              <name>priority</name>
                            </field>
                          </remove>
                        </table>
                      </change>
                    </changeset>
                  </destructive>
                </instructionset>
