SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `ban_log`
-- ----------------------------
DROP TABLE IF EXISTS `ban_log`;
CREATE TABLE `ban_log` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `admin_id` int(10) unsigned NOT NULL,
   `account_id` int(10) unsigned NOT NULL,
   `zeitpunkt` datetime NOT NULL,
   `grund` varchar(200) NOT NULL,
   `typ` varchar(5) NOT NULL,
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of ban_log
-- ----------------------------

-- ----------------------------
-- Table structure for `is_items`
-- ----------------------------
DROP TABLE IF EXISTS `is_items`;
CREATE TABLE `is_items` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `vnum` int(10) unsigned NOT NULL,
   `kategorie_id` int(10) unsigned NOT NULL,
   `bild` varchar(50) NOT NULL,
   `beschreibung` varchar(200) NOT NULL,
   `preis` int(10) unsigned NOT NULL,
   `anzeigen` varchar(1) NOT NULL,
   `attrtype0` tinyint(4) NOT NULL default '0',
   `attrvalue0` smallint(6) NOT NULL default '0',
   `attrtype1` tinyint(4) NOT NULL default '0',
   `attrvalue1` smallint(6) NOT NULL default '0',
   `attrtype2` tinyint(4) NOT NULL default '0',
   `attrvalue2` smallint(6) NOT NULL default '0',
   `attrtype3` tinyint(4) NOT NULL default '0',
   `attrvalue3` smallint(6) NOT NULL default '0',
   `attrtype4` tinyint(4) NOT NULL default '0',
   `attrvalue4` smallint(6) NOT NULL default '0',
   `attrtype5` tinyint(4) NOT NULL default '0',
   `attrvalue5` smallint(6) NOT NULL default '0',
   `attrtype6` tinyint(4) NOT NULL default '0',
   `attrvalue6` smallint(6) NOT NULL default '0',
   `socket0` int(10) unsigned NOT NULL default '0',
   `socket1` int(10) unsigned NOT NULL default '0',
   `socket2` int(10) unsigned NOT NULL default '0',
   `socket3` int(10) unsigned NOT NULL default '0',
   `socket4` int(10) unsigned NOT NULL default '0',
   `socket5` int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of is_items
-- ----------------------------
INSERT INTO `is_items` VALUES ('1', '180', '1', 'item/00180.png', '', '180', 'J', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for `is_kategorien`
-- ----------------------------
DROP TABLE IF EXISTS `is_kategorien`;
CREATE TABLE `is_kategorien` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `titel` varchar(50) NOT NULL,
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of is_kategorien
-- ----------------------------
INSERT INTO `is_kategorien` VALUES ('1', 'Îðóæèå');

-- ----------------------------
-- Table structure for `is_log`
-- ----------------------------
DROP TABLE IF EXISTS `is_log`;
CREATE TABLE `is_log` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `account_id` int(10) unsigned NOT NULL,
   `vnum` int(10) unsigned NOT NULL,
   `preis` int(10) unsigned NOT NULL,
   `zeitpunkt` datetime NOT NULL,
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of is_log
-- ----------------------------

-- ----------------------------
-- Table structure for `news`
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `titel` varchar(200) NOT NULL,
   `inhalt` text NOT NULL,
   `datum` int(10) unsigned NOT NULL,
   `hot` tinyint(1) NOT NULL,
   `kategorie` int(10) unsigned NOT NULL,
   `author` int(10) unsigned NOT NULL,
   `anzeigen` tinyint(1) NOT NULL,
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of news
-- ----------------------------

-- ----------------------------
-- Table structure for `psc_log`
-- ----------------------------
DROP TABLE IF EXISTS `psc_log`;
CREATE TABLE `psc_log` (
   `id` int(11) NOT NULL auto_increment,
   `account_id` int(11) NOT NULL,
   `admin_id` int(11) default NULL,
   `card_type` varchar(20) NOT NULL,
   `waehrung` varchar(10) NOT NULL,
   `psc_code` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL,
   `psc_betrag` decimal(5,2) NOT NULL,
   `psc_pass` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL,
   `status` int(1) NOT NULL,
   `kommentar` varchar(200) NOT NULL,
   `datum` datetime NOT NULL,
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of psc_log
-- ----------------------------

-- ----------------------------
-- Table structure for `server_settings`
-- ----------------------------
DROP TABLE IF EXISTS `server_settings`;
CREATE TABLE `server_settings` (
   `id` int(11) NOT NULL auto_increment,
   `variable` varchar(20) NOT NULL,
   `beschreibung` varchar(100) NOT NULL,
   `typ` enum('CHA','BOO','INT','DEC') NOT NULL,
   `value` varchar(20) NOT NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `variable` (`variable`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of server_settings
-- ----------------------------
INSERT INTO `server_settings` VALUES ('1', 'maxGoldRate', 'Faktor der max. Gold-Drop-Rate', 'DEC', '1');
INSERT INTO `server_settings` VALUES ('2', 'expRate', 'Faktor der EXP-Rate', 'DEC', '1');
INSERT INTO `server_settings` VALUES ('3', 'minGoldRate', 'Faktor der minimalen Gold-Drop-Rate', 'DEC', '1');