sapdb

Strict Standards: Declaration of ADODB2_sapdb::AlterColumnSQL() should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-sapdb.inc.php on line 119

Strict Standards: Declaration of ADODB2_sapdb::DropColumnSQL() should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-sapdb.inc.php on line 119

Strict Standards: Declaration of ADODB2_sapdb::_CreateSuffix() should be compatible with ADODB_DataDict::_CreateSuffix($fname, $ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint) in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-sapdb.inc.php on line 119

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID                       INTEGER NOT NULL DEFAULT SERIAL,
FIRSTNAME                VARCHAR(30) DEFAULT 'Joan',
LASTNAME                 VARCHAR(28) NOT NULL DEFAULT 'Chen',
averylonglongfieldname   LONG,
price                    FIXED(7,2) DEFAULT 0.00,
MYDATE                   DATE DEFAULT DATE,
BIGFELLOW                LONG,
TS                       TIMESTAMP DEFAULT TIMESTAMP,
                 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 FLOAT(38), weight FLOAT(38));
ALTER TABLE KUTU.testtable MODIFY (height FLOAT(38) NOT NULL, weight FLOAT(38) NOT NULL);

sapdb

ALTER TABLE KUTU.table DROP ("my col", "col2_with_Quotes", A_col3, "col3(10)");

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

sybase

Strict Standards: Declaration of ADODB2_sybase::AlterColumnSQL() should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-sybase.inc.php on line 227

Strict Standards: Declaration of ADODB2_sybase::DropColumnSQL() should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-sybase.inc.php on line 227

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID                       INT DEFAULT AUTOINCREMENT 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 NULL,
                 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;

sybase

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

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

mysqlt

Strict Standards: Declaration of ADODB2_mysql::_CreateSuffix() should be compatible with ADODB_DataDict::_CreateSuffix($fname, $ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint) in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-mysql.inc.php on line 180

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)
)TYPE=INNODB;
ALTER TABLE KUTU.testtable ADD  FULLTEXT INDEX idx  (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

Strict Standards: Declaration of ADODB2_access::AlterColumnSQL() should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-access.inc.php on line 92

Strict Standards: Declaration of ADODB2_access::DropColumnSQL() should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-access.inc.php on line 92

Strict Standards: Declaration of ADODB2_access::_CreateSuffix() should be compatible with ADODB_DataDict::_CreateSuffix($fname, $ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint) in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-access.inc.php on line 92

Strict Standards: Non-static method ADOConnection::outp() should not be called statically, assuming $this from incompatible context in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-access.inc.php on line 62
Warning: Access does not supported DEFAULT values (field FIRSTNAME)

Strict Standards: Non-static method ADOConnection::outp() should not be called statically, assuming $this from incompatible context in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-access.inc.php on line 62
Warning: Access does not supported DEFAULT values (field LASTNAME)

Strict Standards: Non-static method ADOConnection::outp() should not be called statically, assuming $this from incompatible context in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-access.inc.php on line 62
Warning: Access does not supported DEFAULT values (field price)

Strict Standards: Non-static method ADOConnection::outp() should not be called statically, assuming $this from incompatible context in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-access.inc.php on line 62
Warning: Access does not supported DEFAULT values (field MYDATE)

Strict Standards: Non-static method ADOConnection::outp() should not be called statically, assuming $this from incompatible context in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-access.inc.php on line 62
Warning: Access does not supported DEFAULT values (field TS)

Strict Standards: Non-static method ADOConnection::outp() should not be called statically, assuming $this from incompatible context in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-access.inc.php on line 81
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;

access

CREATE TABLE adoxyz (
LASTNAME                 VARCHAR(32)
);

oci8

Notice: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS' in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\adodb.inc.php on line 3738

Strict Standards: Declaration of ADODB2_oci8::MetaType() should be compatible with ADODB_DataDict::MetaType($t, $len = -1, $fieldobj = false) in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-oci8.inc.php on line 281

Strict Standards: Declaration of ADODB2_oci8::AlterColumnSQL() should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-oci8.inc.php on line 281

Strict Standards: Declaration of ADODB2_oci8::DropColumnSQL() should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-oci8.inc.php on line 281

Strict Standards: Declaration of ADODB2_oci8::_CreateSuffix() should be compatible with ADODB_DataDict::_CreateSuffix($fname, $ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint) in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-oci8.inc.php on line 281

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 KUTU.seq_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 WHEN (NEW.ID IS NULL OR NEW.ID = 0) 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);
/

oci8

ALTER TABLE table DROP("my col", "col2_with_Quotes", A_col3, "col3(10)") CASCADE CONSTRAINTS;
/

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

postgres

Strict Standards: Declaration of ADODB2_postgres::_CreateSuffix() should be compatible with ADODB_DataDict::_CreateSuffix($fname, $ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint) in D:\Apache24BF\htdocs\MagicExpo_PortaleVisitatori\modules\Ticket\TLite\bestunion_sync\framework\adodb\datadict\datadict-postgres.inc.php on line 370