Rev 6 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 6 | Rev 11 | ||
---|---|---|---|
Line 1... | Line -... | ||
1 | -- phpMyAdmin SQL Dump |
- | |
2 | -- version 4.2.0-dev |
- | |
3 | -- http://www.phpmyadmin.net |
- | |
4 | -- |
1 | |
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 | -- |
2 | -- |
26 | -- Tabellenstruktur für Tabelle `bugs` |
3 | -- Tabellenstruktur für Tabelle `bugs` |
27 | -- |
4 | -- |
28 | 5 | ||
29 | CREATE TABLE IF NOT EXISTS `bugs` ( |
6 | CREATE TABLE IF NOT EXISTS `bugs` ( |
30 | `id` INT(11) NOT NULL, |
7 | `id` INT(11) NOT NULL, |
31 | `titel` VARCHAR(255) NOT NULL, |
8 | `titel` VARCHAR(255) NOT NULL, |
32 | `beschreibung` longtext NOT NULL, |
9 | `beschreibung` longtext NOT NULL, |
33 | `erstellt` datetime DEFAULT NULL, |
10 | `erstellt` datetime DEFAULT NULL, |
34 | `wichtigkeit` INT(11) NOT NULL DEFAULT '5', |
11 | `wichtigkeit` INT(11) NOT NULL DEFAULT '5', |
35 | `erfasser` INT(11) DEFAULT NULL, |
12 | `erfasser` INT(11) DEFAULT NOT NULL, |
36 | `bearbeiter` INT(11) DEFAULT NULL, |
13 | `bearbeiter` INT(11) DEFAULT NULL, |
- | 14 | `status` INT(11) NOT NULL DEFAULT '1', |
|
37 | `fixdatum` datetime DEFAULT NULL, |
15 | `status_geandert` datetime DEFAULT NULL, |
38 | `version_release` INT(11) NOT NULL, |
16 | `version_release` INT(11) NOT NULL, |
39 | `version_agenda` INT(11) NOT NULL, |
17 | `version_agenda` INT(11) NOT NULL, |
40 | `modul` INT(11) NOT NULL, |
18 | `modul` INT(11) NOT NULL, |
41 | `projekt` INT(11) NOT NULL |
19 | `projekt` INT(11) NOT NULL |
42 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
20 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
Line 86... | Line 64... | ||
86 | `version` VARCHAR(255) NOT NULL, |
64 | `version` VARCHAR(255) NOT NULL, |
87 | `projekt` INT(11) NOT NULL |
65 | `projekt` INT(11) NOT NULL |
88 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
66 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
89 | 67 | ||
90 | -- |
68 | -- |
91 | -- Indexes for dumped tables |
69 | -- Tabellenstruktur für Tabelle `lkp_status` |
92 | -- |
70 | -- |
93 | 71 | ||
- | 72 | CREATE TABLE IF NOT EXISTS `lkp_status` ( |
|
- | 73 | `id` INT(11) NOT NULL, |
|
- | 74 | `status` VARCHAR(255) NOT NULL |
|
- | 75 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; |
|
- | 76 | ||
94 | -- |
77 | -- |
95 | -- Indexes for table `bugs` |
78 | -- Indexes for dumped tables |
96 | -- |
79 | -- |
- | 80 | ||
97 | ALTER TABLE `bugs` |
81 | ALTER TABLE `bugs` |
98 | ADD PRIMARY KEY (`id`); |
82 | ADD PRIMARY KEY (`id`); |
99 | 83 | ||
100 | -- |
- | |
101 | -- Indexes for table `mitarbeiter` |
- | |
102 | -- |
- | |
103 | ALTER TABLE `mitarbeiter` |
84 | ALTER TABLE `mitarbeiter` |
104 | ADD PRIMARY KEY (`id`); |
85 | ADD PRIMARY KEY (`id`); |
105 | 86 | ||
106 | -- |
- | |
107 | -- Indexes for table `module` |
- | |
108 | -- |
- | |
109 | ALTER TABLE `module` |
87 | ALTER TABLE `module` |
110 | ADD PRIMARY KEY (`id`); |
88 | ADD PRIMARY KEY (`id`); |
111 | 89 | ||
112 | -- |
- | |
113 | -- Indexes for table `projekte` |
- | |
114 | -- |
- | |
115 | ALTER TABLE `projekte` |
90 | ALTER TABLE `projekte` |
116 | ADD PRIMARY KEY (`id`); |
91 | ADD PRIMARY KEY (`id`); |
117 | 92 | ||
118 | -- |
- | |
119 | -- Indexes for table `versionen` |
- | |
120 | -- |
- | |
121 | ALTER TABLE `versionen` |
93 | ALTER TABLE `versionen` |
122 | ADD PRIMARY KEY (`id`); |
94 | ADD PRIMARY KEY (`id`); |
123 | 95 | ||
- | 96 | ALTER TABLE `lkp_status` |
|
- | 97 | ADD PRIMARY KEY (`id`); |
|
- | 98 | ||
124 | -- |
99 | -- |
125 | -- AUTO_INCREMENT for dumped tables |
100 | -- AUTO_INCREMENT for dumped tables |
126 | -- |
101 | -- |
127 | 102 | ||
128 | -- |
- | |
129 | -- AUTO_INCREMENT for table `bugs` |
- | |
130 | -- |
- | |
131 | ALTER TABLE `bugs` |
103 | ALTER TABLE `bugs` |
132 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
104 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
133 | -- |
- | |
134 | -- AUTO_INCREMENT for table `mitarbeiter` |
- | |
135 | -- |
105 | |
136 | ALTER TABLE `mitarbeiter` |
106 | ALTER TABLE `mitarbeiter` |
137 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
107 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
138 | -- |
- | |
139 | -- AUTO_INCREMENT for table `module` |
- | |
140 | -- |
108 | |
141 | ALTER TABLE `module` |
109 | ALTER TABLE `module` |
142 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
110 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
143 | -- |
- | |
144 | -- AUTO_INCREMENT for table `projekte` |
- | |
145 | -- |
111 | |
146 | ALTER TABLE `projekte` |
112 | ALTER TABLE `projekte` |
147 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
113 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
148 | -- |
- | |
149 | -- AUTO_INCREMENT for table `versionen` |
- | |
150 | -- |
114 | |
151 | ALTER TABLE `versionen` |
115 | ALTER TABLE `versionen` |
152 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
116 | 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 | 117 | ||
- | 118 | ALTER TABLE `lkp_status` |
|
- | 119 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
|
- | 120 | ||
- | 121 | -- |
|
- | 122 | -- Daten für Tabelle `lkp_status` |
|
- | 123 | -- |
|
- | 124 | ||
- | 125 | INSERT INTO `lkp_status` (`id`, `status`) VALUES |
|
- | 126 | (1, 'Offen'), |
|
- | 127 | (2, 'Abgelehnt'), |
|
- | 128 | (3, 'In Arbeit'), |
|
- | 129 | (4, 'Abgeschlossen'), |
|
- | 130 | (5, 'Veröffentlicht'); |