zenn
00999404a4
페이지 섹션 관리와 홈 Pages 진열장 연동, 공개 목록 표시개수 설정 관련 누적 로컬 변경을 기능 단위로 정리해 반영한다. 문서 이력과 패키지 버전을 v1.9.23으로 맞춰 코드와 문서 상태를 동기화한다. Co-authored-by: Cursor <cursoragent@cursor.com>
47 lines
1.6 KiB
SQL
47 lines
1.6 KiB
SQL
ALTER TABLE site_settings
|
|
ADD COLUMN IF NOT EXISTS home_latest_post_limit INTEGER NOT NULL DEFAULT 20,
|
|
ADD COLUMN IF NOT EXISTS post_list_page_size INTEGER NOT NULL DEFAULT 20,
|
|
ADD COLUMN IF NOT EXISTS tag_post_list_page_size INTEGER NOT NULL DEFAULT 20,
|
|
ADD COLUMN IF NOT EXISTS featured_post_limit INTEGER NOT NULL DEFAULT 6,
|
|
ADD COLUMN IF NOT EXISTS page_section_item_limit INTEGER NOT NULL DEFAULT 12;
|
|
|
|
ALTER TABLE site_settings
|
|
ADD CONSTRAINT site_settings_home_latest_post_limit_range_check
|
|
CHECK (home_latest_post_limit BETWEEN 1 AND 50)
|
|
NOT VALID;
|
|
|
|
ALTER TABLE site_settings
|
|
ADD CONSTRAINT site_settings_post_list_page_size_range_check
|
|
CHECK (post_list_page_size BETWEEN 1 AND 50)
|
|
NOT VALID;
|
|
|
|
ALTER TABLE site_settings
|
|
ADD CONSTRAINT site_settings_tag_post_list_page_size_range_check
|
|
CHECK (tag_post_list_page_size BETWEEN 1 AND 50)
|
|
NOT VALID;
|
|
|
|
ALTER TABLE site_settings
|
|
ADD CONSTRAINT site_settings_featured_post_limit_range_check
|
|
CHECK (featured_post_limit BETWEEN 1 AND 50)
|
|
NOT VALID;
|
|
|
|
ALTER TABLE site_settings
|
|
ADD CONSTRAINT site_settings_page_section_item_limit_range_check
|
|
CHECK (page_section_item_limit BETWEEN 1 AND 50)
|
|
NOT VALID;
|
|
|
|
ALTER TABLE site_settings
|
|
VALIDATE CONSTRAINT site_settings_home_latest_post_limit_range_check;
|
|
|
|
ALTER TABLE site_settings
|
|
VALIDATE CONSTRAINT site_settings_post_list_page_size_range_check;
|
|
|
|
ALTER TABLE site_settings
|
|
VALIDATE CONSTRAINT site_settings_tag_post_list_page_size_range_check;
|
|
|
|
ALTER TABLE site_settings
|
|
VALIDATE CONSTRAINT site_settings_featured_post_limit_range_check;
|
|
|
|
ALTER TABLE site_settings
|
|
VALIDATE CONSTRAINT site_settings_page_section_item_limit_range_check;
|