X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=sql%2Finstall.sql;fp=sql%2Finstall.sql;h=86a0cd83e1843871b8d234cad2b3024c7fb93423;hb=c1a7ee1fb9858d215b31f5ec25b5f2b3f7cd8fed;hp=e921af89b1a69a96bac5390f1d526fe0274bcb43;hpb=059e13b7c530e5303c0b43381d708254e6d68ba2;p=com.zyxware.civiwci.git

diff --git a/sql/install.sql b/sql/install.sql
index e921af8..86a0cd8 100644
--- a/sql/install.sql
+++ b/sql/install.sql
@@ -44,6 +44,11 @@ CREATE TABLE IF NOT EXISTS civicrm_wci_widget (
   hide_title tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Hide title, if 1.',
   hide_border tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Hide widget border, if 1.',
   hide_pbcap tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Hide pb caption, if 1.',
+  color_btn_newsletter varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Newsletter Button text color',
+  color_btn_newsletter_bg varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Newsletter Button color',
+  newsletter_text varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Newsletter text',
+  color_newsletter_text varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Newsletter text color',
+  
   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