MyRPG - DBDUMP

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.5.20 - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL version:             7.0.0.4053
-- Date/time:                    2012-03-18 20:42:59
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

-- Dumping structure for table myrpg.faction_info
CREATE TABLE IF NOT EXISTS `faction_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT 'Civil',
  `type` int(11) NOT NULL DEFAULT '0',
  `bank` int(11) NOT NULL DEFAULT '0',
  `x` double NOT NULL DEFAULT '0',
  `y` double NOT NULL DEFAULT '0',
  `z` double NOT NULL DEFAULT '0',
  `rank1` varchar(64) NOT NULL DEFAULT 'Civil',
  `rank2` varchar(64) NOT NULL DEFAULT 'Civil',
  `rank3` varchar(64) NOT NULL DEFAULT 'Civil',
  `rank4` varchar(64) NOT NULL DEFAULT 'Civil',
  `rank5` varchar(64) NOT NULL DEFAULT 'Civil',
  `rank6` varchar(64) NOT NULL DEFAULT 'Civil',
  `rank7` varchar(64) NOT NULL DEFAULT 'Civil',
  `rank8` varchar(64) NOT NULL DEFAULT 'Civil',
  `rank9` varchar(64) NOT NULL DEFAULT 'Civil',
  `rank10` varchar(64) NOT NULL DEFAULT 'Civil',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='Infos from the Families';

-- Data exporting was unselected.


-- Dumping structure for table myrpg.inventory_info
CREATE TABLE IF NOT EXISTS `inventory_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0',
  `itemid` int(11) NOT NULL DEFAULT '0',
  `info` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='Infos from the Families';

-- Data exporting was unselected.


-- Dumping structure for table myrpg.player_info
CREATE TABLE IF NOT EXISTS `player_info` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `password` varchar(129) NOT NULL,
  `attrib` int(11) NOT NULL DEFAULT '0',
  `skin` int(11) NOT NULL DEFAULT '167',
  `level` int(11) NOT NULL DEFAULT '1',
  `exp` int(11) NOT NULL DEFAULT '0',
  `cash` int(11) NOT NULL DEFAULT '5000',
  `money` int(11) NOT NULL DEFAULT '10000',
  `paycheck` int(11) NOT NULL DEFAULT '255',
  `savings` int(11) NOT NULL DEFAULT '0',
  `family` int(11) NOT NULL DEFAULT '0',
  `familyrank` int(11) NOT NULL DEFAULT '0',
  `familyjoin` int(11) NOT NULL DEFAULT '0',
  `job` int(11) NOT NULL DEFAULT '0',
  `jobrank` int(11) NOT NULL DEFAULT '0',
  `jobtime` int(11) NOT NULL DEFAULT '0',
  `spawn` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Infos from players';

-- Data exporting was unselected.


-- Dumping structure for table myrpg.property_info
CREATE TABLE IF NOT EXISTS `property_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attrib` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '0',
  `price` int(11) NOT NULL DEFAULT '0',
  `ext_x` double NOT NULL DEFAULT '0',
  `ext_y` double NOT NULL DEFAULT '0',
  `ext_z` double NOT NULL DEFAULT '0',
  `ext_prop` double NOT NULL DEFAULT '0',
  `int_x` double NOT NULL DEFAULT '0',
  `int_y` double NOT NULL DEFAULT '0',
  `int_z` double NOT NULL DEFAULT '0',
  `int_int` double NOT NULL DEFAULT '0',
  `owner` int(11) NOT NULL DEFAULT '0',
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='Infos from the Families';

-- Data exporting was unselected.


-- Dumping structure for table myrpg.record_info
CREATE TABLE IF NOT EXISTS `record_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `stamp` int(10) NOT NULL DEFAULT '0',
  `reason` varchar(255) NOT NULL DEFAULT 'Sem motivo',
  `time` int(11) NOT NULL DEFAULT '0',
  `admin` int(11) NOT NULL DEFAULT '0',
  `lifted` int(2) NOT NULL DEFAULT '0',
  `liftadmin` int(11) NOT NULL DEFAULT '0',
  `liftreason` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;