--建表sql和新增sql均在oracle数据库中生成
--建表sql
create table T_HOLIDAY_WEEK_INFO
(
id VARCHAR2(50) default sys_guid() not null,
day_date DATE,
day_type VARCHAR2(10)
)
;
comment on table T_HOLIDAY_WEEK_INFO
is '2025年节假日周末表';
-- Add comments to the columns
comment on column T_HOLIDAY_WEEK_INFO.id
is '主键';
comment on column T_HOLIDAY_WEEK_INFO.day_date
is '日期';
comment on column T_HOLIDAY_WEEK_INFO.day_type
is '日期类型，0：工作日 1：周末 2：节假日';
--新增sql
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B18F5435E0636D17BCAC0E61', to_date('01-01-2025', 'dd-mm-yyyy'), '2');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B18E5435E0636D17BCAC0E61', to_date('02-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B18D5435E0636D17BCAC0E61', to_date('03-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B18C5435E0636D17BCAC0E61', to_date('04-01-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B18B5435E0636D17BCAC0E61', to_date('05-01-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B18A5435E0636D17BCAC0E61', to_date('06-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1895435E0636D17BCAC0E61', to_date('07-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1885435E0636D17BCAC0E61', to_date('08-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1875435E0636D17BCAC0E61', to_date('09-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1865435E0636D17BCAC0E61', to_date('10-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1855435E0636D17BCAC0E61', to_date('11-01-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1845435E0636D17BCAC0E61', to_date('12-01-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1835435E0636D17BCAC0E61', to_date('13-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1825435E0636D17BCAC0E61', to_date('14-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1815435E0636D17BCAC0E61', to_date('15-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1805435E0636D17BCAC0E61', to_date('16-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B17F5435E0636D17BCAC0E61', to_date('17-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B17E5435E0636D17BCAC0E61', to_date('18-01-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B17D5435E0636D17BCAC0E61', to_date('19-01-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B17C5435E0636D17BCAC0E61', to_date('20-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B17B5435E0636D17BCAC0E61', to_date('21-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B17A5435E0636D17BCAC0E61', to_date('22-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1795435E0636D17BCAC0E61', to_date('23-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1785435E0636D17BCAC0E61', to_date('24-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1775435E0636D17BCAC0E61', to_date('25-01-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1765435E0636D17BCAC0E61', to_date('26-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1755435E0636D17BCAC0E61', to_date('27-01-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1745435E0636D17BCAC0E61', to_date('28-01-2025', 'dd-mm-yyyy'), '2');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1735435E0636D17BCAC0E61', to_date('29-01-2025', 'dd-mm-yyyy'), '2');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1725435E0636D17BCAC0E61', to_date('30-01-2025', 'dd-mm-yyyy'), '2');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1715435E0636D17BCAC0E61', to_date('31-01-2025', 'dd-mm-yyyy'), '2');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1705435E0636D17BCAC0E61', to_date('01-02-2025', 'dd-mm-yyyy'), '2');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B16F5435E0636D17BCAC0E61', to_date('02-02-2025', 'dd-mm-yyyy'), '2');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B16E5435E0636D17BCAC0E61', to_date('03-02-2025', 'dd-mm-yyyy'), '2');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B16D5435E0636D17BCAC0E61', to_date('04-02-2025', 'dd-mm-yyyy'), '2');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B16C5435E0636D17BCAC0E61', to_date('05-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B16B5435E0636D17BCAC0E61', to_date('06-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B16A5435E0636D17BCAC0E61', to_date('07-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1695435E0636D17BCAC0E61', to_date('08-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1685435E0636D17BCAC0E61', to_date('09-02-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1675435E0636D17BCAC0E61', to_date('10-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1665435E0636D17BCAC0E61', to_date('11-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1655435E0636D17BCAC0E61', to_date('12-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1645435E0636D17BCAC0E61', to_date('13-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1635435E0636D17BCAC0E61', to_date('14-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1625435E0636D17BCAC0E61', to_date('15-02-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1615435E0636D17BCAC0E61', to_date('16-02-2025', 'dd-mm-yyyy'), '1');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B1605435E0636D17BCAC0E61', to_date('17-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B15F5435E0636D17BCAC0E61', to_date('18-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID, DAY_DATE, DAY_TYPE)
values ('26B78A22B15E5435E0636D17BCAC0E61', to_date('19-02-2025', 'dd-mm-yyyy'), '0');
insert into T_HOLIDAY_WEEK_info (ID
