create procedure set_user_attribute ( IN user_id INT, IN attribute_id INT, IN attribute_value varchar(255), IN attribute_value_id INT ) BEGIN -- come back and do the kick-ass 1, -1 thing. insert into user_attribute_value (id, user_id, attribute_id, value) values (null, user_id, attribute_id, attribute_value); END GO