-- *****************************
-- RC Pro
-- *****************************

 UPDATE `mon_entreprise` SET
`id_entreprise` = '1',
`raison_sociale` = 'PGE Services',
`adresse` = '35 hameaux des lacs',
`complement_adresse` = NULL,
`code_postal` = '59510',
`ville` = 'Forêt-Sur-Marque',
`pays` = 'France',
`tel` = '0954993454',
`gsm` = '0685532246',
`fax` = NULL,
`email` = 'pge59000@gmail.com',
`forme_juridique` = NULL,
`capital` = NULL,
`siret` = '52075582800032',
`naf` = NULL,
`num_tva_intra` = 'FR46520755828'
WHERE `id_entreprise` = '1';

ALTER TABLE `mon_entreprise`
ADD `rcs` varchar(45) COLLATE 'utf8_general_ci' NULL,
ADD `rc_pro` varchar(80) COLLATE 'utf8_general_ci' NULL AFTER `rcs`;

-- ALTER TABLE `mon_entreprise`
-- CHANGE `rc_pro` `rc_pro` varchar(80) COLLATE 'utf8_general_ci' NULL AFTER `rcs`;

UPDATE `mon_entreprise` SET
`id_entreprise` = '1',
`raison_sociale` = 'PGE Services',
`adresse` = '35 hameaux des lacs',
`complement_adresse` = NULL,
`code_postal` = '59510',
`ville` = 'Forêt-Sur-Marque',
`pays` = 'France',
`tel` = '0954993454',
`gsm` = '0685532246',
`fax` = NULL,
`email` = 'pge59000@gmail.com',
`forme_juridique` = NULL,
`capital` = NULL,
`siret` = '52075582800032',
`naf` = NULL,
`num_tva_intra` = 'FR46520755828',
`rcs` = 'Lille Métropole A 520 755 828',
`rc_pro` = 'N° ORIAS : 11060719 - RC Pro : contrat N° 55982745'
WHERE `id_entreprise` = '1';



-- *****************************
-- Dépenses
-- *****************************
ALTER TABLE `depenses`
ADD `photo` varchar(200) COLLATE 'utf8_general_ci' NULL;





-- ######################################
-- A ajouter
-- ######################################


-- *****************************
-- Ramonages
-- *****************************

ALTER TABLE `ramonages`
CHANGE `gicleurs` `gicleurs` int(1) NOT NULL COMMENT 'Accessoires, vis, lingettes' AFTER `controle_combustion`,
CHANGE `flexibles` `flexibles` int(1) NOT NULL COMMENT 'Joints' AFTER `gicleurs`;

ALTER TABLE `ramonages`
ADD `poele_etanche` int(1) NULL COMMENT '1= Oui, 0= Non',
ADD `commentaire_validation` text COLLATE 'utf8_general_ci' NULL AFTER `poele_etanche`,
ADD `conduit` int(1) NULL COMMENT '1=Zone 1,2=Zone 2, 3=Zone 3' AFTER `commentaire_validation`;

ALTER TABLE `ramonages`
CHANGE `sign` `sign` date NULL AFTER `mention2`;


-- *****************************
-- Entretiens annuels
-- *****************************
CREATE TABLE `interventions_annuel_planning` (
  `id` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `annee` int(4) NOT NULL,
  `mois` int(2) NOT NULL,
  `nb` int(5) NOT NULL
) ENGINE='InnoDB';


ALTER TABLE `interventions`
ADD `annuel` text(7) COLLATE 'utf8_general_ci' NULL COMMENT 'Entretien annuel';


ALTER TABLE `interventions`
CHANGE `annuel` `annuel` varchar(7) COLLATE 'utf8_general_ci' NULL COMMENT 'Entretien annuel' AFTER `commentaire_secretariat`;


ALTER TABLE `interventions`
CHANGE `traite` `traite` int(1) NOT NULL DEFAULT '0' COMMENT '1=Oui, 0=Non, 2=Annule' AFTER `pieces_changer_delai`;


ALTER TABLE `ramonages`
CHANGE `sign` `sign` text COLLATE 'utf8_general_ci' NULL AFTER `mention2`;
