Changeset 18


Ignore:
Timestamp:
Oct 21, 2008, 4:15:52 PM (16 years ago)
Author:
george
Message:
  • Upraveno: Prozatím jednoduché oprávnění pro čtení a zápis k jednotlivým seznamům.
  • Přidáno: Typ GPS souřadnice.
  • Opraveno: Převod přes hašovací funkci SHA1 u typu Password.
  • Upraveno: Možnost vybrat variantu Žádný u odkazů.
  • Opraveno: Součinost modulu User s časovou databázovou strukturou.
Files:
8 edited

Legend:

Unmodified
Added
Removed
  • base.php

    r17 r18  
    55  global $Database, $Types, $Config;
    66
    7   //if(!CheckPermission('Read', $List['Id'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění'));
     7  if(!CheckPermission('Read', $List['ItemId']))
     8  {
     9    if($Column != '') return('');
     10    else return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění'));
     11  }
    812
    913  if($Title == '') $Output = '<div>'.$List['Title'].'</div>';
     
    3337  if(array_key_exists('OrderColumn', $_GET))
    3438  {
    35     if($_SESSION['OrderColumn'] == $_GET['OrderColumn']) // Same column => reverse orded
     39    if($_SESSION['OrderColumn'] == $_GET['OrderColumn']) // Same column => reverse order
    3640      $_SESSION['OrderDirection'] = ($_SESSION['OrderDirection'] + 1) % 2;
    3741    if($_SESSION['OrderTable'] != $List['TableName']) // Different table => set ascending order
     
    6569      }
    6670    }
    67     $Output .= '<td><a href="?Action=ViewItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a> <a href="?Action=EditItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/edit.png" alt="Editovat" title="Editovat"></a> <a href="?Action=DeleteItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/delete.png" alt="Smazat" title="Smazat"></a></td></tr>';
     71    $Output .= '<td>';
     72    if(CheckPermission('Read', $List['ItemId'])) $Output .= '<a href="?Action=ViewItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a>';
     73    if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=EditItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/edit.png" alt="Editovat" title="Editovat"></a>';
     74    if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=DeleteItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/delete.png" alt="Smazat" title="Smazat"></a>';
     75    $Output .= '</td></tr>';
    6876  }
    6977  $Output .= '</table>';
    7078  $PageList = PagesList($Page, $TotalItemCount);
    7179  if(strlen($PageList) != 0) $Output .= $PageList.'<br />';
    72   $Output .= ' <a href="?Action=AddItem&amp;Table='.$List['TableName'].$ColumnSelection.'">Přidat</a> '.$FullListLink;
     80  if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=AddItem&amp;Table='.$List['TableName'].$ColumnSelection.'">Přidat</a> '.$FullListLink;
    7381  return($Output);
    7482}
     
    8694      $Output .= '<th><a href="?OrderColumn='.$Item['Name'].'">'.$Item['TextBefore'].'</a></th>';
    8795  }
    88   $Output .= '<th><a href="?OrderColumn=Author">Autor</a></th><th><a href="?OrderColumn=CreationTime">Čas vytvoření</a></th><th>Akce</th></tr>';
     96  $Output .= '<th><a href="?OrderColumn=Author">Autor</a></th><th><a href="?OrderColumn=CreationTime">Čas vytvoření</a></th><th><a href="?OrderColumn=CreationTime">Čas odstranění</a></th><th>Akce</th></tr>';
    8997
    9098  $Where = ' AND (ItemId='.$Id.')';
     
    127135      }
    128136    }
    129     echo($TypeNames['PointerOneToUser']);
    130     $Item = array('Name' => 'Author', 'Type' => $TypeNames['PointerOneToUser']);
     137    //print_r($TypeNames);
     138    //print_r($Types);
     139    $Item = array('Name' => 'Author', 'Type' => $TypeNames['PointerToUser']);
     140    //print_r($Item);
    131141    $ItemType = explode('|', $Types[$Item['Type']]['Parameters']);
    132142    $Type = $Types[$ItemType[0]];
     
    136146    $Output .= '<td>'.$Value.'</td>';
    137147
    138     $Output .= '<td>'.$DbRow['CreationTime'].'</td>';
     148    $Output .= '<td>'.$DbRow['CreationTime'].'</td><td>'.$DbRow['DeletionTime'].'</td>';
    139149    $Output .= '<td><a href="?Action=ViewItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['Id'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a></td></tr>';
    140150  }
     
    149159  global $Database, $Types;
    150160
     161  if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění'));
    151162  $DbResult = $Database->select($List['TableName'], '*', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1');
    152163  while($DbRow = $DbResult->fetch_array())
     
    184195  global $Database, $Types, $System, $LogActionType;
    185196
     197  if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění'));
    186198  $DbResult = $Database->select($List['TableName'], '*', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1');
    187199  while($DbRow = $DbResult->fetch_array())
     
    220232  global $Database, $Types;
    221233
     234  if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění'));
    222235  $DefinitionItems = array();
    223236  $AfterTableOutput = '';
     
    260273  global $Database, $Types, $System, $LogActionType;
    261274
     275  if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění'));
    262276  $DefinitionItems = array();
    263277  $AfterTableOutput = '';
     
    298312  global $Database, $Types, $Lists;
    299313
     314  if(!CheckPermission('Read', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění'));
    300315  $Output = '';
    301316  $DbResult = $Database->select($List['TableName'], '*', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1');
     
    317332    );
    318333    $Output .= $Form->ShowReadOnlyForm();
    319     $Output .= '<a href="?Action=EditItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'">Editovat</a> ';
     334    if(CheckPermission('Write', $List['ItemId'])) $Output .= '<a href="?Action=EditItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'">Editovat</a> ';
    320335
    321336    if(($Column != '') and ($ColumnValue != 0))
     
    344359  global $Database, $Lists, $System, $LogActionType;
    345360
     361  if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění'));
    346362  $System->Modules['Log']->Add($List['Id'], $Id, $LogActionType['Delete']);
    347363  $System->Modules['DatabaseList']->DeleteItem($List['TableName'], $Id);
     
    359375  while($DbRow = $DbResult->fetch_assoc())
    360376  {
    361     $Output .= '<strong>'.$DbRow['Name'].'</strong><br />';
     377    $Group = '';
    362378    $DbResult2 = $Database->query('SELECT t1.* FROM `SystemList` AS t1 LEFT JOIN `SystemList` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL) AND (t1.DeletionTime IS NULL) AND (t1.`Menu` = '.$DbRow['ItemId'].')');
    363379    while($DbRow2 = $DbResult2->fetch_assoc())
    364380    {
    365       //if(($List['System'] == $System) and ($List['VisibleInMenu'] == 1))
    366       //if(CheckPermission('Read', $List['Id']))
    367       $Output .= '<a href="?Action=ShowList&amp;Table='.$DbRow2['TableName'].'">'.$DbRow2['Title'].'</a><br />';
    368     }
    369     $Output .= '<br />';
     381      if(CheckPermission('Read', $DbRow2['ItemId']))
     382        $Group .= '<a href="?Action=ShowList&amp;Table='.$DbRow2['TableName'].'">'.$DbRow2['Title'].'</a><br />';
     383    }
     384    if($Group != '')
     385      $Output .= '<strong>'.$DbRow['Name'].'</strong><br />'.$Group.'<br />';
    370386  }
    371387  $Output .= '<br />';
     
    440456    $List = array(
    441457     'Id' => $DbRow['Id'],
     458     'ItemId' => $DbRow['ItemId'],
    442459     'TableName' => $DbRow['TableName'],
    443460     'Title' => $DbRow['Title'],
    444      'System' => $DbRow['System'],
    445      'VisibleInMenu' => $DbRow['VisibleInMenu'],
    446461     'Items' => $Items,
    447462    );
     
    513528  global $Database, $System;
    514529
    515   $DbResult = $Database->query('SELECT t1.* FROM `Permission` AS t1 LEFT JOIN `Permission` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL) AND t1.PermissionGroup = (SELECT PermissionGroup.Id FROM PermissionGroup WHERE PermissionGroup.Id=(SELECT User.PermissionGroup FROM User WHERE User.ItemId='.$System->Modules['User']->User['Id'].' ORDER BY User.Id DESC LIMIT 1) ORDER BY PermissionGroup.Id DESC LIMIT 1) AND t1.DeletionTime IS NULL AND t1.List='.$ListId);
     530  $Result = FALSE;
     531  //return(TRUE);
     532  $DbResult = $Database->query('SELECT t1.* FROM `Permission` AS t1 LEFT JOIN `Permission` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL) AND t1.PermissionGroup = (SELECT PermissionGroup.Id FROM PermissionGroup WHERE PermissionGroup.Id=(SELECT User.PermissionGroup FROM User WHERE User.ItemId='.$System->Modules['User']->User['ItemId'].' ORDER BY User.Id DESC LIMIT 1) ORDER BY PermissionGroup.Id DESC LIMIT 1) AND t1.DeletionTime IS NULL AND t1.List='.$ListId);
    516533  if($DbResult->num_rows > 0)
    517534  {
     
    519536    switch($DbRow['Right'])
    520537    {
    521       case 0: return(array('Read' => FALSE, 'Write' => FALSE));
    522       case 1: return(array('Read' => TRUE, 'Write' => FALSE));
    523       case 2: return(array('Read' => TRUE, 'Write' => TRUE));
    524     }
    525   }
     538      case 0: $Privileges = array('Read' => FALSE, 'Write' => FALSE); break;
     539      case 1: $Privileges = array('Read' => TRUE, 'Write' => FALSE); break;
     540      case 2: $Privileges = array('Read' => TRUE, 'Write' => TRUE); break;
     541    }
     542    $Result = $Privileges[$Right];
     543  }
     544  //print_r($Privileges);
     545  //echo($DbRow['Right'].' '.$Result.'<br>');
     546  return($Result);
    526547}
    527548
  • index.php

    r16 r18  
    3939      if($_GET['Action'] == 'Login')
    4040      {
    41         $Output .= $this->SystemMessage('Přihlášení', $this->System->Modules['User']->Login($_POST['UserName'], $_POST['Password']));
     41        $Form = new Form();
     42        $Form->Definition = $FormUserLogin;
     43        $Form->LoadValuesFromForm();
     44        $Output .= $this->SystemMessage('Přihlášení', $this->System->Modules['User']->Login($Form->Values['UserName'], $Form->Values['Password']));
    4245      } else
    4346      if($_GET['Action'] == 'Logout')
     
    7376    if($this->System->Modules['User']->User['Id'] == 0)
    7477    {
    75       if(!array_key_exists('Action', $_GET))
     78      //if(!array_key_exists('Action', $_GET))
    7679      {
    7780        $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/?Action=LoginForm">Přihlášení</a><br /><a href="'.$this->System->Config['Web']['RootFolder'].'/?Action=UserRegister">Registrace</a>';
  • sql/demo_database.sql

    r11 r18  
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Pondělí 13. října 2008, 08:00
     6-- Vygenerováno: Úterý 21. října 2008, 16:14
    77-- Verze MySQL: 5.0.51
    88-- Verze PHP: 5.2.6
     
    3939  `HostList` int(11) NOT NULL,
    4040  PRIMARY KEY  (`Id`)
    41 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ;
     41) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
    4242
    4343--
     
    5353(6, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:04:59', NULL, 'kk', '', '', '', '', '', '', '', '', 0),
    5454(7, 2, 0, '2008-10-09 14:09:48', NULL, '2008-10-09 14:09:48', NULL, 'kk', 'sss', '', '', '', '', '', '', '', 0),
    55 (8, 2, 5, '2008-10-09 14:43:13', NULL, '2008-10-09 14:43:13', '2008-10-13 07:56:32', 'Ahoj', 'sss', '', '', '', '', '', '', '', 0);
     55(8, 2, 5, '2008-10-09 14:43:13', NULL, '2008-10-09 14:43:13', '2008-10-13 07:56:32', 'Ahoj', 'sss', '', '', '', '', '', '', '', 0),
     56(9, 5, 5, '2008-10-19 20:00:47', NULL, '2008-10-19 20:00:47', NULL, 'Czfree', '10.0.0.0', '255.0.0.0', '', '', '', 'czf', 'czfree', '', 0);
    5657
    5758-- --------------------------------------------------------
     
    7778  `PurcheasedFrom` int(11) NOT NULL,
    7879  PRIMARY KEY  (`Id`)
    79 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=15 ;
     80) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=17 ;
    8081
    8182--
     
    9798(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Edimax gigabit switch 8-port', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 750, 2, 'EDW8-423423-333', 9),
    9899(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'VoIP adaptér Zyxel VO-112', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1342, 2, 'ZXS422Z33', 9),
    99 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IP kamera Vivotek IP-224', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3744, 2, 'VOWW623335', 9);
     100(14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IP kamera Vivotek IP-224', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3744, 2, 'VOWW623335', 9),
     101(15, 9, 5, '2008-10-14 07:20:25', NULL, '2008-10-14 07:20:25', '2008-10-16 12:24:44', 'Všesměrová anténa Omni 10 dBi', '2001-01-01 00:00:00', '2066-01-01 00:00:00', 1043, 2, 'OMNI123533', 9),
     102(16, 9, 5, '2008-10-16 12:24:44', NULL, '2008-10-16 12:24:44', NULL, 'Všesměrová anténa Omni 10 dBi', '2001-01-01 00:00:00', '2066-01-01 00:00:00', 1050, 2, 'OMNI123533', 9);
    100103
    101104-- --------------------------------------------------------
     
    130133(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Vedlejší účet', 'Komerční banka', '5543332', '0400', 2, 2),
    131134(3, 3, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Pomocný - vedení zdarma', 'Mbank', '24522266', '0156', 1, 2);
     135
     136-- --------------------------------------------------------
     137
     138--
     139-- Struktura tabulky `CableTV`
     140--
     141
     142CREATE TABLE IF NOT EXISTS `CableTV` (
     143  `Id` int(11) NOT NULL auto_increment,
     144  `Name` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL,
     145  `Frequency` int(11) NOT NULL default '0',
     146  `Norm` varchar(8) character set utf8 collate utf8_czech_ci NOT NULL,
     147  `Homepage` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
     148  `Language` varchar(32) character set utf8 collate utf8_czech_ci NOT NULL,
     149  `ShortName` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL,
     150  `ItemId` int(11) NOT NULL,
     151  `Author` int(11) NOT NULL,
     152  `ValidTimeFrom` datetime default NULL,
     153  `ValidTimeTo` datetime default NULL,
     154  `CreationTime` datetime default NULL,
     155  `DeletionTime` datetime default NULL,
     156  PRIMARY KEY  (`Id`)
     157) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=25 ;
     158
     159--
     160-- Vypisuji data pro tabulku `CableTV`
     161--
     162
     163INSERT INTO `CableTV` (`Id`, `Name`, `Frequency`, `Norm`, `Homepage`, `Language`, `ShortName`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`) VALUES
     164(1, 'STV 1', 49218, 'pal-bg', 'http://www.stv.sk/', 'slovensky', 'stv1', 1, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     165(2, 'Galaxie Sport', 230687, 'pal-bg', 'http://www.galaxie-sport.cz/', 'česky', 'galaxia_sport', 2, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     166(3, 'STV 2', 76650, 'pal-bg', 'http://www.stv.sk/', 'slovensky', 'stv2', 3, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     167(4, 'TVN', 150937, 'pal-bg', 'http://tvn.pl/', 'polsky', 'tvn', 4, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     168(5, 'CNN', 158718, 'pal-bg', 'http://www.cnn.com/', 'anglicky', 'cnn', 5, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     169(6, 'Nova', 175381, 'pal-dk', 'http://www.nova.cz/', 'česky', 'nova', 6, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     170(7, 'Prima', 190781, 'pal-dk', 'http://www.iprima.cz/', 'česky', 'prima', 7, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     171(8, 'JOJ', 198718, 'pal-bg', 'http://www.joj.sk/', 'slovensky', 'joj', 8, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     172(9, 'ČT2', 206937, 'pal-dk', 'http://www.ceskatelevize.cz/', 'česky', 'ct2', 9, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     173(10, 'Infokanál', 214843, 'pal-bg', '', 'česky', 'infokanal', 10, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     174(11, 'ČT1', 223125, 'pal-dk', 'http://www.ceskatelevize.cz/', 'česky', 'ct1', 11, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     175(12, 'Markíza', 58781, 'pal-bg', 'http://www.markiza.sk/', 'slovenky', 'markiza', 12, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     176(13, 'Discovery', 237781, 'pal-bg', 'http://www.discoverychannel.cz/', 'česky', 'discovery', 13, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     177(14, 'Eurosport', 470781, 'pal-bg', 'http://www.eurosport.cz/', 'česky', 'eurosport', 14, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     178(15, 'DSF', 486718, 'pal-bg', 'http://www.dsf.de/', 'německy', 'dsf', 15, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     179(16, 'VIVA 1', 502718, 'pal-bg', 'http://www.viva.tv/', 'německy', 'viva1', 16, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     180(17, 'VIVA 2', 518718, 'pal-bg', 'http://www.viva.tv/', 'německy', 'viva2', 17, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     181(18, 'MTV', 534718, 'pal-bg', 'http://www.mtv.tv/', 'německy', 'mtv', 18, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     182(19, 'ZDF', 550718, 'pal-bg', 'http://www.zdf.de/', 'německy', 'zdf', 19, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     183(20, 'Noe', 244781, 'pal-bg', 'http://www.tvnoe.cz/', 'česky', 'noe', 20, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     184(21, 'RTL', 166718, 'pal-bg', 'http://www.rtl.de/', 'německy', 'rtl', 21, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     185(22, 'NOVA Cinema', 252250, 'pal-bg', 'http://novacinema.nova.cz/', 'česky', 'nova_cinema', 22, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     186(23, 'ČT 24', 273250, 'pal-bg', 'http://www.ct24.cz/', 'česky', 'ct24', 23, 5, NULL, NULL, '2008-10-21 16:05:26', NULL),
     187(24, 'ČT 4 Sport', 280250, 'pal-bg', 'http://www.ct24.cz/sport/', 'česky', 'ct4sport', 24, 5, NULL, NULL, '2008-10-21 16:05:26', NULL);
    132188
    133189-- --------------------------------------------------------
     
    152208  `Type` int(11) NOT NULL,
    153209  `InsertedByUser` int(11) NOT NULL,
    154   PRIMARY KEY  (`Id`)
    155 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
     210  `Document` int(11) NOT NULL,
     211  PRIMARY KEY  (`Id`)
     212) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
    156213
    157214--
     
    159216--
    160217
    161 INSERT INTO `FinanceTransaction` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Description`, `Amount`, `SourceSubject`, `TargetSubject`, `Time`, `Type`, `InsertedByUser`) VALUES
    162 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 2 Mbit 2008/05', 360, 2, 11, '0000-00-00 00:00:00', 0, 1),
    163 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Zřízení přípojky', 4300, 10, 11, '0000-00-00 00:00:00', 1, 11),
    164 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 8 Mbit 2008/05', 750, 8, 11, '0000-00-00 00:00:00', 0, 11),
    165 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Vrácení přeplatku', 231, 11, 8, '0000-00-00 00:00:00', 0, 11);
     218INSERT INTO `FinanceTransaction` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Description`, `Amount`, `SourceSubject`, `TargetSubject`, `Time`, `Type`, `InsertedByUser`, `Document`) VALUES
     219(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 2 Mbit 2008/05', 360, 2, 11, '0000-00-00 00:00:00', 0, 1, 0),
     220(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Zřízení přípojky', 4300, 10, 11, '0000-00-00 00:00:00', 1, 11, 0),
     221(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 8 Mbit 2008/05', 750, 8, 11, '0000-00-00 00:00:00', 0, 11, 0),
     222(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Vrácení přeplatku', 231, 11, 8, '0000-00-00 00:00:00', 0, 11, 0),
     223(31, 2, 5, '2008-10-14 09:20:19', NULL, '2008-10-14 09:20:19', NULL, 'Zřízení přípojky', 4300, 10, 11, '1900-01-01 00:00:00', 1, 11, 4),
     224(30, 2, 5, '2008-10-14 09:17:42', NULL, '2008-10-14 09:17:42', NULL, 'Zřízení přípojky', 4300, 10, 11, '1900-01-01 00:00:00', 1, 11, 0),
     225(29, 2, 5, '2008-10-14 09:16:57', NULL, '2008-10-14 09:16:57', NULL, 'Zřízení přípojky', 4300, 10, 11, '1900-01-01 00:00:00', 1, 11, 0),
     226(28, 3, 5, '2008-10-14 09:16:34', NULL, '2008-10-14 09:16:34', NULL, 'Internet 8 Mbit 2008/05', 750, 8, 11, '1900-01-01 00:00:00', 0, 11, 3),
     227(27, 4, 5, '2008-10-14 09:16:00', NULL, '2008-10-14 09:16:00', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 2),
     228(26, 4, 5, '2008-10-14 09:07:57', NULL, '2008-10-14 09:07:57', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0),
     229(25, 4, 5, '2008-10-14 09:05:45', NULL, '2008-10-14 09:05:45', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0),
     230(24, 4, 5, '2008-10-14 09:03:32', NULL, '2008-10-14 09:03:32', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 1),
     231(23, 4, 5, '2008-10-14 09:02:31', NULL, '2008-10-14 09:02:31', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0),
     232(22, 4, 5, '2008-10-14 09:01:39', NULL, '2008-10-14 09:01:39', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0);
    166233
    167234-- --------------------------------------------------------
     
    189256  `Member` int(11) NOT NULL,
    190257  `Area` int(11) NOT NULL,
    191   PRIMARY KEY  (`Id`)
    192 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
     258  `SubHostList` int(11) NOT NULL,
     259  PRIMARY KEY  (`Id`)
     260) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ;
    193261
    194262--
     
    196264--
    197265
    198 INSERT INTO `Host` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`) VALUES
    199 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'george', 'GEORGE', '192.168.0.23', '', '0000-00-00', 1, 0, 4, 0, 0),
    200 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0),
    201 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'telefon', 'TELEFON', '192.168.1.45', '', '0000-00-00', 2, 0, 4, 1, 2),
    202 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'router-inet', 'ROUTER-INET', '192.168.0.2', '77.33.55.12', '0000-00-00', 4, 0, 1, 1, 4),
    203 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'muhehe', 'MUHEHE', '192.168.0.4', '', '0000-00-00', 1, 0, 1, 1, 2),
    204 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'jonny', 'JONNY', '192.168.0.6', '', '0000-00-00', 1, 0, 1, 1, 1),
    205 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '0000-00-00', 6, 0, 0, 0, 0),
    206 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'www', 'WWW', '192.168.0.7', '34.22.1.4', '0000-00-00', 5, 0, 0, 0, 0),
    207 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'peklo', 'PEKLO', '192.168.66.66', '', '0000-00-00', 7, 0, 4, 2, 0);
     266INSERT INTO `Host` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`, `SubHostList`) VALUES
     267(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'george', 'GEORGE', '192.168.0.23', '', '0000-00-00', 1, 0, 4, 0, 0, 0),
     268(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0, 0),
     269(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'telefon', 'TELEFON', '192.168.1.45', '', '0000-00-00', 2, 0, 4, 1, 2, 0),
     270(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'router-inet', 'ROUTER-INET', '192.168.0.2', '77.33.55.12', '0000-00-00', 4, 0, 1, 1, 4, 0),
     271(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'muhehe', 'MUHEHE', '192.168.0.4', '', '0000-00-00', 1, 0, 1, 1, 2, 0),
     272(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'jonny', 'JONNY', '192.168.0.6', '', '0000-00-00', 1, 0, 1, 1, 1, 0),
     273(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 20:01:24', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '0000-00-00', 6, 0, 0, 0, 0, 0),
     274(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'www', 'WWW', '192.168.0.7', '34.22.1.4', '0000-00-00', 5, 0, 0, 0, 0, 0),
     275(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'peklo', 'PEKLO', '192.168.66.66', '', '0000-00-00', 7, 0, 4, 2, 0, 0),
     276(10, 1, 5, '2008-10-13 13:52:04', NULL, '2008-10-13 13:52:04', NULL, 'george', 'GEORGE', '192.168.0.23', '', '1900-01-01', 1, 0, 4, 1, 4, 0),
     277(11, 7, 5, '2008-10-19 20:01:24', NULL, '2008-10-19 20:01:24', '2008-10-19 20:03:14', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 5, 0),
     278(12, 7, 5, '2008-10-19 20:03:14', NULL, '2008-10-19 20:03:14', '2008-10-19 20:03:19', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 5, 0),
     279(13, 7, 5, '2008-10-19 20:03:19', NULL, '2008-10-19 20:03:19', NULL, 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 2, 0);
    208280
    209281-- --------------------------------------------------------
     
    226298  `Host` int(11) NOT NULL,
    227299  `MAC` varchar(255) collate utf8_czech_ci NOT NULL,
    228   PRIMARY KEY  (`Id`)
    229 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
     300  `ParentHost` int(11) NOT NULL,
     301  PRIMARY KEY  (`Id`)
     302) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ;
    230303
    231304--
     
    233306--
    234307
    235 INSERT INTO `Interface` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Type`, `Area`, `Host`, `MAC`) VALUES
    236 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Kabel', 2, 0, 1, '00:00:00:00:00:00'),
    237 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F'),
    238 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Bezdrát', 0, 0, 5, '00:00:00:A5:53:26'),
    239 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'eth0', 2, 0, 6, '45:00:12:54:FE:C2');
     308INSERT INTO `Interface` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Type`, `Area`, `Host`, `MAC`, `ParentHost`) VALUES
     309(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 19:13:18', 'Kabel', 2, 0, 1, '00:00:00:00:00:00', 0),
     310(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 19:13:33', 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F', 0),
     311(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Bezdrát', 0, 0, 5, '00:00:00:A5:53:26', 0),
     312(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 20:07:04', 'eth0', 2, 0, 6, '45:00:12:54:FE:C2', 0),
     313(5, 1, 5, '2008-10-19 19:13:18', NULL, '2008-10-19 19:13:18', '2008-10-19 19:13:25', 'Kabel', 2, 0, 1, '00:00:00:00:00:00', 1),
     314(6, 1, 5, '2008-10-19 19:13:25', NULL, '2008-10-19 19:13:25', NULL, 'Kabel', 2, 0, 1, '00:00:00:00:00:00', 2),
     315(7, 2, 5, '2008-10-19 19:13:33', NULL, '2008-10-19 19:13:33', NULL, 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F', 8),
     316(8, 4, 5, '2008-10-19 20:07:04', NULL, '2008-10-19 20:07:04', NULL, 'eth0', 2, 0, 6, '45:00:12:54:FE:C2', 4);
    240317
    241318-- --------------------------------------------------------
     
    255332  `Subject` int(11) NOT NULL,
    256333  `ResponsibleUser` int(11) NOT NULL,
    257   `MapPositionX` int(11) NOT NULL,
    258   `MapPositionY` int(11) NOT NULL,
    259334  `FamilyMemberCount` int(11) NOT NULL,
    260335  `MembershipDate` date NOT NULL,
     
    263338  `Tariff` int(11) NOT NULL,
    264339  `UserList` int(11) NOT NULL,
    265   PRIMARY KEY  (`Id`)
    266 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7 ;
     340  `GPS` int(11) NOT NULL,
     341  PRIMARY KEY  (`Id`)
     342) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=37 ;
    267343
    268344--
     
    270346--
    271347
    272 INSERT INTO `Member` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Subject`, `ResponsibleUser`, `MapPositionX`, `MapPositionY`, `FamilyMemberCount`, `MembershipDate`, `MemberState`, `HostList`, `Tariff`, `UserList`) VALUES
    273 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 1, 123, 567, 3, '0000-00-00', 2, 0, 3, 0),
    274 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3, 6, 123, 123, 2, '0000-00-00', 2, 0, 4, 0),
    275 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 7, 8, 0, 0, 0, '0000-00-00', 2, 0, 2, 0),
    276 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 8, 11, 0, 0, 0, '0000-00-00', 2, 0, 3, 0),
    277 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 10, 1, 32423, 21, 2, '0000-00-00', 1, 0, 3, 0),
    278 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 12, 12, 12, 2, 1, '0000-00-00', 3, 0, 1, 0);
     348INSERT INTO `Member` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Subject`, `ResponsibleUser`, `FamilyMemberCount`, `MembershipDate`, `MemberState`, `HostList`, `Tariff`, `UserList`, `GPS`) VALUES
     349(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:11:56', 2, 1, 3, '0000-00-00', 2, 0, 3, 0, 0),
     350(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:13:08', 3, 6, 2, '0000-00-00', 2, 0, 4, 0, 0),
     351(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:18:03', 7, 8, 0, '0000-00-00', 2, 0, 2, 0, 0),
     352(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:20:38', 8, 11, 0, '0000-00-00', 2, 0, 3, 0, 0),
     353(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 10, 1, 2, '0000-00-00', 1, 0, 3, 0, 0),
     354(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 12, 12, 1, '0000-00-00', 3, 0, 1, 0, 0),
     355(7, 3, 5, '2008-10-21 10:18:03', '0000-00-00 00:00:00', '2008-10-21 10:18:03', '0000-00-00 00:00:00', 7, 8, 0, '1900-01-01', 2, 0, 2, 0, 0),
     356(8, 4, 5, '2008-10-21 10:20:38', '0000-00-00 00:00:00', '2008-10-21 10:20:38', '2008-10-21 10:21:01', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 3),
     357(9, 4, 5, '2008-10-21 10:21:01', '0000-00-00 00:00:00', '2008-10-21 10:21:01', '2008-10-21 10:22:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 4),
     358(10, 4, 5, '2008-10-21 10:22:36', '0000-00-00 00:00:00', '2008-10-21 10:22:36', '2008-10-21 10:30:03', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 5),
     359(11, 4, 5, '2008-10-21 10:30:03', '0000-00-00 00:00:00', '2008-10-21 10:30:03', '2008-10-21 10:35:47', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 6),
     360(12, 4, 5, '2008-10-21 10:35:47', '0000-00-00 00:00:00', '2008-10-21 10:35:47', '2008-10-21 10:36:21', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 7),
     361(13, 4, 5, '2008-10-21 10:36:21', '0000-00-00 00:00:00', '2008-10-21 10:36:21', '2008-10-21 10:36:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 8),
     362(14, 4, 5, '2008-10-21 10:36:36', '0000-00-00 00:00:00', '2008-10-21 10:36:36', '2008-10-21 10:38:25', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 9),
     363(15, 4, 5, '2008-10-21 10:38:25', '0000-00-00 00:00:00', '2008-10-21 10:38:25', '2008-10-21 10:39:52', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 10),
     364(16, 4, 5, '2008-10-21 10:39:52', '0000-00-00 00:00:00', '2008-10-21 10:39:52', '2008-10-21 10:39:57', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 11),
     365(17, 4, 5, '2008-10-21 10:39:57', '0000-00-00 00:00:00', '2008-10-21 10:39:57', '2008-10-21 11:40:16', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 12),
     366(18, 4, 5, '2008-10-21 11:40:16', '0000-00-00 00:00:00', '2008-10-21 11:40:16', '2008-10-21 11:41:33', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 13),
     367(19, 4, 5, '2008-10-21 11:41:33', '0000-00-00 00:00:00', '2008-10-21 11:41:33', '2008-10-21 11:41:42', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 14),
     368(20, 4, 5, '2008-10-21 11:41:42', '0000-00-00 00:00:00', '2008-10-21 11:41:42', '2008-10-21 11:41:50', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 15),
     369(21, 4, 5, '2008-10-21 11:41:50', '0000-00-00 00:00:00', '2008-10-21 11:41:50', '2008-10-21 11:41:54', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 16),
     370(22, 4, 5, '2008-10-21 11:41:54', '0000-00-00 00:00:00', '2008-10-21 11:41:54', '2008-10-21 11:42:30', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 17),
     371(23, 4, 5, '2008-10-21 11:42:30', '0000-00-00 00:00:00', '2008-10-21 11:42:30', '2008-10-21 11:42:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 18),
     372(24, 4, 5, '2008-10-21 11:42:36', '0000-00-00 00:00:00', '2008-10-21 11:42:36', '2008-10-21 11:42:41', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 19),
     373(25, 4, 5, '2008-10-21 11:42:41', '0000-00-00 00:00:00', '2008-10-21 11:42:41', '2008-10-21 11:47:30', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 20),
     374(26, 4, 5, '2008-10-21 11:47:30', '0000-00-00 00:00:00', '2008-10-21 11:47:30', '2008-10-21 11:47:39', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 21),
     375(27, 4, 5, '2008-10-21 11:47:39', '0000-00-00 00:00:00', '2008-10-21 11:47:39', '2008-10-21 11:49:23', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 22),
     376(28, 4, 5, '2008-10-21 11:49:23', '0000-00-00 00:00:00', '2008-10-21 11:49:23', '2008-10-21 11:53:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 23),
     377(29, 4, 5, '2008-10-21 11:53:36', '0000-00-00 00:00:00', '2008-10-21 11:53:36', '2008-10-21 11:53:42', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 24),
     378(30, 4, 5, '2008-10-21 11:53:42', '0000-00-00 00:00:00', '2008-10-21 11:53:42', '2008-10-21 11:56:52', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 25),
     379(31, 4, 5, '2008-10-21 11:56:52', '0000-00-00 00:00:00', '2008-10-21 11:56:52', '2008-10-21 12:04:01', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 26),
     380(32, 4, 5, '2008-10-21 12:04:01', '0000-00-00 00:00:00', '2008-10-21 12:04:01', '2008-10-21 12:05:49', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 27),
     381(33, 4, 5, '2008-10-21 12:05:49', '0000-00-00 00:00:00', '2008-10-21 12:05:49', '2008-10-21 12:07:48', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 28),
     382(34, 4, 5, '2008-10-21 12:07:48', '0000-00-00 00:00:00', '2008-10-21 12:07:48', '0000-00-00 00:00:00', 8, 11, 6, '2000-01-01', 2, 0, 3, 0, 29),
     383(35, 7, 28, '2008-10-21 15:53:47', '0000-00-00 00:00:00', '2008-10-21 15:53:47', '0000-00-00 00:00:00', 15, 1, 0, '1900-01-01', 2, 0, 2, 0, 30),
     384(36, 8, 28, '2008-10-21 15:54:04', '0000-00-00 00:00:00', '2008-10-21 15:54:04', '0000-00-00 00:00:00', 0, 0, 0, '0000-00-00', 0, 0, 0, 0, 31);
    279385
    280386-- --------------------------------------------------------
     
    318424
    319425--
     426-- Struktura tabulky `NewsGroup`
     427--
     428
     429CREATE TABLE IF NOT EXISTS `NewsGroup` (
     430  `Id` int(11) NOT NULL auto_increment,
     431  `ItemId` int(11) NOT NULL,
     432  `Author` int(11) NOT NULL,
     433  `ValidTimeFrom` datetime default NULL,
     434  `ValidTimeTo` datetime default NULL,
     435  `CreationTime` datetime default NULL,
     436  `DeletionTime` datetime default NULL,
     437  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     438  `NewsItems` int(11) NOT NULL,
     439  PRIMARY KEY  (`Id`)
     440) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ;
     441
     442--
     443-- Vypisuji data pro tabulku `NewsGroup`
     444--
     445
     446INSERT INTO `NewsGroup` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `NewsItems`) VALUES
     447(1, 1, 28, '2008-10-21 14:51:50', NULL, '2008-10-21 14:51:50', NULL, 'Různé informace', 0),
     448(2, 2, 28, '2008-10-21 14:52:11', NULL, '2008-10-21 14:52:11', NULL, 'Bazar', 0),
     449(3, 3, 28, '2008-10-21 14:52:25', NULL, '2008-10-21 14:52:25', NULL, 'Dění v obci', 0),
     450(4, 4, 28, '2008-10-21 14:52:39', NULL, '2008-10-21 14:52:39', NULL, 'Správa sítě - oznámení', 0),
     451(5, 5, 28, '2008-10-21 14:52:53', NULL, '2008-10-21 14:52:53', NULL, 'Správa sítě - změny zařízení', 0),
     452(6, 6, 28, '2008-10-21 14:53:07', NULL, '2008-10-21 14:53:07', NULL, 'Multimediální archív', 0),
     453(7, 7, 28, '2008-10-21 14:53:51', NULL, '2008-10-21 14:53:51', NULL, 'Správa sítě - výpadky', 0),
     454(8, 8, 28, '2008-10-21 14:58:03', NULL, '2008-10-21 14:58:03', NULL, 'Sport', 0);
     455
     456-- --------------------------------------------------------
     457
     458--
     459-- Struktura tabulky `NewsItem`
     460--
     461
     462CREATE TABLE IF NOT EXISTS `NewsItem` (
     463  `Id` int(11) NOT NULL auto_increment,
     464  `ItemId` int(11) NOT NULL,
     465  `Author` int(11) NOT NULL,
     466  `ValidTimeFrom` datetime default NULL,
     467  `ValidTimeTo` datetime default NULL,
     468  `CreationTime` datetime default NULL,
     469  `DeletionTime` datetime default NULL,
     470  `Title` varchar(255) collate utf8_czech_ci NOT NULL,
     471  `Content` varchar(255) collate utf8_czech_ci NOT NULL,
     472  `NewsGroup` int(11) NOT NULL,
     473  `Enclosure` int(11) NOT NULL,
     474  PRIMARY KEY  (`Id`)
     475) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ;
     476
     477--
     478-- Vypisuji data pro tabulku `NewsItem`
     479--
     480
     481INSERT INTO `NewsItem` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Title`, `Content`, `NewsGroup`, `Enclosure`) VALUES
     482(1, 1, 28, '2008-10-21 14:57:33', NULL, '2008-10-21 14:57:33', NULL, 'Ukončovačka', '!!!POZOR!!! V sobotu 25.10.2008 \\UKONČOVACÍ AKCE\\ v kasíně. Rum + kofola 25Kč Vodka + fanta 25Kč Vodka + džus 25Kč', 1, 0),
     483(2, 2, 28, '2008-10-21 14:58:16', NULL, '2008-10-21 14:58:16', NULL, 'Fotbalové utkání', 'dsdada', 8, 0),
     484(3, 3, 28, '2008-10-21 15:57:44', NULL, '2008-10-21 15:57:44', NULL, 'Čistota', 'Na 1100 speciálně školených pracovníků je připraveno přesvědčit Vás o významu slova čistota.', 1, 0),
     485(4, 4, 28, '2008-10-21 15:58:31', NULL, '2008-10-21 15:58:31', NULL, 'Hokej v 15:00(19.10)', 'Zitra v nedeli 19.10 v 15:00 hod. si p pridte zahrat jako kazdy tyden hokej .Dnes(sobota)jsme si byli zapinkat.tak pridte at je nas co nejvic Aktualni vysledky poctu lidi na hristi najdete na web kamere .Sportu zdar a hokeji zvlast', 8, 0),
     486(5, 5, 28, '2008-10-21 15:59:35', NULL, '2008-10-21 15:59:35', NULL, 'Apokalipsa', 'Přírodní živel zničil celou síť.', 7, 0);
     487
     488-- --------------------------------------------------------
     489
     490--
     491-- Struktura tabulky `Permission`
     492--
     493
     494CREATE TABLE IF NOT EXISTS `Permission` (
     495  `Id` int(11) NOT NULL auto_increment,
     496  `ItemId` int(11) NOT NULL,
     497  `Author` int(11) NOT NULL,
     498  `ValidTimeFrom` datetime default NULL,
     499  `ValidTimeTo` datetime default NULL,
     500  `CreationTime` datetime default NULL,
     501  `DeletionTime` datetime default NULL,
     502  `List` int(11) NOT NULL,
     503  `Item` int(11) NOT NULL,
     504  `Right` int(11) NOT NULL,
     505  `PermissionGroup` int(11) NOT NULL,
     506  PRIMARY KEY  (`Id`)
     507) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=43 ;
     508
     509--
     510-- Vypisuji data pro tabulku `Permission`
     511--
     512
     513INSERT INTO `Permission` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `List`, `Item`, `Right`, `PermissionGroup`) VALUES
     514(1, 1, 5, '2008-10-13 10:45:28', NULL, '2008-10-13 10:45:28', '2008-10-13 13:17:44', 1, 0, 0, 7),
     515(2, 2, 5, '2008-10-13 10:47:10', NULL, '2008-10-13 10:47:10', NULL, 1, 0, 2, 2),
     516(3, 3, 5, '2008-10-13 10:49:22', NULL, '2008-10-13 10:49:22', NULL, 2, 0, 2, 2),
     517(4, 4, 5, '2008-10-13 11:08:44', NULL, '2008-10-13 11:08:44', NULL, 3, 0, 2, 2),
     518(5, 5, 5, '2008-10-13 11:10:14', NULL, '2008-10-13 11:10:14', NULL, 4, 0, 2, 2),
     519(6, 6, 0, '2008-10-13 12:43:44', NULL, '2008-10-13 12:43:44', '2008-10-13 13:17:41', 7, 0, 2, 2),
     520(7, 7, 0, '2008-10-13 12:43:59', NULL, '2008-10-13 12:43:59', '2008-10-13 13:17:40', 7, 0, 2, 2),
     521(8, 8, 0, '2008-10-13 12:45:14', NULL, '2008-10-13 12:45:14', '2008-10-13 13:17:38', 7, 0, 2, 2),
     522(9, 9, 0, '2008-10-13 12:48:25', NULL, '2008-10-13 12:48:25', NULL, 7, 0, 2, 2),
     523(10, 10, 0, '2008-10-13 12:50:52', NULL, '2008-10-13 12:50:52', '2008-10-13 13:17:35', 7, 0, 2, 2),
     524(11, 11, 0, '2008-10-13 12:58:32', NULL, '2008-10-13 12:58:32', NULL, 8, 0, 2, 2),
     525(12, 12, 5, '2008-10-13 13:00:34', NULL, '2008-10-13 13:00:34', NULL, 9, 0, 2, 2),
     526(13, 9, 5, '2008-10-13 13:04:26', NULL, '2008-10-13 13:04:26', NULL, 7, 0, 2, 2),
     527(14, 9, 5, '2008-10-13 13:19:17', NULL, '2008-10-13 13:19:17', '2008-10-13 13:19:27', 7, 0, 2, 2),
     528(15, 13, 5, '2008-10-13 14:05:54', NULL, '2008-10-13 14:05:54', NULL, 8, 0, 1, 5),
     529(16, 14, 5, '2008-10-13 14:06:21', NULL, '2008-10-13 14:06:21', NULL, 2, 0, 1, 5),
     530(17, 15, 5, '2008-10-21 07:06:14', NULL, '2008-10-21 07:06:14', NULL, 1, 0, 2, 1),
     531(18, 16, 5, '2008-10-21 08:10:57', NULL, '2008-10-21 08:10:57', NULL, 21, 0, 2, 1),
     532(19, 17, 5, '2008-10-21 08:51:03', NULL, '2008-10-21 08:51:03', NULL, 7, 0, 0, 1),
     533(20, 18, 5, '2008-10-21 12:44:55', NULL, '2008-10-21 12:44:55', '2008-10-21 13:14:45', 8, 0, 1, 1),
     534(21, 19, 5, '2008-10-21 12:57:35', NULL, '2008-10-21 12:57:35', '2008-10-21 12:58:43', 3, 0, 0, 1),
     535(22, 20, 5, '2008-10-21 12:57:54', NULL, '2008-10-21 12:57:54', '2008-10-21 12:58:23', 20, 0, 0, 1),
     536(23, 21, 5, '2008-10-21 12:58:11', NULL, '2008-10-21 12:58:11', NULL, 14, 0, 2, 1),
     537(24, 20, 5, '2008-10-21 12:58:23', NULL, '2008-10-21 12:58:23', '2008-10-21 13:11:11', 20, 0, 2, 1),
     538(25, 19, 5, '2008-10-21 12:58:43', NULL, '2008-10-21 12:58:43', NULL, 3, 0, 2, 1),
     539(26, 22, 5, '2008-10-21 12:58:54', NULL, '2008-10-21 12:58:54', NULL, 11, 0, 2, 1),
     540(27, 23, 5, '2008-10-21 12:59:08', NULL, '2008-10-21 12:59:08', NULL, 19, 0, 2, 1),
     541(28, 24, 5, '2008-10-21 12:59:15', NULL, '2008-10-21 12:59:15', NULL, 18, 0, 2, 1),
     542(29, 20, 5, '2008-10-21 13:11:11', NULL, '2008-10-21 13:11:11', NULL, 20, 0, 1, 1),
     543(30, 25, 5, '2008-10-21 13:14:20', NULL, '2008-10-21 13:14:20', NULL, 4, 0, 2, 1),
     544(31, 18, 5, '2008-10-21 13:14:45', NULL, '2008-10-21 13:14:45', '2008-10-21 13:18:52', 8, 0, 0, 1),
     545(32, 26, 5, '2008-10-21 13:18:17', NULL, '2008-10-21 13:18:17', '2008-10-21 13:18:39', 0, 0, 0, 1),
     546(33, 26, 5, '2008-10-21 13:18:39', NULL, '2008-10-21 13:18:39', NULL, 5, 0, 1, 1),
     547(34, 18, 5, '2008-10-21 13:18:52', NULL, '2008-10-21 13:18:52', NULL, 8, 0, 1, 1),
     548(35, 27, 5, '2008-10-21 13:19:36', NULL, '2008-10-21 13:19:36', NULL, 13, 0, 2, 1),
     549(36, 28, 5, '2008-10-21 13:48:35', NULL, '2008-10-21 13:48:35', NULL, 7, 0, 1, 5),
     550(37, 29, 5, '2008-10-21 13:49:05', NULL, '2008-10-21 13:49:05', '2008-10-21 14:36:27', 21, 0, 1, 5),
     551(38, 30, 5, '2008-10-21 13:49:48', NULL, '2008-10-21 13:49:48', NULL, 15, 0, 1, 1),
     552(39, 29, 28, '2008-10-21 14:36:27', NULL, '2008-10-21 14:36:27', NULL, 21, 0, 0, 5),
     553(40, 31, 28, '2008-10-21 14:45:36', NULL, '2008-10-21 14:45:36', NULL, 23, 0, 2, 1),
     554(41, 32, 28, '2008-10-21 14:54:31', NULL, '2008-10-21 14:54:31', NULL, 22, 0, 2, 1),
     555(42, 33, 28, '2008-10-21 16:09:19', NULL, '2008-10-21 16:09:19', NULL, 24, 0, 1, 1);
     556
     557-- --------------------------------------------------------
     558
     559--
     560-- Struktura tabulky `PermissionGroup`
     561--
     562
     563CREATE TABLE IF NOT EXISTS `PermissionGroup` (
     564  `Id` int(11) NOT NULL auto_increment,
     565  `ItemId` int(11) NOT NULL,
     566  `Author` int(11) NOT NULL,
     567  `ValidTimeFrom` datetime default NULL,
     568  `ValidTimeTo` datetime default NULL,
     569  `CreationTime` datetime default NULL,
     570  `DeletionTime` datetime default NULL,
     571  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     572  `PermissionList` int(11) NOT NULL,
     573  `UserList` int(11) NOT NULL,
     574  PRIMARY KEY  (`Id`)
     575) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
     576
     577--
     578-- Vypisuji data pro tabulku `PermissionGroup`
     579--
     580
     581INSERT INTO `PermissionGroup` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `PermissionList`, `UserList`) VALUES
     582(1, 1, 5, '2008-10-13 09:54:31', NULL, '2008-10-13 09:54:31', NULL, 'Administrátor', 0, 0),
     583(2, 1, 5, '2008-10-13 09:55:09', NULL, '2008-10-13 09:55:09', NULL, 'Systémoví správci', 0, 0),
     584(3, 2, 5, '2008-10-13 09:55:23', NULL, '2008-10-13 09:55:23', NULL, 'Správci sítě', 0, 0),
     585(4, 3, 5, '2008-10-13 09:55:39', NULL, '2008-10-13 09:55:39', NULL, 'Klienti', 0, 0),
     586(5, 3, 5, '2008-10-13 09:55:56', NULL, '2008-10-13 09:55:56', NULL, 'Zástupci subjektů', 0, 0),
     587(6, 4, 5, '2008-10-13 09:56:13', NULL, '2008-10-13 09:56:13', NULL, 'Připojení uživatelé', 0, 0),
     588(7, 5, 5, '2008-10-13 09:56:20', NULL, '2008-10-13 09:56:20', NULL, 'Ostatní', 0, 0);
     589
     590-- --------------------------------------------------------
     591
     592--
    320593-- Struktura tabulky `Subject`
    321594--
     
    341614  `MemberList` int(11) NOT NULL,
    342615  PRIMARY KEY  (`Id`)
    343 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=18 ;
     616) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=22 ;
    344617
    345618--
     
    360633(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Fantomas', 'Tajná 10', 'Pod vodou', '11223', '', '', '', 0, 0, '', 0),
    361634(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
    362 (14, 14, 5, '2008-10-11 22:38:49', '0000-00-00 00:00:00', '2008-10-11 22:38:49', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
    363 (15, 15, 5, '2008-10-11 22:41:56', '0000-00-00 00:00:00', '2008-10-11 22:41:56', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
    364 (16, 16, 5, '2008-10-11 22:46:30', '0000-00-00 00:00:00', '2008-10-11 22:46:30', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
    365 (17, 17, 5, '2008-10-11 22:47:36', '0000-00-00 00:00:00', '2008-10-11 22:47:36', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0);
    366 
    367 -- --------------------------------------------------------
    368 
    369 --
    370 -- Struktura tabulky `SystemList`
    371 --
    372 
    373 CREATE TABLE IF NOT EXISTS `SystemList` (
    374   `Id` int(11) NOT NULL auto_increment,
    375   `ItemId` int(11) NOT NULL,
    376   `Author` int(11) NOT NULL,
    377   `ValidTimeFrom` datetime default NULL,
    378   `ValidTimeTo` datetime default NULL,
    379   `CreationTime` datetime default NULL,
    380   `DeletionTime` datetime default NULL,
    381   `TableName` varchar(255) collate utf8_czech_ci NOT NULL,
    382   `Title` varchar(255) collate utf8_czech_ci NOT NULL,
    383   `System` tinyint(1) NOT NULL,
    384   `Items` varchar(255) collate utf8_czech_ci NOT NULL,
    385   `VisibleInMenu` int(11) NOT NULL default '1',
    386   PRIMARY KEY  (`Id`)
    387 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
    388 
    389 --
    390 -- Vypisuji data pro tabulku `SystemList`
    391 --
    392 
    393 INSERT INTO `SystemList` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `TableName`, `Title`, `System`, `Items`, `VisibleInMenu`) VALUES
    394 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'User', 'Uživatelé', 0, '', 1),
    395 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Host', 'Zařízení', 0, '', 1),
    396 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Subject', 'Finanční subjekty', 0, '', 1),
    397 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Členové sítě', 0, '', 1),
    398 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Area', 'Oblasti', 0, '', 1),
    399 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Interface', 'Rozhraní zařízení', 0, '', 1),
    400 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Asset', 'Majetek', 0, '', 1),
    401 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Tariff', 'Tarify', 0, '', 1),
    402 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberReport', 'Hlášení členů', 0, '', 1),
    403 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BankAccount', 'Bankovní účty', 0, '', 1),
    404 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SystemType', 'Definice typů', 1, '', 1),
    405 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'FinanceTransaction', 'Platební operace', 0, '', 1),
    406 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SystemList', 'Definice tabulek', 1, '', 1),
    407 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SystemListItem', 'Definice položek formulářů', 1, '', 0),
    408 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UserOnline', 'Přihlášení uživatelé', 1, '', 1),
    409 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'History', 'Historie záznamů', 1, '', 0),
    410 (28, 8, 5, '2008-10-12 21:44:42', '0000-00-00 00:00:00', '2008-10-12 21:44:42', NULL, 'Tariff', 'Tarify', 0, '', 0),
    411 (27, 8, 5, '2008-10-12 21:44:31', '0000-00-00 00:00:00', '2008-10-12 21:44:31', NULL, 'Tariff', 'Tarify', 0, '', 0),
    412 (26, 17, 5, '2008-10-12 18:38:17', '0000-00-00 00:00:00', '2008-10-12 18:38:17', NULL, 'Test', 'Testovací tabulka', 0, '', 1),
    413 (29, 8, 5, '2008-10-12 21:48:28', '0000-00-00 00:00:00', '2008-10-12 21:48:28', NULL, 'Tariff', 'Tarify', 0, '', 0),
    414 (30, 8, 5, '2008-10-12 21:48:33', '0000-00-00 00:00:00', '2008-10-12 21:48:33', NULL, 'Tariff', 'Tarify', 0, '', 0),
    415 (31, 8, 5, '2008-10-13 07:25:43', '0000-00-00 00:00:00', '2008-10-13 07:25:43', NULL, 'Tariff', 'Tarify', 0, '', 1);
    416 
    417 -- --------------------------------------------------------
    418 
    419 --
    420 -- Struktura tabulky `SystemListItem`
    421 --
    422 
    423 CREATE TABLE IF NOT EXISTS `SystemListItem` (
    424   `Id` int(11) NOT NULL auto_increment,
    425   `ItemId` int(11) NOT NULL,
    426   `Author` int(11) NOT NULL,
    427   `ValidTimeFrom` datetime default NULL,
    428   `ValidTimeTo` datetime default NULL,
    429   `CreationTime` datetime default NULL,
    430   `DeletionTime` datetime default NULL,
    431   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    432   `TextBefore` varchar(255) collate utf8_czech_ci NOT NULL,
    433   `TextAfter` varchar(255) collate utf8_czech_ci NOT NULL,
    434   `Type` varchar(255) collate utf8_czech_ci NOT NULL,
    435   `Help` varchar(255) collate utf8_czech_ci NOT NULL,
    436   `Default` varchar(255) collate utf8_czech_ci NOT NULL,
    437   `Required` tinyint(1) NOT NULL default '1',
    438   `Editable` tinyint(1) NOT NULL default '1',
    439   `VisibleInList` tinyint(1) NOT NULL default '0',
    440   `VisibleInPointer` tinyint(1) NOT NULL default '0',
    441   `List` int(11) NOT NULL,
    442   PRIMARY KEY  (`Id`)
    443 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=143 ;
    444 
    445 --
    446 -- Vypisuji data pro tabulku `SystemListItem`
    447 --
    448 
    449 INSERT INTO `SystemListItem` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `TextBefore`, `TextAfter`, `Type`, `Help`, `Default`, `Required`, `Editable`, `VisibleInList`, `VisibleInPointer`, `List`) VALUES
    450 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'FirstName', 'Jméno', '', '3', 'Zadejte jméno', '', 1, 1, 1, 1, 1),
    451 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SecondName', 'Příjmení', '', '3', 'Zadejte příjmení', '', 1, 1, 1, 1, 1),
    452 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Email', 'E-mail', '', '3', 'Zadejte emailovou adresu', '', 1, 1, 1, 0, 1),
    453 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ICQ', 'ICQ', '', '1', 'Zadejte kontaktní číslo textového komunikačního programu ICQ.', '', 0, 1, 0, 0, 1),
    454 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Sex', 'Pohlaví', '', '5', 'Vyberte pohlaví osoby', '', 0, 1, 0, 0, 1),
    455 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BirthDay', 'Datum narození', '', '2', 'Vyberte datum narození', '', 0, 1, 0, 0, 1),
    456 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DomainName', 'Doménové jméno', '', '3', 'Zadejte jméno počítače v doméně', '', 1, 1, 1, 1, 2),
    457 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'NetBIOSName', 'NetBIOSové jméno', '', '3', 'Zadejte jméno počítače v rámci protokolů NetBIOS a sdílení souborů', '', 0, 1, 0, 0, 2),
    458 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LocalIPAddress', 'Místní IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci místní sítě', '', 1, 1, 1, 0, 2),
    459 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PublicIPAddress', 'Veřejná IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci Internetu', '', 0, 1, 1, 0, 2),
    460 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LastOnlineDate', 'Naposledy online', '', '2', 'Čas posledního úspěšného měření dostupnosti počítače', '', 0, 0, 0, 0, 2),
    461 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Jméno', '', '3', 'Jméno subjektu', '', 1, 1, 1, 1, 3),
    462 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'AddressStreet', 'Ulice', '', '3', 'Ulice', '', 1, 1, 1, 0, 3),
    463 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'AddressTown', 'Město', '', '3', 'Město', '', 1, 1, 1, 0, 3),
    464 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'AddressZIP', 'PSČ', '', '3', '', '', 1, 1, 1, 0, 3),
    465 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IC', 'IČ', '', '3', 'Identifikační číslo subjektu', '', 0, 1, 0, 0, 3),
    466 (17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DIC', 'DIČ', '', '3', 'Daňové identifikační číslo', '', 0, 1, 0, 0, 3),
    467 (18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MapPositionX', 'Horizontálně pozice', '', '1', 'Vodorovná pozice na mapě', '', 0, 1, 0, 0, 4),
    468 (19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MapPositionY', 'Vertikální pozice', '', '1', 'Svislá pozice na mapě', '', 0, 1, 0, 0, 4),
    469 (20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MembershipDate', 'Začátek členství', '', '2', 'Datum přípojení do sítě', '', 0, 1, 0, 0, 4),
    470 (21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'FamilyMemberCount', 'Osob v rodině', '', '1', 'Počet osob v připojené domácnosti', '', 0, 1, 0, 0, 4),
    471 (22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ResponsibleUser', 'Zodpovědný uživatel', '', '37', '', '', 1, 1, 1, 1, 4),
    472 (23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Subject', 'Subjekt', '', '33', '', '', 1, 1, 0, 0, 4),
    473 (24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Druh', '', '7', '', '1', 0, 1, 1, 0, 2),
    474 (25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Phone', 'Telefón', '', '3', '', '', 0, 1, 0, 0, 1),
    475 (26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Notice', 'Poznámka', '', '3', '', '', 0, 1, 0, 0, 3),
    476 (27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberState', 'Stav připojení', '', '6', '', '', 1, 1, 1, 0, 4),
    477 (28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'HostList', 'Registrované zařízení', '', '23', '', '', 0, 1, 0, 0, 4),
    478 (29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 5),
    479 (30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'NetworkIPAddress', 'Adresa sítě', '', '3', '', '', 1, 1, 1, 0, 5),
    480 (31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IPAddressMask', 'Maska sítě', '', '3', '', '', 1, 1, 1, 0, 5),
    481 (32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DNSPrimary', 'Primární DNS server', '', '3', '', '', 0, 1, 0, 0, 5),
    482 (33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DNSSecondary', 'Sukundární DNS server', '', '3', '', '', 0, 1, 0, 0, 5),
    483 (34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DHCP', 'DHCP server', '', '3', '', '', 0, 1, 0, 0, 5),
    484 (35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Domain', 'Doména', '', '3', '', '', 0, 1, 0, 0, 5),
    485 (36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Workgroup', 'Pracovní skupina', '', '3', '', '', 0, 1, 0, 0, 5),
    486 (37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'WINS', 'WINS server', '', '3', '', '', 0, 1, 0, 0, 5),
    487 (38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 6),
    488 (39, 39, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Typ', '', '8', '', '', 1, 1, 1, 0, 6),
    489 (40, 40, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Host', 'Zařízení', '', '31', 'Vyberte zařízení, ke kterému patří toto rozhraní.', '', 1, 1, 1, 0, 6),
    490 (41, 41, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ParentHost', 'Připojeno k bodu', '', '31', '', '', 1, 1, 1, 0, 6),
    491 (42, 42, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Interface', 'Rozhraní', '', '24', '', '', 0, 1, 0, 0, 2),
    492 (43, 43, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MAC', 'Fyzická adresa', '', '3', 'Zadejte fyzickou adresu síťové karty též nazývanou MAC adresa.', '', 1, 1, 0, 0, 6),
    493 (44, 44, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ParentHost', 'Nadřazený uzel', '', '31', '', '', 0, 1, 0, 0, 2),
    494 (45, 45, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SubHostList', 'Připojené zařízení', '', '38', 'Seznam podřízených zařízení ve virtuálním stromu propojení.', '', 0, 1, 0, 0, 2),
    495 (46, 46, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 7),
    496 (47, 47, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeEnlistment', 'Čas zařazení', '', '2', '', '', 1, 1, 0, 0, 7),
    497 (48, 48, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeElimination', 'Čas vyřazení', '', '2', '', '', 0, 1, 0, 0, 7),
    498 (49, 49, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Price', 'Pořizovací cena', '', '1', '', '', 1, 1, 1, 0, 7),
    499 (50, 50, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'State', 'Stav', '', '9', '', '', 1, 1, 1, 0, 7),
    500 (51, 51, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SerialNumber', 'Sériové číslo', '', '3', '', '', 0, 1, 0, 0, 7),
    501 (52, 52, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PurcheasedFrom', 'Zakoupeno od', '', '33', '', '', 0, 1, 0, 0, 7),
    502 (53, 53, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PurcheasedAsset', 'Nakoupené zboží', '', '21', '', '', 0, 1, 0, 0, 3),
    503 (54, 54, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Člen', '', '32', '', '', 0, 1, 0, 0, 1),
    504 (113, 113, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ValidFromTime', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 4),
    505 (57, 57, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Price', 'Cena', '', '1', '', '', 1, 1, 1, 0, 8),
    506 (56, 56, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 8),
    507 (58, 58, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MinUploadSpeed', 'Minimální odchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8),
    508 (59, 59, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MaxUploadSpeed', 'Maximální odchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8),
    509 (60, 60, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MinDownloadSpeed', 'Minimální příchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8),
    510 (61, 61, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MaxDownloadSpeed', 'Max příchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8),
    511 (62, 62, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UserName', 'Uživatelské jméno', '', '3', '', '', 1, 1, 0, 0, 1),
    512 (63, 63, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Password', 'Heslo', '', '15', '', '', 1, 1, 0, 0, 1),
    513 (64, 64, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Členové', '', '26', '', '', 0, 1, 0, 0, 8),
    514 (65, 65, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Tariff', 'Tarif', '', '36', '', '', 1, 1, 1, 0, 4),
    515 (66, 66, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Vlastník', '', '32', '', '', 0, 1, 0, 0, 2),
    516 (67, 67, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'WWW', 'Internetové stránky', '', '18', '', '', 0, 1, 0, 0, 3),
    517 (68, 68, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Text', 'Text zprávy', '', '3', '', '', 1, 1, 1, 1, 9),
    518 (69, 69, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Date', 'Datum', '', '2', '', '', 1, 1, 1, 0, 9),
    519 (70, 70, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Člen', '', '32', '', '', 1, 1, 1, 0, 9),
    520 (71, 71, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Typ zprávy', '', '10', '', '', 1, 1, 1, 0, 9),
    521 (72, 72, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ReportList', 'Záznamy', '', '27', '', '', 0, 1, 0, 0, 4),
    522 (73, 73, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Creator', 'Vložil', '', '37', '', '', 1, 1, 0, 0, 9),
    523 (74, 74, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 10),
    524 (75, 75, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BankName', 'Jméno banky', '', '3', '', '', 1, 1, 0, 0, 10),
    525 (76, 76, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Number', 'Identifikační číslo', '', '3', '', '', 1, 1, 1, 0, 10),
    526 (77, 77, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BankCode', 'Kód banky', '', '3', '', '', 1, 1, 1, 0, 10),
    527 (78, 78, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'User', 'Registroval', '', '37', '', '', 0, 1, 0, 0, 10),
    528 (79, 79, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Typ', '', '11', '', '', 1, 1, 1, 0, 10),
    529 (80, 80, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberList', 'Členství', '', '25', '', '', 0, 1, 0, 0, 3),
    530 (81, 81, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Systémové jméno typu', '', '3', 'Jméno by mělo obsahovat pouze velké a malé písmena. V podsložece types projektu jsou umístěny výkonné soubory pro jednotlivé typy.', 'Name', 1, 1, 1, 1, 11),
    531 (82, 82, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ParentType', 'Rodičovský typ', '', '35', '', '', 1, 1, 1, 0, 11),
    532 (83, 83, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Parameters', 'Parametry typu', '', '3', '', 'Parametry zadávejte jako řetězce oddělené symblem "|".', 0, 1, 0, 0, 11),
    533 (84, 84, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'System', 'Systémový', '', '4', '', '0', 1, 1, 0, 0, 11),
    534 (88, 88, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 11),
    535 (89, 89, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 12),
    536 (90, 90, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Amount', 'Částka', '', '16', '', '', 1, 1, 1, 0, 12),
    537 (91, 91, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Time', 'Čas', '', '2', '', '', 1, 1, 1, 0, 12),
    538 (92, 92, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SourceSubject', 'Zdrojový subjekt', '', '33', '', '', 1, 1, 1, 0, 12),
    539 (93, 93, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TargetSubject', 'Cílový subjekt', '', '33', '', '', 1, 1, 1, 0, 12),
    540 (94, 94, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Type', '', '15', '', '', 1, 1, 0, 0, 12),
    541 (95, 95, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'InsertedByUser', 'Vložil', '', '37', '', '', 0, 0, 0, 0, 12),
    542 (96, 96, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DbDataType', 'Datový typ v databázi', '', '3', '', '', 1, 1, 0, 0, 11),
    543 (97, 97, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TableName', 'Jméno tabulky', '', '3', 'Zadejte jméno tabulky v databázi, která bude použita pro uchování informací.', '', 1, 1, 1, 0, 13),
    544 (98, 98, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Title', 'Název seznamu', '', '3', 'Zadejte nadpis seznamu.', '', 1, 1, 1, 1, 13),
    545 (99, 99, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'VisibleInMenu', 'Viditelné v menu', '', '4', 'Zobrazovat tuto tabulku v hlavním menu', '', 1, 1, 0, 0, 13),
    546 (100, 100, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Items', 'Položky', '', '28', 'Definujte potřebné položky pro seznam.', '', 1, 1, 0, 0, 13),
    547 (101, 101, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Jméno sloupce', '', '3', 'Jméno sloupce tabulky v databázi', '', 1, 1, 1, 0, 14),
    548 (102, 102, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TextBefore', 'Text před hodnotou', '', '3', 'Oznčení položky umístěné před zobrazenou hodnotou.', '', 1, 1, 1, 1, 14),
    549 (103, 103, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TextAfter', 'Text za hodnotou', '', '3', 'Tento text většinou obsahuje jednotky použité veličiny.', '', 1, 1, 0, 0, 14),
    550 (104, 104, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Type', '', '35', 'Typ dat položky', '', 1, 1, 1, 0, 14),
    551 (105, 105, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Help', 'Nápověda', '', '3', 'Textová nápověda zobrazovaná jako pomůcka při editaci hodnoty.', '', 1, 1, 0, 0, 14),
    552 (106, 106, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Required', 'Požadováno', '', '4', 'Určuje zda je nutné danou položku vyplnit.', '', 1, 1, 0, 0, 14),
    553 (107, 107, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Editable', 'Editovatelné', '', '4', 'Určuje zda je možné danou položku ručně editovat nebo zda je měněna automaticky systémem.', '', 1, 1, 0, 0, 14),
    554 (108, 108, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'VisibleInList', 'Viditelné v seznamu', '', '4', 'Určuje viditelnost této položky v seznamu', '', 1, 1, 0, 0, 14),
    555 (109, 109, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'VisibleInPointer', 'Viditelné v odkazech', '', '4', 'Určuje viditelnost této položky v názvech odkazů na tuto položku', '', 1, 1, 0, 0, 14),
    556 (110, 110, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Area', 'Umístění', '', '30', 'Vyberte oblast, do které toto zařízení patří.', '', 0, 1, 0, 0, 2),
    557 (111, 111, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'HostList', 'Seznam zařízení', '', '22', '', '', 0, 1, 0, 0, 5),
    558 (112, 112, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UserList', 'Uživatelů', '', '29', '', '', 0, 1, 0, 0, 4),
    559 (114, 114, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ValidToTime', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 4),
    560 (115, 115, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'User', 'Uživatel', '', '37', '', '', 1, 0, 1, 1, 15),
    561 (116, 116, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LoginTime', 'Čas přihlášení', '', '2', '', '', 0, 0, 0, 0, 15),
    562 (117, 117, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ActivityTime', 'Naposledy aktivní', '', '2', '', '', 0, 0, 0, 0, 15),
    563 (118, 118, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SessionId', 'Identifikace spojení', '', '3', '', '', 0, 0, 0, 0, 15),
    564 (119, 119, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IpAddress', 'IP adresa', '', '3', '', '', 0, 0, 0, 0, 15),
    565 (120, 120, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'HostName', 'Jméno počítače', '', '3', '', '', 0, 0, 1, 0, 15),
    566 (121, 121, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Locked', 'Zamčeno', '', '4', '', '', 0, 0, 0, 0, 1),
    567 (122, 122, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'RegistrationTime', 'Čas registrace', '', '2', '', '', 0, 0, 0, 0, 1),
    568 (123, 123, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LastLoginTime', 'Čas posledního přihlášení', '', '2', '', '', 0, 0, 0, 0, 1),
    569 (124, 124, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LastIpAddress', 'Poslední IP adresa', '', '3', '', '', 0, 0, 0, 0, 1),
    570 (125, 125, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Author', 'Autor', '', '37', '', '', 1, 0, 0, 0, 16),
    571 (126, 126, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeCreation', 'Čas vytvoření', '', '2', '', '', 1, 0, 0, 0, 16),
    572 (127, 127, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeValidFrom', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 16),
    573 (128, 128, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeValidTo', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 16),
    574 (129, 129, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ListId', 'Odkazovaná tabulka', '', '34', '', '', 1, 1, 0, 0, 16),
    575 (130, 130, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PermanentId', 'Trvalá identifikace', '', '1', '', '', 1, 1, 0, 0, 16),
    576 (133, 132, 5, '2008-10-12 17:48:27', '0000-00-00 00:00:00', '2008-10-12 17:48:27', NULL, 'List', 'Rodičovský seznam', '', '34', '', '', 1, 0, 0, 0, 14),
    577 (142, 133, 5, '2008-10-12 18:39:09', '0000-00-00 00:00:00', '2008-10-12 18:39:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 26);
    578 
    579 -- --------------------------------------------------------
    580 
    581 --
    582 -- Struktura tabulky `SystemType`
    583 --
    584 
    585 CREATE TABLE IF NOT EXISTS `SystemType` (
    586   `Id` int(11) NOT NULL auto_increment,
    587   `ItemId` int(11) NOT NULL,
    588   `Author` int(11) NOT NULL,
    589   `ValidTimeFrom` datetime default NULL,
    590   `ValidTimeTo` datetime default NULL,
    591   `CreationTime` datetime default NULL,
    592   `DeletionTime` datetime default NULL,
    593   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    594   `Description` varchar(255) collate utf8_czech_ci NOT NULL,
    595   `ParentType` int(255) NOT NULL,
    596   `Parameters` varchar(255) collate utf8_czech_ci NOT NULL,
    597   `System` tinyint(1) NOT NULL default '0',
    598   `DbDataType` varchar(255) collate utf8_czech_ci NOT NULL,
    599   PRIMARY KEY  (`Id`),
    600   UNIQUE KEY `Name` (`Name`)
    601 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=39 ;
    602 
    603 --
    604 -- Vypisuji data pro tabulku `SystemType`
    605 --
    606 
    607 INSERT INTO `SystemType` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Description`, `ParentType`, `Parameters`, `System`, `DbDataType`) VALUES
    608 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Integer', 'Číslo', 0, '', 1, 'INT'),
    609 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Date', 'Datum', 0, '', 1, 'DATE'),
    610 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'String', 'Řetězec', 0, '', 1, 'VARCHAR(255)'),
    611 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Boolean', 'Logická hodnota', 0, '', 1, 'BOOL'),
    612 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Sex', 'Pohlaví', 14, 'Muž|Žena', 0, ''),
    613 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberState', 'Stav člena', 14, 'Neznámý stav|Zájemce o připojení|Připojen|Trvale odpojen', 0, ''),
    614 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'HostType', 'Typ zařízení', 14, 'Nezařazeno|Osobní počítač|VoIP zařízení|IPTV zařízení|Směrovač|Server|Tiskárna/Skener/Kopírka|Jiné', 0, ''),
    615 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'InterfaceType', 'Typ rozhraní', 14, 'Jiný|Ethernet 10 Mbit/s|Ethernet 100 Mbit/s|Ethernet 1 Gbit/s|Wifi 2,4 GHz 802.11b 11 Mbit/s|Wifi 2,4 GHz 802.11g 54 Mbit/s|Wifi 5 GHz 802.11a 54 Mbit/s|Optika 100 Mbit/s|Optika 1 Gbit/s', 0, ''),
    616 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'AssetState', 'Stav majetku', 14, 'Neznámý|Na skladě|Používáno|V reklamaci|Vyřazeno', 0, ''),
    617 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberReportType', 'Typ hlášení člena', 14, 'Jiné|Hlášení závady|Požadavek na změnu|Poznámka správce', 0, ''),
    618 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BankAccountType', 'Typ účtu', 14, 'Neurčeno|Běžný účet|Spořící účet', 0, ''),
    619 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerOneToOne', 'Ukazatel na jednu položku', 0, '', 1, 'INT'),
    620 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerOneToMany', 'Ukazatel na více položek', 0, '', 1, 'INT'),
    621 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Enumeration', 'Výčet', 0, '', 0, 'INT'),
    622 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Password', 'Heslo', 0, '', 1, ''),
    623 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Float', 'Desetinné číslo', 0, '', 1, 'FLOAT'),
    624 (17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'FinanceTransactionType', 'Typ finanční transakce', 14, 'Bankovní převod|Osobní platba', 0, ''),
    625 (18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Hyperlink', 'Internetový odkaz', 0, '', 0, 'VARCHAR(255)'),
    626 (19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IPv4Address', 'IP adresa v4', 0, '', 0, 'VARCHAR(16)'),
    627 (20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Hidden', 'Skrytá položka formuláře', 0, '', 1, 'VARCHAR(255)'),
    628 (21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:01:23', NULL, 'PointerToAssetPurcheasedFrom', '', 13, 'Asset|PurcheasedFrom', 0, ''),
    629 (22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:02:00', NULL, 'PointerToHostArea', '', 13, 'Host|Area', 0, ''),
    630 (23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:04:28', NULL, 'PointerToHostMember', '', 13, 'Host|Member', 0, ''),
    631 (24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:05:47', NULL, 'PointerToInterfaceHost', '', 13, 'Interface|Host', 0, ''),
    632 (25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', NULL, 'PointerToMemberSubject', '', 13, 'Member|Subject', 0, ''),
    633 (26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', NULL, 'PointerToMemberTariff', '', 13, 'Member|Tariff', 0, ''),
    634 (27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToMemberReportMember', '', 13, 'MemberReport|Member      ', 0, ''),
    635 (28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToSystemListItemList', '', 13, 'SystemListItem|List', 0, ''),
    636 (29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', NULL, 'PointerToUserMember', '', 13, 'User|Member', 0, ''),
    637 (30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', NULL, 'PointerToArea', '', 12, 'Area', 0, ''),
    638 (31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerOneToHost', '', 12, 'Host', 0, ''),
    639 (32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToMember', '', 12, 'Member', 0, ''),
    640 (33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:11:14', NULL, 'PointerToSubject', '', 12, 'Subject', 0, ''),
    641 (34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:12:37', NULL, 'PointerToSystemList', '', 12, 'SystemList', 0, ''),
    642 (35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToSystemType', '', 12, 'SystemType', 0, ''),
    643 (36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', NULL, 'PointerToTariff', '', 12, 'Tariff', 0, ''),
    644 (37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', NULL, 'PointerToUser', '', 12, 'User', 0, ''),
    645 (38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToHostParentHost', '', 13, 'Host|ParentHost', 0, '');
    646 
    647 -- --------------------------------------------------------
    648 
    649 --
    650 -- Struktura tabulky `Tariff`
    651 --
    652 
    653 CREATE TABLE IF NOT EXISTS `Tariff` (
    654   `Id` int(11) NOT NULL auto_increment,
    655   `ItemId` int(11) NOT NULL,
    656   `Author` int(11) NOT NULL,
    657   `ValidTimeFrom` datetime default NULL,
    658   `ValidTimeTo` datetime default NULL,
    659   `CreationTime` datetime default NULL,
    660   `DeletionTime` datetime default NULL,
    661   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    662   `Price` float NOT NULL,
    663   `MinUploadSpeed` int(11) NOT NULL,
    664   `MaxUploadSpeed` int(11) NOT NULL,
    665   `MinDownloadSpeed` int(11) NOT NULL,
    666   `MaxDownloadSpeed` int(11) NOT NULL,
    667   `MemberList` int(11) NOT NULL,
    668   PRIMARY KEY  (`Id`)
    669 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ;
    670 
    671 --
    672 -- Vypisuji data pro tabulku `Tariff`
    673 --
    674 
    675 INSERT INTO `Tariff` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Price`, `MinUploadSpeed`, `MaxUploadSpeed`, `MinDownloadSpeed`, `MaxDownloadSpeed`, `MemberList`) VALUES
    676 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 512 kbit', 190, 31, 512, 31, 512, 0),
    677 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 1 Mbit', 260, 62, 1024, 62, 1024, 0),
    678 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 2 Mbit', 360, 124, 2048, 124, 2048, 0),
    679 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 4 Mbit', 520, 249, 4096, 249, 4096, 0),
    680 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 8 Mbit', 750, 497, 8192, 497, 8192, 0);
    681 
    682 -- --------------------------------------------------------
    683 
    684 --
    685 -- Struktura tabulky `Test`
    686 --
    687 
    688 CREATE TABLE IF NOT EXISTS `Test` (
    689   `Id` int(11) NOT NULL auto_increment,
    690   `ItemId` int(11) NOT NULL,
    691   `Author` int(11) NOT NULL,
    692   `ValidTimeFrom` datetime default NULL,
    693   `ValidTimeTo` datetime default NULL,
    694   `CreationTime` datetime default NULL,
    695   `DeletionTime` datetime default NULL,
    696   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    697   PRIMARY KEY  (`Id`)
    698 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
    699 
    700 --
    701 -- Vypisuji data pro tabulku `Test`
    702 --
    703 
    704 
    705 -- --------------------------------------------------------
    706 
    707 --
    708 -- Struktura tabulky `User`
    709 --
    710 
    711 CREATE TABLE IF NOT EXISTS `User` (
    712   `Id` int(11) NOT NULL auto_increment,
    713   `ItemId` int(11) NOT NULL,
    714   `Author` int(11) NOT NULL,
    715   `ValidTimeFrom` datetime default NULL,
    716   `ValidTimeTo` datetime default NULL,
    717   `CreationTime` datetime default NULL,
    718   `DeletionTime` datetime default NULL,
    719   `UserName` varchar(255) collate utf8_czech_ci NOT NULL,
    720   `Password` varchar(255) collate utf8_czech_ci NOT NULL,
    721   `FirstName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
    722   `SecondName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
    723   `Email` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
    724   `ICQ` int(11) NOT NULL,
    725   `Sex` int(11) NOT NULL default '0',
    726   `BirthDay` date NOT NULL,
    727   `Phone` varchar(255) collate utf8_czech_ci NOT NULL,
    728   `Member` int(11) NOT NULL,
    729   `RegistrationTime` datetime NOT NULL,
    730   `LastLoginTime` datetime NOT NULL,
    731   `Locked` tinyint(1) NOT NULL,
    732   `LastIpAddress` varchar(255) collate utf8_czech_ci NOT NULL,
    733   PRIMARY KEY  (`Id`)
    734 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13 ;
    735 
    736 --
    737 -- Vypisuji data pro tabulku `User`
    738 --
    739 
    740 INSERT INTO `User` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `UserName`, `Password`, `FirstName`, `SecondName`, `Email`, `ICQ`, `Sex`, `BirthDay`, `Phone`, `Member`, `RegistrationTime`, `LastLoginTime`, `Locked`, `LastIpAddress`) VALUES
    741 (1, 1, 5, NULL, NULL, '2008-10-13 07:50:41', NULL, '', 'fdsfsdfsd', 'Alfons', 'Much', 'mucha@all.cz', 89, 0, '0000-00-00', '', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    742 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '0000-00-00', '123456789', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    743 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ferda', '123', 'Ferda', 'Mravenec', 'ferda@mraveniste.cz', 1, 0, '0000-00-00', '', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    744 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '0000-00-00', '', 6, '0000-00-00 00:00:00', '2008-10-13 06:55:32', 0, ''),
    745 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    746 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Petr', 'Slovák', 'slovak@zdarma.cz', 34, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    747 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Alena', 'Kocourková', 'alena.kocourkova@centrum.cz', 32, 1, '0000-00-00', '223344556', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    748 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Jonny', 'Hurikán', 'storm@atlas.cz', 16, 0, '0000-00-00', '224556778', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    749 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Smrťák', 'Krutý', 'smrt@peklo.cz', 111222333, 0, '0000-00-00', '', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    750 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Karel', 'Nejedlý', 'starosta@obec-milosice.cz', 0, 0, '0000-00-00', '443666333', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    751 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'fantomas', 'dsds', 'Fantomas', 'Tajemný', 'fantom@fantom.com', 0, 0, '0000-00-00', '', 12, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '');
    752 
    753 -- --------------------------------------------------------
    754 
    755 --
    756 -- Struktura tabulky `UserOnline`
    757 --
    758 
    759 CREATE TABLE IF NOT EXISTS `UserOnline` (
    760   `User` int(11) NOT NULL,
    761   `LoginTime` datetime NOT NULL,
    762   `ActivityTime` datetime NOT NULL,
    763   `SessionId` varchar(255) collate utf8_czech_ci NOT NULL,
    764   `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL,
    765   `HostName` varchar(255) collate utf8_czech_ci NOT NULL,
    766   `Id` int(11) NOT NULL auto_increment,
    767   `ItemId` int(11) NOT NULL,
    768   `Author` int(11) NOT NULL,
    769   `ValidTimeFrom` datetime default NULL,
    770   `ValidTimeTo` datetime default NULL,
    771   `CreationTime` datetime default NULL,
    772   `DeletionTime` datetime default NULL,
    773   PRIMARY KEY  (`Id`),
    774   KEY `User` (`User`)
    775 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;
    776 
    777 --
    778 -- Vypisuji data pro tabulku `UserOnline`
    779 --
    780 
    781 INSERT INTO `UserOnline` (`User`, `LoginTime`, `ActivityTime`, `SessionId`, `IpAddress`, `HostName`, `Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`) VALUES
    782 (5, '2008-10-13 06:39:23', '2008-10-13 07:59:09', 'otgr2r8jjukmnng2rr49oi49p4', '192.168.0.23', 'george-nb.zdechov.net', 11, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
     635(14, 13, 5, '2008-10-11 22:38:49', '0000-00-00 00:00:00', '2008-10-11 22:38:49', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
     636(15, 13, 5, '2008-10-11 22:41:56', '0000-00-00 00:00:00', '2008-10-11 22:41:56', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
     637(16, 13, 5, '2008-10-11 22:46:30', '0000-00-00 00:00:00', '2008-10-11 22:46:30', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
     638(17, 13, 5, '2008-10-11 22:47:36', '0000-00-00 00:00:00', '2008-10-11 22:47:36', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
     639(18, 13, 5, '2008-10-13 08:46:07', NULL, '2008-10-13 08:46:07', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
     640(19, 14, 5, '2008-10-21 13:02:40', NULL, '2008-10-21 13:02:40', '2008-10-21 13:02:59', 'Alza', 'Pod vodou 12', 'Praha', '12012', '2312312', 'CZ34523423', '(please note if any errors come up you have not followed this guide properly also make sure your web server is on if you are running XAMPP start the top 2 \\APACHE\\ and \\MYSQL\\ tabs)', 0, 0, 'http://www.alza.cz/', 0),
     641(20, 14, 5, '2008-10-21 13:02:59', NULL, '2008-10-21 13:02:59', NULL, 'Alza', 'Pod vodou 12', 'Praha', '12012', '2312312', 'CZ34523423', 'As the name of topic says i''m wondering will the ACE problems be fixed for windows (of any distro) users ? Because i didn''t see nothing that gives hope for the past few days .I know it is not a easy way to fix it but i have a strange feeling that for us a', 0, 0, 'http://www.alza.cz/', 0),
     642(21, 15, 28, '2008-10-21 15:51:24', NULL, '2008-10-21 15:51:24', NULL, 'Kačer Skrblík', 'U trezoru', 'Kačerov', '123', '442342343', '55252345252', '', 0, 0, '', 0);
     643
     644-- --------------------------------------------------------
     645
     646--
     647-- Struktura tabulky `SystemFile`
     648--
     649
     650CREATE TABLE IF NOT EXISTS `SystemFile` (
     651  `Id` int(11) NOT NULL auto_increment,
     652  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     653  `Content` mediumblob NOT NULL,
     654  PRIMARY KEY  (`Id`)
     655) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
     656
     657--
     658-- Vypisuji data pro tabulku `SystemFile`
     659--
     660
  • sql/system_structure.sql

    r11 r18  
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Pondělí 13. října 2008, 08:00
     6-- Vygenerováno: Úterý 21. října 2008, 16:14
    77-- Verze MySQL: 5.0.51
    88-- Verze PHP: 5.2.6
     
    1717
    1818--
     19-- Struktura tabulky `Permission`
     20--
     21
     22CREATE TABLE IF NOT EXISTS `Permission` (
     23  `Id` int(11) NOT NULL auto_increment,
     24  `ItemId` int(11) NOT NULL,
     25  `Author` int(11) NOT NULL,
     26  `ValidTimeFrom` datetime default NULL,
     27  `ValidTimeTo` datetime default NULL,
     28  `CreationTime` datetime default NULL,
     29  `DeletionTime` datetime default NULL,
     30  `List` int(11) NOT NULL,
     31  `Item` int(11) NOT NULL,
     32  `Right` int(11) NOT NULL,
     33  `PermissionGroup` int(11) NOT NULL,
     34  PRIMARY KEY  (`Id`)
     35) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=43 ;
     36
     37-- --------------------------------------------------------
     38
     39--
     40-- Struktura tabulky `PermissionGroup`
     41--
     42
     43CREATE TABLE IF NOT EXISTS `PermissionGroup` (
     44  `Id` int(11) NOT NULL auto_increment,
     45  `ItemId` int(11) NOT NULL,
     46  `Author` int(11) NOT NULL,
     47  `ValidTimeFrom` datetime default NULL,
     48  `ValidTimeTo` datetime default NULL,
     49  `CreationTime` datetime default NULL,
     50  `DeletionTime` datetime default NULL,
     51  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     52  `PermissionList` int(11) NOT NULL,
     53  `UserList` int(11) NOT NULL,
     54  PRIMARY KEY  (`Id`)
     55) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
     56
     57-- --------------------------------------------------------
     58
     59--
     60-- Struktura tabulky `SystemFile`
     61--
     62
     63CREATE TABLE IF NOT EXISTS `SystemFile` (
     64  `Id` int(11) NOT NULL auto_increment,
     65  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     66  `Content` mediumblob NOT NULL,
     67  PRIMARY KEY  (`Id`)
     68) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
     69
     70-- --------------------------------------------------------
     71
     72--
     73-- Struktura tabulky `SystemGPS`
     74--
     75
     76CREATE TABLE IF NOT EXISTS `SystemGPS` (
     77  `Id` int(11) NOT NULL auto_increment,
     78  `Longitude` double NOT NULL,
     79  `Latitude` double NOT NULL,
     80  PRIMARY KEY  (`Id`)
     81) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
     82
     83-- --------------------------------------------------------
     84
     85--
    1986-- Struktura tabulky `SystemList`
    2087--
     
    3097  `TableName` varchar(255) collate utf8_czech_ci NOT NULL,
    3198  `Title` varchar(255) collate utf8_czech_ci NOT NULL,
    32   `System` tinyint(1) NOT NULL,
    3399  `Items` varchar(255) collate utf8_czech_ci NOT NULL,
    34   `VisibleInMenu` int(11) NOT NULL default '1',
    35   PRIMARY KEY  (`Id`)
    36 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
     100  `Menu` int(11) NOT NULL,
     101  PRIMARY KEY  (`Id`)
     102) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=75 ;
    37103
    38104-- --------------------------------------------------------
     
    62128  `List` int(11) NOT NULL,
    63129  PRIMARY KEY  (`Id`)
    64 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=143 ;
     130) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=184 ;
     131
     132-- --------------------------------------------------------
     133
     134--
     135-- Struktura tabulky `SystemLog`
     136--
     137
     138CREATE TABLE IF NOT EXISTS `SystemLog` (
     139  `Id` int(11) NOT NULL auto_increment,
     140  `ItemId` int(11) NOT NULL,
     141  `Author` int(11) NOT NULL,
     142  `ValidTimeFrom` datetime default NULL,
     143  `ValidTimeTo` datetime default NULL,
     144  `CreationTime` datetime default NULL,
     145  `DeletionTime` datetime default NULL,
     146  `User` int(11) NOT NULL,
     147  `List` int(11) NOT NULL,
     148  `Item` int(11) NOT NULL,
     149  `Action` int(11) NOT NULL,
     150  PRIMARY KEY  (`Id`)
     151) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=238 ;
     152
     153-- --------------------------------------------------------
     154
     155--
     156-- Struktura tabulky `SystemMenu`
     157--
     158
     159CREATE TABLE IF NOT EXISTS `SystemMenu` (
     160  `Id` int(11) NOT NULL auto_increment,
     161  `ItemId` int(11) NOT NULL,
     162  `Author` int(11) NOT NULL,
     163  `ValidTimeFrom` datetime default NULL,
     164  `ValidTimeTo` datetime default NULL,
     165  `CreationTime` datetime default NULL,
     166  `DeletionTime` datetime default NULL,
     167  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     168  `SystemListItems` int(11) NOT NULL,
     169  PRIMARY KEY  (`Id`)
     170) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
    65171
    66172-- --------------------------------------------------------
     
    84190  `System` tinyint(1) NOT NULL default '0',
    85191  `DbDataType` varchar(255) collate utf8_czech_ci NOT NULL,
     192  PRIMARY KEY  (`Id`)
     193) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=57 ;
     194
     195-- --------------------------------------------------------
     196
     197--
     198-- Struktura tabulky `User`
     199--
     200
     201CREATE TABLE IF NOT EXISTS `User` (
     202  `Id` int(11) NOT NULL auto_increment,
     203  `ItemId` int(11) NOT NULL,
     204  `Author` int(11) NOT NULL,
     205  `ValidTimeFrom` datetime default NULL,
     206  `ValidTimeTo` datetime default NULL,
     207  `CreationTime` datetime default NULL,
     208  `DeletionTime` datetime default NULL,
     209  `UserName` varchar(255) collate utf8_czech_ci NOT NULL,
     210  `Password` varchar(255) collate utf8_czech_ci NOT NULL,
     211  `FirstName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
     212  `SecondName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
     213  `Email` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
     214  `ICQ` int(11) NOT NULL,
     215  `Sex` int(11) NOT NULL default '0',
     216  `BirthDay` date NOT NULL,
     217  `Phone` varchar(255) collate utf8_czech_ci NOT NULL,
     218  `Member` int(11) NOT NULL,
     219  `RegistrationTime` datetime NOT NULL,
     220  `LastLoginTime` datetime NOT NULL,
     221  `Locked` tinyint(1) NOT NULL,
     222  `LastIpAddress` varchar(255) collate utf8_czech_ci NOT NULL,
     223  `PermissionGroup` int(11) NOT NULL,
     224  PRIMARY KEY  (`Id`)
     225) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=36 ;
     226
     227-- --------------------------------------------------------
     228
     229--
     230-- Struktura tabulky `UserOnline`
     231--
     232
     233CREATE TABLE IF NOT EXISTS `UserOnline` (
     234  `User` int(11) NOT NULL,
     235  `LoginTime` datetime NOT NULL,
     236  `ActivityTime` datetime NOT NULL,
     237  `SessionId` varchar(255) collate utf8_czech_ci NOT NULL,
     238  `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL,
     239  `HostName` varchar(255) collate utf8_czech_ci NOT NULL,
     240  `Id` int(11) NOT NULL auto_increment,
     241  `ItemId` int(11) NOT NULL,
     242  `Author` int(11) NOT NULL,
     243  `ValidTimeFrom` datetime default NULL,
     244  `ValidTimeTo` datetime default NULL,
     245  `CreationTime` datetime default NULL,
     246  `DeletionTime` datetime default NULL,
    86247  PRIMARY KEY  (`Id`),
    87   UNIQUE KEY `Name` (`Name`)
    88 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=39 ;
     248  KEY `User` (`User`)
     249) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=28 ;
  • types/GPS.php

    r17 r18  
    2020  global $Database;
    2121
    22   $DbResult = $Database->query('SELECT * FROM `SystemGPS` WHERE `Id`='.$Item['Value']);
    23   if($DbResult->num_rows > 0)
     22  if($Item['Value'] != '')
    2423  {
    25     $DbRow = $DbResult->fetch_assoc();
     24    $DbResult = $Database->query('SELECT * FROM `SystemGPS` WHERE `Id`='.$Item['Value']);
     25    if($DbResult->num_rows > 0)
     26    {
     27      $DbRow = $DbResult->fetch_assoc();
     28    } else $DbRow = array('Longitude' => 0, 'Latitude' => 0);
    2629  } else $DbRow = array('Longitude' => 0, 'Latitude' => 0);
    2730  $Value = TypeGPSExplode($DbRow['Latitude']);
  • types/Password.php

    r11 r18  
    11<?php
     2
     3// SHA1 hash used
    24
    35function TypePasswordOnView($Item)
    46{
    57  $Output = '';
    6   for($I = 0; $I < strlen($Item['Value']); $I++)
     8  for($I = 0; $I < 6; $I++)
    79    $Output .= '*';
    810  return($Output);
     
    1113function TypePasswordOnEdit($Item)
    1214{
    13   $Output = '<input type="password" name="'.$Item['Name'].'" value="'.$Item['Value'].'">';
     15  $Output = '<input type="password" name="'.$Item['Name'].'" value="">';
    1416  return($Output);
    1517}
     
    1719function TypePasswordOnLoad($Item)
    1820{
    19   return($_POST[$Item['Name']]);
     21  global $Database;
     22
     23  if(!array_key_exists('SourceItemId', $Item)) $Result = sha1($_POST[$Item['Name']]);
     24  else
     25  {
     26    $DbRestult = $Database->query('SELECT '.$Item['Name'].' FROM '.$Item['SourceTable'].' WHERE Id='.$Item['SourceItemId']);
     27    if($DbResult->num_rows > 0)
     28    {
     29      $DbRow = $DbResult->fetch_assoc();
     30      if($_POST[$Item['Name']] == '') $Result = $DbRow[$Item['Name']];
     31      else $Result = sha1($_POST[$Item['Name']]);
     32    } else $Result = sha1($_POST[$Item['Name']]);
     33  }
     34  return($Result);
    2035}
    2136
  • types/PointerOneToOne.php

    r15 r18  
    3434  if($DbResult->num_rows > 0)
    3535  {
    36     $Result = array();
     36    $Result = array(array('Name' => 'Žádný', 'Id' => 0, 'ItemId' => 0));
    3737    while($DbRow = $DbResult->fetch_assoc())
    3838      $Result[] = $DbRow;
  • user.php

    r15 r18  
    4141    $SID = session_id();
    4242    // Lookup user record
    43     $Query = $this->Database->select($this->TableUserOnline, '*', 'SessionId="'.$SID.'"');
     43    $Query = $this->Database->select($this->TableUserOnline, '*', '`SessionId`="'.$SID.'"');
    4444    if($Query->num_rows > 0)
    4545    {
    4646      // Refresh time of last access
    47       $this->Database->update($this->TableUserOnline, 'SessionId="'.$SID.'"', array('ActivityTime' => 'NOW()'));
     47      $this->Database->update($this->TableUserOnline, '`SessionId`="'.$SID.'"', array('ActivityTime' => 'NOW()'));
    4848    } else $this->Database->insert($this->TableUserOnline, array('SessionId' => $SID, 'User' => 0, 'LoginTime' => 'NOW()', 'ActivityTime' => 'NOW()', 'IpAddress' => GetRemoteAddress(), 'HostName' => gethostbyaddr(GetRemoteAddress())));
    4949    //echo($this->Database->LastQuery);
     
    5454    if($Row['User'] != 0)
    5555    {
    56       $Query = $this->Database->select($this->TableUser, '*', "Id=".$Row['User']."");
    57       $this->User = $Query->fetch_array();
     56      $Query = $this->Database->query('SELECT * FROM `'.$this->TableUser.'` WHERE `ItemId`='.$Row['User'].' ORDER BY `Id` DESC LIMIT 1');
     57      $this->User = $Query->fetch_assoc();
     58      //print_r($this->User);
    5859      $Result = USER_LOGGED;
    59     } else 
    60     {
    61       $Query = $this->Database->select($this->TableUser, '*', "Id=0");
    62       $this->User = $Query->fetch_array();
     60    } else
     61    {
     62      $Query = $this->Database->select($this->TableUser, '*', "`ItemId`=0");
     63      $this->User = $Query->fetch_assoc();
    6364      $Result = USER_NOT_LOGGED;
    6465    }
    6566
    6667    // Odeber neaktivní uživatele
    67     $DbResult = $this->Database->select($this->TableUserOnline, 'User', 'ActivityTime < DATE_SUB(NOW(), INTERVAL '.USER_TIMEOUT.' SECOND)');
    68     while($DbRow = $DbResult->fetch_array())
    69     {
    70       $this->Database->delete($this->TableUserOnline, 'User='.$DbRow['User']);
     68    $DbResult = $this->Database->select($this->TableUserOnline, 'User', '`ActivityTime` < DATE_SUB(NOW(), INTERVAL '.USER_TIMEOUT.' SECOND)');
     69    while($DbRow = $DbResult->fetch_assoc())
     70    {
     71      $this->Database->delete($this->TableUserOnline, '`User`='.$DbRow['User']);
    7172      //$this->System->Modules['Log']->Add('User', 'Logout');
    7273    }
     
    9495        else
    9596        {
    96           $this->Database->insert($this->TableUser, array('Name' => $Nick, 'FirstName' => $FirstName, 'SecondName' => $SecondName, 'Password' => sha1($Password), 'Email' => $Email, 'RegistrationTime' => 'NOW()', 'Locked' => 1));
     97          $this->Database->insert($this->TableUser, array('Name' => $Nick, 'FirstName' => $FirstName, 'SecondName' => $SecondName, 'Password' => $Password, 'Email' => $Email, 'RegistrationTime' => 'NOW()', 'Locked' => 1));
    9798          $UserId = $this->Database->insert_id;
    9899
    99100          $Subject = FromUTF8('Registrace nového účtu', 'iso2');
    100           $Message = 'Provedli jste registraci nového účtu na serveru <a href="http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'">http://'.$Config['Web']['Host'].$Config['Web']['RootFolder']."</a>.<br>\nPokud jste tak neučinili, měli by jste tento email ignorovat.<br><br>\n\nVáš účet je: ".$Nick."\n<br>Pro dokončení registrace klikněte na ".'<a href="http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'/?Action=UserRegisterConfirm&amp;User='.$UserId.'&amp;H='.sha1($Password).'">tento odkaz</a>.'."\n<br> \n\n<br><br>Na tento email neodpovídejte.";
     101          $Message = 'Provedli jste registraci nového účtu na serveru <a href="http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'">http://'.$Config['Web']['Host'].$Config['Web']['RootFolder']."</a>.<br>\nPokud jste tak neučinili, měli by jste tento email ignorovat.<br><br>\n\nVáš účet je: ".$Nick."\n<br>Pro dokončení registrace klikněte na ".'<a href="http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'/?Action=UserRegisterConfirm&amp;User='.$UserId.'&amp;H='.$Password.'">tento odkaz</a>.'."\n<br> \n\n<br><br>Na tento email neodpovídejte.";
    101102          $AdditionalHeaders = "To: ".$Nick." <".$Email.">\n"."From: ".FromUTF8($Config['Web']['Title'], 'iso2')." <noreplay@zdechov.net>\n"."MIME-Version: 1.0\n"."Content-type: text/html; charset=utf-8";
    102103          mail($Email, $Subject, $Message, $AdditionalHeaders);
     
    133134    {
    134135      $Row = $Query->fetch_array();
    135       if($Row['Password'] != sha1($Password)) $Result = BAD_PASSWORD;
     136      if($Row['Password'] != $Password) $Result = BAD_PASSWORD;
    136137      else if($Row['Locked'] == 1) $Result = ACCOUNT_LOCKED;
    137       else 
     138      else
    138139      {
    139140        $this->Database->update($this->TableUser, 'Id='.$Row['Id'], array('LastLoginTime' => 'NOW()'));
    140         $this->Database->update($this->TableUserOnline, 'SessionId="'.$SID.'"', array('User' => $Row['Id']));
     141        $this->Database->update($this->TableUserOnline, 'SessionId="'.$SID.'"', array('User' => $Row['ItemId'], 'ItemId' => $Row['ItemId']));
    141142        // načtení stavu stromu
    142143        $Result = USER_LOGGED_IN;
     
    188189      if(($NewPassword == $NewPassword2) and ($Hash == $Row['Password']))
    189190      {
    190         $this->Database->update($this->TableUser, 'Id='.$Row['Id'], array('Password' => sha1($NewPassword), 'Locked' => 0));
     191        $this->Database->update($this->TableUser, 'Id='.$Row['Id'], array('Password' => $NewPassword, 'Locked' => 0));
    191192        $Output = USER_PASSWORD_RECOVERY_CONFIRMED;
    192193        //$this->System->Modules['Log']->NewRecord('User', 'PasswordRecoveryConfirm', 'UserName='.$Row['Name']);
Note: See TracChangeset for help on using the changeset viewer.