Changeset 37
- Timestamp:
- Nov 25, 2008, 3:36:49 PM (16 years ago)
- Location:
- branches/2/sql
- Files:
-
- 2 edited
-
full.sql (modified) (10 diffs)
-
init_data.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/2/sql/full.sql
r5 r37 1 1 -- phpMyAdmin SQL Dump 2 -- version 2. 10.22 -- version 2.9.1.1 3 3 -- http://www.phpmyadmin.net 4 4 -- 5 -- Počítač: localhost 6 -- Vygenerováno: Čtvrtek 08. května 2008, 19:59 7 -- Verze MySQL: 5.0.45 8 -- Verze PHP: 5.2.4 9 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 5 -- Host: localhost 6 -- Generation Time: Oct 13, 2008 at 07:51 PM 7 -- Server version: 5.0.67 8 -- PHP Version: 5.2.0 12 9 -- 13 -- Datab áze: `wowpreklad`10 -- Database: `wowpreklad` 14 11 -- 15 12 … … 17 14 18 15 -- 19 -- Struktura tabulky `Language`16 -- Table structure for table `language` 20 17 -- 21 18 22 CREATE TABLE ` Language` (19 CREATE TABLE `language` ( 23 20 `Id` int(11) NOT NULL auto_increment, 24 21 `Name` varchar(64) collate utf8_czech_ci NOT NULL, … … 29 26 30 27 -- 31 -- Struktura tabulky `Permission`28 -- Table structure for table `permission` 32 29 -- 33 30 34 CREATE TABLE ` Permission` (31 CREATE TABLE `permission` ( 35 32 `Id` int(11) NOT NULL auto_increment, 36 33 `Title` varchar(64) collate utf8_czech_ci NOT NULL, … … 41 38 42 39 -- 43 -- Struktura tabulky `Text`40 -- Table structure for table `text` 44 41 -- 45 42 46 CREATE TABLE ` Text` (43 CREATE TABLE `text` ( 47 44 `Id` int(11) NOT NULL auto_increment, 48 45 `TranslationGroup` int(11) NOT NULL, … … 56 53 57 54 -- 58 -- Struktura tabulky `TextGroup`55 -- Table structure for table `textgroup` 59 56 -- 60 57 61 CREATE TABLE ` TextGroup` (58 CREATE TABLE `textgroup` ( 62 59 `Id` int(11) NOT NULL auto_increment, 63 60 `Group` int(11) NOT NULL, … … 74 71 75 72 -- 76 -- Struktura tabulky `Translation`73 -- Table structure for table `translation` 77 74 -- 78 75 79 CREATE TABLE ` Translation` (76 CREATE TABLE `translation` ( 80 77 `Id` int(11) NOT NULL auto_increment, 81 78 `Group` int(11) NOT NULL, … … 88 85 89 86 -- 90 -- Struktura tabulky `TranslationGroup`87 -- Table structure for table `translationgroup` 91 88 -- 92 89 93 CREATE TABLE ` TranslationGroup` (90 CREATE TABLE `translationgroup` ( 94 91 `Id` int(11) NOT NULL auto_increment, 95 92 `Name` varchar(64) collate utf8_czech_ci NOT NULL, … … 102 99 103 100 -- 104 -- Struktura tabulky `User`101 -- Table structure for table `user` 105 102 -- 106 103 107 CREATE TABLE ` User` (104 CREATE TABLE `user` ( 108 105 `Id` int(11) NOT NULL auto_increment, 109 106 `Name` varchar(64) collate utf8_czech_ci NOT NULL, … … 111 108 `Email` varchar(128) collate utf8_czech_ci NOT NULL, 112 109 `Permission` int(11) NOT NULL, 113 `LastIpAddress` varchar( 16) collate utf8_czech_ci NOT NULL,110 `LastIpAddress` varchar(255) collate utf8_czech_ci NOT NULL, 114 111 `LastLoginTime` datetime NOT NULL, 115 112 `TranslationLanguage` int(11) NOT NULL, 116 113 `FullName` varchar(128) collate utf8_czech_ci NOT NULL, 117 114 PRIMARY KEY (`Id`) 118 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 2;115 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ; 119 116 120 117 -- -------------------------------------------------------- 121 118 122 119 -- 123 -- Struktura tabulky `UserOnline`120 -- Table structure for table `useronline` 124 121 -- 125 122 126 CREATE TABLE ` UserOnline` (123 CREATE TABLE `useronline` ( 127 124 `User` int(11) NOT NULL, 128 125 `Time` datetime NOT NULL, 129 126 `SessionId` varchar(255) collate utf8_czech_ci NOT NULL, 130 `IpAddress` varchar( 16) collate utf8_czech_ci NOT NULL,131 PRIMARY KEY (`User`)127 `IpAddress` varchar(255) collate utf8_czech_ci NOT NULL, 128 UNIQUE KEY `SessionId` (`SessionId`) 132 129 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 133 130 … … 135 132 136 133 -- 137 -- Struktura tabulky `Vote`134 -- Table structure for table `vote` 138 135 -- 139 136 140 CREATE TABLE ` Vote` (137 CREATE TABLE `vote` ( 141 138 `TranslationGroup` int(11) NOT NULL, 142 139 `User` int(11) NOT NULL, -
branches/2/sql/init_data.sql
r5 r37 1 1 -- phpMyAdmin SQL Dump 2 -- version 2.10.2 2 -- version 2.10.2 3 3 -- http://www.phpmyadmin.net 4 4 --
Note:
See TracChangeset
for help on using the changeset viewer.
