CREATE<\/span> TABLE<\/span> products<\/span> (<\/span> id<\/span> INTEGER<\/span> NOT<\/span> NULL<\/span> PRIMARY<\/span> KEY<\/span>,<\/span> description<\/span> varchar<\/span>(<\/span>255<\/span>),<\/span> price<\/span> decimal<\/span>(<\/span>15<\/span>,<\/span>2<\/span>)<\/span> );<\/span><\/div>CREATE<\/span> INDEX<\/span> products_description<\/span> ON<\/span> products<\/span>(<\/span>description<\/span>);<\/span><\/div><\/pre><\/div>\n \n <\/div>\n\n