----- DROP TABLE','-----
drop table shukujitsu_table;

----- CREATE TABLE','-----
create table shukujitsu_table(
	date		date,
	setsumei	text,
	CONSTRAINT shukujitsu_pkey PRIMARY KEY(date)
);

----- INSERT TABLE','-----
insert into shukujitsu_table values('2002-01-01','元日');
insert into shukujitsu_table values('2002-01-14','成人の日');
insert into shukujitsu_table values('2002-02-11','建国記念の日');
insert into shukujitsu_table values('2002-03-21','春分の日');
insert into shukujitsu_table values('2002-04-29','みどりの日');
insert into shukujitsu_table values('2002-05-03','憲法記念日');
insert into shukujitsu_table values('2002-05-04','国民の休日');
insert into shukujitsu_table values('2002-05-05','こどもの日');
insert into shukujitsu_table values('2002-05-06','振替休日');
insert into shukujitsu_table values('2002-07-20','海の日');
insert into shukujitsu_table values('2002-09-15','敬老の日');
insert into shukujitsu_table values('2002-09-16','振替休日');
insert into shukujitsu_table values('2002-09-23','秋分の日');
insert into shukujitsu_table values('2002-10-14','体育の日');
insert into shukujitsu_table values('2002-11-03','文化の日');
insert into shukujitsu_table values('2002-11-04','振替休日');
insert into shukujitsu_table values('2002-11-23','勤労感謝の日');
insert into shukujitsu_table values('2002-12-23','天皇誕生日');
insert into shukujitsu_table values('2003-01-01','元日');
insert into shukujitsu_table values('2003-01-13','成人の日');
insert into shukujitsu_table values('2003-02-11','建国記念の日');
insert into shukujitsu_table values('2003-03-21','春分の日');
insert into shukujitsu_table values('2003-04-29','みどりの日');
insert into shukujitsu_table values('2003-05-03','憲法記念日');
insert into shukujitsu_table values('2003-05-04','国民の休日');
insert into shukujitsu_table values('2003-05-05','こどもの日');
insert into shukujitsu_table values('2003-07-21','海の日');
insert into shukujitsu_table values('2003-09-15','敬老の日');
insert into shukujitsu_table values('2003-09-23','秋分の日');
insert into shukujitsu_table values('2003-10-13','体育の日');
insert into shukujitsu_table values('2003-11-03','文化の日');
insert into shukujitsu_table values('2003-11-23','勤労感謝の日');
insert into shukujitsu_table values('2003-11-24','振替休日');
insert into shukujitsu_table values('2003-12-23','天皇誕生日');

----- GRANT TABLE','-----
grant all on shukujitsu_table to public;