INSERT INTO `house` (`identifier`, `name`, `price`, `type`, `payment`, `furniture`, `data`, `locked`, `mortgage`, `complex`, `area`, `configuration`, `permission`, `doors`, `entry`, `storages`, `wardrobes`, `cctv`, `realestate`, `created_at`) VALUES ('82734', 'Fantastic Plaza', 1000, 'shell', 'Sale', NULL, '{"placement":{"x":291.35,"y":-1078.63,"z":9.39999999999999,"w":-5.0},"downpayment":0,"starter":true,"garage":[],"interior":"modernhotel_shell"}', 0, '[]', 'Apartment', '[]', '{"storage":4,"keys":5,"rename":false,"wardrobes":3,"rentable":false,"cctv":false,"garage":false,"disableBuy":false,"area":false}', '{"doorlock":false,"sell":true,"transfer":true,"moveGarage":true}', NULL, '{"x":291.35,"y":-1078.63,"z":29.4,"w":86.28}', '[]', NULL, NULL, NULL, '2024-06-30 12:24:18');

INSERT INTO `house` (`identifier`, `name`, `price`, `type`, `payment`, `furniture`, `data`, `locked`, `mortgage`, `complex`, `area`, `configuration`, `permission`, `doors`, `entry`, `storages`, `wardrobes`, `cctv`, `realestate`, `created_at`) VALUES ('31364', 'Integrity Way', 1000, 'shell', 'Sale', NULL, '{"placement":{"x":269.69,"y":-640.8,"z":24.02,"w":0.0},"downpayment":0,"starter":true,"garage":[],"interior":"modernhotel_shell"}', 0, '[]', 'Apartment', '[]', '{"storage":4,"keys":5,"rename":false,"wardrobes":3,"rentable":false,"cctv":false,"garage":false,"disableBuy":false,"area":false}', '{"doorlock":false,"sell":true,"transfer":true,"moveGarage":true}', NULL, '{"x":269.69,"y":-640.8,"z":42.02,"w":247.84}', '[]', NULL, NULL, NULL, '2024-06-30 12:22:46');

INSERT INTO `house` (`identifier`, `name`, `price`, `type`, `payment`, `furniture`, `data`, `locked`, `mortgage`, `complex`, `area`, `configuration`, `permission`, `doors`, `entry`, `storages`, `wardrobes`, `cctv`, `realestate`, `created_at`) VALUES ('50374', 'Morningwood Blvd', 1000, 'shell', 'Sale', NULL, '{"placement":{"x":-1288.52,"y":-430.45,"z":15.14999999999999,"w":-5.0},"downpayment":0,"starter":true,"garage":[],"interior":"modernhotel_shell"}', 0, '[]', 'Apartment', '[]', '{"storage":4,"keys":5,"rename":false,"wardrobes":3,"rentable":false,"cctv":false,"garage":false,"disableBuy":false,"area":false}', '{"doorlock":false,"sell":true,"transfer":true,"moveGarage":true}', NULL, '{"x":-1288.52,"y":-430.45,"z":35.15,"w":122.83}', '[]', NULL, NULL, NULL, '2024-06-30 12:21:41');

INSERT INTO `house` (`identifier`, `name`, `price`, `type`, `payment`, `furniture`, `data`, `locked`, `mortgage`, `complex`, `area`, `configuration`, `permission`, `doors`, `entry`, `storages`, `wardrobes`, `cctv`, `realestate`, `created_at`) VALUES ('39729', 'South Rockford Drive', 1000, 'shell', 'Sale', NULL, '{"placement":{"x":-667.03,"y":-1105.28,"z":-5.36999999999999,"w":-5.0},"downpayment":0,"starter":true,"garage":[],"interior":"modernhotel_shell"}', 0, '[]', 'Apartment', '[]', '{"keys":5,"cctv":false,"disableBuy":false,"garage":false,"rentable":false,"storage":4,"wardrobes":3,"area":false,"rename":false}', '{"doorlock":false,"transfer":true,"moveGarage":true,"sell":true}', NULL, '{"x":-667.03,"w":239.55,"z":14.63,"y":-1105.28}', '[]', NULL, NULL, NULL, '2024-06-30 12:19:48');

INSERT INTO `house` (`identifier`, `name`, `price`, `type`, `payment`, `furniture`, `data`, `locked`, `mortgage`, `complex`, `area`, `configuration`, `permission`, `doors`, `entry`, `storages`, `wardrobes`, `cctv`, `realestate`, `created_at`) VALUES ('19585', 'Tinsel Towers', 1000, 'shell', 'Sale', NULL, '{"placement":{"x":-619.22,"y":37.85,"z":23.6,"w":-5.0},"downpayment":0,"starter":true,"garage":[],"interior":"modernhotel_shell"}', 1, '[]', 'Apartment', '[]', '{"wardrobes":3,"garage":false,"storage":0,"rentable":false,"rename":false,"cctv":false,"keys":5,"area":false,"disableBuy":false}', '{"doorlock":false,"sell":true,"transfer":true,"moveGarage":true}', NULL, '{"x":-619.22,"y":37.85,"z":43.6,"w":6.26}', '[]', NULL, NULL, NULL, '2024-06-30 12:23:37');

CREATE TABLE IF NOT EXISTS `buildings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `label` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `metadata` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `buildings` (`id`, `name`, `label`, `metadata`) VALUES
	(1, 'Alta St 1', 'Alta St 1', '{"images":["https://r2.fivemanage.com/xAGbYdcTtNkthvTNfzai9/isoSQbOWGSFc.webp"],"enterData":{"x":-271.4185180664063,"z":31.68611717224121,"y":-957.678466796875},"inventoryData":{"weight":10000,"slots":50},"exitCoords":{"x":-271.0500793457031,"w":290.97967529296877,"z":31.22315788269043,"y":-957.8670654296876}}');

StarterApartment = {
        Enabled = true,                   -- Enable the starter apartment
        BuildingId = 1,                   -- The building id of the starter apartment
        Address = "Los Santos",           -- The address of the starter apartment
        Name = "Starter Apartment",       -- The name of the starter apartment
        RentedInstead = true,             -- If true, the apartment will be rented instead of owned
        InitialRentDays = 7,              -- How many days the starter apartment should be rented for free
        FutureRentPrice = 500,            -- How much it will cost to renew the rent after the free period
        Interior = {
            type = "shell",               -- The type of the interior, "shell" or "ipl"
            name = "Apartment Furnished", -- The name of the shell or ipl
        },
        Inventory = {
            slots = 10,     -- The amount of slots the inventory has
            weight = 10000, -- The weight of the inventory
        },
        InteractablePoints = {
            ["OpenInventory"] = true, -- The name of the interactable point
            ["ClothingMenu"] = true,  -- The name of the interactable point
        }
    },