Changeset 530
- Timestamp:
- Mar 24, 2009, 9:40:02 AM (16 years ago)
- Files:
-
- 6 deleted
- 8 edited
Legend:
- Unmodified
- Added
- Removed
-
/
-
Property svn:ignore
set to
mm
-
Property svn:ignore
set to
-
trunk/gh_system/export_system
-
Property svn:ignore
set to
*.sql
-
Property svn:ignore
set to
-
trunk/imgs
-
Property svn:ignore
set to
Thumbs.db
-
Property svn:ignore
set to
-
trunk/imgs/icons
-
Property svn:ignore
set to
Thumbs.db
-
Property svn:ignore
set to
-
trunk/imgs/inc
-
Property svn:ignore
set to
Thumbs.db
-
Property svn:ignore
set to
-
trunk/imgs/order
-
Property svn:ignore
set to
Thumbs.db
-
Property svn:ignore
set to
-
trunk/imgs/web
-
Property svn:ignore
set to
Thumbs.db
-
Property svn:ignore
set to
-
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 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; 15 70 16 71 -- -------------------------------------------------------- … … 28 83 `date` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP, 29 84 PRIMARY KEY (`id`) 30 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 2;85 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=115 ; 31 86 32 87 -- -------------------------------------------------------- … … 45 100 46 101 -- 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 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=63 ; 72 120 73 121 -- -------------------------------------------------------- … … 84 132 PRIMARY KEY (`id`) 85 133 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ; 134 135 -- -------------------------------------------------------- 136 137 -- 138 -- Struktura tabulky `diskuze` 139 -- 140 141 CREATE 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 157 CREATE 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; 86 161 87 162 -- -------------------------------------------------------- … … 97 172 `operation` enum('contribution','consumption','buy','internet','sell') collate latin2_czech_cs NOT NULL default 'contribution', 98 173 `description` varchar(255) collate latin2_czech_cs default NULL, 174 `odmena` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL, 99 175 KEY `ID` (`id`) 100 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1 13;176 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=127 ; 101 177 102 178 -- -------------------------------------------------------- … … 126 202 PRIMARY KEY (`id`) 127 203 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 204 205 -- -------------------------------------------------------- 206 207 -- 208 -- Struktura tabulky `uzivatele` 209 -- 210 211 CREATE 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.