14 lines
398 B
MySQL
14 lines
398 B
MySQL
|
-- Place your SQL code here
|
||
|
|
USE vn;
|
||
|
|
DROP TABLE IF EXISTS vn.accountingConfig;
|
||
|
|
CREATE TABLE vn.accountingConfig (
|
||
|
|
id INT primary key,
|
||
|
|
minDate DATE NOT NULL,
|
||
|
|
maxDate DATE NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
ALTER TABLE `vn`.`accountingConfig`
|
||
|
|
CHANGE COLUMN `id` `id` INT(11) NOT NULL AUTO_INCREMENT ;
|
||
|
|
|
||
|
|
INSERT INTO `vn`.`accountingConfig` (`minDate`, `maxDate`) VALUES ('2021-12-01', '2023-01-01');
|