fixed beta 1 bugs, 31062, 31063, 31101, 31067, 31065

[com.zyxware.civiwci.git] / sql / install.sql

diff --git a/sql/install.sql b/sql/install.sql
index 0b5836592baeb9a3e330017f5f185b82f2465ee8..3e149ec01982fc0e4f7a42f33c39039301ed2603 100644 (file)
--- a/sql/install.sql
+++ b/sql/install.sql
@@ -51,7 +51,7 @@ CREATE TABLE IF NOT EXISTS civicrm_wci_widget (
   
   PRIMARY KEY (`id`),
   UNIQUE KEY `unique_wci_title` (`title`),
-  CONSTRAINT FK_civicrm_wci_widget_progress_bar_id FOREIGN KEY (`progress_bar_id`) REFERENCES `civicrm_wci_progress_bar`(`id`) ON DELETE SET NULL
+  CONSTRAINT FK_civicrm_wci_widget_progress_bar_id FOREIGN KEY (`progress_bar_id`) REFERENCES `civicrm_wci_progress_bar`(`id`) ON DELETE RESTRICT
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
 -- WCI embed code.