[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_chatlog.chatlog_channel (
   2    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   3    serviceName VARCHAR(64) COLLATE utf8_bin NOT NULL,
   4    serviceType VARCHAR(32) COLLATE utf8_bin NOT NULL,
   5    channelName VARCHAR(64) COLLATE utf8_bin NOT NULL,
   6    viewPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,
   7    editPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,
   8    dateCreated INT UNSIGNED NOT NULL,
   9    dateModified INT UNSIGNED NOT NULL,
  10    UNIQUE KEY `key_channel` (channelName, serviceType, serviceName)
  11  )ENGINE=InnoDB DEFAULT CHARSET=utf8;