Changeset 118
- Timestamp:
- Feb 21, 2009, 4:06:54 PM (15 years ago)
- Location:
- trunk
- Files:
-
- 6 edited
-
import/index.php (modified) (2 diffs)
-
includes/global.php (modified) (1 diff)
-
includes/stream.php (modified) (3 diffs)
-
readme.txt (modified) (1 diff)
-
sql/structure.sql (modified) (19 diffs)
-
sql/text_table_init_structure.sql (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/import/index.php
r117 r118 4 4 include('../includes/dbc.php'); 5 5 6 $PatchVersion = '3.0.3'; 7 8 function ImportSQLMangos() 9 { 10 global $Database, $TranslationTree; 11 12 echo('Načítání textů z databáze MaNGOSu...'); 13 foreach($TranslationTree as $Group) 14 { 15 if(($Group['MangosTable'] != '') and ($Group['TablePrefix'] != '')) 16 { 17 echo('<br />'.$Group['Name'].'<br />'); 18 $Columns = '`'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`.`'.$Group['MangosTableIndex'].'`'; 19 foreach($Group['Items'] as $GroupItem) 20 $Columns .= ', `'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`.`'.$GroupItem['MangosColumn'].'` AS `'.$GroupItem['Column'].'`'; 21 $Query = 'SELECT '.$Columns.' FROM `'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`'; 22 //echo($Query.'<br />'); 23 $Count = 0; 24 $NewCount = 0; 25 $DbResult = $Database->SQLCommand($Query); 26 while($DbRow = mysql_fetch_assoc($DbResult)) 27 { 28 //echo('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$DbRow[$Group['MangosTableIndex']].' AND Language=0'."<br>"); 29 $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$DbRow[$Group['MangosTableIndex']].' AND Language=0'); 30 if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0)) 31 { 32 $DbRow2 = mysql_fetch_assoc($DbResult2); 33 //echo($DbRow2['ID']); 34 $ColumnsValues = ''; 35 foreach($Group['Items'] as $GroupItem) 36 { 37 $ColumnsValues .= ', `'.$GroupItem['Column'].'`="'.addslashes($DbRow[$GroupItem['MangosColumn']]).'"'; 38 } 39 $ColumnsValues = substr($ColumnsValues, 2); 40 echo('. '); //'UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']."<br>"); 41 //print_r($DbRow2); 42 $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']); 43 } else 44 { 45 $Columns = 'entry, language'; 46 $Values = $DbRow[$Group['MangosTableIndex']].', 0'; 47 foreach($Group['Items'] as $GroupItem) 48 { 49 $Columns .= ', `'.$GroupItem['Column'].'`'; 50 $Values .= ', "'.addslashes($DbRow[$GroupItem['MangosColumn']]).'"'; 51 } 52 //$Columns = substr($Columns, 2); 53 //$Values = substr($Values, 2); 54 $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'); 55 echo('# '); 56 //echo('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'."<br>"); 57 $NewCount++; 58 } 59 $Count++; 60 } 61 echo('<br />Celkem: '.$Count.' Nových: '.$NewCount.'<br />'); 62 } 63 } 64 echo('Dokončeno.</div>'); 65 } 66 67 function ImportDBC() 68 { 69 global $Database, $TranslationTree, $PatchVersion; 70 71 echo('Načítání textů z DBC souborů...'); 72 foreach($TranslationTree as $Group) 73 { 74 if(($Group['DBCFileName'] != '') and ($Group['TablePrefix'] != '')) 75 { 76 echo('<br />'.$Group['Name'].'<br />'); 77 $DBCFile = new DBCFile(); 78 $DBCFile->OpenFile('../source/'.$PatchVersion.'/dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']); 79 $ItemCount = $DBCFile->GetRecordCount(); 80 $NewCount = 0; 81 $Count = 0; 82 for($i = 0; $i < $ItemCount; $i++) 83 { 84 $ItemId = $DBCFile->GetUint($i, 0); 85 $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$ItemId.' AND Language=0'); 86 if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0)) 87 { 88 $DbRow2 = mysql_fetch_assoc($DbResult2); 89 //echo($DbRow2['ID']); 90 $ColumnsValues = ''; 91 foreach($Group['Items'] as $GroupItem) 92 { 93 $ColumnsValues .= ', `'.$GroupItem['Column'].'`="'.addslashes($DBCFile->GetString($i, $GroupItem['DBCColumnIndex'])).'"'; 94 } 95 $ColumnsValues = substr($ColumnsValues, 2); 96 echo('. '); //'UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']."<br>"); 97 //print_r($DbRow2); 98 $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']); 99 } else 100 { 101 $Columns = 'entry, language'; 102 $Values = $ItemId.', 0'; 103 foreach($Group['Items'] as $GroupItem) 104 { 105 $Columns .= ', `'.$GroupItem['Column'].'`'; 106 $Values .= ', "'.addslashes($DBCFile->GetString($i, $GroupItem['DBCColumnIndex'])).'"'; 107 } 108 //$Columns = substr($Columns, 2); 109 //$Values = substr($Values, 2); 110 $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'); 111 echo('# '); 112 //echo('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'."<br>"); 113 $NewCount++; 114 } 115 $Count++; 116 } 117 echo('<br />Celkem: '.$Count.' Nových: '.$NewCount.'<br />'); 118 } 119 } 120 echo('Dokončeno.</div>'); 121 } 122 123 function ImportLUA() 124 { 125 global $Database, $TranslationTree, $PatchVersion; 126 127 echo('Načítání textů z LUA souborů...'); 128 foreach($TranslationTree as $Group) 129 { 130 if(($Group['LuaFileName'] != '') and ($Group['TablePrefix'] != '')) 131 { 132 echo('<br />'.$Group['Name'].'<br />'); 133 $File = new FileStream(); 134 $File->OpenFile('../source/'.$PatchVersion.'/lua/'.$Group['LuaFileName'].'.lua'); 135 $NewCount = 0; 136 $Count = 0; 137 while(!$File->EOF()) 138 { 139 $Line = $File->ReadLine(); 140 if(strpos($Line, '=') !== false) 141 { 142 $LineParts = explode(';', $Line); 143 $LineParts2 = explode('=', $LineParts[0]); 144 $Value['ShortCut'] = addslashes(trim($LineParts2[0])); 145 $Value['Text'] = addslashes(substr(trim($LineParts2[1]), 1, -1)); 146 $Value['Comment'] = addslashes(trim($LineParts[1])); 147 148 $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE ShortCut="'.$Value['ShortCut'].'" AND (Language=0)'); 149 if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0)) 150 { 151 $ColumnsValues = ''; 152 foreach($Group['Items'] as $GroupItem) 153 { 154 $ColumnsValues .= ', `'.$GroupItem['Column'].'`="'.$Value[$GroupItem['Column']].'"'; 155 } 156 $ColumnsValues = substr($ColumnsValues, 2); 157 158 $DbRow2 = mysql_fetch_assoc($DbResult2); 159 echo('. '); //'UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']."<br>"); 160 $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']); 161 } else 162 { 163 $Entry = 1; 164 $DbResult = $Database->SQLCommand('SELECT MAX(`entry`) FROM `'.$Group['TablePrefix'].'`'); 165 if(mysql_num_rows($DbResult) > 0) 166 { 167 $DbRow = mysql_fetch_row($DbResult); 168 $Entry += $DbRow[0]; 169 } 170 171 $Columns = 'entry, language, ShortCut'; 172 $Values = $Entry.', 0, "'.$Value['ShortCut'].'"'; 173 foreach($Group['Items'] as $GroupItem) 174 { 175 $Columns .= ', `'.$GroupItem['Column'].'`'; 176 $Values .= ', "'.$Value[$GroupItem['Column']].'"'; 177 } 178 $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'); 179 echo('# '); 180 $NewCount++; 181 } 182 }; 183 $Count++; 184 } 185 echo('<br />Celkem: '.$Count.' Nových: '.$NewCount.'<br />'); 186 } 187 } 188 echo('Dokončeno.</div>'); 189 } 190 6 191 ShowPage(); 7 192 … … 12 197 } 13 198 14 echo('Načítání textů z databáze MaNGOSu: '); 15 echo('<div style="font-size: xx-small;">'); 16 17 foreach($TranslationTree as $Group) 18 { 19 if(($Group['MangosTable'] != '') and ($Group['TablePrefix'] != '')) 20 { 21 echo('<br />'.$Group['Name'].'<br />'); 22 $Columns = '`'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`.`'.$Group['MangosTableIndex'].'`'; 23 foreach($Group['Items'] as $GroupItem) 24 $Columns .= ', `'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`.`'.$GroupItem['MangosColumn'].'` AS `'.$GroupItem['Column'].'`'; 25 $Query = 'SELECT '.$Columns.' FROM `'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`'; 26 //echo($Query.'<br />'); 27 $Count = 0; 28 $NewCount = 0; 29 $DbResult = $Database->SQLCommand($Query); 30 while($DbRow = mysql_fetch_assoc($DbResult)) 31 { 32 //echo('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$DbRow[$Group['MangosTableIndex']].' AND Language=0'."<br>"); 33 $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$DbRow[$Group['MangosTableIndex']].' AND Language=0'); 34 if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0)) 35 { 36 $DbRow2 = mysql_fetch_assoc($DbResult2); 37 //echo($DbRow2['ID']); 38 $ColumnsValues = ''; 39 foreach($Group['Items'] as $GroupItem) 40 { 41 $ColumnsValues .= ', `'.$GroupItem['Column'].'`="'.addslashes($DbRow[$GroupItem['MangosColumn']]).'"'; 42 } 43 $ColumnsValues = substr($ColumnsValues, 2); 44 echo('. '); //'UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']."<br>"); 45 //print_r($DbRow2); 46 $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']); 47 } else 48 { 49 $Columns = 'entry, language'; 50 $Values = $DbRow[$Group['MangosTableIndex']].', 0'; 51 foreach($Group['Items'] as $GroupItem) 52 { 53 $Columns .= ', `'.$GroupItem['Column'].'`'; 54 $Values .= ', "'.addslashes($DbRow[$GroupItem['MangosColumn']]).'"'; 55 } 56 //$Columns = substr($Columns, 2); 57 //$Values = substr($Values, 2); 58 $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'); 59 echo('# '); 60 //echo('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'."<br>"); 61 $NewCount++; 62 } 63 $Count++; 64 } 65 echo('<br />Celkem: '.$Count.' Nových: '.$NewCount.'<br />'); 66 } else 67 if(($Group['DBCFileName'] != '') and ($Group['TablePrefix'] != '')) 68 { 69 echo('<br />'.$Group['Name'].'<br />'); 70 $DBCFile = new DBCFile(); 71 $DBCFile->OpenFile('dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']); 72 $ItemCount = $DBCFile->RecordCount(); 73 $NewCount = 0; 74 $Count = 0; 75 for($i = 0; $i < $ItemCount; $i++) 76 { 77 $ItemId = $DBCFile->GetUint($i, 0); 78 $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$ItemId.' AND Language=0'); 79 if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0)) 80 { 81 $DbRow2 = mysql_fetch_assoc($DbResult2); 82 //echo($DbRow2['ID']); 83 $ColumnsValues = ''; 84 foreach($Group['Items'] as $GroupItem) 85 { 86 $ColumnsValues .= ', `'.$GroupItem['Column'].'`="'.addslashes($DBCFile->GetString($i, $GroupItem['DBCColumnIndex'])).'"'; 87 } 88 $ColumnsValues = substr($ColumnsValues, 2); 89 echo('. '); //'UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']."<br>"); 90 //print_r($DbRow2); 91 $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']); 92 } else 93 { 94 $Columns = 'entry, language'; 95 $Values = $ItemId.', 0'; 96 foreach($Group['Items'] as $GroupItem) 97 { 98 $Columns .= ', `'.$GroupItem['Column'].'`'; 99 $Values .= ', "'.addslashes($DBCFile->GetString($i, $GroupItem['DBCColumnIndex'])).'"'; 100 } 101 //$Columns = substr($Columns, 2); 102 //$Values = substr($Values, 2); 103 $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'); 104 echo('# '); 105 //echo('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'."<br>"); 106 $NewCount++; 107 } 108 $Count++; 109 } 110 echo('<br />Celkem: '.$Count.' Nových: '.$NewCount.'<br />'); 111 } 112 } 113 echo('Dokončeno.</div>'); 114 115 WriteLog('Plnění databáze', 4); 199 if(!array_key_exists('source', $_GET)) 200 { 201 echo('<div>Načíst zdroj:</strong></div>'); 202 echo('<div><a href="?source=dbc">DBC soubory</a></div>'); 203 echo('<div><a href="?source=sql_mangos">SQL MaNGOS</a></div>'); 204 echo('<div><a href="?source=lua">LUA soubory</a></div>'); 205 } else 206 { 207 echo('<div style="font-size: xx-small;">'); 208 switch($_GET['source']) 209 { 210 case 'sql_mangos': 211 ImportSQLMangos(); 212 break; 213 case 'dbc': 214 ImportDBC(); 215 break; 216 case 'lua': 217 ImportLUA(); 218 break; 219 } 220 WriteLog('Plnění databáze', 4); 221 } 116 222 117 223 ShowFooter(); -
trunk/includes/global.php
r117 r118 86 86 'index.php?Logout' => array(LICENCE_USER, 'Odhlášení ze systému', 'Odhlásit'), 87 87 'log.php' => array(LICENCE_MODERATOR, 'Log dění (Pouze moderátor)', 'Záznamy'), 88 'import/' => array(LICENCE_ADMIN, 'Načtení překladů do database (pouze admin)', 'Import textů z MaNGOSu'),88 'import/' => array(LICENCE_ADMIN, 'Načtení zdrojových textů do databáze (pouze admin)', 'Import textů'), 89 89 //'client_files/generate_SQL.php' => array(LICENCE_ADMIN, 'Generování clientských souborů (pouze admin)', 'Generování C.S.'), 90 90 'https://wow.zdechov.net/mysql/' => array(LICENCE_ADMIN, 'phpMyAdmin(pouze admin)', 'Správa databáze'), -
trunk/includes/stream.php
r117 r118 67 67 { 68 68 return(fread($this->Handle, 1)); 69 } 70 71 public function ReadLine() 72 { 73 return(fgets($this->Handle)); 69 74 } 70 75 … … 99 104 fwrite($this->Handle, "\0", 1); 100 105 } 106 107 public function WriteLine() 108 { 109 fputs($this->Handle); 110 } 101 111 102 112 public function Seek($Position, $Type = SEEK_SET) … … 114 124 return(filesize($this->FileName)); 115 125 } 126 127 public function EOF() 128 { 129 return(feof($this->Handle)); 130 } 116 131 } 117 132 -
trunk/readme.txt
r107 r118 29 29 30 30 31 6) Import dat31 6) Import textů 32 32 33 - Tabulka mangos.command nemá číselné id a proto je nutné je pro import doplnit. 33 Zdrojové soubory pro import jsou umístěny ve složce source. Zde jsou pak umístěny podsložky pojmenované jako jednotlivé verze hry. V těchto podsložká jsou dále podsložky dbc, sql_mangos a lua, ze kterých je prováděn import dat. 34 35 36 7) Tabulka mangos.command nemá číselné id a proto je nutné je pro import doplnit. 34 37 35 38 To lze to provést pomící SQL povelů: -
trunk/sql/structure.sql
r111 r118 1 2 --3 -- Struktura tabulky `banner`4 --5 6 1 CREATE TABLE IF NOT EXISTS `banner` ( 7 2 `DateFirst` datetime NOT NULL, … … 36 31 KEY `Take` (`Take`), 37 32 KEY `Complete` (`Complete`) 38 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1239 5;33 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12394 ; 39 34 40 35 -- -------------------------------------------------------- … … 59 54 KEY `Complete` (`Complete`), 60 55 KEY `Language` (`Language`) 61 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=527 17 ;56 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=52707 ; 62 57 63 58 -- -------------------------------------------------------- … … 97 92 KEY `Complete` (`Complete`), 98 93 KEY `Language` (`Language`) 99 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3595 7;94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35956 ; 100 95 101 96 -- -------------------------------------------------------- … … 119 114 KEY `Language` (`Language`), 120 115 KEY `Complete` (`Complete`) 121 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=212 ; 116 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=189 ; 117 118 -- -------------------------------------------------------- 119 120 -- 121 -- Struktura tabulky `global_strings` 122 -- 123 124 CREATE TABLE IF NOT EXISTS `global_strings` ( 125 `ID` int(11) unsigned NOT NULL auto_increment, 126 `entry` int(11) NOT NULL, 127 `Language` int(11) NOT NULL default '0', 128 `Vote` float NOT NULL, 129 `CountVote` int(11) NOT NULL, 130 `User` int(11) NOT NULL, 131 `Complete` int(11) NOT NULL, 132 `Take` int(11) NOT NULL, 133 `ShortCut` text NOT NULL, 134 `Text` text NOT NULL, 135 `Comment` text NOT NULL, 136 PRIMARY KEY (`ID`), 137 KEY `entry` (`entry`), 138 KEY `User` (`User`), 139 KEY `Take` (`Take`), 140 KEY `Language` (`Language`), 141 KEY `Complete` (`Complete`) 142 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7700 ; 143 144 -- -------------------------------------------------------- 145 146 -- 147 -- Struktura tabulky `glue_strings` 148 -- 149 150 CREATE TABLE IF NOT EXISTS `glue_strings` ( 151 `ID` int(11) unsigned NOT NULL auto_increment, 152 `entry` int(11) NOT NULL, 153 `Language` int(11) NOT NULL default '0', 154 `Vote` float NOT NULL, 155 `CountVote` int(11) NOT NULL, 156 `User` int(11) NOT NULL, 157 `Complete` int(11) NOT NULL, 158 `Take` int(11) NOT NULL, 159 `ShortCut` text NOT NULL, 160 `Text` text NOT NULL, 161 `Comment` text NOT NULL, 162 PRIMARY KEY (`ID`), 163 KEY `entry` (`entry`), 164 KEY `User` (`User`), 165 KEY `Take` (`Take`), 166 KEY `Language` (`Language`), 167 KEY `Complete` (`Complete`) 168 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=713 ; 122 169 123 170 -- -------------------------------------------------------- … … 137 184 `DBCColumns` text collate utf8_czech_ci NOT NULL, 138 185 `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL, 186 `LuaFileName` varchar(255) collate utf8_czech_ci NOT NULL, 139 187 PRIMARY KEY (`Id`) 140 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 4;188 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=16 ; 141 189 142 190 -- -------------------------------------------------------- … … 153 201 `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL, 154 202 `AddonFileName` varchar(255) collate utf8_czech_ci NOT NULL, 155 `DBCColumnIndex` int(11) NOT NULL ,203 `DBCColumnIndex` int(11) NOT NULL default '0', 156 204 PRIMARY KEY (`Id`) 157 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 47;205 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=51 ; 158 206 159 207 -- -------------------------------------------------------- … … 178 226 KEY `Complete` (`Complete`), 179 227 KEY `Language` (`Language`) 180 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=629 21;228 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62909 ; 181 229 182 230 -- -------------------------------------------------------- … … 195 243 PRIMARY KEY (`ID`), 196 244 KEY `user` (`user`) 197 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 5390;245 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14592 ; 198 246 199 247 -- -------------------------------------------------------- … … 217 265 KEY `Complete` (`Complete`), 218 266 KEY `Language` (`Language`) 219 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=259;267 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 220 268 221 269 -- -------------------------------------------------------- … … 239 287 KEY `Complete` (`Complete`), 240 288 KEY `Language` (`Language`) 241 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 87;289 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1878 ; 242 290 243 291 -- -------------------------------------------------------- … … 253 301 `Text` text NOT NULL, 254 302 PRIMARY KEY (`Id`) 255 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 10;303 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; 256 304 257 305 -- -------------------------------------------------------- … … 290 338 KEY `Complete` (`Complete`), 291 339 KEY `Language` (`Language`) 292 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1677907 4;340 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779072 ; 293 341 294 342 -- -------------------------------------------------------- … … 342 390 KEY `complete` (`Complete`), 343 391 KEY `Language` (`Language`) 344 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=107 74;392 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10730 ; 345 393 346 394 -- -------------------------------------------------------- … … 365 413 KEY `Complete` (`Complete`), 366 414 KEY `Language` (`Language`) 367 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 1;415 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=410 ; 368 416 369 417 -- -------------------------------------------------------- … … 388 436 KEY `Complete` (`Complete`), 389 437 KEY `Language` (`Language`) 390 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 20;438 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1117 ; 391 439 392 440 -- -------------------------------------------------------- … … 403 451 `IP` text character set latin2 collate latin2_czech_cs NOT NULL, 404 452 PRIMARY KEY (`ID`) 405 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 54;453 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=447 ; 406 454 407 455 -- -------------------------------------------------------- … … 428 476 KEY `Language` (`Language`), 429 477 KEY `Complete` (`Complete`) 430 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 197;478 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42086 ; 431 479 432 480 -- -------------------------------------------------------- … … 446 494 `Language` int(11) NOT NULL default '1', 447 495 `ExportSetting` text collate utf8_czech_ci NOT NULL, 448 `XP` int(11) NOT NULL default '0',449 `NeedUpdate` int(11) NOT NULL default '0',496 `XP` int(11) NOT NULL, 497 `NeedUpdate` int(11) NOT NULL, 450 498 PRIMARY KEY (`ID`) 451 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=55 3;499 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=551 ; -
trunk/sql/text_table_init_structure.sql
r70 r118 8 8 `Complete` int(11) NOT NULL, 9 9 `Take` int(11) NOT NULL, 10 `admin_check` int(11) NOT NULL default '0',11 10 PRIMARY KEY (`ID`), 12 11 KEY `entry` (`entry`), … … 16 15 KEY `Complete` ( `Complete` ) 17 16 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 18
Note:
See TracChangeset
for help on using the changeset viewer.
