Making tables with SQLight

Hi, Im using locomotive and running SQLight. Im confused about making tables with sqlight.

Im following the depot example from 'agile web development with rails'. When trying to make the table 'products' is there a difference when using SQLight rather than MySQL?

Here is the DDL for MySQL, how do I make this table with SQLight?

if you were to use rails migrations you wouldn't have to worry about it database specific language.


The first version of the agile book is very very outdated, rails hove along pretty fast.

Do migrations instead. Write the scremas in ruby and make rails deal with the sql.

Thanks for your help. This is alot better!