All pastes #623383 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-07-17 15:28 UTC
rendered paste body
CREATE TABLE `channels` (
  `id` tinyint(3) unsigned NOT NULL auto_increment COMMENT 'PKEY for channels',
  `channel` char(32) NOT NULL COMMENT 'Name of the channel',
  `network` CHAR(16) NOT NULL COMMENT 'Name of the network',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_channel` (`channel`, `network`)        // Drop the old one, add this one
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Stores the channel names';