Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ADODB_Cache_File has a deprecated constructor in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 233

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ADOConnection has a deprecated constructor in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 327

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ADORecordSet has a deprecated constructor in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 2851

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; ADORecordSet_array has a deprecated constructor in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 3869

sapdb


Warning: Use of undefined constant ODBC_BINMODE_RETURN - assumed 'ODBC_BINMODE_RETURN' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 4230

Warning: Use of undefined constant SQL_CUR_USE_DRIVER - assumed 'SQL_CUR_USE_DRIVER' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 4230

Warning: Use of undefined constant ODBC_BINMODE_RETURN - assumed 'ODBC_BINMODE_RETURN' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 4230

Warning: Use of undefined constant SQL_CUR_USE_DRIVER - assumed 'SQL_CUR_USE_DRIVER' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 4230

Warning: Declaration of ADODB2_sapdb::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-sapdb.inc.php on line 103

Warning: Declaration of ADODB2_sapdb::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-sapdb.inc.php on line 111

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_SECS                  TIMESTAMP DEFAULT TIMESTAMP,
TS_SUBSEC                TIMESTAMP DEFAULT TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME);
CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME);
CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE);
CREATE INDEX idx ON KUTU.testtable (price, 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


Warning: Declaration of ADODB2_sybase::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-sybase.inc.php on line 90

Warning: Declaration of ADODB2_sybase::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-sybase.inc.php on line 102

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_SECS                  DATETIME NULL,
TS_SUBSEC                DATETIME NULL,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME);
CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME);
CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE);
CREATE CLUSTERED INDEX idx ON KUTU.testtable (price, 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
);

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_SECS                  TIMESTAMP,
TS_SUBSEC                TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
)ENGINE=INNODB;
ALTER TABLE KUTU.`KUTU.testtable` ADD  INDEX idx_name  (FIRSTNAME);
ALTER TABLE KUTU.`KUTU.testtable` ADD  INDEX idx_lastname  (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


Warning: Declaration of ADODB2_access::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-access.inc.php on line 80

Warning: Declaration of ADODB2_access::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-access.inc.php on line 87
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_SECS)
Warning: Access does not supported DEFAULT values (field TS_SUBSEC)
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_SECS                  DATETIME,
TS_SUBSEC                DATETIME,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx_name ON testtable (FIRSTNAME);
CREATE INDEX idx_lastname ON testtable (LASTNAME);
CREATE INDEX idx_date ON testtable (MYDATE);
CREATE INDEX idx ON testtable (price, firstname, lastname);
CREATE INDEX idx2 ON testtable (price, lastname);
ALTER TABLE testtable ADD height DOUBLE;
ALTER TABLE testtable ADD weight DOUBLE;

access
DropColumnSQL not supported

CREATE TABLE adoxyz (
LASTNAME                 VARCHAR(32)
);

oci8po


Warning: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 4230

Warning: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 4230

Warning: Declaration of ADODB2_oci8::MetaType($t, $len = -1) should be compatible with ADODB_DataDict::MetaType($t, $len = -1, $fieldobj = false) in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-oci8.inc.php on line 27

Warning: Declaration of ADODB2_oci8::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-oci8.inc.php on line 131

Warning: Declaration of ADODB2_oci8::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-oci8.inc.php on line 144

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                       NUMBER(10) NOT NULL,
FIRSTNAME                VARCHAR(30) DEFAULT 'Joan',
LASTNAME                 VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname   VARCHAR(4000),
price                    NUMBER(7,2) DEFAULT 0.00,
MYDATE                   DATE DEFAULT TRUNC(SYSDATE),
BIGFELLOW                VARCHAR(4000),
TS_SECS                  DATE DEFAULT SYSDATE,
TS_SUBSEC                TIMESTAMP DEFAULT SYSDATE,
                 PRIMARY KEY (ID, LASTNAME)
)TABLESPACE USERS;
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 INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME);
CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME);
CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE);
CREATE BITMAP INDEX idx ON KUTU.testtable (price, firstname, lastname);
CREATE INDEX idx2 ON KUTU.testtable (price, lastname);
ALTER TABLE testtable ADD (
 height NUMBER, 
 weight NUMBER);
ALTER TABLE testtable MODIFY(
 height NUMBER NOT NULL, 
 weight NUMBER 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)
);

odbc_mssql


Warning: Declaration of ADODB2_mssql::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-mssql.inc.php on line 140

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_SECS                  DATETIME DEFAULT GetDate(),
TS_SUBSEC                DATETIME DEFAULT GetDate(),
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME);
CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME);
CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE);
CREATE CLUSTERED INDEX idx ON KUTU.testtable (price, 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;

CREATE TABLE adoxyz (
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_SECS                  DATETIME DEFAULT GetDate(),
TS_SUBSEC                DATETIME DEFAULT GetDate(),
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx_name ON adoxyz (FIRSTNAME);
CREATE INDEX idx_lastname ON adoxyz (LASTNAME);
CREATE INDEX idx_date ON adoxyz (MYDATE);

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

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

odbc


Warning: Declaration of ADODB2_generic::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-generic.inc.php on line 52

Warning: Declaration of ADODB2_generic::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-generic.inc.php on line 59
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_SECS                  DATE,
TS_SUBSEC                DATE,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME);
CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME);
CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE);
CREATE INDEX idx ON KUTU.testtable (price, 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);

generic
DropColumnSQL not supported

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

db2


Warning: Use of undefined constant DB2_BINARY - assumed 'DB2_BINARY' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb.inc.php on line 4230

Warning: Declaration of ADODB2_db2::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-db2.inc.php on line 61

Warning: Declaration of ADODB2_db2::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-db2.inc.php on line 68

Warning: Declaration of ADODB2_db2::ChangeTableSQL($tablename, $flds, $tableoptions = false) should be compatible with ADODB_DataDict::ChangeTableSQL($tablename, $flds, $tableoptions = false, $dropOldFlds = false) in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-db2.inc.php on line 75
AlterColumnSQL not supported

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID                       INTEGER GENERATED ALWAYS AS IDENTITY,
FIRSTNAME                VARCHAR(30) DEFAULT 'Joan',
LASTNAME                 VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname   VARCHAR(3600),
price                    DECIMAL(7,2) DEFAULT 0.00,
MYDATE                   DATE DEFAULT CURRENT DATE,
BIGFELLOW                VARCHAR(3600),
TS_SECS                  TIMESTAMP DEFAULT CURRENT TIMESTAMP,
TS_SUBSEC                TIMESTAMP DEFAULT CURRENT TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME);
CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME);
CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE);
CREATE INDEX idx ON KUTU.testtable (price, firstname, lastname);
CREATE INDEX idx2 ON KUTU.testtable (price, lastname);
ALTER TABLE KUTU.testtable ADD height DOUBLE;
ALTER TABLE KUTU.testtable ADD weight DOUBLE;

db2
DropColumnSQL not supported

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

firebird


Warning: Declaration of ADODB2_ibase::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-ibase.inc.php on line 52

Warning: Declaration of ADODB2_ibase::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/datadict/datadict-ibase.inc.php on line 59
AlterColumnSQL not supported

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID                       INTEGER 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 cast('TODAY' as timestamp),
BIGFELLOW                VARCHAR(4000),
TS_SECS                  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
TS_SUBSEC                TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME);
CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME);
CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE);
CREATE INDEX idx ON KUTU.testtable (price, firstname, lastname);
CREATE INDEX idx2 ON KUTU.testtable (price, lastname);
ALTER TABLE KUTU.testtable ADD height DOUBLE PRECISION;
ALTER TABLE KUTU.testtable ADD weight DOUBLE PRECISION;

ibase
DropColumnSQL not supported

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

postgres


Fatal error: Uncaught Error: Call to undefined function pg_escape_string() in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/drivers/adodb-postgres64.inc.php:244 Stack trace: #0 /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb-datadict.inc.php(779): ADODB_postgres64->qstr('Joan') #1 /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/adodb-datadict.inc.php(565): ADODB_DataDict->_GenFields(Array, true) #2 /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/tests/test-datadict.php(64): ADODB_DataDict->CreateTableSQL('testtable', '\nID ...', Array) #3 {main} thrown in /opt/lampp/htdocs/tarki_survey/leiratkozasg/classes/adodb/drivers/adodb-postgres64.inc.php on line 244