Index: branches/version-2/html/install/sql/drop_table.sql
===================================================================
--- branches/version-2/html/install/sql/drop_table.sql	(revision 16862)
+++ branches/version-2/html/install/sql/drop_table.sql	(revision 17143)
@@ -92,2 +92,3 @@
 DROP TABLE mtb_ownersstore_err;
 DROP TABLE mtb_ownersstore_ips;
+DROP TABLE dtb_holiday;
Index: branches/version-2/html/install/sql/insert_data.sql
===================================================================
--- branches/version-2/html/install/sql/insert_data.sql	(revision 17123)
+++ branches/version-2/html/install/sql/insert_data.sql	(revision 17143)
@@ -13,4 +13,6 @@
 insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('ログイン',	'bloc/login.tpl', 'login','frontparts/bloc/login.php', 1, now(), now());
 insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('オススメ商品', 'bloc/best5.tpl', 'best5','frontparts/bloc/best5.php', 1, now(), now());
+INSERT INTO dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) VALUES ('カレンダー', 'bloc/calendar.tpl', 'calendar', 'frontparts/bloc/calendar.php', 1, now(), now());
+
 
 insert into dtb_pagelayout (page_name,url,php_dir,tpl_dir,filename,edit_flg, create_date, update_date)values('TOPページ','index.php',' ','user_data/templates/','top',2,now(),now());
@@ -453,4 +455,37 @@
 VALUES ('第12条（準拠法、管轄裁判所）','本規約に関して紛争が生じた場合、当社本店所在地を管轄する地方裁判所を第一審の専属的合意管轄裁判所とします。 ',
 1,0,Now(),0, now());
+
+
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('元旦(1月1日)','1', '1' ,100, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('成人の日(1月第2月曜日)','1', '14' ,98, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('建国記念の日(2月11日)','2', '11' ,96, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('春分の日(3月21日)','3', '21' ,94, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('昭和の日(4月29日)','4', '29' ,92, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('憲法記念日(5月3日)','5', '3' ,90, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('みどりの日(5月4日)','5', '4' ,88, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('こどもの日(5月5日)','5', '5' ,86, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('海の日(7月第3月曜日)','7', '21' ,84, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('敬老の日(9月第3月曜日)','9', '15' ,82, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('秋分の日(9月23日)','9', '23' ,80, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('体育の日(10月第2月曜日)','10', '13' ,78, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('文化の日(11月3日)','11', '3' ,76, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('勤労感謝の日(11月23日)','11', '23' ,74, 0, now(), 0, now());
+INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
+VALUES ('天皇誕生日(12月23日)','12', '23' ,72, 0, now(), 0, now());
+
 
 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES ('1', '北海道', '1');
Index: branches/version-2/html/install/sql/create_table_mysql.sql
===================================================================
--- branches/version-2/html/install/sql/create_table_mysql.sql	(revision 16926)
+++ branches/version-2/html/install/sql/create_table_mysql.sql	(revision 17143)
@@ -21,4 +21,16 @@
     creator_id int NOT NULL,
     create_date datetime NOT NULL ,
+    update_date datetime NOT NULL,
+    del_flg  smallint NOT NULL DEFAULT 0
+) TYPE=InnoDB ;
+
+CREATE TABLE dtb_holiday (
+    holiday_id int auto_increment primary key NOT NULL,
+    title text NOT NULL,
+    month smallint NOT NULL,
+    day smallint NOT NULL,
+    rank int NOT NULL DEFAULT 0,
+    creator_id int NOT NULL,
+    create_date datetime NOT NULL,
     update_date datetime NOT NULL,
     del_flg  smallint NOT NULL DEFAULT 0
Index: branches/version-2/html/install/sql/create_table_pgsql.sql
===================================================================
--- branches/version-2/html/install/sql/create_table_pgsql.sql	(revision 16867)
+++ branches/version-2/html/install/sql/create_table_pgsql.sql	(revision 17143)
@@ -18,4 +18,16 @@
     kiyaku_title text NOT NULL,
     kiyaku_text text NOT NULL,
+    rank int4 NOT NULL DEFAULT 0,
+    creator_id int4 NOT NULL,
+    create_date timestamp NOT NULL DEFAULT now(),
+    update_date timestamp NOT NULL,
+    del_flg  int2 NOT NULL DEFAULT 0
+);
+
+CREATE TABLE dtb_holiday (
+    holiday_id serial NOT NULL,
+    title text NOT NULL,
+    month int2 NOT NULL,
+    day int2 NOT NULL,
     rank int4 NOT NULL DEFAULT 0,
     creator_id int4 NOT NULL,