Hi all, as promised last week (sorry for the delay) following is the DB schema for the SQLite history plug-in, there are 3 tables: one for the infos about calls, one for incoming SMSes and one for outgoing ones. I wrote some comments in the scripts to clarify fields informations, please feel free to comment/correct if you think something could be wrong or better handled. I'm also finishing a first plug-in version, I'll send the patches to the current git revision as soon as possible. Thank you in advance, happy Easter :) Dario ------------- cut here ------------- cut here ------------- cut here ------------- cut here ------------- CREATE TABLE "ofono_history_calls" ( "ohc_modem_path" TEXT, -- Modem path string i.e. "/modem0" "ohc_type" INTEGER, -- Call type ( 0 = Call ended, 1 = Call missed ) "ohc_direction" INTEGER, -- Call direction ( 0 = Mobile Originated, 1 = Mobile Terminated ) "ohc_phone_number" TEXT, -- Other party phone number "ohc_start_time" TEXT, -- Starting date/time "ohc_end_time" TEXT -- Ending date/time ); CREATE TABLE "ofono_history_incoming_messages" ( "ohim_modem_path" TEXT, -- Modem path string i.e. "/modem0" "ohim_msg_id" INTEGER, -- oFono unique message id number "ohim_sender" TEXT, -- Sender phone number "ohim_text" TEXT, -- Message text "ohim_local_date" TEXT, -- Local sent date/time "ohim_remote_date" TEXT -- Remote sent date/time ); CREATE TABLE "ofono_history_outgoing_messages" ( "ohom_modem_path" TEXT, -- Modem path string i.e. "/modem0" "ohom_msg_id" INTEGER, -- oFono unique message id number "ohom_recipient" TEXT, -- Recipient phone number "ohom_text" TEXT, -- Message text "ohom_creation_date" TEXT, -- Message creation date/time "ohom_send_status" INTEGER, -- Sending status ( 0 = Pending, 1 = Submitted, 2 = Failed ) "ohom_status_update_date" TEXT -- Last row update date/time ); CREATE UNIQUE INDEX "ohim_idx_msg_id" on ofono_history_incoming_messages (ohim_msg_id ASC); CREATE UNIQUE INDEX "ohom_idx_msg_id" on ofono_history_outgoing_messages (ohom_msg_id ASC); ------------- cut here ------------- cut here ------------- cut here ------------- cut here -------------