Director General of Defenece Purchase's SQL Dump File

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 13, 2006 at 04:27 PM
-- Server version: 4.1.11
-- PHP Version: 5.0.4
--
-- Database: `db_dgdp`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `username` varchar(10)  NOT NULL default '',
  `password` varchar(15)  NOT NULL default '',
  `user_type` varchar(10)  default NULL,
  `md5_password` text  NOT NULL,
  PRIMARY KEY  (`id`)
)  ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` VALUES (1, 'dgdp', 'dgdp', NULL, 'cd37388706e390931fab6b80fdcd4188');
INSERT INTO `admin` VALUES (8, 'sumona', 'sumona', 'admin', '3556622040606d58c302117c90e5ab4f');
INSERT INTO `admin` VALUES (5, 'joyaa', 'joyaa', 'admin', 'c2c8e798aecbc26d86e4805114b03c51');
INSERT INTO `admin` VALUES (6, 'maya', 'maya', 'general', 'b2693d9c2124f3ca9547b897794ac6a1');
INSERT INTO `admin` VALUES (7, '', '', 'admin', 'd41d8cd98f00b204e9800998ecf8427e');
INSERT INTO `admin` VALUES (9, 'ranjon', '123456', 'admin', 'e10adc3949ba59abbe56e057f20f883e');

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

--
-- Table structure for table `news_table`
--

CREATE TABLE `news_table` (
  `new_id` int(5) unsigned NOT NULL auto_increment,
  `news_title` varchar(255) default '',
  `news_detail` text  NOT NULL,
  `file` varchar(150)  default NULL,
  `posting` date NOT NULL default '0000-00-00',
  `news_type` enum('restricted','global')  NOT NULL default 'restricted',
  PRIMARY KEY  (`new_id`)
) ;

--
-- Dumping data for table `news_table`
--

INSERT INTO `news_table` VALUES (49, 'dgdp launch dgdp website in 24.06.06', 'sagdjasgdfjasgfjasgfg', '', '2006-06-12', 'restricted');
INSERT INTO `news_table` VALUES (27, 'maya', 'sangida', 'swif.pdf', '2006-06-06', 'restricted');
INSERT INTO `news_table` VALUES (24, 'mizan', 'lkfjdlkfd', '', '2006-05-14', 'restricted');
INSERT INTO `news_table` VALUES (36, 'welcomw dgdp ddp', 'sdklfj', 'New Microsoft Word Document.doc', '2006-05-14', 'restricted');
INSERT INTO `news_table` VALUES (48, 'joy', 'dgdp joy', 'DP-35,ltr of -1961,SOP.pdf', '2006-06-12', 'restricted');
INSERT INTO `news_table` VALUES (46, 'dsfdsf', 'dsfsdfsd', '', '2006-05-31', 'restricted');
INSERT INTO `news_table` VALUES (45, 'sda', 'fdsfds', '', '2006-05-31', 'restricted');
INSERT INTO `news_table` VALUES (44, 'fgfd', 'fdgfd', 'mdm1.pdf', '2006-05-31', 'restricted');
INSERT INTO `news_table` VALUES (42, 'sadfas', 'dfdsf', '', '2006-05-31', 'restricted');
INSERT INTO `news_table` VALUES (43, 'sdgfd', 'fgdgdf', '', '2006-05-31', 'restricted');
INSERT INTO `news_table` VALUES (17, 'bbbb', 'gfgfg', 'swifen41.pdf', '2006-05-14', 'restricted');
INSERT INTO `news_table` VALUES (47, 'ttttttttttt', 'ttfvghf', '', '2006-05-31', 'restricted');

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

--
-- Table structure for table `super_admin`
--

CREATE TABLE `super_admin` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `username` varchar(10)  NOT NULL default '',
  `password` varchar(15)  NOT NULL default '',
  `md5_password` text  NOT NULL,
  PRIMARY KEY  (`id`)
)  ;

--
-- Dumping data for table `super_admin`
--

INSERT INTO `super_admin` VALUES (1, 'dgdp', '1234567', 'fcea920f7412b5da7be0cf42b8c93759');

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

--
-- Table structure for table `tbl_black_list`
--

CREATE TABLE `tbl_black_list` (
  `enlist_id` varchar(10)  default NULL,
  `active_date` date default NULL,
  `reason` varchar(40)  default NULL
) ;

--
-- Dumping data for table `tbl_black_list`
--

INSERT INTO `tbl_black_list` VALUES ('21', '2006-05-26', 'erew');
INSERT INTO `tbl_black_list` VALUES ('25', '2006-05-25', 'ewrew');
INSERT INTO `tbl_black_list` VALUES ('21', '2006-05-24', 'rtre');

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

--
-- Table structure for table `tbl_debar_list`
--

CREATE TABLE `tbl_debar_list` (
  `enlist_id` varchar(10) default NULL,
  `active_date` date default '0000-00-00',
  `reason` varchar(40)  default NULL
);

--
-- Dumping data for table `tbl_debar_list`
--

INSERT INTO `tbl_debar_list` VALUES ('1', '2012-09-06', 'ggg');
INSERT INTO `tbl_debar_list` VALUES ('2', '2012-09-06', 'bad\r\n');
INSERT INTO `tbl_debar_list` VALUES ('1', '2012-09-06', 'sdfsf');
---------------------------------------------------

--
-- Table structure for table `tbl_enlist_image`
--

CREATE TABLE `tbl_enlist_image` (
  `enlist_id` int(10) default NULL,
  `img_desc` varchar(25) default NULL,
  `attach_img` varchar(30)  default NULL
);

--
-- Dumping data for table `tbl_enlist_image`
--

INSERT INTO `tbl_enlist_image` VALUES (12, '', 'Blue hills.jpg');
INSERT INTO `tbl_enlist_image` VALUES (120, '', 'Winter.jpg');
INSERT INTO `tbl_enlist_image` VALUES (0, 'gf', 'mmmm1.rtf');

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

--
-- Table structure for table `tbl_enlistment_info`
--

CREATE TABLE `tbl_enlistment_info` (
  `enlist_id` int(10) NOT NULL auto_increment,
  `enlist_name` varchar(20)  default NULL,
  `enlist_password` varchar(16)  default NULL,
  `user_type` varchar(15)  default NULL,
  `firm_name` varchar(20)  default NULL,
  `md_name` varchar(20)  default NULL,
  `dir_name` varchar(20)  default NULL,
  `address` varchar(27)  default NULL,
  `telephone` varchar(14)  default NULL,
  `fax` varchar(15)  default NULL,
  `email` varchar(20)  default NULL,
  `group` varchar(20)  default NULL,
  `enlist_date` date default NULL,
  `no_of_debar` varchar(20)  default NULL,
  `enlist_status` varchar(20)  default NULL,
  `sec_cat` varchar(18)  default NULL,
  PRIMARY KEY  (`enlist_id`)
)  ;

--
-- Dumping data for table `tbl_enlistment_info`
--

INSERT INTO `tbl_enlistment_info` VALUES (6, 'mizan', '123456g', 'common', 'anupam', 'mm', 'mmm', 'gfgf', '543543', '524324', 'ghfhgf', 'ghfgh', '0000-00-00', '10', '', NULL);

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

--
-- Table structure for table `tbl_limited_tender`
--

CREATE TABLE `tbl_limited_tender` (
  `limited_tender_id` int(10) NOT NULL auto_increment,
  `limited_tender_no` varchar(10)  default NULL,
  `limited_tender_name` varchar(30)  default NULL,
  `limited_tender_password` varchar(20)  default NULL,
  `firm_name` varchar(24)  default NULL,
  `tender_date` date default NULL,
  `file` varchar(200)  default NULL,
  `sec_cat` varchar(18)  default NULL,
  PRIMARY KEY  (`limited_tender_id`)
)  ;

--
-- Dumping data for table `tbl_limited_tender`
--

INSERT INTO `tbl_limited_tender` VALUES (6, '12', 'mizan', '123456', 'anupam', '2006-05-18', 'Antea_AIL.pdf', 'p-sec-10');

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

--
-- Table structure for table `tbl_registration_access`
--

CREATE TABLE `tbl_registration_access` (
  `reg_id` int(10) NOT NULL auto_increment,
  `reg_user_name` varchar(25)  default NULL,
  `reg_password` varchar(16)  default NULL,
  `reg_name` varchar(25)  default NULL,
  `registration_doc` varchar(16)  default NULL,
  `reg_address` varchar(30)  default NULL,
  `reg_phone` varchar(10)  default NULL,
  `download_count` varchar(10)  default NULL,
  PRIMARY KEY  (`reg_id`)
) ;

--
-- Dumping data for table `tbl_registration_access`
--

INSERT INTO `tbl_registration_access` VALUES (45, NULL, NULL, NULL, 'Antea_AIL.pdf', NULL, NULL, NULL);

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

--
-- Table structure for table `tbl_tender_amenmend`
--

CREATE TABLE `tbl_tender_amenmend` (
  `tender_id` int(10) NOT NULL auto_increment,
  `tender_no` varchar(10)  default NULL,
  `date_of_publish` date default NULL,
  `name_newspaper` varchar(18)  default NULL,
  `sdate_tdate` date default NULL,
  `open_date` date default NULL,
  `add_tender` varchar(15)  default NULL,
  `contact_tender` varchar(15)  default NULL,
  `sec_cat` varchar(18)  default NULL,
  PRIMARY KEY  (`tender_id`)
) ;
--
-- Dumping data for table `tbl_tender_amenmend`
--

INSERT INTO `tbl_tender_amenmend` VALUES (1, '1', '2006-05-25', 'prothom alo', '0000-00-00', '2006-05-31', '', 'cornel mizan', 'Navy Wing');

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

--
-- Table structure for table `tbl_tender_doc`
--

CREATE TABLE `tbl_tender_doc` (
  `tender_id` int(10) NOT NULL auto_increment,
  `tender_no` varchar(10)  default NULL,
  `date_of_publish` date default NULL,
  `name_newspaper` varchar(30)  default NULL,
  `sdate_tdate` date default NULL,
  `open_date` date default NULL,
  `add_tender` varchar(25)  default NULL,
  `contact_tender` varchar(15)  default NULL,
  `tender_doc` varchar(180)  default NULL,
  `schedule_doc` varchar(180)  default NULL,
  `procurement_list` varchar(180)  default NULL,
  `submit_date` date default NULL,
  `sec_cat` varchar(25)  default NULL,
  PRIMARY KEY  (`tender_id`)
) ;

--
-- Dumping data for table `tbl_tender_doc`
--

INSERT INTO `tbl_tender_doc` VALUES (3, '1', '2006-06-15', 'prothom alo', '2006-06-19', '2006-06-23', 'dgdp', 'COrnel aftab', 'TenderNotice.pdf', '', '', '2006-06-06', 'Air Force Wing');