-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 10, 2008 at 02:22 PM
-- Server version: 4.1.14
-- PHP Version: 5.0.5
-- 
-- Database: `news`
-- 

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

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

CREATE TABLE `news` (
  `recNo` int(4) NOT NULL auto_increment,
  `companyNo` int(4) NOT NULL default '0',
  `locationNo` int(4) NOT NULL default '0',
  `releaseDate` date NOT NULL default '0000-00-00',
  `title` varchar(100) collate latin1_general_ci NOT NULL default '',
  `summary` blob NOT NULL,
  `detail` blob NOT NULL,
  `emailText` blob NOT NULL,
  `validity` int(1) NOT NULL default '0',
  `validTillDate` date NOT NULL default '0000-00-00',
  `ActiveInActive` varchar(4) collate latin1_general_ci NOT NULL default '',
  `createDate` date NOT NULL default '0000-00-00',
  `modifyDate` date NOT NULL default '0000-00-00',
  `lastAcessDate` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`recNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

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

INSERT INTO `news` VALUES (2, 0, 0, '0000-00-00', '', '', '', '', 2, '2008-03-10', '', '0000-00-00', '0000-00-00', '0000-00-00');
INSERT INTO `news` VALUES (3, 0, 0, '0000-00-00', '', '', '', '', 2, '2008-03-10', '', '0000-00-00', '0000-00-00', '0000-00-00');