Produced by Araxis Merge on 9/9/2019 5:42:10 PM Eastern Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | Webvram-v4.zip\20190725-webvram-source.zip\Sources\WebVRAM.DB\Tables | VistaSites.sql | Tue Jul 23 23:11:38 2019 UTC |
2 | Webvram-v4.zip\20190725-webvram-source.zip\Sources\WebVRAM.DB\Tables | VistaSites.sql | Fri Sep 6 20:44:23 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 1 | 242 |
Changed | 1 | 2 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | /* modeled after the output fr om http:// URL: PORT /VistaWebS vcs/Exchan geSiteServ ice */ | |
2 | ||
3 | CREATE TAB LE dbo.Vis taSites | |
4 | ( | |
5 | -- fields | |
6 | Vi staSiteID [smallint] NOT NULL, --set to non-ide ntity seed ing so we can set pr e-populate the ID wi th the sam e value as the VISN code | |
7 | VisnNu mber [tinyint ] NOT NULL , | |
8 | Si teName [varchar]( 100) NOT N ULL, | |
9 | Si teNumber [varchar]( 100) NOT N ULL, | |
10 | SiteAb breviation [varch ar](8) NUL L, | |
11 | ||
12 | Rp cHostname [varchar ](200) NOT NULL, | |
13 | Rp cPort [int] NO T NULL, | |
14 | ||
15 | Da teInactive [datet ime2](7), | |
16 | In active [bit] NO T NULL, | |
17 | ||
18 | -- primary ke y | |
19 | CO NSTRAINT P K_VistaSit eID PRIMAR Y KEY CLUS TERED | |
20 | ( | |
21 | Vist aSiteID AS C | |
22 | ) | |
23 | ) | |
24 | GO | |
25 | ||
26 | --foreign keys | |
27 | ||
28 | --indexes | |
29 | CREATE NON CLUSTERED INDEX IX_V istaSites_ VisnNumber ON dbo.Vi staSites | |
30 | ( | |
31 | Vi snNumber | |
32 | ) WITH( STAT ISTICS_NOR ECOMPUTE = OFF, IGNO RE_DUP_KEY = OFF, AL LOW_ROW_LO CKS = ON, ALLOW_PAGE _LOCKS = O N) | |
33 | GO | |
34 | ||
35 | CREATE NON CLUSTERED INDEX IX_V istaSites_ SiteName O N dbo.Vist aSites | |
36 | ( | |
37 | Si teName | |
38 | ) WITH( STAT ISTICS_NOR ECOMPUTE = OFF, IGNO RE_DUP_KEY = OFF, AL LOW_ROW_LO CKS = ON, ALLOW_PAGE _LOCKS = O N) | |
39 | GO | |
40 | ||
41 | CREATE NON CLUSTERED INDEX IX_V istaSites_ SiteNumber ON dbo.Vi staSites | |
42 | ( | |
43 | Si teNumber | |
44 | ) WITH( STAT ISTICS_NOR ECOMPUTE = OFF, IGNO RE_DUP_KEY = OFF, AL LOW_ROW_LO CKS = ON, ALLOW_PAGE _LOCKS = O N) | |
45 | GO | |
46 | ||
47 | CREATE NON CLUSTERED INDEX IX_V istaSites_ SiteAbbrev iation ON dbo.VistaS ites | |
48 | ( | |
49 | Si teAbbrevia tion | |
50 | ) WITH( STAT ISTICS_NOR ECOMPUTE = OFF, IGNO RE_DUP_KEY = OFF, AL LOW_ROW_LO CKS = ON, ALLOW_PAGE _LOCKS = O N) | |
51 | GO | |
52 | ||
53 | --constrai nts | |
54 | ALTER TABL E dbo.Vist aSites | |
55 | ADD CON STRAINT DF _VistaSite s_Inactive | |
56 | DEFAULT 0 | |
57 | FOR Ina ctive | |
58 | GO | |
59 | ||
60 | --Metadata descripti ons for ea ch field | |
61 | EXECUTE sp _addextend edproperty | |
62 | N'MS_Descr iption', N 'Unique Ke y for the table', | |
63 | N'SCHEMA', N'dbo', | |
64 | N'TABLE', N'VistaSit es', | |
65 | N'COLUMN', N'VistaSi teID' | |
66 | GO | |
67 | ||
68 | EXECUTE sp _addextend edproperty | |
69 | N'MS_Descr iption', N 'The VISN number tha t the Vist A system r esides wit hin', | |
70 | N'SCHEMA', N'dbo', | |
71 | N'TABLE', N'VistaSit es', | |
72 | N'COLUMN', N'VisnNum ber' | |
73 | GO | |
74 | ||
75 | EXECUTE sp _addextend edproperty | |
76 | N'MS_Descr iption', N 'The VistA site name ', | |
77 | N'SCHEMA', N'dbo', | |
78 | N'TABLE', N'VistaSit es', | |
79 | N'COLUMN', N'SiteNam e' | |
80 | GO | |
81 | ||
82 | EXECUTE sp _addextend edproperty | |
83 | N'MS_Descr iption', N 'The VistA site numb er, ie 528 A7', | |
84 | N'SCHEMA', N'dbo', | |
85 | N'TABLE', N'VistaSit es', | |
86 | N'COLUMN', N'SiteNum ber' | |
87 | GO | |
88 | ||
89 | EXECUTE sp _addextend edproperty | |
90 | N'MS_Descr iption', N 'Abbreviat ion for th e site nam e and numb er', | |
91 | N'SCHEMA', N'dbo', | |
92 | N'TABLE', N'VistaSit es', | |
93 | N'COLUMN', N'SiteAbb reviation' | |
94 | GO | |
95 | ||
96 | EXECUTE sp _addextend edproperty | |
97 | N'MS_Descr iption', N 'The VistA systems h ostname fo r the RPC broker', | |
98 | N'SCHEMA', N'dbo', | |
99 | N'TABLE', N'VistaSit es', | |
100 | N'COLUMN', N'RpcHost name' | |
101 | GO | |
102 | ||
103 | EXECUTE sp _addextend edproperty | |
104 | N'MS_Descr iption', N 'The VistA systems p ort for th e RPC brok er', | |
105 | N'SCHEMA', N'dbo', | |
106 | N'TABLE', N'VistaSit es', | |
107 | N'COLUMN', N'RpcPort ' | |
108 | GO | |
109 | ||
110 | EXECUTE sp _addextend edproperty | |
111 | N'MS_Descr iption', N 'Date reco rd was ina ctivated', | |
112 | N'SCHEMA', N'dbo', | |
113 | N'TABLE', N'VistaSit es', | |
114 | N'COLUMN', N'DateIna ctive' | |
115 | GO | |
116 | ||
117 | EXECUTE sp _addextend edproperty | |
118 | N'MS_Descr iption', N 'Identifie s if the r ecord is i nactive', | |
119 | N'SCHEMA', N'dbo', | |
120 | N'TABLE', N'VistaSit es', | |
121 | N'COLUMN', N'Inactiv e' | |
122 | GO |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.