Can't create table with this script
The index you have named cat_id doesn't have any columns in it.  You must actually index something in your index.  The FOREIGN KEY () column list is also empty.  You must actual point at some foreign keys.