View Single Post
Old 01-28-2017, 03:33 PM   #73
pluma
Enthusiast
pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.pluma ought to be getting tired of karma fortunes by now.
 
Posts: 48
Karma: 854254
Join Date: Nov 2016
Device: none
kobo firmware 3.20 reference.

What would it be the fields to set given the following:

Code:
CREATE TABLE user(UserID TEXT NOT NULL,
UserKey TEXT NOT NULL,
UserDisplayName TEXT,
UserEmail TEXT,
___DeviceID TEXT,
FacebookAuthToken TEXT,
HasMadePurchase BIT DEFAULT FALSE,
IsOneStoreAccount BIT DEFAULT FALSE,
IsC$ildAccount BIT DEFAULT FALSE,
RefreshToken TEXT,
AuthToken TEXT,
AuthType TEXT,
Loyalty BLOB,
IsLibraryMigrated BIT NOT NULL DEFAULT true,
SyncContinuationToken TEXT,
Subscription INT NOT NULL DEFAULT 0,
PRIMARY $EY (UserID));
Where would it go the fancyful email address here while keeping everything else empty?

thanks
pluma is offline   Reply With Quote