-- phpMyAdmin SQL Dump
-- version 3.1.3
-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Úterý 24. března 2009, 13:43
-- Verze MySQL: 5.0.51
-- Verze PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

--
-- Struktura tabulky `ChatHistory`
--

CREATE TABLE IF NOT EXISTS `ChatHistory` (
  `Id` int(11) NOT NULL auto_increment,
  `Nick` varchar(64) NOT NULL default '',
  `Text` text NOT NULL,
  `Time` datetime NOT NULL default '0000-00-00 00:00:00',
  `Color` int(11) NOT NULL default '0',
  `RoomName` varchar(32) NOT NULL default '',
  `RoomType` int(11) NOT NULL default '0',
  `Host` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=528576 ;

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

--
-- Struktura tabulky `DocumentLine`
--

CREATE TABLE IF NOT EXISTS `DocumentLine` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
  `Shortcut` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL,
  `NextNumber` int(11) NOT NULL,
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Shortcut` (`Shortcut`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

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

--
-- Struktura tabulky `FinanceAdvances_old`
--

CREATE TABLE IF NOT EXISTS `FinanceAdvances_old` (
  `Id` int(11) NOT NULL auto_increment,
  `Direction` enum('In','Out') collate utf8_czech_ci NOT NULL default 'In',
  `Subject` int(11) NOT NULL default '0',
  `Value` float NOT NULL default '0',
  `TimeCreation` datetime NOT NULL default '0000-00-00 00:00:00',
  `TimePass` datetime NOT NULL default '0000-00-00 00:00:00',
  `CashFlowId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1466 ;

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

--
-- Struktura tabulky `FinanceAssetsHistory`
--

CREATE TABLE IF NOT EXISTS `FinanceAssetsHistory` (
  `AssetsId` int(11) NOT NULL default '0',
  `Time` datetime NOT NULL default '0000-00-00 00:00:00',
  `Text` varchar(255) collate utf8_czech_ci NOT NULL default '',
  `User` int(11) NOT NULL default '0',
  KEY `AssetsId` (`AssetsId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

--
-- Struktura tabulky `FinanceBills`
--

CREATE TABLE IF NOT EXISTS `FinanceBills` (
  `Id` int(11) NOT NULL auto_increment,
  `TimeFrom` datetime NOT NULL default '0000-00-00 00:00:00',
  `Subject` int(11) NOT NULL default '0',
  `TimeTo` datetime NOT NULL default '0000-00-00 00:00:00',
  `TimeCreate` datetime NOT NULL default '0000-00-00 00:00:00',
  `TimeDue` datetime NOT NULL default '0000-00-00 00:00:00',
  `BillCode` varchar(32) collate latin2_czech_cs NOT NULL,
  `Type` enum('invoice','income') collate latin2_czech_cs NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1707 ;

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

--
-- Struktura tabulky `FinanceBillsItems`
--

CREATE TABLE IF NOT EXISTS `FinanceBillsItems` (
  `Id` int(11) NOT NULL auto_increment,
  `Bill` int(11) NOT NULL default '0',
  `Description` varchar(255) collate latin2_czech_cs NOT NULL,
  `Price` float NOT NULL default '0',
  `Quantity` float NOT NULL default '1',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=13248 ;

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

--
-- Struktura tabulky `FinanceCashFlow_old`
--

CREATE TABLE IF NOT EXISTS `FinanceCashFlow_old` (
  `Id` int(11) NOT NULL auto_increment,
  `BillCode` varchar(16) collate utf8_czech_ci NOT NULL,
  `Subject` int(11) NOT NULL default '0',
  `Text` varchar(255) collate utf8_czech_ci NOT NULL default '',
  `Time` datetime NOT NULL default '0000-00-00 00:00:00',
  `Taxable` tinyint(1) NOT NULL default '0',
  `Cash` tinyint(1) NOT NULL default '0',
  `Value` float NOT NULL default '0',
  `Bill` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=434 ;

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

--
-- Struktura tabulky `FinanceClaimsLiabilities`
--

CREATE TABLE IF NOT EXISTS `FinanceClaimsLiabilities` (
  `Id` int(11) NOT NULL auto_increment,
  `BillCode` varchar(16) collate utf8_czech_ci NOT NULL,
  `Subject` int(11) NOT NULL default '0',
  `TimeCreation` datetime NOT NULL default '0000-00-00 00:00:00',
  `TimeDue` datetime NOT NULL default '0000-00-00 00:00:00',
  `TimePayment` datetime NOT NULL default '0000-00-00 00:00:00',
  `Value` float NOT NULL default '0',
  `Bill` int(11) NOT NULL default '0',
  `Text` varchar(255) collate utf8_czech_ci NOT NULL default '',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4182 ;

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

--
-- Struktura tabulky `FinanceLog`
--

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

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

--
-- Struktura tabulky `FinanceOperation`
--

CREATE TABLE IF NOT EXISTS `FinanceOperation` (
  `Id` int(11) NOT NULL auto_increment,
  `Time` datetime NOT NULL,
  `Subject` int(11) NOT NULL default '0',
  `Cash` int(11) NOT NULL default '0',
  `Value` float NOT NULL,
  `BillCode` varchar(32) collate utf8_czech_ci NOT NULL,
  `Taxable` tinyint(1) NOT NULL,
  `Bill` int(11) NOT NULL,
  `Text` varchar(255) collate utf8_czech_ci NOT NULL,
  `Network` int(11) NOT NULL default '1',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4205 ;

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

--
-- Struktura tabulky `FinanceSmallAssets`
--

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

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

--
-- Struktura tabulky `finance_charge`
--

CREATE TABLE IF NOT EXISTS `finance_charge` (
  `period` int(11) NOT NULL default '0',
  `internet` int(11) NOT NULL default '0',
  `internet_speed` int(11) NOT NULL default '0',
  `internet_speed_reserve` int(11) NOT NULL default '0',
  `administration_per_user` int(20) NOT NULL default '0',
  `kWh` int(11) NOT NULL default '0',
  `base_speed_element` int(11) NOT NULL default '0',
  `BaseTariffPrice` int(11) NOT NULL default '0',
  `TopTariffPrice` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `finance_groups`
--

CREATE TABLE IF NOT EXISTS `finance_groups` (
  `Id` int(11) NOT NULL auto_increment,
  `Description` varchar(128) character set utf8 collate utf8_czech_ci NOT NULL default '',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=4 ;

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

--
-- Struktura tabulky `finance_monthly_overall`
--

CREATE TABLE IF NOT EXISTS `finance_monthly_overall` (
  `id` int(11) NOT NULL auto_increment,
  `money` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `administration` int(11) NOT NULL default '0',
  `kWh` int(11) NOT NULL default '0',
  `administration_total` int(11) NOT NULL default '0',
  `consumption_total` int(11) NOT NULL default '0',
  `total_paid` int(11) NOT NULL default '0',
  `BaseTariffPrice` int(11) NOT NULL default '0',
  `TopTariffPrice` int(11) NOT NULL default '0',
  `member_count` int(11) NOT NULL default '0',
  `investment` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;

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

--
-- Struktura tabulky `finance_operations`
--

CREATE TABLE IF NOT EXISTS `finance_operations` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `money` int(11) NOT NULL default '0',
  `type` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `comment` varchar(255) collate latin2_czech_cs NOT NULL default '',
  `bill_id` int(11) NOT NULL default '0',
  `group` int(11) NOT NULL default '1',
  `cash` int(11) NOT NULL default '0',
  `BillCode` varchar(16) collate latin2_czech_cs NOT NULL,
  `Network` int(11) NOT NULL default '1',
  `Taxable` int(11) NOT NULL default '1',
  `Invoice` int(11) NOT NULL,
  `Source` int(11) NOT NULL,
  `Destination` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=4158 ;

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

--
-- Struktura tabulky `finance_tariffs`
--

CREATE TABLE IF NOT EXISTS `finance_tariffs` (
  `id` int(11) NOT NULL default '0',
  `period` int(11) NOT NULL default '0',
  `name` varchar(32) collate latin2_czech_cs NOT NULL default '',
  `speed_factor` float NOT NULL default '0',
  `price_units` float NOT NULL default '0',
  `group_id` int(11) NOT NULL default '0',
  `min_speed` int(11) NOT NULL default '0',
  `max_speed` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

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

--
-- Struktura tabulky `hosts`
--

CREATE TABLE IF NOT EXISTS `hosts` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(24) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `IP` varchar(16) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `external_ip` varchar(16) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `czfree_ip` varchar(16) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `MAC` varchar(32) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `block` int(11) NOT NULL default '0',
  `online` int(11) NOT NULL default '0',
  `user` int(11) NOT NULL default '0',
  `last_online` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_share_check` date NOT NULL default '0000-00-00',
  `parent` int(11) NOT NULL default '0',
  `channel` int(11) NOT NULL default '0',
  `link_type` int(11) NOT NULL default '0',
  `pptp_password` varchar(8) character set latin2 collate latin2_czech_cs NOT NULL default '0',
  `show_online` int(11) NOT NULL default '1',
  `vpn` int(11) NOT NULL default '0',
  `type` int(11) NOT NULL default '0',
  `used` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=347 ;

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

--
-- Struktura tabulky `hosts_topology`
--

CREATE TABLE IF NOT EXISTS `hosts_topology` (
  `host` int(11) NOT NULL default '0',
  `depth` int(11) NOT NULL default '0',
  `pos` int(11) NOT NULL default '0',
  `first` int(11) NOT NULL default '0',
  `last` int(11) NOT NULL default '0',
  PRIMARY KEY  (`host`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

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

--
-- Struktura tabulky `known_hosts`
--

CREATE TABLE IF NOT EXISTS `known_hosts` (
  `IP` varchar(16) NOT NULL default '',
  `hostname` varchar(16) NOT NULL default '',
  `interface` varchar(8) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `MAC` varchar(64) NOT NULL default '',
  `traffic_total_up` bigint(11) NOT NULL default '0',
  `traffic_total_down` bigint(11) NOT NULL default '0',
  `traffic_avg_up` int(11) NOT NULL default '0',
  `traffic_avg_down` int(11) NOT NULL default '0',
  `port` int(11) NOT NULL default '0',
  `protocol` varchar(8) NOT NULL default '',
  PRIMARY KEY  (`IP`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `known_hosts_ports`
--

CREATE TABLE IF NOT EXISTS `known_hosts_ports` (
  `host` varchar(16) NOT NULL default '',
  `port` int(11) NOT NULL default '0',
  `down` int(11) NOT NULL default '0',
  `up` int(11) NOT NULL default '0',
  `total_down` int(11) NOT NULL default '0',
  `total_up` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `link_types`
--

CREATE TABLE IF NOT EXISTS `link_types` (
  `id` int(11) NOT NULL auto_increment,
  `caption` varchar(64) NOT NULL default '',
  `teoretical_speed` float NOT NULL default '0',
  `real_speed` float NOT NULL default '0',
  `color` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

--
-- Struktura tabulky `Log`
--

CREATE TABLE IF NOT EXISTS `Log` (
  `Time` datetime NOT NULL default '0000-00-00 00:00:00',
  `User` int(11) NOT NULL default '0',
  `Module` varchar(64) collate utf8_czech_ci NOT NULL default '',
  `Operation` varchar(255) collate utf8_czech_ci NOT NULL default '',
  `Value` varchar(255) collate utf8_czech_ci NOT NULL default '',
  KEY `Time` (`Time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

--
-- Struktura tabulky `Meals`
--

CREATE TABLE IF NOT EXISTS `Meals` (
  `Date` date NOT NULL default '0000-00-00',
  `Soup` varchar(255) collate utf8_czech_ci NOT NULL,
  `Meal` varchar(255) collate utf8_czech_ci NOT NULL,
  `Status` int(11) NOT NULL default '0',
  UNIQUE KEY `date` (`Date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci ROW_FORMAT=DYNAMIC;

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

--
-- Struktura tabulky `MealsInfo`
--

CREATE TABLE IF NOT EXISTS `MealsInfo` (
  `Info` text collate utf8_czech_ci NOT NULL,
  `Price` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci ROW_FORMAT=DYNAMIC;

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

--
-- Struktura tabulky `Member`
--

CREATE TABLE IF NOT EXISTS `Member` (
  `Id` int(11) NOT NULL auto_increment,
  `Subject` int(11) NOT NULL,
  `ResponsibleUser` int(11) NOT NULL,
  `FamilyMemberCount` int(11) NOT NULL,
  `MembershipDate` date NOT NULL,
  `MemberState` int(11) NOT NULL,
  `InternetTariffCurrentMonth` int(11) NOT NULL,
  `InternetTariffNextMonth` int(11) NOT NULL,
  `GPS` int(11) NOT NULL,
  `BillingPeriod` enum('never','monthly','quarterly','half-yearly','yearly') collate utf8_czech_ci NOT NULL default 'monthly',
  `NetworkSegment` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=98 ;

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

--
-- Struktura tabulky `MemberPayment`
--

CREATE TABLE IF NOT EXISTS `MemberPayment` (
  `Id` int(11) NOT NULL auto_increment,
  `Member` int(11) NOT NULL,
  `MonthlyTotal` float NOT NULL,
  `MonthlyInternet` float NOT NULL,
  `MonthlyConsumption` float NOT NULL,
  `NetworkDevice` float NOT NULL,
  `MonthlyPlus` float NOT NULL,
  `Cash` float NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=83 ;

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

--
-- Struktura tabulky `NetworkDeviceHistory`
--

CREATE TABLE IF NOT EXISTS `NetworkDeviceHistory` (
  `Id` int(11) NOT NULL auto_increment,
  `Device` int(11) NOT NULL default '0',
  `Time` datetime NOT NULL default '0000-00-00 00:00:00',
  `Action` int(11) NOT NULL default '0',
  `Notice` varchar(255) collate utf8_czech_ci NOT NULL default '',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `NetworkSubnet`
--

CREATE TABLE IF NOT EXISTS `NetworkSubnet` (
  `Id` int(11) NOT NULL auto_increment,
  `AddressRange` varchar(255) collate utf8_czech_ci NOT NULL,
  `Mask` int(11) NOT NULL,
  `DHCP` varchar(255) collate utf8_czech_ci NOT NULL,
  `Gateway` varchar(255) collate utf8_czech_ci NOT NULL,
  `WINS` varchar(255) collate utf8_czech_ci NOT NULL,
  `DNS` varchar(255) collate utf8_czech_ci NOT NULL,
  `Domain` varchar(255) collate utf8_czech_ci NOT NULL,
  `NTP` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;

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

--
-- Struktura tabulky `network_devices`
--

CREATE TABLE IF NOT EXISTS `network_devices` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(128) NOT NULL default '',
  `price` int(11) NOT NULL default '0',
  `count` int(11) NOT NULL default '1',
  `date` date NOT NULL default '0000-00-00',
  `segment` int(11) NOT NULL default '0',
  `used` int(11) NOT NULL default '0',
  `consumption` int(11) NOT NULL default '0',
  `user` int(11) NOT NULL default '0',
  `info` text NOT NULL,
  `channel` int(11) NOT NULL default '0',
  `device_id` varchar(255) NOT NULL default '',
  `shop` varchar(64) NOT NULL default '',
  `deprecated_price` int(11) NOT NULL default '0',
  `TimeEnlistment` datetime NOT NULL default '0000-00-00 00:00:00',
  `TimeElimination` datetime NOT NULL default '0000-00-00 00:00:00',
  `StockCard` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=160 ;

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

--
-- Struktura tabulky `network_dns_alias`
--

CREATE TABLE IF NOT EXISTS `network_dns_alias` (
  `name` varchar(255) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `target` varchar(255) character set latin2 collate latin2_czech_cs NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `network_segments`
--

CREATE TABLE IF NOT EXISTS `network_segments` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(128) NOT NULL default '',
  `price` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  `users` int(11) NOT NULL default '0',
  `consumption` int(11) NOT NULL default '0',
  `users_overheads` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=33 ;

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

--
-- Struktura tabulky `network_udp_forwarder`
--

CREATE TABLE IF NOT EXISTS `network_udp_forwarder` (
  `port` int(11) NOT NULL default '0',
  `game` varchar(255) character set latin2 NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) collate utf8_czech_ci NOT NULL default '',
  `content` text collate utf8_czech_ci NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `target_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `author` varchar(32) collate utf8_czech_ci NOT NULL default 'Anonym',
  `ip` varchar(16) collate utf8_czech_ci NOT NULL default '',
  `category` int(11) NOT NULL default '0',
  `enclosure` varchar(255) collate utf8_czech_ci NOT NULL default '',
  `User` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `category` (`category`),
  KEY `date` (`date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30854 ;

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

--
-- Struktura tabulky `news_category`
--

CREATE TABLE IF NOT EXISTS `news_category` (
  `id` int(11) NOT NULL auto_increment,
  `caption` varchar(255) NOT NULL default '',
  `permission` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=13 ;

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

--
-- Struktura tabulky `PermissionGroup`
--

CREATE TABLE IF NOT EXISTS `PermissionGroup` (
  `Id` int(11) NOT NULL auto_increment,
  `Description` varchar(255) collate utf8_czech_ci NOT NULL default '',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ;

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

--
-- Struktura tabulky `PermissionGroupAssignment`
--

CREATE TABLE IF NOT EXISTS `PermissionGroupAssignment` (
  `Group` int(11) NOT NULL default '0',
  `GroupOrOperation` int(11) NOT NULL default '0',
  `Type` enum('Group','Operation') collate utf8_czech_ci NOT NULL default 'Group'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

--
-- Struktura tabulky `PermissionOperation`
--

CREATE TABLE IF NOT EXISTS `PermissionOperation` (
  `Id` int(11) NOT NULL auto_increment,
  `Module` varchar(64) collate utf8_czech_ci NOT NULL default '',
  `Operation` varchar(128) collate utf8_czech_ci NOT NULL default '',
  `Item` varchar(64) collate utf8_czech_ci NOT NULL default '',
  `ItemId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=37 ;

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

--
-- Struktura tabulky `PermissionUserAssignment`
--

CREATE TABLE IF NOT EXISTS `PermissionUserAssignment` (
  `User` int(11) NOT NULL default '0',
  `GroupOrOperation` int(11) NOT NULL default '0',
  `Type` enum('Group','Operation') collate utf8_czech_ci NOT NULL default 'Group'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

--
-- Struktura tabulky `services_restart`
--

CREATE TABLE IF NOT EXISTS `services_restart` (
  `id` int(11) NOT NULL auto_increment,
  `caption` varchar(255) character set latin2 NOT NULL default '',
  `generator` varchar(255) character set latin2 NOT NULL default '',
  `restarter` varchar(255) character set latin2 NOT NULL default '',
  `changed` int(11) NOT NULL default '0',
  `last_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

--
-- Struktura tabulky `stat_hosts`
--

CREATE TABLE IF NOT EXISTS `stat_hosts` (
  `host_id` int(11) NOT NULL default '0',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `count` int(11) NOT NULL default '0',
  KEY `host_id` (`host_id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `StockCard`
--

CREATE TABLE IF NOT EXISTS `StockCard` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL,
  `SellPrice` float NOT NULL,
  `Consumption` int(11) NOT NULL COMMENT 'In Watts',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `Subject`
--

CREATE TABLE IF NOT EXISTS `Subject` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(64) collate utf8_czech_ci NOT NULL default '',
  `AddressStreet` varchar(64) collate utf8_czech_ci NOT NULL default '',
  `AddressTown` varchar(64) collate utf8_czech_ci NOT NULL default '',
  `AddressPSC` int(11) NOT NULL default '0',
  `IC` int(11) NOT NULL default '0',
  `DIC` varchar(32) collate utf8_czech_ci NOT NULL default '',
  `MapPositionX` float NOT NULL default '0',
  `MapPositionY` float NOT NULL default '0',
  `WWW` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=105 ;

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

--
-- Struktura tabulky `SubjectOpenTime`
--

CREATE TABLE IF NOT EXISTS `SubjectOpenTime` (
  `Subject` int(11) NOT NULL default '0',
  `UpdateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `Notice` varchar(255) collate utf8_czech_ci NOT NULL default '',
  PRIMARY KEY  (`Subject`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

--
-- Struktura tabulky `SubjectOpenTimeInterval`
--

CREATE TABLE IF NOT EXISTS `SubjectOpenTimeInterval` (
  `Id` int(11) NOT NULL auto_increment,
  `Subject` int(11) NOT NULL default '0',
  `DayOfWeek` int(11) NOT NULL default '0',
  `OpenTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `CloseTime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=50 ;

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

--
-- Struktura tabulky `sunrisechat_history`
--

CREATE TABLE IF NOT EXISTS `sunrisechat_history` (
  `id` int(11) NOT NULL auto_increment,
  `nick` varchar(64) NOT NULL default '',
  `text` text NOT NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `color` int(11) NOT NULL default '0',
  `roomname` varchar(32) NOT NULL default '',
  `roomtype` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=528523 ;

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

--
-- Struktura tabulky `sunrisechat_onlinelist`
--

CREATE TABLE IF NOT EXISTS `sunrisechat_onlinelist` (
  `id` int(11) NOT NULL auto_increment,
  `sender_ip` varchar(16) character set latin2 NOT NULL default '',
  `sender_id` int(11) NOT NULL default '0',
  `nick` varchar(64) character set latin2 NOT NULL default '',
  `color` int(11) NOT NULL default '0',
  `lasttime` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` varchar(16) character set latin2 NOT NULL default '',
  `operating_system` varchar(32) character set latin2 NOT NULL default '',
  `sequence` int(11) NOT NULL default '0',
  `info` varchar(255) character set latin2 NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=78758 ;

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

--
-- Struktura tabulky `test`
--

CREATE TABLE IF NOT EXISTS `test` (
  `text` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `tkr`
--

CREATE TABLE IF NOT EXISTS `tkr` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(16) NOT NULL default '',
  `freq` int(11) NOT NULL default '0',
  `norm` varchar(8) NOT NULL default '',
  `www` varchar(255) NOT NULL default '',
  `lang` varchar(32) NOT NULL default '',
  `shortname` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=25 ;

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

--
-- Struktura tabulky `User`
--

CREATE TABLE IF NOT EXISTS `User` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(64) collate utf8_czech_ci NOT NULL default '',
  `FirstName` varchar(128) collate utf8_czech_ci NOT NULL default '',
  `SecondName` varchar(128) collate utf8_czech_ci NOT NULL default '',
  `Nick` varchar(128) collate utf8_czech_ci NOT NULL default '',
  `Password` text collate utf8_czech_ci NOT NULL,
  `Email` varchar(128) collate utf8_czech_ci NOT NULL default '',
  `LastIpAddress` varchar(16) collate utf8_czech_ci NOT NULL default '',
  `LastLoginTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `RegistrationTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `Member` int(11) NOT NULL,
  `Locked` tinyint(1) NOT NULL default '1',
  `ICQ` int(11) NOT NULL default '0',
  `PhoneNumber` varchar(32) collate utf8_czech_ci NOT NULL default '',
  `InitPassword` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ;

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

--
-- Struktura tabulky `UserOnline`
--

CREATE TABLE IF NOT EXISTS `UserOnline` (
  `Id` int(11) NOT NULL auto_increment,
  `User` int(11) NOT NULL default '0',
  `ActivityTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `LoginTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `SessionId` varchar(255) collate utf8_czech_ci NOT NULL default '',
  `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL default '',
  `HostName` varchar(255) collate utf8_czech_ci NOT NULL default '',
  `ScriptName` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`),
  KEY `User` (`User`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;

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

--
-- Struktura tabulky `users_old`
--

CREATE TABLE IF NOT EXISTS `users_old` (
  `id` int(11) NOT NULL auto_increment,
  `first_name` varchar(64) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `second_name` varchar(64) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `email` varchar(128) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `phone` int(9) NOT NULL default '0',
  `icq` int(11) NOT NULL default '0',
  `password` varchar(32) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `nick` varchar(32) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `role` int(11) NOT NULL default '0',
  `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `family` int(11) NOT NULL default '0',
  `notice` varchar(255) character set latin2 collate latin2_czech_cs NOT NULL default '',
  `PositionX` int(11) NOT NULL default '0',
  `PositionY` int(11) NOT NULL default '0',
  `network_device` int(11) NOT NULL default '0',
  `cash` int(11) NOT NULL default '0',
  `network_segment` int(11) NOT NULL default '0',
  `inet` int(11) NOT NULL default '0',
  `hw` int(11) NOT NULL default '1',
  `overheads` int(11) NOT NULL default '1',
  `monthly` int(11) NOT NULL default '0',
  `plus` int(11) NOT NULL default '0',
  `consumption` int(11) NOT NULL default '0',
  `inet_hw` int(11) NOT NULL default '0',
  `membership_date` date NOT NULL default '0000-00-00',
  `inet_tarif_now` int(11) NOT NULL default '2',
  `inet_tarif_next` int(11) NOT NULL default '2',
  `monthly_inet` int(11) NOT NULL default '0',
  `subject_name` varchar(128) character set utf8 collate utf8_czech_ci NOT NULL default '',
  `street` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL default '',
  `town` varchar(64) character set utf8 collate utf8_czech_ci NOT NULL default '',
  `psc` int(11) NOT NULL default '0',
  `ico` int(11) NOT NULL default '0',
  `dic` varchar(32) NOT NULL default '',
  `BillingPeriod` enum('never','monthly','quarterly','half-yearly','yearly') NOT NULL default 'monthly',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `nick` (`nick`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=98 ;

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

--
-- Struktura tabulky `users_online`
--

CREATE TABLE IF NOT EXISTS `users_online` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `session` varchar(128) character set latin2 NOT NULL default '',
  `ip` varchar(64) character set latin2 NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=282 ;

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

--
-- Struktura tabulky `users_roles`
--

CREATE TABLE IF NOT EXISTS `users_roles` (
  `Id` int(11) NOT NULL auto_increment,
  `Description` varchar(128) collate utf8_czech_ci NOT NULL default '',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;

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

--
-- Struktura tabulky `wlan_db`
--

CREATE TABLE IF NOT EXISTS `wlan_db` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `value` float NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=12 ;

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

--
-- Struktura tabulky `wlan_links`
--

CREATE TABLE IF NOT EXISTS `wlan_links` (
  `id` int(11) NOT NULL auto_increment,
  `point1` int(11) NOT NULL default '0',
  `point2` int(11) NOT NULL default '0',
  `distance` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

--
-- Struktura tabulky `wlan_list`
--

CREATE TABLE IF NOT EXISTS `wlan_list` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) character set latin2 NOT NULL default '',
  `device` int(11) NOT NULL default '0',
  `antena` int(11) NOT NULL default '0',
  `cable` int(11) NOT NULL default '0',
  `cable_length` int(11) NOT NULL default '0',
  `connector1` int(11) NOT NULL default '0',
  `connector2` int(11) NOT NULL default '0',
  `total` int(11) NOT NULL default '0',
  `comment` int(11) NOT NULL default '0',
  `total_passive` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
