19 lines
644 B
SQL
19 lines
644 B
SQL
-- ============================================
|
|
-- Migration 007: Fix Category Column Type
|
|
-- E-Proposal Komite - MySQL Migration
|
|
-- ============================================
|
|
-- Problem: category column was defined as ENUM which causes
|
|
-- "Data truncated for column 'category'" error
|
|
-- Solution: Change to VARCHAR to be more flexible
|
|
|
|
USE db_proposalkomite;
|
|
|
|
-- Convert category from ENUM to VARCHAR(100)
|
|
ALTER TABLE proposals
|
|
MODIFY COLUMN category VARCHAR(100) NOT NULL DEFAULT 'AKADEMIK';
|
|
|
|
-- Verify the change
|
|
DESCRIBE proposals;
|
|
|
|
SELECT 'Migration 007 completed: category column updated to VARCHAR(100)' AS message;
|