atoropics.sql

DROP TABLE IF EXISTS `mythicalpics_apikeys`;
CREATE TABLE `mythicalpics_apikeys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `api_key` text NOT NULL,
  `owner_api_key` text NOT NULL,
  `name` text NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


LOCK TABLES `mythicalpics_apikeys` WRITE;
UNLOCK TABLES;

DROP TABLE IF EXISTS `mythicalpics_imgs`;
CREATE TABLE `mythicalpics_imgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `owner_key` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `storage_folder` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


LOCK TABLES `mythicalpics_imgs` WRITE;
UNLOCK TABLES;

DROP TABLE IF EXISTS `mythicalpics_users`;
CREATE TABLE `mythicalpics_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `avatar` text DEFAULT NULL,
  `email` text NOT NULL,
  `password` text NOT NULL,
  `code` text NOT NULL,
  `last_ip` text DEFAULT 'localhost',
  `register_ip` text DEFAULT 'localhost',
  `api_key` text NOT NULL,
  `admin` enum('false','true') NOT NULL DEFAULT 'false',
  `embed_title` text DEFAULT NULL,
  `embed_small_title` text DEFAULT NULL,
  `embed_desc` text DEFAULT NULL,
  `embed_theme` text DEFAULT NULL,
  `embed_domain` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


LOCK TABLES `mythicalpics_users` WRITE;
UNLOCK TABLES;