Webocreation

Sunday, February 7, 2010

Database structures for php classes

-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 05, 2010 at 12:47 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;

--
-- Database: `php_classes`
--

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

--
-- Table structure for table `profile`
--

CREATE TABLE IF NOT EXISTS `profile` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(254) NOT NULL,
`address` varchar(150) NOT NULL,
`user_name` varchar(50) NOT NULL,
`pass` varchar(40) NOT NULL,
`added_on` datetime NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `profile`
--

INSERT INTO `profile` (`user_id`, `name`, `address`, `user_name`, `pass`, `added_on`) VALUES
(1, 'Rupak', 'kathmandu', 'rupakr', 'd41d8cd98f00b204e9800998ecf8427e', '2010-02-05 17:24:09'),
(2, 'Jayaman', 'lalitpur', 'jaya', 'ce9689abdeab50b5bee3b56c7aadee27', '2010-02-05 17:27:09'),
(4, 'Sanjay', 'boudha', 'sanjay', '13ff58bd0f3da95d58fbe21d98436798', '2010-02-05 17:28:28'),
(5, 'Rupak', 'kathmandu', 'rupakr', 'd41d8cd98f00b204e9800998ecf8427e', '2010-02-05 18:26:14');

No comments:

Post a Comment