Changeset 17143 for branches/version-2/html/install/sql/insert_data.sql
- Timestamp:
- 2008/03/12 22:01:51 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2/html/install/sql/insert_data.sql
r17123 r17143 13 13 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()); 14 14 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()); 15 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()); 16 15 17 16 18 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 455 VALUES ('第12条(準拠法、管轄裁判所)','本規約に関して紛争が生じた場合、当社本店所在地を管轄する地方裁判所を第一審の専属的合意管轄裁判所とします。 ', 454 456 1,0,Now(),0, now()); 457 458 459 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 460 VALUES ('元旦(1月1日)','1', '1' ,100, 0, now(), 0, now()); 461 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 462 VALUES ('成人の日(1月第2月曜日)','1', '14' ,98, 0, now(), 0, now()); 463 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 464 VALUES ('建国記念の日(2月11日)','2', '11' ,96, 0, now(), 0, now()); 465 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 466 VALUES ('春分の日(3月21日)','3', '21' ,94, 0, now(), 0, now()); 467 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 468 VALUES ('昭和の日(4月29日)','4', '29' ,92, 0, now(), 0, now()); 469 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 470 VALUES ('憲法記念日(5月3日)','5', '3' ,90, 0, now(), 0, now()); 471 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 472 VALUES ('みどりの日(5月4日)','5', '4' ,88, 0, now(), 0, now()); 473 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 474 VALUES ('こどもの日(5月5日)','5', '5' ,86, 0, now(), 0, now()); 475 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 476 VALUES ('海の日(7月第3月曜日)','7', '21' ,84, 0, now(), 0, now()); 477 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 478 VALUES ('敬老の日(9月第3月曜日)','9', '15' ,82, 0, now(), 0, now()); 479 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 480 VALUES ('秋分の日(9月23日)','9', '23' ,80, 0, now(), 0, now()); 481 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 482 VALUES ('体育の日(10月第2月曜日)','10', '13' ,78, 0, now(), 0, now()); 483 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 484 VALUES ('文化の日(11月3日)','11', '3' ,76, 0, now(), 0, now()); 485 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 486 VALUES ('勤労感謝の日(11月23日)','11', '23' ,74, 0, now(), 0, now()); 487 INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date) 488 VALUES ('天皇誕生日(12月23日)','12', '23' ,72, 0, now(), 0, now()); 489 455 490 456 491 INSERT INTO mtb_pref (pref_id, pref_name, rank) VALUES ('1', '北海道', '1');
Note: See TracChangeset
for help on using the changeset viewer.