-- INSERTION DES ACCESSECOIRS GARANT  -- 999 999 999

-- SELECT * FROM baremeaccessoire WHERE codeGcAssureur='SAAR'

-- 1-- Groupe
INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','1','99000','0','5000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','100000','199999','0','10000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','200000','499999','0','20000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','500000','999999','0','30000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','1000000','4999999','0','40000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','5000000','9999999','0','50000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','10000000','14999999','0','100000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','15000000','19999999','0','150000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','20000000','29999999','0','200000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','5','30000000','9999999999','0','250000','1');

-- 2 -- Individuel
INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','P','5','1','99000','0','5000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','P','5','100000','499999','0','10000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','P','5','500000','9999999999','0','20000','1');

-- 3-- SUR REMBOURSEMENT   -- 100 000

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','P','6','0','99999','0','0','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','P','6','100000','9999999999','0','5000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','6','0','99999','0','0','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','6','100000','999999','0','10000','1');

INSERT INTO baremeaccessoire(codeSociete,codeGcAssureur,codeTypeContrat,codeApplication,primeMin,primeMax,tauxAccessoire,accessoireForfait, choix)
VALUES	('vitalis','SAAR','G','6','1000000','9999999999','0','20000','1');



