Mercurial > pidgin.yaz
view pidgin/plugins/cap/cap-mysql.sql @ 28352:a195ce8eb805
Update versions. Yes, I'm aware I skipped a number. I just don't want to
make you run configure twice.
author | Elliott Sales de Andrade <qulogic@pidgin.im> |
---|---|
date | Wed, 19 Aug 2009 00:41:06 +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) );