All pastes #717200 Raw Edit

Miscellany

public text v1 · immutable
#717200 ·published 2007-09-27 13:31 UTC
rendered paste body
        $options = array('create' => 0, 'name' => 'ticket');
        $dsn = 'sqlite://test.sqlite';
        $schema = MDB2_Schema::factory($dsn, $options);
        if (PEAR::isError($schema)) {
            echo $schema->getMessage();
        }
        $definition = $schema->parseDatabaseDefinitionFile(dirname(__FILE__) . '/schema.xml');

        if (PEAR::isError($definition)) {
            echo $definition->getMessage();

        } else {

            $op = $schema->updateDatabase($definition, false, array('create' => '0', 'name' => 'ticket'));
            echo 'her';
        }


<?xml version="1.0" encoding="ISO-8859-1" ?>
<database>

 <name>test.sqlite</name>
 <create>true</create>
 <overwrite>true</overwrite>

 <table>

  <name>message</name>

  <declaration>

   <field>
    <name>id</name>
    <type>integer</type>
    <unsigned>true</unsigned>
    <length>4</length>
    <notnull>true</notnull>
    <default>0</default>
   </field>

   <field>
    <name>received_on</name>
    <type>timestamp</type>
    <notnull>true</notnull>
    <default>0000-00-00 00:00:00</default>
   </field>

   <field>
    <name>subject</name>
    <type>text</type>
    <length>255</length>
    <notnull>true</notnull>
    <default></default>
   </field>

   <index>
    <name>id_pKey</name>
    <primary>true</primary>
    <field>
     <name>id</name>
     <sorting>ascending</sorting>
    </field>
   </index>

  </declaration>

 </table>

</database>