4.3 - Does Initial Install Use Foreign Keys???

[mleary2001]

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

[Brandin]

UserSpice currently doesn't use foreign keys.

[mleary2001]

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

[dan]

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.