On Wed, Mar 26, 2014 at 10:21 PM, Muharrem Bilgin (Bright Software) < mbil...@brightsoft.com.au> wrote:
> The table in question is created by using the following statement. > > CREATE TABLE PRD_DETAILS (PRD_CODE TEXT COLLATE NOCASE NOT NULL, TERID > INTEGER NOT NULL, SEQ INTEGER, PRD_DESC TEXT COLLATE NOCASE, FRANCHISE_CODE > INTEGER, PRD_STATUS TEXT COLLATE NOCASE, PRD_CLASS TEXT COLLATE NOCASE, > TESTER TEXT COLLATE NOCASE, APN1 TEXT COLLATE NOCASE, APN2 TEXT COLLATE > NOCASE, APN3 TEXT COLLATE NOCASE, RRP REAL, PRD_SIZE INTEGER, > EX_GST_ITEM_COST REAL, GST_ITEM_COST REAL, ITEM_COST REAL, ORD_QTY INTEGER, > NOTES TEXT COLLATE NOCASE, ORDERED_QTY INTEGER, PRFLAG1 TEXT COLLATE > NOCASE, > PRFLAG2 TEXT COLLATE NOCASE, PRUSER1 TEXT COLLATE NOCASE, PRUSER2 TEXT > COLLATE NOCASE, PRSPARE1 TEXT COLLATE NOCASE, PRVAL1 REAL, PRVAL2 REAL, > BS_USER_ID_ INTEGER, BS_ID_ INTEGER, BS_RTYPE_ INTEGER, BS_XTYPE_ INTEGER, > BS_XSTATUS_ INTEGER, CONSTRAINT PK_PRD_DETAILS PRIMARY KEY (PRD_CODE, > TERID)) > > Let me know if you need anything further. > No indices? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
