-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `develable_rutapbot`
--
CREATE DATABASE IF NOT EXISTS `develable_rutapbot` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `develable_rutapbot`;

-- --------------------------------------------------------

--
-- Table structure for table `afk`
--

CREATE TABLE `afk` (
  `id` int(11) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `since` datetime NOT NULL,
  `reason` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `and_so_on`
--

CREATE TABLE `and_so_on` (
  `server_id` bigint(20) NOT NULL,
  `prefix` tinytext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `and_so_on`
--

INSERT INTO `and_so_on` (`server_id`, `prefix`) VALUES
(333949691962195969, '/'),
(340823112994127873, '/'),
(350943138853945345, '/'),
(402779772880420875, '/'),
(407394417259970561, '/'),
(408850170927644692, '/'),
(419451008360513536, '/'),
(420507385325682689, '/'),
(462383319217078273, '/'),
(464764907666145281, '/'),
(469346663190888468, '/'),
(472677760192479232, '/'),
(478524835321085952, '/'),
(478793534984552459, '/'),
(482894918746898432, '/'),
(485313308119793664, '/'),
(498096074138058752, '/'),
(500905996298747905, '/'),
(506840403794853899, '/'),
(532831945365651457, '/'),
(534159625331671041, '/'),
(535329910722658304, '/'),
(535750411097866241, '/'),
(539059719801667584, '/'),
(541478035338035225, '/'),
(542599372836438016, '/'),
(552115592170307585, '/'),
(552761031651491870, '/'),
(556397971315359745, '/'),
(557177308360867854, '/'),
(559749856344670219, '/'),
(561846311058669569, '/'),
(566436900664246290, '/'),
(566886791983136787, '/'),
(570960163754868747, '/'),
(573415327178686464, '/'),
(573767304832352256, '/'),
(583583382605398016, '/'),
(584884877648855070, '/'),
(593083639483596810, '/'),
(594513082605240360, '/'),
(598514755615064064, '/'),
(601693631635783680, '/'),
(601707389359620107, '/'),
(601746282905600020, '/'),
(602743295101239337, '/'),
(603928040430632990, '/'),
(603981129728524288, '/'),
(606095327837159434, '/'),
(612167953437163520, '/'),
(613000823168827412, '/'),
(617653072755163137, '/'),
(622079451186069524, '/');

-- --------------------------------------------------------

--
-- Table structure for table `banned_user`
--

CREATE TABLE `banned_user` (
  `id` int(11) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `since` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `banned_user`
--

INSERT INTO `banned_user` (`id`, `user_id`, `since`) VALUES
(1, 267306598756515841, '2019-11-09 10:34:06');

-- --------------------------------------------------------

--
-- Table structure for table `bot_selection_noti`
--

CREATE TABLE `bot_selection_noti` (
  `id` int(11) NOT NULL,
  `server_id` bigint(20) NOT NULL,
  `channel_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bot_selection_noti`
--

INSERT INTO `bot_selection_noti` (`id`, `server_id`, `channel_id`) VALUES
(1, 420507385325682689, 602399094236774401),
(2, 464764907666145281, 465831052045451294),
(3, 552115592170307585, 615141733130305556),
(4, 617653072755163137, 618013647586852902);

-- --------------------------------------------------------

--
-- Table structure for table `custom_command`
--

CREATE TABLE `custom_command` (
  `server_id` bigint(20) UNSIGNED NOT NULL,
  `total` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `custom_command`
--

INSERT INTO `custom_command` (`server_id`, `total`) VALUES
(333949691962195969, 5),
(340823112994127873, 25),
(350943138853945345, 5),
(402779772880420875, 25),
(407394417259970561, 25),
(408850170927644692, 25),
(419451008360513536, 25),
(420507385325682689, 25),
(462383319217078273, 25),
(464764907666145281, 1),
(469346663190888468, 25),
(472677760192479232, 25),
(478524835321085952, 5),
(478793534984552459, 25),
(482894918746898432, 25),
(485313308119793664, 25),
(498096074138058752, 25),
(500905996298747905, 25),
(506840403794853899, 40),
(532831945365651457, 50),
(534159625331671041, 25),
(535329910722658304, 25),
(535750411097866241, 25),
(539059719801667584, 5),
(541478035338035225, 25),
(542599372836438016, 25),
(552115592170307585, 1),
(552761031651491870, 25),
(556397971315359745, 5),
(557177308360867854, 5),
(559749856344670219, 25),
(561846311058669569, 5),
(566436900664246290, 5),
(566886791983136787, 5),
(570960163754868747, 5),
(573415327178686464, 5),
(573767304832352256, 5),
(583583382605398016, 5),
(584884877648855070, 5),
(593083639483596810, 5),
(594513082605240360, 5),
(598514755615064064, 5),
(601693631635783680, 5),
(601707389359620107, 5),
(601746282905600020, 5),
(602743295101239337, 5),
(603928040430632990, 5),
(603981129728524288, 5),
(606095327837159434, 5),
(612167953437163520, 5),
(613000823168827412, 5),
(617653072755163137, 5),
(622079451186069524, 5);

-- --------------------------------------------------------

--
-- Table structure for table `custom_command_data`
--

CREATE TABLE `custom_command_data` (
  `id` bigint(20) NOT NULL,
  `content` longtext NOT NULL,
  `name` longtext NOT NULL,
  `custom_command_server_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `custom_command_data`
--

INSERT INTO `custom_command_data` (`id`, `content`, `name`, `custom_command_server_id`) VALUES
(1, '안녕하세요!!! 저는 루탑봇입니다. (이 명령어는 루탑봇 제작자가 만든것이 아닌 이 서버를 만든 **도르크**님께서 CC 추가 명령어를 사용하여 만든 명령어입니다.)', '안녕하세요', 407394417259970561),
(2, '안녕.', 'ㅎㅇ', 482894918746898432),
(3, '안녕', '_ㅎㅇ', 482894918746898432),
(4, '안녕하세요 천재 리드라고 합니다', 'Lead', 506840403794853899),
(5, '안녕하세여 Wide7입니다! 저는 모션그래픽 디자이너로 활동중입니다. 외주문의는 JTNCProjectWide7@gmail.com으로 보내주시면 됩니다.', 'Wide7', 506840403794853899),
(17, '는 정말 차칸 사람 .... 아마도?', '와이드', 532831945365651457),
(22, 'spiethserver.kro.kr', '서버주소', 583583382605398016),
(19, '오! 안녕하신가요?', '안녕하세요', 535750411097866241),
(20, 'ㅁㄴㅇㄹ', '매리', 542599372836438016),
(21, '옹ㅁㄴ엄니ㅏ어미낭', '신기하군', 566436900664246290);

-- --------------------------------------------------------

--
-- Table structure for table `hibernate_sequence`
--

CREATE TABLE `hibernate_sequence` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hibernate_sequence`
--

INSERT INTO `hibernate_sequence` (`next_val`) VALUES
(228);

-- --------------------------------------------------------

--
-- Table structure for table `logging`
--

CREATE TABLE `logging` (
  `id` int(11) NOT NULL,
  `server_id` bigint(20) NOT NULL,
  `channel_id` bigint(20) NOT NULL,
  `text_logging` tinyint(1) NOT NULL,
  `channel_logging` tinyint(1) NOT NULL,
  `member_logging` tinyint(1) NOT NULL,
  `guild_logging` tinyint(1) NOT NULL,
  `voice_logging` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `logging`
--

INSERT INTO `logging` (`id`, `server_id`, `channel_id`, `text_logging`, `channel_logging`, `member_logging`, `guild_logging`, `voice_logging`) VALUES
(1, 464764907666145281, 560403477415591936, 1, 1, 1, 1, 1),
(2, 552115592170307585, 567638307413032963, 1, 1, 1, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `notice`
--

CREATE TABLE `notice` (
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `author` text NOT NULL,
  `content` longtext NOT NULL,
  `id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notice`
--

INSERT INTO `notice` (`time`, `author`, `content`, `id`) VALUES
('2019-11-09 10:34:11', '화향', '이 패널은 베타입니다! 언제든 버그를 발견하시면 공식 서버로 알려주세요!', 0),
('2019-11-09 10:34:11', '화향', '7~8월 중으로 웹패널 전반적인 기능의 개편이 있을 예정입니다. 감사합니다.', 1),
('2019-11-09 10:34:11', '화향', '웹패널 시스템 전체 개편을 생각중에 있습니다. 정확한 웹패널 업데이트 일정은 없습니다.', 3);

-- --------------------------------------------------------

--
-- Table structure for table `on_join`
--

CREATE TABLE `on_join` (
  `server_id` bigint(25) NOT NULL,
  `channel_id` bigint(25) NOT NULL,
  `say` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `on_join`
--

INSERT INTO `on_join` (`server_id`, `channel_id`, `say`) VALUES
(407394417259970561, 416457572732895233, '안녕하세요! **도르크 팬 디스코드방**에 오신것을 정말로 환영합니다!'),
(420507385325682689, 441225730207252480, '어서오세요!!! <#441226267183022081> 을 봐주세요'),
(464764907666145281, 473389580310282250, '[@유저], Develable 공식 서버에 오신 것을 환영합니다!\r\n<#519865731706388482>에서 규착 한번 읽어주세요!'),
(472677760192479232, 491918610441306145, '레드 드래곤 디스코드에 입장하셨습니다'),
(482894918746898432, 485650693722734602, '안녕하십니까, 유버에 오신 걸 환영합니다!'),
(485313308119793664, 518068418608365578, ',MineKorea Commuity입니다! <#490410709797306369> 을 읽고 서버를 재미있게 즐겨주세요!들낙은 하지 말아주세요~^^\n\n홈페이지(Wix)\nhttps://albert1020121.wixsite.com/minekoreacommuity\n\n카페(naver)\nhttps://cafe.naver.com/purplewqrxs\n감사합니다~'),
(500905996298747905, 500905996298747909, '돌아가세요'),
(534159625331671041, 537909508677173258, 'Hello Bro ! :)'),
(535329910722658304, 535331079570194442, '어서오세요!'),
(535750411097866241, 563926134115401738, '안녕하세요!'),
(541478035338035225, 542534048128434187, '환영합니다!!!\n**MineKorea**에 오셔서 감사합니다~ <#541478626210873384> 을 보아주세요!\n\nMineKorea Official Server : https://discord.gg/hdHPjUA\n\nMineKorea Naver Cafe : https://m.cafe.naver.com/purplewqrxs\n\n문의 : https://discord.gg/hdHPjUA'),
(542599372836438016, 579973723667300353, 'ㄱ'),
(552761031651491870, 553816577372323850, '이프팀 디코방에 오신것을 환영합니다'),
(566436900664246290, 566436900664246295, '와'),
(573415327178686464, 573415327178686466, '입국을 환영합니다!'),
(583583382605398016, 585392269629325333, '안녕하세요! MINECRAFT112서버에오신걸환영합니다!'),
(606095327837159434, 606099063485497354, '님 죄송합니다 이미팀에서 퇴출당한사람은 면접이 불가합니다');

-- --------------------------------------------------------

--
-- Table structure for table `on_leave`
--

CREATE TABLE `on_leave` (
  `server_id` bigint(20) NOT NULL,
  `channel_id` bigint(20) NOT NULL,
  `say` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `on_leave`
--

INSERT INTO `on_leave` (`server_id`, `channel_id`, `say`) VALUES
(407394417259970561, 416457572732895233, '안녕히가세요....'),
(420507385325682689, 441225730207252480, '안녕히가세요ㅠㅠ 다음에 또 오세요~'),
(464764907666145281, 473389580310282250, '`[@#유저]`, 안녕히가세요..'),
(472677760192479232, 491918610441306145, '레드 드래곤 디스코드에서 나가셨습니다'),
(485313308119793664, 518068418608365578, '저희 MineKorea를 방문해 주셔서 감사의 말씀 드립니다.안녕히 가세요…'),
(534159625331671041, 537909508677173258, 'Bye Bro :('),
(535329910722658304, 535331079570194442, '안녕히 가세요..'),
(535750411097866241, 563926134115401738, '잘가!'),
(541478035338035225, 542534091006803988, '님께서 나가셨습니다…\n**MineKorea**에 와주셔서 감사했습니다…ㅠㅠ\n\nMineKorea Official Server : https://discord.gg/hdHPjUA\n\nMineKorea Naver Cafe : https://m.cafe.naver.com/purplewqrxs\n\n문의 : https://discord.gg/hdHPjUA'),
(566436900664246290, 566436900664246295, '패널'),
(573415327178686464, 573415327178686466, '출국하셨습니다.'),
(583583382605398016, 585392269629325333, '나가주셨네요... 나중에다시와주세요!');

-- --------------------------------------------------------

--
-- Table structure for table `ping`
--

CREATE TABLE `ping` (
  `TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Ping` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `spring_session_attributes`
--

CREATE TABLE `spring_session_attributes` (
  `SESSION_PRIMARY_ID` char(36) NOT NULL,
  `ATTRIBUTE_NAME` varchar(200) NOT NULL,
  `ATTRIBUTE_BYTES` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `spring_session_attributes`
--

INSERT INTO `spring_session_attributes` (`SESSION_PRIMARY_ID`, `ATTRIBUTE_NAME`, `ATTRIBUTE_BYTES`) VALUES
('0f39677e-f421-4c75-b7fe-a24a6853fa39', 'SPRING_SECURITY_SAVED_REQUEST', 0x[BLOB]),
('63b0b4db-6d87-4789-a550-aa5229003970', 'SPRING_SECURITY_SAVED_REQUEST', 0x[BLOB]),
('7236a012-0cf1-41c7-bfa0-5d3f4314244a', 'SPRING_SECURITY_SAVED_REQUEST', 0x[BLOB]),
('827e17a9-2f0f-4dc6-997c-93bd3bd5d48d', 'SPRING_SECURITY_SAVED_REQUEST', 0x[BLOB]),
('8b0192ae-8fc6-43bb-8093-5fdfc16bfa22', 'SPRING_SECURITY_SAVED_REQUEST', 0x[BLOB]),
('aefd1f41-853b-4706-a857-a288fadc72da', 'SPRING_SECURITY_SAVED_REQUEST', 0x[BLOB]);

-- --------------------------------------------------------

--
-- Table structure for table `userdata`
--

CREATE TABLE `userdata` (
  `userid` bigint(20) NOT NULL,
  `permission` bigint(20) NOT NULL,
  `email` longtext NOT NULL,
  `birthday` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `userdata`
--

INSERT INTO `userdata` (`userid`, `permission`, `email`, `birthday`) VALUES
(332836587576492033, 1, 'cyoung06@naver.com', '2006-06-21 15:00:00'),
(357857022974230538, 1, 'kangs7721@naver.com', '2004-12-22 15:00:00'),
(362198954257154051, 1, 'endom4086@gmail.com', '1999-06-20 15:00:00'),
(375951816384446464, 1, 'eric071024@naver.com', '2000-10-23 15:00:00'),
(383801854003511296, 1, 'phw3071@gmail.com', '2004-07-07 15:00:00'),
(392650333634953218, 1, 'ws16111002@gmail.com', '2004-12-22 15:00:00'),
(423037094320013312, 1, 'jaemin5336@naver.com', '2007-01-13 15:00:00'),
(461495816142716928, 1, '01094986943a@gmail.com', '1998-11-29 15:00:00'),
(480240821623455746, 1, 'kkomanse1004@gmail.com', '2005-01-11 15:00:00'),
(480568196286644224, 1, 'kill_help@naver.com', '2000-04-22 15:00:00'),
(498094046284349441, 1, 'kevin5404@naver.com', '2006-04-20 15:00:00'),
(513232014275510272, 1, 'siyeong.song.06@gmail.com', '2006-06-29 15:00:00'),
(575218612403437579, 1, '2smkr@naver.com', '2004-03-31 15:00:00'),
(578931815746764822, 1, 'freb89@yahoo.com', '1990-01-13 15:00:00'),
(584365011384926210, 1, 'riuu2715@gmail.com', '2001-06-02 15:00:00'),
(602740095438815243, 1, 'fyy@yy.com', '1997-04-18 15:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `userlog`
--

CREATE TABLE `userlog` (
  `id` bigint(20) NOT NULL,
  `action` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `time` datetime DEFAULT NULL,
  `user` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `userlog`
--

INSERT INTO `userlog` (`id`, `action`, `description`, `ip`, `time`, `user`) VALUES
(130, '나가는말 변경', 'minecraft 112서버 나가는말을 나가주셨네요... 나중에다시와주세요!로 환영-나감채널에서 보내도록 설정하였숩니다.', '114.207.64.212', '2019-06-04 09:01:21', 461495816142716928),
(129, '인사말 변경', 'minecraft 112서버의 인사말을 안녕하세요! MINECRAFT112서버에오신걸환영합니다!로 환영-나감채널에서 보내도록 설정하였숩니다.', '114.207.64.212', '2019-06-04 09:00:45', 461495816142716928),
(127, '로그아웃', '해당 계정에서 로그아웃되었습니다', '115.143.169.133', '2019-06-04 08:39:06', 392650333634953218),
(128, '로그인', '해당 계정으로 로그인되었습니다', '114.207.64.212', '2019-06-04 08:58:40', 461495816142716928),
(126, '서버 접두사 변경', 'Team. 화공 Official서버의 서버 접두사를 /로 변경허였습니다.', '115.143.169.133', '2019-06-04 08:38:03', 392650333634953218),
(122, '로그인', '해당 계정으로 로그인되었습니다', '114.207.64.212', '2019-06-03 08:55:29', 461495816142716928),
(123, '회원가입', '이메일: 01094986943a@gmail.com, 생년월일: Mon Nov 30 00:00:00 KST 1998', '114.207.64.212', '2019-06-03 08:57:00', 461495816142716928),
(124, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-03 14:42:50', 392650333634953218),
(125, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-04 08:36:40', 392650333634953218),
(119, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-03 06:25:53', 357857022974230538),
(120, '로그인', '해당 계정으로 로그인되었습니다', '211.36.138.196', '2019-06-03 06:27:00', 584365011384926210),
(121, '회원가입', '이메일: riuu2715@gmail.com, 생년월일: Sun Jun 03 00:00:00 KST 2001', '211.36.138.196', '2019-06-03 06:27:33', 584365011384926210),
(116, '로그인', '해당 계정으로 로그인되었습니다', '1.224.119.162', '2019-06-02 22:21:53', 550876882246303774),
(117, '로그인', '해당 계정으로 로그인되었습니다', '1.224.119.162', '2019-06-02 22:22:08', 550876882246303774),
(118, '로그인', '해당 계정으로 로그인되었습니다', '1.224.119.162', '2019-06-02 23:24:30', 550876882246303774),
(115, '로그인', '해당 계정으로 로그인되었습니다', '24.169.24.199', '2019-06-02 16:49:02', 332836587576492033),
(114, '인사말 변경', 'ㅃㅏㅂㅏㅁ서버의 인사말을 와로 general채널에서 보내도록 설정하였숩니다.', '107.77.224.151', '2019-06-02 14:51:46', 332836587576492033),
(112, '회원가입', '이메일: cyoung06@naver.com, 생년월일: Sat Jan 01 00:00:00 KST 2000', '107.77.224.151', '2019-06-02 14:49:52', 332836587576492033),
(113, '나가는말 변경', 'ㅃㅏㅂㅏㅁ서버 나가는말을 패널로 general채널에서 보내도록 설정하였숩니다.', '107.77.224.151', '2019-06-02 14:51:22', 332836587576492033),
(110, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-02 14:37:03', 392650333634953218),
(111, '로그인', '해당 계정으로 로그인되었습니다', '107.77.224.151', '2019-06-02 14:49:30', 332836587576492033),
(108, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-02 14:29:43', 392650333634953218),
(109, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-02 14:30:51', 357857022974230538),
(106, '회원가입', '이메일: phw3071@gmail.com, 생년월일: Thu Jul 08 00:00:00 KST 2004', '1.247.122.168', '2019-06-02 14:24:34', 383801854003511296),
(107, '로그아웃', '해당 계정에서 로그아웃되었습니다', '115.143.169.133', '2019-06-02 14:29:34', 392650333634953218),
(105, '로그인', '해당 계정으로 로그인되었습니다', '1.247.122.168', '2019-06-02 14:23:58', 383801854003511296),
(102, '로그인', '해당 계정으로 로그인되었습니다', '180.224.8.219', '2019-06-02 13:45:33', 362198954257154051),
(103, '회원가입', '이메일: endom4086@gmail.com, 생년월일: Mon Jun 21 00:00:00 KST 1999', '180.224.8.219', '2019-06-02 13:45:51', 362198954257154051),
(104, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-02 14:21:08', 392650333634953218),
(101, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-02 13:43:35', 392650333634953218),
(100, '회원가입', '이메일: ws16111002@gmail.com, 생년월일: Thu Dec 23 00:00:00 KST 2004', '115.143.169.133', '2019-06-02 13:15:41', 392650333634953218),
(99, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-02 13:15:23', 392650333634953218),
(98, '회원가입', '이메일: kangs7721@naver.com, 생년월일: Thu Dec 23 00:00:00 KST 2004', '115.143.169.133', '2019-06-02 12:45:46', 357857022974230538),
(90, '회원가입', '이메일: kevin5404@naver.com, 생년월일: Fri Apr 21 00:00:00 KST 2006', '222.108.90.136', '2019-06-02 12:34:45', 498094046284349441),
(97, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-02 12:45:26', 357857022974230538),
(89, '로그인', '해당 계정으로 로그인되었습니다', '222.108.90.136', '2019-06-02 12:33:58', 498094046284349441),
(131, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-04 23:24:56', 357857022974230538),
(132, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-05 07:27:38', 392650333634953218),
(133, '로그인', '해당 계정으로 로그인되었습니다', '211.114.192.159', '2019-06-05 11:37:03', 480568196286644224),
(134, '회원가입', '이메일: kill_help@naver.com, 생년월일: Sun Apr 23 00:00:00 KST 2000', '211.114.192.159', '2019-06-05 11:38:06', 480568196286644224),
(135, '인사말 변경', '통합로그서버의 인사말을 안녕하세요!로 채널채널에서 보내도록 설정하였숩니다.', '211.114.192.159', '2019-06-05 11:40:30', 480568196286644224),
(136, '나가는말 변경', '통합로그서버 나가는말을 잘가!로 채널채널에서 보내도록 설정하였숩니다.', '211.114.192.159', '2019-06-05 11:40:43', 480568196286644224),
(137, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-06 08:55:32', 392650333634953218),
(138, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-07 14:23:36', 392650333634953218),
(139, '로그아웃', '해당 계정에서 로그아웃되었습니다', '115.143.169.133', '2019-06-07 14:24:36', 392650333634953218),
(140, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-08 08:32:44', 392650333634953218),
(141, '나가는말 변경', 'Team. 화공 Official서버 나가는말을 안녕히가세요..로 환영합니다채널에서 보내도록 설정하였숩니다.', '115.143.169.133', '2019-06-08 08:34:27', 392650333634953218),
(142, '로그아웃', '해당 계정에서 로그아웃되었습니다', '115.143.169.133', '2019-06-08 08:42:45', 392650333634953218),
(143, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-08 09:29:18', 392650333634953218),
(144, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-09 07:53:05', 392650333634953218),
(145, '로그인', '해당 계정으로 로그인되었습니다', '182.228.107.209', '2019-06-12 06:53:27', 575218612403437579),
(146, '회원가입', '이메일: 2smkr@naver.com, 생년월일: Thu Apr 01 00:00:00 KST 2004', '182.228.107.209', '2019-06-12 06:53:45', 575218612403437579),
(147, '로그인', '해당 계정으로 로그인되었습니다', '121.147.148.41', '2019-06-12 12:53:07', 260303569591205888),
(148, '로그인', '해당 계정으로 로그인되었습니다', '116.127.193.102', '2019-06-12 12:54:01', 480240821623455746),
(149, '회원가입', '이메일: kkomanse1004@gmail.com, 생년월일: Wed Jan 12 00:00:00 KST 2005', '116.127.193.102', '2019-06-12 12:54:38', 480240821623455746),
(150, '로그인', '해당 계정으로 로그인되었습니다', '182.209.5.10', '2019-06-12 12:57:00', 351613953769603073),
(151, '로그아웃', '해당 계정에서 로그아웃되었습니다', '182.209.5.10', '2019-06-12 12:58:10', 351613953769603073),
(152, '로그인', '해당 계정으로 로그인되었습니다', '59.10.101.147', '2019-06-12 13:00:19', 285185716240252929),
(153, '인사말 변경', '갈구자 채뭉서버의 인사말을 \"\'\"\\``\\`\\```\"\'\'`\'\'`\'`\'`\'`\\``````:;\'[][]ㅋㅌㅊㅍ[][\'\'\'\';;\'\'\"\'\'\'\'::\";:;;;;로 direct채널에서 보내도록 설정하였숩니다.', '121.147.148.41', '2019-06-12 13:05:51', 260303569591205888),
(154, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-13 23:31:15', 357857022974230538),
(155, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-16 11:37:01', 392650333634953218),
(156, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-19 13:35:08', 392650333634953218),
(157, '로그인', '해당 계정으로 로그인되었습니다', '114.207.64.212', '2019-06-22 02:14:32', 461495816142716928),
(158, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-23 14:27:36', 392650333634953218),
(159, '로그아웃', '해당 계정에서 로그아웃되었습니다', '115.143.169.133', '2019-06-23 14:29:44', 392650333634953218),
(160, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-23 14:30:22', 392650333634953218),
(161, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-06-24 10:11:36', 392650333634953218),
(162, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-03 08:11:16', 392650333634953218),
(163, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-04 11:23:59', 392650333634953218),
(164, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-04 14:16:28', 392650333634953218),
(165, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-05 11:59:35', 392650333634953218),
(166, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-06 12:43:10', 392650333634953218),
(167, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-10 07:19:24', 392650333634953218),
(168, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-07-10 14:15:52', 513232014275510272),
(169, '로그인', '해당 계정으로 로그인되었습니다', '180.224.8.219', '2019-07-10 15:28:43', 362198954257154051),
(170, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-11 13:01:45', 392650333634953218),
(171, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-11 14:21:37', 392650333634953218),
(172, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-07-11 15:16:43', 332836587576492033),
(173, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-07-11 15:16:57', 332836587576492033),
(174, '회원정보 수정', '이전 이메일: cyoung06@naver.com, 이전 생년월일: 2000-01-01 변경 이메일: cyoung06@naver.com 변경 생년월일: Thu Jun 22 00:00:00 KST 2006', '67.252.28.68', '2019-07-11 15:19:47', 332836587576492033),
(175, '회원정보 수정', '이전 이메일: cyoung06@naver.com, 이전 생년월일: 2006-06-22 변경 이메일: cyoung06@naver.com 변경 생년월일: Fri Jun 22 00:00:00 KST 2007', '67.252.28.68', '2019-07-11 15:19:57', 332836587576492033),
(176, '회원정보 수정', '이전 이메일: cyoung06@naver.com, 이전 생년월일: 2007-06-22 변경 이메일: cyoung06@naver.com 변경 생년월일: Thu Jun 22 00:00:00 KST 2006', '67.252.28.68', '2019-07-11 15:20:38', 332836587576492033),
(177, '로그아웃', '해당 계정에서 로그아웃되었습니다', '67.252.28.68', '2019-07-11 15:21:06', 332836587576492033),
(178, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-07-11 15:21:17', 332836587576492033),
(179, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-13 07:31:45', 392650333634953218),
(180, '로그인', '해당 계정으로 로그인되었습니다', '114.207.64.212', '2019-07-13 10:36:55', 461495816142716928),
(181, '로그인', '해당 계정으로 로그인되었습니다', '211.114.192.159', '2019-07-17 14:20:38', 599215078595625002),
(182, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-20 08:42:57', 392650333634953218),
(183, '로그인', '해당 계정으로 로그인되었습니다', '14.5.146.134', '2019-07-22 05:54:49', 602740095438815243),
(184, '회원가입', '이메일: fyy@yy.com, 생년월일: Sat Apr 19 00:00:00 KST 1997', '14.5.146.134', '2019-07-22 05:55:37', 602740095438815243),
(185, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-07-25 13:18:53', 392650333634953218),
(186, '로그인', '해당 계정으로 로그인되었습니다', '182.209.5.10', '2019-07-25 14:07:32', 351613953769603073),
(187, '로그인', '해당 계정으로 로그인되었습니다', '180.64.229.192', '2019-07-26 09:12:15', 423037094320013312),
(188, '회원가입', '이메일: jaemin5336@naver.com, 생년월일: Sun Jan 14 00:00:00 KST 2007', '180.64.229.192', '2019-07-26 09:12:55', 423037094320013312),
(189, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-07-30 16:22:51', 513232014275510272),
(190, '회원가입', '이메일: siyeong.song.06@gmail.com, 생년월일: Fri Jun 30 00:00:00 KST 2006', '67.252.28.68', '2019-07-30 16:23:32', 513232014275510272),
(191, '회원가입', '이메일: siyeong.song.06@gmail.com, 생년월일: Fri Jun 30 00:00:00 KST 2006', '67.252.28.68', '2019-07-30 16:23:32', 513232014275510272),
(192, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-07-30 21:25:45', 513232014275510272),
(193, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-07-31 16:42:27', 513232014275510272),
(194, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-08-16 00:08:35', 513232014275510272),
(195, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-08-16 00:08:45', 513232014275510272),
(196, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-08-24 09:42:44', 392650333634953218),
(197, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-08-24 10:56:07', 392650333634953218),
(198, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-08-27 16:43:43', 332836587576492033),
(199, '로그아웃', '해당 계정에서 로그아웃되었습니다', '67.252.28.68', '2019-08-27 16:44:44', 332836587576492033),
(200, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-08-28 14:43:32', 392650333634953218),
(201, '로그아웃', '해당 계정에서 로그아웃되었습니다', '115.143.169.133', '2019-08-28 14:44:32', 392650333634953218),
(202, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-08-29 12:36:05', 392650333634953218),
(203, '로그아웃', '해당 계정에서 로그아웃되었습니다', '115.143.169.133', '2019-08-29 12:37:24', 392650333634953218),
(204, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-08-29 12:37:35', 392650333634953218),
(205, '로그아웃', '해당 계정에서 로그아웃되었습니다', '115.143.169.133', '2019-08-29 12:42:54', 392650333634953218),
(206, '로그인', '해당 계정으로 로그인되었습니다', '61.80.117.253', '2019-09-03 10:26:17', 260303569591205888),
(207, '로그아웃', '해당 계정에서 로그아웃되었습니다', '61.80.117.253', '2019-09-03 10:26:34', 260303569591205888),
(208, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-09-03 14:31:36', 392650333634953218),
(209, '로그인', '해당 계정으로 로그인되었습니다', '182.214.196.48', '2019-09-04 10:56:17', 578931815746764822),
(210, '회원가입', '이메일: freb89@yahoo.com, 생년월일: Sun Jan 14 00:00:00 KST 1990', '182.214.196.48', '2019-09-04 10:56:54', 578931815746764822),
(211, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-09-06 23:17:17', 332836587576492033),
(212, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-09-07 04:33:47', 332836587576492033),
(213, '로그인', '해당 계정으로 로그인되었습니다', '117.111.1.3', '2019-09-13 10:50:35', 392650333634953218),
(214, '로그인', '해당 계정으로 로그인되었습니다', '117.111.1.3', '2019-09-13 12:10:46', 392650333634953218),
(215, '로그인', '해당 계정으로 로그인되었습니다', '211.202.204.21', '2019-09-14 06:01:09', 392650333634953218),
(216, '로그인', '해당 계정으로 로그인되었습니다', '211.202.204.21', '2019-09-14 08:06:34', 392650333634953218),
(217, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-09-14 13:37:41', 513232014275510272),
(218, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-09-14 13:37:41', 513232014275510272),
(219, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-09-17 14:30:32', 392650333634953218),
(220, '로그인', '해당 계정으로 로그인되었습니다', '222.108.90.95', '2019-09-19 13:57:35', 498094046284349441),
(221, '로그인', '해당 계정으로 로그인되었습니다', '115.143.169.133', '2019-10-10 14:35:55', 392650333634953218),
(222, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-10-11 01:04:50', 332836587576492033),
(223, '로그인', '해당 계정으로 로그인되었습니다', '211.247.34.220', '2019-10-11 23:47:51', 354616772030365707),
(224, '로그인', '해당 계정으로 로그인되었습니다', '118.217.137.28', '2019-10-19 10:40:26', 375951816384446464),
(225, '회원가입', '이메일: eric071024@naver.com, 생년월일: Tue Oct 24 00:00:00 KST 2000', '118.217.137.28', '2019-10-19 10:40:59', 375951816384446464),
(226, '로그인', '해당 계정으로 로그인되었습니다', '67.252.28.68', '2019-10-20 18:16:06', 332836587576492033),
(227, '로그인', '해당 계정으로 로그인되었습니다', '222.113.169.183', '2019-10-23 06:47:13', 246250457230475264);

-- --------------------------------------------------------

--
-- Table structure for table `vote`
--

CREATE TABLE `vote` (
  `id` int(11) NOT NULL,
  `server_id` bigint(20) NOT NULL,
  `starter` bigint(20) NOT NULL,
  `datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `title` longtext NOT NULL,
  `description` longtext NOT NULL,
  `up_vote` bigint(20) NOT NULL DEFAULT '0',
  `down_vote` bigint(20) NOT NULL DEFAULT '0',
  `participants` longtext NOT NULL,
  `ch` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `warn`
--

CREATE TABLE `warn` (
  `id` int(11) NOT NULL,
  `server_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `count` bigint(20) NOT NULL,
  `reason` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `afk`
--
ALTER TABLE `afk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `and_so_on`
--
ALTER TABLE `and_so_on`
  ADD PRIMARY KEY (`server_id`),
  ADD UNIQUE KEY `server_id_UNIQUE` (`server_id`);

--
-- Indexes for table `banned_user`
--
ALTER TABLE `banned_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bot_selection_noti`
--
ALTER TABLE `bot_selection_noti`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_command`
--
ALTER TABLE `custom_command`
  ADD PRIMARY KEY (`server_id`),
  ADD UNIQUE KEY `server_id_UNIQUE` (`server_id`);

--
-- Indexes for table `custom_command_data`
--
ALTER TABLE `custom_command_data`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`),
  ADD KEY `FKfb4goecu3mfnx5iabgm7ttvo7` (`custom_command_server_id`);

--
-- Indexes for table `logging`
--
ALTER TABLE `logging`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notice`
--
ALTER TABLE `notice`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_UNIQUE` (`id`);

--
-- Indexes for table `on_join`
--
ALTER TABLE `on_join`
  ADD PRIMARY KEY (`server_id`),
  ADD UNIQUE KEY `server_id_UNIQUE` (`server_id`),
  ADD UNIQUE KEY `channel_id_UNIQUE` (`channel_id`);

--
-- Indexes for table `on_leave`
--
ALTER TABLE `on_leave`
  ADD PRIMARY KEY (`server_id`),
  ADD UNIQUE KEY `server_id_UNIQUE` (`server_id`),
  ADD UNIQUE KEY `channel_id_UNIQUE` (`channel_id`);

--
-- Indexes for table `spring_session_attributes`
--
ALTER TABLE `spring_session_attributes`
  ADD PRIMARY KEY (`SESSION_PRIMARY_ID`,`ATTRIBUTE_NAME`);

--
-- Indexes for table `userdata`
--
ALTER TABLE `userdata`
  ADD PRIMARY KEY (`userid`),
  ADD UNIQUE KEY `userid_UNIQUE` (`userid`);

--
-- Indexes for table `userlog`
--
ALTER TABLE `userlog`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vote`
--
ALTER TABLE `vote`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `warn`
--
ALTER TABLE `warn`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `afk`
--
ALTER TABLE `afk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banned_user`
--
ALTER TABLE `banned_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bot_selection_noti`
--
ALTER TABLE `bot_selection_noti`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `custom_command_data`
--
ALTER TABLE `custom_command_data`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `logging`
--
ALTER TABLE `logging`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `vote`
--
ALTER TABLE `vote`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warn`
--
ALTER TABLE `warn`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `spring_session_attributes`
--
ALTER TABLE `spring_session_attributes`
  ADD CONSTRAINT `SPRING_SESSION_ATTRIBUTES_FK` FOREIGN KEY (`SESSION_PRIMARY_ID`) REFERENCES `spring_session` (`PRIMARY_ID`) ON DELETE CASCADE;
COMMIT;

