--
-- Host: localhost    Database: elec
-- ------------------------------------------------------


--
-- Table structure for table `jos_banner`
--

CREATE TABLE `jos_banner` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT '0',
  `type` varchar(30) NOT NULL DEFAULT 'banner',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `imptotal` int(11) NOT NULL DEFAULT '0',
  `impmade` int(11) NOT NULL DEFAULT '0',
  `clicks` int(11) NOT NULL DEFAULT '0',
  `imageurl` varchar(100) NOT NULL DEFAULT '',
  `clickurl` varchar(200) NOT NULL DEFAULT '',
  `date` datetime DEFAULT NULL,
  `showBanner` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `editor` varchar(50) DEFAULT NULL,
  `custombannercode` text,
  `catid` int(10) unsigned NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tags` text NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`bid`),
  KEY `viewbanner` (`showBanner`),
  KEY `idx_banner_catid` (`catid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_banner`
--

INSERT INTO `jos_banner` VALUES (1,1,'','sisa','sisa',0,649813,368,'sisa.jpg','http://sisa.northmbk.ac.th/frdsisa/','2012-06-08 06:13:06',1,0,'0000-00-00 00:00:00','','',3,'',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','','width=0\nheight=0'),(2,2,'','activity','activity',0,649742,486,'activity.jpg','http://elec.northmbk.ac.th/index.php?option=com_content&view=category&layout=blog&id=1&Itemid=6','2012-07-17 14:29:18',1,0,'0000-00-00 00:00:00','','',3,'',1,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','','width=0\nheight=0'),(3,3,'','webboard','webboard',0,646662,509,'webboard.jpg','http://elec.northmbk.ac.th/index.php?option=com_kunena&view=listcat&catid=0&func=listcat&Itemid=8','2012-10-31 06:59:10',1,0,'0000-00-00 00:00:00','','',3,'',0,3,'0000-00-00 00:00:00','0000-00-00 00:00:00','','width=0\nheight=0'),(4,4,'','ห้องสมุด','',0,646428,327,'lib.jpg','http://lib.northmbk.ac.th/Library.asp','2012-11-06 05:55:41',1,0,'0000-00-00 00:00:00','','',3,'',0,4,'0000-00-00 00:00:00','0000-00-00 00:00:00','','width=0\nheight=0'),(5,5,'','นวรรตกรรม','',0,645846,250,'link.jpg','http://electronic-love-of-free-doom.blogspot.com/','2012-12-25 03:25:06',1,0,'0000-00-00 00:00:00','','',3,'',0,5,'0000-00-00 00:00:00','0000-00-00 00:00:00','','width=0\nheight=0');

--
-- Table structure for table `jos_bannerclient`
--

CREATE TABLE `jos_bannerclient` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `contact` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `extrainfo` text NOT NULL,
  `checked_out` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out_time` time DEFAULT NULL,
  `editor` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bannerclient`
--

INSERT INTO `jos_bannerclient` VALUES (1,'sisa','sisa','info@sisa.com','',0,'00:00:00',''),(2,'activity','activity','arm_pree@hotmail.com','',0,'00:00:00',''),(3,'webboard','webboard','arm_pree@hotmail.com','',0,'00:00:00',''),(4,'ห้องสมุด','ระบบสืบค้นห้องสมุด','arm_pree@hotmail.com','',0,'00:00:00',''),(5,'นวรรตกรรม','นวรรตกรรม','arm_pree@hotmail.com','',0,'00:00:00','');

--
-- Table structure for table `jos_bannertrack`
--

CREATE TABLE `jos_bannertrack` (
  `track_date` date NOT NULL,
  `track_type` int(10) unsigned NOT NULL,
  `banner_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bannertrack`
--


--
-- Table structure for table `jos_categories`
--

CREATE TABLE `jos_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `image` varchar(255) NOT NULL DEFAULT '',
  `section` varchar(50) NOT NULL DEFAULT '',
  `image_position` varchar(30) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `editor` varchar(50) DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cat_idx` (`section`,`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_categories`
--

INSERT INTO `jos_categories` VALUES (1,0,'ภาพกิจกรรม','','new','','1','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(2,0,'about','','about','','1','left','',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),(3,0,'Banner','','banner','','com_banner','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(4,0,'ข่าวกิจกรรม','','-m---m-s','','1','left','',1,0,'0000-00-00 00:00:00',NULL,3,0,0,''),(5,0,'ค่าปกติ','ค่าปกติ','','','com_jevents','left','',1,0,'0000-00-00 00:00:00',NULL,0,0,0,'');

--
-- Table structure for table `jos_components`
--

CREATE TABLE `jos_components` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `menuid` int(11) unsigned NOT NULL DEFAULT '0',
  `parent` int(11) unsigned NOT NULL DEFAULT '0',
  `admin_menu_link` varchar(255) NOT NULL DEFAULT '',
  `admin_menu_alt` varchar(255) NOT NULL DEFAULT '',
  `option` varchar(50) NOT NULL DEFAULT '',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `admin_menu_img` varchar(255) NOT NULL DEFAULT '',
  `iscore` tinyint(4) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `parent_option` (`parent`,`option`(32))
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_components`
--

INSERT INTO `jos_components` VALUES (1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,'track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n',1),(2,'Banners','',0,1,'option=com_banners','Active Banners','com_banners',1,'js/ThemeOffice/edit.png',0,'',1),(3,'Clients','',0,1,'option=com_banners&c=client','Manage Clients','com_banners',2,'js/ThemeOffice/categories.png',0,'',1),(4,'Web Links','option=com_weblinks',0,0,'','Manage Weblinks','com_weblinks',0,'js/ThemeOffice/component.png',0,'show_comp_description=1\ncomp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n',1),(5,'Links','',0,4,'option=com_weblinks','View existing weblinks','com_weblinks',1,'js/ThemeOffice/edit.png',0,'',1),(6,'Categories','',0,4,'option=com_categories&section=com_weblinks','Manage weblink categories','',2,'js/ThemeOffice/categories.png',0,'',1),(7,'Contacts','option=com_contact',0,0,'','Edit contact details','com_contact',0,'js/ThemeOffice/component.png',1,'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',1),(8,'Contacts','',0,7,'option=com_contact','Edit contact details','com_contact',0,'js/ThemeOffice/edit.png',1,'',1),(9,'Categories','',0,7,'option=com_categories&section=com_contact_details','Manage contact categories','',2,'js/ThemeOffice/categories.png',1,'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',1),(10,'Polls','option=com_poll',0,0,'option=com_poll','Manage Polls','com_poll',0,'js/ThemeOffice/component.png',0,'',1),(11,'News Feeds','option=com_newsfeeds',0,0,'','News Feeds Management','com_newsfeeds',0,'js/ThemeOffice/component.png',0,'',1),(12,'Feeds','',0,11,'option=com_newsfeeds','Manage News Feeds','com_newsfeeds',1,'js/ThemeOffice/edit.png',0,'show_headings=1\nshow_name=1\nshow_articles=1\nshow_link=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1\nshow_item_description=1\nfeed_word_count=0\n\n',1),(13,'Categories','',0,11,'option=com_categories&section=com_newsfeeds','Manage Categories','',2,'js/ThemeOffice/categories.png',0,'',1),(14,'User','option=com_user',0,0,'','','com_user',0,'',1,'',1),(15,'Search','option=com_search',0,0,'option=com_search','Search Statistics','com_search',0,'js/ThemeOffice/component.png',1,'enabled=0\n\n',1),(16,'Categories','',0,1,'option=com_categories&section=com_banner','Categories','',3,'',1,'',1),(17,'Wrapper','option=com_wrapper',0,0,'','Wrapper','com_wrapper',0,'',1,'',1),(18,'Mail To','',0,0,'','','com_mailto',0,'',1,'',1),(19,'Media Manager','',0,0,'option=com_media','Media Manager','com_media',0,'',1,'upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS,docx\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\nallowed_media_usergroup=3\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html\nenable_flash=0\n\n',1),(20,'Articles','option=com_content',0,0,'','','com_content',0,'',1,'show_noauth=0\nshow_title=0\nlink_titles=0\nshow_intro=0\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=0\nshow_create_date=0\nshow_modify_date=0\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=0\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=0\nshow_hits=0\nfeed_summary=0\nfilter_tags=\nfilter_attritbutes=\n\n',1),(21,'Configuration Manager','',0,0,'','Configuration','com_config',0,'',1,'',1),(22,'Installation Manager','',0,0,'','Installer','com_installer',0,'',1,'',1),(23,'Language Manager','',0,0,'','Languages','com_languages',0,'',1,'administrator=th-TH\nsite=th-TH\n\n',1),(24,'Mass mail','',0,0,'','Mass Mail','com_massmail',0,'',1,'mailSubjectPrefix=\nmailBodySuffix=\n\n',1),(25,'Menu Editor','',0,0,'','Menu Editor','com_menus',0,'',1,'',1),(27,'Messaging','',0,0,'','Messages','com_messages',0,'',1,'',1),(28,'Modules Manager','',0,0,'','Modules','com_modules',0,'',1,'',1),(29,'Plugin Manager','',0,0,'','Plugins','com_plugins',0,'',1,'',1),(30,'Template Manager','',0,0,'','Templates','com_templates',0,'',1,'',1),(31,'User Manager','',0,0,'','Users','com_users',0,'',1,'allowUserRegistration=1\nnew_usertype=Registered\nuseractivation=1\nfrontend_userparams=1\n\n',1),(32,'Cache Manager','',0,0,'','Cache','com_cache',0,'',1,'',1),(33,'Control Panel','',0,0,'','Control Panel','com_cpanel',0,'',1,'',1),(46,'WF_MENU_INSTALL','',0,34,'option=com_jce&view=installer','WF_MENU_INSTALL','com_jce',3,'components/com_jce/media/img/menu/jce-install.png',0,'',1),(45,'WF_MENU_PROFILES','',0,34,'option=com_jce&view=profiles','WF_MENU_PROFILES','com_jce',2,'components/com_jce/media/img/menu/jce-profiles.png',0,'',1),(44,'WF_MENU_CONFIG','',0,34,'option=com_jce&view=config','WF_MENU_CONFIG','com_jce',1,'components/com_jce/media/img/menu/jce-config.png',0,'',1),(34,'JCE','option=com_jce',0,0,'option=com_jce','JCE','com_jce',0,'components/com_jce/media/img/menu/logo.png',0,'',1),(43,'WF_MENU_CPANEL','',0,34,'option=com_jce','WF_MENU_CPANEL','com_jce',0,'components/com_jce/media/img/menu/jce-cpanel.png',0,'',1),(47,'COM_KUNENA','option=com_kunena',0,0,'option=com_kunena','COM_KUNENA','com_kunena',0,'components/com_kunena/media/icons/kunena-favicon.png',0,'',1),(48,'COM_KUNENA_CONFIGURATION','',0,47,'option=com_kunena&task=showconfig','COM_KUNENA_CONFIGURATION','com_kunena',0,'components/com_kunena/media/icons/config-favicon.png',0,'',1),(49,'COM_KUNENA_CATEGORY_MANAGER','',0,47,'option=com_kunena&task=showAdministration','COM_KUNENA_CATEGORY_MANAGER','com_kunena',1,'components/com_kunena/media/icons/forums-favicon.png',0,'',1),(50,'COM_KUNENA_USER_MANAGER','',0,47,'option=com_kunena&task=showprofiles','COM_KUNENA_USER_MANAGER','com_kunena',2,'components/com_kunena/media/icons/users-favicon.png',0,'',1),(51,'COM_KUNENA_TEMPLATE_MANAGER','',0,47,'option=com_kunena&task=showTemplates','COM_KUNENA_TEMPLATE_MANAGER','com_kunena',3,'components/com_kunena/media/icons/templates-favicon.png',0,'',1),(52,'COM_KUNENA_RANK_MANAGER','',0,47,'option=com_kunena&task=ranks','COM_KUNENA_RANK_MANAGER','com_kunena',4,'components/com_kunena/media/icons/ranks-favicon.png',0,'',1),(53,'COM_KUNENA_TRASH_MANAGER','',0,47,'option=com_kunena&task=showtrashview','COM_KUNENA_TRASH_MANAGER','com_kunena',5,'components/com_kunena/media/icons/trash-favicon.png',0,'',1),(54,'JEvents MVC','option=com_jevents',0,0,'option=com_jevents','JEvents MVC','com_jevents',0,'js/ThemeOffice/component.png',0,'com_calViewName=default\ncom_dateformat=1\ncom_calUseStdTime=1\ncom_blockRobots=1\nrobotprior=-1 month\nrobotpost=+1 month\ncom_cache=0\ncom_calHeadline=comp\ncom_calUseIconic=1\ncom_navbarcolor=green\ncom_earliestyear=2000\ncom_latestyear=2015\ncom_starday=0\ncom_print_icon_view=1\ncom_hideshowbycats=1\ncom_copyright=1\ninstalllayouts=0\njevadmin=62\nauthorisedonly=0\njevcreator_level=19\njeveditor_level=20\njevpublish_level=21\njevpublishown=0\neditpopup=0\npopupw=800\npopuph=500\ndefaultcat=0\ncom_defColor=category\ncom_calForceCatColorEventForm=0\ncom_single_pane_edit=0\ncom_show_editor_buttons=0\ncom_editor_button_exceptions=\ncom_notifyboth=0\ncom_notifyallevents=0\nshowpriority=0\ncom_mailview=1\ncom_byview=1\ncom_hitsview=1\ncom_repeatview=1\ncom_calCutTitle=15\ncom_calMaxDisplay=15\ncom_calDisplayStarttime=1\ncom_enableToolTip=1\ncom_calTTBackground=1\ncom_calTTPosX=LEFT\ncom_calTTPosY=BELOW\ncom_calTTShadow=0\ncom_calTTShadowX=0\ncom_calTTShadowY=0\ncom_showrepeats=1\ncom_calEventListRowsPpg=10\nshowyeardate=0\nshowyearpast=1\ncom_rss_cache=1\ncom_rss_cache_time=3600\ncom_rss_count=5\ncom_rss_live_bookmarks=1\ncom_rss_modid=0\ncom_rss_title=JEvents Syndication for Joomla\ncom_rss_description=Powered by JEvents!\ncom_rss_limit_text=0\ncom_rss_text_length=20\nmodcal_DispLastMonth=NO\nmodcal_DispLastMonthDays=0\nmodcal_DispNextMonth=NO\nmodcal_DispNextMonthDays=0\nmodcal_LinkCloaking=0\nmodlatest_MaxEvents=10\nmodlatest_Mode=0\nmodlatest_Days=5\nmodlatest_NoRepeat=1\nmodlatest_DispLinks=1\nmodlatest_DispYear=0\nmodlatest_DisDateStyle=0\nmodlatest_DisTitleStyle=0\nmodlatest_LinkToCal=0\nmodlatest_LinkCloaking=0\nmodlatest_SortReverse=0\nmodlatest_CustFmtStr=${eventDate}[!a: - ${endDate(%I:%M%p)}]\\n${title}\nmodlatest_RSS=0\n\n',1);

--
-- Table structure for table `jos_contact_details`
--

CREATE TABLE `jos_contact_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `con_position` varchar(255) DEFAULT NULL,
  `address` text,
  `suburb` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `postcode` varchar(100) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `misc` mediumtext,
  `image` varchar(255) DEFAULT NULL,
  `imagepos` varchar(20) DEFAULT NULL,
  `email_to` varchar(255) DEFAULT NULL,
  `default_con` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `published` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `catid` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `mobile` varchar(255) NOT NULL DEFAULT '',
  `webpage` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_contact_details`
--


--
-- Table structure for table `jos_content`
--

CREATE TABLE `jos_content` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `title_alias` varchar(255) NOT NULL DEFAULT '',
  `introtext` mediumtext NOT NULL,
  `fulltext` mediumtext NOT NULL,
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `sectionid` int(11) unsigned NOT NULL DEFAULT '0',
  `mask` int(11) unsigned NOT NULL DEFAULT '0',
  `catid` int(11) unsigned NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(11) unsigned NOT NULL DEFAULT '0',
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `images` text NOT NULL,
  `urls` text NOT NULL,
  `attribs` text NOT NULL,
  `version` int(11) unsigned NOT NULL DEFAULT '1',
  `parentid` int(11) unsigned NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `metakey` text NOT NULL,
  `metadesc` text NOT NULL,
  `access` int(11) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '0',
  `metadata` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_section` (`sectionid`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_catid` (`catid`),
  KEY `idx_createdby` (`created_by`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_content`
--

INSERT INTO `jos_content` VALUES (1,'เกี่ยวกับแผนก','-m-m-s','','<p style=\"text-align: center;\"><span style=\"color: #000080; font-size: 14pt;\">สาขาวิชาอิเล็กทรอนิกส์</span></p>\r\n<p style=\"text-align: center;\"><span style=\"color: #000080; font-size: 14pt;\">เปิดสอนในระดับ ปวช. และ ปวส. </span></p>\r\n<p style=\"text-align: center;\"><span style=\"color: #000080; font-size: 14pt;\">สาขางานอิเล็กทรอนิกส์ และสาขางานเทคนิคคอมพิวเตอร์ </span></p>\r\n<p style=\"text-align: center;\"><span style=\"color: #000080; font-size: 14pt;\">สอบถามรายละเอียดเพิ่มเติมได้ที่ </span></p>\r\n<p style=\"text-align: center;\"><span style=\"color: #000080; font-size: 14pt;\">อ.ผ่องอำไพ เสนแสง 084 - 8090022</span></p>\r\n<p style=\"text-align: center;\"><span style=\"color: #000080; font-size: 14pt;\">อ.ณัฐพล จอมขันเงิน 081 - 6733615</span></p>\r\n<p><img style=\"display: block; margin-left: auto; margin-right: auto;\" alt=\"IMG 6191 resize\" src=\"images/stories/008/IMG_6191_resize.JPG\" height=\"253\" width=\"168\" /></p>\r\n<p><img alt=\"IMG 6185 resize\" src=\"images/stories/008/IMG_6185_resize.JPG\" height=\"328\" width=\"492\" /></p>','',1,1,0,2,'0000-00-00 00:00:00',62,'','2013-06-07 04:06:22',62,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',3,0,2,'','',0,721,'robots=\nauthor='),(2,'อาจารย์ในแผนก','-m-m-s','','<p><img style=\"display: block; margin-left: auto; margin-right: auto;\" alt=\"kung\" src=\"images/stories/contac/kung.jpg\" height=\"249\" width=\"217\" /></p>\r\n<p style=\"text-align: center;\"><strong><span style=\"color: #000080;\">อ.ผ่องอำไพ เสนแสง</span></strong></p>\r\n<p style=\"text-align: center;\"><strong><span style=\"color: #000080;\">หัวหน้าแผนก</span></strong></p>\r\n<p style=\"text-align: center;\"><strong><span style=\"color: #000080;\">081 - 8090022</span></strong></p>\r\n<p style=\"text-align: center;\">&nbsp;<img alt=\"DSC 1313 copy\" src=\"images/stories/contac/DSC_1313%20copy.jpg\" height=\"319\" width=\"213\" />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <img alt=\"arm\" src=\"images/stories/contac/arm.jpg\" height=\"320\" width=\"232\" /></p>\r\n<p style=\"text-align: left;\"><strong><span style=\"color: #000080;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; อ.ณัฐพล&nbsp; จอมขันเงิน &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; อ.ปรีดา&nbsp; รัตนพรม</span></strong></p>\r\n<p style=\"text-align: left;\"><strong><span style=\"color: #000080;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ฝ่ายพัฒนาคุณภาพนักศึกษา&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ฝ่ายซ่อมบำรุงแผนก</span></strong></p>\r\n<p style=\"text-align: left;\"><strong><span style=\"color: #000080;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 081-6733615&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 081 - 3868897</span></strong></p>\r\n<p style=\"text-align: left;\"><strong><span style=\"color: #000080;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img src=\"images/stories/contac/yim.jpg\" alt=\"\" height=\"288\" width=\"223\" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; <img src=\"images/stories/contac/kor.jpg\" alt=\"\" height=\"281\" width=\"232\" /></span></strong></p>\r\n<p style=\"text-align: left;\"><strong><span style=\"color: #000080;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; นางสาวอรพรรณ&nbsp; ศรีจันทร์&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; นายจักรพันธ์&nbsp;&nbsp;&nbsp;&nbsp; ธุระวร</span></strong></p>\r\n<p style=\"text-align: left;\"><strong><span style=\"color: #000080;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; นักศึกษาฝึกสอน&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <strong><span style=\"color: #000080;\">นักศึกษาฝึกสอน</span></strong></span></strong></p>\r\n<p style=\"text-align: left;\"><strong><span style=\"color: #000080;\"><strong><span style=\"color: #000080;\"></span></strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; 088 - 2634455&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 085&nbsp; - 6203540<br /></span></strong></p>\r\n<p style=\"text-align: left;\"><strong><span style=\"color: #000080;\"><br /></span></strong></p>','',1,1,0,2,'0000-00-00 00:00:00',62,'','2013-06-07 03:07:50',62,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',11,0,1,'','',0,755,'robots=\nauthor='),(3,'บ้านห้วยฮ่อม','-m-m-s','','<p>{vsig}001{/vsig}</p>','',1,1,0,1,'0000-00-00 00:00:00',62,'','2012-06-08 06:44:15',62,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',4,0,4,'','',0,247,'robots=\nauthor='),(4,'บริจาคของวันเด็กบ้านห้วยขนุน','๒๕๕๕-%m-๐๘-๐๖-%M-%S','','<p>{vsig}002{/vsig}</p>','',1,1,0,1,'0000-00-00 00:00:00',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',1,0,3,'','',0,186,'robots=\nauthor='),(5,'กิจกรรมไหว้ครู 2555','-m-m-s','','<p>แผนกอิเล็กทรอนิกส์ร่วมกิจกรรมไหว้ครูประจำปี 2555</p>\r\n<p><img alt=\"IMG 4879 resize\" src=\"images/stories/005/IMG_4879_resize.JPG\" height=\"210\" width=\"317\" /></p>\r\n','\r\n<p>{vsig}005{/vsig}</p>',1,1,0,4,'0000-00-00 00:00:00',62,'','2012-07-17 14:25:49',62,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',3,0,6,'','',0,353,'robots=\nauthor='),(8,'กิจกรรมปริวาสกรรม','-m---m-s','','<p>อาจารย์ นักศึกษา&nbsp; แผนกอิเล็กทรอนิกส์ ร่วมทำบุญตักบาตร ณ ธรรมสถานลานโพธิ์ เนื่อในงานปาริวาสกรรม ภายในวิทยาลัยเคโนโลยีหมู่บ้านครูภาคเหนือ</p>\r\n<p><img alt=\"IMG 1252 resize\" src=\"images/stories/006/IMG_1252_resize.JPG\" height=\"202\" width=\"303\" /></p>\r\n','\r\n<p>{vsig}006{/vsig}</p>',1,1,0,4,'0000-00-00 00:00:00',62,'','2012-07-17 14:46:28',62,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',2,0,5,'','',0,454,'robots=\nauthor='),(6,'ไหว้ครู 2554','-2554','','<p>{vsig}003{/vsig}</p>','',1,1,0,1,'0000-00-00 00:00:00',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',1,0,2,'','',0,99,'robots=\nauthor='),(7,'Congratulation','congratulation','','<p>{vsig}004{/vsig}</p>','',1,1,0,1,'0000-00-00 00:00:00',62,'','2012-06-08 07:06:01',62,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',2,0,1,'','',0,132,'robots=\nauthor='),(9,'ศึกษาดูงานวิทยุการบิน','-m---m-s','','<p>อาจารย์ นักศึกษา สาขาวิชาอิเล็กทรอนิกส์และไฟฟ้า ศึกษาดูงานที่ศูนย์ควบคุมการบิน กองบิน 41 เชียงใหม่</p>\r\n<p><img alt=\"IMG 6397 resize\" src=\"images/stories/007/IMG_6397_resize.JPG\" height=\"219\" width=\"329\" /></p>\r\n','\r\n<p>{vsig}007{/vsig}</p>',1,1,0,4,'0000-00-00 00:00:00',62,'','2012-07-18 06:17:33',62,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',2,0,4,'','',0,473,'robots=\nauthor='),(10,'โครงการ Fix it Center อ.บ้านธิ','-fix-it-center-','','<p>สาขาวิชาอิเล็กทรอนิกส์ ร่วมโครงการ Fix It Center อ.บ้านธิ จ.ลำพูน</p>\r\n<p><img alt=\"IMG 6219 resize\" src=\"images/stories/008/IMG_6219_resize.JPG\" height=\"239\" width=\"359\" /></p>\r\n','\r\n<p>{vsig}008{/vsig}</p>',1,1,0,4,'0000-00-00 00:00:00',62,'','2012-07-18 06:30:04',62,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',2,0,3,'','',0,874,'robots=\nauthor='),(11,'ร่วมโครงการ Fix It Center บ้านแม่ร้องน้อย ','-fix-it-center-','','<p>สาขาวิชาอิเล็กทรอนิกส์ ร่วมโครงการ Fix It Center บ้านแม่ร้องน้อย อ.เมือง จ.ลำพูน</p>\r\n<p><img alt=\"IMG 7895 resize\" src=\"images/stories/009/IMG_7895_resize.JPG\" height=\"200\" width=\"301\" /></p>\r\n','\r\n<p>{vsig}009{/vsig}</p>',1,1,0,4,'0000-00-00 00:00:00',62,'','2012-07-18 06:40:42',62,62,'2012-10-14 01:58:38','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',2,0,2,'','',0,1110,'robots=\nauthor='),(12,'พิธีหล่อเทียนพรรษา ประจำปี 2555','-2555','','<p>วิทยาลัยเทคโนโลยีหมู่บ้านครูจัดพิธีหล่อเทียนพรรษา เฉลิมพระเกียติ 82 พรรษา เพื่อถวายวัดต่างๆในวันเข้าพรรษา ประจำปี 2555</p>\r\n<p><img alt=\"IMG 5050 resize\" src=\"images/stories/010/IMG_5050_resize.JPG\" height=\"241\" width=\"373\" /></p>\r\n<p>{vsig}010{/vsig}</p>','',1,1,0,4,'0000-00-00 00:00:00',62,'','2012-07-30 07:27:52',62,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',2,0,1,'','',0,1143,'robots=\nauthor=');

--
-- Table structure for table `jos_content_frontpage`
--

CREATE TABLE `jos_content_frontpage` (
  `content_id` int(11) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_content_frontpage`
--


--
-- Table structure for table `jos_content_rating`
--

CREATE TABLE `jos_content_rating` (
  `content_id` int(11) NOT NULL DEFAULT '0',
  `rating_sum` int(11) unsigned NOT NULL DEFAULT '0',
  `rating_count` int(11) unsigned NOT NULL DEFAULT '0',
  `lastip` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_content_rating`
--


--
-- Table structure for table `jos_core_acl_aro`
--

CREATE TABLE `jos_core_acl_aro` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section_value` varchar(240) NOT NULL DEFAULT '0',
  `value` varchar(240) NOT NULL DEFAULT '',
  `order_value` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `hidden` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(100)),
  KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM AUTO_INCREMENT=261 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_aro`
--

INSERT INTO `jos_core_acl_aro` VALUES (10,'users','62',0,'Administrator',0),(11,'users','63',0,'นายมนัสวี ไชยคำเรือง',0),(12,'users','64',0,'อรพรรณ ศรีจันทร์',0),(14,'users','66',0,'suwat naluang',0),(15,'users','67',0,'เกียรติศักดิ์',0),(16,'users','68',0,'Thanakit',0),(17,'users','69',0,'ไพศาล ผมติด',0),(18,'users','70',0,'ชัยวัฒน์ มหิทธิ',0),(19,'users','71',0,'ธนัชภูรินทร์   หวังธารา',0),(20,'users','72',0,'Narpswada',0),(21,'users','73',0,'Merbentaite',0),(22,'users','74',0,'coxchese',0),(23,'users','75',0,'Bladoman',0),(24,'users','76',0,'Petrosyann',0),(25,'users','77',0,'Cickimice',0),(26,'users','78',0,'Fatiokepterie',0),(27,'users','79',0,'abrurpamb',0),(28,'users','80',0,'taxJettebarce',0),(29,'users','81',0,'Ketryopetly',0),(30,'users','82',0,'loyashhox',0),(31,'users','83',0,'Reggie-PGK',0),(32,'users','84',0,'Reggiena',0),(33,'users','85',0,'DoctorAmadeus',0),(34,'users','86',0,'NadiaKrol',0),(35,'users','87',0,'DoctorAybolitoff',0),(36,'users','88',0,'DoctorLowberd',0),(37,'users','89',0,'EnelpmepBes',0),(38,'users','90',0,'yuanserpf',0),(39,'users','91',0,'hongselxm',0),(40,'users','92',0,'agoxCrearse',0),(41,'users','93',0,'DctorMorguls',0),(42,'users','94',0,'stydayorano',0),(43,'users','95',0,'LordMartines',0),(44,'users','96',0,'VIELPAROLVE',0),(45,'users','97',0,'AngeminoDit',0),(46,'users','98',0,'RichardKi',0),(47,'users','99',0,'GabrielBow',0),(48,'users','100',0,'AlyssaFL',0),(49,'users','101',0,'natthapon',0),(50,'users','102',0,'AblerDhip',0),(51,'users','103',0,'Tanishaknof',0),(52,'users','104',0,'DennisKr',0),(53,'users','105',0,'Anthonytig',0),(54,'users','106',0,'Sttruster',0),(55,'users','107',0,'DustinTib',0),(56,'users','108',0,'Armenp',0),(57,'users','109',0,'alexahofman',0),(58,'users','110',0,'JoshuaVady',0),(59,'users','111',0,'Annast',0),(60,'users','112',0,'Brandonor',0),(61,'users','113',0,'elenavoenkova',0),(62,'users','114',0,'Chatwidge',0),(63,'users','115',0,'AzizoHfst',0),(64,'users','116',0,'Essaykip',0),(65,'users','117',0,'KristyKl',0),(66,'users','118',0,'katyakeupetman',0),(67,'users','119',0,'AnniePr',0),(68,'users','120',0,'Lexxypa',0),(69,'users','121',0,'OlgaLoxy',0),(70,'users','122',0,'Vincentki',0),(71,'users','123',0,'Larisaalpn',0),(72,'users','124',0,'olgaromanenko',0),(73,'users','125',0,'Apelsinobaw',0),(74,'users','126',0,'Abrekilore',0),(75,'users','127',0,'Roberter',0),(76,'users','128',0,'RTnewspa',0),(77,'users','129',0,'Antoperie',0),(78,'users','130',0,'Earlinept',0),(79,'users','131',0,'Alvarotam',0),(80,'users','132',0,'Alexschpa',0),(81,'users','133',0,'AlfyNuff',0),(82,'users','134',0,'invireehoinny',0),(83,'users','135',0,'insiguits',0),(84,'users','136',0,'OliDaryweet',0),(85,'users','137',0,'JannieSr',0),(86,'users','138',0,'AndrewtuT',0),(87,'users','139',0,'bablosNuff',0),(88,'users','140',0,'MarcosMets',0),(89,'users','141',0,'antonbychkov',0),(90,'users','142',0,'Marselqopa',0),(91,'users','143',0,'RussellSr',0),(92,'users','144',0,'Stmostere',0),(93,'users','145',0,'Haroldved',0),(94,'users','146',0,'marinazinkevich',0),(95,'users','147',0,'Cameronst',0),(96,'users','148',0,'AArorrywem',0),(97,'users','149',0,'Ktulhudoop',0),(98,'users','150',0,'pefReelty',0),(99,'users','151',0,'viktoraleksandrovich',0),(100,'users','152',0,'Woltaioma',0),(101,'users','153',0,'belinskiyboris',0),(102,'users','154',0,'mitrofanovgleb',0),(103,'users','155',0,'EdmondSor',0),(104,'users','156',0,'yackevichmihail',0),(105,'users','157',0,'SpravkiSt',0),(106,'users','158',0,'samantablaik',0),(107,'users','159',0,'Ladazoaa',0),(108,'users','160',0,'mfsn8oce',0),(109,'users','161',0,'Apokoakotek',0),(110,'users','162',0,'RonaldTep',0),(111,'users','163',0,'Veraroua',0),(112,'users','164',0,'aypy7uaw',0),(113,'users','165',0,'ipzi4gry',0),(114,'users','166',0,'DelkyBing',0),(115,'users','167',0,'vkwa7qwj',0),(116,'users','168',0,'Storezito',0),(117,'users','169',0,'wuniwloo',0),(118,'users','170',0,'VeraPop',0),(119,'users','171',0,'WheertyGroutt',0),(120,'users','172',0,'Lubamah',0),(121,'users','173',0,'AngelaZot',0),(122,'users','174',0,'Nicahep',0),(123,'users','175',0,'RadaHem',0),(124,'users','176',0,'Aneskerly',0),(125,'users','177',0,'Dannafum',0),(126,'users','178',0,'PolinaJem',0),(127,'users','179',0,'ArwilHaph',0),(128,'users','180',0,'Tanyafak',0),(129,'users','181',0,'Williamitox',0),(130,'users','182',0,'GalyaFaf',0),(131,'users','183',0,'Renata Zitzner',0),(132,'users','184',0,'wuniwloo',0),(133,'users','185',0,'getloans',0),(134,'users','186',0,'zenonandwelon',0),(135,'users','187',0,'ElenMarselOr',0),(136,'users','188',0,'Robertfex',0),(137,'users','189',0,'RobertNund',0),(138,'users','190',0,'CarolFib',0),(139,'users','191',0,'Stephencig',0),(140,'users','192',0,'RohlfMurb',0),(141,'users','193',0,'CurtisDife',0),(142,'users','194',0,'JessicaSex',0),(143,'users','195',0,'CieraSeed',0),(144,'users','196',0,'Darryljet',0),(145,'users','197',0,'Palmertaf',0),(146,'users','198',0,'Stanleyjof',0),(147,'users','199',0,'Alissacax',0),(148,'users','200',0,'WilliamRex',0),(149,'users','201',0,'Ekberglox',0),(150,'users','202',0,'Tarshavage',0),(151,'users','203',0,'AlbertHope',0),(152,'users','204',0,'Richardfem',0),(153,'users','205',0,'RobertFumb',0),(154,'users','206',0,'natthapon Chomkhanngeon',0),(155,'users','207',0,'DanielPn',0),(156,'users','208',0,'Andrzej White',0),(157,'users','209',0,'Andrzej Gonzalez',0),(158,'users','210',0,'Andrzej Slater',0),(159,'users','211',0,'ewavufoj',0),(160,'users','212',0,'Asyre',0),(161,'users','213',0,'whatheDon',0),(162,'users','214',0,'WillLAYERGY',0),(163,'users','215',0,'RodneyPof',0),(164,'users','216',0,'Geraldpi',0),(165,'users','217',0,'coarals',0),(166,'users','218',0,'Gerylpi',0),(167,'users','219',0,'pengar',0),(168,'users','220',0,'MichealLype',0),(169,'users','221',0,'King',0),(170,'users','222',0,'Shanae',0),(171,'users','223',0,'Carletta',0),(172,'users','224',0,'Georgeann',0),(173,'users','225',0,'Kristofer',0),(174,'users','226',0,'Nakesha',0),(175,'users','227',0,'Lauryn',0),(176,'users','228',0,'Walter',0),(177,'users','229',0,'Deon',0),(178,'users','230',0,'Dorthea',0),(179,'users','231',0,'Janelle',0),(180,'users','232',0,'Wallace',0),(181,'users','233',0,'Leonida',0),(182,'users','234',0,'Jewell',0),(183,'users','235',0,'Rupert',0),(184,'users','236',0,'Tashia',0),(185,'users','237',0,'Lory',0),(186,'users','238',0,'Annmarie',0),(187,'users','239',0,'Cythia',0),(188,'users','240',0,'Lakesha',0),(189,'users','241',0,'Cristopher',0),(190,'users','242',0,'Guillermo',0),(191,'users','243',0,'Tambra',0),(192,'users','244',0,'Derrick',0),(193,'users','245',0,'Larry',0),(194,'users','246',0,'Tamera',0),(195,'users','247',0,'Pamila',0),(196,'users','248',0,'Bernard',0),(197,'users','249',0,'Beulah',0),(198,'users','250',0,'Nicole',0),(199,'users','251',0,'Devon',0),(200,'users','252',0,'Cathy',0),(201,'users','253',0,'George',0),(202,'users','254',0,'Glen',0),(203,'users','255',0,'Ayako',0),(204,'users','256',0,'Carroll',0),(205,'users','257',0,'Cornell',0),(206,'users','258',0,'Nathan',0),(207,'users','259',0,'Elene',0),(208,'users','260',0,'Monnie',0),(209,'users','261',0,'Chi',0),(210,'users','262',0,'Denise',0),(211,'users','263',0,'Erick',0),(212,'users','264',0,'Efrain',0),(213,'users','265',0,'Jim',0),(214,'users','266',0,'Aubrey',0),(215,'users','267',0,'Eddie',0),(216,'users','268',0,'Syble',0),(217,'users','269',0,'Efrain',0),(218,'users','270',0,'Annamaria',0),(219,'users','271',0,'Brandee',0),(220,'users','272',0,'Muoi',0),(221,'users','273',0,'Brent',0),(222,'users','274',0,'Edwin',0),(223,'users','275',0,'Ward',0),(224,'users','276',0,'Robt',0),(225,'users','277',0,'Jody',0),(226,'users','278',0,'Lyle',0),(227,'users','279',0,'Amado',0),(228,'users','280',0,'Beverly',0),(229,'users','281',0,'Velva',0),(230,'users','282',0,'Cedrick',0),(231,'users','283',0,'Cinderella',0),(232,'users','284',0,'Johnathan',0),(233,'users','285',0,'Sherrill',0),(234,'users','286',0,'Norris',0),(235,'users','287',0,'Johnqueef',0),(236,'users','288',0,'Matthew',0),(237,'users','289',0,'Laverne',0),(238,'users','290',0,'Ashli',0),(239,'users','291',0,'Ira',0),(240,'users','292',0,'Deb',0),(241,'users','293',0,'Jose',0),(242,'users','294',0,'Elenore',0),(243,'users','295',0,'Jamika',0),(244,'users','296',0,'Sanda',0),(245,'users','297',0,'Isidra',0),(246,'users','298',0,'Takisha',0),(247,'users','299',0,'Clinton',0),(248,'users','300',0,'Clyde',0),(249,'users','301',0,'Man',0),(250,'users','302',0,'Jefferson',0),(251,'users','303',0,'Ginger',0),(252,'users','304',0,'Ramiro',0),(253,'users','305',0,'Chantal',0),(254,'users','306',0,'Roman',0),(255,'users','307',0,'Farah',0),(256,'users','308',0,'Mitchell',0),(257,'users','309',0,'Lucas',0),(258,'users','310',0,'Shon',0),(259,'users','311',0,'RichieMi',0),(260,'users','312',0,'FrancisKisy',0);

--
-- Table structure for table `jos_core_acl_aro_groups`
--

CREATE TABLE `jos_core_acl_aro_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),
  KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_aro_groups`
--

INSERT INTO `jos_core_acl_aro_groups` VALUES (17,0,'ROOT',1,22,'ROOT'),(28,17,'USERS',2,21,'USERS'),(29,28,'Public Frontend',3,12,'Public Frontend'),(18,29,'Registered',4,11,'Registered'),(19,18,'Author',5,10,'Author'),(20,19,'Editor',6,9,'Editor'),(21,20,'Publisher',7,8,'Publisher'),(30,28,'Public Backend',13,20,'Public Backend'),(23,30,'Manager',14,19,'Manager'),(24,23,'Administrator',15,18,'Administrator'),(25,24,'Super Administrator',16,17,'Super Administrator');

--
-- Table structure for table `jos_core_acl_aro_map`
--

CREATE TABLE `jos_core_acl_aro_map` (
  `acl_id` int(11) NOT NULL DEFAULT '0',
  `section_value` varchar(230) NOT NULL DEFAULT '0',
  `value` varchar(100) NOT NULL,
  PRIMARY KEY (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_aro_map`
--


--
-- Table structure for table `jos_core_acl_aro_sections`
--

CREATE TABLE `jos_core_acl_aro_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(230) NOT NULL DEFAULT '',
  `order_value` int(11) NOT NULL DEFAULT '0',
  `name` varchar(230) NOT NULL DEFAULT '',
  `hidden` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jos_gacl_value_aro_sections` (`value`),
  KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_aro_sections`
--

INSERT INTO `jos_core_acl_aro_sections` VALUES (10,'users',1,'Users',0);

--
-- Table structure for table `jos_core_acl_groups_aro_map`
--

CREATE TABLE `jos_core_acl_groups_aro_map` (
  `group_id` int(11) NOT NULL DEFAULT '0',
  `section_value` varchar(240) NOT NULL DEFAULT '',
  `aro_id` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_groups_aro_map`
--

INSERT INTO `jos_core_acl_groups_aro_map` VALUES (18,'',14),(18,'',15),(18,'',16),(18,'',17),(18,'',18),(18,'',19),(18,'',20),(18,'',21),(18,'',22),(18,'',23),(18,'',24),(18,'',25),(18,'',26),(18,'',27),(18,'',28),(18,'',29),(18,'',30),(18,'',31),(18,'',32),(18,'',33),(18,'',34),(18,'',35),(18,'',36),(18,'',37),(18,'',38),(18,'',39),(18,'',40),(18,'',41),(18,'',42),(18,'',43),(18,'',44),(18,'',45),(18,'',46),(18,'',47),(18,'',48),(18,'',49),(18,'',50),(18,'',51),(18,'',52),(18,'',53),(18,'',54),(18,'',55),(18,'',56),(18,'',57),(18,'',58),(18,'',59),(18,'',60),(18,'',61),(18,'',62),(18,'',63),(18,'',64),(18,'',65),(18,'',66),(18,'',67),(18,'',68),(18,'',69),(18,'',70),(18,'',71),(18,'',72),(18,'',73),(18,'',74),(18,'',75),(18,'',76),(18,'',77),(18,'',78),(18,'',79),(18,'',80),(18,'',81),(18,'',82),(18,'',83),(18,'',84),(18,'',85),(18,'',86),(18,'',87),(18,'',88),(18,'',89),(18,'',90),(18,'',91),(18,'',92),(18,'',93),(18,'',94),(18,'',95),(18,'',96),(18,'',97),(18,'',98),(18,'',99),(18,'',100),(18,'',101),(18,'',102),(18,'',103),(18,'',104),(18,'',105),(18,'',106),(18,'',107),(18,'',108),(18,'',109),(18,'',110),(18,'',111),(18,'',112),(18,'',113),(18,'',114),(18,'',115),(18,'',116),(18,'',117),(18,'',118),(18,'',119),(18,'',120),(18,'',121),(18,'',122),(18,'',123),(18,'',124),(18,'',125),(18,'',126),(18,'',127),(18,'',128),(18,'',129),(18,'',130),(18,'',131),(18,'',132),(18,'',133),(18,'',134),(18,'',135),(18,'',136),(18,'',137),(18,'',138),(18,'',139),(18,'',140),(18,'',141),(18,'',142),(18,'',143),(18,'',144),(18,'',145),(18,'',146),(18,'',147),(18,'',148),(18,'',149),(18,'',150),(18,'',151),(18,'',152),(18,'',153),(18,'',154),(18,'',155),(18,'',156),(18,'',157),(18,'',158),(18,'',159),(18,'',160),(18,'',161),(18,'',162),(18,'',163),(18,'',164),(18,'',165),(18,'',166),(18,'',167),(18,'',168),(18,'',169),(18,'',170),(18,'',171),(18,'',172),(18,'',173),(18,'',174),(18,'',175),(18,'',176),(18,'',177),(18,'',178),(18,'',179),(18,'',180),(18,'',181),(18,'',182),(18,'',183),(18,'',184),(18,'',185),(18,'',186),(18,'',187),(18,'',188),(18,'',189),(18,'',190),(18,'',191),(18,'',192),(18,'',193),(18,'',194),(18,'',195),(18,'',196),(18,'',197),(18,'',198),(18,'',199),(18,'',200),(18,'',201),(18,'',202),(18,'',203),(18,'',204),(18,'',205),(18,'',206),(18,'',207),(18,'',208),(18,'',209),(18,'',210),(18,'',211),(18,'',212),(18,'',213),(18,'',214),(18,'',215),(18,'',216),(18,'',217),(18,'',218),(18,'',219),(18,'',220),(18,'',221),(18,'',222),(18,'',223),(18,'',224),(18,'',225),(18,'',226),(18,'',227),(18,'',228),(18,'',229),(18,'',230),(18,'',231),(18,'',232),(18,'',233),(18,'',234),(18,'',235),(18,'',236),(18,'',237),(18,'',238),(18,'',239),(18,'',240),(18,'',241),(18,'',242),(18,'',243),(18,'',244),(18,'',245),(18,'',246),(18,'',247),(18,'',248),(18,'',249),(18,'',250),(18,'',251),(18,'',252),(18,'',253),(18,'',254),(18,'',255),(18,'',256),(18,'',257),(18,'',258),(18,'',259),(18,'',260),(25,'',10),(25,'',11),(25,'',12);

--
-- Table structure for table `jos_core_log_items`
--

CREATE TABLE `jos_core_log_items` (
  `time_stamp` date NOT NULL DEFAULT '0000-00-00',
  `item_table` varchar(50) NOT NULL DEFAULT '',
  `item_id` int(11) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_log_items`
--


--
-- Table structure for table `jos_core_log_searches`
--

CREATE TABLE `jos_core_log_searches` (
  `search_term` varchar(128) NOT NULL DEFAULT '',
  `hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_log_searches`
--


--
-- Table structure for table `jos_groups`
--

CREATE TABLE `jos_groups` (
  `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_groups`
--

INSERT INTO `jos_groups` VALUES (0,'Public'),(1,'Registered'),(2,'Special');

--
-- Table structure for table `jos_jev_users`
--

CREATE TABLE `jos_jev_users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(2) NOT NULL DEFAULT '0',
  `canuploadimages` tinyint(2) NOT NULL DEFAULT '0',
  `canuploadmovies` tinyint(2) NOT NULL DEFAULT '0',
  `cancreate` tinyint(2) NOT NULL DEFAULT '0',
  `canedit` tinyint(2) NOT NULL DEFAULT '0',
  `canpublishown` tinyint(2) NOT NULL DEFAULT '0',
  `candeleteown` tinyint(2) NOT NULL DEFAULT '0',
  `canpublishall` tinyint(2) NOT NULL DEFAULT '0',
  `candeleteall` tinyint(2) NOT NULL DEFAULT '0',
  `cancreateown` tinyint(2) NOT NULL DEFAULT '0',
  `cancreateglobal` tinyint(2) NOT NULL DEFAULT '0',
  `eventslimit` int(11) NOT NULL DEFAULT '0',
  `extraslimit` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `user` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_jev_users`
--


--
-- Table structure for table `jos_jevents_categories`
--

CREATE TABLE `jos_jevents_categories` (
  `id` int(12) NOT NULL DEFAULT '0',
  `color` varchar(8) NOT NULL DEFAULT '',
  `admin` int(12) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_jevents_categories`
--

INSERT INTO `jos_jevents_categories` VALUES (5,'#CCCCFF',0);

--
-- Table structure for table `jos_jevents_exception`
--

CREATE TABLE `jos_jevents_exception` (
  `ex_id` int(12) NOT NULL AUTO_INCREMENT,
  `rp_id` int(12) NOT NULL DEFAULT '0',
  `eventid` int(12) NOT NULL DEFAULT '1',
  `eventdetail_id` int(12) NOT NULL DEFAULT '0',
  `exception_type` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ex_id`),
  KEY `eventid` (`eventid`),
  KEY `rp_id` (`rp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_jevents_exception`
--


--
-- Table structure for table `jos_jevents_icsfile`
--

CREATE TABLE `jos_jevents_icsfile` (
  `ics_id` int(12) NOT NULL AUTO_INCREMENT,
  `srcURL` varchar(255) NOT NULL DEFAULT '',
  `label` varchar(30) NOT NULL DEFAULT '',
  `filename` varchar(120) NOT NULL DEFAULT '',
  `icaltype` tinyint(3) NOT NULL DEFAULT '0',
  `isdefault` tinyint(3) NOT NULL DEFAULT '0',
  `state` tinyint(3) NOT NULL DEFAULT '1',
  `access` int(11) unsigned NOT NULL DEFAULT '0',
  `catid` int(11) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(11) unsigned NOT NULL DEFAULT '0',
  `created_by_alias` varchar(100) NOT NULL DEFAULT '',
  `modified_by` int(11) unsigned NOT NULL DEFAULT '0',
  `refreshed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `autorefresh` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ics_id`),
  UNIQUE KEY `label` (`label`),
  KEY `stateidx` (`state`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_jevents_icsfile`
--

INSERT INTO `jos_jevents_icsfile` VALUES (1,'','Default','Initial ICS File',2,1,1,0,5,'0000-00-00 00:00:00',0,'',0,'0000-00-00 00:00:00',0);

--
-- Table structure for table `jos_jevents_repbyday`
--

CREATE TABLE `jos_jevents_repbyday` (
  `rptday` date NOT NULL DEFAULT '0000-00-00',
  `rp_id` int(12) NOT NULL DEFAULT '0',
  `catid` int(11) NOT NULL DEFAULT '1',
  KEY `rptday` (`rptday`),
  KEY `daycat` (`rptday`,`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_jevents_repbyday`
--


--
-- Table structure for table `jos_jevents_repetition`
--

CREATE TABLE `jos_jevents_repetition` (
  `rp_id` int(12) NOT NULL AUTO_INCREMENT,
  `eventid` int(12) NOT NULL DEFAULT '1',
  `eventdetail_id` int(12) NOT NULL DEFAULT '0',
  `duplicatecheck` varchar(32) NOT NULL DEFAULT '',
  `startrepeat` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `endrepeat` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`rp_id`),
  UNIQUE KEY `duplicatecheck` (`duplicatecheck`),
  KEY `eventid` (`eventid`),
  KEY `eventstart` (`eventid`,`startrepeat`),
  KEY `eventend` (`eventid`,`endrepeat`),
  KEY `eventdetail` (`eventdetail_id`),
  KEY `startrepeat` (`startrepeat`),
  KEY `endrepeat` (`endrepeat`),
  KEY `startend` (`startrepeat`,`endrepeat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_jevents_repetition`
--


--
-- Table structure for table `jos_jevents_rrule`
--

CREATE TABLE `jos_jevents_rrule` (
  `rr_id` int(12) NOT NULL AUTO_INCREMENT,
  `eventid` int(12) NOT NULL DEFAULT '1',
  `freq` varchar(30) NOT NULL DEFAULT '',
  `until` int(12) NOT NULL DEFAULT '1',
  `untilraw` varchar(30) NOT NULL DEFAULT '',
  `count` int(6) NOT NULL DEFAULT '1',
  `rinterval` int(6) NOT NULL DEFAULT '1',
  `bysecond` varchar(50) NOT NULL DEFAULT '',
  `byminute` varchar(50) NOT NULL DEFAULT '',
  `byhour` varchar(50) NOT NULL DEFAULT '',
  `byday` varchar(50) NOT NULL DEFAULT '',
  `bymonthday` varchar(50) NOT NULL DEFAULT '',
  `byyearday` varchar(50) NOT NULL DEFAULT '',
  `byweekno` varchar(50) NOT NULL DEFAULT '',
  `bymonth` varchar(50) NOT NULL DEFAULT '',
  `bysetpos` varchar(50) NOT NULL DEFAULT '',
  `wkst` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`rr_id`),
  KEY `eventid` (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_jevents_rrule`
--


--
-- Table structure for table `jos_jevents_vevdetail`
--

CREATE TABLE `jos_jevents_vevdetail` (
  `evdet_id` int(12) NOT NULL AUTO_INCREMENT,
  `rawdata` longtext NOT NULL,
  `dtstart` int(11) NOT NULL DEFAULT '0',
  `dtstartraw` varchar(30) NOT NULL DEFAULT '',
  `duration` int(11) NOT NULL DEFAULT '0',
  `durationraw` varchar(30) NOT NULL DEFAULT '',
  `dtend` int(11) NOT NULL DEFAULT '0',
  `dtendraw` varchar(30) NOT NULL DEFAULT '',
  `dtstamp` varchar(30) NOT NULL DEFAULT '',
  `class` varchar(10) NOT NULL DEFAULT '',
  `categories` varchar(120) NOT NULL DEFAULT '',
  `color` varchar(20) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `geolon` float NOT NULL DEFAULT '0',
  `geolat` float NOT NULL DEFAULT '0',
  `location` varchar(120) NOT NULL DEFAULT '',
  `priority` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` varchar(20) NOT NULL DEFAULT '',
  `summary` longtext NOT NULL,
  `contact` varchar(120) NOT NULL DEFAULT '',
  `organizer` varchar(120) NOT NULL DEFAULT '',
  `url` varchar(120) NOT NULL DEFAULT '',
  `extra_info` varchar(240) NOT NULL DEFAULT '',
  `created` varchar(30) NOT NULL DEFAULT '',
  `sequence` int(11) NOT NULL DEFAULT '1',
  `state` tinyint(3) NOT NULL DEFAULT '1',
  `multiday` tinyint(3) NOT NULL DEFAULT '1',
  `hits` int(11) NOT NULL DEFAULT '0',
  `noendtime` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`evdet_id`),
  FULLTEXT KEY `searchIdx` (`summary`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_jevents_vevdetail`
--


--
-- Table structure for table `jos_jevents_vevent`
--

CREATE TABLE `jos_jevents_vevent` (
  `ev_id` int(12) NOT NULL AUTO_INCREMENT,
  `icsid` int(12) NOT NULL DEFAULT '0',
  `catid` int(11) NOT NULL DEFAULT '1',
  `uid` varchar(255) NOT NULL DEFAULT '',
  `refreshed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(11) unsigned NOT NULL DEFAULT '0',
  `created_by_alias` varchar(100) NOT NULL DEFAULT '',
  `modified_by` int(11) unsigned NOT NULL DEFAULT '0',
  `rawdata` longtext NOT NULL,
  `recurrence_id` varchar(30) NOT NULL DEFAULT '',
  `detail_id` int(12) NOT NULL DEFAULT '0',
  `state` tinyint(3) NOT NULL DEFAULT '1',
  `access` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ev_id`),
  UNIQUE KEY `uid` (`uid`),
  KEY `icsid` (`icsid`),
  KEY `stateidx` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_jevents_vevent`
--


--
-- Table structure for table `jos_kunena_announcement`
--

CREATE TABLE `jos_kunena_announcement` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `title` tinytext NOT NULL,
  `sdescription` text NOT NULL,
  `description` text NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `ordering` tinyint(4) NOT NULL DEFAULT '0',
  `showdate` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_announcement`
--


--
-- Table structure for table `jos_kunena_categories`
--

CREATE TABLE `jos_kunena_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) DEFAULT '0',
  `name` tinytext,
  `cat_emoticon` tinyint(4) NOT NULL DEFAULT '0',
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  `alert_admin` tinyint(4) NOT NULL DEFAULT '0',
  `moderated` tinyint(4) NOT NULL DEFAULT '1',
  `moderators` varchar(15) DEFAULT NULL,
  `accesstype` varchar(20) NOT NULL DEFAULT 'none',
  `access` int(11) NOT NULL DEFAULT '0',
  `pub_access` tinyint(4) DEFAULT '1',
  `pub_recurse` tinyint(4) DEFAULT '1',
  `admin_access` tinyint(4) DEFAULT '0',
  `admin_recurse` tinyint(4) DEFAULT '1',
  `ordering` smallint(6) NOT NULL DEFAULT '0',
  `future2` int(11) DEFAULT '0',
  `published` tinyint(4) NOT NULL DEFAULT '0',
  `checked_out` tinyint(4) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `review` tinyint(4) NOT NULL DEFAULT '0',
  `allow_anonymous` tinyint(4) NOT NULL DEFAULT '0',
  `post_anonymous` tinyint(4) NOT NULL DEFAULT '0',
  `hits` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `headerdesc` text NOT NULL,
  `class_sfx` varchar(20) NOT NULL,
  `allow_polls` tinyint(4) NOT NULL DEFAULT '0',
  `id_last_msg` int(10) NOT NULL DEFAULT '0',
  `numTopics` mediumint(8) NOT NULL DEFAULT '0',
  `numPosts` mediumint(8) NOT NULL DEFAULT '0',
  `time_last_msg` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`),
  KEY `published_pubaccess_id` (`published`,`pub_access`,`id`),
  KEY `msg_id` (`id_last_msg`),
  KEY `category_access` (`accesstype`,`access`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_categories`
--

INSERT INTO `jos_kunena_categories` VALUES (1,0,'ข่าวประชาสัมพันธ์',0,0,0,1,NULL,'none',0,0,1,0,1,1,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'ข่าวประชาสัมพันธ์ต่างๆ ของแผนกอิเล็กทรอนิกส์','ข่าวประชาสัมพันธ์ต่างๆ ของแผนกอิเล็กทรอนิกส์','',0,1,1,0,1351641145),(2,1,'ข่าวกิจกรรม',0,0,0,1,NULL,'none',0,0,1,0,1,4,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'สำหรับกิจกรรมในแผนกของเรานะครับ','','',0,1,1,0,1351641145),(4,0,'E-learning',0,0,0,1,NULL,'none',0,0,1,0,1,5,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'เอกสารประกอบการสอบต่างๆ ของอาจารย์ในแผนก','','',0,2,1,0,1362260282),(5,4,'Webboard อ.ผ่องอำไพ เสนแสง',0,0,0,1,NULL,'none',0,0,1,0,1,2,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'','','',0,0,0,0,NULL),(6,4,'Webboard อ.ปรีดา รัตนพรม',0,0,0,1,NULL,'none',0,0,1,0,1,3,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'','','',0,2,1,0,1362260282);

--
-- Table structure for table `jos_kunena_config`
--

CREATE TABLE `jos_kunena_config` (
  `id` int(11) NOT NULL DEFAULT '0',
  `board_title` text,
  `email` text,
  `board_offline` int(11) DEFAULT NULL,
  `board_ofset` text,
  `offline_message` text,
  `enablerss` int(11) DEFAULT NULL,
  `enablepdf` int(11) DEFAULT NULL,
  `threads_per_page` int(11) DEFAULT NULL,
  `messages_per_page` int(11) DEFAULT NULL,
  `messages_per_page_search` int(11) DEFAULT NULL,
  `showhistory` int(11) DEFAULT NULL,
  `historylimit` int(11) DEFAULT NULL,
  `shownew` int(11) DEFAULT NULL,
  `jmambot` int(11) DEFAULT NULL,
  `disemoticons` int(11) DEFAULT NULL,
  `template` text,
  `showannouncement` int(11) DEFAULT NULL,
  `avataroncat` int(11) DEFAULT NULL,
  `catimagepath` text,
  `showchildcaticon` int(11) DEFAULT NULL,
  `annmodid` text,
  `rtewidth` int(11) DEFAULT NULL,
  `rteheight` int(11) DEFAULT NULL,
  `enableforumjump` int(11) DEFAULT NULL,
  `reportmsg` int(11) DEFAULT NULL,
  `username` int(11) DEFAULT NULL,
  `askemail` int(11) DEFAULT NULL,
  `showemail` int(11) DEFAULT NULL,
  `showuserstats` int(11) DEFAULT NULL,
  `showkarma` int(11) DEFAULT NULL,
  `useredit` int(11) DEFAULT NULL,
  `useredittime` int(11) DEFAULT NULL,
  `useredittimegrace` int(11) DEFAULT NULL,
  `editmarkup` int(11) DEFAULT NULL,
  `allowsubscriptions` int(11) DEFAULT NULL,
  `subscriptionschecked` int(11) DEFAULT NULL,
  `allowfavorites` int(11) DEFAULT NULL,
  `maxsubject` int(11) DEFAULT NULL,
  `maxsig` int(11) DEFAULT NULL,
  `regonly` int(11) DEFAULT NULL,
  `changename` int(11) DEFAULT NULL,
  `pubwrite` int(11) DEFAULT NULL,
  `floodprotection` int(11) DEFAULT NULL,
  `mailmod` int(11) DEFAULT NULL,
  `mailadmin` int(11) DEFAULT NULL,
  `captcha` int(11) DEFAULT NULL,
  `mailfull` int(11) DEFAULT NULL,
  `allowavatar` int(11) DEFAULT NULL,
  `allowavatarupload` int(11) DEFAULT NULL,
  `allowavatargallery` int(11) DEFAULT NULL,
  `avatarquality` int(11) DEFAULT NULL,
  `avatarsize` int(11) DEFAULT NULL,
  `allowimageupload` int(11) DEFAULT NULL,
  `allowimageregupload` int(11) DEFAULT NULL,
  `imageheight` int(11) DEFAULT NULL,
  `imagewidth` int(11) DEFAULT NULL,
  `imagesize` int(11) DEFAULT NULL,
  `allowfileupload` int(11) DEFAULT NULL,
  `allowfileregupload` int(11) DEFAULT NULL,
  `filetypes` text,
  `filesize` int(11) DEFAULT NULL,
  `showranking` int(11) DEFAULT NULL,
  `rankimages` int(11) DEFAULT NULL,
  `avatar_src` text,
  `fb_profile` text,
  `pm_component` text,
  `userlist_rows` int(11) DEFAULT NULL,
  `userlist_online` int(11) DEFAULT NULL,
  `userlist_avatar` int(11) DEFAULT NULL,
  `userlist_name` int(11) DEFAULT NULL,
  `userlist_username` int(11) DEFAULT NULL,
  `userlist_posts` int(11) DEFAULT NULL,
  `userlist_karma` int(11) DEFAULT NULL,
  `userlist_email` int(11) DEFAULT NULL,
  `userlist_usertype` int(11) DEFAULT NULL,
  `userlist_joindate` int(11) DEFAULT NULL,
  `userlist_lastvisitdate` int(11) DEFAULT NULL,
  `userlist_userhits` int(11) DEFAULT NULL,
  `latestcategory` text,
  `showstats` int(11) DEFAULT NULL,
  `showwhoisonline` int(11) DEFAULT NULL,
  `showgenstats` int(11) DEFAULT NULL,
  `showpopuserstats` int(11) DEFAULT NULL,
  `popusercount` int(11) DEFAULT NULL,
  `showpopsubjectstats` int(11) DEFAULT NULL,
  `popsubjectcount` int(11) DEFAULT NULL,
  `usernamechange` int(11) DEFAULT NULL,
  `rules_infb` int(11) DEFAULT NULL,
  `rules_cid` int(11) DEFAULT NULL,
  `help_infb` int(11) DEFAULT NULL,
  `help_cid` int(11) DEFAULT NULL,
  `showspoilertag` int(11) DEFAULT NULL,
  `showvideotag` int(11) DEFAULT NULL,
  `showebaytag` int(11) DEFAULT NULL,
  `trimlongurls` int(11) DEFAULT NULL,
  `trimlongurlsfront` int(11) DEFAULT NULL,
  `trimlongurlsback` int(11) DEFAULT NULL,
  `autoembedyoutube` int(11) DEFAULT NULL,
  `autoembedebay` int(11) DEFAULT NULL,
  `ebaylanguagecode` text,
  `fbsessiontimeout` int(11) DEFAULT NULL,
  `highlightcode` int(11) DEFAULT NULL,
  `rss_type` text,
  `rss_timelimit` text,
  `rss_limit` int(11) DEFAULT NULL,
  `rss_included_categories` text,
  `rss_excluded_categories` text,
  `rss_specification` text,
  `rss_allow_html` int(11) DEFAULT NULL,
  `rss_author_format` text,
  `rss_author_in_title` int(11) DEFAULT NULL,
  `rss_word_count` text,
  `rss_old_titles` int(11) DEFAULT NULL,
  `rss_cache` int(11) DEFAULT NULL,
  `fbdefaultpage` text,
  `default_sort` text,
  `alphauserpointsnumchars` int(11) DEFAULT NULL,
  `sef` int(11) DEFAULT NULL,
  `sefcats` int(11) DEFAULT NULL,
  `sefutf8` int(11) DEFAULT NULL,
  `showimgforguest` int(11) DEFAULT NULL,
  `showfileforguest` int(11) DEFAULT NULL,
  `pollnboptions` int(11) DEFAULT NULL,
  `pollallowvoteone` int(11) DEFAULT NULL,
  `pollenabled` int(11) DEFAULT NULL,
  `poppollscount` int(11) DEFAULT NULL,
  `showpoppollstats` int(11) DEFAULT NULL,
  `polltimebtvotes` text,
  `pollnbvotesbyuser` int(11) DEFAULT NULL,
  `pollresultsuserslist` int(11) DEFAULT NULL,
  `maxpersotext` int(11) DEFAULT NULL,
  `ordering_system` text,
  `post_dateformat` text,
  `post_dateformat_hover` text,
  `hide_ip` int(11) DEFAULT NULL,
  `js_actstr_integration` int(11) DEFAULT NULL,
  `imagetypes` text,
  `checkmimetypes` int(11) DEFAULT NULL,
  `imagemimetypes` text,
  `imagequality` int(11) DEFAULT NULL,
  `thumbheight` int(11) DEFAULT NULL,
  `thumbwidth` int(11) DEFAULT NULL,
  `hideuserprofileinfo` text,
  `integration_access` text,
  `integration_login` text,
  `integration_avatar` text,
  `integration_profile` text,
  `integration_private` text,
  `integration_activity` text,
  `boxghostmessage` int(11) DEFAULT NULL,
  `userdeletetmessage` int(11) DEFAULT NULL,
  `latestcategory_in` int(11) DEFAULT NULL,
  `topicicons` int(11) DEFAULT NULL,
  `onlineusers` int(11) DEFAULT NULL,
  `debug` int(11) DEFAULT NULL,
  `catsautosubscribed` int(11) DEFAULT NULL,
  `showbannedreason` int(11) DEFAULT NULL,
  `version_check` int(11) DEFAULT NULL,
  `showthankyou` int(11) DEFAULT NULL,
  `showpopthankyoustats` int(11) DEFAULT NULL,
  `popthankscount` int(11) DEFAULT NULL,
  `mod_see_deleted` int(11) DEFAULT NULL,
  `bbcode_img_secure` text,
  `listcat_show_moderators` int(11) DEFAULT NULL,
  `lightbox` int(11) DEFAULT NULL,
  `activity_limit` int(11) DEFAULT NULL,
  `show_list_time` int(11) DEFAULT NULL,
  `show_session_type` int(11) DEFAULT NULL,
  `show_session_starttime` int(11) DEFAULT NULL,
  `userlist_allowed` int(11) DEFAULT NULL,
  `userlist_count_users` int(11) DEFAULT NULL,
  `enable_threaded_layouts` int(11) DEFAULT NULL,
  `category_subscriptions` text,
  `topic_subscriptions` text,
  `pubprofile` int(11) DEFAULT NULL,
  `thankyou_max` int(11) DEFAULT NULL,
  `email_recipient_count` int(11) DEFAULT NULL,
  `email_recipient_privacy` text,
  `email_visible_address` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_config`
--


--
-- Table structure for table `jos_kunena_favorites`
--

CREATE TABLE `jos_kunena_favorites` (
  `thread` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `thread` (`thread`,`userid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_favorites`
--


--
-- Table structure for table `jos_kunena_groups`
--

CREATE TABLE `jos_kunena_groups` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_groups`
--


--
-- Table structure for table `jos_kunena_messages`
--

CREATE TABLE `jos_kunena_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) DEFAULT '0',
  `thread` int(11) DEFAULT '0',
  `catid` int(11) NOT NULL DEFAULT '0',
  `name` tinytext,
  `userid` int(11) NOT NULL DEFAULT '0',
  `email` tinytext,
  `subject` tinytext,
  `time` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(15) DEFAULT NULL,
  `topic_emoticon` int(11) NOT NULL DEFAULT '0',
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  `hold` tinyint(4) NOT NULL DEFAULT '0',
  `ordering` int(11) DEFAULT '0',
  `hits` int(11) DEFAULT '0',
  `moved` tinyint(4) DEFAULT '0',
  `modified_by` int(7) DEFAULT NULL,
  `modified_time` int(11) DEFAULT NULL,
  `modified_reason` tinytext,
  PRIMARY KEY (`id`),
  KEY `thread` (`thread`),
  KEY `ip` (`ip`),
  KEY `userid` (`userid`),
  KEY `time` (`time`),
  KEY `locked` (`locked`),
  KEY `hold_time` (`hold`,`time`),
  KEY `parent_hits` (`parent`,`hits`),
  KEY `catid_parent` (`catid`,`parent`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_messages`
--

INSERT INTO `jos_kunena_messages` VALUES (1,0,1,2,'Kunena',62,NULL,'ยินดีต้อนรับ!',1351641145,'127.0.0.1',0,0,0,0,134,0,NULL,NULL,NULL),(2,0,2,6,'admin',62,'','งานวิชาดิจิตอล',1362260282,'10.0.98.2',0,0,0,0,178,0,62,1362260370,'');

--
-- Table structure for table `jos_kunena_messages_text`
--

CREATE TABLE `jos_kunena_messages_text` (
  `mesid` int(11) NOT NULL DEFAULT '0',
  `message` text NOT NULL,
  PRIMARY KEY (`mesid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_messages_text`
--

INSERT INTO `jos_kunena_messages_text` VALUES (1,'[size=4][b]ยินดีต้อนรับสู่ Kunena![/b][/size] \n\n ขอขอบคุณที่คุณได้เลือก Kunena สำหรับใช้งานเป็นระบบกระดานสนทนาของเว็บที่สร้างบนจูมล่าของคุณ \n\n คำว่า Kunena เป็นภาษา  Swahili ซึ่งมีความหมายว่า  &quot;to speak&quot; หรือ &quot;พูดคุย&quot; พัฒนาเป็นซอฟต์แวร์เปิดโดยทีมงานมืออาชีพ โดยมีเป้าหมายคือ ตั้งใจพัฒนาให้เป็นระบบฟอรัมคุณภาพ  โดยคุณสามารถเชื่อมโยงกับระบบ Joomla ได้เป็นอย่างดี  และนอกจากนั้น Kunena ยังมีความสามารถที่จะเชื่อมโยงเข้ากับคอมโพเนนท์เครือข่ายสังคมเช่น Community Builder และ JomSocial. \n\n\n [size=4][b]รายละเอียด ข้อมูลเพิ่มเติมเกี่ยวกับ Kunena[/b][/size] \n\n [b]คู่มือการใช้งาน Kunena:[/b] [url]http://www.kunena.com/docs[/url] \n\n [b]ฟอรัมสอบถามการใช้งาน Kunena[/b]: [url]http://www.kunena.com/forum[/url] \n\n [b]ดาวน์โหลด Kunena:[/b] [url]http://www.kunena.com/downloads[/url] \n\n [b]Kunena Blog:[/b] [url]http://www.kunena.com/blog[/url] \n\n [b]นำเสนอแนวคิดใหม่ๆ:[/b] [url]http://www.kunena.com/uservoice[/url] \n\n [b]ติดตาม Kunena บน Twitter:[/b] [url]http://www.kunena.com/twitter[/url]'),(2,'ส่งอาทิตย์ที่ 10 มีนาคม');

--
-- Table structure for table `jos_kunena_moderation`
--

CREATE TABLE `jos_kunena_moderation` (
  `catid` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `future1` tinyint(4) DEFAULT '0',
  `future2` int(11) DEFAULT '0',
  PRIMARY KEY (`catid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_moderation`
--


--
-- Table structure for table `jos_kunena_polls`
--

CREATE TABLE `jos_kunena_polls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `threadid` int(11) NOT NULL,
  `polltimetolive` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_polls`
--


--
-- Table structure for table `jos_kunena_polls_options`
--

CREATE TABLE `jos_kunena_polls_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pollid` int(11) DEFAULT NULL,
  `text` varchar(100) DEFAULT NULL,
  `votes` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pollid` (`pollid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_polls_options`
--


--
-- Table structure for table `jos_kunena_polls_users`
--

CREATE TABLE `jos_kunena_polls_users` (
  `pollid` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `votes` int(11) DEFAULT NULL,
  `lasttime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `lastvote` int(11) DEFAULT NULL,
  UNIQUE KEY `pollid` (`pollid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_polls_users`
--


--
-- Table structure for table `jos_kunena_ranks`
--

CREATE TABLE `jos_kunena_ranks` (
  `rank_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `rank_title` varchar(255) NOT NULL DEFAULT '',
  `rank_min` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rank_special` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `rank_image` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`rank_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_ranks`
--

INSERT INTO `jos_kunena_ranks` VALUES (1,'Fresh Boarder',0,0,'rank1.gif'),(2,'Junior Boarder',20,0,'rank2.gif'),(3,'Senior Boarder',40,0,'rank3.gif'),(4,'Expert Boarder',80,0,'rank4.gif'),(5,'Gold Boarder',160,0,'rank5.gif'),(6,'Platinum Boarder',320,0,'rank6.gif'),(7,'Administrator',0,1,'rankadmin.gif'),(8,'Moderator',0,1,'rankmod.gif'),(9,'Spammer',0,1,'rankspammer.gif'),(10,'แบน',0,1,'rankbanned.gif');

--
-- Table structure for table `jos_kunena_sessions`
--

CREATE TABLE `jos_kunena_sessions` (
  `userid` int(11) NOT NULL DEFAULT '0',
  `allowed` text,
  `lasttime` int(11) NOT NULL DEFAULT '0',
  `readtopics` text,
  `currvisit` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`),
  KEY `currvisit` (`currvisit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_sessions`
--

INSERT INTO `jos_kunena_sessions` VALUES (62,'1,2,4,5,6',1370804369,'0,2',1377979633),(144,'1,2,4,5,6',1400587213,'0',1401796831),(161,'1,2,4,5,6',1407136610,'0',1407187118),(176,'1,2,4,5,6',1411035277,'0',1412570102),(189,'1,2,4,5,6',1422995808,'0',1424205408);

--
-- Table structure for table `jos_kunena_smileys`
--

CREATE TABLE `jos_kunena_smileys` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `code` varchar(12) NOT NULL DEFAULT '',
  `location` varchar(50) NOT NULL DEFAULT '',
  `greylocation` varchar(60) NOT NULL DEFAULT '',
  `emoticonbar` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_smileys`
--

INSERT INTO `jos_kunena_smileys` VALUES (1,'B)','cool.png','cool-grey.png',1),(2,'8)','cool.png','cool-grey.png',0),(3,'8-)','cool.png','cool-grey.png',0),(4,':-(','sad.png','sad-grey.png',0),(5,':(','sad.png','sad-grey.png',1),(6,':sad:','sad.png','sad-grey.png',0),(7,':cry:','sad.png','sad-grey.png',0),(8,':)','smile.png','smile-grey.png',1),(9,':-)','smile.png','smile-grey.png',0),(10,':cheer:','cheerful.png','cheerful-grey.png',1),(11,';)','wink.png','wink-grey.png',1),(12,';-)','wink.png','wink-grey.png',0),(13,':wink:','wink.png','wink-grey.png',0),(14,';-)','wink.png','wink-grey.png',0),(15,':P','tongue.png','tongue-grey.png',1),(16,':p','tongue.png','tongue-grey.png',0),(17,':-p','tongue.png','tongue-grey.png',0),(18,':-P','tongue.png','tongue-grey.png',0),(19,':razz:','tongue.png','tongue-grey.png',0),(20,':angry:','angry.png','angry-grey.png',1),(21,':mad:','angry.png','angry-grey.png',0),(22,':unsure:','unsure.png','unsure-grey.png',1),(23,':o','shocked.png','shocked-grey.png',0),(24,':-o','shocked.png','shocked-grey.png',0),(25,':O','shocked.png','shocked-grey.png',0),(26,':-O','shocked.png','shocked-grey.png',0),(27,':eek:','shocked.png','shocked-grey.png',0),(28,':ohmy:','shocked.png','shocked-grey.png',1),(29,':huh:','wassat.png','wassat-grey.png',1),(30,':?','confused.png','confused-grey.png',0),(31,':-?','confused.png','confused-grey.png',0),(32,':???','confused.png','confused-grey.png',0),(33,':dry:','ermm.png','ermm-grey.png',1),(34,':ermm:','ermm.png','ermm-grey.png',0),(35,':lol:','grin.png','grin-grey.png',1),(36,':X','sick.png','sick-grey.png',0),(37,':x','sick.png','sick-grey.png',0),(38,':sick:','sick.png','sick-grey.png',1),(39,':silly:','silly.png','silly-grey.png',1),(40,':y32b4:','silly.png','silly-grey.png',0),(41,':blink:','blink.png','blink-grey.png',1),(42,':blush:','blush.png','blush-grey.png',1),(43,':oops:','blush.png','blush-grey.png',1),(44,':kiss:','kissing.png','kissing-grey.png',1),(45,':rolleyes:','blink.png','blink-grey.png',0),(46,':roll:','blink.png','blink-grey.png',0),(47,':woohoo:','w00t.png','w00t-grey.png',1),(48,':side:','sideways.png','sideways-grey.png',1),(49,':S','dizzy.png','dizzy-grey.png',1),(50,':s','dizzy.png','dizzy-grey.png',0),(51,':evil:','devil.png','devil-grey.png',1),(52,':twisted:','devil.png','devil-grey.png',0),(53,':whistle:','whistling.png','whistling-grey.png',1),(54,':pinch:','pinch.png','pinch-grey.png',1),(55,':D','laughing.png','laughing-grey.png',0),(56,':-D','laughing.png','laughing-grey.png',0),(57,':grin:','laughing.png','laughing-grey.png',0),(58,':laugh:','laughing.png','laughing-grey.png',0),(59,':|','neutral.png','neutral-grey.png',0),(60,':-|','neutral.png','neutral-grey.png',0),(61,':neutral:','neutral.png','neutral-grey.png',0),(62,':mrgreen:','mrgreen.png','mrgreen-grey.png',0),(63,':?:','question.png','question-grey.png',0),(64,':!:','exclamation.png','exclamation-grey.png',0),(65,':arrow:','arrow.png','arrow-grey.png',0),(66,':idea:','idea.png','idea-grey.png',0);

--
-- Table structure for table `jos_kunena_subscriptions`
--

CREATE TABLE `jos_kunena_subscriptions` (
  `thread` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `future1` int(11) DEFAULT '0',
  UNIQUE KEY `thread` (`thread`,`userid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_subscriptions`
--

INSERT INTO `jos_kunena_subscriptions` VALUES (2,62,0);

--
-- Table structure for table `jos_kunena_subscriptions_categories`
--

CREATE TABLE `jos_kunena_subscriptions_categories` (
  `catid` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `future1` int(11) DEFAULT '0',
  UNIQUE KEY `thread` (`catid`,`userid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_subscriptions_categories`
--


--
-- Table structure for table `jos_kunena_thankyou`
--

CREATE TABLE `jos_kunena_thankyou` (
  `postid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `targetuserid` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `postid` (`postid`,`userid`),
  KEY `userid` (`userid`),
  KEY `targetuserid` (`targetuserid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_thankyou`
--


--
-- Table structure for table `jos_kunena_users`
--

CREATE TABLE `jos_kunena_users` (
  `userid` int(11) NOT NULL DEFAULT '0',
  `view` varchar(8) NOT NULL DEFAULT 'flat',
  `signature` text,
  `moderator` int(11) DEFAULT '0',
  `banned` datetime DEFAULT NULL,
  `ordering` int(11) DEFAULT '0',
  `posts` int(11) DEFAULT '0',
  `avatar` varchar(255) DEFAULT NULL,
  `karma` int(11) DEFAULT '0',
  `karma_time` int(11) DEFAULT '0',
  `group_id` int(4) DEFAULT '1',
  `uhits` int(11) DEFAULT '0',
  `personalText` tinytext,
  `gender` tinyint(4) NOT NULL DEFAULT '0',
  `birthdate` date NOT NULL DEFAULT '0001-01-01',
  `location` varchar(50) DEFAULT NULL,
  `ICQ` varchar(50) DEFAULT NULL,
  `AIM` varchar(50) DEFAULT NULL,
  `YIM` varchar(50) DEFAULT NULL,
  `MSN` varchar(50) DEFAULT NULL,
  `SKYPE` varchar(50) DEFAULT NULL,
  `TWITTER` varchar(50) DEFAULT NULL,
  `FACEBOOK` varchar(50) DEFAULT NULL,
  `GTALK` varchar(50) DEFAULT NULL,
  `MYSPACE` varchar(50) DEFAULT NULL,
  `LINKEDIN` varchar(50) DEFAULT NULL,
  `DELICIOUS` varchar(50) DEFAULT NULL,
  `FRIENDFEED` varchar(50) DEFAULT NULL,
  `DIGG` varchar(50) DEFAULT NULL,
  `BLOGSPOT` varchar(50) DEFAULT NULL,
  `FLICKR` varchar(50) DEFAULT NULL,
  `BEBO` varchar(50) DEFAULT NULL,
  `websitename` varchar(50) DEFAULT NULL,
  `websiteurl` varchar(50) DEFAULT NULL,
  `rank` tinyint(4) NOT NULL DEFAULT '0',
  `hideEmail` tinyint(1) NOT NULL DEFAULT '1',
  `showOnline` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`userid`),
  KEY `group_id` (`group_id`),
  KEY `posts` (`posts`),
  KEY `uhits` (`uhits`),
  KEY `banned` (`banned`),
  KEY `moderator` (`moderator`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_users`
--

INSERT INTO `jos_kunena_users` VALUES (62,'flat',NULL,0,NULL,0,2,NULL,0,0,1,20,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(65,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(66,'flat',NULL,0,NULL,0,0,NULL,0,0,1,9,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(67,'flat',NULL,0,NULL,0,0,NULL,0,0,1,10,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(68,'flat',NULL,0,NULL,0,0,NULL,0,0,1,10,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(64,'flat',NULL,0,NULL,0,0,NULL,0,0,1,12,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(69,'flat',NULL,0,NULL,0,0,NULL,0,0,1,13,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(70,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(71,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(72,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(73,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(74,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(75,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(76,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(77,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(78,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(79,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(80,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(81,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(82,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(83,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(84,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(85,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(86,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(87,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(88,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(89,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(90,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(91,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(92,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(93,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(94,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(95,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(96,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(97,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(98,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(99,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(100,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(101,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(102,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(103,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(104,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(105,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(106,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(107,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(108,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(109,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(110,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(111,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(112,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(113,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(114,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(115,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(116,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(117,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(118,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(119,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(120,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(121,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(122,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(123,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(124,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(125,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(126,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(127,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(128,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(129,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(130,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(131,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(132,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(133,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(134,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(135,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(136,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(137,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(138,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(139,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(140,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(141,'flat',NULL,0,NULL,0,0,NULL,0,0,1,1,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(142,'flat',NULL,0,NULL,0,0,NULL,0,0,1,4,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(143,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(144,'flat',NULL,0,NULL,0,0,NULL,0,0,1,4,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(145,'flat',NULL,0,NULL,0,0,NULL,0,0,1,4,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(146,'flat',NULL,0,NULL,0,0,NULL,0,0,1,4,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(147,'flat',NULL,0,NULL,0,0,NULL,0,0,1,4,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(148,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(149,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(150,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(151,'flat',NULL,0,NULL,0,0,NULL,0,0,1,4,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(152,'flat',NULL,0,NULL,0,0,NULL,0,0,1,4,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(153,'flat',NULL,0,NULL,0,0,NULL,0,0,1,4,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(154,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(155,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(156,'flat',NULL,0,NULL,0,0,NULL,0,0,1,3,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(157,'flat',NULL,0,NULL,0,0,NULL,0,0,1,3,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(158,'flat',NULL,0,NULL,0,0,NULL,0,0,1,3,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(159,'flat',NULL,0,NULL,0,0,NULL,0,0,1,3,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(160,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(161,'flat',NULL,0,NULL,0,0,NULL,0,0,1,3,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(162,'flat',NULL,0,NULL,0,0,NULL,0,0,1,3,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(163,'flat',NULL,0,NULL,0,0,NULL,0,0,1,3,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(164,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(165,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(166,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(167,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(168,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(169,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(170,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(171,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(172,'flat',NULL,0,NULL,0,0,NULL,0,0,1,2,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(173,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(174,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(175,'flat',NULL,0,NULL,0,0,NULL,0,0,1,2,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(176,'flat',NULL,0,NULL,0,0,NULL,0,0,1,2,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(177,'flat',NULL,0,NULL,0,0,NULL,0,0,1,3,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(178,'flat',NULL,0,NULL,0,0,NULL,0,0,1,2,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(179,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(180,'flat',NULL,0,NULL,0,0,NULL,0,0,1,2,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(181,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(182,'flat',NULL,0,NULL,0,0,NULL,0,0,1,2,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(183,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(184,'flat',NULL,0,NULL,0,0,NULL,0,0,1,2,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(185,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(186,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(187,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(188,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(189,'flat',NULL,0,NULL,0,0,NULL,0,0,1,3,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(190,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(191,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(192,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(193,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(194,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(195,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(196,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(197,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(198,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(199,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(200,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(201,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(202,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(203,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(204,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(205,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(206,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(207,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(208,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(209,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(210,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(211,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(212,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(213,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(214,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(215,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(216,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(217,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(218,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(219,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(220,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(221,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(222,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(223,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(224,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(225,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(226,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(227,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(228,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(229,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(230,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(231,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(232,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(233,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(234,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(235,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(236,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(237,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(238,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(239,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(240,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(241,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(242,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(243,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(244,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(245,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(246,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(247,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(248,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(249,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(250,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(251,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(252,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(253,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(254,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(255,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(256,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(257,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(258,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(259,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(260,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(261,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(262,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(263,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(264,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(265,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(266,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(267,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(268,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(269,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(270,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(271,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(272,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(273,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(274,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(275,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(276,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(277,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(278,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(279,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(280,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(281,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(282,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(283,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(284,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(285,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(286,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(287,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(288,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(289,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(290,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(291,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(292,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(293,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(294,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(295,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(296,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(297,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(298,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(299,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(300,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(301,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(302,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(303,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(304,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(305,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(306,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(307,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(308,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(309,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(310,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(311,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1),(312,'flat',NULL,0,NULL,0,0,NULL,0,0,1,0,NULL,0,'0001-01-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,1);

--
-- Table structure for table `jos_kunena_users_banned`
--

CREATE TABLE `jos_kunena_users_banned` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `ip` varchar(128) DEFAULT NULL,
  `blocked` tinyint(4) NOT NULL DEFAULT '0',
  `expiration` datetime DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_time` datetime NOT NULL,
  `reason_private` text,
  `reason_public` text,
  `modified_by` int(11) DEFAULT NULL,
  `modified_time` datetime DEFAULT NULL,
  `comments` text,
  `params` text,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `ip` (`ip`),
  KEY `expiration` (`expiration`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_users_banned`
--


--
-- Table structure for table `jos_kunena_version`
--

CREATE TABLE `jos_kunena_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(20) NOT NULL,
  `versiondate` date NOT NULL,
  `installdate` date NOT NULL,
  `build` varchar(20) NOT NULL,
  `versionname` varchar(40) DEFAULT NULL,
  `state` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_version`
--

INSERT INTO `jos_kunena_version` VALUES (1,'1.7.2','2012-01-31','2012-10-31','5215','Omega','');

--
-- Table structure for table `jos_kunena_whoisonline`
--

CREATE TABLE `jos_kunena_whoisonline` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL DEFAULT '0',
  `time` varchar(14) NOT NULL DEFAULT '0',
  `item` int(6) DEFAULT '0',
  `what` varchar(255) DEFAULT '0',
  `func` varchar(50) DEFAULT NULL,
  `do` varchar(50) DEFAULT NULL,
  `task` varchar(50) DEFAULT NULL,
  `link` text,
  `userip` varchar(20) NOT NULL DEFAULT '',
  `user` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid_userip` (`userid`,`userip`),
  KEY `func` (`func`),
  KEY `time` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=2717 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_kunena_whoisonline`
--

INSERT INTO `jos_kunena_whoisonline` VALUES (2716,0,'1434871343',0,'User is viewing main page','rules','','','http://elec.northmbk.ac.th/index.php?option=com_kunena&view=rules&func=rules&Itemid=14','66.249.75.24',0);

--
-- Table structure for table `jos_menu`
--

CREATE TABLE `jos_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menutype` varchar(75) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `alias` varchar(255) NOT NULL DEFAULT '',
  `link` text,
  `type` varchar(50) NOT NULL DEFAULT '',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `parent` int(11) unsigned NOT NULL DEFAULT '0',
  `componentid` int(11) unsigned NOT NULL DEFAULT '0',
  `sublevel` int(11) DEFAULT '0',
  `ordering` int(11) DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pollid` int(11) NOT NULL DEFAULT '0',
  `browserNav` tinyint(4) DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `utaccess` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `lft` int(11) unsigned NOT NULL DEFAULT '0',
  `rgt` int(11) unsigned NOT NULL DEFAULT '0',
  `home` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
  KEY `menutype` (`menutype`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_menu`
--

INSERT INTO `jos_menu` VALUES (1,'mainmenu','Home','home','index.php?option=com_content&view=frontpage','component',1,0,20,0,4,0,'0000-00-00 00:00:00',0,0,0,3,'num_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=front\nmulti_column_order=1\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=0\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,1),(2,'mainmenu','เกี่ยวกับแผนก','๒๕๕๕-%m-๐๘-๐๕-%M-%S','index.php?option=com_content&view=article&id=1','component',1,0,20,0,5,0,'0000-00-00 00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(3,'mainmenu','ติดต่ออาจารย์ในแผนก','๒๕๕๕-%m-๐๘-๐๕-%M-%S','index.php?option=com_content&view=article&id=2','component',1,0,20,0,6,0,'0000-00-00 00:00:00',0,0,0,0,'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(4,'mainmenu','เว็บหลัก','๒๕๕๕-%m-๐๘-๐๖-%M-%S','http://www.northmbk.ac.th','url',1,0,0,0,3,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\n\n',0,0,0),(5,'mainmenu','ภาพกิจกรรม','-m-m-s','index.php?option=com_content&view=category&layout=blog&id=1','component',-2,0,20,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'show_description=0\nshow_description_image=0\nnum_leading_articles=1\nnum_intro_articles=0\nnum_columns=0\nnum_links=0\norderby_pri=\norderby_sec=\nmulti_column_order=0\nshow_pagination=0\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(6,'mainmenu','ภาพกิจกรรม','-m-m-s','index.php?option=com_content&view=category&layout=blog&id=1','component',1,0,20,0,7,0,'0000-00-00 00:00:00',0,0,0,0,'show_description=0\nshow_description_image=0\nnum_leading_articles=1\nnum_intro_articles=0\nnum_columns=0\nnum_links=0\norderby_pri=\norderby_sec=\nmulti_column_order=0\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(7,'kunenamenu','ฟอรัม','forum','index.php?option=com_kunena&view=entrypage&defaultmenu=9','component',1,0,47,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\r\ncatids=0\r\n\r\n',0,0,0),(8,'kunenamenu','หน้าหลัก','index','index.php?option=com_kunena&view=listcat','component',1,7,47,1,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\r\ncatid=0\r\n\r\n',0,0,0),(9,'kunenamenu','กระทู้ล่าสุด','recent','index.php?option=com_kunena&view=latest','component',1,7,47,1,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\r\ndo=latest\r\n\r\n',0,0,0),(10,'kunenamenu','ตั้งกระทู้ใหม่','newtopic','index.php?option=com_kunena&view=post&do=new','component',1,7,47,1,3,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\r\ncatid=0\r\ndo=new\r\n\r\n',0,0,0),(11,'kunenamenu','กระทู้ที่ไม่มีการตอบกลับ','noreplies','index.php?option=com_kunena&view=latest&do=noreplies','component',1,7,47,1,4,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\r\ndo=noreplies\r\n\r\n',0,0,0),(12,'kunenamenu','กระทู้ของฉัน','mylatest','index.php?option=com_kunena&view=latest&do=mylatest','component',1,7,47,1,5,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\r\ndo=mylatest\r\n\r\n',0,0,0),(13,'kunenamenu','โพรไฟล์','profile','index.php?option=com_kunena&view=profile','component',1,7,47,1,6,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\r\nintegration=1\r\n\r\n',0,0,0),(14,'kunenamenu','กฏกติกา','rules','index.php?option=com_kunena&view=rules','component',1,7,47,1,7,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\r\ndo=rules\r\n\r\n',0,0,0),(15,'kunenamenu','ช่่วยเหลือ','help','index.php?option=com_kunena&view=help','component',1,7,47,1,8,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\r\ndo=help\r\n\r\n',0,0,0),(16,'kunenamenu','สืบค้น','search','index.php?option=com_kunena&view=search','component',1,7,47,1,9,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\r\n\r\n',0,0,0),(17,'mainmenu','ฟอรัม','kunenaforum','index.php?Itemid=7','menulink',0,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_item=7\r\ncatids=0\r\n\r\n',0,0,0),(18,'mainmenu','webboard','webboard','index.php?option=com_kunena&view=listcat&catid=0','component',0,0,47,0,8,0,'0000-00-00 00:00:00',0,0,0,0,'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0);

--
-- Table structure for table `jos_menu_types`
--

CREATE TABLE `jos_menu_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `menutype` varchar(75) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `menutype` (`menutype`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_menu_types`
--

INSERT INTO `jos_menu_types` VALUES (1,'mainmenu','Main Menu','The main menu for the site'),(2,'kunenamenu','เมนูใช้งานKunena','นี่คือเมนูเริ่มต้นสำหรับ Kunena  ในส่วนด้านบนของเมนู สามารถนำเสนอได้สารพัดโมดูล');

--
-- Table structure for table `jos_messages`
--

CREATE TABLE `jos_messages` (
  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id_from` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id_to` int(10) unsigned NOT NULL DEFAULT '0',
  `folder_id` int(10) unsigned NOT NULL DEFAULT '0',
  `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` int(11) NOT NULL DEFAULT '0',
  `priority` int(1) unsigned NOT NULL DEFAULT '0',
  `subject` text NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY (`message_id`),
  KEY `useridto_state` (`user_id_to`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_messages`
--


--
-- Table structure for table `jos_messages_cfg`
--

CREATE TABLE `jos_messages_cfg` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cfg_name` varchar(100) NOT NULL DEFAULT '',
  `cfg_value` varchar(255) NOT NULL DEFAULT '',
  UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_messages_cfg`
--


--
-- Table structure for table `jos_migration_backlinks`
--

CREATE TABLE `jos_migration_backlinks` (
  `itemid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `url` text NOT NULL,
  `sefurl` text NOT NULL,
  `newurl` text NOT NULL,
  PRIMARY KEY (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_migration_backlinks`
--


--
-- Table structure for table `jos_modules`
--

CREATE TABLE `jos_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `position` varchar(50) DEFAULT NULL,
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `module` varchar(50) DEFAULT NULL,
  `numnews` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `params` text NOT NULL,
  `iscore` tinyint(4) NOT NULL DEFAULT '0',
  `client_id` tinyint(4) NOT NULL DEFAULT '0',
  `control` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `published` (`published`,`access`),
  KEY `newsfeeds` (`module`,`published`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_modules`
--

INSERT INTO `jos_modules` VALUES (1,'Main Menu','',7,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'menutype=mainmenu\nmenu_style=list_flat\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=_sidenav\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n',1,0,''),(2,'Login','',1,'login',0,'0000-00-00 00:00:00',1,'mod_login',0,0,1,'',1,1,''),(3,'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,2,1,'',0,1,''),(4,'Recent added Articles','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,2,1,'ordering=c_dsc\nuser_id=0\ncache=0\n\n',0,1,''),(5,'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,2,1,'',0,1,''),(6,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,2,1,'',1,1,''),(7,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,2,1,'',1,1,''),(8,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,2,1,'',1,1,''),(9,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,2,1,'',1,1,''),(10,'Logged in Users','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,2,1,'',0,1,''),(11,'Footer','',0,'footer',0,'0000-00-00 00:00:00',1,'mod_footer',0,0,1,'',1,1,''),(12,'Admin Menu','',1,'menu',0,'0000-00-00 00:00:00',1,'mod_menu',0,2,1,'',0,1,''),(13,'Admin SubMenu','',1,'submenu',0,'0000-00-00 00:00:00',1,'mod_submenu',0,2,1,'',0,1,''),(14,'User Status','',1,'status',0,'0000-00-00 00:00:00',1,'mod_status',0,2,1,'',0,1,''),(15,'Title','',1,'title',0,'0000-00-00 00:00:00',1,'mod_title',0,2,1,'',0,1,''),(16,'footer','<p style=\"text-align: center;\">วิทยาลัยเทคโนโลยีหมู่บ้านครูภาคเหนือ จังหวัดลำพูน</p>\r\n<p style=\"text-align: center;\">197 หมู่ 8 ต.บ้านธิ อ.บ้านธิ จ.ลำพูน</p>\r\n<p style=\"text-align: center;\">053 - 558750 ต่อ 140, 141</p>\r\n<!-- โค้ด Flash Player นี้ถูกสร้างขึ้นโดย Hostpleng.com --><iframe src=\"http://www.hostpleng.com/develop/skin/script.php?iframegen&ip=202.162.78.200&port=9234&vol=80&auto=true&skin=cassette&name=FM 99.5 Lamphun Radio\" width=\"200\" height=\"120\" frameborder=\"0\" scrolling=\"no\"></iframe><!-- โค้ด Flash Player นี้ถูกสร้างขึ้นโดย Hostpleng.com -->',0,'footer',62,'2013-10-14 00:52:11',1,'mod_custom',0,0,0,'moduleclass_sfx=\n\n',0,0,''),(17,'Face Like Button Module','',2,'left',0,'0000-00-00 00:00:00',0,'mod_facelike',0,0,0,'adresa=\nauto_url=0\nlike_width=150\nlike_height=200\nlocale_lang=54\nlike_tip=0\nlike_font=0\nlike_verb=0\nlike_faces=0\nlike_color=0\nmoduleclass_sfx=\nartcreative=1\n\n',0,0,''),(18,'Update ข่าว IT ','',4,'banner',0,'0000-00-00 00:00:00',0,'mod_feed',0,0,0,'moduleclass_sfx=\nrssurl=http://www.krobkruakao.com/rss/News.rss\nrssrtl=0\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=5\nrssitemdesc=1\nword_count=100\ncache=0\ncache_time=15\n\n',0,0,''),(19,'Global News','',2,'banner',62,'2013-09-29 12:38:41',1,'mod_globalnews',0,0,1,'global=c\nlayout=slider\ncols=1\nmargin=2px\ncat_order=3\ncat_limit=\nempty=0\nfilter=0\ncurcat=0\ncatids=4\nsecids=\ncatexc=\nsecexc=\nshow_cat=1\ncat_title=1\ncat_img_align=0\ncat_img_width=\ncat_img_height=\ncat_img_margin=3px\ncat_img_border=0\ncount=3\nordering=order\nlimittitle=\nshow_front=0\nuser_id=0\ncurrent=1\nmore=1\nwidth=auto\nborder=1px solid #EFEFEF\nheader_color=#EFEFEF\nheader_padding=15px\nheight=200px\ncolor=#FFFFFF\npadding=5px\ndelay=3000\nnext=1\nhtml=GN_image  GN_break GN_break GN_text GN_readmore\nlimittext=500\ntext=1\nstriptext=1\nallowedtags=\ndate_format=\ndate=created\nitem_img_align=left\nitem_img_width=200px\nitem_img_height=\nitem_img_margin=3px\nitem_img_border=0\nauthor=alias\ncb_link=0\ncomments_table=#__comment\narticle_column=contentid\ncache=0\ncache_time=900\nmoduleclass_sfx=\n\n',0,0,''),(20,'sisa','',5,'left',0,'0000-00-00 00:00:00',1,'mod_banners',0,0,0,'target=1\ncount=1\ncid=1\ncatid=3\ntag_search=0\nordering=0\nheader_text=\nfooter_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n\n',0,0,''),(21,'activity','',9,'left',0,'0000-00-00 00:00:00',1,'mod_banners',0,0,0,'target=0\ncount=1\ncid=2\ncatid=3\ntag_search=0\nordering=0\nheader_text=\nfooter_text=\nmoduleclass_sfx=\ncache=0\ncache_time=900\n\n',0,0,''),(24,'เมนูใช้งานKunena','',1,'kunena_menu',62,'2013-09-29 12:33:48',1,'mod_mainmenu',0,0,0,'menutype=kunenamenu\nmenu_style=list\nstartLevel=1\nendLevel=2\nshowAllChildren=1\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n',0,0,''),(22,'Facebook Share','',1,'left',0,'0000-00-00 00:00:00',1,'mod_facebookshare',0,0,0,'linkTxt=Share   on   facebook\nlinkColor=3b5998\nlinkHColor=e5791e\ntheUrl=1\n\n',0,0,''),(23,'ITPFacebookLikeBox','',3,'banner',0,'0000-00-00 00:00:00',1,'mod_itpfblikebox',0,0,0,'fbPageLink=https://www.facebook.com/pages/Electronics_north_mbk/221066854676487\nfbRendering=2\nfbWidth=670\nfbHeight=600\nfbColour=light\nfbBColour=\nfbFaces=1\nfbStream=1\nfbHeader=0\nfbDynamicLocale=1\nfbLocale=en_US\nmoduleclass_sfx=\ncache=0\ncache_time=900\nfacebookLikeAppId=\nfbLoadJsLib=1\nfacebookRootDiv=1\nfacebookForceWall=0\n\n',0,0,''),(25,'webboard','',10,'left',0,'0000-00-00 00:00:00',1,'mod_banners',0,0,0,'target=1\ncount=1\ncid=3\ncatid=3\ntag_search=0\nordering=0\nheader_text=\nfooter_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n\n',0,0,''),(26,'login','',12,'left',0,'0000-00-00 00:00:00',1,'mod_login',0,0,0,'cache=0\nmoduleclass_sfx=\npretext=\nposttext=\nlogin=\nlogout=\ngreeting=1\nname=0\nusesecure=0\n\n',0,0,''),(27,'ห้องสมุด','',6,'left',0,'0000-00-00 00:00:00',1,'mod_banners',0,0,0,'target=1\ncount=1\ncid=4\ncatid=3\ntag_search=0\nordering=0\nheader_text=\nfooter_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n\n',0,0,''),(28,'นวรรตกรรม','',8,'left',0,'0000-00-00 00:00:00',1,'mod_banners',0,0,0,'target=1\ncount=1\ncid=5\ncatid=3\ntag_search=0\nordering=0\nheader_text=\nfooter_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n\n',0,0,''),(29,'GQR Codes','',4,'left',0,'0000-00-00 00:00:00',0,'mod_gqrcodes',0,0,0,'moduleclass_sfx=\nsize=150\nalign=center\ncredits=1\n\n',0,0,''),(30,'Autson Slideshow','',1,'banner',0,'0000-00-00 00:00:00',1,'mod_AutsonSlideShow',0,0,0,'moduleclass_sfx=\nslidewidth=500\nslideheight=250\nmenu_style=0\ntimeinterval=2500\nvelocity=1\nalign=center\nbackgroundcolor=#000\nlinktarget=_self\nlinkedtitle=no\nnavigation=numbers\nnavigationalign=left\narrows=yes\nhidetools=no\narrowspos=default\nnumberspos=default\nborder=0\nbordercolor=#000\nlabelcolor=#fff\nlabelsize=22\ntitlefont=BebasNeueRegular\ndesccolor=#fff\ndescsize=10\ndescfont=arial\nbgout=#333\ncolorout=#fff\nbgover=#000\ncolorover=#fff\nbgactive=#cc3333\ncoloractive=#fff\nshow_jquery=yes\njver=1.5.2\nload=onmod\nimg1=modules/mod_AutsonSlideShow/images/001.jpg\nlabel1=\ndesc1=\nlink1=\nimg2=modules/mod_AutsonSlideShow/images/002.jpg\nlabel2=\ndesc2=\nlink2=\nimg3=modules/mod_AutsonSlideShow/images/003.jpg\nlabel3=\ndesc3=\nlink3=\nimg4=modules/mod_AutsonSlideShow/images/004.jpg\nlabel4=\ndesc4=\nlink4=\nimg5=modules/mod_AutsonSlideShow/images/005.jpg\nlabel5=\ndesc5=\nlink5=\nimg6=modules/mod_AutsonSlideShow/images/006.jpg\nlabel6=\ndesc6=\nlink6=\nimg7=modules/mod_AutsonSlideShow/images/007.jpg\nlabel7=\ndesc7=\nlink7=\nimg8=modules/mod_AutsonSlideShow/images/008.jpg\nlabel8=\ndesc8=\nlink8=\nimg9=\nlabel9=\ndesc9=\nlink9=\nimg10=\nlabel10=\ndesc10=\nlink10=\nimg11=\nlabel11=\ndesc11=\nlink11=\nimg12=\nlabel12=\ndesc12=\nlink12=\nimg13=\nlabel13=\ndesc13=\nlink13=\nimg14=\nlabel14=\ndesc14=\nlink14=\nimg15=\nlabel15=\ndesc15=\nlink15=\nimg16=\nlabel16=\ndesc16=\nlink16=\nimg17=\nlabel17=\ndesc17=\nlink17=\nimg18=\nlabel18=\ndesc18=\nlink18=\nimg19=\nlabel19=\ndesc19=\nlink19=\nimg20=\nlabel20=\ndesc20=\nlink20=\n\n',0,0,''),(31,'thai clock','',3,'left',0,'0000-00-00 00:00:00',1,'mod_rmclock',0,0,0,'rmclWidth=130\nrmclHeight=130\nbgclColor=#ffffff\nclwmode=window\ncache=0\nmoduleclass_sfx=\n\n',0,0,''),(32,'JEvents Calendar','',11,'left',0,'0000-00-00 00:00:00',1,'mod_jevents_cal',0,0,0,'inc_ec_css=1\ncache=1\nmoduleclass_sfx=\nallcats=1\ncatid0=0\ncatid1=0\ncatid2=0\ncatid3=0\ncatid4=0\nminical_showlink=1\nminical_prevyear=1\nminical_prevmonth=1\nminical_actmonth=1\nminical_actyear=1\nminical_nextmonth=1\nminical_nextyear=1\nmodcal_useLocalParam=0\nmodcal_DispLastMonth=NO\nmodcal_DispLastMonthDays=0\nmodcal_DispNextMonth=NO\nmodcal_DispNextMonthDays=0\nmodcal_LinkCloaking=0\ntarget_itemid=\n\n',0,0,'');

--
-- Table structure for table `jos_modules_menu`
--

CREATE TABLE `jos_modules_menu` (
  `moduleid` int(11) NOT NULL DEFAULT '0',
  `menuid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_modules_menu`
--

INSERT INTO `jos_modules_menu` VALUES (1,0),(16,0),(17,0),(18,1),(19,1),(20,0),(21,0),(22,0),(23,1),(24,0),(25,0),(26,0),(27,0),(28,0),(29,0),(30,1),(31,0),(32,0);

--
-- Table structure for table `jos_newsfeeds`
--

CREATE TABLE `jos_newsfeeds` (
  `catid` int(11) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `alias` varchar(255) NOT NULL DEFAULT '',
  `link` text NOT NULL,
  `filename` varchar(200) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `numarticles` int(11) unsigned NOT NULL DEFAULT '1',
  `cache_time` int(11) unsigned NOT NULL DEFAULT '3600',
  `checked_out` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `rtl` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `published` (`published`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_newsfeeds`
--


--
-- Table structure for table `jos_plugins`
--

CREATE TABLE `jos_plugins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `element` varchar(100) NOT NULL DEFAULT '',
  `folder` varchar(100) NOT NULL DEFAULT '',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(3) NOT NULL DEFAULT '0',
  `iscore` tinyint(3) NOT NULL DEFAULT '0',
  `client_id` tinyint(3) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_plugins`
--

INSERT INTO `jos_plugins` VALUES (1,'Authentication - Joomla','joomla','authentication',0,1,1,1,0,0,'0000-00-00 00:00:00',''),(2,'Authentication - LDAP','ldap','authentication',0,2,0,1,0,0,'0000-00-00 00:00:00','host=\nport=389\nuse_ldapV3=0\nnegotiate_tls=0\nno_referrals=0\nauth_method=bind\nbase_dn=\nsearch_string=\nusers_dn=\nusername=\npassword=\nldap_fullname=fullName\nldap_email=mail\nldap_uid=uid\n\n'),(3,'Authentication - GMail','gmail','authentication',0,4,0,0,0,0,'0000-00-00 00:00:00',''),(4,'Authentication - OpenID','openid','authentication',0,3,0,0,0,0,'0000-00-00 00:00:00',''),(5,'User - Joomla!','joomla','user',0,0,1,0,0,0,'0000-00-00 00:00:00','autoregister=1\n\n'),(6,'Search - Content','content','search',0,1,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\nsearch_content=1\nsearch_uncategorised=1\nsearch_archived=1\n\n'),(7,'Search - Contacts','contacts','search',0,3,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(8,'Search - Categories','categories','search',0,4,1,0,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(9,'Search - Sections','sections','search',0,5,1,0,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(10,'Search - Newsfeeds','newsfeeds','search',0,6,1,0,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(11,'Search - Weblinks','weblinks','search',0,2,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(12,'Content - Pagebreak','pagebreak','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','enabled=1\ntitle=1\nmultipage_toc=1\nshowall=1\n\n'),(13,'Content - Rating','vote','content',0,4,1,1,0,0,'0000-00-00 00:00:00',''),(14,'Content - Email Cloaking','emailcloak','content',0,5,1,0,0,0,'0000-00-00 00:00:00','mode=1\n\n'),(15,'Content - Code Hightlighter (GeSHi)','geshi','content',0,5,0,0,0,0,'0000-00-00 00:00:00',''),(16,'Content - Load Module','loadmodule','content',0,6,1,0,0,0,'0000-00-00 00:00:00','enabled=1\nstyle=0\n\n'),(17,'Content - Page Navigation','pagenavigation','content',0,2,1,1,0,0,'0000-00-00 00:00:00','position=1\n\n'),(18,'Editor - No Editor','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00',''),(19,'Editor - TinyMCE','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','mode=advanced\nskin=0\ncompressed=0\ncleanup_startup=0\ncleanup_save=2\nentity_encoding=raw\nlang_mode=0\nlang_code=en\ntext_direction=ltr\ncontent_css=1\ncontent_css_custom=\nrelative_urls=1\nnewlines=0\ninvalid_elements=applet\nextended_elements=\ntoolbar=top\ntoolbar_align=left\nhtml_height=550\nhtml_width=750\nelement_path=1\nfonts=1\npaste=1\nsearchreplace=1\ninsertdate=1\nformat_date=%Y-%m-%d\ninserttime=1\nformat_time=%H:%M:%S\ncolors=1\ntable=1\nsmilies=1\nmedia=1\nhr=1\ndirectionality=1\nfullscreen=1\nstyle=1\nlayer=1\nxhtmlxtras=1\nvisualchars=1\nnonbreaking=1\ntemplate=0\nadvimage=1\nadvlink=1\nautosave=1\ncontextmenu=1\ninlinepopups=1\nsafari=1\ncustom_plugin=\ncustom_button=\n\n'),(20,'Editor - XStandard Lite 2.0','xstandard','editors',0,0,0,1,0,0,'0000-00-00 00:00:00',''),(21,'Editor Button - Image','image','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(22,'Editor Button - Pagebreak','pagebreak','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(23,'Editor Button - Readmore','readmore','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(24,'XML-RPC - Joomla','joomla','xmlrpc',0,7,0,1,0,0,'0000-00-00 00:00:00',''),(25,'XML-RPC - Blogger API','blogger','xmlrpc',0,7,0,1,0,0,'0000-00-00 00:00:00','catid=1\nsectionid=0\n\n'),(27,'System - SEF','sef','system',0,1,1,0,0,0,'0000-00-00 00:00:00',''),(28,'System - Debug','debug','system',0,2,1,0,0,0,'0000-00-00 00:00:00','queries=1\nmemory=1\nlangauge=1\n\n'),(29,'System - Legacy','legacy','system',0,3,1,1,0,0,'0000-00-00 00:00:00','route=0\n\n'),(30,'System - Cache','cache','system',0,4,0,1,0,0,'0000-00-00 00:00:00','browsercache=0\ncachetime=15\n\n'),(31,'System - Log','log','system',0,5,0,1,0,0,'0000-00-00 00:00:00',''),(32,'System - Remember Me','remember','system',0,6,1,1,0,0,'0000-00-00 00:00:00',''),(33,'System - Backlink','backlink','system',0,7,0,1,0,0,'0000-00-00 00:00:00',''),(34,'System - Mootools Upgrade','mtupgrade','system',0,8,0,1,0,0,'0000-00-00 00:00:00',''),(35,'Editor - JCE','jce','editors',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(36,'System - IE8 Compatibility','ie8_compatibility','system',0,0,0,0,0,0,'0000-00-00 00:00:00','method=meta\ncompatibility_mode=EmulateIE7\n'),(38,'Very Simple Image Gallery Plugin','vsig','content',0,0,1,0,0,0,'0000-00-00 00:00:00','im_width=500\nim_height=400\nim_quality=90\nim_align=1\nth_width=80\nth_height=90\nth_keep=keep\nth_quality=80\nth_space=10\nth_right=2\nth_area=30\nth_sort=0\nsets_use=6\nsets_txt=Set\nctrl_fwd=\nctrl_back=\ncap_show=1\ncap_pos=1\nlink_use=1\nimagepath=/images/stories/\nbuttonpath=/images/stories/vsig_buttons/\nusescript=1\nsetid=0\n\n'),(39,'Content - Easy Like and Share Plus','easyshareplus','content',0,0,0,0,0,0,'0000-00-00 00:00:00','excludeSections=\nexcludeCats=\nexcludeArticles=\nincludeArticles=\nshowInArticles=1\nshowInFrontPage=0\nshowInCategories=0\nshowInSections=0\nembed=no\nposition=2\ncss=\nalign=horizontal\ncentering=left\nsupport=yes\nogtags=no\nogtype=website\nogtitle=\nogdescription=\nogurl=\nogimage=\nogdeterminer=\nogaudio=\noglocale=\nogsitename=\nogvideo=\nogimagesecure=\nogimagetype=none\nogimagewidth=\nogimageheight=\nogvideosecure=\nogvideotype=none\nogvideowidth=\nogvideoheight=\nogaudiosecure=\nogaudiotype=none\nk2DisplayInArticles=1\nk2DisplayInItemlist=1\nvmDisplayInDetails=1\njeDisplayInEvents=1\nebDisplayInEntry=1\nebDisplayInCategories=1\nebDisplayInLatest=1\nmbDisplay=1\ngo1=yes\ncbo1=1\ngoembed=everytime\ngocss=\ngoheight=\ngowidth=\ngooutput=standard\nsizegoogle=tall\nannotation=bubble\ngolang=en-US\ngourl=\nli1=yes\ncbo2=2\nlicss=\nliheight=\nliwidth=\nlilayout=vertical\nliurl=\ndi1=yes\ncbo3=3\ndijs=everytime\ndicss=\ndiheight=\ndiwidth=\ndilayout=medium\ndiurl=\ndititle=\nst1=yes\ncbo4=4\nstcss=\nstheight=\nstwidth=\nstlayout=5\nsturl=\nre1=yes\ncbo5=5\nrecss=\nreheight=\nrewidth=\nretype=button5\nrebgcolor=\nrebordercol=\nreurl=\nretitle=\nem1=yes\ncbo6=6\nemcss=\nemheight=\nemwidth=\nemstyle=vertical\n\n'),(40,'Content - Facebook Like And Share','facebooklikeandshare','content',0,0,1,0,0,0,'0000-00-00 00:00:00','enable_like=1\nenable_share=1\nenable_comments=1\nweight_like=1\nweight_share=4\nignore_pagination=1\nauto_language=1\ncontent_tobe_excluded_buttons=\ncategory_tobe_excluded_buttons=\nposition=2\ncontainer_buttons=1\ncss_buttons=height:40px;\nview_article_buttons=1\nview_frontpage_buttons=0\nview_category_buttons=0\nview_section_buttons=0\ncontent_tobe_excluded_comments=\ncategory_tobe_excluded_comments=\nwidth_comments=450\nautofit_comments=0\nnumber_comments=10\nbox_color=light\ncontainer_comments=1\ncss_comments=border-top-style:solid;border-top-width:1px;padding:10px;text-align:center;\nview_article_comments=1\nview_frontpage_comments=0\nview_category_comments=0\nview_section_comments=0\nasynchronous_fb=0\nlayout_style=button_count\nshow_faces=1\nsend=1\nwidth_like=\nverb_to_display=1\nfont=arial\ncolor_scheme=light\nlanguage_fb=en_US\ncontainer_like=1\ncss_like=float:left;margin:10px;\ntype=article\ndefaultimage=\nonlydefaultimage=0\ndescription=0\ndirectyoutube=0\nshare_button_style=icontext\ntext_share_button=Share\ncontainer_share=1\ncss_share=float:right;margin:10px;\nenable_comments_print=0\nenable_comments_count=0\ncontainer_comments_count=1\ncss_comments_count=\nadmin_id=\napp_id=\nfb_secret_key=\nenable_admin=0\nenable_app=0\nenable_fb_autopublish=0\nfb_id_publish=\nfb_token=\nfb_code=\nfb_admin=\n\n'),(41,'System - Kunena','kunena','system',0,0,1,0,0,0,'0000-00-00 00:00:00','');

--
-- Table structure for table `jos_poll_data`
--

CREATE TABLE `jos_poll_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pollid` int(11) NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `hits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_poll_data`
--


--
-- Table structure for table `jos_poll_date`
--

CREATE TABLE `jos_poll_date` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vote_id` int(11) NOT NULL DEFAULT '0',
  `poll_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_poll_date`
--


--
-- Table structure for table `jos_poll_menu`
--

CREATE TABLE `jos_poll_menu` (
  `pollid` int(11) NOT NULL DEFAULT '0',
  `menuid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_poll_menu`
--


--
-- Table structure for table `jos_polls`
--

CREATE TABLE `jos_polls` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `voters` int(9) NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `access` int(11) NOT NULL DEFAULT '0',
  `lag` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_polls`
--


--
-- Table structure for table `jos_sections`
--

CREATE TABLE `jos_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `image` text NOT NULL,
  `scope` varchar(50) NOT NULL DEFAULT '',
  `image_position` varchar(30) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_scope` (`scope`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_sections`
--

INSERT INTO `jos_sections` VALUES (1,'electronic','','electronic','','content','left','',1,0,'0000-00-00 00:00:00',1,0,5,'');

--
-- Table structure for table `jos_stats_agents`
--

CREATE TABLE `jos_stats_agents` (
  `agent` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_stats_agents`
--


--
-- Table structure for table `jos_templates_menu`
--

CREATE TABLE `jos_templates_menu` (
  `template` varchar(255) NOT NULL DEFAULT '',
  `menuid` int(11) NOT NULL DEFAULT '0',
  `client_id` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`menuid`,`client_id`,`template`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_templates_menu`
--

INSERT INTO `jos_templates_menu` VALUES ('js_jamba_edit',0,0),('khepri',0,1);

--
-- Table structure for table `jos_weblinks`
--

CREATE TABLE `jos_weblinks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `catid` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(250) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(250) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hits` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `archived` tinyint(1) NOT NULL DEFAULT '0',
  `approved` tinyint(1) NOT NULL DEFAULT '1',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_weblinks`
--


--
-- Table structure for table `jos_wf_profiles`
--

CREATE TABLE `jos_wf_profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `users` text NOT NULL,
  `types` varchar(255) NOT NULL,
  `components` text NOT NULL,
  `area` tinyint(3) NOT NULL,
  `rows` text NOT NULL,
  `plugins` text NOT NULL,
  `published` tinyint(3) NOT NULL,
  `ordering` int(11) NOT NULL,
  `checked_out` tinyint(3) NOT NULL,
  `checked_out_time` datetime NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_wf_profiles`
--

INSERT INTO `jos_wf_profiles` VALUES (1,'Default','Default Profile for all users','','19,20,21,23,24,25','',0,'help,newdocument,undo,redo,spacer,bold,italic,underline,strikethrough,justifyfull,justifycenter,justifyleft,justifyright,spacer,blockquote,formatselect,styleselect,removeformat,cleanup;fontselect,fontsizeselect,forecolor,backcolor,spacer,paste,indent,outdent,numlist,bullist,sub,sup,textcase,charmap,hr;directionality,fullscreen,preview,source,print,searchreplace,spacer,table;visualaid,visualchars,nonbreaking,style,xhtmlxtras,anchor,unlink,link,imgmanager,spellchecker,article','contextmenu,browser,inlinepopups,media,help,paste,searchreplace,directionality,fullscreen,preview,source,table,textcase,print,style,nonbreaking,visualchars,xhtmlxtras,imgmanager,link,spellchecker,article',1,1,0,'0000-00-00 00:00:00',''),(2,'Front End','Sample Front-end Profile','','19,20,21','',1,'help,newdocument,undo,redo,spacer,bold,italic,underline,strikethrough,justifyfull,justifycenter,justifyleft,justifyright,spacer,formatselect,styleselect;paste,searchreplace,indent,outdent,numlist,bullist,cleanup,charmap,removeformat,hr,sub,sup,textcase,nonbreaking,visualchars;fullscreen,preview,print,visualaid,style,xhtmlxtras,anchor,unlink,link,imgmanager,spellchecker,article','contextmenu,inlinepopups,help,paste,searchreplace,fullscreen,preview,print,style,textcase,nonbreaking,visualchars,xhtmlxtras,imgmanager,link,spellchecker,article',0,2,0,'0000-00-00 00:00:00','');


