-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 07, 2026 at 09:39 PM
-- Server version: 10.5.27-MariaDB
-- PHP Version: 8.0.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `blarma`
--

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int(11) NOT NULL,
  `wordId` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `mediaName` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `wordId`, `order`, `type`, `mediaName`) VALUES
(4768, 30402, 1, 'jpg', 'afternoon-47221.png'),
(4903, 30549, 1, 'jpg', 'anesthesia-02839.png'),
(4824, 30463, 1, 'jpg', 'antique-99072.png'),
(4898, 30543, 1, 'jpg', 'aquarium-02817.png'),
(4766, 30400, 1, 'jpg', 'attend-a-meeting-47211.png'),
(4806, 30443, 1, 'jpg', 'awesome-51573.png'),
(4823, 30462, 1, 'jpg', 'barn-99052.png'),
(4875, 30534, 1, 'jpg', 'be-fed-up-with-23287.png'),
(4775, 30414, 1, 'jpg', 'bloom-47287.png'),
(4853, 30501, 1, 'jpg', 'build-up-23181.png'),
(4842, 30484, 1, 'jpg', 'call-off-23125.png'),
(4877, 30536, 1, 'jpg', 'camping-chair-23060.png'),
(4902, 30548, 1, 'jpg', 'career-development-02822.png'),
(4798, 30433, 1, 'jpg', 'carnival-06073.png'),
(4887, 30533, 1, 'jpg', 'carry-out-21146.png'),
(4786, 30407, 1, 'jpg', 'chronological-47505.png'),
(4817, 30438, 1, 'jpg', 'chronology-54823.png'),
(4849, 30491, 1, 'jpg', 'clear-out-64449.png'),
(4802, 30437, 1, 'jpg', 'colonialism-51554.png'),
(4860, 30513, 1, 'jpg', 'come-up-with-23219.png'),
(4901, 30547, 1, 'jpg', 'company-culture-02820.png'),
(4846, 30488, 1, 'jpg', 'cope-with-23127.png'),
(4857, 30509, 1, 'jpg', 'count-on-23200.png'),
(4836, 30478, 1, 'jpg', 'cut-down-on-23107.png'),
(4816, 30444, 1, 'jpg', 'dazzling-52020.png'),
(4911, 30558, 1, 'jpg', 'doll-02863.png'),
(4799, 30434, 1, 'jpg', 'eating-habits-51535.png'),
(4913, 30560, 1, 'jpg', 'effortless-02865.png'),
(4762, 30395, 1, 'jpg', 'energy-drink-46975.png'),
(4922, 30544, 1, 'jpg', 'extraordinary-03641.png'),
(4899, 30545, 1, 'jpg', 'fascinating-02819.png'),
(4771, 30419, 1, 'jpg', 'fertiliser-47307.png'),
(4803, 30439, 1, 'jpg', 'feudalism-51554.png'),
(4892, 30526, 1, 'jpg', 'fight-off-22387.png'),
(4873, 30531, 1, 'jpg', 'fill-out-23278.png'),
(4883, 30504, 1, 'jpg', 'get-along-with-21050.png'),
(4871, 30529, 1, 'jpg', 'get-away-23270.png'),
(4835, 30477, 1, 'jpg', 'get-rid-of-23107.png'),
(4845, 30487, 1, 'jpg', 'get-through-23125.png'),
(4855, 30503, 1, 'jpg', 'get-up-23184.png'),
(4881, 30499, 1, 'jpg', 'give-rise-to-23165.png'),
(4843, 30485, 1, 'jpg', 'give-up-23125.png'),
(4924, 30565, 1, 'jpg', 'glamourous-03825.png'),
(4876, 30535, 1, 'jpg', 'go-on-23290.png'),
(4765, 30399, 1, 'jpg', 'go-to-work-47208.png'),
(4917, 30567, 1, 'jpg', 'handcrafted-02905.png'),
(4921, 30540, 1, 'jpg', 'handle-03560.png'),
(4918, 30568, 1, 'jpg', 'harmonious-04032.png'),
(4811, 30449, 1, 'jpg', 'heart-attack-51595.png'),
(4770, 30420, 1, 'jpg', 'heartbreak-47312.png'),
(4910, 30557, 1, 'jpg', 'hire-02860.png'),
(4909, 30556, 1, 'jpg', 'hiring-02862.png'),
(4870, 30528, 1, 'jpg', 'hold-on-23267.png'),
(4839, 30481, 1, 'jpg', 'hold-up-23107.png'),
(4830, 30470, 1, 'jpg', 'immediately-99297.png'),
(4801, 30436, 1, 'jpg', 'immune-system-51553.png'),
(4804, 30440, 1, 'jpg', 'imperialism-51557.png'),
(4840, 30482, 1, 'jpg', 'insecure-24634.png'),
(4814, 30452, 1, 'jpg', 'insomnia-51602.png'),
(4809, 30447, 1, 'jpg', 'inspiring-51584.png'),
(4778, 30411, 1, 'jpg', 'job-description-47285.png'),
(4810, 30448, 1, 'jpg', 'joyful-51591.png'),
(4890, 30512, 1, 'jpg', 'keen-65365.png'),
(4869, 30527, 1, 'jpg', 'keep-away-23262.png'),
(4852, 30497, 1, 'jpg', 'keep-out-23945.png'),
(4914, 30561, 1, 'jpg', 'knitwear-02881.png'),
(4828, 30465, 1, 'jpg', 'later-99267.png'),
(4779, 30410, 1, 'jpg', 'life-47282.png'),
(4780, 30409, 1, 'jpg', 'lifestyle-47282.png'),
(4856, 30506, 1, 'jpg', 'literate-67324.png'),
(4858, 30510, 1, 'jpg', 'look-after-23204.png'),
(4874, 30532, 1, 'jpg', 'look-for-23281.png'),
(4891, 30517, 1, 'jpg', 'look-through-22219.png'),
(4773, 30416, 1, 'jpg', 'magnet-47299.png'),
(4764, 30398, 1, 'jpg', 'make-coffee-47208.png'),
(4868, 30524, 1, 'jpg', 'make-do-with-23250.png'),
(4838, 30480, 1, 'jpg', 'make-up-for-23918.png'),
(4789, 30424, 1, 'jpg', 'martial-arts-51512.png'),
(4781, 30408, 1, 'jpg', 'mental-health-47268.png'),
(4826, 30458, 1, 'jpg', 'miraculous-99236.png'),
(4769, 30421, 1, 'jpg', 'misfortune-47320.png'),
(4822, 30461, 1, 'jpg', 'natural-disaster-99053.png'),
(4812, 30450, 1, 'jpg', 'nausea-51595.png'),
(4825, 30466, 1, 'jpg', 'never-99075.png'),
(4827, 30464, 1, 'jpg', 'now-99267.png'),
(4920, 30537, 1, 'jpg', 'obtain-03422.png'),
(4831, 30468, 1, 'jpg', 'often-99286.png'),
(4834, 30460, 1, 'jpg', 'operating-system-08797.png'),
(4915, 30562, 1, 'jpg', 'opulent-02885.png'),
(4800, 30435, 1, 'jpg', 'organic-foods-51543.png'),
(4861, 30515, 1, 'jpg', 'participate-67711.png'),
(4761, 30393, 1, 'jpg', 'passion-46972.png'),
(4904, 30550, 1, 'jpg', 'patient-record-02839.png'),
(4882, 30500, 1, 'jpg', 'peanut-butter-65047.png'),
(4772, 30417, 1, 'jpg', 'picnic-47303.png'),
(4886, 30525, 1, 'jpg', 'play-down-23259.png'),
(4867, 30523, 1, 'jpg', 'point-out-23248.png'),
(4896, 30541, 1, 'jpg', 'prioritise-02797.png'),
(4792, 30427, 1, 'jpg', 'professional-51514.png'),
(4908, 30555, 1, 'jpg', 'professionalism-02860.png'),
(4776, 30413, 1, 'jpg', 'project-management-47290.png'),
(4782, 30406, 1, 'jpg', 'punctual-47266.png'),
(4821, 30457, 1, 'jpg', 'purchase-99055.png'),
(4862, 30516, 1, 'jpg', 'put-down-23228.png'),
(4841, 30483, 1, 'jpg', 'put-off-23125.png'),
(4848, 30490, 1, 'jpg', 'put-on-23144.png'),
(4889, 30498, 1, 'jpg', 'put-up-with-21897.png'),
(4793, 30428, 1, 'jpg', 'qualification-51513.png'),
(4788, 30397, 1, 'jpg', 'recommendation-48259.png'),
(4907, 30553, 1, 'jpg', 'recruiter-02839.png'),
(4777, 30412, 1, 'jpg', 'reference-47285.png'),
(4885, 30514, 1, 'jpg', 'rely-on-23221.png'),
(4790, 30425, 1, 'jpg', 'romance-51513.png'),
(4837, 30479, 1, 'jpg', 'run-out-23993.png'),
(4854, 30502, 1, 'jpg', 'run-over-23183.png'),
(4819, 30455, 1, 'jpg', 'seafood-89734.png'),
(4912, 30559, 1, 'jpg', 'security-camera-02864.png'),
(4864, 30519, 1, 'jpg', 'send-for-23239.png'),
(4820, 30456, 1, 'jpg', 'sensational-90277.png'),
(4844, 30486, 1, 'jpg', 'settle-down-23128.png'),
(4794, 30429, 1, 'jpg', 'sewage-51513.png'),
(4894, 30520, 1, 'jpg', 'show-off-25433.png'),
(4872, 30530, 1, 'jpg', 'slow-down-23270.png'),
(4829, 30467, 1, 'jpg', 'sometimes-99270.png'),
(4791, 30426, 1, 'jpg', 'soulmate-51517.png'),
(4818, 30454, 1, 'jpg', 'spice-89732.png'),
(4879, 30492, 1, 'jpg', 'step-down-21009.png'),
(4796, 30431, 1, 'jpg', 'stepbrother-51532.png'),
(4795, 30430, 1, 'jpg', 'stepsister-51532.png'),
(4813, 30451, 1, 'jpg', 'stomach-ache-51598.png'),
(4905, 30551, 1, 'jpg', 'strengths-02841.png'),
(4805, 30441, 1, 'jpg', 'suffrage-51564.png'),
(4785, 30418, 1, 'jpg', 'sunbathe-47425.png'),
(4900, 30546, 1, 'jpg', 'surprising-02819.png'),
(4884, 30505, 1, 'jpg', 'sustainable-agriculture-25003.png'),
(4866, 30522, 1, 'jpg', 'take-care-of-23246.png'),
(4847, 30489, 1, 'jpg', 'take-off-23149.png'),
(4880, 30494, 1, 'jpg', 'take-on-64564.png'),
(4851, 30496, 1, 'jpg', 'take-over-23164.png'),
(4865, 30521, 1, 'jpg', 'think-over-23242.png'),
(4925, 30566, 1, 'jpg', 'timeless-03913.png'),
(4784, 30403, 1, 'jpg', 'tomorrow-47261.png'),
(4919, 30538, 1, 'jpg', 'transform-03422.png'),
(4897, 30542, 1, 'jpg', 'trim-nails-02798.png'),
(4878, 30508, 1, 'jpg', 'try-on-23202.png'),
(4859, 30511, 1, 'jpg', 'turn-down-23208.png'),
(4863, 30518, 1, 'jpg', 'turn-off-24255.png'),
(4888, 30493, 1, 'jpg', 'turn-on-21831.png'),
(4774, 30415, 1, 'jpg', 'twilight-47301.png'),
(4807, 30445, 1, 'jpg', 'unbelievable-51573.png'),
(4832, 30459, 1, 'jpg', 'unprecedented-1881.png'),
(4797, 30432, 1, 'jpg', 'unrivaled-05790.png'),
(4916, 30563, 1, 'jpg', 'urban-02884.png'),
(4760, 30394, 1, 'jpg', 'vegetable-soup-45835.png'),
(4763, 30396, 1, 'jpg', 'vegetarian-47201.png'),
(4895, 30539, 1, 'jpg', 'verify-02796.png'),
(4923, 30554, 1, 'jpg', 'version-03704.png'),
(4893, 30507, 1, 'jpg', 'water-conservation-25125.png'),
(4906, 30552, 1, 'jpg', 'weaknesses-02843.png'),
(4783, 30405, 1, 'jpg', 'week-47265.png'),
(4926, 30564, 1, 'jpg', 'wheelbarrow-04184.png'),
(4850, 30495, 1, 'jpg', 'wipe-out-23162.png'),
(4767, 30401, 1, 'jpg', 'wireless-47211.png'),
(4808, 30446, 1, 'jpg', 'wonderful-51576.png'),
(4787, 30404, 1, 'jpg', 'yesterday-48260.png');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_media_word_media` (`wordId`,`mediaName`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `media`
--
ALTER TABLE `media`
  ADD CONSTRAINT `fk_media_word` FOREIGN KEY (`wordId`) REFERENCES `main_words` (`wordId`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
