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.
|