-- phpMyAdmin SQL Dump
-- version 2.9.0.3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 07. Juli 2007 um 11:28
-- Server Version: 5.0.27
-- PHP-Version: 5.2.0
-- 
-- Datenbank: `wxmonitor`
-- 
CREATE DATABASE `wxmonitor` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `wxmonitor`;

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

-- 
-- Tabellenstruktur für Tabelle `fms`
-- 

CREATE TABLE `fms` (
  `id` int(11) NOT NULL auto_increment,
  `datetime` int(11) NOT NULL,
  `t_alarm` int(1) NOT NULL,
  `t_status` int(1) NOT NULL,
  `schleife` varchar(30) NOT NULL,
  `text` text NOT NULL,
  `status` varchar(2) NOT NULL,
  `richtung` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1884815 ;

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

-- 
-- Tabellenstruktur für Tabelle `fzg`
-- 

CREATE TABLE `fzg` (
  `id` int(11) NOT NULL auto_increment,
  `kennung` varchar(255) NOT NULL,
  `rufname` varchar(255) NOT NULL,
  `hiorg_name` varchar(255) NOT NULL,
  `hiorg` varchar(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=211 ;

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

-- 
-- Tabellenstruktur für Tabelle `ric_watch`
-- 

CREATE TABLE `ric_watch` (
  `user_id` int(11) NOT NULL,
  `fzg_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Tabellenstruktur für Tabelle `user`
-- 

CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `passwort` varchar(255) NOT NULL,
  `login` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;