On Jan 9, 2005, at 9:52 PM, John Richard Moser wrote:
(...)-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
/* ~ * SQL_ALCUBIERRE_CREATE_DB ~ * SQL instructions to create a database ~ */
#define SQL_ALCUBIERRE_CREATE_DB \ ~ "CREATE TABLE" TBL_PACKAGES \ ~ "(" \ ~ "name varchar(255)," \ ~ "category varchar(32)," \ ~ "group varchar(32)," \ ~ "class varchar(32)," \ ~ "tversion varchar(32)," \ ~ "version integer(16)," \ ~ "slot decimal(4,2)," \ ~ "conflicts varchar(255)," \ ~ "vendor varchar(64)," \ ~ "multilib integer(4)," \ ~ "critical char(1)," /*y,n*/ \ ~ "keepme char(1)," \ ~ "policy BLOB" \ ~ ")"
At a glance it looks like your OK. Your questions are answered in the docs:
http://www.sqlite.org/datatype3.html
http://www.sqlite.org/docs.html
-Charlie