text: DROP TABLE IF EXISTS `phpcms_vote_subject`;
  CREATE TABLE `phpcms_vote_subject` (
    `subjectid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    `siteid` smallint(5) unsigned DEFAULT '0',
    `subject` char(255) NOT NULL,
    `ismultiple` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `ischeckbox` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `credit` smallint(5) unsigned NOT NULL DEFAULT '0',
    `addtime` int(10) unsigned NOT NULL DEFAULT '0',
    `fromdate` date NOT NULL DEFAULT '1000-01-01',
    `todate` date NOT NULL DEFAULT '1000-01-01',
    `interval` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
    `template` char(20) NOT NULL,
    `description` text NOT NULL,
    `listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
    `allowguest` tinyint(1) unsigned NOT NULL DEFAULT '1',
    `maxval` tinyint(2) unsigned NOT NULL DEFAULT '0',
    `minval` tinyint(1) unsigned NOT NULL DEFAULT '1',
    `allowview` tinyint(1) unsigned NOT NULL DEFAULT '1',
    `optionnumber` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `votenumber` mediumint(8) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`subjectid`),
    KEY `enabled` (`enabled`),
    KEY `fromdate` (`fromdate`,`todate`),
    KEY `todate` (`todate`)
  ) ENGINE=MyISAM;