46 lines
1.3 KiB
SQL
46 lines
1.3 KiB
SQL
-- ============================================
|
|
-- Migration 004: Add New Status Values
|
|
-- E-Proposal Komite - MySQL Migration
|
|
-- Adds DRAFT and REVISI_KEPSEK status values
|
|
-- Adds HUMAS category value
|
|
-- ============================================
|
|
|
|
USE db_proposalkomite;
|
|
|
|
-- ============================================
|
|
-- Step 1: Alter proposals table - Update status ENUM
|
|
-- ============================================
|
|
ALTER TABLE proposals
|
|
MODIFY COLUMN status ENUM(
|
|
'DRAFT',
|
|
'PENDING_WAKA',
|
|
'REVISI_WAKA',
|
|
'PENDING_KS',
|
|
'REVISI_KEPSEK',
|
|
'REJECTED_KS',
|
|
'PENDING_KOMITE',
|
|
'APPROVED_PARTIAL',
|
|
'APPROVED_FULL',
|
|
'REJECTED_KOMITE',
|
|
'READY_TO_DISBURSE',
|
|
'DISBURSED',
|
|
'PENDING_LPJ',
|
|
'COMPLETED'
|
|
) NOT NULL;
|
|
|
|
-- ============================================
|
|
-- Step 2: Alter proposals table - Update category ENUM
|
|
-- ============================================
|
|
ALTER TABLE proposals
|
|
MODIFY COLUMN category ENUM(
|
|
'AKADEMIK',
|
|
'NON_AKADEMIK',
|
|
'SARPRAS_LAINNYA',
|
|
'HUMAS'
|
|
) NOT NULL;
|
|
|
|
-- ============================================
|
|
-- Success Message
|
|
-- ============================================
|
|
SELECT 'Migration 004 completed - Added DRAFT, REVISI_KEPSEK status and HUMAS category!' AS message;
|