widget cache code cleanup and bug fixes.

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

diff --git a/sql/install.sql b/sql/install.sql
index d20d6726a8dd8bd54c2a2416950671a828f7d7b3..a80194ed0a623f46f0968c215c5905e035ef46ab 100644 (file)
--- a/sql/install.sql
+++ b/sql/install.sql
@@ -67,9 +67,10 @@ CREATE TABLE IF NOT EXISTS civicrm_wci_embed_code (
 
 -- WCI widget cache.
 CREATE TABLE IF NOT EXISTS civicrm_wci_widget_cache (
-  widget_id int(10) id int(10) unsigned NOT NULL COMMENT 'widget id.',
+  widget_id int(10) unsigned NOT NULL COMMENT 'widget id.',
   widget_code text DEFAULT NULL COMMENT 'Widget code.',
-  expire int(10) DEFAULT 0 COMMENT 'A Unix timestamp indicating when the cache entry should expire.';,
+  expire int(10) DEFAULT 0 COMMENT 'A Unix timestamp indicating when the cache entry should expire.',
+  createdtime int(10) DEFAULT 0 COMMENT 'A Unix timestamp indicating create time.',
   PRIMARY KEY (`widget_id`)
 
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;