· 6 years ago · Apr 12, 2019, 05:20 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 = 'B09Services'))
65BEGIN
66
67 CREATE TABLE [Propriete.Enum].B09Services (
68 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
69 NameValue NVARCHAR(25) NOT NULL,
70 ViewValue NVARCHAR(175) NOT NULL,
71 OrderValue INT NOT NULL
72 );
73
74 INSERT INTO [Propriete.Enum].B09Services VALUES ('70EC4F0B-6FA1-490D-AB1B-A8F819A3D75B', 'Ascenseur', 'Ascenseur', 1)
75 INSERT INTO [Propriete.Enum].B09Services VALUES ('59FBBA59-0ED9-48C9-97E1-F0A937E3E3A5', 'Buanderie', 'Buanderie', 2)
76 INSERT INTO [Propriete.Enum].B09Services VALUES ('F7CA83E1-9246-4C0A-B301-39EF56F25D29', 'CommerceUtilite', 'Commerce d''utilité', 3)
77 INSERT INTO [Propriete.Enum].B09Services VALUES ('92C89F3E-29DF-4003-9B19-E1D357BB23A8', 'PiscineExt', 'Piscine extérieure', 4)
78 INSERT INTO [Propriete.Enum].B09Services VALUES ('10E7DD1E-6AD2-4486-B08D-53DEACADC0F2', 'PiscineInt', 'Piscine intérieure', 5)
79 INSERT INTO [Propriete.Enum].B09Services VALUES ('85D5F0AE-10E1-40CF-A541-4B342F01F9BC', 'PiscineToit', 'Piscine sur le toit', 6)
80 INSERT INTO [Propriete.Enum].B09Services VALUES ('D5E94047-7D58-4B85-BB3B-3EE25CCE7CB8', 'Sauna', 'Sauna', 7)
81 INSERT INTO [Propriete.Enum].B09Services VALUES ('6913092E-EC3F-4A15-8867-2B5A9579902D', 'SalleCommunautaire', 'Salle communautaire', 8)
82 INSERT INTO [Propriete.Enum].B09Services VALUES ('6659AC76-2C0F-41D5-94AB-E69A99C81185', 'SalleExercice', 'Salle d''exercice', 9)
83 INSERT INTO [Propriete.Enum].B09Services VALUES ('F8E7353D-B676-4BC5-B499-7E1401D3453C', 'SpaExt', 'Spa extérieur', 10)
84 INSERT INTO [Propriete.Enum].B09Services VALUES ('BACCA12B-4B14-4F64-B210-14BC713D8679', 'SpaInt', 'Spa intérieur', 11)
85 INSERT INTO [Propriete.Enum].B09Services VALUES ('E9D4121A-D0A6-4FFF-9B3C-54F63447773F', 'SystemeSurveillance', 'Système de surveillance', 12)
86 INSERT INTO [Propriete.Enum].B09Services VALUES ('83AA935B-51A7-461D-8763-9911C2AF8363', 'SystemeInterphones', 'Système d''interphones', 13)
87
88END;
89
90
91IF (NOT EXISTS (SELECT *
92 FROM INFORMATION_SCHEMA.TABLES
93 WHERE TABLE_SCHEMA = 'Propriete.Enum'
94 AND TABLE_NAME = 'B15MatFondation'))
95BEGIN
96
97 CREATE TABLE [Propriete.Enum].B15MatFondation (
98 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
99 NameValue NVARCHAR(25) NOT NULL,
100 ViewValue NVARCHAR(175) NOT NULL,
101 Code NVARCHAR(2) NOT NULL,
102 Materiau NVARCHAR(25) NOT NULL,
103 Type NVARCHAR(25) NOT NULL,
104 OrderValue INT NOT NULL
105 );
106
107 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('9DD44770-C90C-4EF7-AC43-EA2D5C4B8A8C', 'BetonCoule' , 'Béton coulé' , '4', 'Beton', 'Lourd', 1)
108 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('E8725EFC-BC00-4D2E-9583-1AD95C777262', 'BlocBeton' , 'Bloc de béton' , '4', 'Beton', 'Lourd', 2)
109 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('CB1521E7-0A27-4FD6-BFF0-543BDC59F505', 'PilierExcaveMetal', 'Pilier excavé en métal', '2', 'Beton', 'Lourd', 3)
110 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('D1012019-4567-4DA8-AD6C-A072A40AD2AC', 'PilierExcaveBeton', 'Pilier excavé en béton', '2', 'Beton', 'Lourd', 4)
111 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('98F9885A-69DE-4D5A-9A21-F227D0192642', 'PilierBlocBeton' , 'Pilier en bloc de béton' , '1', 'Beton', 'Lourd', 5)
112 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('3433D38E-9C43-4D9F-9501-D5CEE65D58CD', 'PilierMetal' , 'Pilier en metal' , '1', 'Beton', 'Lourd', 6)
113 INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('2688EAF7-711A-4FA3-8DCA-92B26A2CB398', 'PilierCageBois' , 'Pilier en cage de bois' , '1', 'Brique', 'Lourd', 7)
114
115END
116-- B22
117
118-- Images
119IF (NOT EXISTS (SELECT *
120 FROM INFORMATION_SCHEMA.TABLES
121 WHERE TABLE_SCHEMA = 'Propriete.Enum'
122 AND TABLE_NAME = 'B22TypePorteFacade'))
123BEGIN
124
125 CREATE TABLE [Propriete.Enum].B22TypePorteFacade (
126 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
127 NameValue NVARCHAR(25) NOT NULL,
128 ViewValue NVARCHAR(175) NOT NULL,
129 OrderValue INT NOT NULL
130 );
131
132 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('87746D8D-FF3C-4CB4-955B-BA79E856E795', '1', '1', 1)
133 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('F703BB10-B643-4519-B286-CB705B80C9CD', '2', '2', 2)
134 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('F1959FD5-DF98-441C-803F-A6AD18DC756D', '3', '3', 3)
135 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('61F277E3-8BAD-4D06-BC4E-12BEAA44A73C', '4', '4', 4)
136 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('1D267804-ABBC-4566-A4F4-5AD52E3CF045', '5', '5', 5)
137 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('77BEC2CE-9C23-4565-97F2-E47230327766', '6', '6', 6)
138 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('82B4E646-3E11-46D4-B429-71CCD78CB9BD', '7', '7', 7)
139 INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('2AF8B003-2C2A-4ADB-B7F4-71FA65440E1B', '8', '8', 8)
140
141END
142
143
144IF (NOT EXISTS (SELECT *
145 FROM INFORMATION_SCHEMA.TABLES
146 WHERE TABLE_SCHEMA = 'Propriete.Enum'
147 AND TABLE_NAME = 'B22TypeFenetreFacade'))
148BEGIN
149
150 CREATE TABLE [Propriete.Enum].B22TypeFenetreFacade (
151 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
152 NameValue NVARCHAR(25) NOT NULL,
153 ViewValue NVARCHAR(175) NOT NULL,
154 OrderValue INT NOT NULL
155 );
156
157 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('9ED9E0B6-CC20-488C-9DD7-C98096B4E4DB', '1', '1', 1)
158 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('E1A04AE5-67C4-4BB0-B2D5-D970F67E567D', '2', '2', 2)
159 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('50E8D4EF-5983-498B-AB47-ECC254689515', '3', '3', 3)
160 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('E133B635-C665-40A1-B445-1474B86E45DA', '4', '4', 4)
161 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('65A4A8E8-E051-4811-A5CB-E04D096BBBC8', '5', '5', 5)
162 INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('4C1BC118-BD0F-4BBF-A844-207429BB5AF9', '6', '6', 6)
163
164END
165
166IF (NOT EXISTS (SELECT *
167 FROM INFORMATION_SCHEMA.TABLES
168 WHERE TABLE_SCHEMA = 'Propriete.Enum'
169 AND TABLE_NAME = 'B22ChoixAngle'))
170BEGIN
171
172 CREATE TABLE [Propriete.Enum].B22ChoixAngle (
173 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
174 NameValue NVARCHAR(25) NOT NULL,
175 ViewValue NVARCHAR(175) NOT NULL,
176 OrderValue INT NOT NULL
177 );
178
179
180 INSERT INTO [Propriete.Enum].B22ChoixAngle VALUES ('4668CD8B-85B6-462F-9280-AE237A1D1DFD', '4-6' , '4-6', 1 )
181 INSERT INTO [Propriete.Enum].B22ChoixAngle VALUES ('E868B155-1340-4F58-BD6C-883550729CF8', '7-10', '7-10', 2)
182 INSERT INTO [Propriete.Enum].B22ChoixAngle VALUES ('E4FE4175-3C6D-4CA4-9FEA-2D66B098CA4A', '>10' , '> 10', 3 )
183
184END
185
186IF (NOT EXISTS (SELECT *
187 FROM INFORMATION_SCHEMA.TABLES
188 WHERE TABLE_SCHEMA = 'Propriete.Enum'
189 AND TABLE_NAME = 'B22RevetementExtMur'))
190BEGIN
191
192 CREATE TABLE [Propriete.Enum].B22RevetementExtMur (
193 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
194 NameValue NVARCHAR(25) NOT NULL,
195 ViewValue NVARCHAR(175) NOT NULL,
196 Code NVARCHAR(2) NOT NULL,
197 Materiau NVARCHAR(25) NOT NULL,
198 Type NVARCHAR(25) NOT NULL,
199 OrderValue INT NOT NULL
200 );
201
202 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('E5184235-6733-4A39-9A20-4F1A1E7CDAF7', 'Aluminium' , 'Aluminium' , '50', 'Metal', 'Leger', 1)
203 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('F7D4B87A-D9F8-4825-B465-91670712D79A', 'AluminiumEmaillee' , 'Aluminium émaillée' , '50', 'Metal', 'Leger', 2)
204 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('68D76E66-2D34-4755-A47A-380E88610F06', 'Amiante' , 'Amiante' , '70', 'Synthetique', 'Leger', 3)
205 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('F12501C5-D24C-445C-AF6D-16C62AA919B8', 'BardeauAmiante' , 'Bardeau d''amiante' , '70', 'Synthetique', 'Leger', 4)
206 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('CF7B62EB-8097-4C64-964E-59A0ACDB8AF2', 'BardeauAsphalte' , 'Bardeau d''asphalte' , '70', 'Synthetique', 'Leger', 5)
207 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('DFA648EA-B646-4236-8060-6D4003CF6763', 'BardeauBois' , 'Bardeau de bois' , '60', 'Bois', 'Leger', 6)
208 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('DE36583E-3644-4B36-A1F1-5E7C7D4539AF', 'BlocBeton' , 'Bloc de béton' , '10', 'Beton', 'Lourd', 7)
209 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('8954F501-AA06-4072-9C11-E31959E082CE', 'Beton' , 'Béton' , '10', 'Beton', 'Lourd', 8)
210 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('57CC17DE-72CB-4A8B-822C-7A805C765CE8', 'BetonPrefabrique' , 'Béton préfabriqué' , '10', 'Beton', 'Lourd', 9)
211 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('744E7431-23ED-40E1-825F-FBBB1F52331F', 'PanneauxPrefabBeton', 'Panneaux préfabriqués en béton', '10', 'Beton', 'Lourd', 10)
212 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('F5B45972-0C29-44DD-BE19-B30D4074F05A', 'Brique' , 'Brique' , '32', 'Brique', 'Lourd', 11)
213 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('2E62636C-7A07-41A1-88BC-A09CD859116B', 'BriqueAutoportante' , 'Brique autoportante' , '40', 'Brique', 'Lourd', 12)
214 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('318AFD7D-FDC0-4305-9134-621F41B05ED5', 'Ceramique' , 'Céramique' , '32', 'Brique', 'Lourd', 13)
215 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('4E880D0B-EEE2-49C0-95DA-9D5C7ADE71AA', 'Cinyle' , 'Cinyle' , '70', 'Synthetique', 'Leger', 14)
216 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('E4832F2A-8E56-4165-8E50-AD429030764E', 'ContrePlaque' , 'Contreplaqué' , '60', 'Bois', 'Leger', 15)
217 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('38207410-0242-43D8-9C0F-A937A44AA0CC', 'Copolymere' , 'Copolymère' , '60', 'Bois', 'Leger', 16)
218 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('88CDFEDD-C318-4C9E-A83E-EF9390385725', 'DeclinBois' , 'Déclin de bois' , '60', 'Bois', 'Leger', 17)
219 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('7724D108-922B-42AB-BC09-AA11578E4970', 'DeclinFibrePressee' , 'Déclin de fibre pressée' , '65', 'Fibre', 'Leger', 18)
220 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('B2858A11-0038-4287-9713-5AFCD10760E5', 'Marbre' , 'Marbre' , '37', 'Pierre', 'Lourd', 19)
221 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('603E2652-12FC-4D83-AE1D-D52EC542B775', 'MarbrePoli' , 'Marbre poli' , '37', 'Pierre', 'Lourd', 20)
222 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('6FA31A6D-5498-4174-9E91-B2EB5FCA5CAA', 'PierreChamps' , 'Pierre des champs' , '37', 'Pierre', 'Lourd', 21)
223 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('735E18AC-A8A9-4846-AF74-93F426596478', 'PierreDressee' , 'Pierre dressée' , '37', 'Pierre', 'Lourd', 22)
224 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('5B6EAA72-B121-4D66-B67D-1ABBC17F0CBC', 'PierreFendue' , 'Pierre fendue' , '37', 'Pierre', 'Lourd', 23)
225 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('7C892A72-EB6B-4942-B8D9-193D01631E15', 'PierreSimili' , 'Pierre de simili' , '37', 'Pierre', 'Lourd', 24)
226 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('1545C9E2-0137-4CEA-B808-332A5BEFB02F', 'PierreTaillee' , 'Pierre taillée' , '37', 'Pierre', 'Lourd', 25)
227 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('E1B517EF-A87B-444F-A756-A8E09091A5FC', 'PierreTailleePolie' , 'Pierre taillée polie' , '37', 'Pierre', 'Lourd', 26)
228 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('585450D4-039A-41DE-BF46-06E795FEFE51', 'Pierre' , 'Pierre' , '37', 'Pierre', 'Lourd', 27)
229 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('73F7A5FA-0573-425B-8A3E-4CCB06FAF3CB', 'Planche' , 'Planche' , '60', 'Bois', 'Leger', 28)
230 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('E79F9EC4-FFA9-48C0-964B-E7298B93B078', 'StucAgregat' , 'Stuc/agrégat' , '94', 'EnduitFinition', 'Leger', 29)
231 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('7ED897B4-DA3E-4A1A-BC30-D43C7800037A', 'Tole' , 'Tôle' , '90', 'Metal', 'Leger', 30)
232 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('D0AAB01A-235D-4CD4-925E-E382D68B9739', 'ToleEmaillee' , 'Tôle émaillée' , '50', 'Metal', 'Leger', 31)
233 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('B9D4B6C4-B9B3-4B80-BC8F-0C971A31327B', 'Verre' , 'Verre' , '20', 'Verre', 'Lourd', 32)
234 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('F25F6334-432F-4A57-97E6-BC7B2EBCD56C', 'Autre' , 'Autre' , '40', '', '', 33)
235 INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('5BEBCC2B-2C12-43AE-B046-F434486FF2BF', 'Aucun' , 'Aucun' , '99', '', '', 33)
236
237END
238-- B23
239
240IF (NOT EXISTS (SELECT *
241 FROM INFORMATION_SCHEMA.TABLES
242 WHERE TABLE_SCHEMA = 'Propriete.Enum'
243 AND TABLE_NAME = 'B23RevetementToit'))
244BEGIN
245
246 CREATE TABLE [Propriete.Enum].B23RevetementToit (
247 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
248 NameValue NVARCHAR(25) NOT NULL,
249 ViewValue NVARCHAR(175) NOT NULL,
250 OrderValue INT NOT NULL
251 );
252
253
254 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('8FC2E04B-A9AE-4B84-BB2E-A46194983CF4', 'BardeauAsphalte', 'Bardeau d''asphalte', 1)
255 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('E0EC01CD-3FB4-41A1-8101-21845BD74A9F', 'BardeauBois' , 'Bardeau de bois', 2 )
256 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('A2495A60-175A-45B1-A56A-722DF3538D7A', 'Cuivre' , 'Cuivre', 3 )
257 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('EB3F81B5-21B7-48AB-A691-9B21804CEEAE', 'Membrane' , 'Membrane', 4 )
258 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('E0C3B8B0-049F-42DB-990D-0913C10C0D87', 'Metal' , 'Métal', 5 )
259 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('BB787874-8570-490E-9DE5-5D7FBE83D75F', 'Tuile' , 'Tuile', 6 )
260 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('630F0E15-3428-4B3E-B163-24D26236354B', 'Verre' , 'Verre', 7 )
261 INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('48D19E62-31CF-44EA-9E46-3EC351ABFEE8', 'Autre' , 'Autre', 8 )
262
263END
264
265IF (NOT EXISTS (SELECT *
266 FROM INFORMATION_SCHEMA.TABLES
267 WHERE TABLE_SCHEMA = 'Propriete.Enum'
268 AND TABLE_NAME = 'B23NbVersants'))
269BEGIN
270
271 CREATE TABLE [Propriete.Enum].B23NbVersants (
272 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
273 NameValue NVARCHAR(25) NOT NULL,
274 ViewValue NVARCHAR(175) NOT NULL,
275 OrderValue INT NOT NULL
276 );
277
278 INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('11687ECC-3467-4404-A496-7644842EB5C7', '1a2', '1 Ã 2', 1)
279 INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('B19E8344-5EF9-48A6-B69F-242DCEAF0CD0', '3a4' , '3 Ã 4 ou toit plat', 2 )
280 INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('A79D0CCA-FE63-466A-9C0A-AF7DAEBDF496', '5a8' , '5 Ã 8', 3 )
281 INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('8501C608-D02C-4909-93F2-AA379AD549D8', '9plus' , '9 et +', 4 )
282
283END
284-- B33
285
286IF (NOT EXISTS (SELECT *
287 FROM INFORMATION_SCHEMA.TABLES
288 WHERE TABLE_SCHEMA = 'Propriete.Enum'
289 AND TABLE_NAME = 'B33QualitePorteInt'))
290BEGIN
291
292 CREATE TABLE [Propriete.Enum].B33QualitePorteInt (
293 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
294 NameValue NVARCHAR(25) NOT NULL,
295 ViewValue NVARCHAR(175) NOT NULL,
296 OrderValue INT NOT NULL
297 );
298
299
300 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('FB44C086-1990-4BB9-9698-436FF2F8C110', 'Luxueux' , 'Portes luxueuses, faites sur mesure, au desgin unique', 1 )
301 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('A8B750E7-A160-49FD-8E81-68E42168CAA8', 'Superieur', 'Portes au cachet supérieur, portes françaises, escamotables, en bois pleines, coulissantes non courrantes', 2)
302 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('54F60F49-164F-4D66-96E0-A2BE288E4F49', 'Courant' , 'Portes de type courant, avec certains motifs', 3 )
303 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('739BF7E7-FB07-49B1-B141-912961319DC1', 'Unie' , 'Portes simples unies et sans attrait', 4 )
304 INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('C825AC29-109B-48B4-BE62-A266B67DF49F', 'Aucune' , 'Aucune porte', 5 )
305
306END
307
308
309IF (NOT EXISTS (SELECT *
310 FROM INFORMATION_SCHEMA.TABLES
311 WHERE TABLE_SCHEMA = 'Propriete.Enum'
312 AND TABLE_NAME = 'B33QualiteOrnement'))
313BEGIN
314
315 CREATE TABLE [Propriete.Enum].B33QualiteOrnement (
316 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
317 NameValue NVARCHAR(25) NOT NULL,
318 ViewValue NVARCHAR(175) NOT NULL,
319 OrderValue INT NOT NULL
320 );
321
322
323 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('8F211266-AA51-451E-8627-ED1DDC76DB08', 'Extraordinaire', 'Cachet extraordinaire, profusion de moulures larges et lambris coûteux, design intérieur somptueux et architectural', 1)
324 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('A2622689-B74A-4886-990A-1281B1B9BCC6', '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 )
325 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('9AD67D0C-400B-437D-99DF-71BD41CB998E', 'Quelques' , 'Quelques moulures décoratives et/ou présence de lambris standard et luminaires courants répondant aux besoins usuels', 3 )
326 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('0D63618C-DCEA-4379-9364-591ED79DC165', 'Minimale' , 'Ornementation minimale, moulures bas de gamme et luminaires modestes et peu nombreux', 4 )
327 INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('B370C62F-86E4-4F65-BA1E-96DDCA9067CE', 'Aucune' , 'Aucune moulure, finition peu harmonieuse et luminaires de type plafonnier', 5 )
328
329END
330
331IF (NOT EXISTS (SELECT *
332 FROM INFORMATION_SCHEMA.TABLES
333 WHERE TABLE_SCHEMA = 'Propriete.Enum'
334 AND TABLE_NAME = 'B33QualiteEscalierInt'))
335BEGIN
336
337 CREATE TABLE [Propriete.Enum].B33QualiteEscalierInt (
338 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
339 NameValue NVARCHAR(25) NOT NULL,
340 ViewValue NVARCHAR(175) NOT NULL,
341 OrderValue INT NOT NULL
342 );
343
344 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('A410D90A-CD33-4E35-B3C6-A875E9CBFC7C', 'Luxueux', 'Matériaux luxueux au design unique, avec courbes, angles', 1 )
345 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('BD50CA14-5154-4C36-B7DC-576552F6370E', 'Design' , 'Matériaux et designs particuliers et/ou avec angle ou paliers', 2 )
346 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('D27CACB6-C6C2-40E4-8C5D-6EF1D6E385D3', 'Courant', 'Matériaux et designs courants, rectiligne ou à paliers en bois franc', 3 )
347 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('573BF990-6E79-4CAD-A3ED-B3EC5E0D845B', 'Modeste', 'Escalier modeste, fonctionnel et sans particularité', 4 )
348 INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('6289B4B6-517A-48C1-A8A1-39D20A4C7EEA', 'Aucune', 'Aucune finition', 5 )
349
350END
351
352IF (NOT EXISTS (SELECT *
353 FROM INFORMATION_SCHEMA.TABLES
354 WHERE TABLE_SCHEMA = 'Propriete.Enum'
355 AND TABLE_NAME = 'B33MatPlafond'))
356BEGIN
357
358 CREATE TABLE [Propriete.Enum].B33MatPlafond (
359 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
360 NameValue NVARCHAR(25) NOT NULL,
361 ViewValue NVARCHAR(175) NOT NULL,
362 Code NVARCHAR(2) NOT NULL,
363 OrderValue INT NOT NULL
364 );
365
366
367 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('BF1C996F-528B-41C6-A021-9EEF592B09FB', 'BoisMou' , 'Bois mou' , '63', 1)
368 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('6D5469E2-4523-434F-B9F2-515DE9C6AA7E', 'ContreplaquePrefini', 'Contreplaqué préfini', '64', 2)
369 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('140A8281-C92B-4AD7-A792-DEDBA809904C', 'Fibre' , 'Fibre' , '65', 3)
370 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('B5FE31B0-60A0-4719-BFA9-DF4DA712FBD9', 'PanneauGypse' , 'Panneau de gypse' , '93', 4)
371 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('523765BB-BB8F-4314-B1EA-FF4AF57328C3', 'Autre' , 'Autre' , '90', 5)
372 INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('B09A38EE-68D1-4CEF-AF8F-314BAD102451', 'Aucun' , 'Aucun' , '99', 6)
373
374END
375
376IF (NOT EXISTS (SELECT *
377 FROM INFORMATION_SCHEMA.TABLES
378 WHERE TABLE_SCHEMA = 'Propriete.Enum'
379 AND TABLE_NAME = 'B33MatMur'))
380BEGIN
381
382 CREATE TABLE [Propriete.Enum].B33MatMur (
383 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
384 NameValue NVARCHAR(25) NOT NULL,
385 ViewValue NVARCHAR(175) NOT NULL,
386 Code NVARCHAR(2) NOT NULL,
387 OrderValue INT NOT NULL
388 );
389
390 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('665E300D-5BAA-4A07-B226-A8B6FDBF9822', 'BoisMou' , 'Bois mou' , '63', 1)
391 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('3FA7BF93-04AB-477D-A944-EC971A562C6E', 'ContreplaquePrefini', 'Contreplaqué préfini', '64', 2)
392 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('B3A68085-3DBC-4F9F-88EC-6079AADAD905', 'Fibre' , 'Fibre' , '65', 3)
393 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('8CAE1068-FB05-4BCD-A957-54523D9BB41D', 'PanneauGypse' , 'Panneau de gypse' , '93', 4)
394 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('01470D68-2523-49F7-8538-7CDB52F44506', 'Autre' , 'Autre' , '90', 5)
395 INSERT INTO [Propriete.Enum].B33MatMur VALUES ('B5952360-3D1E-44A3-A4F4-5C10028D2189', 'Aucun' , 'Aucun' , '99', 6)
396
397END
398
399IF (NOT EXISTS (SELECT *
400 FROM INFORMATION_SCHEMA.TABLES
401 WHERE TABLE_SCHEMA = 'Propriete.Enum'
402 AND TABLE_NAME = 'B33MatMurPlafond'))
403BEGIN
404 -- TODO: Change QC for plafond and mur
405 CREATE TABLE [Propriete.Enum].B33MatMurPlafond (
406 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
407 NameValue NVARCHAR(25) NOT NULL,
408 ViewValue NVARCHAR(175) NOT NULL,
409 Code NVARCHAR(2) NOT NULL,
410 OrderValue INT NOT NULL
411 );
412
413
414 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('F6176DD0-69B9-477B-A3A4-089A26DD492A', 'BoisMou' , 'Bois mou' , '63', 1)
415 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('2248AFFA-1CFA-4E73-A795-A526538840DA', 'ContreplaquePrefini', 'Contreplaque préfini', '64', 2)
416 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('03253889-5758-44D5-A371-F323490FCCBE', 'PanneauGypse' , 'Panneau de gypse' , '93', 3)
417 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('BCD71FB7-3162-4409-B9BF-08326D5BBB61', 'PlafondExpanse' , 'Plafond expansé' , '90', 4)
418 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('924978A1-BC39-4FD1-8B6C-5CC7B78C73D0', 'Fibre' , 'Tuiles de fibre suspendues ou non' , '65', 5)
419 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('4FE1BCEF-7D82-4C9D-A6A4-A290F52B808A', 'TuileSuspendue' , 'Tuile suspendue en bois ou MDF' , '90', 6)
420 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('40CD4274-97EC-49F4-B998-BD3BB1A4FB8A', 'Autre' , 'Autre' , '90', 7)
421 INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('1B53512B-2D70-4C72-B5C4-9583F363332C', 'Aucun' , 'Aucun' , '99', 8)
422
423END
424-- B34
425
426IF (NOT EXISTS (SELECT *
427 FROM INFORMATION_SCHEMA.TABLES
428 WHERE TABLE_SCHEMA = 'Propriete.Enum'
429 AND TABLE_NAME = 'B34TypePiece'))
430BEGIN
431
432 CREATE TABLE [Propriete.Enum].B34TypePiece (
433 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
434 NameValue NVARCHAR(25) NOT NULL,
435 ViewValue NVARCHAR(175) NOT NULL,
436 OrderValue INT NOT NULL
437 );
438
439
440 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('639D4B0B-7549-48FB-860B-B233597BA98B', 'Cuisine' , 'Cuisine', 1)
441 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('DB4650C2-47A6-49E7-98F5-85755E368ADF', 'Chambre' , 'Chambre', 2 )
442 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('34953FBD-612E-491D-8E06-F9399EBA1723', 'SalleEau' , 'Salle d''eau', 3)
443 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('B88176C2-25AD-4353-A625-705355452AA9', 'SalleFamiliale' , 'Salle familiale / Salle de jeux', 4)
444 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('33443D6A-2227-4600-9A92-DE168FF9E0F6', 'SalleDeBain' , 'Salle de bain', 5)
445 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('9E303FB9-E5A8-439D-B679-5D52EBBE360A', 'SalleAManger' , 'Salle à manger', 6)
446 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('16741681-D50A-49BC-8637-A16FB1C8B0EB', 'Salon' , 'Salon', 7 )
447 INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('8F6FC851-AEF7-470F-A021-8BB572195F78', 'Autre' , 'Autre', 8)
448
449END
450
451IF (NOT EXISTS (SELECT *
452 FROM INFORMATION_SCHEMA.TABLES
453 WHERE TABLE_SCHEMA = 'Propriete.Enum'
454 AND TABLE_NAME = 'B34Etage'))
455BEGIN
456
457 CREATE TABLE [Propriete.Enum].B34Etage (
458 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
459 NameValue NVARCHAR(25) NOT NULL,
460 ViewValue NVARCHAR(175) NOT NULL,
461 OrderValue INT NOT NULL
462 );
463
464
465 INSERT INTO [Propriete.Enum].B34Etage VALUES ('1E3CA954-EF3D-49E7-8D95-0B59DC15D65F', 'Rdc' , 'Rez-de-chaussée', 1 )
466 INSERT INTO [Propriete.Enum].B34Etage VALUES ('B5E25F99-197F-4B31-B89F-D263E54418B0', 'SS' , 'Sous-sol', 2 )
467 INSERT INTO [Propriete.Enum].B34Etage VALUES ('FAF8484E-91C6-4A27-A8A1-F93F67D588DF', 'Etg2', '2', 3)
468 INSERT INTO [Propriete.Enum].B34Etage VALUES ('9A4C0686-673E-4E1D-8844-35268CB3CA48', 'Etg3', '3', 4)
469 INSERT INTO [Propriete.Enum].B34Etage VALUES ('69D7F9D6-7322-4BCA-90C5-6C2BB3CB5C73', 'Att', 'Attique', 5)
470
471END
472
473IF (NOT EXISTS (SELECT *
474 FROM INFORMATION_SCHEMA.TABLES
475 WHERE TABLE_SCHEMA = 'Propriete.Enum'
476 AND TABLE_NAME = 'B34MatPlancher'))
477BEGIN
478
479 CREATE TABLE [Propriete.Enum].B34MatPlancher (
480 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
481 NameValue NVARCHAR(25) NOT NULL,
482 ViewValue NVARCHAR(175) NOT NULL,
483 Code NVARCHAR(2) NOT NULL,
484 OrderValue INT NOT NULL
485 );
486
487 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('BDBDCBDF-3723-46BA-8B54-B8CDA44DCA95', 'Ardoise' ,'Ardoise' , '40', 1)
488 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('A5DB208D-C281-4324-BDC6-9DD39B3D2ADF', 'BoisIngenerie', 'Bois d''ingénérie', '60', 2)
489 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('2BE47765-D906-422B-8C18-F08A38EA0471', 'BoisFranc' , 'Bois franc' , '62', 3)
490 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('AD73F79C-289B-43AD-8DFB-3EC1E34C7E37', 'Ceramique' , 'Céramique' , '35', 4)
491 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('5DC16279-619A-428E-8A53-DD7341071459', 'Epoxy' , 'Époxy' , '60', 5)
492 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('F9D94F0A-BE5A-46E1-B3E6-92A6F16E71A2', 'FlottantStrat', 'Flottant Stratifié', '60', 6)
493 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('F063ED8F-2C05-4101-888A-876B24520E06', 'Marbre' , 'Marbre' , '40', 7)
494 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('AC204278-C7A3-4E2F-9418-D69241B5CCDB', 'Parquetereie' , 'Parquetereie' , '60', 8)
495 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('E529AC5E-EBC0-42A5-A594-5296BB78446C', 'Tapis' , 'Tapis' , '75', 9)
496 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('ABAB2848-974A-460F-87F5-3D0B7D0EE22E', 'Vinyle' , 'Vinyle' , '77', 10)
497 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('722DE502-7EC7-41DD-B204-A4E2B2DBE582', 'Autre' , 'Autre' , '40', 11)
498 INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('B1B1E179-6447-443B-B551-48BF338E072B', 'Aucun' , 'Aucun' , '99', 12)
499
500END
501
502IF (NOT EXISTS (SELECT *
503 FROM INFORMATION_SCHEMA.TABLES
504 WHERE TABLE_SCHEMA = 'Propriete.Enum'
505 AND TABLE_NAME = 'B36MatArmoire'))
506BEGIN
507
508-- B36
509
510 CREATE TABLE [Propriete.Enum].B36MatArmoire (
511 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
512 NameValue NVARCHAR(50) NOT NULL,
513 ViewValue NVARCHAR(175) NOT NULL,
514 Code NVARCHAR(2) NOT NULL,
515 OrderValue INT NOT NULL
516 );
517
518
519 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('70B561E4-0E05-401D-9224-A20AC2669C50', 'BoisDur', 'Bois dur (chêne, érable, bois laqué etc.)', '60', 1)
520 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('63CE9C6F-A9FF-4EF2-9FA0-56EF5DC13D41', 'BoisMou', 'Bois mou (pin, épinette, cèdre etc.)', '60', 2)
521 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('9D6E282F-3A47-4C70-903D-ABA9E5E2E99A', 'Melamine' , 'Mélamine' , '67', 3)
522 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('EB015E56-1C50-494A-8927-03D825E44D0C', 'Polyester' , 'Polyester' , '76', 4)
523 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('A40E02F2-8BEA-40B6-BA08-8F49E4E87630', 'Thermoplastique', 'Thermoplastique', '76', 5)
524 INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('DE8F165D-1896-4F29-B7AB-5E380A12451C', 'Autre' , 'Autre', '90', 6)
525
526END
527
528IF (NOT EXISTS (SELECT *
529 FROM INFORMATION_SCHEMA.TABLES
530 WHERE TABLE_SCHEMA = 'Propriete.Enum'
531 AND TABLE_NAME = 'B36QualiteMatComptoir'))
532BEGIN
533
534 CREATE TABLE [Propriete.Enum].B36QualiteMatComptoir (
535 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
536 NameValue NVARCHAR(25) NOT NULL,
537 ViewValue NVARCHAR(175) NOT NULL,
538 OrderValue INT NOT NULL
539 );
540
541
542 INSERT INTO [Propriete.Enum].B36QualiteMatComptoir VALUES ('C898AC45-230D-42F0-B249-0DDEE7138F31', 'Standard', 'Standard (stratifié, bois, céramique)', 1)
543 INSERT INTO [Propriete.Enum].B36QualiteMatComptoir VALUES ('1039E7C1-C9EA-4DE9-AC92-5040CFD6C082', 'Superieur', 'Qualité supérieure (marbre, quartz, granit, béton, corian, stainless)', 2)
544
545END
546
547IF (NOT EXISTS (SELECT *
548 FROM INFORMATION_SCHEMA.TABLES
549 WHERE TABLE_SCHEMA = 'Propriete.Enum'
550 AND TABLE_NAME = 'B36AppEncastre'))
551BEGIN
552
553 CREATE TABLE [Propriete.Enum].B36AppEncastre (
554 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
555 NameValue NVARCHAR(25) NOT NULL,
556 ViewValue NVARCHAR(175) NOT NULL,
557 OrderValue INT NOT NULL
558 );
559
560 INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('4997D3EA-037F-46C5-A581-1A2054A1FD03', 'Aucun', 'Aucun', 1)
561 INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('21442127-E388-47A3-84A9-2BF21F4A4491', 'Cellier', 'Chambre cellier vitrée', 2)
562 INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('E838933C-7EC9-488F-82F5-A5CD8275CCEE', 'PlaqueCuissonOuFour', 'Plaque de cuisson et/ou four', 3)
563 INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('34026271-523F-4C48-86B7-561471BBDD44', 'Refrigerateur', 'Réfrigérateur (utilise le même matériau que les armoires)', 4)
564
565END
566
567IF (NOT EXISTS (SELECT *
568 FROM INFORMATION_SCHEMA.TABLES
569 WHERE TABLE_SCHEMA = 'Propriete.Enum'
570 AND TABLE_NAME = 'B43TypeBainDouche'))
571BEGIN
572-- B43
573
574 CREATE TABLE [Propriete.Enum].B43TypeBainDouche(
575 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
576 NameValue NVARCHAR(25) NOT NULL,
577 ViewValue NVARCHAR(175) NOT NULL,
578 OrderValue INT NOT NULL
579 );
580
581
582 INSERT INTO [Propriete.Enum].B43TypeBainDouche VALUES ('6231559C-80C8-4608-BD01-521A8DCFC4B3', 'Bain', 'Bain', 1)
583 INSERT INTO [Propriete.Enum].B43TypeBainDouche VALUES ('7AE7B631-80A0-46B3-B200-1F4BDB23C06E', 'Douche' , 'Douche' , 2 )
584 INSERT INTO [Propriete.Enum].B43TypeBainDouche VALUES ('CD9847E8-FFA6-4135-A092-54E9A41F68A0', 'BainDouche' , 'Bain/Douche', 3 )
585
586END
587
588IF (NOT EXISTS (SELECT *
589 FROM INFORMATION_SCHEMA.TABLES
590 WHERE TABLE_SCHEMA = 'Propriete.Enum'
591 AND TABLE_NAME = 'B43TypeBain'))
592BEGIN
593
594 CREATE TABLE [Propriete.Enum].B43TypeBain (
595 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
596 NameValue NVARCHAR(25) NOT NULL,
597 ViewValue NVARCHAR(175) NOT NULL,
598 OrderValue INT NOT NULL
599 );
600
601
602 INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('0F30CC35-CED0-4699-9565-80FA5CAE7A8F', 'AutoPortant', 'Auto-portant', 1)
603 INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('FDA8B06B-5C80-4166-ACB4-0D3236CBBB79', 'Remous' , 'À remous' , 2 )
604 INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('D3390328-B74B-48E5-BB05-B000C6C361DD', 'Encastre' , 'Encastré', 3 )
605 INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('A4CA09BC-2939-47FF-B427-88DA5711B7AE', 'Podium' , 'Podium' , 4 )
606
607END
608
609IF (NOT EXISTS (SELECT *
610 FROM INFORMATION_SCHEMA.TABLES
611 WHERE TABLE_SCHEMA = 'Propriete.Enum'
612 AND TABLE_NAME = 'B43TypeDouche'))
613BEGIN
614
615 CREATE TABLE [Propriete.Enum].B43TypeDouche (
616 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
617 NameValue NVARCHAR(25) NOT NULL,
618 ViewValue NVARCHAR(175) NOT NULL,
619 OrderValue INT NOT NULL
620 );
621
622 INSERT INTO [Propriete.Enum].B43TypeDouche VALUES ('99CB38A9-88F5-4C77-956A-7345353210A8', 'Ceramique', 'Céramique', 1)
623 INSERT INTO [Propriete.Enum].B43TypeDouche VALUES ('D9331605-0680-44BE-91F0-83188B19A4DC', 'Plastique', 'Plastique', 2)
624
625END
626
627IF (NOT EXISTS (SELECT *
628 FROM INFORMATION_SCHEMA.TABLES
629 WHERE TABLE_SCHEMA = 'Propriete.Enum'
630 AND TABLE_NAME = 'B43QualiteSalleBain'))
631BEGIN
632
633 CREATE TABLE [Propriete.Enum].B43QualiteSalleBain (
634 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
635 NameValue NVARCHAR(25) NOT NULL,
636 ViewValue NVARCHAR(250) NOT NULL,
637 OrderValue INT NOT NULL
638 );
639
640
641 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('5008374A-93DB-436D-81AE-A22BA4615C68', '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
642 et/ou au design sophistiqué', 1)
643 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('7CAE6356-831B-4248-8AFF-75713FE52268', 'Stylise', 'Bain sur pied ou autoportant et douche de céramique et verre, meuble lavabo de bonne qualité', 2)
644 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('A2CCEBA1-5445-48E7-81EF-EB30ABB04830', 'Repandu', 'Bain podium ou autre bain et douche céramique/acrylique, bain douche/douche blanc, meuble lavabo standard', 3)
645 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('8F2E7A0E-3BA4-4159-B68C-D9281CCEFA47', 'Simple' , 'Bain/douche ou bain de couleur autre que blanc et/ou en fonte ou douche plastique, meuble lavabo sans attrait particulier', 4 )
646 INSERT INTO [Propriete.Enum].B43QualiteSalleBain VALUES ('95E5C5ED-BD5D-4CB8-B3C4-678CCB79592C', 'Minimum', 'Une très petite douche de métal ou en plastique, lavabo rudimentaire', 5)
647
648END
649
650IF (NOT EXISTS (SELECT *
651 FROM INFORMATION_SCHEMA.TABLES
652 WHERE TABLE_SCHEMA = 'Propriete.Enum'
653 AND TABLE_NAME = 'B43DescriptionMeubleLavabo'))
654BEGIN
655
656 CREATE TABLE [Propriete.Enum].B43DescriptionMeubleLavabo (
657 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
658 NameValue NVARCHAR(25) NOT NULL,
659 ViewValue NVARCHAR(250) NOT NULL,
660 OrderValue INT NOT NULL
661 );
662
663 INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('DC6A9B8E-4A93-4F37-9964-60DEEFC76F3D', 'SurMesure', 'Fait sur mesure, acquis chez un marchand spécialisé', 1)
664 INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('D9AE2480-6BA4-4AF3-869B-57B954ADB48D', 'BonneQualite', 'Meuble lavabo de bonne qualité', 2)
665 INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('580C2CFB-FC11-4B54-BE9D-C5827D2F40B6', 'Standard', 'Meuble lavabo de qualité standard', 3)
666 INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('B09DD649-A511-4657-98AA-F4A450C9806C', 'Rudimentaire' , 'Meuble lavabo sans attrait/rudimentaire', 4 )
667
668END
669
670IF (NOT EXISTS (SELECT *
671 FROM INFORMATION_SCHEMA.TABLES
672 WHERE TABLE_SCHEMA = 'Propriete.Enum'
673 AND TABLE_NAME = 'B43MatDouche'))
674BEGIN
675
676 CREATE TABLE [Propriete.Enum].B43MatDouche (
677 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
678 NameValue NVARCHAR(25) NOT NULL,
679 ViewValue NVARCHAR(250) NOT NULL,
680 OrderValue INT NOT NULL
681 );
682
683 INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('6EECA293-B033-45F3-A944-B676A5140302', 'Acrylique', 'Acrylique', 1)
684 INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('BA718D99-77DB-4137-A257-260E60A04F37', 'Ceramique', 'Céramique', 2)
685 INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('3A6BD091-802F-4FDF-9E63-272072A33D23', 'Metal', 'Métal', 3)
686 INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('5440E723-D158-4EBF-9455-1098810F49C6', 'Plastique' , 'Plastique', 4 )
687
688END
689
690IF (NOT EXISTS (SELECT *
691 FROM INFORMATION_SCHEMA.TABLES
692 WHERE TABLE_SCHEMA = 'Propriete.Enum'
693 AND TABLE_NAME = 'B43MatMeubleLavabo'))
694BEGIN
695
696 CREATE TABLE [Propriete.Enum].B43MatMeubleLavabo (
697 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
698 NameValue NVARCHAR(25) NOT NULL,
699 ViewValue NVARCHAR(250) NOT NULL,
700 OrderValue INT NOT NULL
701 );
702
703 INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('482AC127-24BD-4C73-A844-72CFE801603C', 'Bois', 'Bois', 1)
704 INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('D9270965-0B5E-422E-AE5B-580E7D5B1681', 'Melamine', 'Melamine', 2)
705 INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('9B8E6912-ABDD-4C35-B417-F2556653DA7B', 'Polyester', 'Polyester', 3)
706 INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('E958724F-0EEF-47D6-B353-967CFE1E786E', 'Thermoplastique' , 'Thermoplastique', 4 )
707
708END
709
710IF (NOT EXISTS (SELECT *
711 FROM INFORMATION_SCHEMA.TABLES
712 WHERE TABLE_SCHEMA = 'Propriete.Enum'
713 AND TABLE_NAME = 'B43MatTourBain'))
714BEGIN
715
716 CREATE TABLE [Propriete.Enum].B43MatTourBain (
717 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
718 NameValue NVARCHAR(25) NOT NULL,
719 ViewValue NVARCHAR(250) NOT NULL,
720 OrderValue INT NOT NULL
721 );
722
723 INSERT INTO [Propriete.Enum].B43MatTourBain VALUES ('96FA950B-71C0-4B04-8B33-A57FD3650338', 'Ceramique', 'Céramique', 1)
724 INSERT INTO [Propriete.Enum].B43MatTourBain VALUES ('F67B5BA1-33C3-4AF8-8BA7-BB7DCD663D5F', 'Plastique', 'Plastique', 2)
725
726END
727
728IF (NOT EXISTS (SELECT *
729 FROM INFORMATION_SCHEMA.TABLES
730 WHERE TABLE_SCHEMA = 'Propriete.Enum'
731 AND TABLE_NAME = 'B43Couleur'))
732BEGIN
733
734 CREATE TABLE [Propriete.Enum].B43Couleur (
735 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
736 NameValue NVARCHAR(25) NOT NULL,
737 ViewValue NVARCHAR(250) NOT NULL,
738 OrderValue INT NOT NULL
739 );
740
741 INSERT INTO [Propriete.Enum].B43Couleur VALUES ('98B7815F-47D2-4299-9396-DA74131C2E59', 'Blanc', 'Blanc', 1)
742 INSERT INTO [Propriete.Enum].B43Couleur VALUES ('94CC6E1F-1FA4-4B6B-AA92-57C972FFB137', 'Couleur', 'Couleur', 2)
743
744END
745
746IF (NOT EXISTS (SELECT *
747 FROM INFORMATION_SCHEMA.TABLES
748 WHERE TABLE_SCHEMA = 'Propriete.Enum'
749 AND TABLE_NAME = 'B43DimensionSalleBain'))
750BEGIN
751
752 CREATE TABLE [Propriete.Enum].B43DimensionSalleBain (
753 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
754 NameValue NVARCHAR(25) NOT NULL,
755 ViewValue NVARCHAR(175) NOT NULL,
756 OrderValue INT NOT NULL
757 );
758
759 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('B8EF1B05-81E1-473E-B384-C0F9B1B96AFA', 'TresPetite', 'Tres petite (moins de 4 m² / 40 pi²)', 1)
760 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('94263628-6777-427D-A75C-C0CDB259CD1B', 'Petite' , 'Petite (de 4 à 8m² / 40 à 85 pi²)', 2 )
761 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('051A6F64-DA15-42DF-BA5C-2A3B1C79D77F', 'Moyenne' , 'Moyenne (de 8 à 12m² / 85 à 130 pi²)', 3 )
762 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('9BD735E8-908C-4271-97BD-015AF6B20766', 'Grande' , 'Grande (de 12 à 16m² / 130 à 170 pi²)', 4 )
763 INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('1EC500ED-0848-4756-A76C-E0E747A32B35', 'Spacieuse' , 'Spacieuse (plus de 16m² / 170 pi²)', 5 )
764
765END
766
767IF (NOT EXISTS (SELECT *
768 FROM INFORMATION_SCHEMA.TABLES
769 WHERE TABLE_SCHEMA = 'Propriete.Enum'
770 AND TABLE_NAME = 'B44TypeChauffage'))
771BEGIN
772
773-- B44
774 CREATE TABLE [Propriete.Enum].B44TypeChauffage (
775 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
776 NameValue NVARCHAR(25) NOT NULL,
777 ViewValue NVARCHAR(175) NOT NULL,
778 Code NVARCHAR(2) NOT NULL,
779 OrderValue INT NOT NULL
780 );
781
782 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('022C348A-2B24-4038-B111-89B9E99E4EC3', 'FournaiseElectrique', 'Fournaise électrique', '1', 1)
783 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('D5E1B43C-6431-4D9F-9A54-970E0A807473', 'FournaiseHuile' , 'Fournaise à l''huile' , '2', 2)
784 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('11549C24-979D-48F7-A99F-CE5F7043F81F', 'FournaiseGaz' , 'Fournaise à gaz' , '3', 3)
785 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('887B3DA5-CB66-42E5-B74C-1D1FEB82CC80', 'FournaiseBois' , 'Fournaise à bois' , '4', 4)
786 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('EB232AC4-99A2-4FDE-A643-4893A802DE51', 'Geothermie' , 'Géothermie' , '5', 5)
787 INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('3F78ECBF-DD9E-4EFB-880C-7F3B75504935', 'PlintheElectrique' , 'Plinthe électrique' , '6', 6)
788
789
790END
791
792IF (NOT EXISTS (SELECT *
793 FROM INFORMATION_SCHEMA.TABLES
794 WHERE TABLE_SCHEMA = 'Propriete.Enum'
795 AND TABLE_NAME = 'B44TypeDistribChauf'))
796BEGIN
797
798 CREATE TABLE [Propriete.Enum].B44TypeDistribChauf (
799 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
800 NameValue NVARCHAR(25) NOT NULL,
801 ViewValue NVARCHAR(175) NOT NULL,
802 Code NVARCHAR(2) NOT NULL,
803 OrderValue INT NOT NULL
804 );
805
806
807 INSERT INTO [Propriete.Enum].B44TypeDistribChauf VALUES ('0EA07B76-9DAF-456E-9586-B38F4D57A196', 'Aire', 'À air', '1', 1)
808 INSERT INTO [Propriete.Enum].B44TypeDistribChauf VALUES ('F6943973-546A-4FE4-9C49-E69720CDF7FC', 'Eau', 'À eau', '3', 2)
809
810END
811
812IF (NOT EXISTS (SELECT *
813 FROM INFORMATION_SCHEMA.TABLES
814 WHERE TABLE_SCHEMA = 'Propriete.Enum'
815 AND TABLE_NAME = 'B44TypeClimatisation'))
816BEGIN
817
818 CREATE TABLE [Propriete.Enum].B44TypeClimatisation (
819 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
820 NameValue NVARCHAR(25) NOT NULL,
821 ViewValue NVARCHAR(175) NOT NULL,
822 Code NVARCHAR(2) NOT NULL,
823 OrderValue INT NOT NULL
824 );
825
826
827 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('A78CA176-BA41-4A7A-9744-2721E9165F70', 'ClimatiseurCentral', 'Climatiseur central', '1', 1)
828 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('C22C32B0-B756-4F11-9DCF-3077FD1B0C17', 'ClimatiseurMural', 'Climatiseur mural', '2', 2)
829 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('782A7111-1CEF-4A81-A550-CE52FE30EA04', 'ThermopompeCentrale' , 'Thermopompe centrale' , '2', 3)
830 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('5A474359-69D4-4497-B68E-A39355F86567', 'ThermopompeMurale' , 'Thermopompe murale' , '4', 4)
831 INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('1DE544A8-4BA0-4C37-A75A-319F64E13C2C', 'Aucun' , 'Aucun' , '8', 5)
832
833END
834
835IF (NOT EXISTS (SELECT *
836 FROM INFORMATION_SCHEMA.TABLES
837 WHERE TABLE_SCHEMA = 'Propriete.Enum'
838 AND TABLE_NAME = 'B44TypeDistribClim'))
839BEGIN
840
841 CREATE TABLE [Propriete.Enum].B44TypeDistribClim (
842 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
843 NameValue NVARCHAR(25) NOT NULL,
844 ViewValue NVARCHAR(175) NOT NULL,
845 Code NVARCHAR(2) NOT NULL,
846 OrderValue INT NOT NULL
847 );
848
849 INSERT INTO [Propriete.Enum].B44TypeDistribClim VALUES ('7B7A3D28-573F-4764-AFAC-3C0FB07F3ACA', 'Exclusive' , 'Exclusive' , '1', 1)
850 INSERT INTO [Propriete.Enum].B44TypeDistribClim VALUES ('168CB6AD-AFF6-42B8-A4F4-AFEF10F3F22F', 'PartageChauffage', 'Partage du chauffage', '2', 2)
851
852END
853
854
855IF (NOT EXISTS (SELECT *
856 FROM INFORMATION_SCHEMA.TABLES
857 WHERE TABLE_SCHEMA = 'Propriete.Enum'
858 AND TABLE_NAME = 'B59Appareils'))
859BEGIN
860
861 -- B59
862 CREATE TABLE [Propriete.Enum].B59Appareils (
863 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
864 NameValue NVARCHAR(25) NOT NULL,
865 ViewValue NVARCHAR(175) NOT NULL,
866 Code NVARCHAR(2) NOT NULL,
867 OrderValue INT NOT NULL
868 );
869
870
871 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Ascenseur' , 'Ascenseur' , '3', 1)
872 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'AspirateurCentral', 'Aspirateur central', '1', 2)
873 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Sauna' , 'Sauna' , '2', 3)
874 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'SpaInterieur' , 'Spa intérieur' , '4', 4)
875 INSERT INTO [Propriete.Enum].B59Appareils VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'SystemeAlarme' , 'Système d''alarme' , '5', 5)
876
877END
878
879IF (NOT EXISTS (SELECT *
880 FROM INFORMATION_SCHEMA.TABLES
881 WHERE TABLE_SCHEMA = 'Propriete.Enum'
882 AND TABLE_NAME = 'B59TypeFoyer'))
883BEGIN
884
885 CREATE TABLE [Propriete.Enum].B59TypeFoyer (
886 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
887 NameValue NVARCHAR(25) NOT NULL,
888 ViewValue NVARCHAR(175) NOT NULL,
889 Code NVARCHAR(2) NOT NULL,
890 OrderValue INT NOT NULL
891 );
892
893 INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('9A5FAD5B-28D5-440D-B595-600AB729E41E', 'BoisGranule', 'Poêle à bois ou à granules', '4', 1)
894 INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('04F0A856-98D8-4946-A93B-967033ADF2BF', 'Bois' , 'Foyer à bois' , '1', 2)
895 INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('1F8ADE85-EB44-488E-861F-B252F031BF47', 'Granule' , 'Foyer à granule' , '2', 3)
896 INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('7BDA3C43-7141-4421-8050-D84451966054', 'Gaz' , 'Foyer à gaz' , '3', 4)
897
898END
899
900IF (NOT EXISTS (SELECT *
901 FROM INFORMATION_SCHEMA.TABLES
902 WHERE TABLE_SCHEMA = 'Propriete.Enum'
903 AND TABLE_NAME = 'B59TypeEtatSPA'))
904BEGIN
905
906 CREATE TABLE [Propriete.Enum].B59TypeEtatSPA (
907 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
908 NameValue NVARCHAR(25) NOT NULL,
909 ViewValue NVARCHAR(175) NOT NULL,
910 Code NVARCHAR(2) NOT NULL,
911 OrderValue INT NOT NULL
912 );
913
914
915 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('A4D933C1-3573-4C46-9566-515FB8A0A71B', 'Excellent' , 'Excellent' , '1', 1)
916 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('BFED397A-56D1-45D2-BA6D-F72E9B5FD57E', 'TresBon' , 'Tres bon' , '2', 2)
917 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('78B722EB-931A-4AF5-9008-C84A5E7AF8B1', 'Acceptable', 'Acceptable', '3', 3)
918 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('B991AFBC-AA87-4CAC-9D7D-D29DC9CE01AE', 'Mediocre' , 'Médiocre' , '4', 4)
919 INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('414491B2-ECDF-45D1-B910-B734074F88BA', 'Delabre' , 'Délabré' , '5', 5)
920
921END
922
923IF (NOT EXISTS (SELECT *
924 FROM INFORMATION_SCHEMA.TABLES
925 WHERE TABLE_SCHEMA = 'Propriete.Enum'
926 AND TABLE_NAME = 'B62TypeFondGarAttache'))
927BEGIN
928-- B62
929
930 CREATE TABLE [Propriete.Enum].B62TypeFondGarAttache (
931 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
932 NameValue NVARCHAR(25) NOT NULL,
933 ViewValue NVARCHAR(175) NOT NULL,
934 Code NVARCHAR(2) NOT NULL,
935 OrderValue INT NOT NULL
936 );
937
938 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('D7B26B95-C149-47F3-AA87-049837A152CD', 'Muret' , 'Muret' , '3', 1)
939 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('712DF131-BF42-4B1D-A230-B29BB8D0876E', 'Piliers' , 'Piliers' , '1', 2)
940 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('8C783654-DE8B-4A2E-B0C1-C93704FBE60B', 'PiliersExacve', 'Piliers excavés', '2', 3)
941 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('AC5BF36A-B56F-4A47-950D-FB7FAAB04B3B', 'Radier' , 'Radier' , '4', 4)
942 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('4C9FA9B7-C0F9-4EE6-BE0A-9B4372B0F00D', 'Sole' , 'Sole' , '5', 5)
943 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('F8C3B2C8-A395-4CBC-990B-38DB800D06FC', 'SousSol' , 'Sous-sol' , '6', 6)
944 INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('DD746476-5533-490B-8352-1D9D24726E68', 'VideSanitaire', 'Vide sanitaire', '7', 7)
945
946
947END
948
949IF (NOT EXISTS (SELECT *
950 FROM INFORMATION_SCHEMA.TABLES
951 WHERE TABLE_SCHEMA = 'Propriete.Enum'
952 AND TABLE_NAME = 'B63AireRemise'))
953BEGIN
954 -- B63
955 CREATE TABLE [Propriete.Enum].B63AireRemise (
956 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
957 NameValue NVARCHAR(25) NOT NULL,
958 ViewValue NVARCHAR(175) NOT NULL,
959 M2 DECIMAL,
960 OrderValue INT NOT NULL
961 );
962
963 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '557A0FDF-62BA-4518-9771-DDCA1566FC28', '8x8', '8 X 8 (pi) / 2.5 X 2.5 (m)' , '6.25', 1)
964 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '69E462F1-1A99-4618-BD3B-C4BBD35DC2FD', '8x12', '8 X 10 (pi) / 2.5 X 3 (m)' , '7.5', 2)
965 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '65D97A8C-ED4B-4B8D-A024-B1B6351C4CDB', '10x10', '10 X 10 (pi) / 3 X 3 (m)' , '9', 3)
966 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( 'F3F6CE84-A47A-44E0-83C5-EF64BFB6D890', '10x12', '10 X 12 (pi) / 3 X 3.7 (m)' , '11.1', 4)
967 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '6A339467-D505-47CF-AE2D-48B067B9D45C', '12x12', '12 X 12 (pi) / 3.7 X 3.7 (m)' , '13.69', 5)
968 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '89910ECC-76CE-4050-A209-6D4142418267', '12x14', '12 X 14 (pi) / 3.7 X 4.3 (m)' , '15.91', 6)
969 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '8D93AFA9-91BC-47C0-AD79-67C3BABD3ECF', '12x16', '12 X 16 (pi) / 3.7 X 4.9 (m)' , '18.13', 7)
970 INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( 'C1C1D868-2887-4380-85CE-6DD919E64712', '14x14', '14 X 14 (pi) / 4.3 X 4.3 (m)' , '18.49', 8)
971
972END
973
974IF (NOT EXISTS (SELECT *
975 FROM INFORMATION_SCHEMA.TABLES
976 WHERE TABLE_SCHEMA = 'Propriete.Enum'
977 AND TABLE_NAME = 'B71TypePiscine'))
978BEGIN
979-- B71
980
981CREATE TABLE [Propriete.Enum].B71TypePiscine (
982 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
983 NameValue NVARCHAR(25) NOT NULL,
984 ViewValue NVARCHAR(175) NOT NULL,
985 Code NVARCHAR(2) NOT NULL,
986 OrderValue INT NOT NULL
987);
988
989INSERT INTO [Propriete.Enum].B71TypePiscine VALUES ('39BBBA29-E6E3-4908-BB17-5E95D39FC8D9', 'Creusee' , 'Creusée' , '1', 1)
990INSERT INTO [Propriete.Enum].B71TypePiscine VALUES ('749CC9BF-27E3-421C-ADC4-09D815B9EEF2', 'SemiCreusee', 'Semi-creusée', '2', 2)
991INSERT INTO [Propriete.Enum].B71TypePiscine VALUES ('EADD960A-DF1B-4A6E-AC74-B313C3A23A8A', 'HorsTerre' , 'Hors-terre' , '3', 3)
992
993END
994
995IF (NOT EXISTS (SELECT *
996 FROM INFORMATION_SCHEMA.TABLES
997 WHERE TABLE_SCHEMA = 'Propriete.Enum'
998 AND TABLE_NAME = 'B71TypeEtatPiscine'))
999BEGIN
1000
1001 CREATE TABLE [Propriete.Enum].B71TypeEtatPiscine (
1002 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1003 NameValue NVARCHAR(25) NOT NULL,
1004 ViewValue NVARCHAR(175) NOT NULL,
1005 Code NVARCHAR(2) NOT NULL,
1006 OrderValue INT NOT NULL
1007 );
1008
1009
1010 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('642E74FE-81E1-4A10-9506-FFFF18DE972B', 'Excellent' , 'Excellent' , '1', 1)
1011 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('F4B20794-26AD-4AA0-A7F6-32BEFB150D48', 'TresBon' , 'Très bon' , '2', 2)
1012 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('554CE4E6-426B-425A-9A8B-0C7F83CF6DB4', 'Acceptable', 'Acceptable', '3', 3)
1013 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('9A437C8A-2A67-479C-9550-DAA069531981', 'Mediocre' , 'Médiocre' , '4', 4)
1014 INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('12B9E85C-C86D-4C2D-B22F-ED67630C23C8', 'Delabre' , 'Délabré' , '5', 5)
1015
1016END
1017
1018IF (NOT EXISTS (SELECT *
1019 FROM INFORMATION_SCHEMA.TABLES
1020 WHERE TABLE_SCHEMA = 'Propriete.Enum'
1021 AND TABLE_NAME = 'B71TypeFormePiscine'))
1022BEGIN
1023
1024 CREATE TABLE [Propriete.Enum].B71TypeFormePiscine (
1025 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1026 NameValue NVARCHAR(25) NOT NULL,
1027 ViewValue NVARCHAR(175) NOT NULL,
1028 Code NVARCHAR(2) NOT NULL,
1029 OrderValue INT NOT NULL
1030 );
1031
1032 INSERT INTO [Propriete.Enum].B71TypeFormePiscine VALUES ('B9AEECC2-AD42-4B51-BCC5-9DB01149F0DE', 'Ronde', 'Ronde', '1', 1)
1033 INSERT INTO [Propriete.Enum].B71TypeFormePiscine VALUES ('2E738B76-FFF0-4ED4-B221-B140E5128C13', 'Autre', 'Autre', '2', 2)
1034
1035END
1036
1037
1038IF (NOT EXISTS (SELECT *
1039 FROM INFORMATION_SCHEMA.TABLES
1040 WHERE TABLE_SCHEMA = 'Propriete.Enum'
1041 AND TABLE_NAME = 'B71MatStationnement'))
1042BEGIN
1043
1044 CREATE TABLE [Propriete.Enum].B71MatStationnement (
1045 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1046 NameValue NVARCHAR(25) NOT NULL,
1047 ViewValue NVARCHAR(175) NOT NULL,
1048 Code NVARCHAR(2) NOT NULL,
1049 OrderValue INT NOT NULL
1050 );
1051
1052
1053 INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('A21093A5-B4E5-4CE7-942D-9B512711B72F', 'Asphalte' , 'Asphalte' , '16', 1)
1054 INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('3948D6C5-CFCE-44E2-A4CA-C03A97D8BBA8', 'Beton' , 'Béton' , '10', 2)
1055 INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('2089640C-7CE2-4BBD-B171-750DB5E12E8F', 'Concasse' , 'Concassé' , '43', 3)
1056 INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('6B6C3735-E390-49F6-9107-0F669EA48D2D', 'DaleImbrique', 'Dale imbriquée/inter bloc', '15', 4)
1057
1058END
1059
1060IF (NOT EXISTS (SELECT *
1061 FROM INFORMATION_SCHEMA.TABLES
1062 WHERE TABLE_SCHEMA = 'General.Enum'
1063 AND TABLE_NAME = 'UniteMesure'))
1064BEGIN
1065
1066 CREATE TABLE [General.Enum].UniteMesure (
1067 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1068 NameValue NVARCHAR(25) NOT NULL,
1069 ViewValue NVARCHAR(175) NOT NULL,
1070 Code NVARCHAR(2) NOT NULL,
1071 OrderValue INT NOT NULL
1072 );
1073
1074 INSERT INTO [General.Enum].UniteMesure VALUES ('11D15BB8-BE9B-4908-BE05-1E1D1A89DC74', 'Pieds', 'Pieds', '1', 1)
1075 INSERT INTO [General.Enum].UniteMesure VALUES ('EF56E873-2E3A-463D-B66A-641FBFCCFED0', 'Metre', 'Mètres', '2', 2)
1076
1077END
1078
1079IF (NOT EXISTS (SELECT *
1080 FROM INFORMATION_SCHEMA.TABLES
1081 WHERE TABLE_SCHEMA = 'Propriete.Enum'
1082 AND TABLE_NAME = 'FraisExploitation'))
1083BEGIN
1084
1085 CREATE TABLE [Propriete.Enum].FraisExploitation (
1086 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1087 NameValue NVARCHAR(25) NOT NULL,
1088 ViewValue NVARCHAR(175) NOT NULL,
1089 OrderValue INT NOT NULL
1090 );
1091
1092
1093 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('1E907A4C-B6C6-4A9E-97B9-3411DE31365B', 'Administration', 'Administration', 1 )
1094 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('86463986-E758-4D20-AA8B-9AEC4E426618', 'Assurance', 'Assurance', 2 )
1095 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('2052C7E8-15D2-4E8E-B9E8-B28892B1216A', 'Chauffage', 'Chauffage (combustible)', 3 )
1096 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('9EB1B891-90E3-42EB-8C7D-D98214FEFB95', 'ContetantSanitaire', 'Contenant sanitaire (location)', 4 )
1097 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('88F9C996-5154-4BF0-9C2D-0FF8995D7CBA', 'Deneigement', 'Déneigement', 5 )
1098 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('5BFF7D13-2C40-4B45-962D-FA467B656571', 'Electricite', 'Électricité', 6 )
1099 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('F15CDA78-BDF1-498B-8037-5B8CE0335F70', 'EntretientReparation', 'Entretien et réparations', 7 )
1100 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('8DFAF35A-98BA-4210-A6FC-04ACCE55C9DF', 'FraisConciergerie', 'Frais conciergerie', 8 )
1101 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('BDAB1A1E-8EE6-4F7E-BA1E-8A755AFBD62C', 'HonoraireProfessionnel', 'Honoraire professionnels', 9 )
1102 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('C84F15D3-9688-40AA-A880-5FDAAFFCC109', 'Publicite', 'Publicité', 10 )
1103 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('FE941D85-4844-4B32-B10D-1EF39C91FC4D', 'ReserveRemplacement', 'Réserve de remplacement', 11 )
1104 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('E9DCE444-9C03-4504-9A1F-C6BD1CEE678B', 'SalaireAvantageSociaux', 'Salaire et avantages sociaux', 12 )
1105 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('EBFB3C1B-0CFA-4F24-B677-976CB85D3668', 'TaxeFonciereScolaire', 'Taxes foncières et scolaires', 13)
1106 INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('40C329FC-FBB7-4C24-8D67-720EC9217390', 'AutreDepense', 'Autre dépenses', 14 )
1107
1108END
1109
1110IF (NOT EXISTS (SELECT *
1111 FROM INFORMATION_SCHEMA.TABLES
1112 WHERE TABLE_SCHEMA = 'Propriete.Enum'
1113 AND TABLE_NAME = 'RevenusLocation'))
1114BEGIN
1115
1116 CREATE TABLE [Propriete.Enum].RevenusLocation (
1117 Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
1118 NameValue NVARCHAR(25) NOT NULL,
1119 ViewValue NVARCHAR(175) NOT NULL,
1120 OrderValue INT NOT NULL
1121 );
1122
1123 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('B5BFAA92-55AA-47E2-A0AA-AA3374BC1757', 'Commerces', 'Commerces', 1)
1124 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('74DEE8A9-FB0A-47DD-9703-2B8F29B1A18D', 'Logements', 'Logements', 2)
1125 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('C88B44E8-CF35-4F91-BD47-9888AACA72E4', 'RecupFraisExpl', 'Récuperation des frais d''exploitation', 3)
1126 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('63838A52-30D2-4A54-8B7B-55527BCE23C2', 'RevenusStationnement', 'Revenus de stationnement', 4)
1127 INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('01D1E65D-3DD0-4ECE-856C-297A37E14766', 'AutreRevenus', 'Autre revenus', 5)
1128
1129END
1130
1131GO