· 6 years ago · Dec 12, 2019, 12:42 PM
1USE RIS;
2
3IF NOT EXISTS(SELECT name FROM sys.columns WHERE object_id = OBJECT_ID(N'[RIS].[dbo].[tblOrder]') AND name = 'ClinicalInfo')
4 BEGIN
5 ALTER TABLE RIS.dbo.tblOrder ADD ClinicalInfo nvarchar(max) NULL
6 END
7
8 IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[RIS].[dbo].[tblPlacer_Checks]') AND type in (N'U'))
9 BEGIN
10 CREATE TABLE [dbo].[tblPlacer_Checks](
11 [ID] [int] IDENTITY(1,1) NOT NULL,
12 [Name] [nvarchar](50) NOT NULL,
13 [Value] [nvarchar](50) NULL,
14 [Value2] [nvarchar](50) NULL,
15 [Value3] [nvarchar](50) NULL,
16 [tblPlacer_ID] [int] NOT NULL,
17 CONSTRAINT [PK_tblPlacer_Checks] PRIMARY KEY CLUSTERED
18 (
19 [ID] ASC
20 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
21 ) ON [PRIMARY]
22
23 ALTER TABLE [dbo].[tblPlacer_Checks] WITH CHECK ADD CONSTRAINT [FK_tblPlacer_Checks_tblPlacer] FOREIGN KEY([tblPlacer_ID]) REFERENCES [dbo].[tblPlacer] ([ID])
24 ALTER TABLE [dbo].[tblPlacer_Checks] CHECK CONSTRAINT [FK_tblPlacer_Checks_tblPlacer]
25 END
26
27 IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[RIS].[dbo].[tblPlacer_PreviousExams]') AND type in (N'U'))
28 BEGIN
29 CREATE TABLE [dbo].[tblPlacer_PreviousExams](
30 [ID] [int] IDENTITY(1,1) NOT NULL,
31 [Name] [nvarchar](50) NOT NULL,
32 [Checked] [bit] NOT NULL,
33 [tblPlacer_ID] [int] NOT NULL,
34 CONSTRAINT [PK_tblPlacer_PreviousExams] PRIMARY KEY CLUSTERED
35 (
36 [ID] ASC
37 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
38 ) ON [PRIMARY]
39
40 ALTER TABLE [dbo].[tblPlacer_PreviousExams] WITH CHECK ADD CONSTRAINT [FK_tblPlacer_PreviousExams_tblPlacer] FOREIGN KEY([tblPlacer_ID]) REFERENCES [dbo].[tblPlacer] ([ID])
41 ALTER TABLE [dbo].[tblPlacer_PreviousExams] CHECK CONSTRAINT [FK_tblPlacer_PreviousExams_tblPlacer]
42 END
43
44 IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[RIS].[dbo].[tblPlacer_Procedures]') AND type in (N'U'))
45 BEGIN
46 CREATE TABLE [dbo].[tblPlacer_Procedures](
47 [ID] [int] IDENTITY(1,1) NOT NULL,
48 [tblBodyPart_ID] [int] NOT NULL,
49 [tblModality_Type_ID] [int] NOT NULL,
50 [Contrast] [bit] NOT NULL,
51 [LeftRight] [nvarchar](1) NOT NULL,
52 [DateTime] [smalldatetime] NOT NULL,
53 [OrderPlacerProcedureNumber] [nvarchar](50) NOT NULL,
54 [tblPlacer_ID] [int] NOT NULL,
55 CONSTRAINT [PK_tblPlacer_Procedures] PRIMARY KEY CLUSTERED
56 (
57 [ID] ASC
58 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
59 ) ON [PRIMARY]
60
61 ALTER TABLE [dbo].[tblPlacer_Procedures] WITH CHECK ADD CONSTRAINT [FK_tblPlacer_Procedures_tblOrdercom_BodyPart] FOREIGN KEY([tblBodyPart_ID]) REFERENCES [dbo].[tblOrdercom_BodyPart] ([ID])
62 ALTER TABLE [dbo].[tblPlacer_Procedures] CHECK CONSTRAINT [FK_tblPlacer_Procedures_tblOrdercom_BodyPart]
63 ALTER TABLE [dbo].[tblPlacer_Procedures] WITH CHECK ADD CONSTRAINT [FK_tblPlacer_Procedures_tblOrdercom_Modality] FOREIGN KEY([tblModality_Type_ID]) REFERENCES [dbo].[tblOrdercom_Modality] ([ID])
64 ALTER TABLE [dbo].[tblPlacer_Procedures] CHECK CONSTRAINT [FK_tblPlacer_Procedures_tblOrdercom_Modality]
65 ALTER TABLE [dbo].[tblPlacer_Procedures] WITH CHECK ADD CONSTRAINT [FK_tblPlacer_Procedures_tblPlacer] FOREIGN KEY([tblPlacer_ID]) REFERENCES [dbo].[tblPlacer] ([ID])
66 ALTER TABLE [dbo].[tblPlacer_Procedures] CHECK CONSTRAINT [FK_tblPlacer_Procedures_tblPlacer]
67 END
68
69 IF NOT EXISTS(SELECT name FROM sys.columns WHERE object_id = OBJECT_ID(N'[RIS].[dbo].[tblOrder_Procedure]') AND name = 'tblPlacer_ProcedureID')
70 BEGIN
71 ALTER TABLE RIS.dbo.tblOrder_Procedure ADD tblPlacer_ProcedureID int NULL
72 END
73
74 IF NOT EXISTS(SELECT name FROM sys.foreign_keys WHERE name = 'FK_tblOrder_Procedure_tblPlacer_Procedures')
75 BEGIN
76 ALTER TABLE [dbo].[tblOrder_Procedure] WITH CHECK ADD CONSTRAINT [FK_tblOrder_Procedure_tblPlacer_Procedures] FOREIGN KEY([tblPlacer_ProcedureID]) REFERENCES [dbo].[tblPlacer_Procedures] ([ID])
77 ALTER TABLE [dbo].[tblOrder_Procedure] CHECK CONSTRAINT [FK_tblOrder_Procedure_tblPlacer_Procedures]
78 END
79
80 IF NOT EXISTS(SELECT name FROM sys.columns WHERE object_id = OBJECT_ID(N'[RIS].[dbo].[tblPlacer]') AND name = 'Decision')
81 BEGIN
82 ALTER TABLE dbo.tblPlacer ADD Decision bit NULL
83 ALTER TABLE dbo.tblPlacer ADD Decision_DateTime datetime NULL
84 ALTER TABLE dbo.tblPlacer ADD Decision_By int NULL
85 ALTER TABLE dbo.tblPlacer ADD Decision_Comment nvarchar(max) NULL
86 END
87
88 IF NOT EXISTS(SELECT name FROM sys.foreign_keys WHERE name = 'FK_tblPlacer_tblUser')
89 BEGIN
90 ALTER TABLE [dbo].[tblPlacer] WITH CHECK ADD CONSTRAINT [FK_tblPlacer_tblUser] FOREIGN KEY([Decision_By]) REFERENCES [dbo].[tblUser] ([ID])
91 ALTER TABLE [dbo].[tblPlacer] CHECK CONSTRAINT [FK_tblPlacer_tblUser]
92 END
93
94 IF NOT EXISTS(SELECT name FROM sys.columns WHERE object_id = OBJECT_ID(N'[RIS].[dbo].[tblPlacer_Procedures]') AND name = 'MappedProcedure_UID')
95 BEGIN
96 ALTER TABLE dbo.tblPlacer_Procedures ADD MappedProcedure_UID int NULL
97 ALTER TABLE dbo.tblPlacer_Procedures ADD LinkedProcedure_UID int NULL
98 END
99
100 IF NOT EXISTS(SELECT name FROM sys.foreign_keys WHERE name = 'FK_tblPlacer_Procedures_tblProcedure')
101 BEGIN
102 ALTER TABLE [dbo].[tblPlacer_Procedures] WITH CHECK ADD CONSTRAINT [FK_tblPlacer_Procedures_tblProcedure] FOREIGN KEY([MappedProcedure_UID]) REFERENCES [dbo].[tblProcedure] ([ID])
103 ALTER TABLE [dbo].[tblPlacer_Procedures] CHECK CONSTRAINT [FK_tblPlacer_Procedures_tblProcedure]
104 ALTER TABLE [dbo].[tblPlacer_Procedures] WITH CHECK ADD CONSTRAINT [FK_tblPlacer_Procedures_tblProcedure1] FOREIGN KEY([LinkedProcedure_UID]) REFERENCES [dbo].[tblProcedure] ([ID])
105 ALTER TABLE [dbo].[tblPlacer_Procedures] CHECK CONSTRAINT [FK_tblPlacer_Procedures_tblProcedure1]
106 END
107
108 IF NOT EXISTS(SELECT * FROM dbo.tblMenuItem WHERE linkID = 'PlacerList')
109 BEGIN
110 INSERT INTO [RIS].[dbo].[tblMenuItem] (LinkID, Text, Controller, Action, ParentID, Visible, IconClass)
111 VALUES ('PlacerList', 'Placer list', 'Placerlist', NULL, NULL, 1, 'orderOverview')
112
113 INSERT INTO [RIS].[dbo].tblView (ViewURL, MenuItem_UID) VALUES
114 ('/PlacerList', (SELECT ID FROM [RIS].[dbo].tblMenuItem WHERE LinkID = 'PlacerList'))
115 END
116
117 IF NOT EXISTS (SELECT Name FROM ris.dbo.tblSettingGroup WHERE Name = 'DigitalOrdering')
118 BEGIN
119 INSERT INTO ris.dbo.tblSettingGroup
120 (Name, Number)
121 VALUES
122 ('DigitalOrdering',(select max(number)+1 from ris.dbo.tblSettingGroup))
123 END
124
125 IF NOT EXISTS (SELECT Tag FROM ris.dbo.tblSystemSetting WHERE Tag = 'UseDigitalOrdering')
126 BEGIN
127 INSERT INTO ris.dbo.tblSystemSetting
128 (System_UID,SettingGroup_UID,Tag,TagOnScreen,Value,ModifiedBy_UID,LastModification_DateTime,Number,Explanation,HasMulti,ValueMultiSetting_UID)
129 VALUES
130 (1,(SELECT ID FROM ris.dbo.tblSettingGroup WHERE Name = 'DigitalOrdering'), 'UseDigitalOrdering', 'Use Digital Ordering functionality',null, (SELECT ID FROM RIS.dbo.tblUser WHERE Username = 'admin@dobcomed.com'), getdate(),(select max(number)+1 from ris.dbo.tblSystemSetting), 'Use Digital Ordering functionality', 1,(SELECT ID FROM ris.dbo.tblMultiSetting WHERE Value = 'No'))
131 END
132 IF NOT EXISTS (SELECT * FROM ris.dbo.tblSystemSetting_HasMulti WHERE SystemSetting_UID = (SELECT ID FROM ris.dbo.tblSystemSetting WHERE Tag = 'UseDigitalOrdering') AND MultiSetting_UID = (SELECT ID FROM ris.dbo.tblMultiSetting WHERE Value = 'Yes'))
133 BEGIN
134 INSERT INTO ris.dbo.tblSystemSetting_HasMulti
135 (SystemSetting_UID, MultiSetting_UID)
136 VALUES
137 ((SELECT ID FROM ris.dbo.tblSystemSetting WHERE Tag = 'UseDigitalOrdering'), (SELECT ID FROM ris.dbo.tblMultiSetting WHERE Value = 'Yes'));
138 END;
139
140 IF NOT EXISTS (SELECT * FROM ris.dbo.tblSystemSetting_HasMulti WHERE SystemSetting_UID = (SELECT ID FROM ris.dbo.tblSystemSetting WHERE Tag = 'UseDigitalOrdering') AND MultiSetting_UID = (SELECT ID FROM ris.dbo.tblMultiSetting WHERE Value = 'No'))
141 BEGIN
142 INSERT INTO ris.dbo.tblSystemSetting_HasMulti
143 (SystemSetting_UID, MultiSetting_UID)
144 VALUES
145 ((SELECT ID FROM ris.dbo.tblSystemSetting WHERE Tag = 'UseDigitalOrdering'), (SELECT ID FROM ris.dbo.tblMultiSetting WHERE Value = 'No'));
146 END
147
148 IF NOT EXISTS ( SELECT name FROM sys.columns WHERE object_id = OBJECT_ID(N'[RIS].[dbo].[tblUser]') AND name = 'HeaderBold' )
149 BEGIN
150 ALTER TABLE RIS.dbo.[tblUser] ADD HeaderBold bit NULL
151 ALTER TABLE RIS.dbo.[tblUser] ADD HeaderItalic bit NULL
152 ALTER TABLE RIS.dbo.[tblUser] ADD HeaderUnderline bit NULL
153 END
154
155 update ris.dbo.tblSystem set Dbversion_Current = '1.6.23.0'