On Wed, Mar 26, 2014 at 10:26 PM, Richard Hipp <d...@sqlite.org> wrote:
> > > > 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? > > Also, which columns contain the 1MB blobs? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
