/* **Kayros**
 Disponibilizar os cartões de consumo de 0001 a 0100, e de 1000 a 1500. Entre a numeração 0101 a 0999,
apenas os cartões que tem a mesma numeração dos apartamentos. */

update cconsumo set ccc_status =1 where ccc_numero between 101 and 999;
update cconsumo set ccc_status =0 where ccc_numero = 0301;
update cconsumo set ccc_status =0 where ccc_numero = 0302;
update cconsumo set ccc_status =0 where ccc_numero = 0303;
update cconsumo set ccc_status =0 where ccc_numero = 0304;
update cconsumo set ccc_status =0 where ccc_numero = 0305;
update cconsumo set ccc_status =0 where ccc_numero = 0306;
update cconsumo set ccc_status =0 where ccc_numero = 0307;
update cconsumo set ccc_status =0 where ccc_numero = 0401;
update cconsumo set ccc_status =0 where ccc_numero = 0402;
update cconsumo set ccc_status =0 where ccc_numero = 0403;
update cconsumo set ccc_status =0 where ccc_numero = 0404;
update cconsumo set ccc_status =0 where ccc_numero = 0405;
update cconsumo set ccc_status =0 where ccc_numero = 0406;
update cconsumo set ccc_status =0 where ccc_numero = 0407;
update cconsumo set ccc_status =0 where ccc_numero = 0501;
update cconsumo set ccc_status =0 where ccc_numero = 0502;
update cconsumo set ccc_status =0 where ccc_numero = 0503;
update cconsumo set ccc_status =0 where ccc_numero = 0504;
update cconsumo set ccc_status =0 where ccc_numero = 0505;
update cconsumo set ccc_status =0 where ccc_numero = 0506;
update cconsumo set ccc_status =0 where ccc_numero = 0507;
update cconsumo set ccc_status =0 where ccc_numero = 0601;
update cconsumo set ccc_status =0 where ccc_numero = 0602;
update cconsumo set ccc_status =0 where ccc_numero = 0603;
update cconsumo set ccc_status =0 where ccc_numero = 0604;
update cconsumo set ccc_status =0 where ccc_numero = 0605;
update cconsumo set ccc_status =0 where ccc_numero = 0606;
update cconsumo set ccc_status =0 where ccc_numero = 0607;
update cconsumo set ccc_status =0 where ccc_numero = 0701;
update cconsumo set ccc_status =0 where ccc_numero = 0702;
update cconsumo set ccc_status =0 where ccc_numero = 0703;
update cconsumo set ccc_status =0 where ccc_numero = 0704;
update cconsumo set ccc_status =0 where ccc_numero = 0705;
update cconsumo set ccc_status =0 where ccc_numero = 0706;
update cconsumo set ccc_status =0 where ccc_numero = 0707;
update cconsumo set ccc_status =0 where ccc_numero = 0801;
update cconsumo set ccc_status =0 where ccc_numero = 0802;
update cconsumo set ccc_status =0 where ccc_numero = 0803;
update cconsumo set ccc_status =0 where ccc_numero = 0804;
update cconsumo set ccc_status =0 where ccc_numero = 0805;
update cconsumo set ccc_status =0 where ccc_numero = 0806;
Commit;