SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `genix220`
--
-- --------------------------------------------------------
--
-- Table structure for table `cat`
--
CREATE TABLE `cat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`slug` text NOT NULL,
`parent` text,
`image` text,
`desc` text,
`type` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `cat`
--
INSERT INTO `cat` VALUES
(1, 'News', 'news', '0', NULL, 'Latest announcements and news.', 'post'),
(2, 'Tutorials', 'tutorials', '0', NULL, 'Guides and how-to articles.', 'post');
-- --------------------------------------------------------
--
-- Table structure for table `cat_param`
--
CREATE TABLE `cat_param` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cat_id` int(11) NOT NULL,
`param` text NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`id` bigint(22) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL,
`userid` text NOT NULL,
`name` text NOT NULL,
`email` text NOT NULL,
`url` text NOT NULL,
`comment` longtext NOT NULL,
`post_id` int(11) NOT NULL,
`parent` int(11) NOT NULL,
`status` enum('0','1','2') NOT NULL,
`type` text NOT NULL,
`ipaddress` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `comments`
--
INSERT INTO `comments` VALUES
(1, '[[regtime]]', '[[admin_username]]', '[[admin_username]]', '[[admin_email]]', '', 'This is sample of comment<br />', 6, 0, '1', 'post', '::1');
-- --------------------------------------------------------
--
-- Table structure for table `menus`
--
CREATE TABLE `menus` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`menuid` varchar(32) NOT NULL,
`parent` varchar(11) DEFAULT NULL,
`sub` enum('0','1') NOT NULL,
`type` varchar(8) NOT NULL,
`value` text NOT NULL,
`class` varchar(64) DEFAULT NULL,
`order` varchar(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `menus`
--
INSERT INTO `menus` VALUES
(1, 'Home', 'mainmenu', '0', '0', 'custom', '[[softurl]]/', '', NULL),
(2, 'About Us', 'mainmenu', '0', '0', 'page', '4', '', NULL),
(3, 'Privacy Policy', 'footer', '0', '0', 'page', '5', '', NULL),
(4, 'Contact Us', 'footer', '0', '0', 'mod', 'contactPage', '', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `options`
--
CREATE TABLE `options` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`value` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=70 ;
--
-- Dumping data for table `options`
--
INSERT INTO `options` VALUES
(1, 'sitename', '[[site_name]]'),
(2, 'siteurl', '[[softurl]]/'),
(3, 'sitedomain', '[[domhost]]'),
(4, 'siteslogan', '[[site_desc]]'),
(5, 'sitedesc', ''),
(6, 'sitekeywords', ''),
(7, 'siteicon', '[[softurl]]/favicon.ico'),
(8, 'siteaddress', ''),
(9, 'siteemail', ''),
(10, 'fbacc', ''),
(11, 'fbpage', ''),
(12, 'twitter', ''),
(13, 'linkedin', ''),
(14, 'gplus', ''),
(15, 'logo', 'assets/images/genixcms-logo-sign-small.png'),
(16, 'logourl', ''),
(17, 'is_logourl', 'off'),
(18, 'currency', 'USD'),
(19, 'country_id', 'ID'),
(20, 'mailtype', '0'),
(21, 'smtphost', ''),
(22, 'smtpuser', ''),
(23, 'smtppass', ''),
(24, 'smtpport', '25'),
(25, 'timezone', 'Asia/Jakarta'),
(26, 'paypalemail', ''),
(27, 'robots', 'index, follow'),
(28, 'use_jquery', 'on'),
(29, 'use_bootstrap', 'on'),
(30, 'use_fontawesome', 'on'),
(31, 'use_bsvalidator', 'on'),
(32, 'jquery_v', '3.7.1'),
(33, 'bs_v', ''),
(34, 'fontawesome_v', ''),
(35, 'use_editor', 'on'),
(36, 'editor_type', 'summernote'),
(37, 'editor_v', ''),
(38, 'menus', '{"mainmenu":{"name":"Main Menu","class":"","menu":[]},"footer":{"name":"Footer Menu","class":"","menu":[]}}'),
(39, 'post_perpage', '3'),
(40, 'pagination', 'pager'),
(41, 'pinger', 'rpc.pingomatic.com\r\nblogsearch.google.com/ping/RPC2\r\nfeedburner.google.com/fb/a/pingSubmit?bloglink=http%3A%2F%2F{{domain}}'),
(42, 'bsvalidator_v', ''),
(43, 'ppsandbox', 'off'),
(44, 'ppuser', ''),
(45, 'pppass', ''),
(46, 'ppsign', ''),
(47, 'tokens', ''),
(48, 'modules', '["gxeditor"]'),
(49, 'themes', 'default'),
(50, 'system_lang', 'en_US'),
(51, 'charset', 'utf-8'),
(52, 'google_captcha_sitekey', ''),
(53, 'google_captcha_secret', ''),
(54, 'google_captcha_lang', 'en'),
(55, 'google_captcha_enable', 'off'),
(56, 'multilang_enable', 'off'),
(57, 'multilang_default', ''),
(58, 'multilang_country', ''),
(59, 'system_check', '{}'),
(60, 'permalink_use_index_php', 'off'),
(61, 'pinger_enable', 'on'),
(62, 'cdn_url', '[[softurl]]/'),
(63, 'spamwords', ''),
(64, 'comments_perpage', '5'),
(65, 'comments_enable', 'on'),
(66, 'db_version', '1.1.4'),
(67, 'cache_enabled', 'off'),
(68, 'cache_path', '/assets/cache/pages/'),
(69, 'cache_timeout', '300');
-- --------------------------------------------------------
--
-- Table structure for table `permissions`
--
CREATE TABLE `permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`permission` varchar(100) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `posts`
--
CREATE TABLE `posts` (
`id` bigint(32) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL,
`title` text NOT NULL,
`slug` text NOT NULL,
`content` longtext NOT NULL,
`author` text NOT NULL,
`type` text NOT NULL,
`cat` varchar(11) DEFAULT NULL,
`modified` datetime DEFAULT NULL,
`status` enum('0','1','2') NOT NULL,
`views` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `posts`
--
INSERT INTO `posts` VALUES
(1, '[[regtime]]', 'Welcome to GeniXCMS 2.1.1', 'welcome-to-genixcms', '<p>Congratulations and welcome to the next generation of Content Management! <strong>GeniXCMS 2.1.1</strong> is our most advanced release yet, featuring a professional-grade editor and a robust modular architecture.</p><p>Key features to explore:</p><ul><li>Professional GxEditor with Math & Table support.</li><li>Dynamic Page Layouts and Dark Mode aesthetics.</li><li>Powerful REST API and OAuth2 integrations.</li><li>Secure, session-based CSRF protection.</li></ul><p>We hope you enjoy building with GeniXCMS. Explore the dashboard to start customizing your site!</p>', '[[admin_username]]', 'post', '1', '[[regtime]]', '1', 42),
(2, '[[regtime]]', 'Professional Publishing: Math & Tables', 'professional-publishing-math-tables', '<p>GeniXCMS 2.1.1 introduces professional publishing tools: <strong>Math Equations</strong> and the <strong>Table Wizard</strong>.</p><p>Write complex LaTeX formulas with real-time previews using the Sigma-Root icon, or build structured tables via our new Bootstrap-based modal interface. These tools make GeniXCMS perfect for technical and academic content.</p>', '[[admin_username]]', 'post', '2', '[[regtime]]', '1', 25),
(3, '[[regtime]]', 'Dynamic Layouts and Deep Dark Mode', 'dynamic-layouts-dark-mode', '<p>Themes now support <strong>Dynamic Page Layouts</strong>—simply create a <code>layout-*.latte</code> file and select it in the admin panel. Combined with our expanded <strong>Dark Mode</strong> support, your site will look professional in any light.</p>', '[[admin_username]]', 'post', '2', '[[regtime]]', '1', 18),
(4, '[[regtime]]', 'About Us', 'about-us', '<p>Hello and welcome to our website! We are a passionate team dedicated to delivering high-quality content and services to our incredible community.</p><p>This page is fully customizable. You can edit this text from the <strong>Pages</strong> menu in your administration panel.</p>', '[[admin_username]]', 'page', NULL, NULL, '1', 12),
(5, '[[regtime]]', 'Privacy Policy', 'privacy-policy', '<h2>Cookies</h2><p>We gather information about visitors who visit our site. For anonymous visitors, we track non-identifying data for analytics to improve user experience. You can manage or delete cookies directly from your browser settings.</p><h3>Personal Information</h3><p>If you register on our site, we securely store information such as your Name and Email address. We do not sell or share this information to untrusted third parties. It is strictly used for platform communication.</p>', '[[admin_username]]', 'page', NULL, NULL, '1', 4);
-- --------------------------------------------------------
--
-- Table structure for table `posts_param`
--
CREATE TABLE `posts_param` (
`id` bigint(32) NOT NULL AUTO_INCREMENT,
`post_id` bigint(32) NOT NULL,
`param` text NOT NULL,
`value` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `user`
--
CREATE TABLE `user` (
`id` bigint(32) NOT NULL AUTO_INCREMENT,
`userid` varchar(32) NOT NULL,
`pass` varchar(255) NOT NULL,
`confirm` varchar(255) DEFAULT NULL,
`group` enum('0','1','2','3','4','5','6') NOT NULL,
`email` varchar(255) NOT NULL,
`join_date` datetime NOT NULL,
`status` enum('0','1') NOT NULL,
`activation` text,
`ipaddress` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `user`
--
INSERT INTO `user` VALUES
(1, '[[admin_username]]', '[[admin_pass]]', NULL, '0', '[[admin_email]]', '[[regtime]]', '1', NULL, '[[clientip]]');
-- --------------------------------------------------------
--
-- Table structure for table `user_detail`
--
CREATE TABLE `user_detail` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`userid` varchar(32) NOT NULL,
`fname` varchar(32) DEFAULT NULL,
`lname` varchar(255) DEFAULT NULL,
`sex` varchar(2) DEFAULT NULL,
`birthplace` varchar(32) DEFAULT NULL,
`birthdate` date DEFAULT NULL,
`addr` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`postcode` varchar(32) DEFAULT NULL,
`avatar` text,
`balance` float DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `user_detail`
--
INSERT INTO `user_detail` VALUES
(1, '[[admin_username]]', '[[admin_realname]]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'IN', NULL, NULL, 0);
-- --------------------------------------------------------
--
-- Table structure for table `widgets`
--
CREATE TABLE `widgets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`content` longtext NOT NULL,
`type` text NOT NULL,
`location` text NOT NULL,
`sorting` int(11) NOT NULL,
`status` enum('0','1') NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
