Changeset 55 for trunk/sql/full.sql


Ignore:
Timestamp:
Feb 2, 2009, 8:21:34 PM (16 years ago)
Author:
george
Message:
  • Upraveno: Ukládání odkazovaných stránek na bannery pouze v základní ořezané formě na kořenovou složku.
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/full.sql

    r43 r55  
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Čtvrtek 29. ledna 2009, 12:48
    7 -- Verze MySQL: 5.0.51
     6-- Vygenerováno: Pondělí 02. února 2009, 19:54
     7-- Verze MySQL: 5.0.67
    88-- Verze PHP: 5.2.6
    99
    … …  
    1111
    1212--
    13 -- Databáze: `quests`
     13-- Databáze: `wowpreklad_1`
    1414--
    1515
    … …  
    3333
    3434--
    35 -- Struktura tabulky `client_text`
    36 --
    37 
    38 CREATE TABLE IF NOT EXISTS `client_text` (
     35-- Struktura tabulky `client`
     36--
     37
     38CREATE TABLE IF NOT EXISTS `client` (
    3939  `ID` int(11) unsigned NOT NULL auto_increment,
    4040  `entry` int(11) unsigned NOT NULL,
    41   `text` text character set latin2 collate latin2_czech_cs,
     41  `Text` text character set latin2 collate latin2_czech_cs,
    4242  `id_text` text character set latin2 collate latin2_czech_cs,
    4343  `File` int(11) NOT NULL default '0',
    … …  
    4848  `Complete` int(11) NOT NULL,
    4949  `Take` int(11) NOT NULL,
     50  `admin_check` int(11) NOT NULL,
    5051  PRIMARY KEY  (`ID`),
    5152  KEY `entry` (`entry`),
    … …  
    5354  KEY `User` (`User`),
    5455  KEY `Take` (`Take`)
    55 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12079 ;
     56) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12081 ;
    5657
    5758-- --------------------------------------------------------
    … …  
    7071  KEY `IDclient` (`IDclient`)
    7172) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=85 ;
     73
     74-- --------------------------------------------------------
     75
     76--
     77-- Struktura tabulky `creature`
     78--
     79
     80CREATE TABLE IF NOT EXISTS `creature` (
     81  `ID` int(11) unsigned NOT NULL auto_increment,
     82  `entry` int(11) NOT NULL,
     83  `name` varchar(255) NOT NULL,
     84  `subname` varchar(255) NOT NULL,
     85  `Language` int(11) NOT NULL default '0',
     86  `Vote` float NOT NULL,
     87  `CountVote` int(11) NOT NULL,
     88  `User` int(11) NOT NULL,
     89  `Complete` int(11) NOT NULL,
     90  `Take` int(11) NOT NULL,
     91  `admin_check` int(11) NOT NULL default '0',
     92  PRIMARY KEY  (`ID`),
     93  KEY `entry` (`entry`),
     94  KEY `User` (`User`),
     95  KEY `Take` (`Take`)
     96) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26294 ;
     97
     98-- --------------------------------------------------------
     99
     100--
     101-- Struktura tabulky `creature_vote`
     102--
     103
     104CREATE TABLE IF NOT EXISTS `creature_vote` (
     105  `ID` int(11) NOT NULL auto_increment,
     106  `TextId` int(11) NOT NULL,
     107  `IDuser` int(11) NOT NULL,
     108  `vote` int(11) NOT NULL,
     109  PRIMARY KEY  (`ID`),
     110  KEY `IDquest` (`TextId`),
     111  KEY `IDuser` (`IDuser`)
     112) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    72113
    73114-- --------------------------------------------------------
    … …  
    89130
    90131--
     132-- Struktura tabulky `gameobject`
     133--
     134
     135CREATE TABLE IF NOT EXISTS `gameobject` (
     136  `ID` int(11) unsigned NOT NULL auto_increment,
     137  `entry` int(11) NOT NULL,
     138  `Name` varchar(255) NOT NULL,
     139  `castbarcaption` varchar(255) NOT NULL,
     140  `Language` int(11) NOT NULL default '0',
     141  `Vote` float NOT NULL,
     142  `CountVote` int(11) NOT NULL,
     143  `User` int(11) NOT NULL,
     144  `Complete` int(11) NOT NULL,
     145  `Take` int(11) NOT NULL,
     146  `admin_check` int(11) NOT NULL default '0',
     147  PRIMARY KEY  (`ID`),
     148  KEY `entry` (`entry`),
     149  KEY `User` (`User`),
     150  KEY `Take` (`Take`)
     151) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17823 ;
     152
     153-- --------------------------------------------------------
     154
     155--
     156-- Struktura tabulky `gameobject_vote`
     157--
     158
     159CREATE TABLE IF NOT EXISTS `gameobject_vote` (
     160  `ID` int(11) NOT NULL auto_increment,
     161  `TextId` int(11) NOT NULL,
     162  `IDuser` int(11) NOT NULL,
     163  `vote` int(11) NOT NULL,
     164  PRIMARY KEY  (`ID`),
     165  KEY `IDquest` (`TextId`),
     166  KEY `IDuser` (`IDuser`)
     167) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     168
     169-- --------------------------------------------------------
     170
     171--
     172-- Struktura tabulky `group`
     173--
     174
     175CREATE TABLE IF NOT EXISTS `group` (
     176  `Id` int(11) NOT NULL auto_increment,
     177  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     178  `TablePrefix` varchar(255) collate utf8_czech_ci NOT NULL,
     179  `MangosTable` varchar(255) collate utf8_czech_ci NOT NULL,
     180  `MangosTableIndex` varchar(255) collate utf8_czech_ci NOT NULL,
     181  PRIMARY KEY  (`Id`)
     182) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ;
     183
     184-- --------------------------------------------------------
     185
     186--
     187-- Struktura tabulky `group_item`
     188--
     189
     190CREATE TABLE IF NOT EXISTS `group_item` (
     191  `Id` int(11) NOT NULL auto_increment,
     192  `Group` int(11) NOT NULL,
     193  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
     194  `Column` varchar(255) collate utf8_czech_ci NOT NULL,
     195  `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL,
     196  PRIMARY KEY  (`Id`)
     197) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=38 ;
     198
     199-- --------------------------------------------------------
     200
     201--
     202-- Struktura tabulky `item`
     203--
     204
     205CREATE TABLE IF NOT EXISTS `item` (
     206  `ID` int(11) unsigned NOT NULL auto_increment,
     207  `entry` int(11) NOT NULL,
     208  `Name` varchar(255) NOT NULL,
     209  `Description` varchar(255) NOT NULL,
     210  `Language` int(11) NOT NULL default '0',
     211  `Vote` float NOT NULL,
     212  `CountVote` int(11) NOT NULL,
     213  `User` int(11) NOT NULL,
     214  `Complete` int(11) NOT NULL,
     215  `Take` int(11) NOT NULL,
     216  `admin_check` int(11) NOT NULL default '0',
     217  PRIMARY KEY  (`ID`),
     218  KEY `entry` (`entry`),
     219  KEY `User` (`User`),
     220  KEY `Take` (`Take`)
     221) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31370 ;
     222
     223-- --------------------------------------------------------
     224
     225--
     226-- Struktura tabulky `item_vote`
     227--
     228
     229CREATE TABLE IF NOT EXISTS `item_vote` (
     230  `ID` int(11) NOT NULL auto_increment,
     231  `TextId` int(11) NOT NULL,
     232  `IDuser` int(11) NOT NULL,
     233  `vote` int(11) NOT NULL,
     234  PRIMARY KEY  (`ID`),
     235  KEY `IDquest` (`TextId`),
     236  KEY `IDuser` (`IDuser`)
     237) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     238
     239-- --------------------------------------------------------
     240
     241--
    91242-- Struktura tabulky `log`
    92243--
    … …  
    101252  PRIMARY KEY  (`ID`),
    102253  KEY `user` (`user`)
    103 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12647 ;
    104 
    105 -- --------------------------------------------------------
    106 
    107 --
    108 -- Struktura tabulky `npc_text`
    109 --
    110 
    111 CREATE TABLE IF NOT EXISTS `npc_text` (
     254) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12739 ;
     255
     256-- --------------------------------------------------------
     257
     258--
     259-- Struktura tabulky `mangos_command`
     260--
     261
     262CREATE TABLE IF NOT EXISTS `mangos_command` (
    112263  `ID` int(11) unsigned NOT NULL auto_increment,
    113264  `entry` int(11) NOT NULL,
    114   `text0_0` text character set latin2 collate latin2_czech_cs,
    115   `text0_1` text character set latin2 collate latin2_czech_cs,
    116   `text1_0` text character set latin2 collate latin2_czech_cs,
    117   `text1_1` text character set latin2 collate latin2_czech_cs,
    118   `text2_0` text character set latin2 collate latin2_czech_cs,
    119   `text2_1` text character set latin2 collate latin2_czech_cs,
    120   `text3_0` text character set latin2 collate latin2_czech_cs,
    121   `text3_1` text character set latin2 collate latin2_czech_cs,
    122   `text4_0` text character set latin2 collate latin2_czech_cs,
    123   `text4_1` text character set latin2 collate latin2_czech_cs,
    124   `text5_0` text character set latin2 collate latin2_czech_cs,
    125   `text5_1` text character set latin2 collate latin2_czech_cs,
    126   `text6_0` text character set latin2 collate latin2_czech_cs,
    127   `text6_1` text character set latin2 collate latin2_czech_cs,
    128   `text7_0` text character set latin2 collate latin2_czech_cs,
    129   `text7_1` text character set latin2 collate latin2_czech_cs,
    130   `Language` int(11) NOT NULL default '0',
    131   `Vote` float NOT NULL,
    132   `CountVote` int(11) NOT NULL,
    133   `User` int(11) NOT NULL,
    134   `Complete` int(11) NOT NULL,
    135   `Take` int(11) NOT NULL,
    136   `admin_check` int(11) NOT NULL default '0',
    137   PRIMARY KEY  (`ID`),
    138   KEY `entry` (`entry`),
    139   KEY `User` (`User`),
    140   KEY `Take` (`Take`)
    141 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16777687 ;
     265  `help` varchar(255) NOT NULL,
     266  `Language` int(11) NOT NULL default '0',
     267  `Vote` float NOT NULL,
     268  `CountVote` int(11) NOT NULL,
     269  `User` int(11) NOT NULL,
     270  `Complete` int(11) NOT NULL,
     271  `Take` int(11) NOT NULL,
     272  `admin_check` int(11) NOT NULL default '0',
     273  PRIMARY KEY  (`ID`),
     274  KEY `entry` (`entry`),
     275  KEY `User` (`User`),
     276  KEY `Take` (`Take`)
     277) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     278
     279-- --------------------------------------------------------
     280
     281--
     282-- Struktura tabulky `mangos_command_vote`
     283--
     284
     285CREATE TABLE IF NOT EXISTS `mangos_command_vote` (
     286  `ID` int(11) NOT NULL auto_increment,
     287  `TextId` int(11) NOT NULL,
     288  `IDuser` int(11) NOT NULL,
     289  `vote` int(11) NOT NULL,
     290  PRIMARY KEY  (`ID`),
     291  KEY `IDquest` (`TextId`),
     292  KEY `IDuser` (`IDuser`)
     293) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     294
     295-- --------------------------------------------------------
     296
     297--
     298-- Struktura tabulky `mangos_string`
     299--
     300
     301CREATE TABLE IF NOT EXISTS `mangos_string` (
     302  `ID` int(11) unsigned NOT NULL auto_increment,
     303  `entry` int(11) NOT NULL,
     304  `content_default` varchar(255) NOT NULL,
     305  `Language` int(11) NOT NULL default '0',
     306  `Vote` float NOT NULL,
     307  `CountVote` int(11) NOT NULL,
     308  `User` int(11) NOT NULL,
     309  `Complete` int(11) NOT NULL,
     310  `Take` int(11) NOT NULL,
     311  `admin_check` int(11) NOT NULL default '0',
     312  PRIMARY KEY  (`ID`),
     313  KEY `entry` (`entry`),
     314  KEY `User` (`User`),
     315  KEY `Take` (`Take`)
     316) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=680 ;
     317
     318-- --------------------------------------------------------
     319
     320--
     321-- Struktura tabulky `mangos_string_vote`
     322--
     323
     324CREATE TABLE IF NOT EXISTS `mangos_string_vote` (
     325  `ID` int(11) NOT NULL auto_increment,
     326  `TextId` int(11) NOT NULL,
     327  `IDuser` int(11) NOT NULL,
     328  `vote` int(11) NOT NULL,
     329  PRIMARY KEY  (`ID`),
     330  KEY `IDquest` (`TextId`),
     331  KEY `IDuser` (`IDuser`)
     332) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     333
     334-- --------------------------------------------------------
     335
     336--
     337-- Struktura tabulky `npc`
     338--
     339
     340CREATE TABLE IF NOT EXISTS `npc` (
     341  `ID` int(11) unsigned NOT NULL auto_increment,
     342  `entry` int(11) NOT NULL,
     343  `Text0_0` text character set latin2 collate latin2_czech_cs,
     344  `Text0_1` text character set latin2 collate latin2_czech_cs,
     345  `Text1_0` text character set latin2 collate latin2_czech_cs,
     346  `Text1_1` text character set latin2 collate latin2_czech_cs,
     347  `Text2_0` text character set latin2 collate latin2_czech_cs,
     348  `Text2_1` text character set latin2 collate latin2_czech_cs,
     349  `Text3_0` text character set latin2 collate latin2_czech_cs,
     350  `Text3_1` text character set latin2 collate latin2_czech_cs,
     351  `Text4_0` text character set latin2 collate latin2_czech_cs,
     352  `Text4_1` text character set latin2 collate latin2_czech_cs,
     353  `Text5_0` text character set latin2 collate latin2_czech_cs,
     354  `Text5_1` text character set latin2 collate latin2_czech_cs,
     355  `Text6_0` text character set latin2 collate latin2_czech_cs,
     356  `Text6_1` text character set latin2 collate latin2_czech_cs,
     357  `Text7_0` text character set latin2 collate latin2_czech_cs,
     358  `Text7_1` text character set latin2 collate latin2_czech_cs,
     359  `Language` int(11) NOT NULL default '0',
     360  `Vote` float NOT NULL,
     361  `CountVote` int(11) NOT NULL,
     362  `User` int(11) NOT NULL,
     363  `Complete` int(11) NOT NULL,
     364  `Take` int(11) NOT NULL,
     365  `admin_check` int(11) NOT NULL default '0',
     366  PRIMARY KEY  (`ID`),
     367  KEY `entry` (`entry`),
     368  KEY `User` (`User`),
     369  KEY `Take` (`Take`)
     370) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779063 ;
    142371
    143372-- --------------------------------------------------------
    … …  
    160389
    161390--
    162 -- Struktura tabulky `page_text`
    163 --
    164 
    165 CREATE TABLE IF NOT EXISTS `page_text` (
     391-- Struktura tabulky `page`
     392--
     393
     394CREATE TABLE IF NOT EXISTS `page` (
    166395  `ID` int(11) NOT NULL auto_increment,
    167396  `entry` int(11) unsigned NOT NULL default '0',
    168   `text` text character set latin2 collate latin2_czech_cs,
     397  `Text` text character set latin2 collate latin2_czech_cs,
    169398  `Language` int(11) NOT NULL,
    170399  `Vote` float NOT NULL,
    … …  
    178407  KEY `User` (`User`),
    179408  KEY `Take` (`Take`)
    180 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1527 ;
     409) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1737 ;
    181410
    182411-- --------------------------------------------------------
    … …  
    219448  `CountVote` int(11) NOT NULL,
    220449  `User` int(11) NOT NULL,
    221   `complete` int(11) NOT NULL default '1',
     450  `Complete` int(11) NOT NULL default '1',
    222451  `Take` int(11) NOT NULL,
    223452  `admin_check` int(11) NOT NULL default '0',
    … …  
    225454  KEY `entry` (`entry`),
    226455  KEY `User` (`User`)
    227 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8780 ;
     456) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10696 ;
    228457
    229458-- --------------------------------------------------------
    … …  
    249478CREATE TABLE IF NOT EXISTS `quests_vote` (
    250479  `ID` int(11) NOT NULL auto_increment,
    251   `IDquest` int(11) NOT NULL,
    252   `IDuser` int(11) NOT NULL,
    253   `vote` int(11) NOT NULL,
    254   PRIMARY KEY  (`ID`),
    255   KEY `IDquest` (`IDquest`),
     480  `TextId` int(11) NOT NULL,
     481  `IDuser` int(11) NOT NULL,
     482  `vote` int(11) NOT NULL,
     483  PRIMARY KEY  (`ID`),
     484  KEY `IDquest` (`TextId`),
    256485  KEY `IDuser` (`IDuser`)
    257486) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3278 ;
    … …  
    270499  `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
    271500  PRIMARY KEY  (`ID`)
    272 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=448 ;
     501) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=449 ;
    273502
    274503-- --------------------------------------------------------
    … …  
    285514  `tag` int(11) NOT NULL,
    286515  PRIMARY KEY  (`ID`)
    287 ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=334 ;
     516) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=335 ;
    288517
    289518-- --------------------------------------------------------
Note: See TracChangeset for help on using the changeset viewer.