PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE ZBLDOWNLOADPOLICYINFO ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZSTOREPLAYLISTIDENTIFIER INTEGER, ZPOLICYID VARCHAR, ZPOLICYDATA BLOB );
CREATE TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY, Z_NAME VARCHAR, Z_SUPER INTEGER, Z_MAX INTEGER);
INSERT INTO Z_PRIMARYKEY VALUES(1,'BLDownloadInfo',0,6);
INSERT INTO Z_PRIMARYKEY VALUES(2,'BLDownloadPolicyInfo',0,2);
CREATE TABLE Z_METADATA (Z_VERSION INTEGER PRIMARY KEY, Z_UUID VARCHAR(255), Z_PLIST BLOB);
INSERT INTO Z_METADATA VALUES(1,'2D3944E4-521A-43A6-AFF5-55A3E2A63841',X'62706c6973743030d80102030405060708090b0c0d0e0f14155f101e4e5353746f72654d6f64656c56657273696f6e4964656e746966696572735b4e5353746f7265547970655f10125f4e534175746f56616375756d4c6576656c5f101f4e5353746f72654d6f64656c56657273696f6e4861736865734469676573745f101e4e5353746f72654d6f64656c56657273696f6e436865636b73756d4b65795f10194e5353746f72654d6f64656c56657273696f6e4861736865735f101d4e5350657273697374656e63654672616d65776f726b56657273696f6e5f10204e5353746f72654d6f64656c56657273696f6e48617368657356657273696f6ea10a505653514c69746551325f10586d4a52623772585a664f6e6a7541714d504739695537424d4164766672543033797a7678344878636273307a34636e4b6f357a677262715149635542764c65527a524f506c79744249307a4a5772546b4e4639314f773d3d5f102c7671527a56456f3535615a6d6d433733355a63682b734c42336a4a6c6366314b4a4c476b456c79527a79513dd2101112135f1014424c446f776e6c6f6164506f6c696379496e666f5e424c446f776e6c6f6164496e666f4f102045bb929b5dd5da6fbca53674a37213713b95aef9df0c51c7085cc1e283f02f714f1020b42f3d26a27e7248429c9d5466fc52910c9b42055169caafcc2ec5e396c86f631105a7100300080019003a0046005b007d009e00ba00da00fd00ff01000107010901640193019801af01be01e1020402070000000000000201000000000000001600000000000000000000000000000209');
CREATE TABLE Z_MODELCACHE (Z_CONTENT BLOB);
INSERT INTO Z_MODELCACHE VALUES(X'[encoded data, 10424 characters]');
CREATE TABLE IF NOT EXISTS "ZBLDOWNLOADINFO" (
	"Z_PK"	INTEGER,
	"Z_ENT"	INTEGER,
	"Z_OPT"	INTEGER,
	"ZACCOUNTIDENTIFIER"	INTEGER,
	"ZCLEANUPPENDING"	INTEGER,
	"ZFAMILYACCOUNTIDENTIFIER"	INTEGER,
	"ZISAUTOMATICDOWNLOAD"	INTEGER,
	"ZISLOCALCACHESERVER"	INTEGER,
	"ZISPURCHASE"	INTEGER,
	"ZISRESTORE"	INTEGER,
	"ZISSAMPLE"	INTEGER,
	"ZISZIPSTREAMABLE"	INTEGER,
	"ZNUMBEROFBYTESTOHASH"	INTEGER,
	"ZPERSISTENTIDENTIFIER"	INTEGER,
	"ZPUBLICATIONVERSION"	INTEGER,
	"ZSERVERNUMBEROFBYTESTOHASH"	INTEGER,
	"ZSIZE"	INTEGER,
	"ZSTATE"	INTEGER,
	"ZSTOREIDENTIFIER"	INTEGER,
	"ZSTOREPLAYLISTIDENTIFIER"	INTEGER,
	"ZLASTSTATECHANGETIME"	TIMESTAMP,
	"ZPURCHASEDATE"	TIMESTAMP,
	"ZSTARTTIME"	TIMESTAMP,
	"ZARTISTNAME"	VARCHAR,
	"ZARTWORKPATH"	VARCHAR,
	"ZASSETPATH"	VARCHAR,
	"ZBUYPARAMETERS"	VARCHAR,
	"ZCANCELDOWNLOADURL"	VARCHAR,
	"ZCLIENTIDENTIFIER"	VARCHAR,
	"ZCOLLECTIONARTISTNAME"	VARCHAR,
	"ZCOLLECTIONTITLE"	VARCHAR,
	"ZDOWNLOADID"	VARCHAR,
	"ZDOWNLOADKEY"	VARCHAR,
	"ZENCRYPTIONKEY"	VARCHAR,
	"ZEPUBRIGHTSPATH"	VARCHAR,
	"ZFILEEXTENSION"	VARCHAR,
	"ZGENRE"	VARCHAR,
	"ZHASHTYPE"	VARCHAR,
	"ZKIND"	VARCHAR,
	"ZMD5HASHSTRINGS"	VARCHAR,
	"ZORIGINALURL"	VARCHAR,
	"ZPERMLINK"	VARCHAR,
	"ZPLISTPATH"	VARCHAR,
	"ZSALT"	VARCHAR,
	"ZSUBTITLE"	VARCHAR,
	"ZTHUMBNAILIMAGEURL"	VARCHAR,
	"ZTITLE"	VARCHAR,
	"ZTRANSACTIONIDENTIFIER"	VARCHAR,
	"ZURL"	VARCHAR,
	"ZRACGUID"	BLOB,
	"ZDPINFO"	BLOB,
	"ZSINFDATA"	BLOB,
	"ZFILEATTRIBUTES"	BLOB,
	PRIMARY KEY("Z_PK")
);
INSERT INTO ZBLDOWNLOADINFO VALUES(1,2,3,0,0,0,0,'',NULL,NULL,NULL,NULL,0,0,0,NULL,0,2,765107108,NULL,767991550.1191970109,NULL,767991353.2452750206,NULL,NULL,'/private/var/mobile/Media/Books/asset.epub','productType=PUB&price=0&salableAdamId=765107106&pricingParameters=PLUS&pg=default&mtApp=com.apple.iBooks&mtEventTime=1746298553233&mtOsVersion=18.4.1&mtPageId=SearchIncrementalTopResults&mtPageType=Search&mtPageContext=search&mtTopic=xp_amp_bookstore&mtRequestId=35276ff6-5c8b-4136-894e-b6d8fc7677b3','https://p19-buy.itunes.apple.com/WebObjects/MZFastFinance.woa/wa/songDownloadDone?download-id=J19N_PUB_190099164604738&cancel=1','4GG2695MJK.com.apple.iBooks','Sebastian Saenz','Cartas de Amor a la Luna','../../../../../../private/var/containers/Shared/SystemGroup/systemgroup.com.apple.mobilegestaltcache/Library',NULL,NULL,NULL,NULL,'Contemporary Romance',NULL,'ebook',NULL,NULL,NULL,'/private/var/mobile/Media/iTunes_Control/iTunes/iTunesMetadata.plist',NULL,'Cartas de Amor a la Luna',unistr('https://is1-ssl.mzstatic.com/image/thumb/Publication126/v4/3d/b6/0a/3db60a65-b1a5-51c3-b306-c58870663fd3/Portada.jpg/200x200bb.jpg\u000a'),'Cartas de Amor a la Luna','J19N_PUB_190099164604738','KEYOOOOOO',NULL,NULL,NULL,X'62706c6973743030d80102030405060708090b0c0d0e0f14155f101e4e5353746f72654d6f64656c56657273696f6e4964656e746966696572735b4e5353746f7265547970655f10125f4e534175746f56616375756d4c6576656c5f101f4e5353746f72654d6f64656c56657273696f6e4861736865734469676573745f101e4e5353746f72654d6f64656c56657273696f6e436865636b73756d4b65795f10194e5353746f72654d6f64656c56657273696f6e4861736865735f101d4e5350657273697374656e63654672616d65776f726b56657273696f6e5f10204e5353746f72654d6f64656c56657273696f6e48617368657356657273696f6ea10a505653514c69746551325f10586d4a52623772585a664f6e6a7541714d504739695537424d4164766672543033797a7678344878636273307a34636e4b6f357a677262715149635542764c65527a524f506c79744249307a4a5772546b4e4639314f773d3d5f102c7671527a56456f3535615a6d6d433733355a63682b734c42336a4a6c6366314b4a4c476b456c79527a79513dd2101112135f1014424c446f776e6c6f6164506f6c696379496e666f5e424c446f776e6c6f6164496e666f4f102045bb929b5dd5da6fbca53674a37213713b95aef9df0c51c7085cc1e283f02f714f1020b42f3d26a27e7248429c9d5466fc52910c9b42055169caafcc2ec5e396c86f631105a7100300080019003a0046005b007d009e00ba00da00fd00ff01000107010901640193019801af01be01e1020402070000000000000201000000000000001600000000000000000000000000000209');
CREATE INDEX Z_BLDownloadInfo_byDownloadIDIndex ON ZBLDOWNLOADINFO (ZDOWNLOADID COLLATE BINARY ASC);
CREATE INDEX Z_BLDownloadInfo_byStateIndex ON ZBLDOWNLOADINFO (ZSTATE COLLATE BINARY ASC);
COMMIT;
