25 lines
962 B
MySQL
25 lines
962 B
MySQL
|
-- DDL incremental para introducir el plazo de pago por defecto de Company.
|
||
|
|
-- Mantiene la referencia como valor vivo y evita forzar FKs cross-module.
|
||
|
|
-- Ejecutar solo en una BD de desarrollo segura o mediante procedimiento controlado.
|
||
|
|
-- No ejecutar automaticamente en produccion.
|
||
|
|
|
||
|
|
ALTER TABLE companies
|
||
|
|
ADD COLUMN default_payment_term_id CHAR(36) NULL AFTER website;
|
||
|
|
|
||
|
|
ALTER TABLE companies
|
||
|
|
ADD KEY idx_companies_default_payment_term (default_payment_term_id);
|
||
|
|
|
||
|
|
-- Validacion minima posterior a la DDL.
|
||
|
|
-- SELECT column_name
|
||
|
|
-- FROM information_schema.columns
|
||
|
|
-- WHERE table_schema = DATABASE()
|
||
|
|
-- AND table_name = 'companies'
|
||
|
|
-- AND column_name = 'default_payment_term_id';
|
||
|
|
--
|
||
|
|
-- SELECT index_name, GROUP_CONCAT(column_name ORDER BY seq_in_index) AS indexed_columns
|
||
|
|
-- FROM information_schema.statistics
|
||
|
|
-- WHERE table_schema = DATABASE()
|
||
|
|
-- AND table_name = 'companies'
|
||
|
|
-- AND index_name = 'idx_companies_default_payment_term'
|
||
|
|
-- GROUP BY index_name;
|