Complete the database

While yesterday i was create the conection. i see that my BD needs more Sp. A Sp that tellme if a code has the state repeted, maybe this is the most complex because need make queries in all tables. I test the procedures but with very simplify examples in database. the rest of the day i continue try to test the SPs using this example. i look that i need a XML with the tables information, then i try the mysql generate to me this information. I use this Informtion to create the file, but with this export all the information and dont need.