· 7 years ago · Dec 12, 2018, 03:52 PM
1
2 if db_id('imp_ramicro') is not null
3 BEGIN
4 IF (NOT EXISTS (SELECT *
5 FROM INFORMATION_SCHEMA.TABLES
6 WHERE TABLE_SCHEMA = 'dbo'
7 AND TABLE_NAME = 'tblAkten'))
8 BEGIN
9
10
11 USE imp_ramicro;
12 BEGIN TRANSACTION
13 SET QUOTED_IDENTIFIER ON
14 SET ARITHABORT ON
15 SET NUMERIC_ROUNDABORT OFF
16 SET CONCAT_NULL_YIELDS_NULL ON
17 SET ANSI_NULLS ON
18 SET ANSI_PADDING ON
19 SET ANSI_WARNINGS ON
20 COMMIT
21 BEGIN TRANSACTION
22 GO
23 CREATE TABLE dbo.tblAkten
24 (
25 GUIDAktenNummer bigint NOT NULL,
26 sAktenNummer bigint NULL,
27 sAktenKurzBezeichnung nvarchar(MAX) NULL,
28 sAktenBezeichnung nvarchar(MAX) NULL,
29 iReferat smallint NULL,
30 sAktenSachbearbeiter nvarchar(2) NULL,
31 sBemerkung nchar(63) NULL,
32 dtAblage datetime NULL,
33 yAktenArt tinyint NULL,
34 iAktenjahrgang bigint NULL,
35 iLaufendeNummer bigint NULL,
36 sMandant nvarchar(255) NULL,
37 sGegner nvarchar(255) NULL
38 ) ON [PRIMARY]
39 TEXTIMAGE_ON [PRIMARY]
40 GO
41 ALTER TABLE dbo.tblAkten ADD CONSTRAINT
42 PK_tblAkten PRIMARY KEY CLUSTERED
43 (
44 GUIDAktenNummer
45 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
46
47 GO
48 ALTER TABLE dbo.tblAkten SET (LOCK_ESCALATION = TABLE)
49 GO
50 COMMIT
51
52
53
54
55 END
56 END
57 BEGIN
58 IF (NOT EXISTS (SELECT *
59 FROM INFORMATION_SCHEMA.TABLES
60 WHERE TABLE_SCHEMA = 'dbo'
61 AND TABLE_NAME = 'tblAdressen'))
62 BEGIN
63
64 USE imp_ramicro;
65
66 BEGIN TRANSACTION
67 SET QUOTED_IDENTIFIER ON
68 SET ARITHABORT ON
69 SET NUMERIC_ROUNDABORT OFF
70 SET CONCAT_NULL_YIELDS_NULL ON
71 SET ANSI_NULLS ON
72 SET ANSI_PADDING ON
73 SET ANSI_WARNINGS ON
74 COMMIT
75 BEGIN TRANSACTION
76 GO
77 CREATE TABLE dbo.tblAdressen
78 (
79 GUIDAdresse bigint NOT NULL,
80 iAdressNummer bigint NULL,
81 sVorname nchar(50) NULL,
82 sNachname nchar(255) NULL
83 ) ON [PRIMARY]
84 GO
85 ALTER TABLE dbo.tblAdressen ADD CONSTRAINT
86 PK_tblAdressen PRIMARY KEY CLUSTERED
87 (
88 GUIDAdresse
89 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
90
91 GO
92 ALTER TABLE dbo.tblAdressen SET (LOCK_ESCALATION = TABLE)
93 GO
94 COMMIT
95
96 END
97 END
98 BEGIN
99 IF (NOT EXISTS (SELECT *
100 FROM INFORMATION_SCHEMA.TABLES
101 WHERE TABLE_SCHEMA = 'dbo'
102 AND TABLE_NAME = 'tblAktenBeteiligte'))
103 BEGIN
104
105 USE imp_ramicro;
106
107 BEGIN TRANSACTION
108 SET QUOTED_IDENTIFIER ON
109 SET ARITHABORT ON
110 SET NUMERIC_ROUNDABORT OFF
111 SET CONCAT_NULL_YIELDS_NULL ON
112 SET ANSI_NULLS ON
113 SET ANSI_PADDING ON
114 SET ANSI_WARNINGS ON
115 COMMIT
116 BEGIN TRANSACTION
117 GO
118 CREATE TABLE dbo.tblAktenBeteiligte
119 (
120 GUIDAkte bigint NOT NULL,-*
121 GUIDAdresse bigint NOT NULL,
122 iBeteiligtenArt int NULL,
123 sBetreffZeile1 nvarchar(MAX) NULL,
124 sBetreffZeile2 nvarchar(MAX) NULL,
125 sBetreffZeile3 nvarchar(MAX) NULL
126 ) ON [PRIMARY]
127 TEXTIMAGE_ON [PRIMARY]
128 GO
129 ALTER TABLE dbo.tblAktenBeteiligte ADD CONSTRAINT
130 PK_tblAktenBeteiligte PRIMARY KEY CLUSTERED
131 (
132 GUIDAkte
133 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
134
135 GO
136 ALTER TABLE dbo.tblAktenBeteiligte SET (LOCK_ESCALATION = TABLE)
137 GO
138 COMMIT
139
140
141
142 END
143 END
144
145 ELSE
146 BEGIN
147 CREATE DATABASE imp_ramicro; SELECT 0 as result;
148 END