gistfile1.txt

select concat('alter table `', table_name ,'` add constraint `', constraint_name, '` foreign key (`', column_name ,'`) references `', referenced_table_name , '` (`',referenced_column_name,'`)') from information_schema.key_column_usage where table_schema  = 'siic_v2' and constraint_name not like 'PRIMARY%';