back to first page [..][[BR]]


= Scripts de creation ONEMA =
    * source:trunk/EDAcommun/sql/implementation_pose/1-language_schema.sql
    * source:trunk/EDAcommun/sql/implementation_pose/2-function.sql
    * source:trunk/EDAcommun/sql/implementation_pose/3-nomenclatures.sql
    * source:trunk/EDAcommun/sql/implementation_pose/4-Squelette.sql
    * source:trunk/EDAcommun/sql/implementation_pose/5-obs_scientifique.sql
    * source:trunk/EDAcommun/sql/implementation_pose/6-PressionImpact.sql
    * source:trunk/EDAcommun/sql/implementation_pose/7-Biological_Process.sql
    * source:trunk/EDAcommun/sql/implementation_pose/db_feeding.sql
    * source:trunk/EDAcommun/sql/implementation_pose/db_feeding_BDMAP.sql 

= inserting BDMAP =
I already have a dump of the BDMAP somewhere so I'm just saving it and will use it to insert data into the debile.
{{{
sauvegarde
cd C:\eda\backup
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 --schema=bdmap BDMAP> bdmap.bdmap.sql
restauration
C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d dbeel -p 5433 -f bdmap.bdmap.sql
}}}

= BDMAP changes by cedric =

changeset:2485 download of base modif from Laurent, the 10 files above [[BR]]
changeset:2486 in the script I first include dbeel.establishment and data.provider, and I'm not copying from .csv files anymore, station finished [[BR]]
changeset:2487 finishing changes in electrofishing, changes brought to operation  [[BR]]
changeset:2488 finishing changes in operations [[BR]]
changeset:2489 included number in optaxon; added stages to batch. [[BR]]
changeset:2490 optaxon, passtaxon batch. [[BR]]
changeset:2491 lotpeche [[BR]]
changeset:2492 lotpeche mensurationindiv[[BR]]

= inserting Western River Basin District (Ireland) =

REM sauvegarde
cd C:\eda\backup
C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 --schema=wrbd -T wrbd.irish_catchments -T wrbd.irish_lakes -T wrbd.irish_water_bodies -T wrbd.outline_of_ireland -T wrbd.wfd_lakesegment_we -T wrbd.wfd_riversegment_we -T wrbd.wfd_riversubbasins_we eda2.0> eda2.0.wrbd.sql
REM restauration, restoring the whole schema preserves indexes and foreign keys
C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d dbeel -p 5433 -f eda2.0.wrbd.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d dbeel -p 5433 -c 'create schema wrbd; alter table fish_fi set schema wrbd;alter table operation_op set schema wrbd;alter table