Rev 2 | Rev 11 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 6 | daniel-mar | 1 | -- phpMyAdmin SQL Dump |
| 2 | -- version 4.2.0-dev |
||
| 3 | -- http://www.phpmyadmin.net |
||
| 4 | -- |
||
| 5 | -- Host: localhost |
||
| 6 | -- Erstellungszeit: 21. Feb 2016 um 03:49 |
||
| 7 | -- Server Version: 5.5.44-0+deb8u1 |
||
| 8 | -- PHP-Version: 5.6.17-0+deb8u1 |
||
| 9 | |||
| 10 | SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |
||
| 11 | SET time_zone = "+00:00"; |
||
| 12 | |||
| 13 | |||
| 14 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
||
| 15 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
||
| 16 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
||
| 17 | /*!40101 SET NAMES utf8 */; |
||
| 18 | |||
| 19 | -- |
||
| 20 | -- Datenbank: `bugtracker` |
||
| 21 | -- |
||
| 22 | |||
| 23 | -- -------------------------------------------------------- |
||
| 24 | |||
| 25 | -- |
||
| 26 | -- Tabellenstruktur für Tabelle `bugs` |
||
| 27 | -- |
||
| 28 | |||
| 29 | CREATE TABLE IF NOT EXISTS `bugs` ( |
||
| 30 | `id` INT(11) NOT NULL, |
||
| 31 | `titel` VARCHAR(255) NOT NULL, |
||
| 32 | `beschreibung` longtext NOT NULL, |
||
| 33 | `erstellt` datetime DEFAULT NULL, |
||
| 34 | `wichtigkeit` INT(11) NOT NULL DEFAULT '5', |
||
| 35 | `erfasser` INT(11) DEFAULT NULL, |
||
| 36 | `bearbeiter` INT(11) DEFAULT NULL, |
||
| 37 | `fixdatum` datetime DEFAULT NULL, |
||
| 38 | `version_release` INT(11) NOT NULL, |
||
| 39 | `version_agenda` INT(11) NOT NULL, |
||
| 40 | `modul` INT(11) NOT NULL, |
||
| 41 | `projekt` INT(11) NOT NULL |
||
| 42 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 43 | |||
| 44 | -- -------------------------------------------------------- |
||
| 45 | |||
| 46 | -- |
||
| 47 | -- Tabellenstruktur für Tabelle `mitarbeiter` |
||
| 48 | -- |
||
| 49 | |||
| 50 | CREATE TABLE IF NOT EXISTS `mitarbeiter` ( |
||
| 51 | `id` INT(11) NOT NULL, |
||
| 52 | `name` VARCHAR(255) NOT NULL |
||
| 53 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 54 | |||
| 55 | -- -------------------------------------------------------- |
||
| 56 | |||
| 57 | -- |
||
| 58 | -- Tabellenstruktur für Tabelle `module` |
||
| 59 | -- |
||
| 60 | |||
| 61 | CREATE TABLE IF NOT EXISTS `module` ( |
||
| 62 | `id` INT(11) NOT NULL, |
||
| 63 | `projekt` INT(11) NOT NULL, |
||
| 64 | `modul` VARCHAR(255) NOT NULL |
||
| 65 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 66 | |||
| 67 | -- -------------------------------------------------------- |
||
| 68 | |||
| 69 | -- |
||
| 70 | -- Tabellenstruktur für Tabelle `projekte` |
||
| 71 | -- |
||
| 72 | |||
| 73 | CREATE TABLE IF NOT EXISTS `projekte` ( |
||
| 74 | `id` INT(11) NOT NULL, |
||
| 75 | `projekt` VARCHAR(255) NOT NULL |
||
| 76 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 77 | |||
| 78 | -- -------------------------------------------------------- |
||
| 79 | |||
| 80 | -- |
||
| 81 | -- Tabellenstruktur für Tabelle `versionen` |
||
| 82 | -- |
||
| 83 | |||
| 84 | CREATE TABLE IF NOT EXISTS `versionen` ( |
||
| 85 | `id` INT(11) NOT NULL, |
||
| 86 | `version` VARCHAR(255) NOT NULL, |
||
| 87 | `projekt` INT(11) NOT NULL |
||
| 88 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 89 | |||
| 90 | -- |
||
| 91 | -- Indexes for dumped tables |
||
| 92 | -- |
||
| 93 | |||
| 94 | -- |
||
| 95 | -- Indexes for table `bugs` |
||
| 96 | -- |
||
| 97 | ALTER TABLE `bugs` |
||
| 98 | ADD PRIMARY KEY (`id`); |
||
| 99 | |||
| 100 | -- |
||
| 101 | -- Indexes for table `mitarbeiter` |
||
| 102 | -- |
||
| 103 | ALTER TABLE `mitarbeiter` |
||
| 104 | ADD PRIMARY KEY (`id`); |
||
| 105 | |||
| 106 | -- |
||
| 107 | -- Indexes for table `module` |
||
| 108 | -- |
||
| 109 | ALTER TABLE `module` |
||
| 110 | ADD PRIMARY KEY (`id`); |
||
| 111 | |||
| 112 | -- |
||
| 113 | -- Indexes for table `projekte` |
||
| 114 | -- |
||
| 115 | ALTER TABLE `projekte` |
||
| 116 | ADD PRIMARY KEY (`id`); |
||
| 117 | |||
| 118 | -- |
||
| 119 | -- Indexes for table `versionen` |
||
| 120 | -- |
||
| 121 | ALTER TABLE `versionen` |
||
| 122 | ADD PRIMARY KEY (`id`); |
||
| 123 | |||
| 124 | -- |
||
| 125 | -- AUTO_INCREMENT for dumped tables |
||
| 126 | -- |
||
| 127 | |||
| 128 | -- |
||
| 129 | -- AUTO_INCREMENT for table `bugs` |
||
| 130 | -- |
||
| 131 | ALTER TABLE `bugs` |
||
| 132 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 133 | -- |
||
| 134 | -- AUTO_INCREMENT for table `mitarbeiter` |
||
| 135 | -- |
||
| 136 | ALTER TABLE `mitarbeiter` |
||
| 137 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 138 | -- |
||
| 139 | -- AUTO_INCREMENT for table `module` |
||
| 140 | -- |
||
| 141 | ALTER TABLE `module` |
||
| 142 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 143 | -- |
||
| 144 | -- AUTO_INCREMENT for table `projekte` |
||
| 145 | -- |
||
| 146 | ALTER TABLE `projekte` |
||
| 147 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 148 | -- |
||
| 149 | -- AUTO_INCREMENT for table `versionen` |
||
| 150 | -- |
||
| 151 | ALTER TABLE `versionen` |
||
| 152 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 153 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
||
| 154 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
||
| 155 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
||
| 156 |