20 lines
828 B
MySQL
20 lines
828 B
MySQL
|
-- Place your SQL code here
|
||
|
|
DROP TABLE IF EXISTS vn.comparativeConfig;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS vn.comparativeConfig (
|
||
|
|
id int unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
defaultDayRange int unsigned NULL COMMENT 'Rango de días predeterminado si no se especifica',
|
||
|
|
weekRange int unsigned NULL COMMENT 'La cantidad de semanas que se restarán y sumarán',
|
||
|
|
maxDayRange int unsigned NULL COMMENT 'El rango máximo de días antes de utilizar el rango de días predeterminado',
|
||
|
|
minDayRange int unsigned NULL COMMENT 'El rango mínimo de días antes de utilizar el rango de días predeterminado',
|
||
|
|
PRIMARY KEY (id)
|
||
|
|
)
|
||
|
|
ENGINE=InnoDB
|
||
|
|
DEFAULT CHARSET=utf8mb3
|
||
|
|
COLLATE=utf8mb3_unicode_ci;
|
||
|
|
|
||
|
|
INSERT IGNORE INTO vn.comparativeConfig
|
||
|
|
SET defaultDayRange = 21,
|
||
|
|
weekRange = 3,
|
||
|
|
maxDayRange = 60,
|
||
|
|
minDayRange = 0;
|