CREATE TABLE IF NOT EXISTS `donators` (
	`donID` INT(11) NOT NULL COMMENT 'auto incrementing donID of each donator, unique index',
	`playerid` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
	`donLevel` SMALLINT NOT NULL,
	`expired` SMALLINT NOT NULL,
	`purchased` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`expires` TIMESTAMP NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='donation data';
ALTER TABLE `donators` ADD PRIMARY KEY (`donID`);
ALTER TABLE `donators` MODIFY `donID` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'auto incrementing user_id of each user, unique index',AUTO_INCREMENT=5;