init.sql

USE `junction-prac-database`;

-- Safe Update 임시 해제 (세션 범위)
SET SQL_SAFE_UPDATES = 0;

-- FK 무결성 검사 임시 해제
SET FOREIGN_KEY_CHECKS = 0;

-- 자식 → 부모 순서로 전행 삭제
DELETE FROM `apartment_analysis`;
DELETE FROM `apartment_company`;
DELETE FROM `apartment_construction_step`;
DELETE FROM `apartment_detail`;
DELETE FROM `apartment`;

-- AUTO_INCREMENT 리셋
ALTER TABLE `apartment_analysis`           AUTO_INCREMENT = 1;
ALTER TABLE `apartment_company`            AUTO_INCREMENT = 1;
ALTER TABLE `apartment_construction_step`  AUTO_INCREMENT = 1;
ALTER TABLE `apartment_detail`             AUTO_INCREMENT = 1;
ALTER TABLE `apartment`                    AUTO_INCREMENT = 1;

-- FK/세이프 업데이트 원복
SET FOREIGN_KEY_CHECKS = 1;
SET SQL_SAFE_UPDATES = 1;

-- apartment
INSERT INTO apartment (id, name, type, address) VALUES
(1, '힐스테이트 리버뷰', 'PRIVATE', '서울특별시 강동구 고덕동'),
(2, 'LH 행복주택 송파', 'PUBLIC', '서울특별시 송파구 잠실동'),
(3, '자이 파크시티', 'PRIVATE', '경기도 성남시 분당구 정자동'),
(4, '래미안 그린파크', 'PRIVATE', '서울특별시 강서구 마곡동');

-- apartment_company
INSERT INTO apartment_company (id, apartment_id, type, company_name, average_rating) VALUES
(1, 1, 'CONSTRUCTOR', '현대건설', 4.75),
(2, 1, 'ARCHITECT', '삼우종합건축사사무소', 4.10),
(3, 2, 'CONSTRUCTOR', 'LH공사', 3.20),
(4, 2, 'SUPERVISOR', '한국감리협회', 3.90),
(5, 3, 'OWNER', 'GS건설', 4.50),
(6, 4, 'CONSTRUCTOR', '삼성물산', 4.25);

-- apartment_construction_step
INSERT INTO apartment_construction_step (id, apartment_id, step) VALUES
(3, 1, 'APPROVAL'),
(5, 2, 'START'),
(7, 3, 'START'),
(8, 4, 'PERMIT');

-- apartment_detail
INSERT INTO apartment_detail (apartment_id, presale_start, construction_start, movein_prep_start, movein_start) VALUES
(1, '2023-05-01', '2023-07-15', '2025-01-01', '2025-03-01'),
(2, '2022-11-01', '2023-02-01', '2024-08-01', '2024-10-01'),
(3, '2023-08-01', '2023-10-01', '2024-6-01', '2024-8-01'),
(4, '2024-01-15', '2024-04-01', '2025-3-01', '2025-5-01');

-- user
INSERT INTO user (id, password, nickname, apartmentName) VALUES
('user01', 'pw1234', '박호건', '힐스테이트 리버뷰'),
('user02', 'pw5678', '양예원', 'LH 행복주택 송파'),
('user03', 'pw9999', '김종하', '자이 파크시티'),
('user04', 'pw9999', '김나연', '래미안 그린파크');