CREATE TABLE IF NOT EXISTS `groups` (
  `id` bigint(20) NOT NULL,
  `chatusername` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Group id here` (
  `id` int(40) NOT NULL,
  `username` varchar(32) DEFAULT NULL,
  `role` tinyint(4) NOT NULL DEFAULT '0',
  `messageCounter` int(11) unsigned NOT NULL DEFAULT '0',
  `free` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;