CREATE TABLE tunnel (
	ID INT PRIMARY KEY AUTO_INCREMENT,

	pop INT NOT NULL,
	ip4addr CHAR(16) NOT NULL,
	UNIQUE KEY (pop, ip4addr),
	FOREIGN KEY (pop) REFERENCES pop (ID) ON UPDATE CASCADE,

	phys_id INT NOT NULL,
	UNIQUE (pop, phys_id),

	owner INT NOT NULL # user->ID
);

CREATE TABLE route (
	ID INT PRIMARY KEY AUTO_INCREMENT,

	tunnel INT NOT NULL,
	FOREIGN KEY (`tunnel`) REFERENCES `tunnel` (`ID`) ON UPDATE CASCADE,

	zone INT NOT NULL
	FOREIGN KEY (`zone`) REFERENCES `inet6num` (`ID`) ON UPDATE CASCADE
);