/*
 Navicat Premium Dump SQL

 Source Server         : ProductionServer
 Source Server Type    : MariaDB
 Source Server Version : 100622 (10.6.22-MariaDB-log)
 Source Host           : localhost:3306
 Source Schema         : kiosk_buykiosk

 Target Server Type    : MariaDB
 Target Server Version : 100622 (10.6.22-MariaDB-log)
 File Encoding         : 65001

 Date: 24/07/2025 09:56:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for storetypes
-- ----------------------------
DROP TABLE IF EXISTS `storetypes`;
CREATE TABLE `storetypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(2) unsigned NOT NULL,
  `name` varchar(20) NOT NULL,
  `dir` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- ----------------------------
-- Records of storetypes
-- ----------------------------
BEGIN;
INSERT INTO `storetypes` (`id`, `type`, `name`, `dir`) VALUES (1, 0, 'Clothes Mentor', 'ClothesMentor');
INSERT INTO `storetypes` (`id`, `type`, `name`, `dir`) VALUES (2, 1, 'Platos Closet', 'PlatosCloset');
INSERT INTO `storetypes` (`id`, `type`, `name`, `dir`) VALUES (3, 2, 'Once Upon a Child', 'OnceUpon');
INSERT INTO `storetypes` (`id`, `type`, `name`, `dir`) VALUES (4, 3, 'Style Encore', 'StyleEncore');
INSERT INTO `storetypes` (`id`, `type`, `name`, `dir`) VALUES (5, 4, 'Play It Again Sports', 'PIAS');
INSERT INTO `storetypes` (`id`, `type`, `name`, `dir`) VALUES (6, 5, 'Home Once More', 'HomeOnceMore');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
