Rev 6 | Rev 12 | Go to most recent revision | Details | Compare with Previous | 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, |
||
11 | daniel-mar | 10 | [STATUS] [INT] NOT NULL, |
11 | [status_geandert] [datetime] NULL, |
||
6 | daniel-mar | 12 | [version_release] [INT] NULL, |
13 | [version_agenda] [INT] NULL, |
||
14 | [modul] [INT] NULL, |
||
15 | [projekt] [INT] NOT NULL |
||
16 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
||
17 | ALTER TABLE [dbo].[bugs] ADD CONSTRAINT [DF_bugs_wichtigkeit] DEFAULT ((5)) FOR [wichtigkeit] |
||
11 | daniel-mar | 18 | ALTER TABLE [dbo].[bugs] ADD CONSTRAINT [DF_bugs_status] DEFAULT ((1)) FOR [STATUS] |
6 | daniel-mar | 19 | |
20 | CREATE TABLE [dbo].[mitarbeiter]( |
||
21 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
22 | [name] [VARCHAR](255) NULL |
||
23 | ) ON [PRIMARY] |
||
24 | |||
25 | CREATE TABLE [dbo].[module]( |
||
26 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
27 | [modul] [VARCHAR](255) NULL, |
||
28 | [projekt] [INT] NOT NULL |
||
29 | ) ON [PRIMARY] |
||
30 | |||
31 | CREATE TABLE [dbo].[projekte]( |
||
32 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
33 | [projekt] [VARCHAR](255) NULL |
||
34 | ) ON [PRIMARY] |
||
35 | |||
36 | CREATE TABLE [dbo].[versionen]( |
||
37 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
38 | [version] [VARCHAR](255) NULL, |
||
39 | [projekt] [INT] NOT NULL |
||
40 | ) ON [PRIMARY] |
||
11 | daniel-mar | 41 | |
42 | CREATE TABLE [dbo].[lkp_status]( |
||
43 | [id] [INT] IDENTITY(1,1) NOT NULL, |
||
44 | [STATUS] [VARCHAR](255) NULL |
||
45 | ) ON [PRIMARY] |