 -- --------------------------------------------------------
 
 --
+-- Table structure for table `media`
+--
+
+CREATE TABLE IF NOT EXISTS `media` (
+  `id` int(11) NOT NULL,
+  `username` varchar(72) NOT NULL,
+  `type` int(11) NOT NULL,
+  `createdAt` int(15) NOT NULL,
+  `filename` varchar(255) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `mediaType`
+--
+
+CREATE TABLE IF NOT EXISTS `mediaType` (
+  `id` int(11) NOT NULL,
+  `name` varchar(50) NOT NULL,
+  `amount` int(11) NOT NULL,
+  `note` varchar(100) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `mediaType`
+--
+
+INSERT INTO `mediaType` (`id`, `name`, `amount`, `note`) VALUES
+(1, 'Images', 0, ''),
+(2, 'Videos', 0, ''),
+(3, 'Audios', 0, ''),
+(4, 'PDFs', 0, '');
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `notifications`
 --
 

  `auditId` char(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `fieldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `oldValue` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `newValue` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

  ADD KEY `idUser` (`userId`);

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
