-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 18, 2010 at 06:28 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `acelg_db`
--

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

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

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

INSERT INTO `admin` (`id`, `username`, `password`, `first_name`, `last_name`) VALUES
(1, 'admin', 'admin', 'sunil', 'banjara');

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

--
-- Table structure for table `tbl_aboutus_page`
--

CREATE TABLE IF NOT EXISTS `tbl_aboutus_page` (
  `bint_aboutusID` bigint(20) NOT NULL auto_increment,
  `txt_aboutus_description` text NOT NULL,
  `txt_aboutus_image` text NOT NULL,
  `txt_aboutus_htmlcontent` text NOT NULL,
  `enum_aboutus_visible` enum('Y','N') NOT NULL default 'N',
  `txt_aboutus_pagetitle` text NOT NULL,
  `txt_aboutus_meta_description` text NOT NULL,
  `txt_aboutus_meta_keywords` text NOT NULL,
  PRIMARY KEY  (`bint_aboutusID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=160 ;

--
-- Dumping data for table `tbl_aboutus_page`
--

INSERT INTO `tbl_aboutus_page` (`bint_aboutusID`, `txt_aboutus_description`, `txt_aboutus_image`, `txt_aboutus_htmlcontent`, `enum_aboutus_visible`, `txt_aboutus_pagetitle`, `txt_aboutus_meta_description`, `txt_aboutus_meta_keywords`) VALUES
(159, 'The Australian Government is contributing $8 million in funding for a Centre for Excellence in Local Government to enhance professionalism and skills, showcase innovation and best practice, and facilitate a better informed policy debate. The new centre was announced by the Prime Minister at the inaugural Australian Council of Local Government meeting on 18 November 2008. A consortium led by the University of Technology, Sydney (UTS) has been selected to establish the centre following a competitive process. The consortium partners are the University of Canberra, Australia and New Zealand School of Government, Local Government Managers Australia, and the Institute of Public Works Engineering Australia Limited. Other program partners will include the Australian National University, Charles Darwin University and Edith Cowan University.', '1268542617_launch_acelg.jpg', '<div class=\\"contentinner\\">\r\n<p><strong>The Centre will: </strong></p>\r\n<ul>\r\n    <li>build on existing  local government programs and networks;</li>\r\n    <li>encourage innovation  and best practice across local government;</li>\r\n    <li>foster good  governance and strategic leadership</li>\r\n    <li>support action to  improve local government workforce capability to address skill shortages and  attract and retain skilled staff;</li>\r\n    <li>promote new and  improved training and development programs; and</li>\r\n    <li>stimulate and inform  debate on key issues for local government in coming decades.</li>\r\n</ul>\r\n<p><strong>Activities  will be grouped in six program areas: </strong></p>\r\n<ul>\r\n    <li>Research and policy  foresight</li>\r\n    <li>Innovation and best  practice</li>\r\n    <li>Governance and  strategic leadership</li>\r\n    <li>Organisation capacity  building</li>\r\n    <li>Rural, remote and  Indigenous Australia</li>\r\n    <li>Workforce  development.</li>\r\n</ul>\r\n<p>Some activities  will commence almost immediately, with the Centre expected to be fully  operational by early 2010.</p>\r\n</div>', 'Y', 'About Us', 'Some activities will commence almost immediately, with the Centre expected to be fully operational by early 2010.', 'Some activities will commence almost immediately, with the Centre expected to be fully operational by early 2010.');

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

--
-- Table structure for table `tbl_board_members`
--

CREATE TABLE IF NOT EXISTS `tbl_board_members` (
  `bint_boardID` bigint(20) NOT NULL auto_increment,
  `vch_board_name` varchar(255) NOT NULL,
  `txt_board_title` text NOT NULL,
  `txt_board_description` text NOT NULL,
  `txt_board_image` text NOT NULL,
  `txt_board_readmore` text NOT NULL,
  `bint_board_display_characters` bigint(20) NOT NULL,
  `enum_board_visible` enum('Y','N') NOT NULL default 'N',
  `txt_board_pagetitle` text NOT NULL,
  `txt_board_meta_description` text NOT NULL,
  `txt_board_meta_keywords` text NOT NULL,
  PRIMARY KEY  (`bint_boardID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `tbl_board_members`
--

INSERT INTO `tbl_board_members` (`bint_boardID`, `vch_board_name`, `txt_board_title`, `txt_board_description`, `txt_board_image`, `txt_board_readmore`, `bint_board_display_characters`, `enum_board_visible`, `txt_board_pagetitle`, `txt_board_meta_description`, `txt_board_meta_keywords`) VALUES
(18, 'Professor Attila Brungs', 'Board Member', 'Penny Holloway\r\nBoard Member,\r\nGeneral Manager, North Sydney City Council (representing Local Government Managers Australia)\r\n', '1268545105_board-pic.jpg', 'http://www.acelg.com', 222, 'Y', 'Board Members', 'Meta Description', 'Meta keywords'),
(17, 'Hon Margaret Reynolds', 'Chairperson,', 'Chairperson\r\n\r\nHon Margaret Reynolds\r\n \r\nChairperson, \r\nFormer federal Minister for Local Government\r\nConsectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation.\r\n\r\nConsectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation.\r\n\r\nConsectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation.', '1268658054_chairperson.jpg', '', 222, 'Y', 'Board Members', 'meta', 'meta'),
(27, 'Professor John H Howard', 'Board Member', 'Professor John H Howard\\r\\nBoard Member,\\r\\nPro Vice Chancellor, University of Canberra\\r\\nread more �', '1268568243_board-pic.gif', 'www.acelg.com', 222, 'Y', 'Board Members', 'Meta description', 'Meta description Keywords');

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

--
-- Table structure for table `tbl_box_content`
--

CREATE TABLE IF NOT EXISTS `tbl_box_content` (
  `bint_boxID` bigint(20) NOT NULL auto_increment,
  `txt_box_title` text NOT NULL,
  `txt_box_description` text NOT NULL,
  `bint_box_sort_order` bigint(20) NOT NULL,
  `enum_box_visible` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`bint_boxID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Dumping data for table `tbl_box_content`
--

INSERT INTO `tbl_box_content` (`bint_boxID`, `txt_box_title`, `txt_box_description`, `bint_box_sort_order`, `enum_box_visible`) VALUES
(25, 'Project Plan', '<a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/index.html#\\"><img src=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/images/pdf-icon.png\\" alt=\\"Project Plan\\" title=\\"ACELG Project Plan\\" /></a> <a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/index.html#\\">ACELG  Project Plan</a><img alt=\\"\\" src=\\"http://localhost/upload/pdf-icon.gif\\" />', 2, 'Y'),
(21, 'Year of Women in Local Government', 'Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim... <a href="women-in-local-gov.html">read more &raquo;</a>', 2, 'Y'),
(28, 'Project Plan', '<a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/index.html#\\"><img src=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/images/pdf-icon.png\\" alt=\\"Project Plan\\" title=\\"ACELG Project Plan\\" /></a> <a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/index.html#\\">ACELG  Project Plan</a><img alt=\\"\\" src=\\"http://localhost/upload/pdf-icon.gif\\" />', 2, 'Y'),
(22, 'Announcements', '<p>&raquo; <a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/index.html#\\">Consectetur  adipisicing elit, sed do</a><br /> &raquo; <a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/index.html#\\">Consectetur  adipisicing elit, sed do</a><br /> &raquo; <a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/index.html#\\">Consectetur  adipisicing elit, sed do</a><br /> &raquo; <a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/index.html#\\">Consectetur  adipisicing elit, sed do</a></p>', 1, 'Y');

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

--
-- Table structure for table `tbl_home_page`
--

CREATE TABLE IF NOT EXISTS `tbl_home_page` (
  `bint_homepageID` bigint(20) NOT NULL auto_increment,
  `txt_home_header_text` text NOT NULL,
  `txt_home_header_text_colored` text NOT NULL,
  `txt_home_welcome_title` text NOT NULL,
  `txt_home_welcome_description` text NOT NULL,
  `txt_home_welcome_image` text NOT NULL,
  `txt_home_welcome_readmore` text NOT NULL,
  `enum_home_visible` enum('Y','N') NOT NULL default 'N',
  `txt_home_welcome_pagetitle` text NOT NULL,
  `txt_home_meta_description` text NOT NULL,
  `txt_home_keywords` text NOT NULL,
  PRIMARY KEY  (`bint_homepageID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Dumping data for table `tbl_home_page`
--

INSERT INTO `tbl_home_page` (`bint_homepageID`, `txt_home_header_text`, `txt_home_header_text_colored`, `txt_home_welcome_title`, `txt_home_welcome_description`, `txt_home_welcome_image`, `txt_home_welcome_readmore`, `enum_home_visible`, `txt_home_welcome_pagetitle`, `txt_home_meta_description`, `txt_home_keywords`) VALUES
(28, 'The Australian Centre of Excellence for Local Government is a unique collaboration of universities and professional bodies committed to the advancement of local government. The Centre�s vision is:', 'ACELGWorld-class local government to meet the emerging challenges of 21st century Australia', 'Official Launch of ACELG', 'The Australian Government is contributing $8 million in funding for a Centre for Excellence in Local Government to enhance professionalism and skills, showcase innovation and best practice, and facilitate a better informed policy debate. The new centre was announced by the Prime Minister at the inaugural Australian Council of Local Government meeting on 18 November 2008. A consortium led by the University of Technology, Sydney (UTS) has been selected to establish the centre following a competitive process. The consortium partners are the University of Canberra, Australia and New Zealand School of Government, Local Government Managers Australia...', '1268543674_launch_acelg.jpg', 'http://www.aboutacelg.com', 'Y', 'Home Page', 'MEta description', 'Meta keywords');

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

--
-- Table structure for table `tbl_meeting_info`
--

CREATE TABLE IF NOT EXISTS `tbl_meeting_info` (
  `bint_meetingID` bigint(16) NOT NULL auto_increment,
  `txt_meeting_image` text NOT NULL,
  `txt_meeting_bottom_image1` text NOT NULL,
  `txt_meeting_bottom_image2` text NOT NULL,
  `txt_meeting_bottom_image3` text NOT NULL,
  `txt_meeting_bottom_image4` text NOT NULL,
  `txt_meeting_bottom_image5` text NOT NULL,
  `txt_meeting_title` text NOT NULL,
  `int_meeting_date` int(11) NOT NULL,
  `txt_meeting_description` text NOT NULL,
  `txt_meeting_readmore` text NOT NULL,
  `txt_meeting_htmlcontent` text NOT NULL,
  `bint_meeting_number` bigint(10) NOT NULL,
  `txt_meeting_pagetitle` text NOT NULL,
  `txt_meeting_meta_description` text NOT NULL,
  `txt_meeting_meta_keywords` text NOT NULL,
  `enum_meeting_visible` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`bint_meetingID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `tbl_meeting_info`
--

INSERT INTO `tbl_meeting_info` (`bint_meetingID`, `txt_meeting_image`, `txt_meeting_bottom_image1`, `txt_meeting_bottom_image2`, `txt_meeting_bottom_image3`, `txt_meeting_bottom_image4`, `txt_meeting_bottom_image5`, `txt_meeting_title`, `int_meeting_date`, `txt_meeting_description`, `txt_meeting_readmore`, `txt_meeting_htmlcontent`, `bint_meeting_number`, `txt_meeting_pagetitle`, `txt_meeting_meta_description`, `txt_meeting_meta_keywords`, `enum_meeting_visible`) VALUES
(10, '1268769188_board_meeting.jpg', '1268769188_board_meeting.jpg', '1268769188_board_meeting.jpg', '1268797479_chairperson.jpg', '1268805817_chairperson.jpg', '1268805817_chairperson.jpg', 'jkkjhk', 1283299200, 'hjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsum', '', '<p><span style=\\"color: rgb(255, 255, 0);\\"><span style=\\"font-size: medium;\\">hjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsum</span></span></p>', 66767, '67657657', '767', '                                67576576', 'Y'),
(11, '1268830759_board_meeting.jpg', '1268771455_ipwea.jpg', '1268771566_picplaceholder1.jpg', '1268771455_meeting-pic2.jpg', '', '', 'iug ddd wewe drdr  nn', 1268784000, 'hjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsum', '8768768', '<p><span style=\\"\\"><span style=\\"\\">hjh  hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg  content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content  content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content  coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty  hgh jgjhgtlorem ipsum</span></span></p>', 0, '768768768', '7876876', '             8687687', 'Y'),
(12, '1268830848_board_meeting.jpg', '1268830848_launch_acelg.jpg', 'khkj', 'kjhkjh', '', '', 'jkkjhk', 1266364800, 'hjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsum', '7657', '<p><span style=\\"\\"><span style=\\"\\">hjh  hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg  content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content  content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content  coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty  hgh jgjhgtlorem ipsum</span></span></p>', 0, '67657657', 'hjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsum', '         67576576', 'Y'),
(15, '1268762594_header_bg.jpg', '1268832234_header_program_bg.gif', '1268832234_meeting-pic1.jpg', '1268832234_board_meeting.jpg', '1268832234_meeting-pic2.jpg', '1268832234_meeting-pic3.jpg', 'old mee ting', 1152144000, 'hjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsum', '', '<p><span style=\\"\\"><span style=\\"\\">hjh  hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg  content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content  content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content  coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty  hgh jgjhgtlorem ipsum</span></span></p>', 0, '', '', '     ', 'Y'),
(16, '1268830955_board_meeting.jpg', '', '', '', '', '1268808885_read_more_in_off.gif', 'title', 1268784000, 'hjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsum', '', '<p>select *  from tbl_meeting_info where bint_meetingID=10select *  from tbl_meeting_info where bint_meetingID=10select *  from tbl_meeting_info where bint_meetingID=10select *  from tbl_meeting_info where bint_meetingID=10select *  from tbl_meeting_info where bint_meetingID=10select *  from tbl_meeting_info where bint_meetingID=10select *  from tbl_meeting_info where bint_meetingID=10select *  from tbl_meeting_info where bint_meetingID=10</p>', 0, '', '', '       ', 'Y'),
(17, '1268830999_board_meeting.jpg', '', '', '', '', '', 'acagadg hdghggggg g gfdd', 1268784000, 'hjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsum', '', '', 0, '', '', '  ', 'Y'),
(18, '1268831048_board-pic.gif', '', '', '', '', '', 'dorrrrety', 1268784000, 'hjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty hgh jgjhgtlorem ipsum', '', '<p><span style=\\"\\"><span style=\\"\\">hjh  hjgjhghghg content content coyhnrty  hgh jgjhgtlorem ipsumhjh hjgjhghghg  content content coyhnrty hgh  jgjhgtlorem ipsumhjh hjgjhghghg content  content coyhnrty hgh  jgjhgtlorem ipsumhjh hjgjhghghg content content  coyhnrty hgh  jgjhgtlorem ipsumhjh hjgjhghghg content content coyhnrty  hgh  jgjhgtlorem ipsum</span></span></p>', 0, '', '', '      ', 'Y');

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

--
-- Table structure for table `tbl_news_info`
--

CREATE TABLE IF NOT EXISTS `tbl_news_info` (
  `bint_newsID` bigint(16) NOT NULL auto_increment,
  `txt_news_image` text NOT NULL,
  `txt_news_title` text NOT NULL,
  `txt_news_place` text NOT NULL,
  `int_news_date` int(11) NOT NULL,
  `txt_news_short_description` text NOT NULL,
  `txt_news_long_description` text NOT NULL,
  `enum_news_visible` enum('Y','N') NOT NULL,
  `txt_news_pagetitle` text NOT NULL,
  `txt_news_meta_description` text NOT NULL,
  `txt_news_meta_keywords` text NOT NULL,
  PRIMARY KEY  (`bint_newsID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `tbl_news_info`
--

INSERT INTO `tbl_news_info` (`bint_newsID`, `txt_news_image`, `txt_news_title`, `txt_news_place`, `int_news_date`, `txt_news_short_description`, `txt_news_long_description`, `enum_news_visible`, `txt_news_pagetitle`, `txt_news_meta_description`, `txt_news_meta_keywords`) VALUES
(2, '1268858342_new_pic.jpg', 'Chennai Super Kings', 'txt_news_place', 1270512000, '', '<p>ACELG was officially launched on 14 December by Hon  Anthony  Albanese, Minister for Infrastructure, Transport, Regional Development   and Local Government. The Minister also released the first ACELG <a target=\\"_blank\\" href=\\"https://www.acelg.org.au/Documents/ACELG_Project_Plan.pdf\\">Project  Plan</a> and opened the international <a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/roundtable-metropolitan-governace.html\\">Roundtable  on Metropolitan  Governance</a>.</p> <p>The launch was hosted by the University of  Technology,  Sydney, which leads the ACELG consortium, and attended by  around 70 invited  guests including Hon Maxine McKew, Parliamentary  Secretary for Local  Government, Cllr Philip Black, Deputy Lord Mayor of  Sydney, senior state and  federal government officials, international  guests and representatives of ACELG  consortium and program partners.</p> <p>Mr Albanese commented said that the Centre of  Excellence is the first of its kind  in Australia and is part of the  Rudd Government`s historic partnership with  local government to improve  the way both levels of government serve local  communities.</p> <p>&quot;This  is a historic first for Australia - a centre dedicated to  supporting and  improving the way that local government serves their  communities,&quot; he  said.</p> <p>Recognising  the need for an institution that  focuses on improving efficiency and  performance in local government, Mr  Albanese said that Australia had for too  long trailed the rest of the  world.</p> <p>&quot;Until  now Australia has had a vacuum,&quot; he said. &quot;Over the last  decade a  lack of leadership has shown neglect of the local government  sector when it  comes to the attitude of the federal government.&quot;</p> <p>ACELG  board chairperson Hon Margaret Reynolds - a  former federal minister for local  government - said that the new centre  would usher in a new era of co-operation  between the three levels of  government in Australia. &quot;I do feel confident  that the work that this  new centre of excellence is going to do is really going  to engage the  three levels of government in recognising how much contribution  can be  made at the national level and to lives of Australian citizens.&quot;</p> <p>UTS  Vice-Chancellor Professor Ross Milbourne said  the 565 local governments across  Australia had a huge impact on  everyday lives, delivering essential services  and providing much of the  nation`s infrastructure.</p> <p>&quot;Despite  being less than six months old the centre has already  been very busy,&quot; Professor Milbourne said. &quot;A wide ranging consultation  with the sector is  well advanced, with discussions having already  occurred in all states and the  Northern Territory, and a number of  projects are already underway.&quot;</p> <strong>Examples  include:</strong> <ul type=\\"disc\\">     <li>the first ANZSOG Excellence in Local Government  Leadership program (for senior managers and elected leaders);</li>     <li>a new Graduate Certificate in Local Government  Leadership, as part of a national Emerging Leaders program for middle  managers;</li>     <li>guidelines on asset management for small  communities;</li>     <li>a national strategy to address the special  capacity-building needs of small rural-remote and Indigenous local  governments;</li>     <li>a national Local Government Innovation and  Knowledge Exchange to showcase outstanding examples of best practice;</li>     <li>the third Local Government Skills Forum;</li>     <li>a special LGMA Management Challenge to increase  women`s participation in over 100 councils across Australia; and</li>     <li>research papers and seminars on critical issues  facing local government.</li>     <li>Professor  Milbourne said these were just a few of  the plans in place for the coming year.  &quot;This Centre of Excellence  can, and will, make a very real difference to  Australia,&quot; he said.</li> </ul>', '', 'News & Events', 'Meta Description', 'meta keywords'),
(4, '1268858439_new_pic.jpg', 'Chennai Super Kings', 'txt_news_place', 1270512000, '', '<p>ACELG was officially launched on 14 December by Hon  Anthony  Albanese, Minister for Infrastructure, Transport, Regional Development   and Local Government. The Minister also released the first ACELG <a target=\\"_blank\\" href=\\"https://www.acelg.org.au/Documents/ACELG_Project_Plan.pdf\\">Project  Plan</a> and opened the international <a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/roundtable-metropolitan-governace.html\\">Roundtable  on Metropolitan  Governance</a>.</p> <p>The launch was hosted by the University of  Technology,  Sydney, which leads the ACELG consortium, and attended by  around 70 invited  guests including Hon Maxine McKew, Parliamentary  Secretary for Local  Government, Cllr Philip Black, Deputy Lord Mayor of  Sydney, senior state and  federal government officials, international  guests and representatives of ACELG  consortium and program partners.</p> <p>Mr Albanese commented said that the Centre of  Excellence is the first of its kind  in Australia and is part of the  Rudd Government`s historic partnership with  local government to improve  the way both levels of government serve local  communities.</p> <p>&quot;This  is a historic first for Australia - a centre dedicated to  supporting and  improving the way that local government serves their  communities,&quot; he  said.</p> <p>Recognising  the need for an institution that  focuses on improving efficiency and  performance in local government, Mr  Albanese said that Australia had for too  long trailed the rest of the  world.</p> <p>&quot;Until  now Australia has had a vacuum,&quot; he said. &quot;Over the last  decade a  lack of leadership has shown neglect of the local government  sector when it  comes to the attitude of the federal government.&quot;</p> <p>ACELG  board chairperson Hon Margaret Reynolds - a  former federal minister for local  government - said that the new centre  would usher in a new era of co-operation  between the three levels of  government in Australia. &quot;I do feel confident  that the work that this  new centre of excellence is going to do is really going  to engage the  three levels of government in recognising how much contribution  can be  made at the national level and to lives of Australian citizens.&quot;</p> <p>UTS  Vice-Chancellor Professor Ross Milbourne said  the 565 local governments across  Australia had a huge impact on  everyday lives, delivering essential services  and providing much of the  nation`s infrastructure.</p> <p>&quot;Despite  being less than six months old the centre has already  been very busy,&quot; Professor Milbourne said. &quot;A wide ranging consultation  with the sector is  well advanced, with discussions having already  occurred in all states and the  Northern Territory, and a number of  projects are already underway.&quot;</p> <strong>Examples  include:</strong> <ul type=\\"disc\\">     <li>the first ANZSOG Excellence in Local Government  Leadership program (for senior managers and elected leaders);</li>     <li>a new Graduate Certificate in Local Government  Leadership, as part of a national Emerging Leaders program for middle  managers;</li>     <li>guidelines on asset management for small  communities;</li>     <li>a national strategy to address the special  capacity-building needs of small rural-remote and Indigenous local  governments;</li>     <li>a national Local Government Innovation and  Knowledge Exchange to showcase outstanding examples of best practice;</li>     <li>the third Local Government Skills Forum;</li>     <li>a special LGMA Management Challenge to increase  women`s participation in over 100 councils across Australia; and</li>     <li>research papers and seminars on critical issues  facing local government.</li>     <li>Professor  Milbourne said these were just a few of  the plans in place for the coming year.  &quot;This Centre of Excellence  can, and will, make a very real difference to  Australia,&quot; he said.</li> </ul>', '', 'News & Events', 'Meta Description', 'meta keywords'),
(5, '1268858534_new_pic.jpg', 'Chennai Super Kings', 'txt_news_place', 1270512000, '', '<p>ACELG was officially launched on 14 December by Hon  Anthony  Albanese, Minister for Infrastructure, Transport, Regional Development   and Local Government. The Minister also released the first ACELG <a target=\\"_blank\\" href=\\"https://www.acelg.org.au/Documents/ACELG_Project_Plan.pdf\\">Project  Plan</a> and opened the international <a href=\\"file:///C:/Documents%20and%20Settings/acer/Desktop/acelg/acelgnew/html/roundtable-metropolitan-governace.html\\">Roundtable  on Metropolitan  Governance</a>.</p> <p>The launch was hosted by the University of  Technology,  Sydney, which leads the ACELG consortium, and attended by  around 70 invited  guests including Hon Maxine McKew, Parliamentary  Secretary for Local  Government, Cllr Philip Black, Deputy Lord Mayor of  Sydney, senior state and  federal government officials, international  guests and representatives of ACELG  consortium and program partners.</p> <p>Mr Albanese commented said that the Centre of  Excellence is the first of its kind  in Australia and is part of the  Rudd Government`s historic partnership with  local government to improve  the way both levels of government serve local  communities.</p> <p>&quot;This  is a historic first for Australia - a centre dedicated to  supporting and  improving the way that local government serves their  communities,&quot; he  said.</p> <p>Recognising  the need for an institution that  focuses on improving efficiency and  performance in local government, Mr  Albanese said that Australia had for too  long trailed the rest of the  world.</p> <p>&quot;Until  now Australia has had a vacuum,&quot; he said. &quot;Over the last  decade a  lack of leadership has shown neglect of the local government  sector when it  comes to the attitude of the federal government.&quot;</p> <p>ACELG  board chairperson Hon Margaret Reynolds - a  former federal minister for local  government - said that the new centre  would usher in a new era of co-operation  between the three levels of  government in Australia. &quot;I do feel confident  that the work that this  new centre of excellence is going to do is really going  to engage the  three levels of government in recognising how much contribution  can be  made at the national level and to lives of Australian citizens.&quot;</p> <p>UTS  Vice-Chancellor Professor Ross Milbourne said  the 565 local governments across  Australia had a huge impact on  everyday lives, delivering essential services  and providing much of the  nation`s infrastructure.</p> <p>&quot;Despite  being less than six months old the centre has already  been very busy,&quot; Professor Milbourne said. &quot;A wide ranging consultation  with the sector is  well advanced, with discussions having already  occurred in all states and the  Northern Territory, and a number of  projects are already underway.&quot;</p> <strong>Examples  include:</strong> <ul type=\\"disc\\">     <li>the first ANZSOG Excellence in Local Government  Leadership program (for senior managers and elected leaders);</li>     <li>a new Graduate Certificate in Local Government  Leadership, as part of a national Emerging Leaders program for middle  managers;</li>     <li>guidelines on asset management for small  communities;</li>     <li>a national strategy to address the special  capacity-building needs of small rural-remote and Indigenous local  governments;</li>     <li>a national Local Government Innovation and  Knowledge Exchange to showcase outstanding examples of best practice;</li>     <li>the third Local Government Skills Forum;</li>     <li>a special LGMA Management Challenge to increase  women`s participation in over 100 councils across Australia; and</li>     <li>research papers and seminars on critical issues  facing local government.</li>     <li>Professor  Milbourne said these were just a few of  the plans in place for the coming year.  &quot;This Centre of Excellence  can, and will, make a very real difference to  Australia,&quot; he said.</li> </ul>', '', 'News & Events', 'Meta Description', 'meta keywords');

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

--
-- Table structure for table `tbl_partners_info`
--

CREATE TABLE IF NOT EXISTS `tbl_partners_info` (
  `bint_partnersID` bigint(16) NOT NULL auto_increment,
  `vch_partners_name` varchar(255) NOT NULL,
  `txt_partners_image` text NOT NULL,
  `txt_partners_shortdescription` text NOT NULL,
  `txt_partners_longdescription` text NOT NULL,
  `txt_partners_url` text NOT NULL,
  `txt_partners_readmore` text NOT NULL,
  `enum_partners_visible` enum('Y','N') NOT NULL default 'Y',
  `txt_partners_page_title` text NOT NULL,
  `txt_partners_meta_description` text NOT NULL,
  `txt_partners_keywords` text NOT NULL,
  PRIMARY KEY  (`bint_partnersID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `tbl_partners_info`
--

INSERT INTO `tbl_partners_info` (`bint_partnersID`, `vch_partners_name`, `txt_partners_image`, `txt_partners_shortdescription`, `txt_partners_longdescription`, `txt_partners_url`, `txt_partners_readmore`, `enum_partners_visible`, `txt_partners_page_title`, `txt_partners_meta_description`, `txt_partners_keywords`) VALUES
(21, 'UTS Centre for Local GovernmentUTS Centre for Local Government', '1268552000_uts-logo.jpg', 'The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.', '<p><strong> The  Centre''s activities are diverse and include:</strong></p>\r\n            	<ul type="disc">\r\n                  <li>professional       development programs for local government personnel&nbsp;and associated       professionals</li>\r\n                  <li>a Graduate       Diploma in Local Government Management</li>\r\n                  <li>research into       various aspects of local government and governance</li>\r\n                  <li>specialist       consultancy services for councils and State and Federal agencies</li>\r\n                  <li>international       programs and projects.</li>\r\n                </ul>\r\n                <p>The  Centre promotes a cooperative approach to local government education, research  and development, and maintains close ties with a large number of local  government associations, professional institutes and academic bodies in  Australia, the Asia-Pacific and globally.</p>\r\n                <p> The  Centre''s mission is to support the advancement and improvement of local  government both in Australia and internationally through leadership in  education and research, and by providing specialist consultancy services.</p>\r\n                <p><strong>Contact Info</strong>\r\n                City Campus<br />\r\n                15 Broadway,<br />\r\n                Ultimo, NSW 2007<br />\r\n                Kuring-gai Campus<br />\r\n                Eton Road,<br />\r\n                Lindfield, NSW 2070<br />\r\n                Phone: +61 2 9514 2000\r\n                </p>\r\n', 'www.signitysolutions.com', 'www.signitysolutions.com', 'Y', 'Partners', 'Meta description', 'MEta key words'),
(20, 'UTS Centre for Local Government', '1268685916_uoc-logo.jpg', 'The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.', '<p><strong> The  Centre`s activities are diverse and include:</strong></p>\r\n<ul type=\\"disc\\">\r\n    <li>professional       development programs for local  government personnel&nbsp;and associated       professionals</li>\r\n    <li>a Graduate       Diploma in Local Government  Management</li>\r\n    <li>research into       various aspects of local  government and governance</li>\r\n    <li>specialist       consultancy services for councils  and State and Federal agencies</li>\r\n    <li>international       programs and projects.</li>\r\n</ul>\r\n<p>The  Centre promotes a cooperative approach to local  government education, research  and development, and maintains close  ties with a large number of local  government associations, professional  institutes and academic bodies in  Australia, the Asia-Pacific and  globally.</p>\r\n<p>The  Centre`s mission is to support the advancement  and improvement of local  government both in Australia and  internationally through leadership in  education and research, and by  providing specialist consultancy services.</p>\r\n<p><strong>Contact Info</strong>                 City Campus<br />\r\n15 Broadway,<br />\r\nUltimo, NSW 2007<br />\r\nKuring-gai Campus<br />\r\nEton Road,<br />\r\nLindfield, NSW 2070<br />\r\nPhone: +61 2 9514 2000</p>', 'http://www.acelg.com', '', 'Y', 'Partners', 'Meta description', 'MEta key words'),
(19, 'UTS Centre for Local GovernmentUTS Centre for Local Government', '1268551996_uts-logo.jpg', 'The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.', '<p><strong> The  Centre`s activities are diverse and include:</strong></p>\r\n<ul type=\\"disc\\">\r\n    <li>professional       development programs for local  government personnel&nbsp;and associated       professionals</li>\r\n    <li>a Graduate       Diploma in Local Government  Management</li>\r\n    <li>research into       various aspects of local  government and governance</li>\r\n    <li>specialist       consultancy services for councils  and State and Federal agencies</li>\r\n    <li>international       programs and projects.</li>\r\n</ul>\r\n<p>The  Centre promotes a cooperative approach to local  government education, research  and development, and maintains close  ties with a large number of local  government associations, professional  institutes and academic bodies in  Australia, the Asia-Pacific and  globally.</p>\r\n<p>The  Centre`s mission is to support the advancement  and improvement of local  government both in Australia and  internationally through leadership in  education and research, and by  providing specialist consultancy services.</p>\r\n<p><strong>Contact Info</strong>                 City Campus<br />\r\n15 Broadway,<br />\r\nUltimo, NSW 2007<br />\r\nKuring-gai Campus<br />\r\nEton Road,<br />\r\nLindfield, NSW 2070<br />\r\nPhone: +61 2 9514 2000</p>', 'http://www.acelg.com', '', 'Y', 'Partners', 'Meta description', 'MEta key words'),
(22, 'UTS Centre for Local GovernmentUTS Centre for Local Government', '1268552001_uts-logo.jpg', 'The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.', '<p><strong> The  Centre`s activities are diverse and include:</strong></p>\r\n<ul type="disc">\r\n    <li>professional       development programs for local  government personnel&nbsp;and associated       professionals</li>\r\n    <li>a Graduate       Diploma in Local Government  Management</li>\r\n    <li>research into       various aspects of local  government and governance</li>\r\n    <li>specialist       consultancy services for councils  and State and Federal agencies</li>\r\n    <li>international       programs and projects.</li>\r\n</ul>\r\n<p>The  Centre promotes a cooperative approach to local  government education, research  and development, and maintains close  ties with a large number of local  government associations, professional  institutes and academic bodies in  Australia, the Asia-Pacific and  globally.</p>\r\n<p>The  Centre`s mission is to support the advancement  and improvement of local  government both in Australia and  internationally through leadership in  education and research, and by  providing specialist consultancy services.</p>\r\n<p><strong>Contact Info</strong>                 City Campus<br />\r\n15 Broadway,<br />\r\nUltimo, NSW 2007<br />\r\nKuring-gai Campus<br />\r\nEton Road,<br />\r\nLindfield, NSW 2070<br />\r\nPhone: +61 2 9514 2000</p>', 'www.signitysolutions.com', 'www.signitysolutions.com', 'Y', 'Partners', 'Meta description', 'MEta key words'),
(23, 'UTS Centre for Local GovernmentUTS Centre for Local Government', '1268552001_uts-logo.jpg', 'The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.', '<p><strong> The  Centre`s activities are diverse and include:</strong></p>\r\n<ul type="disc">\r\n    <li>professional       development programs for local  government personnel&nbsp;and associated       professionals</li>\r\n    <li>a Graduate       Diploma in Local Government  Management</li>\r\n    <li>research into       various aspects of local  government and governance</li>\r\n    <li>specialist       consultancy services for councils  and State and Federal agencies</li>\r\n    <li>international       programs and projects.</li>\r\n</ul>\r\n<p>The  Centre promotes a cooperative approach to local  government education, research  and development, and maintains close  ties with a large number of local  government associations, professional  institutes and academic bodies in  Australia, the Asia-Pacific and  globally.</p>\r\n<p>The  Centre`s mission is to support the advancement  and improvement of local  government both in Australia and  internationally through leadership in  education and research, and by  providing specialist consultancy services.</p>\r\n<p><strong>Contact Info</strong>                 City Campus<br />\r\n15 Broadway,<br />\r\nUltimo, NSW 2007<br />\r\nKuring-gai Campus<br />\r\nEton Road,<br />\r\nLindfield, NSW 2070<br />\r\nPhone: +61 2 9514 2000</p>', 'www.signitysolutions.com', 'www.signitysolutions.com', 'Y', 'Partners', 'Meta description', 'MEta key words'),
(24, 'UTS Centre for Local GovernmentUTS Centre for Local Government', '1268552002_uts-logo.jpg', 'The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.The UTS Centre for Local Government is an autonomous unit within the University of Technology, Sydney. It was established in 1991 and is now the largest centre of its kind in Australia.', '<p><strong> The  Centre`s activities are diverse and include:</strong></p>\r\n<ul type="disc">\r\n    <li>professional       development programs for local  government personnel&nbsp;and associated       professionals</li>\r\n    <li>a Graduate       Diploma in Local Government  Management</li>\r\n    <li>research into       various aspects of local  government and governance</li>\r\n    <li>specialist       consultancy services for councils  and State and Federal agencies</li>\r\n    <li>international       programs and projects.</li>\r\n</ul>\r\n<p>The  Centre promotes a cooperative approach to local  government education, research  and development, and maintains close  ties with a large number of local  government associations, professional  institutes and academic bodies in  Australia, the Asia-Pacific and  globally.</p>\r\n<p>The  Centre`s mission is to support the advancement  and improvement of local  government both in Australia and  internationally through leadership in  education and research, and by  providing specialist consultancy services.</p>\r\n<p><strong>Contact Info</strong>                 City Campus<br />\r\n15 Broadway,<br />\r\nUltimo, NSW 2007<br />\r\nKuring-gai Campus<br />\r\nEton Road,<br />\r\nLindfield, NSW 2070<br />\r\nPhone: +61 2 9514 2000</p>', 'www.signitysolutions.com', 'www.signitysolutions.com', 'Y', 'Partners', 'Meta description', 'MEta key words');

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

--
-- Table structure for table `tbl_programs_info`
--

CREATE TABLE IF NOT EXISTS `tbl_programs_info` (
  `bint_programID` bigint(16) NOT NULL auto_increment,
  `vch_program_title` varchar(255) NOT NULL,
  `txt_program_content` text NOT NULL,
  PRIMARY KEY  (`bint_programID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_programs_info`
--


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

--
-- Table structure for table `tbl_program_contactinfo`
--

CREATE TABLE IF NOT EXISTS `tbl_program_contactinfo` (
  `bint_program_contactID` bigint(16) NOT NULL auto_increment,
  `bint_programID` bigint(16) NOT NULL,
  `vch_program_contactName` varchar(255) NOT NULL,
  `vch_program_contactEmail` varchar(255) NOT NULL,
  `vch_program_contactImage` varchar(255) NOT NULL,
  PRIMARY KEY  (`bint_program_contactID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_program_contactinfo`
--


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

--
-- Table structure for table `tbl_staff_members`
--

CREATE TABLE IF NOT EXISTS `tbl_staff_members` (
  `bint_staffID` bigint(20) NOT NULL auto_increment,
  `vch_staff_name` varchar(255) NOT NULL,
  `txt_staff_title` text NOT NULL,
  `txt_staff_description` text NOT NULL,
  `txt_staff_image` text NOT NULL,
  `txt_staff_readmore` text NOT NULL,
  `bint_staff_display_characters` bigint(20) NOT NULL,
  `enum_staff_visible` enum('Y','N') NOT NULL default 'N',
  `txt_staff_pagetitle` text NOT NULL,
  `txt_staff_meta_description` text NOT NULL,
  `txt_staff_meta_keywords` text NOT NULL,
  PRIMARY KEY  (`bint_staffID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `tbl_staff_members`
--

INSERT INTO `tbl_staff_members` (`bint_staffID`, `vch_staff_name`, `txt_staff_title`, `txt_staff_description`, `txt_staff_image`, `txt_staff_readmore`, `bint_staff_display_characters`, `enum_staff_visible`, `txt_staff_pagetitle`, `txt_staff_meta_description`, `txt_staff_meta_keywords`) VALUES
(8, 'abcd', 'Chair Person', 'Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation.\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\r\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\r\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\nConsectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation', '1268659975_chairperson-large.jpg', '', 333, 'N', 'Staff members', 'Meta description', 'Meta Keywords'),
(9, 'Amit Dua', 'Chair Person Of signity', 'Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation.\\\\r\\\\n\\\\r\\\\nConsectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation', '1268545936_staff-pic.gif', 'http://www.google.com', 333, 'N', 'Staff members', 'Meta description', 'Meta Keywords'),
(10, 'Amit Dua', 'Chair Person Of signity', 'Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation.\\r\\n\\r\\nConsectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation', '1268545939_staff-pic.gif', 'www.signitysolutions.com', 333, 'N', 'Staff members', 'Meta description', 'Meta Keywords'),
(11, 'Amit Dua', 'Chair Person Of signity', 'Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation.\\r\\n\\r\\nConsectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation', '1268545941_staff-pic.gif', 'www.signitysolutions.com', 333, 'N', 'Staff members', 'Meta description', 'Meta Keywords'),
(12, 'Amit Dua', 'Chair Person Of signity', 'Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation.\\r\\n\\r\\nConsectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation. Consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation Ut enim ad minim veniam, quis nostrud exercitation', '1268546106_staff-pic.gif', 'www.signitysolutions.com', 333, 'N', 'Staff members', 'Meta description', 'Meta Keywords');