Changeset 712 for trunk/sql


Ignore:
Timestamp:
Jul 30, 2013, 11:34:19 PM (11 years ago)
Author:
chronos
Message:
  • Upraveno: Aktualizace inicializačního skriptu pro sql databázi na revizi 710.
  • Upraveno: Aktualizována třída Database na novější využívající třídu PDO a generující výjímky při chybě, které je pak nutno očetřit.
Location:
trunk
Files:
1 added
3 edited

Legend:

Unmodified
Added
Removed

  • trunk

    • Property svn:ignore

      •  

        old new  
        55minimanager
        66mmfpm
         7.settings
         8.buildpath
         9.project

  • trunk/sql/structure.sql

    r555 r712  
    1 --
    2 -- Struktura tabulky `achievement`
    3 --
    4 
    5 CREATE TABLE IF NOT EXISTS `achievement` (
    6   `id` bigint(20) NOT NULL COMMENT 'Entry',
    7   `team` bigint(20) NOT NULL COMMENT '-1=all, 0=horde, 1=alliance',
    8   `mapid` bigint(20) NOT NULL COMMENT '-1=none - Only set if achievement is related to a zone',
    9   `field_3` bigint(20) NOT NULL,
    10   `name01` text NOT NULL,
    11   `name02` text NOT NULL,
    12   `name03` text NOT NULL,
    13   `name04` text NOT NULL,
    14   `name05` text NOT NULL,
    15   `name06` text NOT NULL,
    16   `name07` text NOT NULL,
    17   `name08` text NOT NULL,
    18   `name09` text NOT NULL,
    19   `name10` text NOT NULL,
    20   `name11` text NOT NULL,
    21   `name12` text NOT NULL,
    22   `name13` text NOT NULL,
    23   `name14` text NOT NULL,
    24   `name15` text NOT NULL,
    25   `name16` text NOT NULL,
    26   `field_20` bigint(20) NOT NULL,
    27   `description01` text NOT NULL COMMENT 'description - each for one locale',
    28   `description02` text NOT NULL,
    29   `description03` text NOT NULL,
    30   `description04` text NOT NULL,
    31   `description05` text NOT NULL,
    32   `description06` text NOT NULL,
    33   `description07` text NOT NULL,
    34   `description08` text NOT NULL,
    35   `description09` text NOT NULL,
    36   `description10` text NOT NULL,
    37   `description11` text NOT NULL,
    38   `description12` text NOT NULL,
    39   `description13` text NOT NULL,
    40   `description14` text NOT NULL,
    41   `description15` text NOT NULL,
    42   `description16` text NOT NULL,
    43   `field_37` bigint(20) NOT NULL,
    44   `categoryid` bigint(20) NOT NULL COMMENT 'id of category',
    45   `rewpoints` bigint(20) NOT NULL COMMENT 'rewarded points',
    46   `order` bigint(20) NOT NULL COMMENT 'order in category',
    47   `flags` bigint(20) NOT NULL COMMENT 'flags',
    48   `field_42` bigint(20) NOT NULL,
    49   `rewarddesc01` text NOT NULL COMMENT 'reward description - each for one locale',
    50   `rewarddesc02` text NOT NULL,
    51   `rewarddesc03` text NOT NULL,
    52   `rewarddesc04` text NOT NULL,
    53   `rewarddesc05` text NOT NULL,
    54   `rewarddesc06` text NOT NULL,
    55   `rewarddesc07` text NOT NULL,
    56   `rewarddesc08` text NOT NULL,
    57   `rewarddesc09` text NOT NULL,
    58   `rewarddesc10` text NOT NULL,
    59   `rewarddesc11` text NOT NULL,
    60   `rewarddesc12` text NOT NULL,
    61   `rewarddesc13` text NOT NULL,
    62   `rewarddesc14` text NOT NULL,
    63   `rewarddesc15` text NOT NULL,
    64   `rewarddesc16` text NOT NULL,
    65   `field_59` bigint(20) NOT NULL,
    66   `field_60` bigint(20) NOT NULL,
    67   `field_61` bigint(20) NOT NULL,
    68   PRIMARY KEY  (`id`)
    69 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    70 
    711-- --------------------------------------------------------
    72 
    73 --
    74 -- Struktura tabulky `articles`
    75 --
    76 
    77 CREATE TABLE IF NOT EXISTS `articles` (
    78   `id` int(11) NOT NULL auto_increment,
    79   `title` text collate utf8_czech_ci NOT NULL,
    80   `autor` text collate utf8_czech_ci NOT NULL,
    81   `category` int(11) NOT NULL default '0',
    82   `text` text collate utf8_czech_ci NOT NULL,
    83   `date` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
    84   PRIMARY KEY  (`id`)
    85 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=117 ;
    86 
     2-- Hostitel:                     127.0.0.1
     3-- Verze serveru:                5.5.32-0ubuntu0.13.04.1 - (Ubuntu)
     4-- OS serveru:                   debian-linux-gnu
     5-- HeidiSQL Verze:               8.0.0.4396
    876-- --------------------------------------------------------
    887
    89 --
    90 -- Struktura tabulky `characters`
    91 --
    92 
     8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
     9/*!40101 SET NAMES utf8 */;
     10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
     11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
     12
     13-- Exportování struktury pro tabulka wow_web.Article
     14CREATE TABLE IF NOT EXISTS `Article` (
     15  `Id` int(11) NOT NULL AUTO_INCREMENT,
     16  `Title` text COLLATE utf8_czech_ci NOT NULL,
     17  `Author` text COLLATE utf8_czech_ci NOT NULL,
     18  `Category` int(11) NOT NULL DEFAULT '0',
     19  `Content` text COLLATE utf8_czech_ci NOT NULL,
     20  `Time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
     21  PRIMARY KEY (`Id`),
     22  KEY `Category` (`Category`),
     23  KEY `Time` (`Time`),
     24  CONSTRAINT `Article_ibfk_1` FOREIGN KEY (`Category`) REFERENCES `ArticleCategory` (`Id`)
     25) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
     26
     27-- Exportování dat pro tabulku wow_web.Article: ~0 rows (přibližně)
     28/*!40000 ALTER TABLE `Article` DISABLE KEYS */;
     29/*!40000 ALTER TABLE `Article` ENABLE KEYS */;
     30
     31
     32-- Exportování struktury pro tabulka wow_web.ArticleCategory
     33CREATE TABLE IF NOT EXISTS `ArticleCategory` (
     34  `Id` int(11) NOT NULL AUTO_INCREMENT,
     35  `Name` varchar(255) NOT NULL,
     36  PRIMARY KEY (`Id`)
     37) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
     38
     39-- Exportování dat pro tabulku wow_web.ArticleCategory: ~4 rows (přibližně)
     40/*!40000 ALTER TABLE `ArticleCategory` DISABLE KEYS */;
     41INSERT INTO `ArticleCategory` (`Id`, `Name`) VALUES
     42        (1, 'Server novinky'),
     43        (2, 'GM novinky'),
     44        (3, 'In-game novinky'),
     45        (4, 'Články');
     46/*!40000 ALTER TABLE `ArticleCategory` ENABLE KEYS */;
     47
     48
     49-- Exportování struktury pro tabulka wow_web.characters
    9350CREATE TABLE IF NOT EXISTS `characters` (
    94   `guid` int(11) NOT NULL default '0',
    95   `warm` int(11) NOT NULL default '0',
    96   `weblevel` int(11) NOT NULL default '0'
    97 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    98 
    99 -- --------------------------------------------------------
    100 
    101 --
    102 -- Struktura tabulky `chyby`
    103 --
    104 
    105 CREATE TABLE IF NOT EXISTS `chyby` (
    106   `id` int(8) NOT NULL auto_increment,
    107   `id_name` varchar(128) collate utf8_czech_ci NOT NULL,
    108   `jmeno` varchar(128) collate utf8_czech_ci NOT NULL,
    109   `prispevek` text collate utf8_czech_ci NOT NULL,
    110   `postava` text collate utf8_czech_ci NOT NULL,
    111   `typ` int(24) NOT NULL,
    112   `frakce` int(24) NOT NULL,
    113   `mail` varchar(128) collate utf8_czech_ci NOT NULL,
    114   `screenshot` text collate utf8_czech_ci NOT NULL,
    115   `datum` int(24) NOT NULL,
    116   `status` int(24) NOT NULL,
    117   `ip` varchar(16) collate utf8_czech_ci NOT NULL,
    118   PRIMARY KEY  (`id`)
    119 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=91 ;
    120 
    121 -- --------------------------------------------------------
    122 
    123 --
    124 -- Struktura tabulky `comments`
    125 --
    126 
     51  `guid` int(11) NOT NULL DEFAULT '0',
     52  `warm` int(11) NOT NULL DEFAULT '0',
     53  `weblevel` int(11) NOT NULL DEFAULT '0'
     54) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     55
     56-- Exportování dat pro tabulku wow_web.characters: ~0 rows (přibližně)
     57/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
     58/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
     59
     60
     61-- Exportování struktury pro tabulka wow_web.ClientRedirection
     62CREATE TABLE IF NOT EXISTS `ClientRedirection` (
     63  `Id` int(11) NOT NULL AUTO_INCREMENT,
     64  `Original` varchar(255) NOT NULL,
     65  `Local` varchar(255) NOT NULL,
     66  PRIMARY KEY (`Id`)
     67) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
     68
     69-- Exportování dat pro tabulku wow_web.ClientRedirection: 26 rows
     70/*!40000 ALTER TABLE `ClientRedirection` DISABLE KEYS */;
     71INSERT INTO `ClientRedirection` (`Id`, `Original`, `Local`) VALUES
     72        (1, 'http://signup.wow-europe.com/', 'http://www.heroesoffantasy.cz/registrace/'),
     73        (2, 'http://www.wow-europe.com/en/support/', 'http://www.heroesoffantasy.cz/podpora/'),
     74        (3, 'http://www.wow-europe.com/en/legal', 'http://www.heroesoffantasy.cz/pravni/'),
     75        (4, 'http://www.wow-europe.com/en/serverstatus', 'http://www.heroesoffantasy.cz/stav-serveru/'),
     76        (5, 'http://www.wow-europe.com/en/account/', 'http://www.heroesoffantasy.cz/ucet/'),
     77        (6, 'http://www.wow-europe.com/en/burningcrusade/download', 'http://www.heroesoffantasy.cz/stahovani/'),
     78        (7, 'http://eu.blizzard.com/support/article.xml?articleId=19654', 'http://www.heroesoffantasy.cz/platna-verze-hry/'),
     79        (8, 'http://www.wow-europe.com/en/misc/banned.html', 'http://www.heroesoffantasy.cz/blokovani/'),
     80        (9, 'https://www.wow-europe.com/login-support', 'http://www.heroesoffantasy.cz/podpora-prihlaseni/'),
     81        (10, 'www.wow-europe.com/en/support', 'www.heroesoffantasy.cz/podpora/'),
     82        (11, 'http://beta.wow-europe.com/en/alert', 'http://www.heroesoffantasy.cz/alert-beta/'),
     83        (12, 'http://eu.scan.worldofwarcraft.com/update/Launcher.txt', 'http://www.heroesoffantasy.cz/launcher/'),
     84        (13, 'http://eu.scan.worldofwarcraft.com/update/Scan.dll', 'http://www.heroesoffantasy.cz/'),
     85        (14, 'http://eu.blizzard.com/support/article.xml?articleId=19644', 'http://www.heroesoffantasy.cz/trojan/'),
     86        (15, 'http://eu.blizzard.com/support/article.xml?articleId=19633', 'http://www.heroesoffantasy.cz/hack/'),
     87        (16, 'http://status.wow-europe.com/en/alert', 'http://www.heroesoffantasy.cz/alert/'),
     88        (17, 'https://www.wow-europe.com/account/account-error.html', 'http://www.heroesoffantasy.cz/chyba-uctu/'),
     89        (18, 'http://www.wow-europe.com', 'http://www.heroesoffantasy.cz/'),
     90        (19, 'www.wow-europe.com', 'www.heroesoffantasy.cz'),
     91        (20, 'http://launcher.wow-europe.com/en/eula.htm', 'http://www.heroesoffantasy.cz/eula/'),
     92        (21, 'http://launcher.wow-europe.com/en/tos.htm', 'http://www.heroesoffantasy.cz/tos/'),
     93        (22, 'www.wow-europe.com/en/lichking/download/', 'www.heroesoffantasy.cz/stahovani/'),
     94        (23, 'http://us.blizzard.com/support/index.xml?gameId=11', 'http://www.heroesoffantasy.cz/podpora/'),
     95        (25, 'http://www.worldofwarcraft.com/policy/pvp.shtml', 'http://www.heroesoffantasy.com/pvp/'),
     96        (24, 'http://signup.worldofwarcraft.com', 'http://www.heroesoffantasy.cz/registrace/'),
     97        (26, 'www.worldofwarcraft.com/support/trial', 'www.heroesoffantasyc.cz/stahovani');
     98/*!40000 ALTER TABLE `ClientRedirection` ENABLE KEYS */;
     99
     100
     101-- Exportování struktury pro tabulka wow_web.comments
    127102CREATE TABLE IF NOT EXISTS `comments` (
    128   `id` int(11) NOT NULL auto_increment,
    129   `user` text collate utf8_czech_ci NOT NULL,
    130   `comment` text collate utf8_czech_ci NOT NULL,
    131   `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    132   PRIMARY KEY  (`id`)
    133 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
    134 
    135 -- --------------------------------------------------------
    136 
    137 --
    138 -- Struktura tabulky `debug`
    139 --
    140 
    141 CREATE TABLE IF NOT EXISTS `debug` (
    142   `Id` int(11) NOT NULL auto_increment,
     103  `id` int(11) NOT NULL AUTO_INCREMENT,
     104  `user` text COLLATE utf8_czech_ci NOT NULL,
     105  `comment` text COLLATE utf8_czech_ci NOT NULL,
     106  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
     107  PRIMARY KEY (`id`)
     108) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
     109
     110-- Exportování dat pro tabulku wow_web.comments: ~0 rows (přibližně)
     111/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
     112/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
     113
     114
     115-- Exportování struktury pro tabulka wow_web.DbVersion
     116CREATE TABLE IF NOT EXISTS `DbVersion` (
     117  `Id` int(11) NOT NULL AUTO_INCREMENT,
     118  `Revision` int(11) NOT NULL,
     119  PRIMARY KEY (`Id`)
     120) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     121
     122-- Exportování dat pro tabulku wow_web.DbVersion: ~0 rows (přibližně)
     123/*!40000 ALTER TABLE `DbVersion` DISABLE KEYS */;
     124INSERT INTO `DbVersion` (
     125`Id` ,
     126`Revision`
     127)
     128VALUES (
     129NULL , '710'
     130);
     131/*!40000 ALTER TABLE `DbVersion` ENABLE KEYS */;
     132
     133
     134-- Exportování struktury pro tabulka wow_web.File
     135CREATE TABLE IF NOT EXISTS `File` (
     136  `Id` int(11) NOT NULL AUTO_INCREMENT,
     137  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     138  `Location` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    143139  `Time` datetime NOT NULL,
    144   `Backtrace` mediumtext collate latin2_czech_cs NOT NULL,
    145   `Log` text collate latin2_czech_cs NOT NULL,
    146   `MangosVersion` varchar(255) collate latin2_czech_cs NOT NULL,
    147   `DbVersion` varchar(255) collate latin2_czech_cs NOT NULL,
    148   `MaxPlayerCount` int(11) NOT NULL,
    149   `Uptime` int(11) NOT NULL,
    150   `ErrorLog` text collate latin2_czech_cs NOT NULL,
    151   `DbErrors` text collate latin2_czech_cs NOT NULL,
    152   `Configuration` text collate latin2_czech_cs NOT NULL,
    153   PRIMARY KEY  (`Id`)
    154 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1 ;
    155 
    156 -- --------------------------------------------------------
    157 
    158 --
    159 -- Struktura tabulky `diskuze`
    160 --
    161 
    162 CREATE TABLE IF NOT EXISTS `diskuze` (
    163   `id` int(8) NOT NULL auto_increment,
    164   `entry` int(24) NOT NULL,
    165   `jmeno` varchar(128) collate utf8_czech_ci NOT NULL,
    166   `prispevek` text collate utf8_czech_ci NOT NULL,
    167   `datum` int(24) NOT NULL,
    168   `ip` varchar(16) collate utf8_czech_ci NOT NULL,
    169   PRIMARY KEY  (`id`)
    170 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=41 ;
    171 
    172 -- --------------------------------------------------------
    173 
    174 --
    175 -- Struktura tabulky `export_list`
    176 --
    177 
    178 CREATE TABLE IF NOT EXISTS `export_list` (
    179   `typ` varchar(255) collate utf8_czech_ci default NULL,
    180   `guid` varchar(255) collate utf8_czech_ci default NULL
    181 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
    182 
    183 -- --------------------------------------------------------
    184 
    185 --
    186 -- Struktura tabulky `finance`
    187 --
    188 
    189 CREATE TABLE IF NOT EXISTS `finance` (
    190   `id` int(11) NOT NULL auto_increment,
    191   `time` datetime default NULL,
    192   `money` int(11) default NULL,
    193   `operation` enum('contribution','consumption','buy','internet','sell') collate latin2_czech_cs NOT NULL default 'contribution',
    194   `description` varchar(255) collate latin2_czech_cs default NULL,
    195   `odmena` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
    196   KEY `ID` (`id`)
    197 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=128 ;
    198 
    199 -- --------------------------------------------------------
    200 
    201 --
    202 -- Struktura tabulky `guildy`
    203 --
    204 
     140  `Category` int(11) NOT NULL,
     141  `Description` text COLLATE utf8_czech_ci NOT NULL,
     142  PRIMARY KEY (`Id`),
     143  KEY `Category` (`Category`),
     144  CONSTRAINT `File_ibfk_1` FOREIGN KEY (`Category`) REFERENCES `FileCategory` (`Id`)
     145) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
     146
     147-- Exportování dat pro tabulku wow_web.File: ~0 rows (přibližně)
     148/*!40000 ALTER TABLE `File` DISABLE KEYS */;
     149/*!40000 ALTER TABLE `File` ENABLE KEYS */;
     150
     151
     152-- Exportování struktury pro tabulka wow_web.FileCategory
     153CREATE TABLE IF NOT EXISTS `FileCategory` (
     154  `Id` int(11) NOT NULL AUTO_INCREMENT,
     155  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     156  PRIMARY KEY (`Id`)
     157) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
     158
     159-- Exportování dat pro tabulku wow_web.FileCategory: ~2 rows (přibližně)
     160/*!40000 ALTER TABLE `FileCategory` DISABLE KEYS */;
     161INSERT INTO `FileCategory` (`Id`, `Name`) VALUES
     162        (1, 'Herní klient WoW'),
     163        (2, 'Čeština pro klienta');
     164/*!40000 ALTER TABLE `FileCategory` ENABLE KEYS */;
     165
     166
     167-- Exportování struktury pro tabulka wow_web.Finance
     168CREATE TABLE IF NOT EXISTS `Finance` (
     169  `Id` int(11) NOT NULL AUTO_INCREMENT,
     170  `Time` datetime DEFAULT NULL,
     171  `Money` int(11) DEFAULT NULL,
     172  `Operation` enum('contribution','consumption','buy','internet','sell','hosting') CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL DEFAULT 'contribution',
     173  `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL,
     174  `Reward` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     175  KEY `ID` (`Id`)
     176) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;
     177
     178-- Exportování dat pro tabulku wow_web.Finance: ~0 rows (přibližně)
     179/*!40000 ALTER TABLE `Finance` DISABLE KEYS */;
     180/*!40000 ALTER TABLE `Finance` ENABLE KEYS */;
     181
     182
     183-- Exportování struktury pro tabulka wow_web.FinanceReward
     184CREATE TABLE IF NOT EXISTS `FinanceReward` (
     185  `Id` int(11) NOT NULL AUTO_INCREMENT,
     186  `Reward` varchar(255) NOT NULL,
     187  `Price` varchar(255) NOT NULL,
     188  PRIMARY KEY (`Id`)
     189) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     190
     191-- Exportování dat pro tabulku wow_web.FinanceReward: ~0 rows (přibližně)
     192/*!40000 ALTER TABLE `FinanceReward` DISABLE KEYS */;
     193/*!40000 ALTER TABLE `FinanceReward` ENABLE KEYS */;
     194
     195
     196-- Exportování struktury pro tabulka wow_web.GmTeam
     197CREATE TABLE IF NOT EXISTS `GmTeam` (
     198  `Nick` varchar(255) NOT NULL,
     199  `AccountId` int(11) NOT NULL,
     200  `Delegation` varchar(255) NOT NULL,
     201  `ForumId` int(11) NOT NULL,
     202  `RealmId` int(11) NOT NULL,
     203  `TimeFrom` date DEFAULT NULL,
     204  `TimeTo` date DEFAULT NULL,
     205  KEY `AccountId` (`AccountId`),
     206  KEY `TimeFrom` (`TimeFrom`),
     207  KEY `TimeTo` (`TimeTo`),
     208  KEY `RealmId` (`RealmId`)
     209) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     210
     211-- Exportování dat pro tabulku wow_web.GmTeam: ~0 rows (přibližně)
     212/*!40000 ALTER TABLE `GmTeam` DISABLE KEYS */;
     213/*!40000 ALTER TABLE `GmTeam` ENABLE KEYS */;
     214
     215
     216-- Exportování struktury pro tabulka wow_web.GuildHouse
     217CREATE TABLE IF NOT EXISTS `GuildHouse` (
     218  `Guild` int(255) DEFAULT NULL,
     219  `Realm` int(11) NOT NULL,
     220  `Type` int(255) NOT NULL,
     221  `NextPayment` date DEFAULT NULL,
     222  KEY `Id` (`Guild`),
     223  KEY `Type` (`Type`),
     224  CONSTRAINT `GuildHouse_ibfk_1` FOREIGN KEY (`Type`) REFERENCES `GuildHouseType` (`Id`)
     225) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     226
     227-- Exportování dat pro tabulku wow_web.GuildHouse: ~0 rows (přibližně)
     228/*!40000 ALTER TABLE `GuildHouse` DISABLE KEYS */;
     229/*!40000 ALTER TABLE `GuildHouse` ENABLE KEYS */;
     230
     231
     232-- Exportování struktury pro tabulka wow_web.GuildHouseType
     233CREATE TABLE IF NOT EXISTS `GuildHouseType` (
     234  `Id` int(11) NOT NULL AUTO_INCREMENT,
     235  `Name` varchar(255) NOT NULL,
     236  `Tax` int(11) NOT NULL,
     237  PRIMARY KEY (`Id`)
     238) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     239
     240-- Exportování dat pro tabulku wow_web.GuildHouseType: ~0 rows (přibližně)
     241/*!40000 ALTER TABLE `GuildHouseType` DISABLE KEYS */;
     242/*!40000 ALTER TABLE `GuildHouseType` ENABLE KEYS */;
     243
     244
     245-- Exportování struktury pro tabulka wow_web.GuildInfo
     246CREATE TABLE IF NOT EXISTS `GuildInfo` (
     247  `Id` int(11) NOT NULL DEFAULT '0',
     248  `Guild` int(11) NOT NULL,
     249  `Realm` int(11) NOT NULL,
     250  `Homepage` varchar(255) NOT NULL,
     251  PRIMARY KEY (`Id`),
     252  KEY `Guild` (`Guild`),
     253  KEY `Realm` (`Realm`)
     254) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     255
     256-- Exportování dat pro tabulku wow_web.GuildInfo: ~0 rows (přibližně)
     257/*!40000 ALTER TABLE `GuildInfo` DISABLE KEYS */;
     258/*!40000 ALTER TABLE `GuildInfo` ENABLE KEYS */;
     259
     260
     261-- Exportování struktury pro tabulka wow_web.guildy
    205262CREATE TABLE IF NOT EXISTS `guildy` (
    206   `id` varchar(255) default NULL,
    207   `jmeno` varchar(255) character set utf8 collate utf8_czech_ci default NULL,
    208   `GuM` varchar(255) default NULL,
     263  `id` varchar(255) DEFAULT NULL,
     264  `jmeno` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL,
     265  `GuM` varchar(255) DEFAULT NULL,
    209266  `typgh` varchar(255) NOT NULL,
    210   `dalsi_platba` date default NULL
     267  `dalsi_platba` date DEFAULT NULL
    211268) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    212269
    213 -- --------------------------------------------------------
    214 
    215 --
    216 -- Struktura tabulky `users`
    217 --
    218 
     270-- Exportování dat pro tabulku wow_web.guildy: ~0 rows (přibližně)
     271/*!40000 ALTER TABLE `guildy` DISABLE KEYS */;
     272/*!40000 ALTER TABLE `guildy` ENABLE KEYS */;
     273
     274
     275-- Exportování struktury pro tabulka wow_web.Host
     276CREATE TABLE IF NOT EXISTS `Host` (
     277  `Id` int(11) NOT NULL AUTO_INCREMENT,
     278  `OS` varchar(255) NOT NULL,
     279  `CPU` varchar(255) NOT NULL,
     280  `Memory` varchar(255) NOT NULL,
     281  `HDD` varchar(255) NOT NULL,
     282  `Internet` varchar(255) NOT NULL,
     283  `Address` varchar(255) NOT NULL,
     284  `Statistic` varchar(255) NOT NULL,
     285  `Enabled` int(11) NOT NULL DEFAULT '1',
     286  PRIMARY KEY (`Id`)
     287) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
     288
     289-- Exportování dat pro tabulku wow_web.Host: ~1 rows (přibližně)
     290/*!40000 ALTER TABLE `Host` DISABLE KEYS */;
     291INSERT INTO `Host` (`Id`, `OS`, `CPU`, `Memory`, `HDD`, `Internet`, `Address`, `Statistic`, `Enabled`) VALUES
     292        (3, 'Linux', '', '', '', '', 'localhost', '', 1);
     293/*!40000 ALTER TABLE `Host` ENABLE KEYS */;
     294
     295
     296-- Exportování struktury pro tabulka wow_web.Logon
     297CREATE TABLE IF NOT EXISTS `Logon` (
     298  `Id` int(11) NOT NULL AUTO_INCREMENT,
     299  `Host` int(11) NOT NULL,
     300  `DatabaseUser` varchar(255) NOT NULL,
     301  `DatabasePassword` varchar(255) NOT NULL,
     302  `DatabaseHost` varchar(255) NOT NULL,
     303  `DatabaseRealmd` varchar(255) NOT NULL,
     304  `ClientVersion` varchar(255) NOT NULL,
     305  `Port` int(11) NOT NULL,
     306  `Online` int(11) NOT NULL,
     307  `Name` varchar(255) NOT NULL,
     308  `Enabled` int(11) NOT NULL DEFAULT '1',
     309  PRIMARY KEY (`Id`),
     310  KEY `Host` (`Host`),
     311  CONSTRAINT `Logon_ibfk_1` FOREIGN KEY (`Host`) REFERENCES `Host` (`Id`)
     312) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
     313
     314-- Exportování dat pro tabulku wow_web.Logon: ~1 rows (přibližně)
     315/*!40000 ALTER TABLE `Logon` DISABLE KEYS */;
     316INSERT INTO `Logon` (`Id`, `Host`, `DatabaseUser`, `DatabasePassword`, `DatabaseHost`, `DatabaseRealmd`, `ClientVersion`, `Port`, `Online`, `Name`, `Enabled`) VALUES
     317        (1, 3, 'wow', 'tenkyprut', 'localhost', 'wow_auth', '4.3.4', 3724, 0, 'Hlavní', 1);
     318/*!40000 ALTER TABLE `Logon` ENABLE KEYS */;
     319
     320
     321-- Exportování struktury pro tabulka wow_web.Realm
     322CREATE TABLE IF NOT EXISTS `Realm` (
     323  `Id` int(11) NOT NULL AUTO_INCREMENT,
     324  `Host` int(11) NOT NULL,
     325  `Logon` int(11) NOT NULL,
     326  `DatabaseHost` varchar(255) NOT NULL,
     327  `DatabaseUser` varchar(255) NOT NULL,
     328  `DatabasePassword` varchar(255) NOT NULL,
     329  `DatabaseCharacters` varchar(255) NOT NULL,
     330  `DatabaseMangos` varchar(255) NOT NULL,
     331  `DatabaseScriptDev2` varchar(255) NOT NULL,
     332  `MaxOnlinePlayers` int(11) NOT NULL,
     333  `Rate` varchar(255) NOT NULL,
     334  `Type` varchar(255) NOT NULL,
     335  `Name` varchar(255) NOT NULL,
     336  `Description` text NOT NULL,
     337  `Online` int(11) NOT NULL DEFAULT '0',
     338  `Port` int(11) NOT NULL,
     339  `Enabled` int(11) NOT NULL DEFAULT '1',
     340  `Information` text NOT NULL,
     341  `Locale` varchar(255) NOT NULL,
     342  PRIMARY KEY (`Id`),
     343  UNIQUE KEY `Port` (`Port`),
     344  KEY `Host` (`Host`),
     345  KEY `Logon` (`Logon`),
     346  CONSTRAINT `Realm_ibfk_1` FOREIGN KEY (`Host`) REFERENCES `Host` (`Id`),
     347  CONSTRAINT `Realm_ibfk_2` FOREIGN KEY (`Logon`) REFERENCES `Logon` (`Id`)
     348) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
     349
     350-- Exportování dat pro tabulku wow_web.Realm: ~1 rows (přibližně)
     351/*!40000 ALTER TABLE `Realm` DISABLE KEYS */;
     352INSERT INTO `Realm` (`Id`, `Host`, `Logon`, `DatabaseHost`, `DatabaseUser`, `DatabasePassword`, `DatabaseCharacters`, `DatabaseMangos`, `DatabaseScriptDev2`, `MaxOnlinePlayers`, `Rate`, `Type`, `Name`, `Description`, `Online`, `Port`, `Enabled`, `Information`, `Locale`) VALUES
     353        (3, 3, 1, 'localhost', 'wow', 'tenkyprut', 'wow_characters', 'wow_world', '', 100, '1x', 'normal', 'Virtuál', 'ssdasdas asd as dsa dasd', 0, 8081, 1, '', 'csCZ');
     354/*!40000 ALTER TABLE `Realm` ENABLE KEYS */;
     355
     356
     357-- Exportování struktury pro tabulka wow_web.users
    219358CREATE TABLE IF NOT EXISTS `users` (
    220   `id` int(11) NOT NULL auto_increment,
    221   `realmd_id` int(11) NOT NULL default '0',
    222   `name` text character set utf8 collate utf8_czech_ci NOT NULL,
    223   PRIMARY KEY  (`id`)
    224 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    225 
    226 -- --------------------------------------------------------
    227 
    228 --
    229 -- Struktura tabulky `uzivatele`
    230 --
    231 
    232 CREATE TABLE IF NOT EXISTS `uzivatele` (
    233   `id` int(64) NOT NULL auto_increment,
    234   `user` varchar(1024) collate utf8_czech_ci NOT NULL,
    235   `pass` varchar(40) collate utf8_czech_ci NOT NULL,
    236   `mail` varchar(1024) collate utf8_czech_ci NOT NULL,
    237   PRIMARY KEY  (`id`)
    238 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;
     359  `id` int(11) NOT NULL AUTO_INCREMENT,
     360  `realmd_id` int(11) NOT NULL DEFAULT '0',
     361  `name` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     362  PRIMARY KEY (`id`)
     363) ENGINE=InnoDB DEFAULT CHARSET=utf8;
     364
     365-- Exportování dat pro tabulku wow_web.users: ~0 rows (přibližně)
     366/*!40000 ALTER TABLE `users` DISABLE KEYS */;
     367/*!40000 ALTER TABLE `users` ENABLE KEYS */;
     368/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
     369/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
     370/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

  • trunk/sql/updates/650.sql

    r681 r712  
    6565ALTER TABLE `Logon` ADD `Port` INT NOT NULL ;
    6666
     67ALTER TABLE `articles` CHANGE `id` `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
     68CHANGE `title` `Title` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
     69CHANGE `autor` `Author` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
     70CHANGE `category` `Category` INT( 11 ) NOT NULL DEFAULT '0',
     71CHANGE `text` `Content` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
     72CHANGE `date` `Time` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00';
     73
     74RENAME TABLE `articles`  TO `Article` ;
     75ALTER TABLE `Article`  ENGINE = InnoDB;
     76
     77ALTER TABLE `Article` ADD INDEX ( `Category` ) ;
     78
     79CREATE TABLE IF NOT EXISTS `ArticleCategory` (
     80  `Id` int(11) NOT NULL auto_increment,
     81  `Name` varchar(255) NOT NULL,
     82  PRIMARY KEY  (`Id`)
     83) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     84
     85INSERT INTO `ArticleCategory` (`Id`, `Name`) VALUES
     86(1, 'Server novinky'),
     87(2, 'GM novinky'),
     88(3, 'In-game novinky'),
     89(4, 'Články');
     90
     91ALTER TABLE `Article` ADD FOREIGN KEY ( `Category` ) REFERENCES `ArticleCategory` (`Id`);
     92
Note: See TracChangeset for help on using the changeset viewer.