Actions
Improvement #12289
closed
Improvement #11632: Patch management/ Windows updates related improvements
Convert Boolean Columns from BIT to TINYINT in WIN_UPDATE and WIN_DEVICE_UPDATE Tables
Start date:
27/11/2024
Due date:
27/11/2024
% Done:
100%
Estimated time:
Device Type:
Windows
Component:
Type:
Windows
Description
Update the database schema for WIN_UPDATE and WIN_DEVICE_UPDATE tables to replace the BIT data type with TINYINT for storing boolean values. As per the MySQL standard practice, the TINYINT data type is recommended for boolean fields.This ensures compatibility, better handling of boolean values, and alignment with database best practices.
Files
Updated by Subodhinie chathurajika 2 months ago
- Status changed from New to QA
- % Done changed from 0 to 100
Updated by Arshana Atapattu 2 months ago
- File windows-migration-mysql.sql windows-migration-mysql.sql added
- Status changed from QA to QA Accept
included in migration script [1]
Updated by Arshana Atapattu 2 months ago
- Status changed from QA Accept to Closed
Closing due to QA accept
Actions