Changeset 63 for branches/2/sql/full.sql

Timestamp:

Feb 5, 2009, 8:30:59 AM (16 years ago)

Author:

george

Message:

• Upraveno: Ukládání hesla nyní v kódované podobě pomocí hašovací funkce sha1.
• Opraveno: Některé normálně nezobrazované chyby v inicializaci proměnných.
• Upraveno: Informace o překladu byly z úvodní stránky přesunuty do stránky Informace dostupné z menu.
• Přidáno: Na hlavní stránku přidány jednoduché aktuality o systému.

File:

• branches/2/sql/full.sql (modified) (8 diffs)

branches/2/sql/full.sql

@@ -1 +1 @@
 -- phpMyAdmin SQL Dump
--- version 2.10.2
+-- version 3.1.2
 -- http://www.phpmyadmin.net
--- 
+--
 -- Počítač: localhost
--- Vygenerováno: Čtvrtek 08. května 2008, 19:59
--- Verze MySQL: 5.0.45
--- Verze PHP: 5.2.4
+-- Vygenerováno: Čtvrtek 05. února 2009, 06:45
+-- Verze MySQL: 5.0.67
+-- Verze PHP: 5.2.6
 
 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
--- 
+--
 -- Databáze: `wowpreklad`
--- 
+--
 
 -- --------------------------------------------------------
 
--- 
+--
 -- Struktura tabulky `Language`
--- 
+--
 
-CREATE TABLE `Language` (
+CREATE TABLE IF NOT EXISTS `Language` (
   `Id` int(11) NOT NULL auto_increment,
   `Name` varchar(64) collate utf8_czech_ci NOT NULL,
@@ -28 +28 @@
 -- --------------------------------------------------------
 
--- 
--- Struktura tabulky `Permission`
--- 
+--
+-- Struktura tabulky `PermissionOperation`
+--
 
-CREATE TABLE `Permission` (
+CREATE TABLE IF NOT EXISTS `PermissionOperation` (
   `Id` int(11) NOT NULL auto_increment,
-  `Title` varchar(64) collate utf8_czech_ci NOT NULL,
+  `Description` varchar(128) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
 
 -- --------------------------------------------------------
 
--- 
+--
 -- Struktura tabulky `Text`
--- 
+--
 
-CREATE TABLE `Text` (
+CREATE TABLE IF NOT EXISTS `Text` (
   `Id` int(11) NOT NULL auto_increment,
   `TranslationGroup` int(11) NOT NULL,
@@ -51 +51 @@
   PRIMARY KEY  (`Id`),
   KEY `TranslationGroup` (`TranslationGroup`,`GroupItem`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=113390 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=427992 ;
 
 -- --------------------------------------------------------
 
--- 
+--
 -- Struktura tabulky `TextGroup`
--- 
+--
 
-CREATE TABLE `TextGroup` (
+CREATE TABLE IF NOT EXISTS `TextGroup` (
   `Id` int(11) NOT NULL auto_increment,
   `Group` int(11) NOT NULL,
@@ -67 +67 @@
   `Time` datetime NOT NULL,
   `Revision` int(11) NOT NULL,
+  `Complete` tinyint(1) NOT NULL,
+  `OriginalText` int(11) NOT NULL,
+  `OldSystem` tinyint(1) NOT NULL,
   PRIMARY KEY  (`Id`),
   UNIQUE KEY `Group` (`Group`,`User`,`Index`,`Language`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=358575 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=256750 ;
 
 -- --------------------------------------------------------
 
--- 
+--
 -- Struktura tabulky `Translation`
--- 
+--
 
-CREATE TABLE `Translation` (
+CREATE TABLE IF NOT EXISTS `Translation` (
   `Id` int(11) NOT NULL auto_increment,
   `Group` int(11) NOT NULL,
@@ -87 +90 @@
 -- --------------------------------------------------------
 
--- 
+--
 -- Struktura tabulky `TranslationGroup`
--- 
+--
 
-CREATE TABLE `TranslationGroup` (
+CREATE TABLE IF NOT EXISTS `TranslationGroup` (
   `Id` int(11) NOT NULL auto_increment,
   `Name` varchar(64) collate utf8_czech_ci NOT NULL,
@@ -101 +104 @@
 -- --------------------------------------------------------
 
--- 
+--
 -- Struktura tabulky `User`
--- 
+--
 
-CREATE TABLE `User` (
+CREATE TABLE IF NOT EXISTS `User` (
   `Id` int(11) NOT NULL auto_increment,
   `Name` varchar(64) collate utf8_czech_ci NOT NULL,
   `Password` varchar(64) collate utf8_czech_ci NOT NULL,
   `Email` varchar(128) collate utf8_czech_ci NOT NULL,
-  `Permission` int(11) NOT NULL,
+  `Role` int(11) NOT NULL,
   `LastIpAddress` varchar(16) collate utf8_czech_ci NOT NULL,
   `LastLoginTime` datetime NOT NULL,
@@ -116 +119 @@
   `FullName` varchar(128) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=319 ;
 
 -- --------------------------------------------------------
 
--- 
+--
 -- Struktura tabulky `UserOnline`
--- 
+--
 
-CREATE TABLE `UserOnline` (
+CREATE TABLE IF NOT EXISTS `UserOnline` (
   `User` int(11) NOT NULL,
   `Time` datetime NOT NULL,
   `SessionId` varchar(255) collate utf8_czech_ci NOT NULL,
-  `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL,
+  `HostAddress` varchar(255) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`User`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
@@ -134 +137 @@
 -- --------------------------------------------------------
 
--- 
+--
+-- Struktura tabulky `UserRole`
+--
+
+CREATE TABLE IF NOT EXISTS `UserRole` (
+  `Id` int(11) NOT NULL auto_increment,
+  `Title` varchar(64) collate utf8_czech_ci NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `UserRolePermission`
+--
+
+CREATE TABLE IF NOT EXISTS `UserRolePermission` (
+  `Role` int(11) NOT NULL,
+  `Operation` int(11) NOT NULL,
+  `Read` tinyint(1) NOT NULL,
+  `Write` tinyint(1) NOT NULL,
+  PRIMARY KEY  (`Role`,`Operation`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+
+-- --------------------------------------------------------
+
+--
 -- Struktura tabulky `Vote`
--- 
+--
 
-CREATE TABLE `Vote` (
+CREATE TABLE IF NOT EXISTS `Vote` (
   `TranslationGroup` int(11) NOT NULL,
   `User` int(11) NOT NULL,