Rev 11 | Only display areas with differences | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 11 | Rev 14 | ||
|---|---|---|---|
| 1 | |
1 | |
| 2 | -- |
2 | -- |
| 3 | -- Tabellenstruktur für Tabelle `bugs` |
3 | -- Tabellenstruktur für Tabelle `bugs` |
| 4 | -- |
4 | -- |
| 5 | 5 | ||
| 6 | CREATE TABLE IF NOT EXISTS `bugs` ( |
6 | CREATE TABLE IF NOT EXISTS `bugs` ( |
| 7 | `id` INT(11) NOT NULL, |
7 | `id` INT(11) NOT NULL, |
| 8 | `titel` VARCHAR(255) NOT NULL, |
8 | `titel` VARCHAR(255) NOT NULL, |
| 9 | `beschreibung` longtext NOT NULL, |
9 | `beschreibung` longtext NOT NULL, |
| 10 | `erstellt` datetime DEFAULT NULL, |
10 | `erstellt` datetime DEFAULT NULL, |
| 11 | `wichtigkeit` INT(11) NOT NULL DEFAULT '5', |
11 | `wichtigkeit` INT(11) NOT NULL DEFAULT '5', |
| 12 | `erfasser` INT(11) DEFAULT NOT NULL, |
12 | `erfasser` INT(11) DEFAULT NOT NULL, |
| 13 | `bearbeiter` INT(11) DEFAULT NULL, |
13 | `bearbeiter` INT(11) DEFAULT NULL, |
| 14 | `status` INT(11) NOT NULL DEFAULT '1', |
14 | `status` INT(11) NOT NULL DEFAULT '1', |
| 15 | `status_geandert` datetime DEFAULT NULL, |
15 | `status_geandert` datetime DEFAULT NULL, |
| 16 | `version_release` INT(11) NOT NULL, |
16 | `version_release` INT(11) NOT NULL, |
| 17 | `version_agenda` INT(11) NOT NULL, |
17 | `version_agenda` INT(11) NOT NULL, |
| 18 | `modul` INT(11) NOT NULL, |
18 | `modul` INT(11) NOT NULL, |
| 19 | `projekt` INT(11) NOT NULL |
19 | `projekt` INT(11) NOT NULL |
| 20 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
20 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 21 | 21 | ||
| 22 | -- -------------------------------------------------------- |
22 | -- -------------------------------------------------------- |
| 23 | 23 | ||
| 24 | -- |
24 | -- |
| 25 | -- Tabellenstruktur für Tabelle `mitarbeiter` |
25 | -- Tabellenstruktur für Tabelle `mitarbeiter` |
| 26 | -- |
26 | -- |
| 27 | 27 | ||
| 28 | CREATE TABLE IF NOT EXISTS `mitarbeiter` ( |
28 | CREATE TABLE IF NOT EXISTS `mitarbeiter` ( |
| 29 | `id` INT(11) NOT NULL, |
29 | `id` INT(11) NOT NULL, |
| 30 | `name` VARCHAR(255) NOT NULL |
30 | `name` VARCHAR(255) NOT NULL |
| 31 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
31 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 32 | 32 | ||
| 33 | -- -------------------------------------------------------- |
33 | -- -------------------------------------------------------- |
| 34 | 34 | ||
| 35 | -- |
35 | -- |
| 36 | -- Tabellenstruktur für Tabelle `module` |
36 | -- Tabellenstruktur für Tabelle `module` |
| 37 | -- |
37 | -- |
| 38 | 38 | ||
| 39 | CREATE TABLE IF NOT EXISTS `module` ( |
39 | CREATE TABLE IF NOT EXISTS `module` ( |
| 40 | `id` INT(11) NOT NULL, |
40 | `id` INT(11) NOT NULL, |
| 41 | `projekt` INT(11) NOT NULL, |
41 | `projekt` INT(11) NOT NULL, |
| 42 | `modul` VARCHAR(255) NOT NULL |
42 | `modul` VARCHAR(255) NOT NULL |
| 43 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
43 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 44 | 44 | ||
| 45 | -- -------------------------------------------------------- |
45 | -- -------------------------------------------------------- |
| 46 | 46 | ||
| 47 | -- |
47 | -- |
| 48 | -- Tabellenstruktur für Tabelle `projekte` |
48 | -- Tabellenstruktur für Tabelle `projekte` |
| 49 | -- |
49 | -- |
| 50 | 50 | ||
| 51 | CREATE TABLE IF NOT EXISTS `projekte` ( |
51 | CREATE TABLE IF NOT EXISTS `projekte` ( |
| 52 | `id` INT(11) NOT NULL, |
52 | `id` INT(11) NOT NULL, |
| 53 | `projekt` VARCHAR(255) NOT NULL |
53 | `projekt` VARCHAR(255) NOT NULL |
| 54 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
54 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 55 | 55 | ||
| 56 | -- -------------------------------------------------------- |
56 | -- -------------------------------------------------------- |
| 57 | 57 | ||
| 58 | -- |
58 | -- |
| 59 | -- Tabellenstruktur für Tabelle `versionen` |
59 | -- Tabellenstruktur für Tabelle `versionen` |
| 60 | -- |
60 | -- |
| 61 | 61 | ||
| 62 | CREATE TABLE IF NOT EXISTS `versionen` ( |
62 | CREATE TABLE IF NOT EXISTS `versionen` ( |
| 63 | `id` INT(11) NOT NULL, |
63 | `id` INT(11) NOT NULL, |
| 64 | `version` VARCHAR(255) NOT NULL, |
64 | `version` VARCHAR(255) NOT NULL, |
| 65 | `projekt` INT(11) NOT NULL |
65 | `projekt` INT(11) NOT NULL |
| 66 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
66 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
| 67 | 67 | ||
| 68 | -- |
68 | -- |
| 69 | -- Tabellenstruktur für Tabelle `lkp_status` |
69 | -- Tabellenstruktur für Tabelle `lkp_status` |
| 70 | -- |
70 | -- |
| 71 | 71 | ||
| 72 | CREATE TABLE IF NOT EXISTS `lkp_status` ( |
72 | CREATE TABLE IF NOT EXISTS `lkp_status` ( |
| 73 | `id` INT(11) NOT NULL, |
73 | `id` INT(11) NOT NULL, |
| 74 | `status` VARCHAR(255) NOT NULL |
74 | `status` VARCHAR(255) NOT NULL, |
| - | 75 | `color` INT(11) NOT NULL |
|
| 75 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; |
76 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; |
| 76 | 77 | ||
| 77 | -- |
78 | -- |
| 78 | -- Indexes for dumped tables |
79 | -- Indexes for dumped tables |
| 79 | -- |
80 | -- |
| 80 | 81 | ||
| 81 | ALTER TABLE `bugs` |
82 | ALTER TABLE `bugs` |
| 82 | ADD PRIMARY KEY (`id`); |
83 | ADD PRIMARY KEY (`id`); |
| 83 | 84 | ||
| 84 | ALTER TABLE `mitarbeiter` |
85 | ALTER TABLE `mitarbeiter` |
| 85 | ADD PRIMARY KEY (`id`); |
86 | ADD PRIMARY KEY (`id`); |
| 86 | 87 | ||
| 87 | ALTER TABLE `module` |
88 | ALTER TABLE `module` |
| 88 | ADD PRIMARY KEY (`id`); |
89 | ADD PRIMARY KEY (`id`); |
| 89 | 90 | ||
| 90 | ALTER TABLE `projekte` |
91 | ALTER TABLE `projekte` |
| 91 | ADD PRIMARY KEY (`id`); |
92 | ADD PRIMARY KEY (`id`); |
| 92 | 93 | ||
| 93 | ALTER TABLE `versionen` |
94 | ALTER TABLE `versionen` |
| 94 | ADD PRIMARY KEY (`id`); |
95 | ADD PRIMARY KEY (`id`); |
| 95 | 96 | ||
| 96 | ALTER TABLE `lkp_status` |
97 | ALTER TABLE `lkp_status` |
| 97 | ADD PRIMARY KEY (`id`); |
98 | ADD PRIMARY KEY (`id`); |
| 98 | 99 | ||
| 99 | -- |
100 | -- |
| 100 | -- AUTO_INCREMENT for dumped tables |
101 | -- AUTO_INCREMENT for dumped tables |
| 101 | -- |
102 | -- |
| 102 | 103 | ||
| 103 | ALTER TABLE `bugs` |
104 | ALTER TABLE `bugs` |
| 104 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
105 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
| 105 | 106 | ||
| 106 | ALTER TABLE `mitarbeiter` |
107 | ALTER TABLE `mitarbeiter` |
| 107 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
108 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
| 108 | 109 | ||
| 109 | ALTER TABLE `module` |
110 | ALTER TABLE `module` |
| 110 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
111 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
| 111 | 112 | ||
| 112 | ALTER TABLE `projekte` |
113 | ALTER TABLE `projekte` |
| 113 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
114 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
| 114 | 115 | ||
| 115 | ALTER TABLE `versionen` |
116 | ALTER TABLE `versionen` |
| 116 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
117 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
| 117 | 118 | ||
| 118 | ALTER TABLE `lkp_status` |
119 | ALTER TABLE `lkp_status` |
| 119 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
120 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
| 120 | 121 | ||
| 121 | -- |
122 | -- |
| 122 | -- Daten für Tabelle `lkp_status` |
123 | -- Daten für Tabelle `lkp_status` |
| 123 | -- |
124 | -- |
| 124 | 125 | ||
| 125 | INSERT INTO `lkp_status` (`id`, `status`) VALUES |
126 | INSERT INTO `lkp_status` (`id`, `status`) VALUES |
| 126 | (1, 'Offen'), |
127 | (1, 'Offen', 255), |
| 127 | (2, 'Abgelehnt'), |
128 | (2, 'Abgelehnt', 128), |
| 128 | (3, 'In Arbeit'), |
129 | (3, 'In Arbeit', 8388736), |
| 129 | (4, 'Abgeschlossen'), |
130 | (4, 'Abgeschlossen', 8421376), |
| 130 | (5, 'Veröffentlicht'); |
131 | (5, 'Veröffentlicht', 32768); |
| 131 | 132 | ||