Multiple Registration Form Organization

[eluser]Sumon[/eluser]
Here it is

Code:

-- Table structure for table `basic_registration`
CREATE TABLE `basic_registration` (
  `user_id` int(11) NOT NULL auto_increment,
  `name` varchar(50) collate latin1_general_ci NOT NULL,
  `email` varchar(50) collate latin1_general_ci NOT NULL,
  `password` varchar(50) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

-- Table structure for table `event_registration`
CREATE TABLE `event_registration` (
  `event_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `event_title` varchar(255) collate latin1_general_ci NOT NULL,
  `event_date` date NOT NULL,
  `event_detail` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

-- Table structure for table `payment_information`
CREATE TABLE `payment_information` (
  `pay_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `cc_card_no` int(11) NOT NULL,
  `pincode` int(11) NOT NULL,
  PRIMARY KEY  (`pay_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;