-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Jul 18, 2022 at 12:53 PM -- Server version: 10.4.21-MariaDB -- PHP Version: 7.3.31 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: `u1808083_pp1DMorTa1` -- -- -------------------------------------------------------- -- -- Table structure for table `member` -- CREATE TABLE `member` ( `id_member` int(11) NOT NULL, `no_identitas` varchar(50) DEFAULT NULL, `image` varchar(256) DEFAULT NULL, `nama` varchar(128) DEFAULT NULL, `alamat` varchar(256) DEFAULT NULL, `no_telp` varchar(15) DEFAULT NULL, `email` varchar(128) DEFAULT NULL, `password` varchar(128) DEFAULT NULL, `tipe_member` int(3) DEFAULT NULL, `is_active` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `member` -- INSERT INTO `member` (`id_member`, `no_identitas`, `image`, `nama`, `alamat`, `no_telp`, `email`, `password`, `date_created`, `tipe_member`, `is_active`) VALUES (12, '3323074904990002', '11355.jpg', 'Mahmud', 'Wonogiri', '081516262728', 'milleepark94@gmail.com', '2e3817293fc275dbee74bd71ce6eb056',1, 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `member` -- ALTER TABLE `member` ADD PRIMARY KEY (`id_member`), ADD KEY `type` (`tipe_member`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `member` -- ALTER TABLE `member` MODIFY `id_member` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=132; -- -- Constraints for dumped tables -- -- -- Constraints for table `member` -- ALTER TABLE `member` ADD CONSTRAINT `type` FOREIGN KEY (`tipe_member`) REFERENCES `member_type` (`id_type`); 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 */;