-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 10, 2008 at 12:11 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 `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL auto_increment,
  `iso` char(2) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1000000 ;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES(1, 'AR', 'Argentina');
INSERT INTO `countries` VALUES(2, 'AU', 'Australia');
INSERT INTO `countries` VALUES(3, 'AT', 'Austria');
INSERT INTO `countries` VALUES(4, 'BS', 'Bahamas');
INSERT INTO `countries` VALUES(5, 'BE', 'Belgium');
INSERT INTO `countries` VALUES(6, 'BO', 'Bolivia');
INSERT INTO `countries` VALUES(7, 'BR', 'Brazil');
INSERT INTO `countries` VALUES(8, 'CA', 'Canada');
INSERT INTO `countries` VALUES(9, 'CL', 'Chile');
INSERT INTO `countries` VALUES(10, 'CN', 'China');
INSERT INTO `countries` VALUES(11, 'CO', 'Colombia');
INSERT INTO `countries` VALUES(12, 'CR', 'Costa Rica');
INSERT INTO `countries` VALUES(13, 'HR', 'Croatia');
INSERT INTO `countries` VALUES(14, 'CU', 'Cuba');
INSERT INTO `countries` VALUES(15, 'CZ', 'Czech, Rep.');
INSERT INTO `countries` VALUES(16, 'DK', 'Denmark');
INSERT INTO `countries` VALUES(17, 'DO', 'Dominican, Rep.');
INSERT INTO `countries` VALUES(18, 'EC', 'Ecuador');
INSERT INTO `countries` VALUES(19, 'EG', 'Egypt');
INSERT INTO `countries` VALUES(20, 'SV', 'El Salvador');
INSERT INTO `countries` VALUES(21, 'FI', 'Finland');
INSERT INTO `countries` VALUES(22, 'FR', 'France');
INSERT INTO `countries` VALUES(23, 'DE', 'Germany');
INSERT INTO `countries` VALUES(24, 'GB', 'Great Britain');
INSERT INTO `countries` VALUES(25, 'GR', 'Greece');
INSERT INTO `countries` VALUES(26, 'GT', 'Guatemala');
INSERT INTO `countries` VALUES(27, 'HN', 'Honduras');
INSERT INTO `countries` VALUES(28, 'HK', 'Hong Kong');
INSERT INTO `countries` VALUES(29, 'IN', 'India');
INSERT INTO `countries` VALUES(30, 'IE', 'Ireland');
INSERT INTO `countries` VALUES(31, 'IL', 'Israel');
INSERT INTO `countries` VALUES(32, 'IT', 'Italy');
INSERT INTO `countries` VALUES(33, 'JM', 'Jamaica');
INSERT INTO `countries` VALUES(34, 'JP', 'Japan');
INSERT INTO `countries` VALUES(35, 'LU', 'Luxembourg');
INSERT INTO `countries` VALUES(36, 'MX', 'Mexico');
INSERT INTO `countries` VALUES(37, 'MA', 'Morocco');
INSERT INTO `countries` VALUES(38, 'NL', 'Netherlands');
INSERT INTO `countries` VALUES(39, 'NZ', 'New Zealand');
INSERT INTO `countries` VALUES(40, 'NI', 'Nicaragua');
INSERT INTO `countries` VALUES(41, 'NG', 'Nigeria');
INSERT INTO `countries` VALUES(42, 'NO', 'Norway');
INSERT INTO `countries` VALUES(43, 'PY', 'Paraguay');
INSERT INTO `countries` VALUES(44, 'PE', 'Peru');
INSERT INTO `countries` VALUES(45, 'PL', 'Poland');
INSERT INTO `countries` VALUES(46, 'PT', 'Portugal');
INSERT INTO `countries` VALUES(47, 'PR', 'Puerto Rico');
INSERT INTO `countries` VALUES(48, 'RU', 'Russia');
INSERT INTO `countries` VALUES(49, 'SA', 'Saudi Arabia');
INSERT INTO `countries` VALUES(50, 'ZA', 'South Africa');
INSERT INTO `countries` VALUES(51, 'ES', 'Spain');
INSERT INTO `countries` VALUES(52, 'SE', 'Sweden');
INSERT INTO `countries` VALUES(53, 'CH', 'Switzerland');
INSERT INTO `countries` VALUES(54, 'TW', 'Taiwan');
INSERT INTO `countries` VALUES(55, 'TR', 'Turkey');
INSERT INTO `countries` VALUES(56, 'US', 'United States');
INSERT INTO `countries` VALUES(57, 'UY', 'Uruguay');
INSERT INTO `countries` VALUES(58, 'VE', 'Venezuela');
INSERT INTO `countries` VALUES(999999, '', 'Other...');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `ses_id` varchar(32) NOT NULL default '',
  `ses_time` int(11) NOT NULL default '0',
  `ses_start` int(11) NOT NULL default '0',
  `ses_value` text NOT NULL,
  PRIMARY KEY  (`ses_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES('a9f3cbeec2ad30bd5d0261d96ce1727a', 1202604216, 1202596501, '_7JyYe8cCzQxkTGM_sCOwQStY5DjPUzy8Is86jpKav_UzU968_3TqP6CE_6JijFlga_JeImbbob-Ozw0X24B5eTOx7OMoJ8dbVsw_D98sgwWtRym6jtC7lfNewKF7t1i9YSwVHfLWlCSx3-ZdrJDT2SGfxHzUv39RnESArYqpwOC3-_HpYo_NYk-U6Dc_1x3');

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

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
  `id` int(2) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `class` varchar(10) NOT NULL default '',
  `mark` int(3) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

--
-- Dumping data for table `student`
--

INSERT INTO `student` VALUES(1, 'John Deo', 'Four', 75);
INSERT INTO `student` VALUES(2, 'Max Ruin', 'Three', 85);
INSERT INTO `student` VALUES(3, 'Arnold', 'Three', 55);
INSERT INTO `student` VALUES(4, 'Krish Star', 'Four', 60);
INSERT INTO `student` VALUES(5, 'John Mike', 'Four', 60);
INSERT INTO `student` VALUES(6, 'Alex John', 'Four', 55);
INSERT INTO `student` VALUES(7, 'My John Rob', 'Fifth', 78);
INSERT INTO `student` VALUES(8, 'Asruid', 'Five', 85);
INSERT INTO `student` VALUES(9, 'Tes Qry', 'Six', 78);
INSERT INTO `student` VALUES(10, 'Big John', 'Four', 55);
INSERT INTO `student` VALUES(11, 'Ronald', 'Six', 89);
INSERT INTO `student` VALUES(12, 'Recky', 'Six', 94);
INSERT INTO `student` VALUES(13, 'Kty', 'Seven', 88);
INSERT INTO `student` VALUES(14, 'Bigy', 'Seven', 88);
INSERT INTO `student` VALUES(15, 'Tade Row', 'Four', 88);
INSERT INTO `student` VALUES(16, 'Gimmy', 'Four', 88);
INSERT INTO `student` VALUES(17, 'Tumyu', 'Six', 54);
INSERT INTO `student` VALUES(18, 'Honny', 'Five', 75);
INSERT INTO `student` VALUES(19, 'Tinny', 'Nine', 18);
INSERT INTO `student` VALUES(20, 'Jackly', 'Nine', 65);
INSERT INTO `student` VALUES(21, 'Babby John', 'Four', 69);
INSERT INTO `student` VALUES(22, 'Reggid', 'Seven', 55);
INSERT INTO `student` VALUES(23, 'Herod', 'Eight', 79);
INSERT INTO `student` VALUES(24, 'Tiddy Now', 'Seven', 78);
INSERT INTO `student` VALUES(25, 'Giff Tow', 'Seven', 88);
INSERT INTO `student` VALUES(26, 'Crelea', 'Seven', 79);
INSERT INTO `student` VALUES(27, 'Big Nose', 'Three', 81);
INSERT INTO `student` VALUES(28, 'Rojj Base', 'Seven', 86);
INSERT INTO `student` VALUES(29, 'Tess Played', 'Seven', 55);
INSERT INTO `student` VALUES(30, 'Reppy Red', 'Six', 79);
INSERT INTO `student` VALUES(31, 'Marry Toeey', 'Four', 88);
INSERT INTO `student` VALUES(32, 'Binn Rott', 'Seven', 90);
INSERT INTO `student` VALUES(33, 'Kenn Rein', 'Six', 96);
INSERT INTO `student` VALUES(34, 'Gain Toe', 'Seven', 69);
INSERT INTO `student` VALUES(35, 'Rows Noump', 'Six', 88);

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

--
-- 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');

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

--
-- Table structure for table `users_profile`
--

CREATE TABLE `users_profile` (
  `id` int(11) NOT NULL auto_increment,
  `users_id` int(11) NOT NULL default '0',
  `language` char(2) NOT NULL default '',
  `address` varchar(50) NOT NULL default '',
  `postcode` varchar(15) NOT NULL default '',
  `city` varchar(50) NOT NULL default '',
  `country` char(2) NOT NULL default '',
  `phone` varchar(50) NOT NULL default '',
  `fax` varchar(50) NOT NULL default '',
  `homepage` varchar(100) NOT NULL default '',
  `notes` text NOT NULL,
  `user_1` varchar(100) NOT NULL default '',
  `user_2` varchar(100) NOT NULL default '',
  `user_3` varchar(100) NOT NULL default '',
  `user_4` varchar(100) NOT NULL default '',
  `user_5` varchar(100) NOT NULL default '',
  `user_6` varchar(100) NOT NULL default '',
  `last_change` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `users_id` (`users_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `users_profile`
--

INSERT INTO `users_profile` VALUES(1, 1, 'en', 'reserve', '4888', 'pond oo', 'AU', '', '', 'pp', 'me laugooooh also yup olollllllllllll', 'uuu', '', '', '', '', '', '2008-02-10 10:36:47');
INSERT INTO `users_profile` VALUES(2, 3, 'en', 'reserve', '4568', 'pomona', 'AU', '', '', '', 'hioppkkkkk', '', '', '', '', '', '', '2008-02-09 19:46:22');
INSERT INTO `users_profile` VALUES(3, 2, 'en', 'eleanor', '4568', 'pomona', 'AU', '', '', '', 'hello hello an d hello', 'EQ Forum', '', '', '', '', '', '2008-02-10 08:22:30');

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

--
-- Table structure for table `user_helpgather`
--

CREATE TABLE `user_helpgather` (
  `helpgather` varchar(40) NOT NULL,
  PRIMARY KEY  (`helpgather`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_helpgather`
--

INSERT INTO `user_helpgather` VALUES('gather01');
INSERT INTO `user_helpgather` VALUES('gather02');
INSERT INTO `user_helpgather` VALUES('gather03');
INSERT INTO `user_helpgather` VALUES('gather04');
INSERT INTO `user_helpgather` VALUES('gather05');
INSERT INTO `user_helpgather` VALUES('gather06');
INSERT INTO `user_helpgather` VALUES('gather07');
INSERT INTO `user_helpgather` VALUES('gather08');
INSERT INTO `user_helpgather` VALUES('gather09');
INSERT INTO `user_helpgather` VALUES('gather10');
INSERT INTO `user_helpgather` VALUES('Sunshine Coast Creative HS');

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

--
-- Table structure for table `user_helpindiv`
--

CREATE TABLE `user_helpindiv` (
  `helpindiv` varchar(40) NOT NULL,
  PRIMARY KEY  (`helpindiv`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_helpindiv`
--

INSERT INTO `user_helpindiv` VALUES('Beverley');
INSERT INTO `user_helpindiv` VALUES('Eleanor');
INSERT INTO `user_helpindiv` VALUES('Grace');
INSERT INTO `user_helpindiv` VALUES('Kathy');
INSERT INTO `user_helpindiv` VALUES('Marion');
INSERT INTO `user_helpindiv` VALUES('Potter');
INSERT INTO `user_helpindiv` VALUES('Shelley');

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

--
-- Table structure for table `user_helponline`
--

CREATE TABLE `user_helponline` (
  `helponline` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`helponline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_helponline`
--

INSERT INTO `user_helponline` VALUES('Discussion List1');
INSERT INTO `user_helponline` VALUES('Discussion List2');
INSERT INTO `user_helponline` VALUES('EQ Forum');
INSERT INTO `user_helponline` VALUES('Forum1');
INSERT INTO `user_helponline` VALUES('Forum2');
INSERT INTO `user_helponline` VALUES('Forum3');
INSERT INTO `user_helponline` VALUES('Forum4');
INSERT INTO `user_helponline` VALUES('Forum5');
INSERT INTO `user_helponline` VALUES('Forum6');
INSERT INTO `user_helponline` VALUES('Forum7');
INSERT INTO `user_helponline` VALUES('Forum8');
INSERT INTO `user_helponline` VALUES('Forum9');

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

--
-- Table structure for table `user_region`
--

CREATE TABLE `user_region` (
  `region` char(34) NOT NULL default '',
  PRIMARY KEY  (`region`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_region`
--

INSERT INTO `user_region` VALUES('ACT Canberra');
INSERT INTO `user_region` VALUES('HRP Hutt River Provence');
INSERT INTO `user_region` VALUES('NI Norfolk Island');
INSERT INTO `user_region` VALUES('NSW Blue Mountains');
INSERT INTO `user_region` VALUES('NSW Central Coast');
INSERT INTO `user_region` VALUES('NSW Central West');
INSERT INTO `user_region` VALUES('NSW Far South Coast');
INSERT INTO `user_region` VALUES('NSW Far West');
INSERT INTO `user_region` VALUES('NSW Greater Western Sydney');
INSERT INTO `user_region` VALUES('NSW Illawarra (Wollongong)');
INSERT INTO `user_region` VALUES('NSW Lord Howe Island');
INSERT INTO `user_region` VALUES('NSW Mid North Coast');
INSERT INTO `user_region` VALUES('NSW Murray');
INSERT INTO `user_region` VALUES('NSW New England (north-west)');
INSERT INTO `user_region` VALUES('NSW North West Slopes');
INSERT INTO `user_region` VALUES('NSW Northern Rivers');
INSERT INTO `user_region` VALUES('NSW Riverina RIV');
INSERT INTO `user_region` VALUES('NSW Sapphire Coast');
INSERT INTO `user_region` VALUES('NSW Snowy Mountains');
INSERT INTO `user_region` VALUES('NSW South Coast');
INSERT INTO `user_region` VALUES('NSW South West Slopes');
INSERT INTO `user_region` VALUES('NSW Southern Highlands');
INSERT INTO `user_region` VALUES('NSW Southern Tablelands');
INSERT INTO `user_region` VALUES('NSW Sydney SB');
INSERT INTO `user_region` VALUES('NSW The Hunter (Newcastle)');
INSERT INTO `user_region` VALUES('NT Arnhem Land');
INSERT INTO `user_region` VALUES('NT Central Australia');
INSERT INTO `user_region` VALUES('NT Top End');
INSERT INTO `user_region` VALUES('QLD Brisbane');
INSERT INTO `user_region` VALUES('QLD Bundaberg/Coral Coast');
INSERT INTO `user_region` VALUES('QLD Capricorn');
INSERT INTO `user_region` VALUES('QLD Far North Queensland');
INSERT INTO `user_region` VALUES('QLD Gladstone');
INSERT INTO `user_region` VALUES('QLD Gold Coast');
INSERT INTO `user_region` VALUES('QLD Mackay');
INSERT INTO `user_region` VALUES('QLD Outback Queensland');
INSERT INTO `user_region` VALUES('QLD South East Queensland');
INSERT INTO `user_region` VALUES('QLD Southern Downs');
INSERT INTO `user_region` VALUES('QLD Sunshine Coast');
INSERT INTO `user_region` VALUES('QLD Sunshine Coast Hinterland');
INSERT INTO `user_region` VALUES('QLD Toowoomba/Darling Downs');
INSERT INTO `user_region` VALUES('QLD Torres Strait Islands');
INSERT INTO `user_region` VALUES('QLD Townsville');
INSERT INTO `user_region` VALUES('QLD Whitsunday');
INSERT INTO `user_region` VALUES('QLD Wide Bay/Burnett');
INSERT INTO `user_region` VALUES('SA Adelaide Hills/Mount Lofty Rang');
INSERT INTO `user_region` VALUES('SA Adelaide Plains');
INSERT INTO `user_region` VALUES('SA Barossa Valley');
INSERT INTO `user_region` VALUES('SA Copper Triangle');
INSERT INTO `user_region` VALUES('SA Eyre Peninsula');
INSERT INTO `user_region` VALUES('SA Far North');
INSERT INTO `user_region` VALUES('SA Fleurieu Peninsula');
INSERT INTO `user_region` VALUES('SA Flinders Ranges');
INSERT INTO `user_region` VALUES('SA Kangaroo Island');
INSERT INTO `user_region` VALUES('SA Limestone Coast');
INSERT INTO `user_region` VALUES('SA Mid North');
INSERT INTO `user_region` VALUES('SA Murraylands');
INSERT INTO `user_region` VALUES('SA Riverland');
INSERT INTO `user_region` VALUES('SA Yorke Peninsula');
INSERT INTO `user_region` VALUES('TAS Central Highlands TCH');
INSERT INTO `user_region` VALUES('TAS Midlands TNM');
INSERT INTO `user_region` VALUES('TAS West Coast TWE');
INSERT INTO `user_region` VALUES('VIC Gippsland');
INSERT INTO `user_region` VALUES('VIC Melbourne');
INSERT INTO `user_region` VALUES('VIC Mornington Peninsula');
INSERT INTO `user_region` VALUES('VIC The Grampians');
INSERT INTO `user_region` VALUES('VIC The Mallee MAL');
INSERT INTO `user_region` VALUES('VIC The Victorian Alps');
INSERT INTO `user_region` VALUES('VIC The Wimmera');
INSERT INTO `user_region` VALUES('VIC Western District');
INSERT INTO `user_region` VALUES('VIC Yarra Valley');
INSERT INTO `user_region` VALUES('WA Christmas Island');
INSERT INTO `user_region` VALUES('WA Cocos(Keeling) Islands');
INSERT INTO `user_region` VALUES('WA Goldfields-Esperance');
INSERT INTO `user_region` VALUES('WA Great Southern');
INSERT INTO `user_region` VALUES('WA Kimberley/Pilbara/Gascoyne');
INSERT INTO `user_region` VALUES('WA Mid West');
INSERT INTO `user_region` VALUES('WA Peel');
INSERT INTO `user_region` VALUES('WA Perth');
INSERT INTO `user_region` VALUES('WA South West');
INSERT INTO `user_region` VALUES('WA Wheatbelt');