$dbh->do ("CREATE TABLE ScoreCard ( id integer PRIMARY KEY AUTOINCREMENT, Url varchar(80) NOT NULL, DateTime varchar(20) DEFAULT '1995-12-30 00:00:01', Description varchar(80) NOT NULL ); "); $dbh->do ("CREATE TABLE Participants ( id integer PRIMARY KEY AUTOINCREMENT, Url varchar(80) NOT NULL REFERENCES ScoreCard(Url) ON DELETE CASCADE, Name varchar(10) NOT NULL ); ");