/* 
SQLyog v4.0
Host - localhost : Database - lokbaja
**************************************************************
Server version 4.1.11
*/

create database if not exists `lokbaja`;

use `lokbaja`;

/*
Table structure for guestbook
*/

drop table if exists `guestbook`;
CREATE TABLE `guestbook` (
  `ID` int(4) NOT NULL auto_increment,
  `Name` varchar(100) collate latin1_general_ci NOT NULL default '',
  `email` varchar(30) collate latin1_general_ci NOT NULL default '',
  `f_date` varchar(30) collate latin1_general_ci default NULL,
  `url` varchar(30) collate latin1_general_ci NOT NULL default '',
  `country` varchar(50) collate latin1_general_ci NOT NULL default '',
  `comment` longblob NOT NULL,
  `Validate` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*
Table structure for news_master
*/

drop table if exists `news_master`;
CREATE TABLE `news_master` (
  `news_id` int(10) NOT NULL auto_increment,
  `news_type` int(5) NOT NULL default '0',
  `news_title` text collate latin1_general_ci NOT NULL,
  `news_details` longblob NOT NULL,
  `news_photo` varchar(255) collate latin1_general_ci NOT NULL default '',
  `news_date` date NOT NULL default '0000-00-00',
  `news_time` time NOT NULL default '00:00:00',
  `news_by` varchar(255) collate latin1_general_ci NOT NULL default '',
  `news_verified` char(1) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*
Table structure for tbl_breaking
*/

drop table if exists `tbl_breaking`;
CREATE TABLE `tbl_breaking` (
  `breaking_id` int(10) NOT NULL auto_increment,
  `breaking_detail` longblob NOT NULL,
  `verified` char(1) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`breaking_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*
Table structure for tbl_newstype
*/

drop table if exists `tbl_newstype`;
CREATE TABLE `tbl_newstype` (
  `type_id` int(5) NOT NULL auto_increment,
  `type_name` varchar(255) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*
Table structure for tbl_photo
*/

drop table if exists `tbl_photo`;
CREATE TABLE `tbl_photo` (
  `id` int(3) NOT NULL auto_increment,
  `photo` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*
Table structure for tbl_poll
*/

drop table if exists `tbl_poll`;
CREATE TABLE `tbl_poll` (
  `poll_id` int(10) NOT NULL auto_increment,
  `poll_question` longblob NOT NULL,
  `no_of_options` int(2) NOT NULL default '0',
  `poll_date` date NOT NULL default '0000-00-00',
  `poll_priority` int(1) NOT NULL default '0',
  PRIMARY KEY  (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*
Table structure for tbl_poll_options
*/

drop table if exists `tbl_poll_options`;
CREATE TABLE `tbl_poll_options` (
  `poll_ans_id` int(10) NOT NULL auto_increment,
  `poll_id` int(10) NOT NULL default '0',
  `poll_option` varchar(255) collate latin1_general_ci NOT NULL default '',
  `total_poll` int(10) NOT NULL default '0',
  PRIMARY KEY  (`poll_ans_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*
Table structure for tbl_todays_pic
*/

drop table if exists `tbl_todays_pic`;
CREATE TABLE `tbl_todays_pic` (
  `pf_id` int(10) NOT NULL auto_increment,
  `pic_name` varchar(255) collate latin1_general_ci NOT NULL default '',
  `pic_caption` longblob NOT NULL,
  `pic_date` date NOT NULL default '0000-00-00',
  `priority` int(1) NOT NULL default '0',
  PRIMARY KEY  (`pf_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;