And the database tables created:
-- MySQL dump 10.13 Distrib 5.7.12, for Win64 (x86_64)
-- Host: bgncloud.nl Database: BASDB
-- Server version 5.5.5-10.1.38-MariaDB-0ubuntu0.18.04.2
/*!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 /;
/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
/!40103 SET TIME_ZONE='+00:00' /;
/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table BAS_IDGEN
DROP TABLE IF EXISTS BAS_IDGEN;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE BAS_IDGEN (
MAX_ID int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table BAS_IDGEN
LOCK TABLES BAS_IDGEN WRITE;
/*!40000 ALTER TABLE BAS_IDGEN DISABLE KEYS /;
INSERT INTO BAS_IDGEN VALUES (1);
/!40000 ALTER TABLE BAS_IDGEN ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table BAS_SYSTEM
DROP TABLE IF EXISTS BAS_SYSTEM;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE BAS_SYSTEM (
P1 varchar(100) DEFAULT NULL,
P2 varchar(100) DEFAULT NULL,
P3 varchar(100) DEFAULT NULL,
P4 varchar(100) DEFAULT NULL,
P5 varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table BAS_SYSTEM
LOCK TABLES BAS_SYSTEM WRITE;
/*!40000 ALTER TABLE BAS_SYSTEM DISABLE KEYS /;
INSERT INTO BAS_SYSTEM VALUES ('673d795b5a717fe0ddbf',NULL,'e2cfc1b3503439752b900c8e06c68d01','DefaultApplication','0.9948259108450725');
/!40000 ALTER TABLE BAS_SYSTEM ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table BAS_SYSTEM2
DROP TABLE IF EXISTS BAS_SYSTEM2;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE BAS_SYSTEM2 (
P1 varchar(100) DEFAULT NULL,
P2 varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table BAS_SYSTEM2
LOCK TABLES BAS_SYSTEM2 WRITE;
/*!40000 ALTER TABLE BAS_SYSTEM2 DISABLE KEYS /;
/!40000 ALTER TABLE BAS_SYSTEM2 ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table ConfigToolUsers
DROP TABLE IF EXISTS ConfigToolUsers;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE ConfigToolUsers (
Acl int(11) DEFAULT NULL,
LoginName varchar(80) DEFAULT NULL,
Password varchar(250) DEFAULT NULL,
BusinessSpaces mediumblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table ConfigToolUsers
LOCK TABLES ConfigToolUsers WRITE;
/*!40000 ALTER TABLE ConfigToolUsers DISABLE KEYS /;
INSERT INTO ConfigToolUsers VALUES (0,'admin','5f4db43b5ad965aa1dfd27a2c8feb1e7',NULL);
/!40000 ALTER TABLE ConfigToolUsers ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT
DROP TABLE IF EXISTS DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT (
ID int(11) NOT NULL,
BASVERSION int(11) DEFAULT NULL,
BASTIMESTAMP datetime DEFAULT NULL,
UDD_AccessLevels varchar(250) DEFAULT NULL,
UDD_Template_DOCTYPE varchar(200) DEFAULT NULL,
UDD_Template_DOCDATA longblob,
UDD_Name varchar(50) DEFAULT NULL,
UDD_Type varchar(50) DEFAULT NULL,
UDD_ObjName varchar(80) DEFAULT NULL,
UDD_QueryString mediumtext,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT
LOCK TABLES DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT WRITE;
/*!40000 ALTER TABLE DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT DISABLE KEYS /;
/!40000 ALTER TABLE DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY
DROP TABLE IF EXISTS DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY (
ID int(11) NOT NULL,
BASVERSION int(11) DEFAULT NULL,
BASTIMESTAMP datetime DEFAULT NULL,
UDQ_Name varchar(50) DEFAULT NULL,
UDQ_AccessLevels varchar(250) DEFAULT NULL,
UDQ_Query mediumblob,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY
LOCK TABLES DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY WRITE;
/*!40000 ALTER TABLE DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY DISABLE KEYS /;
/!40000 ALTER TABLE DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table DEFAULTAPPLICATION_REGULARUSER
DROP TABLE IF EXISTS DEFAULTAPPLICATION_REGULARUSER;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE DEFAULTAPPLICATION_REGULARUSER (
ID int(11) NOT NULL,
BASVERSION int(11) DEFAULT NULL,
BASTIMESTAMP datetime DEFAULT NULL,
AccessLevel varchar(50) DEFAULT NULL,
Theme varchar(80) DEFAULT NULL,
TimeZone varchar(80) DEFAULT NULL,
Password varchar(40) DEFAULT NULL,
RTL bit(1) DEFAULT NULL,
SessionTimeout int(11) DEFAULT NULL,
LoginName varchar(40) DEFAULT NULL,
Locale varchar(50) DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table DEFAULTAPPLICATION_REGULARUSER
LOCK TABLES DEFAULTAPPLICATION_REGULARUSER WRITE;
/*!40000 ALTER TABLE DEFAULTAPPLICATION_REGULARUSER DISABLE KEYS /;
INSERT INTO DEFAULTAPPLICATION_REGULARUSER VALUES (1,1,'2019-05-31 12:42:01','Administrator',NULL,NULL,'5f4db43b5ad965aa1dfd27a2c8feb1e7',NULL,NULL,'admin',NULL);
/!40000 ALTER TABLE DEFAULTAPPLICATION_REGULARUSER ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table DEFAULTAPPLICATION_SYSTEMSETTINGS
DROP TABLE IF EXISTS DEFAULTAPPLICATION_SYSTEMSETTINGS;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE DEFAULTAPPLICATION_SYSTEMSETTINGS (
ID int(11) NOT NULL,
BASVERSION int(11) DEFAULT NULL,
BASTIMESTAMP datetime DEFAULT NULL,
OutgoingEmailSSL bit(1) DEFAULT NULL,
UDPAcls varchar(3) DEFAULT NULL,
OutgoingEmailPort int(11) DEFAULT NULL,
OutgoingEmailFromAddress varchar(50) DEFAULT NULL,
GoogleMapsKey varchar(150) DEFAULT NULL,
OutgoingEmailUserName varchar(50) DEFAULT NULL,
OutgoingEmailTLS bit(1) DEFAULT NULL,
IncomingEmailUserName varchar(50) DEFAULT NULL,
OutgoingEmailPassword varchar(50) DEFAULT NULL,
IncomingEmailPassword varchar(50) DEFAULT NULL,
IncomingEmailSSL bit(1) DEFAULT NULL,
IncomingEmailProtocol varchar(15) DEFAULT NULL,
IncomingEmailHost varchar(50) DEFAULT NULL,
OutgoingEmailHost varchar(50) DEFAULT NULL,
IncomingEmailPort int(11) DEFAULT NULL,
IncomingEmailTLS bit(1) DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table DEFAULTAPPLICATION_SYSTEMSETTINGS
LOCK TABLES DEFAULTAPPLICATION_SYSTEMSETTINGS WRITE;
/*!40000 ALTER TABLE DEFAULTAPPLICATION_SYSTEMSETTINGS DISABLE KEYS /;
/!40000 ALTER TABLE DEFAULTAPPLICATION_SYSTEMSETTINGS ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table DOMAINS
DROP TABLE IF EXISTS DOMAINS;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE DOMAINS (
ID int(11) NOT NULL AUTO_INCREMENT,
DATA mediumblob,
PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table DOMAINS
LOCK TABLES DOMAINS WRITE;
/*!40000 ALTER TABLE DOMAINS DISABLE KEYS /;
INSERT INTO DOMAINS VALUES (1,'xœ…T\ÍoEY{›\ÔnKš\0•@ \rmhY’[š´K\ÄF&M\å\ÈBX%\Z\ïN\ì\rû1̾u·P{Ÿ\äc\'$.ü=UH•8 DopD´R\̯?„Y\É?\ï̼y¿÷\Þ\ï½\Ýý\ÌD™X¶XðˆyL,-!‹[[\Ü\ÅĪû¡¸v.ëO¿õšU6˜¨A¯Ž0WS*#*#*uûòº2«f¬qLK%sq\Èu÷Ë«»3¿\×\\º,Hy‚ðHm‹uY%E?¨¼Î’²V ¼•\É,Xtb\rNf|h\î\é•\ß(€±¥ fÞ²\"‰¥±#yÒ‰/ž©kS\n\Ë\êWD(®²Pe7cóM–¸$D\à»ý8B0[ñ\Õ|‹Ú–!os9ó\Ûö\Î\ß7?|E…쀩CVyO\íVÓ°\Å\å»_<Qþü×€L(¶ „©†m\Æ2LR ó\ÍÚ¸J\r+T½söÁ‹7ν\Ýwd$\ï\Âû\0\Z\Í%e ˜š¡°- hÔ‘!\×\æ%Š#SY\Û=5\ï\'ÛŸ\Ý\Þ=¿c@\á-(ûÉšôCý.\É.—‰’j\Ô÷T{‚Qú•:J?jS/œÇ²\ìg\Ü\ë1\Ù\åvºúóMŠ58¼\áv¸û÷\èDG]¨A‰¡ò\ÚJ‘ºcf¤;\Zœ„®\Ö\à\ÈЂú\"¿WŒ”¾ô~,\Ô=\Ó\Ã\î\éݼó\Õ{\Í\Õ\ï&\nPp\à¨\Ës}¼\îD®\ä!ÐC<\Ðo—\â4\Â&”ó%\éƒ0\Û\É;—KkD©T\Î\rz}‘|r\ë\Ío¦“ù ¯gI\Åu\êôX\ê\'·ò\Ú\é»÷¾\Ø6À\Ín0§\'\Æ\ÎiL]š\Ñ\Å}T¡š¤\'\ÚD:\Ð\É }þÁ\Ã#¦¦\Zƒ³/\î±<Ù³¤³y\âJZ\ï䚷g«Ð¨½1\âqJ“¯û!\ß\ã´\"\è\Éþ£\ÍMÁ3\Ϝѡ\Ì\Ìœ\"8Mð\†pÈŽC\æGŽú\Þ5œ>ˆñ¥™ô4½0¬Mdôö\§\ÎewIn,_YExÙC«\Å+\é0\É=\ËÓ´–G›~;•úcå¤f}T–WEÿ=ž‡7™\Ò\êI\Ý)E\Z)(Á\ä¾õA‚gû7\ì‹{Xß·a\î×\à°NoŒ“\æs\Îóƒ›6Á‚W .\\Ä^%X\"XT”†5\ÊòôöV');
/!40000 ALTER TABLE DOMAINS ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table DOMAINVERSIONS
DROP TABLE IF EXISTS DOMAINVERSIONS;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE DOMAINVERSIONS (
DNAME char(50) DEFAULT NULL,
VERSIONSTR char(30) DEFAULT NULL,
DATA mediumblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table DOMAINVERSIONS
LOCK TABLES DOMAINVERSIONS WRITE;
/*!40000 ALTER TABLE DOMAINVERSIONS DISABLE KEYS /;
INSERT INTO DOMAINVERSIONS VALUES ('DefaultApplication','1.0','..... TEXT DELETED by ME .....');
/!40000 ALTER TABLE DOMAINVERSIONS ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table DVHISTORIES
DROP TABLE IF EXISTS DVHISTORIES;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE DVHISTORIES (
DNAME char(50) DEFAULT NULL,
VERSIONSTR char(30) DEFAULT NULL,
EVENTTYPE tinyint(4) DEFAULT NULL,
EVENTTIME datetime DEFAULT NULL,
DESCR varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table DVHISTORIES
LOCK TABLES DVHISTORIES WRITE;
/*!40000 ALTER TABLE DVHISTORIES DISABLE KEYS /;
INSERT INTO DVHISTORIES VALUES ('DefaultApplication','1.0',0,'2019-05-31 12:42:01','Blank version created'),('DefaultApplication','1.1',0,'2019-05-31 12:42:01','Created from version 1.0');
/!40000 ALTER TABLE DVHISTORIES ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table DV_SYNC_LOG
DROP TABLE IF EXISTS DV_SYNC_LOG;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE DV_SYNC_LOG (
AwEventId int(11) DEFAULT NULL,
AwEventName varchar(60) DEFAULT NULL,
AwUserId int(11) DEFAULT NULL,
CalendarId varchar(100) DEFAULT NULL,
SyncTime datetime DEFAULT NULL,
VEventId varchar(100) DEFAULT NULL,
VendorId varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table DV_SYNC_LOG
LOCK TABLES DV_SYNC_LOG WRITE;
/*!40000 ALTER TABLE DV_SYNC_LOG DISABLE KEYS /;
/!40000 ALTER TABLE DV_SYNC_LOG ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table EXECUTION_CONTEXTS
DROP TABLE IF EXISTS EXECUTION_CONTEXTS;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE EXECUTION_CONTEXTS (
ID int(11) DEFAULT NULL,
DATA tinyblob,
LONGDATA mediumblob,
PGID int(11) DEFAULT NULL,
PROCNAME varchar(50) DEFAULT NULL,
POLLING bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table EXECUTION_CONTEXTS
LOCK TABLES EXECUTION_CONTEXTS WRITE;
/*!40000 ALTER TABLE EXECUTION_CONTEXTS DISABLE KEYS /;
/!40000 ALTER TABLE EXECUTION_CONTEXTS ENABLE KEYS /;
UNLOCK TABLES;
/!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE /;
/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
/!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 /;
/!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-05-31 12:47:05
