Changeset 221 for trunk


Ignore:
Timestamp:
May 27, 2009, 9:05:21 PM (15 years ago)
Author:
george
Message:
  • Upraveno: Částečný přepis vzhledu tabulky s aktualitami do CSS.
  • Upraveno: Zobrazovat již pouze tabulku následujících tarifů.
Location:
trunk
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • trunk/Readme.txt

    r202 r221  
    1919  finance/doklady - účetní doklady
    2020  aktuality/uploads - přílohy aktualit
     21  galerie - fotogalerie obrázků
    2122
    2223
    … …  
    3132
    3233  Nutno nainstalovat balík htmldoc. Na Fedoře pomocí yum install htmldoc.
     34

  • trunk/aktuality/news.php

    r196 r221  
    2121    $DbResult = $Database->select('NewsCategory', '*', 'Id='.$Category);
    2222    $Row = $DbResult->fetch_array();
    23     $Output = '<table cellspacing="0" cellpadding="0" border="0" width="100%" style="font-size: small; padding-bottom: 5px;"><tr>';
     23    $Output = '<table class="NewsBaseTable"><tr>';
    2424    $Output .= '<td>'.$Row['Caption'].'</td><td align="right">';
    2525    $Output .= '<a href="aktuality/index.php?category='.$Category.'">Zobrazit všechny aktuality</a>&nbsp;';
    … …  
    3535    if($DbResult->num_rows > 0)
    3636    {
    37       $Output .= '<table cellspacing="0" width="100%" class="NewsTable">';
     37      $Output .= '<table class="NewsTable">';
    3838      while($Row = $DbResult->fetch_array())
    3939      {
    4040        if($Row['Name'] == '') $Author = $Row['Author'];
    4141          else $Author = $Row['Name'];
    42         $Output .= '<tr><td onclick="window.location=\'aktuality/index.php?action=view&amp;id='.$Row['Id'].'\'" onmouseover="zobraz('."'new".$Category.$Index."'".')" style="cursor: pointer; margin: 0px;"><table cellspacing="0" cellpadding="0" style="padding: 0px; margin: 0px; font-size: small; color: red;" width="100%"><tr><td style="font-size: '.$FontSize.'pt"><strong>'.$Row['Title'].'</strong></td><td align="right" style="font-size: '.$FontSize.'pt">'.$Author.' ('.HumanDate($Row['Date']).')</td></tr></table>';
     42        $Output .= '<tr><td onclick="window.location=\'aktuality/index.php?action=view&amp;id='.$Row['Id'].'\'" onmouseover="zobraz('."'new".$Category.$Index."'".')" style="cursor: pointer; margin: 0px;"><table class="NewsItemFrame"><tr><td style="font-size: '.$FontSize.'pt"><strong>'.$Row['Title'].'</strong></td><td align="right" style="font-size: '.$FontSize.'pt">'.$Author.' ('.HumanDate($Row['Date']).')</td></tr></table>';
    4343        $Output .= '<div id="new'.$Category.$Index.'" class="NewsTableItem">'.$Row['Content'];
    4444
    … …  
    5858      $Output .= '</table>';
    5959    }
    60     $Output .= '</td></tr></table>'."\n\n";
     60    $Output .= '</td></tr></table>';
    6161    return($Output);
    6262  }
    … …  
    8686  function Show()
    8787  {
    88     $Output = '<div class="PanelTitle"><span class="MenuItem">Aktuálně</span><div class="MenuItem2"><a href="?Action=CustomizeNews">Upravit</a></div></div>';
     88    $Output = '<div class="PanelTitle"><span class="MenuItem">Aktuálně</span><span class="MenuItem2"><a href="?Action=CustomizeNews">Upravit</a></span></div>';
    8989
    9090    $UploadedFilesFolder = 'aktuality/uploads/';

  • trunk/finance/tarify.php

    r204 r221  
    3535        $Finance = &$this->System->Modules['Finance'];
    3636    $Output = 'Počet členů s internetovým připojením: <strong>'.$Finance->InternetUsers.'</strong><br /><br />';
     37/*
    3738    $Output .= '<table><tr><td valign="top">';
    38 
    3939    $Finance->LoadMonthParameters(0);
    4040    $Output .= '<strong>Stav pro aktuální měsíc:</strong><br />';
    … …  
    4343    $Output .= '<br /></td></tr><tr><td valign="top">';
    4444
     45    $Output .= '</td></tr></table>';
     46*/
    4547    $Finance->LoadMonthParameters(1);
    46     $Output .= '<strong>Stav pro další měsíc:</strong><br />';
     48    $Output .= '<strong>Tabulka tarifů:</strong><br />';
    4749    $Output .= $this->TariffTable();
    48 
    49     $Output .= '</td></tr></table>';
    5050
    5151    $Output .= '<br /><strong>Doplňující informace:</strong><br />';
    … …  
    5454    Skutečná rychlost může mírně kolísat kolem těchto hodnot, jelikož řízení toku není dokonalé.<br />
    5555    Agregační pomněr je poměr mezi minimální garantovanou rychlostí a maximální dosažitelnou rychlostí. Ukazuje, jak moc je linka sdílena a jak hodně může rychlost kolísat. Při posuzování kvality linky je toto také důležitý ukazatel.<br />
    56     Cenové jednotky vystihují jakým podílem se poplatek za tarif podílí na celkové placené sumě.<br />
    5756    Počet podílníků znamená počet uživatelů platících daný tarif.<br />
    58     Údaj celkem cenových jednotek je součin počtu podílníků a cenových jednotek. Vystihuje podíl všech uživatelů v daném tarifu na celkové placené sumě.<br />
    59     Cena udává rozpočtenou celkovou cenu na jednotlivé tarify podle cenových jednotek.<br />
     57    Cena udává stanovenou cenu pro jednotlivé tarify. Je uplatněn motivační princip, že při dvojnásobné rychlosti cena stoupá o 1,5 násobek. V ceně je zahrnut pevný základ 50 Kč za údržbu sítě.<br />
    6058    Sloupec vybráno dává informaci, kolik se v kterém tarifu vybralo peněz na placení společné linky.<br /><br />';
    61     $Output .= 'Tabulka Stav pro aktuální měsíc se aktualizuje první den v měsíci při odečtení peněz z účtů dle tabulky na příští měsíc.<br />';
    6259
    63     $Output .= '<br />Změnu tarifu na další měsíc oznamujte prozatím na email robie@centrum.cz<br />';
     60    $Output .= '<br />Tarif na další období si lze nastavit po přihlášení do systému pomocí nastavení domácnosti přes pravé užifatelské menu.<br />';
    6461    $Output .= '<a href="http://centrala.zdechov.net/forum/viewtopic.php?t=50">Diskuse</a><br />';
    6562    return($Output);

  • trunk/sql/full.sql

    r181 r221  
    11-- phpMyAdmin SQL Dump
    2 -- version 3.1.3
     2-- version 3.1.5
    33-- http://www.phpmyadmin.net
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Úterý 24. března 2009, 22:51
    7 -- Verze MySQL: 5.0.51
     6-- Vygenerováno: Středa 27. května 2009, 20:30
     7-- Verze MySQL: 5.0.77
    88-- Verze PHP: 5.2.6
    99
    … …  
    1111
    1212--
    13 -- Databáze: `is`
     13-- Databáze: `centrala`
    1414--
    1515
    … …  
    2222CREATE TABLE IF NOT EXISTS `ChatHistory` (
    2323  `Id` int(11) NOT NULL auto_increment,
    24   `Nick` varchar(64) NOT NULL default '',
    25   `Text` text NOT NULL,
     24  `Nick` varchar(64) collate utf8_czech_ci NOT NULL,
     25  `Text` text collate utf8_czech_ci NOT NULL,
    2626  `Time` datetime NOT NULL default '0000-00-00 00:00:00',
    2727  `Color` int(11) NOT NULL default '0',
    28   `RoomName` varchar(32) NOT NULL default '',
     28  `RoomName` varchar(32) collate utf8_czech_ci NOT NULL,
    2929  `RoomType` int(11) NOT NULL default '0',
    30   `Host` varchar(255) NOT NULL default '',
    31   PRIMARY KEY  (`Id`)
    32 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=528576 ;
     30  `Host` varchar(255) collate utf8_czech_ci NOT NULL,
     31  PRIMARY KEY  (`Id`)
     32) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=528576 ;
    3333
    3434-- --------------------------------------------------------
    … …  
    4040CREATE TABLE IF NOT EXISTS `DocumentLine` (
    4141  `Id` int(11) NOT NULL auto_increment,
    42   `Name` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
    43   `Shortcut` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL,
     42  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     43  `Shortcut` varchar(16) collate utf8_czech_ci NOT NULL,
    4444  `NextNumber` int(11) NOT NULL,
    4545  PRIMARY KEY  (`Id`),
    4646  UNIQUE KEY `Shortcut` (`Shortcut`)
    47 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
    48 
    49 -- --------------------------------------------------------
    50 
    51 --
    52 -- Struktura tabulky `FinanceAdvances_old`
    53 --
    54 
    55 CREATE TABLE IF NOT EXISTS `FinanceAdvances_old` (
    56   `Id` int(11) NOT NULL auto_increment,
    57   `Direction` enum('In','Out') collate utf8_czech_ci NOT NULL default 'In',
    58   `Subject` int(11) NOT NULL default '0',
    59   `Value` float NOT NULL default '0',
    60   `TimeCreation` datetime NOT NULL default '0000-00-00 00:00:00',
    61   `TimePass` datetime NOT NULL default '0000-00-00 00:00:00',
    62   `CashFlowId` int(11) NOT NULL default '0',
    63   PRIMARY KEY  (`Id`)
    64 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1466 ;
     47) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
     48
     49-- --------------------------------------------------------
     50
     51--
     52-- Struktura tabulky `EmailQueue`
     53--
     54
     55CREATE TABLE IF NOT EXISTS `EmailQueue` (
     56  `Id` int(11) NOT NULL auto_increment,
     57  `Time` datetime NOT NULL,
     58  `Subject` varchar(255) collate utf8_czech_ci NOT NULL,
     59  `Content` text collate utf8_czech_ci NOT NULL,
     60  `Address` varchar(255) collate utf8_czech_ci NOT NULL,
     61  `Headers` varchar(255) collate utf8_czech_ci NOT NULL,
     62  `Archive` int(11) NOT NULL default '0',
     63  PRIMARY KEY  (`Id`)
     64) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=79 ;
    6565
    6666-- --------------------------------------------------------
    … …  
    8181
    8282--
     83-- Struktura tabulky `FinanceBillingPeriod`
     84--
     85
     86CREATE TABLE IF NOT EXISTS `FinanceBillingPeriod` (
     87  `Id` int(11) NOT NULL auto_increment,
     88  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     89  `MonthCount` int(11) NOT NULL,
     90  PRIMARY KEY  (`Id`)
     91) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ;
     92
     93-- --------------------------------------------------------
     94
     95--
    8396-- Struktura tabulky `FinanceBills`
    8497--
    … …  
    91104  `TimeCreate` datetime NOT NULL default '0000-00-00 00:00:00',
    92105  `TimeDue` datetime NOT NULL default '0000-00-00 00:00:00',
    93   `BillCode` varchar(32) collate latin2_czech_cs NOT NULL,
    94   `Type` enum('invoice','income') collate latin2_czech_cs NOT NULL,
    95   PRIMARY KEY  (`Id`)
    96 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1707 ;
     106  `BillCode` varchar(32) collate utf8_czech_ci NOT NULL,
     107  `Type` enum('invoice','income') collate utf8_czech_ci NOT NULL,
     108  `Cash` int(11) NOT NULL default '0',
     109  PRIMARY KEY  (`Id`)
     110) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3159 ;
    97111
    98112-- --------------------------------------------------------
    … …  
    105119  `Id` int(11) NOT NULL auto_increment,
    106120  `Bill` int(11) NOT NULL default '0',
    107   `Description` varchar(255) collate latin2_czech_cs NOT NULL,
     121  `Description` varchar(255) collate utf8_czech_ci NOT NULL,
    108122  `Price` float NOT NULL default '0',
    109123  `Quantity` float NOT NULL default '1',
    110124  PRIMARY KEY  (`Id`)
    111 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=13248 ;
    112 
    113 -- --------------------------------------------------------
    114 
    115 --
    116 -- Struktura tabulky `FinanceCashFlow_old`
    117 --
    118 
    119 CREATE TABLE IF NOT EXISTS `FinanceCashFlow_old` (
    120   `Id` int(11) NOT NULL auto_increment,
    121   `BillCode` varchar(16) collate utf8_czech_ci NOT NULL,
    122   `Subject` int(11) NOT NULL default '0',
    123   `Text` varchar(255) collate utf8_czech_ci NOT NULL default '',
    124   `Time` datetime NOT NULL default '0000-00-00 00:00:00',
    125   `Taxable` tinyint(1) NOT NULL default '0',
    126   `Cash` tinyint(1) NOT NULL default '0',
    127   `Value` float NOT NULL default '0',
    128   `Bill` int(11) NOT NULL default '0',
    129   PRIMARY KEY  (`Id`)
    130 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=434 ;
     125) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14700 ;
    131126
    132127-- --------------------------------------------------------
    … …  
    147142  `Text` varchar(255) collate utf8_czech_ci NOT NULL default '',
    148143  PRIMARY KEY  (`Id`)
    149 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4183 ;
     144) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5667 ;
    150145
    151146-- --------------------------------------------------------
    … …  
    175170  `Value` float NOT NULL,
    176171  `BillCode` varchar(32) collate utf8_czech_ci NOT NULL,
    177   `Taxable` tinyint(1) NOT NULL,
     172  `Taxable` tinyint(1) NOT NULL default '1',
    178173  `Bill` int(11) NOT NULL,
    179174  `Text` varchar(255) collate utf8_czech_ci NOT NULL,
    180175  `Network` int(11) NOT NULL default '1',
    181176  PRIMARY KEY  (`Id`)
    182 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4205 ;
     177) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4248 ;
    183178
    184179-- --------------------------------------------------------
    … …  
    198193  PRIMARY KEY  (`Id`)
    199194) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
     195
     196-- --------------------------------------------------------
     197
     198--
     199-- Struktura tabulky `FinanceTariff`
     200--
     201
     202CREATE TABLE IF NOT EXISTS `FinanceTariff` (
     203  `Id` int(11) NOT NULL auto_increment,
     204  `Tariff` int(11) NOT NULL default '0',
     205  `Period` int(11) NOT NULL default '0',
     206  `Name` varchar(32) collate utf8_czech_ci NOT NULL,
     207  `Group` int(11) NOT NULL default '0',
     208  `SpeedMin` int(11) NOT NULL default '0',
     209  `SpeedMax` int(11) NOT NULL default '0',
     210  `UploadAsymmetry` int(11) NOT NULL default '1',
     211  `Price` int(11) NOT NULL default '0',
     212  `MemberCount` int(11) NOT NULL default '0',
     213  PRIMARY KEY  (`Id`)
     214) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=155 ;
    200215
    201216-- --------------------------------------------------------
    … …  
    215230  `BaseTariffPrice` int(11) NOT NULL default '0',
    216231  `TopTariffPrice` int(11) NOT NULL default '0'
    217 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
     232) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
    218233
    219234-- --------------------------------------------------------
    … …  
    225240CREATE TABLE IF NOT EXISTS `finance_groups` (
    226241  `Id` int(11) NOT NULL auto_increment,
    227   `Description` varchar(128) character set utf8 collate utf8_czech_ci NOT NULL default '',
    228   PRIMARY KEY  (`Id`)
    229 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=4 ;
     242  `Description` varchar(128) collate utf8_czech_ci NOT NULL default '',
     243  PRIMARY KEY  (`Id`)
     244) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
    230245
    231246-- --------------------------------------------------------
    … …  
    249264  `investment` int(11) NOT NULL,
    250265  PRIMARY KEY  (`id`)
    251 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;
    252 
    253 -- --------------------------------------------------------
    254 
    255 --
    256 -- Struktura tabulky `finance_operations_old`
    257 --
    258 
    259 CREATE TABLE IF NOT EXISTS `finance_operations_old` (
     266) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=96 ;
     267
     268-- --------------------------------------------------------
     269
     270--
     271-- Struktura tabulky `History`
     272--
     273
     274CREATE TABLE IF NOT EXISTS `History` (
     275  `Id` int(11) NOT NULL auto_increment,
     276  `Date` date NOT NULL,
     277  `Text` text collate utf8_czech_ci NOT NULL,
     278  PRIMARY KEY  (`Id`)
     279) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=21 ;
     280
     281-- --------------------------------------------------------
     282
     283--
     284-- Struktura tabulky `hosts_old`
     285--
     286
     287CREATE TABLE IF NOT EXISTS `hosts_old` (
    260288  `id` int(11) NOT NULL auto_increment,
    261   `user` int(11) NOT NULL default '0',
    262   `money` int(11) NOT NULL default '0',
    263   `type` int(11) NOT NULL default '0',
    264   `date` date NOT NULL default '0000-00-00',
    265   `comment` varchar(255) collate latin2_czech_cs NOT NULL default '',
    266   `bill_id` int(11) NOT NULL default '0',
    267   `group` int(11) NOT NULL default '1',
    268   `cash` int(11) NOT NULL default '0',
    269   `BillCode` varchar(16) collate latin2_czech_cs NOT NULL,
    270   `Network` int(11) NOT NULL default '1',
    271   `Taxable` int(11) NOT NULL default '1',
    272   `Invoice` int(11) NOT NULL,
    273   `Source` int(11) NOT NULL,
    274   `Destination` int(11) NOT NULL,
    275   PRIMARY KEY  (`id`)
    276 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=4158 ;
    277 
    278 -- --------------------------------------------------------
    279 
    280 --
    281 -- Struktura tabulky `finance_tariffs`
    282 --
    283 
    284 CREATE TABLE IF NOT EXISTS `finance_tariffs` (
    285   `id` int(11) NOT NULL default '0',
    286   `period` int(11) NOT NULL default '0',
    287   `name` varchar(32) collate latin2_czech_cs NOT NULL default '',
    288   `speed_factor` float NOT NULL default '0',
    289   `price_units` float NOT NULL default '0',
    290   `group_id` int(11) NOT NULL default '0',
    291   `min_speed` int(11) NOT NULL default '0',
    292   `max_speed` int(11) NOT NULL default '0',
    293   `price` int(11) NOT NULL default '0'
    294 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
    295 
    296 -- --------------------------------------------------------
    297 
    298 --
    299 -- Struktura tabulky `hosts`
    300 --
    301 
    302 CREATE TABLE IF NOT EXISTS `hosts` (
    303   `id` int(11) NOT NULL auto_increment,
    304   `name` varchar(24) character set latin2 collate latin2_czech_cs NOT NULL default '',
    305   `IP` varchar(16) character set latin2 collate latin2_czech_cs NOT NULL default '',
    306   `external_ip` varchar(16) character set latin2 collate latin2_czech_cs NOT NULL default '',
    307   `czfree_ip` varchar(16) character set latin2 collate latin2_czech_cs NOT NULL default '',
    308   `MAC` varchar(32) character set latin2 collate latin2_czech_cs NOT NULL default '',
     289  `name` varchar(24) collate utf8_czech_ci NOT NULL,
     290  `IP` varchar(16) collate utf8_czech_ci NOT NULL,
     291  `external_ip` varchar(16) collate utf8_czech_ci NOT NULL,
     292  `czfree_ip` varchar(16) collate utf8_czech_ci NOT NULL,
     293  `MAC` varchar(32) collate utf8_czech_ci NOT NULL,
    309294  `block` int(11) NOT NULL default '0',
    310295  `online` int(11) NOT NULL default '0',
    … …  
    315300  `channel` int(11) NOT NULL default '0',
    316301  `link_type` int(11) NOT NULL default '0',
    317   `pptp_password` varchar(8) character set latin2 collate latin2_czech_cs NOT NULL default '0',
    318   `show_online` int(11) NOT NULL default '1',
     302  `pptp_password` varchar(8) collate utf8_czech_ci NOT NULL default '0',
    319303  `vpn` int(11) NOT NULL default '0',
    320304  `type` int(11) NOT NULL default '0',
    321305  `used` int(11) NOT NULL default '1',
    322306  PRIMARY KEY  (`id`)
    323 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=348 ;
     307) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ;
    324308
    325309-- --------------------------------------------------------
    … …  
    336320  `last` int(11) NOT NULL default '0',
    337321  PRIMARY KEY  (`host`)
    338 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
    339 
    340 -- --------------------------------------------------------
    341 
    342 --
    343 -- Struktura tabulky `known_hosts`
    344 --
    345 
    346 CREATE TABLE IF NOT EXISTS `known_hosts` (
    347   `IP` varchar(16) NOT NULL default '',
    348   `hostname` varchar(16) NOT NULL default '',
    349   `interface` varchar(8) NOT NULL default '',
    350   `time` datetime NOT NULL default '0000-00-00 00:00:00',
    351   `MAC` varchar(64) NOT NULL default '',
    352   `traffic_total_up` bigint(11) NOT NULL default '0',
    353   `traffic_total_down` bigint(11) NOT NULL default '0',
    354   `traffic_avg_up` int(11) NOT NULL default '0',
    355   `traffic_avg_down` int(11) NOT NULL default '0',
    356   `port` int(11) NOT NULL default '0',
    357   `protocol` varchar(8) NOT NULL default '',
    358   PRIMARY KEY  (`IP`)
    359 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    360 
    361 -- --------------------------------------------------------
    362 
    363 --
    364 -- Struktura tabulky `known_hosts_ports`
    365 --
    366 
    367 CREATE TABLE IF NOT EXISTS `known_hosts_ports` (
    368   `host` varchar(16) NOT NULL default '',
    369   `port` int(11) NOT NULL default '0',
    370   `down` int(11) NOT NULL default '0',
    371   `up` int(11) NOT NULL default '0',
    372   `total_down` int(11) NOT NULL default '0',
    373   `total_up` int(11) NOT NULL default '0'
    374 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
     322) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
    375323
    376324-- --------------------------------------------------------
    … …  
    382330CREATE TABLE IF NOT EXISTS `link_types` (
    383331  `id` int(11) NOT NULL auto_increment,
    384   `caption` varchar(64) NOT NULL default '',
     332  `caption` varchar(64) collate utf8_czech_ci NOT NULL,
    385333  `teoretical_speed` float NOT NULL default '0',
    386334  `real_speed` float NOT NULL default '0',
    387   `color` varchar(16) NOT NULL default '',
     335  `color` varchar(16) collate utf8_czech_ci NOT NULL,
    388336  PRIMARY KEY  (`id`)
    389 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
     337) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ;
    390338
    391339-- --------------------------------------------------------
    … …  
    445393  `InternetTariffNextMonth` int(11) NOT NULL,
    446394  `GPS` int(11) NOT NULL,
    447   `BillingPeriod` enum('never','monthly','quarterly','half-yearly','yearly') collate utf8_czech_ci NOT NULL default 'monthly',
     395  `BillingPeriod` int(11) NOT NULL default '2',
    448396  `NetworkSegment` int(11) NOT NULL,
     397  `BillingPeriodNext` int(11) NOT NULL default '2',
     398  `BillingPeriodLastDate` date NOT NULL,
     399  `Hire` float NOT NULL default '0',
    449400  PRIMARY KEY  (`Id`)
    450401) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ;
    … …  
    471422
    472423--
     424-- Struktura tabulky `NetworkConfiguration`
     425--
     426
     427CREATE TABLE IF NOT EXISTS `NetworkConfiguration` (
     428  `Id` int(11) NOT NULL auto_increment,
     429  `Caption` varchar(255) collate utf8_czech_ci NOT NULL,
     430  `Execute` varchar(255) collate utf8_czech_ci NOT NULL,
     431  `Changed` int(11) NOT NULL default '0',
     432  `LastTime` datetime NOT NULL default '0000-00-00 00:00:00',
     433  `ExecutionTime` int(11) NOT NULL,
     434  `Enabled` int(11) NOT NULL default '1',
     435  `Period` int(11) NOT NULL default '60',
     436  `Log` text collate utf8_czech_ci NOT NULL,
     437  PRIMARY KEY  (`Id`)
     438) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
     439
     440-- --------------------------------------------------------
     441
     442--
     443-- Struktura tabulky `NetworkDevice`
     444--
     445
     446CREATE TABLE IF NOT EXISTS `NetworkDevice` (
     447  `Id` int(11) NOT NULL auto_increment,
     448  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     449  `Member` int(11) NOT NULL,
     450  `Type` int(11) NOT NULL,
     451  `PositionLatitude` double NOT NULL default '0',
     452  `PositionLongitude` double NOT NULL default '0',
     453  `Used` int(11) NOT NULL default '1',
     454  `Online` int(11) NOT NULL default '0',
     455  `LastOnline` datetime NOT NULL,
     456  PRIMARY KEY  (`Id`),
     457  KEY `Member` (`Member`)
     458) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ;
     459
     460-- --------------------------------------------------------
     461
     462--
    473463-- Struktura tabulky `NetworkDeviceHistory`
    474464--
    … …  
    486476
    487477--
     478-- Struktura tabulky `NetworkDeviceType`
     479--
     480
     481CREATE TABLE IF NOT EXISTS `NetworkDeviceType` (
     482  `Id` int(11) NOT NULL auto_increment,
     483  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     484  `ShowOnline` int(11) NOT NULL default '0',
     485  `IconName` varchar(255) collate utf8_czech_ci NOT NULL,
     486  PRIMARY KEY  (`Id`)
     487) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
     488
     489-- --------------------------------------------------------
     490
     491--
     492-- Struktura tabulky `NetworkDomainAlias`
     493--
     494
     495CREATE TABLE IF NOT EXISTS `NetworkDomainAlias` (
     496  `Id` int(11) NOT NULL auto_increment,
     497  `Name` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
     498  `Target` varchar(255) collate utf8_czech_ci NOT NULL,
     499  PRIMARY KEY  (`Id`)
     500) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=20 ;
     501
     502-- --------------------------------------------------------
     503
     504--
     505-- Struktura tabulky `NetworkInterface`
     506--
     507
     508CREATE TABLE IF NOT EXISTS `NetworkInterface` (
     509  `Id` int(11) NOT NULL auto_increment,
     510  `Name` varchar(16) collate utf8_czech_ci NOT NULL,
     511  `Type` int(11) NOT NULL,
     512  `MAC` varchar(17) collate utf8_czech_ci NOT NULL,
     513  `LocalIP` varchar(16) collate utf8_czech_ci NOT NULL,
     514  `ExternalIP` varchar(16) collate utf8_czech_ci NOT NULL,
     515  `CZFreeIP` varchar(16) collate utf8_czech_ci NOT NULL,
     516  `Device` int(11) NOT NULL,
     517  `Online` int(11) NOT NULL default '0',
     518  `LastOnline` datetime NOT NULL,
     519  PRIMARY KEY  (`Id`),
     520  KEY `Device` (`Device`)
     521) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=352 ;
     522
     523-- --------------------------------------------------------
     524
     525--
     526-- Struktura tabulky `NetworkInterfaceType`
     527--
     528
     529CREATE TABLE IF NOT EXISTS `NetworkInterfaceType` (
     530  `Id` int(11) NOT NULL auto_increment,
     531  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     532  `MaxSpeed` int(11) NOT NULL,
     533  `FullDuplex` int(11) NOT NULL default '1',
     534  `Color` varchar(6) collate utf8_czech_ci NOT NULL,
     535  PRIMARY KEY  (`Id`)
     536) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
     537
     538-- --------------------------------------------------------
     539
     540--
     541-- Struktura tabulky `NetworkLink`
     542--
     543
     544CREATE TABLE IF NOT EXISTS `NetworkLink` (
     545  `Id` int(11) NOT NULL auto_increment,
     546  `Type` int(11) NOT NULL,
     547  `Interface1` int(11) NOT NULL,
     548  `Interface2` int(11) NOT NULL,
     549  PRIMARY KEY  (`Id`)
     550) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=351 ;
     551
     552-- --------------------------------------------------------
     553
     554--
    488555-- Struktura tabulky `NetworkSubnet`
    489556--
    … …  
    491558CREATE TABLE IF NOT EXISTS `NetworkSubnet` (
    492559  `Id` int(11) NOT NULL auto_increment,
     560  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    493561  `AddressRange` varchar(255) collate utf8_czech_ci NOT NULL,
    494562  `Mask` int(11) NOT NULL,
    … …  
    499567  `Domain` varchar(255) collate utf8_czech_ci NOT NULL,
    500568  `NTP` varchar(255) collate utf8_czech_ci NOT NULL,
    501   PRIMARY KEY  (`Id`)
    502 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
     569  `Member` int(11) NOT NULL default '0',
     570  `ExtAddressRange` varchar(255) collate utf8_czech_ci NOT NULL,
     571  `ExtMask` int(11) NOT NULL default '32',
     572  PRIMARY KEY  (`Id`)
     573) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
    503574
    504575-- --------------------------------------------------------
    … …  
    510581CREATE TABLE IF NOT EXISTS `network_devices` (
    511582  `id` int(11) NOT NULL auto_increment,
    512   `name` varchar(128) NOT NULL default '',
     583  `name` varchar(128) collate utf8_czech_ci NOT NULL,
    513584  `price` int(11) NOT NULL default '0',
    514585  `count` int(11) NOT NULL default '1',
    … …  
    518589  `consumption` int(11) NOT NULL default '0',
    519590  `user` int(11) NOT NULL default '0',
    520   `info` text NOT NULL,
     591  `info` text collate utf8_czech_ci NOT NULL,
    521592  `channel` int(11) NOT NULL default '0',
    522   `device_id` varchar(255) NOT NULL default '',
    523   `shop` varchar(64) NOT NULL default '',
     593  `device_id` varchar(255) collate utf8_czech_ci NOT NULL,
     594  `shop` varchar(64) collate utf8_czech_ci NOT NULL,
    524595  `deprecated_price` int(11) NOT NULL default '0',
    525596  `TimeEnlistment` datetime NOT NULL default '0000-00-00 00:00:00',
    … …  
    527598  `StockCard` int(11) NOT NULL,
    528599  PRIMARY KEY  (`id`)
    529 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=160 ;
    530 
    531 -- --------------------------------------------------------
    532 
    533 --
    534 -- Struktura tabulky `network_dns_alias`
    535 --
    536 
    537 CREATE TABLE IF NOT EXISTS `network_dns_alias` (
    538   `name` varchar(255) character set latin2 collate latin2_czech_cs NOT NULL default '',
    539   `target` varchar(255) character set latin2 collate latin2_czech_cs NOT NULL default ''
    540 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
     600) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=160 ;
    541601
    542602-- --------------------------------------------------------
    … …  
    548608CREATE TABLE IF NOT EXISTS `network_segments` (
    549609  `id` int(11) NOT NULL auto_increment,
    550   `name` varchar(128) NOT NULL default '',
     610  `name` varchar(128) collate utf8_czech_ci NOT NULL,
    551611  `price` int(11) NOT NULL default '0',
    552612  `parent` int(11) NOT NULL default '0',
    … …  
    555615  `users_overheads` int(11) NOT NULL default '0',
    556616  PRIMARY KEY  (`id`)
    557 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=33 ;
    558 
    559 -- --------------------------------------------------------
    560 
    561 --
    562 -- Struktura tabulky `network_udp_forwarder`
    563 --
    564 
    565 CREATE TABLE IF NOT EXISTS `network_udp_forwarder` (
    566   `port` int(11) NOT NULL default '0',
    567   `game` varchar(255) character set latin2 NOT NULL default ''
    568 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    569 
    570 -- --------------------------------------------------------
    571 
    572 --
    573 -- Struktura tabulky `news`
    574 --
    575 
    576 CREATE TABLE IF NOT EXISTS `news` (
    577   `id` int(11) NOT NULL auto_increment,
    578   `title` varchar(255) collate utf8_czech_ci NOT NULL default '',
    579   `content` text collate utf8_czech_ci NOT NULL,
    580   `date` datetime NOT NULL default '0000-00-00 00:00:00',
    581   `target_date` datetime NOT NULL default '0000-00-00 00:00:00',
    582   `author` varchar(32) collate utf8_czech_ci NOT NULL default '',
    583   `ip` varchar(16) collate utf8_czech_ci NOT NULL default '',
    584   `category` int(11) NOT NULL default '0',
    585   `enclosure` varchar(255) collate utf8_czech_ci NOT NULL default '',
     617) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=33 ;
     618
     619-- --------------------------------------------------------
     620
     621--
     622-- Struktura tabulky `News`
     623--
     624
     625CREATE TABLE IF NOT EXISTS `News` (
     626  `Id` int(11) NOT NULL auto_increment,
     627  `Title` varchar(255) collate utf8_czech_ci NOT NULL,
     628  `Content` text collate utf8_czech_ci NOT NULL,
     629  `Date` datetime NOT NULL default '0000-00-00 00:00:00',
     630  `TargetDate` datetime NOT NULL default '0000-00-00 00:00:00',
     631  `Author` varchar(32) collate utf8_czech_ci NOT NULL,
     632  `IP` varchar(16) collate utf8_czech_ci NOT NULL,
     633  `Category` int(11) NOT NULL default '0',
     634  `Enclosure` varchar(255) collate utf8_czech_ci NOT NULL,
    586635  `User` int(11) NOT NULL default '0',
    587   PRIMARY KEY  (`id`),
    588   KEY `category` (`category`),
    589   KEY `date` (`date`)
    590 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30855 ;
    591 
    592 -- --------------------------------------------------------
    593 
    594 --
    595 -- Struktura tabulky `news_category`
    596 --
    597 
    598 CREATE TABLE IF NOT EXISTS `news_category` (
    599   `id` int(11) NOT NULL auto_increment,
    600   `caption` varchar(255) NOT NULL default '',
    601   `permission` int(11) NOT NULL default '0',
    602   PRIMARY KEY  (`id`)
    603 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=13 ;
     636  PRIMARY KEY  (`Id`),
     637  KEY `category` (`Category`),
     638  KEY `date` (`Date`)
     639) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30865 ;
     640
     641-- --------------------------------------------------------
     642
     643--
     644-- Struktura tabulky `NewsCategory`
     645--
     646
     647CREATE TABLE IF NOT EXISTS `NewsCategory` (
     648  `Id` int(11) NOT NULL auto_increment,
     649  `Caption` varchar(255) collate utf8_czech_ci NOT NULL,
     650  `Permission` int(11) NOT NULL default '0',
     651  PRIMARY KEY  (`Id`)
     652) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13 ;
    604653
    605654-- --------------------------------------------------------
    … …  
    640689  `ItemId` int(11) NOT NULL default '0',
    641690  PRIMARY KEY  (`Id`)
    642 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=37 ;
     691) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=38 ;
    643692
    644693-- --------------------------------------------------------
    … …  
    653702  `Type` enum('Group','Operation') collate utf8_czech_ci NOT NULL default 'Group'
    654703) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
    655 
    656 -- --------------------------------------------------------
    657 
    658 --
    659 -- Struktura tabulky `services_restart`
    660 --
    661 
    662 CREATE TABLE IF NOT EXISTS `services_restart` (
    663   `id` int(11) NOT NULL auto_increment,
    664   `caption` varchar(255) character set latin2 NOT NULL default '',
    665   `generator` varchar(255) character set latin2 NOT NULL default '',
    666   `restarter` varchar(255) character set latin2 NOT NULL default '',
    667   `changed` int(11) NOT NULL default '0',
    668   `last_time` datetime NOT NULL default '0000-00-00 00:00:00',
    669   PRIMARY KEY  (`id`)
    670 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
    671704
    672705-- --------------------------------------------------------
    … …  
    682715  KEY `host_id` (`host_id`),
    683716  KEY `time` (`time`)
    684 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
     717) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
    685718
    686719-- --------------------------------------------------------
    … …  
    692725CREATE TABLE IF NOT EXISTS `StockCard` (
    693726  `Id` int(11) NOT NULL auto_increment,
    694   `Name` varchar(255) NOT NULL,
     727  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    695728  `SellPrice` float NOT NULL,
    696729  `Consumption` int(11) NOT NULL COMMENT 'In Watts',
    697730  PRIMARY KEY  (`Id`)
    698 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
     731) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
    699732
    700733-- --------------------------------------------------------
    … …  
    710743  `AddressTown` varchar(64) collate utf8_czech_ci NOT NULL default '',
    711744  `AddressPSC` int(11) NOT NULL default '0',
    712   `IC` int(11) NOT NULL default '0',
     745  `IC` varchar(32) collate utf8_czech_ci NOT NULL,
    713746  `DIC` varchar(32) collate utf8_czech_ci NOT NULL default '',
    714747  `MapPositionX` float NOT NULL default '0',
    715748  `MapPositionY` float NOT NULL default '0',
    716749  `WWW` varchar(255) collate utf8_czech_ci NOT NULL,
    717   PRIMARY KEY  (`Id`)
    718 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=106 ;
     750  `Note` varchar(255) collate utf8_czech_ci NOT NULL,
     751  PRIMARY KEY  (`Id`)
     752) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=112 ;
    719753
    720754-- --------------------------------------------------------
    … …  
    749783
    750784--
    751 -- Struktura tabulky `sunrisechat_history`
    752 --
    753 
    754 CREATE TABLE IF NOT EXISTS `sunrisechat_history` (
    755   `id` int(11) NOT NULL auto_increment,
    756   `nick` varchar(64) NOT NULL default '',
    757   `text` text NOT NULL,
    758   `time` datetime NOT NULL default '0000-00-00 00:00:00',
    759   `color` int(11) NOT NULL default '0',
    760   `roomname` varchar(32) NOT NULL default '',
    761   `roomtype` int(11) NOT NULL default '0',
    762   PRIMARY KEY  (`id`)
    763 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=528523 ;
    764 
    765 -- --------------------------------------------------------
    766 
    767 --
    768 -- Struktura tabulky `sunrisechat_onlinelist`
    769 --
    770 
    771 CREATE TABLE IF NOT EXISTS `sunrisechat_onlinelist` (
    772   `id` int(11) NOT NULL auto_increment,
    773   `sender_ip` varchar(16) character set latin2 NOT NULL default '',
    774   `sender_id` int(11) NOT NULL default '0',
    775   `nick` varchar(64) character set latin2 NOT NULL default '',
    776   `color` int(11) NOT NULL default '0',
    777   `lasttime` datetime NOT NULL default '0000-00-00 00:00:00',
    778   `status` varchar(16) character set latin2 NOT NULL default '',
    779   `operating_system` varchar(32) character set latin2 NOT NULL default '',
    780   `sequence` int(11) NOT NULL default '0',
    781   `info` varchar(255) character set latin2 NOT NULL default '',
    782   PRIMARY KEY  (`id`)
    783 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=78758 ;
    784 
    785 -- --------------------------------------------------------
    786 
    787 --
    788 -- Struktura tabulky `test`
    789 --
    790 
    791 CREATE TABLE IF NOT EXISTS `test` (
    792   `text` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL
    793 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    794 
    795 -- --------------------------------------------------------
    796 
    797 --
    798785-- Struktura tabulky `tkr`
    799786--
    … …  
    801788CREATE TABLE IF NOT EXISTS `tkr` (
    802789  `id` int(11) NOT NULL auto_increment,
    803   `name` varchar(16) NOT NULL default '',
     790  `name` varchar(16) collate utf8_czech_ci NOT NULL,
    804791  `freq` int(11) NOT NULL default '0',
    805   `norm` varchar(8) NOT NULL default '',
    806   `www` varchar(255) NOT NULL default '',
    807   `lang` varchar(32) NOT NULL default '',
    808   `shortname` varchar(16) NOT NULL default '',
     792  `norm` varchar(8) collate utf8_czech_ci NOT NULL,
     793  `www` varchar(255) collate utf8_czech_ci NOT NULL,
     794  `lang` varchar(32) collate utf8_czech_ci NOT NULL,
     795  `shortname` varchar(16) collate utf8_czech_ci NOT NULL,
    809796  PRIMARY KEY  (`id`)
    810 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=25 ;
     797) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=25 ;
    811798
    812799-- --------------------------------------------------------
    … …  
    818805CREATE TABLE IF NOT EXISTS `User` (
    819806  `Id` int(11) NOT NULL auto_increment,
    820   `Name` varchar(64) collate utf8_czech_ci NOT NULL default '',
    821   `FirstName` varchar(128) collate utf8_czech_ci NOT NULL default '',
    822   `SecondName` varchar(128) collate utf8_czech_ci NOT NULL default '',
    823   `Nick` varchar(128) collate utf8_czech_ci NOT NULL default '',
     807  `Login` varchar(64) collate utf8_czech_ci NOT NULL,
     808  `Name` varchar(128) collate utf8_czech_ci NOT NULL,
    824809  `Password` varchar(255) collate utf8_czech_ci NOT NULL,
    825810  `Email` varchar(128) collate utf8_czech_ci NOT NULL default '',
    … …  
    833818  `InitPassword` varchar(255) collate utf8_czech_ci NOT NULL,
    834819  PRIMARY KEY  (`Id`),
    835   UNIQUE KEY `Name` (`Name`)
    836 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=104 ;
     820  UNIQUE KEY `Name` (`Login`),
     821  UNIQUE KEY `Nick` (`Name`)
     822) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=107 ;
    837823
    838824-- --------------------------------------------------------
    … …  
    853839  PRIMARY KEY  (`Id`),
    854840  KEY `User` (`User`)
    855 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=299 ;
     841) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3571 ;
    856842
    857843-- --------------------------------------------------------
    … …  
    890876  `inet_tarif_next` int(11) NOT NULL default '2',
    891877  `monthly_inet` int(11) NOT NULL default '0',
    892   `subject_name` varchar(128) character set utf8 collate utf8_czech_ci NOT NULL default '',
    893   `street` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL default '',
    894   `town` varchar(64) character set utf8 collate utf8_czech_ci NOT NULL default '',
     878  `subject_name` varchar(128) collate utf8_czech_ci NOT NULL default '',
     879  `street` varchar(255) collate utf8_czech_ci NOT NULL default '',
     880  `town` varchar(64) collate utf8_czech_ci NOT NULL default '',
    895881  `psc` int(11) NOT NULL default '0',
    896882  `ico` int(11) NOT NULL default '0',
    897   `dic` varchar(32) NOT NULL default '',
    898   `BillingPeriod` enum('never','monthly','quarterly','half-yearly','yearly') NOT NULL default 'monthly',
     883  `dic` varchar(32) character set latin1 NOT NULL default '',
     884  `BillingPeriod` enum('never','monthly','quarterly','half-yearly','yearly') character set latin1 NOT NULL default 'monthly',
    899885  PRIMARY KEY  (`id`),
    900886  UNIQUE KEY `nick` (`nick`)
    901 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=98 ;
    902 
    903 -- --------------------------------------------------------
    904 
    905 --
    906 -- Struktura tabulky `users_online`
    907 --
    908 
    909 CREATE TABLE IF NOT EXISTS `users_online` (
    910   `id` int(11) NOT NULL auto_increment,
    911   `user` int(11) NOT NULL default '0',
    912   `time` int(11) NOT NULL default '0',
    913   `session` varchar(128) character set latin2 NOT NULL default '',
    914   `ip` varchar(64) character set latin2 NOT NULL default '',
    915   PRIMARY KEY  (`id`)
    916 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=282 ;
    917 
    918 -- --------------------------------------------------------
    919 
    920 --
    921 -- Struktura tabulky `users_roles`
    922 --
    923 
    924 CREATE TABLE IF NOT EXISTS `users_roles` (
    925   `Id` int(11) NOT NULL auto_increment,
    926   `Description` varchar(128) collate utf8_czech_ci NOT NULL default '',
    927   PRIMARY KEY  (`Id`)
    928 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;
    929 
    930 -- --------------------------------------------------------
    931 
    932 --
    933 -- Struktura tabulky `wlan_db`
    934 --
    935 
    936 CREATE TABLE IF NOT EXISTS `wlan_db` (
    937   `id` int(11) NOT NULL auto_increment,
    938   `name` varchar(255) NOT NULL default '',
    939   `value` float NOT NULL default '0',
    940   PRIMARY KEY  (`id`)
    941 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=12 ;
    942 
    943 -- --------------------------------------------------------
    944 
    945 --
    946 -- Struktura tabulky `wlan_links`
    947 --
    948 
    949 CREATE TABLE IF NOT EXISTS `wlan_links` (
    950   `id` int(11) NOT NULL auto_increment,
    951   `point1` int(11) NOT NULL default '0',
    952   `point2` int(11) NOT NULL default '0',
    953   `distance` int(11) NOT NULL default '0',
    954   PRIMARY KEY  (`id`)
    955 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
    956 
    957 -- --------------------------------------------------------
    958 
    959 --
    960 -- Struktura tabulky `wlan_list`
    961 --
    962 
    963 CREATE TABLE IF NOT EXISTS `wlan_list` (
    964   `id` int(11) NOT NULL auto_increment,
    965   `name` varchar(255) character set latin2 NOT NULL default '',
    966   `device` int(11) NOT NULL default '0',
    967   `antena` int(11) NOT NULL default '0',
    968   `cable` int(11) NOT NULL default '0',
    969   `cable_length` int(11) NOT NULL default '0',
    970   `connector1` int(11) NOT NULL default '0',
    971   `connector2` int(11) NOT NULL default '0',
    972   `total` int(11) NOT NULL default '0',
    973   `comment` int(11) NOT NULL default '0',
    974   `total_passive` int(11) NOT NULL default '0',
    975   PRIMARY KEY  (`id`)
    976 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
     887) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=98 ;

  • trunk/style.css

    r211 r221  
    6666  width: 100%;
    6767  font-weight: normal;
     68  display: block;
    6869}
    6970
    … …  
    109110.NewsTable
    110111{
     112  margin: 2px 0px 2px 0px;
    111113  padding: 2px 2px 2px 2px;
    112114  font-size: small;
    … …  
    115117  border-width: 1px;
    116118  background-color: #FFF0F0;
     119  width: 100%;
     120  border-collapse: collapse;
     121}
     122
     123.NewsTable td
     124{
     125  padding: 2px 2px 2px 2px;
     126  margin: 0px 0px 0px 0px;
     127}
     128
     129.NewsTable th
     130{
     131  padding: 2px 2px 2px 2px;
     132  margin: 0px 0px 0px 0px;
    117133}
    118134
    119135.NewsTableItem
    120136{
     137  margin: 2px 2px 2px 2px;
    121138  display: none;
    122139  border-width: 1px;
    … …  
    127144}
    128145
     146#NewsColumn
     147{
     148  width: 50%;
     149}
     150
     151.NewsBaseTable
     152{
     153  width: 100%;
     154  border-width: 0px;
     155  font-size: small;
     156  padding-bottom: 5px;
     157  margin-bottom: 5px;
     158  border-collapse: collapse;
     159}
     160
     161.NewsBaseTable td
     162{
     163  padding: 2px 2px 2px 2px;
     164  margin: 2px 2px 2px 2px;
     165}
     166
     167.NewsItemFrame
     168{
     169  border-collapse: collapse;
     170  padding: 0px;
     171  margin: 2px 2px 2px 2px;
     172  font-size: small;
     173  color: red;
     174  width: 100%;
     175}
     176
    129177.RSSIcon
    130178{
    … …  
    132180  border-width: 0px;
    133181}
    134 
    135 #NewsColumn
    136 {
    137   width: 50%;
    138 }
    139 
    140182div.HalfWidth
    141183{
Note: See TracChangeset for help on using the changeset viewer.