SQLite History plugin DB Schema

[Dario <djdas@djdas.net>]

[-- Attachment #1: Type: text/plain, Size: 2270 bytes --]

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 -------------