· 6 years ago · Apr 08, 2019, 08:38 PM
1IF (NOT EXISTS (SELECT *
2 FROM INFORMATION_SCHEMA.TABLES
3 WHERE TABLE_SCHEMA = 'General.Enum'
4 AND TABLE_NAME = 'DemandeStatut'))
5BEGIN
6
7 CREATE TABLE [General.Enum].DemandeStatut (
8 DmdSt_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
9 DmdSt_Nom NVARCHAR(25) NOT NULL
10 );
11
12 INSERT INTO [General.Enum].DemandeStatut VALUES ('0FAA0F3A-E510-4B9F-922B-39277C363E15', 'Reçu');
13 INSERT INTO [General.Enum].DemandeStatut VALUES ('1E185F4B-2EB6-407A-B276-6C9A0C70B0A2', 'EnCorrespondance');
14 INSERT INTO [General.Enum].DemandeStatut VALUES ('E7C74E04-8D3C-4515-94F6-70D627258C17', 'Completée');
15 INSERT INTO [General.Enum].DemandeStatut VALUES ('376E9AA4-4A76-4716-9962-72CDDD8C79BB', 'Annulée');
16 INSERT INTO [General.Enum].DemandeStatut VALUES ('D20357BD-AFDC-45CF-9821-CCC5D4CF9F54', 'EnMutation');
17 INSERT INTO [General.Enum].DemandeStatut VALUES ('A99FFCC4-86FA-4000-ACFE-EE76463A1DDF', 'Expirée');
18
19END
20
21IF (NOT EXISTS (SELECT *
22 FROM INFORMATION_SCHEMA.TABLES
23 WHERE TABLE_SCHEMA = 'Propriete.Enum'
24 AND TABLE_NAME = 'FormStatut'))
25BEGIN
26
27 CREATE TABLE [Propriete.Enum].FormStatut (
28 FrmSt_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
29 FrmSt_Nom NVARCHAR(25) NOT NULL
30 );
31
32 INSERT INTO [Propriete.Enum].FormStatut VALUES ('86D03AE3-A2B9-4686-A571-1D98506F541C', 'Complété');
33 INSERT INTO [Propriete.Enum].FormStatut VALUES ('EA5D43E8-2B34-4A34-9F92-AA1306165582', 'EnCours');
34 INSERT INTO [Propriete.Enum].FormStatut VALUES ('286CD2E4-C48E-4B76-9820-EB335AAB97DE', 'Annulé');
35
36END
37-- B15
38
39-- ProprieteType
40IF (NOT EXISTS (SELECT *
41 FROM INFORMATION_SCHEMA.TABLES
42 WHERE TABLE_SCHEMA = 'Propriete.Enum'
43 AND TABLE_NAME = 'ProprieteType'))
44BEGIN
45
46 CREATE TABLE [Propriete.Enum].ProprieteType (
47 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
48 NameValue NVARCHAR(25) NOT NULL,
49 ViewValue NVARCHAR(175) NOT NULL,
50 OrderValue INT NOT NULL
51 );
52
53 INSERT INTO [Propriete.Enum].ProprieteType VALUES ('4E56DC5E-7E34-4806-9DA5-BDEEE29A4425', 'RES', 'Résidentiel', 1)
54 INSERT INTO [Propriete.Enum].ProprieteType VALUES ('DC5ACC46-E596-4000-9BC1-D5A10F943BF8', 'CONDO', 'Condo', 2)
55 INSERT INTO [Propriete.Enum].ProprieteType VALUES ('2A9FD589-B2CE-4BFB-9710-52D483F8CD41', 'DAE', 'Dépendances et améliorations', 3)
56
57END;
58
59--
60
61IF (NOT EXISTS (SELECT *
62 FROM INFORMATION_SCHEMA.TABLES
63 WHERE TABLE_SCHEMA = 'Propriete.Enum'
64 AND TABLE_NAME = 'B15MatFondation'))
65BEGIN
66
67 CREATE TABLE [Propriete.Enum].B15MatFondation (
68 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
69 NameValue NVARCHAR(25) NOT NULL,
70 ViewValue NVARCHAR(175) NOT NULL,
71 Code NVARCHAR(2) NOT NULL,
72 Materiau NVARCHAR(25) NOT NULL,
73 Type NVARCHAR(25) NOT NULL,
74 OrderValue INT NOT NULL
75 );
76
77 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'BetonCoule' , 'Béton coulé' , '4', 'Beton', 'Lourd', 1)
78 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'BlocBeton' , 'Bloc de béton' , '4', 'Beton', 'Lourd', 2)
79 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'PilierExcaveMetal', 'Pilier excavé en métal', '2', 'Beton', 'Lourd', 3)
80 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'PilierExcaveBeton', 'Pilier excavé en béton', '2', 'Beton', 'Lourd', 4)
81 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('5ADF7D8A-B3A9-4C2F-9216-75C91C420BB0', 'PilierBlocBeton' , 'Pilier en bloc de béton' , '1', 'Beton', 'Lourd', 5)
82 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('5219F83D-3D28-419A-BCA6-965AAE9AA359', 'PilierMetal' , 'Pilier en metal' , '1', 'Beton', 'Lourd', 6)
83 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'PilierCageBois' , 'Pilier en cage de bois' , '1', 'Brique', 'Lourd', 7)
84
85END
86-- B22
87
88-- Images
89IF (NOT EXISTS (SELECT *
90 FROM INFORMATION_SCHEMA.TABLES
91 WHERE TABLE_SCHEMA = 'Propriete.Enum'
92 AND TABLE_NAME = 'B22TypePorteFacade'))
93BEGIN
94
95 CREATE TABLE [Propriete.Enum].B22TypePorteFacade (
96 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
97 NameValue NVARCHAR(25) NOT NULL,
98 ViewValue NVARCHAR(175) NOT NULL,
99 OrderValue INT NOT NULL
100 );
101
102 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', '1', '1', 1)
103 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '2', '2', 2)
104 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '3', '3', 3)
105 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', '4', '4', 4)
106 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', '5', '5', 5)
107 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', '6', '6', 6)
108 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', '7', '7', 7)
109 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', '8', '8', 8)
110
111END
112
113
114IF (NOT EXISTS (SELECT *
115 FROM INFORMATION_SCHEMA.TABLES
116 WHERE TABLE_SCHEMA = 'Propriete.Enum'
117 AND TABLE_NAME = 'B22TypeFenetreFacade'))
118BEGIN
119
120 CREATE TABLE [Propriete.Enum].B22TypeFenetreFacade (
121 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
122 NameValue NVARCHAR(25) NOT NULL,
123 ViewValue NVARCHAR(175) NOT NULL,
124 OrderValue INT NOT NULL
125 );
126
127 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', '1', '1', 1)
128 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '2', '2', 2)
129 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '3', '3', 3)
130 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', '4', '4', 4)
131 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', '5', '5', 5)
132 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', '6', '6', 6)
133
134END
135
136IF (NOT EXISTS (SELECT *
137 FROM INFORMATION_SCHEMA.TABLES
138 WHERE TABLE_SCHEMA = 'Propriete.Enum'
139 AND TABLE_NAME = 'B22ChoixAngle'))
140BEGIN
141
142 CREATE TABLE [Propriete.Enum].B22ChoixAngle (
143 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
144 NameValue NVARCHAR(25) NOT NULL,
145 ViewValue NVARCHAR(175) NOT NULL,
146 OrderValue INT NOT NULL
147 );
148
149
150 INSERT INTO [Propriete.Enum].B22ChoixAngle VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', '4-6' , '4-6', 1 )
151 INSERT INTO [Propriete.Enum].B22ChoixAngle VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '7-10', '7-10', 2)
152 INSERT INTO [Propriete.Enum].B22ChoixAngle VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '>10' , '> 10', 3 )
153
154END
155
156IF (NOT EXISTS (SELECT *
157 FROM INFORMATION_SCHEMA.TABLES
158 WHERE TABLE_SCHEMA = 'Propriete.Enum'
159 AND TABLE_NAME = 'B22RevetementExtMur'))
160BEGIN
161
162 CREATE TABLE [Propriete.Enum].B22RevetementExtMur (
163 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
164 NameValue NVARCHAR(25) NOT NULL,
165 ViewValue NVARCHAR(175) NOT NULL,
166 Code NVARCHAR(2) NOT NULL,
167 Materiau NVARCHAR(25) NOT NULL,
168 Type NVARCHAR(25) NOT NULL,
169 OrderValue INT NOT NULL
170 );
171
172 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('C2C8D93B-E570-43C8-B8A3-06AF83FA46E3', 'Aluminium' , 'Aluminium' , '50', 'Metal', 'Leger', 1)
173 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('E4127D59-35F2-4F9D-8708-34B9145EDF17', 'AluminiumEmaillee' , 'Aluminium émaillée' , '50', 'Metal', 'Leger', 2)
174 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('81666D01-0FFA-4842-9E6D-A10139BC172E', 'Amiante' , 'Amiante' , '70', 'Synthetique', 'Leger', 3)
175 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('1CB61628-9DDB-4B51-BA75-D455EC7647DF', 'BardeauAmiante' , 'Bardeau d''amiante' , '70', 'Synthetique', 'Leger', 4)
176 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('B9BC46AC-B5E5-4DC4-9B1A-88B1AED6571C', 'BardeauAsphalte' , 'Bardeau d''asphalte' , '70', 'Synthetique', 'Leger', 5)
177 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('5A3F9F15-009E-49F0-8CAA-BBE40E3FD537', 'BardeauBois' , 'Bardeau de bois' , '60', 'Bois', 'Leger', 6)
178 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'BlocBeton' , 'Bloc de béton' , '10', 'Beton', 'Lourd', 7)
179 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Beton' , 'Béton' , '10', 'Beton', 'Lourd', 8)
180 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'BetonPrefabrique' , 'Béton préfabriqué' , '10', 'Beton', 'Lourd', 9)
181 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'PanneauxPrefabBeton', 'Panneaux préfabriqués en béton', '10', 'Beton', 'Lourd', 10)
182 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'Brique' , 'Brique' , '32', 'Brique', 'Lourd', 11)
183 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'BriqueAutoportante' , 'Brique autoportante' , '40', 'Brique', 'Lourd', 12)
184 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('17426FA8-EFF5-4322-88FA-4787384A6687', 'Ceramique' , 'Céramique' , '32', 'Brique', 'Lourd', 13)
185 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('73A4587D-FC45-40D3-BC78-B4E62CFCC1F3', 'Cinyle' , 'Cinyle' , '70', 'Synthetique', 'Leger', 14)
186 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('9AA1A77A-4976-478E-9972-9A3445E64410', 'ContrePlaque' , 'Contreplaqué' , '60', 'Bois', 'Leger', 15)
187 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('7D6B5160-6DDD-42EA-AE02-B1FA601D7DF1', 'Copolymere' , 'Copolymère' , '60', 'Bois', 'Leger', 16)
188 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('CB3ADBB8-D324-4193-B351-2A1F6245CC83', 'DeclinBois' , 'Déclin de bois' , '60', 'Bois', 'Leger', 17)
189 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('9A39DF0D-2D8A-41E3-94E1-3F6BD1733D79', 'DeclinFibrePressee' , 'Déclin de fibre pressée' , '65', 'Fibre', 'Leger', 18)
190 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('EE23A293-C820-4933-A4F7-EE2946BEDAAD', 'Marbre' , 'Marbre' , '37', 'Pierre', 'Lourd', 19)
191 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('93E59223-5646-486C-B03E-DF4CBF07715E', 'MarbrePoli' , 'Marbre poli' , '37', 'Pierre', 'Lourd', 20)
192 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'PierreChamps' , 'Pierre des champs' , '37', 'Pierre', 'Lourd', 21)
193 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', 'PierreDressee' , 'Pierre dressée' , '37', 'Pierre', 'Lourd', 22)
194 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('8DA7BB04-60E3-4BA4-8DFF-EFC3E78FFA78', 'PierreFendue' , 'Pierre fendue' , '37', 'Pierre', 'Lourd', 23)
195 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('56EC78D0-ABA3-43B3-8FE9-8A561B982046', 'PierreSimili' , 'Pierre de simili' , '37', 'Pierre', 'Lourd', 24)
196 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('7378BD19-C592-4305-8C99-95858F26B2ED', 'PierreTaillee' , 'Pierre taillée' , '37', 'Pierre', 'Lourd', 25)
197 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('9433B22B-7F7B-46CD-8EB5-93D839196DC9', 'PierreTailleePolie' , 'Pierre taillée polie' , '37', 'Pierre', 'Lourd', 26)
198 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('687E16F5-DD98-4AB0-B101-3FACF65CCB7D', 'Pierre' , 'Pierre' , '37', 'Pierre', 'Lourd', 27)
199 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('9C6B15C2-D2AE-4D7C-9379-9A064FCA8239', 'Planche' , 'Planche' , '60', 'Bois', 'Leger', 28)
200 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('30395223-A379-4029-A084-6ADE99C8B328', 'StucAgregat' , 'Stuc/agrégat' , '94', 'EnduitFinition', 'Leger', 29)
201 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('72DD989C-8148-4910-A762-4C19EF076D7B', 'Tole' , 'Tôle' , '90', 'Metal', 'Leger', 30)
202 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('564CC8E0-EE9B-4B5D-9822-B32BB3DEA5AF', 'ToleEmaillee' , 'Tôle émaillée' , '50', 'Metal', 'Leger', 31)
203 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('3B9C3BBE-F092-4829-A0DD-BA055F626556', 'Verre' , 'Verre' , '20', 'Verre', 'Lourd', 32)
204 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('BBCF9B45-29E4-4729-9DA5-31FA6A38A414', 'Autre' , 'Autre' , '40', '', '', 33)
205 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('4371B62D-18F7-45D7-A234-2A817DF2003A', 'Aucun' , 'Aucun' , '99', '', '', 33)
206
207END
208-- B23
209
210IF (NOT EXISTS (SELECT *
211 FROM INFORMATION_SCHEMA.TABLES
212 WHERE TABLE_SCHEMA = 'Propriete.Enum'
213 AND TABLE_NAME = 'B23RevetementToit'))
214BEGIN
215
216 CREATE TABLE [Propriete.Enum].B23RevetementToit (
217 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
218 NameValue NVARCHAR(25) NOT NULL,
219 ViewValue NVARCHAR(175) NOT NULL,
220 OrderValue INT NOT NULL
221 );
222
223
224 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'BardeauAsphalte', 'Bardeau d''asphalte', 1)
225 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'BardeauBois' , 'Bardeau de bois', 2 )
226 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Cuivre' , 'Cuivre', 3 )
227 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'Membrane' , 'Membrane', 4 )
228 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'Metal' , 'Métal', 5 )
229 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'Tuile' , 'Tuile', 6 )
230 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'Verre' , 'Verre', 7 )
231 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', 'Autre' , 'Autre', 8 )
232
233END
234
235IF (NOT EXISTS (SELECT *
236 FROM INFORMATION_SCHEMA.TABLES
237 WHERE TABLE_SCHEMA = 'Propriete.Enum'
238 AND TABLE_NAME = 'B23NbVersants'))
239BEGIN
240
241 CREATE TABLE [Propriete.Enum].B23NbVersants (
242 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
243 NameValue NVARCHAR(25) NOT NULL,
244 ViewValue NVARCHAR(175) NOT NULL,
245 OrderValue INT NOT NULL
246 );
247
248 INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', '1a2', '1 Ã 2', 1)
249 INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '3a4' , '3 Ã 4 ou toit plat', 2 )
250 INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '5a8' , '5 Ã 8', 3 )
251 INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', '9plus' , '9 et +', 4 )
252
253END
254-- B33
255
256IF (NOT EXISTS (SELECT *
257 FROM INFORMATION_SCHEMA.TABLES
258 WHERE TABLE_SCHEMA = 'Propriete.Enum'
259 AND TABLE_NAME = 'B33QualitePorteInt'))
260BEGIN
261
262 CREATE TABLE [Propriete.Enum].B33QualitePorteInt (
263 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
264 NameValue NVARCHAR(25) NOT NULL,
265 ViewValue NVARCHAR(175) NOT NULL,
266 OrderValue INT NOT NULL
267 );
268
269
270 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Luxueux' , 'Portes luxueuses, faites sur mesure, au desgin unique', 1 )
271 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Superieur', 'Portes au cachet supérieur, portes françaises, escamotables, en bois pleines, coulissantes non courrantes', 2)
272 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Courant' , 'Portes de type courant, avec certains motifs', 3 )
273 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Unie' , 'Portes simples unies et sans attrait', 4 )
274 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucune' , 'Aucune porte', 5 )
275
276END
277
278
279IF (NOT EXISTS (SELECT *
280 FROM INFORMATION_SCHEMA.TABLES
281 WHERE TABLE_SCHEMA = 'Propriete.Enum'
282 AND TABLE_NAME = 'B33QualiteOrnement'))
283BEGIN
284
285 CREATE TABLE [Propriete.Enum].B33QualiteOrnement (
286 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
287 NameValue NVARCHAR(25) NOT NULL,
288 ViewValue NVARCHAR(175) NOT NULL,
289 OrderValue INT NOT NULL
290 );
291
292
293 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Extraordinaire', 'Cachet extraordinaire, profusion de moulures larges et lambris coûteux, design intérieur somptueux et architectural', 1)
294 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Nombreuse' , 'Nombreuses moulures de qualité supérieure et/ou au design luxueux et/ou lambris de qualité supérieure et aux luminaires luxueux surpassant les besoin usuels', 2 )
295 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Quelques' , 'Quelques moulures décoratives et/ou présence de lambris standard et luminaires courants répondant aux besoins usuels', 3 )
296 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Minimale' , 'Ornementation minimale, moulures bas de gamme et luminaires modestes et peu nombreux', 4 )
297 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucune' , 'Aucune moulure, finition peu harmonieuse et luminaires de type plafonnier', 5 )
298
299END
300
301IF (NOT EXISTS (SELECT *
302 FROM INFORMATION_SCHEMA.TABLES
303 WHERE TABLE_SCHEMA = 'Propriete.Enum'
304 AND TABLE_NAME = 'B33QualiteEscalierInt'))
305BEGIN
306
307 CREATE TABLE [Propriete.Enum].B33QualiteEscalierInt (
308 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
309 NameValue NVARCHAR(25) NOT NULL,
310 ViewValue NVARCHAR(175) NOT NULL,
311 OrderValue INT NOT NULL
312 );
313
314 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Luxueux', 'Matériaux luxueux au design unique, avec courbes, angles', 1 )
315 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Design' , 'Matériaux et designs particuliers et/ou avec angle ou paliers', 2 )
316 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Courant', 'Matériaux et designs courants, rectiligne ou à paliers en bois franc', 3 )
317 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Modeste', 'Escalier modeste, fonctionnel et sans particularité', 4 )
318 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucune', 'Aucune finition', 5 )
319
320END
321
322IF (NOT EXISTS (SELECT *
323 FROM INFORMATION_SCHEMA.TABLES
324 WHERE TABLE_SCHEMA = 'Propriete.Enum'
325 AND TABLE_NAME = 'B33MatPlafond'))
326BEGIN
327
328 CREATE TABLE [Propriete.Enum].B33MatPlafond (
329 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
330 NameValue NVARCHAR(25) NOT NULL,
331 ViewValue NVARCHAR(175) NOT NULL,
332 Code NVARCHAR(2) NOT NULL,
333 OrderValue INT NOT NULL
334 );
335
336
337 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BoisMou' , 'Bois mou' , '63', 1)
338 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'ContreplaquePrefini', 'Contreplaqué préfini', '64', 2)
339 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Fibre' , 'Fibre' , '65', 3)
340 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'PanneauGypse' , 'Panneau de gypse' , '93', 4)
341 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Autre' , 'Autre' , '90', 5)
342 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('AD5D1C92-A75B-40B4-806D-1F978D517AEC', 'Aucun' , 'Aucun' , '99', 6)
343
344END
345
346IF (NOT EXISTS (SELECT *
347 FROM INFORMATION_SCHEMA.TABLES
348 WHERE TABLE_SCHEMA = 'Propriete.Enum'
349 AND TABLE_NAME = 'B33MatMur'))
350BEGIN
351
352 CREATE TABLE [Propriete.Enum].B33MatMur (
353 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
354 NameValue NVARCHAR(25) NOT NULL,
355 ViewValue NVARCHAR(175) NOT NULL,
356 Code NVARCHAR(2) NOT NULL,
357 OrderValue INT NOT NULL
358 );
359
360 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BoisMou' , 'Bois mou' , '63', 1)
361 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'ContreplaquePrefini', 'Contreplaqué préfini', '64', 2)
362 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Fibre' , 'Fibre' , '65', 3)
363 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'PanneauGypse' , 'Panneau de gypse' , '93', 4)
364 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('771EA95D-D4B8-4D21-83F7-677979CDCCFB', 'Autre' , 'Autre' , '90', 5)
365 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('AD5D1C92-A75B-40B4-806D-1F978D517AEC', 'Aucun' , 'Aucun' , '99', 6)
366
367END
368
369IF (NOT EXISTS (SELECT *
370 FROM INFORMATION_SCHEMA.TABLES
371 WHERE TABLE_SCHEMA = 'Propriete.Enum'
372 AND TABLE_NAME = 'B33MatMurPlafond'))
373BEGIN
374 -- TODO: Change QC for plafond and mur
375 CREATE TABLE [Propriete.Enum].B33MatMurPlafond (
376 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
377 NameValue NVARCHAR(25) NOT NULL,
378 ViewValue NVARCHAR(175) NOT NULL,
379 Code NVARCHAR(2) NOT NULL,
380 OrderValue INT NOT NULL
381 );
382
383
384 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BoisMou' , 'Bois mou' , '63', 1)
385 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'ContreplaquePrefini', 'Contreplaque préfini', '64', 2)
386 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'PanneauGypse' , 'Panneau de gypse' , '93', 3)
387 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', 'PlafondExpanse' , 'Plafond expansé' , '90', 4)
388 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Fibre' , 'Tuiles de fibre suspendues ou non' , '65', 5)
389 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'TuileSuspendue' , 'Tuile suspendue en bois ou MDF' , '90', 6)
390 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('771EA95D-D4B8-4D21-83F7-677979CDCCFB', 'Autre' , 'Autre' , '90', 7)
391 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('AD5D1C92-A75B-40B4-806D-1F978D517AEC', 'Aucun' , 'Aucun' , '99', 8)
392
393END
394-- B34
395
396IF (NOT EXISTS (SELECT *
397 FROM INFORMATION_SCHEMA.TABLES
398 WHERE TABLE_SCHEMA = 'Propriete.Enum'
399 AND TABLE_NAME = 'B34TypePiece'))
400BEGIN
401
402 CREATE TABLE [Propriete.Enum].B34TypePiece (
403 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
404 NameValue NVARCHAR(25) NOT NULL,
405 ViewValue NVARCHAR(175) NOT NULL,
406 OrderValue INT NOT NULL
407 );
408
409
410 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Cuisine' , 'Cuisine', 1)
411 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Chambre' , 'Chambre', 2 )
412 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('72DD989C-8148-4910-A762-4C19EF076D7B', 'SalleEau' , 'Salle d''eau', 3)
413 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'SalleFamiliale' , 'Salle familiale / Salle de jeux', 4)
414 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('AD5D1C92-A75B-40B4-806D-1F978D517AEC', 'SalleDeBain' , 'Salle de bain', 5)
415 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'SalleAManger' , 'Salle à manger', 6)
416 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Salon' , 'Salon', 7 )
417 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', 'Autre' , 'Autre', 8)
418
419END
420
421IF (NOT EXISTS (SELECT *
422 FROM INFORMATION_SCHEMA.TABLES
423 WHERE TABLE_SCHEMA = 'Propriete.Enum'
424 AND TABLE_NAME = 'B34Etage'))
425BEGIN
426
427 CREATE TABLE [Propriete.Enum].B34Etage (
428 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
429 NameValue NVARCHAR(25) NOT NULL,
430 ViewValue NVARCHAR(175) NOT NULL,
431 OrderValue INT NOT NULL
432 );
433
434
435 INSERT INTO [Propriete.Enum].B34Etage VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Rdc' , 'Rez-de-chaussée', 1 )
436 INSERT INTO [Propriete.Enum].B34Etage VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'SS' , 'Sous-sol', 2 )
437 INSERT INTO [Propriete.Enum].B34Etage VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Etg2', '2', 3)
438 INSERT INTO [Propriete.Enum].B34Etage VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Etg3', '3', 4)
439 INSERT INTO [Propriete.Enum].B34Etage VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Att', 'Attique', 5)
440
441END
442
443IF (NOT EXISTS (SELECT *
444 FROM INFORMATION_SCHEMA.TABLES
445 WHERE TABLE_SCHEMA = 'Propriete.Enum'
446 AND TABLE_NAME = 'B34MatPlancher'))
447BEGIN
448
449 CREATE TABLE [Propriete.Enum].B34MatPlancher (
450 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
451 NameValue NVARCHAR(25) NOT NULL,
452 ViewValue NVARCHAR(175) NOT NULL,
453 Code NVARCHAR(2) NOT NULL,
454 OrderValue INT NOT NULL
455 );
456
457 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('8C39EF4D-7D4D-4697-AE45-9FAFB5559FB7', 'Ardoise' ,'Ardoise' , '40', 1)
458 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('771EA95D-D4B8-4D21-83F7-677979CDCCFB', 'BoisIngenerie', 'Bois d''ingénérie', '60', 2)
459 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'BoisFranc' , 'Bois franc' , '62', 3)
460 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Ceramique' , 'Céramique' , '35', 4)
461 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('9ECBB6F0-AF5A-4FFF-8BD9-A8231978D7A4', 'Epoxy' , 'Époxy' , '60', 5)
462 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'FlottantStrat', 'Flottant Stratifié', '60', 6)
463 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('A48B8065-A4E8-46DA-97E5-C107BF7B5713', 'Marbre' , 'Marbre' , '40', 7)
464 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('3D3D687B-5FC5-4962-9F7F-04A9FA7F7490', 'Parquetereie' , 'Parquetereie' , '60', 8)
465 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Tapis' , 'Tapis' , '75', 9)
466 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Vinyle' , 'Vinyle' , '77', 10)
467 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('BBCF9B45-29E4-4729-9DA5-31FA6A38A414', 'Autre' , 'Autre' , '40', 11)
468 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('4371B62D-18F7-45D7-A234-2A817DF2003A', 'Aucun' , 'Aucun' , '99', 12)
469
470END
471
472IF (NOT EXISTS (SELECT *
473 FROM INFORMATION_SCHEMA.TABLES
474 WHERE TABLE_SCHEMA = 'Propriete.Enum'
475 AND TABLE_NAME = 'B36MatArmoire'))
476BEGIN
477
478-- B36
479
480 CREATE TABLE [Propriete.Enum].B36MatArmoire (
481 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
482 NameValue NVARCHAR(50) NOT NULL,
483 ViewValue NVARCHAR(175) NOT NULL,
484 Code NVARCHAR(2) NOT NULL,
485 OrderValue INT NOT NULL
486 );
487
488
489 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('D69DCE90-6DE4-4CE7-B949-428828D34266', 'BoisDur', 'Bois dur (chêne, érable, bois laqué etc.)', '60', 1)
490 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('8C92FB06-1F56-4584-8EBC-479F05130BE8', 'BoisMou', 'Bois mou (pin, épinette, cèdre etc.)', '60', 2)
491 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Melamine' , 'Mélamine' , '67', 3)
492 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Polyester' , 'Polyester' , '76', 4)
493 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Thermoplastique', 'Thermoplastique', '76', 5)
494 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('D6AAAEB8-E5A3-4B13-ADD9-DD273F7E75F7', 'Autre' , 'Autre', '90', 6)
495
496END
497
498IF (NOT EXISTS (SELECT *
499 FROM INFORMATION_SCHEMA.TABLES
500 WHERE TABLE_SCHEMA = 'Propriete.Enum'
501 AND TABLE_NAME = 'B36QualiteMatComptoir'))
502BEGIN
503
504 CREATE TABLE [Propriete.Enum].B36QualiteMatComptoir (
505 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
506 NameValue NVARCHAR(25) NOT NULL,
507 ViewValue NVARCHAR(175) NOT NULL,
508 OrderValue INT NOT NULL
509 );
510
511
512 INSERT INTO [Propriete.Enum].B36QualiteMatComptoir VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Standard', 'Standard (stratifié, bois, céramique)', 1)
513 INSERT INTO [Propriete.Enum].B36QualiteMatComptoir VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Superieur', 'Qualité supérieure (marbre, quartz, granit, béton, corian, stainless)', 2)
514
515END
516
517IF (NOT EXISTS (SELECT *
518 FROM INFORMATION_SCHEMA.TABLES
519 WHERE TABLE_SCHEMA = 'Propriete.Enum'
520 AND TABLE_NAME = 'B36AppEncastre'))
521BEGIN
522
523 CREATE TABLE [Propriete.Enum].B36AppEncastre (
524 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
525 NameValue NVARCHAR(25) NOT NULL,
526 ViewValue NVARCHAR(175) NOT NULL,
527 OrderValue INT NOT NULL
528 );
529
530 INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucun', 'Aucun', 1)
531 INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('E5B1A652-510B-4354-BF00-D6A545C1BA50', 'Cellier', 'Chambre cellier vitrée', 2)
532 INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'PlaqueCuissonOuFour', 'Plaque de cuisson et/ou four', 3)
533 INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Refrigerateur', 'Réfrigérateur (utilise le même matériau que les armoires)', 4)
534
535END
536
537IF (NOT EXISTS (SELECT *
538 FROM INFORMATION_SCHEMA.TABLES
539 WHERE TABLE_SCHEMA = 'Propriete.Enum'
540 AND TABLE_NAME = 'B43TypeBainDouche'))
541BEGIN
542-- B43
543
544 CREATE TABLE [Propriete.Enum].B43TypeBainDouche(
545 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
546 NameValue NVARCHAR(25) NOT NULL,
547 ViewValue NVARCHAR(175) NOT NULL,
548 OrderValue INT NOT NULL
549 );
550
551
552 INSERT INTO [Propriete.Enum].B43TypeBainDouche VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Bain', 'Bain', 1)
553 INSERT INTO [Propriete.Enum].B43TypeBainDouche VALUES ('E5B1A652-510B-4354-BF00-D6A545C1BA50', 'Douche' , 'Douche' , 2 )
554 INSERT INTO [Propriete.Enum].B43TypeBainDouche VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BainDouche' , 'Bain/Douche', 3 )
555
556END
557
558IF (NOT EXISTS (SELECT *
559 FROM INFORMATION_SCHEMA.TABLES
560 WHERE TABLE_SCHEMA = 'Propriete.Enum'
561 AND TABLE_NAME = 'B43TypeBain'))
562BEGIN
563
564 CREATE TABLE [Propriete.Enum].B43TypeBain (
565 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
566 NameValue NVARCHAR(25) NOT NULL,
567 ViewValue NVARCHAR(175) NOT NULL,
568 OrderValue INT NOT NULL
569 );
570
571
572 INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'AutoPortant', 'Auto-portant', 1)
573 INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('E5B1A652-510B-4354-BF00-D6A545C1BA50', 'Remous' , 'À remous' , 2 )
574 INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Encastre' , 'Encastré', 3 )
575 INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Podium' , 'Podium' , 4 )
576
577END
578
579IF (NOT EXISTS (SELECT *
580 FROM INFORMATION_SCHEMA.TABLES
581 WHERE TABLE_SCHEMA = 'Propriete.Enum'
582 AND TABLE_NAME = 'B43TypeDouche'))
583BEGIN
584
585 CREATE TABLE [Propriete.Enum].B43TypeDouche (
586 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
587 NameValue NVARCHAR(25) NOT NULL,
588 ViewValue NVARCHAR(175) NOT NULL,
589 OrderValue INT NOT NULL
590 );
591
592 INSERT INTO [Propriete.Enum].B43TypeDouche VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Ceramique', 'Céramique', 1)
593 INSERT INTO [Propriete.Enum].B43TypeDouche VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Plastique', 'Plastique', 2)
594
595END
596
597IF (NOT EXISTS (SELECT *
598 FROM INFORMATION_SCHEMA.TABLES
599 WHERE TABLE_SCHEMA = 'Propriete.Enum'
600 AND TABLE_NAME = 'B43QualiteSalleBain'))
601BEGIN
602
603 CREATE TABLE [Propriete.Enum].B43QualiteSalleBain (
604 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
605 NameValue NVARCHAR(25) NOT NULL,
606 ViewValue NVARCHAR(250) NOT NULL,
607 OrderValue INT NOT NULL
608 );
609
610
611 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Luxueux', 'Matériaux de qualité exceptionnelle, marbre, céramique haut de gamme, douche surdimensionnée fait de verre et céramique, les appareils de plomberie sont des importations
612 et/ou au design sophistiqué', 1)
613 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Stylise', 'Bain sur pied ou autoportant et douche de céramique et verre, meuble lavabo de bonne qualité', 2)
614 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Repandu', 'Bain podium ou autre bain et douche céramique/acrylique, bain douche/douche blanc, meuble lavabo standard', 3)
615 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Simple' , 'Bain/douche ou bain de couleur autre que blanc et/ou en fonte ou douche plastique, meuble lavabo sans attrait particulier', 4 )
616 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Minimum', 'Une très petite douche de métal ou en plastique, lavabo rudimentaire', 5)
617
618END
619
620IF (NOT EXISTS (SELECT *
621 FROM INFORMATION_SCHEMA.TABLES
622 WHERE TABLE_SCHEMA = 'Propriete.Enum'
623 AND TABLE_NAME = 'B43DescriptionMeubleLavabo'))
624BEGIN
625
626 CREATE TABLE [Propriete.Enum].B43DescriptionMeubleLavabo (
627 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
628 NameValue NVARCHAR(25) NOT NULL,
629 ViewValue NVARCHAR(250) NOT NULL,
630 OrderValue INT NOT NULL
631 );
632
633 INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'SurMesure', 'Fait sur mesure, acquis chez un marchand spécialisé', 1)
634 INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BonneQualite', 'Meuble lavabo de bonne qualité', 2)
635 INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Standard', 'Meuble lavabo de qualité standard', 3)
636 INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Rudimentaire' , 'Meuble lavabo sans attrait/rudimentaire', 4 )
637
638END
639
640IF (NOT EXISTS (SELECT *
641 FROM INFORMATION_SCHEMA.TABLES
642 WHERE TABLE_SCHEMA = 'Propriete.Enum'
643 AND TABLE_NAME = 'B43MatDouche'))
644BEGIN
645
646 CREATE TABLE [Propriete.Enum].B43MatDouche (
647 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
648 NameValue NVARCHAR(25) NOT NULL,
649 ViewValue NVARCHAR(250) NOT NULL,
650 OrderValue INT NOT NULL
651 );
652
653 INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Acrylique', 'Acrylique', 1)
654 INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Ceramique', 'Céramique', 2)
655 INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Metal', 'Métal', 3)
656 INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Plastique' , 'Plastique', 4 )
657
658END
659
660IF (NOT EXISTS (SELECT *
661 FROM INFORMATION_SCHEMA.TABLES
662 WHERE TABLE_SCHEMA = 'Propriete.Enum'
663 AND TABLE_NAME = 'B43MatMeubleLavabo'))
664BEGIN
665
666 CREATE TABLE [Propriete.Enum].B43MatMeubleLavabo (
667 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
668 NameValue NVARCHAR(25) NOT NULL,
669 ViewValue NVARCHAR(250) NOT NULL,
670 OrderValue INT NOT NULL
671 );
672
673 INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Bois', 'Bois', 1)
674 INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Melamine', 'Melamine', 2)
675 INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Polyester', 'Polyester', 3)
676 INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Thermoplastique' , 'Thermoplastique', 4 )
677
678END
679
680IF (NOT EXISTS (SELECT *
681 FROM INFORMATION_SCHEMA.TABLES
682 WHERE TABLE_SCHEMA = 'Propriete.Enum'
683 AND TABLE_NAME = 'B43MatTourBain'))
684BEGIN
685
686 CREATE TABLE [Propriete.Enum].B43MatTourBain (
687 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
688 NameValue NVARCHAR(25) NOT NULL,
689 ViewValue NVARCHAR(250) NOT NULL,
690 OrderValue INT NOT NULL
691 );
692
693 INSERT INTO [Propriete.Enum].B43MatTourBain VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Ceramique', 'Céramique', 1)
694 INSERT INTO [Propriete.Enum].B43MatTourBain VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Plastique', 'Plastique', 2)
695
696END
697
698IF (NOT EXISTS (SELECT *
699 FROM INFORMATION_SCHEMA.TABLES
700 WHERE TABLE_SCHEMA = 'Propriete.Enum'
701 AND TABLE_NAME = 'B43Couleur'))
702BEGIN
703
704 CREATE TABLE [Propriete.Enum].B43Couleur (
705 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
706 NameValue NVARCHAR(25) NOT NULL,
707 ViewValue NVARCHAR(250) NOT NULL,
708 OrderValue INT NOT NULL
709 );
710
711 INSERT INTO [Propriete.Enum].B43Couleur VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Blanc', 'Blanc', 1)
712 INSERT INTO [Propriete.Enum].B43Couleur VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Couleur', 'Couleur', 2)
713
714END
715
716IF (NOT EXISTS (SELECT *
717 FROM INFORMATION_SCHEMA.TABLES
718 WHERE TABLE_SCHEMA = 'Propriete.Enum'
719 AND TABLE_NAME = 'B43DimensionSalleBain'))
720BEGIN
721
722 CREATE TABLE [Propriete.Enum].B43DimensionSalleBain (
723 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
724 NameValue NVARCHAR(25) NOT NULL,
725 ViewValue NVARCHAR(175) NOT NULL,
726 OrderValue INT NOT NULL
727 );
728
729 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'TresPetite', 'Tres petite (moins de 4 m² / 40 pi²)', 1)
730 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Petite' , 'Petite (de 4 à 8m² / 40 à 85 pi²)', 2 )
731 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Moyenne' , 'Moyenne (de 8 à 12m² / 85 à 130 pi²)', 3 )
732 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Grande' , 'Grande (de 12 à 16m² / 130 à 170 pi²)', 4 )
733 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Spacieuse' , 'Spacieuse (plus de 16m² / 170 pi²)', 5 )
734
735END
736
737IF (NOT EXISTS (SELECT *
738 FROM INFORMATION_SCHEMA.TABLES
739 WHERE TABLE_SCHEMA = 'Propriete.Enum'
740 AND TABLE_NAME = 'B44TypeChauffage'))
741BEGIN
742
743-- B44
744 CREATE TABLE [Propriete.Enum].B44TypeChauffage (
745 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
746 NameValue NVARCHAR(25) NOT NULL,
747 ViewValue NVARCHAR(175) NOT NULL,
748 Code NVARCHAR(2) NOT NULL,
749 OrderValue INT NOT NULL
750 );
751
752 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'FournaiseElectrique', 'Fournaise électrique', '1', 1)
753 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'FournaiseHuile' , 'Fournaise à l''huile' , '2', 2)
754 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'FournaiseGaz' , 'Fournaise à gaz' , '3', 3)
755 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'FournaiseBois' , 'Fournaise à bois' , '4', 4)
756 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Geothermie' , 'Géothermie' , '5', 5)
757 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('62424A37-5945-4809-9306-DA08F47179A7', 'PlintheElectrique' , 'Plinthe électrique' , '6', 6)
758
759
760END
761
762IF (NOT EXISTS (SELECT *
763 FROM INFORMATION_SCHEMA.TABLES
764 WHERE TABLE_SCHEMA = 'Propriete.Enum'
765 AND TABLE_NAME = 'B44TypeDistribChauf'))
766BEGIN
767
768 CREATE TABLE [Propriete.Enum].B44TypeDistribChauf (
769 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
770 NameValue NVARCHAR(25) NOT NULL,
771 ViewValue NVARCHAR(175) NOT NULL,
772 Code NVARCHAR(2) NOT NULL,
773 OrderValue INT NOT NULL
774 );
775
776
777 INSERT INTO [Propriete.Enum].B44TypeDistribChauf VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Aire', 'À air', '1', 1)
778 INSERT INTO [Propriete.Enum].B44TypeDistribChauf VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Eau', 'À eau', '3', 2)
779
780END
781
782IF (NOT EXISTS (SELECT *
783 FROM INFORMATION_SCHEMA.TABLES
784 WHERE TABLE_SCHEMA = 'Propriete.Enum'
785 AND TABLE_NAME = 'B44TypeClimatisation'))
786BEGIN
787
788 CREATE TABLE [Propriete.Enum].B44TypeClimatisation (
789 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
790 NameValue NVARCHAR(25) NOT NULL,
791 ViewValue NVARCHAR(175) NOT NULL,
792 Code NVARCHAR(2) NOT NULL,
793 OrderValue INT NOT NULL
794 );
795
796
797 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'ClimatiseurCentral', 'Climatiseur central', '1', 1)
798 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'ClimatiseurMural', 'Climatiseur mural', '2', 2)
799 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('33780049-8FBA-40E8-BBF4-57E5A7CADE14', 'ThermopompeCentrale' , 'Thermopompe centrale' , '2', 3)
800 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'ThermopompeMurale' , 'Thermopompe murale' , '4', 4)
801 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucun' , 'Aucun' , '8', 5)
802
803END
804
805IF (NOT EXISTS (SELECT *
806 FROM INFORMATION_SCHEMA.TABLES
807 WHERE TABLE_SCHEMA = 'Propriete.Enum'
808 AND TABLE_NAME = 'B44TypeDistribClim'))
809BEGIN
810
811 CREATE TABLE [Propriete.Enum].B44TypeDistribClim (
812 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
813 NameValue NVARCHAR(25) NOT NULL,
814 ViewValue NVARCHAR(175) NOT NULL,
815 Code NVARCHAR(2) NOT NULL,
816 OrderValue INT NOT NULL
817 );
818
819 INSERT INTO [Propriete.Enum].B44TypeDistribClim VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Exclusive' , 'Exclusive' , '1', 1)
820 INSERT INTO [Propriete.Enum].B44TypeDistribClim VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'PartageChauffage', 'Partage du chauffage', '2', 2)
821
822END
823
824
825IF (NOT EXISTS (SELECT *
826 FROM INFORMATION_SCHEMA.TABLES
827 WHERE TABLE_SCHEMA = 'Propriete.Enum'
828 AND TABLE_NAME = 'B59Appareils'))
829BEGIN
830
831 -- B59
832 CREATE TABLE [Propriete.Enum].B59Appareils (
833 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
834 NameValue NVARCHAR(25) NOT NULL,
835 ViewValue NVARCHAR(175) NOT NULL,
836 Code NVARCHAR(2) NOT NULL,
837 OrderValue INT NOT NULL
838 );
839
840
841 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Ascenseur' , 'Ascenseur' , '3', 1)
842 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'AspirateurCentral', 'Aspirateur central', '1', 2)
843 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Sauna' , 'Sauna' , '2', 3)
844 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'SpaInterieur' , 'Spa intérieur' , '4', 4)
845 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'SystemeAlarme' , 'Système d''alarme' , '5', 5)
846
847END
848
849IF (NOT EXISTS (SELECT *
850 FROM INFORMATION_SCHEMA.TABLES
851 WHERE TABLE_SCHEMA = 'Propriete.Enum'
852 AND TABLE_NAME = 'B59TypeFoyer'))
853BEGIN
854
855 CREATE TABLE [Propriete.Enum].B59TypeFoyer (
856 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
857 NameValue NVARCHAR(25) NOT NULL,
858 ViewValue NVARCHAR(175) NOT NULL,
859 Code NVARCHAR(2) NOT NULL,
860 OrderValue INT NOT NULL
861 );
862
863 INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'BoisGranule', 'Poêle à bois ou à granules', '4', 1)
864 INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Bois' , 'Foyer à bois' , '1', 2)
865 INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Granule' , 'Foyer à granule' , '2', 3)
866 INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Gaz' , 'Foyer à gaz' , '3', 4)
867
868END
869
870IF (NOT EXISTS (SELECT *
871 FROM INFORMATION_SCHEMA.TABLES
872 WHERE TABLE_SCHEMA = 'Propriete.Enum'
873 AND TABLE_NAME = 'B59TypeEtatSPA'))
874BEGIN
875
876 CREATE TABLE [Propriete.Enum].B59TypeEtatSPA (
877 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
878 NameValue NVARCHAR(25) NOT NULL,
879 ViewValue NVARCHAR(175) NOT NULL,
880 Code NVARCHAR(2) NOT NULL,
881 OrderValue INT NOT NULL
882 );
883
884
885 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Excellent' , 'Excellent' , '1', 1)
886 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'TresBon' , 'Tres bon' , '2', 2)
887 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Acceptable', 'Acceptable', '3', 3)
888 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'Mediocre' , 'Médiocre' , '4', 4)
889 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'Delabre' , 'Délabré' , '5', 5)
890
891END
892
893IF (NOT EXISTS (SELECT *
894 FROM INFORMATION_SCHEMA.TABLES
895 WHERE TABLE_SCHEMA = 'Propriete.Enum'
896 AND TABLE_NAME = 'B62TypeFondGarAttache'))
897BEGIN
898-- B62
899
900 CREATE TABLE [Propriete.Enum].B62TypeFondGarAttache (
901 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
902 NameValue NVARCHAR(25) NOT NULL,
903 ViewValue NVARCHAR(175) NOT NULL,
904 Code NVARCHAR(2) NOT NULL,
905 OrderValue INT NOT NULL
906 );
907
908 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Muret' , 'Muret' , '3', 1)
909 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Piliers' , 'Piliers' , '1', 2)
910 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'PiliersExacve', 'Piliers excavés', '2', 3)
911 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'Radier' , 'Radier' , '4', 4)
912 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'Sole' , 'Sole' , '5', 5)
913 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'SousSol' , 'Sous-sol' , '6', 6)
914 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'VideSanitaire', 'Vide sanitaire', '7', 7)
915
916
917END
918
919IF (NOT EXISTS (SELECT *
920 FROM INFORMATION_SCHEMA.TABLES
921 WHERE TABLE_SCHEMA = 'Propriete.Enum'
922 AND TABLE_NAME = 'B63AireRemise'))
923BEGIN
924 -- B63
925 CREATE TABLE [Propriete.Enum].B63AireRemise (
926 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
927 NameValue NVARCHAR(25) NOT NULL,
928 ViewValue NVARCHAR(175) NOT NULL,
929 M2 DECIMAL,
930 OrderValue INT NOT NULL
931 );
932
933 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '3B52CCFA-5514-4143-B697-DD897C4981EB', '8x8', '8 X 8 (pi) / 2.5 X 2.5 (m)' , '6.25', 1)
934 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( 'A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '8x12', '8 X 10 (pi) / 2.5 X 3 (m)' , '7.5', 2)
935 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( 'F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '10x10', '10 X 10 (pi) / 3 X 3 (m)' , '9', 3)
936 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '64043AFD-2FF8-43A6-A04A-545214B9A7E4', '10x12', '10 X 12 (pi) / 3 X 3.7 (m)' , '11.1', 4)
937 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', '12x12', '12 X 12 (pi) / 3.7 X 3.7 (m)' , '13.69', 5)
938 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', '12x14', '12 X 14 (pi) / 3.7 X 4.3 (m)' , '15.91', 6)
939 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '7B3BB3A7-4373-410C-B3E7-DA08F47179A7', '12x16', '12 X 16 (pi) / 3.7 X 4.9 (m)' , '18.13', 7)
940 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '3B9C3BBE-F092-4829-A0DD-BA055F626556', '14x14', '14 X 14 (pi) / 4.3 X 4.3 (m)' , '18.49', 8)
941
942END
943
944IF (NOT EXISTS (SELECT *
945 FROM INFORMATION_SCHEMA.TABLES
946 WHERE TABLE_SCHEMA = 'Propriete.Enum'
947 AND TABLE_NAME = 'B71TypePiscine'))
948BEGIN
949-- B71
950
951CREATE TABLE [Propriete.Enum].B71TypePiscine (
952 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
953 NameValue NVARCHAR(25) NOT NULL,
954 ViewValue NVARCHAR(175) NOT NULL,
955 Code NVARCHAR(2) NOT NULL,
956 OrderValue INT NOT NULL
957);
958
959INSERT INTO [Propriete.Enum].B71TypePiscine VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Creusee' , 'Creusée' , '1', 1)
960INSERT INTO [Propriete.Enum].B71TypePiscine VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'SemiCreusee', 'Semi-creusée', '2', 2)
961INSERT INTO [Propriete.Enum].B71TypePiscine VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'HorsTerre' , 'Hors-terre' , '3', 3)
962
963END
964
965IF (NOT EXISTS (SELECT *
966 FROM INFORMATION_SCHEMA.TABLES
967 WHERE TABLE_SCHEMA = 'Propriete.Enum'
968 AND TABLE_NAME = 'B71TypeEtatPiscine'))
969BEGIN
970
971 CREATE TABLE [Propriete.Enum].B71TypeEtatPiscine (
972 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
973 NameValue NVARCHAR(25) NOT NULL,
974 ViewValue NVARCHAR(175) NOT NULL,
975 Code NVARCHAR(2) NOT NULL,
976 OrderValue INT NOT NULL
977 );
978
979
980 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Excellent' , 'Excellent' , '1', 1)
981 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'TresBon' , 'Très bon' , '2', 2)
982 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Acceptable', 'Acceptable', '3', 3)
983 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'Mediocre' , 'Médiocre' , '4', 4)
984 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'Delabre' , 'Délabré' , '5', 5)
985
986END
987
988IF (NOT EXISTS (SELECT *
989 FROM INFORMATION_SCHEMA.TABLES
990 WHERE TABLE_SCHEMA = 'Propriete.Enum'
991 AND TABLE_NAME = 'B71TypeFormePiscine'))
992BEGIN
993
994 CREATE TABLE [Propriete.Enum].B71TypeFormePiscine (
995 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
996 NameValue NVARCHAR(25) NOT NULL,
997 ViewValue NVARCHAR(175) NOT NULL,
998 Code NVARCHAR(2) NOT NULL,
999 OrderValue INT NOT NULL
1000 );
1001
1002 INSERT INTO [Propriete.Enum].B71TypeFormePiscine VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Ronde', 'Ronde', '1', 1)
1003 INSERT INTO [Propriete.Enum].B71TypeFormePiscine VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Autre', 'Autre', '2', 2)
1004
1005END
1006
1007
1008IF (NOT EXISTS (SELECT *
1009 FROM INFORMATION_SCHEMA.TABLES
1010 WHERE TABLE_SCHEMA = 'Propriete.Enum'
1011 AND TABLE_NAME = 'B71MatStationnement'))
1012BEGIN
1013
1014 CREATE TABLE [Propriete.Enum].B71MatStationnement (
1015 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1016 NameValue NVARCHAR(25) NOT NULL,
1017 ViewValue NVARCHAR(175) NOT NULL,
1018 Code NVARCHAR(2) NOT NULL,
1019 OrderValue INT NOT NULL
1020 );
1021
1022
1023 INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Asphalte' , 'Asphalte' , '16', 1)
1024 INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Beton' , 'Béton' , '10', 2)
1025 INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Concasse' , 'Concassé' , '43', 3)
1026 INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'DaleImbrique', 'Dale imbriquée/inter bloc', '15', 4)
1027
1028END
1029
1030IF (NOT EXISTS (SELECT *
1031 FROM INFORMATION_SCHEMA.TABLES
1032 WHERE TABLE_SCHEMA = 'General.Enum'
1033 AND TABLE_NAME = 'UniteMesure'))
1034BEGIN
1035
1036 CREATE TABLE [General.Enum].UniteMesure (
1037 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1038 NameValue NVARCHAR(25) NOT NULL,
1039 ViewValue NVARCHAR(175) NOT NULL,
1040 Code NVARCHAR(2) NOT NULL,
1041 OrderValue INT NOT NULL
1042 );
1043
1044 INSERT INTO [General.Enum].UniteMesure VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Pieds', 'Pieds', '1', 1)
1045 INSERT INTO [General.Enum].UniteMesure VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Metre', 'Mètres', '2', 2)
1046
1047END
1048
1049IF (NOT EXISTS (SELECT *
1050 FROM INFORMATION_SCHEMA.TABLES
1051 WHERE TABLE_SCHEMA = 'Propriete.Enum'
1052 AND TABLE_NAME = 'FraisExploitation'))
1053BEGIN
1054
1055 CREATE TABLE [Propriete.Enum].FraisExploitation (
1056 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1057 NameValue NVARCHAR(25) NOT NULL,
1058 ViewValue NVARCHAR(175) NOT NULL,
1059 OrderValue INT NOT NULL
1060 );
1061
1062
1063 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'Administration', 'Administration', 1 )
1064 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'Assurance', 'Assurance', 2 )
1065 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Chauffage', 'Chauffage (combustible)', 3 )
1066 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('659AA197-DBBA-4D7C-A8D8-5C08F0633FE8', 'ContetantSanitaire', 'Contenant sanitaire (location)', 4 )
1067 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'Deneigement', 'Déneigement', 5 )
1068 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Electricite', 'Électricité', 6 )
1069 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'EntretientReparation', 'Entretien et réparations', 7 )
1070 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('E2787FB1-F2B9-4BBF-8531-97832CE1B76A', 'FraisConciergerie', 'Frais conciergerie', 8 )
1071 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('3B9C3BBE-F092-4829-A0DD-BA055F626556', 'HonoraireProfessionnel', 'Honoraire professionnels', 9 )
1072 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('A02E292E-620F-482A-B0B6-9586B3A9AD54', 'Publicite', 'Publicité', 10 )
1073 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('469B2334-6FEF-4BAF-A04D-4050D40B0C22', 'ReserveRemplacement', 'Réserve de remplacement', 11 )
1074 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('E995017A-A2CC-4B70-8D0E-D5AF1917C78E', 'SalaireAvantageSociaux', 'Salaire et avantages sociaux', 12 )
1075 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'TaxeFonciereScolaire', 'Taxes foncières et scolaires', 13)
1076 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('B0349FA8-BD80-4C36-B329-4B1518EAABE4', 'AutreDepense', 'Autre dépenses', 14 )
1077
1078END
1079
1080IF (NOT EXISTS (SELECT *
1081 FROM INFORMATION_SCHEMA.TABLES
1082 WHERE TABLE_SCHEMA = 'Propriete.Enum'
1083 AND TABLE_NAME = 'RevenusLocation'))
1084BEGIN
1085
1086 CREATE TABLE [Propriete.Enum].RevenusLocation (
1087 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1088 NameValue NVARCHAR(25) NOT NULL,
1089 ViewValue NVARCHAR(175) NOT NULL,
1090 OrderValue INT NOT NULL
1091 );
1092
1093 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Commerces', 'Commerces', 1)
1094 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Logements', 'Logements', 2)
1095 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'RecupFraisExpl', 'Récuperation des frais d''exploitation', 3)
1096 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'RevenusStationnement', 'Revenus de stationnement', 4)
1097 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'AutreRevenus', 'Autre revenus', 5)
1098
1099END
1100
1101GO