seoxiongdi

it’s looks working when i create 3 table

CREATE TABLE ms_3_pollsa (
  polla_aid int(10) NOT NULL AUTO_INCREMENT,
  polla_qid int(10) NOT NULL DEFAULT '0',
  polla_answers varchar(200) CHARACTER SET utf8 NOT NULL DEFAULT '',
  polla_votes int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (polla_aid)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE ms_3_pollsip (
  pollip_id int(10) NOT NULL AUTO_INCREMENT,
  pollip_qid varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  pollip_aid varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  pollip_ip varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  pollip_host varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  pollip_timestamp varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0000-00-00 00:00:00',
  pollip_user tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  pollip_userid int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (pollip_id),
  KEY pollip_ip (pollip_ip),
  KEY pollip_qid (pollip_qid),
  KEY pollip_ip_qid_aid (pollip_ip,pollip_qid,pollip_aid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE ms_3_pollsq (
  pollq_id int(10) NOT NULL AUTO_INCREMENT,
  pollq_question varchar(200) CHARACTER SET utf8 NOT NULL DEFAULT '',
  pollq_timestamp varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  pollq_totalvotes int(10) NOT NULL DEFAULT '0',
  pollq_active tinyint(1) NOT NULL DEFAULT '1',
  pollq_expiry varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  pollq_multiple tinyint(3) NOT NULL DEFAULT '0',
  pollq_totalvoters int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (pollq_id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;