Rev 2 | Rev 11 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 2 | Rev 6 | ||
|---|---|---|---|
| Line 27... | Line 27... | ||
| 27 | -- |
27 | -- |
| 28 | 28 | ||
| 29 | CREATE TABLE IF NOT EXISTS `bugs` ( |
29 | CREATE TABLE IF NOT EXISTS `bugs` ( |
| 30 | `id` INT(11) NOT NULL, |
30 | `id` INT(11) NOT NULL, |
| 31 | `titel` VARCHAR(255) NOT NULL, |
31 | `titel` VARCHAR(255) NOT NULL, |
| 32 | `beschreibung` text NOT NULL, |
32 | `beschreibung` longtext NOT NULL, |
| 33 | `erstellt` datetime DEFAULT NULL, |
33 | `erstellt` datetime DEFAULT NULL, |
| 34 | `wichtigkeit` INT(11) NOT NULL DEFAULT '5', |
34 | `wichtigkeit` INT(11) NOT NULL DEFAULT '5', |
| - | 35 | `erfasser` INT(11) DEFAULT NULL, |
|
| 35 | `bearbeiter` INT(11) DEFAULT NULL, |
36 | `bearbeiter` INT(11) DEFAULT NULL, |
| 36 | `fixdatum` datetime DEFAULT NULL, |
37 | `fixdatum` datetime DEFAULT NULL, |
| 37 | `version_release` INT(11) NOT NULL, |
38 | `version_release` INT(11) NOT NULL, |
| - | 39 | `version_agenda` INT(11) NOT NULL, |
|
| 38 | `modul` INT(11) NOT NULL, |
40 | `modul` INT(11) NOT NULL, |
| 39 | `projekt` INT(11) NOT NULL |
41 | `projekt` INT(11) NOT NULL |
| 40 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
42 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 41 | 43 | ||
| 42 | -- -------------------------------------------------------- |
44 | -- -------------------------------------------------------- |
| 43 | 45 | ||
| 44 | -- |
46 | -- |
| 45 | -- Tabellenstruktur für Tabelle `mitarbeiter` |
47 | -- Tabellenstruktur für Tabelle `mitarbeiter` |
| 46 | -- |
48 | -- |
| 47 | 49 | ||
| 48 | CREATE TABLE IF NOT EXISTS `mitarbeiter` ( |
50 | CREATE TABLE IF NOT EXISTS `mitarbeiter` ( |
| 49 | `id` INT(11) NOT NULL, |
51 | `id` INT(11) NOT NULL, |
| 50 | `name` VARCHAR(255) NOT NULL |
52 | `name` VARCHAR(255) NOT NULL |
| 51 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
53 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 52 | 54 | ||
| 53 | -- -------------------------------------------------------- |
55 | -- -------------------------------------------------------- |
| 54 | 56 | ||
| 55 | -- |
57 | -- |
| 56 | -- Tabellenstruktur für Tabelle `module` |
58 | -- Tabellenstruktur für Tabelle `module` |
| Line 58... | Line 60... | ||
| 58 | 60 | ||
| 59 | CREATE TABLE IF NOT EXISTS `module` ( |
61 | CREATE TABLE IF NOT EXISTS `module` ( |
| 60 | `id` INT(11) NOT NULL, |
62 | `id` INT(11) NOT NULL, |
| 61 | `projekt` INT(11) NOT NULL, |
63 | `projekt` INT(11) NOT NULL, |
| 62 | `modul` VARCHAR(255) NOT NULL |
64 | `modul` VARCHAR(255) NOT NULL |
| 63 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
65 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 64 | 66 | ||
| 65 | -- -------------------------------------------------------- |
67 | -- -------------------------------------------------------- |
| 66 | 68 | ||
| 67 | -- |
69 | -- |
| 68 | -- Tabellenstruktur für Tabelle `projekte` |
70 | -- Tabellenstruktur für Tabelle `projekte` |
| 69 | -- |
71 | -- |
| 70 | 72 | ||
| 71 | CREATE TABLE IF NOT EXISTS `projekte` ( |
73 | CREATE TABLE IF NOT EXISTS `projekte` ( |
| 72 | `id` INT(11) NOT NULL, |
74 | `id` INT(11) NOT NULL, |
| 73 | `projekt` VARCHAR(255) NOT NULL |
75 | `projekt` VARCHAR(255) NOT NULL |
| 74 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
76 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 75 | 77 | ||
| 76 | -- -------------------------------------------------------- |
78 | -- -------------------------------------------------------- |
| 77 | 79 | ||
| 78 | -- |
80 | -- |
| 79 | -- Tabellenstruktur für Tabelle `versionen` |
81 | -- Tabellenstruktur für Tabelle `versionen` |
| Line 81... | Line 83... | ||
| 81 | 83 | ||
| 82 | CREATE TABLE IF NOT EXISTS `versionen` ( |
84 | CREATE TABLE IF NOT EXISTS `versionen` ( |
| 83 | `id` INT(11) NOT NULL, |
85 | `id` INT(11) NOT NULL, |
| 84 | `version` VARCHAR(255) NOT NULL, |
86 | `version` VARCHAR(255) NOT NULL, |
| 85 | `projekt` INT(11) NOT NULL |
87 | `projekt` INT(11) NOT NULL |
| 86 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; |
88 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 87 | 89 | ||
| 88 | -- |
90 | -- |
| 89 | -- Indexes for dumped tables |
91 | -- Indexes for dumped tables |
| 90 | -- |
92 | -- |
| 91 | 93 | ||
| Line 149... | Line 151... | ||
| 149 | ALTER TABLE `versionen` |
151 | ALTER TABLE `versionen` |
| 150 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
152 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
| 151 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
153 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
| 152 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
154 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
| 153 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
155 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
| - | 156 | ||