/**
 * @author sbarthon
 * @date 02/06/2022
 * @version 1.0.0
 * @project SIEau
 * @table codes_sandre
 */
# --- !Ups

drop view  if exists  lex_continuite;
drop view  if exists  lex_cote_chronique ;
drop view  if exists  lex_dip ;
drop view  if exists  lex_etat_hg;
drop view  if exists  lex_etat_pe;
drop view  if exists  lex_mode_depouillement;
drop view  if exists  lex_mode_gisement;
drop view  if exists  lex_mode_mesure;
drop view  if exists  lex_mode_obtention;
drop view  if exists  lex_nature_hg;
drop view  if exists  lex_nature_pe;
drop view  if exists  lex_nature_reference;
drop view  if exists  lex_origin_interv;
drop view  if exists  lex_periodicite_acquis;
drop view  if exists  lex_precision_alti;
drop view  if exists  lex_projection;
drop view  if exists  lex_reference_temporelle;
drop view  if exists  lex_situation;
drop view  if exists  lex_statut;
drop view  if exists  lex_structure_hg;
drop view  if exists  lex_systeme_alti;
drop view  if exists  lex_type_connexion;
drop view  if exists  lex_type_reservoir;
drop view  if exists  lex_validite;
drop view  if exists  pz_mode_mesure;

alter table codes_sandre alter column libelle type character varying(255);
# --- !Downs

