PHP Classes

File: test.sql

Recommend this page to a friend!
  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: 18 years ago
Size: 1,201 bytes


Class file image Download
-- phpMyAdmin SQL Dump -- version 2.6.2-pl1 -- -- -- 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');