icqtalk.sql

The goal with this project was to make it possible for almost any mobile-phone to use ICQ and be abl

DROP TABLE IF EXISTS alive;
CREATE TABLE alive (
  uin varchar(15) NOT NULL default '',
  lifesign bigint(14) default NULL
) TYPE=MyISAM;






DROP TABLE IF EXISTS contactlist;
CREATE TABLE contactlist (
  id int(11) NOT NULL auto_increment,
  uin varchar(15) NOT NULL default '',
  cnick varchar(15) NOT NULL default '',
  cuin varchar(15) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;






DROP TABLE IF EXISTS cookies;
CREATE TABLE cookies (
  uin varchar(15) NOT NULL default '',
  cookie text NOT NULL,
  ip varchar(15) NOT NULL default '',
  port varchar(5) NOT NULL default ''
) TYPE=MyISAM;






DROP TABLE IF EXISTS incoming;
CREATE TABLE incoming (
  id int(11) NOT NULL auto_increment,
  fromuin varchar(15) NOT NULL default '',
  touin varchar(15) NOT NULL default '',
  msg text NOT NULL,
  msgtime datetime default NULL,
  online tinyint(4) NOT NULL default '0',
  seen tinyint(4) NOT NULL default '0',
  KEY id (id)
) TYPE=MyISAM;






DROP TABLE IF EXISTS outgoing;
CREATE TABLE outgoing (
  id int(11) NOT NULL auto_increment,
  fromuin varchar(15) NOT NULL default '',
  touin varchar(15) NOT NULL default '',
  msg text NOT NULL,
  msgtime datetime default NULL,
  seen tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;






DROP TABLE IF EXISTS uinstatus;
CREATE TABLE uinstatus (
  uin varchar(15) NOT NULL default '',
  statusstr text NOT NULL
) TYPE=MyISAM;