Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.4.15
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Sep 25, 2016 at 07:11 AM
- -- Server version: 5.5.47
- -- PHP Version: 5.5.27
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- 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: `UPLOAD`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `tab_user`
- --
- CREATE TABLE IF NOT EXISTS `tab_user` (
- `user_id` int(11) NOT NULL,
- `username` varchar(50) COLLATE latin1_general_ci NOT NULL,
- `password` varchar(50) COLLATE latin1_general_ci NOT NULL,
- `user_nama` varchar(50) COLLATE latin1_general_ci NOT NULL,
- `user_akses` enum('gratis','premium','admin') COLLATE latin1_general_ci NOT NULL DEFAULT 'gratis'
- ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
- --
- -- Dumping data for table `tab_user`
- --
- INSERT INTO `tab_user` (`user_id`, `username`, `password`, `user_nama`, `user_akses`) VALUES
- (1, 'andi', '1234', 'Andi Doang', 'gratis'),
- (2, 'toto', '1234', 'Toto Kuncoro', 'premium'),
- (3, 'calim', '1234', 'Calim Weh', 'admin'),
- (4, 'widia', '1234', 'Widia Yatin', 'gratis');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `tab_user`
- --
- ALTER TABLE `tab_user`
- ADD PRIMARY KEY (`user_id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `tab_user`
- --
- ALTER TABLE `tab_user`
- MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement