GP > Documentation > Procédure d’installation de la version 10.1.0
Procédure d’installation de la version 10.1.0
vendredi 24 juin 2011, par
Cette version d’intègre les modifications fonctionnelles pour le suivi des subventions
Modification sur la base de donnée
Voici l’ensemble des modifications à effectuer sur la base de données avant installation de cette version
%
% Ajout de nouveaux sous type de financement
%
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('STF','ANRU','','ANRU','O',0,0,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('STF','EPCI','','EPCI','O',0,0,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('STF','B1','','REGION (amélioration qualité)','O',0,0,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('STF','B2','','REGION (autres)','O',0,0,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('STF','B3','','VILLE','O',0,0,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('STF','B4','','AUTRES ORGANISMES 1','O',0,0,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('STF','B5','','AUTRES ORGANISMES 2','O',0,0,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
%
% Modification de l'ordre des natures de subventions
%
UPDATE GP_CODS SET NUM_ORD=14 where CODPAR='NFS' AND VALPAR is null AND LIBEL='SUBV 1 PCT RELANCE';
UPDATE GP_CODS SET NUM_ORD=20 where CODPAR='NFS' AND VALPAR is null AND LIBEL='SUBVENTION AUTRE A1';
UPDATE GP_CODS SET NUM_ORD=21 where CODPAR='NFS' AND VALPAR is null AND LIBEL='SUBVENTION AUTRE A2';
UPDATE GP_CODS SET NUM_ORD=6 where CODPAR='NFS' AND VALPAR='PLAI' AND LIBEL='PLA INTEGRATION' AND TYFI_SS_TYFI='SE';
UPDATE GP_CODS SET NUM_ORD=5 where CODPAR='NFS' AND VALPAR='PLUS' AND LIBEL='PLUS' AND TYFI_SS_TYFI='SE';
%
% Ajout de nouvelles natures de subventions
%
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','','SE','Autres','O',7,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','PLUSCD','SANRU','Subventions ANRU','O',8,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','PLUS','SEPCI','PLUS','O',9,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','PLAI','SEPCI','PLAI','O',10,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','PLUSCD','SEPCI','PLUSCD','O',11,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','PLSF','SEPCI','PLS','O',12,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','','SEPCI','Autres','O',13,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','','SB1','Régions (amélioration qualité)','O',15,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','','SB2','Région (autres)','O',16,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','','SB3','Ville','O',17,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','','SB4','Autres organismes 1','O',18,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('NFS','','SB5','Autres organismes 2','O',19,3,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
%
% Ajout des organismes subventionneurs
%
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG1','','EDF','O',1,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG2','','GDF','O',2,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG3','','CNAM','O',3,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG4','','Département','O',4,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG5','','CAF','O',5,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG6','','FEDER','O',6,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG7','','Ademe','O',7,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG8','','Rectorat','O',8,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG9','','FNSE','O',9,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG10','','DDASS','O',10,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG11','','Caisse de retraite','O',11,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG12','','Fondations','O',12,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG13','','Vente / cession / VEFA','O',13,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG14','','Pas-de-Calais Habitat','O',14,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
INSERT INTO GP.GP_CODS (CODPAR,VALPAR,TYFI_SS_TYFI,LIBEL,VALID,NUM_ORD,NUM_COL,LIENPRET,DATCREA,DATMAJ,QUIMAJ,D_DEBUT_VAL,D_FIN_VAL) VALUES ('ORF','ORG15','','Autres','O',15,1,'',sysdate,sysdate,'GLESCAUTM',TO_DATE('19800101','YYYYMMDD'),TO_DATE('20991231','YYYYMMDD'));
%
% Ajout de la colonne des organismes subventionneurs dans la table GP_HFINA
%
ALTER TABLE GP_HFINA ADD C_ORG VARCHAR2(8);
%
% Modification des libellés des types de logements
%
UPDATE GP_HLOCA SET C_TYP_LOGT='PARKINGS' where C_TYP_LOGT='JARDIN';
UPDATE GP_HCHAPL SET C_TYP_LOGT='PARKINGS' where C_TYP_LOGT='JARDIN';
UPDATE GP_CODS SET VALPAR='PARKINGS',LIBEL='PARKINGS' where CODPAR='TLOGT' AND VALPAR='JARDIN';
UPDATE GP_HLOCA SET C_TYP_LOGT='COMMERCE' where C_TYP_LOGT='AUTRE';
UPDATE GP_HCHAPL SET C_TYP_LOGT='COMMERCE' where C_TYP_LOGT='AUTRE';
UPDATE GP_CODS SET VALPAR='COMMERCE', LIBEL='COMMERCE' where CODPAR='TLOGT' AND VALPAR='AUTRE';
UPDATE GP_HLOCA SET C_TYP_LOGT='T5' where C_TYP_LOGT='T5+';
UPDATE GP_CODS SET LIBEL='T5',VALPAR='T5' where CODPAR='TLOGT' AND VALPAR='T5+';
UPDATE GP_HCHAPL SET C_TYP_LOGT='T5' where C_TYP_LOGT='T5+';
%
% Ajout de la colonne montant 'foncier versé à la commune' dans la table GP_HOPER
%
ALTER TABLE GP_HOPER ADD MNT_F_COM NUMBER(10,0);
%
% Ajout de valeur à exporter vers le fichier Excel
%
INSERT INTO GP.GP_BD_EX (NOM_CHAMP,LIEN_LIGEX,LIEN_COLEX,DAT_MAJ,QUI_MAJ,TYPE) VALUES ('MNT_F_COM','173','4',sysdate,'GLESCAUTM','I');