File: localhost.sql

-- Database: `test`
-- 
CREATE DATABASE `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;
USE test;

-- --------------------------------------------------------

-- 
-- Table structure for table `user_tbl`
-- 

CREATE TABLE IF NOT EXISTS `user_tbl` (
  `id` int(11) NOT NULL auto_increment,
  `first_name` varchar(25) collate latin1_general_ci NOT NULL,
  `last_name` varchar(25) collate latin1_general_ci NOT NULL,
  `email_add` varchar(50) collate latin1_general_ci NOT NULL,
  `phone` varchar(11) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `user_tbl`
-- 

INSERT INTO `user_tbl` VALUES (2, 'First Name', 'Last Name', 'email@email.com', '1234-5789');