-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 06, 2011 at 11:32 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: `proforma`
--

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

--
-- Table structure for table `admin_info`
--

CREATE TABLE IF NOT EXISTS `admin_info` (
  `ai_id` int(11) NOT NULL AUTO_INCREMENT,
  `ai_name` varchar(75) NOT NULL,
  `ai_email_id` varchar(50) NOT NULL,
  `ai_password` varchar(15) NOT NULL,
  `ai_security_id` varchar(15) NOT NULL,
  `ai_status` int(11) NOT NULL,
  `ai_last_update` datetime NOT NULL,
  `ai_lastlogin_ip` varchar(20) NOT NULL,
  PRIMARY KEY (`ai_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin_info`
--

INSERT INTO `admin_info` (`ai_id`, `ai_name`, `ai_email_id`, `ai_password`, `ai_security_id`, `ai_status`, `ai_last_update`, `ai_lastlogin_ip`) VALUES
(1, 'Srikanta12', 'srikanta.ku.subudhi@gmail.com', 'proforma', '1234', 1, '2011-07-06 16:11:11', '127.0.0.1');

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

--
-- Table structure for table `client_info`
--

CREATE TABLE IF NOT EXISTS `client_info` (
  `ci_id` int(11) NOT NULL AUTO_INCREMENT,
  `ci_email` varchar(50) NOT NULL,
  `ci_password` varchar(25) NOT NULL,
  `ci_logo` varchar(40) NOT NULL,
  `ci_name` varchar(30) NOT NULL,
  `ci_phone` varchar(20) NOT NULL,
  `ci_description` text NOT NULL,
  `ci_last_update` datetime NOT NULL,
  `ci_last_login_ip` varchar(20) NOT NULL,
  `ci_email_verification_status` int(11) NOT NULL,
  `ci_status` int(11) NOT NULL,
  `ci_no_project` int(11) NOT NULL,
  PRIMARY KEY (`ci_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;

--
-- Dumping data for table `client_info`
--

INSERT INTO `client_info` (`ci_id`, `ci_email`, `ci_password`, `ci_logo`, `ci_name`, `ci_phone`, `ci_description`, `ci_last_update`, `ci_last_login_ip`, `ci_email_verification_status`, `ci_status`, `ci_no_project`) VALUES
(2, 's', 's', '', 's', 's', 's', '2011-07-03 17:04:19', '127.0.0.1', 0, 1, 0),
(4, 's', 's', '4_bullet.jpg', 's', 'z', 'z', '2011-07-03 18:47:50', '127.0.0.1', 0, 0, 0),
(10, 's', 's', '10_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:19:42', '127.0.0.1', 0, 0, 0),
(11, 's', 's', '11_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:20:39', '127.0.0.1', 0, 0, 0),
(12, 's', 's', '12_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:21:07', '127.0.0.1', 0, 0, 0),
(46, 'srikanta.ku.subudhi@gmail', '12223', '46_button1.jpg', 'Sathia', '9999999', 'fsadfasfdas', '2011-07-04 16:12:56', '', 0, 1, 0),
(47, '1srikanta.ku.subudhi@gmail', '9999999', '47_logo.jpg', 'Sathia1', '999999911', 'fsadfasfdas  1111', '2011-07-04 16:15:26', '', 0, 1, 0),
(27, 's', 's', '27_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:29:42', '127.0.0.1', 0, 0, 0),
(28, 's', 's', '28_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:35:54', '127.0.0.1', 0, 0, 0),
(29, 's', 's', '29_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:38:32', '127.0.0.1', 0, 1, 0),
(30, 's', 's', '30_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:39:33', '127.0.0.1', 0, 1, 0),
(31, 's', 's', '31_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:49:22', '127.0.0.1', 0, 1, 0),
(32, 's', 's', '32_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:49:43', '127.0.0.1', 0, 1, 0),
(33, 's', 's', '33_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:54:28', '127.0.0.1', 0, 1, 0),
(34, 's', 's', '34_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:58:37', '127.0.0.1', 0, 1, 0),
(35, 's', 's', '35_bullet.jpg', 's', 'z', 'z', '2011-07-04 11:59:57', '127.0.0.1', 0, 1, 0),
(36, 's', 's', '36_bullet.jpg', 's', 'z', 'z', '2011-07-04 12:01:39', '127.0.0.1', 0, 1, 0),
(37, 's', 's', '37_bullet.jpg', 's', 'z', 'z', '2011-07-04 12:02:12', '127.0.0.1', 0, 1, 0),
(38, 's1', 's1', '38_button1.jpg', 's1', 'z1', 'z  1', '2011-07-04 16:03:29', '', 0, 1, 0),
(39, 's', 's', '39_bullet.jpg', 's', 'z', 'z', '2011-07-04 12:45:13', '127.0.0.1', 0, 1, 0),
(40, 's', 's', '40_bullet.jpg', 's', 'z', 'z', '2011-07-04 12:47:14', '127.0.0.1', 0, 1, 0),
(41, 's', 's', '41_bullet.jpg', 's', 'z', 'z', '2011-07-04 12:56:24', '127.0.0.1', 0, 1, 0),
(42, 's', 's', '42_bullet.jpg', 's', 'z', 'z', '2011-07-04 12:57:37', '127.0.0.1', 0, 1, 0),
(43, 's', 's', '43_bullet.jpg', 's', 'z', 'z', '2011-07-04 12:57:55', '127.0.0.1', 0, 1, 0),
(44, 's', 's', '44_bullet.jpg', 's', 'z', 'z', '2011-07-04 13:04:58', '127.0.0.1', 0, 1, 0);

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

--
-- Table structure for table `photo_info`
--

CREATE TABLE IF NOT EXISTS `photo_info` (
  `ph_id` int(11) NOT NULL AUTO_INCREMENT,
  `ph_name` varchar(30) NOT NULL,
  `ph_pi_id` int(11) NOT NULL,
  `ph_ci_id` int(11) NOT NULL,
  `ph_lastupdate` datetime NOT NULL,
  `ph_status` int(11) NOT NULL,
  PRIMARY KEY (`ph_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `photo_info`
--

INSERT INTO `photo_info` (`ph_id`, `ph_name`, `ph_pi_id`, `ph_ci_id`, `ph_lastupdate`, `ph_status`) VALUES
(19, '19_upload.jpg', 19, 46, '2011-07-06 16:37:48', 0),
(18, '18_logo.jpg', 19, 46, '2011-07-06 10:43:12', 0),
(17, '17_logo.jpg', 19, 46, '2011-07-06 10:41:25', 0),
(16, '16_logo.jpg', 19, 46, '2011-07-06 10:40:44', 0);

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

--
-- Table structure for table `project_info`
--

CREATE TABLE IF NOT EXISTS `project_info` (
  `pi_id` int(11) NOT NULL AUTO_INCREMENT,
  `pi_name` varchar(30) NOT NULL,
  `pi_ci_id` int(11) NOT NULL,
  `pi_status` int(11) NOT NULL,
  `pi_last_update` datetime NOT NULL,
  PRIMARY KEY (`pi_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `project_info`
--

INSERT INTO `project_info` (`pi_id`, `pi_name`, `pi_ci_id`, `pi_status`, `pi_last_update`) VALUES
(19, 'ssss', 46, 1, '2011-07-05 11:59:25'),
(16, 'aaa', 46, 1, '2011-07-05 07:56:58'),
(17, 'qqq', 2, 1, '2011-07-05 09:56:23');

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

--
-- Table structure for table `video_info`
--

CREATE TABLE IF NOT EXISTS `video_info` (
  `vi_id` int(11) NOT NULL AUTO_INCREMENT,
  `vi_name` varchar(30) NOT NULL,
  `vi_url` varchar(75) NOT NULL,
  `vi_pi_id` int(11) NOT NULL,
  `vi_ci_id` int(11) NOT NULL,
  `vi_last_update` datetime NOT NULL,
  `vi_status` int(11) NOT NULL,
  PRIMARY KEY (`vi_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `video_info`
--

INSERT INTO `video_info` (`vi_id`, `vi_name`, `vi_url`, `vi_pi_id`, `vi_ci_id`, `vi_last_update`, `vi_status`) VALUES
(1, 'fasf', 'fasdf', 19, 46, '2011-07-05 14:04:50', 0),
(2, 'fasf', 'fasdf', 19, 46, '2011-07-05 14:06:10', 0),
(3, 'fasf', 'fasdf', 19, 46, '2011-07-05 14:06:34', 0),
(4, 'fasf', 'fasdf', 19, 46, '2011-07-05 14:06:47', 0),
(5, 'fasf', 'fasdf', 19, 46, '2011-07-05 14:07:08', 0),
(6, 'fasf122', 'fasdf12222', 19, 46, '2011-07-05 18:47:29', 0),
(15, 'fasdf', 'fasdf', 19, 46, '2011-07-05 14:29:59', 0),
(16, 'fasdf', 'fasdf', 19, 46, '2011-07-05 14:31:34', 0),
(17, 'fasdf', 'fasdf', 19, 46, '2011-07-05 14:32:36', 0),
(18, 'fasdf', 'fasdf', 19, 46, '2011-07-05 16:00:01', 0),
(19, 'fasdf', 'fasdf', 19, 46, '2011-07-05 16:00:34', 0),
(20, 'fasdf', 'fasdf', 19, 46, '2011-07-05 16:01:56', 1);