-- phpMyAdmin SQL Dump
-- version 3.4.10
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 20, 2012 at 05:14 AM
-- Server version: 5.0.95
-- PHP Version: 5.2.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `agony`
--

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

--
-- Table structure for table `enemys`
--

CREATE TABLE IF NOT EXISTS `enemys` (
  `name` text NOT NULL,
  `ip` text NOT NULL,
  `uid` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `friends`
--

CREATE TABLE IF NOT EXISTS `friends` (
  `name` text NOT NULL,
  `ip` text NOT NULL,
  `uid` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `logs`
--

CREATE TABLE IF NOT EXISTS `logs` (
  `data` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(255) NOT NULL auto_increment,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `author` text NOT NULL,
  `date_posted` text NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `content`, `author`, `date_posted`, `date`) VALUES
(6, 'News Update', 'You can post updates to your users by using the form in the Administration panel, this is a very useful feature if you don''t want to email every user about a new upudate that is coming out or has been implemented.', 'System', '', '2012-10-05');

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

--
-- Table structure for table `shells`
--

CREATE TABLE IF NOT EXISTS `shells` (
  `url` varchar(2000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `package_type` text NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
  `ip` text NOT NULL,
  `payment_method` text NOT NULL,
  `trans_id` text NOT NULL,
  `active` int(11) NOT NULL,
  `isadmin` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `reg_date` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `package_type`, `username`, `password`, `email`, `ip`, `payment_method`, `trans_id`, `active`, `isadmin`, `level`, `reg_date`) VALUES
(20, '1', 'Agony', '81dc9bdb52d04dc20036dbd8313ed055', 'agony@agony.pro', '127.0.0.1', 'none', 'none', 1, 1, 5, '2012-10-20');