# SQL Changes

CREATE TABLE `pokecommdev_forums`.`badge` ( `badgeid` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) NOT NULL , `description` VARCHAR(255) NOT NULL , `icon` TEXT NOT NULL , PRIMARY KEY (`badgeid`)) ENGINE = MyISAM;

ALTER TABLE `badge` ADD `users` INT NOT NULL DEFAULT '0' AFTER `icon`;

CREATE TABLE `pokecommdev_forums`.`badge_ownership` ( `badgeid` INT NOT NULL , `given_to_userid` INT NOT NULL , `given_by_userid` INT NOT NULL , `given_at` DATE NOT NULL DEFAULT CURRENT_TIMESTAMP , `reason` VARCHAR(255) NOT NULL ) ENGINE = MyISAM;

ALTER TABLE `badge_ownership` CHANGE `given_at` `given_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE `badge_ownership` ADD `favorite` BOOLEAN NOT NULL DEFAULT FALSE AFTER `reason`;

ALTER TABLE `pokecommdev_forums`.`badge_ownership` ADD UNIQUE (`badgeid`, `given_to_userid`);

ALTER TABLE `badge_ownership` ADD `color` VARCHAR(255) NOT NULL AFTER `favorite`, ADD `shine` TINYINT NOT NULL DEFAULT '0' AFTER `color`;

ALTER TABLE `badge` CHANGE `icon` `icon` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

ALTER TABLE `pokecommdev_forums`.`badge` ADD UNIQUE `badge_icon_is_unique` (`icon`);

ALTER TABLE `user` ADD `decal_style` ENUM('solid','light','colorless') NOT NULL DEFAULT 'solid' AFTER `emailLastConfirmedDate`;

# Changed Templates
staff_dashboard_shell - added badge tab
MEMBERINFO - added badge tab
memberinfo_block_badges - created
memberinfo_block_myawards - added deprecation notice
postbit - duh
settings_postflair - weight customization
navbar - added badges mod link

# Changed Files
.htaccess - added badge-related routes to staff dashboard
staff-dashboard-badges.php - created
includes/functions_badges.php - created
includes/staff-dashboard/global.php - added $show variable for badges tab
styles/badges.scss - added badge styling
styles/base.scss - added @import to badges.scss
styles/base-rewrite.scss - added @import to badges.scss
member.php - unbroke it
includes/class_profileblock.php - added badges block
scripts/badges.js - created
scripts/staff-dashboard-badges.js - created
includes/class_postbit.php - badge displaying
settings.php - weight customization