Subversion Repositories winbugtracker

Rev

Rev 12 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 12 Rev 14
Line 39... Line 39...
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);