Root Zanli
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
o5t6x7pgljbm
/
public_html
/
admin
/
sqls
/
Filename :
v4_2_enhancements.sql
back
Copy
INSERT INTO tuit_allocation_config (parent_id, action, description, tuit_points, created_at, updated_at) VALUES (NULL, 'MANUAL_ALLOCATION_BY_ADMIN', 'Manual allocation by admin', 0, NOW(), NOW()), (NULL, 'MANUAL_DEDUCTION_BY_ADMIN', 'Manual deduction by admin', 0, NOW(), NOW()); ALTER TABLE tuit_allocation_config ADD COLUMN type ENUM('CREDIT','DEBIT') DEFAULT 'CREDIT' AFTER action; UPDATE tuit_allocation_config SET `type` ='DEBIT' WHERE action='MANUAL_DEDUCTION_BY_ADMIN';