Changeset 10

Timestamp:

Oct 12, 2008, 8:43:23 PM (16 years ago)

Author:

george

Message:

• Upraveno: Odkazy na datové typy jsou nyní uváděny přímo jako ukazatele do tabulky SystemTypes oproti dřívějšímu textovému zápisu. Veškeré parametrické typy je nutno nyní definovat přes tabulku SystemTypes.
• Upraveno: Sloupec ParentType v tabulce SystemTypes nyní ukazuje na rodičovský typ pomocí ukazatele typu INT.
• Upraveno: Názvy funkcí vykreslování datových typů sjednoceny na systém událostí a tedy OnView a OnEdit.
• Přidáno: Událost OnAdd pro tabulky SystemList a SystemListItem, které zajistí automatické vytvoření uživatelských tabulek.

Files:

• base.php (modified) (16 diffs)
• forms.php (modified) (3 diffs)
• lists (added)
• lists/SystemList.php (added)
• lists/SystemListItem.php (added)
• sql/demo_database.sql (modified) (36 diffs)
• sql/system_structure.sql (modified) (6 diffs)
• types/Boolean.php (modified) (1 diff)
• types/Date.php (modified) (2 diffs)
• types/Enumeration.php (modified) (1 diff)
• types/Float.php (modified) (2 diffs)
• types/Hidden.php (added)
• types/Hyperlink.php (modified) (2 diffs)
• types/IPv4Address.php (modified) (3 diffs)
• types/Integer.php (modified) (2 diffs)
• types/Password.php (modified) (2 diffs)
• types/PointerOneToMany.php (modified) (2 diffs)
• types/PointerOneToOne.php (modified) (4 diffs)
• types/String.php (modified) (2 diffs)

base.php

@@ -12 +12 @@
 include('types/Float.php');
 include('types/Hyperlink.php');
+include('types/Hidden.php');
+
+// Include list events definitions
+include('lists/SystemList.php');
+include('lists/SystemListItem.php');
 
 function ShowList($List, $Column = '', $ColumnValue = 0, $Title = '')
@@ -73 +78 @@
       if($Item['VisibleInList'] == 1)
       {
-        $ItemType = explode(':', $Item['Type']);
-        $Type = $Types[$ItemType[0]];
         $ItemDefinition = array('Name' => $Index, 'Value' => $DbRow[$Index], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
-        if(is_callable($Type['CallbackView'])) $Value = $Type['CallbackView']($Type, $ItemDefinition);
-        else $Value = $Type['CallbackView'];
-        $Output .= '<td>'.$Value.'</td>';
+        $Output .= '<td>'.ExecuteTypeEvent($Item['Type'], 'OnView', $ItemDefinition).'</td>';
       }
     }
@@ -101 +102 @@
       $Output .= '<th><a href="?OrderColumn='.$Item['Name'].'">'.$Item['TextBefore'].'</a></th>';
   }
-  $Output .= '<th>Akce</th></tr>';
+  $Output .= '<th><a href="?OrderColumn=Author">Autor</a></th><th><a href="?OrderColumn=CreationTime">Čas vytvoření</a></th><th>Akce</th></tr>';
 
   $Where = ' AND (ItemId='.$Id.')';
@@ -129 +130 @@
   $TotalItemCount = $DbRow[0];
 
-  $DbResult = $Database->query('SELECT * FROM `'.$List['TableName'].'` WHERE 1'.$Where.' LIMIT '.($Page * $Config['Web']['ItemsPerPage']).', '.$Config['Web']['ItemsPerPage']);
+  $DbResult = $Database->query('SELECT * FROM `'.$List['TableName'].'` AS t1 WHERE 1'.$Where.' LIMIT '.($Page * $Config['Web']['ItemsPerPage']).', '.$Config['Web']['ItemsPerPage']);
   //echo($Database->LastQuery.'<br>');
   while($DbRow = $DbResult->fetch_array())
   {
     $Output .= '<tr>';
-    foreach($List['Items'] as $Index => $Item)
+    foreach($List['Items'] as $Item)
     {
       if($Item['VisibleInList'] == 1)
       {
-        $ItemType = explode(':', $Item['Type']);
-        $Type = $Types[$ItemType[0]];
-        $ItemDefinition = array('Name' => $Index, 'Value' => $DbRow[$Index], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
-        if(is_callable($Type['CallbackView'])) $Value = $Type['CallbackView']($Type, $ItemDefinition);
-        else $Value = $Type['CallbackView'];
-        $Output .= '<td>'.$Value.'</td>';
-      }
-    }
+        $ItemDefinition = array('Name' => $Item['Name'], 'Value' => $DbRow[$Item['Name']], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
+        $Output .= '<td>'.ExecuteTypeEvent($Item['Type'], 'OnView', $ItemDefinition).'</td>';
+      }
+    }
+    $Item = array('Name' => 'Author', 'Type' => 'PointerOneToOne:User');
+    $ItemType = explode(':', $Item['Type']);
+    $Type = $Types[$ItemType[0]];
+    $ItemDefinition = array('Name' => $Item['Name'], 'Value' => $DbRow[$Item['Name']], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
+    if(is_callable($Type['CallbackView'])) $Value = $Type['CallbackView']($Type, $ItemDefinition);
+      else $Value = $Type['CallbackView'];
+    $Output .= '<td>'.$Value.'</td>';
+
+    $Output .= '<td>'.$DbRow['CreationTime'].'</td>';
     $Output .= '<td><a href="?Action=ViewItem&amp;Table='.$List['TableName'].'&amp;Item='.$DbRow['Id'].'">Zobrazit</a> </td></tr>';
   }
   $Output .= '</table>';
   $Output .= PagesList($Page, $TotalItemCount);
-  $Output .= '<a href="?Action=AddItem&amp;Table='.$List['TableName'].$ColumnSelection.'">Přidat</a> '.$FullListLink;
+  $Output .= '<a href="?Action=ShowList&amp;Table='.$List['TableName'].'">Celkový seznam</a>';
   return($Output);
 }
@@ -164 +170 @@
     foreach($List['Items'] as $Index => $Item)
     {
-      $ItemType = explode(':', $Item['Type']);
-      if($ItemType[0] != 'PointerOneToMany')
+      if($Types[$Item['Type']]['BaseType'] != 'PointerOneToMany')
       {
         $DefinitionItems[] = array('Name' => $Index, 'Caption' => $Item['TextBefore'].$Required, 'Value' => $DbRow[$Index], 'SourceTable' => $List['TableName'], 'SourceItemId' => $DbRow['Id'], 'Type' => $Item['Type']);
@@ -197 +202 @@
   foreach($List['Items'] as $Index => $Item)
   {
-    $ItemType = explode(':', $Item['Type']);
-    if($ItemType[0] != 'PointerOneToMany')
+    if($Types[$Item['Type']]['BaseType'] != 'PointerOneToMany')
     {
       $Values[$Index] = $_POST[$Index];
@@ -222 +226 @@
   $DefinitionItems = array();
   $AfterTableOutput = '';
-  foreach($List['Items'] as $Index => $Item)
-  {
-    $ItemType = explode(':', $Item['Type']);
-    if(($ItemType[0] != 'PointerOneToMany') and ($Item['Name'] != $Column))
+  foreach($List['Items'] as $Item)
+  {
+    //echo($Item['Name'].',');
+    if(($Types[$Item['Type']]['BaseType'] != 'PointerOneToMany') and ($Item['Name'] != $Column))
     {
       if($Item['Required'] == 1) $Required = '*'; else $Required = '';
-      $DefinitionItems[] = array('Name' => $Index, 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => '', 'SourceTable' => $List['TableName'], 'SourceItemId' => 0);
+      $DefinitionItems[] = array('Name' => $Item['Name'], 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => '', 'SourceTable' => $List['TableName'], 'SourceItemId' => 0);
     } else
     if($Item['Name'] == $Column)
     {
-      $DefinitionItems[] = array('Name' => $Column, 'Type' => 'String', 'Caption' => '', 'Value' => $ColumnValue);
-    }
-  }
+      $DefinitionItems[] = array('Name' => $Column, 'Type' => 'Hidden', 'Caption' => '', 'Value' => $ColumnValue);
+    }
+  }
+  $DefinitionItems[] = array('Name' => 'Column', 'Type' => 'Hidden', 'Caption' => '', 'Value' => $Column);
+
   $Form = new Form();
   $Form->Definition = array
@@ -261 +267 @@
   foreach($List['Items'] as $Index => $Item)
   {
-    $ItemType = explode(':', $Item['Type']);
-    if($ItemType[0] != 'PointerOneToMany')
+    if($Types[$Item['Type']]['BaseType'] != 'PointerOneToMany')
     {
       $Values[$Index] = $_POST[$Index];
@@ -278 +283 @@
   $Output = 'Položka přidána';
   $Output .= ShowViewItem($List, $Database->insert_id);
+  $Values['Column'] = $_POST['Column'];
+  ExecuteListEvent($List['TableName'], 'OnAdd', $Values);
   return($Output);
 }
@@ -292 +299 @@
     foreach($List['Items'] as $Index => $Item)
     {
-      $ItemType = explode(':', $Item['Type']);
-      if($ItemType[0] != 'PointerOneToMany')
+      if($Types[$Item['Type']]['BaseType'] != 'PointerOneToMany')
       {
         $DefinitionItems[] = array('Name' => $Index, 'Type' => $Item['Type'], 'Caption' => $Item['TextBefore'].$Required, 'Value' => $DbRow[$Index], 'SourceTable' => $List['TableName'], 'SourceItemId' => 0);
@@ -318 +324 @@
     foreach($List['Items'] as $Index => $Item)
     {
-      $ItemType = explode(':', $Item['Type']);
-      if($ItemType[0] == 'PointerOneToMany')
-      {
-        $SubList = $Lists[$ItemType[1]];
-        $Output .= ShowList($SubList, $ItemType[2], $DbRow['Id'], $Item['TextBefore']).'<br /><br />';
+      if($Types[$Item['Type']]['BaseType'] == 'PointerOneToMany')
+      {
+        $SubList = $Lists[$Types[$Item['Type']]['Parameters'][0]];
+        $Output .= ShowList($SubList, $Types[$Item['Type']]['Parameters'][1], $DbRow['Id'], $Item['TextBefore']).'<br /><br />';
       }
     }
@@ -362 +367 @@
     if(array_key_exists($Var, $_GET)) $_SESSION[$Var] = $_GET[$Var];
   }
-
   $Output = '';
   if(array_key_exists('Table', $_SESSION) and array_key_exists($_SESSION['Table'], $Lists))
@@ -434 +438 @@
   {
     $DbRow['Parameters'] = explode('|', $DbRow['Parameters']);
-    $Types[$DbRow['Name']] = $DbRow;
+    $DbRow['BaseType'] = $DbRow['Name'];
+    $Types[$DbRow['Id']] = $DbRow;
   }
 
@@ -440 +445 @@
   foreach($Types as $Index => $Type)
   {
-    if($Type['ParentType'] != '')
+    if($Type['ParentType'] != 0)
     {
       foreach($Type as $Index2 => $Item)
@@ -447 +452 @@
         $Types[$Index][$Index2] = $Types[$Type['ParentType']][$Index2];
       }
+      $Types[$Index]['BaseType'] = $Types[$Type['ParentType']]['Name'];
     }
   }
@@ -452 +458 @@
 }
 
+function ExecuteListEvent($Table, $Event, $Parameters)
+{
+  $Callback = 'List'.$Table.$Event;
+  if(is_callable($Callback)) $Callback($Parameters);
+}
+
+function ExecuteTypeEvent($Type, $Event, $Parameters)
+{
+  global $Types;
+
+  $Callback = 'Type'.$Types[$Type]['BaseType'].$Event;
+  //echo($Callback.',');
+  if(is_callable($Callback)) return($Callback($Parameters));
+    else return($Callback);
+}
+
 ?>

forms.php

@@ -13 +13 @@
     $Output = '<center><form action="'.$this->OnSubmit.'" method="post"><div align="center">';
     $Table = $this->ShowEditBlock();
-    $Output .= $this->Definition['Title'].Table($Table).'<input type="submit" value="'.$this->Definition['SubmitBuffonText'].'"></div></form>';
+    $Output .= $this->Definition['Title'].Table($Table).$this->ShowHiddenBlock().'<input type="submit" value="'.$this->Definition['SubmitBuffonText'].'"></div></form>';
     return($Output);
   }
@@ -28 +28 @@
     foreach($this->Definition['Items'] as $Item)
     {
-      $ItemType = explode(':', $Item['Type']);
-      $Index = $Item['Name'];
-      $Type = $Types[$ItemType[0]];
-      if(!array_key_exists($Index, $this->Values) and isset($Item['Value'])) $this->Values[$Index] = $Item['Value'];
-      if(is_callable($Type['CallbackEdit'])) $Edit = $Type['CallbackEdit']($Type, $Item);
-      else $Edit = $Type['CallbackEdit']; 
-      array_push($Table['Rows'], array($Item['Caption'].':', $Edit));
+      if($Item['Type'] != 'Hidden')
+      {
+        if(!array_key_exists($Index, $this->Values) and isset($Item['Value'])) $this->Values[$Index] = $Item['Value'];
+        $Edit = ExecuteTypeEvent($Item['Type'], 'OnEdit', $Item);
+        array_push($Table['Rows'], array($Item['Caption'].':', $Edit));
+      }
     }
     return($Table);
+  }
+
+  function ShowHiddenBlock($Context = '')
+  {
+    global $Database, $Types;
+
+    $Output = '';
+    if($Context != '') $Context = $Context.'-';
+    foreach($this->Definition['Items'] as $Item)
+    {
+      if($Item['Type'] == 'Hidden')
+      {
+        if(!array_key_exists($Item['Name'], $this->Values) and isset($Item['Value'])) $this->Values[$Item['Name']] = $Item['Value'];
+        $Edit = ExecuteTypeEvent($Item['Type'], 'OnEdit', $Item);
+        $Output .= $Edit;
+      }
+    }
+    return($Output);
   }
 
@@ -58 +75 @@
     foreach($this->Definition['Items'] as $Item)
     {
-      $ItemType = explode(':', $Item['Type']);
-      $Index = $Item['Name'];
-      $Type = $Types[$ItemType[0]];
-      if(!array_key_exists($Index, $this->Values) and isset($Item['Value'])) $this->Values[$Index] = $Item['Value'];
-      if(is_callable($Type['CallbackView'])) $Edit = $Type['CallbackView']($Type, $Item);
-      else $Edit = $Type['CallbackView'];
+      if(!array_key_exists($Item['Name'], $this->Values) and isset($Item['Value'])) $this->Values[$Item['Name']] = $Item['Value'];
+      $Edit = ExecuteTypeEvent($Item['Type'], 'OnView', $Item);
       array_push($Table['Rows'], array($Item['Caption'].':', $Edit));
     }

sql/demo_database.sql

@@ -1 +1 @@
 -- phpMyAdmin SQL Dump
--- version 2.11.9.1
+-- version 2.11.9.2
 -- http://www.phpmyadmin.net
 --
 -- Počítač: localhost
--- Vygenerováno: Pondělí 29. září 2008, 14:31
+-- Vygenerováno: Neděle 12. října 2008, 20:37
 -- Verze MySQL: 5.0.51
 -- Verze PHP: 5.2.6
@@ -22 +22 @@
 CREATE TABLE IF NOT EXISTS `Area` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime default NULL,
+  `ValidTimeTo` datetime default NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `NetworkIPAddress` varchar(255) collate utf8_czech_ci NOT NULL,
@@ -33 +38 @@
   `HostList` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ;
 
 --
@@ -39 +44 @@
 --
 
-INSERT INTO `Area` (`Id`, `Name`, `NetworkIPAddress`, `IPAddressMask`, `DNSPrimary`, `DNSSecondary`, `DHCP`, `Domain`, `Workgroup`, `WINS`, `HostList`) VALUES
-(1, 'Bytovky dolní konec', '192.168.12.0', '255.255.255.0', '192.168.0.22', '46.33.1.2', '192.168.12.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
-(2, 'Centrum Komořany', '192.168.10.0', '255.255.255.0', '192.168.0.22', '', '192.168.10.1', 'centrum.freenet.cz', 'CENTRUM', '192.168.0.23', 0),
-(3, 'Serverovna', '192.168.0.0', '255.255.255.0', '192.168.0.22', '44.55.22.34', '19ě.168.0.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
-(4, 'Kůlna', '10.198.0.0', '255.255.0.0', '192.168.0.1', '129.168.0.22', '10.198.0.1', 'kulna.freenet.cz', 'KULNA', '192.168.0.23', 0);
+INSERT INTO `Area` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `NetworkIPAddress`, `IPAddressMask`, `DNSPrimary`, `DNSSecondary`, `DHCP`, `Domain`, `Workgroup`, `WINS`, `HostList`) VALUES
+(1, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Bytovky dolní konec', '192.168.12.0', '255.255.255.0', '192.168.0.22', '46.33.1.2', '192.168.12.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
+(2, 3, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Centrum Komořany', '192.168.10.0', '255.255.255.0', '192.168.0.22', '', '192.168.10.1', 'centrum.freenet.cz', 'CENTRUM', '192.168.0.23', 0),
+(3, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Serverovna', '192.168.0.0', '255.255.255.0', '192.168.0.22', '44.55.22.34', '19ě.168.0.1', 'freenet.cz', 'FREENET', '192.168.0.23', 0),
+(4, 4, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Kůlna', '10.198.0.0', '255.255.0.0', '192.168.0.1', '129.168.0.22', '10.198.0.1', 'kulna.freenet.cz', 'KULNA', '192.168.0.23', 0),
+(5, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:02:11', 'ss', 'ss', 'ss', '', '', '', '', '', '', 0),
+(6, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:04:59', 'kk', '', '', '', '', '', '', '', '', 0),
+(7, 2, 0, '2008-10-09 14:09:48', NULL, '2008-10-09 14:09:48', 'kk', 'sss', '', '', '', '', '', '', '', 0),
+(8, 2, 5, '2008-10-09 14:43:13', NULL, '2008-10-09 14:43:13', 'Ahoj', 'sss', '', '', '', '', '', '', '', 0);
 
 -- --------------------------------------------------------
@@ -53 +62 @@
 CREATE TABLE IF NOT EXISTS `Asset` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `TimeEnlistment` datetime NOT NULL,
@@ -67 +81 @@
 --
 
-INSERT INTO `Asset` (`Id`, `Name`, `TimeEnlistment`, `TimeElimination`, `Price`, `State`, `SerialNumber`, `PurcheasedFrom`) VALUES
-(1, 'Ovislink WL-1120AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 563, 2, 'WL1120AP111353', 2),
-(2, 'Routerboard RB-433', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3200, 1, 'RB433-3366264', 9),
-(3, 'Ovislink WL-5460AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 800, 3, 'WL5460A-4372-333362', 9),
-(4, 'StraightCore WRT-312', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1110, 0, 'SC-WRT312-112', 7),
-(5, 'UTP kabel 100 m', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '', 7),
-(6, 'Anténa UNIMAX 12 dBi 2,4 GHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '4234234234', 7),
-(7, 'UTP kabel Belden CAT-5 305 m ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1766, 1, '', 9),
-(8, 'Paměť DDR2 2 GB 800 MHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 734, 2, 'DDR2422622a', 9),
-(9, 'Všesměrová anténa Omni 10 dBi', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1043, 2, 'OMNI123533', 9),
-(10, 'Notebook Asus EEE PC 901', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 6232, 2, 'ASUSEEE901-2414aa53', 9),
-(11, '10x UTP konektory drát', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 30, 1, '', 9),
-(12, 'Edimax gigabit switch 8-port', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 750, 2, 'EDW8-423423-333', 9),
-(13, 'VoIP adaptér Zyxel VO-112', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1342, 2, 'ZXS422Z33', 9),
-(14, 'IP kamera Vivotek IP-224', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3744, 2, 'VOWW623335', 9);
+INSERT INTO `Asset` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `TimeEnlistment`, `TimeElimination`, `Price`, `State`, `SerialNumber`, `PurcheasedFrom`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Ovislink WL-1120AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 563, 2, 'WL1120AP111353', 2),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Routerboard RB-433', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3200, 1, 'RB433-3366264', 9),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Ovislink WL-5460AP', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 800, 3, 'WL5460A-4372-333362', 9),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'StraightCore WRT-312', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1110, 0, 'SC-WRT312-112', 7),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UTP kabel 100 m', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '', 7),
+(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Anténa UNIMAX 12 dBi 2,4 GHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 600, 2, '4234234234', 7),
+(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UTP kabel Belden CAT-5 305 m ', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1766, 1, '', 9),
+(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Paměť DDR2 2 GB 800 MHz', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 734, 2, 'DDR2422622a', 9),
+(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Všesměrová anténa Omni 10 dBi', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1043, 2, 'OMNI123533', 9),
+(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Notebook Asus EEE PC 901', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 6232, 2, 'ASUSEEE901-2414aa53', 9),
+(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '10x UTP konektory drát', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 30, 1, '', 9),
+(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Edimax gigabit switch 8-port', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 750, 2, 'EDW8-423423-333', 9),
+(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'VoIP adaptér Zyxel VO-112', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1342, 2, 'ZXS422Z33', 9),
+(14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IP kamera Vivotek IP-224', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3744, 2, 'VOWW623335', 9);
 
 -- --------------------------------------------------------
@@ -91 +105 @@
 CREATE TABLE IF NOT EXISTS `BankAccount` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `BankName` varchar(255) collate utf8_czech_ci NOT NULL,
@@ -104 +123 @@
 --
 
-INSERT INTO `BankAccount` (`Id`, `Name`, `BankName`, `Number`, `BankCode`, `Type`, `User`) VALUES
-(1, 'Hlavní účet', 'Poštovní spořitelna', '22653446', '0200', 1, 1),
-(2, 'Vedlejší účet', 'Komerční banka', '5543332', '0400', 2, 2),
-(3, 'Pomocný - vedení zdarma', 'Mbank', '24522266', '0156', 1, 2);
+INSERT INTO `BankAccount` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `BankName`, `Number`, `BankCode`, `Type`, `User`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Hlavní účet', 'Poštovní spořitelna', '22653446', '0200', 1, 1),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Vedlejší účet', 'Komerční banka', '5543332', '0400', 2, 2),
+(3, 3, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Pomocný - vedení zdarma', 'Mbank', '24522266', '0156', 1, 2);
 
 -- --------------------------------------------------------
@@ -117 +136 @@
 CREATE TABLE IF NOT EXISTS `FinanceTransaction` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Description` varchar(255) collate utf8_czech_ci NOT NULL,
   `Amount` float NOT NULL,
@@ -131 +155 @@
 --
 
-INSERT INTO `FinanceTransaction` (`Id`, `Description`, `Amount`, `SourceSubject`, `TargetSubject`, `Time`, `Type`, `InsertedByUser`) VALUES
-(1, 'Internet 2 Mbit 2008/05', 360, 2, 11, '0000-00-00 00:00:00', 0, 1),
-(2, 'Zřízení přípojky', 4300, 10, 11, '0000-00-00 00:00:00', 1, 11),
-(3, 'Internet 8 Mbit 2008/05', 750, 8, 11, '0000-00-00 00:00:00', 0, 11),
-(4, 'Vrácení přeplatku', 231, 11, 8, '0000-00-00 00:00:00', 0, 11);
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `History`
---
-
-CREATE TABLE IF NOT EXISTS `History` (
-  `Id` int(11) NOT NULL auto_increment,
-  `Author` int(11) NOT NULL,
-  `TimeValidFrom` datetime NOT NULL,
-  `TimeValidTo` datetime NOT NULL,
-  `PermanentId` int(11) NOT NULL,
-  `ListId` int(11) NOT NULL,
-  `TimeCreation` datetime NOT NULL,
-  PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
-
---
--- Vypisuji data pro tabulku `History`
---
-
+INSERT INTO `FinanceTransaction` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Description`, `Amount`, `SourceSubject`, `TargetSubject`, `Time`, `Type`, `InsertedByUser`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 2 Mbit 2008/05', 360, 2, 11, '0000-00-00 00:00:00', 0, 1),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Zřízení přípojky', 4300, 10, 11, '0000-00-00 00:00:00', 1, 11),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 8 Mbit 2008/05', 750, 8, 11, '0000-00-00 00:00:00', 0, 11),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Vrácení přeplatku', 231, 11, 8, '0000-00-00 00:00:00', 0, 11);
 
 -- --------------------------------------------------------
@@ -167 +169 @@
 CREATE TABLE IF NOT EXISTS `Host` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `DomainName` varchar(225) character set latin1 NOT NULL,
   `NetBIOSName` varchar(255) character set latin1 NOT NULL,
@@ -184 +191 @@
 --
 
-INSERT INTO `Host` (`Id`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`) VALUES
-(1, 'george', 'GEORGE', '192.168.0.23', '', '0000-00-00', 1, 0, 4, 0, 0),
-(2, 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0),
-(3, 'telefon', 'TELEFON', '192.168.1.45', '', '0000-00-00', 2, 0, 4, 1, 2),
-(4, 'router-inet', 'ROUTER-INET', '192.168.0.2', '77.33.55.12', '0000-00-00', 4, 0, 1, 1, 4),
-(5, 'muhehe', 'MUHEHE', '192.168.0.4', '', '0000-00-00', 1, 0, 1, 1, 2),
-(6, 'jonny', 'JONNY', '192.168.0.6', '', '0000-00-00', 1, 0, 1, 1, 1),
-(7, 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '0000-00-00', 6, 0, 0, 0, 0),
-(8, 'www', 'WWW', '192.168.0.7', '34.22.1.4', '0000-00-00', 5, 0, 0, 0, 0),
-(9, 'peklo', 'PEKLO', '192.168.66.66', '', '0000-00-00', 7, 0, 4, 2, 0);
+INSERT INTO `Host` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'george', 'GEORGE', '192.168.0.23', '', '0000-00-00', 1, 0, 4, 0, 0),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'telefon', 'TELEFON', '192.168.1.45', '', '0000-00-00', 2, 0, 4, 1, 2),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'router-inet', 'ROUTER-INET', '192.168.0.2', '77.33.55.12', '0000-00-00', 4, 0, 1, 1, 4),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'muhehe', 'MUHEHE', '192.168.0.4', '', '0000-00-00', 1, 0, 1, 1, 2),
+(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'jonny', 'JONNY', '192.168.0.6', '', '0000-00-00', 1, 0, 1, 1, 1),
+(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '0000-00-00', 6, 0, 0, 0, 0),
+(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'www', 'WWW', '192.168.0.7', '34.22.1.4', '0000-00-00', 5, 0, 0, 0, 0),
+(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'peklo', 'PEKLO', '192.168.66.66', '', '0000-00-00', 7, 0, 4, 2, 0);
 
 -- --------------------------------------------------------
@@ -203 +210 @@
 CREATE TABLE IF NOT EXISTS `Interface` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `Type` int(11) NOT NULL,
@@ -215 +227 @@
 --
 
-INSERT INTO `Interface` (`Id`, `Name`, `Type`, `Area`, `Host`, `MAC`) VALUES
-(1, 'Kabel', 2, 0, 1, '00:00:00:00:00:00'),
-(2, 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F'),
-(3, 'Bezdrát', 0, 0, 5, '00:00:00:A5:53:26'),
-(4, 'eth0', 2, 0, 6, '45:00:12:54:FE:C2');
+INSERT INTO `Interface` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `Type`, `Area`, `Host`, `MAC`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Kabel', 2, 0, 1, '00:00:00:00:00:00'),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F'),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Bezdrát', 0, 0, 5, '00:00:00:A5:53:26'),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'eth0', 2, 0, 6, '45:00:12:54:FE:C2');
 
 -- --------------------------------------------------------
@@ -229 +241 @@
 CREATE TABLE IF NOT EXISTS `Member` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Subject` int(11) NOT NULL,
   `ResponsibleUser` int(11) NOT NULL,
@@ -239 +256 @@
   `Tariff` int(11) NOT NULL,
   `UserList` int(11) NOT NULL,
-  `ValidFromTime` datetime default NULL,
-  `ValidToTime` datetime default NULL,
   PRIMARY KEY  (`Id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7 ;
@@ -248 +263 @@
 --
 
-INSERT INTO `Member` (`Id`, `Subject`, `ResponsibleUser`, `MapPositionX`, `MapPositionY`, `FamilyMemberCount`, `MembershipDate`, `MemberState`, `HostList`, `Tariff`, `UserList`, `ValidFromTime`, `ValidToTime`) VALUES
-(1, 2, 1, 123, 567, 3, '0000-00-00', 2, 0, 3, 0, '2008-09-01 00:00:00', NULL),
-(2, 3, 6, 123, 123, 2, '0000-00-00', 2, 0, 4, 0, '2008-09-01 00:00:00', NULL),
-(3, 7, 8, 0, 0, 0, '0000-00-00', 2, 0, 2, 0, '2008-09-01 00:00:00', NULL),
-(4, 8, 11, 0, 0, 0, '0000-00-00', 2, 0, 3, 0, '2008-09-01 00:00:00', NULL),
-(5, 10, 1, 32423, 21, 2, '0000-00-00', 1, 0, 3, 0, '2008-09-01 00:00:00', NULL),
-(6, 12, 12, 12, 2, 1, '0000-00-00', 3, 0, 1, 0, '2008-09-01 00:00:00', NULL);
+INSERT INTO `Member` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Subject`, `ResponsibleUser`, `MapPositionX`, `MapPositionY`, `FamilyMemberCount`, `MembershipDate`, `MemberState`, `HostList`, `Tariff`, `UserList`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 1, 123, 567, 3, '0000-00-00', 2, 0, 3, 0),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3, 6, 123, 123, 2, '0000-00-00', 2, 0, 4, 0),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 7, 8, 0, 0, 0, '0000-00-00', 2, 0, 2, 0),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 8, 11, 0, 0, 0, '0000-00-00', 2, 0, 3, 0),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 10, 1, 32423, 21, 2, '0000-00-00', 1, 0, 3, 0),
+(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 12, 12, 12, 2, 1, '0000-00-00', 3, 0, 1, 0);
 
 -- --------------------------------------------------------
@@ -264 +279 @@
 CREATE TABLE IF NOT EXISTS `MemberReport` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Member` int(11) NOT NULL,
   `Text` varchar(255) collate utf8_czech_ci NOT NULL,
@@ -276 +296 @@
 --
 
-INSERT INTO `MemberReport` (`Id`, `Member`, `Text`, `Date`, `Type`, `Creator`) VALUES
-(1, 1, 'Nefunguje mi internet', '0000-00-00', 1, 11),
-(2, 1, 'Poslední dobu jede internet nějak pomalu. Podívejte se na to prosím.', '0000-00-00', 1, 7),
-(3, 1, 'Uživatel se přestěhoval mimo dosah sítě', '0000-00-00', 3, 11),
-(4, 4, 'Během bouřky spadl strom na vedení a roztrhl jej. Bylo nutno natáhnout kabel znova.', '0000-00-00', 3, 2),
-(5, 2, 'Nefunguje odesílání pošty.', '0000-00-00', 1, 10),
-(6, 1, 'Změna tarifu na Internet 2 Mbit', '0000-00-00', 2, 11),
-(7, 2, 'Chce se stát správcem tamního úseku.', '0000-00-00', 3, 11);
+INSERT INTO `MemberReport` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Member`, `Text`, `Date`, `Type`, `Creator`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Nefunguje mi internet', '0000-00-00', 1, 11),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Poslední dobu jede internet nějak pomalu. Podívejte se na to prosím.', '0000-00-00', 1, 7),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Uživatel se přestěhoval mimo dosah sítě', '0000-00-00', 3, 11),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 4, 'Během bouřky spadl strom na vedení a roztrhl jej. Bylo nutno natáhnout kabel znova.', '0000-00-00', 3, 2),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 'Nefunguje odesílání pošty.', '0000-00-00', 1, 10),
+(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'Změna tarifu na Internet 2 Mbit', '0000-00-00', 2, 11),
+(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 'Chce se stát správcem tamního úseku.', '0000-00-00', 3, 11);
 
 -- --------------------------------------------------------
@@ -293 +313 @@
 CREATE TABLE IF NOT EXISTS `Subject` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `AddressStreet` varchar(255) collate utf8_czech_ci NOT NULL,
@@ -305 +330 @@
   `MemberList` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=18 ;
 
 --
@@ -311 +336 @@
 --
 
-INSERT INTO `Subject` (`Id`, `Name`, `AddressStreet`, `AddressTown`, `AddressZIP`, `IC`, `DIC`, `Notice`, `PurcheasedAsset`, `UserList`, `WWW`, `MemberList`) VALUES
-(2, 'Ing. Karel Milosrdný', 'Na ústraní 302', 'Otrokovice', '45667', '', '', 'Dodavatel wifi techniky', 0, 0, '', 0),
-(3, 'Poskytovatel', 'Těsná 23', 'Prachatice', '56678', '33445633', '', '', 0, 0, '', 0),
-(4, 'Finanční úřad Brno', 'Brněnská 1', 'Brno', '44134', '45773325', 'CZ44337778', '', 0, 0, '', 0),
-(5, 'GTS Novera', 'U skládky 9', 'Kladno', '47353', '3216346365', '423432', 'Hlavní dodavatel internetu', 0, 0, 'http://www.gtsnovera.cz', 0),
-(6, 'České radiokomunikace', 'Na rozcestí 5', 'Ostrava', '12445', '23132312', 'CZ342342342', 'Záložní linka', 0, 0, '', 0),
-(7, 'Lucie Dobrovolná', 'Čajkovského 3', 'Pardubice', '73322', '', '', 'Neplatí včas', 0, 0, '', 0),
-(8, 'Obecní úřad Nové Milošice', 'Nové Milošice 24', 'Nové Milošice', '44222', '31231312312', 'CZ31231231', '', 0, 0, '', 0),
-(9, 'SOFTCOM', 'Pod vodou 9', 'Praha', '42044', '2323324234234', 'CZ6565622', 'Prodej výpočetní techniky', 0, 0, 'http://www.softcom.cz/', 0),
-(10, 'Honza Procházka', 'Za bukem 3', 'Chvojkovice', '44332', '', '', '', 0, 0, '', 0),
-(11, 'Freenet s.r.o.', 'Bezdrátová 11', 'Nové síťovice', '434223', '43423423423', 'CZ42423423', 'Hlavní kontakt na tuto síť', 0, 0, '', 0),
-(12, 'Fantomas', 'Tajná 10', 'Pod vodou', '11223', '', '', '', 0, 0, '', 0),
-(13, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0);
+INSERT INTO `Subject` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `AddressStreet`, `AddressTown`, `AddressZIP`, `IC`, `DIC`, `Notice`, `PurcheasedAsset`, `UserList`, `WWW`, `MemberList`) VALUES
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Ing. Karel Milosrdný', 'Na ústraní 302', 'Otrokovice', '45667', '', '', 'Dodavatel wifi techniky', 0, 0, '', 0),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Poskytovatel', 'Těsná 23', 'Prachatice', '56678', '33445633', '', '', 0, 0, '', 0),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Finanční úřad Brno', 'Brněnská 1', 'Brno', '44134', '45773325', 'CZ44337778', '', 0, 0, '', 0),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'GTS Novera', 'U skládky 9', 'Kladno', '47353', '3216346365', '423432', 'Hlavní dodavatel internetu', 0, 0, 'http://www.gtsnovera.cz', 0),
+(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'České radiokomunikace', 'Na rozcestí 5', 'Ostrava', '12445', '23132312', 'CZ342342342', 'Záložní linka', 0, 0, '', 0),
+(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Lucie Dobrovolná', 'Čajkovského 3', 'Pardubice', '73322', '', '', 'Neplatí včas', 0, 0, '', 0),
+(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Obecní úřad Nové Milošice', 'Nové Milošice 24', 'Nové Milošice', '44222', '31231312312', 'CZ31231231', '', 0, 0, '', 0),
+(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SOFTCOM', 'Pod vodou 9', 'Praha', '42044', '2323324234234', 'CZ6565622', 'Prodej výpočetní techniky', 0, 0, 'http://www.softcom.cz/', 0),
+(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Honza Procházka', 'Za bukem 3', 'Chvojkovice', '44332', '', '', '', 0, 0, '', 0),
+(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Freenet s.r.o.', 'Bezdrátová 11', 'Nové síťovice', '434223', '43423423423', 'CZ42423423', 'Hlavní kontakt na tuto síť', 0, 0, '', 0),
+(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Fantomas', 'Tajná 10', 'Pod vodou', '11223', '', '', '', 0, 0, '', 0),
+(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
+(14, 14, 5, '2008-10-11 22:38:49', '0000-00-00 00:00:00', '2008-10-11 22:38:49', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
+(15, 15, 5, '2008-10-11 22:41:56', '0000-00-00 00:00:00', '2008-10-11 22:41:56', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0),
+(16, 16, 5, '2008-10-11 22:46:30', '0000-00-00 00:00:00', '2008-10-11 22:46:30', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0),
+(17, 17, 5, '2008-10-11 22:47:36', '0000-00-00 00:00:00', '2008-10-11 22:47:36', 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0);
 
 -- --------------------------------------------------------
@@ -333 +362 @@
 CREATE TABLE IF NOT EXISTS `SystemList` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `TableName` varchar(255) collate utf8_czech_ci NOT NULL,
   `Title` varchar(255) collate utf8_czech_ci NOT NULL,
@@ -339 +373 @@
   `VisibleInMenu` int(11) NOT NULL default '1',
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=17 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=27 ;
 
 --
@@ -345 +379 @@
 --
 
-INSERT INTO `SystemList` (`Id`, `TableName`, `Title`, `System`, `Items`, `VisibleInMenu`) VALUES
-(1, 'User', 'Uživatelé', 0, '', 1),
-(2, 'Host', 'Zařízení', 0, '', 1),
-(3, 'Subject', 'Finanční subjekty', 0, '', 1),
-(4, 'Member', 'Členové sítě', 0, '', 1),
-(5, 'Area', 'Oblasti', 0, '', 1),
-(6, 'Interface', 'Rozhraní zařízení', 0, '', 1),
-(7, 'Asset', 'Majetek', 0, '', 1),
-(8, 'Tariff', 'Tarify', 0, '', 1),
-(9, 'MemberReport', 'Hlášení členů', 0, '', 1),
-(10, 'BankAccount', 'Bankovní účty', 0, '', 1),
-(11, 'SystemType', 'Definice typů', 1, '', 1),
-(12, 'FinanceTransaction', 'Platební operace', 0, '', 1),
-(13, 'SystemList', 'Definice tabulek', 1, '', 1),
-(14, 'SystemListItem', 'Definice položek formulářů', 1, '', 0),
-(15, 'UserOnline', 'Přihlášení uživatelé', 1, '', 1),
-(16, 'History', 'Historie záznamů', 1, '', 0);
+INSERT INTO `SystemList` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `TableName`, `Title`, `System`, `Items`, `VisibleInMenu`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'User', 'Uživatelé', 0, '', 1),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Host', 'Zařízení', 0, '', 1),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Subject', 'Finanční subjekty', 0, '', 1),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Členové sítě', 0, '', 1),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Area', 'Oblasti', 0, '', 1),
+(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Interface', 'Rozhraní zařízení', 0, '', 1),
+(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Asset', 'Majetek', 0, '', 1),
+(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Tariff', 'Tarify', 0, '', 1),
+(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberReport', 'Hlášení členů', 0, '', 1),
+(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BankAccount', 'Bankovní účty', 0, '', 1),
+(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SystemType', 'Definice typů', 1, '', 1),
+(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'FinanceTransaction', 'Platební operace', 0, '', 1),
+(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SystemList', 'Definice tabulek', 1, '', 1),
+(14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SystemListItem', 'Definice položek formulářů', 1, '', 0),
+(15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UserOnline', 'Přihlášení uživatelé', 1, '', 1),
+(16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'History', 'Historie záznamů', 1, '', 0),
+(26, 17, 5, '2008-10-12 18:38:17', '0000-00-00 00:00:00', '2008-10-12 18:38:17', 'Test', 'Testovací tabulka', 0, '', 1);
 
 -- --------------------------------------------------------
@@ -371 +406 @@
 CREATE TABLE IF NOT EXISTS `SystemListItem` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `TextBefore` varchar(255) collate utf8_czech_ci NOT NULL,
@@ -383 +423 @@
   `List` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=131 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=143 ;
 
 --
@@ -389 +429 @@
 --
 
-INSERT INTO `SystemListItem` (`Id`, `Name`, `TextBefore`, `TextAfter`, `Type`, `Help`, `Default`, `Required`, `Editable`, `VisibleInList`, `VisibleInPointer`, `List`) VALUES
-(1, 'FirstName', 'Jméno', '', 'String', 'Zadejte jméno', '', 1, 1, 1, 1, 1),
-(2, 'SecondName', 'Příjmení', '', 'String', 'Zadejte příjmení', '', 1, 1, 1, 1, 1),
-(3, 'Email', 'E-mail', '', 'String', 'Zadejte emailovou adresu', '', 1, 1, 1, 0, 1),
-(4, 'ICQ', 'ICQ', '', 'Integer', 'Zadejte kontaktní číslo textového komunikačního programu ICQ.', '', 0, 1, 0, 0, 1),
-(5, 'Sex', 'Pohlaví', '', 'Sex', 'Vyberte pohlaví osoby', '', 0, 1, 0, 0, 1),
-(6, 'BirthDay', 'Datum narození', '', 'Date', 'Vyberte datum narození', '', 0, 1, 0, 0, 1),
-(7, 'DomainName', 'Doménové jméno', '', 'String', 'Zadejte jméno počítače v doméně', '', 1, 1, 1, 1, 2),
-(8, 'NetBIOSName', 'NetBIOSové jméno', '', 'String', 'Zadejte jméno počítače v rámci protokolů NetBIOS a sdílení souborů', '', 0, 1, 0, 0, 2),
-(9, 'LocalIPAddress', 'Místní IP adresa', '', 'String', 'Zadejte síťovou adresu používanou v rámci místní sítě', '', 1, 1, 1, 0, 2),
-(10, 'PublicIPAddress', 'Veřejná IP adresa', '', 'String', 'Zadejte síťovou adresu používanou v rámci Internetu', '', 0, 1, 1, 0, 2),
-(11, 'LastOnlineDate', 'Naposledy online', '', 'Date', 'Čas posledního úspěšného měření dostupnosti počítače', '', 0, 0, 0, 0, 2),
-(12, 'Name', 'Jméno', '', 'String', 'Jméno subjektu', '', 1, 1, 1, 1, 3),
-(13, 'AddressStreet', 'Ulice', '', 'String', 'Ulice', '', 1, 1, 1, 0, 3),
-(14, 'AddressTown', 'Město', '', 'String', 'Město', '', 1, 1, 1, 0, 3),
-(15, 'AddressZIP', 'PSČ', '', 'String', '', '', 1, 1, 1, 0, 3),
-(16, 'IC', 'IČ', '', 'String', 'Identifikační číslo subjektu', '', 0, 1, 0, 0, 3),
-(17, 'DIC', 'DIČ', '', 'String', 'Daňové identifikační číslo', '', 0, 1, 0, 0, 3),
-(18, 'MapPositionX', 'Horizontálně pozice', '', 'Integer', 'Vodorovná pozice na mapě', '', 0, 1, 0, 0, 4),
-(19, 'MapPositionY', 'Vertikální pozice', '', 'Integer', 'Svislá pozice na mapě', '', 0, 1, 0, 0, 4),
-(20, 'MembershipDate', 'Začátek členství', '', 'Date', 'Datum přípojení do sítě', '', 0, 1, 0, 0, 4),
-(21, 'FamilyMemberCount', 'Osob v rodině', '', 'Integer', 'Počet osob v připojené domácnosti', '', 0, 1, 0, 0, 4),
-(22, 'ResponsibleUser', 'Zodpovědný uživatel', '', 'PointerOneToOne:User', '', '', 1, 1, 1, 1, 4),
-(23, 'Subject', 'Subjekt', '', 'PointerOneToOne:Subject', '', '', 1, 1, 0, 0, 4),
-(24, 'Type', 'Druh', '', 'HostType', '', '1', 0, 1, 1, 0, 2),
-(25, 'Phone', 'Telefón', '', 'String', '', '', 0, 1, 0, 0, 1),
-(26, 'Notice', 'Poznámka', '', 'String', '', '', 0, 1, 0, 0, 3),
-(27, 'MemberState', 'Stav připojení', '', 'MemberState', '', '', 1, 1, 1, 0, 4),
-(28, 'HostList', 'Registrované zařízení', '', 'PointerOneToMany:Host:Member', '', '', 0, 1, 0, 0, 4),
-(29, 'Name', 'Označení', '', 'String', '', '', 1, 1, 1, 1, 5),
-(30, 'NetworkIPAddress', 'Adresa sítě', '', 'String', '', '', 1, 1, 1, 0, 5),
-(31, 'IPAddressMask', 'Maska sítě', '', 'String', '', '', 1, 1, 1, 0, 5),
-(32, 'DNSPrimary', 'Primární DNS server', '', 'String', '', '', 0, 1, 0, 0, 5),
-(33, 'DNSSecondary', 'Sukundární DNS server', '', 'String', '', '', 0, 1, 0, 0, 5),
-(34, 'DHCP', 'DHCP server', '', 'String', '', '', 0, 1, 0, 0, 5),
-(35, 'Domain', 'Doména', '', 'String', '', '', 0, 1, 0, 0, 5),
-(36, 'Workgroup', 'Pracovní skupina', '', 'String', '', '', 0, 1, 0, 0, 5),
-(37, 'WINS', 'WINS server', '', 'String', '', '', 0, 1, 0, 0, 5),
-(38, 'Name', 'Označení', '', 'String', '', '', 1, 1, 1, 1, 6),
-(39, 'Type', 'Typ', '', 'InterfaceType', '', '', 1, 1, 1, 0, 6),
-(40, 'Host', 'Zařízení', '', 'PointerOneToOne:Host', 'Vyberte zařízení, ke kterému patří toto rozhraní.', '', 1, 1, 1, 0, 6),
-(41, 'ParentHost', 'Připojeno k bodu', '', 'PointerOneToOne:Host', '', '', 1, 1, 1, 0, 6),
-(42, 'Interface', 'Rozhraní', '', 'PointerOneToMany:Interface:Host', '', '', 0, 1, 0, 0, 2),
-(43, 'MAC', 'Fyzická adresa', '', 'String', 'Zadejte fyzickou adresu síťové karty též nazývanou MAC adresa.', '', 1, 1, 0, 0, 6),
-(44, 'ParentHost', 'Nadřazený uzel', '', 'PointerOneToOne:Host', '', '', 0, 1, 0, 0, 2),
-(45, 'SubHostList', 'Připojené zařízení', '', 'PointerOneToMany:Host:ParentHost', 'Seznam podřízených zařízení ve virtuálním stromu propojení.', '', 0, 1, 0, 0, 2),
-(46, 'Name', 'Označení', '', 'String', '', '', 1, 1, 1, 1, 7),
-(47, 'TimeEnlistment', 'Čas zařazení', '', 'Date', '', '', 1, 1, 0, 0, 7),
-(48, 'TimeElimination', 'Čas vyřazení', '', 'Date', '', '', 0, 1, 0, 0, 7),
-(49, 'Price', 'Pořizovací cena', '', 'Integer', '', '', 1, 1, 1, 0, 7),
-(50, 'State', 'Stav', '', 'AssetState', '', '', 1, 1, 1, 0, 7),
-(51, 'SerialNumber', 'Sériové číslo', '', 'String', '', '', 0, 1, 0, 0, 7),
-(52, 'PurcheasedFrom', 'Zakoupeno od', '', 'PointerOneToOne:Subject', '', '', 0, 1, 0, 0, 7),
-(53, 'PurcheasedAsset', 'Nakoupené zboží', '', 'PointerOneToMany:Asset:PurcheasedFrom', '', '', 0, 1, 0, 0, 3),
-(54, 'Member', 'Člen', '', 'PointerOneToOne:Member', '', '', 0, 1, 0, 0, 1),
-(113, 'ValidFromTime', 'Platnost od', '', 'Date', '', '', 1, 1, 0, 0, 4),
-(57, 'Price', 'Cena', '', 'Integer', '', '', 1, 1, 1, 0, 8),
-(56, 'Name', 'Označení', '', 'String', '', '', 1, 1, 1, 1, 8),
-(58, 'MinUploadSpeed', 'Minimální odchozí rychlost', '', 'Integer', '', '', 1, 1, 0, 0, 8),
-(59, 'MaxUploadSpeed', 'Maximální odchozí rychlost', '', 'Integer', '', '', 1, 1, 1, 0, 8),
-(60, 'MinDownloadSpeed', 'Minimální příchozí rychlost', '', 'Integer', '', '', 1, 1, 0, 0, 8),
-(61, 'MaxDownloadSpeed', 'Max příchozí rychlost', '', 'Integer', '', '', 1, 1, 1, 0, 8),
-(62, 'UserName', 'Uživatelské jméno', '', 'String:4:30', '', '', 1, 1, 0, 0, 1),
-(63, 'Password', 'Heslo', '', 'Password:4:20', '', '', 1, 1, 0, 0, 1),
-(64, 'Member', 'Členové', '', 'PointerOneToMany:Member:Tariff', '', '', 0, 1, 0, 0, 8),
-(65, 'Tariff', 'Tarif', '', 'PointerOneToOne:Tariff', '', '', 1, 1, 1, 0, 4),
-(66, 'Member', 'Vlastník', '', 'PointerOneToOne:Member', '', '', 0, 1, 0, 0, 2),
-(67, 'WWW', 'Internetové stránky', '', 'Hyperlink', '', '', 0, 1, 0, 0, 3),
-(68, 'Text', 'Text zprávy', '', 'String', '', '', 1, 1, 1, 1, 9),
-(69, 'Date', 'Datum', '', 'Date', '', '', 1, 1, 1, 0, 9),
-(70, 'Member', 'Člen', '', 'PointerOneToOne:Member', '', '', 1, 1, 1, 0, 9),
-(71, 'Type', 'Typ zprávy', '', 'MemberReportType', '', '', 1, 1, 1, 0, 9),
-(72, 'ReportList', 'Záznamy', '', 'PointerOneToMany:MemberReport:Member', '', '', 0, 1, 0, 0, 4),
-(73, 'Creator', 'Vložil', '', 'PointerOneToOne:User', '', '', 1, 1, 0, 0, 9),
-(74, 'Name', 'Označení', '', 'String', '', '', 1, 1, 1, 1, 10),
-(75, 'BankName', 'Jméno banky', '', 'String', '', '', 1, 1, 0, 0, 10),
-(76, 'Number', 'Identifikační číslo', '', 'String', '', '', 1, 1, 1, 0, 10),
-(77, 'BankCode', 'Kód banky', '', 'String', '', '', 1, 1, 1, 0, 10),
-(78, 'User', 'Registroval', '', 'PointerOneToOne:User', '', '', 0, 1, 0, 0, 10),
-(79, 'Type', 'Typ', '', 'BankAccountType', '', '', 1, 1, 1, 0, 10),
-(80, 'MemberList', 'Členství', '', 'PointerOneToMany:Member:Subject', '', '', 0, 1, 0, 0, 3),
-(81, 'Name', 'Systémové jméno typu', '', 'String', '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),
-(82, 'ParentType', 'Rodičovský typ', '', 'String', '', '', 1, 1, 1, 0, 11),
-(83, 'Parameters', 'Parametry typu', '', 'String', '', 'Parametry zadávejte jako řetězce oddělené symblem "|".', 0, 1, 0, 0, 11),
-(84, 'System', 'Systémový', '', 'Boolean', '', '0', 1, 1, 0, 0, 11),
-(85, 'CallbackView', 'Funkce pro generování zobrazení', '', 'String', '', '', 0, 1, 0, 0, 11),
-(86, 'CallbackEdit', 'Funkce pro generování editace', '', 'String', '', '', 0, 1, 0, 0, 11),
-(87, 'CallbackCheck', 'Funkce pro kontrolu vstupních dat', '', 'String', '', '', 0, 1, 0, 0, 11),
-(88, 'Description', 'Popis', '', 'String', '', '', 1, 1, 1, 0, 11),
-(89, 'Description', 'Popis', '', 'String', '', '', 1, 1, 1, 0, 12),
-(90, 'Amount', 'Částka', '', 'Float', '', '', 1, 1, 1, 0, 12),
-(91, 'Time', 'Čas', '', 'DateTime', '', '', 1, 1, 1, 0, 12),
-(92, 'SourceSubject', 'Zdrojový subjekt', '', 'PointerOneToOne:Subject', '', '', 1, 1, 1, 0, 12),
-(93, 'TargetSubject', 'Cílový subjekt', '', 'PointerOneToOne:Subject', '', '', 1, 1, 1, 0, 12),
-(94, 'Type', 'Type', '', 'FinanceTransactionType', '', '', 1, 1, 0, 0, 12),
-(95, 'InsertedByUser', 'Vložil', '', 'PointerOneToOne:User', '', '', 0, 0, 0, 0, 12),
-(96, 'DbDataType', 'Datový typ v databázi', '', 'String', '', '', 1, 1, 0, 0, 11),
-(97, 'TableName', 'Jméno tabulky', '', 'String', 'Zadejte jméno tabulky v databázi, která bude použita pro uchování informací.', '', 1, 1, 1, 0, 13),
-(98, 'Title', 'Název seznamu', '', 'String', 'Zadejte nadpis seznamu.', '', 1, 1, 1, 1, 13),
-(99, 'VisibleInMenu', 'Viditelné v menu', '', 'Boolean', 'Zobrazovat tuto tabulku v hlavním menu', '', 1, 1, 0, 0, 13),
-(100, 'Items', 'Položky', '', 'PointerOneToMany:SystemListItem:List', 'Definujte potřebné položky pro seznam.', '', 1, 1, 0, 0, 13),
-(101, 'Name', 'Jméno sloupce', '', 'String', 'Jméno sloupce tabulky v databázi', '', 1, 1, 1, 0, 14),
-(102, 'TextBefore', 'Text před hodnotou', '', 'String', 'Oznčení položky umístěné před zobrazenou hodnotou.', '', 1, 1, 1, 1, 14),
-(103, 'TextAfter', 'Text za hodnotou', '', 'String', 'Tento text většinou obsahuje jednotky použité veličiny.', '', 1, 1, 0, 0, 14),
-(104, 'Type', 'Type', '', 'PointerOneToOne:SystemType', 'Typ dat položky', '', 1, 1, 1, 0, 14),
-(105, 'Help', 'Nápověda', '', 'String', 'Textová nápověda zobrazovaná jako pomůcka při editaci hodnoty.', '', 1, 1, 0, 0, 14),
-(106, 'Required', 'Požadováno', '', 'Boolean', 'Určuje zda je nutné danou položku vyplnit.', '', 1, 1, 0, 0, 14),
-(107, 'Editable', 'Editovatelné', '', 'Boolean', '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),
-(108, 'VisibleInList', 'Viditelné v seznamu', '', 'Boolean', 'Určuje viditelnost této položky v seznamu', '', 1, 1, 0, 0, 14),
-(109, 'VisibleInPointer', 'Viditelné v odkazech', '', 'Boolean', 'Určuje viditelnost této položky v názvech odkazů na tuto položku', '', 1, 1, 0, 0, 14),
-(110, 'Area', 'Umístění', '', 'PointerOneToOne:Area', 'Vyberte oblast, do které toto zařízení patří.', '', 0, 1, 0, 0, 2),
-(111, 'HostList', 'Seznam zařízení', '', 'PointerOneToMany:Host:Area', '', '', 0, 1, 0, 0, 5),
-(112, 'UserList', 'Uživatelů', '', 'PointerOneToMany:User:Member', '', '', 0, 1, 0, 0, 4),
-(114, 'ValidToTime', 'Platnost do', '', 'Date', '', '', 1, 1, 0, 0, 4),
-(115, 'User', 'Uživatel', '', 'PointerOneToOne:User', '', '', 1, 0, 1, 1, 15),
-(116, 'LoginTime', 'Čas přihlášení', '', 'Date', '', '', 0, 0, 0, 0, 15),
-(117, 'ActivityTime', 'Naposledy aktivní', '', 'Date', '', '', 0, 0, 0, 0, 15),
-(118, 'SessionId', 'Identifikace spojení', '', 'String', '', '', 0, 0, 0, 0, 15),
-(119, 'IpAddress', 'IP adresa', '', 'String', '', '', 0, 0, 0, 0, 15),
-(120, 'HostName', 'Jméno počítače', '', 'String', '', '', 0, 0, 1, 0, 15),
-(121, 'Locked', 'Zamčeno', '', 'Boolean', '', '', 0, 0, 0, 0, 1),
-(122, 'RegistrationTime', 'Čas registrace', '', 'Date', '', '', 0, 0, 0, 0, 1),
-(123, 'LastLoginTime', 'Čas posledního přihlášení', '', 'Date', '', '', 0, 0, 0, 0, 1),
-(124, 'LastIpAddress', 'Poslední IP adresa', '', 'String', '', '', 0, 0, 0, 0, 1),
-(125, 'Author', 'Autor', '', 'PointerOneToOne:User', '', '', 1, 0, 0, 0, 16),
-(126, 'TimeCreation', 'Čas vytvoření', '', 'Date', '', '', 1, 0, 0, 0, 16),
-(127, 'TimeValidFrom', 'Platnost od', '', 'Date', '', '', 1, 1, 0, 0, 16),
-(128, 'TimeValidTo', 'Platnost do', '', 'Date', '', '', 1, 1, 0, 0, 16),
-(129, 'ListId', 'Odkazovaná tabulka', '', 'PointerOneToOne:SystemList', '', '', 1, 1, 0, 0, 16),
-(130, 'PermanentId', 'Trvalá identifikace', '', 'Integer', '', '', 1, 1, 0, 0, 16);
+INSERT INTO `SystemListItem` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `TextBefore`, `TextAfter`, `Type`, `Help`, `Default`, `Required`, `Editable`, `VisibleInList`, `VisibleInPointer`, `List`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'FirstName', 'Jméno', '', '3', 'Zadejte jméno', '', 1, 1, 1, 1, 1),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SecondName', 'Příjmení', '', '3', 'Zadejte příjmení', '', 1, 1, 1, 1, 1),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Email', 'E-mail', '', '3', 'Zadejte emailovou adresu', '', 1, 1, 1, 0, 1),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ICQ', 'ICQ', '', '1', 'Zadejte kontaktní číslo textového komunikačního programu ICQ.', '', 0, 1, 0, 0, 1),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Sex', 'Pohlaví', '', '5', 'Vyberte pohlaví osoby', '', 0, 1, 0, 0, 1),
+(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BirthDay', 'Datum narození', '', '2', 'Vyberte datum narození', '', 0, 1, 0, 0, 1),
+(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DomainName', 'Doménové jméno', '', '3', 'Zadejte jméno počítače v doméně', '', 1, 1, 1, 1, 2),
+(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'NetBIOSName', 'NetBIOSové jméno', '', '3', 'Zadejte jméno počítače v rámci protokolů NetBIOS a sdílení souborů', '', 0, 1, 0, 0, 2),
+(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LocalIPAddress', 'Místní IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci místní sítě', '', 1, 1, 1, 0, 2),
+(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PublicIPAddress', 'Veřejná IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci Internetu', '', 0, 1, 1, 0, 2),
+(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LastOnlineDate', 'Naposledy online', '', '2', 'Čas posledního úspěšného měření dostupnosti počítače', '', 0, 0, 0, 0, 2),
+(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Jméno', '', '3', 'Jméno subjektu', '', 1, 1, 1, 1, 3),
+(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'AddressStreet', 'Ulice', '', '3', 'Ulice', '', 1, 1, 1, 0, 3),
+(14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'AddressTown', 'Město', '', '3', 'Město', '', 1, 1, 1, 0, 3),
+(15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'AddressZIP', 'PSČ', '', '3', '', '', 1, 1, 1, 0, 3),
+(16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IC', 'IČ', '', '3', 'Identifikační číslo subjektu', '', 0, 1, 0, 0, 3),
+(17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DIC', 'DIČ', '', '3', 'Daňové identifikační číslo', '', 0, 1, 0, 0, 3),
+(18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MapPositionX', 'Horizontálně pozice', '', '1', 'Vodorovná pozice na mapě', '', 0, 1, 0, 0, 4),
+(19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MapPositionY', 'Vertikální pozice', '', '1', 'Svislá pozice na mapě', '', 0, 1, 0, 0, 4),
+(20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MembershipDate', 'Začátek členství', '', '2', 'Datum přípojení do sítě', '', 0, 1, 0, 0, 4),
+(21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'FamilyMemberCount', 'Osob v rodině', '', '1', 'Počet osob v připojené domácnosti', '', 0, 1, 0, 0, 4),
+(22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ResponsibleUser', 'Zodpovědný uživatel', '', '37', '', '', 1, 1, 1, 1, 4),
+(23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Subject', 'Subjekt', '', '33', '', '', 1, 1, 0, 0, 4),
+(24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Druh', '', '7', '', '1', 0, 1, 1, 0, 2),
+(25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Phone', 'Telefón', '', '3', '', '', 0, 1, 0, 0, 1),
+(26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Notice', 'Poznámka', '', '3', '', '', 0, 1, 0, 0, 3),
+(27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberState', 'Stav připojení', '', '6', '', '', 1, 1, 1, 0, 4),
+(28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'HostList', 'Registrované zařízení', '', '23', '', '', 0, 1, 0, 0, 4),
+(29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 5),
+(30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'NetworkIPAddress', 'Adresa sítě', '', '3', '', '', 1, 1, 1, 0, 5),
+(31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IPAddressMask', 'Maska sítě', '', '3', '', '', 1, 1, 1, 0, 5),
+(32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DNSPrimary', 'Primární DNS server', '', '3', '', '', 0, 1, 0, 0, 5),
+(33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DNSSecondary', 'Sukundární DNS server', '', '3', '', '', 0, 1, 0, 0, 5),
+(34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DHCP', 'DHCP server', '', '3', '', '', 0, 1, 0, 0, 5),
+(35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Domain', 'Doména', '', '3', '', '', 0, 1, 0, 0, 5),
+(36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Workgroup', 'Pracovní skupina', '', '3', '', '', 0, 1, 0, 0, 5),
+(37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'WINS', 'WINS server', '', '3', '', '', 0, 1, 0, 0, 5),
+(38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 6),
+(39, 39, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Typ', '', '8', '', '', 1, 1, 1, 0, 6),
+(40, 40, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Host', 'Zařízení', '', '31', 'Vyberte zařízení, ke kterému patří toto rozhraní.', '', 1, 1, 1, 0, 6),
+(41, 41, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ParentHost', 'Připojeno k bodu', '', '31', '', '', 1, 1, 1, 0, 6),
+(42, 42, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Interface', 'Rozhraní', '', '24', '', '', 0, 1, 0, 0, 2),
+(43, 43, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MAC', 'Fyzická adresa', '', '3', 'Zadejte fyzickou adresu síťové karty též nazývanou MAC adresa.', '', 1, 1, 0, 0, 6),
+(44, 44, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ParentHost', 'Nadřazený uzel', '', '31', '', '', 0, 1, 0, 0, 2),
+(45, 45, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SubHostList', 'Připojené zařízení', '', '38', 'Seznam podřízených zařízení ve virtuálním stromu propojení.', '', 0, 1, 0, 0, 2),
+(46, 46, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 7),
+(47, 47, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeEnlistment', 'Čas zařazení', '', '2', '', '', 1, 1, 0, 0, 7),
+(48, 48, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeElimination', 'Čas vyřazení', '', '2', '', '', 0, 1, 0, 0, 7),
+(49, 49, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Price', 'Pořizovací cena', '', '1', '', '', 1, 1, 1, 0, 7),
+(50, 50, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'State', 'Stav', '', '9', '', '', 1, 1, 1, 0, 7),
+(51, 51, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SerialNumber', 'Sériové číslo', '', '3', '', '', 0, 1, 0, 0, 7),
+(52, 52, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PurcheasedFrom', 'Zakoupeno od', '', '33', '', '', 0, 1, 0, 0, 7),
+(53, 53, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PurcheasedAsset', 'Nakoupené zboží', '', '21', '', '', 0, 1, 0, 0, 3),
+(54, 54, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Člen', '', '32', '', '', 0, 1, 0, 0, 1),
+(113, 113, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ValidFromTime', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 4),
+(57, 57, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Price', 'Cena', '', '1', '', '', 1, 1, 1, 0, 8),
+(56, 56, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 8),
+(58, 58, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MinUploadSpeed', 'Minimální odchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8),
+(59, 59, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MaxUploadSpeed', 'Maximální odchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8),
+(60, 60, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MinDownloadSpeed', 'Minimální příchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8),
+(61, 61, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MaxDownloadSpeed', 'Max příchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8),
+(62, 62, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UserName', 'Uživatelské jméno', '', '3', '', '', 1, 1, 0, 0, 1),
+(63, 63, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Password', 'Heslo', '', '15', '', '', 1, 1, 0, 0, 1),
+(64, 64, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Členové', '', '26', '', '', 0, 1, 0, 0, 8),
+(65, 65, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Tariff', 'Tarif', '', '36', '', '', 1, 1, 1, 0, 4),
+(66, 66, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Vlastník', '', '32', '', '', 0, 1, 0, 0, 2),
+(67, 67, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'WWW', 'Internetové stránky', '', '18', '', '', 0, 1, 0, 0, 3),
+(68, 68, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Text', 'Text zprávy', '', '3', '', '', 1, 1, 1, 1, 9),
+(69, 69, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Date', 'Datum', '', '2', '', '', 1, 1, 1, 0, 9),
+(70, 70, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Member', 'Člen', '', '32', '', '', 1, 1, 1, 0, 9),
+(71, 71, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Typ zprávy', '', '10', '', '', 1, 1, 1, 0, 9),
+(72, 72, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ReportList', 'Záznamy', '', '27', '', '', 0, 1, 0, 0, 4),
+(73, 73, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Creator', 'Vložil', '', '37', '', '', 1, 1, 0, 0, 9),
+(74, 74, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 10),
+(75, 75, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BankName', 'Jméno banky', '', '3', '', '', 1, 1, 0, 0, 10),
+(76, 76, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Number', 'Identifikační číslo', '', '3', '', '', 1, 1, 1, 0, 10),
+(77, 77, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BankCode', 'Kód banky', '', '3', '', '', 1, 1, 1, 0, 10),
+(78, 78, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'User', 'Registroval', '', '37', '', '', 0, 1, 0, 0, 10),
+(79, 79, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Typ', '', '11', '', '', 1, 1, 1, 0, 10),
+(80, 80, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberList', 'Členství', '', '25', '', '', 0, 1, 0, 0, 3),
+(81, 81, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Systémové jméno typu', '', '3', 'Jméno by mělo obsahovat pouze velké a malé písmena. V podsložece types projektu jsou umístěny výkonné soubory pro jednotlivé typy.', 'Name', 1, 1, 1, 1, 11),
+(82, 82, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ParentType', 'Rodičovský typ', '', '35', '', '', 1, 1, 1, 0, 11),
+(83, 83, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Parameters', 'Parametry typu', '', '3', '', 'Parametry zadávejte jako řetězce oddělené symblem "|".', 0, 1, 0, 0, 11),
+(84, 84, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'System', 'Systémový', '', '4', '', '0', 1, 1, 0, 0, 11),
+(88, 88, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 11),
+(89, 89, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 12),
+(90, 90, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Amount', 'Částka', '', '16', '', '', 1, 1, 1, 0, 12),
+(91, 91, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Time', 'Čas', '', '2', '', '', 1, 1, 1, 0, 12),
+(92, 92, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SourceSubject', 'Zdrojový subjekt', '', '33', '', '', 1, 1, 1, 0, 12),
+(93, 93, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TargetSubject', 'Cílový subjekt', '', '33', '', '', 1, 1, 1, 0, 12),
+(94, 94, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Type', '', '15', '', '', 1, 1, 0, 0, 12),
+(95, 95, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'InsertedByUser', 'Vložil', '', '37', '', '', 0, 0, 0, 0, 12),
+(96, 96, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'DbDataType', 'Datový typ v databázi', '', '3', '', '', 1, 1, 0, 0, 11),
+(97, 97, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TableName', 'Jméno tabulky', '', '3', 'Zadejte jméno tabulky v databázi, která bude použita pro uchování informací.', '', 1, 1, 1, 0, 13),
+(98, 98, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Title', 'Název seznamu', '', '3', 'Zadejte nadpis seznamu.', '', 1, 1, 1, 1, 13),
+(99, 99, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'VisibleInMenu', 'Viditelné v menu', '', '4', 'Zobrazovat tuto tabulku v hlavním menu', '', 1, 1, 0, 0, 13),
+(100, 100, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Items', 'Položky', '', '28', 'Definujte potřebné položky pro seznam.', '', 1, 1, 0, 0, 13),
+(101, 101, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Name', 'Jméno sloupce', '', '3', 'Jméno sloupce tabulky v databázi', '', 1, 1, 1, 0, 14),
+(102, 102, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TextBefore', 'Text před hodnotou', '', '3', 'Oznčení položky umístěné před zobrazenou hodnotou.', '', 1, 1, 1, 1, 14),
+(103, 103, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TextAfter', 'Text za hodnotou', '', '3', 'Tento text většinou obsahuje jednotky použité veličiny.', '', 1, 1, 0, 0, 14),
+(104, 104, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Type', 'Type', '', '35', 'Typ dat položky', '', 1, 1, 1, 0, 14),
+(105, 105, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Help', 'Nápověda', '', '3', 'Textová nápověda zobrazovaná jako pomůcka při editaci hodnoty.', '', 1, 1, 0, 0, 14),
+(106, 106, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Required', 'Požadováno', '', '4', 'Určuje zda je nutné danou položku vyplnit.', '', 1, 1, 0, 0, 14),
+(107, 107, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Editable', 'Editovatelné', '', '4', 'Určuje zda je možné danou položku ručně editovat nebo zda je měněna automaticky systémem.', '', 1, 1, 0, 0, 14),
+(108, 108, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'VisibleInList', 'Viditelné v seznamu', '', '4', 'Určuje viditelnost této položky v seznamu', '', 1, 1, 0, 0, 14),
+(109, 109, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'VisibleInPointer', 'Viditelné v odkazech', '', '4', 'Určuje viditelnost této položky v názvech odkazů na tuto položku', '', 1, 1, 0, 0, 14),
+(110, 110, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Area', 'Umístění', '', '30', 'Vyberte oblast, do které toto zařízení patří.', '', 0, 1, 0, 0, 2),
+(111, 111, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'HostList', 'Seznam zařízení', '', '22', '', '', 0, 1, 0, 0, 5),
+(112, 112, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'UserList', 'Uživatelů', '', '29', '', '', 0, 1, 0, 0, 4),
+(114, 114, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ValidToTime', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 4),
+(115, 115, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'User', 'Uživatel', '', '37', '', '', 1, 0, 1, 1, 15),
+(116, 116, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LoginTime', 'Čas přihlášení', '', '2', '', '', 0, 0, 0, 0, 15),
+(117, 117, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ActivityTime', 'Naposledy aktivní', '', '2', '', '', 0, 0, 0, 0, 15),
+(118, 118, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'SessionId', 'Identifikace spojení', '', '3', '', '', 0, 0, 0, 0, 15),
+(119, 119, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IpAddress', 'IP adresa', '', '3', '', '', 0, 0, 0, 0, 15),
+(120, 120, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'HostName', 'Jméno počítače', '', '3', '', '', 0, 0, 1, 0, 15),
+(121, 121, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Locked', 'Zamčeno', '', '4', '', '', 0, 0, 0, 0, 1),
+(122, 122, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'RegistrationTime', 'Čas registrace', '', '2', '', '', 0, 0, 0, 0, 1),
+(123, 123, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LastLoginTime', 'Čas posledního přihlášení', '', '2', '', '', 0, 0, 0, 0, 1),
+(124, 124, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'LastIpAddress', 'Poslední IP adresa', '', '3', '', '', 0, 0, 0, 0, 1),
+(125, 125, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Author', 'Autor', '', '37', '', '', 1, 0, 0, 0, 16),
+(126, 126, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeCreation', 'Čas vytvoření', '', '2', '', '', 1, 0, 0, 0, 16),
+(127, 127, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeValidFrom', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 16),
+(128, 128, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'TimeValidTo', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 16),
+(129, 129, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ListId', 'Odkazovaná tabulka', '', '34', '', '', 1, 1, 0, 0, 16),
+(130, 130, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PermanentId', 'Trvalá identifikace', '', '1', '', '', 1, 1, 0, 0, 16),
+(133, 132, 5, '2008-10-12 17:48:27', '0000-00-00 00:00:00', '2008-10-12 17:48:27', 'List', 'Rodičovský seznam', '', '34', '', '', 1, 0, 0, 0, 14),
+(142, 133, 5, '2008-10-12 18:39:09', '0000-00-00 00:00:00', '2008-10-12 18:39:09', 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 26);
 
 -- --------------------------------------------------------
@@ -528 +567 @@
 CREATE TABLE IF NOT EXISTS `SystemType` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `Description` varchar(255) collate utf8_czech_ci NOT NULL,
-  `ParentType` varchar(255) collate utf8_czech_ci NOT NULL,
+  `ParentType` int(255) NOT NULL,
   `Parameters` varchar(255) collate utf8_czech_ci NOT NULL,
   `System` tinyint(1) NOT NULL default '0',
   `DbDataType` varchar(255) collate utf8_czech_ci NOT NULL,
-  `CallbackView` varchar(255) collate utf8_czech_ci NOT NULL,
-  `CallbackEdit` varchar(255) collate utf8_czech_ci NOT NULL,
-  `CallbackCheck` varchar(255) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`Id`),
   UNIQUE KEY `Name` (`Name`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=20 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=39 ;
 
 --
@@ -545 +586 @@
 --
 
-INSERT INTO `SystemType` (`Id`, `Name`, `Description`, `ParentType`, `Parameters`, `System`, `DbDataType`, `CallbackView`, `CallbackEdit`, `CallbackCheck`) VALUES
-(1, 'Integer', 'Číslo', '', '', 1, 'INT', 'TypeIntegerViewHtml', 'TypeIntegerEditHtml', ''),
-(2, 'Date', 'Datum', '', '', 1, 'DATE', 'TypeDateViewHtml', 'TypeDateEditHtml', ''),
-(3, 'String', 'Řetězec', '', '', 1, 'VARCHAR(255)', 'TypeStringViewHtml', 'TypeStringEditHtml', ''),
-(4, 'Boolean', 'Logická hodnota', '', '', 1, 'BOOL', 'TypeBooleanViewHtml', 'TypeBooleanEditHtml', ''),
-(5, 'Sex', 'Pohlaví', 'Enumeration', 'Muž|Žena', 0, '', '', '', ''),
-(6, 'MemberState', 'Stav člena', 'Enumeration', 'Neznámý stav|Zájemce o připojení|Připojen|Trvale odpojen', 0, '', '', '', ''),
-(7, 'HostType', 'Typ zařízení', 'Enumeration', 'Nezařazeno|Osobní počítač|VoIP zařízení|IPTV zařízení|Směrovač|Server|Tiskárna/Skener/Kopírka|Jiné', 0, '', '', '', ''),
-(8, 'InterfaceType', 'Typ rozhraní', 'Enumeration', '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, '', '', '', ''),
-(9, 'AssetState', 'Stav majetku', 'Enumeration', 'Neznámý|Na skladě|Používáno|V reklamaci|Vyřazeno', 0, '', '', '', ''),
-(10, 'MemberReportType', 'Typ hlášení člena', 'Enumeration', 'Jiné|Hlášení závady|Požadavek na změnu|Poznámka správce', 0, '', '', '', ''),
-(11, 'BankAccountType', 'Typ účtu', 'Enumeration', 'Neurčeno|Běžný účet|Spořící účet', 0, '', '', '', ''),
-(12, 'PointerOneToOne', 'Ukazatel na jednu položku', '', '', 1, 'INT', 'TypePointerOneToOneViewHtml', 'TypePointerOneToOneEditHtml', ''),
-(13, 'PointerOneToMany', 'Ukazatel na více položek', '', '', 1, 'INT', 'TypePointerOneToManyViewHtml', 'TypePointerOneToManyEditHtml', ''),
-(14, 'Enumeration', 'Výčet', '', '', 0, 'INT', 'TypeEnumerationViewHtml', 'TypeEnumerationEditHtml', ''),
-(15, 'Password', 'Heslo', '', '', 1, '', 'TypePasswordViewHtml', 'TypePasswordEditHtml', ''),
-(16, 'Float', 'Desetinné číslo', '', '', 1, 'FLOAT', 'TypeFloatViewHtml', 'TypeFloatEditHtml', ''),
-(17, 'FinanceTransactionType', 'Typ finanční transakce', 'Enumeration', 'Bankovní převod|Osobní platba', 0, '', '', '', ''),
-(18, 'Hyperlink', 'Internetový odkaz', '', '', 0, 'VARCHAR(255)', 'TypeHyperlinkViewHtml', 'TypeHyperlinkEditHtml', ''),
-(19, 'IPv4Address', 'IP adresa v4', '', '', 0, 'VARCHAR(16)', 'TypeIPv4AddressView', 'TypeIPv4AddressEdit', 'TypeIPv4AddressCheck');
+INSERT INTO `SystemType` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `Description`, `ParentType`, `Parameters`, `System`, `DbDataType`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Integer', 'Číslo', 0, '', 1, 'INT'),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Date', 'Datum', 0, '', 1, 'DATE'),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'String', 'Řetězec', 0, '', 1, 'VARCHAR(255)'),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Boolean', 'Logická hodnota', 0, '', 1, 'BOOL'),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Sex', 'Pohlaví', 14, 'Muž|Žena', 0, ''),
+(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberState', 'Stav člena', 14, 'Neznámý stav|Zájemce o připojení|Připojen|Trvale odpojen', 0, ''),
+(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'HostType', 'Typ zařízení', 14, 'Nezařazeno|Osobní počítač|VoIP zařízení|IPTV zařízení|Směrovač|Server|Tiskárna/Skener/Kopírka|Jiné', 0, ''),
+(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'InterfaceType', 'Typ rozhraní', 14, 'Jiný|Ethernet 10 Mbit/s|Ethernet 100 Mbit/s|Ethernet 1 Gbit/s|Wifi 2,4 GHz 802.11b 11 Mbit/s|Wifi 2,4 GHz 802.11g 54 Mbit/s|Wifi 5 GHz 802.11a 54 Mbit/s|Optika 100 Mbit/s|Optika 1 Gbit/s', 0, ''),
+(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'AssetState', 'Stav majetku', 14, 'Neznámý|Na skladě|Používáno|V reklamaci|Vyřazeno', 0, ''),
+(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'MemberReportType', 'Typ hlášení člena', 14, 'Jiné|Hlášení závady|Požadavek na změnu|Poznámka správce', 0, ''),
+(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'BankAccountType', 'Typ účtu', 14, 'Neurčeno|Běžný účet|Spořící účet', 0, ''),
+(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerOneToOne', 'Ukazatel na jednu položku', 0, '', 1, 'INT'),
+(13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerOneToMany', 'Ukazatel na více položek', 0, '', 1, 'INT'),
+(14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Enumeration', 'Výčet', 0, '', 0, 'INT'),
+(15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Password', 'Heslo', 0, '', 1, ''),
+(16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Float', 'Desetinné číslo', 0, '', 1, 'FLOAT'),
+(17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'FinanceTransactionType', 'Typ finanční transakce', 14, 'Bankovní převod|Osobní platba', 0, ''),
+(18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Hyperlink', 'Internetový odkaz', 0, '', 0, 'VARCHAR(255)'),
+(19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'IPv4Address', 'IP adresa v4', 0, '', 0, 'VARCHAR(16)'),
+(20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Hidden', 'Skrytá položka formuláře', 0, '', 1, 'VARCHAR(255)'),
+(21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:01:23', 'PointerToAssetPurcheasedFrom', '', 13, 'Asset|PurcheasedFrom', 0, ''),
+(22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:02:00', 'PointerToHostArea', '', 13, 'Host|Area', 0, ''),
+(23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:04:28', 'PointerToHostMember', '', 13, 'Host|Member', 0, ''),
+(24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:05:47', 'PointerToInterfaceHost', '', 13, 'Interface|Host', 0, ''),
+(25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', 'PointerToMemberSubject', '', 13, 'Member|Subject', 0, ''),
+(26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', 'PointerToMemberTariff', '', 13, 'Member|Tariff', 0, ''),
+(27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToMemberReportMember', '', 13, 'MemberReport|Member    ', 0, ''),
+(28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToSystemListItemList', '', 13, 'SystemListItem|List', 0, ''),
+(29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', 'PointerToUserMember', '', 13, 'User|Member', 0, ''),
+(30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', 'PointerToArea', '', 12, 'Area', 0, ''),
+(31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerOneToHost', '', 12, 'Host', 0, ''),
+(32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToMember', '', 12, 'Member', 0, ''),
+(33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:11:14', 'PointerToSubject', '', 12, 'Subject', 0, ''),
+(34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:12:37', 'PointerToSystemList', '', 12, 'SystemList', 0, ''),
+(35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToSystemType', '', 12, 'SystemType', 0, ''),
+(36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', 'PointerToTariff', '', 12, 'Tariff', 0, ''),
+(37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', 'PointerToUser', '', 12, 'User', 0, ''),
+(38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'PointerToHostParentHost', '', 13, 'Host|ParentHost', 0, '');
 
 -- --------------------------------------------------------
@@ -574 +634 @@
 CREATE TABLE IF NOT EXISTS `Tariff` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `Price` float NOT NULL,
@@ -588 +653 @@
 --
 
-INSERT INTO `Tariff` (`Id`, `Name`, `Price`, `MinUploadSpeed`, `MaxUploadSpeed`, `MinDownloadSpeed`, `MaxDownloadSpeed`, `MemberList`) VALUES
-(1, 'Internet 512 kbit', 190, 31, 512, 31, 512, 0),
-(2, 'Internet 1 Mbit', 260, 62, 1024, 62, 1024, 0),
-(3, 'Internet 2 Mbit', 360, 124, 2048, 124, 2048, 0),
-(4, 'Internet 4 Mbit', 520, 249, 4096, 249, 4096, 0),
-(5, 'Internet 8 Mbit', 750, 497, 8192, 497, 8192, 0);
+INSERT INTO `Tariff` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `Name`, `Price`, `MinUploadSpeed`, `MaxUploadSpeed`, `MinDownloadSpeed`, `MaxDownloadSpeed`, `MemberList`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 512 kbit', 190, 31, 512, 31, 512, 0),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 1 Mbit', 260, 62, 1024, 62, 1024, 0),
+(3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 2 Mbit', 360, 124, 2048, 124, 2048, 0),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 4 Mbit', 520, 249, 4096, 249, 4096, 0),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Internet 8 Mbit', 750, 497, 8192, 497, 8192, 0);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `Test`
+--
+
+CREATE TABLE IF NOT EXISTS `Test` (
+  `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
+  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
+
+--
+-- Vypisuji data pro tabulku `Test`
+--
+
 
 -- --------------------------------------------------------
@@ -603 +690 @@
 CREATE TABLE IF NOT EXISTS `User` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `UserName` varchar(255) collate utf8_czech_ci NOT NULL,
   `Password` varchar(255) collate utf8_czech_ci NOT NULL,
@@ -624 +716 @@
 --
 
-INSERT INTO `User` (`Id`, `UserName`, `Password`, `FirstName`, `SecondName`, `Email`, `ICQ`, `Sex`, `BirthDay`, `Phone`, `Member`, `RegistrationTime`, `LastLoginTime`, `Locked`, `LastIpAddress`) VALUES
-(1, '', '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, ''),
-(2, '', '', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '0000-00-00', '123456789', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
-(4, '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, ''),
-(5, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '0000-00-00', '', 6, '0000-00-00 00:00:00', '2008-09-29 12:50:38', 0, ''),
-(6, '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
-(7, '', '', '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, ''),
-(8, '', '', '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, ''),
-(9, '', '', '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, ''),
-(10, '', '', '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, ''),
-(11, '', '', '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, ''),
-(12, '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, '');
+INSERT INTO `User` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `UserName`, `Password`, `FirstName`, `SecondName`, `Email`, `ICQ`, `Sex`, `BirthDay`, `Phone`, `Member`, `RegistrationTime`, `LastLoginTime`, `Locked`, `LastIpAddress`) VALUES
+(1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'fdsfsdfsd', 'Alfons', 'Much', 'mucha@all.cz', 89, 0, '0000-00-00', '', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
+(2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '0000-00-00', '123456789', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
+(4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'ferda', '123', 'Ferda', 'Mravenec', 'ferda@mraveniste.cz', 1, 0, '0000-00-00', '', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
+(5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '0000-00-00', '', 6, '0000-00-00 00:00:00', '2008-10-11 19:11:56', 0, ''),
+(6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
+(7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 'Petr', 'Slovák', 'slovak@zdarma.cz', 34, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
+(8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 'Alena', 'Kocourková', 'alena.kocourkova@centrum.cz', 32, 1, '0000-00-00', '223344556', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
+(9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 'Jonny', 'Hurikán', 'storm@atlas.cz', 16, 0, '0000-00-00', '224556778', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
+(10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 'Smrťák', 'Krutý', 'smrt@peklo.cz', 111222333, 0, '0000-00-00', '', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
+(11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 'Karel', 'Nejedlý', 'starosta@obec-milosice.cz', 0, 0, '0000-00-00', '443666333', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''),
+(12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'fantomas', 'dsds', 'Fantomas', 'Tajemný', 'fantom@fantom.com', 0, 0, '0000-00-00', '', 12, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '');
 
 -- --------------------------------------------------------
@@ -651 +743 @@
   `HostName` varchar(255) collate utf8_czech_ci NOT NULL,
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   PRIMARY KEY  (`Id`),
   KEY `User` (`User`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
 
 --
@@ -659 +756 @@
 --
 
-INSERT INTO `UserOnline` (`User`, `LoginTime`, `ActivityTime`, `SessionId`, `IpAddress`, `HostName`, `Id`) VALUES
-(0, '2008-09-29 09:33:17', '2008-09-29 11:07:24', '96bhsqoheu6feqh7rmpa30ak92', '192.168.0.23', 'george-nb.zdechov.net', 1),
-(5, '2008-09-29 11:07:29', '2008-09-29 14:29:45', 'ectsef5epcsgtcb4mpscq3kk84', '192.168.0.23', 'george-nb.zdechov.net', 2);
+INSERT INTO `UserOnline` (`User`, `LoginTime`, `ActivityTime`, `SessionId`, `IpAddress`, `HostName`, `Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`) VALUES
+(5, '2008-10-11 19:11:48', '2008-10-12 20:36:20', 'h10jgvuaueeqe09je1ataith80', '192.168.0.23', 'george-nb.zdechov.net', 10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

sql/system_structure.sql

@@ -1 +1 @@
 -- phpMyAdmin SQL Dump
--- version 2.11.9
+-- version 2.11.9.2
 -- http://www.phpmyadmin.net
 --
 -- Počítač: localhost
--- Vygenerováno: Úterý 16. září 2008, 09:15
+-- Vygenerováno: Neděle 12. října 2008, 20:38
 -- Verze MySQL: 5.0.51
 -- Verze PHP: 5.2.6
@@ -22 +22 @@
 CREATE TABLE IF NOT EXISTS `SystemList` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `TableName` varchar(255) collate utf8_czech_ci NOT NULL,
   `Title` varchar(255) collate utf8_czech_ci NOT NULL,
@@ -28 +33 @@
   `VisibleInMenu` int(11) NOT NULL default '1',
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=15 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=27 ;
 
 -- --------------------------------------------------------
@@ -38 +43 @@
 CREATE TABLE IF NOT EXISTS `SystemListItem` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `TextBefore` varchar(255) collate utf8_czech_ci NOT NULL,
@@ -50 +60 @@
   `List` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=110 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=143 ;
 
 -- --------------------------------------------------------
@@ -60 +70 @@
 CREATE TABLE IF NOT EXISTS `SystemType` (
   `Id` int(11) NOT NULL auto_increment,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime NOT NULL,
+  `ValidTimeTo` datetime NOT NULL,
+  `CreationTime` datetime NOT NULL,
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `Description` varchar(255) collate utf8_czech_ci NOT NULL,
-  `ParentType` varchar(255) collate utf8_czech_ci NOT NULL,
+  `ParentType` int(255) NOT NULL,
   `Parameters` varchar(255) collate utf8_czech_ci NOT NULL,
   `System` tinyint(1) NOT NULL default '0',
   `DbDataType` varchar(255) collate utf8_czech_ci NOT NULL,
-  `CallbackView` varchar(255) collate utf8_czech_ci NOT NULL,
-  `CallbackEdit` varchar(255) collate utf8_czech_ci NOT NULL,
-  `CallbackCheck` varchar(255) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`Id`),
   UNIQUE KEY `Name` (`Name`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=19 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=39 ;

types/Boolean.php

@@ -1 +1 @@
 <?php
 
-function TypeBooleanViewHtml($Type, $Item)
+function TypeBooleanOnView($Item)
 {
   return('<input type="checkbox" name="'.$Item['Name'].'" value="'.$Item['Value'].'" disabled="1">');
 }
 
-function TypeBooleanEditHtml($Type, $Item)
+function TypeBooleanOnEdit($Item)
 {
   return('<input type="checkbox" name="'.$Item['Name'].'" value="'.$Item['Value'].'">');

types/Date.php

@@ -3 +3 @@
 $MonthList = array('0', 'Leden', 'Únor', 'Březen', 'Duben', 'Květen', 'Červen', 'Červenec', 'Srpen', 'Září', 'Říjen', 'Listopad', 'Prosinec');
 
-function TypeDateViewHtml($Type, $Item)
+function TypeDateOnView($Item)
 {
   global $MonthList;
@@ -13 +13 @@
 }
 
-function TypeDateEditHtml($Type, $Item)
+function TypeDateOnEdit($Item)
 {
   global $MonthList;

types/Enumeration.php

@@ -1 +1 @@
 <?php
 
-function TypeEnumerationViewHtml($Type, $Item)
+function TypeEnumerationOnView($Item)
 {
-  $Output = $Type['Parameters'][$Item['Value']];
+  global $Types;
+
+  $Output = $Types[$Item['Type']]['Parameters'][$Item['Value']];
   return($Output);
 }
 
-function TypeEnumerationEditHtml($Type, $Item)
+function TypeEnumerationOnEdit($Item)
 {
+  global $Types;
+
   $Output = '<select name="'.$Item['Name'].'">';
-  foreach($Type['Parameters'] as $Index => $StateName)
+  foreach($Types[$Item['Type']]['Parameters'] as $Index => $StateName)
   {
     if($Parameter == $Index) $Selected = ' selected="1"'; else $Selected = '';

types/Float.php

@@ -1 +1 @@
 <?php
 
-function TypeFloatViewHtml($Type, $Item)
+function TypeFloatOnView($Item)
 {
   $Output = $Item['Value'];
@@ -7 +7 @@
 }
 
-function TypeFloatEditHtml($Type, $Item)
+function TypeFloatEditHtml($Item)
 {
   $Output = '<input type="text" name="'.$Item['Name'].'" value="'.$Item['Value'].'">';

types/Hyperlink.php

@@ -1 +1 @@
 <?php
 
-function TypeHyperlinkViewHtml($Type, $Item)
+function TypeHyperlinkOnView($Item)
 {
   $Output = '<a href="'.$Item['Value'].'">'.$Item['Value'].'</a>';
@@ -7 +7 @@
 }
 
-function TypeHyperlinkEditHtml($Type, $Item)
+function TypeHyperlinkOnEdit($Item)
 {
   $Output = '<input type="text" name="'.$Item['Name'].'" value="'.$Item['Value'].'">';

types/IPv4Address.php

@@ -1 +1 @@
 <?php
 
-function TypeIPv4AddressView($Type, $Item)
+function TypeIPv4AddressOnView($Item)
 {
   $Output = $Item['Value'];
@@ -7 +7 @@
 }
 
-function TypeIPv4AddressEdit($Type, $Item)
+function TypeIPv4AddressOnEdit($Item)
 {
   $Output = '<input type="text" name="'.$Item['Name'].'" value="'.$Item['Value'].'">';
@@ -13 +13 @@
 }
 
-function TypeIPv4AddressCheck($Type, $Parameter, $Table, $Id)
+function TypeIPv4AddressOnCheck($Parameter, $Table, $Id)
 {
   return(true);

types/Integer.php

@@ -1 +1 @@
 <?php
 
-function TypeIntegerViewHtml($Type, $Item)
+function TypeIntegerOnView($Item)
 {
   $Output = $Item['Value'];
@@ -7 +7 @@
 }
 
-function TypeIntegerEditHtml($Type, $Item)
+function TypeIntegerOnEdit($Item)
 {
   $Output = '<input type="text" name="'.$Item['Name'].'" value="'.$Item['Value'].'">';

types/Password.php

@@ -1 +1 @@
 <?php
 
-function TypePasswordViewHtml($Type, $Item)
+function TypePasswordOnView($Item)
 {
   $Output = '';
@@ -9 +9 @@
 }
 
-function TypePasswordEditHtml($Type, $Item)
+function TypePasswordOnEdit($Item)
 {
   $Output = '<input type="password" name="'.$Item['Name'].'" value="'.$Item['Value'].'">';

types/PointerOneToMany.php

@@ -1 +1 @@
 <?php
 
-function TypePointerOneToManyViewHtml($Type, $Item)
+function TypePointerOneToManyOnView($Item)
 {
   $Output = '<a href="?Action=ShowList&amp;TableId='.$Type['TypeDefinition'].'&amp;ParentTable='.$Item['SourceTable'].'&amp;ParentColumn='.$Item['SourceItemId'].'">Seznam</a>';
@@ -7 +7 @@
 }
 
-function TypePointerOneToManyEditHtml($Type, $Item)
+function TypePointerOneToManyOnEdit($Item)
 {
   $Output = '<a href="?Action=ShowList&amp;TableId='.$Type['TypeDefinition'].'&amp;ParentTable='.$Item['SourceTable'].'&amp;ParentColumn='.$Item['SourceItemId'].'">Seznam</a>';

types/PointerOneToOne.php

@@ -6 +6 @@
 
   $Columns = '';
-  $ItemType = explode(':', $Item['Type']);
-  $TargetTable = $ItemType[1];
+  $TargetTable = $Type['Parameters'][0];
 
   foreach($Lists[$TargetTable]['Items'] as $ListItem)
@@ -25 +24 @@
 
   $Columns = '';
-  $ItemType = explode(':', $Item['Type']);
-  $TargetTable = $ItemType[1];
+  $TargetTable = $Type['Parameters'][0];
 
   foreach($Lists[$TargetTable]['Items'] as $ListItem)
@@ -42 +40 @@
 }
 
-function TypePointerOneToOneViewHtml($Type, $Item)
+function TypePointerOneToOneOnView($Item)
 {
-  global $Database, $Lists;
+  global $Database, $Lists, $Types;
 
-  $ItemType = explode(':', $Item['Type']);
-  $TargetTable = $ItemType[1];
+  $Type = $Types[$Item['Type']];
+  $TargetTable = $Type['Parameters'][0];
   $TargetName = GetTablePointerName($Type, $Item);
   $Output = '<a href="?Action=ViewItem&amp;Table='.$TargetTable.'&amp;Item='.$TargetName['Id'].'">'.$TargetName['Name'].'</a>';
@@ -53 +51 @@
 }
 
-function TypePointerOneToOneEditHtml($Type, $Item)
+function TypePointerOneToOneOnEdit($Item)
 {
-  global $Database, $Lists;
+  global $Database, $Lists, $Types;
 
+  $Type = $Types[$Item['Type']];
   $Output = '<select name="'.$Item['Name'].'">';
   $TargetNameList = GetTablePointerNameList($Type, $Item);

types/String.php

@@ -1 +1 @@
 <?php
 
-function TypeStringViewHtml($Type, $Item)
+function TypeStringOnView($Item)
 {
   $Output = $Item['Value'];
@@ -7 +7 @@
 }
 
-function TypeStringEditHtml($Type, $Item)
+function TypeStringOnEdit($Item)
 {
   $Output = '<input type="text" name="'.$Item['Name'].'" value="'.$Item['Value'].'">';