search

lter / LTER-core-metabase

RDB model, based on the GCE LTER Metabase, with adaptations from other LTER sites
https://lter.github.io/LTER-core-metabase/
GNU General Public License v3.0
11 stars 4 forks source link

provide optional script to DELETE example data #64

Closed atn38 closed 5 years ago

atn38 commented 5 years ago

We decided to provide a one-file install script that includes everything. We think it's a good way to show people how to use metabase. If people want to delete the example data while keeping controlled vocabs and suggested content (Thesauri and Taxonomic Providers), Gastil will write an optional SQL script for them.

gastil commented 5 years ago

patch 26_delete_exampledatasets.sql deletes the four examples provided (at least as of now). This is an OPTIONAL patch. It does not delete the EML or List tables' rows that come with initial installation. I expect to make another patch for the List but perhaps not for the EML unless someone suggests otherwise. Will close this issue after List script is done.

I suggest NOT patching OBF with this delete. We do want the examples to ship with the install. (heads up @atn38)

gastil commented 5 years ago

patches 28_delete_all_rows_from_ListTables.sql and 29_delete_all_rows_from_EMLTables.sql complete this issue. Again, do not apply these "patches" as routine. These are only for special cases when empty parent tables are desired.

Do not make an OBF with 26, 28, or 29 applied.