Re: GSoC History plugin

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

> Great, but there are missing descriptions what column means...
>
> > CREATE TABLE "groups"(
> > "group_id" Text  NOT NULL  ,
> > "description" Text  ,
> > "subject" Text  ,
> > "group_type" Text
>
> Hm ?
>
> > );
> >
> >
> > CREATE TABLE "messages"(
> > "entry_id" Integer Primary Key Autoincrement  NOT NULL  ,
> > "timestamp" Text  ,      "message" Text  ,
> > "contact_name" Text  ,
>
> Which? Local or remote?
>
> > "subject" Text  ,
>
> Why there is duplicate subject ?
>
> > "importance" Text  ,
> >  "background_color" Text  ,
>
> Is not this part of HTML message?
>
> >  "is_group_message" Integer   DEFAULT (0),
> >  "group_id" Text  ,
>
> Cannot be both columns reduced to just one?
>
> >  "protocol" Text  ,
> >  "direction" Text  ,
> >  "local_id" Text  ,
> >  "remote_id" Text
> >  );
> >
> >
>
> And where will be stored something like jabber resource?
>
> --
> Pali Rohár
> [email protected]
> _______________________________________________
> kopete-devel mailing list
> [email protected]
> https://mail.kde.org/mailman/listinfo/kopete-devel
>


Pali,
Here is an updated schema, correcting the above:


--Groups table:

CREATE TABLE "groups"(
"group_id" Text  NOT NULL  ,    --Unique identifier for the group
"description" Text  ,   -- A human readable description of the group
"subject" Text  ,    -- Topic being discussed.
"group_type" Text  -- Type of group (IRC, Skype etc)
);


-- Messages Table
CREATE TABLE "messages"(
"entry_id" Integer Primary Key Autoincrement  NOT NULL  ,    --- Date and
time of the message
"timestamp" Text  ,      "message" Text  ,   --The content of the message
in HTML format
"local_contact_name" Text  ,   -- Contact Name (Local)
"remote_contact_name" Text  ,    -- Contact Name (Remote)
"importance" Text  ,
 "group_id" Text  ,    -- If this is a group message, this will hold the
group id. If null, this is not a group message
 "protocol" Text  ,  -- Protocol in use
 "direction" Text  ,   -- Incoming or Outgoing
 "local_id" Text  ,    --  The account being used locally
 "remote_id" Text,  -- The account being used by the remote party
 "jabber_resource" text -- The jabber resource containing this message
 );

-- 
Thanks,
Joshua

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