CREATE TABLE `apps` (
  `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(30),
  `url` VARCHAR(50),
  `icon` VARCHAR(30),
  `urlbase` VARCHAR(15),
  `NSFW` VARCHAR(10),
  PRIMARY KEY (`id`)
);

CREATE TABLE `links` (
  `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(20),
  `name` VARCHAR(50),
  `url` VARCHAR(100),
  PRIMARY KEY (`id`)
);

CREATE TABLE `tabs` (
  `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(50),
  `NSFW` BOOLEAN,
  PRIMARY KEY (`id`)
);

CREATE TABLE `categories` (
  `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(50),
  PRIMARY KEY (`id`)
);

CREATE TABLE `messages` (
  `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `message` VARCHAR(255),
  `easteregg` BOOLEAN,
  PRIMARY KEY (`id`)
);

CREATE TABLE `personaldata` (
  `fname` VARCHAR(20),
  `lname` VARCHAR(30),
  `email` VARCHAR(50)
);

CREATE TABLE `providers` (
  `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(20),
  `url` VARCHAR(100),
  `prefix` VARCHAR(5),
  PRIMARY KEY (`id`)
);

CREATE TABLE `themes` (
  `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(20),
  `imagebackground` VARCHAR(100),
  `colorbackground` VARCHAR(9),
  `colorserachbackground` VARCHAR(9),
  `colortextpri` VARCHAR(9),
  `colortextacc` VARCHAR(9),
  `colorborder` VARCHAR(9),
  PRIMARY KEY (`id`)
);