Mercurial > pidgin.yaz
view pidgin/plugins/cap/cap-mysql.sql @ 16871:86ba72a2b31e
merge of '27e1df003532e1209f1f56770923ca4c7674d7ca'
and 'ace1e60dda39081ec5404dfa76fa55f79b3e30c6'
author | Daniel Atallah <daniel.atallah@gmail.com> |
---|---|
date | Fri, 04 May 2007 04:02:14 +0000 |
parents | 56430bf7fe9d |
children | 44b4e8bd759b |
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., 59 Temple Place - Suite 330, Boston, MA -- 02111-1307, 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) );