Changeset 18 for sql/system_structure.sql

Timestamp:

Oct 21, 2008, 4:15:52 PM (16 years ago)

Author:

george

Message:

• Upraveno: Prozatím jednoduché oprávnění pro čtení a zápis k jednotlivým seznamům.
• Přidáno: Typ GPS souřadnice.
• Opraveno: Převod přes hašovací funkci SHA1 u typu Password.
• Upraveno: Možnost vybrat variantu Žádný u odkazů.
• Opraveno: Součinost modulu User s časovou databázovou strukturou.

File:

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

sql/system_structure.sql

@@ -4 +4 @@
 --
 -- Počítač: localhost
--- Vygenerováno: Pondělí 13. října 2008, 08:00
+-- Vygenerováno: Úterý 21. října 2008, 16:14
 -- Verze MySQL: 5.0.51
 -- Verze PHP: 5.2.6
@@ -17 +17 @@
 
 --
+-- Struktura tabulky `Permission`
+--
+
+CREATE TABLE IF NOT EXISTS `Permission` (
+  `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 default NULL,
+  `DeletionTime` datetime default NULL,
+  `List` int(11) NOT NULL,
+  `Item` int(11) NOT NULL,
+  `Right` int(11) NOT NULL,
+  `PermissionGroup` int(11) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=43 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `PermissionGroup`
+--
+
+CREATE TABLE IF NOT EXISTS `PermissionGroup` (
+  `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 default NULL,
+  `DeletionTime` datetime default NULL,
+  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
+  `PermissionList` int(11) NOT NULL,
+  `UserList` int(11) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `SystemFile`
+--
+
+CREATE TABLE IF NOT EXISTS `SystemFile` (
+  `Id` int(11) NOT NULL auto_increment,
+  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
+  `Content` mediumblob NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `SystemGPS`
+--
+
+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 AUTO_INCREMENT=32 ;
+
+-- --------------------------------------------------------
+
+--
 -- Struktura tabulky `SystemList`
 --
@@ -30 +97 @@
   `TableName` varchar(255) collate utf8_czech_ci NOT NULL,
   `Title` varchar(255) collate utf8_czech_ci NOT NULL,
-  `System` tinyint(1) NOT NULL,
   `Items` varchar(255) collate utf8_czech_ci NOT NULL,
-  `VisibleInMenu` int(11) NOT NULL default '1',
-  PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
+  `Menu` int(11) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=75 ;
 
 -- --------------------------------------------------------
@@ -62 +128 @@
   `List` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=143 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=184 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `SystemLog`
+--
+
+CREATE TABLE IF NOT EXISTS `SystemLog` (
+  `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 default NULL,
+  `DeletionTime` datetime default NULL,
+  `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 AUTO_INCREMENT=238 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `SystemMenu`
+--
+
+CREATE TABLE IF NOT EXISTS `SystemMenu` (
+  `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 default NULL,
+  `DeletionTime` datetime default NULL,
+  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
+  `SystemListItems` int(11) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
 
 -- --------------------------------------------------------
@@ -84 +190 @@
   `System` tinyint(1) NOT NULL default '0',
   `DbDataType` varchar(255) collate utf8_czech_ci NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=57 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `User`
+--
+
+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 default NULL,
+  `ValidTimeTo` datetime default NULL,
+  `CreationTime` datetime default NULL,
+  `DeletionTime` datetime default NULL,
+  `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 AUTO_INCREMENT=36 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `UserOnline`
+--
+
+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,
+  `ItemId` int(11) NOT NULL,
+  `Author` int(11) NOT NULL,
+  `ValidTimeFrom` datetime default NULL,
+  `ValidTimeTo` datetime default NULL,
+  `CreationTime` datetime default NULL,
+  `DeletionTime` datetime default NULL,
   PRIMARY KEY  (`Id`),
-  UNIQUE KEY `Name` (`Name`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=39 ;
+  KEY `User` (`User`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=28 ;