59 |
|
$mysqlbin -pnieve -h $h -B -N $graphDb <<ENDSQL1 |
60 |
|
SET sql_mode = "NO_UNSIGNED_SUBTRACTION,TRADITIONAL"; |
61 |
|
CREATE TABLE chain_graph LIKE abstract.chain_graph; |
62 |
+ |
CREATE TABLE scop_graph LIKE abstract.scop_graph; |
63 |
|
CREATE TABLE single_model_graph LIKE abstract.single_model_graph; |
64 |
|
CREATE TABLE single_model_node LIKE abstract.single_model_node; |
65 |
|
CREATE TABLE single_model_edge LIKE abstract.single_model_edge; |
75 |
|
MODIFY chain_id INT, |
76 |
|
MODIFY model_id INT; |
77 |
|
|
78 |
+ |
ALTER TABLE scop_graph |
79 |
+ |
MODIFY graph_id INT UNSIGNED NOT NULL AUTO_INCREMENT, |
80 |
+ |
MODIFY pchain_code VARCHAR(2) NOT NULL, |
81 |
+ |
MODIFY sunid INT UNSIGNED, |
82 |
+ |
MODIFY sccs VARCHAR(10), |
83 |
+ |
MODIFY domain_type ENUM('UNKNOWN', 'WHOLECHAIN', 'SINGLEFRAGMENT', 'MULTIFRAGMENT', 'MULTICHAIN'), |
84 |
+ |
MODIFY num_chain INT, |
85 |
+ |
MODIFY num_fragment INT, |
86 |
+ |
MODIFY caths INT, |
87 |
+ |
MODIFY num_chain_res INT, |
88 |
+ |
MODIFY chain_scops INT, |
89 |
+ |
MODIFY entry_id INT, |
90 |
+ |
MODIFY assembly_id INT, |
91 |
+ |
MODIFY chain_id VARCHAR(35), |
92 |
+ |
MODIFY model_id INT; |
93 |
+ |
|
94 |
|
ALTER TABLE single_model_graph |
95 |
|
MODIFY graph_id INT UNSIGNED NOT NULL AUTO_INCREMENT; |
96 |
|
|
97 |
|
ALTER TABLE single_model_node |
98 |
+ |
MODIFY num INT NOT NULL, |
99 |
|
MODIFY ssid VARCHAR(5), |
100 |
|
MODIFY sheet_serial CHAR(1); |
101 |
|
|
102 |
|
ALTER TABLE single_model_edge |
103 |
+ |
MODIFY i_num INT NOT NULL, |
104 |
|
MODIFY i_ssid VARCHAR(5), |
105 |
|
MODIFY i_sheet_serial CHAR(1), |
106 |
+ |
MODIFY j_num INT NOT NULL, |
107 |
|
MODIFY j_ssid VARCHAR(5), |
108 |
|
MODIFY j_sheet_serial CHAR(1); |
109 |
|
ENDSQL1 |