|
Connoisseur
Posts: 70
Karma: 798
Join Date: Apr 2012
Device: iLiad, Kobo Aura 6"
|
Quote:
Originally Posted by davidfor
But, there is also a reading status column. This is "ReadStatus". It has values of "0" for unread, "1" for reading and "2" for finished.
|
i believe in you  but i can't find "ReadStatus" column.
For example, in this book where is it?
Code:
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','6','application/epub+zip',NULL,NULL,'file____mnt_onboard_Il_gatto_venuto_dal_cielo_-_Hiraide_Takashi_epub','Il gatto venuto dal cielo','Hiraide Takashi','',NULL,NULL,'','','false','2019-07-10T10:34:37Z','false','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(2)OEBPS/Text/part0003.html',0,0,35,0,0,1,'2019-06-13T08:33:55Z','adobe_user',NULL,NULL,837784,5,0,-1,-1,'','it','','true',0,0,0,'default','false','9788858419120',NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,0,0,0.0,0,'','',NULL,'','','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
It's "1" (the value before the date '2019-06-13T08:33:55Z')?
This is the list of columns which is at the beginning of the file sql, but maybe it's not in order:
Code:
"ContentID" TEXT NOT NULL,
"ContentType" TEXT NOT NULL,
"MimeType" TEXT NOT NULL,
"BookID" TEXT,
"BookTitle" TEXT,
"ImageId" TEXT,
"Title" TEXT COLLATE NOCASE,
"Attribution" TEXT COLLATE NOCASE,
"Description" TEXT,
"DateCreated" TEXT,
"ShortCoverKey" TEXT,
"adobe_location" TEXT,
"Publisher" TEXT,
"IsEncrypted" BOOL,
"DateLastRead" TEXT,
"FirstTimeReading" BOOL,
"ChapterIDBookmarked" TEXT,
"ParagraphBookmarked" INTEGER,
"BookmarkWordOffset" INTEGER,
"NumShortcovers" INTEGER,
"VolumeIndex" INTEGER,
"___NumPages" INTEGER,
"ReadStatus" INTEGER,
"___SyncTime" TEXT,
"___UserID" TEXT NOT NULL,
"PublicationId" TEXT,
"___FileOffset" INTEGER,
"___FileSize" INTEGER,
"___PercentRead" INTEGER,
"___ExpirationStatus" INTEGER,
"FavouritesIndex" NOT NULL DEFAULT -1,
"Accessibility" INTEGER DEFAULT 1,
"ContentURL" TEXT,
"Language" TEXT,
"BookshelfTags" TEXT,
"IsDownloaded" BIT NOT NULL DEFAULT 1,
"FeedbackType" INTEGER DEFAULT 0,
"AverageRating" INTEGER DEFAULT 0,
"Depth" INTEGER,
"PageProgressDirection" TEXT,
"InWishlist" BOOL NOT NULL DEFAULT FALSE,
"ISBN" TEXT,
"WishlistedDate" TEXT DEFAULT 0000-00-00T00:00:00.000,
"FeedbackTypeSynced" INTEGER DEFAULT 0,
"IsSocialEnabled" BOOL NOT NULL DEFAULT TRUE,
"EpubType" INT NOT NULL DEFAULT -1,
"Monetization" INTEGER DEFAULT 2,
"ExternalId" TEXT,
"Series" TEXT,
"SeriesNumber" TEXT,
"Subtitle" TEXT,
"WordCount" INTEGER DEFAULT -1,
"Fallback" TEXT,
"RestOfBookEstimate" INTEGER,
"CurrentChapterEstimate" INTEGER,
"CurrentChapterProgress" FLOAT,
"PocketStatus" INTEGER DEFAULT 0,
"UnsyncedPocketChanges" TEXT,
"ImageUrl" TEXT,
"DateAdded" TEXT,
"WorkId" TEXT,
"Properties" TEXT,
"RenditionSpread" TEXT,
"RatingCount" INTEGER DEFAULT 0,
"ReviewsSyncDate" TEXT,
"MediaOverlay" TEXT,
"MediaOverlayType" TEXT,
"RedirectPreviewUrl" TEXT,
"PreviewFileSize" INTEGER,
"EntitlementId" TEXT,
"CrossRevisionId" TEXT,
"DownloadUrl" TEXT,
"ReadStateSynced" BIT NOT NULL DEFAULT false,
"TimesStartedReading" INTEGER,
"TimeSpentReading" INTEGER,
"LastTimeStartedReading" TEXT,
"LastTimeFinishedReading" TEXT,
"ApplicableSubscriptions" TEXT,
"ExternalIds" TEXT,
"PurchaseRevisionId" TEXT,
"SeriesID" TEXT,
"SeriesNumberFloat" REAL,
"AdobeLoanExpiration" TEXT,
"HideFromHomePage" bit,
"IsInternetArchive" BOOL NOT NULL DEFAULT FALSE,
"titleKana" TEXT,
"subtitleKana" TEXT,
"seriesKana" TEXT,
"attributionKana" TEXT,
"publisherKana" TEXT,
"IsPurchaseable" BOOL DEFAULT TRUE,
"IsSupported" BOOL DEFAULT TRUE,
PRIMARY KEY("ContentID")
);
Last edited by mortimer7; 07-01-2022 at 02:47 PM.
|