Creating demo databases for mfsql

For the SQLite demonstration program to work no database needs be created as an open creates the underlying file that is the database

For the MariaDB demonstration program to work a demonstration database must be setup otherwise all sql statements will fail
e.g.
   Log into MariaDB with a user that can create users and databases
   run the sql statements

CREATE database inventory;
CREATE USER inventory_user@localhost IDENTIFIED BY 'inventory_user_password';
GRANT ALL ON inventory.* TO inventory_user@localhost;
flush privileges;

For the PostgreSQL demonstration program to work a demonstration database must be setup otherwise all sql statements will fail
e.g.
   Log into PostgreSQL with a user that can create users and databases
   sudo -u postgres psql
   run the sql statements

CREATE DATABASE inventory;
CREATE USER inventory_user with encrypted password 'inventory_user_password';
ALTER DATABASE inventory OWNER TO inventory_user;
GRANT ALL privileges on database inventory to inventory_user;

Demonstration Database
Inventory


in the demos folder after compilation will be a demo program for each of the the three types of databases if you have the develpment libraries installed for them

• demo_postgre
• demo_mariadb
• demo_sqlite