Foreign key support is missing
Originally reported on Google Code with ID 81
According to the MissingFeatures list, foreign keys should be implemented.
One of the comments suggested that foreign keys are supported because triggers are
implemented.
However, SQLite now has official foreign key support.
http://www.hwaci.com/sw/sqlite/foreignkeys.html
What version of the product are you using? On what operating system?
1.9.1 on Windows 7 32bit with php 5.3.6
Reported by jeroen.walter
on 2012-01-12 21:08:40
Comments (14)
-
Account Deleted -
Account Deleted ``` How is this tricky? Just execute 'PRAGMA foreign_keys = on' in Database::construct after you open the database.....
```
Reported by `jeroen.walter` on 2012-04-28 20:45:51
-
Account Deleted ``` That would work but then it would *always* be on and no longer an option. On the other hand, I think very few would want it to be *off* ```
Reported by `jos.grootlipman` on 2012-04-29 14:34:21
-
Account Deleted ``` Yes I noticed this as well, as I use FOREIGN KEYS in most of my databases it would be great to include this. Just trying to think how this should look. I think a simple drop down with all tables and columns would be pretty effective if placed within the table create action at the end of each table. ```
Reported by `M.Tomlin@wlvacems.com` on 2012-09-06 21:14:05
-
``` Very important issue in my opinion. I am currently working on other issues, but after that I might implement this. ```
Reported by `crazy4chrissi` on 2012-10-06 23:03:35 - Status changed: `Accepted` - Labels added: Type-Enhancement, Priority-High - Labels removed: Type-Defect, Priority-Medium
-
Reported by
crazy4chrissi
on 2013-03-26 19:28:10 - Labels added: Target-1.9.5 -
Account Deleted As mentioned by jos.gross, On each connection to the database you have to issue "PRAGMA foreign_keys = ON;" for that connection to the database follow the foreign key constraints. And as Jeroen said we are going to have to add a line the execs right after the connection to enable it. Kinda sucks, but is a necessary evil. I will submit a patch later on that includes this "fix".
Reported by
M.Tomlin@wlvacems.com
on 2013-05-25 06:37:36 -
Issue 217 has been merged into this issue.
Reported by
crazy4chrissi
on 2013-12-25 16:19:48 -
Reported by
crazy4chrissi
on 2014-01-02 12:40:04 - Labels added: Target-1.9.6 - Labels removed: Target-1.9.5 -
- changed version to 1.9.7
- edited description
-
- changed milestone to 1.9.7
- removed version
-
Account Deleted +1 awaiting for foreign key support. thanx
-
- changed status to resolved
Added the PRAGMA in rev. 603ac86a6b65. I think it's not much use to disable foreign key support, so we now always enable it. Anybody disagreeing please tell us why.
-
Can one use foreign keys in phpLiteAdmin v1.9.8-dev or not?
- Log in to comment
``` Just realized this might be very tricky to implement. In SQLite foreign keys are disabled by default after opening any connection. You need to do 'PRAGMA foreign_keys = on' each time.
Phpliteadmin does not keep a connection open between request. Therefore it would have to rememeber to do 'PRAGMA foreign_keys = on' for each request . ```
Reported by `jos.grootlipman` on 2012-04-28 14:57:22