cqKhbj4W

1- Table structure for table board_member
2--
3
4DROP TABLE IF EXISTS board_member;
5SET @saved_cs_client     = @@character_set_client;
6SET character_set_client = utf8;
7CREATE TABLE board_member (
8  member_srl bigint(11) NOT NULL,
9  user_id varchar(80) NOT NULL,
10  email_address varchar(250) NOT NULL,
11  password varchar(60) NOT NULL,
12  email_id varchar(80) NOT NULL,
13  email_host varchar(160) default NULL,
14  user_name varchar(40) NOT NULL,
15  nick_name varchar(40) NOT NULL,
16  find_account_question bigint(11) default NULL,
17  find_account_answer varchar(250) default NULL,
18  homepage varchar(250) default NULL,
19  blog varchar(250) default NULL,
20  birthday char(8) default NULL,
21  allow_mailing char(1) NOT NULL default 'Y',
22  allow_message char(1) NOT NULL default 'Y',
23  denied char(1) default 'N',
24  limit_date varchar(14) default NULL,
25  regdate varchar(14) default NULL,
26  last_login varchar(14) default NULL,
27  change_password_date varchar(14) default NULL,
28  is_admin char(1) default 'N',
29  description text,
30  extra_vars text,
31  list_order bigint(11) NOT NULL,
32  PRIMARY KEY  (member_srl),
33  UNIQUE KEY unique_user_id (user_id),
34  UNIQUE KEY unique_email_address (email_address),
35  UNIQUE KEY unique_nick_name (nick_name),
36  KEY idx_email_host (email_host),
37  KEY idx_allow_mailing (allow_mailing),
38  KEY idx_is_denied (denied),
39  KEY idx_regdate (regdate),
40  KEY idx_last_login (last_login),
41  KEY idx_is_admin (is_admin),
42  KEY idx_list_order (list_order)
43) ENGINE=MyISAM DEFAULT CHARSET=utf8;
44SET character_set_client = @saved_cs_client;
45
46--
47-- Dumping data for table board_member
48--
49
50LOCK TABLES board_member WRITE;
51/*!40000 ALTER TABLE board_member DISABLE KEYS */;
52INSERT INTO board_member VALUES (4,'admin','master@anyang-fl.hs.kr','ab46d118273b697ca29bce2c0ec49f96','master','anyang-fl.hs.kr','admin','관리자',NULL,NULL,'','',NULL,'N','Y','N',NULL,'20140219155336','20140219160033','20140219155336','Y',NULL,NULL,-4),(105,'master','jsking78@naver.com','ab46d118273b697ca29bce2c0ec49f96','jsking78','naver.com','입학홍보부','입학홍보부',1,'ㅇ','','','','N','Y','N','','20140219160130','20150827094325','20140219160130','Y','','O:8:\"stdClass\":2:{s:15:\"xe_validator_id\";s:20:\"modules/member/tpl/1\";s:14:\"reset_password\";s:10:\"com0815edu\";}',-105),(120,'hsy122','hsy122@hanmail.net','502d4c25dee250befa232c0a400e5c6b','hsy122','hanmail.net','입학홍보','입학홍보',3,'11111','','',NULL,'N','Y','N','','20140313134704','20141027142728','20140313134704','N',NULL,'O:8:\"stdClass\":2:{s:15:\"xe_validator_id\";s:20:\"modules/member/tpl/1\";s:8:\"password\";s:9:\"hunju0826\";}',-120);
53/*!40000 ALTER TABLE board_member ENABLE KEYS */;
54UNLOCK TABLES