Mercurial > pidgin.yaz
view pidgin/plugins/cap/cap-mysql.sql @ 24142:fb722b8b4c74
attempts to resend message on switchboard error once, tested by maually
disabling switchboard connection on the receiving side
I have a feeling that there is a real bug somewhere, but this would at
least allow the message to make through (after some delay)
References #3330
author | Ka-Hing Cheung <khc@hxbc.us> |
---|---|
date | Tue, 30 Sep 2008 05:52:57 +0000 |
parents | 44b4e8bd759b |
children |
line wrap: on
line source
-- Contact Availability Prediction plugin for Pidgin -- -- Copyright (C) 2006 Geoffrey Foster. -- -- This program is free software; you can redistribute it and/or -- modify it under the terms of the GNU General Public License as -- published by the Free Software Foundation; either version 2 of the -- License, or (at your option) any later version. -- -- This program is distributed in the hope that it will be useful, but -- WITHOUT ANY WARRANTY; without even the implied warranty of -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU -- General Public License for more details. -- -- You should have received a copy of the GNU General Public License -- along with this program; if not, write to the Free Software -- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA -- 02111-1301, USA. drop table if exists cap_status; drop table if exists cap_message; drop table if exists cap_msg_count; drop table if exists cap_status_count; drop table if exists cap_my_usage; create table if not exists cap_status ( buddy varchar(60) not null, account varchar(60) not null, protocol varchar(60) not null, status varchar(60) not null, event_time datetime not null, primary key (buddy, account, protocol, event_time) ); create table if not exists cap_message ( sender varchar(60) not null, receiver varchar(60) not null, account varchar(60) not null, protocol varchar(60) not null, word_count integer not null, event_time datetime not null, primary key (sender, account, protocol, receiver, event_time) ); create table if not exists cap_msg_count ( buddy varchar(60) not null, account varchar(60) not null, protocol varchar(60) not null, minute_val int not null, success_count int not null, failed_count int not null, primary key (buddy, account, protocol, minute_val) ); create table if not exists cap_status_count ( buddy varchar(60) not null, account varchar(60) not null, protocol varchar(60) not null, status varchar(60) not null, success_count int not null, failed_count int not null, primary key (buddy, account, protocol, status) ); create table if not exists cap_my_usage ( account varchar(60) not null, protocol varchar(60) not null, online tinyint not null, event_time datetime not null, primary key(account, protocol, online, event_time) );