-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 10, 2008 at 12:12 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `parents_folks`
--

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(25) NOT NULL default '',
  `pw` varchar(32) NOT NULL default '',
  `language` char(2) NOT NULL default '',
  `real_name` varchar(32) NOT NULL,
  `animal` varchar(30) default NULL,
  `year` varchar(20) default NULL,
  `children` longtext,
  `village` varchar(40) default NULL,
  `user_region` varchar(40) default NULL,
  `user_helpgather` varchar(40) default NULL,
  `user_helpind` varchar(40) default NULL,
  `user_helponline` varchar(40) default NULL,
  `user_help` longtext,
  `about` longtext,
  `website` varchar(60) default NULL,
  `photo` varchar(90) default 'picture.gif',
  `extra_info` varchar(100) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `tmp_mail` varchar(50) NOT NULL default '',
  `access_level` tinyint(4) NOT NULL default '0',
  `active` enum('y','n','b') NOT NULL default 'n',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user` (`login`),
  UNIQUE KEY `mail` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES(1, 'admin', 'a4fce4011b346e223707cb6691f3167c', '', 'marion', '', '1995', 'Joe 20.09.91/', 'Pomona', '', '', '', '', '', 'hello i love home edding', '', 'picture.gif', 'beverley ', 'marion@spiderweb.com.au', '', 10, 'y');
INSERT INTO `users` VALUES(2, 'marion', '073caed738eb89c95a716053cea97b7c', '', 'marion', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'picture.gif', '', 'marionwillow@bluebottle.com', '', 1, 'y');