security_insert_data.sql

-- users
INSERT INTO users (user_id, email, password, name) VALUES
('hong123', 'hong@example.com', 'hong123', '홍길동'),
('kim456',  'kim@example.com',  'kim456', '김철수');

-- expenses
INSERT INTO expenses (user_id, category, description, amount, spent_at) VALUES
('hong123', '식비', '편의점 점심', 5500.00, '2025-07-19'),
('hong123', '교통', '버스', 1350.00, '2025-07-18'),
('kim456',  '쇼핑', '신발 구매', 72000.00, '2025-07-17');

-- budgets
INSERT INTO budgets (user_id, month, amount) VALUES
('hong123', '2025-07', 500000.00),
('kim456',  '2025-07', 650000.00);

-- assets
INSERT INTO assets (user_id, name, type, amount) VALUES
('hong123', '현금지갑', '현금', 250000.00),
('hong123', '카카오뱅크', '예금', 1200000.00),
('kim456',  '삼성전자 주식', '주식', 800000.00),
('kim456',  '우리은행 예금', '예금', 430000.00);