#31101 Decouple widgets and embed code

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

diff --git a/sql/install.sql b/sql/install.sql
index 86a0cd83e1843871b8d234cad2b3024c7fb93423..0b5836592baeb9a3e330017f5f185b82f2465ee8 100644 (file)
--- a/sql/install.sql
+++ b/sql/install.sql
@@ -53,3 +53,12 @@ CREATE TABLE IF NOT EXISTS civicrm_wci_widget (
   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
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+
+-- WCI embed code.
+CREATE TABLE IF NOT EXISTS civicrm_wci_embed_code (
+  id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Custom Progress bar Id.',
+  name varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Embed code.',
+  widget_id int(10) unsigned DEFAULT NULL COMMENT 'widget id.',
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `unique_wci_name` (`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;