ViewVC Help
View File | Revision Log | Show Annotations | View Changeset | Root Listing
root/owl/trunk/createGraphDb.sh
(Generate patch)
# Line 6 | Line 6
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  
# Line 127 | Line 127
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

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines