No Validation included -- phpMyAdmin SQL Dump -- version 4.2.11 -- http://www.phpmyadmin.net
-- Host: 127.0.0.1 -- Generation Time: Nov 03, 2015 at 08:10 PM -- Server version: 5.6.21 -- PHP Version: 5.5.19
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 utf8 */;
CREATE TABLE IF NOT EXISTS user_table
(
user_id
int(11) NOT NULL,
user_name
varchar(50) NOT NULL,
user_email
varchar(50) NOT NULL,
user_password
varchar(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
ALTER TABLE user_table
ADD PRIMARY KEY (user_id
);
ALTER TABLE user_table
MODIFY user_id
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
/*!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 */;