https://bugzilla.wikimedia.org/show_bug.cgi?id=61111
Web browser: ---
Bug ID: 61111
Summary: Change log_id, page_id, rc_id, rev_id, and user_id to
bigint unsigned
Product: MediaWiki
Version: 1.23-git
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: nathanlarson3...@gmail.com
Classification: Unclassified
Mobile Platform: ---
Some wikis (e.g. Inclupedia) may wish to import Wikipedia's logging, page,
recentchange, revision, and user data, using the same primary key values for
that imported data as Wikipedia, while also having their own data in those
fields, starting at, e.g., log_id, page_id, rc_id, rev_id, and user_id 1
quadrillion for future-proofing purposes. This will require a change of these
primary keys to bigint unsigned, since int unsigned maxes out at about 2.7
billion.
These keys are going to hit their maxes eventually anyway on enwiki, although
it might take a few decades more. Going to bigint unsigned will use up more
storage, though.
Another issue with this is extensive core use of intval() on these primary
keys. One solution is to create a wfBigintval() global function that removes
any decimal as intval does and removes any non-numeric characters. However,
then it will return a string rather than an int; hopefully no one does any
mathematical operations on these, or it will be necessary to come up with
alternative ways of doing those.
I can change old_id to bigint unsigned as well, if you think that would be
helpful. Should we just migrate all primary keys to bigint unsigned? See also
bug 60962, which this will at least partly fix. See also [[mw:Manual:Primary
key storage in other fields]].
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
