Miscellany

-- phpMyAdmin SQL Dump
-- version 2.9.1
-- http://www.phpmyadmin.net
-- 
-- Värd: localhost
-- Skapad: 31 januari 2007 kl 08:44
-- Serverversion: 5.0.27
-- PHP-version: 5.2.0
-- 
-- Databas: `phpuser`
-- 

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

-- 
-- Struktur för tabell `tbl_equiped_stats`
-- 

CREATE TABLE `tbl_equiped_stats` (
  `mbr_id` int(11) NOT NULL,
  `agility` int(11) NOT NULL,
  `endurence` int(11) NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Data i tabell `tbl_equiped_stats`
-- 

INSERT INTO `tbl_equiped_stats` (`mbr_id`, `agility`, `endurence`) VALUES 
(11, 75, 14);

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

-- 
-- Struktur för tabell `tbl_equipment`
-- 

CREATE TABLE `tbl_equipment` (
  `mbr_id` int(11) NOT NULL,
  `armor` int(11) NOT NULL default '1',
  `legs` int(11) NOT NULL default '2',
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Data i tabell `tbl_equipment`
-- 

INSERT INTO `tbl_equipment` (`mbr_id`, `armor`, `legs`) VALUES 
(11, 1, 2);

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

-- 
-- Struktur för tabell `tbl_item`
-- 

CREATE TABLE `tbl_item` (
  `id` int(11) NOT NULL auto_increment,
  `name` char(32) NOT NULL default 'test',
  `agility` int(11) NOT NULL default '1',
  `endurence` int(11) NOT NULL default '2',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

-- 
-- Data i tabell `tbl_item`
-- 

INSERT INTO `tbl_item` (`id`, `name`, `agility`, `endurence`) VALUES 
(1, 'Super good armor', 1, 2),
(2, 'Imba leggings', 69, 2, ),