Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.2.7.1
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Feb 26, 2018 at 11:31 AM
- -- Server version: 5.6.20
- -- PHP Version: 5.5.15
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `webhozz_app_server`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `profil`
- --
- DROP TABLE IF EXISTS `profil`;
- CREATE TABLE IF NOT EXISTS `profil` (
- `idprofil` int(8) NOT NULL,
- `foto` varchar(100) NOT NULL,
- `nama` varchar(75) NOT NULL,
- `jkelamin` varchar(1) NOT NULL,
- `alamat` text NOT NULL,
- `no_telp` varchar(20) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
- --
- -- Dumping data for table `profil`
- --
- INSERT INTO `profil` (`idprofil`, `foto`, `nama`, `jkelamin`, `alamat`, `no_telp`) VALUES
- (2, '', 'Ari Julianto', 'L', 'Abdi Negara Rancaekek', '089657206089'),
- (3, 'people.png', 'Deni', 'L', 'Cileunyi', '12345'),
- (4, '', 'Vina', 'P', 'Rancabangoo', '0899999'),
- (6, 'man.png', 'Sri', 'P', 'Tanjungsari', '082211111');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `profil`
- --
- ALTER TABLE `profil`
- ADD PRIMARY KEY (`idprofil`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `profil`
- --
- ALTER TABLE `profil`
- MODIFY `idprofil` int(8) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement