
Er. Rochak Chauhan - 2007-08-20 14:05:16 -
In reply to message 1 from raji
Well it depends how you want to use it... The structure I used was:
CREATE TABLE `captcha_info` (
`cid` int(11) NOT NULL auto_increment,
`c_ques` varchar(255) NOT NULL default '',
`c_img_path` varchar(255) NOT NULL default '',
`is_active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Table structure for table `show_captcha`
--
CREATE TABLE `show_captcha` (
`showid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`c_unique_id` varchar(255) NOT NULL default '',
`c_ans` varchar(255) NOT NULL default '',
`is_active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`showid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1411 ;