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

START TRANSACTION;



--
-- Database: `gasd3326_repo`
--

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

--
-- Table structure for table `afm_driveactivitylogs`
--

CREATE TABLE `afm_driveactivitylogs` (
  `id` int(11) NOT NULL,
  `description` longtext DEFAULT NULL,
  `userID` int(20) DEFAULT NULL,
  `date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `afm_driveactivitylogs`
--

INSERT INTO `afm_driveactivitylogs` (`id`, `description`, `userID`, `date`) VALUES
(1, 'Successfully logged in.', 1, '2023-06-27 11:12:46'),
(2, 'Successfully logged in.', 1, '2023-06-27 11:13:32'),
(3, 'Successfully logged in.', 1, '2023-06-27 11:15:34'),
(4, 'Successfully logged in.', 1, '2023-06-27 11:22:20'),
(5, 'Successfully logged in.', 1, '2023-06-27 11:26:23'),
(6, 'Error during login. Wrong password.', 1, '2023-06-27 11:36:35'),
(7, 'Successfully logged in.', 1, '2023-06-27 11:36:43'),
(8, 'Successfully logged in.', 1, '2023-06-27 12:57:02'),
(9, 'Successfully logged in.', 1, '2023-06-27 13:11:56'),
(10, 'Successfully logged in.', 1, '2023-06-27 13:32:49'),
(11, 'Successfully logged in.', 1, '2023-06-27 13:45:41'),
(12, 'Successfully logged in.', 1, '2023-06-27 13:49:31'),
(13, 'Successfully logged in.', 1, '2023-06-27 14:02:15'),
(14, 'Successfully logged in.', 1, '2023-06-27 14:46:59'),
(15, 'Added new folder pendidikan', 1, '2023-06-27 14:47:24'),
(16, 'Successfully logged in.', 1, '2023-06-27 14:50:13'),
(17, 'Successfully logged in.', 1, '2023-06-27 14:52:57'),
(18, 'Successfully logged in.', 1, '2023-06-27 14:53:22'),
(19, 'Added new user tepe', 1, '2023-06-27 14:54:39'),
(20, 'Successfully logged in.', 2, '2023-06-27 14:54:48'),
(21, 'Successfully logged in.', 2, '2023-06-27 14:56:04'),
(22, 'Successfully logged in.', 1, '2023-06-27 14:56:13'),
(23, 'Successfully logged in.', 1, '2023-06-27 14:56:36'),
(24, 'Successfully logged in.', 2, '2023-06-27 14:56:43'),
(25, 'Successfully logged in.', 1, '2023-06-27 14:58:02'),
(26, 'Added new user pranoto', 1, '2023-06-27 14:58:50'),
(27, 'Successfully logged in.', 4, '2023-06-27 15:04:36'),
(28, 'Successfully logged in.', 1, '2023-06-27 15:04:58'),
(29, 'Successfully logged in.', 1, '2023-06-27 16:12:56'),
(30, 'Added new folder penelitian', 1, '2023-06-27 16:14:00'),
(31, 'Added new folder pengabdian', 1, '2023-06-27 16:14:09'),
(32, 'Added new folder penunjang', 1, '2023-06-27 16:14:33'),
(33, 'Successfully logged in.', 2, '2023-06-27 16:18:16'),
(34, 'Successfully logged in.', 2, '2023-06-30 07:12:28'),
(35, 'Successfully logged in.', 1, '2023-06-30 07:22:57'),
(36, 'Successfully logged in.', 1, '2023-06-30 07:23:32'),
(37, 'Successfully logged in.', 1, '2023-06-30 07:28:57'),
(38, 'Successfully logged in.', 2, '2023-06-30 07:29:15'),
(39, 'Successfully logged in.', 1, '2023-06-30 07:29:48'),
(40, 'Added new extension PPT', 1, '2023-06-30 07:30:00'),
(41, 'Added new extension PPTX', 1, '2023-06-30 07:30:08'),
(42, 'Successfully logged in.', 2, '2023-06-30 07:30:14'),
(43, 'Successfully logged in.', 1, '2023-06-30 07:31:04'),
(44, 'Successfully logged in.', 2, '2023-06-30 07:31:49'),
(45, 'Successfully logged in.', 2, '2023-06-30 07:41:28'),
(46, 'Successfully logged in.', 1, '2023-06-30 07:41:48'),
(47, 'Successfully logged in.', 2, '2023-06-30 07:51:30'),
(48, 'Successfully logged in.', 1, '2023-06-30 08:06:25'),
(49, 'Successfully logged in.', 2, '2023-06-30 09:21:46'),
(50, 'Successfully logged in.', 1, '2023-06-30 09:23:22'),
(51, 'Added new extension DOCX', 1, '2023-06-30 09:23:37'),
(52, 'Successfully logged in.', 2, '2023-06-30 09:23:44'),
(53, 'Successfully logged in.', 1, '2023-06-30 09:31:39'),
(54, 'Successfully logged in.', 45, '2023-06-30 09:32:05'),
(55, 'Successfully logged in.', 1, '2023-06-30 09:34:01'),
(56, 'Updated info for user tepe', 1, '2023-06-30 09:34:41'),
(57, 'Successfully reset password.', 2, '2023-06-30 09:35:03'),
(58, 'Successfully reset password.', 2, '2023-06-30 09:35:29'),
(59, 'Successfully reset password.', 2, '2023-06-30 09:36:15'),
(60, 'Successfully logged in.', 1, '2023-06-30 09:36:19'),
(61, 'Successfully logged in.', 1, '2023-06-30 09:58:38'),
(62, 'Error during login. Wrong password.', 2, '2023-06-30 11:38:36'),
(63, 'Error during login. Wrong password.', 2, '2023-06-30 11:38:56'),
(64, 'Error during login. Wrong password.', 2, '2023-06-30 11:39:44'),
(65, 'Error during login. Wrong password.', 2, '2023-06-30 11:41:18'),
(66, 'Error during login. Wrong password.', 2, '2023-06-30 11:41:36'),
(67, 'Error during login. Wrong password.', 2, '2023-06-30 11:41:44'),
(68, 'Error during login. Wrong password.', 2, '2023-06-30 11:41:57'),
(69, 'Successfully logged in.', 3, '2023-06-30 11:42:15'),
(70, 'Successfully logged in.', 3, '2023-06-30 11:44:15'),
(71, 'Added message for file Visi Keilmuan Prodi_A3.jpg', 3, '2023-06-30 11:48:49'),
(72, 'Updated info for file Visi Keilmuan Prodi A3.jpg', 3, '2023-06-30 11:49:22'),
(73, 'Error during login. Wrong password.', 2, '2023-06-30 12:46:18'),
(74, 'Successfully logged in.', 3, '2023-06-30 12:46:38'),
(75, 'Successfully logged in.', 1, '2023-06-30 12:47:03'),
(76, 'Updated info for user tepe', 1, '2023-06-30 12:47:36'),
(77, 'Successfully logged in.', 2, '2023-06-30 12:47:56'),
(78, 'Successfully logged in.', 2, '2023-07-01 11:09:45'),
(79, 'Successfully logged in.', 3, '2023-07-01 11:09:59'),
(80, 'Successfully logged in.', 2, '2023-07-01 11:10:12'),
(81, 'Successfully logged in.', 83, '2023-07-04 10:50:53'),
(82, 'Added message for file Laporan SKPI Mahasiswa.pdf', 83, '2023-07-04 10:53:41'),
(83, 'Successfully logged in.', 1, '2023-07-04 10:54:29'),
(84, 'Successfully logged in.', 1, '2023-07-04 11:11:43'),
(85, 'Successfully logged in.', 81, '2023-07-04 15:48:26'),
(86, 'Successfully logged in.', 2, '2023-07-06 08:42:07'),
(87, 'Successfully logged in.', 1, '2023-07-07 10:45:23'),
(88, 'Added new file Kasus 2.xlsx via FTP Sync.', 1, '2023-07-07 10:46:23'),
(89, 'Added new file SKRIPSI ARIF FAISAL BAB 1.pdf via FTP Sync.', 1, '2023-07-07 10:46:23'),
(90, 'Added new file index.html via FTP Sync.', 1, '2023-07-07 10:46:23'),
(91, 'Successfully logged in.', 3, '2023-07-12 14:25:45'),
(92, 'Successfully logged in.', 1, '2023-09-21 20:54:21'),
(93, 'Successfully logged in.', 2, '2023-10-03 14:45:57'),
(94, 'Successfully logged in.', 1, '2024-04-18 09:38:22'),
(95, 'Added new folder gatot-tri-pranoto', 1, '2024-04-18 09:50:14'),
(96, 'Added new folder rudi', 1, '2024-04-18 09:50:38'),
(97, 'Successfully logged in.', 71, '2024-04-18 09:54:27'),
(98, 'Successfully logged in.', 1, '2024-04-18 09:54:55'),
(99, 'Updated info for user rudi@trilogi.ac.id', 1, '2024-04-18 09:55:20'),
(100, 'Successfully logged in.', 71, '2024-04-18 09:55:26'),
(101, 'Successfully logged in.', 1, '2024-04-18 09:56:06'),
(102, 'Updated info for user rudi@trilogi.ac.id', 1, '2024-04-18 09:56:22'),
(103, 'Successfully logged in.', 71, '2024-04-18 09:56:27'),
(104, 'Successfully logged in.', 1, '2024-04-18 10:14:36'),
(105, 'Successfully logged in.', 71, '2024-04-18 10:15:58'),
(106, 'Successfully logged in.', 1, '2024-04-18 10:16:16'),
(107, 'Added new folder rudi-setiawan', 1, '2024-04-18 10:16:55'),
(108, 'Added new folder penelitian', 1, '2024-04-18 10:17:14'),
(109, 'Added new folder pengabdian', 1, '2024-04-18 10:17:22'),
(110, 'Added new folder penunjang', 1, '2024-04-18 10:17:33'),
(111, 'Added new folder lain-lain', 1, '2024-04-18 10:17:44'),
(112, 'Updated info for user rudi@trilogi.ac.id', 1, '2024-04-18 10:18:05'),
(113, 'Successfully logged in.', 71, '2024-04-18 10:18:17'),
(114, 'Successfully logged in.', 1, '2024-04-18 10:19:11'),
(115, 'Successfully logged in.', 71, '2024-04-18 10:20:22'),
(116, 'Successfully logged in.', 1, '2024-04-18 10:21:08'),
(117, 'Successfully logged in.', 71, '2024-04-18 10:22:23'),
(118, 'Successfully logged in.', 1, '2024-04-18 10:23:01'),
(119, 'Successfully logged in.', 71, '2024-04-18 10:23:21'),
(120, 'Successfully logged in.', 1, '2024-04-18 10:25:08'),
(121, 'Updated info for user rudi@trilogi.ac.id', 1, '2024-04-18 10:26:01'),
(122, 'Successfully logged in.', 71, '2024-04-18 10:26:07'),
(123, 'Successfully logged in.', 1, '2024-04-18 10:26:21'),
(124, 'Successfully logged in.', 1, '2024-05-02 13:32:01');

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

--
-- Table structure for table `afm_drivecategories`
--

CREATE TABLE `afm_drivecategories` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `userID` int(20) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `afm_drivedownloads`
--

CREATE TABLE `afm_drivedownloads` (
  `id` int(11) NOT NULL,
  `idUser` int(11) DEFAULT NULL,
  `idFile` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `size` decimal(10,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `afm_drivedownloads`
--

INSERT INTO `afm_drivedownloads` (`id`, `idUser`, `idFile`, `date`, `size`) VALUES
(1, 1, 67, '2023-06-27 03:02:00', 3692.04),
(2, 1, 0, '2023-06-27 03:48:00', 3765.14),
(3, 2, 943, '2023-06-27 03:57:00', 768.02),
(4, 2, 846301911, '2023-06-29 20:30:00', 211.50),
(5, 3, 1098, '2023-06-30 00:49:00', 235.84),
(6, 0, 0, '2023-07-03 23:52:00', 153.25),
(7, 0, 0, '2023-07-12 03:28:00', 307.38),
(8, 0, 53, '2024-04-17 22:58:00', 614.97);

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

--
-- Table structure for table `afm_driveextensions`
--

CREATE TABLE `afm_driveextensions` (
  `id` int(11) NOT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `afm_driveextensions`
--

INSERT INTO `afm_driveextensions` (`id`, `dateCreated`, `name`) VALUES
(1, '2023-06-27 11:12:42', 'AVI'),
(2, '2023-06-27 11:12:42', 'BMP'),
(3, '2023-06-27 11:12:42', 'BSH'),
(4, '2023-06-27 11:12:42', 'C'),
(5, '2023-06-27 11:12:42', 'CC'),
(6, '2023-06-27 11:12:42', 'CPP'),
(7, '2023-06-27 11:12:42', 'CS'),
(8, '2023-06-27 11:12:42', 'CSH'),
(9, '2023-06-27 11:12:42', 'CSS'),
(10, '2023-06-27 11:12:42', 'CV'),
(11, '2023-06-27 11:12:42', 'CYC'),
(12, '2023-06-27 11:12:42', 'DOC'),
(13, '2023-06-27 11:12:42', 'GIF'),
(14, '2023-06-27 11:12:42', 'HTM'),
(15, '2023-06-27 11:12:42', 'HTML'),
(16, '2023-06-27 11:12:42', 'JAVA'),
(17, '2023-06-27 11:12:42', 'JPEG'),
(18, '2023-06-27 11:12:42', 'JPG'),
(19, '2023-06-27 11:12:42', 'JS'),
(20, '2023-06-27 11:12:42', 'M'),
(21, '2023-06-27 11:12:42', 'MOV'),
(22, '2023-06-27 11:12:42', 'MP3'),
(23, '2023-06-27 11:12:42', 'MP4'),
(24, '2023-06-27 11:12:42', 'MXML'),
(25, '2023-06-27 11:12:42', 'PDF'),
(26, '2023-06-27 11:12:42', 'PERL'),
(27, '2023-06-27 11:12:42', 'PHP'),
(28, '2023-06-27 11:12:42', 'PL'),
(29, '2023-06-27 11:12:42', 'PM'),
(30, '2023-06-27 11:12:42', 'PNG'),
(31, '2023-06-27 11:12:42', 'PY'),
(32, '2023-06-27 11:12:42', 'RAR'),
(33, '2023-06-27 11:12:42', 'RB'),
(34, '2023-06-27 11:12:42', 'SH'),
(35, '2023-06-27 11:12:42', 'SQL'),
(36, '2023-06-27 11:12:42', 'TXT'),
(37, '2023-06-27 11:12:42', 'VB'),
(38, '2023-06-27 11:12:42', 'WMA'),
(39, '2023-06-27 11:12:42', 'WMV'),
(40, '2023-06-27 11:12:42', 'XHTML'),
(41, '2023-06-27 11:12:42', 'XLS'),
(42, '2023-06-27 11:12:42', 'XLSX'),
(43, '2023-06-27 11:12:42', 'XML'),
(44, '2023-06-27 11:12:42', 'XSL'),
(45, '2023-06-27 11:12:42', 'ZIP'),
(46, '2023-06-30 07:30:00', 'PPT'),
(47, '2023-06-30 07:30:08', 'PPTX'),
(48, '2023-06-30 09:23:37', 'DOCX');

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

--
-- Table structure for table `afm_drivefiles`
--

CREATE TABLE `afm_drivefiles` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `size` double DEFAULT NULL,
  `extension` varchar(20) DEFAULT NULL,
  `userID` int(20) DEFAULT NULL,
  `catID` int(20) DEFAULT NULL,
  `dateUploaded` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `afm_drivefiles`
--

INSERT INTO `afm_drivefiles` (`id`, `title`, `path`, `size`, `extension`, `userID`, `catID`, `dateUploaded`) VALUES
(27, 'FORMULIR PENILAIAN KARYAWAN KONTRAK_Barir.pdf', '/FORMULIR PENILAIAN KARYAWAN KONTRAK_Barir.pdf', 629725, 'pdf', 71, 0, '2024-04-17 22:55:44');

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

--
-- Table structure for table `afm_drivefolders`
--

CREATE TABLE `afm_drivefolders` (
  `id` int(11) NOT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `parentID` int(20) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `afm_drivefolders`
--

INSERT INTO `afm_drivefolders` (`id`, `dateCreated`, `parentID`, `name`) VALUES
(1, '2023-06-27 11:12:42', 0, 'lain-lain'),
(2, '2023-06-27 14:47:24', 0, 'pendidikan'),
(3, '2023-06-27 16:14:00', 0, 'penelitian'),
(4, '2023-06-27 16:14:09', 0, 'pengabdian'),
(5, '2023-06-27 16:14:33', 0, 'penunjang'),
(6, '2024-04-18 09:50:14', 1, 'gatot-tri-pranoto'),
(7, '2024-04-18 09:50:38', 1, 'rudi'),
(8, '2024-04-18 10:16:55', 0, 'rudi-setiawan'),
(9, '2024-04-18 10:17:14', 8, 'penelitian'),
(10, '2024-04-18 10:17:22', 8, 'pengabdian'),
(11, '2024-04-18 10:17:33', 8, 'penunjang'),
(12, '2024-04-18 10:17:44', 8, 'lain-lain');

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

--
-- Table structure for table `afm_drivemessages`
--

CREATE TABLE `afm_drivemessages` (
  `id` int(11) NOT NULL,
  `fileID` int(20) NOT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `afm_drivecategories`
--
ALTER TABLE `afm_drivecategories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

