CMS Database Setup

WYSIWYG Web Builder includes a powerful built-in Content Management System (CMS) that allows you or your clients to manage website content online—without needing to edit and publish the site locally.

You can find an introduction to this feature here:
https://www.wysiwygwebbuilder.com/cms_tools.html

The CMS requires a MySQL database to store page content and related data. Therefore, your hosting account must support MySQL.
Most paid hosting plans include database support. If your current plan does not, please contact your hosting provider to upgrade accordingly.

Preparing Your Database
Once you've confirmed that your hosting supports MySQL, you’ll need to either create a new database, or locate the details of an existing one
Please refer to your hosting provider’s documentation for instructions on how to create a MySQL database, as the process varies between hosts.

To configure the CMS tools, make sure you have the following details ready:

Server
Specifies the MySQL database server. Some web hosts use 'localhost' while others have a dedicated database server. Consult the documentation of your host for the exact server name.

Database
Specifies the MySQL database name. Either your host created (and named) the database for you or you will have to create a new database yourself in your host's Control Panel. See the documentation of your website for more details.

UserName
Specifies the MySQL username.

Password
Specifies the MySQL password.

The CMS will automatically create the required tables if they do not exist, so you do not have to create the tables manually.
The following tables will be created (note that the table prefix 'CMS_' is configurable):

CMS_PAGES

This table contains the page information like page title, content, created/updated date, view count etc.

CMS_SEARCH_WORDS

This table is part of the search index and contains all unique words.

CMS_SEARCH_WORDMATCH

This table is part of the search index and contains the word to page relationship.

Note:
Additional database tables may be generated by CMS plug-ins. These tables will have the prefix CMS.

Manually create MYSQL tables

Although in most cases the tables will be automatically created the first time you login to the CMS Admin, you can also create them manually.

--
-- Table structure for table `CMS_PAGES`
--

CREATE TABLE `CMS_PAGES` (
`id` int(10) unsigned NOT NULL auto_increment,
`category_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`content` text NOT NULL,
`home` tinyint(1) NOT NULL default '0',
`visible` tinyint(1) NOT NULL,
`create_date` timestamp NOT NULL,
`created_by` varchar(255) NOT NULL,
`last_update_date` timestamp NOT NULL default '1970-01-01 00:00:01',
`last_update_by` varchar(255) NOT NULL,
`views` int(11) NOT NULL,
`menu_index` smallint(4) NOT NULL,
`url` varchar(255) NULL,
`extra_data` varchar(255) NULL,
`title` VARCHAR(100),
`description` VARCHAR(255),
`keywords` VARCHAR(255),
`seo_friendly_url` VARCHAR(100),
`parent_id` int(11) DEFAULT NULL,
`search_index` int(1) DEFAULT '1'
PRIMARY KEY (`id`));

--
-- Table structure for table `CMS_SEARCH_WORDMATCH`
--
CREATE TABLE `CMS_SEARCH_WORDMATCH` (
`page_id` int(10) unsigned NOT NULL,
`word_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`page_id`,`word_id`));

--
-- Table structure for table `CMS_SEARCH_WORDS`
--
CREATE TABLE `CMS_SEARCH_WORDS` (
`id` int(10) unsigned NOT NULL auto_increment,
`word` varchar(50) NOT NULL,
PRIMARY KEY (`id`)) ;