Changeset 530 for trunk/sql/structure.sql

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:

• trunk/sql/structure.sql (modified) (6 diffs)

trunk/sql/structure.sql

@@ -1 @@
--- phpMyAdmin SQL Dump
--- version 3.1.2
--- http://www.phpmyadmin.net
---
--- Počítač: localhost
--- Vygenerováno: Neděle 22. února 2009, 17:17
--- Verze MySQL: 5.0.51
--- Verze PHP: 5.2.6
-
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-
---
--- Databáze: `wow_web`
---
+--
+-- Struktura tabulky `achievement`
+--
+
+CREATE TABLE IF NOT EXISTS `achievement` (
+  `id` bigint(20) NOT NULL COMMENT 'Entry',
+  `team` bigint(20) NOT NULL COMMENT '-1=all, 0=horde, 1=alliance',
+  `mapid` bigint(20) NOT NULL COMMENT '-1=none - Only set if achievement is related to a zone',
+  `field_3` bigint(20) NOT NULL,
+  `name01` text NOT NULL,
+  `name02` text NOT NULL,
+  `name03` text NOT NULL,
+  `name04` text NOT NULL,
+  `name05` text NOT NULL,
+  `name06` text NOT NULL,
+  `name07` text NOT NULL,
+  `name08` text NOT NULL,
+  `name09` text NOT NULL,
+  `name10` text NOT NULL,
+  `name11` text NOT NULL,
+  `name12` text NOT NULL,
+  `name13` text NOT NULL,
+  `name14` text NOT NULL,
+  `name15` text NOT NULL,
+  `name16` text NOT NULL,
+  `field_20` bigint(20) NOT NULL,
+  `description01` text NOT NULL COMMENT 'description - each for one locale',
+  `description02` text NOT NULL,
+  `description03` text NOT NULL,
+  `description04` text NOT NULL,
+  `description05` text NOT NULL,
+  `description06` text NOT NULL,
+  `description07` text NOT NULL,
+  `description08` text NOT NULL,
+  `description09` text NOT NULL,
+  `description10` text NOT NULL,
+  `description11` text NOT NULL,
+  `description12` text NOT NULL,
+  `description13` text NOT NULL,
+  `description14` text NOT NULL,
+  `description15` text NOT NULL,
+  `description16` text NOT NULL,
+  `field_37` bigint(20) NOT NULL,
+  `categoryid` bigint(20) NOT NULL COMMENT 'id of category',
+  `rewpoints` bigint(20) NOT NULL COMMENT 'rewarded points',
+  `order` bigint(20) NOT NULL COMMENT 'order in category',
+  `flags` bigint(20) NOT NULL COMMENT 'flags',
+  `field_42` bigint(20) NOT NULL,
+  `rewarddesc01` text NOT NULL COMMENT 'reward description - each for one locale',
+  `rewarddesc02` text NOT NULL,
+  `rewarddesc03` text NOT NULL,
+  `rewarddesc04` text NOT NULL,
+  `rewarddesc05` text NOT NULL,
+  `rewarddesc06` text NOT NULL,
+  `rewarddesc07` text NOT NULL,
+  `rewarddesc08` text NOT NULL,
+  `rewarddesc09` text NOT NULL,
+  `rewarddesc10` text NOT NULL,
+  `rewarddesc11` text NOT NULL,
+  `rewarddesc12` text NOT NULL,
+  `rewarddesc13` text NOT NULL,
+  `rewarddesc14` text NOT NULL,
+  `rewarddesc15` text NOT NULL,
+  `rewarddesc16` text NOT NULL,
+  `field_59` bigint(20) NOT NULL,
+  `field_60` bigint(20) NOT NULL,
+  `field_61` bigint(20) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
@@ -28 +83 @@
   `date` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=115 ;
 
 -- --------------------------------------------------------
@@ -45 +100 @@
 
 --
--- Struktura tabulky `chat_rooms`
---
-
-CREATE TABLE IF NOT EXISTS `chat_rooms` (
-  `id` int(11) NOT NULL auto_increment,
-  `owner` int(11) NOT NULL default '0',
-  `pass` text NOT NULL,
-  `security` int(11) NOT NULL default '0',
-  PRIMARY KEY  (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `chat_say`
---
-
-CREATE TABLE IF NOT EXISTS `chat_say` (
-  `chat_room` int(11) NOT NULL default '0',
-  `id` int(11) NOT NULL auto_increment,
-  `user` int(11) NOT NULL default '0',
-  `date` int(11) NOT NULL default '0',
-  `text` text character set utf8 collate utf8_czech_ci NOT NULL,
-  PRIMARY KEY  (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+-- Struktura tabulky `chyby`
+--
+
+CREATE TABLE IF NOT EXISTS `chyby` (
+  `id` int(8) NOT NULL auto_increment,
+  `id_name` varchar(128) collate utf8_czech_ci NOT NULL,
+  `jmeno` varchar(128) collate utf8_czech_ci NOT NULL,
+  `prispevek` text collate utf8_czech_ci NOT NULL,
+  `postava` text collate utf8_czech_ci NOT NULL,
+  `typ` int(24) NOT NULL,
+  `frakce` int(24) NOT NULL,
+  `mail` varchar(128) collate utf8_czech_ci NOT NULL,
+  `screenshot` text collate utf8_czech_ci NOT NULL,
+  `datum` int(24) NOT NULL,
+  `status` int(24) NOT NULL,
+  `ip` varchar(16) collate utf8_czech_ci NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
 
 -- --------------------------------------------------------
@@ -84 +132 @@
   PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `diskuze`
+--
+
+CREATE TABLE IF NOT EXISTS `diskuze` (
+  `id` int(8) NOT NULL auto_increment,
+  `entry` int(24) NOT NULL,
+  `jmeno` varchar(128) collate utf8_czech_ci NOT NULL,
+  `prispevek` text collate utf8_czech_ci NOT NULL,
+  `datum` int(24) NOT NULL,
+  `ip` varchar(16) collate utf8_czech_ci NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=18 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `export_list`
+--
+
+CREATE TABLE IF NOT EXISTS `export_list` (
+  `typ` varchar(255) collate utf8_czech_ci default NULL,
+  `guid` varchar(255) collate utf8_czech_ci default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
 
 -- --------------------------------------------------------
@@ -97 +172 @@
   `operation` enum('contribution','consumption','buy','internet','sell') collate latin2_czech_cs NOT NULL default 'contribution',
   `description` varchar(255) collate latin2_czech_cs default NULL,
+  `odmena` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
   KEY `ID` (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=113 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=127 ;
 
 -- --------------------------------------------------------
@@ -126 +202 @@
   PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `uzivatele`
+--
+
+CREATE TABLE IF NOT EXISTS `uzivatele` (
+  `id` int(64) NOT NULL auto_increment,
+  `user` varchar(1024) collate utf8_czech_ci NOT NULL,
+  `pass` varchar(40) collate utf8_czech_ci NOT NULL,
+  `mail` varchar(1024) collate utf8_czech_ci NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;