CREATE DATABASE `appbackenddb` /*!40100 DEFAULT CHARACTER SET utf8 */;
CREATE TABLE `categories` (
  `categoryname` varchar(50) NOT NULL,
  `categorythumbnail` varchar(999) DEFAULT NULL,
  PRIMARY KEY (`categoryname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `shop` (
  `shopname` varchar(50) NOT NULL,
  `shopowner` varchar(45) DEFAULT NULL,
  `shopthumbnail` varchar(999) DEFAULT NULL,
  `shopdescription` varchar(500) DEFAULT NULL,
  `shopip` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`shopname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `users` (
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `email` varchar(45) DEFAULT NULL,
  `avatar` varchar(999) DEFAULT NULL,
  PRIMARY KEY (`username`),
  UNIQUE KEY `username_UNIQUE` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;