Rev 11 | Go to most recent revision | Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 6 | daniel-mar | 1 | |
| 2 | CREATE TABLE [dbo].[bugs]( |
||
| 3 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
| 4 | [titel] [VARCHAR](255) NULL, |
||
| 5 | [beschreibung] [text] NULL, |
||
| 6 | [erstellt] [datetime] NOT NULL, |
||
| 7 | [wichtigkeit] [INT] NOT NULL, |
||
| 8 | [erfasser] [INT] NOT NULL, |
||
| 9 | [bearbeiter] [INT] NULL, |
||
| 10 | [fixdatum] [datetime] NULL, |
||
| 11 | [version_release] [INT] NULL, |
||
| 12 | [version_agenda] [INT] NULL, |
||
| 13 | [modul] [INT] NULL, |
||
| 14 | [projekt] [INT] NOT NULL |
||
| 15 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
||
| 16 | ALTER TABLE [dbo].[bugs] ADD CONSTRAINT [DF_bugs_wichtigkeit] DEFAULT ((5)) FOR [wichtigkeit] |
||
| 17 | |||
| 18 | CREATE TABLE [dbo].[mitarbeiter]( |
||
| 19 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
| 20 | [name] [VARCHAR](255) NULL |
||
| 21 | ) ON [PRIMARY] |
||
| 22 | |||
| 23 | CREATE TABLE [dbo].[module]( |
||
| 24 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
| 25 | [modul] [VARCHAR](255) NULL, |
||
| 26 | [projekt] [INT] NOT NULL |
||
| 27 | ) ON [PRIMARY] |
||
| 28 | |||
| 29 | CREATE TABLE [dbo].[projekte]( |
||
| 30 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
| 31 | [projekt] [VARCHAR](255) NULL |
||
| 32 | ) ON [PRIMARY] |
||
| 33 | |||
| 34 | CREATE TABLE [dbo].[versionen]( |
||
| 35 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
| 36 | [version] [VARCHAR](255) NULL, |
||
| 37 | [projekt] [INT] NOT NULL |
||
| 38 | ) ON [PRIMARY] |