CREATE TABLE `subscription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` varchar(0) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `plan` varchar(255) DEFAULT NULL,
  `planid` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `expiry` timestamp NULL DEFAULT NULL,
  `lastpayment` timestamp NULL DEFAULT NULL,
  `data` varchar(255) DEFAULT NULL,
  `uniqueid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;