Just a quick one to save as a reference. This query will copy a table structure, including indexes, to a new one.

CREATE TABLE copy LIKE original;

Got it on Stack Overflow.