Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement