WYJP1jTD

1db.update( "CREATE TABLE IF NOT EXISTS graph"
2                            + "("
3                            +   "graphID INT NOT NULL,"
4                            +   "name VARCHAR(50) NOT NULL UNIQUE,"
5                        
6                            +   "PRIMARY KEY(graphID)"
7                            + ");" );
8                
9                db.update( "CREATE TABLE IF NOT EXISTS node"
10                            + "("
11                            +   "nodeID INT NOT NULL UNIQUE AUTO_INCREMENT,"
12                            +   "name VARCHAR(50) NOT NULL,"
13                            +   "weight INT NOT NULL,"
14                            +   "graphID INT NOT NULL,"
15                        
16                            +   "PRIMARY KEY(nodeID),"
17                            +   "FOREIGN KEY (graphID) REFERENCES graph(graphID) ON DELETE CASCADE"
18                            + ");" );
19
20                db.update( "CREATE TABLE IF NOT EXISTS edge"
21                            + "("
22                            +   "graphID INT NOT NULL,"
23                            +   "originID INT NOT NULL,"
24                            +   "endID INT NOT NULL,"
25                        
26                            +   "FOREIGN KEY (graphID) REFERENCES node(nodeID) ON DELETE CASCADE,"
27                            +   "FOREIGN KEY (originID) REFERENCES node(nodeID) ON DELETE CASCADE,"
28                            +   "FOREIGN KEY (endID) REFERENCES graph(graphID) ON DELETE CASCADE"
29                            + ");" );