# | 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 |
– | Removed lines |
+ | Added lines |
< | Changed lines |
> | Changed lines |