- Timestamp:
- Feb 5, 2009, 8:30:59 AM (15 years ago)
- Location:
- branches/2/sql
- Files:
-
- 2 edited
-
full.sql (modified) (8 diffs)
-
init_data.sql (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/2/sql/full.sql
r40 r63 1 1 -- phpMyAdmin SQL Dump 2 -- version 2.10.22 -- version 3.1.2 3 3 -- http://www.phpmyadmin.net 4 -- 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Čtvrtek 0 8. května 2008, 19:597 -- Verze MySQL: 5.0. 458 -- Verze PHP: 5.2. 46 -- Vygenerováno: Čtvrtek 05. února 2009, 06:45 7 -- Verze MySQL: 5.0.67 8 -- Verze PHP: 5.2.6 9 9 10 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 11 12 -- 12 -- 13 13 -- Databáze: `wowpreklad` 14 -- 14 -- 15 15 16 16 -- -------------------------------------------------------- 17 17 18 -- 18 -- 19 19 -- Struktura tabulky `Language` 20 -- 20 -- 21 21 22 CREATE TABLE `Language` (22 CREATE TABLE IF NOT EXISTS `Language` ( 23 23 `Id` int(11) NOT NULL auto_increment, 24 24 `Name` varchar(64) collate utf8_czech_ci NOT NULL, … … 28 28 -- -------------------------------------------------------- 29 29 30 -- 31 -- Struktura tabulky `Permission `32 -- 30 -- 31 -- Struktura tabulky `PermissionOperation` 32 -- 33 33 34 CREATE TABLE `Permission` (34 CREATE TABLE IF NOT EXISTS `PermissionOperation` ( 35 35 `Id` int(11) NOT NULL auto_increment, 36 ` Title` varchar(64) collate utf8_czech_ci NOT NULL,36 `Description` varchar(128) collate utf8_czech_ci NOT NULL, 37 37 PRIMARY KEY (`Id`) 38 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 5;38 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ; 39 39 40 40 -- -------------------------------------------------------- 41 41 42 -- 42 -- 43 43 -- Struktura tabulky `Text` 44 -- 44 -- 45 45 46 CREATE TABLE `Text` (46 CREATE TABLE IF NOT EXISTS `Text` ( 47 47 `Id` int(11) NOT NULL auto_increment, 48 48 `TranslationGroup` int(11) NOT NULL, … … 51 51 PRIMARY KEY (`Id`), 52 52 KEY `TranslationGroup` (`TranslationGroup`,`GroupItem`) 53 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 113390;53 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=427992 ; 54 54 55 55 -- -------------------------------------------------------- 56 56 57 -- 57 -- 58 58 -- Struktura tabulky `TextGroup` 59 -- 59 -- 60 60 61 CREATE TABLE `TextGroup` (61 CREATE TABLE IF NOT EXISTS `TextGroup` ( 62 62 `Id` int(11) NOT NULL auto_increment, 63 63 `Group` int(11) NOT NULL, … … 67 67 `Time` datetime NOT NULL, 68 68 `Revision` int(11) NOT NULL, 69 `Complete` tinyint(1) NOT NULL, 70 `OriginalText` int(11) NOT NULL, 71 `OldSystem` tinyint(1) NOT NULL, 69 72 PRIMARY KEY (`Id`), 70 73 UNIQUE KEY `Group` (`Group`,`User`,`Index`,`Language`) 71 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 358575;74 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=256750 ; 72 75 73 76 -- -------------------------------------------------------- 74 77 75 -- 78 -- 76 79 -- Struktura tabulky `Translation` 77 -- 80 -- 78 81 79 CREATE TABLE `Translation` (82 CREATE TABLE IF NOT EXISTS `Translation` ( 80 83 `Id` int(11) NOT NULL auto_increment, 81 84 `Group` int(11) NOT NULL, … … 87 90 -- -------------------------------------------------------- 88 91 89 -- 92 -- 90 93 -- Struktura tabulky `TranslationGroup` 91 -- 94 -- 92 95 93 CREATE TABLE `TranslationGroup` (96 CREATE TABLE IF NOT EXISTS `TranslationGroup` ( 94 97 `Id` int(11) NOT NULL auto_increment, 95 98 `Name` varchar(64) collate utf8_czech_ci NOT NULL, … … 101 104 -- -------------------------------------------------------- 102 105 103 -- 106 -- 104 107 -- Struktura tabulky `User` 105 -- 108 -- 106 109 107 CREATE TABLE `User` (110 CREATE TABLE IF NOT EXISTS `User` ( 108 111 `Id` int(11) NOT NULL auto_increment, 109 112 `Name` varchar(64) collate utf8_czech_ci NOT NULL, 110 113 `Password` varchar(64) collate utf8_czech_ci NOT NULL, 111 114 `Email` varchar(128) collate utf8_czech_ci NOT NULL, 112 ` Permission` int(11) NOT NULL,115 `Role` int(11) NOT NULL, 113 116 `LastIpAddress` varchar(16) collate utf8_czech_ci NOT NULL, 114 117 `LastLoginTime` datetime NOT NULL, … … 116 119 `FullName` varchar(128) collate utf8_czech_ci NOT NULL, 117 120 PRIMARY KEY (`Id`) 118 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 2;121 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=319 ; 119 122 120 123 -- -------------------------------------------------------- 121 124 122 -- 125 -- 123 126 -- Struktura tabulky `UserOnline` 124 -- 127 -- 125 128 126 CREATE TABLE `UserOnline` (129 CREATE TABLE IF NOT EXISTS `UserOnline` ( 127 130 `User` int(11) NOT NULL, 128 131 `Time` datetime NOT NULL, 129 132 `SessionId` varchar(255) collate utf8_czech_ci NOT NULL, 130 ` IpAddress` varchar(16) collate utf8_czech_ci NOT NULL,133 `HostAddress` varchar(255) collate utf8_czech_ci NOT NULL, 131 134 PRIMARY KEY (`User`) 132 135 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; … … 134 137 -- -------------------------------------------------------- 135 138 136 -- 139 -- 140 -- Struktura tabulky `UserRole` 141 -- 142 143 CREATE TABLE IF NOT EXISTS `UserRole` ( 144 `Id` int(11) NOT NULL auto_increment, 145 `Title` varchar(64) collate utf8_czech_ci NOT NULL, 146 PRIMARY KEY (`Id`) 147 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ; 148 149 -- -------------------------------------------------------- 150 151 -- 152 -- Struktura tabulky `UserRolePermission` 153 -- 154 155 CREATE TABLE IF NOT EXISTS `UserRolePermission` ( 156 `Role` int(11) NOT NULL, 157 `Operation` int(11) NOT NULL, 158 `Read` tinyint(1) NOT NULL, 159 `Write` tinyint(1) NOT NULL, 160 PRIMARY KEY (`Role`,`Operation`) 161 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 162 163 -- -------------------------------------------------------- 164 165 -- 137 166 -- Struktura tabulky `Vote` 138 -- 167 -- 139 168 140 CREATE TABLE `Vote` (169 CREATE TABLE IF NOT EXISTS `Vote` ( 141 170 `TranslationGroup` int(11) NOT NULL, 142 171 `User` int(11) NOT NULL, -
branches/2/sql/init_data.sql
r40 r63 1 1 -- phpMyAdmin SQL Dump 2 -- version 2.10.22 -- version 3.1.2 3 3 -- http://www.phpmyadmin.net 4 -- 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Čtvrtek 0 8. května 2008, 20:007 -- Verze MySQL: 5.0. 458 -- Verze PHP: 5.2. 46 -- Vygenerováno: Čtvrtek 05. února 2009, 06:46 7 -- Verze MySQL: 5.0.67 8 -- Verze PHP: 5.2.6 9 9 10 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 11 12 -- 12 -- 13 13 -- Databáze: `wowpreklad` 14 -- 14 -- 15 15 16 -- 16 -- 17 17 -- Vypisuji data pro tabulku `Language` 18 -- 18 -- 19 19 20 INSERT INTO `Language` (`Id`, `Name`) VALUES 20 INSERT INTO `Language` (`Id`, `Name`) VALUES 21 21 (1, 'English'), 22 22 (2, 'Čeština'), 23 23 (3, 'Slovenština'); 24 24 25 -- 26 -- Vypisuji data pro tabulku ` Permission`27 -- 25 -- 26 -- Vypisuji data pro tabulku `Translation` 27 -- 28 28 29 INSERT INTO `Permission` (`Id`, `Title`) VALUES 30 (1, 'Anonym'), 31 (2, 'Překladatel'), 32 (3, 'Moderátor'), 33 (4, 'Administrátor'); 34 35 -- 36 -- Vypisuji data pro tabulku `Translation` 37 -- 38 39 INSERT INTO `Translation` (`Id`, `Group`, `Name`, `MangosColumn`) VALUES 29 INSERT INTO `Translation` (`Id`, `Group`, `Name`, `MangosColumn`) VALUES 40 30 (1, 1, 'Titulek', 'Title'), 41 31 (2, 1, 'Detaily', 'Details'), … … 74 64 (35, 8, 'Nápověda', 'help'); 75 65 76 -- 66 -- 77 67 -- Vypisuji data pro tabulku `TranslationGroup` 78 -- 68 -- 79 69 80 INSERT INTO `TranslationGroup` (`Id`, `Name`, `MangosTable`, `MangosTableIndex`) VALUES 70 INSERT INTO `TranslationGroup` (`Id`, `Name`, `MangosTable`, `MangosTableIndex`) VALUES 81 71 (1, 'Výpravy', 'quest_template', 'entry'), 82 72 (2, 'Texty knížek', 'page_text', 'entry'), … … 87 77 (7, 'Zprávy MaNGOSu', 'mangos_string', 'entry'), 88 78 (8, 'Popis GM příkazů', 'command', 'entry'); 79 80 -- 81 -- Vypisuji data pro tabulku `UserRole` 82 -- 83 84 INSERT INTO `UserRole` (`Id`, `Title`) VALUES 85 (1, 'Anonym'), 86 (2, 'Překladatel'), 87 (3, 'Moderátor'), 88 (4, 'Administrátor');
Note:
See TracChangeset
for help on using the changeset viewer.
