data.sql 3.0 BETA 버전 by Jazz

INSERT INTO meeting (name, uuid, start_timeslot, end_timeslot, created_at, modified_at, is_locked)
VALUES ('momo_1', '550e8400', 'TIME_1000', 'TIME_1800', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, false);

INSERT INTO available_date (meeting_id, date, created_at, modified_at)
VALUES (1, '2024-07-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-16', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-17', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-18', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-19', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-21', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO attendee (meeting_id, name, password, created_at, modified_at, role)
VALUES (1, 'daon', '1234', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'HOST');
INSERT INTO attendee (meeting_id, name, password, created_at, modified_at, role)
VALUES (1, 'mark', '1234', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'GUEST'); 

INSERT INTO schedule (attendee_id, available_date_id, timeslot, created_at, modified_at)
VALUES (1, 1, 'TIME_2000', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, 1, 'TIME_2030', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (2, 1, 'TIME_2000', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (2, 1, 'TIME_2030', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (2, 1, 'TIME_2100', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
  

data.sql 통합본 by 다온 fixed by 페드로

INSERT INTO meeting (name, uuid, start_timeslot, end_timeslot, is_locked, created_at, modified_at)
VALUES ('momo_1', '550e8400', 'TIME_1000', 'TIME_1800', false, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO available_date (meeting_id, date, created_at, modified_at)
VALUES (1, '2024-07-15', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-16', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-17', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-18', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-19', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-20', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, '2024-07-21', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO attendee (meeting_id, name, password, created_at, modified_at, role)
VALUES (1, 'daon', '1234', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'HOST');

INSERT INTO schedule (attendee_id, available_date_id, first_timeslot, last_timeslot, created_at, modified_at)
VALUES (1, 1, 'TIME_1000', 'TIME_2000', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, 1, 'TIME_1300', 'TIME_2000', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, 1, 'TIME_1200', 'TIME_2000', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, 2, 'TIME_1600', 'TIME_2000', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
       (1, 3, 'TIME_1500', 'TIME_2100', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

• 안 쓰는 것