ViewVC Help
View File | Revision Log | Show Annotations | View Changeset | Root Listing
root/owl/tags/aglappe-1.1.2/createGraphDb.sh
(Generate patch)
# Line 66 | Line 66
66          
67          ALTER TABLE chain_graph
68                  MODIFY graph_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
69 +                MODIFY pchain_code VARCHAR(2) NOT NULL,
70                  MODIFY scops INT,
71                  MODIFY caths INT,
72                  MODIFY entry_id INT,
# Line 94 | Line 95
95          SET sql_mode = "NO_UNSIGNED_SUBTRACTION,TRADITIONAL";  
96          CREATE INDEX NODE_GRAPH_IDX ON single_model_node (graph_id);
97          CREATE INDEX EDGE_GRAPH_IDX ON single_model_edge (graph_id);    
98 +        CREATE INDEX CHAIN_IDX ON pdb_residue_info (pdb_code, chain_code, pdb_chain_code);
99   ENDSQL
100   fi
101  

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines