use sequence table instead of auto_increment [#98280]

the module uses auto_increment for mysql:

db_query("CREATE TABLE {privatemsg} (
          id            int(10) unsigned NOT NULL auto_increment primary key,

instead of using the {sequence} table: http://drupal.org/node/1395

Comments

Comment #1

mindless CreditAttribution: mindless commented 26 January 2007 at 16:43

is there an api to initialize a sequence value? upgrade code here would need to get the max value of the auto_increment columns to initialize the sequences. i guess it could call db_next_id N times, else it would have to write sql knowing the name/structures of the sequences table.

Comment #2

mindless CreditAttribution: mindless commented 22 February 2007 at 14:53

bump

Comment #3

mindless CreditAttribution: mindless commented 22 February 2007 at 19:59

Assigned:	Unassigned	» mindless
Status:	Active	» Fixed

i used sql as in system.install to initialize the sequences.. this means i'm dependent on internals of db_next_id (mysql uses sequences table with name,id and pgsql uses sequence with _seq suffix on the name), but i won't have to call db_next_id 7000 times to upgrade my site..