ad11

http://comeo32.eobiz.co.kr

Mar 24th, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.78 KB | None | 0 0
  1. -- MySQL dump 10.11
  2. --
  3. -- Host: localhost Database: eo32
  4. -- ------------------------------------------------------
  5. -- Server version 5.0.37
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `wiz_member`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `wiz_member`;
  23. CREATE TABLE `wiz_member` (
  24. `idx` int(10) NOT NULL auto_increment,
  25. `id` varchar(20) NOT NULL default '',
  26. `passwd` varchar(20) default NULL,
  27. `name` varchar(20) default NULL,
  28. `photo` varchar(25) default NULL,
  29. `icon` varchar(30) default NULL,
  30. `nick` varchar(20) default NULL,
  31. `resno` varchar(14) default NULL,
  32. `email` varchar(50) default NULL,
  33. `tphone` varchar(14) default NULL,
  34. `hphone` varchar(14) default NULL,
  35. `comtel` varchar(14) default NULL,
  36. `homepage` varchar(255) default NULL,
  37. `post` varchar(7) default NULL,
  38. `address1` varchar(255) default NULL,
  39. `address2` varchar(255) default NULL,
  40. `reemail` enum('Y','N') default NULL,
  41. `resms` enum('Y','N') default NULL,
  42. `birthday` varchar(10) default NULL,
  43. `bgubun` char(4) default NULL,
  44. `marriage` char(4) default NULL,
  45. `memorial` varchar(10) default NULL,
  46. `scholarship` varchar(30) default NULL,
  47. `job` varchar(30) default NULL,
  48. `income` varchar(30) default NULL,
  49. `car` char(6) default NULL,
  50. `hobby` varchar(60) default NULL,
  51. `consph` varchar(80) default NULL,
  52. `conprd` varchar(80) default NULL,
  53. `level` varchar(10) default NULL,
  54. `recom` varchar(20) default NULL,
  55. `visit` int(5) default NULL,
  56. `visit_time` datetime default NULL,
  57. `intro` mediumtext,
  58. `memo` mediumtext,
  59. `addinfo1` mediumtext,
  60. `addinfo2` mediumtext,
  61. `addinfo3` mediumtext,
  62. `addinfo4` mediumtext,
  63. `addinfo5` mediumtext,
  64. `wdate` datetime default NULL,
  65. PRIMARY KEY (`idx`),
  66. UNIQUE KEY `id` (`id`)
  67. ) ENGINE=MyISAM AUTO_INCREMENT=137 DEFAULT CHARSET=euckr;
  68.  
  69. --
  70. -- Dumping data for table `wiz_member`
  71. --
  72.  
  73. LOCK TABLES `wiz_member` WRITE;
  74. /*!40000 ALTER TABLE `wiz_member` DISABLE KEYS */;
  75. INSERT INTO `wiz_member` VALUES (75,'test','test','테스트','test.jpg','test_icon.gif','','761001-1000004','test@test.com','02-2057-3827','000-0000-0000','--','','137-890','서울 서초구 양재1동 ','92-1번지 2층','Y','Y','-0-0','','','-0-0','','','','','',',','','3','',62,'2010-09-28 15:28:02','','','','','','','','2009-06-16 17:57:34'),(92,'js1004','js7752','강선영','','','','650110-2789918','jjss7752@naver.com','070-8272-7799','010-8636-0691','--','','415-020','경기 김포시 걸포동 ','4-46','Y','Y','--','','','--','','','','','',',','','1','js7752',2,'2010-07-15 16:08:54','','','','','','','','2010-07-15 15:56:54'),(68,'test2','test2','테스트2','',NULL,'','761001-1000005','keii@anywiz.co.kr','00-0000-0000','000-0000-0000','--','','608-843','부산 남구 우암2동 ','123','','','-00-00','','','-00-00','','','','','',',','','3','',8,'2009-06-16 17:09:21','','','','','','','','2009-02-11 10:27:44'),(77,'jin007','123123','박멋진','','','','800000-0000000','pas@dlakfj.com','032-111-1111','010-1111-1111','--','','402-040','인천 남구 학익동 ','706-7','Y','Y','-0-0','','','-0-0','','','','','',',','','2','parkhjgood',7,'2010-07-15 09:36:42','','','','','','','','2010-06-28 15:31:57'),(78,'js7752','js1004','주종성','','','','621126-1789916','jjss7752@naver.com','031-986-2991','010-8014-7752','--','','415-020','경기 김포시 걸포동 ','4-323','Y','Y','-0-0','','','-0-0','','','','','',',','','2','jin007',3,'2010-07-19 16:37:57','','','','','','','','2010-07-09 11:03:29'),(79,'passkomc','3007','고명철','','','','630123-1951212','passkomc@naver.com','064-752-9587','010-8458-0012','--','','690-825','제주 제주시 이도2동 ','1084 - 4 미건빌라 301호','Y','N','--','','','--','','','','','',',','','1','',0,'0000-00-00 00:00:00','','','','','','','','2010-07-13 11:36:43'),(90,'cch609','hope812','최춘환','','','','560609-1659614','cch609@paran.com','031-984-3329','010-5128-1525','--','','415-753','경기 김포시 풍무동 양도마을서해아파트 ','209-1103호','Y','Y','--','','','--','','','','','',',','','1','',7,'2012-06-04 13:20:32','','','','','','','','2010-07-14 11:25:18'),(91,'parkhjgood','123123','박현진','','','','800116-1150211','asd@asdf.com','123-123-123','123-123-123','--','','135-875','서울 강남구 삼성2동 ','123','Y','Y','--','','','--','','','','','',',','','1','jin007',3,'2010-07-15 10:16:00','','','','','','','','2010-07-14 11:25:41'),(93,'son9622','son96229622','김명손','','','','610805-2224511','gold2990@hanmail.net','010-7276-9622','010-7276-9622','--','','415-030','경기 김포시 북변동 ','북변연립 가동 203호','N','Y','-0-0','','','-0-0','','','','','',',','','1','',0,'0000-00-00 00:00:00','','','','','','','','2010-07-22 15:44:18'),(94,'josun123','jo9900',' 김헤미','','','','720216-2379810','young4638@naver.com','02-563-5330','010-5050-6350','--','','135-839','서울 강남구 대치4동 ','890-59 롯데골드로즈2차1515호','Y','N','--','','','--','','','','','',',','','1','친구',2,'2010-08-04 18:10:46','','','','','','','','2010-07-30 17:38:47'),(95,'mysook5630','sd5630','임영덕','','','','590822-1548015','mysook5630@hammail.net','063-841-7030','010-8359-7710','--','','570-122','전북 익산시 중앙동2가 ','68번지','Y','N','--','','','--','','','','','',',','','1','',0,'0000-00-00 00:00:00','','','','','','','','2010-08-03 15:41:18'),(96,'jinimom702','khj0273','김현정','','','','690120-2046316','jinimom702@hanmail.net','010-4287-1218','010-4287-1218','--','','400-833','인천 중구 운서동 ','금호2단지206동501호','Y','Y','-0-0','','','-0-0','','','','','',',','','1','',3,'2010-08-13 10:58:20','','','','','','','','2010-08-09 12:34:21'),(97,'cage888','ca5858','백기윤','','','','851002-1065212','cage888@hanmail.net','02-6267-5323','010-7204-1217','--','','423-741','경기 광명시 철산4동 도덕파크타운 ','205동 2003호','N','Y','--','','','--','','','','','',',','','1','',6,'2011-02-11 16:21:12','','','','','','','','2010-09-21 07:39:37'),(98,'hongyuli','h1987512','홍종율','','','','410102-1011129','hongyuli@naver.com','02-3486-5977','010-9600-5977','--','','156-095','서울 동작구 사당5동 ','1138번지 삼호그린아파트 101동115호','Y','Y','--','','','--','','','','','',',','','1','',2,'2010-09-21 08:03:53','','','','','','','','2010-09-21 07:51:25'),(99,'hyh','1097','황영현','','','','501020-1005919','hwangyh-0@hanmail.net','02-2648-0414','010-6680-0414','--','','158-070','서울 양천구 신정동','목동아파트 906 - 905','Y','Y','--','','','--','','','','','',',','','1','',3,'2010-10-11 15:42:14','','','','','','','','2010-10-11 14:56:26'),(100,'pakkhoo','gats638o','박경호','','','','540130-1797816','pakkhad@hanmail.net','031-636-6166','010-2669-3446','--','','467-821','경기 이천시 호법면 매곡리 ','914 총회신학교 사무처','N','N','--','','','--','','','','','',',','','1','',1,'2010-11-01 11:31:42','','','','','','','','2010-11-01 11:31:08'),(101,'6600seoul','seoul6600','조성자','','','','671205-2411618','seoul6600@yahoo.co.kr','02-2624-1999','010-7725-1213','--','','153-803','서울 금천구 가산동 ','371-50 에이스하이엔드3차 107','N','N','--','','','--','','','','','',',','','1','최춘환',1,'2010-11-10 10:54:48','','','','','','','','2010-11-10 10:54:02'),(102,'catos530','sebal530','오세영','','','','730210-1621728','catos530@nate.com','02-485-3551','016-704-6018','--','','134-030','서울 강동구 성내동 ','423번지 3층 302호','N','N','--','','','--','','','','','',',','','1','',10,'2010-12-30 05:02:25','','','','','','','','2010-11-28 22:47:03'),(103,'jlchjs','bbb777','이희숙','','','','640118-2473710','jlchjs@hanmail.net','042-583-7282','010-7586-7282','--','','301-140','대전 중구 유천동 ','186-5 2층','Y','Y','--','','','--','','','','','',',','','1','',1,'2010-12-03 11:26:56','','','','','','','','2010-12-03 11:26:11'),(104,'candymiin','04370437','정유정','','','','700503-2030326','candymiin@nate.com','02-3486-5547','010-9043-0540','--','','137-070','서울 서초구 서초동 ','1641-7 태영빌딩 3층 ','Y','Y','--','','','--','','','','','',',','','1','',0,'0000-00-00 00:00:00','','','','','','','','2010-12-11 10:26:37'),(105,'ksr0824','s164501','김선란','','','','800824-2012210','ksr0824@hanmail.net','070-7137-9714','010-2331-0091','--','','681-300','울산 중구 성안동 ','514-11 번지 2층 조상철 ','Y','Y','--','','','--','','','','','',',','','1','나',1,'2010-12-14 15:21:25','','','','','','','','2010-12-14 15:20:02'),(106,'joisgood','jois1111','조미정','','','','710701-2894320','joisgood@hanmail.net','010-8705-8556','010-8705-8556','--','','630-783','경남 마산시 내서읍 삼계리 대동이미지1차아파트 ','105동1602','Y','Y','--','','','--','','','','','',',','','1','',4,'2012-01-25 21:19:39','','','','','','','','2011-01-11 15:26:32'),(107,'nine7h','mean77','김채원','','','','771014-2120125','9kims@hanmail.net','010-4852-7786','010-4852-7786','--','','626-779','경남 양산시 삼호동 그린빌아파트 ','109-902','N','Y','--','','','--','','','','','',',','','1','',4,'2011-03-14 15:43:01','','','','','','','','2011-01-28 16:46:11'),(108,'harin511','hugh511','박매영','','','','620619-2480616','parkmaeyoung@naver.com','031-815-9870','010-5311-9807','--','','410-907','경기 고양시 일산동구 백석2동 브라운스톤오피스텔 ','101-1112','Y','Y','--','','','--','','','','','',',','','1','',3,'2011-07-07 17:24:46','','','','','','','','2011-02-18 18:37:43'),(109,'jasonpark','gogos','박광일','','','','710827-1052711','feelart@lycos.co.kr','070-5050-7753','011-456-4552','--','','140-835','서울 용산구 용산동2가 ','5-758','N','N','--','','','--','','','','','',',','','1','',1,'2011-03-08 18:12:15','','','','','','','','2011-03-08 18:12:02'),(110,'woni930','jwy0202','양지원','','','','750930-2005410','jwy0202@nate.com','070-8119-4219','011-9028-4219','--','','135-931','서울 강남구 역삼1동 ','812-16안드레아 301호','Y','N','--','','','--','','','','','',',','','1','',2,'2011-03-26 10:02:09','','','','','','','','2011-03-23 17:13:41'),(111,'rlatpdus505','rlatpdus','김세연','','','','980205-2540329','ksy980205@hanmail.net','031-987-0254','010-6603-0254','--','','415-745','경기 김포시 장기동 전원마을월드4차아파트 ','206동 505호','Y','Y','--','','','--','','','','','',',','','1','',1,'2011-03-27 19:21:51','','','','','','','','2011-03-27 19:21:21'),(112,'mjkim774','mj7754','김명자','','','','771223-2041732','mjkim774@hanmail.net','02-385-5816','011-386-6171','--','','122-863','서울 은평구 불광2동 ','369-16 단독','Y','N','--','','','--','','','','','',',','','1','',3,'2011-04-01 17:59:13','','','','','','','','2011-03-31 09:14:43'),(113,'philopark','park373','박영철','','','','560202-1659617','philopark@korea.kr','061-350-5804','010-9440-1005','--','','513-874','전남 영광군 법성면 신장리 ','774','Y','Y','--','','','--','','','','','',',','','1','',0,'0000-00-00 00:00:00','','','','','','','','2011-03-31 10:37:06'),(114,'rmit75','monash75','김충기','','','','410319-1406419','rmit77@naver.com','010-5180-3868','010-5180-3868','--','','423-010','경기 광명시 광명동 ','43-48 2층','N','Y','--','','','--','','','','','',',','','1','',3,'2011-04-12 17:24:08','','','','','','','','2011-04-09 03:30:23'),(115,'k90100939','k9010093','김동욱','','','','600419-1110920','kimdu@ewp.co.kr','052-271-7452','010-7430-1222','--','','680-794','울산 남구 야음동 신정현대홈타운아파트 ','202동 1404호','Y','N','--','','','--','','','','','',',','','1','',2,'2011-05-16 09:12:55','','','','','','','','2011-05-15 10:56:21'),(116,'meunjae','mm0538mm','이은재','','','','610503-1635015','meunjae@gmail.com','031-328-4111','010-6396-0538','--','','456-844','경기 안성시 미양면 구례리 ','31번지','Y','Y','--','','','--','','','','','',',','','1','',6,'2012-01-15 22:29:28','','','','','','','','2011-06-06 12:05:29'),(117,'dltmf00000','lts6712','윤형숙','','','','731110-2449119','dltmf1973@naver.com','02-3013-6713','010-4720-6713','--','','134-050','서울 강동구 암사동 ','419번지 한솔아파트 104동 1004호','Y','Y','--','','','--','','','','','',',','','1','',4,'2012-05-22 14:07:45','','','','','','','','2011-06-21 01:45:36'),(118,'simpeach','tla645100','심정원','','','','591103-2914217','simpeach@hanmail.net','052-234-7973','010-2672-1932','--','','682-060','울산 동구 전하동 ','전하 푸르지오 106동 502호','N','N','-0-0','','','-0-0','','','','','',',','','1','',4,'2012-06-25 12:02:51','','','','','','','','2011-06-28 09:29:18'),(119,'ksj3124258','ksj3064','김선정','','','','800825-2075123','ksj3124258@naver.com','010-6864-4254','010-6864-4254','--','','120-782','서울 서대문구 홍제1동 한양아파트 ','104-510','Y','N','--','','','--','','','','','',',','','1','',1,'2011-06-28 22:42:30','','','','','','','','2011-06-28 22:41:42'),(120,'9191yok','amen8001','육명애','','','','560825-2482111','9191yok90@gmail.com','031-824-0992','010-8960-0991','--','','482-831','경기 양주시 백석읍 가업리 ','99-1 세아청솔아파트 301동 1204호','Y','N','--','','','--','','','','','',',','','1','',1,'2011-07-07 08:35:35','','','','','','','','2011-07-07 08:33:25'),(121,'simple4312','ys8741','최용섭','','','','560102-1144010','simple4312@paran.com','032-322-8741','016-308-8741','--','','420-728','경기 부천시 원미구 중3동 중흥마을아파트 ','신동아아파트617동2103호','Y','Y','--','','','--','','','','','',',','','1','',1,'2011-07-07 09:13:14','','','','','','','','2011-07-07 09:12:23'),(122,'ohdari5','aa7108','오교숙','','','','710717-2155216','darphin5@hanmail.net','032-421-6563','011-346-7108','--','','405-785','인천 남동구 도림동 주공아파트 ','629-1번지102동1502호','N','Y','--','','','--','','','','','',',','','1','네이버',2,'2011-07-12 19:06:01','','','','','','','','2011-07-10 10:09:10'),(123,'leebk3611','1234qwer','이보경','','','','780804-2674717','leebk3611@naver.com','010-9631-2025','010-9631-2025','--','','121-881','서울 마포구 창전동 ','34-4번지, 창전빌라 301호','N','N','--','','','--','','','','','',',','','1','',1,'2011-07-22 16:30:37','','','','','','','','2011-07-22 16:30:29'),(124,'jcwithme','parsons','류신애','','','','800219-2100914','jcwithshinae012@hotmail.com','010-9870-4713','010-9870-4713','--','','140-778','서울 용산구 한강로3가 한강대우트럼프월드3차 ','102동 2403호','N','Y','--','','','--','','','','','',',','','1','',4,'2011-08-16 23:19:52','','','','','','','','2011-08-06 16:34:34'),(125,'sjin21','919261bj','배병준','','','','710406-1113617','sjin21@nate.com','055-321-7284','010-6384-4563','--','','621-752','경남 김해시 어방동 대우유토피아아파트 ','101동 407호','Y','Y','--','','','--','','','','','',',','','1','',2,'2012-01-16 10:05:18','','','','','','','','2011-08-15 21:20:55'),(126,'paul5555','3132qaz','오용석','','','','491217-1031128','paul55555@daum.net','02-583-8585','011-389-5555','--','','131-140','서울 중랑구 묵동 ','122-140 세종빌라트202','Y','Y','--','','','--','','','','','',',','','1','최춘환',0,'0000-00-00 00:00:00','','','','','','','','2011-11-14 05:20:50'),(127,'amy77','0720','신혜숙','','','','771213-2074810','amy7707@naver.com','070-7582-7142','010-3305-3620','--','','410-830','경기 고양시 일산동구 정발산동 ','1346-10번지 3층','N','N','--','','','--','','','','','',',','','1','',2,'2011-12-12 11:03:31','','','','','','','','2011-12-09 19:01:28'),(128,'secc2004','ecc140885','주길자','','','','381106-2042111','secc2004@empal.com','11-111-11111','111-1111-111','--','','120-711','서울 서대문구 연희동 국민건강보험공단서대문지사 ','12-11','Y','Y','--','','','--','','','','','',',','','1','주길자',2,'2012-06-30 14:18:33','','','','','','','','2012-01-25 02:28:01'),(129,'munjjac','munchul','장문철','','','','840919-1058115','munjjac@hanmail.net','031-123-1234','010-8797-2853','--','','429-717','경기 시흥시 대야동 청구아파트 ','104동 203호','N','N','--','','','--','','','','','',',','','1','',1,'2012-04-08 15:17:03','','','','','','','','2012-04-08 15:16:54'),(130,'seann4','dnlsld','김기혜','','','','570120-2067921','seann4@dmeamwiz.com','031-205-2085','010-6363-7855','--','','445-984','경기 화성시 반월동 신영통현대아파트 ','308동301호','N','Y','-0-0','','','-0-0','','','','','',',','','1','',4,'2012-05-10 19:43:52','','','','','','','','2012-04-21 11:31:53'),(131,'ansdudtnr','s121300','문영숙','','','','781225-2552518','rubbiys@hanmail.net','010-9237-7896','010-9237-7896','--','','482-707','경기 양주시 덕정동 주공1단지아파트 ','103동603호','Y','Y','--','','','--','','','','','',',','','1','',0,'0000-00-00 00:00:00','','','','','','','','2012-04-21 20:44:32'),(132,'gratiarhee','gratia1128','이정례','','','','541215-2163217','gratiarhee@hanmail.net','070-8248-6615','010-5348-4454','--','','429-902','경기 시흥시 은행동 대우3차아파트 ','304-1903','Y','Y','-0-0','','','-0-0','','','','','',',','','1','시흥푸른동물병원',1,'2012-06-01 12:55:32','','원장님의 관심과 배려에 감사드립니다. 저희 회사의 관계회사는 올 6월 대톨령상을 수상하였습니다.\r\n더욱 내실있고 실뢰받는 회사로 거듭나겠습니다. 감사합니다.','','','','','','2012-05-31 14:00:32'),(133,'mina713','pc8810pc','성미나','','','','821013-2149125','mina713@nate.com','032-461-6666','010-7533-8814','--','','405-250','인천 남동구 장수동 ','792-4 롯데삼강남인천','Y','Y','-0-0','','','-0-0','','','','','',',','','1','',1,'2012-06-19 04:50:46','','회원가입을 진심으로 환영합니다. 저희회사의 관계회사가 올6월 대9통령상을 수상하였습니다.\r\n이를 자축하고자 합니다. 대푝 할인을 적용할 예정이오니 상품선정후 연락주시기 바랍니다.\r\n감사합니다.','','','','','','2012-06-19 04:50:23'),(134,'chungmong','jhy0829','정현유','','','','760711-1636710','chungmong@naver.com','010-2624-4216','010-2624-4216','--','','121-869','서울 마포구 연남동 ','504-39','Y','Y','--','','','--','','','','','',',','','1','',2,'2012-06-30 14:15:31','','','','','','','','2012-06-30 03:42:41'),(135,'domina','ch4499','성미란','','','','180309-2774817','munni@korea.com','031-985-0181','011-758-0181','--','','415-710','경기 김포시 감정동 효성아파트 ','103동 604호','N','N','-0-0','','','-0-0','','','','','',',','','1','',4,'2012-07-05 07:56:42','','','','','','','','2012-06-30 09:20:10'),(136,'nefertary85','4fkdgownj','공성빈','','','','850920-2100911','nefertary85@naver.com','010-5165-0933','010-5165-0933','--','','645-759','경남 진해시 용원동 일신-님아파트 ','102동 1104호','N','Y','--','','','--','','','','','',',','','1','',1,'2012-07-04 13:01:52','','','','','','','','2012-07-04 12:49:59');
  76. /*!40000 ALTER TABLE `wiz_member` ENABLE KEYS */;
  77. UNLOCK TABLES;
  78. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  79.  
  80. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  81. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  82. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  83. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  84. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  85. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  86. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  87.  
  88. -- Dump completed on 2012-07-06 11:54:16
Add Comment
Please, Sign In to add comment