text: -- phpMyAdmin SQL Dump
  -- version 3.5.2.2
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Erstellungszeit: 01. Dez 2013 um 19:19
  -- Server Version: 5.5.27
  -- PHP-Version: 5.4.7
  
  SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  
  --
  -- Datenbank: `homebank`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Tabellenstruktur für Tabelle `account`
  --
  
  CREATE TABLE IF NOT EXISTS `account` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(128) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
  
  --
  -- Daten für Tabelle `account`
  --
  
  INSERT INTO `account` (`id`, `name`) VALUES
  (1, 'Bargeld'),
  (2, 'Sparkasse');
  
  -- --------------------------------------------------------
  
  --
  -- Tabellenstruktur für Tabelle `category`
  --
  
  CREATE TABLE IF NOT EXISTS `category` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(128) NOT NULL,
    `symbol` varchar(128) NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
  
  --
  -- Daten für Tabelle `category`
  --
  
  INSERT INTO `category` (`id`, `name`, `symbol`) VALUES
  (1, 'Lebensmittel', 'leaf'),
  (2, 'Anderes', 'asterisk'),
  (3, 'Spar', 'cog'),
  (4, 'Kredit', 'folder-close'),
  (5, 'Auto', 'dashboard'),
  (6, 'Versicherung', 'flash'),
  (7, 'Haus', 'home'),
  (8, 'Telefon', 'phone'),
  (9, 'Gehalt', 'usd'),
  (10, 'Bar', NULL),
  (11, 'Sparkasse', 'wrench'),
  (12, 'Urlaub', NULL),
  (13, 'Umzug', NULL),
  (14, '', NULL),
  (15, 'Polizei', NULL),
  (16, 'Geschenk', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Tabellenstruktur für Tabelle `transaction`
  --
  
  CREATE TABLE IF NOT EXISTS `transaction` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `date` datetime NOT NULL,
    `category_id` int(11) DEFAULT NULL,
    `type_id` int(11) NOT NULL,
    `account_id` int(11) NOT NULL,
    `account_to_id` int(11) DEFAULT NULL,
    `comment` varchar(128) NOT NULL,
    `amount` decimal(10,2) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
  
  --
  -- Daten für Tabelle `transaction`
  --
  
  
  -- --------------------------------------------------------
  
  --
  -- Tabellenstruktur für Tabelle `type`
  --
  
  CREATE TABLE IF NOT EXISTS `type` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(128) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
  
  --
  -- Daten für Tabelle `type`
  --
  
  INSERT INTO `type` (`id`, `name`) VALUES
  (1, 'income'),
  (2, 'expense'),
  (3, 'transfer'),
  (4, 'balance');
  
  
  -- --------------------------------------------------------
  
  --
  -- Tabellenstruktur für Tabelle `loan`
  --
  
  CREATE TABLE IF NOT EXISTS `loan` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(128) NOT NULL,
    `date` datetime NOT NULL,
    `amount` decimal(10,2) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
  
  --
  -- Daten für Tabelle `loan`
  --
  
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  