-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 28, 2006 at 10:57 AM
-- Server version: 3.23.58
-- PHP Version: 4.2.2
-- 
-- Database: `member`
-- 

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

-- 
-- Table structure for table `comm_memb`
-- 

CREATE TABLE `comm_memb` (
  `ccode` varchar(6) NOT NULL default '',
  `mcode` varchar(4) NOT NULL default '',
  `chair` enum('N','Y') NOT NULL default 'N'
) TYPE=MyISAM;

-- 
-- Dumping data for table `comm_memb`
-- 

INSERT INTO `comm_memb` VALUES ('PAC', '8', 'Y');
INSERT INTO `comm_memb` VALUES ('PAC', '15', 'N');
INSERT INTO `comm_memb` VALUES ('PAC', '100', 'N');
INSERT INTO `comm_memb` VALUES ('PAC', '68', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '93', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '92', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '79', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '73', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '72', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '64', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '50', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '5', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '25', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '16', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '120', 'N');
INSERT INTO `comm_memb` VALUES ('sub1', '105', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '83', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '71', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '43', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '124', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '113', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '101', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '126', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '131', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '132', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '135', 'N');
INSERT INTO `comm_memb` VALUES ('sub2', '139', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '99', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '89', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '88', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '75', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '55', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '42', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '41', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '38', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '35', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '3', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '15', 'N');
INSERT INTO `comm_memb` VALUES ('sub3', '129', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '31', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '21', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '19', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '14', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '12', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '58', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '60', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '70', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '91', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '108', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '111', 'N');
INSERT INTO `comm_memb` VALUES ('sub4', '134', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '1', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '9', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '10', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '20', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '34', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '48', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '53', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '85', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '97', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '107', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '112', 'N');
INSERT INTO `comm_memb` VALUES ('sub5', '127', 'N');
INSERT INTO `comm_memb` VALUES ('PAC', '120', 'N');
INSERT INTO `comm_memb` VALUES ('PAC', '102', 'N');