 CREATE TABLE IF NOT EXISTS `vendor_details` (
   `v_id` int(4) NOT NULL,
   `name` varchar(50) NOT NULL,
+  `contact_person` varchar(50) NOT NULL,
   `address` text NOT NULL,
   `country` varchar(50) NOT NULL,
   `landline_no` varchar(20) NOT NULL,


INSERT INTO `customer_gstn` (`c_id`, `gstn_no`, `state`, `gstn_image`) VALUES
(1, '12134568108as', 'rajasthan', ''),
(1, '123123213', 'Bihar', '');

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


  `fax_no` varchar(13) NOT NULL,
  `email` int(50) NOT NULL,
  `type` varchar(10) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'unapproved'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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