Changeset 24


Ignore:
Timestamp:
Oct 27, 2008, 5:10:59 PM (16 years ago)
Author:
george
Message:
  • Upraveno: Odkazy na seznamy pomocí ItemId namísto jmen tabulek.
  • Přidáno: Potvrzovací dialog při mazání položek.
Files:
9 edited

Legend:

Unmodified
Added
Removed

  • base.php

    r23 r24  
    2727    $Where .= ' AND (t1.'.$Column.'='.$ColumnValue.')';
    2828    $ColumnSelection = '&Column='.$Column.'&ColumnValue='.$ColumnValue;
    29     $FullListLink = '<a href="?Action=ViewList&amp;Table='.$List['TableName'].'">Celkový seznam</a>';
     29    $FullListLink = '<a href="?Action=ViewList&amp;Table='.$List['ItemId'].'">Celkový seznam</a>';
    3030  } else
    3131  {
    … …  
    3939    if($_SESSION['OrderColumn'] == $_GET['OrderColumn']) // Same column => reverse order
    4040      $_SESSION['OrderDirection'] = ($_SESSION['OrderDirection'] + 1) % 2;
    41     if($_SESSION['OrderTable'] != $List['TableName']) // Different table => set ascending order
     41    if($_SESSION['OrderTable'] != $List['ItemId']) // Different table => set ascending order
    4242      $_SESSION['OrderDirection'] = 0;
    4343    $_SESSION['OrderColumn'] = $_GET['OrderColumn'];
    44     $_SESSION['OrderTable'] = $List['TableName'];
    45   }
    46   if(array_key_exists('OrderColumn', $_SESSION) and ($_SESSION['OrderTable'] == $List['TableName']))
     44    $_SESSION['OrderTable'] = $List['ItemId'];
     45  }
     46  if(array_key_exists('OrderColumn', $_SESSION) and ($_SESSION['OrderTable'] == $List['ItemId']))
    4747  {
    4848    $OrderDirection = array('ASC', 'DESC');
    … …  
    6666      if($Item['VisibleInList'] == 1)
    6767      {
    68         $ItemDefinition = array('Name' => $Index, 'Value' => $DbRow[$Index], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
     68        $ItemDefinition = array('Name' => $Index, 'Value' => $DbRow[$Index], 'SourceTable' => $List['ItemId'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
    6969        $Output .= '<td>'.ExecuteTypeEvent($Item['Type'], 'OnView', $ItemDefinition).'</td>';
    7070      }
    7171    }
    7272    $Output .= '<td>';
    73     if(CheckPermission('Read', $List['ItemId'])) $Output .= '<a href="?Action=ViewItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a>';
    74     if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=EditItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/edit.png" alt="Editovat" title="Editovat"></a>';
    75     if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=DeleteItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/delete.png" alt="Smazat" title="Smazat"></a>';
     73    if(CheckPermission('Read', $List['ItemId'])) $Output .= '<a href="?Action=ViewItem&amp;Table='.$List['ItemId'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a>';
     74    if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=EditItem&amp;Table='.$List['ItemId'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/edit.png" alt="Editovat" title="Editovat"></a>';
     75    if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=DeleteItem&amp;Table='.$List['ItemId'].'&amp;Item='.$DbRow['ItemId'].'"><img border="0" src="images/delete.png" alt="Smazat" title="Smazat" onclick="return confirmAction(\'Opravdu smazat položku?\');"></a>';
    7676    $Output .= '</td></tr>';
    7777  }
    … …  
    7979  $PageList = PagesList($Page, $TotalItemCount);
    8080  if(strlen($PageList) != 0) $Output .= $PageList.'<br />';
    81   if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=AddItem&amp;Table='.$List['TableName'].$ColumnSelection.'">Přidat</a> '.$FullListLink;
     81  if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=AddItem&amp;Table='.$List['ItemId'].$ColumnSelection.'">Přidat</a> '.$FullListLink;
    8282  return($Output);
    8383}
    … …  
    104104    if($_SESSION['OrderColumn'] == $_GET['OrderColumn']) // Same column => reverse orded
    105105      $_SESSION['OrderDirection'] = ($_SESSION['OrderDirection'] + 1) % 2;
    106     if($_SESSION['OrderTable'] != $List['TableName']) // Different table => set ascending order
     106    if($_SESSION['OrderTable'] != $List['ItemId']) // Different table => set ascending order
    107107      $_SESSION['OrderDirection'] = 0;
    108108    $_SESSION['OrderColumn'] = $_GET['OrderColumn'];
    109     $_SESSION['OrderTable'] = $List['TableName'];
    110   }
    111   if(array_key_exists('OrderColumn', $_SESSION) and ($_SESSION['OrderTable'] == $List['TableName']))
     109    $_SESSION['OrderTable'] = $List['ItemId'];
     110  }
     111  if(array_key_exists('OrderColumn', $_SESSION) and ($_SESSION['OrderTable'] == $List['ItemId']))
    112112  {
    113113    $OrderDirection = array('ASC', 'DESC');
    … …  
    132132      if($Item['VisibleInList'] == 1)
    133133      {
    134         $ItemDefinition = array('Name' => $Item['Name'], 'Value' => $DbRow[$Item['Name']], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
     134        $ItemDefinition = array('Name' => $Item['Name'], 'Value' => $DbRow[$Item['Name']], 'SourceTable' => $List['ItemId'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
    135135        $Output .= '<td>'.ExecuteTypeEvent($Item['Type'], 'OnView', $ItemDefinition).'</td>';
    136136      }
    137137    }
    138138    $Item = array('Name' => 'Author', 'Type' => TypePointerToUserId);
    139     $ItemDefinition = array('Name' => $Item['Name'], 'Value' => $DbRow[$Item['Name']], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
     139    $ItemDefinition = array('Name' => $Item['Name'], 'Value' => $DbRow[$Item['Name']], 'SourceTable' => $List['ItemId'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
    140140    $Output .= '<td>'.ExecuteTypeEvent($Item['Type'], 'OnView', $ItemDefinition).'</td>';
    141141
    142142    $Output .= '<td>'.$DbRow['CreationTime'].'</td><td>'.$DbRow['DeletionTime'].'</td>';
    143     $Output .= '<td><a href="?Action=ViewItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['Id'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a></td></tr>';
     143    $Output .= '<td><a href="?Action=ViewItem&amp;Table='.$List['ItemId'].'&amp;Item='.$DbRow['Id'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a></td></tr>';
    144144  }
    145145  $Output .= '</table>';
    146146  $Output .= PagesList($Page, $TotalItemCount);
    147   $Output .= ' <a href="?Action=ShowList&amp;Table='.$List['TableName'].'">Celkový seznam</a>';
     147  $Output .= ' <a href="?Action=ShowList&amp;Table='.$List['ItemId'].'">Celkový seznam</a>';
    148148  return($Output);
    149149}
    … …  
    165165        if($Item['Editable'] == 1)
    166166        {
    167           $DefinitionItems[] = array('Name' => $Index, 'Caption' => $Item['TextBefore'].$Required, 'Value' => $DbRow[$Index], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
     167          $DefinitionItems[] = array('Name' => $Index, 'Caption' => $Item['TextBefore'].$Required, 'Value' => $DbRow[$Index], 'SourceTable' => $List['ItemId'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
    168168        } else $DefinitionItems[] = array('Name' => $Index, 'Type' => TypeHiddenId, 'Caption' => '', 'Value' => $DbRow[$Index]);
    169169      }
    … …  
    181181  if(($Column != '') and ($ColumnValue != 0))
    182182  {
    183     $Output .= '<a href="?Action=ShowList&amp;Table='.$List['TableName'].'&amp;Column='.$Column.'&amp;ColumnValue='.$ColumnValue.'">Celkový seznam</a>';
     183    $Output .= '<a href="?Action=ShowList&amp;Table='.$List['ItemId'].'&amp;Column='.$Column.'&amp;ColumnValue='.$ColumnValue.'">Celkový seznam</a>';
    184184  } else
    185185  {
    186     $Output .= '<a href="?Action=ShowList&amp;Table='.$List['TableName'].'">Celkový seznam</a>';
     186    $Output .= '<a href="?Action=ShowList&amp;Table='.$List['ItemId'].'">Celkový seznam</a>';
    187187  }
    188188  return($Output);
    … …  
    203203      if($Type['BaseType'] != 'PointerOneToMany')
    204204      {
    205         $DefinitionItems[] = array('Name' => $Index, 'Caption' => $Item['TextBefore'].$Required, 'Value' => $DbRow[$Index], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
     205        $DefinitionItems[] = array('Name' => $Index, 'Caption' => $Item['TextBefore'].$Required, 'Value' => $DbRow[$Index], 'SourceTable' => $List['ItemId'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
    206206      }
    207207    }
    … …  
    215215  );
    216216  $Form->LoadValuesFromForm();
    217   $System->Modules['DatabaseList']->EditItem($List['TableName'], $Form->Values, $Id);
     217  $System->Modules['DatabaseList']->EditItem($List['ItemId'], $Form->Values, $Id);
    218218  $NewId = $Database->insert_id;
    219219  $System->Modules['Log']->Add($List['Id'], $NewId, $LogActionType['Edit']);
    … …  
    223223  $Form->Values['ItemId'] = $Id;
    224224  $Form->Values['ListTableName'] = $List['TableName'];
    225   ExecuteListEvent($List['TableName'], 'OnEdit', $Form->Values);
     225  ExecuteListEvent($List['ItemId'], 'OnEdit', $Form->Values);
    226226  return($Output);
    227227}
    … …  
    242242      if($Item['Required'] == 1) $Required = '*'; else $Required = '';
    243243      if($Item['Editable'] == 1)
    244         $DefinitionItems[] = array('Name' => $Item['Name'], 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => '', 'SourceTable' => $List['TableName'], 'SourceItemId' => 0);
     244        $DefinitionItems[] = array('Name' => $Item['Name'], 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => '', 'SourceTable' => $List['ItemId'], 'SourceItemId' => 0);
    245245    } else
    246246    if($Item['Name'] == $Column)
    … …  
    262262  if(($Column != '') and ($ColumnValue != 0))
    263263  {
    264     $Output .= '<a href="?Action=ShowList&amp;Table='.$List['TableName'].'&amp;Column='.$Column.'&amp;ColumnValue='.$ColumnValue.'">Celkový seznam</a>';
     264    $Output .= '<a href="?Action=ShowList&amp;Table='.$List['ItemId'].'&amp;Column='.$Column.'&amp;ColumnValue='.$ColumnValue.'">Celkový seznam</a>';
    265265  } else
    266266  {
    267     $Output .= '<a href="?Action=ShowList&amp;Table='.$List['TableName'].'">Celkový seznam</a>';
     267    $Output .= '<a href="?Action=ShowList&amp;Table='.$List['ItemId'].'">Celkový seznam</a>';
    268268  }
    269269  return($Output);
    … …  
    284284    {
    285285      if($Item['Required'] == 1) $Required = '*'; else $Required = '';
    286       $DefinitionItems[] = array('Name' => $Item['Name'], 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => '', 'SourceTable' => $List['TableName'], 'SourceItemId' => 0);
     286      $DefinitionItems[] = array('Name' => $Item['Name'], 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => '', 'SourceTable' => $List['ItemId'], 'SourceItemId' => 0);
    287287    } else
    288288    if($Item['Name'] == $Column)
    … …  
    300300  );
    301301  $Form->LoadValuesFromForm();
    302   $NewItemId = $System->Modules['DatabaseList']->AddItem($List['TableName'], $Form->Values);
     302  $NewItemId = $System->Modules['DatabaseList']->AddItem($List['ItemId'], $Form->Values);
    303303  $NewId = $Database->insert_id;
    304304  $System->Modules['Log']->Add($List['Id'], $NewId, $LogActionType['Add']);
    … …  
    306306  $Output .= ShowViewItem($List, $NewItemId);
    307307  $Form->Values['Column'] = $_POST['Column'];
    308   ExecuteListEvent($List['TableName'], 'OnAdd', $Form->Values);
     308  ExecuteListEvent($List['ItemId'], 'OnAdd', $Form->Values);
    309309  return($Output);
    310310}
    … …  
    326326      if($Type['BaseType'] != 'PointerOneToMany')
    327327      {
    328         $DefinitionItems[] = array('Name' => $Index, 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => $DbRow[$Index], 'SourceTable' => $List['TableName'], 'SourceItemId' => 0);
     328        $DefinitionItems[] = array('Name' => $Index, 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => $DbRow[$Index], 'SourceTable' => $List['ItemId'], 'SourceItemId' => 0);
    329329      }
    330330    }
    … …  
    336336    );
    337337    $Output .= $Form->ShowReadOnlyForm();
    338     if(CheckPermission('Write', $List['ItemId'])) $Output .= '<a href="?Action=EditItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'">Editovat</a> ';
     338    if(CheckPermission('Write', $List['ItemId'])) $Output .= '<a href="?Action=EditItem&amp;Table='.$List['ItemId'].'&amp;Item='.$DbRow['ItemId'].'">Editovat</a> ';
    339339
    340340    if(($Column != '') and ($ColumnValue != 0))
    341341    {
    342       $Output .= '<a href="?Action=ShowList&amp;Table='.$List['TableName'].'&amp;Column='.$Column.'&amp;ColumnValue='.$ColumnValue.'">Celkový seznam</a>';
     342      $Output .= '<a href="?Action=ShowList&amp;Table='.$List['ItemId'].'&amp;Column='.$Column.'&amp;ColumnValue='.$ColumnValue.'">Celkový seznam</a>';
    343343    } else
    344344    {
    345       $Output .= '<a href="?Action=ShowList&amp;Table='.$List['TableName'].'">Celkový seznam</a>';
    346     }
    347     $Output .= ' <a href="?Action=ShowHistory&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['ItemId'].'">Historie</a>';
     345      $Output .= '<a href="?Action=ShowList&amp;Table='.$List['ItemId'].'">Celkový seznam</a>';
     346    }
     347    $Output .= ' <a href="?Action=ShowHistory&amp;Table='.$List['ItemId'].'&amp;Item='.$DbRow['ItemId'].'">Historie</a>';
    348348    $Output .= '<div class="line"></div>';
    349349    foreach($List['Items'] as $Index => $Item)
    … …  
    366366  if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění'));
    367367  $System->Modules['Log']->Add($List['Id'], $Id, $LogActionType['Delete']);
    368   $System->Modules['DatabaseList']->DeleteItem($List['TableName'], $Id);
     368  $System->Modules['DatabaseList']->DeleteItem($List['ItemId'], $Id);
    369369  $Output = 'Položka smazána.';
    370   $Output .= ShowList($_SESSION['Table'], $_SESSION['Column'], $_SESSION['ColumnValue']).'<br /><br />';
    371   ExecuteListEvent($List['TableName'], 'OnDelete', $Id);
     370  $Output .= ShowList($List, $_SESSION['Column'], $_SESSION['ColumnValue']).'<br /><br />';
     371  ExecuteListEvent($List['ItemId'], 'OnDelete', $Id);
    372372  return($Output);
    373373}
    … …  
    386386    {
    387387      if(CheckPermission('Read', $DbRow2['ItemId']))
    388         $Group .= '<a href="?Action=ShowList&amp;Table='.$DbRow2['TableName'].'">'.$DbRow2['Title'].'</a><br />';
     388        $Group .= '<a href="?Action=ShowList&amp;Table='.$DbRow2['ItemId'].'">'.$DbRow2['Title'].'</a><br />';
    389389    }
    390390    if($Group != '')
    … …  
    411411  {
    412412    $List = GetListDefinition($_SESSION['Table']);
     413    if($List == NULL) SystemMessage('Zobrazení stránky', 'Seznam id '.$_SESSION['Table'].' nenalezen!');
     414    //echo($_SESSION['Table']);
     415    //print_r($List);
    413416    if(array_key_exists('Action', $_SESSION))
    414417    {
    … …  
    451454  if(!array_key_exists($Id, $Lists))
    452455  {
    453     $DbResult = $Database->query('SELECT t1.* FROM `SystemList` AS t1 LEFT JOIN `SystemList` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL) AND (t1.DeletionTime IS NULL) AND t1.TableName="'.$Id.'"');
     456    $DbResult = $Database->query('SELECT t1.* FROM `SystemList` AS t1 LEFT JOIN `SystemList` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL) AND (t1.DeletionTime IS NULL) AND t1.ItemId="'.$Id.'"');
    454457    if($DbResult->num_rows > 0)
    455458    {
    … …  
    468471       'Items' => $Items,
    469472      );
    470       if(!array_key_exists($List['TableName'], $TypeDefinitionList))
     473      //if(!array_key_exists($List['ItemId'], $TypeDefinitionList))
    471474      {
    472475        $ClassName = 'List'.$DbRow['TableName'];
    473476        if(class_exists($ClassName)) $List['Class'] = new $ClassName;
    474477      }
    475       $Lists[$List['TableName']] = $List;
    476     } else $Lists[$List['TableName']] = NULL;
     478      $Lists[$List['ItemId']] = $List;
     479    } else $Lists[$List['ItemId']] = NULL;
    477480  }
    478481  return($Lists[$Id]);
    … …  
    491494      $DbRow = $DbResult->fetch_assoc();
    492495      $DbRow['Parameters'] = explode('|', $DbRow['Parameters']);
     496      if(($DbRow['ParentType'] == TypePointerOneToOneId) or ($DbRow['ParentType'] == TypePointerOneToManyId))
     497      {
     498        $DbResult2 = $Database->query('SELECT t1.* FROM `SystemList` AS t1 LEFT JOIN `SystemType` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL) AND (t1.DeletionTime IS NULL) AND t1.TableName="'.$DbRow['Parameters'][0].'"');
     499        $DbRow2 = $DbResult2->fetch_assoc();
     500        //echo($DbRow['ParentType'].'-'.$DbRow['Parameters'][0].'='.$DbRow2['ItemId'].'<br>');
     501        $DbRow['Parameters'][0] = $DbRow2['ItemId'];
     502      }
    493503      $DbRow['BaseType'] = $DbRow['Name'];
    494504

  • database.php

    r23 r24  
    1717    {
    1818      echo('<strong>Database error:</strong> '.$this->error.'<br /><strong>Query:</strong> '.$Query.'<br />');
    19       echo('<pre>'); print_r(debug_backtrace()); echo('</pre>');
     19      echo('<pre style="font-size: 9px">'); print_r(debug_backtrace()); echo('</pre>');
    2020    }
    2121    return($DbResult);

  • database_list.php

    r19 r24  
    55  var $Dependencies = array('Log', 'User');
    66
    7   function AddItem($TableName, $Values)
     7  function AddItem($TableId, $Values)
    88  {
     9    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$TableId.' ORDER BY Id DESC LIMIT 1');
     10    $DbRow = $DbResult->fetch_assoc();
     11    $TableName = $DbRow['TableName'];
     12
    913    $Values['Author'] = $this->System->Modules['User']->User['ItemId'];
    1014    $Values['CreationTime'] = 'NOW()';
    … …  
    1822  }
    1923
    20   function DeleteItem($TableName, $Id)
     24  function DeleteItem($TableId, $ItemId)
    2125  {
    22     $DbResult = $this->Database->select($TableName, 'Id', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1');
     26    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$TableId.' ORDER BY Id DESC LIMIT 1');
     27    $DbRow = $DbResult->fetch_assoc();
     28    $TableName = $DbRow['TableName'];
     29
     30    $DbResult = $this->Database->select($TableName, 'Id', 'ItemId='.$ItemId.' ORDER BY Id DESC LIMIT 1');
    2331    $DbRow = $DbResult->fetch_assoc();
    2432    $this->Database->update($TableName, 'Id='.$DbRow['Id'], array('DeletionTime' => 'NOW()'));
    2533  }
    2634
    27   function EditItem($TableName, $Values, $Id)
     35  function EditItem($TableId, $Values, $ItemId)
    2836  {
    29     $this->DeleteItem($TableName, $Id);
    30     $Values['ItemId'] = $Id;
     37    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$TableId.' ORDER BY Id DESC LIMIT 1');
     38    $DbRow = $DbResult->fetch_assoc();
     39    $TableName = $DbRow['TableName'];
     40    $this->DeleteItem($TableId, $ItemId);
     41    $Values['ItemId'] = $ItemId;
    3142    $Values['Author'] = $this->System->Modules['User']->User['ItemId'];
    3243    $Values['CreationTime'] = 'NOW()';

  • global.js

    r8 r24  
    2424  }
    2525}
     26
     27function confirmAction(theMessage)
     28{
     29  // TODO: Confirmation is not required in the configuration file
     30  // or browser is Opera (crappy js implementation)
     31  if (typeof(window.opera) != 'undefined')
     32  {
     33    return true;
     34  }
     35
     36  var is_confirmed = confirm(theMessage);
     37
     38  return is_confirmed;
     39}

  • lists/include.php

    r13 r24  
    55include('lists/SystemListItem.php');
    66
     7define('ListSystemLogId', 20);
     8
    79?>

  • log.php

    r13 r24  
    66{
    77  var $Dependencies = array('User', 'DatabaseList');
    8   var $TableName = 'SystemLog';
    98
    109  function Add($List, $Item, $Action)
    1110  {
    1211    $Values = array('User' => $this->System->Modules['User']->User['Id'], 'List' => $List, 'Item' => $Item, 'Action' => $Action);
    13     $this->System->Modules['DatabaseList']->AddItem($this->TableName, $Values);
     12    $this->System->Modules['DatabaseList']->AddItem(ListSystemLogId, $Values);
    1413  }
    1514

  • sql/demo_database.sql

    r18 r24  
    11-- phpMyAdmin SQL Dump
    2 -- version 2.11.9.2
     2-- version 3.0.1
    33-- http://www.phpmyadmin.net
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Úterý 21. října 2008, 16:14
     6-- Vygenerováno: Pondělí 27. října 2008, 14:15
    77-- Verze MySQL: 5.0.51
    88-- Verze PHP: 5.2.6
    … …  
    190190
    191191--
     192-- Struktura tabulky `dd`
     193--
     194
     195CREATE TABLE IF NOT EXISTS `dd` (
     196  `Id` int(11) NOT NULL auto_increment,
     197  `ItemId` int(11) NOT NULL,
     198  `Author` int(11) NOT NULL,
     199  `ValidTimeFrom` datetime default NULL,
     200  `ValidTimeTo` datetime default NULL,
     201  `CreationTime` datetime default NULL,
     202  `DeletionTime` datetime default NULL,
     203  PRIMARY KEY  (`Id`)
     204) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
     205
     206--
     207-- Vypisuji data pro tabulku `dd`
     208--
     209
     210
     211-- --------------------------------------------------------
     212
     213--
    192214-- Struktura tabulky `FinanceTransaction`
    193215--
    … …  
    258280  `SubHostList` int(11) NOT NULL,
    259281  PRIMARY KEY  (`Id`)
    260 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ;
     282) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=15 ;
    261283
    262284--
    … …  
    266288INSERT INTO `Host` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`, `SubHostList`) VALUES
    267289(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'george', 'GEORGE', '192.168.0.23', '', '0000-00-00', 1, 0, 4, 0, 0, 0),
    268 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0, 0),
     290(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:05:42', 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0, 0),
    269291(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'telefon', 'TELEFON', '192.168.1.45', '', '0000-00-00', 2, 0, 4, 1, 2, 0),
    270292(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'router-inet', 'ROUTER-INET', '192.168.0.2', '77.33.55.12', '0000-00-00', 4, 0, 1, 1, 4, 0),
    … …  
    277299(11, 7, 5, '2008-10-19 20:01:24', NULL, '2008-10-19 20:01:24', '2008-10-19 20:03:14', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 5, 0),
    278300(12, 7, 5, '2008-10-19 20:03:14', NULL, '2008-10-19 20:03:14', '2008-10-19 20:03:19', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 5, 0),
    279 (13, 7, 5, '2008-10-19 20:03:19', NULL, '2008-10-19 20:03:19', NULL, 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 2, 0);
     301(13, 7, 5, '2008-10-19 20:03:19', NULL, '2008-10-19 20:03:19', NULL, 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 2, 0),
     302(14, 2, 28, '2008-10-22 08:05:42', NULL, '2008-10-22 08:05:42', NULL, 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '1900-01-01', 5, 0, 4, 4, 3, 0);
    280303
    281304-- --------------------------------------------------------
    … …  
    505528  `PermissionGroup` int(11) NOT NULL,
    506529  PRIMARY KEY  (`Id`)
    507 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=43 ;
     530) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=49 ;
    508531
    509532--
    … …  
    553576(40, 31, 28, '2008-10-21 14:45:36', NULL, '2008-10-21 14:45:36', NULL, 23, 0, 2, 1),
    554577(41, 32, 28, '2008-10-21 14:54:31', NULL, '2008-10-21 14:54:31', NULL, 22, 0, 2, 1),
    555 (42, 33, 28, '2008-10-21 16:09:19', NULL, '2008-10-21 16:09:19', NULL, 24, 0, 1, 1);
     578(42, 33, 28, '2008-10-21 16:09:19', NULL, '2008-10-21 16:09:19', NULL, 24, 0, 1, 1),
     579(43, 34, 28, '2008-10-22 07:13:27', NULL, '2008-10-22 07:13:27', NULL, 12, 0, 2, 1),
     580(44, 35, 28, '2008-10-22 07:43:39', NULL, '2008-10-22 07:43:39', NULL, 2, 0, 2, 1),
     581(45, 36, 5, '2008-10-22 11:50:06', NULL, '2008-10-22 11:50:06', NULL, 6, 0, 2, 1),
     582(46, 37, 5, '2008-10-22 11:50:30', NULL, '2008-10-22 11:50:30', NULL, 10, 0, 2, 1),
     583(47, 38, 5, '2008-10-27 14:04:48', NULL, '2008-10-27 14:04:48', NULL, 28, 0, 2, 1),
     584(48, 39, 5, '2008-10-27 14:14:03', NULL, '2008-10-27 14:14:03', NULL, 33, 0, 2, 1);
    556585
    557586-- --------------------------------------------------------
    … …  
    645674
    646675--
    647 -- Struktura tabulky `SystemFile`
    648 --
    649 
    650 CREATE TABLE IF NOT EXISTS `SystemFile` (
    651   `Id` int(11) NOT NULL auto_increment,
     676-- Struktura tabulky `SystemEnumerationState`
     677--
     678
     679CREATE TABLE IF NOT EXISTS `SystemEnumerationState` (
     680  `Id` int(11) NOT NULL auto_increment,
     681  `ItemId` int(11) NOT NULL,
     682  `Author` int(11) NOT NULL,
     683  `ValidTimeFrom` datetime default NULL,
     684  `ValidTimeTo` datetime default NULL,
     685  `CreationTime` datetime default NULL,
     686  `DeletionTime` datetime default NULL,
    652687  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
    653   `Content` mediumblob NOT NULL,
     688  `ParentParameter` int(11) NOT NULL,
     689  PRIMARY KEY  (`Id`)
     690) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
     691
     692--
     693-- Vypisuji data pro tabulku `SystemEnumerationState`
     694--
     695
     696
     697-- --------------------------------------------------------
     698
     699--
     700-- Struktura tabulky `SystemGPS`
     701--
     702
     703CREATE TABLE IF NOT EXISTS `SystemGPS` (
     704  `Id` int(11) NOT NULL auto_increment,
     705  `Longitude` double NOT NULL,
     706  `Latitude` double NOT NULL,
     707  PRIMARY KEY  (`Id`)
     708) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
     709
     710--
     711-- Vypisuji data pro tabulku `SystemGPS`
     712--
     713
     714INSERT INTO `SystemGPS` (`Id`, `Longitude`, `Latitude`) VALUES
     715(1, 0, 0),
     716(2, 0, 1.0341666666667),
     717(3, 0, 12.067777777778),
     718(4, 5.1019444444444, 12.067777777778),
     719(5, 5.0516666666667, 12.117777777778),
     720(6, 5.0516666666667, -11.882222222222),
     721(7, 5.0516666666667, -11.085555555556),
     722(8, 5.0516666666667, -11.084444444444),
     723(9, 5.0516666666667, -11.083611111111),
     724(10, 5.0516666666667, -11.083611111111),
     725(11, 5.0516666666667, 11.084722222222),
     726(12, 5.0516666666667, 11.084444444444),
     727(13, 5.0519444444444, 11.084166666667),
     728(14, 5.0522222222222, 11.084166666667),
     729(15, 5.0519444444444, 11.084166666667),
     730(16, 5.0516666666667, 11.084444444444),
     731(17, 5.0516666666667, 11.084166666667),
     732(18, 5.0516666666667, 11.084166666667),
     733(19, 5.0516666666667, 11.083888888889),
     734(20, 5.0516666666667, 11.089444444444),
     735(21, 5.0516666666667, 11.089444444444),
     736(22, 5.0516666666667, 11.089166666667),
     737(23, 5.0516666666667, 11.089166666667),
     738(24, 5.0516666666667, 11.089166666667),
     739(25, 5.0516666666667, 11.089444444444),
     740(26, 5.0516666666667, 11.089444444444),
     741(27, 18.080528888889, 49.257925555556),
     742(28, 18.077825, 49.258213611111),
     743(29, 18.077825, 49.258213611111),
     744(30, 0, 0),
     745(31, 0, 0);
     746
     747-- --------------------------------------------------------
     748
     749--
     750-- Struktura tabulky `SystemList`
     751--
     752
     753CREATE TABLE IF NOT EXISTS `SystemList` (
     754  `Id` int(11) NOT NULL auto_increment,
     755  `ItemId` int(11) NOT NULL,
     756  `Author` int(11) NOT NULL,
     757  `ValidTimeFrom` datetime default NULL,
     758  `ValidTimeTo` datetime default NULL,
     759  `CreationTime` datetime default NULL,
     760  `DeletionTime` datetime default NULL,
     761  `TableName` varchar(255) collate utf8_czech_ci NOT NULL,
     762  `Title` varchar(255) collate utf8_czech_ci NOT NULL,
     763  `Items` varchar(255) collate utf8_czech_ci NOT NULL,
     764  `Menu` int(11) NOT NULL,
     765  PRIMARY KEY  (`Id`)
     766) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=84 ;
     767
     768--
     769-- Vypisuji data pro tabulku `SystemList`
     770--
     771
     772INSERT INTO `SystemList` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `TableName`, `Title`, `Items`, `Menu`) VALUES
     773(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:21', 'User', 'Uživatelé', '', 0),
     774(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:07', 'Host', 'Zařízení', '', 0),
     775(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:30', 'Subject', 'Finanční subjekty', '', 0),
     776(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:12', 'Member', 'Členové sítě', '', 0),
     777(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:35', 'Area', 'Oblasti', '', 0),
     778(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:16', 'Interface', 'Rozhraní zařízení', '', 0),
     779(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:41', 'Asset', 'Majetek', '', 0),
     780(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:20', 'Tariff', 'Tarify', '', 0),
     781(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:46', 'MemberReport', 'Hlášení členů', '', 0),
     782(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:19:58', 'BankAccount', 'Bankovní účty', '', 0),
     783(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:25', 'SystemType', 'Definice typů', '', 0),
     784(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:28', 'FinanceTransaction', 'Platební operace', '', 0),
     785(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:11:18', 'SystemList', 'Definice tabulek', '', 0),
     786(14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:33', 'SystemListItem', 'Definice položek formulářů', '', 0),
     787(15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:39', 'UserOnline', 'Přihlášení uživatelé', '', 0),
     788(16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-21 08:20:48', 'History', 'Historie záznamů', '', 0),
     789(34, 20, 5, '2008-10-13 12:12:05', NULL, '2008-10-22 08:15:01', '2008-10-21 08:20:54', 'SystemLog', 'Deník změn', '', 0),
     790(26, 17, 5, '2008-10-12 18:38:17', '0000-00-00 00:00:00', '2008-10-22 08:15:01', '2008-10-13 12:16:59', 'Test', 'Testovací tabulka', '', 0),
     791(33, 19, 5, '2008-10-13 10:19:34', NULL, '2008-10-22 08:15:01', '2008-10-21 08:20:58', 'Permission', 'Oprávnění', '', 0),
     792(32, 18, 5, '2008-10-13 09:53:03', NULL, '2008-10-22 08:15:01', '2008-10-21 08:21:03', 'PermissionGroup', 'Skupiny oprávnění', '', 0),
     793(35, 21, 5, '2008-10-21 07:46:53', NULL, '2008-10-22 08:15:01', '2008-10-21 08:06:34', 'Menu', 'Nabídka', '', 0),
     794(36, 21, 5, '2008-10-21 08:06:34', NULL, '2008-10-22 08:15:01', '2008-10-21 08:07:02', 'dd', 'Nabídka', '', 0),
     795(37, 21, 5, '2008-10-21 08:07:02', NULL, '2008-10-22 08:15:01', '2008-10-21 08:07:20', 'dd', 'Nabídka', '', 0),
     796(38, 21, 5, '2008-10-21 08:07:20', NULL, '2008-10-22 08:15:01', '2008-10-21 08:10:18', 'Menu', 'Nabídka', '', 0),
     797(39, 21, 5, '2008-10-21 08:10:18', NULL, '2008-10-22 08:15:01', '2008-10-21 08:10:28', 'Menuf', 'Nabídka', '', 0),
     798(40, 21, 5, '2008-10-21 08:10:28', NULL, '2008-10-22 08:15:01', '2008-10-21 08:10:38', 'Menu', 'Nabídka', '', 0),
     799(41, 21, 5, '2008-10-21 08:10:38', NULL, '2008-10-22 08:15:01', '2008-10-21 08:21:07', 'SystemMenu', 'Nabídka', '', 0),
     800(42, 13, 5, '2008-10-21 08:11:18', NULL, '2008-10-22 08:15:01', '2008-10-21 08:19:13', 'SystemList', 'Definice seznamů', '', 0),
     801(43, 13, 5, '2008-10-21 08:19:13', NULL, '2008-10-22 08:15:01', NULL, 'SystemList', 'Definice seznamů', '', 1),
     802(44, 1, 5, '2008-10-21 08:19:21', NULL, '2008-10-22 08:15:01', '2008-10-21 08:55:47', 'User', 'Uživatelé', '', 1),
     803(45, 3, 5, '2008-10-21 08:19:30', NULL, '2008-10-22 08:15:01', NULL, 'Subject', 'Finanční subjekty', '', 2),
     804(46, 5, 5, '2008-10-21 08:19:35', NULL, '2008-10-22 08:15:01', NULL, 'Area', 'Oblasti', '', 2),
     805(47, 7, 5, '2008-10-21 08:19:41', NULL, '2008-10-22 08:15:01', NULL, 'Asset', 'Majetek', '', 2),
     806(48, 9, 5, '2008-10-21 08:19:46', NULL, '2008-10-22 08:15:01', '2008-10-21 08:56:03', 'MemberReport', 'Hlášení členů', '', 1),
     807(49, 10, 5, '2008-10-21 08:19:58', NULL, '2008-10-22 08:15:01', NULL, 'BankAccount', 'Bankovní účty', '', 2),
     808(50, 2, 5, '2008-10-21 08:20:07', NULL, '2008-10-22 08:15:01', NULL, 'Host', 'Zařízení', '', 2),
     809(51, 4, 5, '2008-10-21 08:20:12', NULL, '2008-10-22 08:15:01', NULL, 'Member', 'Členové sítě', '', 2),
     810(52, 6, 5, '2008-10-21 08:20:16', NULL, '2008-10-22 08:15:01', NULL, 'Interface', 'Rozhraní zařízení', '', 2),
     811(53, 8, 5, '2008-10-21 08:20:20', NULL, '2008-10-22 08:15:01', NULL, 'Tariff', 'Tarify', '', 2),
     812(54, 11, 5, '2008-10-21 08:20:25', NULL, '2008-10-22 08:15:01', NULL, 'SystemType', 'Definice typů', '', 1),
     813(55, 12, 5, '2008-10-21 08:20:28', NULL, '2008-10-22 08:15:01', NULL, 'FinanceTransaction', 'Platební operace', '', 2),
     814(56, 14, 5, '2008-10-21 08:20:33', NULL, '2008-10-22 08:15:01', '2008-10-21 13:20:18', 'SystemListItem', 'Definice položek formulářů', '', 1),
     815(57, 15, 5, '2008-10-21 08:20:39', NULL, '2008-10-22 08:15:01', '2008-10-21 08:56:29', 'UserOnline', 'Přihlášení uživatelé', '', 1),
     816(58, 16, 5, '2008-10-21 08:20:48', NULL, '2008-10-22 08:15:01', '2008-10-21 08:38:31', 'History', 'Historie záznamů', '', 2),
     817(59, 20, 5, '2008-10-21 08:20:54', NULL, '2008-10-22 08:15:01', NULL, 'SystemLog', 'Deník změn', '', 1),
     818(60, 19, 5, '2008-10-21 08:20:58', NULL, '2008-10-22 08:15:01', '2008-10-21 08:56:11', 'Permission', 'Oprávnění', '', 1),
     819(61, 18, 5, '2008-10-21 08:21:03', NULL, '2008-10-22 08:15:01', '2008-10-21 08:56:22', 'PermissionGroup', 'Skupiny oprávnění', '', 1),
     820(62, 21, 5, '2008-10-21 08:21:07', NULL, '2008-10-22 08:15:01', NULL, 'SystemMenu', 'Nabídka', '', 1),
     821(63, 1, 5, '2008-10-21 08:55:47', NULL, '2008-10-22 08:15:01', NULL, 'User', 'Uživatelé', '', 3),
     822(64, 9, 5, '2008-10-21 08:56:03', NULL, '2008-10-22 08:15:01', NULL, 'MemberReport', 'Hlášení členů', '', 2),
     823(65, 19, 5, '2008-10-21 08:56:11', NULL, '2008-10-22 08:15:01', '2008-10-21 13:19:58', 'Permission', 'Oprávnění', '', 3),
     824(66, 18, 5, '2008-10-21 08:56:22', NULL, '2008-10-22 08:15:01', NULL, 'PermissionGroup', 'Skupiny oprávnění', '', 3),
     825(67, 15, 5, '2008-10-21 08:56:29', NULL, '2008-10-22 08:15:01', NULL, 'UserOnline', 'Přihlášení uživatelé', '', 3),
     826(68, 19, 5, '2008-10-21 13:19:58', NULL, '2008-10-22 08:15:01', NULL, 'Permission', 'Oprávnění', '', 0),
     827(69, 14, 5, '2008-10-21 13:20:18', NULL, '2008-10-22 08:15:01', NULL, 'SystemListItem', 'Definice položek formulářů', '', 0),
     828(70, 22, 28, '2008-10-21 14:38:25', NULL, '2008-10-22 08:15:01', '2008-10-21 14:38:44', 'NewsItem', 'Aktuality', '', 0),
     829(71, 22, 28, '2008-10-21 14:38:44', NULL, '2008-10-22 08:15:01', '2008-10-21 14:39:54', 'NewsItem', 'Aktuality', '', 4),
     830(72, 23, 28, '2008-10-21 14:39:36', NULL, '2008-10-22 08:15:01', NULL, 'NewsGroup', 'Skupiny aktualit', '', 4),
     831(73, 22, 28, '2008-10-21 14:39:54', NULL, '2008-10-22 08:15:01', NULL, 'NewsItem', 'Aktuality', '', 0),
     832(74, 24, 28, '2008-10-21 16:06:09', NULL, '2008-10-22 08:15:01', NULL, 'CableTV', 'Kabelová televize', '', 4),
     833(75, 25, 5, '2008-10-22 12:49:17', NULL, '2008-10-22 12:49:17', '2008-10-22 12:50:21', 'Test', 'test', '', 0),
     834(76, 26, 5, '2008-10-22 12:50:58', NULL, '2008-10-22 12:50:58', '2008-10-27 13:52:40', 'test', 'test', '', 0),
     835(77, 27, 5, '2008-10-22 12:52:24', NULL, '2008-10-22 12:52:24', '2008-10-27 13:52:34', 'test', 'test', '', 0),
     836(78, 28, 5, '2008-10-27 10:35:54', NULL, '2008-10-27 10:35:54', NULL, 'SystemTypeParameter', 'Parametr typu', '', 0),
     837(79, 29, 5, '2008-10-27 11:03:03', NULL, '2008-10-27 11:03:03', '2008-10-27 13:55:21', 'SystemTypeParameter', 'Parametr typu', '', 0),
     838(80, 30, 5, '2008-10-27 12:05:17', NULL, '2008-10-27 12:05:17', '2008-10-27 12:18:24', 'SystemTypeParameter', 'Parametr typu', '', 0),
     839(81, 31, 5, '2008-10-27 12:11:07', NULL, '2008-10-27 12:11:07', '2008-10-27 12:18:22', 'SystemTypeParameter', 'Parametr typu', '', 0),
     840(82, 32, 5, '2008-10-27 13:55:28', NULL, '2008-10-27 13:55:28', '2008-10-27 13:55:49', 'dd', 'dd', '', 0),
     841(83, 33, 5, '2008-10-27 14:10:43', NULL, '2008-10-27 14:10:43', NULL, 'SystemEnumerationState', 'Stavy výčtů', '', 0);
     842
     843-- --------------------------------------------------------
     844
     845--
     846-- Struktura tabulky `SystemListItem`
     847--
     848
     849CREATE TABLE IF NOT EXISTS `SystemListItem` (
     850  `Id` int(11) NOT NULL auto_increment,
     851  `ItemId` int(11) NOT NULL,
     852  `Author` int(11) NOT NULL,
     853  `ValidTimeFrom` datetime default NULL,
     854  `ValidTimeTo` datetime default NULL,
     855  `CreationTime` datetime default NULL,
     856  `DeletionTime` datetime default NULL,
     857  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     858  `TextBefore` varchar(255) collate utf8_czech_ci NOT NULL,
     859  `TextAfter` varchar(255) collate utf8_czech_ci NOT NULL,
     860  `Type` varchar(255) collate utf8_czech_ci NOT NULL,
     861  `Help` varchar(255) collate utf8_czech_ci NOT NULL,
     862  `Default` varchar(255) collate utf8_czech_ci NOT NULL,
     863  `Required` tinyint(1) NOT NULL default '1',
     864  `Editable` tinyint(1) NOT NULL default '1',
     865  `VisibleInList` tinyint(1) NOT NULL default '0',
     866  `VisibleInPointer` tinyint(1) NOT NULL default '0',
     867  `List` int(11) NOT NULL,
     868  PRIMARY KEY  (`Id`)
     869) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=196 ;
     870
     871--
     872-- Vypisuji data pro tabulku `SystemListItem`
     873--
     874
     875INSERT INTO `SystemListItem` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `TextBefore`, `TextAfter`, `Type`, `Help`, `Default`, `Required`, `Editable`, `VisibleInList`, `VisibleInPointer`, `List`) VALUES
     876(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'FirstName', 'Jméno', '', '3', 'Zadejte jméno', '', 1, 1, 1, 1, 1),
     877(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SecondName', 'Příjmení', '', '3', 'Zadejte příjmení', '', 1, 1, 1, 1, 1),
     878(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Email', 'E-mail', '', '3', 'Zadejte emailovou adresu', '', 1, 1, 1, 0, 1),
     879(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ICQ', 'ICQ', '', '1', 'Zadejte kontaktní číslo textového komunikačního programu ICQ.', '', 0, 1, 0, 0, 1),
     880(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Sex', 'Pohlaví', '', '5', 'Vyberte pohlaví osoby', '', 0, 1, 0, 0, 1),
     881(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'BirthDay', 'Datum narození', '', '2', 'Vyberte datum narození', '', 0, 1, 0, 0, 1),
     882(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DomainName', 'Doménové jméno', '', '3', 'Zadejte jméno počítače v doméně', '', 1, 1, 1, 1, 2),
     883(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', 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),
     884(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', 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),
     885(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'PublicIPAddress', 'Veřejná IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci Internetu', '', 0, 1, 1, 0, 2),
     886(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'LastOnlineDate', 'Naposledy online', '', '2', 'Čas posledního úspěšného měření dostupnosti počítače', '', 0, 0, 0, 0, 2),
     887(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', 'Jméno subjektu', '', 1, 1, 1, 1, 3),
     888(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'AddressStreet', 'Ulice', '', '3', 'Ulice', '', 1, 1, 1, 0, 3),
     889(14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'AddressTown', 'Město', '', '3', 'Město', '', 1, 1, 1, 0, 3),
     890(15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'AddressZIP', 'PSČ', '', '3', '', '', 1, 1, 1, 0, 3),
     891(16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'IC', 'IČ', '', '3', 'Identifikační číslo subjektu', '', 0, 1, 0, 0, 3),
     892(17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DIC', 'DIČ', '', '3', 'Daňové identifikační číslo', '', 0, 1, 0, 0, 3),
     893(18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 10:01:03', 'MapPositionX', 'Horizontálně pozice', '', '1', 'Vodorovná pozice na mapě', '', 0, 1, 0, 0, 4),
     894(19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 10:00:27', 'MapPositionY', 'Vertikální pozice', '', '1', 'Svislá pozice na mapě', '', 0, 1, 0, 0, 4),
     895(20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MembershipDate', 'Začátek členství', '', '2', 'Datum přípojení do sítě', '', 0, 1, 0, 0, 4),
     896(21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'FamilyMemberCount', 'Osob v rodině', '', '1', 'Počet osob v připojené domácnosti', '', 0, 1, 0, 0, 4),
     897(22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ResponsibleUser', 'Zodpovědný uživatel', '', '37', '', '', 1, 1, 1, 1, 4),
     898(23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Subject', 'Subjekt', '', '33', '', '', 1, 1, 0, 0, 4),
     899(24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Druh', '', '7', '', '1', 0, 1, 1, 0, 2),
     900(25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Phone', 'Telefón', '', '3', '', '', 0, 1, 0, 0, 1),
     901(26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Notice', 'Poznámka', '', '3', '', '', 0, 1, 0, 0, 3),
     902(27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MemberState', 'Stav připojení', '', '6', '', '', 1, 1, 1, 0, 4),
     903(28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'HostList', 'Registrované zařízení', '', '23', '', '', 0, 1, 0, 0, 4),
     904(29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 5),
     905(30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'NetworkIPAddress', 'Adresa sítě', '', '3', '', '', 1, 1, 1, 0, 5),
     906(31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'IPAddressMask', 'Maska sítě', '', '3', '', '', 1, 1, 1, 0, 5),
     907(32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DNSPrimary', 'Primární DNS server', '', '3', '', '', 0, 1, 0, 0, 5),
     908(33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DNSSecondary', 'Sukundární DNS server', '', '3', '', '', 0, 1, 0, 0, 5),
     909(34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DHCP', 'DHCP server', '', '3', '', '', 0, 1, 0, 0, 5),
     910(35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Domain', 'Doména', '', '3', '', '', 0, 1, 0, 0, 5),
     911(36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Workgroup', 'Pracovní skupina', '', '3', '', '', 0, 1, 0, 0, 5),
     912(37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'WINS', 'WINS server', '', '3', '', '', 0, 1, 0, 0, 5),
     913(38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 6),
     914(39, 39, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Typ', '', '8', '', '', 1, 1, 1, 0, 6),
     915(40, 40, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Host', 'Zařízení', '', '31', 'Vyberte zařízení, ke kterému patří toto rozhraní.', '', 1, 1, 1, 0, 6),
     916(41, 41, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ParentHost', 'Připojeno k bodu', '', '31', '', '', 1, 1, 1, 0, 6),
     917(42, 42, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Interface', 'Rozhraní', '', '24', '', '', 0, 1, 0, 0, 2),
     918(43, 43, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MAC', 'Fyzická adresa', '', '3', 'Zadejte fyzickou adresu síťové karty též nazývanou MAC adresa.', '', 1, 1, 0, 0, 6),
     919(44, 44, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ParentHost', 'Nadřazený uzel', '', '31', '', '', 0, 1, 0, 0, 2),
     920(45, 45, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SubHostList', 'Připojené zařízení', '', '38', 'Seznam podřízených zařízení ve virtuálním stromu propojení.', '', 0, 1, 0, 0, 2),
     921(46, 46, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 7),
     922(47, 47, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeEnlistment', 'Čas zařazení', '', '2', '', '', 1, 1, 0, 0, 7),
     923(48, 48, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeElimination', 'Čas vyřazení', '', '2', '', '', 0, 1, 0, 0, 7),
     924(49, 49, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Price', 'Pořizovací cena', '', '1', '', '', 1, 1, 1, 0, 7),
     925(50, 50, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'State', 'Stav', '', '9', '', '', 1, 1, 1, 0, 7),
     926(51, 51, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SerialNumber', 'Sériové číslo', '', '3', '', '', 0, 1, 0, 0, 7),
     927(52, 52, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'PurcheasedFrom', 'Zakoupeno od', '', '33', '', '', 0, 1, 0, 0, 7),
     928(53, 53, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'PurcheasedAsset', 'Nakoupené zboží', '', '21', '', '', 0, 1, 0, 0, 3),
     929(54, 54, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Member', 'Člen', '', '32', '', '', 0, 1, 0, 0, 1),
     930(113, 113, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 10:17:25', 'ValidFromTime', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 4),
     931(57, 57, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Price', 'Cena', '', '1', '', '', 1, 1, 1, 0, 8),
     932(56, 56, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 8),
     933(58, 58, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MinUploadSpeed', 'Minimální odchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8),
     934(59, 59, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MaxUploadSpeed', 'Maximální odchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8),
     935(60, 60, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MinDownloadSpeed', 'Minimální příchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8),
     936(61, 61, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MaxDownloadSpeed', 'Max příchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8),
     937(62, 62, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'UserName', 'Uživatelské jméno', '', '3', '', '', 1, 1, 0, 0, 1),
     938(63, 63, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Password', 'Heslo', '', '15', '', '', 1, 1, 0, 0, 1),
     939(64, 64, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Member', 'Členové', '', '26', '', '', 0, 1, 0, 0, 8),
     940(65, 65, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Tariff', 'Tarif', '', '36', '', '', 1, 1, 1, 0, 4),
     941(66, 66, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Member', 'Vlastník', '', '32', '', '', 0, 1, 0, 0, 2),
     942(67, 67, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'WWW', 'Internetové stránky', '', '18', '', '', 0, 1, 0, 0, 3),
     943(68, 68, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Text', 'Text zprávy', '', '3', '', '', 1, 1, 1, 1, 9),
     944(69, 69, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Date', 'Datum', '', '2', '', '', 1, 1, 1, 0, 9),
     945(70, 70, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Member', 'Člen', '', '32', '', '', 1, 1, 1, 0, 9),
     946(71, 71, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Typ zprávy', '', '10', '', '', 1, 1, 1, 0, 9),
     947(72, 72, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ReportList', 'Záznamy', '', '27', '', '', 0, 1, 0, 0, 4),
     948(73, 73, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Creator', 'Vložil', '', '37', '', '', 1, 1, 0, 0, 9),
     949(74, 74, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 10),
     950(75, 75, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'BankName', 'Jméno banky', '', '3', '', '', 1, 1, 0, 0, 10),
     951(76, 76, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Number', 'Identifikační číslo', '', '3', '', '', 1, 1, 1, 0, 10),
     952(77, 77, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'BankCode', 'Kód banky', '', '3', '', '', 1, 1, 1, 0, 10),
     953(78, 78, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'User', 'Registroval', '', '37', '', '', 0, 1, 0, 0, 10),
     954(79, 79, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Typ', '', '11', '', '', 1, 1, 1, 0, 10),
     955(80, 80, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'MemberList', 'Členství', '', '25', '', '', 0, 1, 0, 0, 3),
     956(81, 81, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', 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),
     957(82, 82, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ParentType', 'Rodičovský typ', '', '35', '', '', 1, 1, 1, 0, 11),
     958(83, 83, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Parameters', 'Parametry typu', '', '3', '', 'Parametry zadávejte jako řetězce oddělené symblem "|".', 0, 1, 0, 0, 11),
     959(84, 84, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'System', 'Systémový', '', '4', '', '0', 1, 1, 0, 0, 11),
     960(88, 88, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 11),
     961(89, 89, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 12),
     962(90, 90, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Amount', 'Částka', '', '16', '', '', 1, 1, 1, 0, 12),
     963(91, 91, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Time', 'Čas', '', '2', '', '', 1, 1, 1, 0, 12),
     964(92, 92, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SourceSubject', 'Zdrojový subjekt', '', '33', '', '', 1, 1, 1, 0, 12),
     965(93, 93, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TargetSubject', 'Cílový subjekt', '', '33', '', '', 1, 1, 1, 0, 12),
     966(94, 94, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-19 20:08:36', 'Type', 'Type', '', '15', '', '', 1, 1, 0, 0, 12),
     967(95, 95, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'InsertedByUser', 'Vložil', '', '37', '', '', 0, 0, 0, 0, 12),
     968(96, 96, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'DbDataType', 'Datový typ v databázi', '', '3', '', '', 1, 1, 0, 0, 11),
     969(97, 97, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', 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),
     970(98, 98, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Title', 'Název seznamu', '', '3', 'Zadejte nadpis seznamu.', '', 1, 1, 1, 1, 13),
     971(99, 99, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 08:53:27', 'VisibleInMenu', 'Viditelné v menu', '', '4', 'Zobrazovat tuto tabulku v hlavním menu', '', 1, 1, 0, 0, 13),
     972(100, 100, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Items', 'Položky', '', '28', 'Definujte potřebné položky pro seznam.', '', 1, 1, 0, 0, 13),
     973(101, 101, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Jméno sloupce', '', '3', 'Jméno sloupce tabulky v databázi', '', 1, 1, 1, 0, 14),
     974(102, 102, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TextBefore', 'Text před hodnotou', '', '3', 'Oznčení položky umístěné před zobrazenou hodnotou.', '', 1, 1, 1, 1, 14),
     975(103, 103, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TextAfter', 'Text za hodnotou', '', '3', 'Tento text většinou obsahuje jednotky použité veličiny.', '', 1, 1, 0, 0, 14),
     976(104, 104, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Type', 'Type', '', '35', 'Typ dat položky', '', 1, 1, 1, 0, 14),
     977(105, 105, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Help', 'Nápověda', '', '3', 'Textová nápověda zobrazovaná jako pomůcka při editaci hodnoty.', '', 1, 1, 0, 0, 14),
     978(106, 106, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Required', 'Požadováno', '', '4', 'Určuje zda je nutné danou položku vyplnit.', '', 1, 1, 0, 0, 14),
     979(107, 107, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', 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),
     980(108, 108, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'VisibleInList', 'Viditelné v seznamu', '', '4', 'Určuje viditelnost této položky v seznamu', '', 1, 1, 0, 0, 14),
     981(109, 109, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', 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),
     982(110, 110, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Area', 'Umístění', '', '30', 'Vyberte oblast, do které toto zařízení patří.', '', 0, 1, 0, 0, 2),
     983(111, 111, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'HostList', 'Seznam zařízení', '', '22', '', '', 0, 1, 0, 0, 5),
     984(112, 112, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'UserList', 'Uživatelů', '', '29', '', '', 0, 1, 0, 0, 4),
     985(114, 114, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-21 10:17:36', 'ValidToTime', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 4),
     986(115, 115, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'User', 'Uživatel', '', '37', '', '', 1, 0, 1, 1, 15),
     987(116, 116, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', '2008-10-22 08:40:51', 'LoginTime', 'Čas přihlášení', '', '2', '', '', 0, 0, 0, 0, 15),
     988(117, 117, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ActivityTime', 'Naposledy aktivní', '', '2', '', '', 0, 0, 0, 0, 15),
     989(118, 118, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'SessionId', 'Identifikace spojení', '', '3', '', '', 0, 0, 0, 0, 15),
     990(119, 119, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'IpAddress', 'IP adresa', '', '3', '', '', 0, 0, 0, 0, 15),
     991(120, 120, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'HostName', 'Jméno počítače', '', '3', '', '', 0, 0, 1, 0, 15),
     992(121, 121, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Locked', 'Zamčeno', '', '4', '', '', 0, 0, 0, 0, 1),
     993(122, 122, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'RegistrationTime', 'Čas registrace', '', '2', '', '', 0, 0, 0, 0, 1),
     994(123, 123, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'LastLoginTime', 'Čas posledního přihlášení', '', '2', '', '', 0, 0, 0, 0, 1),
     995(124, 124, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'LastIpAddress', 'Poslední IP adresa', '', '3', '', '', 0, 0, 0, 0, 1),
     996(125, 125, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Author', 'Autor', '', '37', '', '', 1, 0, 0, 0, 16),
     997(126, 126, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeCreation', 'Čas vytvoření', '', '2', '', '', 1, 0, 0, 0, 16),
     998(127, 127, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeValidFrom', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 16),
     999(128, 128, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'TimeValidTo', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 16),
     1000(129, 129, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'ListId', 'Odkazovaná tabulka', '', '34', '', '', 1, 1, 0, 0, 16),
     1001(130, 130, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'PermanentId', 'Trvalá identifikace', '', '1', '', '', 1, 1, 0, 0, 16),
     1002(133, 132, 5, '2008-10-12 17:48:27', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'List', 'Rodičovský seznam', '', '34', '', '', 1, 0, 0, 0, 14),
     1003(142, 133, 5, '2008-10-12 18:39:09', '0000-00-00 00:00:00', '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 26),
     1004(143, 134, 5, '2008-10-13 09:54:15', NULL, '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 18),
     1005(144, 135, 5, '2008-10-13 10:04:22', NULL, '2008-10-22 08:15:09', NULL, 'PermissionGroup', 'Oprávnění', '', '39', '', '', 1, 1, 0, 0, 1),
     1006(145, 136, 5, '2008-10-13 10:20:19', NULL, '2008-10-22 08:15:09', NULL, 'List', 'Seznam', '', '34', '', '', 1, 1, 1, 0, 19),
     1007(146, 137, 5, '2008-10-13 10:24:59', NULL, '2008-10-22 08:15:09', NULL, 'Item', 'Položka', '', '1', '', '', 0, 1, 1, 0, 19),
     1008(147, 138, 5, '2008-10-13 10:26:06', NULL, '2008-10-22 08:15:09', NULL, 'Right', 'Práva', '', '14', 'Žádné|Čtení|Čtení i zápis', '', 1, 1, 1, 1, 19),
     1009(148, 139, 5, '2008-10-13 10:39:16', NULL, '2008-10-22 08:15:09', NULL, 'PermissionGroup', 'Rodičovská skupina', '', '39', '', '', 0, 1, 0, 0, 19),
     1010(149, 140, 5, '2008-10-13 10:41:38', NULL, '2008-10-22 08:15:09', NULL, 'PermissionList', 'Oprávnění', '', '41', '', '', 0, 1, 0, 0, 18),
     1011(150, 138, 5, '2008-10-13 10:43:38', NULL, '2008-10-22 08:15:09', NULL, 'Right', 'Práva', '', '42', 'Žádné|Čtení|Čtení i zápis', '', 1, 1, 1, 1, 19),
     1012(151, 141, 5, '2008-10-13 12:06:35', NULL, '2008-10-22 08:15:09', NULL, 'UserList', 'Zařazení uživatelé', '', '43', '', '', 0, 0, 0, 0, 18),
     1013(152, 142, 5, '2008-10-13 12:13:06', NULL, '2008-10-22 08:15:09', '2008-10-21 08:53:00', 'System', 'Systémový', '', '4', '', '', 0, 0, 0, 0, 13),
     1014(153, 143, 5, '2008-10-13 12:14:34', NULL, '2008-10-22 08:15:09', NULL, 'User', 'Uživatel', '', '37', '', '', 0, 0, 1, 1, 20),
     1015(154, 144, 5, '2008-10-13 12:15:22', NULL, '2008-10-22 08:15:09', NULL, 'List', 'Seznam', '', '34', '', '', 0, 0, 1, 0, 20),
     1016(155, 145, 5, '2008-10-13 12:15:40', NULL, '2008-10-22 08:15:09', NULL, 'Item', 'Položka', '', '1', '', '', 0, 0, 1, 0, 20),
     1017(156, 146, 5, '2008-10-13 12:17:36', NULL, '2008-10-22 08:15:09', NULL, 'Action', 'Akce', '', '44', '', '', 0, 0, 1, 0, 20),
     1018(157, 147, 5, '2008-10-14 06:53:58', NULL, '2008-10-22 08:15:09', NULL, 'CreationTime', 'Čas vytvoření', '', '2', '', '', 0, 0, 1, 0, 20),
     1019(158, 147, 5, '2008-10-14 07:21:08', NULL, '2008-10-22 08:15:09', '2008-10-19 19:19:25', 'CreationTime', 'Čas vytvoření', '', '46', '', '', 0, 0, 1, 0, 20),
     1020(159, 148, 5, '2008-10-14 07:51:52', NULL, '2008-10-22 08:15:09', '2008-10-19 20:09:33', 'Document', 'Doklad', '', '47', '', '', 0, 1, 0, 0, 12),
     1021(160, 147, 5, '2008-10-19 19:19:25', NULL, '2008-10-22 08:15:09', NULL, 'CreationTime', 'Čas vytvoření', '', '45', '', '', 0, 0, 1, 0, 20),
     1022(161, 94, 5, '2008-10-19 20:08:36', NULL, '2008-10-22 08:15:09', NULL, 'Type', 'Type', '', '17', '', '', 1, 1, 0, 0, 12),
     1023(162, 148, 5, '2008-10-19 20:09:33', NULL, '2008-10-22 08:15:09', NULL, 'Document', 'Doklad', '', '46', '', '', 0, 1, 0, 0, 12),
     1024(163, 149, 5, '2008-10-21 07:47:49', NULL, '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 21),
     1025(164, 150, 5, '2008-10-21 07:48:56', NULL, '2008-10-22 08:15:09', '2008-10-21 07:52:52', 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 21),
     1026(165, 151, 5, '2008-10-21 07:51:35', NULL, '2008-10-22 08:15:09', '2008-10-21 07:53:04', 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 21),
     1027(166, 152, 5, '2008-10-21 08:14:17', NULL, '2008-10-22 08:15:09', NULL, 'Menu', 'Menu', '', '47', '', '', 1, 1, 0, 0, 13),
     1028(167, 153, 5, '2008-10-21 08:23:20', NULL, '2008-10-22 08:15:09', NULL, 'SystemListItems', 'Položky menu', '', '48', '', '', 0, 0, 0, 0, 21),
     1029(168, 18, 5, '2008-10-21 10:01:03', NULL, '2008-10-22 08:15:09', NULL, 'GPS', 'GPS pozice', '', '49', 'Pozice na mapě', '', 0, 1, 0, 0, 4),
     1030(169, 154, 28, '2008-10-21 14:40:20', NULL, '2008-10-22 08:15:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 23),
     1031(170, 155, 28, '2008-10-21 14:41:01', NULL, '2008-10-22 08:15:09', NULL, 'Title', 'Titulek', '', '3', '', '', 1, 1, 1, 1, 22),
     1032(171, 156, 28, '2008-10-21 14:42:05', NULL, '2008-10-22 08:15:09', NULL, 'Content', 'Obsah sdělení', '', '3', '', '', 1, 1, 0, 0, 22),
     1033(172, 157, 28, '2008-10-21 14:43:30', NULL, '2008-10-22 08:15:09', '2008-10-21 15:55:29', 'NewsGroup', 'Skupina', '', '50', '', '', 1, 1, 1, 0, 22),
     1034(173, 158, 28, '2008-10-21 14:43:57', NULL, '2008-10-22 08:15:09', NULL, 'Enclosure', 'Příloha', '', '46', '', '', 0, 1, 0, 0, 22),
     1035(174, 159, 28, '2008-10-21 14:49:29', NULL, '2008-10-22 08:15:09', NULL, 'NewsItems', 'Aktuality', '', '51', '', '', 0, 0, 0, 0, 23),
     1036(175, 160, 28, '2008-10-21 15:54:56', NULL, '2008-10-22 08:15:09', '2008-10-21 15:56:41', 'Group', 'Skupina', '', '50', '', '', 1, 1, 0, 0, 22),
     1037(176, 160, 28, '2008-10-21 15:56:41', NULL, '2008-10-22 08:15:09', NULL, 'NewsGroup', 'Skupina', '', '50', '', '', 1, 1, 0, 0, 22),
     1038(177, 161, 28, '2008-10-21 16:06:44', NULL, '2008-10-22 08:15:09', NULL, 'Name', 'Jméno kanálu', '', '3', '', '', 1, 1, 1, 1, 24),
     1039(178, 162, 28, '2008-10-21 16:07:14', NULL, '2008-10-22 08:15:09', NULL, 'Frequency', 'Frekvence', '', '1', '', '', 1, 1, 1, 0, 24),
     1040(179, 163, 28, '2008-10-21 16:07:55', NULL, '2008-10-22 08:15:09', NULL, 'Norm', 'Norma', '', '3', '', '', 1, 1, 1, 0, 24),
     1041(180, 164, 28, '2008-10-21 16:08:16', NULL, '2008-10-22 08:15:09', '2008-10-21 16:09:55', 'Homepage', 'Webové stránky', '', '3', '', '', 0, 1, 0, 0, 24),
     1042(181, 165, 28, '2008-10-21 16:08:34', NULL, '2008-10-22 08:15:09', NULL, 'Language', 'Jazyk', '', '3', '', '', 0, 1, 1, 0, 24),
     1043(182, 166, 28, '2008-10-21 16:08:55', NULL, '2008-10-22 08:15:09', NULL, 'ShortName', 'Zkratka', '', '3', '', '', 1, 1, 0, 0, 24),
     1044(183, 164, 28, '2008-10-21 16:09:55', NULL, '2008-10-22 08:15:09', NULL, 'Homepage', 'Webové stránky', '', '18', '', '', 0, 1, 0, 0, 24),
     1045(185, 116, 28, '2008-10-22 08:40:51', NULL, '2008-10-22 08:40:51', '2008-10-22 08:43:30', 'LoginTime', 'Čas přihlášení', '', '45', '', '', 0, 0, 0, 0, 15),
     1046(186, 116, 5, '2008-10-22 08:43:30', NULL, '2008-10-22 08:43:30', NULL, 'LoginTime', 'Čas přihlášení', '', '45', '', '', 0, 0, 0, 0, 15),
     1047(187, 167, 5, '2008-10-27 13:56:31', NULL, '2008-10-27 13:56:31', NULL, 'Name', 'Jméno parameteru', '', '3', '', '', 1, 1, 1, 1, 28),
     1048(188, 168, 5, '2008-10-27 13:57:19', NULL, '2008-10-27 13:57:19', NULL, 'Type', 'Typ', '', '35', '', '', 1, 1, 1, 0, 28),
     1049(189, 169, 5, '2008-10-27 14:01:06', NULL, '2008-10-27 14:01:06', '2008-10-27 14:01:45', 'Type', 'Typ', '', '35', '', '', 1, 1, 0, 0, 28),
     1050(190, 170, 5, '2008-10-27 14:02:10', NULL, '2008-10-27 14:02:10', NULL, 'ParentType', 'Rodičovský typ', '', '35', '', '', 1, 1, 0, 0, 28),
     1051(191, 171, 5, '2008-10-27 14:03:32', NULL, '2008-10-27 14:03:32', NULL, 'ParameterList', 'Seznam parametrů', '', '52', '', '', 1, 1, 0, 0, 11),
     1052(192, 172, 5, '2008-10-27 14:08:15', NULL, '2008-10-27 14:08:15', '2008-10-27 14:08:44', 'Description', 'Popis', '', '3', '', '', 1, 1, 0, 0, 28),
     1053(193, 172, 5, '2008-10-27 14:08:44', NULL, '2008-10-27 14:08:44', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 28),
     1054(194, 173, 5, '2008-10-27 14:12:09', NULL, '2008-10-27 14:12:09', NULL, 'Name', 'Název', '', '3', '', '', 1, 1, 1, 1, 33),
     1055(195, 174, 5, '2008-10-27 14:13:05', NULL, '2008-10-27 14:13:05', NULL, 'ParentParameter', 'Rodičovský parameter', '', '52', '', '', 1, 1, 0, 0, 33);
     1056
     1057-- --------------------------------------------------------
     1058
     1059--
     1060-- Struktura tabulky `SystemLog`
     1061--
     1062
     1063CREATE TABLE IF NOT EXISTS `SystemLog` (
     1064  `Id` int(11) NOT NULL auto_increment,
     1065  `ItemId` int(11) NOT NULL,
     1066  `Author` int(11) NOT NULL,
     1067  `ValidTimeFrom` datetime default NULL,
     1068  `ValidTimeTo` datetime default NULL,
     1069  `CreationTime` datetime default NULL,
     1070  `DeletionTime` datetime default NULL,
     1071  `User` int(11) NOT NULL,
     1072  `List` int(11) NOT NULL,
     1073  `Item` int(11) NOT NULL,
     1074  `Action` int(11) NOT NULL,
     1075  PRIMARY KEY  (`Id`)
     1076) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=293 ;
     1077
     1078--
     1079-- Vypisuji data pro tabulku `SystemLog`
     1080--
     1081
     1082INSERT INTO `SystemLog` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `User`, `List`, `Item`, `Action`) VALUES
     1083(1, 1, 5, '2008-10-13 12:21:11', NULL, '2008-10-13 12:21:11', NULL, 8, 34, 0, 0),
     1084(2, 2, 5, '2008-10-13 12:24:46', NULL, '2008-10-13 12:24:46', NULL, 13, 15, 12, 0),
     1085(3, 3, 0, '2008-10-13 12:50:52', NULL, '2008-10-13 12:50:52', NULL, 5, 0, 10, 0),
     1086(4, 4, 0, '2008-10-13 12:58:32', NULL, '2008-10-13 12:58:32', NULL, 5, 0, 11, 0),
     1087(5, 5, 5, '2008-10-13 13:00:34', NULL, '2008-10-13 13:00:34', NULL, 5, 33, 12, 0),
     1088(6, 6, 5, '2008-10-13 13:04:26', NULL, '2008-10-13 13:04:26', NULL, 5, 33, 13, 0),
     1089(7, 7, 5, '2008-10-13 13:17:35', NULL, '2008-10-13 13:17:35', NULL, 5, 33, 10, 0),
     1090(8, 8, 5, '2008-10-13 13:17:38', NULL, '2008-10-13 13:17:38', NULL, 5, 33, 8, 0),
     1091(9, 9, 5, '2008-10-13 13:17:40', NULL, '2008-10-13 13:17:40', NULL, 5, 33, 7, 0),
     1092(10, 10, 5, '2008-10-13 13:17:41', NULL, '2008-10-13 13:17:41', NULL, 5, 33, 6, 0),
     1093(11, 11, 5, '2008-10-13 13:17:44', NULL, '2008-10-13 13:17:44', NULL, 5, 33, 1, 0),
     1094(12, 12, 5, '2008-10-13 13:19:17', NULL, '2008-10-13 13:19:17', NULL, 5, 33, 14, 1),
     1095(13, 13, 5, '2008-10-13 13:19:27', NULL, '2008-10-13 13:19:27', NULL, 5, 33, 14, 2),
     1096(14, 14, 5, '2008-10-13 13:39:08', NULL, '2008-10-13 13:39:08', NULL, 5, 11, 45, 1),
     1097(15, 15, 5, '2008-10-13 13:52:04', NULL, '2008-10-13 13:52:04', NULL, 5, 2, 10, 1),
     1098(16, 16, 5, '2008-10-13 13:57:30', NULL, '2008-10-13 13:57:30', NULL, 5, 1, 21, 1),
     1099(17, 17, 5, '2008-10-13 14:05:54', NULL, '2008-10-13 14:05:54', NULL, 5, 33, 15, 0),
     1100(18, 18, 5, '2008-10-13 14:06:21', NULL, '2008-10-13 14:06:21', NULL, 5, 33, 16, 0),
     1101(19, 19, 5, '2008-10-14 06:53:58', NULL, '2008-10-14 06:53:58', NULL, 5, 14, 157, 0),
     1102(20, 20, 5, '2008-10-14 07:02:50', NULL, '2008-10-14 07:02:50', NULL, 5, 11, 46, 0),
     1103(21, 21, 5, '2008-10-14 07:20:25', NULL, '2008-10-14 07:20:25', NULL, 5, 7, 15, 1),
     1104(22, 22, 5, '2008-10-14 07:21:08', NULL, '2008-10-14 07:21:08', NULL, 5, 14, 158, 1),
     1105(23, 23, 5, '2008-10-14 07:48:07', NULL, '2008-10-14 07:48:07', NULL, 5, 11, 47, 0),
     1106(24, 24, 5, '2008-10-14 07:51:52', NULL, '2008-10-14 07:51:52', NULL, 5, 14, 159, 0),
     1107(25, 25, 5, '2008-10-14 07:52:23', NULL, '2008-10-14 07:52:23', NULL, 5, 12, 5, 1),
     1108(26, 26, 5, '2008-10-14 07:53:02', NULL, '2008-10-14 07:53:02', NULL, 5, 12, 6, 1),
     1109(27, 27, 5, '2008-10-14 07:56:06', NULL, '2008-10-14 07:56:06', NULL, 5, 12, 7, 1),
     1110(28, 28, 5, '2008-10-14 07:58:11', NULL, '2008-10-14 07:58:11', NULL, 5, 12, 8, 1),
     1111(29, 29, 5, '2008-10-14 08:34:22', NULL, '2008-10-14 08:34:22', NULL, 5, 12, 9, 1),
     1112(30, 30, 5, '2008-10-14 08:35:57', NULL, '2008-10-14 08:35:57', NULL, 5, 12, 10, 1),
     1113(31, 31, 5, '2008-10-14 08:36:48', NULL, '2008-10-14 08:36:48', NULL, 5, 12, 11, 1),
     1114(32, 32, 5, '2008-10-14 08:48:28', NULL, '2008-10-14 08:48:28', NULL, 5, 12, 12, 1),
     1115(33, 33, 5, '2008-10-14 08:48:41', NULL, '2008-10-14 08:48:41', NULL, 5, 12, 13, 1),
     1116(34, 34, 5, '2008-10-14 08:50:50', NULL, '2008-10-14 08:50:50', NULL, 5, 12, 14, 1),
     1117(35, 35, 5, '2008-10-14 08:52:23', NULL, '2008-10-14 08:52:23', NULL, 5, 12, 15, 1),
     1118(36, 36, 5, '2008-10-14 08:53:04', NULL, '2008-10-14 08:53:04', NULL, 5, 12, 16, 1),
     1119(37, 37, 5, '2008-10-14 08:53:22', NULL, '2008-10-14 08:53:22', NULL, 5, 12, 17, 1),
     1120(38, 38, 5, '2008-10-14 08:53:38', NULL, '2008-10-14 08:53:38', NULL, 5, 12, 18, 1),
     1121(39, 39, 5, '2008-10-14 08:53:54', NULL, '2008-10-14 08:53:54', NULL, 5, 12, 19, 1),
     1122(40, 40, 5, '2008-10-14 08:56:11', NULL, '2008-10-14 08:56:11', NULL, 5, 12, 20, 1),
     1123(41, 41, 5, '2008-10-14 09:00:22', NULL, '2008-10-14 09:00:22', NULL, 5, 12, 21, 1),
     1124(42, 42, 5, '2008-10-14 09:01:39', NULL, '2008-10-14 09:01:39', NULL, 5, 12, 22, 1),
     1125(43, 43, 5, '2008-10-14 09:02:31', NULL, '2008-10-14 09:02:31', NULL, 5, 12, 23, 1),
     1126(44, 44, 5, '2008-10-14 09:03:32', NULL, '2008-10-14 09:03:32', NULL, 5, 12, 24, 1),
     1127(45, 45, 5, '2008-10-14 09:05:45', NULL, '2008-10-14 09:05:45', NULL, 5, 12, 25, 1),
     1128(46, 46, 5, '2008-10-14 09:07:57', NULL, '2008-10-14 09:07:57', NULL, 5, 12, 26, 1),
     1129(47, 47, 5, '2008-10-14 09:16:00', NULL, '2008-10-14 09:16:00', NULL, 5, 12, 27, 1),
     1130(48, 48, 5, '2008-10-14 09:16:34', NULL, '2008-10-14 09:16:34', NULL, 5, 12, 28, 1),
     1131(49, 49, 5, '2008-10-14 09:16:57', NULL, '2008-10-14 09:16:57', NULL, 5, 12, 29, 1),
     1132(50, 50, 5, '2008-10-14 09:17:42', NULL, '2008-10-14 09:17:42', NULL, 5, 12, 30, 1),
     1133(51, 51, 5, '2008-10-14 09:20:19', NULL, '2008-10-14 09:20:19', NULL, 5, 12, 31, 1),
     1134(52, 52, 5, '2008-10-14 09:47:32', NULL, '2008-10-14 09:47:32', NULL, 5, 1, 22, 1),
     1135(53, 53, 5, '2008-10-14 09:57:36', NULL, '2008-10-14 09:57:36', NULL, 5, 1, 23, 1),
     1136(54, 54, 5, '2008-10-14 09:57:54', NULL, '2008-10-14 09:57:54', NULL, 5, 1, 24, 1),
     1137(55, 55, 5, '2008-10-15 15:53:45', NULL, '2008-10-15 15:53:45', NULL, 5, 1, 25, 1),
     1138(56, 56, 5, '2008-10-15 15:55:21', NULL, '2008-10-15 15:55:21', NULL, 5, 1, 26, 1),
     1139(57, 57, 5, '2008-10-15 16:00:07', NULL, '2008-10-15 16:00:07', NULL, 5, 1, 27, 1),
     1140(58, 58, 5, '2008-10-16 12:24:44', NULL, '2008-10-16 12:24:44', NULL, 5, 7, 16, 1),
     1141(59, 59, 5, '2008-10-19 19:13:18', NULL, '2008-10-19 19:13:18', NULL, 5, 6, 5, 1),
     1142(60, 60, 5, '2008-10-19 19:13:25', NULL, '2008-10-19 19:13:25', NULL, 5, 6, 6, 1),
     1143(61, 61, 5, '2008-10-19 19:13:33', NULL, '2008-10-19 19:13:33', NULL, 5, 6, 7, 1),
     1144(62, 62, 5, '2008-10-19 19:19:25', NULL, '2008-10-19 19:19:25', NULL, 5, 14, 160, 1),
     1145(63, 63, 5, '2008-10-19 20:00:47', NULL, '2008-10-19 20:00:47', NULL, 5, 5, 9, 0),
     1146(64, 64, 5, '2008-10-19 20:01:24', NULL, '2008-10-19 20:01:24', NULL, 5, 2, 11, 1),
     1147(65, 65, 5, '2008-10-19 20:03:14', NULL, '2008-10-19 20:03:14', NULL, 5, 2, 12, 1),
     1148(66, 66, 5, '2008-10-19 20:03:20', NULL, '2008-10-19 20:03:20', NULL, 5, 2, 13, 1),
     1149(67, 67, 5, '2008-10-19 20:07:04', NULL, '2008-10-19 20:07:04', NULL, 5, 6, 8, 1),
     1150(68, 68, 5, '2008-10-19 20:08:36', NULL, '2008-10-19 20:08:36', NULL, 5, 14, 161, 1),
     1151(69, 69, 5, '2008-10-19 20:09:33', NULL, '2008-10-19 20:09:33', NULL, 5, 14, 162, 1),
     1152(70, 70, 5, '2008-10-19 20:09:37', NULL, '2008-10-19 20:09:37', NULL, 5, 12, 3, 2),
     1153(71, 71, 5, '2008-10-21 07:06:14', NULL, '2008-10-21 07:06:14', NULL, 5, 33, 17, 0),
     1154(72, 72, 5, '2008-10-21 07:06:35', NULL, '2008-10-21 07:06:35', NULL, 5, 1, 28, 1),
     1155(73, 73, 5, '2008-10-21 07:46:53', NULL, '2008-10-21 07:46:53', NULL, 5, 13, 35, 0),
     1156(74, 74, 5, '2008-10-21 07:47:49', NULL, '2008-10-21 07:47:49', NULL, 5, 14, 163, 0),
     1157(75, 75, 5, '2008-10-21 07:48:56', NULL, '2008-10-21 07:48:56', NULL, 5, 14, 164, 0),
     1158(76, 76, 5, '2008-10-21 07:51:35', NULL, '2008-10-21 07:51:35', NULL, 5, 14, 165, 0),
     1159(77, 77, 5, '2008-10-21 07:52:52', NULL, '2008-10-21 07:52:52', NULL, 5, 14, 150, 2),
     1160(78, 78, 5, '2008-10-21 07:53:04', NULL, '2008-10-21 07:53:04', NULL, 5, 14, 151, 2),
     1161(79, 79, 5, '2008-10-21 08:06:34', NULL, '2008-10-21 08:06:34', NULL, 5, 13, 36, 1),
     1162(80, 80, 5, '2008-10-21 08:07:02', NULL, '2008-10-21 08:07:02', NULL, 5, 13, 37, 1),
     1163(81, 81, 5, '2008-10-21 08:07:20', NULL, '2008-10-21 08:07:20', NULL, 5, 13, 38, 1),
     1164(82, 82, 5, '2008-10-21 08:10:18', NULL, '2008-10-21 08:10:18', NULL, 5, 13, 39, 1),
     1165(83, 83, 5, '2008-10-21 08:10:28', NULL, '2008-10-21 08:10:28', NULL, 5, 13, 40, 1),
     1166(84, 84, 5, '2008-10-21 08:10:38', NULL, '2008-10-21 08:10:38', NULL, 5, 13, 41, 1),
     1167(85, 85, 5, '2008-10-21 08:10:57', NULL, '2008-10-21 08:10:57', NULL, 5, 33, 18, 0),
     1168(86, 86, 5, '2008-10-21 08:11:18', NULL, '2008-10-21 08:11:18', NULL, 5, 13, 42, 1),
     1169(87, 87, 5, '2008-10-21 08:13:34', NULL, '2008-10-21 08:13:34', NULL, 5, 11, 48, 0),
     1170(88, 88, 5, '2008-10-21 08:14:17', NULL, '2008-10-21 08:14:17', NULL, 5, 14, 166, 0),
     1171(89, 89, 5, '2008-10-21 08:14:39', NULL, '2008-10-21 08:14:39', NULL, 5, 41, 1, 0),
     1172(90, 90, 5, '2008-10-21 08:14:59', NULL, '2008-10-21 08:14:59', NULL, 5, 41, 2, 0),
     1173(91, 91, 5, '2008-10-21 08:17:28', NULL, '2008-10-21 08:17:28', NULL, 5, 11, 0, 1),
     1174(92, 92, 5, '2008-10-21 08:18:00', NULL, '2008-10-21 08:18:00', NULL, 5, 11, 49, 1),
     1175(93, 93, 5, '2008-10-21 08:19:02', NULL, '2008-10-21 08:19:02', NULL, 5, 11, 50, 1),
     1176(94, 94, 5, '2008-10-21 08:19:13', NULL, '2008-10-21 08:19:13', NULL, 5, 42, 43, 1),
     1177(95, 95, 5, '2008-10-21 08:19:21', NULL, '2008-10-21 08:19:21', NULL, 5, 43, 44, 1),
     1178(96, 96, 5, '2008-10-21 08:19:30', NULL, '2008-10-21 08:19:30', NULL, 5, 43, 45, 1),
     1179(97, 97, 5, '2008-10-21 08:19:35', NULL, '2008-10-21 08:19:35', NULL, 5, 43, 46, 1),
     1180(98, 98, 5, '2008-10-21 08:19:41', NULL, '2008-10-21 08:19:41', NULL, 5, 43, 47, 1),
     1181(99, 99, 5, '2008-10-21 08:19:46', NULL, '2008-10-21 08:19:46', NULL, 5, 43, 48, 1),
     1182(100, 100, 5, '2008-10-21 08:19:58', NULL, '2008-10-21 08:19:58', NULL, 5, 43, 49, 1),
     1183(101, 101, 5, '2008-10-21 08:20:07', NULL, '2008-10-21 08:20:07', NULL, 5, 43, 50, 1),
     1184(102, 102, 5, '2008-10-21 08:20:12', NULL, '2008-10-21 08:20:12', NULL, 5, 43, 51, 1),
     1185(103, 103, 5, '2008-10-21 08:20:16', NULL, '2008-10-21 08:20:16', NULL, 5, 43, 52, 1),
     1186(104, 104, 5, '2008-10-21 08:20:20', NULL, '2008-10-21 08:20:20', NULL, 5, 43, 53, 1),
     1187(105, 105, 5, '2008-10-21 08:20:25', NULL, '2008-10-21 08:20:25', NULL, 5, 43, 54, 1),
     1188(106, 106, 5, '2008-10-21 08:20:28', NULL, '2008-10-21 08:20:28', NULL, 5, 43, 55, 1),
     1189(107, 107, 5, '2008-10-21 08:20:33', NULL, '2008-10-21 08:20:33', NULL, 5, 43, 56, 1),
     1190(108, 108, 5, '2008-10-21 08:20:39', NULL, '2008-10-21 08:20:39', NULL, 5, 43, 57, 1),
     1191(109, 109, 5, '2008-10-21 08:20:48', NULL, '2008-10-21 08:20:48', NULL, 5, 43, 58, 1),
     1192(110, 110, 5, '2008-10-21 08:20:54', NULL, '2008-10-21 08:20:54', NULL, 5, 43, 59, 1),
     1193(111, 111, 5, '2008-10-21 08:20:58', NULL, '2008-10-21 08:20:58', NULL, 5, 43, 60, 1),
     1194(112, 112, 5, '2008-10-21 08:21:03', NULL, '2008-10-21 08:21:03', NULL, 5, 43, 61, 1),
     1195(113, 113, 5, '2008-10-21 08:21:07', NULL, '2008-10-21 08:21:07', NULL, 5, 43, 62, 1),
     1196(114, 114, 5, '2008-10-21 08:22:44', NULL, '2008-10-21 08:22:44', NULL, 5, 54, 51, 0),
     1197(115, 115, 5, '2008-10-21 08:23:20', NULL, '2008-10-21 08:23:20', NULL, 5, 56, 167, 0),
     1198(116, 116, 5, '2008-10-21 08:24:13', NULL, '2008-10-21 08:24:13', NULL, 5, 54, 52, 1),
     1199(117, 117, 5, '2008-10-21 08:38:31', NULL, '2008-10-21 08:38:31', NULL, 5, 43, 16, 2),
     1200(118, 118, 5, '2008-10-21 08:51:03', NULL, '2008-10-21 08:51:03', NULL, 5, 60, 19, 0),
     1201(119, 119, 5, '2008-10-21 08:53:00', NULL, '2008-10-21 08:53:00', NULL, 5, 56, 142, 2),
     1202(120, 120, 5, '2008-10-21 08:53:27', NULL, '2008-10-21 08:53:27', NULL, 5, 56, 99, 2),
     1203(121, 121, 5, '2008-10-21 08:55:36', NULL, '2008-10-21 08:55:36', NULL, 5, 62, 3, 0),
     1204(122, 122, 5, '2008-10-21 08:55:47', NULL, '2008-10-21 08:55:47', NULL, 5, 43, 63, 1),
     1205(123, 123, 5, '2008-10-21 08:56:03', NULL, '2008-10-21 08:56:03', NULL, 5, 43, 64, 1),
     1206(124, 124, 5, '2008-10-21 08:56:11', NULL, '2008-10-21 08:56:11', NULL, 5, 43, 65, 1),
     1207(125, 125, 5, '2008-10-21 08:56:22', NULL, '2008-10-21 08:56:22', NULL, 5, 43, 66, 1),
     1208(126, 126, 5, '2008-10-21 08:56:29', NULL, '2008-10-21 08:56:29', NULL, 5, 43, 67, 1),
     1209(127, 127, 5, '2008-10-21 09:06:54', NULL, '2008-10-21 09:06:54', NULL, 5, 63, 29, 1),
     1210(128, 128, 5, '2008-10-21 09:58:14', NULL, '2008-10-21 09:58:14', NULL, 5, 54, 53, 0),
     1211(129, 129, 5, '2008-10-21 10:00:27', NULL, '2008-10-21 10:00:27', NULL, 5, 56, 19, 2),
     1212(130, 130, 5, '2008-10-21 10:01:03', NULL, '2008-10-21 10:01:03', NULL, 5, 56, 168, 1),
     1213(131, 131, 5, '2008-10-21 10:11:56', NULL, '2008-10-21 10:11:56', NULL, 5, 51, 0, 1),
     1214(132, 132, 5, '2008-10-21 10:13:08', NULL, '2008-10-21 10:13:08', NULL, 5, 51, 0, 1),
     1215(133, 133, 5, '2008-10-21 10:17:25', NULL, '2008-10-21 10:17:25', NULL, 5, 56, 113, 2),
     1216(134, 134, 5, '2008-10-21 10:17:36', NULL, '2008-10-21 10:17:36', NULL, 5, 56, 114, 2),
     1217(135, 135, 5, '2008-10-21 10:18:03', NULL, '2008-10-21 10:18:03', NULL, 5, 51, 7, 1),
     1218(136, 136, 5, '2008-10-21 10:20:38', NULL, '2008-10-21 10:20:38', NULL, 5, 51, 8, 1),
     1219(137, 137, 5, '2008-10-21 10:21:01', NULL, '2008-10-21 10:21:01', NULL, 5, 51, 9, 1),
     1220(138, 138, 5, '2008-10-21 10:22:36', NULL, '2008-10-21 10:22:36', NULL, 5, 51, 10, 1),
     1221(139, 139, 5, '2008-10-21 10:30:03', NULL, '2008-10-21 10:30:03', NULL, 5, 51, 11, 1),
     1222(140, 140, 5, '2008-10-21 10:35:47', NULL, '2008-10-21 10:35:47', NULL, 5, 51, 12, 1),
     1223(141, 141, 5, '2008-10-21 10:36:21', NULL, '2008-10-21 10:36:21', NULL, 5, 51, 13, 1),
     1224(142, 142, 5, '2008-10-21 10:36:36', NULL, '2008-10-21 10:36:36', NULL, 5, 51, 14, 1),
     1225(143, 143, 5, '2008-10-21 10:38:25', NULL, '2008-10-21 10:38:25', NULL, 5, 51, 15, 1),
     1226(144, 144, 5, '2008-10-21 10:39:52', NULL, '2008-10-21 10:39:52', NULL, 5, 51, 16, 1),
     1227(145, 145, 5, '2008-10-21 10:39:57', NULL, '2008-10-21 10:39:57', NULL, 5, 51, 17, 1),
     1228(146, 146, 5, '2008-10-21 11:40:16', NULL, '2008-10-21 11:40:16', NULL, 5, 51, 18, 1),
     1229(147, 147, 5, '2008-10-21 11:41:33', NULL, '2008-10-21 11:41:33', NULL, 5, 51, 19, 1),
     1230(148, 148, 5, '2008-10-21 11:41:42', NULL, '2008-10-21 11:41:42', NULL, 5, 51, 20, 1),
     1231(149, 149, 5, '2008-10-21 11:41:50', NULL, '2008-10-21 11:41:50', NULL, 5, 51, 21, 1),
     1232(150, 150, 5, '2008-10-21 11:41:54', NULL, '2008-10-21 11:41:54', NULL, 5, 51, 22, 1),
     1233(151, 151, 5, '2008-10-21 11:42:30', NULL, '2008-10-21 11:42:30', NULL, 5, 51, 23, 1),
     1234(152, 152, 5, '2008-10-21 11:42:36', NULL, '2008-10-21 11:42:36', NULL, 5, 51, 24, 1),
     1235(153, 153, 5, '2008-10-21 11:42:41', NULL, '2008-10-21 11:42:41', NULL, 5, 51, 25, 1),
     1236(154, 154, 5, '2008-10-21 11:47:30', NULL, '2008-10-21 11:47:30', NULL, 5, 51, 26, 1),
     1237(155, 155, 5, '2008-10-21 11:47:39', NULL, '2008-10-21 11:47:39', NULL, 5, 51, 27, 1),
     1238(156, 156, 5, '2008-10-21 11:49:23', NULL, '2008-10-21 11:49:23', NULL, 5, 51, 28, 1),
     1239(157, 157, 5, '2008-10-21 11:53:36', NULL, '2008-10-21 11:53:36', NULL, 5, 51, 29, 1),
     1240(158, 158, 5, '2008-10-21 11:53:42', NULL, '2008-10-21 11:53:42', NULL, 5, 51, 30, 1),
     1241(159, 159, 5, '2008-10-21 11:56:52', NULL, '2008-10-21 11:56:52', NULL, 5, 51, 31, 1),
     1242(160, 160, 5, '2008-10-21 12:04:01', NULL, '2008-10-21 12:04:01', NULL, 5, 51, 32, 1),
     1243(161, 161, 5, '2008-10-21 12:05:49', NULL, '2008-10-21 12:05:49', NULL, 5, 51, 33, 1),
     1244(162, 162, 5, '2008-10-21 12:07:48', NULL, '2008-10-21 12:07:48', NULL, 5, 51, 34, 1),
     1245(163, 163, 5, '2008-10-21 12:44:55', NULL, '2008-10-21 12:44:55', NULL, 5, 65, 20, 0),
     1246(164, 164, 5, '2008-10-21 12:56:43', NULL, '2008-10-21 12:56:43', NULL, 5, 63, 30, 1),
     1247(165, 165, 5, '2008-10-21 12:57:35', NULL, '2008-10-21 12:57:35', NULL, 5, 65, 21, 0),
     1248(166, 166, 5, '2008-10-21 12:57:54', NULL, '2008-10-21 12:57:54', NULL, 5, 65, 22, 0),
     1249(167, 167, 5, '2008-10-21 12:58:11', NULL, '2008-10-21 12:58:11', NULL, 5, 65, 23, 0),
     1250(168, 168, 5, '2008-10-21 12:58:23', NULL, '2008-10-21 12:58:23', NULL, 5, 65, 24, 1),
     1251(169, 169, 5, '2008-10-21 12:58:43', NULL, '2008-10-21 12:58:43', NULL, 5, 65, 25, 1),
     1252(170, 170, 5, '2008-10-21 12:58:54', NULL, '2008-10-21 12:58:54', NULL, 5, 65, 26, 0),
     1253(171, 171, 5, '2008-10-21 12:59:08', NULL, '2008-10-21 12:59:08', NULL, 5, 65, 27, 0),
     1254(172, 172, 5, '2008-10-21 12:59:15', NULL, '2008-10-21 12:59:15', NULL, 5, 65, 28, 0),
     1255(173, 173, 5, '2008-10-21 13:02:40', NULL, '2008-10-21 13:02:40', NULL, 5, 45, 19, 0),
     1256(174, 174, 5, '2008-10-21 13:02:59', NULL, '2008-10-21 13:02:59', NULL, 5, 45, 20, 1),
     1257(175, 175, 5, '2008-10-21 13:11:11', NULL, '2008-10-21 13:11:11', NULL, 5, 65, 29, 1),
     1258(176, 176, 5, '2008-10-21 13:13:52', NULL, '2008-10-21 13:13:52', NULL, 5, 63, 31, 0),
     1259(177, 177, 5, '2008-10-21 13:14:20', NULL, '2008-10-21 13:14:20', NULL, 5, 65, 30, 0),
     1260(178, 178, 5, '2008-10-21 13:14:45', NULL, '2008-10-21 13:14:45', NULL, 5, 65, 31, 1),
     1261(179, 179, 5, '2008-10-21 13:18:17', NULL, '2008-10-21 13:18:17', NULL, 5, 65, 32, 0),
     1262(180, 180, 5, '2008-10-21 13:18:39', NULL, '2008-10-21 13:18:39', NULL, 5, 65, 33, 1),
     1263(181, 181, 5, '2008-10-21 13:18:52', NULL, '2008-10-21 13:18:52', NULL, 5, 65, 34, 1),
     1264(182, 182, 5, '2008-10-21 13:19:36', NULL, '2008-10-21 13:19:36', NULL, 5, 65, 35, 0),
     1265(183, 183, 5, '2008-10-21 13:19:58', NULL, '2008-10-21 13:19:58', NULL, 5, 43, 68, 1),
     1266(184, 184, 5, '2008-10-21 13:20:18', NULL, '2008-10-21 13:20:18', NULL, 5, 43, 69, 1),
     1267(185, 185, 5, '2008-10-21 13:33:00', NULL, '2008-10-21 13:33:00', NULL, 5, 63, 32, 1),
     1268(186, 186, 5, '2008-10-21 13:45:09', NULL, '2008-10-21 13:45:09', NULL, 5, 63, 33, 1),
     1269(187, 187, 5, '2008-10-21 13:45:28', NULL, '2008-10-21 13:45:28', NULL, 5, 63, 34, 1),
     1270(188, 188, 5, '2008-10-21 13:48:35', NULL, '2008-10-21 13:48:35', NULL, 5, 68, 36, 0),
     1271(189, 189, 5, '2008-10-21 13:49:05', NULL, '2008-10-21 13:49:05', NULL, 5, 68, 37, 0),
     1272(190, 190, 5, '2008-10-21 13:49:48', NULL, '2008-10-21 13:49:48', NULL, 5, 68, 38, 0),
     1273(191, 191, 5, '2008-10-21 14:16:35', NULL, '2008-10-21 14:16:35', NULL, 5, 63, 35, 1),
     1274(192, 192, 28, '2008-10-21 14:36:27', NULL, '2008-10-21 14:36:27', NULL, 28, 68, 39, 1),
     1275(193, 193, 28, '2008-10-21 14:38:25', NULL, '2008-10-21 14:38:25', NULL, 28, 43, 70, 0),
     1276(194, 194, 28, '2008-10-21 14:38:33', NULL, '2008-10-21 14:38:33', NULL, 28, 62, 4, 0),
     1277(195, 195, 28, '2008-10-21 14:38:44', NULL, '2008-10-21 14:38:44', NULL, 28, 43, 71, 1),
     1278(196, 196, 28, '2008-10-21 14:39:36', NULL, '2008-10-21 14:39:36', NULL, 28, 43, 72, 0),
     1279(197, 197, 28, '2008-10-21 14:39:54', NULL, '2008-10-21 14:39:54', NULL, 28, 43, 73, 1),
     1280(198, 198, 28, '2008-10-21 14:40:20', NULL, '2008-10-21 14:40:20', NULL, 28, 69, 169, 0),
     1281(199, 199, 28, '2008-10-21 14:41:01', NULL, '2008-10-21 14:41:01', NULL, 28, 69, 170, 0),
     1282(200, 200, 28, '2008-10-21 14:42:05', NULL, '2008-10-21 14:42:05', NULL, 28, 69, 171, 0),
     1283(201, 201, 28, '2008-10-21 14:42:57', NULL, '2008-10-21 14:42:57', NULL, 28, 54, 54, 0),
     1284(202, 202, 28, '2008-10-21 14:43:30', NULL, '2008-10-21 14:43:30', NULL, 28, 69, 172, 0),
     1285(203, 203, 28, '2008-10-21 14:43:57', NULL, '2008-10-21 14:43:57', NULL, 28, 69, 173, 0),
     1286(204, 204, 28, '2008-10-21 14:45:16', NULL, '2008-10-21 14:45:16', NULL, 28, 54, 55, 0),
     1287(205, 205, 28, '2008-10-21 14:45:36', NULL, '2008-10-21 14:45:36', NULL, 28, 68, 40, 0),
     1288(206, 206, 28, '2008-10-21 14:49:29', NULL, '2008-10-21 14:49:29', NULL, 28, 69, 174, 0),
     1289(207, 207, 28, '2008-10-21 14:49:50', NULL, '2008-10-21 14:49:50', NULL, 28, 72, 0, 0),
     1290(208, 208, 28, '2008-10-21 14:51:50', NULL, '2008-10-21 14:51:50', NULL, 28, 72, 1, 0),
     1291(209, 209, 28, '2008-10-21 14:52:11', NULL, '2008-10-21 14:52:11', NULL, 28, 72, 2, 0),
     1292(210, 210, 28, '2008-10-21 14:52:25', NULL, '2008-10-21 14:52:25', NULL, 28, 72, 3, 0),
     1293(211, 211, 28, '2008-10-21 14:52:39', NULL, '2008-10-21 14:52:39', NULL, 28, 72, 4, 0),
     1294(212, 212, 28, '2008-10-21 14:52:53', NULL, '2008-10-21 14:52:53', NULL, 28, 72, 5, 0),
     1295(213, 213, 28, '2008-10-21 14:53:07', NULL, '2008-10-21 14:53:07', NULL, 28, 72, 6, 0),
     1296(214, 214, 28, '2008-10-21 14:53:51', NULL, '2008-10-21 14:53:51', NULL, 28, 72, 7, 0),
     1297(215, 215, 28, '2008-10-21 14:54:31', NULL, '2008-10-21 14:54:31', NULL, 28, 68, 41, 0),
     1298(216, 216, 28, '2008-10-21 14:57:33', NULL, '2008-10-21 14:57:33', NULL, 28, 73, 1, 0),
     1299(217, 217, 28, '2008-10-21 14:58:03', NULL, '2008-10-21 14:58:03', NULL, 28, 72, 8, 0),
     1300(218, 218, 28, '2008-10-21 14:58:16', NULL, '2008-10-21 14:58:16', NULL, 28, 73, 2, 0),
     1301(219, 219, 28, '2008-10-21 15:51:24', NULL, '2008-10-21 15:51:24', NULL, 28, 45, 21, 0),
     1302(220, 220, 28, '2008-10-21 15:53:47', NULL, '2008-10-21 15:53:47', NULL, 28, 51, 35, 0),
     1303(221, 221, 28, '2008-10-21 15:54:04', NULL, '2008-10-21 15:54:04', NULL, 28, 51, 36, 0),
     1304(222, 222, 28, '2008-10-21 15:54:56', NULL, '2008-10-21 15:54:56', NULL, 28, 69, 175, 0),
     1305(223, 223, 28, '2008-10-21 15:55:29', NULL, '2008-10-21 15:55:29', NULL, 28, 69, 157, 2),
     1306(224, 224, 28, '2008-10-21 15:56:12', NULL, '2008-10-21 15:56:12', NULL, 28, 54, 56, 1),
     1307(225, 225, 28, '2008-10-21 15:56:41', NULL, '2008-10-21 15:56:41', NULL, 28, 69, 176, 1),
     1308(226, 226, 28, '2008-10-21 15:57:44', NULL, '2008-10-21 15:57:44', NULL, 28, 73, 3, 0),
     1309(227, 227, 28, '2008-10-21 15:58:31', NULL, '2008-10-21 15:58:31', NULL, 28, 73, 4, 0),
     1310(228, 228, 28, '2008-10-21 15:59:35', NULL, '2008-10-21 15:59:35', NULL, 28, 73, 5, 0),
     1311(229, 229, 28, '2008-10-21 16:06:09', NULL, '2008-10-21 16:06:09', NULL, 28, 43, 74, 0),
     1312(230, 230, 28, '2008-10-21 16:06:44', NULL, '2008-10-21 16:06:44', NULL, 28, 69, 177, 0),
     1313(231, 231, 28, '2008-10-21 16:07:14', NULL, '2008-10-21 16:07:14', NULL, 28, 69, 178, 0),
     1314(232, 232, 28, '2008-10-21 16:07:55', NULL, '2008-10-21 16:07:55', NULL, 28, 69, 179, 0),
     1315(233, 233, 28, '2008-10-21 16:08:16', NULL, '2008-10-21 16:08:16', NULL, 28, 69, 180, 0),
     1316(234, 234, 28, '2008-10-21 16:08:34', NULL, '2008-10-21 16:08:34', NULL, 28, 69, 181, 0),
     1317(235, 235, 28, '2008-10-21 16:08:55', NULL, '2008-10-21 16:08:55', NULL, 28, 69, 182, 0),
     1318(236, 236, 28, '2008-10-21 16:09:19', NULL, '2008-10-21 16:09:19', NULL, 28, 68, 42, 0),
     1319(237, 237, 28, '2008-10-21 16:09:55', NULL, '2008-10-21 16:09:55', NULL, 28, 69, 183, 1),
     1320(238, 238, 28, '2008-10-22 07:13:27', NULL, '2008-10-22 07:13:27', NULL, 28, 68, 43, 0),
     1321(239, 239, 28, '2008-10-22 07:43:39', NULL, '2008-10-22 07:43:39', NULL, 28, 68, 44, 0),
     1322(240, 240, 28, '2008-10-22 08:05:42', NULL, '2008-10-22 08:05:42', NULL, 28, 50, 14, 1),
     1323(241, 241, 28, '2008-10-22 08:09:18', NULL, '2008-10-22 08:09:18', NULL, 28, 69, 184, 1),
     1324(242, 242, 28, '2008-10-22 08:40:51', NULL, '2008-10-22 08:40:51', NULL, 28, 69, 185, 1),
     1325(243, 243, 5, '2008-10-22 08:43:30', NULL, '2008-10-22 08:43:30', NULL, 28, 69, 186, 1),
     1326(244, 244, 5, '2008-10-22 11:50:06', NULL, '2008-10-22 11:50:06', NULL, 28, 68, 45, 0),
     1327(245, 245, 5, '2008-10-22 11:50:30', NULL, '2008-10-22 11:50:30', NULL, 28, 68, 46, 0),
     1328(246, 246, 5, '2008-10-22 12:49:17', NULL, '2008-10-22 12:49:17', NULL, 28, 43, 75, 0),
     1329(247, 247, 5, '2008-10-22 12:50:21', NULL, '2008-10-22 12:50:21', NULL, 28, 43, 25, 2),
     1330(248, 248, 5, '2008-10-22 12:50:58', NULL, '2008-10-22 12:50:58', NULL, 28, 43, 76, 0),
     1331(249, 249, 5, '2008-10-22 12:52:24', NULL, '2008-10-22 12:52:24', NULL, 28, 43, 77, 0),
     1332(250, 250, 5, '2008-10-27 11:03:03', NULL, '2008-10-27 11:03:03', NULL, 28, 43, 79, 0),
     1333(251, 251, 5, '2008-10-27 12:05:17', NULL, '2008-10-27 12:05:17', NULL, 28, 43, 80, 0),
     1334(252, 252, 5, '2008-10-27 12:11:07', NULL, '2008-10-27 12:11:07', NULL, 28, 43, 81, 0),
     1335(253, 253, 5, '2008-10-27 12:15:20', NULL, '2008-10-27 12:15:20', NULL, 28, 43, 31, 2),
     1336(254, 254, 5, '2008-10-27 12:16:48', NULL, '2008-10-27 12:16:48', NULL, 28, 43, 31, 2),
     1337(255, 255, 5, '2008-10-27 12:18:17', NULL, '2008-10-27 12:18:17', NULL, 28, 43, 31, 2),
     1338(256, 256, 5, '2008-10-27 12:18:22', NULL, '2008-10-27 12:18:22', NULL, 28, 43, 31, 2),
     1339(257, 257, 5, '2008-10-27 12:18:24', NULL, '2008-10-27 12:18:24', NULL, 28, 43, 30, 2),
     1340(258, 258, 5, '2008-10-27 12:18:26', NULL, '2008-10-27 12:18:26', NULL, 28, 43, 23, 2),
     1341(259, 259, 5, '2008-10-27 12:25:08', NULL, '2008-10-27 12:25:08', NULL, 28, 43, 23, 2),
     1342(260, 260, 5, '2008-10-27 13:52:30', NULL, '2008-10-27 13:52:30', NULL, 28, 43, 27, 2),
     1343(261, 261, 5, '2008-10-27 13:52:34', NULL, '2008-10-27 13:52:34', NULL, 28, 43, 27, 2),
     1344(262, 262, 5, '2008-10-27 13:52:37', NULL, '2008-10-27 13:52:37', NULL, 28, 43, 26, 2),
     1345(263, 263, 5, '2008-10-27 13:52:40', NULL, '2008-10-27 13:52:40', NULL, 28, 43, 26, 2),
     1346(264, 264, 5, '2008-10-27 13:52:48', NULL, '2008-10-27 13:52:48', NULL, 28, 43, 29, 2),
     1347(265, 265, 5, '2008-10-27 13:55:21', NULL, '2008-10-27 13:55:21', NULL, 28, 43, 29, 2),
     1348(266, 266, 5, '2008-10-27 13:55:28', NULL, '2008-10-27 13:55:28', NULL, 28, 43, 82, 0),
     1349(267, 267, 5, '2008-10-27 13:55:38', NULL, '2008-10-27 13:55:38', NULL, 28, 43, 32, 2),
     1350(268, 268, 5, '2008-10-27 13:55:49', NULL, '2008-10-27 13:55:49', NULL, 28, 43, 32, 2),
     1351(269, 269, 5, '2008-10-27 13:56:31', NULL, '2008-10-27 13:56:31', NULL, 28, 69, 187, 0),
     1352(270, 270, 5, '2008-10-27 13:57:19', NULL, '2008-10-27 13:57:19', NULL, 28, 69, 188, 0),
     1353(271, 271, 5, '2008-10-27 13:59:51', NULL, '2008-10-27 13:59:51', NULL, 28, 54, 57, 0),
     1354(272, 272, 5, '2008-10-27 14:00:37', NULL, '2008-10-27 14:00:37', NULL, 28, 54, 58, 1),
     1355(273, 273, 5, '2008-10-27 14:01:06', NULL, '2008-10-27 14:01:06', NULL, 28, 69, 189, 0),
     1356(274, 274, 5, '2008-10-27 14:01:45', NULL, '2008-10-27 14:01:45', NULL, 28, 69, 169, 2),
     1357(275, 275, 5, '2008-10-27 14:02:10', NULL, '2008-10-27 14:02:10', NULL, 28, 69, 190, 0),
     1358(276, 276, 5, '2008-10-27 14:02:53', NULL, '2008-10-27 14:02:53', NULL, 28, 54, 59, 1),
     1359(277, 277, 5, '2008-10-27 14:03:32', NULL, '2008-10-27 14:03:32', NULL, 28, 69, 191, 0),
     1360(278, 278, 5, '2008-10-27 14:04:48', NULL, '2008-10-27 14:04:48', NULL, 28, 68, 47, 0),
     1361(279, 279, 5, '2008-10-27 14:05:45', NULL, '2008-10-27 14:05:45', NULL, 28, 78, 1, 0),
     1362(280, 280, 5, '2008-10-27 14:08:15', NULL, '2008-10-27 14:08:15', NULL, 28, 69, 192, 0),
     1363(281, 281, 5, '2008-10-27 14:08:30', NULL, '2008-10-27 14:08:30', NULL, 28, 78, 2, 1),
     1364(282, 282, 5, '2008-10-27 14:08:44', NULL, '2008-10-27 14:08:44', NULL, 28, 69, 193, 1),
     1365(283, 283, 5, '2008-10-27 14:09:20', NULL, '2008-10-27 14:09:20', NULL, 28, 78, 3, 0),
     1366(284, 284, 5, '2008-10-27 14:09:27', NULL, '2008-10-27 14:09:27', NULL, 28, 78, 2, 2),
     1367(285, 285, 5, '2008-10-27 14:09:51', NULL, '2008-10-27 14:09:51', NULL, 28, 78, 4, 0),
     1368(286, 286, 5, '2008-10-27 14:10:12', NULL, '2008-10-27 14:10:12', NULL, 28, 78, 5, 0),
     1369(287, 287, 5, '2008-10-27 14:10:43', NULL, '2008-10-27 14:10:43', NULL, 28, 43, 83, 0),
     1370(288, 288, 5, '2008-10-27 14:11:38', NULL, '2008-10-27 14:11:38', NULL, 28, 54, 60, 0),
     1371(289, 289, 5, '2008-10-27 14:12:09', NULL, '2008-10-27 14:12:09', NULL, 28, 69, 194, 0),
     1372(290, 290, 5, '2008-10-27 14:13:05', NULL, '2008-10-27 14:13:05', NULL, 28, 69, 195, 0),
     1373(291, 291, 5, '2008-10-27 14:14:03', NULL, '2008-10-27 14:14:03', NULL, 28, 68, 48, 0),
     1374(292, 292, 5, '2008-10-27 14:14:41', NULL, '2008-10-27 14:14:41', NULL, 28, 78, 6, 0);
     1375
     1376-- --------------------------------------------------------
     1377
     1378--
     1379-- Struktura tabulky `SystemMenu`
     1380--
     1381
     1382CREATE TABLE IF NOT EXISTS `SystemMenu` (
     1383  `Id` int(11) NOT NULL auto_increment,
     1384  `ItemId` int(11) NOT NULL,
     1385  `Author` int(11) NOT NULL,
     1386  `ValidTimeFrom` datetime default NULL,
     1387  `ValidTimeTo` datetime default NULL,
     1388  `CreationTime` datetime default NULL,
     1389  `DeletionTime` datetime default NULL,
     1390  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     1391  `SystemListItems` int(11) NOT NULL,
    6541392  PRIMARY KEY  (`Id`)
    6551393) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
    6561394
    6571395--
    658 -- Vypisuji data pro tabulku `SystemFile`
    659 --
    660 
     1396-- Vypisuji data pro tabulku `SystemMenu`
     1397--
     1398
     1399INSERT INTO `SystemMenu` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `SystemListItems`) VALUES
     1400(1, 1, 5, '2008-10-21 08:14:39', NULL, '2008-10-21 08:14:39', NULL, 'Systém', 0),
     1401(2, 2, 5, '2008-10-21 08:14:59', NULL, '2008-10-21 08:14:59', NULL, 'Evidence sítě', 0),
     1402(3, 3, 5, '2008-10-21 08:55:36', NULL, '2008-10-21 08:55:36', NULL, 'Řízení přístupu', 0),
     1403(4, 4, 28, '2008-10-21 14:38:33', NULL, '2008-10-21 14:38:33', NULL, 'Webové stránky', 0);
     1404
     1405-- --------------------------------------------------------
     1406
     1407--
     1408-- Struktura tabulky `SystemType`
     1409--
     1410
     1411CREATE TABLE IF NOT EXISTS `SystemType` (
     1412  `Id` int(11) NOT NULL auto_increment,
     1413  `ItemId` int(11) NOT NULL,
     1414  `Author` int(11) NOT NULL,
     1415  `ValidTimeFrom` datetime default NULL,
     1416  `ValidTimeTo` datetime default NULL,
     1417  `CreationTime` datetime default NULL,
     1418  `DeletionTime` datetime default NULL,
     1419  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     1420  `Description` varchar(255) collate utf8_czech_ci NOT NULL,
     1421  `ParentType` int(255) NOT NULL,
     1422  `Parameters` varchar(255) collate utf8_czech_ci NOT NULL,
     1423  `System` tinyint(1) NOT NULL default '0',
     1424  `DbDataType` varchar(255) collate utf8_czech_ci NOT NULL,
     1425  `ParameterList` int(11) NOT NULL,
     1426  PRIMARY KEY  (`Id`)
     1427) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=61 ;
     1428
     1429--
     1430-- Vypisuji data pro tabulku `SystemType`
     1431--
     1432
     1433INSERT INTO `SystemType` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Description`, `ParentType`, `Parameters`, `System`, `DbDataType`, `ParameterList`) VALUES
     1434(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', 0),
     1435(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', 0),
     1436(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)', 0),
     1437(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', 0),
     1438(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, 'INT', 0),
     1439(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, 'INT', 0),
     1440(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, 'INT', 0),
     1441(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, 'INT', 0),
     1442(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, 'INT', 0),
     1443(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, 'INT', 0),
     1444(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, 'INT', 0),
     1445(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', 0),
     1446(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', 0),
     1447(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', 0),
     1448(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, 'INT', 0),
     1449(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', 0),
     1450(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, 'INT', 0),
     1451(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)', 0),
     1452(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)', 0),
     1453(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)', 0),
     1454(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, 'INT', 0),
     1455(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, 'INT', 0),
     1456(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, 'INT', 0),
     1457(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, 'INT', 0),
     1458(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, 'INT', 0),
     1459(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, 'INT', 0),
     1460(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, 'INT', 0),
     1461(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, 'INT', 0),
     1462(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, 'INT', 0),
     1463(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, 'INT', 0),
     1464(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, 'INT', 0),
     1465(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, 'INT', 0),
     1466(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, 'INT', 0),
     1467(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, 'INT', 0),
     1468(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, 'INT', 0),
     1469(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, 'INT', 0),
     1470(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, 'INT', 0),
     1471(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, 'INT', 0),
     1472(39, 39, 5, '2008-10-13 10:03:19', NULL, '2008-10-13 10:03:19', NULL, 'PointerToPermissionGroup', 'Ukazatel na skupinu oprávnění', 12, 'PermissionGroup', 0, 'INT', 0),
     1473(40, 40, 5, '2008-10-13 10:33:20', NULL, '2008-10-13 10:33:20', NULL, 'MySQLDataTypes', 'Databázový datový typ ', 14, 'INT|VARCHAR(255)|TEXT|FLOAT|DOUBLE|TIME|DATE|DATETIME|', 1, 'INT', 0),
     1474(41, 41, 5, '2008-10-13 10:40:38', NULL, '2008-10-13 10:40:38', NULL, 'PointerToPermissionPermissionGroup', 'Definovaná oprávnění', 13, 'Permission|PermissionGroup', 0, 'INT', 0),
     1475(42, 42, 5, '2008-10-13 10:43:25', NULL, '2008-10-13 10:43:25', NULL, 'PermissionRights', 'Typ oprávnění', 14, 'Žádné|Čtení|Čtení i zápis', 0, 'INT', 0),
     1476(43, 43, 5, '2008-10-13 12:05:14', NULL, '2008-10-13 12:05:14', NULL, 'PointerToUserPermissionGroup', 'Uživatelé s oprávněním', 13, 'User|PermissionGroup', 0, 'INT', 0),
     1477(44, 44, 5, '2008-10-13 12:16:46', NULL, '2008-10-13 12:16:46', NULL, 'ActionType', 'Typ akce', 14, 'Přidáno|Upraveno|Odebráno', 0, 'INT', 0),
     1478(45, 31, 5, '2008-10-13 13:39:08', NULL, '2008-10-13 13:39:08', NULL, 'PointerToHost', '', 12, 'Host', 0, 'INT', 0),
     1479(46, 45, 5, '2008-10-14 07:02:50', NULL, '2008-10-14 07:02:50', NULL, 'DateTime', 'Datum a čas', 0, '', 1, 'DATETIME', 0),
     1480(47, 46, 5, '2008-10-14 07:48:07', NULL, '2008-10-14 07:48:07', NULL, 'File', 'Soubor', 0, '', 1, 'INT', 0),
     1481(48, 47, 5, '2008-10-21 08:13:34', NULL, '2008-10-21 08:13:34', '2008-10-21 08:18:00', 'PointerToMenu', 'Ukazatel na menu', 12, '', 0, 'INT', 0),
     1482(49, 47, 5, '2008-10-21 08:18:00', NULL, '2008-10-21 08:18:00', '2008-10-21 08:19:02', 'PointerToMenu', 'Ukazatel na menu', 12, 'Menu', 0, 'INT', 0),
     1483(50, 47, 5, '2008-10-21 08:19:02', NULL, '2008-10-21 08:19:02', NULL, 'PointerToMenu', 'Ukazatel na menu', 12, 'SystemMenu', 0, 'INT', 0),
     1484(51, 48, 5, '2008-10-21 08:22:44', NULL, '2008-10-21 08:22:44', '2008-10-21 08:24:13', 'PointerToSystemListMenu', 'Položky menu', 13, 'SystemList:Menu', 0, 'INT', 0),
     1485(52, 48, 5, '2008-10-21 08:24:13', NULL, '2008-10-21 08:24:13', NULL, 'PointerToSystemListMenu', 'Položky menu', 13, 'SystemList|Menu', 0, 'INT', 0),
     1486(53, 49, 5, '2008-10-21 09:58:14', NULL, '2008-10-21 09:58:14', NULL, 'GPS', 'Zemská souřadnice', 0, '', 1, 'INT', 0),
     1487(54, 50, 28, '2008-10-21 14:42:57', NULL, '2008-10-21 14:42:57', NULL, 'PointerToNewsGroup', 'Ukazatel na skupinu aktualit', 12, 'NewsGroup', 0, 'INT', 0),
     1488(55, 51, 28, '2008-10-21 14:45:16', NULL, '2008-10-21 14:45:16', '2008-10-21 15:56:12', 'PointerToNewsItemGroup', 'Aktuality', 13, 'NewsItem|Group', 0, 'INT', 0),
     1489(56, 51, 28, '2008-10-21 15:56:12', NULL, '2008-10-21 15:56:12', NULL, 'PointerToNewsItemGroup', 'Aktuality', 13, 'NewsItem|NewsGroup', 0, 'INT', 0),
     1490(57, 52, 5, '2008-10-27 13:59:51', NULL, '2008-10-27 13:59:51', '2008-10-27 14:00:37', 'PointerToSystemTypeParameter', 'Ukazatel na seznam paramtrů', 13, '', 0, 'INT', 0),
     1491(58, 52, 5, '2008-10-27 14:00:37', NULL, '2008-10-27 14:00:37', '2008-10-27 14:02:53', 'PointerToSystemTypeParameter', 'Ukazatel na seznam paramtrů', 13, 'SystemTypeParameter|Type', 0, 'INT', 0),
     1492(59, 52, 5, '2008-10-27 14:02:53', NULL, '2008-10-27 14:02:53', NULL, 'PointerToSystemTypeParameter', 'Ukazatel na seznam paramtrů', 13, 'SystemTypeParameter|ParentType', 0, 'INT', 0),
     1493(60, 53, 5, '2008-10-27 14:11:38', NULL, '2008-10-27 14:11:38', NULL, 'PointerToSystemEnumerationState', 'Seznam stavů výčtu', 13, 'SystemEnumerationState|ParentType', 0, 'INT', 0);
     1494
     1495-- --------------------------------------------------------
     1496
     1497--
     1498-- Struktura tabulky `SystemTypeParameter`
     1499--
     1500
     1501CREATE TABLE IF NOT EXISTS `SystemTypeParameter` (
     1502  `Id` int(11) NOT NULL auto_increment,
     1503  `ItemId` int(11) NOT NULL,
     1504  `Author` int(11) NOT NULL,
     1505  `ValidTimeFrom` datetime default NULL,
     1506  `ValidTimeTo` datetime default NULL,
     1507  `CreationTime` datetime default NULL,
     1508  `DeletionTime` datetime default NULL,
     1509  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     1510  `Type` int(11) NOT NULL,
     1511  `ParentType` int(11) NOT NULL,
     1512  `Description` varchar(255) collate utf8_czech_ci NOT NULL,
     1513  PRIMARY KEY  (`Id`)
     1514) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7 ;
     1515
     1516--
     1517-- Vypisuji data pro tabulku `SystemTypeParameter`
     1518--
     1519
     1520INSERT INTO `SystemTypeParameter` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Type`, `ParentType`, `Description`) VALUES
     1521(1, 1, 5, '2008-10-27 14:05:45', NULL, '2008-10-27 14:05:45', '2008-10-27 14:08:30', 'List', 34, 12, ''),
     1522(2, 1, 5, '2008-10-27 14:08:30', NULL, '2008-10-27 14:08:30', NULL, 'List', 34, 12, 'Seznam'),
     1523(3, 2, 5, '2008-10-27 14:09:20', NULL, '2008-10-27 14:09:20', '2008-10-27 14:09:27', 'ColumnId', 1, 12, 'Identifikace sloupce'),
     1524(4, 3, 5, '2008-10-27 14:09:51', NULL, '2008-10-27 14:09:51', NULL, 'List', 34, 13, 'Seznam'),
     1525(5, 4, 5, '2008-10-27 14:10:12', NULL, '2008-10-27 14:10:12', NULL, 'Column', 1, 13, 'Identifikace sloupce'),
     1526(6, 5, 5, '2008-10-27 14:14:41', NULL, '2008-10-27 14:14:41', NULL, 'StateList', 53, 14, 'Seznam stavů');
     1527
     1528-- --------------------------------------------------------
     1529
     1530--
     1531-- Struktura tabulky `Tariff`
     1532--
     1533
     1534CREATE TABLE IF NOT EXISTS `Tariff` (
     1535  `Id` int(11) NOT NULL auto_increment,
     1536  `ItemId` int(11) NOT NULL,
     1537  `Author` int(11) NOT NULL,
     1538  `ValidTimeFrom` datetime default NULL,
     1539  `ValidTimeTo` datetime default NULL,
     1540  `CreationTime` datetime default NULL,
     1541  `DeletionTime` datetime default NULL,
     1542  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     1543  `Price` float NOT NULL,
     1544  `MinUploadSpeed` int(11) NOT NULL,
     1545  `MaxUploadSpeed` int(11) NOT NULL,
     1546  `MinDownloadSpeed` int(11) NOT NULL,
     1547  `MaxDownloadSpeed` int(11) NOT NULL,
     1548  `MemberList` int(11) NOT NULL,
     1549  PRIMARY KEY  (`Id`)
     1550) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ;
     1551
     1552--
     1553-- Vypisuji data pro tabulku `Tariff`
     1554--
     1555
     1556INSERT INTO `Tariff` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Price`, `MinUploadSpeed`, `MaxUploadSpeed`, `MinDownloadSpeed`, `MaxDownloadSpeed`, `MemberList`) VALUES
     1557(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),
     1558(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),
     1559(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),
     1560(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),
     1561(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);
     1562
     1563-- --------------------------------------------------------
     1564
     1565--
     1566-- Struktura tabulky `test`
     1567--
     1568
     1569CREATE TABLE IF NOT EXISTS `test` (
     1570  `Id` int(11) NOT NULL auto_increment,
     1571  `ItemId` int(11) NOT NULL,
     1572  `Author` int(11) NOT NULL,
     1573  `ValidTimeFrom` datetime default NULL,
     1574  `ValidTimeTo` datetime default NULL,
     1575  `CreationTime` datetime default NULL,
     1576  `DeletionTime` datetime default NULL,
     1577  PRIMARY KEY  (`Id`)
     1578) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
     1579
     1580--
     1581-- Vypisuji data pro tabulku `test`
     1582--
     1583
     1584
     1585-- --------------------------------------------------------
     1586
     1587--
     1588-- Struktura tabulky `User`
     1589--
     1590
     1591CREATE TABLE IF NOT EXISTS `User` (
     1592  `Id` int(11) NOT NULL auto_increment,
     1593  `ItemId` int(11) NOT NULL,
     1594  `Author` int(11) NOT NULL,
     1595  `ValidTimeFrom` datetime default NULL,
     1596  `ValidTimeTo` datetime default NULL,
     1597  `CreationTime` datetime default NULL,
     1598  `DeletionTime` datetime default NULL,
     1599  `UserName` varchar(255) collate utf8_czech_ci NOT NULL,
     1600  `Password` varchar(255) collate utf8_czech_ci NOT NULL,
     1601  `FirstName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
     1602  `SecondName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
     1603  `Email` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
     1604  `ICQ` int(11) NOT NULL,
     1605  `Sex` int(11) NOT NULL default '0',
     1606  `BirthDay` date NOT NULL,
     1607  `Phone` varchar(255) collate utf8_czech_ci NOT NULL,
     1608  `Member` int(11) NOT NULL,
     1609  `RegistrationTime` datetime NOT NULL,
     1610  `LastLoginTime` datetime NOT NULL,
     1611  `Locked` tinyint(1) NOT NULL,
     1612  `LastIpAddress` varchar(255) collate utf8_czech_ci NOT NULL,
     1613  `PermissionGroup` int(11) NOT NULL,
     1614  PRIMARY KEY  (`Id`)
     1615) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=36 ;
     1616
     1617--
     1618-- Vypisuji data pro tabulku `User`
     1619--
     1620
     1621INSERT INTO `User` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `UserName`, `Password`, `FirstName`, `SecondName`, `Email`, `ICQ`, `Sex`, `BirthDay`, `Phone`, `Member`, `RegistrationTime`, `LastLoginTime`, `Locked`, `LastIpAddress`, `PermissionGroup`) VALUES
     1622(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, '', 0),
     1623(35, 2, 5, '2008-10-21 14:16:35', NULL, '2008-10-21 14:16:35', NULL, 'petr', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 0, '1900-01-01 00:00:00', '2008-10-21 16:10:26', 0, '', 5),
     1624(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, '', 0),
     1625(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-25 20:56:10', 0, '', 0),
     1626(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, '', 0),
     1627(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, '', 0),
     1628(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, '', 0),
     1629(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, '', 0),
     1630(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, '', 0),
     1631(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 12:56:43', '', '', '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, '', 0),
     1632(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, '', 0),
     1633(13, 1, 5, '2008-10-13 10:06:57', NULL, '2008-10-13 10:06:57', NULL, '', 'fdsfsdfsd', 'Alfons', 'Much', 'mucha@all.cz', 89, 0, '1900-01-01', '', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6),
     1634(14, 5, 5, '2008-10-13 10:07:33', NULL, '2008-10-13 10:07:33', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 2),
     1635(15, 2, 5, '2008-10-13 10:07:44', NULL, '2008-10-13 10:07:44', '2008-10-21 13:33:00', '', '', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5),
     1636(16, 6, 5, '2008-10-13 10:07:58', NULL, '2008-10-13 10:07:58', '2008-10-15 15:53:45', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6),
     1637(17, 10, 5, '2008-10-13 12:03:27', NULL, '2008-10-13 12:03:27', NULL, '', '', 'Smrťák', 'Krutý', 'smrt@peklo.cz', 111222333, 0, '1900-01-01', '', 5, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6),
     1638(18, 9, 5, '2008-10-13 12:03:50', NULL, '2008-10-13 12:03:50', NULL, '', '', 'Jonny', 'Hurikán', 'storm@atlas.cz', 16, 0, '1988-04-05', '224556778', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5),
     1639(19, 7, 5, '2008-10-13 12:04:01', NULL, '2008-10-13 12:04:01', NULL, '', '', 'Petr', 'Slovák', 'slovak@zdarma.cz', 34, 0, '1900-01-01', '', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5),
     1640(20, 4, 5, '2008-10-13 12:04:10', NULL, '2008-10-13 12:04:10', NULL, 'ferda', '123', 'Ferda', 'Mravenec', 'ferda@mraveniste.cz', 1, 0, '1900-01-01', '', 2, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5),
     1641(21, 8, 5, '2008-10-13 13:57:30', NULL, '2008-10-13 13:57:30', NULL, 'alenka', 'dsdasas', 'Alena', 'Kocourková', 'alena.kocourkova@centrum.cz', 324545454, 1, '2004-10-09', '223344556', 1, '1915-01-01 00:00:00', '1900-01-01 00:00:00', 0, '192.168.0.1', 6),
     1642(22, 5, 5, '2008-10-14 09:47:32', NULL, '2008-10-14 09:47:32', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 2),
     1643(23, 5, 5, '2008-10-14 09:57:36', NULL, '2008-10-14 09:57:36', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 3),
     1644(24, 5, 5, '2008-10-14 09:57:54', NULL, '2008-10-14 09:57:54', '2008-10-21 07:06:35', 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 2),
     1645(25, 6, 5, '2008-10-15 15:53:45', NULL, '2008-10-15 15:53:45', '2008-10-15 15:55:21', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '999', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6),
     1646(26, 6, 5, '2008-10-15 15:55:21', NULL, '2008-10-15 15:55:21', '2008-10-15 16:00:07', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '999', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6),
     1647(27, 6, 5, '2008-10-15 16:00:07', NULL, '2008-10-15 16:00:07', '2008-10-21 09:06:54', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '999', 1, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 6),
     1648(28, 5, 5, '2008-10-21 07:06:35', NULL, '2008-10-21 07:06:35', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '1900-01-01', '', 6, '1900-01-01 00:00:00', '2008-10-13 00:00:00', 0, '', 1),
     1649(29, 6, 5, '2008-10-21 09:06:54', NULL, '2008-10-21 09:06:54', NULL, 'joda', 'muhehe', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '1900-01-01', '999', 4, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 3),
     1650(30, 11, 5, '2008-10-21 12:56:43', NULL, '2008-10-21 12:56:43', NULL, '', '', 'Karel', 'Nejedlý', 'starosta@obec-milosice.cz', 0, 0, '1900-01-01', '443666333', 5, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5),
     1651(31, 13, 5, '2008-10-21 13:13:52', NULL, '2008-10-21 13:13:52', NULL, 'ježek', 'dsds', 'Sony', '', 'sony@megadrive.com', 2222, 0, '1904-01-01', '', 3, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 1, '', 4),
     1652(32, 2, 5, '2008-10-21 13:33:00', NULL, '2008-10-21 13:33:00', '2008-10-21 13:45:09', 'petr', 'hruboš', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 0, '1900-01-01 00:00:00', '2008-10-21 13:56:39', 0, '', 5),
     1653(33, 2, 5, '2008-10-21 13:45:09', NULL, '2008-10-21 13:45:09', '2008-10-21 13:45:28', 'petr', 'c6bd4c44228e4c1a18248ba51c744ce7d36db324', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 0, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5),
     1654(34, 2, 5, '2008-10-21 13:45:28', NULL, '2008-10-21 13:45:28', '2008-10-21 14:16:35', 'petr', 'c6bd4c44228e4c1a18248ba51c744ce7d36db324', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '1900-01-01', '123456789', 0, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 0, '', 5);
     1655
     1656-- --------------------------------------------------------
     1657
     1658--
     1659-- Struktura tabulky `UserOnline`
     1660--
     1661
     1662CREATE TABLE IF NOT EXISTS `UserOnline` (
     1663  `User` int(11) NOT NULL,
     1664  `LoginTime` datetime NOT NULL,
     1665  `ActivityTime` datetime NOT NULL,
     1666  `SessionId` varchar(255) collate utf8_czech_ci NOT NULL,
     1667  `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL,
     1668  `HostName` varchar(255) collate utf8_czech_ci NOT NULL,
     1669  `Id` int(11) NOT NULL auto_increment,
     1670  `ItemId` int(11) NOT NULL,
     1671  `Author` int(11) NOT NULL,
     1672  `ValidTimeFrom` datetime default NULL,
     1673  `ValidTimeTo` datetime default NULL,
     1674  `CreationTime` datetime default NULL,
     1675  `DeletionTime` datetime default NULL,
     1676  PRIMARY KEY  (`Id`),
     1677  KEY `User` (`User`)
     1678) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=37 ;
     1679
     1680--
     1681-- Vypisuji data pro tabulku `UserOnline`
     1682--
     1683
     1684INSERT INTO `UserOnline` (`User`, `LoginTime`, `ActivityTime`, `SessionId`, `IpAddress`, `HostName`, `Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`) VALUES
     1685(5, '2008-10-25 20:56:03', '2008-10-27 14:15:02', 'koaodnvsoi9lehrih06mc3sev2', '192.168.0.23', '192.168.0.23', 36, 5, 0, NULL, NULL, NULL, NULL);

  • types/PointerOneToOne.php

    r22 r24  
    99    //print_r($Item);
    1010    $Columns = '';
    11     $TargetTable = $Type['Parameters'][0];
    12 
    13     $List = GetListDefinition($TargetTable);
     11    $List = GetListDefinition($Type['Parameters'][0]);
     12    $TargetTable = $List['TableName'];
    1413    foreach($List['Items'] as $ListItem)
    1514      if($ListItem['VisibleInPointer'] == 1) $Columns .= '`'.$ListItem['Name'].'`," ",';
    … …  
    2827
    2928    $Columns = '';
    30     $TargetTable = $Type['Parameters'][0];
    31 
    32     $List = GetListDefinition($TargetTable);
     29    $List = GetListDefinition($Type['Parameters'][0]);
     30    $TargetTable = $List['TableName'];
    3331    foreach($List['Items'] as $ListItem)
    3432      if($ListItem['VisibleInPointer'] == 1) $Columns .= 't1.`'.$ListItem['Name'].'`," ",';

  • types/include.php

    r23 r24  
    2121define('TypeStringId', 3);
    2222define('TypeDateId', 2);
     23define('TypePointerOneToOneId', 12);
     24define('TypePointerOneToManyId', 13);
    2325define('TypePasswordId', 15);
    2426define('TypeFloatId', 16);
Note: See TracChangeset for help on using the changeset viewer.