File: Sql

Recommend this page to a friend!
  Classes of a77icu5  >  Easy Query  >  Sql  >  Download  
File: Sql
Role: Auxiliary data
Content type: text/plain
Description: Database example
Class: Easy Query
Execute common SQL queries from parameter lists
Author: By
Last change:
Date: 11 years ago
Size: 1,476 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump
-- version 3.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 03, 2010 at 09:41 PM
-- Server version: 5.1.45
-- PHP Version: 5.2.12

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: `easyquery`
--

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

--
-- Table structure for table `easyquery`
--

CREATE TABLE IF NOT EXISTS `easyquery` (
  `id_user` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `user_password` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `user_mail` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_user`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `easyquery`
--

INSERT INTO `easyquery` (`id_user`, `user_name`, `user_password`, `user_mail`) VALUES
(1, 'username2', '14a88b9d2f52c55b5fbcf9c5d9c11875', 'user2@server.com'),
(2, 'username3', 'fe01ce2a7fbac8fafaed7c982a04e229', 'user3@server.com'),
(3, 'username4', 'fe01ce2a7fbac8fafaed7c982a04e229', 'user4@server.com'),
(4, 'username5', 'fe01ce2a7fbac8fafaed7c982a04e229', 'user5@server.com'),
(5, 'username6', 'fe01ce2a7fbac8fafaed7c982a04e229', 'user6@server.com');
For more information send a message to info at phpclasses dot org.