| Server IP : 101.255.104.117 / Your IP : 101.255.104.117 Web Server : Apache/2.4.34 (Win32) OpenSSL/1.0.2o PHP/5.6.38 System : Windows NT DESKTOP-5B8S0D4 6.2 build 9200 (Windows 8 Professional Edition) i586 User : user ( 0) PHP Version : 5.6.38 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/xampp182/htdocs/repository/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.0.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 15, 2020 at 11:06 AM -- Server version: 10.4.11-MariaDB -- PHP Version: 7.4.3 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `ci_repository` -- -- -------------------------------------------------------- -- -- Table structure for table `authors` -- CREATE TABLE `authors` ( `id` int(10) NOT NULL, `author` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `prodi` -- CREATE TABLE `prodi` ( `id` int(10) NOT NULL, `program_studi` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `repo` -- CREATE TABLE `repo` ( `id` int(10) NOT NULL, `date` date NOT NULL, `year` int(4) NOT NULL, `id_author` int(10) NOT NULL, `id_type` int(10) NOT NULL, `id_prodi` int(10) NOT NULL, `title` varchar(500) NOT NULL, `description` text NOT NULL, `file_repo` varchar(255) NOT NULL, `thumbnail` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `types` -- CREATE TABLE `types` ( `id` int(10) NOT NULL, `type` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `level` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `password`, `level`) VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'master'); -- -- Indexes for dumped tables -- -- -- Indexes for table `authors` -- ALTER TABLE `authors` ADD PRIMARY KEY (`id`); -- -- Indexes for table `prodi` -- ALTER TABLE `prodi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `repo` -- ALTER TABLE `repo` ADD PRIMARY KEY (`id`); -- -- Indexes for table `types` -- ALTER TABLE `types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `authors` -- ALTER TABLE `authors` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `prodi` -- ALTER TABLE `prodi` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `repo` -- ALTER TABLE `repo` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `types` -- ALTER TABLE `types` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; COMMIT;