Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'General.Enum'
- AND TABLE_NAME = 'DemandeStatut'))
- BEGIN
- CREATE TABLE [General.Enum].DemandeStatut (
- DmdSt_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- DmdSt_Nom NVARCHAR(25) NOT NULL
- );
- INSERT INTO [General.Enum].DemandeStatut VALUES ('0FAA0F3A-E510-4B9F-922B-39277C363E15', 'Reçu');
- INSERT INTO [General.Enum].DemandeStatut VALUES ('1E185F4B-2EB6-407A-B276-6C9A0C70B0A2', 'EnCorrespondance');
- INSERT INTO [General.Enum].DemandeStatut VALUES ('E7C74E04-8D3C-4515-94F6-70D627258C17', 'Completée');
- INSERT INTO [General.Enum].DemandeStatut VALUES ('376E9AA4-4A76-4716-9962-72CDDD8C79BB', 'Annulée');
- INSERT INTO [General.Enum].DemandeStatut VALUES ('D20357BD-AFDC-45CF-9821-CCC5D4CF9F54', 'EnMutation');
- INSERT INTO [General.Enum].DemandeStatut VALUES ('A99FFCC4-86FA-4000-ACFE-EE76463A1DDF', 'Expirée');
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'FormStatut'))
- BEGIN
- CREATE TABLE [Propriete.Enum].FormStatut (
- FrmSt_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- FrmSt_Nom NVARCHAR(25) NOT NULL
- );
- INSERT INTO [Propriete.Enum].FormStatut VALUES ('86D03AE3-A2B9-4686-A571-1D98506F541C', 'Complété');
- INSERT INTO [Propriete.Enum].FormStatut VALUES ('EA5D43E8-2B34-4A34-9F92-AA1306165582', 'EnCours');
- INSERT INTO [Propriete.Enum].FormStatut VALUES ('286CD2E4-C48E-4B76-9820-EB335AAB97DE', 'Annulé');
- END
- -- B15
- -- ProprieteType
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'ProprieteType'))
- BEGIN
- CREATE TABLE [Propriete.Enum].ProprieteType (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].ProprieteType VALUES ('4E56DC5E-7E34-4806-9DA5-BDEEE29A4425', 'RES', 'Résidentiel', 1)
- INSERT INTO [Propriete.Enum].ProprieteType VALUES ('DC5ACC46-E596-4000-9BC1-D5A10F943BF8', 'CONDO', 'Condo', 2)
- INSERT INTO [Propriete.Enum].ProprieteType VALUES ('2A9FD589-B2CE-4BFB-9710-52D483F8CD41', 'DAE', 'Dépendances et améliorations', 3)
- END;
- --
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B15MatFondation'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B15MatFondation (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- Materiau NVARCHAR(25) NOT NULL,
- Type NVARCHAR(25) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'BetonCoule' , 'Béton coulé' , '4', 'Beton', 'Lourd', 1)
- INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'BlocBeton' , 'Bloc de béton' , '4', 'Beton', 'Lourd', 2)
- INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'PilierExcaveMetal', 'Pilier excavé en métal', '2', 'Beton', 'Lourd', 3)
- INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'PilierExcaveBeton', 'Pilier excavé en béton', '2', 'Beton', 'Lourd', 4)
- INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('5ADF7D8A-B3A9-4C2F-9216-75C91C420BB0', 'PilierBlocBeton' , 'Pilier en bloc de béton' , '1', 'Beton', 'Lourd', 5)
- INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('5219F83D-3D28-419A-BCA6-965AAE9AA359', 'PilierMetal' , 'Pilier en metal' , '1', 'Beton', 'Lourd', 6)
- INSERT INTO [Propriete.Enum].B15MatFondation VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'PilierCageBois' , 'Pilier en cage de bois' , '1', 'Brique', 'Lourd', 7)
- END
- -- B22
- -- Images
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B22TypePorteFacade'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B22TypePorteFacade (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', '1', '1', 1)
- INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '2', '2', 2)
- INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '3', '3', 3)
- INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', '4', '4', 4)
- INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', '5', '5', 5)
- INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', '6', '6', 6)
- INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', '7', '7', 7)
- INSERT INTO [Propriete.Enum].B22TypePorteFacade VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', '8', '8', 8)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B22TypeFenetreFacade'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B22TypeFenetreFacade (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', '1', '1', 1)
- INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '2', '2', 2)
- INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '3', '3', 3)
- INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', '4', '4', 4)
- INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', '5', '5', 5)
- INSERT INTO [Propriete.Enum].B22TypeFenetreFacade VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', '6', '6', 6)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B22ChoixAngle'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B22ChoixAngle (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B22ChoixAngle VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', '4-6' , '4-6', 1 )
- INSERT INTO [Propriete.Enum].B22ChoixAngle VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '7-10', '7-10', 2)
- INSERT INTO [Propriete.Enum].B22ChoixAngle VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '>10' , '> 10', 3 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B22RevetementExtMur'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B22RevetementExtMur (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- Materiau NVARCHAR(25) NOT NULL,
- Type NVARCHAR(25) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('C2C8D93B-E570-43C8-B8A3-06AF83FA46E3', 'Aluminium' , 'Aluminium' , '50', 'Metal', 'Leger', 1)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('E4127D59-35F2-4F9D-8708-34B9145EDF17', 'AluminiumEmaillee' , 'Aluminium émaillée' , '50', 'Metal', 'Leger', 2)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('81666D01-0FFA-4842-9E6D-A10139BC172E', 'Amiante' , 'Amiante' , '70', 'Synthetique', 'Leger', 3)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('1CB61628-9DDB-4B51-BA75-D455EC7647DF', 'BardeauAmiante' , 'Bardeau d''amiante' , '70', 'Synthetique', 'Leger', 4)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('B9BC46AC-B5E5-4DC4-9B1A-88B1AED6571C', 'BardeauAsphalte' , 'Bardeau d''asphalte' , '70', 'Synthetique', 'Leger', 5)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('5A3F9F15-009E-49F0-8CAA-BBE40E3FD537', 'BardeauBois' , 'Bardeau de bois' , '60', 'Bois', 'Leger', 6)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'BlocBeton' , 'Bloc de béton' , '10', 'Beton', 'Lourd', 7)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Beton' , 'Béton' , '10', 'Beton', 'Lourd', 8)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'BetonPrefabrique' , 'Béton préfabriqué' , '10', 'Beton', 'Lourd', 9)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'PanneauxPrefabBeton', 'Panneaux préfabriqués en béton', '10', 'Beton', 'Lourd', 10)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'Brique' , 'Brique' , '32', 'Brique', 'Lourd', 11)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'BriqueAutoportante' , 'Brique autoportante' , '40', 'Brique', 'Lourd', 12)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('17426FA8-EFF5-4322-88FA-4787384A6687', 'Ceramique' , 'Céramique' , '32', 'Brique', 'Lourd', 13)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('73A4587D-FC45-40D3-BC78-B4E62CFCC1F3', 'Cinyle' , 'Cinyle' , '70', 'Synthetique', 'Leger', 14)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('9AA1A77A-4976-478E-9972-9A3445E64410', 'ContrePlaque' , 'Contreplaqué' , '60', 'Bois', 'Leger', 15)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('7D6B5160-6DDD-42EA-AE02-B1FA601D7DF1', 'Copolymere' , 'Copolymère' , '60', 'Bois', 'Leger', 16)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('CB3ADBB8-D324-4193-B351-2A1F6245CC83', 'DeclinBois' , 'Déclin de bois' , '60', 'Bois', 'Leger', 17)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('9A39DF0D-2D8A-41E3-94E1-3F6BD1733D79', 'DeclinFibrePressee' , 'Déclin de fibre pressée' , '65', 'Fibre', 'Leger', 18)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('EE23A293-C820-4933-A4F7-EE2946BEDAAD', 'Marbre' , 'Marbre' , '37', 'Pierre', 'Lourd', 19)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('93E59223-5646-486C-B03E-DF4CBF07715E', 'MarbrePoli' , 'Marbre poli' , '37', 'Pierre', 'Lourd', 20)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'PierreChamps' , 'Pierre des champs' , '37', 'Pierre', 'Lourd', 21)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', 'PierreDressee' , 'Pierre dressée' , '37', 'Pierre', 'Lourd', 22)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('8DA7BB04-60E3-4BA4-8DFF-EFC3E78FFA78', 'PierreFendue' , 'Pierre fendue' , '37', 'Pierre', 'Lourd', 23)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('56EC78D0-ABA3-43B3-8FE9-8A561B982046', 'PierreSimili' , 'Pierre de simili' , '37', 'Pierre', 'Lourd', 24)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('7378BD19-C592-4305-8C99-95858F26B2ED', 'PierreTaillee' , 'Pierre taillée' , '37', 'Pierre', 'Lourd', 25)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('9433B22B-7F7B-46CD-8EB5-93D839196DC9', 'PierreTailleePolie' , 'Pierre taillée polie' , '37', 'Pierre', 'Lourd', 26)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('687E16F5-DD98-4AB0-B101-3FACF65CCB7D', 'Pierre' , 'Pierre' , '37', 'Pierre', 'Lourd', 27)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('9C6B15C2-D2AE-4D7C-9379-9A064FCA8239', 'Planche' , 'Planche' , '60', 'Bois', 'Leger', 28)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('30395223-A379-4029-A084-6ADE99C8B328', 'StucAgregat' , 'Stuc/agrégat' , '94', 'EnduitFinition', 'Leger', 29)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('72DD989C-8148-4910-A762-4C19EF076D7B', 'Tole' , 'Tôle' , '90', 'Metal', 'Leger', 30)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('564CC8E0-EE9B-4B5D-9822-B32BB3DEA5AF', 'ToleEmaillee' , 'Tôle émaillée' , '50', 'Metal', 'Leger', 31)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('3B9C3BBE-F092-4829-A0DD-BA055F626556', 'Verre' , 'Verre' , '20', 'Verre', 'Lourd', 32)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('BBCF9B45-29E4-4729-9DA5-31FA6A38A414', 'Autre' , 'Autre' , '40', '', '', 33)
- INSERT INTO [Propriete.Enum].B22RevetementExtMur VALUES ('4371B62D-18F7-45D7-A234-2A817DF2003A', 'Aucun' , 'Aucun' , '99', '', '', 33)
- END
- -- B23
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B23RevetementToit'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B23RevetementToit (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'BardeauAsphalte', 'Bardeau d''asphalte', 1)
- INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'BardeauBois' , 'Bardeau de bois', 2 )
- INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Cuivre' , 'Cuivre', 3 )
- INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'Membrane' , 'Membrane', 4 )
- INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'Metal' , 'Métal', 5 )
- INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'Tuile' , 'Tuile', 6 )
- INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'Verre' , 'Verre', 7 )
- INSERT INTO [Propriete.Enum].B23RevetementToit VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', 'Autre' , 'Autre', 8 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B23NbVersants'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B23NbVersants (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', '1a2', '1 à 2', 1)
- INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '3a4' , '3 à 4 ou toit plat', 2 )
- INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '5a8' , '5 à 8', 3 )
- INSERT INTO [Propriete.Enum].B23NbVersants VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', '9plus' , '9 et +', 4 )
- END
- -- B33
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B33QualitePorteInt'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B33QualitePorteInt (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Luxueux' , 'Portes luxueuses, faites sur mesure, au desgin unique', 1 )
- 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)
- INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Courant' , 'Portes de type courant, avec certains motifs', 3 )
- INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Unie' , 'Portes simples unies et sans attrait', 4 )
- INSERT INTO [Propriete.Enum].B33QualitePorteInt VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucune' , 'Aucune porte', 5 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B33QualiteOrnement'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B33QualiteOrnement (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- 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)
- 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 )
- 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 )
- 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 )
- INSERT INTO [Propriete.Enum].B33QualiteOrnement VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucune' , 'Aucune moulure, finition peu harmonieuse et luminaires de type plafonnier', 5 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B33QualiteEscalierInt'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B33QualiteEscalierInt (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Luxueux', 'Matériaux luxueux au design unique, avec courbes, angles', 1 )
- INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Design' , 'Matériaux et designs particuliers et/ou avec angle ou paliers', 2 )
- INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Courant', 'Matériaux et designs courants, rectiligne ou à paliers en bois franc', 3 )
- INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Modeste', 'Escalier modeste, fonctionnel et sans particularité', 4 )
- INSERT INTO [Propriete.Enum].B33QualiteEscalierInt VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucune', 'Aucune finition', 5 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B33MatPlafond'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B33MatPlafond (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BoisMou' , 'Bois mou' , '63', 1)
- INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'ContreplaquePrefini', 'Contreplaqué préfini', '64', 2)
- INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Fibre' , 'Fibre' , '65', 3)
- INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'PanneauGypse' , 'Panneau de gypse' , '93', 4)
- INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Autre' , 'Autre' , '90', 5)
- INSERT INTO [Propriete.Enum].B33MatPlafond VALUES ('AD5D1C92-A75B-40B4-806D-1F978D517AEC', 'Aucun' , 'Aucun' , '99', 6)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B33MatMur'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B33MatMur (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B33MatMur VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BoisMou' , 'Bois mou' , '63', 1)
- INSERT INTO [Propriete.Enum].B33MatMur VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'ContreplaquePrefini', 'Contreplaqué préfini', '64', 2)
- INSERT INTO [Propriete.Enum].B33MatMur VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Fibre' , 'Fibre' , '65', 3)
- INSERT INTO [Propriete.Enum].B33MatMur VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'PanneauGypse' , 'Panneau de gypse' , '93', 4)
- INSERT INTO [Propriete.Enum].B33MatMur VALUES ('771EA95D-D4B8-4D21-83F7-677979CDCCFB', 'Autre' , 'Autre' , '90', 5)
- INSERT INTO [Propriete.Enum].B33MatMur VALUES ('AD5D1C92-A75B-40B4-806D-1F978D517AEC', 'Aucun' , 'Aucun' , '99', 6)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B33MatMurPlafond'))
- BEGIN
- -- TODO: Change QC for plafond and mur
- CREATE TABLE [Propriete.Enum].B33MatMurPlafond (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BoisMou' , 'Bois mou' , '63', 1)
- INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'ContreplaquePrefini', 'Contreplaque préfini', '64', 2)
- INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'PanneauGypse' , 'Panneau de gypse' , '93', 3)
- INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', 'PlafondExpanse' , 'Plafond expansé' , '90', 4)
- INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Fibre' , 'Tuiles de fibre suspendues ou non' , '65', 5)
- INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'TuileSuspendue' , 'Tuile suspendue en bois ou MDF' , '90', 6)
- INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('771EA95D-D4B8-4D21-83F7-677979CDCCFB', 'Autre' , 'Autre' , '90', 7)
- INSERT INTO [Propriete.Enum].B33MatMurPlafond VALUES ('AD5D1C92-A75B-40B4-806D-1F978D517AEC', 'Aucun' , 'Aucun' , '99', 8)
- END
- -- B34
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B34TypePiece'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B34TypePiece (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Cuisine' , 'Cuisine', 1)
- INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Chambre' , 'Chambre', 2 )
- INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('72DD989C-8148-4910-A762-4C19EF076D7B', 'SalleEau' , 'Salle d''eau', 3)
- INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'SalleFamiliale' , 'Salle familiale / Salle de jeux', 4)
- INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('AD5D1C92-A75B-40B4-806D-1F978D517AEC', 'SalleDeBain' , 'Salle de bain', 5)
- INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'SalleAManger' , 'Salle à manger', 6)
- INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Salon' , 'Salon', 7 )
- INSERT INTO [Propriete.Enum].B34TypePiece VALUES ('B88383AA-1DD6-411C-A0AB-5708704D6E56', 'Autre' , 'Autre', 8)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B34Etage'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B34Etage (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B34Etage VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Rdc' , 'Rez-de-chaussée', 1 )
- INSERT INTO [Propriete.Enum].B34Etage VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'SS' , 'Sous-sol', 2 )
- INSERT INTO [Propriete.Enum].B34Etage VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Etg2', '2', 3)
- INSERT INTO [Propriete.Enum].B34Etage VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Etg3', '3', 4)
- INSERT INTO [Propriete.Enum].B34Etage VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Att', 'Attique', 5)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B34MatPlancher'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B34MatPlancher (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('8C39EF4D-7D4D-4697-AE45-9FAFB5559FB7', 'Ardoise' ,'Ardoise' , '40', 1)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('771EA95D-D4B8-4D21-83F7-677979CDCCFB', 'BoisIngenerie', 'Bois d''ingénérie', '60', 2)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'BoisFranc' , 'Bois franc' , '62', 3)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Ceramique' , 'Céramique' , '35', 4)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('9ECBB6F0-AF5A-4FFF-8BD9-A8231978D7A4', 'Epoxy' , 'Époxy' , '60', 5)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'FlottantStrat', 'Flottant Stratifié', '60', 6)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('A48B8065-A4E8-46DA-97E5-C107BF7B5713', 'Marbre' , 'Marbre' , '40', 7)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('3D3D687B-5FC5-4962-9F7F-04A9FA7F7490', 'Parquetereie' , 'Parquetereie' , '60', 8)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Tapis' , 'Tapis' , '75', 9)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Vinyle' , 'Vinyle' , '77', 10)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('BBCF9B45-29E4-4729-9DA5-31FA6A38A414', 'Autre' , 'Autre' , '40', 11)
- INSERT INTO [Propriete.Enum].B34MatPlancher VALUES ('4371B62D-18F7-45D7-A234-2A817DF2003A', 'Aucun' , 'Aucun' , '99', 12)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B36MatArmoire'))
- BEGIN
- -- B36
- CREATE TABLE [Propriete.Enum].B36MatArmoire (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(50) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('D69DCE90-6DE4-4CE7-B949-428828D34266', 'BoisDur', 'Bois dur (chêne, érable, bois laqué etc.)', '60', 1)
- INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('8C92FB06-1F56-4584-8EBC-479F05130BE8', 'BoisMou', 'Bois mou (pin, épinette, cèdre etc.)', '60', 2)
- INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Melamine' , 'Mélamine' , '67', 3)
- INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Polyester' , 'Polyester' , '76', 4)
- INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Thermoplastique', 'Thermoplastique', '76', 5)
- INSERT INTO [Propriete.Enum].B36MatArmoire VALUES ('D6AAAEB8-E5A3-4B13-ADD9-DD273F7E75F7', 'Autre' , 'Autre', '90', 6)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B36QualiteMatComptoir'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B36QualiteMatComptoir (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B36QualiteMatComptoir VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Standard', 'Standard (stratifié, bois, céramique)', 1)
- INSERT INTO [Propriete.Enum].B36QualiteMatComptoir VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Superieur', 'Qualité supérieure (marbre, quartz, granit, béton, corian, stainless)', 2)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B36AppEncastre'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B36AppEncastre (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucun', 'Aucun', 1)
- INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('E5B1A652-510B-4354-BF00-D6A545C1BA50', 'Cellier', 'Chambre cellier vitrée', 2)
- INSERT INTO [Propriete.Enum].B36AppEncastre VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'PlaqueCuissonOuFour', 'Plaque de cuisson et/ou four', 3)
- 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)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43TypeBainDouche'))
- BEGIN
- -- B43
- CREATE TABLE [Propriete.Enum].B43TypeBainDouche(
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B43TypeBainDouche VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Bain', 'Bain', 1)
- INSERT INTO [Propriete.Enum].B43TypeBainDouche VALUES ('E5B1A652-510B-4354-BF00-D6A545C1BA50', 'Douche' , 'Douche' , 2 )
- INSERT INTO [Propriete.Enum].B43TypeBainDouche VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BainDouche' , 'Bain/Douche', 3 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43TypeBain'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B43TypeBain (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'AutoPortant', 'Auto-portant', 1)
- INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('E5B1A652-510B-4354-BF00-D6A545C1BA50', 'Remous' , 'À remous' , 2 )
- INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Encastre' , 'Encastré', 3 )
- INSERT INTO [Propriete.Enum].B43TypeBain VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Podium' , 'Podium' , 4 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43TypeDouche'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B43TypeDouche (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B43TypeDouche VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Ceramique', 'Céramique', 1)
- INSERT INTO [Propriete.Enum].B43TypeDouche VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Plastique', 'Plastique', 2)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43QualiteSalleBain'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B43QualiteSalleBain (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(250) NOT NULL,
- OrderValue INT NOT NULL
- );
- 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
- et/ou au design sophistiqué', 1)
- 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)
- 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)
- 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 )
- 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)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43DescriptionMeubleLavabo'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B43DescriptionMeubleLavabo (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(250) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'SurMesure', 'Fait sur mesure, acquis chez un marchand spécialisé', 1)
- INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'BonneQualite', 'Meuble lavabo de bonne qualité', 2)
- INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Standard', 'Meuble lavabo de qualité standard', 3)
- INSERT INTO [Propriete.Enum].B43DescriptionMeubleLavabo VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Rudimentaire' , 'Meuble lavabo sans attrait/rudimentaire', 4 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43MatDouche'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B43MatDouche (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(250) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Acrylique', 'Acrylique', 1)
- INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Ceramique', 'Céramique', 2)
- INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Metal', 'Métal', 3)
- INSERT INTO [Propriete.Enum].B43MatDouche VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Plastique' , 'Plastique', 4 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43MatMeubleLavabo'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B43MatMeubleLavabo (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(250) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Bois', 'Bois', 1)
- INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Melamine', 'Melamine', 2)
- INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Polyester', 'Polyester', 3)
- INSERT INTO [Propriete.Enum].B43MatMeubleLavabo VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Thermoplastique' , 'Thermoplastique', 4 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43MatTourBain'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B43MatTourBain (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(250) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B43MatTourBain VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Ceramique', 'Céramique', 1)
- INSERT INTO [Propriete.Enum].B43MatTourBain VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Plastique', 'Plastique', 2)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43Couleur'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B43Couleur (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(250) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B43Couleur VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Blanc', 'Blanc', 1)
- INSERT INTO [Propriete.Enum].B43Couleur VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Couleur', 'Couleur', 2)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B43DimensionSalleBain'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B43DimensionSalleBain (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'TresPetite', 'Tres petite (moins de 4 m² / 40 pi²)', 1)
- INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Petite' , 'Petite (de 4 à 8m² / 40 à 85 pi²)', 2 )
- INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Moyenne' , 'Moyenne (de 8 à 12m² / 85 à 130 pi²)', 3 )
- INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'Grande' , 'Grande (de 12 à 16m² / 130 à 170 pi²)', 4 )
- INSERT INTO [Propriete.Enum].B43DimensionSalleBain VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Spacieuse' , 'Spacieuse (plus de 16m² / 170 pi²)', 5 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B44TypeChauffage'))
- BEGIN
- -- B44
- CREATE TABLE [Propriete.Enum].B44TypeChauffage (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'FournaiseElectrique', 'Fournaise électrique', '1', 1)
- INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'FournaiseHuile' , 'Fournaise à l''huile' , '2', 2)
- INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'FournaiseGaz' , 'Fournaise à gaz' , '3', 3)
- INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'FournaiseBois' , 'Fournaise à bois' , '4', 4)
- INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Geothermie' , 'Géothermie' , '5', 5)
- INSERT INTO [Propriete.Enum].B44TypeChauffage VALUES ('62424A37-5945-4809-9306-DA08F47179A7', 'PlintheElectrique' , 'Plinthe électrique' , '6', 6)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B44TypeDistribChauf'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B44TypeDistribChauf (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B44TypeDistribChauf VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Aire', 'À air', '1', 1)
- INSERT INTO [Propriete.Enum].B44TypeDistribChauf VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Eau', 'À eau', '3', 2)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B44TypeClimatisation'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B44TypeClimatisation (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'ClimatiseurCentral', 'Climatiseur central', '1', 1)
- INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'ClimatiseurMural', 'Climatiseur mural', '2', 2)
- INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('33780049-8FBA-40E8-BBF4-57E5A7CADE14', 'ThermopompeCentrale' , 'Thermopompe centrale' , '2', 3)
- INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'ThermopompeMurale' , 'Thermopompe murale' , '4', 4)
- INSERT INTO [Propriete.Enum].B44TypeClimatisation VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'Aucun' , 'Aucun' , '8', 5)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B44TypeDistribClim'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B44TypeDistribClim (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B44TypeDistribClim VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Exclusive' , 'Exclusive' , '1', 1)
- INSERT INTO [Propriete.Enum].B44TypeDistribClim VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'PartageChauffage', 'Partage du chauffage', '2', 2)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B59Appareils'))
- BEGIN
- -- B59
- CREATE TABLE [Propriete.Enum].B59Appareils (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B59Appareils VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Ascenseur' , 'Ascenseur' , '3', 1)
- INSERT INTO [Propriete.Enum].B59Appareils VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'AspirateurCentral', 'Aspirateur central', '1', 2)
- INSERT INTO [Propriete.Enum].B59Appareils VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Sauna' , 'Sauna' , '2', 3)
- INSERT INTO [Propriete.Enum].B59Appareils VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'SpaInterieur' , 'Spa intérieur' , '4', 4)
- INSERT INTO [Propriete.Enum].B59Appareils VALUES ('62424A37-5945-4809-9306-98EACC8B2DE0', 'SystemeAlarme' , 'Système d''alarme' , '5', 5)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B59TypeFoyer'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B59TypeFoyer (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('222B591C-6882-4F15-BFBA-A256BAB9C6E8', 'BoisGranule', 'Poêle à bois ou à granules', '4', 1)
- INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('40C7858D-061F-40AA-9CA4-1F886F237033', 'Bois' , 'Foyer à bois' , '1', 2)
- INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('339279E1-9898-4347-B14C-B7D09E1344E3', 'Granule' , 'Foyer à granule' , '2', 3)
- INSERT INTO [Propriete.Enum].B59TypeFoyer VALUES ('3264C0BA-31D8-4A9F-A34C-FF681F65004D', 'Gaz' , 'Foyer à gaz' , '3', 4)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B59TypeEtatSPA'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B59TypeEtatSPA (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Excellent' , 'Excellent' , '1', 1)
- INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'TresBon' , 'Tres bon' , '2', 2)
- INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Acceptable', 'Acceptable', '3', 3)
- INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'Mediocre' , 'Médiocre' , '4', 4)
- INSERT INTO [Propriete.Enum].B59TypeEtatSPA VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'Delabre' , 'Délabré' , '5', 5)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B62TypeFondGarAttache'))
- BEGIN
- -- B62
- CREATE TABLE [Propriete.Enum].B62TypeFondGarAttache (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Muret' , 'Muret' , '3', 1)
- INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Piliers' , 'Piliers' , '1', 2)
- INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'PiliersExacve', 'Piliers excavés', '2', 3)
- INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'Radier' , 'Radier' , '4', 4)
- INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'Sole' , 'Sole' , '5', 5)
- INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'SousSol' , 'Sous-sol' , '6', 6)
- INSERT INTO [Propriete.Enum].B62TypeFondGarAttache VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'VideSanitaire', 'Vide sanitaire', '7', 7)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B63AireRemise'))
- BEGIN
- -- B63
- CREATE TABLE [Propriete.Enum].B63AireRemise (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- M2 DECIMAL,
- OrderValue INT NOT NULL
- );
- 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)
- INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( 'A239D04C-D8E2-46BA-9B96-F8F10A0450E2', '8x12', '8 X 10 (pi) / 2.5 X 3 (m)' , '7.5', 2)
- INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( 'F8564FEA-D8DB-4C5D-8F31-707C11C9B731', '10x10', '10 X 10 (pi) / 3 X 3 (m)' , '9', 3)
- INSERT INTO [Propriete.Enum].B63AireRemise VALUES ( '64043AFD-2FF8-43A6-A04A-545214B9A7E4', '10x12', '10 X 12 (pi) / 3 X 3.7 (m)' , '11.1', 4)
- 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)
- 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)
- 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)
- 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)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B71TypePiscine'))
- BEGIN
- -- B71
- CREATE TABLE [Propriete.Enum].B71TypePiscine (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B71TypePiscine VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Creusee' , 'Creusée' , '1', 1)
- INSERT INTO [Propriete.Enum].B71TypePiscine VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'SemiCreusee', 'Semi-creusée', '2', 2)
- INSERT INTO [Propriete.Enum].B71TypePiscine VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'HorsTerre' , 'Hors-terre' , '3', 3)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B71TypeEtatPiscine'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B71TypeEtatPiscine (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Excellent' , 'Excellent' , '1', 1)
- INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'TresBon' , 'Très bon' , '2', 2)
- INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Acceptable', 'Acceptable', '3', 3)
- INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'Mediocre' , 'Médiocre' , '4', 4)
- INSERT INTO [Propriete.Enum].B71TypeEtatPiscine VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'Delabre' , 'Délabré' , '5', 5)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B71TypeFormePiscine'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B71TypeFormePiscine (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B71TypeFormePiscine VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Ronde', 'Ronde', '1', 1)
- INSERT INTO [Propriete.Enum].B71TypeFormePiscine VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Autre', 'Autre', '2', 2)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'B71MatStationnement'))
- BEGIN
- CREATE TABLE [Propriete.Enum].B71MatStationnement (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Asphalte' , 'Asphalte' , '16', 1)
- INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Beton' , 'Béton' , '10', 2)
- INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Concasse' , 'Concassé' , '43', 3)
- INSERT INTO [Propriete.Enum].B71MatStationnement VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'DaleImbrique', 'Dale imbriquée/inter bloc', '15', 4)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'General.Enum'
- AND TABLE_NAME = 'UniteMesure'))
- BEGIN
- CREATE TABLE [General.Enum].UniteMesure (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- Code NVARCHAR(2) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [General.Enum].UniteMesure VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Pieds', 'Pieds', '1', 1)
- INSERT INTO [General.Enum].UniteMesure VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Metre', 'Mètres', '2', 2)
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'FraisExploitation'))
- BEGIN
- CREATE TABLE [Propriete.Enum].FraisExploitation (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'Administration', 'Administration', 1 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'Assurance', 'Assurance', 2 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'Chauffage', 'Chauffage (combustible)', 3 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('659AA197-DBBA-4D7C-A8D8-5C08F0633FE8', 'ContetantSanitaire', 'Contenant sanitaire (location)', 4 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('7B3BB3A7-4373-410C-B3E7-DA08F47179A7', 'Deneigement', 'Déneigement', 5 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Electricite', 'Électricité', 6 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('262A5A89-A6AE-4ED1-89FB-F0F7599D32BE', 'EntretientReparation', 'Entretien et réparations', 7 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('E2787FB1-F2B9-4BBF-8531-97832CE1B76A', 'FraisConciergerie', 'Frais conciergerie', 8 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('3B9C3BBE-F092-4829-A0DD-BA055F626556', 'HonoraireProfessionnel', 'Honoraire professionnels', 9 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('A02E292E-620F-482A-B0B6-9586B3A9AD54', 'Publicite', 'Publicité', 10 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('469B2334-6FEF-4BAF-A04D-4050D40B0C22', 'ReserveRemplacement', 'Réserve de remplacement', 11 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('E995017A-A2CC-4B70-8D0E-D5AF1917C78E', 'SalaireAvantageSociaux', 'Salaire et avantages sociaux', 12 )
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'TaxeFonciereScolaire', 'Taxes foncières et scolaires', 13)
- INSERT INTO [Propriete.Enum].FraisExploitation VALUES ('B0349FA8-BD80-4C36-B329-4B1518EAABE4', 'AutreDepense', 'Autre dépenses', 14 )
- END
- IF (NOT EXISTS (SELECT *
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = 'Propriete.Enum'
- AND TABLE_NAME = 'RevenusLocation'))
- BEGIN
- CREATE TABLE [Propriete.Enum].RevenusLocation (
- Enum_Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
- NameValue NVARCHAR(25) NOT NULL,
- ViewValue NVARCHAR(175) NOT NULL,
- OrderValue INT NOT NULL
- );
- INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('3B52CCFA-5514-4143-B697-DD897C4981EB', 'Commerces', 'Commerces', 1)
- INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('A239D04C-D8E2-46BA-9B96-F8F10A0450E2', 'Logements', 'Logements', 2)
- INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('F8564FEA-D8DB-4C5D-8F31-707C11C9B731', 'RecupFraisExpl', 'Récuperation des frais d''exploitation', 3)
- INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('64043AFD-2FF8-43A6-A04A-545214B9A7E4', 'RevenusStationnement', 'Revenus de stationnement', 4)
- INSERT INTO [Propriete.Enum].RevenusLocation VALUES ('6DF0C192-EEFF-4CC2-927D-A8B5742E19C9', 'AutreRevenus', 'Autre revenus', 5)
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement