Changeset 530 for trunk/sql


Ignore:
Timestamp:
Mar 24, 2009, 9:40:02 AM (16 years ago)
Author:
george
Message:
  • Smazáno: Do repozitáře neukládat cache soubory obrázků Thumbs.db. Nutno použít vlastnost svn:ignore.
  • Smazáno: Importovací skript ze starého webu již není potřeba.
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/structure.sql

    r445 r530  
    1 -- phpMyAdmin SQL Dump
    2 -- version 3.1.2
    3 -- http://www.phpmyadmin.net
    4 --
    5 -- Počítač: localhost
    6 -- Vygenerováno: Neděle 22. února 2009, 17:17
    7 -- Verze MySQL: 5.0.51
    8 -- Verze PHP: 5.2.6
    9 
    10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    11 
    12 --
    13 -- Databáze: `wow_web`
    14 --
     1--
     2-- Struktura tabulky `achievement`
     3--
     4
     5CREATE 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;
    1570
    1671-- --------------------------------------------------------
    … …  
    2883  `date` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
    2984  PRIMARY KEY  (`id`)
    30 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;
     85) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=115 ;
    3186
    3287-- --------------------------------------------------------
    … …  
    45100
    46101--
    47 -- Struktura tabulky `chat_rooms`
    48 --
    49 
    50 CREATE TABLE IF NOT EXISTS `chat_rooms` (
    51   `id` int(11) NOT NULL auto_increment,
    52   `owner` int(11) NOT NULL default '0',
    53   `pass` text NOT NULL,
    54   `security` int(11) NOT NULL default '0',
    55   PRIMARY KEY  (`id`)
    56 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    57 
    58 -- --------------------------------------------------------
    59 
    60 --
    61 -- Struktura tabulky `chat_say`
    62 --
    63 
    64 CREATE TABLE IF NOT EXISTS `chat_say` (
    65   `chat_room` int(11) NOT NULL default '0',
    66   `id` int(11) NOT NULL auto_increment,
    67   `user` int(11) NOT NULL default '0',
    68   `date` int(11) NOT NULL default '0',
    69   `text` text character set utf8 collate utf8_czech_ci NOT NULL,
    70   PRIMARY KEY  (`id`)
    71 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     102-- Struktura tabulky `chyby`
     103--
     104
     105CREATE 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=63 ;
    72120
    73121-- --------------------------------------------------------
    … …  
    84132  PRIMARY KEY  (`id`)
    85133) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
     134
     135-- --------------------------------------------------------
     136
     137--
     138-- Struktura tabulky `diskuze`
     139--
     140
     141CREATE TABLE IF NOT EXISTS `diskuze` (
     142  `id` int(8) NOT NULL auto_increment,
     143  `entry` int(24) NOT NULL,
     144  `jmeno` varchar(128) collate utf8_czech_ci NOT NULL,
     145  `prispevek` text collate utf8_czech_ci NOT NULL,
     146  `datum` int(24) NOT NULL,
     147  `ip` varchar(16) collate utf8_czech_ci NOT NULL,
     148  PRIMARY KEY  (`id`)
     149) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=18 ;
     150
     151-- --------------------------------------------------------
     152
     153--
     154-- Struktura tabulky `export_list`
     155--
     156
     157CREATE TABLE IF NOT EXISTS `export_list` (
     158  `typ` varchar(255) collate utf8_czech_ci default NULL,
     159  `guid` varchar(255) collate utf8_czech_ci default NULL
     160) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
    86161
    87162-- --------------------------------------------------------
    … …  
    97172  `operation` enum('contribution','consumption','buy','internet','sell') collate latin2_czech_cs NOT NULL default 'contribution',
    98173  `description` varchar(255) collate latin2_czech_cs default NULL,
     174  `odmena` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
    99175  KEY `ID` (`id`)
    100 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=113 ;
     176) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=127 ;
    101177
    102178-- --------------------------------------------------------
    … …  
    126202  PRIMARY KEY  (`id`)
    127203) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
     204
     205-- --------------------------------------------------------
     206
     207--
     208-- Struktura tabulky `uzivatele`
     209--
     210
     211CREATE TABLE IF NOT EXISTS `uzivatele` (
     212  `id` int(64) NOT NULL auto_increment,
     213  `user` varchar(1024) collate utf8_czech_ci NOT NULL,
     214  `pass` varchar(40) collate utf8_czech_ci NOT NULL,
     215  `mail` varchar(1024) collate utf8_czech_ci NOT NULL,
     216  PRIMARY KEY  (`id`)
     217) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;
Note: See TracChangeset for help on using the changeset viewer.