Go to most recent revision | Details | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
2 | 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` text NOT NULL, |
||
33 | `erstellt` datetime DEFAULT NULL, |
||
34 | `wichtigkeit` INT(11) NOT NULL DEFAULT '5', |
||
35 | `bearbeiter` INT(11) DEFAULT NULL, |
||
36 | `fixdatum` datetime DEFAULT NULL, |
||
37 | `version_release` INT(11) NOT NULL, |
||
38 | `modul` INT(11) NOT NULL, |
||
39 | `projekt` INT(11) NOT NULL |
||
40 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
||
41 | |||
42 | -- -------------------------------------------------------- |
||
43 | |||
44 | -- |
||
45 | -- Tabellenstruktur für Tabelle `mitarbeiter` |
||
46 | -- |
||
47 | |||
48 | CREATE TABLE IF NOT EXISTS `mitarbeiter` ( |
||
49 | `id` INT(11) NOT NULL, |
||
50 | `name` VARCHAR(255) NOT NULL |
||
51 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
||
52 | |||
53 | -- -------------------------------------------------------- |
||
54 | |||
55 | -- |
||
56 | -- Tabellenstruktur für Tabelle `module` |
||
57 | -- |
||
58 | |||
59 | CREATE TABLE IF NOT EXISTS `module` ( |
||
60 | `id` INT(11) NOT NULL, |
||
61 | `projekt` INT(11) NOT NULL, |
||
62 | `modul` VARCHAR(255) NOT NULL |
||
63 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
||
64 | |||
65 | -- -------------------------------------------------------- |
||
66 | |||
67 | -- |
||
68 | -- Tabellenstruktur für Tabelle `projekte` |
||
69 | -- |
||
70 | |||
71 | CREATE TABLE IF NOT EXISTS `projekte` ( |
||
72 | `id` INT(11) NOT NULL, |
||
73 | `projekt` VARCHAR(255) NOT NULL |
||
74 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
||
75 | |||
76 | -- -------------------------------------------------------- |
||
77 | |||
78 | -- |
||
79 | -- Tabellenstruktur für Tabelle `versionen` |
||
80 | -- |
||
81 | |||
82 | CREATE TABLE IF NOT EXISTS `versionen` ( |
||
83 | `id` INT(11) NOT NULL, |
||
84 | `version` VARCHAR(255) NOT NULL, |
||
85 | `projekt` INT(11) NOT NULL |
||
86 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
||
87 | |||
88 | -- |
||
89 | -- Indexes for dumped tables |
||
90 | -- |
||
91 | |||
92 | -- |
||
93 | -- Indexes for table `bugs` |
||
94 | -- |
||
95 | ALTER TABLE `bugs` |
||
96 | ADD PRIMARY KEY (`id`); |
||
97 | |||
98 | -- |
||
99 | -- Indexes for table `mitarbeiter` |
||
100 | -- |
||
101 | ALTER TABLE `mitarbeiter` |
||
102 | ADD PRIMARY KEY (`id`); |
||
103 | |||
104 | -- |
||
105 | -- Indexes for table `module` |
||
106 | -- |
||
107 | ALTER TABLE `module` |
||
108 | ADD PRIMARY KEY (`id`); |
||
109 | |||
110 | -- |
||
111 | -- Indexes for table `projekte` |
||
112 | -- |
||
113 | ALTER TABLE `projekte` |
||
114 | ADD PRIMARY KEY (`id`); |
||
115 | |||
116 | -- |
||
117 | -- Indexes for table `versionen` |
||
118 | -- |
||
119 | ALTER TABLE `versionen` |
||
120 | ADD PRIMARY KEY (`id`); |
||
121 | |||
122 | -- |
||
123 | -- AUTO_INCREMENT for dumped tables |
||
124 | -- |
||
125 | |||
126 | -- |
||
127 | -- AUTO_INCREMENT for table `bugs` |
||
128 | -- |
||
129 | ALTER TABLE `bugs` |
||
130 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
131 | -- |
||
132 | -- AUTO_INCREMENT for table `mitarbeiter` |
||
133 | -- |
||
134 | ALTER TABLE `mitarbeiter` |
||
135 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
136 | -- |
||
137 | -- AUTO_INCREMENT for table `module` |
||
138 | -- |
||
139 | ALTER TABLE `module` |
||
140 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
141 | -- |
||
142 | -- AUTO_INCREMENT for table `projekte` |
||
143 | -- |
||
144 | ALTER TABLE `projekte` |
||
145 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
146 | -- |
||
147 | -- AUTO_INCREMENT for table `versionen` |
||
148 | -- |
||
149 | ALTER TABLE `versionen` |
||
150 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
151 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
||
152 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
||
153 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |