-- insert reaction
INSERT INTO `abbboo`.`reaction` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("LOL", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- ㅋㅋㅋㅋㅋ
INSERT INTO `abbboo`.`reaction` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("SAD", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 슬퍼
INSERT INTO `abbboo`.`reaction` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("OOPS", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 헉
INSERT INTO `abbboo`.`reaction` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("COOL", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 짱!!
INSERT INTO `abbboo`.`reaction` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("LOVE", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 사랑해
INSERT INTO `abbboo`.`reaction` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("PRETTY", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 예뻐
INSERT INTO `abbboo`.`reaction` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("GOOD", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 좋아
select * from reaction;
-- insert mood
INSERT INTO `abbboo`.`mood` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("NORMAL", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 평범해요 default
INSERT INTO `abbboo`.`mood` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("ANGRY", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 열 받았어요
INSERT INTO `abbboo`.`mood` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("CHEERUP", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 응원해요
INSERT INTO `abbboo`.`mood` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("TIRED", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 피곤해요
INSERT INTO `abbboo`.`mood` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("WORRY", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 걱정돼요
INSERT INTO `abbboo`.`mood` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("SAD", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 슬퍼요
INSERT INTO `abbboo`.`mood` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("THINK", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 가족 생각중
INSERT INTO `abbboo`.`mood` (`expression`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("PASSION", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 열정 넘처요
select * from mood;
-- insert decoration
INSERT INTO `abbboo`.`decoration` (`item`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("NORMAL", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 기본 default
INSERT INTO `abbboo`.`decoration` (`item`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("ALIEN", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 외계인 안경
INSERT INTO `abbboo`.`decoration` (`item`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("BEE", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 꿀벌 머리띠
INSERT INTO `abbboo`.`decoration` (`item`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("GLASSES", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 안경
INSERT INTO `abbboo`.`decoration` (`item`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("HAT", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 모자
INSERT INTO `abbboo`.`decoration` (`item`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("HEARTHAIRBAND", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 하트 머리띠
INSERT INTO `abbboo`.`decoration` (`item`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("POOP", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 똥
INSERT INTO `abbboo`.`decoration` (`item`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("TIE", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 넥타이
INSERT INTO `abbboo`.`decoration` (`item`, `created_at`, `created_ip`, `updated_at`, `updated_ip`) VALUES ("MUSTACHE", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1"); -- 콧수염
select * from decoration;
-- insert message_template
INSERT INTO `abbboo`.`message_template` (`content`, `created_at`, `created_ip`, `updated_at`, `updated_ip`)
VALUES
("{receiver}! {sender}는 항상 {receiver} 생각뿐인거 알지? 오늘도 좋은 하루 보내 ~ (●'◡'●)", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1")
, ("{sender}의 원동력은 {receiver}! 고마워 ヽ(✿゚▽゚)ノ", current_timestamp(), "127.0.0.1", current_timestamp(), "127.0.0.1")
;