Changeset 40 for branches/2/sql/full.sql
- Timestamp:
- Jan 24, 2009, 5:55:02 PM (15 years ago)
- File:
-
- 1 edited
-
branches/2/sql/full.sql (modified) (10 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/2/sql/full.sql
r37 r40 1 1 -- phpMyAdmin SQL Dump 2 -- version 2. 9.1.12 -- version 2.10.2 3 3 -- http://www.phpmyadmin.net 4 4 -- 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 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 9 12 -- 10 -- Datab ase: `wowpreklad`13 -- Databáze: `wowpreklad` 11 14 -- 12 15 … … 14 17 15 18 -- 16 -- Table structure for table `language`19 -- Struktura tabulky `Language` 17 20 -- 18 21 19 CREATE TABLE ` language` (22 CREATE TABLE `Language` ( 20 23 `Id` int(11) NOT NULL auto_increment, 21 24 `Name` varchar(64) collate utf8_czech_ci NOT NULL, … … 26 29 27 30 -- 28 -- Table structure for table `permission`31 -- Struktura tabulky `Permission` 29 32 -- 30 33 31 CREATE TABLE ` permission` (34 CREATE TABLE `Permission` ( 32 35 `Id` int(11) NOT NULL auto_increment, 33 36 `Title` varchar(64) collate utf8_czech_ci NOT NULL, … … 38 41 39 42 -- 40 -- Table structure for table `text`43 -- Struktura tabulky `Text` 41 44 -- 42 45 43 CREATE TABLE ` text` (46 CREATE TABLE `Text` ( 44 47 `Id` int(11) NOT NULL auto_increment, 45 48 `TranslationGroup` int(11) NOT NULL, … … 53 56 54 57 -- 55 -- Table structure for table `textgroup`58 -- Struktura tabulky `TextGroup` 56 59 -- 57 60 58 CREATE TABLE ` textgroup` (61 CREATE TABLE `TextGroup` ( 59 62 `Id` int(11) NOT NULL auto_increment, 60 63 `Group` int(11) NOT NULL, … … 71 74 72 75 -- 73 -- Table structure for table `translation`76 -- Struktura tabulky `Translation` 74 77 -- 75 78 76 CREATE TABLE ` translation` (79 CREATE TABLE `Translation` ( 77 80 `Id` int(11) NOT NULL auto_increment, 78 81 `Group` int(11) NOT NULL, … … 85 88 86 89 -- 87 -- Table structure for table `translationgroup`90 -- Struktura tabulky `TranslationGroup` 88 91 -- 89 92 90 CREATE TABLE ` translationgroup` (93 CREATE TABLE `TranslationGroup` ( 91 94 `Id` int(11) NOT NULL auto_increment, 92 95 `Name` varchar(64) collate utf8_czech_ci NOT NULL, … … 99 102 100 103 -- 101 -- Table structure for table `user`104 -- Struktura tabulky `User` 102 105 -- 103 106 104 CREATE TABLE ` user` (107 CREATE TABLE `User` ( 105 108 `Id` int(11) NOT NULL auto_increment, 106 109 `Name` varchar(64) collate utf8_czech_ci NOT NULL, … … 108 111 `Email` varchar(128) collate utf8_czech_ci NOT NULL, 109 112 `Permission` int(11) NOT NULL, 110 `LastIpAddress` varchar( 255) collate utf8_czech_ci NOT NULL,113 `LastIpAddress` varchar(16) collate utf8_czech_ci NOT NULL, 111 114 `LastLoginTime` datetime NOT NULL, 112 115 `TranslationLanguage` int(11) NOT NULL, 113 116 `FullName` varchar(128) collate utf8_czech_ci NOT NULL, 114 117 PRIMARY KEY (`Id`) 115 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 4;118 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ; 116 119 117 120 -- -------------------------------------------------------- 118 121 119 122 -- 120 -- Table structure for table `useronline`123 -- Struktura tabulky `UserOnline` 121 124 -- 122 125 123 CREATE TABLE ` useronline` (126 CREATE TABLE `UserOnline` ( 124 127 `User` int(11) NOT NULL, 125 128 `Time` datetime NOT NULL, 126 129 `SessionId` varchar(255) collate utf8_czech_ci NOT NULL, 127 `IpAddress` varchar( 255) collate utf8_czech_ci NOT NULL,128 UNIQUE KEY `SessionId` (`SessionId`)130 `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL, 131 PRIMARY KEY (`User`) 129 132 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 130 133 … … 132 135 133 136 -- 134 -- Table structure for table `vote`137 -- Struktura tabulky `Vote` 135 138 -- 136 139 137 CREATE TABLE ` vote` (140 CREATE TABLE `Vote` ( 138 141 `TranslationGroup` int(11) NOT NULL, 139 142 `User` int(11) NOT NULL,
Note:
See TracChangeset
for help on using the changeset viewer.
