-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- Počítač: localhost
-- Vygenerováno: Středa 16. dubna 2008, 18:50
-- Verze MySQL: 5.0.45
-- Verze PHP: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Databáze: `is`
-- 

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

-- 
-- Struktura tabulky `FinanceAdvances`
-- 

CREATE TABLE `FinanceAdvances` (
  `Id` int(11) NOT NULL auto_increment,
  `Direction` enum('In','Out') collate utf8_czech_ci NOT NULL,
  `Subject` int(11) NOT NULL,
  `Value` float NOT NULL,
  `TimeCreation` datetime NOT NULL,
  `TimePass` datetime NOT NULL,
  `CashFlowId` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=321 ;

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

-- 
-- Struktura tabulky `FinanceAssetsHistory`
-- 

CREATE TABLE `FinanceAssetsHistory` (
  `AssetsId` int(11) NOT NULL,
  `Time` datetime NOT NULL,
  `Text` varchar(255) collate utf8_czech_ci NOT NULL,
  `User` int(11) NOT NULL,
  KEY `AssetsId` (`AssetsId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

-- 
-- Struktura tabulky `FinanceCashFlow`
-- 

CREATE TABLE `FinanceCashFlow` (
  `Id` int(11) NOT NULL auto_increment,
  `Subject` int(11) NOT NULL,
  `Text` varchar(255) collate utf8_czech_ci NOT NULL,
  `Time` datetime NOT NULL,
  `Taxable` tinyint(1) NOT NULL,
  `Cash` tinyint(1) NOT NULL,
  `Value` float NOT NULL,
  `Bill` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=111 ;

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

-- 
-- Struktura tabulky `FinanceClaimsLiabilities`
-- 

CREATE TABLE `FinanceClaimsLiabilities` (
  `Id` int(11) NOT NULL auto_increment,
  `Subject` int(11) NOT NULL,
  `TimeCreation` datetime NOT NULL,
  `TimeDue` datetime NOT NULL,
  `TimePayment` datetime NOT NULL,
  `Value` float NOT NULL,
  `Bill` int(11) NOT NULL,
  `Text` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=258 ;

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

-- 
-- Struktura tabulky `FinanceLog`
-- 

CREATE TABLE `FinanceLog` (
  `Id` int(11) NOT NULL auto_increment,
  `Time` datetime NOT NULL,
  `Text` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

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

-- 
-- Struktura tabulky `FinanceSmallAssets`
-- 

CREATE TABLE `FinanceSmallAssets` (
  `Id` int(11) NOT NULL auto_increment,
  `Text` varchar(255) collate utf8_czech_ci NOT NULL,
  `PricePurchase` float NOT NULL,
  `TimeEnlistment` datetime NOT NULL,
  `TimeElimination` datetime NOT NULL,
  `SupplySubject` int(11) NOT NULL,
  `DeviceId` varchar(128) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
