Changeset 6 for trunk/SQL/Structure.sql

Timestamp:

Dec 25, 2010, 9:31:21 PM (14 years ago)

Author:

george

Message:

• Activated generation of language files.
• Added: Full screen mode.

File:

• trunk/SQL/Structure.sql (modified) (8 diffs)

trunk/SQL/Structure.sql

@@ -4 +4 @@
 --
 -- Počítač: localhost
--- Vygenerováno: Čtvrtek 03. června 2010, 15:29
+-- Vygenerováno: Čtvrtek 03. června 2010, 18:00
 -- Verze MySQL: 5.1.46
 -- Verze PHP: 5.3.2
@@ -17 +17 @@
 
 --
--- Struktura tabulky `MenuGroup`
---
-
-CREATE TABLE IF NOT EXISTS `MenuGroup` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Name` varchar(255) NOT NULL,
-  `Parent` int(11) NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
-
--- --------------------------------------------------------
-
---
 -- Struktura tabulky `Object`
 --
@@ -36 +23 @@
   `Id` int(11) NOT NULL AUTO_INCREMENT,
   `Name` varchar(255) NOT NULL,
-  `MenuGroup` int(11) NOT NULL,
   `Schema` varchar(255) NOT NULL,
   `Table` varchar(255) NOT NULL,
   `PrimaryKey` varchar(255) NOT NULL DEFAULT 'Id',
-  PRIMARY KEY (`Id`),
-  KEY `MenuGroup` (`MenuGroup`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
+  `Sequence` int(11) NOT NULL,
+  `Group` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Group` (`Group`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
+
+--
+-- Vypisuji data pro tabulku `Object`
+--
+
+INSERT INTO `Object` (`Id`, `Name`, `Schema`, `Table`, `PrimaryKey`, `Sequence`, `Group`) VALUES
+(1, 'Síťová zařízení', 'centrala', 'NetworkDevice', 'Id', 0, 1),
+(2, 'Rozhraní zařízení', 'centrala', 'NetworkInterface', 'Id', 0, 1),
+(3, 'Faktury', 'centrala', 'Invoice', 'Id', 0, 2),
+(4, 'Bankovní účty', 'centrala', 'BankAccount', 'Id', 0, 2),
+(5, 'Subjekty', 'centrala', 'Subject', 'Id', 0, 4),
+(6, 'Uživatelé', 'centrala', 'User', 'Id', 0, 4),
+(7, 'Členové', 'centrala', 'Member', 'Id', 0, 4),
+(8, 'Skupiny objektů', 'chronis_system', 'ObjectGroup', 'Id', 0, 5),
+(9, 'Objekty', 'chronis_system', 'Object', 'Id', 0, 5),
+(10, 'Typy vlastností', 'chronis_system', 'Type', 'Id', 0, 5),
+(11, 'Skupiny vlastností', 'chronis_system', 'PropertyGroup', 'Id', 0, 5),
+(12, 'Vlastnosti', 'chronis_system', 'Property', 'Id', 0, 5),
+(13, 'Typ zařízení', 'centrala', 'NetworkDeviceType', 'Id', 0, 1),
+(14, 'Typ rozhraní', 'centrala', 'NetworkInterfaceType', 'Id', 0, 1);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ObjectGroup`
+--
+
+CREATE TABLE IF NOT EXISTS `ObjectGroup` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  `Parent` int(11) NOT NULL,
+  `Sequence` int(11) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
+
+--
+-- Vypisuji data pro tabulku `ObjectGroup`
+--
+
+INSERT INTO `ObjectGroup` (`Id`, `Name`, `Parent`, `Sequence`) VALUES
+(1, 'Síť', 0, 0),
+(2, 'Finance', 0, 0),
+(3, 'Portál', 0, 0),
+(4, 'Obecné', 0, 0),
+(5, 'Systémové', 0, 0);
 
 -- --------------------------------------------------------
@@ -59 +92 @@
   PRIMARY KEY (`Id`),
   KEY `Object` (`Object`),
-  KEY `PropertyGroup` (`PropertyGroup`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
+  KEY `PropertyGroup` (`PropertyGroup`),
+  KEY `Type` (`Type`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
+
+--
+-- Vypisuji data pro tabulku `Property`
+--
+
+INSERT INTO `Property` (`Id`, `Name`, `Object`, `PropertyGroup`, `Type`, `ColumnName`) VALUES
+(1, 'IP adresa', 2, 0, 1, 'IPAddress'),
+(2, 'Kód banky', 4, 0, 1, 'BankCode'),
+(3, 'Číslo', 4, 0, 1, 'Number'),
+(4, 'Název', 1, 0, 1, 'Name'),
+(5, 'Jméno', 5, 0, 1, 'Name'),
+(6, 'Ulice', 5, 0, 1, 'AddressStreet'),
+(7, 'Město', 5, 0, 1, 'AddressTown'),
+(8, 'PSČ', 5, 0, 1, 'AddressPSC'),
+(9, 'IČ', 5, 0, 1, 'IC'),
+(10, 'DIČ', 5, 0, 1, 'DIC'),
+(11, 'WWW', 5, 0, 1, 'WWW'),
+(12, 'Přihlašovací jméno', 6, 0, 2, 'Login'),
+(13, 'Jméno', 6, 0, 2, 'Name'),
+(14, 'Heslo', 6, 0, 15, 'Password'),
+(15, 'E-mail', 6, 0, 2, 'Email'),
+(16, 'IP posledního přístupu', 6, 0, 18, 'LastIpAddress'),
+(17, 'Čas posledního přístupu', 6, 0, 4, 'LastLoginTime'),
+(18, 'Čas registrace', 6, 0, 4, 'RegistrationTime'),
+(19, 'Členství', 6, 0, 16, 'Member'),
+(20, 'Uzamčeno', 6, 0, 7, 'Locked'),
+(21, 'ICQ', 6, 0, 1, 'ICQ'),
+(22, 'Telefoní číslo', 6, 0, 2, 'PhoneNumber'),
+(23, 'Jméno', 9, 0, 2, 'Name'),
+(24, 'Skupina', 9, 0, 16, 'MenuGroup'),
+(25, 'Schéma', 9, 0, 2, 'Schema'),
+(26, 'Tabulka', 9, 0, 2, 'Table'),
+(27, 'Primární klíč', 9, 0, 2, 'PrimaryKey'),
+(28, 'Pořadí', 9, 0, 1, 'Sequence'),
+(29, 'Jméno', 12, 0, 2, 'Name'),
+(30, 'Objekt', 12, 0, 16, 'Object'),
+(31, 'Jméno', 8, 0, 2, 'Name'),
+(32, 'Rodič', 8, 0, 12, 'Parent'),
+(33, 'Pořadí', 8, 0, 1, 'Sequence'),
+(34, 'Jméno', 13, 0, 2, 'Name'),
+(35, 'Ukazovat jako online', 13, 0, 7, 'ShowOnline'),
+(36, 'Jméno ikony', 13, 0, 2, 'IconName'),
+(37, 'Jméno', 14, 0, 2, 'Name'),
+(38, 'Max. rychlost', 14, 0, 1, 'MaxSpeed'),
+(39, 'Plně duplexní', 14, 0, 7, 'FullDuplex'),
+(40, 'Barva', 14, 0, 19, '');
 
 -- --------------------------------------------------------
@@ -76 +156 @@
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
 
--- --------------------------------------------------------
-
---
--- Struktura tabulky `PropertyType`
---
-
-CREATE TABLE IF NOT EXISTS `PropertyType` (
+--
+-- Vypisuji data pro tabulku `PropertyGroup`
+--
+
+INSERT INTO `PropertyGroup` (`Id`, `Object`, `Name`) VALUES
+(1, 6, 'Základní');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `Type`
+--
+
+CREATE TABLE IF NOT EXISTS `Type` (
   `Id` int(11) NOT NULL AUTO_INCREMENT,
   `Name` varchar(255) NOT NULL,
   `DbType` varchar(255) NOT NULL,
+  `Parent` int(11) NOT NULL,
+  `ParameterTable` varchar(255) NOT NULL,
   PRIMARY KEY (`Id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
+
+--
+-- Vypisuji data pro tabulku `Type`
+--
+
+INSERT INTO `Type` (`Id`, `Name`, `DbType`, `Parent`, `ParameterTable`) VALUES
+(1, 'Číslo', 'INT', 0, ''),
+(2, 'Řetězec', 'VARCHAR(255)', 0, ''),
+(3, 'Text', 'TEXT', 0, ''),
+(4, 'Datum a čas', 'DATETIME', 0, ''),
+(5, 'Desetinné číslo', 'FLOAT', 0, ''),
+(6, 'Obrázek', 'BLOB', 0, ''),
+(7, 'Logická hodnota', 'INT', 13, ''),
+(8, 'IPv4', 'BINARY(4)', 0, ''),
+(9, 'MAC adresa', 'BINARY(6)', 0, ''),
+(10, 'IPv6', 'BINARY(16)', 0, ''),
+(11, 'Soubor', '', 0, ''),
+(12, 'GPS', '', 0, ''),
+(13, 'Výčet', 'INT', 0, 'TypeEnumeration'),
+(14, 'Internetový odkaz', 'VARCHAR(255)', 1, ''),
+(15, 'Heslo', 'VARCHAR(255)', 2, ''),
+(16, 'Ukazatel', 'INT', 0, 'TypePointer'),
+(17, 'Datum', 'DATE', 0, ''),
+(18, 'Čas', 'TIME', 0, ''),
+(19, 'Barva', 'INT', 0, '');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TypeEnumeration`
+--
+
+CREATE TABLE IF NOT EXISTS `TypeEnumeration` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  `Type` int(11) NOT NULL,
+  `Sequence` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Type` (`Type`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
+
+--
+-- Vypisuji data pro tabulku `TypeEnumeration`
+--
+
+INSERT INTO `TypeEnumeration` (`Id`, `Name`, `Type`, `Sequence`) VALUES
+(1, 'Nepravda', 7, 0),
+(2, 'Pravda', 7, 1);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TypeFile`
+--
+
+CREATE TABLE IF NOT EXISTS `TypeFile` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  `Size` int(11) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Vypisuji data pro tabulku `TypeFile`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TypeGPS`
+--
+
+CREATE TABLE IF NOT EXISTS `TypeGPS` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Latitude` double NOT NULL,
+  `Longitude` double NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Vypisuji data pro tabulku `TypeGPS`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `TypePointer`
+--
+
+CREATE TABLE IF NOT EXISTS `TypePointer` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Type` int(11) NOT NULL,
+  `Object` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Type` (`Type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Vypisuji data pro tabulku `TypePointer`
+--
+
 
 --
@@ -97 +289 @@
 --
 ALTER TABLE `Object`
-  ADD CONSTRAINT `Object_ibfk_1` FOREIGN KEY (`MenuGroup`) REFERENCES `MenuGroup` (`Id`);
+  ADD CONSTRAINT `Object_ibfk_1` FOREIGN KEY (`Group`) REFERENCES `ObjectGroup` (`Id`);
 
 --
@@ -103 +295 @@
 --
 ALTER TABLE `Property`
-  ADD CONSTRAINT `Property_ibfk_1` FOREIGN KEY (`Object`) REFERENCES `Object` (`Id`);
+  ADD CONSTRAINT `Property_ibfk_1` FOREIGN KEY (`Object`) REFERENCES `Object` (`Id`),
+  ADD CONSTRAINT `Property_ibfk_2` FOREIGN KEY (`Type`) REFERENCES `Type` (`Id`);
 
 --
@@ -110 +303 @@
 ALTER TABLE `PropertyGroup`
   ADD CONSTRAINT `PropertyGroup_ibfk_1` FOREIGN KEY (`Object`) REFERENCES `Object` (`Id`);
+
+--
+-- Omezení pro tabulku `TypeEnumeration`
+--
+ALTER TABLE `TypeEnumeration`
+  ADD CONSTRAINT `TypeEnumeration_ibfk_1` FOREIGN KEY (`Type`) REFERENCES `Type` (`Id`);
+
+--
+-- Omezení pro tabulku `TypePointer`
+--
+ALTER TABLE `TypePointer`
+  ADD CONSTRAINT `TypePointer_ibfk_1` FOREIGN KEY (`Type`) REFERENCES `Type` (`Id`);