CREATE TABLE IF NOT EXISTS `tb_payment_card` (
`no` int(11) NOT NULL auto_increment,
`ord_idx` varchar(30) NOT NULL default '1' COMMENT '주문번호',
`res_cd` varchar(4) NOT NULL,
`res_msg` varchar(255) NOT NULL,
`tno` varchar(30) NOT NULL COMMENT '거래번호',
`cms_no` int(11) NOT NULL,
`cms_hb` varchar(3) NOT NULL COMMENT '할부',
`app_no` varchar(30) NOT NULL COMMENT '승인번호',
`uid` varchar(50) NOT NULL,	
`pay_type` int(1) NOT NULL default '1' COMMENT '1신용카드 2휴대폰',
`money` int(11) NOT NULL,
`memo` varchar(255) NOT NULL,
`signdate` datetime NOT NULL,
`pay_ok` int(1) NOT NULL default '1' COMMENT '1승인 6취소 9실패',
`cancel_date` datetime NOT NULL COMMENT '취소일시',
`ip_addr` varchar(20) NOT NULL,
PRIMARY KEY  (`no`),
KEY `uid` (`uid`),
KEY `gtype` (`ord_idx`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr AUTO_INCREMENT=1;