CREATE TABLE `bs_Book` (
  `booknum` int(11) NOT NULL auto_increment,
  `id` varchar(20) default NULL,
  `seatnum` int(11) default NULL,
  PRIMARY KEY  (`booknum`)
) ENGINE=MyISAM  DEFAULT CHARSET=euckr;

CREATE TABLE `bs_Member` (
  `id` varchar(20) NOT NULL,
  `pwd` varchar(20) default NULL,
  `name` varchar(20) default NULL,
  `age` int(10) unsigned default NULL,
  `sex` varchar(20) default NULL,
  `tel` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;

CREATE TABLE `bs_Seat` (
  `seatnum` int(10) unsigned NOT NULL,
  `grade` varchar(2) default NULL,
  `isbooked` varchar(2) default NULL,
  PRIMARY KEY  (`seatnum`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;

-- 
-- Å×À̺íÀÇ ´ýÇÁ µ¥ÀÌÅÍ `bs_Seat`
-- 

INSERT INTO `bs_Seat` (`seatnum`, `grade`, `isbooked`) VALUES 
(1, 'R', 'O'),
(2, 'R', 'O'),
(3, 'R', 'O'),
(4, 'R', 'O'),
(5, 'R', 'O'),
(6, 'R', 'O'),
(7, 'R', 'X'),
(8, 'R', 'X'),
(9, 'S', 'X'),
(10, 'R', 'X'),
(11, 'R', 'O'),
(12, 'R', 'O'),
(13, 'R', 'X'),
(14, 'R', 'X'),
(15, 'R', 'X'),
(16, 'R', 'X'),
(17, 'R', 'X'),
(18, 'R', 'X'),
(19, 'R', 'X'),
(20, 'R', 'X'),
(21, 'R', 'X'),
(22, 'R', 'X'),
(23, 'R', 'X'),
(24, 'R', 'X'),
(25, 'R', 'X'),
(26, 'R', 'X'),
(27, 'R', 'X'),
(28, 'R', 'X'),
(29, 'R', 'X'),
(30, 'R', 'X'),
(31, 'S', 'O'),
(32, 'S', 'O'),
(33, 'S', 'X'),
(34, 'S', 'X'),
(35, 'S', 'X'),
(36, 'S', 'X'),
(37, 'S', 'X'),
(38, 'S', 'X'),
(39, 'S', 'X'),
(40, 'S', 'X'),
(41, 'S', 'X'),
(42, 'S', 'X'),
(43, 'S', 'X'),
(44, 'S', 'X'),
(45, 'S', 'X'),
(46, 'S', 'X'),
(47, 'S', 'X'),
(48, 'S', 'X'),
(49, 'S', 'X'),
(50, 'S', 'X'),
(51, 'S', 'X'),
(52, 'S', 'X'),
(53, 'S', 'X'),
(54, 'S', 'X'),
(55, 'S', 'X'),
(56, 'S', 'X'),
(57, 'S', 'X'),
(58, 'S', 'X'),
(59, 'S', 'X'),
(60, 'S', 'X'),
(61, 'A', 'X'),
(62, 'A', 'X'),
(63, 'A', 'X'),
(64, 'A', 'X'),
(65, 'A', 'X'),
(66, 'A', 'X'),
(67, 'A', 'X'),
(68, 'A', 'X'),
(69, 'A', 'X'),
(70, 'A', 'X'),
(71, 'A', 'X'),
(72, 'A', 'X'),
(73, 'A', 'X'),
(74, 'A', 'X'),
(75, 'A', 'X'),
(76, 'A', 'X'),
(77, 'A', 'X'),
(78, 'A', 'X'),
(79, 'A', 'X'),
(80, 'A', 'X'),
(81, 'A', 'X'),
(82, 'A', 'X'),
(83, 'A', 'X'),
(84, 'A', 'X'),
(85, 'A', 'X'),
(86, 'A', 'X'),
(87, 'A', 'X'),
(88, 'A', 'X'),
(89, 'A', 'X'),
(90, 'A', 'X');