-- https://www.phpmyadmin.net/
--

START TRANSACTION;





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

--
-- Table structure for table `admin_announcement`
--

CREATE TABLE IF NOT EXISTS `admin_announcement` (
  `announcement_id` int(11) NOT NULL AUTO_INCREMENT,
  `announcement_text` text NOT NULL,
  `fb_url` varchar(255) DEFAULT NULL,
  `announcement_date` date NOT NULL,
  `like_count` int(11) NOT NULL DEFAULT '0',
  `announcement_status` tinyint(1) NOT NULL DEFAULT '1',
  `comment_active` tinyint(1) NOT NULL DEFAULT '1',
  `pinned` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`announcement_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `announcement_like`
--

CREATE TABLE IF NOT EXISTS `announcement_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `announce_id` int(11) NOT NULL,
  `user_ip` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `announcement_limit`
--

CREATE TABLE IF NOT EXISTS `announcement_limit` (
  `id` int(11) NOT NULL,
  `start_lim` int(11) NOT NULL DEFAULT '4',
  `load_lim` int(11) NOT NULL DEFAULT '4',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `announcement_limit`
--

INSERT INTO `announcement_limit` (`id`, `start_lim`, `load_lim`) VALUES
(1, 4, 4);

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

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `announceID` int(11) NOT NULL,
  `announceText` text NOT NULL,
  `fullname` varchar(50) NOT NULL,
  `useremail` varchar(50) NOT NULL,
  `comment_text` text NOT NULL,
  `admin_reply` text,
  `comment_date` date NOT NULL,
  `comment_status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_subscriber`
--

CREATE TABLE IF NOT EXISTS `tbl_subscriber` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subscriber_email` varchar(255) NOT NULL,
  `subscriber_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
COMMIT;

