On Wed, Jun 17, 2015 at 12:46 PM, Pali Rohár <pali.ro...@gmail.com> 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 > pali.ro...@gmail.com > _______________________________________________ > kopete-devel mailing list > kopete-devel@kde.org > 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 kopete-devel@kde.org https://mail.kde.org/mailman/listinfo/kopete-devel
