diff options
author | Camil Staps | 2015-02-15 10:55:11 +0100 |
---|---|---|
committer | Camil Staps | 2015-02-15 10:55:11 +0100 |
commit | 6b3f5728b029acffbc43d6548031d0c69f8c910c (patch) | |
tree | a3552b8300cf3d25cbb90d29f8d7e3b88e707753 /install/index.php | |
parent | Bugfix for table prefixes (diff) |
Updated foreign key constraint
Diffstat (limited to 'install/index.php')
-rw-r--r-- | install/index.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/install/index.php b/install/index.php index 2f5b9e2..8a3d0b0 100644 --- a/install/index.php +++ b/install/index.php @@ -84,7 +84,7 @@ if (isset($_GET['create_tables'])) { ADD CONSTRAINT `assignment_ibfk_1` FOREIGN KEY (`offerId`) REFERENCES `".constants::db_prefix."offer` (`id`)"); $_pdo->query("ALTER TABLE `".constants::db_prefix."contact` - ADD CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`clientId`) REFERENCES `".constants::db_prefix."client` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION"); + ADD CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`clientId`) REFERENCES `".constants::db_prefix."client` (`id`)"); $_pdo->query("ALTER TABLE `".constants::db_prefix."offer` ADD CONSTRAINT `offer_ibfk_1` FOREIGN KEY (`invoice_fileId`) REFERENCES `".constants::db_prefix."file` (`id`), |