-- Crear tabla RamosAGORA - Ramo API ASM
CREATE TABLE TESISSEG.dbo.AGORA_ASM (
                                        ID INT IDENTITY(1,1) NOT NULL,
                                        RamoASM VARCHAR(250) COLLATE Modern_Spanish_CI_AS NULL,
                                        RamoAgora VARCHAR(250) COLLATE Modern_Spanish_CI_AS NULL,
                                        CONSTRAINT PK_AGORA_ASM PRIMARY KEY (ID)
);

SET IDENTITY_INSERT TESISSEG.dbo.AGORA_ASM ON;

INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(1, N'Car', N'Car');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(2, N'Health', N'Health');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(3, N'Motorcycle', N'Motorbike');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(4, N'Home', N'Home');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(5, N'PersonalLegalDefense', N'LegalDefence');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(6, N'Burial', N'Burial');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(7, N'ReplacementVehicle', N'ReplacementVehicle');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(8, N'FamilyLegalDefense', N'FamilyLegalDefense');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(9, N'RoadsideAssistance', N'RoadsideAssistance');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(10, N'Travel', N'Travel');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(11, N'TermLife', N'Life');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(12, N'SavingsLife', N'LifeSaving');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(13, N'Boat', N'Boats');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(14, N'CommercialProperty', N'TradeAndOffice');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(15, N'Community', N'Community');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(16, N'AgriculturalMachinery', N'AgriculturalMachinery');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(17, N'ExcessVehicle', N'ExcessVehicle');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(18, N'ShortTermVehicle', N'VehicleInsuranceForDays');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(19, N'Accident', N'Accident');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(20, N'CorporateDirectorsAndOfficers', N'DAndO');
INSERT INTO TESISSEG.dbo.AGORA_ASM
(ID, RamoASM, RamoAgora)
VALUES(21, N'Car', N'Vehicle');

SET IDENTITY_INSERT TESISSEG.dbo.AGORA_ASM OFF;
