DROP TABLE IF EXISTS `subscribe_category`;
CREATE TABLE IF NOT EXISTS `subscribe_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(250) NOT NULL,
  `moduleId` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `title` varchar(150) NOT NULL,
  `label` varchar(250) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Inactive',
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `label` (`label`),
  KEY `name` (`name`),
  KEY `module` (`module`),
  KEY `moduleId` (`moduleId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `subscribe_signed`;
CREATE TABLE IF NOT EXISTS `subscribe_signed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `notice` enum('monthly','weekly','none') NOT NULL DEFAULT 'none',
  PRIMARY KEY (`id`),
  KEY `notice` (`notice`),
  KEY `categoryId` (`categoryId`),
  KEY `userId` (`userId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `subscribe_user`;