I realize that linuxquestions might be the wrong place to ask this question but I will try anyway.
I am making a simple database that will be populated with data from a perl script. The tables are created and they work fine unless for one thing. I can create rows in the url table with nickids that does not exist in people even though I use the constraint attribute. Anyone have an ide why this is so?
*edit* I pasted a new version of the original code that will not be lost after a couple of days *edit*
http://pastebin.com/DJQ4BtL6
PS, I wrote this by hand so there might be writing errors in the code.