Welcome to Referential Integrity!

Max Kanat-Alexander mkanat at bugzilla.org
Fri Mar 9 22:20:50 UTC 2007


	Hello, Bugzilla passengers! We have now landed at Referential
Integrity Airport. :-)

	You can read a bit about it here:

	http://www.bugzilla.org/docs/tip/html/api/Bugzilla/DB/Schema.html#Referential_Integrity

	(Or at least, you'll be able to when the website updates
itself.)

	What this means that's most important to remember is that you
have to now insert things in the "right order." What's that mean? Well,
example: if you want something to reference a row in the bugs table,
you have to actually insert that row in the bugs table before you
insert the row that references it.

	It does make sense. :-)

	Also, the reverse is true for deletion--if a row references the
bugs table, you have to delete that row *before* you delete the bug.

	This will nicely prevent database corruption, even if people
modify their databases manually. It will also eventually allow us to
easily delete things from the database, or at least keep track of when
we should be deleting something before we delete something else. :-)

	It's actually only implemented on profiles_activity right now,
but it will eventually be showing up in every table in Bugzilla.

	-Max
-- 
http://www.everythingsolved.com/
Competent, Friendly Bugzilla Services. And Everything Else, too.



More information about the developers mailing list