From f160001989402d6d4f000c8faccb5f3b73b3af85 Mon Sep 17 00:00:00 2001 From: Will Budic Date: Sun, 23 Feb 2020 17:35:15 +1100 Subject: [PATCH] new createLOGCATSREFStmt --- htdocs/cgi-bin/system/modules/Settings.pm | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/htdocs/cgi-bin/system/modules/Settings.pm b/htdocs/cgi-bin/system/modules/Settings.pm index 3ef07bd..39f6b85 100644 --- a/htdocs/cgi-bin/system/modules/Settings.pm +++ b/htdocs/cgi-bin/system/modules/Settings.pm @@ -119,7 +119,15 @@ return qq( CREATE INDEX idx_auth_name_passw ON AUTH (ALIAS, PASSW); )} sub createNOTEStmt {return qq(CREATE TABLE NOTES (LID INTEGER PRIMARY KEY NOT NULL, DOC TEXT);)} -sub createLOGCATSREFStmt {return qq(CREATE TABLE LOGCATSREF (LID INTEGER NOT NULL, CID TINY NOT NULL);)} +sub createLOGCATSREFStmt { +return qq( + CREATE TABLE LOGCATSREF ( + LID INTEGER NOT NULL, + CID TINY NOT NULL, + FOREIGN KEY (LID) REFERENCES LOG(ID), + FOREIGN KEY(CID) REFERENCES CAT(ID) + ); +)} sub getConfiguration { my $db = shift; -- 2.34.1