-- http://www.phpmyadmin.net
--
-- Erstellungszeit: 19. Nov 2013 um 14:10
-- Server Version: 5.5.31
-- PHP-Version: 5.3.27




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

--
-- Tabellenstruktur für Tabelle `groupmembers`
--

CREATE TABLE IF NOT EXISTS `groupmembers` (
  `group_id` int(10) unsigned NOT NULL,
  `account_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Tabellenstruktur für Tabelle `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `site_id` smallint(5) unsigned DEFAULT NULL,
  `name` varchar(160) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `state` smallint(5) unsigned NOT NULL,
  `masteradmin` tinyint(1) NOT NULL COMMENT 'boolean',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent` bigint(20) DEFAULT NULL,
  `eventtime` datetime NOT NULL,
  `site_id` smallint(6) DEFAULT NULL,
  `level` smallint(6) NOT NULL,
  `area` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `areaname` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `user` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `code` int(11) DEFAULT NULL,
  `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `event` (`eventtime`,`site_id`,`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

