-- https://www.phpmyadmin.net/
--
-- 생성 시간: 20-02-27 16:40
-- 서버 버전: 10.1.13-MariaDB
-- PHP 버전: 7.3.1p1

START TRANSACTION;



--
-- 데이터베이스: `superstream`
--

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

--
-- 테이블 구조 `tb_user`
--

CREATE TABLE `tb_user` (
  `m_id` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '회원아이디',
  `stud_no` varchar(255) CHARACTER SET utf8 NOT NULL,
  `m_user_type` varchar(1) CHARACTER SET utf8 NOT NULL,
  `m_name` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '이름',
  `m_nick` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '닉네임',
  `m_reg` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '주민번호',
  `m_dn` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '공인인증서 DN',
  `m_password` varchar(512) CHARACTER SET utf8 NOT NULL COMMENT '비밀번호',
  `m_birth` varchar(10) CHARACTER SET utf8 NOT NULL COMMENT '생일',
  `m_gender` int(11) NOT NULL COMMENT '성별',
  `m_mail` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '메일',
  `m_tel` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '전화번호',
  `m_htel` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '핸드폰',
  `m_zipcode` int(10) NOT NULL COMMENT '우편번호',
  `m_address` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '주소',
  `m_address_desc` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '주소상세',
  `m_school_name` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '최종학력 학교명',
  `m_level_edu` int(11) NOT NULL COMMENT '최종학력',
  `m_graduation` int(11) NOT NULL COMMENT '졸업구분',
  `m_request_path` int(11) NOT NULL COMMENT '지원경로',
  `m_level` tinyint(4) NOT NULL COMMENT '회원레벨',
  `m_filename` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '사진',
  `m_tempfilename` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '사진경로',
  `m_stat` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT '1' COMMENT '상태',
  `m_wdate` datetime NOT NULL COMMENT '등록일',
  `m_wip` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '등록아이피',
  `m_sms_perm` varchar(1) CHARACTER SET utf8 NOT NULL COMMENT '문자수신동의',
  `m_mail_perm` varchar(1) CHARACTER SET utf8 NOT NULL COMMENT '메일수신동의',
  `m_agreement` varchar(1) CHARACTER SET utf8 NOT NULL COMMENT '개인정보이용동의',
  `m_mdate` datetime NOT NULL COMMENT '최종수정일',
  `m_mip` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '최종아이피',
  `m_block_date` varchar(8) CHARACTER SET utf8 NOT NULL COMMENT '차단일자',
  `m_out_date` varchar(8) CHARACTER SET utf8 NOT NULL COMMENT '탈퇴일자',
  `m_signature` text CHARACTER SET utf8 NOT NULL,
  `m_recommend` varchar(255) CHARACTER SET utf8 NOT NULL,
  `m_point` int(11) NOT NULL DEFAULT '0',
  `m_today_login` datetime NOT NULL,
  `m_login_ip` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '마지막로그인 아이피',
  `org_id` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '소속기관코드',
  `m_skin` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT 'skin-blue' COMMENT '스킨',
  `m_lost_certify` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `m_excel` int(11) NOT NULL DEFAULT '0' COMMENT '엑셀보안다운로드',
  `m_exceldirect` int(11) NOT NULL DEFAULT '0' COMMENT '엑셀직접다운로드',
  `m_privacy` int(11) NOT NULL DEFAULT '0' COMMENT '개인정보보기',
  `m_cert_login` int(11) NOT NULL DEFAULT '0' COMMENT '공인인증서예외',
  `m_cert_mac` int(11) NOT NULL DEFAULT '0' COMMENT '맥예외',
  `m_login_once` int(11) NOT NULL DEFAULT '0' COMMENT '중복로그인예외',
  `m_cert_ip_enrolment` int(11) NOT NULL DEFAULT '0' COMMENT '수강신청IP검사',
  `m_cert_ip_class` int(11) NOT NULL DEFAULT '0' COMMENT '강의수강IP검사',
  `manager` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '담당자아이디'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 테이블의 덤프 데이터 `tb_user`
--

INSERT INTO `tb_user` (`m_id`, `stud_no`, `m_user_type`, `m_name`, `m_nick`, `m_reg`, `m_dn`, `m_password`, `m_birth`, `m_gender`, `m_mail`, `m_tel`, `m_htel`, `m_zipcode`, `m_address`, `m_address_desc`, `m_school_name`, `m_level_edu`, `m_graduation`, `m_request_path`, `m_level`, `m_filename`, `m_tempfilename`, `m_stat`, `m_wdate`, `m_wip`, `m_sms_perm`, `m_mail_perm`, `m_agreement`, `m_mdate`, `m_mip`, `m_block_date`, `m_out_date`, `m_signature`, `m_recommend`, `m_point`, `m_today_login`, `m_login_ip`, `org_id`, `m_skin`, `m_lost_certify`, `m_excel`, `m_exceldirect`, `m_privacy`, `m_cert_login`, `m_cert_mac`, `m_login_once`, `m_cert_ip_enrolment`, `m_cert_ip_class`, `manager`) VALUES
('admin', 'admin', 'A', 'NoName', '이관리', 'tT26M/q6EcZ+2nH8PYfyHw==', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '2020-01-12', 1, '1234', '1234', '', 0, '충북 청주시 상당구 1순환로 1202-2', '1111', '', 1, 0, 10031, 1, '634026500347202043.png', 'admin_20190821175901_6233.png', '1', '2018-04-10 14:05:44', '0', '0', '0', '0', '2020-02-01 17:42:36', '125.142.120.29', '', '', '', '', 100, '2020-02-27 09:45:38', '{__USER_IP}', '', 'yellow', NULL, 1, 0, 1, 0, 0, 0, 0, 0, ''),
('admin1', 'admin1', 'A', '관리투', '관리투', 'l53hzeqeXUoNDR0oeas/Rg==', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '2020-01-01', 1, 'xSXzrnipP9Wjd3si4NukeA==', 'lLuqi0OFfaJCimxD1HjI2w==', 'Pg2jrmpcd3ivgTDCryHMeA==', 4174, 'L6qFOvTfVbtaTT93LsRQ/glsWzsjsMpfyPwqcENjX7sHd1GP/R6UdXzdEX3tobZ7', 'qe75U33Yke93uV5Ioijo1A==', '', 0, 0, 0, 1, '', '', '1', '2020-01-11 20:52:24', '125.142.120.29', '1', '1', '1', '2020-01-19 18:43:35', '125.142.120.29', '', '', '', '', 0, '2020-02-01 15:26:31', '{__USER_IP}', '', 'skin-blue', NULL, 1, 1, 1, 1, 1, 0, 1, 1, ''),
('asdfasfd', 'asdfasfd', 'S', 'asdf', 'asdf', 'tT26M/q6EcZ+2nH8PYfyHw==', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '1992-10-10', 2, 'jvTjPalXCulZTr5EBT4qXg==', 'WnlTiZWYZkxneFXUXQLVQQ==', 'Pg2jrmpcd3ivgTDCryHMeA==', 0, 'L6qFOvTfVbtaTT93LsRQ/glsWzsjsMpfyPwqcENjX7sHd1GP/R6UdXzdEX3tobZ7', 'tngv08NYVu3TLQU3298VTw==', 'asdf', 1, 0, 10031, 1, '634026500347202043.png', 'asdfasfd_20190910203256_6324.png', '1', '2019-09-08 15:01:35', '192.168.123.50', '1', '1', '1', '2020-01-04 20:02:35', '125.142.120.29', '', '', '', '', 0, '0000-00-00 00:00:00', '', '1', 'blue', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('assit1', 'assit1', 'T', '조교', '조교1', 'tT26M/q6EcZ+2nH8PYfyHw==', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '', 1, 'xSXzrnipP9Wjd3si4NukeA==', 'tT26M/q6EcZ+2nH8PYfyHw==', 'Mq/899sDD4ucST/LMM7ygw==', 4174, 'L6qFOvTfVbtaTT93LsRQ/glsWzsjsMpfyPwqcENjX7sHd1GP/R6UdXzdEX3tobZ7', 'usYt4AXr/D05F6gq2asHSA==', '', 0, 0, 0, 1, '', '', '1', '2020-01-20 21:14:59', '125.142.120.29', '', '', '1', '2020-01-23 20:37:34', '125.142.120.29', '', '', '', '', 0, '0000-00-00 00:00:00', '', '', 'skin-blue', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('asteria', 'asteria', 'O', '이소연', '이이이', 'tT26M/q6EcZ+2nH8PYfyHw==', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '2020-01-01', 0, 'w4Ldnvfl9Fl0ymKEQRFUuA==', 'lLuqi0OFfaJCimxD1HjI2w==', 'lLuqi0OFfaJCimxD1HjI2w==', 7, 'L6qFOvTfVbtaTT93LsRQ/glsWzsjsMpfyPwqcENjX7sHd1GP/R6UdXzdEX3tobZ7', 'yF20jSwOtUG9n7qusvOwyQ==', 'asdf', 1, 0, 10031, 1, '', '', '0', '2019-10-02 16:20:05', '58.72.255.237', '1', '1', '1', '2020-02-01 15:37:22', '125.142.120.29', '', '', '', '', 0, '2019-12-03 10:31:10', '58.72.255.237', '1', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('bigale', 'bigale', 'O', '이원경', '이원경', '690925-1234567', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '1992-10-10', 1, 'xsticker@gmail.com', '02-123-1234', '010-9860-0526', 1453, '서울 도봉구 도봉로 500', '4층', '', 1, 0, 10031, 1, '', '', '1', '2019-10-02 10:36:27', '218.152.100.163', '1', '1', '1', '2020-01-04 18:08:22', '125.142.120.29', '', '', '', '', 0, '2020-02-02 12:50:55', '{__USER_IP}', '1', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('cjsekgml12', 'cjsekgml12', 'O', '천다희', '천다희', '', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '', 0, 'cjsekgml12@naver.com', '', '010-6664-3222', 3380, '서울 은평구 서오릉로4길 20-15', '402호', '', 0, 0, 0, 1, '', '', '1', '2019-10-07 10:08:14', '121.129.25.207', '1', '1', '1', '2020-01-04 17:45:17', '125.142.120.29', '', '', '', '', 0, '2019-12-02 10:22:47', '58.72.255.237', '1', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('gh3495', 'gh3495', 'O', '임호정', '임호정', '', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '', 0, 'hoqaz@naver.com', '', '01088817125', 3076, '서울 종로구 혜화로2길 10', '미래원격평생교육원', '', 0, 0, 0, 1, '', '', '1', '2019-10-07 10:20:33', '121.129.25.207', '1', '1', '1', '2019-12-30 14:31:07', '::1', '', '', '', '', 0, '2019-11-29 10:08:02', '58.72.255.237', '1', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('hackerslab5701', 'hackerslab5701', 'O', '장호현', '장호현', '', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '', 0, 'hackerslab5701@gmail.com', '', '010-9207-0719', 3925, '서울 마포구 월드컵북로 402', '908A', '', 0, 0, 0, 1, '', '', '1', '2019-10-15 13:54:59', '218.236.33.192', '1', '1', '1', '2019-10-15 14:33:58', '218.152.100.163', '', '', '', '', 0, '2019-11-29 14:12:04', '218.236.33.192', '3', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('hackerslabedu', 'hackerslabedu', 'O', '함경주', '함경주', '', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '19420625', 1, 'edu_hackerslab@daum.net', '', '010-3094-2480', 3925, '서울 마포구 월드컵북로 402', '908A', '', 2, 0, 10039, 1, '', '', '1', '2019-10-14 17:40:14', '218.236.33.192', '0', '1', '1', '2019-10-14 17:40:39', '218.152.100.163', '', '', '', '', 0, '2019-12-02 10:22:20', '218.236.33.192', '3', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('hmstudy', 'hmstudy', 'O', '해밀원격', '해밀원격', '', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '', 0, 'haemiledu@gmail.com', '', '01051388242', 3925, '서울 마포구 월드컵북로 400', '1003호', '', 0, 0, 0, 1, '', '', '0', '2019-10-02 16:03:42', '118.223.169.174', '1', '1', '1', '2019-10-02 16:05:13', '218.152.100.163', '', '', '', '', 0, '2019-12-04 09:15:09', '118.223.169.153', '2', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('prof', '', 'P', 'prof', 'prof', 'tT26M/q6EcZ+2nH8PYfyHw==', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '2020-01-27', 1, 'adf', '111', '010-1234-1234', 0, '충북 청주시 상당구 1순환로 1202-2', '1111', '', 1, 0, 10031, 1, '', '', '1', '2020-01-12 16:37:49', '125.142.120.29', '1', '1', '1', '2020-01-20 20:48:10', '125.142.120.29', '', '', '', '', 0, '2020-02-15 18:24:24', '{__USER_IP}', '', 'skin-blue', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('prof2', 'prof2', 'P', 'prof2', 'prof2', 'xagTCB08wlrw+dLulkYH3w==', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '', 0, 'tT26M/q6EcZ+2nH8PYfyHw==', 'tT26M/q6EcZ+2nH8PYfyHw==', 'Bh4gKaAq3x47exWfic/gaw==', 0, 'L6qFOvTfVbtaTT93LsRQ/glsWzsjsMpfyPwqcENjX7sHd1GP/R6UdXzdEX3tobZ7', 'TakUK+rReI4BbFB0SBA3+A==', '', 0, 0, 0, 1, '', '', '1', '2020-01-12 16:43:20', '125.142.120.29', '', '', '1', '2020-01-20 20:48:28', '125.142.120.29', '', '', '', '', 0, '0000-00-00 00:00:00', '', '', 'skin-blue', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('stud', 'stud', 'S', '윤미래', '미래로', 'tT26M/q6EcZ+2nH8PYfyHw==', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '2017-01-05', 1, 'bigale@naver.com', '021-2312-3412', '010-1234-1234', 0, '충북 청주시 서원구 1순환로 627', '111111', '21', 1, 10021, 10031, 1, '20180623_bottom_logo.PNG', 'stud_20200104200531_6124.PNG', '1', '2018-04-10 14:33:18', '::1', '1', '1', '1', '2020-01-04 20:05:31', '125.142.120.29', '', '', '', '', 0, '2020-02-27 15:39:00', '{__USER_IP}', '111', 'blue', '074dbe51f51a206179449a9eccfed8dc *C9F302C4E84CEBC7EB66211A0077BEC3A0E8661B', 0, 0, 0, 0, 0, 0, 0, 0, ''),
('student', '', 'S', '이학생', '이학생', 'l53hzeqeXUoNDR0oeas/Rg==', '', 'YOA/eY7ndclJ+y9qnoIy2/gKq3x/8mbZQfBruFUnC4U0CpW5EKmaGa1DCc18GYM6v3K4lBlcG90S4TcE356bjw==', '2020-01-04', 1, 'xSXzrnipP9Wjd3si4NukeA==', 'tHrJi/MNt4u1u+y3FNk4jQ==', 'nBiy1C7C2EJna2RgbE+FOw==', 0, 'L6qFOvTfVbtaTT93LsRQ/glsWzsjsMpfyPwqcENjX7sHd1GP/R6UdXzdEX3tobZ7', 'Oy8e1dVsPX8dsy0/SdugkA==', 'asdf', 1, 0, 10031, 1, '', '', '1', '2020-01-04 19:56:46', '125.142.120.29', '1', '1', '1', '0000-00-00 00:00:00', '', '', '', '', '', 0, '0000-00-00 00:00:00', '', '', 'skin-blue', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('test03', 'test03', 'O', 'test3', 'test3', '', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '', 0, 'test3@test.test', '', '0101234566', 28787, '충북 청주시 상당구 1순환로 1202-2', '', '', 0, 0, 0, 0, '', '', '0', '2019-10-02 10:56:51', '218.152.100.163', '1', '1', '1', '2019-10-02 10:56:51', '', '', '', '', '', 0, '0000-00-00 00:00:00', '', '', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('testid', 'testid', 'O', 'test', 'test', '', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '', 0, 'test@test.test', '', '01121212121', 7628, '서울 강서구 남부순환로11가길 1', '11', '', 0, 0, 0, 1, '', '', '0', '2019-10-02 10:53:18', '218.152.100.163', '1', '1', '1', '2019-10-02 11:01:24', '218.152.100.163', '', '', '', '', 0, '0000-00-00 00:00:00', '', '', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('testid1', 'testid1', 'O', 'test1', 'test1', '', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '', 0, 'test1@test.test', '', '01121212121', 7628, '서울 강서구 남부순환로11가길 1', '11', '', 0, 0, 0, 0, '', '', '0', '2019-10-02 10:55:52', '218.152.100.163', '1', '1', '1', '2019-10-02 10:55:52', '', '', '', '', '', 0, '0000-00-00 00:00:00', '', '', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, ''),
('user', 'user', 'O', '사용자', '', '', '', '1ARVn2Auq2/WAqx2gNrL+q3RNjAzXpUfCXrzkA6d4Xa22yhRLy4AC50E+6UTPoscbo31nbOoq51gvkuXzJ6B2w==', '1992-10-10', 1, 'ci2019006@mbcjob.com', '021-2311-1111', '010-1234-1111', 48060, '부산 해운대구 APEC로 17', '1111', '1', 2, 0, 10031, 10, 'back.PNG', 'user_20190901135213_1293.PNG', '1', '2019-09-01 13:39:04', '192.168.123.50', '1', '1', '1', '2019-09-30 16:37:52', '192.168.123.50', '', '', '', '', 0, '2019-12-29 18:47:42', '125.142.120.29', '1', 'green', NULL, 0, 0, 0, 0, 0, 0, 0, 0, '');

--
-- 덤프된 테이블의 인덱스
--

--
-- 테이블의 인덱스 `tb_user`
--
ALTER TABLE `tb_user`
  ADD PRIMARY KEY (`m_id`);
COMMIT;

