CREATE TABLE Vendors (
userId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
userEmail varchar(50) NOT NULL,
userName varchar(20) NOT NULL,
userPassword varchar(20) NOT NULL,
userPackageType varchar(10) NOT NULL DEFAULT 'vendor',
userAvatarURL varchar(100) NOT NULL DEFAULT 'https://www.wmpg.org/wp-content/uploads/2019/03/default-avatar-300x300.jpg',
userCoverURL varchar(100) NOT NULL DEFAULT 'https://image.freepik.com/free-vector/gradient-geometric-shapes-dark-background_52683-33258.jpg'
userHash varchar NOT NULL,
userVerified boolean DEFAULT false
);

CREATE TABLE VendorConfigurations (
userId int NOT NULL PRIMARY KEY,
userBitcoinAddress,
userEthereumAddress,
userLitecoinAddress,
userPayPalAddress,
userStripeKey,
);

CREATE TABLE VendorItems (
itemId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
userId int,
itemName,
itemCategory,
itemMarketplaceCategory,
itemSales,
itemTags,
itemDescription,
itemPrice,
itemThumbnailURL,
itemImageURLs,
itemUpdatedDate,
itemCreatedDate
);

CREATE TABLE VendorItemReviews (
reviewId,
itemId,
reviewAuthor,
reviewVendor,
reviewTitle,
reviewBody,
reviewRating
);

CREATE TABLE FundingScheme (
fundingScheme varchar(20) NOT NULL PRIMARY KEY,
title varchar(50) NOT NULL,
description varchar(100) DEFAULT '',
fsLanguage varchar(2) NOT NULL,
fsCall varchar(30) NOT NULL
);

CREATE TABLE Project_FundingScheme (
fundingSchemeId varchar(20) NOT NULL,
projectId int(10) NOT NULL,
FOREIGN KEY (fundingSchemeId) REFERENCES FundingScheme(fundingScheme),
FOREIGN KEY (projectId) REFERENCES Project(projectId)
);

CREATE TABLE AdministrativeContact (
countryId varchar(2) NOT NULL PRIMARY KEY,
coordinatorFlag tinyint(1) NOT NULL,
coordinatorId varchar(20) NOT NULL,
participantFlag tinyint(1) NOT NULL,
participantId varchar(20) NOT NULL,
endOfParticipation boolean NOT NULL,
FOREIGN KEY (countryId) REFERENCES Country(countryId),
);

CREATE TABLE Country (
countryId varchar(2) NOT NULL PRIMARY KEY,
name varchar(20) NOT NULL,
city varchar(20) NOT NULL,
street varchar(50) NOT NULL,
postCode varchar(10) NOT NULL
);

CREATE TABLE Organisation_Country (
organisationId int(5) NOT NULL,
countryId varchar(2) NOT NULL,
FOREIGN KEY (organisationId) REFERENCES Organisation(organisationId),
FOREIGN KEY (countryId) REFERENCES Country(countryId)
);

CREATE TABLE Organisation (
organisationId int(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name varchar(50) NOT NULL,
shortName varchar(20) NOT NULL,
activityType varchar(3) NOT NULL,
organisationURL varchar(50) NOT NULL
);