Documentation
Installation guide — please follow each step carefully and exactly as described to ensure the script works correctly on your server. Skipping or modifying steps may cause the system to not function properly, so follow it step by step.
To download the assets needed for this script, you must access the official Cfx.re portal, where all assets purchased through Tebex are managed.
Open the Cfx.re granted assets page: https://portal.cfx.re/assets/granted-assets.
This page contains all assets linked to your Cfx.re purchases.
Sign in using the same Cfx.re account you used when purchasing the asset.
If you use a different account, the assets will not appear.
In the granted assets list, locate and download:
Restaurant Creator
These two packages are required to install the full housing system.
These files include the models, materials, and visual resources required for the proper operation of the housing system.
This script requires some mandatory dependencies to function correctly. Make sure to download and extract them inside your server’s main directory, keeping their original folder structure intact.
Below you’ll find the SQL to load two pre-made restaurant examples. You can also access the download links and credits for their creators if you want to test them, a burger restaurant and a pizzeria.
This script includes an essential database required for its operation.You must import it before starting your server, preferably using HeidiSQL or any other manager compatible with MariaDB/MySQL.
CREATE TABLE IF NOT EXISTS `qs_restaurants` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`label` VARCHAR(255) NOT NULL,
`owner_identifier` VARCHAR(50) DEFAULT NULL,
`owner_name` VARCHAR(255) DEFAULT NULL,
`color` VARCHAR(7) DEFAULT '#3B82F6',
`zone_points` LONGTEXT DEFAULT NULL,
`fridges` LONGTEXT DEFAULT NULL,
`kiosks` LONGTEXT DEFAULT '[]',
`displays` LONGTEXT DEFAULT '[]',
`pos_terminals` LONGTEXT DEFAULT '[]',
`blip_data` LONGTEXT DEFAULT NULL,
`cooking_systems` LONGTEXT DEFAULT NULL,
`bossmenu_location` LONGTEXT DEFAULT NULL,
`delivery_location` LONGTEXT DEFAULT NULL,
`is_open` TINYINT(1) DEFAULT 1,
`image` VARCHAR(255) DEFAULT NULL,
`creator` VARCHAR(50) DEFAULT NULL,
`fries_price` INT(11) DEFAULT 0,
`fries_category_id` INT(11) DEFAULT NULL,
`beverage_settings` LONGTEXT DEFAULT NULL,
`addon_beverages` LONGTEXT DEFAULT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
INDEX `owner_identifier` (`owner_identifier`),
INDEX `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE `qs_restaurants` ADD COLUMN IF NOT EXISTS `addon_beverages` LONGTEXT DEFAULT NULL AFTER `beverage_settings`;
CREATE TABLE IF NOT EXISTS `qs_restaurant_finance` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`balance` BIGINT DEFAULT 0,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `restaurant_id` (`restaurant_id`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_transactions` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`type` ENUM('deposit', 'withdraw', 'sale', 'expense') NOT NULL,
`amount` BIGINT NOT NULL,
`description` VARCHAR(255) DEFAULT NULL,
`identifier` VARCHAR(50) DEFAULT NULL,
`name` VARCHAR(255) DEFAULT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
INDEX `restaurant_id` (`restaurant_id`),
INDEX `type` (`type`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_workers` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`identifier` VARCHAR(50) NOT NULL,
`name` VARCHAR(255) NOT NULL,
`rank_id` INT(11) DEFAULT NULL,
`is_owner` TINYINT(1) DEFAULT 0,
`joined_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `restaurant_worker` (`restaurant_id`, `identifier`),
INDEX `restaurant_id` (`restaurant_id`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_ranks` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`label` VARCHAR(100) NOT NULL,
`grade` INT(11) DEFAULT 0,
`permissions` LONGTEXT DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `restaurant_id` (`restaurant_id`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_recipes` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`name` VARCHAR(100) NOT NULL,
`label` VARCHAR(255) NOT NULL,
`ingredients` LONGTEXT DEFAULT NULL,
`result_item` VARCHAR(100) DEFAULT NULL,
`result_count` INT(11) DEFAULT 1,
`prep_time` INT(11) DEFAULT 5000,
`cook_time` INT(11) DEFAULT 5000,
`pack_time` INT(11) DEFAULT 3000,
`price` INT(11) DEFAULT 0,
`category_id` INT(11) DEFAULT NULL,
`created_by` VARCHAR(50) DEFAULT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
INDEX `restaurant_id` (`restaurant_id`),
INDEX `category_id` (`category_id`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_recipe_steps` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`recipe_id` INT(11) NOT NULL,
`step_order` INT(11) NOT NULL DEFAULT 1,
`step_type` ENUM('prep', 'chop', 'marinate', 'cook', 'beverage', 'pack') NOT NULL,
`step_label` VARCHAR(100) DEFAULT NULL,
`input_item` VARCHAR(100) DEFAULT NULL,
`input_count` INT(11) DEFAULT 1,
`output_item` VARCHAR(100) NOT NULL,
`output_count` INT(11) DEFAULT 1,
`duration` INT(11) DEFAULT 5000,
`ingredients` LONGTEXT DEFAULT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
INDEX `recipe_id` (`recipe_id`),
INDEX `step_order` (`step_order`),
FOREIGN KEY (`recipe_id`) REFERENCES `qs_restaurant_recipes`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_kiosk_categories` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`name` VARCHAR(50) NOT NULL,
`description` VARCHAR(255) DEFAULT NULL,
`icon` VARCHAR(50) DEFAULT NULL,
`image` VARCHAR(255) DEFAULT NULL,
`color` VARCHAR(50) DEFAULT 'gray',
`sort_order` INT(11) DEFAULT 0,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
INDEX `restaurant_id` (`restaurant_id`),
INDEX `sort_order` (`sort_order`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_orders` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`order_number` INT(11) NOT NULL,
`customer_identifier` VARCHAR(100) NOT NULL,
`customer_name` VARCHAR(100) DEFAULT NULL,
`kiosk_index` INT(11) NOT NULL,
`items` LONGTEXT NOT NULL,
`total_price` INT(11) NOT NULL,
`payment_method` ENUM('cash', 'bank') DEFAULT 'cash',
`status` ENUM('pending', 'preparing', 'ready', 'completed', 'cancelled') DEFAULT 'pending',
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`completed_at` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `restaurant_id` (`restaurant_id`),
INDEX `status` (`status`),
INDEX `order_number` (`order_number`),
INDEX `customer_identifier` (`customer_identifier`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_burger_recipes` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`name` VARCHAR(100) NOT NULL,
`label` VARCHAR(255) NOT NULL,
`ingredients` LONGTEXT NOT NULL,
`price` INT(11) DEFAULT 0,
`image` VARCHAR(500) DEFAULT NULL,
`category_id` INT(11) DEFAULT NULL,
`created_by` VARCHAR(50) DEFAULT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
INDEX `restaurant_id` (`restaurant_id`),
INDEX `category_id` (`category_id`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_pizza_recipes` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`name` VARCHAR(100) NOT NULL,
`label` VARCHAR(255) NOT NULL,
`toppings` LONGTEXT NOT NULL,
`price` INT(11) DEFAULT 0,
`image` VARCHAR(500) DEFAULT NULL,
`category_id` INT(11) DEFAULT NULL,
`created_by` VARCHAR(50) DEFAULT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
INDEX `restaurant_id` (`restaurant_id`),
INDEX `category_id` (`category_id`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `qs_restaurant_allowed_items` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`item_name` VARCHAR(100) NOT NULL,
`item_label` VARCHAR(255) NOT NULL,
`shop_purchasable` TINYINT(1) DEFAULT 0,
`shop_price` INT(11) DEFAULT 0,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `item_name` (`item_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT IGNORE INTO `qs_restaurant_allowed_items` (`id`, `item_name`, `item_label`, `shop_purchasable`, `shop_price`, `created_at`) VALUES
(1, 'cooked_pizza', 'Cooked Pizza', 0, 0, '2026-02-14 05:59:13'),
(2, 'cola_drink', 'Cola', 0, 0, '2026-02-14 05:59:13'),
(3, 'raw_pizza_dough', 'Raw Pizza Dough', 1, 20, '2026-02-14 05:59:13'),
(4, 'pizza_green_pepper', 'Green Pepper', 1, 20, '2026-02-14 05:59:13'),
(5, 'pizza_mushroom', 'Mushroom', 1, 20, '2026-02-14 05:59:13'),
(6, 'burger', 'Burger', 0, 0, '2026-02-14 05:59:13'),
(7, 'burger_cheese', 'Cheese Slice', 0, 0, '2026-02-14 05:59:13'),
(8, 'pizza_green_olive', 'Green Olive', 1, 20, '2026-02-14 05:59:13'),
(9, 'tomato_slice', 'Tomato Slice', 1, 5, '2026-02-14 05:59:13'),
(10, 'burger_bun_bottom', 'Hamburger Bun (Bottom)', 1, 20, '2026-02-14 05:59:13'),
(11, 'burger_bun_top', 'Hamburger Bun (Top)', 1, 20, '2026-02-14 05:59:13'),
(12, 'pizza_pastrami', 'Pastrami', 1, 40, '2026-02-14 05:59:13'),
(13, 'burger_raw_patty', 'Raw Patty', 1, 45, '2026-02-14 05:59:13'),
(14, 'pizza_olive', 'Olive', 1, 5, '2026-02-14 05:59:13'),
(15, 'sprunk_drink', 'Sprunk', 0, 0, '2026-02-14 05:59:13'),
(16, 'onion_slice', 'Onion Ring', 1, 5, '2026-02-14 05:59:13'),
(17, 'cooked_fries', 'Cooked Fries', 0, 0, '2026-02-14 05:59:13'),
(18, 'lettuce', 'Lettuce', 1, 20, '2026-02-14 05:59:13'),
(19, 'raw_fries', 'Raw Fries', 1, 5, '2026-02-14 05:59:13'),
(20, 'orange_drink', 'Orange Juice', 0, 0, '2026-02-14 05:59:13'),
(21, 'pizza_sauce', 'Pizza Sauce', 1, 20, '2026-02-14 05:59:13'),
(22, 'pizza_pepperoni', 'Pepperoni', 1, 20, '2026-02-14 05:59:13'),
(23, 'mozzarella_cheese', 'Mozzarella Cheese', 1, 20, '2026-02-14 05:59:13');
CREATE TABLE IF NOT EXISTS `qs_restaurant_shop_orders` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`restaurant_id` INT(11) NOT NULL,
`order_number` INT(11) NOT NULL,
`player_identifier` VARCHAR(100) NOT NULL,
`player_name` VARCHAR(255) DEFAULT NULL,
`items` LONGTEXT NOT NULL,
`total_price` INT(11) NOT NULL,
`payment_method` ENUM('cash', 'bank') DEFAULT 'cash',
`status` ENUM('pending', 'delivering', 'delivered', 'claimed') DEFAULT 'pending',
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`delivered_at` TIMESTAMP NULL DEFAULT NULL,
`claimed_at` TIMESTAMP NULL DEFAULT NULL,
`claimed_by` VARCHAR(100) DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `restaurant_id` (`restaurant_id`),
INDEX `status` (`status`),
FOREIGN KEY (`restaurant_id`) REFERENCES `qs_restaurants`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;Optional example restaurants included. Maps must be downloaded separately.
INSERT IGNORE INTO `qs_restaurants` (`id`, `label`, `owner_identifier`, `owner_name`, `color`, `zone_points`, `fridges`, `kiosks`, `displays`, `pos_terminals`, `blip_data`, `cooking_systems`, `bossmenu_location`, `delivery_location`, `is_open`, `image`, `creator`, `fries_price`, `fries_category_id`, `beverage_settings`, `created_at`, `updated_at`) VALUES
(1, 'uniqx restaurant', NULL, NULL, '#3B82F6', '{"thickness":25,"points":[{"y":-892.3790893554688,"x":-1154.8743896484376,"z":14},{"y":-909.3997802734376,"x":-1184.2327880859376,"z":14},{"y":-907.256103515625,"x":-1185.5186767578126,"z":14},{"y":-916.0610961914064,"x":-1199.5362548828126,"z":14},{"y":-889.7916259765625,"x":-1217.6552734375,"z":14},{"y":-862.401611328125,"x":-1173.805908203125,"z":14}]}', '[{"y":-897.9075927734375,"x":-1202.3519287109376,"z":14.37363338470459},{"y":-895.8909912109375,"x":-1203.712158203125,"z":14.39053058624267}]', '[{"y":-893.4826049804688,"x":-1185.1602783203126,"z":14.54034423828125},{"y":-891.57861328125,"x":-1182.3375244140626,"z":14.48387336730957},{"y":-887.1520385742188,"x":-1189.372314453125,"z":14.45625782012939},{"y":-885.2930908203125,"x":-1186.6163330078126,"z":14.4670763015747}]', '[{"y":-896.2074584960938,"x":-1188.51806640625,"w":302,"z":15.47226619720459},{"y":-894.3306274414063,"x":-1190.2452392578126,"w":208.0000152587891,"z":14.55458831787109},{"y":-887.8765869140625,"x":-1190.763916015625,"w":34,"z":13.75026893615722}]', '[{"y":-894.630126953125,"x":-1191.550537109375,"z":13.92604160308837},{"y":-894.1238403320313,"x":-1193.366943359375,"z":13.94241714477539},{"y":-893.5094604492188,"x":-1195.3314208984376,"z":13.97869873046875},{"y":-893.0505981445313,"x":-1197.1905517578126,"z":13.97548103332519}]', '{"enable":true,"sprite":93,"coords":{"y":-890.5177612304688,"x":-1190.89111328125,"z":12.88615989685058},"label":"BurgerShot","scale":0.8,"color":17}', '{"fries":{"enabled":true,"position":{"y":-899.6699829101563,"x":-1197.0655517578126,"w":73.8262939453125,"z":13.79824066162109}},"basic":{"stations":{"pack":{"y":-883.03662109375,"x":-1190.1226806640626,"w":0,"z":12.88615989685058},"cook":{"y":-885.1964721679688,"x":-1193.3446044921876,"w":0,"z":12.88615989685058},"prep":{"y":-887.1163330078125,"x":-1196.0921630859376,"w":0,"z":12.88615989685058}},"enabled":false},"burger":{"enabled":true,"position":{"y":-895.0700073242188,"x":-1201.3843994140626,"w":162.59068298339845,"z":13.80108261108398}},"pizza":{"cooking_locations":[],"enabled":false},"beverage":{"enabled":true,"positions":[{"y":-899.365478515625,"x":-1191.728759765625,"w":0,"z":13.93435001373291}]}}', '{"y":-902.6232299804688,"x":-1196.1968994140626,"w":0,"z":14.2366943359375}', '{"y":-908.124755859375,"x":-1196.632568359375,"w":192.0000152587891,"z":12.8345193862915}', 1, NULL, 'char0:c9b3532ead3454b5487ee8140776baf5c6ed39e8', 15, 6, '{"orange_drink":{"price":5,"enabled":true,"categoryId":7},"cola_drink":{"price":3,"enabled":true,"categoryId":7},"sprunk_drink":{"price":4,"enabled":true,"categoryId":7}}', '2026-02-14 01:03:54', '2026-02-17 09:22:37'),
(2, 'pizzaria', NULL, NULL, '#3B82F6', '{"thickness":83.30076002632268,"points":[{"x":-532.202392578125,"y":-391.5250244140625,"z":35},{"x":-531.2835693359375,"y":-447.92822265625,"z":35},{"x":-617.2954711914063,"y":-445.0051574707031,"z":35},{"x":-613.5452880859375,"y":-383.8559875488281,"z":35}]}', '[{"x":-569.1300048828125,"y":-414.3594665527344,"z":35.43743515014648}]', '[{"x":-565.97998046875,"y":-406.25579833984377,"z":35.37738037109375},{"x":-574.6541748046875,"y":-406.21038818359377,"z":35.41924285888672}]', '[{"w":180.0000152587891,"x":-571.8092041015625,"y":-409.5985412597656,"z":36.63455581665039},{"w":181.0000152587891,"x":-567.8314819335938,"y":-409.5925903320313,"z":36.6493034362793},{"w":357,"x":-565.8500366210938,"y":-411.2974548339844,"z":34.75785064697265}]', '[{"x":-570.8384399414063,"y":-411.2230224609375,"z":35.25137329101562},{"x":-574.0712890625,"y":-411.0135803222656,"z":35.24309921264648}]', '{"label":"Pizzeria","sprite":93,"enable":true,"coords":{"x":-570.1549072265625,"y":-402.86322021484377,"z":33.91704177856445},"scale":0.8,"color":17}', '{"pizza":{"position":{"x":-583.2465209960938,"y":-414.22845458984377,"z":34.57798385620117,"w":93.20375061035156},"enabled":true,"cooking_locations":[{"x":-565.8871459960938,"y":-414.2982482910156,"z":34.59894180297851,"w":0.0},{"x":-566.2730102539063,"y":-414.2862243652344,"z":34.59280395507812,"w":0.0}]},"basic":{"enabled":false,"stations":[]},"beverage":{"enabled":true,"positions":[{"x":-574.9169921875,"y":-414.2843322753906,"z":34.73981094360351,"w":0.0}]},"burger":{"enabled":false},"fries":{"enabled":false}}', '{"w":0,"x":-579.8736572265625,"y":-408.3619689941406,"z":37.64155578613281}', '{"w":35,"x":-571.621337890625,"y":-391.5744323730469,"z":33.96834564208984}', 1, NULL, 'char0:c9b3532ead3454b5487ee8140776baf5c6ed39e8', 0, NULL, '{"orange_drink":{"price":8,"categoryId":9,"enabled":true},"cola_drink":{"price":5,"categoryId":9,"enabled":true},"sprunk_drink":{"price":7,"categoryId":9,"enabled":true}}', '2026-02-17 08:30:19', '2026-02-17 09:22:36');
INSERT IGNORE INTO `qs_restaurant_allowed_items` (`id`, `item_name`, `item_label`, `shop_purchasable`, `shop_price`, `created_at`) VALUES
(1, 'cooked_pizza', 'Cooked Pizza', 0, 0, '2026-02-14 02:59:13'),
(2, 'cola_drink', 'Cola', 0, 0, '2026-02-14 02:59:13'),
(3, 'raw_pizza_dough', 'Raw Pizza Dough', 1, 20, '2026-02-14 02:59:13'),
(4, 'pizza_green_pepper', 'Green Pepper', 1, 20, '2026-02-14 02:59:13'),
(5, 'pizza_mushroom', 'Mushroom', 1, 20, '2026-02-14 02:59:13'),
(6, 'burger', 'Burger', 0, 0, '2026-02-14 02:59:13'),
(7, 'burger_cheese', 'Cheese Slice', 1, 5, '2026-02-14 02:59:13'),
(8, 'pizza_green_olive', 'Green Olive', 1, 20, '2026-02-14 02:59:13'),
(9, 'tomato_slice', 'Tomato Slice', 1, 5, '2026-02-14 02:59:13'),
(10, 'burger_bun_bottom', 'Hamburger Bun (Bottom)', 1, 20, '2026-02-14 02:59:13'),
(11, 'burger_bun_top', 'Hamburger Bun (Top)', 1, 20, '2026-02-14 02:59:13'),
(12, 'pizza_pastrami', 'Pastrami', 1, 40, '2026-02-14 02:59:13'),
(13, 'burger_raw_patty', 'Raw Patty', 1, 45, '2026-02-14 02:59:13'),
(14, 'pizza_olive', 'Olive', 1, 5, '2026-02-14 02:59:13'),
(15, 'sprunk_drink', 'Sprunk', 0, 0, '2026-02-14 02:59:13'),
(16, 'onion_slice', 'Onion Ring', 1, 5, '2026-02-14 02:59:13'),
(17, 'cooked_fries', 'Cooked Fries', 0, 0, '2026-02-14 02:59:13'),
(18, 'lettuce', 'Lettuce', 1, 20, '2026-02-14 02:59:13'),
(19, 'raw_fries', 'Raw Fries', 1, 5, '2026-02-14 02:59:13'),
(20, 'orange_drink', 'Orange Juice', 0, 0, '2026-02-14 02:59:13'),
(21, 'pizza_sauce', 'Pizza Sauce', 1, 20, '2026-02-14 02:59:13'),
(22, 'pizza_pepperoni', 'Pepperoni', 1, 20, '2026-02-14 02:59:13'),
(23, 'mozzarella_cheese', 'Mozzarella Cheese', 1, 20, '2026-02-14 02:59:13');
INSERT IGNORE INTO `qs_restaurant_burger_recipes` (`id`, `restaurant_id`, `name`, `label`, `ingredients`, `price`, `image`, `category_id`, `created_by`, `created_at`) VALUES
(2, 1, 'big_mac', 'Big Mac', '[{"key":"bun_bottom","label":"Bun (Bottom)","quantity":1},{"key":"raw_patty","label":"Patty","quantity":2},{"key":"bun_top","label":"Bun (Top)","quantity":1},{"key":"cheese","label":"Cheese","quantity":2},{"key":"lettuce","label":"Lettuce","quantity":1},{"key":"tomato","label":"Tomato","quantity":4},{"key":"onion","label":"Onion","quantity":2}]', 231, NULL, 5, 'char0:c9b3532ead3454b5487ee8140776baf5c6ed39e8', '2026-02-15 01:20:19'),
(3, 1, 'big_mac_xl', 'Big Mac XL', '[{"key":"bun_bottom","label":"Bun (Bottom)","quantity":2},{"key":"raw_patty","label":"Patty","quantity":4},{"key":"bun_top","label":"Bun (Top)","quantity":1},{"key":"cheese","label":"Cheese","quantity":3},{"key":"lettuce","label":"Lettuce","quantity":1},{"key":"tomato","label":"Tomato","quantity":4},{"key":"onion","label":"Onion","quantity":2}]', 222, NULL, 5, 'char0:c9b3532ead3454b5487ee8140776baf5c6ed39e8', '2026-02-15 01:20:51');
INSERT IGNORE INTO `qs_restaurant_kiosk_categories` (`id`, `restaurant_id`, `name`, `description`, `icon`, `image`, `color`, `sort_order`, `created_at`) VALUES
(5, 1, 'Burgers', 'Delicious Burgers', 'burger', NULL, 'red', 0, '2026-02-15 01:18:32'),
(6, 1, 'Others', 'Our delicious things', 'french-fries', NULL, 'orange', 0, '2026-02-15 01:21:28'),
(7, 1, 'Drinks', 'Fresh Drinks', 'beer', NULL, 'yellow', 0, '2026-02-15 01:22:03'),
(8, 2, 'Pizza', 'Delicious Pizzas', 'pizza', NULL, 'gray', 0, '2026-02-17 09:03:31'),
(9, 2, 'Drinks', 'Our Epic Drinks', 'cup-soda', NULL, 'blue', 0, '2026-02-17 09:06:15');
INSERT IGNORE INTO `qs_restaurant_pizza_recipes` (`id`, `restaurant_id`, `name`, `label`, `toppings`, `price`, `image`, `category_id`, `created_by`, `created_at`) VALUES
(1, 2, 'pepperoni', 'Pepperoni', '[{"label":"Green Pepper","quantity":1,"key":"green_pepper"},{"label":"Pastrami","quantity":1,"key":"pastrami"},{"label":"Tomato","quantity":2,"key":"tomato"},{"label":"Olive","quantity":4,"key":"olive"},{"label":"Onion","quantity":2,"key":"onion"},{"label":"Lettuce","quantity":2,"key":"lettuce"},{"label":"Pepperoni","quantity":3,"key":"pepperoni"},{"label":"Green Olive","quantity":1,"key":"green_olive"}]', 222, NULL, 8, 'char0:c9b3532ead3454b5487ee8140776baf5c6ed39e8', '2026-02-17 09:02:50'),
(2, 2, 'margertia', 'Margertia', '[{"label":"Green Pepper","quantity":1,"key":"green_pepper"},{"label":"Pastrami","quantity":3,"key":"pastrami"},{"label":"Tomato","quantity":1,"key":"tomato"},{"label":"Olive","quantity":3,"key":"olive"},{"label":"Onion","quantity":3,"key":"onion"},{"label":"Lettuce","quantity":1,"key":"lettuce"},{"label":"Pepperoni","quantity":3,"key":"pepperoni"},{"label":"Green Olive","quantity":3,"key":"green_olive"},{"label":"Mushroom","quantity":3,"key":"mushroom"}]', 321, NULL, 8, 'char0:c9b3532ead3454b5487ee8140776baf5c6ed39e8', '2026-02-17 09:03:13');