   `canvas_id` BIGINT COMMENT 'Primary key for this communication channel in the communication_channel table.',
   `user_id` BIGINT COMMENT 'Foreign key to the user that owns this communication channel.',
   `address` VARCHAR(256) COMMENT 'Address, or path, of the communication channel. Set to \'NULL\' for push notifications.',
-  `type` VARCHAR(256) COMMENT 'Denotes the type of the path. Possible values are \'email\', \'facebook\', \'push\' (device push notifcations), \'sms\' and \'twitter\'. Defaults to \'email\'.',
+  `type` VARCHAR(256) COMMENT 'Denotes the type of the path. Possible values are \'email\', \'facebook\', \'push\' (device push notifications), \'sms\' and \'twitter\'. Defaults to \'email\'.',
   `position` INTEGER UNSIGNED COMMENT 'Position of this communication channel relative to the user\'s other channels when they are ordered.',
   `workflow_state` VARCHAR(256) COMMENT 'Current state of the communication channel. Possible values are \'unconfirmed\' and \'active\'.',
   `created_at` TIMESTAMP NULL COMMENT 'Date/Time when the quiz was created.',

# MySQL script to create database for Canvas Data schema version 1.9.0
DROP DATABASE IF EXISTS canvas_data;
CREATE DATABASE IF NOT EXISTS canvas_data;
USE canvas_data;

) ENGINE = MyISAM DEFAULT CHARSET=utf8 COMMENT = "Attributes for communication channel.";
DROP TABLE IF EXISTS communication_channel_fact;
CREATE TABLE IF NOT EXISTS communication_channel_fact (
  `communication_channel_id` BIGINT COMMENT 'Foreign key to the communication channel dimension table.',
  `user_id` BIGINT COMMENT 'Foreign key to the user that owns this communication channel.',
  `bounce_count` INTEGER UNSIGNED COMMENT 'Number of permanent bounces since the channel was last reset. If it\'s greater than 0, then no email is sent to the channel, until it is either reset by a siteadmin or it is removed and re-added by a user.'
) ENGINE = MyISAM DEFAULT CHARSET=utf8 COMMENT = "Measures for communication channel.";
