RE: [PEAR] primary key in MDB schema
| From: | Lukas Smith | Date: | Wed, 10 Dec 2003 16:15:33 +0000 |
| Subject: | RE: [PEAR] primary key in MDB schema | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-9459@lists.php.net to get a copy of this message | ||
> From: Matthias Nothhaft [mailto:php@mahono.de]
> Sent: Wednesday, December 10, 2003 4:27 PM
> I wanna use a "multi language content table"
> with a primary key that consists of 2 columns: id and language
>
> That gives me the nice possibility to have one content
> in various languages!
>
> So, how can I define that in a MDB schema?
>
> Are there any differences in the schema between MDB1 and MDB2 ?
Currently primary keys are not supported.
However "unique index" are supported, which is more or less the same (the
only difference being that usually RDBMS don't allow null's on a primary
field while they do on unique fields).
Regards,
Lukas