/*
Navicat MySQL Data Transfer

Source Server         : Bank
Source Server Version : 50516
Source Host           : localhost:3306
Source Database       : gildenbank

Target Server Type    : MYSQL
Target Server Version : 50516
File Encoding         : 65001

Date: 2011-11-07 18:17:36
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `bankstatus`
-- ----------------------------
DROP TABLE IF EXISTS `bankstatus`;
CREATE TABLE `bankstatus` (
  `Mitglied` int(11) NOT NULL,
  `Item` int(11) NOT NULL,
  `Ein_Auslage` tinyint(1) NOT NULL,
  `Anzahl` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of bankstatus
-- ----------------------------
INSERT INTO `bankstatus` VALUES ('1', '11', '0', '5');
INSERT INTO `bankstatus` VALUES ('4', '8', '1', '100');
INSERT INTO `bankstatus` VALUES ('1', '9', '1', '10');
INSERT INTO `bankstatus` VALUES ('4', '9', '1', '65');
INSERT INTO `bankstatus` VALUES ('4', '2', '0', '8');
INSERT INTO `bankstatus` VALUES ('4', '7', '0', '4');

-- ----------------------------
-- Table structure for `bankstatus_check`
-- ----------------------------
DROP TABLE IF EXISTS `bankstatus_check`;
CREATE TABLE `bankstatus_check` (
  `Mitglied` int(11) NOT NULL,
  `Item` text NOT NULL,
  `Ein_Auslage` tinyint(1) NOT NULL,
  `Anzahl` int(11) NOT NULL,
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of bankstatus_check
-- ----------------------------
INSERT INTO `bankstatus_check` VALUES ('3', '7', '0', '666', '80');
INSERT INTO `bankstatus_check` VALUES ('4', '11', '1', '12', '81');
INSERT INTO `bankstatus_check` VALUES ('2', '5', '0', '5', '82');
INSERT INTO `bankstatus_check` VALUES ('1', '8', '1', '9', '83');
INSERT INTO `bankstatus_check` VALUES ('1', '1', '1', '9', '87');
INSERT INTO `bankstatus_check` VALUES ('4', '1', '1', '8', '88');

-- ----------------------------
-- Table structure for `items`
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` text NOT NULL,
  `Wert` int(11) NOT NULL DEFAULT '0',
  `wowhead` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of items
-- ----------------------------
INSERT INTO `items` VALUES ('1', 'Flüchtige Elemente', '0', '0');
INSERT INTO `items` VALUES ('2', 'Himmlischer Splitter', '0', '0');
INSERT INTO `items` VALUES ('3', 'Hypnotischer Staub', '0', '0');
INSERT INTO `items` VALUES ('4', 'Große himmlische Essenz', '0', '0');
INSERT INTO `items` VALUES ('5', 'Kleine himmlische Splitter', '0', '0');
INSERT INTO `items` VALUES ('6', 'Pflanzen', '0', '0');
INSERT INTO `items` VALUES ('7', 'Mahlstromkristall', '0', '52722');
INSERT INTO `items` VALUES ('8', 'Bufffood', '0', '0');
INSERT INTO `items` VALUES ('9', 'Geringe himmlische Essenz', '0', '0');
INSERT INTO `items` VALUES ('10', 'Rohsockelsteine Wert: Rar', '0', '0');
INSERT INTO `items` VALUES ('11', 'Rohsockelsteine Wert: Selten', '0', '0');
INSERT INTO `items` VALUES ('12', 'Rohsockelsteine Wert: Episch', '0', '0');
INSERT INTO `items` VALUES ('13', 'Rohsockelsteine Wert: Meta', '0', '0');
INSERT INTO `items` VALUES ('14', 'Kesselklick', '0', '65460');

-- ----------------------------
-- Table structure for `mitglieder`
-- ----------------------------
DROP TABLE IF EXISTS `mitglieder`;
CREATE TABLE `mitglieder` (
  `Name` text NOT NULL,
  `Rechte` tinyint(1) NOT NULL DEFAULT '0',
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of mitglieder
-- ----------------------------
INSERT INTO `mitglieder` VALUES ('Jar', '1', '1');
INSERT INTO `mitglieder` VALUES ('Noox', '0', '2');
INSERT INTO `mitglieder` VALUES ('Düsterblick', '0', '3');
INSERT INTO `mitglieder` VALUES ('Dioxina', '0', '4');