Changeset 11


Ignore:
Timestamp:
Oct 13, 2008, 8:05:21 AM (16 years ago)
Author:
george
Message:
  • Opraveno: Mazání položek nyní položku neodstraňuje z databáze, ale pouze ji označí za smazanou. Sloupce DeletionTime se nastaví na aktuální čas a položka nadále nebude zobrazována ve výpisech.
  • Opraveno: Načítání položek formuláře nyní prováděno přes událost OnLoad pro každý typ samostatně. Tímto také opraveno načítání hodnoty typu Boolean(checkbox) a Date(comboboxy datumu).
  • Opraveno: Správné zpracování typů nejenom podle id, ale také podle jména.
Files:
17 edited

Legend:

Unmodified
Added
Removed

  • base.php

    r10 r11  
    3232  $Output .= '<th>Akce</th></tr>';
    3333
    34   $Where = '';
     34  $Where = ' AND (t1.DeletionTime IS NULL)';
    3535
    3636  if(($Column != '') and ($ColumnValue != 0))
    … …  
    6969  $TotalItemCount = $DbRow[0];
    7070
    71   $DbResult = $Database->query('SELECT t1.* FROM `'.$List['TableName'].'` AS t1 LEFT JOIN `'.$List['TableName'].'` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE t2.ItemId IS NULL'.$Where.' LIMIT '.($Page * $Config['Web']['ItemsPerPage']).', '.$Config['Web']['ItemsPerPage']);
     71  $DbResult = $Database->query('SELECT t1.* FROM `'.$List['TableName'].'` AS t1 LEFT JOIN `'.$List['TableName'].'` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL)'.$Where.' LIMIT '.($Page * $Config['Web']['ItemsPerPage']).', '.$Config['Web']['ItemsPerPage']);
    7272  //echo($Database->LastQuery.'<br>');
    7373  while($DbRow = $DbResult->fetch_array())
    … …  
    199199  global $Database, $Types, $System;
    200200
    201   $Values = array();
    202   foreach($List['Items'] as $Index => $Item)
    203   {
    204     if($Types[$Item['Type']]['BaseType'] != 'PointerOneToMany')
    205     {
    206       $Values[$Index] = $_POST[$Index];
    207     }
    208   }
     201  $DbResult = $Database->select($List['TableName'], '*', 'Id='.$Id);
     202  while($DbRow = $DbResult->fetch_array())
     203  {
     204    $DefinitionItems = array();
     205    foreach($List['Items'] as $Index => $Item)
     206    {
     207      if($Types[$Item['Type']]['BaseType'] != 'PointerOneToMany')
     208      {
     209        $DefinitionItems[] = array('Name' => $Index, 'Caption' => $Item['TextBefore'].$Required, 'Value' => $DbRow[$Index], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
     210      }
     211    }
     212  }
     213  $Form = new Form();
     214  $Form->Definition = array
     215  (
     216    'Title' => 'Titulek',
     217    'SubmitBuffonText' => 'Uložit',
     218    'Items' => $DefinitionItems,
     219  );
     220  $Form->LoadValuesFromForm();
     221
    209222  $DbResult = $Database->select($List['TableName'], 'ItemId', 'Id='.$Id);
    210223  $DbRow = $DbResult->fetch_assoc();
    211   $Values['ItemId'] = $DbRow['ItemId'];
    212   $Values['Author'] = $System->Modules['User']->User['Id'];
    213   $Values['CreationTime'] = 'NOW()';
    214   $Values['ValidTimeFrom'] = 'NOW()';
    215   $Database->insert($List['TableName'], $Values);
     224  $Form->Values['ItemId'] = $DbRow['ItemId'];
     225  $Form->Values['Author'] = $System->Modules['User']->User['Id'];
     226  $Form->Values['CreationTime'] = 'NOW()';
     227  $Form->Values['ValidTimeFrom'] = 'NOW()';
     228  $Database->insert($List['TableName'], $Form->Values);
    216229  //echo($Database->LastQuery);
    217230  $Output = 'Změny uloženy.';
    218   $Output .= ShowViewItem($List, $Id);
     231  $Output .= ShowViewItem($List, $Database->insert_id);
     232  $Form->Values['Column'] = $_POST['Column'];
     233  ExecuteListEvent($List['TableName'], 'OnEdit', $Form->Values);
    219234  return($Output);
    220235}
    … …  
    264279  global $Database, $Types, $System;
    265280
    266   $Values = array();
    267   foreach($List['Items'] as $Index => $Item)
    268   {
    269     if($Types[$Item['Type']]['BaseType'] != 'PointerOneToMany')
    270     {
    271       $Values[$Index] = $_POST[$Index];
    272     }
    273   }
    274   $Values['Author'] = $System->Modules['User']->User['Id'];
    275   $Values['CreationTime'] = 'NOW()';
    276   $Values['ValidTimeFrom'] = 'NOW()';
     281  $DefinitionItems = array();
     282  $AfterTableOutput = '';
     283  foreach($List['Items'] as $Item)
     284  {
     285    //echo($Item['Name'].',');
     286    if(($Types[$Item['Type']]['BaseType'] != 'PointerOneToMany') and ($Item['Name'] != $Column))
     287    {
     288      if($Item['Required'] == 1) $Required = '*'; else $Required = '';
     289      $DefinitionItems[] = array('Name' => $Item['Name'], 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => '', 'SourceTable' => $List['TableName'], 'SourceItemId' => 0);
     290    } else
     291    if($Item['Name'] == $Column)
     292    {
     293      $DefinitionItems[] = array('Name' => $Column, 'Type' => 'Hidden', 'Caption' => '', 'Value' => $ColumnValue);
     294    }
     295  }
     296  $DefinitionItems[] = array('Name' => 'Column', 'Type' => 'Hidden', 'Caption' => '', 'Value' => $Column);
     297
     298  $Form = new Form();
     299  $Form->Definition = array
     300  (
     301    'Title' => 'Titulek',
     302    'SubmitBuffonText' => 'Přidat',
     303    'Items' => $DefinitionItems,
     304  );
     305  $Form->LoadValuesFromForm();
     306  $Form->Values['Author'] = $System->Modules['User']->User['Id'];
     307  $Form->Values['CreationTime'] = 'NOW()';
     308  $Form->Values['ValidTimeFrom'] = 'NOW()';
    277309  $DbResult = $Database->select($List['TableName'], 'MAX(ItemId)');
    278310  $DbRow = $DbResult->fetch_row();
    279311  $AutoincrementId = $DbRow[0];
    280   $Values['ItemId'] = $AutoincrementId + 1;
    281   $Database->insert($List['TableName'], $Values);
     312  $Form->Values['ItemId'] = $AutoincrementId + 1;
     313  $Database->insert($List['TableName'], $Form->Values);
    282314  //echo($Database->LastQuery);
    283315  $Output = 'Položka přidána';
    284316  $Output .= ShowViewItem($List, $Database->insert_id);
    285   $Values['Column'] = $_POST['Column'];
    286   ExecuteListEvent($List['TableName'], 'OnAdd', $Values);
     317  $Form->Values['Column'] = $_POST['Column'];
     318  ExecuteListEvent($List['TableName'], 'OnAdd', $Form->Values);
    287319  return($Output);
    288320}
    … …  
    336368function ShowDeleteItem($List, $Id)
    337369{
    338   global $Database;
    339 
    340   $Database->delete($List['TableName'], 'Id='.$Id);
     370  global $Database, $Lists;
     371
     372  $Database->update($List['TableName'], 'Id='.$Id, array('DeletionTime' => 'NOW()'));
    341373  $Output = 'Položka smazána.';
     374  $Output .= ShowList($Lists[$_SESSION['Table']], $Lists[$_SESSION['Column']], $Lists[$_SESSION['ColumnValue']]).'<br /><br />';
    342375  return($Output);
    343376}
    … …  
    431464function LoadTypeDefinition()
    432465{
    433   global $Database, $Types;
     466  global $Database, $Types, $TypeNames;
    434467
    435468  $Types = array();
     469  $TypeNames = array();
    436470  $DbResult = $Database->select('SystemType', '*');
    437471  while($DbRow = $DbResult->fetch_assoc())
    … …  
    440474    $DbRow['BaseType'] = $DbRow['Name'];
    441475    $Types[$DbRow['Id']] = $DbRow;
     476    $TypeNames[$DbRow['Name']] = $DbRow['Id'];
    442477  }
    443478
    … …  
    474509}
    475510
     511function ModifyAllTables($Query)
     512{
     513  global $Database;
     514
     515  $DbResult = $Database->select('SystemList', '*');
     516  while($DbRow = $DbResult->fetch_assoc())
     517  {
     518    $Database->query($Query);
     519  }
     520}
     521
    476522?>

  • forms.php

    r10 r11  
    99  var $OnSubmit = '';
    1010
     11  function DefinitionTextTypeToNumericType()
     12  {
     13    global $TypeNames;
     14
     15    foreach($this->Definition['Items'] as $Index => $Definition)
     16      if(!is_numeric($Definition['Type'])) $this->Definition['Items'][$Index]['Type'] = $TypeNames[$Definition['Type']];
     17  }
     18
    1119  function ShowEditForm()
    1220  {
     21    $this->DefinitionTextTypeToNumericType();
    1322    $Output = '<center><form action="'.$this->OnSubmit.'" method="post"><div align="center">';
    1423    $Table = $this->ShowEditBlock();
    … …  
    5867  function ShowReadOnlyForm()
    5968  {
     69    $this->DefinitionTextTypeToNumericType();
     70
    6071    $Output = '<center><div align="center">';
    6172    $Table = $this->ShowReadOnlyBlock();
    … …  
    90101    foreach($this->Definition['Items'] as $Item)
    91102    {
    92       $Index = $Item['Name'];
    93       $this->Values[$Index] = $DbRow[$Index];
     103      $this->Values[$Item['Name']] = $DbRow[$Item['Name']];
    94104      switch($Item['Type'])
    95105      {
    96106        case 'Password':
    97           if($Item['Type'] == 'Password') $this->Values[$Index] = '';  // Dont show password
     107          if($Item['Type'] == 'Password') $this->Values[$Item['Name']] = '';  // Dont show password
    98108          break;
    99109        case 'Time':
    100           $this->Values[$Index] == MysqlDateTimeToTime($this->Values[$Index]);
     110          $this->Values[$Index] == MysqlDateTimeToTime($this->Values[$Item['Name']]);
    101111          break;
    102112      }
    … …  
    110120    foreach($this->Definition['Items'] as $Item)
    111121    {
    112       $Index = $Item['Name'];
    113122      switch($Item['Type'])
    114123      {
    115124        case 'Password':
    116           if($this->Values[$Index] == '') unset($this->Values[$Index]); // Do not modify empty passwords
    117           else $this->Values[$Index] = sha1($this->Values[$Index]);
     125          if($this->Values[$Item['Name']] == '') unset($this->Values[$Item['Name']]); // Do not modify empty passwords
     126          else $this->Values[$Item['Name']] = sha1($this->Values[$Item['Name']]);
    118127          break;
    119128        case 'Time':
    120           $this->Values[$Index] = TimeToMysqlDateTime($this->Values[$Index]);
     129          $this->Values[$Item['Name']] = TimeToMysqlDateTime($this->Values[$Item['Name']]);
    121130          break;
    122131      }
    … …  
    129138  function LoadValuesFromForm()
    130139  {
     140    $this->DefinitionTextTypeToNumericType();
    131141    $this->Values = $this->LoadValuesFromFormBlock();
    132142  }
    … …  
    136146    global $FormTypes;
    137147
    138     if($Context != '') $Context = $Context.'-';
    139148    $Values = array();
    140     foreach($this->Definition['Items'] as $Item)
     149    foreach($this->Definition['Items'] as $Index => $Item)
    141150    {
    142       $Index = $Item['Name'];
    143       switch($Item['Type'])
    144       {
    145         case 'Boolean':
    146           if(array_key_exists($Context.$Index, $_POST)) $Values[$Index] = 1;
    147           else $Values[$Index] = 0;
    148           break;
    149         case 'String':
    150           $Values[$Index] = $_POST[$Context.$Index];
    151           break;
    152         case 'Password':
    153           $Values[$Index] = $_POST[$Context.$Index];
    154           break;
    155         case 'Integer':
    156           $Values[$Index] = $_POST[$Context.$Index];
    157           break;
    158         case 'Float':
    159           $Values[$Index] = $_POST[$Context.$Index];
    160           break;
    161         case 'Time':
    162           $Values[$Index] = explode('.', $_POST[$Context.$Index]);
    163           $Values[$Index] = mktime(0, 0, 0, $Values[$Index][1], $Values[$Index][0], $Values[$Index][2]);
    164           break;
    165         case 'Array':
    166           $I = 1;
    167           //echo('Expect: '.$Context.$Item['ItemClass'].'-'.$I.'<br>');
    168           while(isset($_POST[$Context.$Item['ItemClass'].'-'.$I]))
    169           {
    170             $Form  = new Form($Item['ItemClass']);
    171             $Values[$Index][] = $Form->LoadValuesFromFormBlock($Context.$Item['ItemClass'].'-'.$I);
    172             $I++;
    173           }
    174           break;
    175         default:
    176           if(array_key_exists($Item['Type'], $FormTypes))
    177           {
    178             // Custom types
    179             switch($FormTypes[$Item['Type']]['Type'])
    180             {
    181               case 'Enumeration':
    182                 $Values[$Index] = $_POST[$Context.$Index];
    183                 break;
    184               case 'Reference':
    185                 $Values[$Index] = $_POST[$Context.$Index];
    186                 break;
    187               default:
    188             }
    189           }
    190       }
     151      $Values[$Item['Name']] = ExecuteTypeEvent($Item['Type'], 'OnLoad', $Item);
    191152    }
     153    //print_r($this->Values);
    192154    return($Values);
    193155  }

  • lists/SystemList.php

    r10 r11  
    99  `ItemId` int(11) NOT NULL,
    1010  `Author` int(11) NOT NULL,
    11   `ValidTimeFrom` datetime NOT NULL,
    12   `ValidTimeTo` datetime NOT NULL,
    13   `CreationTime` datetime NOT NULL,
     11  `ValidTimeFrom` datetime default NULL,
     12  `ValidTimeTo` datetime default NULL,
     13  `CreationTime` datetime default NULL,
     14  `DeletionTime` datetime default NULL,
    1415  PRIMARY KEY  (`Id`)
    1516  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');

  • sql/demo_database.sql

    r10 r11  
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Neděle 12. října 2008, 20:37
     6-- Vygenerováno: Pondělí 13. října 2008, 08:00
    77-- Verze MySQL: 5.0.51
    88-- Verze PHP: 5.2.6
    … …  
    2626  `ValidTimeFrom` datetime default NULL,
    2727  `ValidTimeTo` datetime default NULL,
    28   `CreationTime` datetime NOT NULL,
     28  `CreationTime` datetime default NULL,
     29  `DeletionTime` datetime default NULL,
    2930  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    3031  `NetworkIPAddress` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    4445--
    4546
    46 INSERT INTO `Area` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `NetworkIPAddress`, `IPAddressMask`, `DNSPrimary`, `DNSSecondary`, `DHCP`, `Domain`, `Workgroup`, `WINS`, `HostList`) VALUES
    47 (1, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Bytovky dolní konec', '192.168.12.0', '255.255.255.0', '192.168.0.22', '46.33.1.2', '192.168.12.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
    48 (2, 3, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Centrum Komořany', '192.168.10.0', '255.255.255.0', '192.168.0.22', '', '192.168.10.1', 'centrum.freenet.cz', 'CENTRUM', '192.168.0.23', 0),
    49 (3, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Serverovna', '192.168.0.0', '255.255.255.0', '192.168.0.22', '44.55.22.34', '19ě.168.0.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
    50 (4, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Kůlna', '10.198.0.0', '255.255.0.0', '192.168.0.1', '129.168.0.22', '10.198.0.1', 'kulna.freenet.cz', 'KULNA', '192.168.0.23', 0),
    51 (5, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:02:11', 'ss', 'ss', 'ss', '', '', '', '', '', '', 0),
    52 (6, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:04:59', 'kk', '', '', '', '', '', '', '', '', 0),
    53 (7, 2, 0, '2008-10-09 14:09:48', NULL, '2008-10-09 14:09:48', 'kk', 'sss', '', '', '', '', '', '', '', 0),
    54 (8, 2, 5, '2008-10-09 14:43:13', NULL, '2008-10-09 14:43:13', 'Ahoj', 'sss', '', '', '', '', '', '', '', 0);
     47INSERT INTO `Area` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `NetworkIPAddress`, `IPAddressMask`, `DNSPrimary`, `DNSSecondary`, `DHCP`, `Domain`, `Workgroup`, `WINS`, `HostList`) VALUES
     48(1, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Bytovky dolní konec', '192.168.12.0', '255.255.255.0', '192.168.0.22', '46.33.1.2', '192.168.12.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
     49(2, 3, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Centrum Komořany', '192.168.10.0', '255.255.255.0', '192.168.0.22', '', '192.168.10.1', 'centrum.freenet.cz', 'CENTRUM', '192.168.0.23', 0),
     50(3, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Serverovna', '192.168.0.0', '255.255.255.0', '192.168.0.22', '44.55.22.34', '19ě.168.0.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
     51(4, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Kůlna', '10.198.0.0', '255.255.0.0', '192.168.0.1', '129.168.0.22', '10.198.0.1', 'kulna.freenet.cz', 'KULNA', '192.168.0.23', 0),
     52(5, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:02:11', '2008-10-13 07:59:09', 'ss', 'ss', 'ss', '', '', '', '', '', '', 0),
     53(6, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:04:59', NULL, 'kk', '', '', '', '', '', '', '', '', 0),
     54(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);
    5556
    5657-- --------------------------------------------------------
    … …  
    6465  `ItemId` int(11) NOT NULL,
    6566  `Author` int(11) NOT NULL,
    66   `ValidTimeFrom` datetime NOT NULL,
    67   `ValidTimeTo` datetime NOT NULL,
    68   `CreationTime` datetime NOT NULL,
     67  `ValidTimeFrom` datetime default NULL,
     68  `ValidTimeTo` datetime default NULL,
     69  `CreationTime` datetime default NULL,
     70  `DeletionTime` datetime default NULL,
    6971  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    7072  `TimeEnlistment` datetime NOT NULL,
    … …  
    8183--
    8284
    83 INSERT INTO `Asset` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `TimeEnlistment`, `TimeElimination`, `Price`, `State`, `SerialNumber`, `PurcheasedFrom`) VALUES
    84 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Ovislink WL-1120AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 563, 2, 'WL1120AP111353', 2),
    85 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Routerboard RB-433', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3200, 1, 'RB433-3366264', 9),
    86 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Ovislink WL-5460AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 800, 3, 'WL5460A-4372-333362', 9),
    87 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'StraightCore WRT-312', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1110, 0, 'SC-WRT312-112', 7),
    88 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UTP kabel 100 m', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '', 7),
    89 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Anténa UNIMAX 12 dBi 2,4 GHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '4234234234', 7),
    90 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UTP kabel Belden CAT-5 305 m ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1766, 1, '', 9),
    91 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Paměť DDR2 2 GB 800 MHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 734, 2, 'DDR2422622a', 9),
    92 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Všesměrová anténa Omni 10 dBi', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1043, 2, 'OMNI123533', 9),
    93 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Notebook Asus EEE PC 901', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 6232, 2, 'ASUSEEE901-2414aa53', 9),
    94 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '10x UTP konektory drát', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 30, 1, '', 9),
    95 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Edimax gigabit switch 8-port', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 750, 2, 'EDW8-423423-333', 9),
    96 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'VoIP adaptér Zyxel VO-112', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1342, 2, 'ZXS422Z33', 9),
    97 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IP kamera Vivotek IP-224', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3744, 2, 'VOWW623335', 9);
     85INSERT INTO `Asset` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `TimeEnlistment`, `TimeElimination`, `Price`, `State`, `SerialNumber`, `PurcheasedFrom`) VALUES
     86(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Ovislink WL-1120AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 563, 2, 'WL1120AP111353', 2),
     87(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Routerboard RB-433', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3200, 1, 'RB433-3366264', 9),
     88(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Ovislink WL-5460AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 800, 3, 'WL5460A-4372-333362', 9),
     89(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'StraightCore WRT-312', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1110, 0, 'SC-WRT312-112', 7),
     90(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UTP kabel 100 m', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '', 7),
     91(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Anténa UNIMAX 12 dBi 2,4 GHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '4234234234', 7),
     92(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UTP kabel Belden CAT-5 305 m ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1766, 1, '', 9),
     93(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Paměť DDR2 2 GB 800 MHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 734, 2, 'DDR2422622a', 9),
     94(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Všesměrová anténa Omni 10 dBi', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1043, 2, 'OMNI123533', 9),
     95(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Notebook Asus EEE PC 901', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 6232, 2, 'ASUSEEE901-2414aa53', 9),
     96(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '10x UTP konektory drát', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 30, 1, '', 9),
     97(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),
     98(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);
    98100
    99101-- --------------------------------------------------------
    … …  
    107109  `ItemId` int(11) NOT NULL,
    108110  `Author` int(11) NOT NULL,
    109   `ValidTimeFrom` datetime NOT NULL,
    110   `ValidTimeTo` datetime NOT NULL,
    111   `CreationTime` datetime NOT NULL,
     111  `ValidTimeFrom` datetime default NULL,
     112  `ValidTimeTo` datetime default NULL,
     113  `CreationTime` datetime default NULL,
     114  `DeletionTime` datetime default NULL,
    112115  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    113116  `BankName` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    123126--
    124127
    125 INSERT INTO `BankAccount` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `BankName`, `Number`, `BankCode`, `Type`, `User`) VALUES
    126 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Hlavní účet', 'Poštovní spořitelna', '22653446', '0200', 1, 1),
    127 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Vedlejší účet', 'Komerční banka', '5543332', '0400', 2, 2),
    128 (3, 3, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Pomocný - vedení zdarma', 'Mbank', '24522266', '0156', 1, 2);
     128INSERT INTO `BankAccount` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `BankName`, `Number`, `BankCode`, `Type`, `User`) VALUES
     129(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Hlavní účet', 'Poštovní spořitelna', '22653446', '0200', 1, 1),
     130(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),
     131(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);
    129132
    130133-- --------------------------------------------------------
    … …  
    138141  `ItemId` int(11) NOT NULL,
    139142  `Author` int(11) NOT NULL,
    140   `ValidTimeFrom` datetime NOT NULL,
    141   `ValidTimeTo` datetime NOT NULL,
    142   `CreationTime` datetime NOT NULL,
     143  `ValidTimeFrom` datetime default NULL,
     144  `ValidTimeTo` datetime default NULL,
     145  `CreationTime` datetime default NULL,
     146  `DeletionTime` datetime default NULL,
    143147  `Description` varchar(255) collate utf8_czech_ci NOT NULL,
    144148  `Amount` float NOT NULL,
    … …  
    155159--
    156160
    157 INSERT INTO `FinanceTransaction` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Description`, `Amount`, `SourceSubject`, `TargetSubject`, `Time`, `Type`, `InsertedByUser`) VALUES
    158 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 2 Mbit 2008/05', 360, 2, 11, '0000-00-00 00:00:00', 0, 1),
    159 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Zřízení přípojky', 4300, 10, 11, '0000-00-00 00:00:00', 1, 11),
    160 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 8 Mbit 2008/05', 750, 8, 11, '0000-00-00 00:00:00', 0, 11),
    161 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Vrácení přeplatku', 231, 11, 8, '0000-00-00 00:00:00', 0, 11);
     161INSERT 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);
    162166
    163167-- --------------------------------------------------------
    … …  
    171175  `ItemId` int(11) NOT NULL,
    172176  `Author` int(11) NOT NULL,
    173   `ValidTimeFrom` datetime NOT NULL,
    174   `ValidTimeTo` datetime NOT NULL,
    175   `CreationTime` datetime NOT NULL,
     177  `ValidTimeFrom` datetime default NULL,
     178  `ValidTimeTo` datetime default NULL,
     179  `CreationTime` datetime default NULL,
     180  `DeletionTime` datetime default NULL,
    176181  `DomainName` varchar(225) character set latin1 NOT NULL,
    177182  `NetBIOSName` varchar(255) character set latin1 NOT NULL,
    … …  
    191196--
    192197
    193 INSERT INTO `Host` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`) VALUES
    194 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'george', 'GEORGE', '192.168.0.23', '', '0000-00-00', 1, 0, 4, 0, 0),
    195 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0),
    196 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'telefon', 'TELEFON', '192.168.1.45', '', '0000-00-00', 2, 0, 4, 1, 2),
    197 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'router-inet', 'ROUTER-INET', '192.168.0.2', '77.33.55.12', '0000-00-00', 4, 0, 1, 1, 4),
    198 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'muhehe', 'MUHEHE', '192.168.0.4', '', '0000-00-00', 1, 0, 1, 1, 2),
    199 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'jonny', 'JONNY', '192.168.0.6', '', '0000-00-00', 1, 0, 1, 1, 1),
    200 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '0000-00-00', 6, 0, 0, 0, 0),
    201 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'www', 'WWW', '192.168.0.7', '34.22.1.4', '0000-00-00', 5, 0, 0, 0, 0),
    202 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'peklo', 'PEKLO', '192.168.66.66', '', '0000-00-00', 7, 0, 4, 2, 0);
     198INSERT 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);
    203208
    204209-- --------------------------------------------------------
    … …  
    212217  `ItemId` int(11) NOT NULL,
    213218  `Author` int(11) NOT NULL,
    214   `ValidTimeFrom` datetime NOT NULL,
    215   `ValidTimeTo` datetime NOT NULL,
    216   `CreationTime` datetime NOT NULL,
     219  `ValidTimeFrom` datetime default NULL,
     220  `ValidTimeTo` datetime default NULL,
     221  `CreationTime` datetime default NULL,
     222  `DeletionTime` datetime default NULL,
    217223  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    218224  `Type` int(11) NOT NULL,
    … …  
    227233--
    228234
    229 INSERT INTO `Interface` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `Type`, `Area`, `Host`, `MAC`) VALUES
    230 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Kabel', 2, 0, 1, '00:00:00:00:00:00'),
    231 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F'),
    232 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Bezdrát', 0, 0, 5, '00:00:00:A5:53:26'),
    233 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'eth0', 2, 0, 6, '45:00:12:54:FE:C2');
     235INSERT 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');
    234240
    235241-- --------------------------------------------------------
    … …  
    246252  `ValidTimeTo` datetime NOT NULL,
    247253  `CreationTime` datetime NOT NULL,
     254  `DeletionTime` datetime NOT NULL,
    248255  `Subject` int(11) NOT NULL,
    249256  `ResponsibleUser` int(11) NOT NULL,
    … …  
    263270--
    264271
    265 INSERT INTO `Member` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Subject`, `ResponsibleUser`, `MapPositionX`, `MapPositionY`, `FamilyMemberCount`, `MembershipDate`, `MemberState`, `HostList`, `Tariff`, `UserList`) VALUES
    266 (1, 1, 5, '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),
    267 (2, 2, 5, '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),
    268 (3, 3, 5, '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),
    269 (4, 4, 5, '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),
    270 (5, 5, 5, '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),
    271 (6, 6, 5, '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);
     272INSERT 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);
    272279
    273280-- --------------------------------------------------------
    … …  
    284291  `ValidTimeTo` datetime NOT NULL,
    285292  `CreationTime` datetime NOT NULL,
     293  `DeletionTime` datetime NOT NULL,
    286294  `Member` int(11) NOT NULL,
    287295  `Text` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    290298  `Creator` int(11) NOT NULL,
    291299  PRIMARY KEY  (`Id`)
    292 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
     300) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=17 ;
    293301
    294302--
    … …  
    296304--
    297305
    298 INSERT INTO `MemberReport` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Member`, `Text`, `Date`, `Type`, `Creator`) VALUES
    299 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Nefunguje mi internet', '0000-00-00', 1, 11),
    300 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Poslední dobu jede internet nějak pomalu. Podívejte se na to prosím.', '0000-00-00', 1, 7),
    301 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Uživatel se přestěhoval mimo dosah sítě', '0000-00-00', 3, 11),
    302 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 4, 'Během bouřky spadl strom na vedení a roztrhl jej. Bylo nutno natáhnout kabel znova.', '0000-00-00', 3, 2),
    303 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 'Nefunguje odesílání pošty.', '0000-00-00', 1, 10),
    304 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Změna tarifu na Internet 2 Mbit', '0000-00-00', 2, 11),
    305 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 'Chce se stát správcem tamního úseku.', '0000-00-00', 3, 11);
     306INSERT INTO `MemberReport` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Member`, `Text`, `Date`, `Type`, `Creator`) VALUES
     307(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', 1, 'Nefunguje mi internet', '0000-00-00', 1, 11),
     308(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', 1, 'Poslední dobu jede internet nějak pomalu. Podívejte se na to prosím.', '0000-00-00', 1, 7),
     309(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', 1, 'Uživatel se přestěhoval mimo dosah sítě', '0000-00-00', 3, 11),
     310(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', 4, 'Během bouřky spadl strom na vedení a roztrhl jej. Bylo nutno natáhnout kabel znova.', '0000-00-00', 3, 2),
     311(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', 2, 'Nefunguje odesílání pošty.', '0000-00-00', 1, 10),
     312(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', 1, 'Změna tarifu na Internet 2 Mbit', '0000-00-00', 2, 11),
     313(7, 7, 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, 'Chce se stát správcem tamního úseku.', '0000-00-00', 3, 11),
     314(16, 1, 5, '2008-10-13 07:22:24', '0000-00-00 00:00:00', '2008-10-13 07:22:24', '0000-00-00 00:00:00', 1, 'Nefunguje mi internet', '2008-10-01', 1, 11),
     315(15, 1, 5, '2008-10-13 07:20:29', '0000-00-00 00:00:00', '2008-10-13 07:20:29', '0000-00-00 00:00:00', 1, 'Nefunguje mi internet, opravte to prosím', '1900-01-01', 0, 11);
    306316
    307317-- --------------------------------------------------------
    … …  
    315325  `ItemId` int(11) NOT NULL,
    316326  `Author` int(11) NOT NULL,
    317   `ValidTimeFrom` datetime NOT NULL,
    318   `ValidTimeTo` datetime NOT NULL,
    319   `CreationTime` datetime NOT NULL,
     327  `ValidTimeFrom` datetime default NULL,
     328  `ValidTimeTo` datetime default NULL,
     329  `CreationTime` datetime default NULL,
     330  `DeletionTime` datetime default NULL,
    320331  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    321332  `AddressStreet` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    336347--
    337348
    338 INSERT INTO `Subject` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `AddressStreet`, `AddressTown`, `AddressZIP`, `IC`, `DIC`, `Notice`, `PurcheasedAsset`, `UserList`, `WWW`, `MemberList`) VALUES
    339 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Ing. Karel Milosrdný', 'Na ústraní 302', 'Otrokovice', '45667', '', '', 'Dodavatel wifi techniky', 0, 0, '', 0),
    340 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Poskytovatel', 'Těsná 23', 'Prachatice', '56678', '33445633', '', '', 0, 0, '', 0),
    341 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Finanční úřad Brno', 'Brněnská 1', 'Brno', '44134', '45773325', 'CZ44337778', '', 0, 0, '', 0),
    342 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'GTS Novera', 'U skládky 9', 'Kladno', '47353', '3216346365', '423432', 'Hlavní dodavatel internetu', 0, 0, 'http://www.gtsnovera.cz', 0),
    343 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'České radiokomunikace', 'Na rozcestí 5', 'Ostrava', '12445', '23132312', 'CZ342342342', 'Záložní linka', 0, 0, '', 0),
    344 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Lucie Dobrovolná', 'Čajkovského 3', 'Pardubice', '73322', '', '', 'Neplatí včas', 0, 0, '', 0),
    345 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Obecní úřad Nové Milošice', 'Nové Milošice 24', 'Nové Milošice', '44222', '31231312312', 'CZ31231231', '', 0, 0, '', 0),
    346 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SOFTCOM', 'Pod vodou 9', 'Praha', '42044', '2323324234234', 'CZ6565622', 'Prodej výpočetní techniky', 0, 0, 'http://www.softcom.cz/', 0),
    347 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Honza Procházka', 'Za bukem 3', 'Chvojkovice', '44332', '', '', '', 0, 0, '', 0),
    348 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Freenet s.r.o.', 'Bezdrátová 11', 'Nové síťovice', '434223', '43423423423', 'CZ42423423', 'Hlavní kontakt na tuto síť', 0, 0, '', 0),
    349 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Fantomas', 'Tajná 10', 'Pod vodou', '11223', '', '', '', 0, 0, '', 0),
    350 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
    351 (14, 14, 5, '2008-10-11 22:38:49', '0000-00-00 00:00:00', '2008-10-11 22:38:49', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
    352 (15, 15, 5, '2008-10-11 22:41:56', '0000-00-00 00:00:00', '2008-10-11 22:41:56', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
    353 (16, 16, 5, '2008-10-11 22:46:30', '0000-00-00 00:00:00', '2008-10-11 22:46:30', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
    354 (17, 17, 5, '2008-10-11 22:47:36', '0000-00-00 00:00:00', '2008-10-11 22:47:36', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0);
     349INSERT INTO `Subject` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `AddressStreet`, `AddressTown`, `AddressZIP`, `IC`, `DIC`, `Notice`, `PurcheasedAsset`, `UserList`, `WWW`, `MemberList`) VALUES
     350(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Ing. Karel Milosrdný', 'Na ústraní 302', 'Otrokovice', '45667', '', '', 'Dodavatel wifi techniky', 0, 0, '', 0),
     351(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Poskytovatel', 'Těsná 23', 'Prachatice', '56678', '33445633', '', '', 0, 0, '', 0),
     352(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Finanční úřad Brno', 'Brněnská 1', 'Brno', '44134', '45773325', 'CZ44337778', '', 0, 0, '', 0),
     353(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'GTS Novera', 'U skládky 9', 'Kladno', '47353', '3216346365', '423432', 'Hlavní dodavatel internetu', 0, 0, 'http://www.gtsnovera.cz', 0),
     354(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'České radiokomunikace', 'Na rozcestí 5', 'Ostrava', '12445', '23132312', 'CZ342342342', 'Záložní linka', 0, 0, '', 0),
     355(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Lucie Dobrovolná', 'Čajkovského 3', 'Pardubice', '73322', '', '', 'Neplatí včas', 0, 0, '', 0),
     356(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Obecní úřad Nové Milošice', 'Nové Milošice 24', 'Nové Milošice', '44222', '31231312312', 'CZ31231231', '', 0, 0, '', 0),
     357(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SOFTCOM', 'Pod vodou 9', 'Praha', '42044', '2323324234234', 'CZ6565622', 'Prodej výpočetní techniky', 0, 0, 'http://www.softcom.cz/', 0),
     358(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Honza Procházka', 'Za bukem 3', 'Chvojkovice', '44332', '', '', '', 0, 0, '', 0),
     359(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Freenet s.r.o.', 'Bezdrátová 11', 'Nové síťovice', '434223', '43423423423', 'CZ42423423', 'Hlavní kontakt na tuto síť', 0, 0, '', 0),
     360(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),
     361(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);
    355366
    356367-- --------------------------------------------------------
    … …  
    364375  `ItemId` int(11) NOT NULL,
    365376  `Author` int(11) NOT NULL,
    366   `ValidTimeFrom` datetime NOT NULL,
    367   `ValidTimeTo` datetime NOT NULL,
    368   `CreationTime` datetime NOT NULL,
     377  `ValidTimeFrom` datetime default NULL,
     378  `ValidTimeTo` datetime default NULL,
     379  `CreationTime` datetime default NULL,
     380  `DeletionTime` datetime default NULL,
    369381  `TableName` varchar(255) collate utf8_czech_ci NOT NULL,
    370382  `Title` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    373385  `VisibleInMenu` int(11) NOT NULL default '1',
    374386  PRIMARY KEY  (`Id`)
    375 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=27 ;
     387) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
    376388
    377389--
    … …  
    379391--
    380392
    381 INSERT INTO `SystemList` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `TableName`, `Title`, `System`, `Items`, `VisibleInMenu`) VALUES
    382 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'User', 'Uživatelé', 0, '', 1),
    383 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Host', 'Zařízení', 0, '', 1),
    384 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Subject', 'Finanční subjekty', 0, '', 1),
    385 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Členové sítě', 0, '', 1),
    386 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Area', 'Oblasti', 0, '', 1),
    387 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Interface', 'Rozhraní zařízení', 0, '', 1),
    388 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Asset', 'Majetek', 0, '', 1),
    389 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Tariff', 'Tarify', 0, '', 1),
    390 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberReport', 'Hlášení členů', 0, '', 1),
    391 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BankAccount', 'Bankovní účty', 0, '', 1),
    392 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SystemType', 'Definice typů', 1, '', 1),
    393 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'FinanceTransaction', 'Platební operace', 0, '', 1),
    394 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SystemList', 'Definice tabulek', 1, '', 1),
    395 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SystemListItem', 'Definice položek formulářů', 1, '', 0),
    396 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UserOnline', 'Přihlášení uživatelé', 1, '', 1),
    397 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'History', 'Historie záznamů', 1, '', 0),
    398 (26, 17, 5, '2008-10-12 18:38:17', '0000-00-00 00:00:00', '2008-10-12 18:38:17', 'Test', 'Testovací tabulka', 0, '', 1);
     393INSERT 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);
    399416
    400417-- --------------------------------------------------------
    … …  
    408425  `ItemId` int(11) NOT NULL,
    409426  `Author` int(11) NOT NULL,
    410   `ValidTimeFrom` datetime NOT NULL,
    411   `ValidTimeTo` datetime NOT NULL,
    412   `CreationTime` datetime NOT NULL,
     427  `ValidTimeFrom` datetime default NULL,
     428  `ValidTimeTo` datetime default NULL,
     429  `CreationTime` datetime default NULL,
     430  `DeletionTime` datetime default NULL,
    413431  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    414432  `TextBefore` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    429447--
    430448
    431 INSERT INTO `SystemListItem` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `TextBefore`, `TextAfter`, `Type`, `Help`, `Default`, `Required`, `Editable`, `VisibleInList`, `VisibleInPointer`, `List`) VALUES
    432 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'FirstName', 'Jméno', '', '3', 'Zadejte jméno', '', 1, 1, 1, 1, 1),
    433 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SecondName', 'Příjmení', '', '3', 'Zadejte příjmení', '', 1, 1, 1, 1, 1),
    434 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Email', 'E-mail', '', '3', 'Zadejte emailovou adresu', '', 1, 1, 1, 0, 1),
    435 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ICQ', 'ICQ', '', '1', 'Zadejte kontaktní číslo textového komunikačního programu ICQ.', '', 0, 1, 0, 0, 1),
    436 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Sex', 'Pohlaví', '', '5', 'Vyberte pohlaví osoby', '', 0, 1, 0, 0, 1),
    437 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BirthDay', 'Datum narození', '', '2', 'Vyberte datum narození', '', 0, 1, 0, 0, 1),
    438 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DomainName', 'Doménové jméno', '', '3', 'Zadejte jméno počítače v doméně', '', 1, 1, 1, 1, 2),
    439 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '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),
    440 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LocalIPAddress', 'Místní IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci místní sítě', '', 1, 1, 1, 0, 2),
    441 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PublicIPAddress', 'Veřejná IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci Internetu', '', 0, 1, 1, 0, 2),
    442 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LastOnlineDate', 'Naposledy online', '', '2', 'Čas posledního úspěšného měření dostupnosti počítače', '', 0, 0, 0, 0, 2),
    443 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Jméno', '', '3', 'Jméno subjektu', '', 1, 1, 1, 1, 3),
    444 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'AddressStreet', 'Ulice', '', '3', 'Ulice', '', 1, 1, 1, 0, 3),
    445 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'AddressTown', 'Město', '', '3', 'Město', '', 1, 1, 1, 0, 3),
    446 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'AddressZIP', 'PSČ', '', '3', '', '', 1, 1, 1, 0, 3),
    447 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IC', 'IČ', '', '3', 'Identifikační číslo subjektu', '', 0, 1, 0, 0, 3),
    448 (17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DIC', 'DIČ', '', '3', 'Daňové identifikační číslo', '', 0, 1, 0, 0, 3),
    449 (18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MapPositionX', 'Horizontálně pozice', '', '1', 'Vodorovná pozice na mapě', '', 0, 1, 0, 0, 4),
    450 (19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MapPositionY', 'Vertikální pozice', '', '1', 'Svislá pozice na mapě', '', 0, 1, 0, 0, 4),
    451 (20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MembershipDate', 'Začátek členství', '', '2', 'Datum přípojení do sítě', '', 0, 1, 0, 0, 4),
    452 (21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'FamilyMemberCount', 'Osob v rodině', '', '1', 'Počet osob v připojené domácnosti', '', 0, 1, 0, 0, 4),
    453 (22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ResponsibleUser', 'Zodpovědný uživatel', '', '37', '', '', 1, 1, 1, 1, 4),
    454 (23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Subject', 'Subjekt', '', '33', '', '', 1, 1, 0, 0, 4),
    455 (24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Druh', '', '7', '', '1', 0, 1, 1, 0, 2),
    456 (25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Phone', 'Telefón', '', '3', '', '', 0, 1, 0, 0, 1),
    457 (26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Notice', 'Poznámka', '', '3', '', '', 0, 1, 0, 0, 3),
    458 (27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberState', 'Stav připojení', '', '6', '', '', 1, 1, 1, 0, 4),
    459 (28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'HostList', 'Registrované zařízení', '', '23', '', '', 0, 1, 0, 0, 4),
    460 (29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 5),
    461 (30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'NetworkIPAddress', 'Adresa sítě', '', '3', '', '', 1, 1, 1, 0, 5),
    462 (31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IPAddressMask', 'Maska sítě', '', '3', '', '', 1, 1, 1, 0, 5),
    463 (32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DNSPrimary', 'Primární DNS server', '', '3', '', '', 0, 1, 0, 0, 5),
    464 (33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DNSSecondary', 'Sukundární DNS server', '', '3', '', '', 0, 1, 0, 0, 5),
    465 (34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DHCP', 'DHCP server', '', '3', '', '', 0, 1, 0, 0, 5),
    466 (35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Domain', 'Doména', '', '3', '', '', 0, 1, 0, 0, 5),
    467 (36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Workgroup', 'Pracovní skupina', '', '3', '', '', 0, 1, 0, 0, 5),
    468 (37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'WINS', 'WINS server', '', '3', '', '', 0, 1, 0, 0, 5),
    469 (38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 6),
    470 (39, 39, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Typ', '', '8', '', '', 1, 1, 1, 0, 6),
    471 (40, 40, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Host', 'Zařízení', '', '31', 'Vyberte zařízení, ke kterému patří toto rozhraní.', '', 1, 1, 1, 0, 6),
    472 (41, 41, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ParentHost', 'Připojeno k bodu', '', '31', '', '', 1, 1, 1, 0, 6),
    473 (42, 42, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Interface', 'Rozhraní', '', '24', '', '', 0, 1, 0, 0, 2),
    474 (43, 43, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MAC', 'Fyzická adresa', '', '3', 'Zadejte fyzickou adresu síťové karty též nazývanou MAC adresa.', '', 1, 1, 0, 0, 6),
    475 (44, 44, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ParentHost', 'Nadřazený uzel', '', '31', '', '', 0, 1, 0, 0, 2),
    476 (45, 45, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SubHostList', 'Připojené zařízení', '', '38', 'Seznam podřízených zařízení ve virtuálním stromu propojení.', '', 0, 1, 0, 0, 2),
    477 (46, 46, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 7),
    478 (47, 47, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeEnlistment', 'Čas zařazení', '', '2', '', '', 1, 1, 0, 0, 7),
    479 (48, 48, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeElimination', 'Čas vyřazení', '', '2', '', '', 0, 1, 0, 0, 7),
    480 (49, 49, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Price', 'Pořizovací cena', '', '1', '', '', 1, 1, 1, 0, 7),
    481 (50, 50, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'State', 'Stav', '', '9', '', '', 1, 1, 1, 0, 7),
    482 (51, 51, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SerialNumber', 'Sériové číslo', '', '3', '', '', 0, 1, 0, 0, 7),
    483 (52, 52, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PurcheasedFrom', 'Zakoupeno od', '', '33', '', '', 0, 1, 0, 0, 7),
    484 (53, 53, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PurcheasedAsset', 'Nakoupené zboží', '', '21', '', '', 0, 1, 0, 0, 3),
    485 (54, 54, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Člen', '', '32', '', '', 0, 1, 0, 0, 1),
    486 (113, 113, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ValidFromTime', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 4),
    487 (57, 57, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Price', 'Cena', '', '1', '', '', 1, 1, 1, 0, 8),
    488 (56, 56, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 8),
    489 (58, 58, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MinUploadSpeed', 'Minimální odchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8),
    490 (59, 59, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MaxUploadSpeed', 'Maximální odchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8),
    491 (60, 60, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MinDownloadSpeed', 'Minimální příchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8),
    492 (61, 61, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MaxDownloadSpeed', 'Max příchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8),
    493 (62, 62, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UserName', 'Uživatelské jméno', '', '3', '', '', 1, 1, 0, 0, 1),
    494 (63, 63, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Password', 'Heslo', '', '15', '', '', 1, 1, 0, 0, 1),
    495 (64, 64, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Členové', '', '26', '', '', 0, 1, 0, 0, 8),
    496 (65, 65, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Tariff', 'Tarif', '', '36', '', '', 1, 1, 1, 0, 4),
    497 (66, 66, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Vlastník', '', '32', '', '', 0, 1, 0, 0, 2),
    498 (67, 67, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'WWW', 'Internetové stránky', '', '18', '', '', 0, 1, 0, 0, 3),
    499 (68, 68, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Text', 'Text zprávy', '', '3', '', '', 1, 1, 1, 1, 9),
    500 (69, 69, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Date', 'Datum', '', '2', '', '', 1, 1, 1, 0, 9),
    501 (70, 70, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Člen', '', '32', '', '', 1, 1, 1, 0, 9),
    502 (71, 71, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Typ zprávy', '', '10', '', '', 1, 1, 1, 0, 9),
    503 (72, 72, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ReportList', 'Záznamy', '', '27', '', '', 0, 1, 0, 0, 4),
    504 (73, 73, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Creator', 'Vložil', '', '37', '', '', 1, 1, 0, 0, 9),
    505 (74, 74, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 10),
    506 (75, 75, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BankName', 'Jméno banky', '', '3', '', '', 1, 1, 0, 0, 10),
    507 (76, 76, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Number', 'Identifikační číslo', '', '3', '', '', 1, 1, 1, 0, 10),
    508 (77, 77, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BankCode', 'Kód banky', '', '3', '', '', 1, 1, 1, 0, 10),
    509 (78, 78, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'User', 'Registroval', '', '37', '', '', 0, 1, 0, 0, 10),
    510 (79, 79, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Typ', '', '11', '', '', 1, 1, 1, 0, 10),
    511 (80, 80, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberList', 'Členství', '', '25', '', '', 0, 1, 0, 0, 3),
    512 (81, 81, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '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),
    513 (82, 82, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ParentType', 'Rodičovský typ', '', '35', '', '', 1, 1, 1, 0, 11),
    514 (83, 83, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Parameters', 'Parametry typu', '', '3', '', 'Parametry zadávejte jako řetězce oddělené symblem "|".', 0, 1, 0, 0, 11),
    515 (84, 84, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'System', 'Systémový', '', '4', '', '0', 1, 1, 0, 0, 11),
    516 (88, 88, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 11),
    517 (89, 89, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 12),
    518 (90, 90, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Amount', 'Částka', '', '16', '', '', 1, 1, 1, 0, 12),
    519 (91, 91, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Time', 'Čas', '', '2', '', '', 1, 1, 1, 0, 12),
    520 (92, 92, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SourceSubject', 'Zdrojový subjekt', '', '33', '', '', 1, 1, 1, 0, 12),
    521 (93, 93, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TargetSubject', 'Cílový subjekt', '', '33', '', '', 1, 1, 1, 0, 12),
    522 (94, 94, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Type', '', '15', '', '', 1, 1, 0, 0, 12),
    523 (95, 95, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'InsertedByUser', 'Vložil', '', '37', '', '', 0, 0, 0, 0, 12),
    524 (96, 96, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DbDataType', 'Datový typ v databázi', '', '3', '', '', 1, 1, 0, 0, 11),
    525 (97, 97, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '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),
    526 (98, 98, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Title', 'Název seznamu', '', '3', 'Zadejte nadpis seznamu.', '', 1, 1, 1, 1, 13),
    527 (99, 99, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'VisibleInMenu', 'Viditelné v menu', '', '4', 'Zobrazovat tuto tabulku v hlavním menu', '', 1, 1, 0, 0, 13),
    528 (100, 100, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Items', 'Položky', '', '28', 'Definujte potřebné položky pro seznam.', '', 1, 1, 0, 0, 13),
    529 (101, 101, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Jméno sloupce', '', '3', 'Jméno sloupce tabulky v databázi', '', 1, 1, 1, 0, 14),
    530 (102, 102, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TextBefore', 'Text před hodnotou', '', '3', 'Oznčení položky umístěné před zobrazenou hodnotou.', '', 1, 1, 1, 1, 14),
    531 (103, 103, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TextAfter', 'Text za hodnotou', '', '3', 'Tento text většinou obsahuje jednotky použité veličiny.', '', 1, 1, 0, 0, 14),
    532 (104, 104, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Type', '', '35', 'Typ dat položky', '', 1, 1, 1, 0, 14),
    533 (105, 105, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Help', 'Nápověda', '', '3', 'Textová nápověda zobrazovaná jako pomůcka při editaci hodnoty.', '', 1, 1, 0, 0, 14),
    534 (106, 106, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Required', 'Požadováno', '', '4', 'Určuje zda je nutné danou položku vyplnit.', '', 1, 1, 0, 0, 14),
    535 (107, 107, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '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),
    536 (108, 108, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'VisibleInList', 'Viditelné v seznamu', '', '4', 'Určuje viditelnost této položky v seznamu', '', 1, 1, 0, 0, 14),
    537 (109, 109, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '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),
    538 (110, 110, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Area', 'Umístění', '', '30', 'Vyberte oblast, do které toto zařízení patří.', '', 0, 1, 0, 0, 2),
    539 (111, 111, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'HostList', 'Seznam zařízení', '', '22', '', '', 0, 1, 0, 0, 5),
    540 (112, 112, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UserList', 'Uživatelů', '', '29', '', '', 0, 1, 0, 0, 4),
    541 (114, 114, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ValidToTime', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 4),
    542 (115, 115, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'User', 'Uživatel', '', '37', '', '', 1, 0, 1, 1, 15),
    543 (116, 116, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LoginTime', 'Čas přihlášení', '', '2', '', '', 0, 0, 0, 0, 15),
    544 (117, 117, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ActivityTime', 'Naposledy aktivní', '', '2', '', '', 0, 0, 0, 0, 15),
    545 (118, 118, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SessionId', 'Identifikace spojení', '', '3', '', '', 0, 0, 0, 0, 15),
    546 (119, 119, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IpAddress', 'IP adresa', '', '3', '', '', 0, 0, 0, 0, 15),
    547 (120, 120, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'HostName', 'Jméno počítače', '', '3', '', '', 0, 0, 1, 0, 15),
    548 (121, 121, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Locked', 'Zamčeno', '', '4', '', '', 0, 0, 0, 0, 1),
    549 (122, 122, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'RegistrationTime', 'Čas registrace', '', '2', '', '', 0, 0, 0, 0, 1),
    550 (123, 123, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LastLoginTime', 'Čas posledního přihlášení', '', '2', '', '', 0, 0, 0, 0, 1),
    551 (124, 124, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LastIpAddress', 'Poslední IP adresa', '', '3', '', '', 0, 0, 0, 0, 1),
    552 (125, 125, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Author', 'Autor', '', '37', '', '', 1, 0, 0, 0, 16),
    553 (126, 126, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeCreation', 'Čas vytvoření', '', '2', '', '', 1, 0, 0, 0, 16),
    554 (127, 127, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeValidFrom', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 16),
    555 (128, 128, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeValidTo', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 16),
    556 (129, 129, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ListId', 'Odkazovaná tabulka', '', '34', '', '', 1, 1, 0, 0, 16),
    557 (130, 130, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PermanentId', 'Trvalá identifikace', '', '1', '', '', 1, 1, 0, 0, 16),
    558 (133, 132, 5, '2008-10-12 17:48:27', '0000-00-00 00:00:00', '2008-10-12 17:48:27', 'List', 'Rodičovský seznam', '', '34', '', '', 1, 0, 0, 0, 14),
    559 (142, 133, 5, '2008-10-12 18:39:09', '0000-00-00 00:00:00', '2008-10-12 18:39:09', 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 26);
     449INSERT 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);
    560578
    561579-- --------------------------------------------------------
    … …  
    569587  `ItemId` int(11) NOT NULL,
    570588  `Author` int(11) NOT NULL,
    571   `ValidTimeFrom` datetime NOT NULL,
    572   `ValidTimeTo` datetime NOT NULL,
    573   `CreationTime` datetime NOT NULL,
     589  `ValidTimeFrom` datetime default NULL,
     590  `ValidTimeTo` datetime default NULL,
     591  `CreationTime` datetime default NULL,
     592  `DeletionTime` datetime default NULL,
    574593  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    575594  `Description` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    586605--
    587606
    588 INSERT INTO `SystemType` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `Description`, `ParentType`, `Parameters`, `System`, `DbDataType`) VALUES
    589 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Integer', 'Číslo', 0, '', 1, 'INT'),
    590 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Date', 'Datum', 0, '', 1, 'DATE'),
    591 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'String', 'Řetězec', 0, '', 1, 'VARCHAR(255)'),
    592 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Boolean', 'Logická hodnota', 0, '', 1, 'BOOL'),
    593 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Sex', 'Pohlaví', 14, 'Muž|Žena', 0, ''),
    594 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberState', 'Stav člena', 14, 'Neznámý stav|Zájemce o připojení|Připojen|Trvale odpojen', 0, ''),
    595 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '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, ''),
    596 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '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, ''),
    597 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'AssetState', 'Stav majetku', 14, 'Neznámý|Na skladě|Používáno|V reklamaci|Vyřazeno', 0, ''),
    598 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberReportType', 'Typ hlášení člena', 14, 'Jiné|Hlášení závady|Požadavek na změnu|Poznámka správce', 0, ''),
    599 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BankAccountType', 'Typ účtu', 14, 'Neurčeno|Běžný účet|Spořící účet', 0, ''),
    600 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerOneToOne', 'Ukazatel na jednu položku', 0, '', 1, 'INT'),
    601 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerOneToMany', 'Ukazatel na více položek', 0, '', 1, 'INT'),
    602 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Enumeration', 'Výčet', 0, '', 0, 'INT'),
    603 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Password', 'Heslo', 0, '', 1, ''),
    604 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Float', 'Desetinné číslo', 0, '', 1, 'FLOAT'),
    605 (17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'FinanceTransactionType', 'Typ finanční transakce', 14, 'Bankovní převod|Osobní platba', 0, ''),
    606 (18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Hyperlink', 'Internetový odkaz', 0, '', 0, 'VARCHAR(255)'),
    607 (19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IPv4Address', 'IP adresa v4', 0, '', 0, 'VARCHAR(16)'),
    608 (20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Hidden', 'Skrytá položka formuláře', 0, '', 1, 'VARCHAR(255)'),
    609 (21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:01:23', 'PointerToAssetPurcheasedFrom', '', 13, 'Asset|PurcheasedFrom', 0, ''),
    610 (22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:02:00', 'PointerToHostArea', '', 13, 'Host|Area', 0, ''),
    611 (23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:04:28', 'PointerToHostMember', '', 13, 'Host|Member', 0, ''),
    612 (24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:05:47', 'PointerToInterfaceHost', '', 13, 'Interface|Host', 0, ''),
    613 (25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', 'PointerToMemberSubject', '', 13, 'Member|Subject', 0, ''),
    614 (26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', 'PointerToMemberTariff', '', 13, 'Member|Tariff', 0, ''),
    615 (27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToMemberReportMember', '', 13, 'MemberReport|Member    ', 0, ''),
    616 (28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToSystemListItemList', '', 13, 'SystemListItem|List', 0, ''),
    617 (29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', 'PointerToUserMember', '', 13, 'User|Member', 0, ''),
    618 (30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', 'PointerToArea', '', 12, 'Area', 0, ''),
    619 (31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerOneToHost', '', 12, 'Host', 0, ''),
    620 (32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToMember', '', 12, 'Member', 0, ''),
    621 (33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:11:14', 'PointerToSubject', '', 12, 'Subject', 0, ''),
    622 (34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:12:37', 'PointerToSystemList', '', 12, 'SystemList', 0, ''),
    623 (35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToSystemType', '', 12, 'SystemType', 0, ''),
    624 (36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', 'PointerToTariff', '', 12, 'Tariff', 0, ''),
    625 (37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', 'PointerToUser', '', 12, 'User', 0, ''),
    626 (38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToHostParentHost', '', 13, 'Host|ParentHost', 0, '');
     607INSERT 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, '');
    627646
    628647-- --------------------------------------------------------
    … …  
    636655  `ItemId` int(11) NOT NULL,
    637656  `Author` int(11) NOT NULL,
    638   `ValidTimeFrom` datetime NOT NULL,
    639   `ValidTimeTo` datetime NOT NULL,
    640   `CreationTime` datetime NOT NULL,
     657  `ValidTimeFrom` datetime default NULL,
     658  `ValidTimeTo` datetime default NULL,
     659  `CreationTime` datetime default NULL,
     660  `DeletionTime` datetime default NULL,
    641661  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    642662  `Price` float NOT NULL,
    … …  
    653673--
    654674
    655 INSERT INTO `Tariff` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `Price`, `MinUploadSpeed`, `MaxUploadSpeed`, `MinDownloadSpeed`, `MaxDownloadSpeed`, `MemberList`) VALUES
    656 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 512 kbit', 190, 31, 512, 31, 512, 0),
    657 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 1 Mbit', 260, 62, 1024, 62, 1024, 0),
    658 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 2 Mbit', 360, 124, 2048, 124, 2048, 0),
    659 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 4 Mbit', 520, 249, 4096, 249, 4096, 0),
    660 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 8 Mbit', 750, 497, 8192, 497, 8192, 0);
     675INSERT 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);
    661681
    662682-- --------------------------------------------------------
    … …  
    670690  `ItemId` int(11) NOT NULL,
    671691  `Author` int(11) NOT NULL,
    672   `ValidTimeFrom` datetime NOT NULL,
    673   `ValidTimeTo` datetime NOT NULL,
    674   `CreationTime` datetime NOT NULL,
     692  `ValidTimeFrom` datetime default NULL,
     693  `ValidTimeTo` datetime default NULL,
     694  `CreationTime` datetime default NULL,
     695  `DeletionTime` datetime default NULL,
    675696  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    676697  PRIMARY KEY  (`Id`)
    … …  
    692713  `ItemId` int(11) NOT NULL,
    693714  `Author` int(11) NOT NULL,
    694   `ValidTimeFrom` datetime NOT NULL,
    695   `ValidTimeTo` datetime NOT NULL,
    696   `CreationTime` datetime NOT NULL,
     715  `ValidTimeFrom` datetime default NULL,
     716  `ValidTimeTo` datetime default NULL,
     717  `CreationTime` datetime default NULL,
     718  `DeletionTime` datetime default NULL,
    697719  `UserName` varchar(255) collate utf8_czech_ci NOT NULL,
    698720  `Password` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    716738--
    717739
    718 INSERT INTO `User` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `UserName`, `Password`, `FirstName`, `SecondName`, `Email`, `ICQ`, `Sex`, `BirthDay`, `Phone`, `Member`, `RegistrationTime`, `LastLoginTime`, `Locked`, `LastIpAddress`) VALUES
    719 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '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, ''),
    720 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '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, ''),
    721 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '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, ''),
    722 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '0000-00-00', '', 6, '0000-00-00 00:00:00', '2008-10-11 19:11:56', 0, ''),
    723 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
    724 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '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, ''),
    725 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '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, ''),
    726 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '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, ''),
    727 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '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, ''),
    728 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '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, ''),
    729 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '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, '');
     740INSERT 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, '');
    730752
    731753-- --------------------------------------------------------
    … …  
    745767  `ItemId` int(11) NOT NULL,
    746768  `Author` int(11) NOT NULL,
    747   `ValidTimeFrom` datetime NOT NULL,
    748   `ValidTimeTo` datetime NOT NULL,
    749   `CreationTime` datetime NOT NULL,
     769  `ValidTimeFrom` datetime default NULL,
     770  `ValidTimeTo` datetime default NULL,
     771  `CreationTime` datetime default NULL,
     772  `DeletionTime` datetime default NULL,
    750773  PRIMARY KEY  (`Id`),
    751774  KEY `User` (`User`)
    752 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
     775) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;
    753776
    754777--
    … …  
    756779--
    757780
    758 INSERT INTO `UserOnline` (`User`, `LoginTime`, `ActivityTime`, `SessionId`, `IpAddress`, `HostName`, `Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`) VALUES
    759 (5, '2008-10-11 19:11:48', '2008-10-12 20:36:20', 'h10jgvuaueeqe09je1ataith80', '192.168.0.23', 'george-nb.zdechov.net', 10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
     781INSERT 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);

  • sql/system_structure.sql

    r10 r11  
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Neděle 12. října 2008, 20:38
     6-- Vygenerováno: Pondělí 13. října 2008, 08:00
    77-- Verze MySQL: 5.0.51
    88-- Verze PHP: 5.2.6
    … …  
    2424  `ItemId` int(11) NOT NULL,
    2525  `Author` int(11) NOT NULL,
    26   `ValidTimeFrom` datetime NOT NULL,
    27   `ValidTimeTo` datetime NOT NULL,
    28   `CreationTime` datetime NOT NULL,
     26  `ValidTimeFrom` datetime default NULL,
     27  `ValidTimeTo` datetime default NULL,
     28  `CreationTime` datetime default NULL,
     29  `DeletionTime` datetime default NULL,
    2930  `TableName` varchar(255) collate utf8_czech_ci NOT NULL,
    3031  `Title` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    3334  `VisibleInMenu` int(11) NOT NULL default '1',
    3435  PRIMARY KEY  (`Id`)
    35 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=27 ;
     36) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
    3637
    3738-- --------------------------------------------------------
    … …  
    4546  `ItemId` int(11) NOT NULL,
    4647  `Author` int(11) NOT NULL,
    47   `ValidTimeFrom` datetime NOT NULL,
    48   `ValidTimeTo` datetime NOT NULL,
    49   `CreationTime` datetime NOT NULL,
     48  `ValidTimeFrom` datetime default NULL,
     49  `ValidTimeTo` datetime default NULL,
     50  `CreationTime` datetime default NULL,
     51  `DeletionTime` datetime default NULL,
    5052  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    5153  `TextBefore` varchar(255) collate utf8_czech_ci NOT NULL,
    … …  
    7274  `ItemId` int(11) NOT NULL,
    7375  `Author` int(11) NOT NULL,
    74   `ValidTimeFrom` datetime NOT NULL,
    75   `ValidTimeTo` datetime NOT NULL,
    76   `CreationTime` datetime NOT NULL,
     76  `ValidTimeFrom` datetime default NULL,
     77  `ValidTimeTo` datetime default NULL,
     78  `CreationTime` datetime default NULL,
     79  `DeletionTime` datetime default NULL,
    7780  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    7881  `Description` varchar(255) collate utf8_czech_ci NOT NULL,

  • types/Boolean.php

    r10 r11  
    33function TypeBooleanOnView($Item)
    44{
    5   return('<input type="checkbox" name="'.$Item['Name'].'" value="'.$Item['Value'].'" disabled="1">');
     5  if($Item['Value'] == 1) $Checked = ' checked="1"'; else $Checked = '';
     6  return('<input type="checkbox" name="'.$Item['Name'].'" disabled="1"'.$Checked.'>');
    67}
    78
    89function TypeBooleanOnEdit($Item)
    910{
    10   return('<input type="checkbox" name="'.$Item['Name'].'" value="'.$Item['Value'].'">');
     11  if($Item['Value'] == 1) $Checked = ' checked="1"'; else $Checked = '';
     12  return('<input type="checkbox" name="'.$Item['Name'].'"'.$Checked.'>');
     13}
     14
     15function TypeBooleanOnLoad($Item)
     16{
     17  if(array_key_exists($Item['Name'], $_POST)) return(1); else return(0);
    1118}
    1219

  • types/Date.php

    r10 r11  
    3636  $Output .= '</select>';
    3737  // Year
    38   $Output .= '<select name="'.$Item['Name'].'-month">';
     38  $Output .= '<select name="'.$Item['Name'].'-year">';
    3939  for($I = 1900; $I < 2100; $I++)
    4040  {
    … …  
    4646}
    4747
     48function TypeDateOnLoad($Item)
     49{
     50  return($_POST[$Item['Name'].'-year'].'-'.$_POST[$Item['Name'].'-month'].'-'.$_POST[$Item['Name'].'-day']);
     51}
     52
    4853?>

  • types/Enumeration.php

    r10 r11  
    1616  foreach($Types[$Item['Type']]['Parameters'] as $Index => $StateName)
    1717  {
    18     if($Parameter == $Index) $Selected = ' selected="1"'; else $Selected = '';
     18    if($Item['Value'] == $Index) $Selected = ' selected="1"'; else $Selected = '';
    1919    $Output .= '<option value="'.$Index.'"'.$Selected.'>'.$StateName.'</option>';
    2020  }
    … …  
    2323}
    2424
     25function TypeEnumerationOnLoad($Item)
     26{
     27  return($_POST[$Item['Name']]);
     28}
     29
    2530?>

  • types/Float.php

    r10 r11  
    1313}
    1414
     15function TypeFloatOnLoad($Item)
     16{
     17  return($_POST[$Item['Name']]);
     18}
     19
    1520?>

  • types/Hidden.php

    r10 r11  
    1313}
    1414
     15function TypeHiddenOnLoad($Item)
     16{
     17  return($_POST[$Item['Name']]);
     18}
     19
    1520?>

  • types/Hyperlink.php

    r10 r11  
    1313}
    1414
     15function TypeHyperlinkOnLoad($Item)
     16{
     17  return($_POST[$Item['Name']]);
     18}
     19
    1520?>

  • types/IPv4Address.php

    r10 r11  
    1818}
    1919
     20function TypeIPv4AddressOnLoad($Item)
     21{
     22  return($_POST[$Item['Name']]);
     23}
    2024?>

  • types/Integer.php

    r10 r11  
    1313}
    1414
     15function TypeIntegerOnLoad($Item)
     16{
     17  return($_POST[$Item['Name']]);
     18}
     19
    1520?>

  • types/Password.php

    r10 r11  
    1515}
    1616
     17function TypePasswordOnLoad($Item)
     18{
     19  return($_POST[$Item['Name']]);
     20}
     21
    1722?>

  • types/PointerOneToMany.php

    r10 r11  
    1313}
    1414
     15function TypePointerOneToManyOnLoad($Item)
     16{
     17  return($_POST[$Item['Name']]);
     18}
     19
    1520?>

  • types/PointerOneToOne.php

    r10 r11  
    6868}
    6969
     70function TypePointerOneToOneOnLoad($Item)
     71{
     72  return($_POST[$Item['Name']]);
     73}
    7074
    7175?>

  • types/String.php

    r10 r11  
    1313}
    1414
     15function TypeStringOnLoad($Item)
     16{
     17  return($_POST[$Item['Name']]);
     18}
     19
    1520?>
Note: See TracChangeset for help on using the changeset viewer.