CREATE TABLE `TESTPARENT`(`COL1` int primary key, `COL2` int, `COL3` dateTime, `COL4` varchar(100) )

CREATE TABLE `TESTCHILD`(`COL1` int primary key, `COL2` int, `COL3` dateTime, `COL4` varchar(100) )

CREATE TABLE `TESTGRANDCHILD`(`COL1` int primary key, `COL2` int, `COL3` dateTime, `COL4` varchar(100) )

ALTER TABLE `TESTGRANDCHILD` ADD CONSTRAINT `FK_TESTGRANDCHILD_TESTCHILD` FOREIGN KEY(`COL2`) REFERENCES `TESTCHILD`(`COL1`)

ALTER TABLE `TESTCHILD` ADD CONSTRAINT `FK_TESTCHILD_TESTPARENT` FOREIGN KEY(`COL2`) REFERENCES `TESTPARENT`(`COL1`)