RootZanli & NinjaCr3

: / home / o5t6x7pgljbm / public_html / admin_new2 / sqls /

Filename : v4_2_enhancements.sql

back

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';