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 |