-- http://www.phpmyadmin.net
-- 


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

-- 
-- Table structure for table `news`
-- 

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(500) NOT NULL,
  `date` date NOT NULL,
  `file` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

-- 
-- Dumping data for table `news`
-- 

INSERT INTO `news` (`id`, `title`, `date`, `file`) VALUES 
(11, 'Aqua Aquaria 2013', '2013-01-29', 'image/news/AQUA AQUARIA 2013 Brochure.pdf'),
(15, 'Training Programmes', '2013-01-28', NULL),
(21, 'Release of the First Batch of SPF L. vannamei Broodstock produced by RGCA', '2013-05-14', 'image/news/Release of the first batch of SPF L. vannamei Broodstock produced by RGCA .pdf'),
(22, 'Asian Seabass Seeds Available', '2013-06-03', 'image/news/RGCA Seabass Seed Supply Circular DT 01.06.2013.pdf'),
(23, 'International Seminar-Workshop on Mud Crab Aquaculture and Fisheries Management (ISMAF-2013)', '2013-06-11', 'image/news/ISMAF Report -website.pdf'),
(24, 'Workshop on Shrimp Pathology - 2013', '2013-06-14', 'image/news/Shrimp Pathology Workshop 2013.pdf');

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

-- 
-- Table structure for table `placement`
-- 

CREATE TABLE `placement` (
  `id` int(11) NOT NULL,
  `title` varchar(300) NOT NULL,
  `description` varchar(60000) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `placement`
-- 

INSERT INTO `placement` (`id`, `title`, `description`, `date`) VALUES 
(1, 'Openings in RGCA for Aquaculture Professionals, Engineers, Administration and Accounts staff', 'Walk in Interviews from 2nd to 4th July 2013 at MPEDA Head Quarters, Kochi', '2013-06-23 10:53:03');

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

-- 
-- Table structure for table `placementfile`
-- 

CREATE TABLE `placementfile` (
  `id` int(11) NOT NULL,
  `file` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `placementfile`
-- 

INSERT INTO `placementfile` (`id`, `file`) VALUES 
(1, 'Advertisement RGCA Recruitment 2013 (FINAL).pdf');

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

-- 
-- Table structure for table `scientific`
-- 

CREATE TABLE `scientific` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text,
  `author` text,
  `journal` text,
  `vol` text,
  `pageno` text,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `scientific`
-- 

INSERT INTO `scientific` (`id`, `title`, `author`, `journal`, `vol`, `pageno`, `date`) VALUES 
(1, 'Specific pathogen-free assurance of imported Pacific white shrimp Litopenaeus vannamei (Boone, 1931) in the Aquatic Quarantine Facility, Chennai', ' M.C. Remany, Daly Cyriac, S.Nagaraj, BabuRao, A. K. Panda, Jaideep Kumar & Y.C. Thampi Samraj', 'Current Science', '99', '12', '2013-07-29 12:28:05'),
(2, '“Certification process of imported Pacific white shrimp Litopenaeus vannamei (Boone, 1931) at Aquatic Quarantine Facility, India', 'M.C. Remany, Daly Cyriac, D. Kannan, A. K. Panda, Jaideep Kumar and Y. C. Thampi Samraj', 'Journal of Agricultural Science & Technology', '6', '1', '2013-02-06 00:00:00');

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

-- 
-- Table structure for table `tender`
-- 

CREATE TABLE `tender` (
  `id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `description` varchar(5000) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `tender`
-- 

INSERT INTO `tender` (`id`, `title`, `description`, `due_date`) VALUES 
(29, 'Expression of Interest for Sea based Hatchery at Thiruvananthapuram', '', '2012-12-14'),
(30, 'Application for Leasing out Tiger Shrimp Hatchery', '', '2012-12-14'),
(31, 'Quotation for Sale of Cobia Fish', '', '2012-12-10'),
(32, 'Fabrication and Supply of FRP Tanks', '', '2012-11-10'),
(33, 'Tenders/Tender for Construction of Aquatic Quarantine Facility', '', '2012-11-06'),
(34, 'Quotation for the supply of components and accessories for sea cage system', '', '2012-09-20'),
(35, 'Tenders/Quotation for re-circulating aquaculture system components ', '', '2012-08-10'),
(36, 'Civil & Electrical Work at TTTAC Campus, Sirkazhi (TN)', '', '2012-08-01'),
(37, 'Expansion of Aquatic Quarantine Facility for Rajiv Gandhi Centre for Aquaculture', '', '2012-07-04'),
(38, 'Quotation for Supply and installation of DG Set', '', '2012-04-16'),
(39, ' Fabrication & Supply of FRP tanks for Aquatic Quarantine Facility, Neelankarai, Chennai', '', '2013-05-06'),
(40, 'Construction of Compound Wall and Security Sheds for the BMC at Rajakamangalam, Nagercoil', 'Proposed Construction of Compound Wall and Security Sheds for the Broodstock Multiplication Centre at Rajakamangalam, Nagercoil', '2013-05-29'),
(41, 'SUPPLY & INSTALLATION OF DG SETS FOR THE  AQ FACILITY OF RGCA AT NEELANKARAI, CHENNAI', 'SUPPLY & INSTALLATION OF 2 Nos of 250 KVA DG SETs FOR THE AQUATIC QUARANTINE FACILITY OF RGCA AT NEELANKARAI, CHENNAI\r\n', '2013-06-13'),
(42, 'SUPPLY OF PUMPS, FILTRATION & STERILIZATION EQUIPMENTS FOR THE AQ FACILITY OF RGCA AT CHENNAI', 'SUPPLY OF PUMPS, FILTRATION & STERILIZATION EQUIPMENTS FOR THE RGCA AQUATIC QUARANTINE FACILITY FOR L. vannamei AT NEELANKARAI, CHENNAI', '2013-06-20');

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

-- 
-- Table structure for table `tenfile`
-- 

CREATE TABLE `tenfile` (
  `id` int(11) DEFAULT NULL,
  `file` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `tenfile`
-- 

INSERT INTO `tenfile` (`id`, `file`) VALUES 
(29, '2. Sea Based Hatchery.pdf'),
(30, '3. Leasing Shrimp Hatchery.pdf'),
(31, '1. Sale of Cobia fish.pdf'),
(32, '4. Fabrication and Supply of FRP tanks.pdf'),
(33, '5. Construction of Aquatic Quarantine facility.pdf'),
(34, '6. Supply of Sea Cage equipment.doc'),
(35, '8. Inviting Quotations for RAS.pdf'),
(36, '7. Construction of Additional facilities at TTTAC.pdf'),
(37, '9. Expansion of Aquatic Quarantine facility.pdf'),
(38, '10. Supply and Installation of DG Set.pdf'),
(39, 'AN 1 - FRP Ad.doc'),
(39, 'AN 2 - Quotation for FRP Tanks.docx'),
(39, 'AN 3 - NIQ AQF FRP TANKS.pdf'),
(39, 'AN 4 - Cubicle Tank  0.5 MT.pdf'),
(39, 'AN 5 - Receiving Tank 1 MT.pdf'),
(40, 'Tender ADVT - Compound Wall 15th May 2013.pdf'),
(41, 'DG - Limited Tender - Advertisement 6th June 2013.docx'),
(41, 'AN I - DG Blank BOQ.pdf'),
(41, 'AN II - DG 250KVA tech specifications.pdf'),
(41, 'AN III - DG Approved Makes.pdf'),
(42, 'Equipments - Advertisement.docx'),
(42, 'E & M Invitation for Quotation .xlsx');
