php - Drupal convert nid/vid from int to bigint -

i busy project nid , vid values may reach limit. need mechanism modify current , future nid , vid data types int bigint.

i figured maybe there schema alter hook, or limilar. see there hook called hook_schema_alter.

how reliable build module simple checks nid , vid in schema, , modifies bigint? practical way of solving problem? work content types, module ones , cck?

g.

as hook_schema_alter fired on module install, rather build complex module manages automatically, should pick subset of modules know using, install them, , manually update schema.

if going have 4 billion nodes (other poster said 2bn, nid unsigned doubles available range) should not turning modules on , off @ random. architecture should rock solid , planned out in advance.

also, what's use case wanting many nodes in drupal? kind of database operation many rows going very, intensive when optimized , without weight of drupal stack (and it's love of expensive join queries) on top of it.

drupal fine prototyping whatever you're building time hit xxx,000 nodes you'll spending majority of time hand-tuning performance. may x,000,000 nodes if have serious world-class expertise , funding. more, want start looking @ offloading data database system optimized huge datasets , access drupal service.

take @ hadoop , cassandra examples of dbms' can scale billions of items (google, facebook, twitter etc use them).