GoApi/db/migrations/insert_default.sql

BEGIN TRANSACTION;
-- Insert Users
INSERT INTO user (user_name, user_email, user_password, user_flag)
VALUES 
('Gabriel', 'gabriel@smartpay.com.vc', 'senha123', 'default'),
('Angelica', 'angelica@smartpay.com.vc', 'senha123', 'default');

-- Insert collaborator
INSERT INTO collaborator (collaborator_name)
VALUES
('Rocelo'),
('Angelica'),
('Marcelo');

-- Insert events
INSERT INTO events (
    event_name, event_date, event_passage_value, event_hotel_value, 
    event_gift_value, event_team_value, event_sponsor_value, event_total_value
)
VALUES
('Prod Tech', '2025-12-01', '100', '200', '50', '150', '300', '800'),
('Summer Tech', '2025-11-15', '150', '250', '70', '200', '500', '1170');

INSERT INTO event_collaborators (event_id, collaborator_id)
VALUES
(1, 1),
(1, 2),
(2, 2),
(2, 3);

COMMIT;