Re: Using MDB XML Schema

From:	Lorenzo Alberton	Date:	Tue, 18 Feb 2003 19:45:09 +0000
Subject:	Re: Using MDB XML Schema
References:	1	Groups:	php.pear.dev
Request:	Send a blank email to pear-dev+get-13468@lists.php.net to get a copy of this message

At 18/02/2003 14.02 -0500, you wrote:

Hi, I am learning the ropes of the MDB database schema, and have a question regarding primary keys. Specifically, it appears that the schema does not support the deceleration of primary keys. Am I right, and if so, why?

You can declare an unique or an index key, but not a primary (autoincrementing) one, because that's not supported by every dbms. You should use sequences, instead

Also, the reverse engineer script for mysql tables appears to ignore unsigned integers when parsing.

"unsigned" is not a property recognised by all dbms. So it's not implemented. Have a look for MDB datatypes reference for more info.

Thanks, Michael

Regards, Lorenzo