xstfvhPY

1DROP TABLE IF EXISTS LandTerritory;
2CREATE TABLE LandTerritory (
3  name   varchar(50) PRIMARY KEY NOT NULL UNIQUE, 
4  hasSC  boolean NOT NULL DEFAULT 0
5);
6	
7DROP TABLE IF EXISTS LandAdjacent;
8CREATE TABLE LandAdjacent (
9  tname1 varchar(50) NOT NULL,
10  tname2 varchar(50) NOT NULL,
11  PRIMARY KEY (tname1, tname2),
12  /* Foreign keys */
13  FOREIGN KEY (tname1)
14    REFERENCES LandTerrito
15    ON DELETE CASCADE
16    ON UPDATE CASCADE, 
17  FOREIGN KEY (tname2)
18    REFERENCES LandTerritory(name)
19    ON DELETE CASCADE
20    ON UPDATE CASCADE
21);