Re: GSoC History plugin

On Wed, Jun 17, 2015 at 12:19 PM, Pali Rohár <[email protected]> wrote:

> On Tuesday 16 June 2015 20:33:36 Joshua Joseph wrote:
> > On Tue, Jun 16, 2015 at 7:49 PM, Pali Rohár <[email protected]>
> wrote:
> >
> > > On Tuesday 16 June 2015 17:58:04 Joshua Joseph wrote:
> > > > On Tue, Jun 16, 2015 at 6:49 PM, kaushik <[email protected]>
> > > > wrote:
> > > > > @Joshua, Can you look into these things and update the readme
> > > > > accordingly. Do let us know when you are done with it or have any
> > > > > doubts.
> > > >
> > > > Sure Kaushik. I am working on it right now.
> > > >
> > >
> > > Another thing:
> > >
> > > I think it can be useful to store also display name of contact which
> > > sent/received message. This is specially needed for jabber MUC, where
> > > sender is room name with resource specified by sender. So display name
> > > is there needed for identifying user...
> > >
> > >
> > Yes I thought so. I have already added a contact_name field.
> >
>
> When you finish it, please write database SQL schema (for SQLite) and
> sent it to mailing list for review.
>

Hi,

This is the SQL for the current tables:

CREATE TABLE "groups"(
"group_id" Text  NOT NULL  ,
"description" Text  ,
"subject" Text  ,
"group_type" Text
);


CREATE TABLE "messages"(
"entry_id" Integer Primary Key Autoincrement  NOT NULL  ,
"timestamp" Text  ,      "message" Text  ,
"contact_name" Text  ,
"subject" Text  ,
"importance" Text  ,
 "background_color" Text  ,
 "is_group_message" Integer   DEFAULT (0),
 "group_id" Text  ,
 "protocol" Text  ,
 "direction" Text  ,
 "local_id" Text  ,
 "remote_id" Text
 );


>
> --
> Pali Rohár
> [email protected]
> _______________________________________________
> kopete-devel mailing list
> [email protected]
> https://mail.kde.org/mailman/listinfo/kopete-devel
>



-- 
Thanks,
Joshua

_______________________________________________
kopete-devel mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/kopete-devel