4.3 - Does Initial Install Use Foreign Keys???

The following warnings occurred:

Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)

File	Line	Function
/global.php(961) : eval()'d code	26	errorHandler->error
/global.php	961	eval
/printthread.php	16	require_once

4.3 - Does Initial Install Use Foreign Keys??? - Printable Version

+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: 4.3 - Does Initial Install Use Foreign Keys??? (/showthread.php?tid=891)

4.3 - Does Initial Install Use Foreign Keys??? - mleary2001 - 12-20-2017

I cannot see any foreign keys in the MySQL Dump for the Userspice database. Am I missing something???
<pre>

Code:
--

-- Table structure for table <code>permissions</code>

--

CREATE TABLE <code>permissions</code> (

  <code>id</code> int(11) NOT NULL,

  <code>name</code> varchar(150) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

</pre>

Mike

4.3 - Does Initial Install Use Foreign Keys??? - Brandin - 12-21-2017

UserSpice currently doesn't use foreign keys.

4.3 - Does Initial Install Use Foreign Keys??? - mleary2001 - 12-22-2017

Are there drawbacks that I do not know concerning foreign keys???

4.3 - Does Initial Install Use Foreign Keys??? - dan - 12-22-2017

There is no problem with using them but there are so few things that we do that have foreign key type connections that we didn't put the restrictions in the database. For instance, you could consider the profile ID or some of the permissions to be foreign keys. We just did not force the foreign key connection in the database.