sdf
', 'sdf', 'sdf', 'sdf
', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `cms_digital_simak` -- CREATE TABLE IF NOT EXISTS `cms_digital_simak` ( `newsid` bigint(11) NOT NULL auto_increment, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `newstitle_en` varchar(255) NOT NULL default '', `newsopen_en` text NOT NULL, `newsdescription_en` longtext NOT NULL, `newstitle_in` varchar(255) NOT NULL, `newsopen_in` text NOT NULL, `newsdescription_in` mediumtext NOT NULL, `mainimagename` varchar(255) NOT NULL, `mainimagename2` varchar(255) NOT NULL, `pdf_file_path` varchar(255) NOT NULL, PRIMARY KEY (`newsid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `cms_digital_simak` -- INSERT INTO `cms_digital_simak` (`newsid`, `timestamp`, `newstitle_en`, `newsopen_en`, `newsdescription_en`, `newstitle_in`, `newsopen_in`, `newsdescription_in`, `mainimagename`, `mainimagename2`, `pdf_file_path`) VALUES (1, '2010-11-30 10:13:51', 'asdas', '', '', 'asd asd', '', '', 'aaaaa_3.jpg', '', 'aaa___aaa_2.pdf'); -- -------------------------------------------------------- -- -- Table structure for table `cms_education` -- CREATE TABLE IF NOT EXISTS `cms_education` ( `newsid` bigint(11) NOT NULL auto_increment, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `newstitle_en` varchar(255) NOT NULL default '', `newsopen_en` text NOT NULL, `newsdescription_en` longtext NOT NULL, `newstitle_in` varchar(255) NOT NULL, `newsopen_in` text NOT NULL, `newsdescription_in` mediumtext NOT NULL, `mainimagename` varchar(255) NOT NULL, `mainimagename2` varchar(255) NOT NULL, `pdf_file_path` varchar(255) NOT NULL, PRIMARY KEY (`newsid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cms_education` -- -- -------------------------------------------------------- -- -- Table structure for table `cms_enterpreneurship` -- CREATE TABLE IF NOT EXISTS `cms_enterpreneurship` ( `newsid` bigint(11) NOT NULL auto_increment, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `newstitle_en` varchar(255) NOT NULL default '', `newsopen_en` text NOT NULL, `newsdescription_en` longtext NOT NULL, `newstitle_in` varchar(255) NOT NULL, `newsopen_in` text NOT NULL, `newsdescription_in` mediumtext NOT NULL, `mainimagename` varchar(255) NOT NULL, `mainimagename2` varchar(255) NOT NULL, `pdf_file_path` varchar(255) NOT NULL, PRIMARY KEY (`newsid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cms_enterpreneurship` -- -- -------------------------------------------------------- -- -- Table structure for table `cms_events` -- CREATE TABLE IF NOT EXISTS `cms_events` ( `newsid` bigint(11) NOT NULL auto_increment, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `newstitle_en` varchar(255) NOT NULL default '', `newsopen_en` text NOT NULL, `newsdescription_en` longtext NOT NULL, `newstitle_in` varchar(255) NOT NULL, `newsopen_in` text NOT NULL, `newsdescription_in` mediumtext NOT NULL, `mainimagename` varchar(255) NOT NULL, `mainimagename2` varchar(255) NOT NULL, `pdf_file_path` varchar(255) NOT NULL, PRIMARY KEY (`newsid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `cms_events` -- INSERT INTO `cms_events` (`newsid`, `timestamp`, `newstitle_en`, `newsopen_en`, `newsdescription_en`, `newstitle_in`, `newsopen_in`, `newsdescription_in`, `mainimagename`, `mainimagename2`, `pdf_file_path`) VALUES (1, '2010-11-30 11:37:09', 'df', 'gdfg', '', 'gdfg', 'dfgdf', 'dfgdf
', 'aaaaa_4.jpg', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `cms_news` -- CREATE TABLE IF NOT EXISTS `cms_news` ( `newsid` bigint(11) NOT NULL auto_increment, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `newstitle_en` varchar(255) NOT NULL default '', `newsopen_en` text NOT NULL, `newsdescription_en` longtext NOT NULL, `newstitle_in` varchar(255) NOT NULL, `newsopen_in` text NOT NULL, `newsdescription_in` mediumtext NOT NULL, `mainimagename` varchar(255) NOT NULL, `mainimagename2` varchar(255) NOT NULL, `pdf_file_path` varchar(255) NOT NULL, PRIMARY KEY (`newsid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `cms_news` -- INSERT INTO `cms_news` (`newsid`, `timestamp`, `newstitle_en`, `newsopen_en`, `newsdescription_en`, `newstitle_in`, `newsopen_in`, `newsdescription_in`, `mainimagename`, `mainimagename2`, `pdf_file_path`) VALUES (1, '2010-11-30 09:32:26', 'asd', 'asd', 'asd
', 'asd', 'asd', 'asd
', 'aaaaa.jpg', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `download_category` -- CREATE TABLE IF NOT EXISTS `download_category` ( `download_catid` mediumint(8) unsigned NOT NULL auto_increment, `download_catname_en` varchar(255) collate utf8_unicode_ci NOT NULL, `download_catname_in` varchar(255) collate utf8_unicode_ci NOT NULL, `priority` smallint(5) unsigned NOT NULL, PRIMARY KEY (`download_catid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ; -- -- Dumping data for table `download_category` -- INSERT INTO `download_category` (`download_catid`, `download_catname_en`, `download_catname_in`, `priority`) VALUES (1, 'One', 'satu', 1), (2, 'Two', 'Dia', 2), (3, 'Tree', 'tiga', 3), (6, 'asd', 'fdgfh', 4); -- -------------------------------------------------------- -- -- Table structure for table `download_main` -- CREATE TABLE IF NOT EXISTS `download_main` ( `download_id` mediumint(8) unsigned NOT NULL auto_increment, `download_title` varchar(255) collate utf8_unicode_ci NOT NULL, `download_catid` mediumint(8) unsigned NOT NULL, `main_file_path` varchar(255) collate utf8_unicode_ci NOT NULL, `mainimagename` varchar(255) collate utf8_unicode_ci NOT NULL, `short_desc` text collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`download_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -- Dumping data for table `download_main` -- -- -------------------------------------------------------- -- -- Table structure for table `fh_menu` -- CREATE TABLE IF NOT EXISTS `fh_menu` ( `fh_menuid` bigint(11) NOT NULL auto_increment, `fh_kategorimenuid` bigint(11) NOT NULL default '0', `fh_name` varchar(255) NOT NULL default '', `fh_url` varchar(255) NOT NULL default '', `fh_filename` varchar(255) NOT NULL default '', PRIMARY KEY (`fh_menuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; -- -- Dumping data for table `fh_menu` -- INSERT INTO `fh_menu` (`fh_menuid`, `fh_kategorimenuid`, `fh_name`, `fh_url`, `fh_filename`) VALUES (1, 1, 'User Group', 'usermanagement/usergroup.php', 'usergroup.php'), (2, 1, 'User Management', 'usermanagement/useradmin.php', 'useradmin.php'), (3, 1, 'User Log', 'usermanagement/userlog.php', 'userlog.php'), (4, 1, 'Log By User', 'usermanagement/logbyuser.php', 'logbyuser.php'), (5, 2, 'News', 'cms/news.php', 'news.php'), (6, 2, 'Events', 'cms/events.php', 'events.php'), (7, 2, 'Education', 'cms/education.php', 'education.php'), (8, 2, 'Enterpreneurship', 'cms/enterpreneurship.php', 'enterpreneurship.php'), (9, 2, 'Achievement Info', 'cms/achievment.php', 'achievment.php'), (10, 2, 'Digital Simak', 'cms/digital_simak.php', 'digital_simak.php'), (11, 3, 'Polling', 'vote/poll.php', 'poll.php'), (12, 4, 'Banner', 'banner/banner_left.php', 'banner_left.php'), (13, 5, 'Category', 'download/category.php', 'category.php'), (14, 5, 'List download', 'download/download.php', 'download.php'); -- -------------------------------------------------------- -- -- Table structure for table `fh_menu_akses` -- CREATE TABLE IF NOT EXISTS `fh_menu_akses` ( `fh_aksesid` bigint(11) NOT NULL auto_increment, `fh_menuid` bigint(11) NOT NULL default '0', `fh_groupid` bigint(11) NOT NULL default '0', `fh_otoritasid` bigint(11) NOT NULL default '0', PRIMARY KEY (`fh_aksesid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ; -- -- Dumping data for table `fh_menu_akses` -- INSERT INTO `fh_menu_akses` (`fh_aksesid`, `fh_menuid`, `fh_groupid`, `fh_otoritasid`) VALUES (15, 1, 1, 0), (16, 2, 1, 0), (17, 3, 1, 0), (18, 4, 1, 0), (19, 5, 1, 0), (20, 6, 1, 0), (21, 7, 1, 0), (22, 8, 1, 0), (23, 9, 1, 0), (24, 10, 1, 0), (25, 11, 1, 0), (26, 12, 1, 0), (27, 13, 1, 0), (28, 14, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `fh_menu_kategori` -- CREATE TABLE IF NOT EXISTS `fh_menu_kategori` ( `fh_kategorimenuid` bigint(11) NOT NULL auto_increment, `fh_name` varchar(255) NOT NULL default '', PRIMARY KEY (`fh_kategorimenuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `fh_menu_kategori` -- INSERT INTO `fh_menu_kategori` (`fh_kategorimenuid`, `fh_name`) VALUES (1, 'User Management'), (2, 'Content Management'), (3, 'Vote / Poll Management'), (4, 'Banner Management'), (5, 'Download Management'); -- -------------------------------------------------------- -- -- Table structure for table `fh_user` -- CREATE TABLE IF NOT EXISTS `fh_user` ( `fh_userid` bigint(11) NOT NULL auto_increment, `fh_usergroupid` bigint(20) NOT NULL default '0', `fh_username` varchar(20) NOT NULL default '', `fh_password` varchar(255) NOT NULL, `fh_name` varchar(255) NOT NULL default '', `fh_address` varchar(255) NOT NULL default '', `fh_email` varchar(100) NOT NULL default '', `fh_phone` varchar(20) NOT NULL default '', `fh_mobile` varchar(35) NOT NULL default '', `fh_date` datetime default '0000-00-00 00:00:00', `fh_logindate` datetime default '0000-00-00 00:00:00', `fh_status` int(11) NOT NULL default '0', PRIMARY KEY (`fh_userid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fh_user` -- INSERT INTO `fh_user` (`fh_userid`, `fh_usergroupid`, `fh_username`, `fh_password`, `fh_name`, `fh_address`, `fh_email`, `fh_phone`, `fh_mobile`, `fh_date`, `fh_logindate`, `fh_status`) VALUES (1, 1, 'admin', 'Mu2uoA3p9slPXPxoqH0NCZJbgsz/BO5RbLwaiJeJNQ==', 'Administrator FaberHost', '', 'andry@faberhost.com', '', '', '2008-04-20 23:44:04', '2008-12-30 22:10:48', 0); -- -------------------------------------------------------- -- -- Table structure for table `fh_usergroup` -- CREATE TABLE IF NOT EXISTS `fh_usergroup` ( `fh_usergroupid` bigint(20) NOT NULL auto_increment, `fh_usergroupname` varchar(255) NOT NULL default '', PRIMARY KEY (`fh_usergroupid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fh_usergroup` -- INSERT INTO `fh_usergroup` (`fh_usergroupid`, `fh_usergroupname`) VALUES (1, 'Administrator'); -- -------------------------------------------------------- -- -- Table structure for table `fh_userlog` -- CREATE TABLE IF NOT EXISTS `fh_userlog` ( `fh_userlogid` bigint(11) NOT NULL auto_increment, `fh_userid` bigint(11) NOT NULL default '0', `fh_usergroupid` bigint(11) NOT NULL default '0', `fh_pagetitle` varchar(255) NOT NULL default '', `fh_action` varchar(255) NOT NULL default '', `fh_description` varchar(255) NOT NULL default '', `fh_date` datetime default '0000-00-00 00:00:00', PRIMARY KEY (`fh_userlogid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ; -- -- Dumping data for table `fh_userlog` -- INSERT INTO `fh_userlog` (`fh_userlogid`, `fh_userid`, `fh_usergroupid`, `fh_pagetitle`, `fh_action`, `fh_description`, `fh_date`) VALUES (1, 1, 1, 'User Group', 'Edit', 'Edit User Group : Administrator', '2010-11-30 09:27:36'), (2, 1, 1, 'News System', 'Add', 'Add News : asd', '2010-11-30 09:32:26'), (3, 1, 1, 'Digital Simak System', 'Add', 'Add Digital Simak : dsfd', '2010-11-30 10:12:27'), (4, 1, 1, 'Digital Simak System', 'Add', 'Add Digital Simak : asdas', '2010-11-30 10:13:17'), (5, 1, 1, 'Digital Simak System', 'Add', 'Add Digital Simak : asdas', '2010-11-30 10:13:51'), (6, 1, 1, 'Achievment Info System', 'Add', 'Add Achievment Info : sdf', '2010-11-30 10:14:37'), (7, 1, 1, 'Achievment Info System', 'Edit', 'Edit Achievment Info : sdf', '2010-11-30 10:14:43'), (8, 1, 1, 'User Group', 'Edit', 'Edit User Group : Administrator', '2010-11-30 10:54:16'), (9, 1, 1, 'News System', 'Edit', 'Edit News : asd', '2010-11-30 11:36:46'), (10, 1, 1, 'Events System', 'Add', 'Add Events : df', '2010-11-30 11:37:09'), (11, 1, 1, 'Banner System', 'Add', 'Add Banner : asdas', '2010-11-30 12:01:50'), (12, 1, 1, 'Banner System', 'Edit', 'Edit Banner : asdas', '2010-11-30 12:01:58'), (13, 1, 1, 'Banner System', 'Edit', 'Edit Banner : google', '2010-11-30 12:02:05'), (14, 1, 1, 'Banner System', 'Edit', 'Edit Banner : google', '2010-11-30 12:02:11'), (15, 1, 1, 'Banner System', 'Edit', 'Edit Banner : google', '2010-11-30 12:02:17'), (16, 1, 1, 'Banner System', 'Edit', 'Edit Banner : google', '2010-11-30 12:02:22'), (17, 1, 1, 'Banner System', 'Add', 'Add Banner : asd', '2010-11-30 12:09:57'), (18, 1, 1, 'Banner System', 'Add', 'Add Banner : sdfsdf', '2010-11-30 12:10:07'), (19, 1, 1, 'Download Category System', 'Add', 'Add Download Category : Satu', '2010-11-30 13:23:15'), (20, 1, 1, 'Download Category System', 'Edit', 'Edit Download Category : One', '2010-11-30 13:24:02'), (21, 1, 1, 'Download Category System', 'Add', 'Add Download Category : Two', '2010-11-30 13:24:12'), (22, 1, 1, 'Download Category System', 'Add', 'Add Download Category : Tree', '2010-11-30 13:26:26'), (23, 1, 1, 'Download Category System', 'Add', 'Add Download Category : foru', '2010-11-30 13:26:38'), (24, 1, 1, 'Download Category System', 'Delete', 'Delete Download Category : foru, id : 4', '2010-11-30 13:27:00'), (25, 1, 1, 'Download Category System', 'Add', 'Add Download Category : asdas', '2010-11-30 13:27:14'), (26, 1, 1, 'Download Category System', 'Add', 'Add Download Category : asd', '2010-11-30 13:27:17'), (27, 1, 1, 'Download Category System', 'Delete', 'Delete Download Category : asdas, id : 5', '2010-11-30 13:27:30');