- update Drupal site_name variable with PLC_NAME

diff --git a/plc.d/db b/plc.d/db
index 0286f61..b4da453 100755 (executable)
--- a/plc.d/db
+++ b/plc.d/db
@@ -7,7 +7,7 @@
 # Mark Huang <mlhuang@cs.princeton.edu>
 # Copyright (C) 2006 The Trustees of Princeton University
 #
-# $Id: api,v 1.3 2006/04/25 21:18:19 mlhuang Exp $
+# $Id: db,v 1.1 2006/06/23 21:41:42 mlhuang Exp $
 #
 
 # Source function library and configuration
@@ -36,6 +36,12 @@ case "$1" in
        # DB schema itself.
        psql -U $PLC_DB_USER -c "UPDATE persons SET email='$PLC_API_MAINTENANCE_USER' WHERE person_id=1" $PLC_DB_NAME
 
+       # Update the Drupal site_name variable
+       psql -U $PLC_DB_USER drupal <<EOF
+DELETE FROM variable WHERE name = 'site_name';
+INSERT INTO variable (name, value) VALUES ('site_name', 's:${#PLC_NAME}:"$PLC_NAME";');
+EOF
+
        # Bootstrap the DB
        db-config
        check