Changeset 7 for sql/system_structure.sql

Timestamp:

Sep 16, 2008, 9:18:09 AM (16 years ago)

Author:

george

Message:

• Aktualizováno: Soubory demo_database.sql a system_structure.sql.

File:

• sql/system_structure.sql (modified) (3 diffs)

sql/system_structure.sql

@@ -4 +4 @@
 --
 -- Počítač: localhost
--- Vygenerováno: Pondělí 15. září 2008, 21:30
+-- Vygenerováno: Úterý 16. září 2008, 09:15
 -- Verze MySQL: 5.0.51
 -- Verze PHP: 5.2.6
@@ -28 +28 @@
   `VisibleInMenu` int(11) NOT NULL default '1',
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=15 ;
 
 -- --------------------------------------------------------
@@ -50 +50 @@
   `List` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=81 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=110 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `SystemType`
+--
+
+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` varchar(255) collate utf8_czech_ci 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 ;