<?php

function TableStructure()
{
  global $Database;
  
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemType` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
  `Description` 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,
  `ParameterList` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query("INSERT INTO `SystemType` (`Id`, `Name`, `Description`, `ParentType`, `Parameters`, `System`, `DbDataType`, `ParameterList`) VALUES
(1, 'Integer', 'Číslo', 0, '', 1, 'INT', 0),
(2, 'Date', 'Datum', 0, '', 1, 'DATE', 0),
(3, 'String', 'Řetězec', 0, '', 1, 'VARCHAR(255)', 0),
(4, 'Boolean', 'Logická hodnota', 0, '', 1, 'BOOL', 0),
(5, 'Float', 'Desetinné číslo', 0, '', 1, 'FLOAT', 0),
(6, 'Enumeration', 'Výčet', 0, '', 0, 'INT', 0),
(7, 'PointerOneToOne', 'Ukazatel na jednu položku', 0, '', 1, 'INT', 0),
(8, 'PointerOneToMany', 'Ukazatel na více položek', 0, '', 1, 'INT', 0),
(9, 'Password', 'Heslo', 0, '', 1, 'INT', 0),
(10, 'Hyperlink', 'Internetový odkaz', 0, '', 0, 'VARCHAR(255)', 0),
(11, 'IPv4Address', 'IP adresa v4', 0, '', 0, 'VARCHAR(16)', 0),
(12, 'Hidden', 'Skrytá položka formuláře', 0, '', 1, 'VARCHAR(255)', 0),
(13, 'DateTime', 'Datum a čas', 0, '', 1, 'DATETIME', 0),
(14, 'File', 'Soubor', 0, '', 1, 'INT', 0),
(15, 'GPS', 'Zemská souřadnice', 0, '', 1, 'INT', 0),
(16, 'MySQLDataTypes', 'Databázový datový typ ', 14, 'INT|VARCHAR(255)|TEXT|FLOAT|DOUBLE|TIME|DATE|DATETIME|', 1, 'INT', 0),

(17, 'Sex', 'Pohlaví', 14, 'Muž|Žena', 0, 'INT', 0),
(18, 'PointerToSystemListItemList', '', 13, 'SystemListItem|List', 0, 'INT', 0),
(19, 'PointerToSystemList', '', 12, 'SystemList', 0, 'INT', 0),
(20, 'PointerToSystemType', '', 12, 'SystemType', 0, 'INT', 0),
(21, 'PointerToMenu', 'Ukazatel na menu', 12, 'SystemMenu', 0, 'INT', 0),
(22, 'PointerToSystemListMenu', 'Položky menu', 13, 'SystemList|Menu', 0, 'INT', 0),
(23, 'PointerToSystemTypeParameter', 'Ukazatel na seznam paramtrů', 13, 'SystemTypeParameter|ParentType', 0, 'INT', 0),
(24, 'PointerToSystemEnumerationState', 'Seznam stavů výčtu', 13, 'SystemEnumerationState|ParentType', 0, 'INT', 0);");

  $Database->query('CREATE TABLE IF NOT EXISTS `SystemEnumerationState` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
  `ParentParameter` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemFile` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
  `Size` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemGPS` (
  `Id` int(11) NOT NULL auto_increment,
  `Longitude` double NOT NULL,
  `Latitude` double NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemList` (
  `Id` int(11) NOT NULL auto_increment,
  `TableName` varchar(255) collate utf8_czech_ci NOT NULL,
  `Title` varchar(255) collate utf8_czech_ci NOT NULL,
  `Items` varchar(255) collate utf8_czech_ci NOT NULL,
  `Menu` int(11) NOT NULL,
  `Sequence` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemListItem` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
  `TextBefore` varchar(255) collate utf8_czech_ci NOT NULL,
  `TextAfter` varchar(255) collate utf8_czech_ci NOT NULL,
  `Type` varchar(255) collate utf8_czech_ci NOT NULL,
  `Help` varchar(255) collate utf8_czech_ci NOT NULL,
  `Default` varchar(255) collate utf8_czech_ci NOT NULL,
  `Required` tinyint(1) NOT NULL default '1',
  `Editable` tinyint(1) NOT NULL default '1',
  `VisibleInList` tinyint(1) NOT NULL default '0',
  `VisibleInPointer` tinyint(1) NOT NULL default '0',
  `List` int(11) NOT NULL,
  `Sequence` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemLog` (
  `Id` int(11) NOT NULL auto_increment,
  `User` int(11) NOT NULL,
  `List` int(11) NOT NULL,
  `Item` int(11) NOT NULL,
  `Action` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemMenu` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
  `SystemListItems` int(11) NOT NULL,
  `Sequence` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemType` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
  `Description` 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,
  `ParameterList` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemTypeParameter` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
  `Type` int(11) NOT NULL,
  `ParentType` int(11) NOT NULL,
  `Description` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci');
  $Database->query('CREATE TABLE IF NOT EXISTS `SystemTypeParameterValue` (
  `Id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
  $Database->query('CREATE TABLE IF NOT EXISTS `User` (
  `Id` int(11) NOT NULL auto_increment,
  `UserName` varchar(255) collate utf8_czech_ci NOT NULL,
  `Password` varchar(255) collate utf8_czech_ci NOT NULL,
  `FirstName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
  `SecondName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
  `Email` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL,
  `ICQ` int(11) NOT NULL,
  `Sex` int(11) NOT NULL default '0',
  `BirthDay` date NOT NULL,
  `Phone` varchar(255) collate utf8_czech_ci NOT NULL,
  `Member` int(11) NOT NULL,
  `RegistrationTime` datetime NOT NULL,
  `LastLoginTime` datetime NOT NULL,
  `Locked` tinyint(1) NOT NULL,
  `LastIpAddress` varchar(255) collate utf8_czech_ci NOT NULL,
  `PermissionGroup` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci');
  $Database->query('CREATE TABLE IF NOT EXISTS `UserOnline` (
  `User` int(11) NOT NULL,
  `LoginTime` datetime NOT NULL,
  `ActivityTime` datetime NOT NULL,
  `SessionId` varchar(255) collate utf8_czech_ci NOT NULL,
  `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL,
  `HostName` varchar(255) collate utf8_czech_ci NOT NULL,
  `Id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`Id`),
  KEY `User` (`User`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci');

}

function LoadInitData()
{

}

?>