sapdb

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-sapdb.inc.php

ADONewConnection: Unable to load database driver ''

sybase

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-sybase.inc.php

ADONewConnection: Unable to load database driver ''

mysql

CREATE DATABASE KUTU;
DROP TABLE IF EXISTS KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID                       INTEGER NOT NULL AUTO_INCREMENT,
FIRSTNAME                VARCHAR(30) DEFAULT 'Joan',
LASTNAME                 VARCHAR(28) NOT NULL DEFAULT 'Chen',
averylonglongfieldname   TEXT,
price                    NUMERIC(7,2) DEFAULT 0.00,
MYDATE                   TIMESTAMP,
BIGFELLOW                TEXT,
TS                       TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
)ENGINE=INNODB;
ALTER TABLE KUTU.`KUTU.testtable` ADD  INDEX idx_name  (FIRSTNAME, LASTNAME);
ALTER TABLE KUTU.`KUTU.testtable` ADD  INDEX idx_date  (MYDATE);
ALTER TABLE KUTU.testtable ADD  FULLTEXT INDEX idx  (price, firstname, lastname);
ALTER TABLE KUTU.testtable ADD  INDEX idx2  (price, lastname);
ALTER TABLE KUTU.testtable ADD height DOUBLE;
ALTER TABLE KUTU.testtable ADD weight DOUBLE;
ALTER TABLE KUTU.testtable MODIFY COLUMN height DOUBLE NOT NULL;
ALTER TABLE KUTU.testtable MODIFY COLUMN weight DOUBLE NOT NULL;

mysql

ALTER TABLE KUTU.table DROP COLUMN `my col`;
ALTER TABLE KUTU.table DROP COLUMN `col2_with_Quotes`;
ALTER TABLE KUTU.table DROP COLUMN A_col3;
ALTER TABLE KUTU.table DROP COLUMN `col3(10)`;

CREATE TABLE KUTU.adoxyz (
LASTNAME                 VARCHAR(32)
);

access

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-access.inc.php

ADONewConnection: Unable to load database driver ''

oci8po

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-oci8po.inc.php

ADONewConnection: Unable to load database driver ''

postgres

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-postgres7.inc.php

ADONewConnection: Unable to load database driver ''

odbc_mssql

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-odbc_mssql.inc.php

ADONewConnection: Unable to load database driver ''

odbc

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-odbc.inc.php

ADONewConnection: Unable to load database driver ''

db2

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-db2.inc.php

ADONewConnection: Unable to load database driver ''

firebird

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-firebird.inc.php

ADONewConnection: Unable to load database driver ''

informix

Missing file: /var/www/moto.adagps.com/adagps.com/mobile/core/classes/adodb/drivers/adodb-informix.inc.php

ADONewConnection: Unable to load database driver ''

Test XML Schema

<?xml version="1.0"?>
<schema version="0.3">
  <table name="mytable">
    <field name="row1" type="I">
      <descr>An integer row that's a primary key and autoincrements</descr>
      <KEY/>
      <AUTOINCREMENT/>
    </field>
    <field name="row2" type="C" size="16">
      <descr>A 16 character varchar row that can't be null</descr>
      <NOTNULL/>
    </field>
    <index name="myindex">
      <col>row1</col>
      <col>row2</col>
    </index>
  </table>
  <sql>
    <descr>SQL to be executed only on specific platforms</descr>
    <query platform="postgres|postgres7">
      insert into mytable ( row1, row2 ) values ( 12, 'postgres stuff' )
    </query>
    <query platform="mysql">
      insert into mytable ( row1, row2 ) values ( 12, 'mysql stuff' )
    </query>
	<query platform="mssql">
      insert into mytable ( row1, row2 ) values ( 12, 'Microsoft stuff' )
    </query>
  </sql>
  <table name="obsoletetable">
    <DROP/>
  </table>
</schema>