00005b72fb81425da34d48f77c518af8e6c3928d
braney
  Fri Mar 19 13:59:05 2021 -0700
add defaultCart to standard hgcentral tables

diff --git src/utils/qa/weeklybld/buildHgCentralSql.csh src/utils/qa/weeklybld/buildHgCentralSql.csh
index b19d1c3..1bcb39e 100755
--- src/utils/qa/weeklybld/buildHgCentralSql.csh
+++ src/utils/qa/weeklybld/buildHgCentralSql.csh
@@ -16,31 +16,31 @@
 cd ${BUILDHOME}/build-hgdownload/admin
 git pull origin master
 
 ### Creates these tables only
 set CREATE_ONLY="sessionDb userDb hubStatus gbMembers namedSessionDb" 
 set CREATE_OR_LIST=`echo "${CREATE_ONLY}" | sed -e "s/ /|/g"`
 set IGNORE_TABLES=`hgsql -N -h genome-centdb -e "show tables;" hgcentral \
      | egrep -v -w "${CREATE_OR_LIST}" | xargs echo \
      | sed -e "s/^/--ignore-table=hgcentral./; s/ / --ignore-table=hgcentral./g"`
 hgsqldump --skip-add-drop-table --skip-lock-tables --no-data ${IGNORE_TABLES} \
           -h genome-centdb --no-create-db --databases hgcentral  | grep -v "^USE " \
          | sed -e "s/genome-centdb/localhost/; s/CREATE TABLE/CREATE TABLE IF NOT EXISTS/" \
     > /tmp/hgcentraltemp.sql 
 
 ### Creates and fills (replacing entirely) these tables
-set REPLACE_ENTIRELY="blatServers dbDb dbDbArch gdbPdb liftOverChain" 
+set REPLACE_ENTIRELY="blatServers dbDb dbDbArch defaultCart gdbPdb liftOverChain" 
 set CREATE_OR_LIST=`echo "${REPLACE_ENTIRELY}" | sed -e "s/ /|/g"`
 set IGNORE_TABLES=`hgsql -N -h genome-centdb -e "show tables;" hgcentral \
      | egrep -v -w "${CREATE_OR_LIST}" | xargs echo \
      | sed -e "s/^/--ignore-table=hgcentral./; s/ / --ignore-table=hgcentral./g"`
 # --order-by-primary ... to make it dump rows in a stable repeatable order if it has an index
 # --skip-extended-insert ... to make it dump rows as separate insert statements
 # --skip-add-drop-table ... to avoid dropping existing tables
 # Note that INSERT is turned into REPLACE making our table contents dominant, 
 #      but users additional rows are preserved
 hgsqldump ${IGNORE_TABLES} --skip-lock-tables --skip-extended-insert --order-by-primary -c -h genome-centdb \
         --no-create-db --databases hgcentral  | grep -v "^USE " | sed -e \
         "s/genome-centdb/localhost/" \
     >> /tmp/hgcentraltemp.sql
 
 ### Creates and fills (replacing uniquely keyed rows only) these tables