CREATE TABLE gdpr2_bannerSettings (
  id int PRIMARY KEY AUTO_INCREMENT,
  websiteId varchar(255) NOT NULL,
  bannerTxt varchar(500),
  bannerTxtColor varchar(10),
  bannerbgColor varchar(10),
  bannerPosition varchar(10),
  bannerTop varchar(10),
  bannerBottom varchar(10),
  bannerRight varchar(10),
  bannerleft varchar(10),
  bannerSize varchar(10),
  bannerZindex varchar(10),
  bannermargin varchar(10),
  bannerBorder varchar(10),
  bannerBorderradius varchar(10),
  acceptbuttonbgColor varchar(10),
  acceptbuttonTxt varchar(255),
  acceptbuttonTxtColor varchar(10),
  refuseButtonBgColor varchar(10),
  refusebuttonTxt varchar(255),
  refusebuttonTxtColor varchar(10),
  termstxt varchar(255),
  termslink varchar(500)
);

/* fields */
/*
bannerTxt
bannerTxtColor
bannerbgColor
bannerPosition
bannerTop
bannerBottom
bannerRight
bannerleft
bannerSize
bannerZindex
bannermargin
bannerBorder
bannerBorderradius
acceptbuttonbgColor
acceptbuttonTxt
acceptbuttonTxtColor
refusebuttonTxt
refusebuttonTxtColor
termstxt
termslink
*/

CREATE TABLE gdpr2_cookieConsent (
  id int PRIMARY KEY AUTO_INCREMENT,
  websiteId varchar(255),
  ipAddress varchar(50) ,
  acceptsCookies boolean ,
  consentDate datetime
);