mysql

CREATE DATABASE KUTU;
DROP TABLE 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 LONGTEXT,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           TIMESTAMP,
BIGFELLOW        LONGTEXT,
TS               TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
)TYPE=ISAM;
CREATE FULLTEXT INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (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;

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in C:\ms4w\apps\chameleon\htdocs\common\adodb\drivers\adodb-mysql.inc.php on line 235

Notice: Only variable references should be returned by reference in C:\ms4w\apps\chameleon\htdocs\common\adodb\adodb.inc.php on line 773

Notice: Only variable references should be returned by reference in C:\ms4w\apps\chameleon\htdocs\common\adodb\drivers\adodb-mysql.inc.php on line 281
CREATE TABLE adoxyz (
ID               INTEGER NOT NULL AUTO_INCREMENT,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) NOT NULL DEFAULT 'Chen',
averylonglongfieldname LONGTEXT,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           TIMESTAMP,
BIGFELLOW        LONGTEXT,
TS               TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);

access

Warning: Access does not supported DEFAULT values (field FIRSTNAME)
Warning: Access does not supported DEFAULT values (field LASTNAME)
Warning: Access does not supported DEFAULT values (field price)
Warning: Access does not supported DEFAULT values (field MYDATE)
Warning: Access does not supported DEFAULT values (field TS)
AlterColumnSQL not supported

DROP TABLE testtable;
CREATE TABLE testtable (
ID               COUNTER,
FIRSTNAME        VARCHAR(30),
LASTNAME         VARCHAR(28) NOT NULL,
averylonglongfieldname MEMO,
price            NUMERIC(7,2),
MYDATE           DATETIME,
BIGFELLOW        MEMO,
TS               DATETIME,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON testtable (firstname,lastname);
CREATE INDEX idx2 ON testtable (price,lastname);
ALTER TABLE testtable  ADD height           DOUBLE;
ALTER TABLE testtable  ADD weight           DOUBLE;

oci8


Notice: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS' in C:\ms4w\apps\chameleon\htdocs\common\adodb\adodb.inc.php on line 3274

CREATE USER KUTU IDENTIFIED BY tiger;
/
GRANT CREATE SESSION, CREATE TABLE,UNLIMITED TABLESPACE,CREATE SEQUENCE TO KUTU;
/
DROP TABLE KUTU.testtable CASCADE CONSTRAINTS;
/
drop sequence seq_KUTU.testtable;
/
CREATE TABLE KUTU.testtable (
ID               DECIMAL(10) NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname VARCHAR(4000),
price            DECIMAL(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT TRUNC(SYSDATE),
BIGFELLOW        VARCHAR(4000),
TS               DATE DEFAULT SYSDATE,
                 PRIMARY KEY (ID, LASTNAME)
)TABLESPACE USERS;
/
DROP SEQUENCE KUTU.SEQ_testtable;
/
CREATE SEQUENCE KUTU.SEQ_testtable;
/
CREATE OR REPLACE TRIGGER KUTU.TRIG_SEQ_testtable BEFORE insert ON KUTU.testtable 
		FOR EACH ROW
		BEGIN
		  select KUTU.SEQ_testtable.nextval into :new.ID from dual;
		END;;
/
CREATE BITMAP INDEX idx ON KUTU.testtable (firstname,lastname);
/
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
/
ALTER TABLE testtable ADD (
 height           DECIMAL,
 weight           DECIMAL);
/
ALTER TABLE testtable MODIFY(
 height           DECIMAL NOT NULL,
 weight           DECIMAL NOT NULL);
/

postgres

AlterColumnSQL not supported for PostgreSQL

CREATE DATABASE KUTU LOCATION='/u01/postdata';
DROP TABLE KUTU.testtable;
drop sequence KUTU.testtable_m_id_seq;
CREATE TABLE KUTU.testtable (
ID               SERIAL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname TEXT,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT CURRENT_DATE,
BIGFELLOW        TEXT,
TS               TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON KUTU.testtable USING HASH (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD height           FLOAT8;
ALTER TABLE KUTU.testtable  ADD weight           FLOAT8;

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? in C:\ms4w\apps\chameleon\htdocs\common\adodb\drivers\adodb-postgres64.inc.php on line 478

Notice: Only variable references should be returned by reference in C:\ms4w\apps\chameleon\htdocs\common\adodb\adodb.inc.php on line 773

Notice: Only variable references should be returned by reference in C:\ms4w\apps\chameleon\htdocs\common\adodb\drivers\adodb-postgres64.inc.php on line 362
CREATE TABLE adoxyz (
ID               SERIAL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname TEXT,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT CURRENT_DATE,
BIGFELLOW        TEXT,
TS               TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);

odbc_mssql

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               INT IDENTITY(1,1) NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname TEXT NULL,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           DATETIME DEFAULT GetDate(),
BIGFELLOW        TEXT NULL,
TS               DATETIME DEFAULT GetDate(),
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE CLUSTERED INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD
 height           REAL NULL,
 weight           REAL NULL;
ALTER TABLE KUTU.testtable  ALTER COLUMN height           REAL NOT NULL;
ALTER TABLE KUTU.testtable  ALTER COLUMN weight           REAL NOT NULL;

odbc

AlterColumnSQL not supported

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               DECIMAL(10) NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname VARCHAR(250),
price            DECIMAL(7,2) DEFAULT 0.00,
MYDATE           DATE,
BIGFELLOW        VARCHAR(250),
TS               DATE,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD height           DECIMAL(32,8);
ALTER TABLE KUTU.testtable  ADD weight           DECIMAL(32,8);

sybase