The new PEAR package MDB2_Schema-0.8.3 (beta) has been released at
http://pear.php.net/.
Release notes
-------------
- updateDatabase() cannot add UNIQUE attribute to an existing index (Bug #13977). Patch by Holger Schletz
- updateDatabase() keeps old default value even though new column has no default (Bug #13836). Patch by Holger Schletz
- Obsolete tables and sequences not dropped on updateDatabase() (Bug #13608). Patch by Holger Schletz
- Error when creating a new index for a renamed table (Bug #13397)
- Makes use of MDB2::databaseExists() to check whether updating database exists (Bug #13073). This feature was removed on previous release and now is back again.
- createDatabase() correctly lower/upper database name when portability option deems so.
- mdb2_schematool now disables transactions
- mdb2_schematool was missing argument "help"
- mdb2_schematool moved from "bin" to "scripts" folder. now installs to pear_bin dir
- Schema validation not failing when autoincrement field is defined but another column is used as primary key (Bug #14213)
- Accepting NOW() as value for timestamp fields on schema validation (Bug #14052). Patch by Holger Schletz
- Introducing www/mdb2_schematool that is a rewrite of docs/examples/example.php and is now installed to web root
- Web frontend (www/mdb2_schematool) has new options "DBA_username" and "DBA_password"
- Tests missing sequences on database dump (Bug #13562). Patch by Luca Corbo
- When reverse engineering a database, the XML schema file will have <charset> forced to UTF8
open todo items:
- Clean up output of getDefinitionFromDatabase(). Sync it with Parser and Parser2.
- Automatically load reserved keywords
- Make MDB2_Schema loadable via MDB2_Driver_Common::loadModule() (Bug #8270)
- Allow simple if statements that mean that anything enclosed is only executed
if it meets certain criterias based on that version number (or some other
variable). This would enable people to add DML statements that are only
executed when updating from a specific version.
- Modularize Writer code or remake it
- Add specific error codes for Validate class
- Add support for ORDER clauses on UPDATEs (to resolve the duplicate key
problem)
- Update description.schema.xml
- Create unit test for comparedefinitions()
- Create unit test for initializetable()
- Create unit test to compare the expected array definition with what is parsed
- Improve validateDataFieldValue() to validate <column>
- Provide more info on MDB2_Schema_Validate errors (output parsed value and expected value)
- Views support
- Fulltext index support
Package Info
------------
PEAR::MDB2_Schema enables users to maintain RDBMS independant schema
files in XML that can be used to create, alter and drop database entities
and insert data into a database. Reverse engineering database schemas from
existing databases is also supported. The format is compatible with both
PEAR::MDB and Metabase.
Related Links
-------------
Package home:
http://pear.php.net/package/MDB2_Schema
Changelog:
http://pear.php.net/package/MDB2_Schema/download/0.8.3
Download:
http://download.pear.php.net/package...hema-0.8.3.tgz
Authors
-------
Igor Feghali <
ifeghali@php.net> (lead)
Helgi Þormar Þorbjörnsson <
helgith@gmail.com> (lead)
Ali Fazelzadeh (contributor)
Partager