-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `laravel7_spp`
--

-- --------------------------------------------------------

--
-- Table structure for table `balance_history`
--

CREATE TABLE `balance_history` (
  `id` int(11) NOT NULL,
  `school_id` int(11) NOT NULL,
  `transaction_type` enum('IN','OUT') NOT NULL,
  `amount` bigint(20) NOT NULL,
  `description` varchar(255) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `balance_history`
--

INSERT INTO `balance_history` (`id`, `school_id`, `transaction_type`, `amount`, `description`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'IN', 5000000, 'pendapatan SPP', 43, '2026-08-12 09:22:13', '2026-08-12 16:22:13'),
(2, 1, 'IN', 2500000, 'pendaftaran siswa baru', 43, '2026-08-12 09:28:48', '2026-08-12 16:28:48'),
(3, 2, 'IN', 3400000, 'pendapatan spp', 43, '2026-08-12 09:29:17', '2026-08-12 16:29:17'),
(4, 3, 'IN', 8650000, 'pendapatan spp', 43, '2026-08-12 09:29:41', '2026-08-12 16:29:41'),
(5, 4, 'IN', 7860000, 'pendapatan spp', 43, '2026-08-12 09:29:56', '2026-08-12 16:29:56'),
(6, 3, 'IN', 1250000, 'pendapatan spp', 47, '2026-08-16 06:19:23', '2026-08-16 13:19:23'),
(7, 4, 'IN', 1450000, 'pendapatan spp', 47, '2026-08-16 06:19:35', '2026-08-16 13:19:35'),
(8, 2, 'IN', 3500000, 'pendapatan spp', 47, '2026-08-16 06:19:50', '2026-08-16 13:19:50'),
(9, 1, 'IN', 800000, 'pendapatan spp', 47, '2026-08-16 06:20:02', '2026-08-16 13:20:02'),
(10, 2, 'OUT', 4500000, 'Kursi Siswa - Penggantian kursi siswa yang rusak pada beberapa ruang kelas. Estimasi harga Rp300.000/unit × 15 unit.', 41, '2026-08-16 08:25:49', '2026-08-16 15:25:49'),
(11, 1, 'IN', 2000000, 'pendapatan spp', 47, '2026-08-17 00:47:21', '2026-08-17 07:47:21'),
(12, 2, 'IN', 2000000, 'pendapatan spp', 47, '2026-08-17 00:47:31', '2026-08-17 07:47:31'),
(13, 3, 'IN', 2000000, 'pendapatan spp', 47, '2026-08-17 00:47:41', '2026-08-17 07:47:41'),
(14, 4, 'IN', 2000000, 'pendapatan spp', 47, '2026-08-17 00:47:50', '2026-08-17 07:47:50'),
(15, 1, 'OUT', 8000000, 'AC Ruang Kelas - Pengadaan AC untuk 2 ruang kelas. Estimasi harga Rp4.000.000/unit × 2 unit.', 41, '2026-08-17 01:10:23', '2026-08-17 08:10:23'),
(16, 1, 'OUT', 1500000, 'Instalasi AC - Instalasi listrik dan pemasangan AC pada 2 ruang kelas. Estimasi biaya Rp1.500.000.', 41, '2026-08-17 01:11:12', '2026-08-17 08:11:12');

-- --------------------------------------------------------

--
-- Table structure for table `icon`
--

CREATE TABLE `icon` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `icon` (`id`, `name`) VALUES
(3853, 'satellite'),
(3854, 'sausage'),
(3855, 'scale-off'),
(3856, 'scale-outline-off'),
(3857, 'scale-outline'),
(3858, 'scale'),
(3859, 'scan-eye'),
(3860, 'scan'),
(3861, 'schema-off'),
(3862, 'schema'),
(3864, 'school-off'),
(3865, 'school'),
(3866, 'scissors-off'),
(3867, 'scissors'),
(3868, 'scooter-electric'),
(3869, 'scooter'),
(3871, 'screen-share-off'),
(3872, 'screen-share'),
(3873, 'screenshot'),
(3874, 'scribble-off'),
(3875, 'scribble'),
(3876, 'script-minus'),
(3877, 'script-plus'),
(3878, 'script-x'),
(3879, 'script'),
(3880, 'scuba-mask-off'),
(3881, 'scuba-mask'),
(3882, 'sdk'),
(3883, 'search-off'),
(3884, 'search'),
(3885, 'section-sign'),
(3886, 'section'),
(3887, 'seeding-off'),
(3888, 'seeding'),
(3890, 'select'),
(3891, 'selector'),
(3892, 'send-off'),
(3893, 'send'),
(3894, 'seo'),
(3895, 'separator-horizontal'),
(3896, 'separator-vertical'),
(3897, 'separator'),
(3898, 'server-2'),
(3899, 'server-bolt'),
(3900, 'server-cog'),
(3901, 'server-off'),
(3902, 'server'),
(3903, 'servicemark'),
(3904, 'settings-2'),
(3905, 'settings-automation'),
(3917, 'settings-off'),
(3927, 'settings'),
(3928, 'shadow-off'),
(3929, 'shadow'),
(3930, 'shape-2'),
(3931, 'shape-3'),
(3932, 'shape-off'),
(3933, 'shape'),
(3936, 'share-off'),
(3937, 'share'),
(3942, 'shield-check'),
(3944, 'shield-checkered'),
(3945, 'shield-chevron'),
(3952, 'shield-half-filled'),
(3953, 'shield-half'),
(3956, 'shield-lock'),
(3958, 'shield-off'),
(3967, 'shield-x'),
(3968, 'shield'),
(3969, 'ship-off'),
(3970, 'ship'),
(3972, 'shirt-off'),
(3973, 'shirt-sport'),
(3974, 'shirt'),
(3975, 'shoe-off'),
(3976, 'shoe'),
(3992, 'shopping-cart-discount'),
(3999, 'shopping-cart-off'),
(4002, 'shopping-cart-plus'),
(4008, 'shopping-cart-x'),
(4009, 'shopping-cart'),
(4010, 'shovel'),
(4011, 'shredder'),
(4013, 'sign-left'),
(4015, 'sign-right'),
(4017, 'signal-3g'),
(4018, 'signal-4g-plus'),
(4019, 'signal-4g'),
(4020, 'signal-5g'),
(4027, 'signature-off'),
(4028, 'signature'),
(4029, 'sitemap-off'),
(4030, 'sitemap'),
(4031, 'skateboard-off'),
(4032, 'skateboard'),
(4034, 'skull'),
(4035, 'slash'),
(4036, 'slashes'),
(4037, 'sleigh'),
(4038, 'slice'),
(4039, 'slideshow'),
(4040, 'smart-home-off'),
(4041, 'smart-home'),
(4042, 'smoking-no'),
(4043, 'smoking'),
(4044, 'snowflake-off'),
(4045, 'snowflake'),
(4046, 'snowman'),
(4047, 'soccer-field'),
(4048, 'social-off'),
(4049, 'social'),
(4050, 'sock'),
(4051, 'sofa-off'),
(4052, 'sofa'),
(4056, 'sort-0-9'),
(4057, 'sort-9-0'),
(4058, 'sort-a-z'),
(4059, 'sort-ascending-2'),
(4060, 'sort-ascending-letters'),
(4061, 'sort-ascending-numbers'),
(4062, 'sort-ascending'),
(4063, 'sort-descending-2'),
(4064, 'sort-descending-letters'),
(4065, 'sort-descending-numbers'),
(4066, 'sort-descending'),
(4067, 'sort-z-a'),
(4068, 'sos'),
(4069, 'soup-off'),
(4070, 'soup'),
(4071, 'source-code'),
(4072, 'space-off'),
(4073, 'space'),
(4074, 'spacing-horizontal'),
(4075, 'spacing-vertical'),
(4077, 'spade'),
(4079, 'speakerphone'),
(4080, 'speedboat'),
(4084, 'spider'),
(4085, 'spiral-off'),
(4086, 'spiral'),
(4087, 'sport-billard'),
(4088, 'spray'),
(4089, 'spy-off'),
(4090, 'spy'),
(4103, 'square-arrow-down'),
(4105, 'square-arrow-left'),
(4107, 'square-arrow-right'),
(4109, 'square-arrow-up'),
(4111, 'square-asterisk'),
(4113, 'square-check'),
(4131, 'square-dot'),
(4133, 'square-f0'),
(4135, 'square-f1'),
(4137, 'square-f2'),
(4139, 'square-f3'),
(4141, 'square-f4'),
(4143, 'square-f5'),
(4145, 'square-f6'),
(4147, 'square-f7'),
(4149, 'square-f8'),
(4151, 'square-f9'),
(4153, 'square-forbid-2'),
(4154, 'square-forbid'),
(4155, 'square-half'),
(4157, 'square-letter-a'),
(4158, 'square-letter-b'),
(4159, 'square-letter-c'),
(4160, 'square-letter-d'),
(4161, 'square-letter-e'),
(4162, 'square-letter-f'),
(4163, 'square-letter-g'),
(4164, 'square-letter-h'),
(4165, 'square-letter-i'),
(4166, 'square-letter-j'),
(4167, 'square-letter-k'),
(4168, 'square-letter-l'),
(4169, 'square-letter-m'),
(4170, 'square-letter-n'),
(4171, 'square-letter-o'),
(4172, 'square-letter-p'),
(4173, 'square-letter-q'),
(4174, 'square-letter-r'),
(4175, 'square-letter-s'),
(4176, 'square-letter-t'),
(4177, 'square-letter-u'),
(4178, 'square-letter-v'),
(4179, 'square-letter-w'),
(4180, 'square-letter-x'),
(4181, 'square-letter-y'),
(4182, 'square-letter-z'),
(4184, 'square-minus'),
(4185, 'square-number-0'),
(4186, 'square-number-1'),
(4187, 'square-number-2'),
(4188, 'square-number-3'),
(4189, 'square-number-4'),
(4190, 'square-number-5'),
(4191, 'square-number-6'),
(4192, 'square-number-7'),
(4193, 'square-number-8'),
(4194, 'square-number-9'),
(4195, 'square-off'),
(4197, 'square-plus'),
(4198, 'square-root-2'),
(4199, 'square-root'),
(4201, 'square-rotated-forbid-2'),
(4202, 'square-rotated-forbid'),
(4203, 'square-rotated-off'),
(4204, 'square-rotated'),
(4232, 'square-rounded-letter-a'),
(4233, 'square-rounded-letter-b'),
(4234, 'square-rounded-letter-c'),
(4235, 'square-rounded-letter-d'),
(4236, 'square-rounded-letter-e'),
(4237, 'square-rounded-letter-f'),
(4238, 'square-rounded-letter-g'),
(4239, 'square-rounded-letter-h'),
(4240, 'square-rounded-letter-i'),
(4241, 'square-rounded-letter-j'),
(4242, 'square-rounded-letter-k'),
(4243, 'square-rounded-letter-l'),
(4244, 'square-rounded-letter-m'),
(4245, 'square-rounded-letter-n'),
(4246, 'square-rounded-letter-o'),
(4247, 'square-rounded-letter-p'),
(4248, 'square-rounded-letter-q'),
(4249, 'square-rounded-letter-r'),
(4250, 'square-rounded-letter-s'),
(4251, 'square-rounded-letter-t'),
(4252, 'square-rounded-letter-u'),
(4253, 'square-rounded-letter-v'),
(4254, 'square-rounded-letter-w'),
(4255, 'square-rounded-letter-x'),
(4256, 'square-rounded-letter-y'),
(4257, 'square-rounded-letter-z'),
(4262, 'square-rounded-number-0'),
(4264, 'square-rounded-number-1'),
(4266, 'square-rounded-number-2'),
(4268, 'square-rounded-number-3'),
(4270, 'square-rounded-number-4'),
(4272, 'square-rounded-number-5'),
(4274, 'square-rounded-number-6'),
(4276, 'square-rounded-number-7'),
(4278, 'square-rounded-number-8'),
(4280, 'square-rounded-number-9'),
(4286, 'square-rounded'),
(4287, 'square-toggle-horizontal'),
(4288, 'square-toggle'),
(4290, 'square-x'),
(4291, 'square'),
(4292, 'squares-diagonal'),
(4293, 'squares-filled'),
(4294, 'stack-2'),
(4295, 'stack-3'),
(4296, 'stack-pop'),
(4297, 'stack-push'),
(4298, 'stack'),
(4299, 'stairs-down'),
(4300, 'stairs-up'),
(4301, 'stairs'),
(4304, 'star-half'),
(4305, 'star-off'),
(4306, 'star'),
(4308, 'stars-off'),
(4309, 'stars'),
(4310, 'status-change'),
(4311, 'steam'),
(4312, 'steering-wheel-off'),
(4313, 'steering-wheel'),
(4314, 'step-into'),
(4315, 'step-out'),
(4316, 'stereo-glasses'),
(4317, 'stethoscope-off'),
(4318, 'stethoscope'),
(4319, 'sticker'),
(4320, 'storm-off'),
(4321, 'storm'),
(4323, 'stretching'),
(4324, 'strikethrough'),
(4325, 'submarine'),
(4326, 'subscript'),
(4327, 'subtask'),
(4328, 'sum-off'),
(4329, 'sum'),
(4332, 'sun-high'),
(4333, 'sun-low'),
(4334, 'sun-moon'),
(4335, 'sun-off'),
(4336, 'sun-wind'),
(4337, 'sun'),
(4338, 'sunglasses'),
(4339, 'sunrise'),
(4340, 'sunset-2'),
(4341, 'sunset'),
(4342, 'superscript'),
(4343, 'svg'),
(4344, 'swimming'),
(4345, 'swipe'),
(4346, 'switch-2'),
(4347, 'switch-3'),
(4348, 'switch-horizontal'),
(4349, 'switch-vertical'),
(4350, 'switch'),
(4351, 'sword-off'),
(4352, 'sword'),
(4353, 'swords'),
(4354, 'table-alias'),
(4357, 'table-export'),
(4360, 'table-import'),
(4362, 'table-off'),
(4363, 'table-options'),
(4367, 'table-shortcut'),
(4368, 'table'),
(4369, 'tag-off'),
(4371, 'tag'),
(4372, 'tags-off'),
(4373, 'tags'),
(4374, 'tallymark-1'),
(4375, 'tallymark-2'),
(4376, 'tallymark-3'),
(4377, 'tallymark-4'),
(4378, 'tallymarks'),
(4379, 'tank'),
(4380, 'target-arrow'),
(4381, 'target-off'),
(4382, 'target'),
(4383, 'teapot'),
(4384, 'telescope-off'),
(4385, 'telescope'),
(4386, 'temperature-celsius'),
(4387, 'temperature-fahrenheit'),
(4388, 'temperature-minus'),
(4389, 'temperature-off'),
(4390, 'temperature-plus'),
(4391, 'temperature'),
(4392, 'template-off'),
(4393, 'template'),
(4394, 'tent-off'),
(4395, 'tent'),
(4396, 'terminal-2'),
(4397, 'terminal'),
(4398, 'test-pipe-2'),
(4399, 'test-pipe-off'),
(4400, 'test-pipe'),
(4401, 'tex'),
(4402, 'text-caption'),
(4403, 'text-color'),
(4404, 'text-decrease'),
(4405, 'text-direction-ltr'),
(4406, 'text-direction-rtl'),
(4407, 'text-increase'),
(4408, 'text-orientation'),
(4409, 'text-plus'),
(4410, 'text-recognition'),
(4411, 'text-resize'),
(4413, 'text-size'),
(4414, 'text-spellcheck'),
(4415, 'text-wrap-disabled'),
(4416, 'text-wrap'),
(4417, 'texture'),
(4419, 'thermometer'),
(4421, 'thumb-down-off'),
(4422, 'thumb-down'),
(4424, 'thumb-up-off'),
(4425, 'thumb-up'),
(4426, 'tic-tac'),
(4427, 'ticket-off'),
(4428, 'ticket'),
(4429, 'tie'),
(4430, 'tilde'),
(4431, 'tilt-shift-off'),
(4432, 'tilt-shift'),
(4448, 'timeline-event'),
(4449, 'timeline'),
(4450, 'tir'),
(4451, 'toggle-left'),
(4452, 'toggle-right'),
(4453, 'toilet-paper-off'),
(4454, 'toilet-paper'),
(4456, 'tool'),
(4457, 'tools-kitchen-2-off'),
(4458, 'tools-kitchen-2'),
(4459, 'tools-kitchen-off'),
(4460, 'tools-kitchen'),
(4461, 'tools-off'),
(4462, 'tools'),
(4463, 'tooltip'),
(4464, 'topology-bus'),
(4465, 'topology-complex'),
(4466, 'topology-full-hierarchy'),
(4467, 'topology-full'),
(4468, 'topology-ring-2'),
(4469, 'topology-ring-3'),
(4470, 'topology-ring'),
(4471, 'topology-star-2'),
(4472, 'topology-star-3'),
(4473, 'topology-star-ring-2'),
(4474, 'topology-star-ring-3'),
(4475, 'topology-star-ring'),
(4476, 'topology-star'),
(4477, 'torii'),
(4478, 'tornado'),
(4479, 'tournament'),
(4480, 'tower-off'),
(4481, 'tower'),
(4482, 'track'),
(4483, 'tractor'),
(4484, 'trademark'),
(4485, 'traffic-cone-off'),
(4486, 'traffic-cone'),
(4487, 'traffic-lights-off'),
(4488, 'traffic-lights'),
(4489, 'train'),
(4490, 'transfer-in'),
(4491, 'transfer-out'),
(4495, 'transform'),
(4496, 'transition-bottom'),
(4497, 'transition-left'),
(4498, 'transition-right'),
(4499, 'transition-top'),
(4501, 'trash-off'),
(4503, 'trash-x'),
(4504, 'trash'),
(4506, 'tree'),
(4507, 'trees'),
(4508, 'trekking'),
(4509, 'trending-down-2'),
(4510, 'trending-down-3'),
(4511, 'trending-down'),
(4512, 'trending-up-2'),
(4513, 'trending-up-3'),
(4514, 'trending-up'),
(4517, 'triangle-inverted'),
(4520, 'triangle-off'),
(4524, 'triangle-square-circle'),
(4525, 'triangle'),
(4526, 'triangles'),
(4527, 'trident'),
(4528, 'trolley'),
(4530, 'trophy-off'),
(4531, 'trophy'),
(4532, 'trowel'),
(4533, 'truck-delivery'),
(4534, 'truck-loading'),
(4535, 'truck-off'),
(4536, 'truck-return'),
(4537, 'truck'),
(4538, 'txt'),
(4539, 'typography-off'),
(4540, 'typography'),
(4542, 'ufo'),
(4544, 'umbrella-off'),
(4545, 'umbrella'),
(4546, 'underline'),
(4548, 'unlink'),
(4549, 'upload'),
(4550, 'urgent'),
(4551, 'usb'),
(4554, 'user-check'),
(4555, 'user-circle'),
(4561, 'user-exclamation'),
(4565, 'user-minus'),
(4566, 'user-off'),
(4570, 'user-plus'),
(4573, 'user-search'),
(4580, 'user-x'),
(4581, 'user'),
(4585, 'users'),
(4586, 'uv-index'),
(4587, 'ux-circle'),
(4588, 'vaccine-bottle-off'),
(4589, 'vaccine-bottle'),
(4590, 'vaccine-off'),
(4591, 'vaccine'),
(4592, 'vacuum-cleaner'),
(4593, 'variable-minus'),
(4594, 'variable-off'),
(4595, 'variable-plus'),
(4596, 'variable'),
(4597, 'vector-bezier-2'),
(4598, 'vector-bezier-arc'),
(4599, 'vector-bezier-circle'),
(4600, 'vector-bezier'),
(4601, 'vector-off'),
(4602, 'vector-spline'),
(4603, 'vector-triangle-off'),
(4604, 'vector-triangle'),
(4605, 'vector'),
(4606, 'venus'),
(4608, 'versions-off'),
(4609, 'versions'),
(4610, 'video-minus'),
(4611, 'video-off'),
(4612, 'video-plus'),
(4613, 'video'),
(4614, 'view-360-off'),
(4615, 'view-360'),
(4616, 'viewfinder-off'),
(4617, 'viewfinder'),
(4618, 'viewport-narrow'),
(4619, 'viewport-wide'),
(4620, 'vinyl'),
(4621, 'vip-off'),
(4622, 'vip'),
(4623, 'virus-off'),
(4624, 'virus-search'),
(4625, 'virus'),
(4626, 'vocabulary-off'),
(4627, 'vocabulary'),
(4629, 'volume-2'),
(4630, 'volume-3'),
(4631, 'volume-off'),
(4632, 'volume'),
(4634, 'walk'),
(4635, 'wall-off'),
(4636, 'wall'),
(4637, 'wallet-off'),
(4638, 'wallet'),
(4639, 'wallpaper-off'),
(4640, 'wallpaper'),
(4641, 'wand-off'),
(4642, 'wand'),
(4643, 'wash-dry-1'),
(4644, 'wash-dry-2'),
(4645, 'wash-dry-3'),
(4646, 'wash-dry-a'),
(4647, 'wash-dry-dip'),
(4648, 'wash-dry-f'),
(4650, 'wash-dry-hang'),
(4651, 'wash-dry-off'),
(4652, 'wash-dry-p'),
(4653, 'wash-dry-shade'),
(4654, 'wash-dry-w'),
(4655, 'wash-dry'),
(4656, 'wash-dryclean-off'),
(4657, 'wash-dryclean'),
(4659, 'wash-gentle'),
(4661, 'wash-machine'),
(4662, 'wash-off'),
(4663, 'wash-press'),
(4664, 'wash-temperature-1'),
(4665, 'wash-temperature-2'),
(4666, 'wash-temperature-3'),
(4667, 'wash-temperature-4'),
(4668, 'wash-temperature-5'),
(4669, 'wash-temperature-6'),
(4670, 'wash-tumble-dry'),
(4671, 'wash-tumble-off'),
(4672, 'wash'),
(4674, 'wave-saw-tool'),
(4675, 'wave-sine'),
(4676, 'wave-square'),
(4678, 'webhook-off'),
(4679, 'webhook'),
(4680, 'weight'),
(4682, 'wheelchair-off'),
(4683, 'wheelchair'),
(4684, 'whirl'),
(4686, 'wifi-1'),
(4687, 'wifi-2'),
(4688, 'wifi-off'),
(4689, 'wifi'),
(4691, 'wind-off'),
(4692, 'wind'),
(4694, 'windmill-off'),
(4695, 'windmill'),
(4696, 'window-maximize'),
(4697, 'window-minimize'),
(4698, 'window-off'),
(4699, 'window'),
(4700, 'windsock'),
(4701, 'wiper-wash'),
(4702, 'wiper'),
(4703, 'woman'),
(4704, 'wood'),
(4712, 'world-download'),
(4715, 'world-latitude'),
(4716, 'world-longitude'),
(4718, 'world-off'),
(4727, 'world-upload'),
(4728, 'world-www'),
(4730, 'world'),
(4731, 'wrecking-ball'),
(4732, 'writing-off'),
(4733, 'writing-sign-off'),
(4734, 'writing-sign'),
(4735, 'writing'),
(4736, 'x'),
(4737, 'xbox-a'),
(4738, 'xbox-b'),
(4739, 'xbox-x'),
(4740, 'xbox-y'),
(4744, 'yin-yang'),
(4745, 'yoga'),
(4746, 'zeppelin-off'),
(4747, 'zeppelin'),
(4748, 'zip'),
(4749, 'zodiac-aquarius'),
(4750, 'zodiac-aries'),
(4751, 'zodiac-cancer'),
(4752, 'zodiac-capricorn'),
(4753, 'zodiac-gemini'),
(4754, 'zodiac-leo'),
(4755, 'zodiac-libra'),
(4756, 'zodiac-pisces'),
(4757, 'zodiac-sagittarius'),
(4758, 'zodiac-scorpio'),
(4759, 'zodiac-taurus'),
(4760, 'zodiac-virgo'),
(4761, 'zoom-cancel'),
(4763, 'zoom-check'),
(4764, 'zoom-code'),
(4765, 'zoom-exclamation'),
(4768, 'zoom-in-area'),
(4770, 'zoom-in'),
(4771, 'zoom-money'),
(4772, 'zoom-out-area'),
(4774, 'zoom-out'),
(4775, 'zoom-pan'),
(4776, 'zoom-question'),
(4777, 'zoom-replace'),
(4778, 'zoom-reset'),
(4780, 'zzz-off'),
(4781, 'zzz');

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\User', 4),
(1, 'App\\User', 45),
(2, 'App\\User', 41),
(3, 'App\\User', 43),
(3, 'App\\User', 47),
(3, 'App\\User', 49),
(4, 'App\\User', 42),
(4, 'App\\User', 44),
(4, 'App\\User', 46),
(4, 'App\\User', 48);

-- --------------------------------------------------------

--
-- Table structure for table `purchase_request`
--

CREATE TABLE `purchase_request` (
  `id` int(11) NOT NULL,
  `school_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `amount` bigint(20) NOT NULL,
  `description` varchar(255) NOT NULL,
  `status` enum('PENDING','APPROVED','REJECTED') NOT NULL,
  `priority` enum('HIGH','MEDIUM','LOW') NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` datetime NOT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `approved_at` datetime DEFAULT NULL,
  `approved_note` varchar(255) DEFAULT NULL,
  `buy_status` enum('PROCESS','PURCHASED') DEFAULT NULL,
  `buy_by` int(11) DEFAULT NULL,
  `buy_at` datetime DEFAULT NULL,
  `buy_file` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `purchase_request`
--

INSERT INTO `purchase_request` (`id`, `school_id`, `name`, `amount`, `description`, `status`, `priority`, `created_by`, `created_at`, `updated_at`, `approved_by`, `approved_at`, `approved_note`, `buy_status`, `buy_by`, `buy_at`, `buy_file`) VALUES
(2, 4, 'Kursi Siswa', 6000000, 'Penggantian kursi siswa yang rusak pada beberapa ruang kelas. Estimasi harga Rp300.000/unit × 20 unit.', 'PENDING', 'HIGH', 48, '2026-08-11 08:43:51', '2026-08-11 15:43:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 4, 'Meja Siswa', 7500000, 'Penggantian meja belajar yang sudah tidak layak pakai. Estimasi harga Rp500.000/unit × 15 unit.', 'PENDING', 'HIGH', 48, '2026-08-11 16:34:06', '2026-08-11 16:34:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 4, 'Whiteboard Kelas', 3200000, 'Penggantian papan tulis kelas yang sudah mulai pudar dan sulit dibersihkan. Estimasi harga Rp800.000/unit × 4 unit.', 'PENDING', 'MEDIUM', 48, '2026-08-11 08:45:18', '2026-08-11 15:45:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 4, 'Proyektor', 8000000, 'Penambahan media pembelajaran digital untuk ruang kelas. Estimasi harga Rp4.000.000/unit × 2 unit.', 'PENDING', 'MEDIUM', 48, '2026-08-11 08:45:53', '2026-08-11 15:45:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 4, 'Laptop Guru', 12000000, 'Pengadaan laptop untuk administrasi dan penyusunan materi pembelajaran. Estimasi harga Rp6.000.000/unit × 2 unit.', 'PENDING', 'HIGH', 48, '2026-08-11 08:47:13', '2026-08-11 15:47:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 4, 'Printer Multifungsi', 5000000, 'Pengadaan printer untuk kebutuhan administrasi sekolah dan pencetakan soal ujian. Estimasi harga Rp2.500.000/unit × 2 unit.', 'PENDING', 'MEDIUM', 48, '2026-08-11 08:47:51', '2026-08-11 15:47:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 4, 'Rak Sepatu Siswa', 4000000, 'Penataan area depan kelas agar lebih rapi dan tertib. Estimasi harga Rp400.000/unit × 10 unit.', 'PENDING', 'LOW', 48, '2026-08-11 08:48:26', '2026-08-11 15:48:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, 4, 'Karpet Mushola', 3000000, 'Penggantian karpet mushola yang sudah usang dan tidak nyaman digunakan. Estimasi harga Rp1.500.000/roll × 2 roll.', 'PENDING', 'HIGH', 48, '2026-08-11 08:48:57', '2026-08-11 15:48:57', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, 4, 'Sound System Mushola', 4500000, 'Pengadaan sound system untuk kegiatan ibadah, kultum, dan acara sekolah. Estimasi harga Rp4.500.000/paket × 1 paket.', 'PENDING', 'MEDIUM', 48, '2026-08-11 08:49:31', '2026-08-11 15:49:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, 4, 'Buku Perpustakaan Islami', 2500000, 'Penambahan koleksi buku bacaan islami dan edukatif untuk siswa. Estimasi harga Rp50.000/buku × 50 buku.', 'PENDING', 'LOW', 48, '2026-08-11 08:50:06', '2026-08-11 15:50:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, 4, 'Lemari Arsip Guru', 4500000, 'Penyimpanan dokumen administrasi sekolah dan arsip guru. Estimasi harga Rp1.500.000/unit × 3 unit.', 'PENDING', 'LOW', 48, '2026-08-11 08:50:45', '2026-08-11 15:50:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, 4, 'CCTV', 6000000, 'Penambahan perangkat CCTV pada area strategis sekolah untuk meningkatkan keamanan. Estimasi harga Rp1.500.000/unit × 4 unit.', 'PENDING', 'MEDIUM', 48, '2026-08-11 08:51:15', '2026-08-11 15:51:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, 4, 'Tempat Sampah Pilah', 1600000, 'Mendukung program kebersihan dan edukasi pemilahan sampah. Estimasi harga Rp200.000/unit × 8 unit.', 'PENDING', 'LOW', 48, '2026-08-11 08:51:50', '2026-08-11 15:51:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, 4, 'Peralatan UKS', 3500000, 'Pengadaan perlengkapan kesehatan dasar seperti kotak P3K, termometer, dan alat kesehatan ringan. Estimasi harga Rp3.500.000/paket × 1 paket.', 'PENDING', 'HIGH', 48, '2026-08-11 08:53:51', '2026-08-11 15:53:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 4, 'Kipas Angin Dinding', 3000000, 'Penambahan sirkulasi udara pada ruang kelas yang belum memiliki pendingin ruangan. Estimasi harga Rp500.000/unit × 6 unit.', 'PENDING', 'MEDIUM', 48, '2026-08-11 08:54:34', '2026-08-11 15:54:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, 3, 'Kursi Siswa', 7500000, 'Penggantian kursi siswa yang rusak pada beberapa ruang kelas. Estimasi harga Rp300.000/unit × 25 unit.', 'PENDING', 'HIGH', 46, '2026-08-12 06:42:27', '2026-08-12 13:42:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(19, 3, 'Meja Siswa', 10000000, 'Penggantian meja siswa yang sudah tidak layak digunakan. Estimasi harga Rp500.000/unit × 20 unit.', 'PENDING', 'HIGH', 46, '2026-08-12 06:42:59', '2026-08-12 13:42:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, 3, 'Whiteboard Kelas', 4000000, 'Penggantian papan tulis yang sudah kusam dan sulit dibersihkan. Estimasi harga Rp800.000/unit × 5 unit.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:45:48', '2026-08-12 13:45:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, 3, 'Laptop Guru', 18000000, 'Pengadaan laptop untuk guru kelas dan administrasi pembelajaran. Estimasi harga Rp6.000.000/unit × 3 unit.', 'REJECTED', 'HIGH', 46, '2026-08-17 16:26:22', '2026-08-17 16:26:22', 41, '2026-08-17 16:26:22', 'komputer yang disediakan di kantor masih layak pakai, kebutuhan laptop tidak mendesak, sebaikanya pengeluarannya dialihkan ke hal yg lebih urgent', NULL, NULL, NULL, NULL),
(22, 3, 'Printer Multifungsi', 5000000, 'Pengadaan printer untuk kebutuhan administrasi dan pencetakan soal ujian. Estimasi harga Rp2.500.000/unit × 2 unit.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:49:07', '2026-08-12 13:49:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(23, 3, 'Proyektor Kelas', 12000000, 'Penambahan media pembelajaran berbasis multimedia. Estimasi harga Rp4.000.000/unit × 3 unit.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:49:41', '2026-08-12 13:49:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(24, 3, 'Karpet Mushola', 4500000, 'Penggantian karpet mushola yang sudah tipis dan usang. Estimasi harga Rp1.500.000/roll × 3 roll.', 'PENDING', 'HIGH', 46, '2026-08-12 06:50:10', '2026-08-12 13:50:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, 3, 'Sound System Mushola', 5000000, 'Pengadaan sound system untuk kegiatan ibadah dan pembinaan karakter islami siswa. Estimasi harga Rp5.000.000/paket × 1 paket.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:50:46', '2026-08-12 13:50:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, 3, 'Buku Perpustakaan Islami', 5000000, 'Penambahan koleksi buku islami dan literasi anak. Estimasi harga Rp50.000/buku × 100 buku.', 'PENDING', 'LOW', 46, '2026-08-12 06:51:37', '2026-08-12 13:51:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(27, 3, 'Rak Buku Perpustakaan', 6000000, 'Penambahan rak untuk penataan koleksi perpustakaan. Estimasi harga Rp1.500.000/unit × 4 unit.', 'PENDING', 'LOW', 46, '2026-08-12 06:52:08', '2026-08-12 13:52:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, 3, 'CCTV', 9000000, 'Penambahan titik CCTV pada area gerbang dan koridor sekolah. Estimasi harga Rp1.500.000/unit × 6 unit.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:52:42', '2026-08-12 13:52:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, 3, 'Peralatan UKS', 4000000, 'Pengadaan perlengkapan kesehatan dan P3K siswa. Estimasi harga Rp4.000.000/paket × 1 paket.', 'PENDING', 'HIGH', 46, '2026-08-12 06:53:11', '2026-08-12 13:53:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30, 3, 'Kipas Angin Dinding', 4000000, 'Penambahan kipas angin pada ruang kelas yang belum memiliki pendingin ruangan. Estimasi harga Rp500.000/unit × 8 unit.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:53:42', '2026-08-12 13:53:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, 3, 'Lemari Arsip', 6000000, 'Pengadaan lemari arsip untuk penyimpanan dokumen sekolah. Estimasi harga Rp1.500.000/unit × 4 unit.', 'PENDING', 'LOW', 46, '2026-08-12 06:54:13', '2026-08-12 13:54:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, 3, 'Tempat Sampah Pilah', 2400000, 'Mendukung program kebersihan dan edukasi lingkungan. Estimasi harga Rp200.000/unit × 12 unit.', 'PENDING', 'LOW', 46, '2026-08-12 06:54:45', '2026-08-12 13:54:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(33, 3, 'Alat Peraga Matematika', 5000000, 'Pengadaan alat bantu pembelajaran matematika untuk siswa SD. Estimasi harga Rp2.500.000/paket × 2 paket.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:55:15', '2026-08-12 13:55:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, 3, 'Alat Peraga IPA', 6000000, 'Pengadaan alat bantu praktikum IPA sederhana. Estimasi harga Rp3.000.000/paket × 2 paket.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:55:44', '2026-08-12 13:55:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, 3, 'Jam Dinding Kelas', 1000000, 'Penggantian jam dinding yang rusak pada beberapa kelas. Estimasi harga Rp100.000/unit × 10 unit.', 'PENDING', 'LOW', 46, '2026-08-12 06:56:21', '2026-08-12 13:56:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(36, 3, 'Perlengkapan Pramuka', 3000000, 'Pengadaan perlengkapan kegiatan ekstrakurikuler pramuka. Estimasi harga Rp3.000.000/paket × 1 paket.', 'PENDING', 'LOW', 46, '2026-08-12 06:56:46', '2026-08-12 13:56:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(37, 3, 'Router dan Access Point', 6000000, 'Peningkatan kualitas jaringan internet sekolah. Estimasi harga Rp1.500.000/unit × 4 unit.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:57:12', '2026-08-12 13:57:12', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(38, 3, 'Meja Guru', 6000000, 'Penggantian meja guru yang sudah tidak layak digunakan. Estimasi harga Rp1.200.000/unit × 5 unit.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:57:35', '2026-08-12 13:57:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(39, 3, 'Kursi Guru', 4000000, 'Penggantian kursi guru yang rusak. Estimasi harga Rp800.000/unit × 5 unit.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:58:05', '2026-08-12 13:58:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(40, 3, 'Dispenser Air Minum', 3000000, 'Pengadaan dispenser untuk ruang guru dan ruang tamu. Estimasi harga Rp1.000.000/unit × 3 unit.', 'PENDING', 'LOW', 46, '2026-08-12 06:58:32', '2026-08-12 13:58:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(41, 3, 'Pengecatan Ruang Kelas', 9000000, 'Perawatan ruang kelas agar tetap nyaman dan representatif. Estimasi biaya Rp1.500.000/kelas × 6 kelas.', 'PENDING', 'MEDIUM', 46, '2026-08-12 06:59:01', '2026-08-12 13:59:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(42, 3, 'Perbaikan Toilet Siswa', 12000000, 'Perbaikan fasilitas toilet siswa untuk menjaga kenyamanan dan kebersihan. Estimasi biaya pekerjaan Rp12.000.000.', 'PENDING', 'HIGH', 46, '2026-08-12 06:59:35', '2026-08-12 13:59:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(43, 2, 'Kursi Siswa', 4500000, 'Penggantian kursi siswa yang rusak pada beberapa ruang kelas. Estimasi harga Rp300.000/unit × 15 unit.', 'APPROVED', 'HIGH', 44, '2026-08-17 15:37:05', '2026-08-17 15:37:05', 41, '2026-08-16 15:25:49', 'segera di pesankan', 'PURCHASED', 47, '2026-08-17 15:37:05', '1786981025_kursi.PNG'),
(44, 2, 'Meja Siswa', 6000000, 'Penggantian meja belajar siswa yang sudah tidak layak digunakan. Estimasi harga Rp500.000/unit × 12 unit.', 'PENDING', 'HIGH', 44, '2026-08-12 07:09:33', '2026-08-12 14:09:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(45, 2, 'Whiteboard Kelas', 3200000, 'Penggantian papan tulis kelas yang sudah kusam. Estimasi harga Rp800.000/unit × 4 unit.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:10:02', '2026-08-12 14:10:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(46, 2, 'Laptop Guru', 12000000, 'Pengadaan laptop untuk administrasi dan penyusunan perangkat pembelajaran. Estimasi harga Rp6.000.000/unit × 2 unit.', 'REJECTED', 'HIGH', 44, '2026-08-16 15:20:02', '2026-08-16 15:20:02', 41, '2026-08-16 15:20:02', 'komputer yang disediakan di kantor masih layak pakai, kebutuhan laptop tidak mendesak, sebaikanya pengeluarannya dialihkan ke hal yg lebih urgent', NULL, NULL, NULL, NULL),
(47, 2, 'Printer Multifungsi', 5000000, 'Pengadaan printer untuk kebutuhan administrasi dan ujian. Estimasi harga Rp2.500.000/unit × 2 unit.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:11:07', '2026-08-12 14:11:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(48, 2, 'Lemari Al-Qur\'an', 6000000, 'Penyimpanan Al-Qur\'an dan buku keagamaan di setiap kelas. Estimasi harga Rp1.500.000/unit × 4 unit.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:11:33', '2026-08-12 14:11:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(49, 2, 'Al-Qur\'an Siswa', 5000000, 'Penggantian Al-Qur\'an yang rusak dan penambahan untuk siswa baru. Estimasi harga Rp100.000/eksemplar × 50 buah.', 'PENDING', 'HIGH', 44, '2026-08-12 07:12:03', '2026-08-12 14:12:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(50, 2, 'Karpet Mushola', 3000000, 'Penggantian karpet mushola yang sudah usang. Estimasi harga Rp1.500.000/roll × 2 roll.', 'PENDING', 'HIGH', 44, '2026-08-12 07:12:33', '2026-08-12 14:12:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(51, 2, 'Sound System Mushola', 4500000, 'Pengadaan sound system untuk kegiatan ibadah dan hafalan Al-Qur\'an. Estimasi harga Rp4.500.000/paket × 1 paket.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:13:44', '2026-08-12 14:13:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(52, 2, 'Rak Sepatu Mushola', 3000000, 'Penataan area mushola agar lebih tertib. Estimasi harga Rp500.000/unit × 6 unit.', 'PENDING', 'LOW', 44, '2026-08-12 07:14:24', '2026-08-12 14:14:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(53, 2, 'Buku Perpustakaan Islami', 4000000, 'Penambahan koleksi buku islami dan kisah teladan anak. Estimasi harga Rp50.000/buku × 80 buku.', 'PENDING', 'LOW', 44, '2026-08-12 07:15:00', '2026-08-12 14:15:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(54, 2, 'Rak Buku Perpustakaan', 4500000, 'Penambahan rak buku perpustakaan sekolah. Estimasi harga Rp1.500.000/unit × 3 unit.', 'PENDING', 'LOW', 44, '2026-08-12 07:15:36', '2026-08-12 14:15:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(55, 2, 'CCTV', 6000000, 'Penambahan perangkat CCTV pada area gerbang dan koridor sekolah. Estimasi harga Rp1.500.000/unit × 4 unit.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:17:20', '2026-08-12 14:17:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(56, 2, 'Peralatan UKS', 3500000, 'Pengadaan perlengkapan kesehatan siswa dan kotak P3K. Estimasi harga Rp3.500.000/paket × 1 paket.', 'PENDING', 'HIGH', 44, '2026-08-12 07:17:54', '2026-08-12 14:17:54', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(57, 2, 'Kipas Angin Dinding', 3000000, 'Penambahan kipas angin pada ruang kelas. Estimasi harga Rp500.000/unit × 6 unit.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:18:23', '2026-08-12 14:18:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(58, 2, 'Lemari Arsip', 4500000, 'Penyimpanan dokumen administrasi madrasah. Estimasi harga Rp1.500.000/unit × 3 unit.', 'PENDING', 'LOW', 44, '2026-08-12 07:19:53', '2026-08-12 14:19:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(59, 2, 'Tempat Sampah Pilah', 2000000, 'Mendukung program kebersihan lingkungan madrasah. Estimasi harga Rp200.000/unit × 10 unit.', 'PENDING', 'LOW', 44, '2026-08-12 07:20:59', '2026-08-12 14:20:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(60, 2, 'Alat Peraga IPA', 2500000, 'Pengadaan alat bantu pembelajaran IPA sederhana. Estimasi harga Rp2.500.000/paket × 1 paket.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:21:31', '2026-08-12 14:21:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(61, 2, 'Alat Peraga Matematika', 2500000, 'Pengadaan alat bantu pembelajaran matematika. Estimasi harga Rp2.500.000/paket × 1 paket.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:22:05', '2026-08-12 14:22:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(62, 2, 'Jam Dinding Kelas', 800000, 'Penggantian jam dinding pada ruang kelas. Estimasi harga Rp100.000/unit × 8 unit.', 'PENDING', 'LOW', 44, '2026-08-12 07:22:45', '2026-08-12 14:22:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63, 2, 'Perlengkapan Manasik Haji', 4000000, 'Pengadaan perlengkapan edukasi manasik haji untuk siswa. Estimasi biaya Rp4.000.000/paket × 1 paket.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:23:32', '2026-08-12 14:23:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(64, 2, 'Router dan Access Point', 4500000, 'Peningkatan kualitas jaringan internet sekolah. Estimasi harga Rp1.500.000/unit × 3 unit.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:24:03', '2026-08-12 14:24:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(65, 2, 'Meja Guru', 4800000, 'Penggantian meja guru yang sudah rusak. Estimasi harga Rp1.200.000/unit × 4 unit.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:24:40', '2026-08-12 14:24:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(66, 2, 'Kursi Guru', 3200000, 'Penggantian kursi guru yang sudah tidak layak digunakan. Estimasi harga Rp800.000/unit × 4 unit.', 'PENDING', 'MEDIUM', 44, '2026-08-12 07:25:08', '2026-08-12 14:25:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(67, 2, 'Perbaikan Tempat Wudhu', 8000000, 'Perbaikan saluran air dan keramik area wudhu siswa. Estimasi biaya pekerjaan Rp8.000.000.', 'PENDING', 'HIGH', 44, '2026-08-12 07:25:42', '2026-08-12 14:25:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(68, 1, 'AC Ruang Kelas', 8000000, 'Pengadaan AC untuk 2 ruang kelas. Estimasi harga Rp4.000.000/unit × 2 unit.', 'APPROVED', 'HIGH', 42, '2026-08-17 08:10:23', '2026-08-17 08:10:23', 41, '2026-08-17 08:10:23', 'segera dilaksanakan, dahulukan pelayanan dan kenyamanan belajar & mengajar', 'PROCESS', NULL, NULL, NULL),
(69, 1, 'Instalasi AC', 1500000, 'Instalasi listrik dan pemasangan AC pada 2 ruang kelas. Estimasi biaya Rp1.500.000.', 'APPROVED', 'HIGH', 42, '2026-08-17 08:11:12', '2026-08-17 08:11:12', 41, '2026-08-17 08:11:12', 'segera dilaksanakan, dahulukan pelayanan dan kenyamanan belajar & mengajar', 'PROCESS', NULL, NULL, NULL),
(70, 1, 'Meja Belajar Anak', 3000000, 'Penggantian meja belajar yang sudah mulai rusak. Estimasi harga Rp500.000/unit × 6 unit.', 'PENDING', 'MEDIUM', 42, '2026-08-12 07:38:09', '2026-08-12 14:38:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(71, 1, 'Kursi Belajar Anak', 2000000, 'Penggantian kursi anak yang rusak. Estimasi harga Rp200.000/unit × 10 unit.', 'PENDING', 'MEDIUM', 42, '2026-08-12 07:40:34', '2026-08-12 14:40:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(72, 1, 'Karpet Bermain', 1500000, 'Karpet busa untuk kegiatan belajar dan bermain kelompok. Estimasi harga Rp750.000/unit × 2 unit.', 'PENDING', 'HIGH', 42, '2026-08-12 07:41:36', '2026-08-12 14:41:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(73, 1, 'Alat Lukis dan Mewarnai', 1500000, 'Pengadaan krayon, cat air, kuas, kertas gambar, dan perlengkapan seni selama 1 tahun.', 'PENDING', 'HIGH', 42, '2026-08-12 07:42:05', '2026-08-12 14:42:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(74, 1, 'Puzzle Edukasi', 1250000, 'Puzzle huruf, angka, hewan, dan bentuk geometri. Estimasi harga Rp250.000/set × 5 set.', 'PENDING', 'MEDIUM', 42, '2026-08-12 07:42:30', '2026-08-12 14:42:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(75, 1, 'Balok Susun Edukatif', 2000000, 'Alat bermain untuk melatih motorik dan kreativitas anak. Estimasi harga Rp500.000/set × 4 set.', 'PENDING', 'MEDIUM', 42, '2026-08-12 07:43:11', '2026-08-12 14:43:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(76, 1, 'Perosotan Anak', 3500000, 'Pengadaan perosotan ukuran sedang untuk area bermain.', 'PENDING', 'MEDIUM', 42, '2026-08-12 07:43:41', '2026-08-12 14:43:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(77, 1, 'Ayunan Anak', 2500000, 'Pengadaan ayunan anak untuk taman bermain.', 'PENDING', 'LOW', 42, '2026-08-12 07:44:06', '2026-08-12 14:44:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(78, 1, 'Rak Mainan', 2000000, 'Penyimpanan alat bermain dan alat belajar anak. Estimasi harga Rp1.000.000/unit × 2 unit.', 'PENDING', 'MEDIUM', 42, '2026-08-12 07:44:34', '2026-08-12 14:44:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(79, 1, 'Buku Cerita Anak Islami', 1500000, 'Penambahan koleksi buku cerita dan kisah nabi untuk siswa TK. Estimasi harga Rp50.000/buku × 30 buku.', 'PENDING', 'LOW', 42, '2026-08-12 07:45:04', '2026-08-12 14:45:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(80, 1, 'Sound Portable', 1500000, 'Digunakan untuk senam pagi, kegiatan pentas, dan pembelajaran interaktif.', 'PENDING', 'LOW', 42, '2026-08-12 07:46:13', '2026-08-12 14:46:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(81, 1, 'Tempat Cuci Tangan Anak', 1500000, 'Penambahan fasilitas kebersihan ramah anak. Estimasi harga Rp1.500.000/unit × 1 unit.', 'PENDING', 'MEDIUM', 42, '2026-08-12 07:46:59', '2026-08-12 14:46:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(82, 1, 'CCTV', 3000000, 'Pengadaan CCTV untuk area pintu masuk dan ruang bermain. Estimasi harga Rp1.500.000/unit × 2 unit.', 'PENDING', 'HIGH', 42, '2026-08-12 07:47:29', '2026-08-12 14:47:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'web', '2022-08-14 21:11:33', '2022-08-14 21:11:33'),
(2, 'Yayasan', 'web', '2022-08-14 21:11:33', '2022-08-14 21:11:33'),
(3, 'Keuangan', 'web', '2022-08-14 21:11:33', '2022-08-14 21:11:33'),
(4, 'Kepala Sekolah', 'web', '2022-08-14 21:11:33', '2022-08-14 21:11:33');

-- --------------------------------------------------------

--
-- Table structure for table `school`
--

CREATE TABLE `school` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `saldo` bigint(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` datetime NOT NULL,
  `color` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `school`
--

INSERT INTO `school` (`id`, `name`, `saldo`, `created_at`, `updated_at`, `color`) VALUES
(1, 'TKIT Al Istiqomah', 800000, '2026-08-17 08:11:12', '2026-08-17 08:11:12', 'text-primary'),
(2, 'MI Al Istiqomah', 4400000, '2026-08-17 07:47:31', '2026-08-17 07:47:31', 'text-success'),
(3, 'SDIT Al Istiqomah 1', 11900000, '2026-08-17 07:47:41', '2026-08-17 07:47:41', 'text-warning'),
(4, 'SDIT Al Istiqomah 2', 11310000, '2026-08-17 07:47:50', '2026-08-17 07:47:50', 'text-danger');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `balance_history`
--
ALTER TABLE `balance_history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `icon`
--
ALTER TABLE `icon`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `purchase_request`
--
ALTER TABLE `purchase_request`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `school`
--
ALTER TABLE `school`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `balance_history`
--
ALTER TABLE `balance_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `purchase_request`
--
ALTER TABLE `purchase_request`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `school`
--
ALTER TABLE `school`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

