/**
 * @author tpasquet via dbuisine
 * @date 04/08/21
 * @version 1.0.0
 * @project SIEau
 * @table public.inst_batiments
 */

# --- !Ups
create table public.inst_batiments (codeinstallation bigint NULL,
                                    indicebatiment integer NULL,
                                    typebatiment bigint NULL,
                                    surfacebatiment real NULL,
                                    commentaires text NULL);
insert into inst_batiments (select * from inst_step_gc_batiments);
insert into inst_batiments (select * from inst_st_pompage_gc_batiments);

# --- !Downs
