I am creating a fairly simple sqlite db for my android project. It has been a long time since i have written msql commands, let alone sqlite.
To keep this question simple, lets just say i have two tables. One table for
dogs and another for
dogs there will be a column to hold the owner's
_id which will be a primary key from the other table.
I can't for the life of me remember how to do this in sqlite or if i even can.
I am creating the dog table with this String :
private static final String CREATE_TABLE_DOGS = "CREATE TABLE" + TABLE_DOGS + "(" + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_NAME + " TEXT NOT NULL, " + COLUMN_OWNER + " INTEGER );";