-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- Host: db.htk.tlu.ee
-- Generation Time: Apr 30, 2010 at 03:14 PM
-- Server version: 5.0.45
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `wp_koeratoit`
-- 

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

-- 
-- Table structure for table `wp_dog_base`
-- 

CREATE TABLE `wp_dog_base` (
  `id` bigint(255) NOT NULL auto_increment,
  `owners_id` varchar(255) NOT NULL,
  `fbuid` varchar(255) NOT NULL,
  `dog_name` varchar(255) NOT NULL,
  `dog_weight` varchar(255) NOT NULL,
  `dog_breed` varchar(255) NOT NULL,
  `dog_age` varchar(255) NOT NULL,
  `dog_pregnant` int(1) NOT NULL,
  `microchip` varchar(255) NOT NULL,
  `allergies` varchar(255) NOT NULL,
  `nutrition_info` varchar(255) NOT NULL,
  `vaccine` varchar(255) NOT NULL,
  `sex` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `lifestyle` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `owners_address` varchar(255) NOT NULL,
  `dog_picture` varchar(255) NOT NULL,
  `show_cv` int(1) NOT NULL default '0',
  `date_added` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;

-- 
-- Dumping data for table `wp_dog_base`
-- 

INSERT INTO `wp_dog_base` (`id`, `owners_id`, `fbuid`, `dog_name`, `dog_weight`, `dog_breed`, `dog_age`, `dog_pregnant`, `microchip`, `allergies`, `nutrition_info`, `vaccine`, `sex`, `location`, `lifestyle`, `description`, `color`, `owners_address`, `dog_picture`, `show_cv`, `date_added`) VALUES 
(45, '5', '1014803739', 'Maximus', '19', '1', '1132704000', 0, '', '', '', '', '', '', '', '', '', '', '', 0, '1272628053'),
(33, '2', '', 'Naks', '20', '7', '1088899200', 0, '123.3434.3443', 'Õietolm', ' Sööb toorest kala.', '', 'Isane', '', '', '', 'Pruun', '', '', 1, '1272267456'),
(34, '3', '', 'Kriimu', '7', '5', '1259884800', 0, '', '', ' ', '', '', '', '', '', '', '', '', 1, '1272267511'),
(36, '9', '', 'A', '45', '8', '1222819200', 0, '', '', '', '', '', '', '', '', '', '', '', 0, '1272269684'),
(46, '5', '1014803739', 'Maximus', '19', '1', '1132704000', 0, '', '', '', '', '', '', '', '', '', '', '', 0, '1272628220');

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

-- 
-- Table structure for table `wp_dog_breed`
-- 

CREATE TABLE `wp_dog_breed` (
  `id` bigint(255) NOT NULL auto_increment,
  `breed` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- 
-- Dumping data for table `wp_dog_breed`
-- 

INSERT INTO `wp_dog_breed` (`id`, `breed`) VALUES 
(1, 'Prantsuse Buldog'),
(6, 'Saksa Lambakoer'),
(5, 'Taks'),
(7, 'Terjer'),
(8, 'krants');

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

-- 
-- Table structure for table `wp_food_storage`
-- 

CREATE TABLE `wp_food_storage` (
  `id` bigint(255) NOT NULL auto_increment,
  `owner_id` varchar(255) NOT NULL,
  `fbuid` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL default '0',
  `last_check` varchar(255) NOT NULL,
  `orders_processed` varchar(255) NOT NULL,
  `date_added` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

-- 
-- Dumping data for table `wp_food_storage`
-- 

INSERT INTO `wp_food_storage` (`id`, `owner_id`, `fbuid`, `quantity`, `last_check`, `orders_processed`, `date_added`) VALUES 
(22, '1', '', '59.73', '1271856846', '{4}{1}{3}{2}', '1271758779'),
(24, '2', '586587822', '12.339834375', '1272625160', '{5}', '1271773695'),
(25, '0', '', '0', '1271773808', '', '1271773808'),
(26, '5', '', '-0.00043940972223324', '1272624583', '{2}{4}{5}', '1272015266'),
(27, '3', '1062256670', '0', '1272266887', '', '1272266887'),
(28, '9', '', '11', '1272269739', '', '1272269632'),
(29, '5', '1014803739', '31.99928125', '1272629659', '', '1272626910');
