database.sql

-- AdminNeo 5.2.1 MySQL 8.0.30 dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `promo_code`;
CREATE TABLE `promo_code` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE cp1251_bin NOT NULL,
  `activations` int NOT NULL DEFAULT '0',
  `remainingUses` int NOT NULL DEFAULT '-1',
  `expiryTime` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin;


DROP TABLE IF EXISTS `promo_code_activated`;
CREATE TABLE `promo_code_activated` (
  `id` int NOT NULL,
  `accountID` int NOT NULL,
  `name` varchar(32) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  `activationDate` timestamp NOT NULL,
  KEY `id` (`id`),
  CONSTRAINT `promo_code_activated_ibfk_1` FOREIGN KEY (`id`) REFERENCES `promo_code` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin;


DROP TABLE IF EXISTS `promo_code_categories`;
CREATE TABLE `promo_code_categories` (
  `id` int NOT NULL,
  `category` varchar(32) COLLATE cp1251_bin NOT NULL,
  `value` int NOT NULL,
  KEY `id` (`id`),
  CONSTRAINT `promo_code_categories_ibfk_1` FOREIGN KEY (`id`) REFERENCES `promo_code` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin;


-- 2026-05-08 11:02:34 UTC