Rev 6 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 11 | daniel-mar | 1 | |
| 6 | daniel-mar | 2 | -- |
| 3 | -- Tabellenstruktur für Tabelle `bugs` |
||
| 4 | -- |
||
| 5 | |||
| 6 | CREATE TABLE IF NOT EXISTS `bugs` ( |
||
| 7 | `id` INT(11) NOT NULL, |
||
| 8 | `titel` VARCHAR(255) NOT NULL, |
||
| 9 | `beschreibung` longtext NOT NULL, |
||
| 10 | `erstellt` datetime DEFAULT NULL, |
||
| 11 | `wichtigkeit` INT(11) NOT NULL DEFAULT '5', |
||
| 11 | daniel-mar | 12 | `erfasser` INT(11) DEFAULT NOT NULL, |
| 6 | daniel-mar | 13 | `bearbeiter` INT(11) DEFAULT NULL, |
| 11 | daniel-mar | 14 | `status` INT(11) NOT NULL DEFAULT '1', |
| 15 | `status_geandert` datetime DEFAULT NULL, |
||
| 6 | daniel-mar | 16 | `version_release` INT(11) NOT NULL, |
| 17 | `version_agenda` INT(11) NOT NULL, |
||
| 18 | `modul` INT(11) NOT NULL, |
||
| 19 | `projekt` INT(11) NOT NULL |
||
| 20 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 21 | |||
| 22 | -- -------------------------------------------------------- |
||
| 23 | |||
| 24 | -- |
||
| 25 | -- Tabellenstruktur für Tabelle `mitarbeiter` |
||
| 26 | -- |
||
| 27 | |||
| 28 | CREATE TABLE IF NOT EXISTS `mitarbeiter` ( |
||
| 29 | `id` INT(11) NOT NULL, |
||
| 30 | `name` VARCHAR(255) NOT NULL |
||
| 31 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 32 | |||
| 33 | -- -------------------------------------------------------- |
||
| 34 | |||
| 35 | -- |
||
| 36 | -- Tabellenstruktur für Tabelle `module` |
||
| 37 | -- |
||
| 38 | |||
| 39 | CREATE TABLE IF NOT EXISTS `module` ( |
||
| 40 | `id` INT(11) NOT NULL, |
||
| 41 | `projekt` INT(11) NOT NULL, |
||
| 42 | `modul` VARCHAR(255) NOT NULL |
||
| 43 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 44 | |||
| 45 | -- -------------------------------------------------------- |
||
| 46 | |||
| 47 | -- |
||
| 48 | -- Tabellenstruktur für Tabelle `projekte` |
||
| 49 | -- |
||
| 50 | |||
| 51 | CREATE TABLE IF NOT EXISTS `projekte` ( |
||
| 52 | `id` INT(11) NOT NULL, |
||
| 53 | `projekt` VARCHAR(255) NOT NULL |
||
| 54 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 55 | |||
| 56 | -- -------------------------------------------------------- |
||
| 57 | |||
| 58 | -- |
||
| 59 | -- Tabellenstruktur für Tabelle `versionen` |
||
| 60 | -- |
||
| 61 | |||
| 62 | CREATE TABLE IF NOT EXISTS `versionen` ( |
||
| 63 | `id` INT(11) NOT NULL, |
||
| 64 | `version` VARCHAR(255) NOT NULL, |
||
| 65 | `projekt` INT(11) NOT NULL |
||
| 66 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |
||
| 67 | |||
| 68 | -- |
||
| 11 | daniel-mar | 69 | -- Tabellenstruktur für Tabelle `lkp_status` |
| 6 | daniel-mar | 70 | -- |
| 71 | |||
| 11 | daniel-mar | 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 | |||
| 6 | daniel-mar | 77 | -- |
| 11 | daniel-mar | 78 | -- Indexes for dumped tables |
| 6 | daniel-mar | 79 | -- |
| 11 | daniel-mar | 80 | |
| 6 | daniel-mar | 81 | ALTER TABLE `bugs` |
| 82 | ADD PRIMARY KEY (`id`); |
||
| 83 | |||
| 84 | ALTER TABLE `mitarbeiter` |
||
| 85 | ADD PRIMARY KEY (`id`); |
||
| 86 | |||
| 87 | ALTER TABLE `module` |
||
| 88 | ADD PRIMARY KEY (`id`); |
||
| 89 | |||
| 90 | ALTER TABLE `projekte` |
||
| 91 | ADD PRIMARY KEY (`id`); |
||
| 92 | |||
| 93 | ALTER TABLE `versionen` |
||
| 94 | ADD PRIMARY KEY (`id`); |
||
| 95 | |||
| 11 | daniel-mar | 96 | ALTER TABLE `lkp_status` |
| 97 | ADD PRIMARY KEY (`id`); |
||
| 98 | |||
| 6 | daniel-mar | 99 | -- |
| 100 | -- AUTO_INCREMENT for dumped tables |
||
| 101 | -- |
||
| 102 | |||
| 103 | ALTER TABLE `bugs` |
||
| 104 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 11 | daniel-mar | 105 | |
| 6 | daniel-mar | 106 | ALTER TABLE `mitarbeiter` |
| 107 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 11 | daniel-mar | 108 | |
| 6 | daniel-mar | 109 | ALTER TABLE `module` |
| 110 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 11 | daniel-mar | 111 | |
| 6 | daniel-mar | 112 | ALTER TABLE `projekte` |
| 113 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 11 | daniel-mar | 114 | |
| 6 | daniel-mar | 115 | ALTER TABLE `versionen` |
| 116 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 117 | |||
| 11 | daniel-mar | 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'); |