Convert a Simple T-SQL ''CREATE TABLE'' Syntax to MySQL Syntax

<strong><span class="kwd">CREATE</span> <span class="kwd">TABLE</span><span class="pln"> FavoriteList<br /></span><span class="pun">(</span><span class="pln"><br /> favoriteWantedID int </span><span class="kwd">IDENTITY</span> <span class="pun">(</span><span class="lit">50</span><span class="pun">,</span><span class="lit">4</span><span class="pun">)</span> <span class="kwd">PRIMARY</span> <span class="kwd">KEY</span><span class="pun">,</span><span class="pln"><br /> memberID int </span><span class="kwd">NOT</span> <span class="kwd">NULL</span> <span class="kwd">REFERENCES</span><span class="pln"> Member</span><span class="pun">(</span><span class="pln">memberID</span><span class="pun">),</span><span class="pln"><br /> wantedID int </span><span class="kwd">NOT</span> <span class="kwd">NULL</span> <span class="kwd">REFERENCES</span><span class="pln"> Wanted</span><span class="pun">(</span><span class="pln">wantedID</span><span class="pun">)</span> <span class="kwd">ON</span> <span class="kwd">DELETE</span> <span class="kwd">CASCADE</span><span class="pun">,</span><span class="pln"><br /> dateCreated datetime </span><span class="kwd">DEFAULT</span><span class="pln"> GetDate</span><span class="pun">()</span> <span class="kwd">NOT</span> <span class="kwd">NULL</span><span class="pun">,</span><span class="pln"><br /> </span><span class="kwd">UNIQUE</span> <span class="pun">(</span><span class="pln">memberID</span><span class="pun">,</span><span class="pln"> wantedID</span><span class="pun">)</span><span class="pln"><br /></span></strong><span class="pun"><strong>);<br /></strong><br /><span style="color: #c00000;"><strong>The above Syntax is written in T-SQL ... Please change it to MySQL, write it<br />clearly as i wrote it above.</strong></span><br /></span> ## Deliverables ## **Quick Edit .... **