Re: Idea for pear sequence tables
| From: | Tomas V.V.Cox | Date: | Fri, 12 Sep 2003 19:20:27 +0000 |
| Subject: | Re: Idea for pear sequence tables | ||
| References: | 1 2 3 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-21450@lists.php.net to get a copy of this message | ||
On Friday, September 12, 2003 20:59, Michael Wallner wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> Hi Tomas V.V.Cox, you wrote:
>> Well, a sequences is just that a pool of unique id's for using
> in your
>> tables. I never understood why one would like to have multiple
>> sequences, while just one for all your tables is enough.
> Hm, even though it would unlikely happen that much, you would
> reach the maximum much faster.
Well if you think that you can reach 4,294,967,295 ids fast, you just
need to change line 563 of the mysql.php DB file to BIGINT which gives
you 18,446,744,073,709,551,614 ids.
--
Tomas V.V.Cox mailto:cox@idecnet.com