trial sql create table for a record of stock transactions

transaction.sql

Create Table "main"."transactions"
CREATE  TABLE  IF NOT EXISTS "main"."transactions" ("tid" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL ,
"stkcode" TEXT NOT NULL ,
"stkname" TEXT, "qty" INTEGER NOT NULL ,
"broker" TEXT NOT NULL ,
"price" REAL NOT NULL ,
"targetprice" REAL,
"stoploss" REAL,
"longshort" TEXT NOT NULL ,
"date" TEXT NOT NULL ,
"time" TEXT NOT NULL )