Project

General

Profile

Actions
Copy link

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

Added by Subodhinie chathurajika 3 months ago. Updated about 1 month ago.

Status:
Closed
Priority:
None
Assignee:
Subodhinie chathurajika
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

windows-migration-mysql.sql (1.58 KB) windows-migration-mysql.sql [1] Arshana Atapattu, 05/12/2024 10:49 AM
Actions
Copy link

Also available in: Atom PDF