BCOE&M 3.0.0.0 Set Up: Install DB Tables and Data

Installation Items

Previous version: 2.1.10.0

• PDF file names in the user_docs directory converted to lowercase (including extension).
• Added BA Styles to styles table.
• Toggle to preferences added to allow users to specify whether to use BOS in "Best of" calculations.
• Toggle to preferences value added to allow users to specify whether to use BOS in "Best of" calculations.
• Mead/Cider style type added.
• Language column updated in the preferences table.
• Language column value updated in the preferences table.
• Burton Ale style added.
• New England IPA style added.
• Dorada Pampeana style added.
• IPA Argenta style added.
• Italian Grape Ale style added.
• Catharina Sour style added.
• New Zealand Pilsner style added.
• Style type Lager updated.
• Style type Ale updated.
• Style type Mixed updated.
• Style type Cider updated.
• Style type Mead updated.
• Previous pro-am column added in the brewer table.
• Custom styles updated to currently chosen style set.
• British Strong Ale name corrected in styles table.
• Added AABC Styles to styles table.
• Specialty Fruit Beer name corrected in styles table.
• All Specialty Fruit Beer names corrected in brewing table.
• prefsTimeZone DB column altered to FLOAT to accommodate fractional time zone numbers.
• Legacy core style types reconstructed.
• Wine style type added.
• Rice Wine style type added.
• Spirits style type added.
• Kombucha style type added.
• Pulque style type added.
• Beer Style Type reassigned.
• Cider Style Type reassigned.
• Mead Style Type reassigned.
• Mead/Cider Style Type reassigned.
• All alpha-numeric judging numbers converted to lower case.
• The judgingDateEnd column was added to the judging_locations table.
• The judgingDateEnd value was set.
• The judgingLocType column was added to the judging_locations table.
• The judgingLocType value was set for all judging locations.
• The assignPlanning column was added to the judging_assignments table.
• The flightPlanning column was added to the judging_flights table.
• The jPrefsTablePlanning column was added to the judging_preferences table.
• The prefsEmailCC column was added to the preferences table.
• The prefsEmailCC value was set to 0 (disabled).
• The archiveWinnerMethod column was added to the archive table.
• The archiveWinnerMethod value was set to 0.
• The archiveDisplayWinners column was added to the archive table.
• The archiveDisplayWinners value was set to No.
• The prefsEval column was added to the preferences table.
• The prefsEval column value was set.
• Added more information requirement for Italian Grape Ale (PRX3).
• Added BJCP 2021 Styles to styles table.
• The brewStyleGroup column was moved after id in the styles table.
• The brewStyleVersion column was moved after brewStyleCategory in the styles table.
• Added evaluation DB table - for use with Electronic Scoresheets.
• Corrected British Golden Ale name in styles table.
• Corrected British Golden Ale name in brewing table.
• 2021 BA style Kentucky Common added.
• 2021 BA style New Zealand-Style Pale Ale added.
• 2021 BA style New Zealand-Style India Pale Ale added.
• 2021 BA style Belgian-Style Session Ale added.
• 2022 BA Experimental India Pale Ale style updated.
• 2022 BA Session Beer style updated.
• 2022 BA Session India Pale Ale style updated.
• 2022 BA Traditional Belgian-Style Gueuze style updated.
• 2022 BA Bohemian-Style Pilsener style updated.
• 2022 BA American-Style India Pale Lager style updated.
• 2022 BA Specialty Beer style updated.
• 2022 BA Chili Pepper Beer style updated.
• Added 2022 AABC Styles to styles table.
• Recipe-related data collection is now deprecated. Removed entry recipe fields from UI.
• Corrected Czech Premium Pale Lager name in styles table.
• Corrected Czech Premium Pale Lager name in brewing table.
• The scoreType column was converted to INT(3) in the judging_scores table.
• The scoreType column was converted to INT(3) in the judging_scores_bos table.
• The jPrefsMinWords column was added to the judging preferences table.
• Added NW Cider Cup styles to Styles table.
• BA European Origin Lagers styles updated.
• European-Style Dark Lager style updated.
• 2022 BA American-Style India Pale Lager style updated.
• 2023 BA style West Coast-Style India Pale Ale added.
• 2023 BA style Dessert Stout or Pastry Stout added.
• All deprecated recipe-related columns were removed from the brewing table.
• Updated the Style Type of BJCP 2021 30D - Specialty Spice Beer.
• Updated the Style Type of BA style - Juicy or Hazy Imperial or Double India Pale Ale.
• Changed brewerAssignment row type to MEDIUMTEXT - used store judge/steward industry affiliations while using the Professional Edition.
• The contestClubs column was added to the competition information table.
• The userAdminObfuscate column was added to the users table.
• The prefsScoringCOA column was added to the preferences table.
• The brewerMHP column was added to the brewer table.
• The unused prefsSponsorLogoSize column in the preferences table was renamed to prefsSelectedStyles and set to MEDIUMTEXT.
• Selected styles data was added to the prefsSelectedStyles row.
• ABV column added to the brewing table.
• Sweetness Level column added to the brewing table.
• Juice Source column added to the brewing table.
• Packaging column added to the brewing table.
• Pouring instructions column added to the brewing table.
• Style type column added to the brewing table.
• Entry edit deadline column added to the competition info table.
• Winner link column added to the competition info table.
• Entry limit column added to the style types table.
• Organization info column added to the brewer table.
• NW Cider Cup C1 and C2 styles updated to remove additional info input requirement.
• The brewerAHA column was converted to VARCHAR in the brewer table to allow for alpha-numeric input.
• BJCP 2021 Style C2A updated.
• BJCP 2021 Style C2B updated.
• BJCP 2021 Style C2D updated.
• BJCP 2021 Style C2E updated.
• BJCP 2021 Style C2F updated.
• User incremental entry limit dates column added to preferences table.
• Claussenii and Naardenensis themes are deprecated and were removed due to accessibility issues.
• Enable/Disable MHP Display column added to preferences table.
• SMTP Email Enable column added to preferences table.
• SMTP Email Host column added to preferences table.
• SMTP "From" email column added to preferences table.
• SMTP Email Username column added to preferences table.
• SMTP Email Password column added to preferences table.
• SMTP Email Encrypt column added to preferences table.
• SMTP Email Port column added to preferences table.
• Entry limits by style column added to preferences table.
• Table entry limit column added to judging preferences table.
• At entry limit column added to the styles table.
• Notes column added to the judging locations table.
• Added BJCP 2025 Cider Styles to styles table.
• Added AABC 2025 Cider Styles to styles table.
• Updated BJCP 2021 style 9A's entry instructions.
• 2025 changes to NW Cider Cup styles updated successfully.