Lesson: https://friendlyopenspace.site/en/stepbystep/001/createdb

Download the latest version of the library https://friendlyopenspace.site/en/download and unzip in the root directory of the library. And of course, don't forget to install NODEJS :-)

Next we need to create the following directories to store the template files and css in the root directory of the project.

• projections - the projections folder database
• templates - the templates folder
• css - folder css files

The next step we will create a MYSQL database stepbystep001, note that the encoding should be in UTF8 format.

CREATE DATABASE stepbystep001 CHARACTER SET utf8 COLLATE utf8_unicode_ci; 

Next, create a user for our database with named fos

CREATE USER 'fos'@'localhost' IDENTIFIED WITH mysql_native_password BY 'fos'; 

And give him privileges to work with the database stepbystep001

GRANT ALL PRIVILEGES ON stepbystep001.* TO 'fos'@'localhost'; 

For our example it is enough to create only one table pages.

USE stepbystep001; 

​

CREATE TABLE IF NOT EXISTS pages (
             id serial PRIMARY KEY,
             name varchar(255) UNIQUE NOT NULL,
             title text,
             body text
            ); 

Link to an example