Description: ------------ Hello, in addition to Bug #10488, I think there is another problem: If you have a TIMESTAMP column in MySQL you can't recreate this column with the manager module as it was, with the information from the reverse module. Because a DEFAULT CURRENT_TIMESTAMP is illegal for a DATETIME column in MySQL, which the manager create instead of a TIMESTAMP. And yes: it's really a difference between a DATETIME and a TIMESTAMP. And if there was a TIMESTAMP, I want to have a TIMESTAMP ;-) In the constructor I told MDB2 that I want use MySQL, and so I should be able to use all basic features from this DB (without using e.g. custom types). Another thing I'm missing: If I create the original column with an additional "ON UPDATE CURRENT_TIMESTAMP", I don't get this info from the reverse module tableInfo(). (For this I can make a patch.) BTW: On this manual page [1] you can read, that MDB is creating a TIMESTAMP in MySQL, and not a DATETIME. Regards, Carsten [1] http://pear.php.net/manual/en/package.database.mdb2.datatypes.php#AEN38081 Test script: --------------- <?php header('Content-Type: text/plain'); require_once 'MDB2.php'; function printError($error) { die($error->getDebugInfo()); } PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, 'printError'); $dsn = 'mysqli://root@localhost/test'; $dbTable = 'mdb2test'; $mdb2 = MDB2::connect($dsn); $mdb2->loadModule('Manager'); $mdb2->loadModule('Reverse', null, true); echo 'Created table with e.g. phpMyAdmin:'.PHP_EOL; $sql = <<<SQL DROP TABLE IF EXISTS $dbTable SQL; $mdb2->exec($sql); /* Use this for a negative test */ $sql = <<<SQL CREATE TABLE $dbTable ( updatetime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); SQL; /* Use this for a positive test */ //$sql = <<<SQL //CREATE TABLE $dbTable ( // updatetime DATETIME // DEFAULT NULL //); //SQL; echo $sql.PHP_EOL.PHP_EOL; $mdb2->exec($sql); echo 'Get tableInfo() from the original table:'.PHP_EOL; $oldDefinition = $mdb2->tableInfo($dbTable); var_dump($oldDefinition); echo PHP_EOL; echo 'dropTable()'.PHP_EOL.PHP_EOL; $mdb2->dropTable($dbTable); echo 'Show MDB2 FieldDeclaration:'.PHP_EOL; $definition = array (); foreach ($oldDefinition as $value) { $definition[$value['name']] = array( 'type' => $value['mdb2type'], 'notnull' => $value['notnull'], 'default' => $value['default'], ); } echo "CREATE TABLE $dbTable (".PHP_EOL; echo " ".$mdb2->getFieldDeclarationList($definition).PHP_EOL; echo ")".PHP_EOL.PHP_EOL; echo 'createTable()'.PHP_EOL.PHP_EOL; $mdb2->createTable($dbTable, $definition); echo 'Get tableInfo() from the new table:'.PHP_EOL; $newDefinition = $mdb2->tableInfo($dbTable); var_dump($newDefinition); echo PHP_EOL; echo 'Are old and new tableInfo() the same?'.PHP_EOL; var_dump($oldDefinition == $newDefinition); echo PHP_EOL; ?> Expected result: ---------------- No error message and the arrays $old_definition and $new_definition should be equal. Actual result: -------------- Created table with e.g. phpMyAdmin: CREATE TABLE mdb2test ( updatetime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); Get tableInfo() from the original table: array(1) { [0]=> array(8) { ["notnull"]=> bool(true) ["nativetype"]=> string(9) "timestamp" ["default"]=> string(17) "CURRENT_TIMESTAMP" ["type"]=> string(9) "timestamp" ["mdb2type"]=> string(9) "timestamp" ["name"]=> string(10) "updatetime" ["table"]=> string(8) "mdb2test" ["flags"]=> string(35) " not_null default_CURRENT_TIMESTAMP" } } dropTable() Show MDB2 FieldDeclaration: CREATE TABLE mdb2test ( updatetime DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL ) createTable() _doQuery: [Error message: Could not execute statement] [Last executed query: CREATE TABLE mdb2test (updatetime DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL)] [Native code: 1067] [Native message: Fehlerhafter Vorgabewert (DEFAULT) für 'updatetime']