ViewVC Help

View File | Revision Log | Show Annotations | View Changeset | Root Listing

root/owl/trunk/createGraphDb.sh

#	Line 59 | Line 59
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;
#	Line 74 | Line 75
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

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines