diff scripts/search/dbsavedsearch-delete @ 10:a50cf11e5178

Rewrite LGDataverse completely upgrading to dataverse4.0
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 08 Sep 2015 17:00:21 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/search/dbsavedsearch-delete	Tue Sep 08 17:00:21 2015 +0200
@@ -0,0 +1,6 @@
+#!/bin/bash -x
+~/.homebrew/bin/psql -c "delete from savedsearchfilterquery;" dataverse_db
+~/.homebrew/bin/psql -c "delete from savedsearch cascade;" dataverse_db
+exit
+~/.homebrew/bin/psql -c "drop table savedsearch cascade;" dataverse_db
+~/.homebrew/bin/psql -c "drop table savedsearchfilterquery cascade;" dataverse_db