groups_*

CREATE TABLE IF NOT EXISTS `groups_data` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(50) NOT NULL,
  `desc` VARCHAR(255) NOT NULL,
  `badge` VARCHAR(50) NOT NULL,
  `owner_id` INT(11) UNSIGNED NOT NULL,
  `created` INT(50) NOT NULL,
  `room_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `state` INT(1) UNSIGNED NOT NULL DEFAULT '0',
  `colour1` INT(11) NOT NULL DEFAULT '242424',
  `colour2` INT(11) NOT NULL DEFAULT '242424',
  `admindeco` INT(1) UNSIGNED DEFAULT '1',
  `has_forum` enum('0','1') NOT NULL DEFAULT '0',
  `forum_name` VARCHAR(255) NOT NULL DEFAULT '',
  `forum_description` VARCHAR(4096) NOT NULL DEFAULT '',
  `forum_messages_count` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `forum_score` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `forum_lastposter_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `forum_lastposter_name` VARCHAR(255) NOT NULL DEFAULT '0',
  `forum_lastposter_timestamp` INT(11) NOT NULL DEFAULT '0',
  `who_can_read` INT(11) NOT NULL DEFAULT '0',
  `who_can_post` INT(11) NOT NULL DEFAULT '1',
  `who_can_thread` INT(11) NOT NULL DEFAULT '1',
  `who_can_mod` INT(11) NOT NULL DEFAULT '2',
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `groups_members`
--

CREATE TABLE IF NOT EXISTS `groups_members` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `group_id` INT(11) NOT NULL,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `rank` INT(1) NOT NULL DEFAULT '0',
  `date_join` INT(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `groupid` (`group_id`) USING BTREE,
  KEY `userid` (`user_id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `groups_requests`
--

CREATE TABLE IF NOT EXISTS `groups_requests` (
  `group_id` INT(11) UNSIGNED NOT NULL,
  `user_id` INT(11) UNSIGNED NOT NULL,
  KEY `groupid` (`group_id`) USING BTREE,
  KEY `userid` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;