SQLite History plugin DB Schema
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 -------------