Rev 6 | Rev 12 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 6 | Rev 11 | ||
---|---|---|---|
Line 5... | Line 5... | ||
5 | [beschreibung] [text] NULL, |
5 | [beschreibung] [text] NULL, |
6 | [erstellt] [datetime] NOT NULL, |
6 | [erstellt] [datetime] NOT NULL, |
7 | [wichtigkeit] [INT] NOT NULL, |
7 | [wichtigkeit] [INT] NOT NULL, |
8 | [erfasser] [INT] NOT NULL, |
8 | [erfasser] [INT] NOT NULL, |
9 | [bearbeiter] [INT] NULL, |
9 | [bearbeiter] [INT] NULL, |
- | 10 | [STATUS] [INT] NOT NULL, |
|
10 | [fixdatum] [datetime] NULL, |
11 | [status_geandert] [datetime] NULL, |
11 | [version_release] [INT] NULL, |
12 | [version_release] [INT] NULL, |
12 | [version_agenda] [INT] NULL, |
13 | [version_agenda] [INT] NULL, |
13 | [modul] [INT] NULL, |
14 | [modul] [INT] NULL, |
14 | [projekt] [INT] NOT NULL |
15 | [projekt] [INT] NOT NULL |
15 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
16 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
16 | ALTER TABLE [dbo].[bugs] ADD CONSTRAINT [DF_bugs_wichtigkeit] DEFAULT ((5)) FOR [wichtigkeit] |
17 | ALTER TABLE [dbo].[bugs] ADD CONSTRAINT [DF_bugs_wichtigkeit] DEFAULT ((5)) FOR [wichtigkeit] |
- | 18 | ALTER TABLE [dbo].[bugs] ADD CONSTRAINT [DF_bugs_status] DEFAULT ((1)) FOR [STATUS] |
|
17 | 19 | ||
18 | CREATE TABLE [dbo].[mitarbeiter]( |
20 | CREATE TABLE [dbo].[mitarbeiter]( |
19 | [id] [INT] IDENTITY(1,1) NOT NULL, |
21 | [id] [INT] IDENTITY(1,1) NOT NULL, |
20 | [name] [VARCHAR](255) NULL |
22 | [name] [VARCHAR](255) NULL |
21 | ) ON [PRIMARY] |
23 | ) ON [PRIMARY] |
Line 34... | Line 36... | ||
34 | CREATE TABLE [dbo].[versionen]( |
36 | CREATE TABLE [dbo].[versionen]( |
35 | [id] [INT] IDENTITY(1,1) NOT NULL, |
37 | [id] [INT] IDENTITY(1,1) NOT NULL, |
36 | [version] [VARCHAR](255) NULL, |
38 | [version] [VARCHAR](255) NULL, |
37 | [projekt] [INT] NOT NULL |
39 | [projekt] [INT] NOT NULL |
38 | ) ON [PRIMARY] |
40 | ) ON [PRIMARY] |
- | 41 | ||
- | 42 | CREATE TABLE [dbo].[lkp_status]( |
|
- | 43 | [id] [INT] IDENTITY(1,1) NOT NULL, |
|
- | 44 | [STATUS] [VARCHAR](255) NULL |
|
- | 45 | ) ON [PRIMARY] |