-- 1/3 : Création de la table temporaire
DROP TABLE IF EXISTS w_dbsetup
;

CREATE TEMP TABLE w_dbsetup AS
    SELECT 
    	oid AS keepoid, 
    	code, 
    	texte
    FROM rh.t_ages
    ORDER BY code
     LIMIT 0
;

-- 2/3 : Peuplement de la table temporaire
INSERT INTO w_dbsetup(
    keepoid,
    code,
    texte
)
VALUES
(0, '000', 'Nouveaux nés'),
(1, '001', '1 an'),
(2, '002', '2 ans'),
(3, '003', '3 ans'),
(4, '004', '4 ans'),
(5, '005', '5 ans'),
(6, '006', '6 ans'),
(7, '007', '7 ans'),
(8, '008', '8 ans'),
(9, '009', '9 ans'),
(10, '010', '10 ans'),
(11, '011', '11 ans'),
(12, '012', '12 ans'),
(13, '013', '13 ans'),
(14, '014', '14 ans'),
(15, '015', '15 ans'),
(16, '016', '16 ans'),
(17, '017', '17 ans'),
(18, '018', '18 ans'),
(19, '019', '19 ans'),
(20, '020', '20 ans'),
(21, '021', '21 ans'),
(22, '022', '22 ans'),
(23, '023', '23 ans'),
(24, '024', '24 ans'),
(25, '025', '25 ans'),
(26, '026', '26 ans'),
(27, '027', '27 ans'),
(28, '028', '28 ans'),
(29, '029', '29 ans'),
(30, '030', '30 ans'),
(31, '031', '31 ans'),
(32, '032', '32 ans'),
(33, '033', '33 ans'),
(34, '034', '34 ans'),
(35, '035', '35 ans'),
(36, '036', '36 ans'),
(37, '037', '37 ans'),
(38, '038', '38 ans'),
(39, '039', '39 ans'),
(40, '040', '40 ans'),
(41, '041', '41 ans'),
(42, '042', '42 ans'),
(43, '043', '43 ans'),
(44, '044', '44 ans'),
(45, '045', '45 ans'),
(46, '046', '46 ans'),
(47, '047', '47 ans'),
(48, '048', '48 ans'),
(49, '049', '49 ans'),
(50, '050', '50 ans'),
(51, '051', '51 ans'),
(52, '052', '52 ans'),
(53, '053', '53 ans'),
(54, '054', '54 ans'),
(55, '055', '55 ans'),
(56, '056', '56 ans'),
(57, '057', '57 ans'),
(58, '058', '58 ans'),
(59, '059', '59 ans'),
(60, '060', '60 ans'),
(61, '061', '61 ans'),
(62, '062', '62 ans'),
(63, '063', '63 ans'),
(64, '064', '64 ans'),
(65, '065', '65 ans'),
(66, '066', '66 ans'),
(67, '067', '67 ans'),
(68, '068', '68 ans'),
(69, '069', '69 ans'),
(70, '070', '70 ans'),
(71, '071', '71 ans'),
(72, '072', '72 ans'),
(73, '073', '73 ans'),
(74, '074', '74 ans'),
(75, '075', '75 ans'),
(76, '076', '76 ans'),
(77, '077', '77 ans'),
(78, '078', '78 ans'),
(79, '079', '79 ans'),
(80, '080', '80 ans'),
(81, '081', '81 ans'),
(82, '082', '82 ans'),
(83, '083', '83 ans'),
(84, '084', '84 ans'),
(85, '085', '85 ans'),
(86, '086', '86 ans'),
(87, '087', '87 ans'),
(88, '088', '88 ans'),
(89, '089', '89 ans'),
(90, '090', '90 ans'),
(91, '091', '91 ans'),
(92, '092', '92 ans'),
(93, '093', '93 ans'),
(94, '094', '94 ans'),
(95, '095', '95 ans'),
(96, '096', '96 ans'),
(97, '097', '97 ans'),
(98, '098', '98 ans'),
(99, '099', '99 ans'),
(100, '100', '100 ans'),
(101, '101', '101 ans'),
(102, '102', '102 ans'),
(103, '103', '103 ans'),
(104, '104', '104 ans'),
(105, '105', '105 ans'),
(106, '106', '106 ans'),
(107, '107', '107 ans'),
(108, '108', '108 ans'),
(109, '109', '109 ans'),
(110, '110', '110 ans')
;

-- 3/3 : Màj de la table iCTI
UPDATE rh.t_ages SET 
	code = w_dbsetup.code,
	texte = w_dbsetup.texte
FROM w_dbsetup
WHERE t_ages.oid = w_dbsetup.keepoid
;

INSERT INTO rh.t_ages(oid, code, texte)
	SELECT keepoid, code, texte FROM w_dbsetup WHERE keepoid NOT IN (SELECT oid FROM rh.t_ages)
;
	
SELECT * FROM rh.cti_update_schema_classes('AGE')
;