| 6 |
|
echo "Usage: $1 -d <db_name> -m <mode>" |
| 7 |
|
echo |
| 8 |
|
echo "-d <db_name> the graph database name " |
| 9 |
< |
echo "-m <mode> create/index/unindex tables " |
| 9 |
> |
echo "-m <mode> create/index/unindex/drop tables " |
| 10 |
|
echo |
| 11 |
|
} |
| 12 |
|
|
| 127 |
|
DROP INDEX EDGE_GRAPH_IDX ON single_model_edge; |
| 128 |
|
ENDSQL |
| 129 |
|
fi |
| 130 |
+ |
|
| 131 |
+ |
if [ "$mode" == "DROP" ] |
| 132 |
+ |
then |
| 133 |
+ |
$mysqlbin -pnieve -h $h -B -N $graphDb <<ENDSQL |
| 134 |
+ |
SET sql_mode = "NO_UNSIGNED_SUBTRACTION,TRADITIONAL"; |
| 135 |
+ |
DROP TABLE chain_graph; |
| 136 |
+ |
DROP TABLE scop_graph; |
| 137 |
+ |
DROP TABLE single_model_graph; |
| 138 |
+ |
DROP TABLE single_model_node; |
| 139 |
+ |
DROP TABLE single_model_edge; |
| 140 |
+ |
DROP TABLE pdb_residue_info; |
| 141 |
+ |
ENDSQL |
| 142 |
+ |
fi |
