Re: PEAR DB Sequences
| From: | Arnaud Limbourg | Date: | Sat, 19 Oct 2002 11:37:47 +0000 |
| Subject: | Re: PEAR DB Sequences | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-2527@lists.php.net to get a copy of this message | ||
> I think you make perfect sense.
>
> So when I create the table I just set the id field as an unsigned int and
> define it as the primary key, but make no reference to incrementation or
> sequences. I then setup the sequence via the PEAR DB Sequence operation,
> one sequence for each table that needs one?
Exactly. Though i'd think it a good way to let pear::db handles that.
I just do a
$db->nextId('myseq');
and let pear::db create it ;))
Otherwise there is one table per sequence, you're correct.
> Please correct me if I'm mistaken.
>
> That is VERY nice.
>
> Thanks!
> Don.