From 22341fad67660a5c7b6307c7de51c00d5f539605 Mon Sep 17 00:00:00 2001
From: "Jean-Marc Pigeon (Delson)" <jmp@safe.ca>
Date: Tue, 24 Jun 2025 11:24:54 -0400
Subject: [PATCH] Building database (POSTGRESQL and MYSQL) ready

---
 sql/Makefile       | 38 +++++++++++++++++++++++++++++++-------
 sql/mailleur.mysql |  7 +++++++
 2 files changed, 38 insertions(+), 7 deletions(-)
 create mode 100644 sql/mailleur.mysql

diff --git a/sql/Makefile b/sql/Makefile
index 27c261f..2aa7557 100644
--- a/sql/Makefile
+++ b/sql/Makefile
@@ -13,20 +13,44 @@ mailleur.mysql					\
 	:  mailleur.sql
 	   cpp -P -DMYSQL	mailleur.sql > mailleur.mysql
 
-#--------------------------------------------------------------------
-#procedure to dele or craate a postgresql test database
+dbmysql	:  mailleur.mysql ndbmysql
+	   @ - (					\
+	     echo "CREATE USER `id -un`@localhost;";	\
+	     echo "GRANT ALL PRIVILEGES ON mailleur.* to `id -un`@localhost;";\
+	     echo "FLUSH PRIVILEGES;";			\
+	     echo "CREATE DATABASE mailleur;";		\
+	     ) | sudo mariadb -q
+	   @ cat mailleur.mysql | mariadb -q mailleur;
+	   @ cpp -P -DMYSQL datatest.sql | mariadb -q mailleur;
+	   @ echo "MYSQL database ready"
+
 
-newtest:  mailleur.postg 
-	   @ (						\
+ndbmysql:
+	   @-(						\
+	     echo "DROP DATABASE mailleur;";		\
+	     echo "DROP USER `id -un`@localhost;";	\
+	     ) | sudo mariadb 
+
+dbpostg	:  mailleur.postg ndbpostg
+	   @-(						\
 	     echo "create database mailleur;"		\
 	     ) | psql -q -U postgres template1
-	   @ cat mailleur.postg | psql mailleur;
+	   @ cat mailleur.postg | psql -q mailleur;
 	   @ cpp -P -DPOSTGRESQL datatest.sql | psql -q mailleur;
+	   @ echo "POSGRESQL database ready"
 
-deltest	:
-	   @ (						\
+ndbpostg:
+	   @-(						\
 	     echo "drop database mailleur;"		\
 	     ) | psql -q -U postgres template1
+
+#--------------------------------------------------------------------
+#procedure to dele or craate a postgresql test database
+
+newtest	:  dbpostg dbmysql
+
+deltest	:  ndbpostg ndbmysql
+
 #--------------------------------------------------------------------
 clean	:
 	   @ rm -fr mailleur.mysql mailleur.postg
diff --git a/sql/mailleur.mysql b/sql/mailleur.mysql
new file mode 100644
index 0000000..3dffd8c
--- /dev/null
+++ b/sql/mailleur.mysql
@@ -0,0 +1,7 @@
+CREATE TABLE emails (
+ email TEXT,
+ space INTEGER
+  DEFAULT 0,
+ mxspace INTEGER
+  DEFAULT 20000
+ );
-- 
2.47.3