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?
drop table if exists products;
create table products (
id int not null auto_increment,
title varchar(100) not null,
description text not null,
image_url varchar(200) not null,
price decimal(10,2) not null,
primary key (id)
);
Also am I right in thinking this should go directly into my
addproductstable?
Basically if someone can explain to me the steps I need to do to make
tables in SQLight!
Thanks in advance.