salix/db/versions/10930-wheatDendro/06-payroll_conceptos.sql

6 lines
286 B
MySQL
Raw Permalink Normal View History

2024-03-13 11:50:27 +00:00
-- Place your SQL code here
ALTER TABLE IF EXISTS `vn2008`.`payroll_conceptos` RENAME `vn`.`payrollComponent`;
ALTER TABLE IF EXISTS `vn`.`payrollComponent`
CHANGE COLUMN IF EXISTS `conceptoid` `id` int(11) NOT NULL,
2024-03-13 13:08:14 +00:00
CHANGE COLUMN IF EXISTS `concepto` `name` varchar(255) DEFAULT NULL;