Changeset 30 for install

Timestamp:

Dec 16, 2008, 8:15:34 AM (15 years ago)

Author:

george

Message:

• Přidáno: Podpora pro určování v definicích krom tabulky také jméno databáze a jméno primárního identifikačního sloupce.

File:

• install/system_init.php (modified) (1 diff)

install/system_init.php

@@ -1 +1 @@
 <?php
 
-$SytemList = array();
+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()
+{
+
+}
 
 ?>