-- phpMyAdmin SQL Dump
-- version 4.1.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 14, 2014 at 12:07 AM
-- Server version: 5.5.35-0ubuntu0.12.04.2
-- PHP Version: 5.3.10-1ubuntu3.10
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `pw`
--
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
`account_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL,
`role_name` varchar(64) NOT NULL,
`role_level` smallint(6) NOT NULL,
`role_race` tinyint(4) NOT NULL,
`role_occupation` tinyint(4) NOT NULL,
`role_gender` tinyint(4) NOT NULL,
`role_spouse` int(11) NOT NULL,
`faction_id` int(11) NOT NULL,
`faction_name` varchar(64) NOT NULL,
`faction_level` int(11) NOT NULL,
`faction_domains` varchar(132) NOT NULL,
`role_faction_rank` int(11) NOT NULL,
`pvp_time` int(11) NOT NULL,
`pvp_kills` int(11) NOT NULL,
`pvp_deads` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Truncate table before insert `roles`
--
TRUNCATE TABLE `roles`;
/*!40101 SET CHARACTER_SET_CLIENT [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION [USER=1333464006]old[/USER]_COLLATION_CONNECTION */;