Changeset 57 for trunk/sql

Timestamp:

Feb 3, 2009, 7:54:37 AM (15 years ago)

Author:

george

Message:

• Upraveno: Stránka statistika rozdělena na stránky Stav dokončení a Seznam uživatelů.
• Přidáno: Stránkování seznamu uživatelů.
• Opraveno: Přidány indexy do tabulek překladů pro sloupce Complete a Language. Díky tomu se výrazně zrychlilo zobrazení seznamu uživatelů.

Location:

trunk/sql

Files:

• full.sql (modified) (14 diffs)
• text_table_init_structure.sql (modified) (1 diff)
• updates/57.sql (added)

trunk/sql/full.sql

@@ -1 @@
--- phpMyAdmin SQL Dump
--- version 3.1.2
--- http://www.phpmyadmin.net
---
--- Počítač: localhost
--- Vygenerováno: Pondělí 02. února 2009, 19:54
--- Verze MySQL: 5.0.67
--- Verze PHP: 5.2.6
-
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-
---
--- Databáze: `wowpreklad_1`
---
-
 -- --------------------------------------------------------
 
@@ -53 +38 @@
   KEY `Language` (`Language`),
   KEY `User` (`User`),
-  KEY `Take` (`Take`)
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12081 ;
 
@@ -93 +79 @@
   KEY `entry` (`entry`),
   KEY `User` (`User`),
-  KEY `Take` (`Take`)
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26294 ;
 
@@ -148 +136 @@
   KEY `entry` (`entry`),
   KEY `User` (`User`),
-  KEY `Take` (`Take`)
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17823 ;
 
@@ -177 +167 @@
   `Name` varchar(255) collate utf8_czech_ci NOT NULL,
   `TablePrefix` varchar(255) collate utf8_czech_ci NOT NULL,
+  `MangosDatabase` varchar(255) collate utf8_czech_ci NOT NULL,
   `MangosTable` varchar(255) collate utf8_czech_ci NOT NULL,
   `MangosTableIndex` varchar(255) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;
 
 -- --------------------------------------------------------
@@ -195 +186 @@
   `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=38 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=42 ;
 
 -- --------------------------------------------------------
@@ -218 +209 @@
   KEY `entry` (`entry`),
   KEY `User` (`User`),
-  KEY `Take` (`Take`)
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31370 ;
 
@@ -252 +245 @@
   PRIMARY KEY  (`ID`),
   KEY `user` (`user`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12739 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12741 ;
 
 -- --------------------------------------------------------
@@ -274 +267 @@
   KEY `entry` (`entry`),
   KEY `User` (`User`),
-  KEY `Take` (`Take`)
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
@@ -313 +308 @@
   KEY `entry` (`entry`),
   KEY `User` (`User`),
-  KEY `Take` (`Take`)
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=680 ;
 
@@ -367 +364 @@
   KEY `entry` (`entry`),
   KEY `User` (`User`),
-  KEY `Take` (`Take`)
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779063 ;
 
@@ -406 +405 @@
   KEY `entry` (`entry`),
   KEY `User` (`User`),
-  KEY `Take` (`Take`)
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1737 ;
 
@@ -453 +454 @@
   PRIMARY KEY  (`ID`),
   KEY `entry` (`entry`),
-  KEY `User` (`User`)
+  KEY `User` (`User`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10696 ;
 
@@ -485 +488 @@
   KEY `IDuser` (`IDuser`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3278 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `sd2_eventai_texts`
+--
+
+CREATE TABLE IF NOT EXISTS `sd2_eventai_texts` (
+  `ID` int(11) unsigned NOT NULL auto_increment,
+  `entry` int(11) NOT NULL,
+  `content_default` text NOT NULL,
+  `comment` text NOT NULL,
+  `Language` int(11) NOT NULL default '0',
+  `Vote` float NOT NULL,
+  `CountVote` int(11) NOT NULL,
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `admin_check` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`ID`),
+  KEY `entry` (`entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=380 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `sd2_eventai_texts_vote`
+--
+
+CREATE TABLE IF NOT EXISTS `sd2_eventai_texts_vote` (
+  `ID` int(11) NOT NULL auto_increment,
+  `TextId` int(11) NOT NULL,
+  `IDuser` int(11) NOT NULL,
+  `vote` int(11) NOT NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `IDquest` (`TextId`),
+  KEY `IDuser` (`IDuser`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `sd2_script_texts`
+--
+
+CREATE TABLE IF NOT EXISTS `sd2_script_texts` (
+  `ID` int(11) unsigned NOT NULL auto_increment,
+  `entry` int(11) NOT NULL,
+  `content_default` text NOT NULL,
+  `comment` text NOT NULL,
+  `Language` int(11) NOT NULL default '0',
+  `Vote` float NOT NULL,
+  `CountVote` int(11) NOT NULL,
+  `User` int(11) NOT NULL,
+  `Complete` int(11) NOT NULL,
+  `Take` int(11) NOT NULL,
+  `admin_check` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`ID`),
+  KEY `entry` (`entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Complete` (`Complete`),
+  KEY `Language` (`Language`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1088 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `sd2_script_texts_vote`
+--
+
+CREATE TABLE IF NOT EXISTS `sd2_script_texts_vote` (
+  `ID` int(11) NOT NULL auto_increment,
+  `TextId` int(11) NOT NULL,
+  `IDuser` int(11) NOT NULL,
+  `vote` int(11) NOT NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `IDquest` (`TextId`),
+  KEY `IDuser` (`IDuser`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------

trunk/sql/text_table_init_structure.sql

@@ -12 +12 @@
   KEY `entry` (`entry`),
   KEY `User` (`User`),
-  KEY `Take` (`Take`)
+  KEY `Take` (`Take`),
+  KEY `Language` ( `Language` ),
+  KEY `Complete` ( `Complete` ),
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;