Rev 12 | Only display areas with differences | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 12 | Rev 14 | ||
---|---|---|---|
1 | 1 | ||
2 | CREATE TABLE [dbo].[bugs]( |
2 | CREATE TABLE [dbo].[bugs]( |
3 | [id] [INT] IDENTITY(1,1) NOT NULL, |
3 | [id] [INT] IDENTITY(1,1) NOT NULL, |
4 | [titel] [VARCHAR](255) NULL, |
4 | [titel] [VARCHAR](255) NULL, |
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 | [STATUS] [INT] NOT NULL, |
11 | [status_geandert] [datetime] NULL, |
11 | [status_geandert] [datetime] NULL, |
12 | [version_release] [INT] NULL, |
12 | [version_release] [INT] NULL, |
13 | [version_agenda] [INT] NULL, |
13 | [version_agenda] [INT] NULL, |
14 | [modul] [INT] NULL, |
14 | [modul] [INT] NULL, |
15 | [projekt] [INT] NOT NULL |
15 | [projekt] [INT] NOT NULL |
16 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
16 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
17 | 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] |
18 | ALTER TABLE [dbo].[bugs] ADD CONSTRAINT [DF_bugs_status] DEFAULT ((1)) FOR [STATUS] |
19 | 19 | ||
20 | CREATE TABLE [dbo].[mitarbeiter]( |
20 | CREATE TABLE [dbo].[mitarbeiter]( |
21 | [id] [INT] IDENTITY(1,1) NOT NULL, |
21 | [id] [INT] IDENTITY(1,1) NOT NULL, |
22 | [name] [VARCHAR](255) NULL |
22 | [name] [VARCHAR](255) NULL |
23 | ) ON [PRIMARY] |
23 | ) ON [PRIMARY] |
24 | 24 | ||
25 | CREATE TABLE [dbo].[module]( |
25 | CREATE TABLE [dbo].[module]( |
26 | [id] [INT] IDENTITY(1,1) NOT NULL, |
26 | [id] [INT] IDENTITY(1,1) NOT NULL, |
27 | [modul] [VARCHAR](255) NULL, |
27 | [modul] [VARCHAR](255) NULL, |
28 | [projekt] [INT] NOT NULL |
28 | [projekt] [INT] NOT NULL |
29 | ) ON [PRIMARY] |
29 | ) ON [PRIMARY] |
30 | 30 | ||
31 | CREATE TABLE [dbo].[projekte]( |
31 | CREATE TABLE [dbo].[projekte]( |
32 | [id] [INT] IDENTITY(1,1) NOT NULL, |
32 | [id] [INT] IDENTITY(1,1) NOT NULL, |
33 | [projekt] [VARCHAR](255) NULL |
33 | [projekt] [VARCHAR](255) NULL |
34 | ) ON [PRIMARY] |
34 | ) ON [PRIMARY] |
35 | 35 | ||
36 | CREATE TABLE [dbo].[versionen]( |
36 | CREATE TABLE [dbo].[versionen]( |
37 | [id] [INT] IDENTITY(1,1) NOT NULL, |
37 | [id] [INT] IDENTITY(1,1) NOT NULL, |
38 | [version] [VARCHAR](255) NULL, |
38 | [version] [VARCHAR](255) NULL, |
39 | [projekt] [INT] NOT NULL |
39 | [projekt] [INT] NOT NULL |
40 | ) ON [PRIMARY] |
40 | ) ON [PRIMARY] |
41 | 41 | ||
42 | CREATE TABLE [dbo].[lkp_status]( |
42 | CREATE TABLE [dbo].[lkp_status]( |
43 | [id] [INT] IDENTITY(1,1) NOT NULL, |
43 | [id] [INT] IDENTITY(1,1) NOT NULL, |
44 | [STATUS] [VARCHAR](255) NULL |
44 | [STATUS] [VARCHAR](255) NULL, |
- | 45 | [color] [INT] NOT NULL |
|
45 | ) ON [PRIMARY] |
46 | ) ON [PRIMARY] |
- | 47 | ALTER TABLE [dbo].[lkp_status] ADD CONSTRAINT [DF_lkp_status_color] DEFAULT ((0)) |
|
46 | 48 | ||
47 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('Offen'); |
49 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('Offen', 255); |
48 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('Abgelehnt'); |
50 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('Abgelehnt', 128); |
49 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('In Arbeit'); |
51 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('In Arbeit', 8388736); |
50 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('Abgeschlossen'); |
52 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('Abgeschlossen', 8421376); |
51 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('Veröffentlicht'); |
53 | INSERT INTO [lkp_status] ([STATUS]) VALUES ('Veröffentlicht', 32768); |
52 | 54 |