Login   Register  
PHP Classes
elePHPant
Icontem

File: test.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Nic Stevens  >  MySQL Table Abstraction Class  >  test.sql  >  Download  
File: test.sql
Role: Auxiliary data
Content type: text/plain
Description: Test database tested against
Class: MySQL Table Abstraction Class
Wrap the access to MySQL database table rows
Author: By
Last change:
Date: 2005-07-22 19:33
Size: 1,201 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 22, 2005 at 07:11 PM
-- Server version: 5.0.7
-- PHP Version: 5.0.4
-- 
-- Database: `test`
-- 

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

-- 
-- Table structure for table `mtacuser`
-- 

DROP TABLE IF EXISTS `mtacuser`;
CREATE TABLE `mtacuser` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  `firstname` varchar(40) default NULL,
  `lastname` varchar(40) default NULL,
  `address1` varchar(80) default NULL,
  `address2` varchar(80) default NULL,
  `city` varchar(80) default NULL,
  `state` char(2) default NULL,
  `zip` varchar(10) default NULL,
  `username` varchar(20) default NULL,
  `password` char(34) default NULL,
  `secret_question` varchar(255) default NULL,
  `secret_answer` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `mtacuser`
-- 

INSERT INTO `mtacuser` VALUES (1, 'Frank Jones', 'Frank', 'Jones', 'Apartment 4', '1286 N. Central Ave', 'Chino', 'CA', '92737', 'fjones', '2f3858f62230ac3c915f300c664312c63f', 'cat', 'dog');