-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 26, 2023 at 04:44 AM
-- Server version: 5.1.33
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `hochste`
--

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

--
-- Table structure for table `delivery_address`
--

CREATE TABLE IF NOT EXISTS `delivery_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email_id` varchar(255) NOT NULL,
  `mobile_no` varchar(255) NOT NULL,
  `delivery_address` varchar(255) NOT NULL,
  `delivery_country` int(11) NOT NULL,
  `delivery_state` int(11) NOT NULL,
  `delivery_city` int(11) NOT NULL,
  `delivery_pincode` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `created_date` date NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `delivery_address`
--

INSERT INTO `delivery_address` (`id`, `cust_id`, `first_name`, `last_name`, `email_id`, `mobile_no`, `delivery_address`, `delivery_country`, `delivery_state`, `delivery_city`, `delivery_pincode`, `status`, `created_date`, `is_active`) VALUES
(1, 'CNSTR-001', 'Ranjith', 'J', 'ranjithjms1998@gmail.com', '6380666635', 'Test Address', 101, 35, 3659, '600037', 1, '2023-07-24', 1),
(2, 'CNSTR-001', 'Ranjith', 'J', 'ranjith@kokatechnology.com', '1234567890', 'Test Address', 101, 35, 3659, '600101', 1, '2023-07-24', 1);
