bbs_favorite.sql 463 B

123456789101112
  1. CREATE TABLE `bbs_favorites` (
  2. `favId` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  3. `playerId` INT UNSIGNED NOT NULL,
  4. `favTitle` VARCHAR(50) NOT NULL,
  5. `favBypass` VARCHAR(127) NOT NULL,
  6. `favAddDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  7. PRIMARY KEY (`favId`),
  8. UNIQUE INDEX `favId_playerId` (`favId`, `playerId`)
  9. )
  10. COMMENT='This table saves the Favorite links from each player for the community board.'
  11. COLLATE='utf8_unicode_ci'
  12. ENGINE=InnoDB;