Changeset 71 for trunk/sql/structure.sql


Ignore:
Timestamp:
Feb 6, 2009, 4:55:48 PM (16 years ago)
Author:
george
Message:
  • Odstraněno: Funkce kontrola překladů a vrácení k překladu prováděná adminem a moderátory.
  • Odstraněno: Funkce vytváření svých výběrů překladů. Uživatel sestavuje svůj export pomocí výběrů dobře překládajících uživatelů namísto jednotlivých překladů.
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/structure.sql

    r70 r71  
    3939  KEY `Take` (`Take`),
    4040  KEY `Complete` (`Complete`)
    41 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12081 ;
    42 
    43 -- --------------------------------------------------------
    44 
    45 --
    46 -- Struktura tabulky `client_vote`
    47 --
    48 
    49 CREATE TABLE IF NOT EXISTS `client_vote` (
    50   `ID` int(11) NOT NULL auto_increment,
    51   `IDclient` int(11) NOT NULL,
    52   `IDuser` int(11) NOT NULL,
    53   `vote` int(11) NOT NULL,
    54   PRIMARY KEY  (`ID`),
    55   KEY `IDuser` (`IDuser`),
    56   KEY `IDclient` (`IDclient`)
    57 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=85 ;
     41) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12080 ;
    5842
    5943-- --------------------------------------------------------
    … …  
    8266  KEY `Language` (`Language`)
    8367) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26294 ;
    84 
    85 -- --------------------------------------------------------
    86 
    87 --
    88 -- Struktura tabulky `creature_vote`
    89 --
    90 
    91 CREATE TABLE IF NOT EXISTS `creature_vote` (
    92   `ID` int(11) NOT NULL auto_increment,
    93   `TextId` int(11) NOT NULL,
    94   `IDuser` int(11) NOT NULL,
    95   `vote` int(11) NOT NULL,
    96   PRIMARY KEY  (`ID`),
    97   KEY `IDquest` (`TextId`),
    98   KEY `IDuser` (`IDuser`)
    99 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    10068
    10169-- --------------------------------------------------------
    … …  
    143111
    144112--
    145 -- Struktura tabulky `gameobject_vote`
    146 --
    147 
    148 CREATE TABLE IF NOT EXISTS `gameobject_vote` (
    149   `ID` int(11) NOT NULL auto_increment,
    150   `TextId` int(11) NOT NULL,
    151   `IDuser` int(11) NOT NULL,
    152   `vote` int(11) NOT NULL,
    153   PRIMARY KEY  (`ID`),
    154   KEY `IDquest` (`TextId`),
    155   KEY `IDuser` (`IDuser`)
    156 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     113-- Struktura tabulky `gametips`
     114--
     115
     116CREATE TABLE IF NOT EXISTS `gametips` (
     117  `ID` int(11) unsigned NOT NULL auto_increment,
     118  `entry` int(11) NOT NULL,
     119  `Text` text NOT NULL,
     120  `Language` int(11) NOT NULL default '0',
     121  `Vote` float NOT NULL,
     122  `CountVote` int(11) NOT NULL,
     123  `User` int(11) NOT NULL,
     124  `Complete` int(11) NOT NULL,
     125  `Take` int(11) NOT NULL,
     126  `admin_check` int(11) NOT NULL default '0',
     127  PRIMARY KEY  (`ID`),
     128  KEY `entry` (`entry`),
     129  KEY `User` (`User`),
     130  KEY `Take` (`Take`),
     131  KEY `Language` (`Language`),
     132  KEY `Complete` (`Complete`)
     133) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=132 ;
    157134
    158135-- --------------------------------------------------------
    … …  
    169146  `MangosTable` varchar(255) collate utf8_czech_ci NOT NULL,
    170147  `MangosTableIndex` varchar(255) collate utf8_czech_ci NOT NULL,
     148  `DBCFileName` varchar(255) collate utf8_czech_ci NOT NULL,
     149  `DBCColumns` text collate utf8_czech_ci NOT NULL,
    171150  PRIMARY KEY  (`Id`)
    172 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;
     151) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ;
    173152
    174153-- --------------------------------------------------------
    … …  
    185164  `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL,
    186165  `AddonFileName` varchar(255) collate utf8_czech_ci NOT NULL,
     166  `DBCColumnIndex` int(11) NOT NULL,
    187167  PRIMARY KEY  (`Id`)
    188 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=42 ;
     168) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=47 ;
    189169
    190170-- --------------------------------------------------------
    … …  
    213193  KEY `Language` (`Language`)
    214194) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31370 ;
    215 
    216 -- --------------------------------------------------------
    217 
    218 --
    219 -- Struktura tabulky `item_vote`
    220 --
    221 
    222 CREATE TABLE IF NOT EXISTS `item_vote` (
    223   `ID` int(11) NOT NULL auto_increment,
    224   `TextId` int(11) NOT NULL,
    225   `IDuser` int(11) NOT NULL,
    226   `vote` int(11) NOT NULL,
    227   PRIMARY KEY  (`ID`),
    228   KEY `IDquest` (`TextId`),
    229   KEY `IDuser` (`IDuser`)
    230 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    231195
    232196-- --------------------------------------------------------
    … …  
    245209  PRIMARY KEY  (`ID`),
    246210  KEY `user` (`user`)
    247 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12875 ;
     211) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12925 ;
    248212
    249213-- --------------------------------------------------------
    … …  
    275239
    276240--
    277 -- Struktura tabulky `mangos_command_vote`
    278 --
    279 
    280 CREATE TABLE IF NOT EXISTS `mangos_command_vote` (
    281   `ID` int(11) NOT NULL auto_increment,
    282   `TextId` int(11) NOT NULL,
    283   `IDuser` int(11) NOT NULL,
    284   `vote` int(11) NOT NULL,
    285   PRIMARY KEY  (`ID`),
    286   KEY `IDquest` (`TextId`),
    287   KEY `IDuser` (`IDuser`)
    288 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    289 
    290 -- --------------------------------------------------------
    291 
    292 --
    293241-- Struktura tabulky `mangos_string`
    294242--
    … …  
    316264
    317265--
    318 -- Struktura tabulky `mangos_string_vote`
    319 --
    320 
    321 CREATE TABLE IF NOT EXISTS `mangos_string_vote` (
    322   `ID` int(11) NOT NULL auto_increment,
    323   `TextId` int(11) NOT NULL,
    324   `IDuser` int(11) NOT NULL,
    325   `vote` int(11) NOT NULL,
    326   PRIMARY KEY  (`ID`),
    327   KEY `IDquest` (`TextId`),
    328   KEY `IDuser` (`IDuser`)
    329 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     266-- Struktura tabulky `news`
     267--
     268
     269CREATE TABLE IF NOT EXISTS `news` (
     270  `Id` int(11) NOT NULL auto_increment,
     271  `Time` datetime NOT NULL,
     272  `User` int(11) NOT NULL,
     273  `Text` text NOT NULL,
     274  PRIMARY KEY  (`Id`)
     275) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
    330276
    331277-- --------------------------------------------------------
    … …  
    372318
    373319--
    374 -- Struktura tabulky `npc_vote`
    375 --
    376 
    377 CREATE TABLE IF NOT EXISTS `npc_vote` (
    378   `ID` int(11) NOT NULL auto_increment,
    379   `IDnpc` int(11) NOT NULL,
    380   `IDuser` int(11) NOT NULL,
    381   `vote` int(11) NOT NULL,
    382   PRIMARY KEY  (`ID`),
    383   KEY `IDuser` (`IDuser`),
    384   KEY `IDquest` (`IDnpc`)
    385 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=744 ;
    386 
    387 -- --------------------------------------------------------
    388 
    389 --
    390320-- Struktura tabulky `page`
    391321--
    … …  
    409339  KEY `Language` (`Language`)
    410340) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1737 ;
    411 
    412 -- --------------------------------------------------------
    413 
    414 --
    415 -- Struktura tabulky `page_vote`
    416 --
    417 
    418 CREATE TABLE IF NOT EXISTS `page_vote` (
    419   `ID` int(11) NOT NULL auto_increment,
    420   `IDpage` int(11) NOT NULL,
    421   `IDuser` int(11) NOT NULL,
    422   `vote` int(11) NOT NULL,
    423   PRIMARY KEY  (`ID`),
    424   KEY `IDuser` (`IDpage`),
    425   KEY `IDquest` (`IDpage`)
    426 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=417 ;
    427341
    428342-- --------------------------------------------------------
    … …  
    462376
    463377--
    464 -- Struktura tabulky `quests_status`
    465 --
    466 
    467 CREATE TABLE IF NOT EXISTS `quests_status` (
    468   `ID` int(11) NOT NULL auto_increment,
    469   `QuestEntry` int(11) NOT NULL,
    470   `CountQuest` int(11) NOT NULL,
    471   `State` int(11) NOT NULL,
    472   PRIMARY KEY  (`ID`)
    473 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    474 
    475 -- --------------------------------------------------------
    476 
    477 --
    478 -- Struktura tabulky `quests_vote`
    479 --
    480 
    481 CREATE TABLE IF NOT EXISTS `quests_vote` (
    482   `ID` int(11) NOT NULL auto_increment,
    483   `TextId` int(11) NOT NULL,
    484   `IDuser` int(11) NOT NULL,
    485   `vote` int(11) NOT NULL,
    486   PRIMARY KEY  (`ID`),
    487   KEY `IDquest` (`TextId`),
    488   KEY `IDuser` (`IDuser`)
    489 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3278 ;
    490 
    491 -- --------------------------------------------------------
    492 
    493 --
    494378-- Struktura tabulky `sd2_eventai_texts`
    495379--
    … …  
    518402
    519403--
    520 -- Struktura tabulky `sd2_eventai_texts_vote`
    521 --
    522 
    523 CREATE TABLE IF NOT EXISTS `sd2_eventai_texts_vote` (
    524   `ID` int(11) NOT NULL auto_increment,
    525   `TextId` int(11) NOT NULL,
    526   `IDuser` int(11) NOT NULL,
    527   `vote` int(11) NOT NULL,
    528   PRIMARY KEY  (`ID`),
    529   KEY `IDquest` (`TextId`),
    530   KEY `IDuser` (`IDuser`)
    531 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    532 
    533 -- --------------------------------------------------------
    534 
    535 --
    536404-- Struktura tabulky `sd2_script_texts`
    537405--
    … …  
    556424  KEY `Language` (`Language`)
    557425) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1088 ;
    558 
    559 -- --------------------------------------------------------
    560 
    561 --
    562 -- Struktura tabulky `sd2_script_texts_vote`
    563 --
    564 
    565 CREATE TABLE IF NOT EXISTS `sd2_script_texts_vote` (
    566   `ID` int(11) NOT NULL auto_increment,
    567   `TextId` int(11) NOT NULL,
    568   `IDuser` int(11) NOT NULL,
    569   `vote` int(11) NOT NULL,
    570   PRIMARY KEY  (`ID`),
    571   KEY `IDquest` (`TextId`),
    572   KEY `IDuser` (`IDuser`)
    573 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    574426
    575427-- --------------------------------------------------------
    … …  
    586438  `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
    587439  PRIMARY KEY  (`ID`)
    588 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=449 ;
     440) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=451 ;
     441
     442-- --------------------------------------------------------
     443
     444--
     445-- Struktura tabulky `spell`
     446--
     447
     448CREATE TABLE IF NOT EXISTS `spell` (
     449  `ID` int(11) unsigned NOT NULL auto_increment,
     450  `entry` int(11) NOT NULL,
     451  `Name` text NOT NULL,
     452  `Rank` text NOT NULL,
     453  `ToolTip` text NOT NULL,
     454  `Description` text NOT NULL,
     455  `Language` int(11) NOT NULL default '0',
     456  `Vote` float NOT NULL,
     457  `CountVote` int(11) NOT NULL,
     458  `User` int(11) NOT NULL,
     459  `Complete` int(11) NOT NULL,
     460  `Take` int(11) NOT NULL,
     461  `admin_check` int(11) NOT NULL default '0',
     462  PRIMARY KEY  (`ID`),
     463  KEY `entry` (`entry`),
     464  KEY `User` (`User`),
     465  KEY `Take` (`Take`),
     466  KEY `Language` (`Language`),
     467  KEY `Complete` (`Complete`)
     468) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42088 ;
    589469
    590470-- --------------------------------------------------------
    … …  
    618498  `Email` text character set latin2 collate latin2_czech_cs NOT NULL,
    619499  `Language` int(11) NOT NULL default '1',
    620   `ExportSetting` text NOT NULL,
     500  `ExportSetting` text character set utf8 NOT NULL,
    621501  PRIMARY KEY  (`ID`)
    622 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=549 ;
     502) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=550 ;
Note: See TracChangeset for help on using the changeset viewer.