Da

✏️ Editing: genix.sql

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: `genix230`
--

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

--
-- 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', '{&quot;mainmenu&quot;:{&quot;name&quot;:&quot;Main Menu&quot;,&quot;class&quot;:&quot;&quot;,&quot;menu&quot;:[]},&quot;footer&quot;:{&quot;name&quot;:&quot;Footer Menu&quot;,&quot;class&quot;:&quot;&quot;,&quot;menu&quot;:[]}}'),
(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', '[&quot;gxeditor&quot;]'),
(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.3.0', 'welcome-to-genixcms', '&lt;p&gt;Congratulations and welcome to the future of modular web management! &lt;strong&gt;GeniXCMS 2.3.0&lt;/strong&gt; is our most powerful release yet, featuring a refined e-commerce ecosystem and advanced financial intelligence.&lt;/p&gt;&lt;p&gt;New highlights in this version:&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Nixomers Ecosystem: Ultra-Premium checkout experiences with Glassmorphism.&lt;/li&gt;&lt;li&gt;Financial Recalculate Engine: Deep data synchronization between orders and transactions.&lt;/li&gt;&lt;li&gt;Optimized Granular Tracking: Selective unit-level monitoring for performance.&lt;/li&gt;&lt;li&gt;Next-Gen UiBuilder: Programmatic logic loops and schema-driven dashboards.&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;We hope you enjoy building with GeniXCMS. Explore the dashboard and start creating!&lt;/p&gt;', '[[admin_username]]', 'post', '1', '[[regtime]]', '1', 42),
(2, '[[regtime]]', 'Professional Publishing: Math &amp; Tables', 'professional-publishing-math-tables', '&lt;p&gt;GeniXCMS 2.1.1 introduces professional publishing tools: &lt;strong&gt;Math Equations&lt;/strong&gt; and the &lt;strong&gt;Table Wizard&lt;/strong&gt;.&lt;/p&gt;&lt;p&gt;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.&lt;/p&gt;', '[[admin_username]]', 'post', '2', '[[regtime]]', '1', 25),
(3, '[[regtime]]', 'Dynamic Layouts and Deep Dark Mode', 'dynamic-layouts-dark-mode', '&lt;p&gt;Themes now support &lt;strong&gt;Dynamic Page Layouts&lt;/strong&gt;—simply create a &lt;code&gt;layout-*.latte&lt;/code&gt; file and select it in the admin panel. Combined with our expanded &lt;strong&gt;Dark Mode&lt;/strong&gt; support, your site will look professional in any light.&lt;/p&gt;', '[[admin_username]]', 'post', '2', '[[regtime]]', '1', 18),
(4, '[[regtime]]', 'About Us', 'about-us', '&lt;p&gt;Hello and welcome to our website! We are a passionate team dedicated to delivering high-quality content and services to our incredible community.&lt;/p&gt;&lt;p&gt;This page is fully customizable. You can edit this text from the &lt;strong&gt;Pages&lt;/strong&gt; menu in your administration panel.&lt;/p&gt;', '[[admin_username]]', 'page', NULL, NULL, '1', 12),
(5, '[[regtime]]', 'Privacy Policy', 'privacy-policy', '&lt;h2&gt;Cookies&lt;/h2&gt;&lt;p&gt;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.&lt;/p&gt;&lt;h3&gt;Personal Information&lt;/h3&gt;&lt;p&gt;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.&lt;/p&gt;', '[[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 */;

📁 Sid Gifari File Manager