-- Host: localhost
-- Erstellungszeit: 16. Dez 2014 um 19:41
-- Server Version: 5.5.40
-- PHP-Version: 5.4.35-0+deb7u2
-- Author: Dipl.-Inform. (FH) Andreas Link

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Datenbank: `homebus`
--

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

--
-- Tabellenstruktur für Tabelle `ioevents`
--

DROP TABLE IF EXISTS `ioevents`;
CREATE TABLE IF NOT EXISTS `ioevents` (
  `entry` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'PrimaryKey Autoincrement',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Zeitpunkt des Eintrages',
  `A0` tinyint(3) unsigned NOT NULL,
  `A1` tinyint(3) unsigned NOT NULL,
  `A2` tinyint(3) unsigned NOT NULL,
  `A3` tinyint(3) unsigned NOT NULL,
  `A4` tinyint(3) unsigned NOT NULL,
  `A5` tinyint(3) unsigned NOT NULL,
  `A6` tinyint(3) unsigned NOT NULL,
  `A7` tinyint(3) unsigned NOT NULL,
  `B0` tinyint(3) unsigned NOT NULL,
  `B1` tinyint(3) unsigned NOT NULL,
  `B2` tinyint(3) unsigned NOT NULL,
  `B3` tinyint(3) unsigned NOT NULL,
  `B4` tinyint(3) unsigned NOT NULL,
  `B5` tinyint(3) unsigned NOT NULL,
  `B6` tinyint(3) unsigned NOT NULL,
  `B7` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`entry`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Verlauf aller über Interrupts ausgeloesten Events' AUTO_INCREMENT=1 ;