View Single Post
Old 06-10-2014, 12:03 PM   #1
Darko
Junior Member
Darko began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Jun 2014
Device: kobo
Populating Calibre DB with NON

Hi,
I am trying to develop a tool that coverts an existing database to calibre sqlite db.
However, the sqlite driver I am using in my .Net project chokes on the word "NON".
See following table examples from calibre source:
CREATE TABLE comments ( id INTEGER PRIMARY KEY,
book INTEGER NON NULL,
text TEXT NON NULL COLLATE NOCASE,
UNIQUE(book)
);
...
CREATE TABLE data ( id INTEGER PRIMARY KEY,
book INTEGER NON NULL,
format TEXT NON NULL COLLATE NOCASE,
uncompressed_size INTEGER NON NULL,
name TEXT NON NULL,
UNIQUE(book, format)
);
...

As far as I know SQL does not have keyword "NON".
Could anybody enlighten me regarding this construct?
Tnx.
Darko is offline   Reply With Quote