PHP Classes
elePHPant
Icontem

File: localhost.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Mitchelle Pascual  >  MySQL DB Class and Data Manipulation Class  >  localhost.sql  >  Download  
File: localhost.sql
Role: Auxiliary data
Content type: text/plain
Description: db sample
Class: MySQL DB Class and Data Manipulation Class
MySQL wrapper with data manipulation functions
Author: By
Last change:
Date: 8 years ago
Size: 825 bytes
 

Contents

Class file image Download
-- 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');