/usr/lib/luna/PalmDatabase.db3
/usr/lib/luna/CarrierNetworkSettings.db3
/var/luna/data/CarrierNetworkSettings.db3
/var/luna/data/dbdata/PalmAccountDatabase.db3
/var/luna/data/dbdata/PalmDatabase.db3


/var/luna/data/mediadb.db3
---
sqlite> .tables
com_palm_media_audio                                     
com_palm_media_image                                     
com_palm_media_imagealbum                                
com_palm_media_imagetag                                  
com_palm_media_other                                     
com_palm_media_playlist                                  
com_palm_media_ringtone                                  
com_palm_media_video                                     
relation__com_palm_media_audio__com_palm_media_playlist  
relation__com_palm_media_image__com_palm_media_imagealbum
relation__com_palm_media_image__com_palm_media_imagetag 

sqlite> .schema
CREATE TABLE com_palm_media_audio (creationDate INTEGER, modifiedDate INTEGER, size INTEGER, itunes INTEGER, basename TEXT, fileType TEXT, path UNIQUE ON CONFLICT FAIL, pictureUrl TEXT, name TEXT, nameNormalized TEXT, processed INTEGER, inRestoreProcess INTEGER, currentPlaybackPosition INTEGER, duration INTEGER, encoding INTEGER, bitrate INTEGER, samplerate INTEGER, track INTEGER, numberOfChannels INTEGER, albumTitle TEXT, albumTitleNormalized TEXT, genre TEXT, genreNormalized TEXT, artist TEXT, artistNormalized TEXT, dateSizeHash INTEGER, toxic INTEGER, starred INTEGER, isRingtone INTEGER );
CREATE TABLE com_palm_media_image (encoding INTEGER, latitude REAL, modifiedDate INTEGER, size INTEGER, basename TEXT, itunes INTEGER, fileType TEXT, longitude REAL, creationDate INTEGER, orientation INTEGER, path UNIQUE ON CONFLICT FAIL, pictureUrl TEXT, name TEXT, description TEXT, createdWithDevice INTEGER, processed INTEGER, inRestoreProcess INTEGER, dateSizeHash INTEGER, toxic INTEGER, starred INTEGER );
CREATE TABLE com_palm_media_imagealbum (path UNIQUE ON CONFLICT IGNORE, itunes INTEGER, nameSort TEXT, priority INTEGER, name TEXT);
CREATE TABLE com_palm_media_imagetag (name UNIQUE ON CONFLICT IGNORE, nameSort TEXT );
CREATE TABLE com_palm_media_other (modifiedDate INTEGER, path UNIQUE ON CONFLICT FAIL, name TEXT, nameNormalized TEXT, itunes INTEGER, basename TEXT, fileType TEXT, createdWithDevice INTEGER, processed INTEGER, inRestoreProcess INTEGER, dateSizeHash INTEGER, size INTEGER, toxic INTEGER, starred INTEGER );
CREATE TABLE com_palm_media_playlist (path UNIQUE ON CONFLICT FAIL, name TEXT, nameNormalized TEXT, basename TEXT, itunes INTEGER, fileType TEXT, description TEXT, extended INTEGER, size INTEGER, modifiedDate INTEGER, trackCount INTEGER, createdWithDevice INTEGER, processed INTEGER, inRestoreProcess INTEGER, currentPlaybackPosition INTEGER, dateSizeHash INTEGER, toxic INTEGER, starred INTEGER );
CREATE TABLE com_palm_media_ringtone (creationDate INTEGER, modifiedDate INTEGER, size INTEGER, basename TEXT, itunes INTEGER, fileType TEXT, path UNIQUE ON CONFLICT FAIL, name TEXT, processed INTEGER, inRestoreProcess INTEGER, currentPlaybackPosition INTEGER, duration INTEGER, pictureUrl TEXT, encoding INTEGER, bitrate INTEGER, samplerate INTEGER, track INTEGER, numberOfChannels INTEGER, albumTitle TEXT, genre TEXT, artist TEXT, dateSizeHash INTEGER, toxic INTEGER, starred INTEGER, isRingtone INTEGER );
CREATE TABLE com_palm_media_video (creationDate INTEGER, path UNIQUE ON CONFLICT FAIL, pictureUrl TEXT, modifiedDate INTEGER, itunes INTEGER, size INTEGER, basename TEXT, fileType TEXT, name TEXT, description TEXT, createdWithDevice INTEGER, processed INTEGER, position INTEGER, inRestoreProcess INTEGER, currentPlaybackPosition INTEGER, duration INTEGER, encoding INTEGER, artist INTEGER, dateSizeHash INTEGER, latitude REAL, longitude REAL, orientation INTEGER, toxic INTEGER, starred INTEGER );
CREATE TABLE relation__com_palm_media_audio__com_palm_media_playlist (keyA INTEGER, keyB INTEGER );
CREATE TABLE relation__com_palm_media_image__com_palm_media_imagealbum (keyA INTEGER, keyB INTEGER, unique (keyA, keyB) on conflict ignore );
CREATE TABLE relation__com_palm_media_image__com_palm_media_imagetag (keyA INTEGER, keyB INTEGER, unique (keyA, keyB) on conflict ignore );
CREATE INDEX index_albumTitleNormalized_asc__com_palm_media_audio on com_palm_media_audio (albumTitleNormalized asc);
CREATE INDEX index_artistNormalized_asc__com_palm_media_audio on com_palm_media_audio (artistNormalized asc);
CREATE INDEX index_creationDate_desc__com_palm_media_image on com_palm_media_image (creationDate desc);
CREATE INDEX index_fileType_asc__com_palm_media_other on com_palm_media_other (fileType asc);
CREATE INDEX index_fileType_desc__com_palm_media_other on com_palm_media_other (fileType desc);
CREATE INDEX index_genreNormalized_asc__com_palm_media_audio on com_palm_media_audio (genreNormalized asc);
CREATE INDEX "index_keyAB_asc__relation__com_palm_media_audio__com_palm_media_playlist" on "relation__com_palm_media_audio__com_palm_media_playlist" (keyA asc, keyB asc);
CREATE INDEX "index_keyAB_asc__relation__com_palm_media_image__com_palm_media_imagealbum" on "relation__com_palm_media_image__com_palm_media_imagealbum" (keyA asc, keyB asc);
CREATE INDEX "index_keyAB_asc__relation__com_palm_media_image__com_palm_media_imagetag" on "relation__com_palm_media_image__com_palm_media_imagetag" (keyA asc, keyB asc);
CREATE INDEX index_keyA_asc__relation__com_palm_media_audio__com_palm_media_playlist on relation__com_palm_media_audio__com_palm_media_playlist (keyA asc);
CREATE INDEX index_keyA_asc__relation__com_palm_media_image__com_palm_media_imagealbum on relation__com_palm_media_image__com_palm_media_imagealbum (keyA asc);
CREATE INDEX index_keyA_asc__relation__com_palm_media_image__com_palm_media_imagetag on relation__com_palm_media_image__com_palm_media_imagetag (keyA asc);
CREATE INDEX index_keyB_asc__relation__com_palm_media_audio__com_palm_media_playlist on relation__com_palm_media_audio__com_palm_media_playlist (keyB asc);
CREATE INDEX index_keyB_asc__relation__com_palm_media_image__com_palm_media_imagealbum on relation__com_palm_media_image__com_palm_media_imagealbum (keyB asc);
CREATE INDEX index_keyB_asc__relation__com_palm_media_image__com_palm_media_imagetag on relation__com_palm_media_image__com_palm_media_imagetag (keyB asc);
CREATE INDEX index_modifiedDate_asc__com_palm_media_other on com_palm_media_other (modifiedDate asc);
CREATE INDEX index_modifiedDate_desc__com_palm_media_other on com_palm_media_other (modifiedDate desc);
CREATE INDEX index_nameNormalized_asc__com_palm_media_audio on com_palm_media_audio (nameNormalized asc);
CREATE INDEX index_nameNormalized_asc__com_palm_media_other on com_palm_media_other (nameNormalized asc);
CREATE INDEX index_nameNormalized_asc__com_palm_media_playlist on com_palm_media_playlist (nameNormalized asc);
CREATE INDEX index_nameNormalized_desc__com_palm_media_other on com_palm_media_other (nameNormalized desc);
CREATE INDEX index_nameSort_asc__com_palm_media_imagealbum on com_palm_media_imagealbum (nameSort asc);
CREATE INDEX index_name_asc__com_palm_media_image on com_palm_media_image (name asc);
CREATE INDEX index_name_asc__com_palm_media_ringtone on com_palm_media_ringtone (name asc);
CREATE INDEX index_name_asc__com_palm_media_video on com_palm_media_video (name asc);
CREATE INDEX index_name_desc__com_palm_media_ringtone on com_palm_media_ringtone (name desc);
CREATE INDEX index_size_asc__com_palm_media_other on com_palm_media_other (size asc);
CREATE INDEX index_size_desc__com_palm_media_other on com_palm_media_other (size desc);
CREATE INDEX index_track_asc__com_palm_media_audio on com_palm_media_audio (track asc);
CREATE TRIGGER trigger_clean_a_from_relation__com_palm_media_audio__com_palm_media_playlist after delete on com_palm_media_audio begin delete from relation__com_palm_media_audio__com_palm_media_playlist where relation__com_palm_media_audio__com_palm_media_playlist.keyA = old.rowid; end;
CREATE TRIGGER trigger_clean_a_from_relation__com_palm_media_image__com_palm_media_imagealbum after delete on com_palm_media_image begin delete from relation__com_palm_media_image__com_palm_media_imagealbum where relation__com_palm_media_image__com_palm_media_imagealbum.keyA = old.rowid; end;
CREATE TRIGGER trigger_clean_a_from_relation__com_palm_media_image__com_palm_media_imagetag after delete on com_palm_media_image begin delete from relation__com_palm_media_image__com_palm_media_imagetag where relation__com_palm_media_image__com_palm_media_imagetag.keyA = old.rowid; end;
CREATE TRIGGER trigger_clean_b_from_relation__com_palm_media_audio__com_palm_media_playlist after delete on com_palm_media_playlist begin delete from relation__com_palm_media_audio__com_palm_media_playlist where relation__com_palm_media_audio__com_palm_media_playlist.keyB = old.rowid; end;
CREATE TRIGGER trigger_clean_b_from_relation__com_palm_media_image__com_palm_media_imagealbum after delete on com_palm_media_imagealbum begin delete from relation__com_palm_media_image__com_palm_media_imagealbum where relation__com_palm_media_image__com_palm_media_imagealbum.keyB = old.rowid; end;
CREATE TRIGGER trigger_clean_b_from_relation__com_palm_media_image__com_palm_media_imagetag after delete on com_palm_media_imagetag begin delete from relation__com_palm_media_image__com_palm_media_imagetag where relation__com_palm_media_image__com_palm_media_imagetag.keyB = old.rowid; end;
sqlite>